Exemplo n.º 1
0
//todo: rewrite this to not need direct access to trap members.
bool ZoneDatabase::LoadTraps(const char* zonename, int16 version) {

	std::string query = StringFormat("SELECT id, x, y, z, effect, effectvalue, effectvalue2, skill, "
									"maxzdiff, radius, chance, message, respawn_time, respawn_var, level "
									"FROM traps WHERE zone='%s' AND version=%u", zonename, version);
	auto results = QueryDatabase(query);
	if (!results.Success()) {
		return false;
	}

	for (auto row = results.begin(); row != results.end(); ++row) {
		Trap* trap = new Trap();
		trap->trap_id = atoi(row[0]);
		trap->m_Position = glm::vec3(atof(row[1]), atof(row[2]), atof(row[3]));
		trap->effect = atoi(row[4]);
		trap->effectvalue = atoi(row[5]);
		trap->effectvalue2 = atoi(row[6]);
		trap->skill = atoi(row[7]);
		trap->maxzdiff = atof(row[8]);
		trap->radius = atof(row[9]);
		trap->chance = atoi(row[10]);
		trap->message = row[11];
		trap->respawn_time = atoi(row[12]);
		trap->respawn_var = atoi(row[13]);
		trap->level = atoi(row[14]);
		entity_list.AddTrap(trap);
		trap->CreateHiddenTrigger();
	}

	return true;
}
Exemplo n.º 2
0
bool ZoneDatabase::LoadTraps(const char* zonename, int16 version) {

	std::string query = StringFormat("SELECT id, x, y, z, effect, effectvalue, effectvalue2, skill, "
									"maxzdiff, radius, chance, message, respawn_time, respawn_var, level, "
									"`group`, triggered_number, despawn_when_triggered FROM traps WHERE zone='%s' AND version=%u", zonename, version);
	auto results = QueryDatabase(query);
	if (!results.Success()) {
		return false;
	}

	for (auto row = results.begin(); row != results.end(); ++row) {
		uint32 tid = atoi(row[0]);
		uint8 grp = atoi(row[15]);

		if(grp > 0)
		{
			// If a member of our group is already spawned skip loading this trap.
			if(entity_list.IsTrapGroupSpawned(tid, grp))
			{
				continue;
			}
		}

		Trap* trap = new Trap();
		trap->trap_id = tid;
		trap->db_id = tid;
		trap->m_Position = glm::vec3(atof(row[1]), atof(row[2]), atof(row[3]));
		trap->effect = atoi(row[4]);
		trap->effectvalue = atoi(row[5]);
		trap->effectvalue2 = atoi(row[6]);
		trap->skill = atoi(row[7]);
		trap->maxzdiff = atof(row[8]);
		trap->radius = atof(row[9]);
		trap->chance = atoi(row[10]);
		trap->message = row[11];
		trap->respawn_time = atoi(row[12]);
		trap->respawn_var = atoi(row[13]);
		trap->level = atoi(row[14]);
		trap->group = grp;
		trap->triggered_number = atoi(row[16]);
		trap->despawn_when_triggered = atoi(row[17]);
		entity_list.AddTrap(trap);
		trap->CreateHiddenTrigger();
		Log.Out(Logs::General, Logs::Traps, "Trap %d successfully loaded.", trap->trap_id);
	}

	return true;
}
Exemplo n.º 3
0
//todo: rewrite this to not need direct access to trap members.
bool ZoneDatabase::LoadTraps(const char* zonename, int16 version) {
	char errbuf[MYSQL_ERRMSG_SIZE];
	char *query = 0;
	MYSQL_RES *result;
	MYSQL_ROW row;

	//	int char_num = 0;
	unsigned long* lengths;

	if (RunQuery(query, MakeAnyLenString(&query, "SELECT id,x,y,z,effect,effectvalue,effectvalue2,skill,maxzdiff,radius,chance,message,respawn_time,respawn_var,level FROM traps WHERE zone='%s' AND version=%u", zonename, version), errbuf, &result)) {
		safe_delete_array(query);
		while ((row = mysql_fetch_row(result)))
		{
			lengths = mysql_fetch_lengths(result);
			Trap* trap = new Trap();
			trap->trap_id = atoi(row[0]);
			trap->x = atof(row[1]);
			trap->y = atof(row[2]);
			trap->z = atof(row[3]);
			trap->effect = atoi(row[4]);
			trap->effectvalue = atoi(row[5]);
			trap->effectvalue2 = atoi(row[6]);
			trap->skill = atoi(row[7]);
			trap->maxzdiff = atof(row[8]);
			trap->radius = atof(row[9]);
			trap->chance = atoi(row[10]);
			trap->message = row[11];
			trap->respawn_time = atoi(row[12]);
			trap->respawn_var = atoi(row[13]);
			trap->level = atoi(row[14]);
			entity_list.AddTrap(trap);
			trap->CreateHiddenTrigger();
		}
		mysql_free_result(result);
	}
	else {
		LogFile->write(EQEMuLog::Error, "Error in LoadTraps query '%s': %s", query, errbuf);
		safe_delete_array(query);
		return false;
	}

	return true;
}