uint32 CDataLoader::GetPlayersCount(search_req sr)
{
uint8 jobid = sr.jobid;
if (jobid > 0 && jobid < 21){
if (Sql_Query(SqlHandle, "SELECT COUNT(*) FROM accounts_sessions LEFT JOIN char_stats USING (charid) WHERE mjob = %u", jobid)
!= SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
if (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
return Sql_GetUIntData(SqlHandle, 0);
}
}
}
else{
if (Sql_Query(SqlHandle, "SELECT COUNT(*) FROM accounts_sessions") != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
if (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
return Sql_GetUIntData(SqlHandle, 0);
}
}
}
return 0;
}
void CStatusEffectContainer::LoadStatusEffects()
{
DSP_DEBUG_BREAK_IF(m_POwner->objtype != TYPE_PC);
const int8* Query =
"SELECT "
"effectid,"
"icon,"
"power,"
"tick,"
"duration,"
"subid,"
"subpower,"
"tier "
"FROM char_effects "
"WHERE charid = %u;";
int32 ret = Sql_Query(SqlHandle, Query, m_POwner->id);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
CStatusEffect* PStatusEffect = new CStatusEffect(
(EFFECT)Sql_GetUIntData(SqlHandle,0),
(uint16)Sql_GetUIntData(SqlHandle,1),
(uint16)Sql_GetUIntData(SqlHandle,2),
(uint32)Sql_GetUIntData(SqlHandle,3),
(uint32)Sql_GetUIntData(SqlHandle,4),
(uint16)Sql_GetUIntData(SqlHandle,5),
(uint16)Sql_GetUIntData(SqlHandle,6),
(uint16)Sql_GetUIntData(SqlHandle,7));
AddStatusEffect(PStatusEffect);
// load shadows left
if(PStatusEffect->GetStatusID() == EFFECT_COPY_IMAGE){
m_POwner->setModifier(MOD_UTSUSEMI, PStatusEffect->GetPower());
} else if(PStatusEffect->GetStatusID() == EFFECT_BLINK){
m_POwner->setModifier(MOD_BLINK, PStatusEffect->GetPower());
}
}
}
m_POwner->UpdateHealth(); // после загрузки эффектов пересчитываем максимальное количество HP/MP
}
bool Sql_GetAutoCommit(Sql_t* self)
{
if( self )
{
int32 ret = Sql_Query(self, "SELECT @@autocommit;");
if( ret != SQL_ERROR &&
Sql_NumRows(self) > 0 &&
Sql_NextRow(self) == SQL_SUCCESS )
{
return (Sql_GetUIntData(self, 0) == 1);
}
}
ShowFatalError("Sql_GetAutoCommit: SQL_ERROR\n");
return false;
}
uint16 getRollsPerGroup(CInstance* instance, uint8 groupID){
const int8* fmtQuery = "SELECT SUM(CASE \
WHEN LootDropID = %u \
AND lootGroupId = %u \
THEN rolls \
ELSE 0 END) \
FROM bcnm_loot;";
int32 ret = Sql_Query(SqlHandle, fmtQuery, instance->getLootId(), groupID);
if (ret == SQL_ERROR || Sql_NumRows(SqlHandle) == 0 || Sql_NextRow(SqlHandle) != SQL_SUCCESS){
ShowError("SQL error occured \n");
return 0;
}
else {
return (uint16)Sql_GetUIntData(SqlHandle,0);
}
}
bool spawnSecondPartDynamis(CInstance* instance){
DSP_DEBUG_BREAK_IF(instance==NULL);
//get ids from DB
const int8* fmtQuery = "SELECT monsterId \
FROM bcnm_instance \
WHERE bcnmId = %u AND instanceNumber = 2";
int32 ret = Sql_Query(SqlHandle, fmtQuery, instance->getID());
if (ret == SQL_ERROR ||
Sql_NumRows(SqlHandle) == 0)
{
ShowError("spawnSecondPartDynamis : SQL error - Cannot find any monster IDs for Dynamis %i \n",
instance->getID(), instance->getInstanceNumber());
}
else{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS){
uint32 mobid = Sql_GetUIntData(SqlHandle,0);
CMobEntity* PMob = (CMobEntity*)zoneutils::GetEntity(mobid, TYPE_MOB);
if (PMob != NULL)
{
if (PMob->PBattleAI->GetCurrentAction() == ACTION_NONE ||
PMob->PBattleAI->GetCurrentAction() == ACTION_SPAWN)
{
PMob->PBattleAI->SetLastActionTime(0);
PMob->PBattleAI->SetCurrentAction(ACTION_SPAWN);
PMob->m_instanceID = instance->getInstanceNumber();
ShowDebug("Spawned %s (%u) id %i inst %i \n",PMob->GetName(),PMob->id,instance->getID(),instance->getInstanceNumber());
instance->addEnemy(PMob, CONDITION_SPAWNED_AT_START & CONDITION_WIN_REQUIREMENT);
} else {
ShowDebug(CL_CYAN"spawnSecondPartDynamis: <%s> (%u) is alredy spawned\n" CL_RESET, PMob->GetName(), PMob->id);
}
} else {
ShowDebug("spawnSecondPartDynamis: mob %u not found\n", mobid);
}
}
return true;
}
return false;
}
bool spawnSecondPartDynamis(CBattlefield* battlefield) {
DSP_DEBUG_BREAK_IF(battlefield == nullptr);
//get ids from DB
const int8* fmtQuery = "SELECT monsterId \
FROM bcnm_battlefield \
WHERE bcnmId = %u AND battlefieldNumber = 2";
int32 ret = Sql_Query(SqlHandle, fmtQuery, battlefield->getID());
if (ret == SQL_ERROR ||
Sql_NumRows(SqlHandle) == 0)
{
ShowError("spawnSecondPartDynamis : SQL error - Cannot find any monster IDs for Dynamis %i \n",
battlefield->getID(), battlefield->getBattlefieldNumber());
}
else {
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS) {
uint32 mobid = Sql_GetUIntData(SqlHandle, 0);
CMobEntity* PMob = (CMobEntity*)zoneutils::GetEntity(mobid, TYPE_MOB);
if (PMob != nullptr)
{
if (!PMob->PAI->IsSpawned())
{
PMob->Spawn();
PMob->m_battlefieldID = battlefield->getBattlefieldNumber();
ShowDebug("Spawned %s (%u) id %i inst %i \n", PMob->GetName(), PMob->id, battlefield->getID(), battlefield->getBattlefieldNumber());
battlefield->addEnemy(PMob, CONDITION_SPAWNED_AT_START & CONDITION_WIN_REQUIREMENT);
}
else {
ShowDebug(CL_CYAN"spawnSecondPartDynamis: <%s> (%u) is already spawned\n" CL_RESET, PMob->GetName(), PMob->id);
}
}
else {
ShowDebug("spawnSecondPartDynamis: mob %u not found\n", mobid);
}
}
return true;
}
return false;
}
void CZone::LoadZoneSettings()
{
static const int8* Query =
"SELECT "
"zone.name,"
"zone.zoneip,"
"zone.zoneport,"
"zone.music,"
"zone.battlesolo,"
"zone.battlemulti,"
"zone.tax,"
"zone.misc,"
"zone.navmesh,"
"bcnm.name "
"FROM zone_settings AS zone "
"LEFT JOIN bcnm_info AS bcnm "
"USING (zoneid) "
"WHERE zoneid = %u "
"LIMIT 1";
if (Sql_Query(SqlHandle, Query, m_zoneID) != SQL_ERROR &&
Sql_NumRows(SqlHandle) != 0 &&
Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
m_zoneName.insert(0, Sql_GetData(SqlHandle,0));
m_zoneIP = (uint32)Sql_GetUIntData(SqlHandle,1);
m_zonePort = (uint16)Sql_GetUIntData(SqlHandle,2);
m_zoneMusic.m_song = (uint8)Sql_GetUIntData(SqlHandle,3); // background music
m_zoneMusic.m_bSongS = (uint8)Sql_GetUIntData(SqlHandle,4); // solo battle music
m_zoneMusic.m_bSongM = (uint8)Sql_GetUIntData(SqlHandle,5); // party battle music
m_tax = (uint16)(Sql_GetFloatData(SqlHandle,6) * 100); // tax for bazaar
m_miscMask = (uint16)Sql_GetUIntData(SqlHandle,7);
m_useNavMesh = (bool)Sql_GetIntData(SqlHandle,8);
if (Sql_GetData(SqlHandle,9) != NULL) // сейчас нельзя использовать bcnmid, т.к. они начинаются с нуля
{
m_InstanceHandler = new CInstanceHandler(m_zoneID);
}
if (m_miscMask & MISC_TREASURE)
{
m_TreasurePool = new CTreasurePool(TREASUREPOOL_ZONE);
}
}
else
{
ShowFatalError(CL_RED"CZone::LoadZoneSettings: Cannot load zone settings (%u)\n" CL_RESET, m_zoneID);
}
}
/***************************************************************
Spawns treasure chest/armory crate, what ever on winning bcnm
****************************************************************/
bool spawnTreasureForBcnm(CBattlefield* battlefield) {
DSP_DEBUG_BREAK_IF(battlefield == nullptr);
//get ids from DB
const int8* fmtQuery = "SELECT npcId \
FROM bcnm_treasure_chests \
WHERE bcnmId = %u AND battlefieldNumber = %u";
int32 ret = Sql_Query(SqlHandle, fmtQuery, battlefield->getID(), battlefield->getBattlefieldNumber());
if (ret == SQL_ERROR || Sql_NumRows(SqlHandle) == 0)
{
ShowError("spawnTreasureForBcnm : SQL error - Cannot find any npc IDs for BCNMID %i Battlefield %i \n",
battlefield->getID(), battlefield->getBattlefieldNumber());
}
else
{
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint32 npcid = Sql_GetUIntData(SqlHandle, 0);
CBaseEntity* PNpc = (CBaseEntity*)zoneutils::GetEntity(npcid, TYPE_NPC);
if (PNpc != nullptr)
{
PNpc->status = STATUS_NORMAL;
PNpc->animation = 0;
PNpc->loc.zone->PushPacket(PNpc, CHAR_INRANGE, new CEntityUpdatePacket(PNpc, ENTITY_SPAWN, UPDATE_ALL_MOB));
battlefield->addNpc(PNpc);
ShowDebug(CL_CYAN"Spawned %s id %i inst %i \n", PNpc->status, PNpc->id, battlefield->getBattlefieldNumber());
}
else
{
ShowDebug(CL_CYAN"spawnTreasureForBcnm: <%s> is already spawned\n" CL_RESET, PNpc->GetName());
}
}
return true;
}
return false;
}
std::vector<CParty::partyInfo_t> CParty::GetPartyInfo()
{
std::vector<CParty::partyInfo_t> memberinfo;
int ret = Sql_Query(SqlHandle, "SELECT chars.charid, partyid, allianceid, charname, partyflag, pos_zone, pos_prevzone FROM accounts_parties \
LEFT JOIN chars ON accounts_parties.charid = chars.charid WHERE \
(allianceid <> 0 AND allianceid = %d) OR partyid = %d ORDER BY partyflag & %u, timestamp;",
m_PAlliance ? m_PAlliance->m_AllianceID : 0, m_PartyID, PARTY_SECOND | PARTY_THIRD);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
memberinfo.push_back({Sql_GetUIntData(SqlHandle,0), Sql_GetUIntData(SqlHandle, 1),
Sql_GetUIntData(SqlHandle, 2), std::string((const char*)Sql_GetData(SqlHandle, 3)),
static_cast<uint16>(Sql_GetUIntData(SqlHandle, 4)),
static_cast<uint16>(Sql_GetUIntData(SqlHandle, 5)),
static_cast<uint16>(Sql_GetUIntData(SqlHandle, 6))});
}
}
return memberinfo;
}
void CTransportHandler::InitializeElevators()
{
DSP_DEBUG_BREAK_IF(ElevatorList.size() != 0);
const int8* fmtQuery = "SELECT id, elevator, lowerDoor, upperDoor, status, regime FROM elevators ;";
int32 ret = Sql_Query(SqlHandle, fmtQuery);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
Elevator_t elevator;
elevator.id = (uint8)Sql_GetUIntData(SqlHandle,0);
elevator.zone = (uint16)((Sql_GetUIntData(SqlHandle,1) >> 12) & 0x0FFF);
elevator.Elevator = (CNpcEntity*)zoneutils::GetEntity(Sql_GetUIntData(SqlHandle,1), TYPE_NPC);
elevator.LowerDoor = (CNpcEntity*)zoneutils::GetEntity(Sql_GetUIntData(SqlHandle,2), TYPE_NPC);
elevator.UpperDoor = (CNpcEntity*)zoneutils::GetEntity(Sql_GetUIntData(SqlHandle,3), TYPE_NPC);
elevator.isMoving = false;
elevator.isStarted = (Sql_GetUIntData(SqlHandle,4) != 0);
elevator.isPermanent = (Sql_GetUIntData(SqlHandle,5) != 0);
elevator.movetime = ((elevator.UpperDoor == NULL)||(elevator.LowerDoor == NULL) ? 0 : 3);
elevator.interval = ((elevator.UpperDoor == NULL)||(elevator.LowerDoor == NULL)||(!elevator.isPermanent) ? 8 : 8);
if (elevator.Elevator != NULL)
{
elevator.Elevator->name.resize(10);
ElevatorList.push_back(elevator);
}
}
}
}
void LoadItemList()
{
PROFILE_FUNC();
memset(g_pItemList,0,sizeof(g_pItemList));
memset(g_pDropList,0,sizeof(g_pDropList));
const int8* Query =
"SELECT "
"b.itemId," // 0
"b.name," // 1
"b.stackSize," // 2
"b.flags," // 3
"b.aH," // 4
"b.BaseSell," // 5
"b.subid," // 6
"u.validTargets," // 7
"u.activation," // 8
"u.animation," // 9
"u.animationTime," // 10
"u.maxCharges," // 11
"u.useDelay," // 12
"u.reuseDelay," // 13
"u.aoe," // 14
"a.level," // 15
"a.jobs," // 16
"a.MId," // 17
"a.shieldSize," // 18
"a.scriptType," // 19
"a.slot," // 20
"a.rslot," // 21
"w.skill," // 22
"w.subskill," // 23
"w.delay," // 24
"w.dmg," // 25
"w.dmgType," // 26
"w.hit," // 27
"w.unlock_index," // 28
"f.storage," // 29
"f.moghancement," // 30
"f.element," // 31
"f.aura," // 32
"p.slot," // 33
"p.element " // 34
"FROM item_basic AS b "
"LEFT JOIN item_usable AS u USING (itemId) "
"LEFT JOIN item_armor AS a USING (itemId) "
"LEFT JOIN item_weapon AS w USING (itemId) "
"LEFT JOIN item_furnishing AS f USING (itemId) "
"LEFT JOIN item_puppet AS p USING (itemId) "
"WHERE itemId < %u;";
int32 ret = Sql_Query(SqlHandle, Query, MAX_ITEMID);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
CItem* PItem = CreateItem(Sql_GetUIntData(SqlHandle,0));
if(PItem != NULL)
{
PItem->setName(Sql_GetData(SqlHandle,1));
PItem->setStackSize(Sql_GetUIntData(SqlHandle,2));
PItem->setFlag(Sql_GetUIntData(SqlHandle,3));
PItem->setAHCat(Sql_GetUIntData(SqlHandle,4));
PItem->setBasePrice(Sql_GetUIntData(SqlHandle,5));
PItem->setSubID(Sql_GetUIntData(SqlHandle,6));
if (PItem->isType(ITEM_GENERAL))
{
}
if (PItem->isType(ITEM_USABLE))
{
((CItemUsable*)PItem)->setValidTarget(Sql_GetUIntData(SqlHandle,7));
((CItemUsable*)PItem)->setActivationTime(Sql_GetUIntData(SqlHandle,8)*1000);
((CItemUsable*)PItem)->setAnimationID(Sql_GetUIntData(SqlHandle,9));
((CItemUsable*)PItem)->setAnimationTime(Sql_GetUIntData(SqlHandle,10)*1000);
((CItemUsable*)PItem)->setMaxCharges(Sql_GetUIntData(SqlHandle,11));
((CItemUsable*)PItem)->setCurrentCharges(Sql_GetUIntData(SqlHandle,11));
((CItemUsable*)PItem)->setUseDelay(Sql_GetUIntData(SqlHandle,12));
((CItemUsable*)PItem)->setReuseDelay(Sql_GetUIntData(SqlHandle,13));
((CItemUsable*)PItem)->setAoE(Sql_GetUIntData(SqlHandle,14));
}
if (PItem->isType(ITEM_PUPPET))
{
((CItemPuppet*)PItem)->setEquipSlot(Sql_GetUIntData(SqlHandle,33));
((CItemPuppet*)PItem)->setElementSlots(Sql_GetUIntData(SqlHandle,34));
}
if (PItem->isType(ITEM_ARMOR))
{
((CItemArmor*)PItem)->setReqLvl(Sql_GetUIntData(SqlHandle,15));
((CItemArmor*)PItem)->setJobs(Sql_GetUIntData(SqlHandle,16));
((CItemArmor*)PItem)->setModelId(Sql_GetUIntData(SqlHandle,17));
((CItemArmor*)PItem)->setShieldSize(Sql_GetUIntData(SqlHandle,18));
((CItemArmor*)PItem)->setScriptType(Sql_GetUIntData(SqlHandle,19));
((CItemArmor*)PItem)->setEquipSlotId(Sql_GetUIntData(SqlHandle,20));
((CItemArmor*)PItem)->setRemoveSlotId(Sql_GetUIntData(SqlHandle,21));
if (((CItemArmor*)PItem)->getValidTarget() != 0)
{
((CItemArmor*)PItem)->setSubType(ITEM_CHARGED);
}
}
if (PItem->isType(ITEM_WEAPON))
{
((CItemWeapon*)PItem)->setSkillType(Sql_GetUIntData(SqlHandle,22));
((CItemWeapon*)PItem)->setSubSkillType(Sql_GetUIntData(SqlHandle,23));
((CItemWeapon*)PItem)->setDelay((Sql_GetIntData(SqlHandle,24)*1000)/60);
((CItemWeapon*)PItem)->setDamage(Sql_GetUIntData(SqlHandle,25));
((CItemWeapon*)PItem)->setDmgType(Sql_GetUIntData(SqlHandle,26));
((CItemWeapon*)PItem)->setMaxHit(Sql_GetUIntData(SqlHandle,27));
((CItemWeapon*)PItem)->setUnlockable(Sql_GetUIntData(SqlHandle,28));
}
if (PItem->isType(ITEM_FURNISHING))
{
((CItemFurnishing*)PItem)->setStorage(Sql_GetUIntData(SqlHandle,29));
((CItemFurnishing*)PItem)->setMoghancement(Sql_GetUIntData(SqlHandle,30));
((CItemFurnishing*)PItem)->setElement(Sql_GetUIntData(SqlHandle,31));
((CItemFurnishing*)PItem)->setAura(Sql_GetUIntData(SqlHandle,32));
}
g_pItemList[PItem->getID()] = PItem;
}
}
}
ret = Sql_Query(SqlHandle,"SELECT itemId, modId, value FROM item_mods WHERE itemId IN (SELECT itemId FROM item_basic LEFT JOIN item_armor USING (itemId))");
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 ItemID = (uint16)Sql_GetUIntData(SqlHandle,0);
uint16 modID = (uint16)Sql_GetUIntData(SqlHandle,1);
int16 value = (int16) Sql_GetIntData (SqlHandle,2);
if ((g_pItemList[ItemID] != NULL) && g_pItemList[ItemID]->isType(ITEM_ARMOR))
{
((CItemArmor*)g_pItemList[ItemID])->addModifier(new CModifier(modID,value));
}
}
}
ret = Sql_Query(SqlHandle,"SELECT itemId, modId, value, latentId, latentParam FROM item_latents WHERE itemId IN (SELECT itemId FROM item_basic LEFT JOIN item_armor USING (itemId))");
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 ItemID = (uint16)Sql_GetUIntData(SqlHandle,0);
uint16 modID = (uint16)Sql_GetUIntData(SqlHandle,1);
int16 value = (int16) Sql_GetIntData (SqlHandle,2);
uint16 latentId = (uint16) Sql_GetIntData(SqlHandle,3);
uint16 latentParam = (uint16) Sql_GetIntData(SqlHandle,4);
if ((g_pItemList[ItemID] != NULL) && g_pItemList[ItemID]->isType(ITEM_ARMOR))
{
((CItemArmor*)g_pItemList[ItemID])->addLatent(new CLatentEffect((LATENT)latentId, latentParam, 0, modID, value));
}
}
}
}
/***************************************************************
Spawns monsters for the given BCNMID/Instance number by
looking at bcnm_instance table for mob ids then spawning
them and adding them to the monster list for the given
instance.
****************************************************************/
bool spawnMonstersForBcnm(CInstance* instance){
DSP_DEBUG_BREAK_IF(instance==NULL);
//get ids from DB
const int8* fmtQuery = "SELECT monsterId, conditions \
FROM bcnm_instance \
WHERE bcnmId = %u AND instanceNumber = %u";
int32 ret = Sql_Query(SqlHandle, fmtQuery, instance->getID(), instance->getInstanceNumber());
if (ret == SQL_ERROR ||
Sql_NumRows(SqlHandle) == 0)
{
ShowError("spawnMonstersForBcnm : SQL error - Cannot find any monster IDs for BCNMID %i Instance %i \n",
instance->getID(), instance->getInstanceNumber());
}
else{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS){
uint32 mobid = Sql_GetUIntData(SqlHandle,0);
uint8 condition = Sql_GetUIntData(SqlHandle,1);
CMobEntity* PMob = (CMobEntity*)zoneutils::GetEntity(mobid, TYPE_MOB);
if (PMob != NULL)
{
PMob->m_instanceID = instance->getInstanceNumber();
PMob->m_bcnmID = instance->getID();
if (condition & CONDITION_SPAWNED_AT_START)
{
// This condition is needed for some mob at dynamis, else he don't pop
if(PMob->PBattleAI->GetCurrentAction() == ACTION_FADE_OUT){
PMob->PBattleAI->SetLastActionTime(0);
PMob->PBattleAI->SetCurrentAction(ACTION_NONE);
}
if (PMob->PBattleAI->GetCurrentAction() == ACTION_NONE ||
PMob->PBattleAI->GetCurrentAction() == ACTION_SPAWN)
{
PMob->PBattleAI->SetLastActionTime(0);
PMob->PBattleAI->SetCurrentAction(ACTION_SPAWN);
if(strcmp(PMob->GetName(),"Maat")==0){
mobutils::SetupMaat(PMob, (JOBTYPE)instance->getPlayerMainJob());
PMob->m_DropID = 4485; //Give Maat his stealable Warp Scroll
// disable players subjob
instance->disableSubJob();
// disallow subjob, this will enable for later
instance->m_RuleMask &= ~(1 << RULES_ALLOW_SUBJOBS);
}
//ShowDebug("Spawned %s (%u) id %i inst %i \n",PMob->GetName(),PMob->id,instance->getID(),instance->getInstanceNumber());
instance->addEnemy(PMob, condition);
} else {
ShowDebug(CL_CYAN"SpawnMobForBcnm: <%s> (%u) is alredy spawned\n" CL_RESET, PMob->GetName(), PMob->id);
}
} else {
instance->addEnemy(PMob, condition);
}
} else {
ShowDebug("SpawnMobForBcnm: mob %u not found\n", mobid);
}
}
return true;
}
return false;
}
std::list<SearchEntity*> CDataLoader::GetPlayersList(search_req sr, int* count)
{
std::list<SearchEntity*> PlayersList;
std::string filterQry = "";
if (sr.jobid > 0 && sr.jobid < 21){
filterQry.append(" AND ");
filterQry.append(" mjob = ");
filterQry.append(std::to_string(static_cast<unsigned long long>(sr.jobid)));
}
if (sr.zoneid[0] > 0) {
string_t zoneList;
int i = 1;
zoneList.append(std::to_string(static_cast<unsigned long long>(sr.zoneid[0])));
while (i < 10 && sr.zoneid[i] != 0)
{
zoneList.append(", ");
zoneList.append(std::to_string(static_cast<unsigned long long>(sr.zoneid[i])));
i++;
}
filterQry.append(" AND ");
filterQry.append("(pos_zone IN (");
filterQry.append(zoneList);
filterQry.append(") OR (pos_zone = 0 AND pos_prevzone IN (");
filterQry.append(zoneList);
filterQry.append("))) ");
}
std::string fmtQuery = "SELECT charid, partyid, charname, pos_zone, pos_prevzone, nation, rank_sandoria, rank_bastok, rank_windurst, race, nameflags, mjob, sjob, mlvl, slvl "
"FROM accounts_sessions "
"LEFT JOIN accounts_parties USING (charid) "
"LEFT JOIN chars USING (charid) "
"LEFT JOIN char_look USING (charid) "
"LEFT JOIN char_stats USING (charid) "
"LEFT JOIN char_profile USING(charid) "
"WHERE charname IS NOT NULL ";
fmtQuery.append(filterQry);
fmtQuery.append(" ORDER BY charname ASC");
int32 ret = Sql_Query(SqlHandle, fmtQuery.c_str());
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
int totalResults = 0; //gives ALL matching criteria (total)
int visibleResults = 0; //capped at first 20
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
SearchEntity* PPlayer = new SearchEntity;
memset(PPlayer, 0, sizeof(SearchEntity));
memcpy(PPlayer->name, Sql_GetData(SqlHandle, 2), 15);
PPlayer->id = (uint32)Sql_GetUIntData(SqlHandle, 0);
PPlayer->zone = (uint16)Sql_GetIntData(SqlHandle, 3);
PPlayer->prevzone = (uint16)Sql_GetIntData(SqlHandle, 4);
PPlayer->nation = (uint8)Sql_GetIntData(SqlHandle, 5);
PPlayer->mjob = (uint8)Sql_GetIntData(SqlHandle, 11);
PPlayer->sjob = (uint8)Sql_GetIntData(SqlHandle, 12);
PPlayer->mlvl = (uint8)Sql_GetIntData(SqlHandle, 13);
PPlayer->slvl = (uint8)Sql_GetIntData(SqlHandle, 14);
PPlayer->race = (uint8)Sql_GetIntData(SqlHandle, 9);
PPlayer->rank = (uint8)Sql_GetIntData(SqlHandle, 6 + PPlayer->nation);
PPlayer->zone = (PPlayer->zone == 0 ? PPlayer->prevzone : PPlayer->zone);
uint32 partyid = (uint32)Sql_GetUIntData(SqlHandle, 1);
uint32 nameflag = (uint32)Sql_GetUIntData(SqlHandle, 10);
if (partyid == PPlayer->id) PPlayer->flags1 |= 0x0008;
if (nameflag & FLAG_AWAY) PPlayer->flags1 |= 0x0100;
if (nameflag & FLAG_DC) PPlayer->flags1 |= 0x0800;
if (partyid != 0) PPlayer->flags1 |= 0x2000;
if (nameflag & FLAG_ANON) PPlayer->flags1 |= 0x4000;
if (nameflag & FLAG_INVITE) PPlayer->flags1 |= 0x8000;
PPlayer->flags2 = PPlayer->flags1;
// TODO: search comments
// filter by job
if (sr.jobid > 0 && sr.jobid != PPlayer->mjob)
continue;
// filter by nation
if (sr.nation != 255 && sr.nation != PPlayer->nation)
continue;
// filter by race
if (sr.race != 255)
{
// hume (male/female)
if (sr.race == 0 && (PPlayer->race != 1 && PPlayer->race != 2))
continue;
// elvaan (male/female)
else if (sr.race == 1 && (PPlayer->race != 3 && PPlayer->race != 4))
continue;
// tarutaru (male/female)
else if (sr.race == 2 && (PPlayer->race != 5 && PPlayer->race != 6))
continue;
// mithra (female only)
else if (sr.race == 3 && PPlayer->race != 7)
continue;
// galka (male only)
else if (sr.race == 4 && PPlayer->race != 8)
continue;
}
// filter by rank
if (sr.minRank > 0 && sr.maxRank >= sr.minRank)
{
if (PPlayer->rank < sr.minRank || PPlayer->rank > sr.maxRank)
continue;
}
// filter by flag (away, seek party etc.)
if (sr.flags != 0 && !(PPlayer->flags2 & sr.flags))
continue;
// filter by level
if (sr.minlvl > 0 && sr.maxlvl >= sr.minlvl){
if (PPlayer->mlvl < sr.minlvl || PPlayer->mlvl > sr.maxlvl)
continue;
}
// filter by name
if (sr.nameLen > 0){
string_t dbname;
dbname.insert(0, (char*)PPlayer->name);
//can't be this name, too long
if (sr.nameLen > dbname.length()){
continue;
}
bool validName = true;
for (int i = 0; i < sr.nameLen; i++){
//convert to lowercase for both
if (tolower(sr.name[i]) != tolower(PPlayer->name[i])){
validName = false;
break;
}
}
if (!validName){
continue;
}
}
// dont show hidden gm
if (nameflag & FLAG_ANON && nameflag & FLAG_GM)
{
continue;
}
if (visibleResults < 20){
PlayersList.push_back(PPlayer);
visibleResults++;
}
totalResults++;
}
if (totalResults > 0){
*count = totalResults;
}
ShowMessage("Found %i results, displaying %i. \n", totalResults, visibleResults);
}
return PlayersList;
}
void LoadNPCList()
{
const int8* Query =
"SELECT \
zoneid,\
npcid,\
name,\
pos_rot,\
pos_x,\
pos_y,\
pos_z,\
flag,\
speed,\
speedsub,\
animation,\
animationsub,\
namevis,\
status,\
unknown,\
look,\
name_prefix \
FROM npc_list \
WHERE npcid < 1024;";
int32 ret = Sql_Query(SqlHandle, Query);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 ZoneID = (uint16)Sql_GetUIntData(SqlHandle, 0);
if (GetZone(ZoneID)->GetType() != ZONETYPE_DUNGEON_INSTANCED)
{
CNpcEntity* PNpc = new CNpcEntity;
PNpc->targid = (uint16)Sql_GetUIntData(SqlHandle, 1);
PNpc->id = (uint32)PNpc->targid + (ZoneID << 12) + 0x1000000;
PNpc->name.insert(0, Sql_GetData(SqlHandle, 2));
PNpc->loc.p.rotation = (uint8)Sql_GetIntData(SqlHandle, 3);
PNpc->loc.p.x = Sql_GetFloatData(SqlHandle, 4);
PNpc->loc.p.y = Sql_GetFloatData(SqlHandle, 5);
PNpc->loc.p.z = Sql_GetFloatData(SqlHandle, 6);
PNpc->loc.p.moving = (uint16)Sql_GetUIntData(SqlHandle, 7);
PNpc->m_TargID = (uint32)Sql_GetUIntData(SqlHandle, 7) >> 16; // вполне вероятно
PNpc->speed = (uint8)Sql_GetIntData(SqlHandle, 8);
PNpc->speedsub = (uint8)Sql_GetIntData(SqlHandle, 9);
PNpc->animation = (uint8)Sql_GetIntData(SqlHandle, 10);
PNpc->animationsub = (uint8)Sql_GetIntData(SqlHandle, 11);
PNpc->namevis = (uint8)Sql_GetIntData(SqlHandle, 12);
PNpc->status = (STATUSTYPE)Sql_GetIntData(SqlHandle, 13);
PNpc->unknown = (uint32)Sql_GetUIntData(SqlHandle, 14);
PNpc->name_prefix = (uint8)Sql_GetIntData(SqlHandle, 16);
memcpy(&PNpc->look, Sql_GetData(SqlHandle, 15), 20);
GetZone(ZoneID)->InsertNPC(PNpc);
luautils::OnNpcSpawn(PNpc);
}
}
}
/*
Loads up custom mob mods from mob_pool_mods and mob_family_mods table. This will allow you to customize
a mobs regen rate, magic defense, triple attack rate from a table instead of hardcoding it.
Usage:
Evil weapons have a magic defense boost. So pop that into mob_family_mods table.
Goblin Diggers have a vermin killer trait, so find its poolid and put it in mod_pool_mods table.
*/
void LoadCustomMods()
{
// load family mods
const char QueryFamilyMods[] = "SELECT familyid, modid, value, is_mob_mod FROM mob_family_mods;";
int32 ret = Sql_Query(SqlHandle, QueryFamilyMods);
if(ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
ModsList_t* familyMods = GetMobFamilyMods(Sql_GetUIntData(SqlHandle,0), true);
CModifier* mod = new CModifier(static_cast<Mod>(Sql_GetUIntData(SqlHandle,1)));
mod->setModAmount(Sql_GetIntData(SqlHandle,2));
int8 isMobMod = Sql_GetIntData(SqlHandle,3);
if(isMobMod == 1)
{
familyMods->mobMods.push_back(mod);
}
else
{
familyMods->mods.push_back(mod);
}
}
}
// load pool mods
const char QueryPoolMods[] = "SELECT poolid, modid, value, is_mob_mod FROM mob_pool_mods;";
ret = Sql_Query(SqlHandle, QueryPoolMods);
if(ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 pool = Sql_GetUIntData(SqlHandle,0);
ModsList_t* poolMods = GetMobPoolMods(pool, true);
Mod id = static_cast<Mod>(Sql_GetUIntData(SqlHandle,1));
CModifier* mod = new CModifier(id);
mod->setModAmount(Sql_GetUIntData(SqlHandle,2));
int8 isMobMod = Sql_GetIntData(SqlHandle,3);
if(isMobMod == 1)
{
poolMods->mobMods.push_back(mod);
}
else
{
poolMods->mods.push_back(mod);
}
}
}
// load spawn mods
const char QuerySpawnMods[] = "SELECT mobid, modid, value, is_mob_mod FROM mob_spawn_mods;";
ret = Sql_Query(SqlHandle, QuerySpawnMods);
if(ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
ModsList_t* spawnMods = GetMobSpawnMods(Sql_GetUIntData(SqlHandle,0), true);
CModifier* mod = new CModifier(static_cast<Mod>(Sql_GetUIntData(SqlHandle,1)));
mod->setModAmount(Sql_GetUIntData(SqlHandle,2));
int8 isMobMod = Sql_GetIntData(SqlHandle,3);
if(isMobMod == 1)
{
spawnMods->mobMods.push_back(mod);
}
else
{
spawnMods->mods.push_back(mod);
}
}
}
}
void CZone::LoadZoneSettings()
{
static const int8* Query =
"SELECT "
"zone.name,"
"zone.zoneip,"
"zone.zoneport,"
"zone.music_day,"
"zone.music_night,"
"zone.battlesolo,"
"zone.battlemulti,"
"zone.tax,"
"zone.misc,"
"zone.navmesh,"
"zone.zonetype,"
"bcnm.name,"
"zone.eventtype "
"FROM zone_settings AS zone "
"LEFT JOIN bcnm_info AS bcnm "
"USING (zoneid) "
"WHERE zoneid = %u "
"LIMIT 1";
if (Sql_Query(SqlHandle, Query, m_zoneID) != SQL_ERROR &&
Sql_NumRows(SqlHandle) != 0 &&
Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
m_zoneName.insert(0, Sql_GetData(SqlHandle,0));
m_zoneIP = inet_addr(Sql_GetData(SqlHandle,1));
m_zonePort = (uint16)Sql_GetUIntData(SqlHandle,2);
m_zoneMusic.m_songDay = (uint8)Sql_GetUIntData(SqlHandle, 3); // background music (day)
m_zoneMusic.m_songNight = (uint8)Sql_GetUIntData(SqlHandle, 4); // background music (night)
m_zoneMusic.m_bSongS = (uint8)Sql_GetUIntData(SqlHandle,5); // solo battle music
m_zoneMusic.m_bSongM = (uint8)Sql_GetUIntData(SqlHandle,6); // party battle music
m_tax = (uint16)(Sql_GetFloatData(SqlHandle,7) * 100); // tax for bazaar
m_miscMask = (uint16)Sql_GetUIntData(SqlHandle,8);
m_useNavMesh = (bool)Sql_GetIntData(SqlHandle,9);
m_eventType = (EVENTTYPE)Sql_GetUIntData(SqlHandle, 12);
if (luautils::IsSummerfestYearRound())
{
if ((EVENTTYPE)Sql_GetUIntData(SqlHandle, 12) >= 3)
{
m_zoneMusic.m_songNight = 227; // background music (night)
}
}
m_zoneType = (ZONETYPE)Sql_GetUIntData(SqlHandle, 10);
//luautils::OnZoneWeatherChange(GetID(), Weather);
if (Sql_GetData(SqlHandle,11) != nullptr) // сейчас нельзя использовать bcnmid, т.к. они начинаются с нуля
{
m_BattlefieldHandler = new CBattlefieldHandler(m_zoneID);
}
if (m_miscMask & MISC_TREASURE)
{
m_TreasurePool = new CTreasurePool(TREASUREPOOL_ZONE);
}
}
else
{
ShowFatalError(CL_RED"CZone::LoadZoneSettings: Cannot load zone settings (%u)\n" CL_RESET, m_zoneID);
}
}
/***************************************************************
Spawns monsters for the given BCNMID/Battlefield number by
looking at bcnm_battlefield table for mob ids then spawning
them and adding them to the monster list for the given
battlefield.
****************************************************************/
bool spawnMonstersForBcnm(CBattlefield* battlefield) {
DSP_DEBUG_BREAK_IF(battlefield == nullptr);
//get ids from DB
const int8* fmtQuery = "SELECT monsterId, conditions \
FROM bcnm_battlefield \
WHERE bcnmId = %u AND battlefieldNumber = %u";
int32 ret = Sql_Query(SqlHandle, fmtQuery, battlefield->getID(), battlefield->getBattlefieldNumber());
if (ret == SQL_ERROR ||
Sql_NumRows(SqlHandle) == 0)
{
ShowError("spawnMonstersForBcnm : SQL error - Cannot find any monster IDs for BCNMID %i Battlefield %i \n",
battlefield->getID(), battlefield->getBattlefieldNumber());
}
else {
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS) {
uint32 mobid = Sql_GetUIntData(SqlHandle, 0);
uint8 condition = Sql_GetUIntData(SqlHandle, 1);
CMobEntity* PMob = (CMobEntity*)zoneutils::GetEntity(mobid, TYPE_MOB);
if (PMob != nullptr)
{
PMob->m_battlefieldID = battlefield->getBattlefieldNumber();
PMob->m_bcnmID = battlefield->getID();
if (condition & CONDITION_SPAWNED_AT_START)
{
if (!PMob->PAI->IsSpawned())
{
PMob->Spawn();
if (strcmp(PMob->GetName(), "Maat") == 0) {
mobutils::InitializeMaat(PMob, (JOBTYPE)battlefield->getPlayerMainJob());
// disable players subjob
battlefield->disableSubJob();
// disallow subjob, this will enable for later
battlefield->m_RuleMask &= ~(1 << RULES_ALLOW_SUBJOBS);
}
//ShowDebug("Spawned %s (%u) id %i inst %i \n",PMob->GetName(),PMob->id,battlefield->getID(),battlefield->getBattlefieldNumber());
battlefield->addEnemy(PMob, condition);
}
else {
ShowDebug(CL_CYAN"SpawnMobForBcnm: <%s> (%u) is already spawned\n" CL_RESET, PMob->GetName(), PMob->id);
}
}
else {
battlefield->addEnemy(PMob, condition);
}
}
else {
ShowDebug("SpawnMobForBcnm: mob %u not found\n", mobid);
}
}
return true;
}
return false;
}
CCurrencyPacket1::CCurrencyPacket1(CCharEntity* PChar)
{
this->type = 0x13;
this->size = 0x6F;
const char* query = "SELECT sandoria_cp, bastok_cp, windurst_cp, beastman_seal, kindred_seal, kindred_crest, \
high_kindred_crest, sacred_kindred_crest, ancient_beastcoin, valor_point, scyld, \
guild_fishing, guild_woodworking, guild_smithing, guild_goldsmithing, guild_weaving, \
guild_leathercraft, guild_bonecraft, guild_alchemy, guild_cooking, cinder, fire_fewell, \
ice_fewell, wind_fewell, earth_fewell, lightning_fewell, water_fewell, light_fewell, \
dark_fewell, ballista_point, fellow_point, chocobuck_sandoria, chocobuck_bastok, chocobuck_windurst, \
research_mark, tunnel_worm, morion_worm, phantom_worm, moblin_marble, infamy, prestige, \
legion_point, spark_of_eminence, shining_star, imperial_standing, leujaoam_assault_point, \
mamool_assault_point, lebros_assault_point, periqia_assault_point, ilrusi_assault_point, \
nyzul_isle_assault_point, zeni_point, jetton, therion_ichor, allied_notes, cruor, resistance_credit, \
dominion_note, fifth_echelon_trophy, fourth_echelon_trophy, third_echelon_trophy, second_echelon_trophy, \
first_echelon_trophy, cave_points, id_tags, op_credits, traverser_stones, voidstones, kupofried_corundums, \
pheromone_sacks FROM char_points WHERE charid = %d";
int ret = Sql_Query(SqlHandle, query, PChar->id);
if (ret != SQL_ERROR && Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
WBUFL(data, (0x04)-4) = Sql_GetIntData(SqlHandle, 0);
WBUFL(data, (0x08)-4) = Sql_GetIntData(SqlHandle, 1);
WBUFL(data, (0x0C)-4) = Sql_GetIntData(SqlHandle, 2);
WBUFW(data, (0x10)-4) = Sql_GetUIntData(SqlHandle, 3);
WBUFW(data, (0x12)-4) = Sql_GetUIntData(SqlHandle, 4);
WBUFW(data, (0x14)-4) = Sql_GetUIntData(SqlHandle, 5);
WBUFW(data, (0x16)-4) = Sql_GetUIntData(SqlHandle, 6);
WBUFW(data, (0x18)-4) = Sql_GetUIntData(SqlHandle, 7);
WBUFW(data, (0x1A)-4) = Sql_GetUIntData(SqlHandle, 8);
WBUFW(data, (0x1C)-4) = Sql_GetUIntData(SqlHandle, 9);
WBUFW(data, (0x1E)-4) = Sql_GetUIntData(SqlHandle, 10);
WBUFL(data, (0x20)-4) = Sql_GetIntData(SqlHandle, 11);
WBUFL(data, (0x24)-4) = Sql_GetIntData(SqlHandle, 12);
WBUFL(data, (0x28)-4) = Sql_GetIntData(SqlHandle, 13);
WBUFL(data, (0x2C)-4) = Sql_GetIntData(SqlHandle, 14);
WBUFL(data, (0x30)-4) = Sql_GetIntData(SqlHandle, 15);
WBUFL(data, (0x34)-4) = Sql_GetIntData(SqlHandle, 16);
WBUFL(data, (0x38)-4) = Sql_GetIntData(SqlHandle, 17);
WBUFL(data, (0x3C)-4) = Sql_GetIntData(SqlHandle, 18);
WBUFL(data, (0x40)-4) = Sql_GetIntData(SqlHandle, 19);
WBUFL(data, (0x44)-4) = Sql_GetIntData(SqlHandle, 20);
WBUFB(data, (0x48)-4) = Sql_GetUIntData(SqlHandle, 21);
WBUFB(data, (0x49)-4) = Sql_GetUIntData(SqlHandle, 22);
WBUFB(data, (0x4A)-4) = Sql_GetUIntData(SqlHandle, 23);
WBUFB(data, (0x4B)-4) = Sql_GetUIntData(SqlHandle, 24);
WBUFB(data, (0x4C)-4) = Sql_GetUIntData(SqlHandle, 25);
WBUFB(data, (0x4D)-4) = Sql_GetUIntData(SqlHandle, 26);
WBUFB(data, (0x4E)-4) = Sql_GetUIntData(SqlHandle, 27);
WBUFB(data, (0x4F)-4) = Sql_GetUIntData(SqlHandle, 28);
WBUFL(data, (0x50)-4) = Sql_GetIntData(SqlHandle, 29);
WBUFL(data, (0x54)-4) = Sql_GetIntData(SqlHandle, 30);
WBUFW(data, (0x58)-4) = Sql_GetUIntData(SqlHandle, 31);
WBUFW(data, (0x5A)-4) = Sql_GetUIntData(SqlHandle, 32);
WBUFW(data, (0x5C)-4) = Sql_GetUIntData(SqlHandle, 33);
// daily tally (2 byte)
WBUFL(data, (0x60)-4) = Sql_GetIntData(SqlHandle, 34);
WBUFB(data, (0x64)-4) = Sql_GetUIntData(SqlHandle, 35);
WBUFB(data, (0x65)-4) = Sql_GetUIntData(SqlHandle, 36);
WBUFB(data, (0x66)-4) = Sql_GetUIntData(SqlHandle, 37);
WBUFL(data, (0x68)-4) = Sql_GetIntData(SqlHandle, 38);
WBUFW(data, (0x6C)-4) = Sql_GetUIntData(SqlHandle, 39);
WBUFW(data, (0x6E)-4) = Sql_GetUIntData(SqlHandle, 40);
WBUFL(data, (0x70)-4) = Sql_GetIntData(SqlHandle, 41);
WBUFL(data, (0x74)-4) = Sql_GetIntData(SqlHandle, 42);
WBUFL(data, (0x78)-4) = Sql_GetIntData(SqlHandle, 43);
WBUFL(data, (0x7C)-4) = Sql_GetIntData(SqlHandle, 44);
WBUFL(data, (0x80)-4) = Sql_GetIntData(SqlHandle, 45);
WBUFL(data, (0x84)-4) = Sql_GetIntData(SqlHandle, 46);
WBUFL(data, (0x88)-4) = Sql_GetIntData(SqlHandle, 47);
WBUFL(data, (0x8C)-4) = Sql_GetIntData(SqlHandle, 48);
WBUFL(data, (0x90)-4) = Sql_GetIntData(SqlHandle, 49);
WBUFL(data, (0x94)-4) = Sql_GetIntData(SqlHandle, 50);
WBUFL(data, (0x98)-4) = Sql_GetIntData(SqlHandle, 51);
WBUFL(data, (0x9C)-4) = Sql_GetIntData(SqlHandle, 52);
WBUFL(data, (0xA0)-4) = Sql_GetIntData(SqlHandle, 53);
WBUFL(data, (0xA4)-4) = Sql_GetIntData(SqlHandle, 54);
// AMAN vouchers
// unity accolades
WBUFL(data, (0xAC)-4) = Sql_GetIntData(SqlHandle, 55);
WBUFL(data, (0xB0)-4) = Sql_GetIntData(SqlHandle, 56);
WBUFL(data, (0xB4)-4) = Sql_GetIntData(SqlHandle, 57);
WBUFB(data, (0xB8)-4) = Sql_GetUIntData(SqlHandle, 58);
WBUFB(data, (0xB9)-4) = Sql_GetUIntData(SqlHandle, 59);
WBUFB(data, (0xBA)-4) = Sql_GetUIntData(SqlHandle, 60);
WBUFB(data, (0xBB)-4) = Sql_GetUIntData(SqlHandle, 61);
WBUFB(data, (0xBC)-4) = Sql_GetUIntData(SqlHandle, 62);
WBUFB(data, (0xBD)-4) = Sql_GetUIntData(SqlHandle, 63);
WBUFB(data, (0xBE)-4) = Sql_GetUIntData(SqlHandle, 64);
WBUFB(data, (0xBF)-4) = Sql_GetUIntData(SqlHandle, 65);
WBUFL(data, (0xC0)-4) = Sql_GetIntData(SqlHandle, 66);
WBUFL(data, (0xC4)-4) = Sql_GetIntData(SqlHandle, 67);
WBUFL(data, (0xC8)-4) = Sql_GetIntData(SqlHandle, 68);
WBUFB(data, (0xCC)-4) = Sql_GetUIntData(SqlHandle, 69);
}
}
void CParty::ReloadParty()
{
//check if partyflags have changed
int ret = Sql_Query(SqlHandle, "SELECT charid, partyflag FROM accounts_parties WHERE partyid = %d;", m_PartyID);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) > 0)
{
uint8 j = 0;
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint32 charid = Sql_GetUIntData(SqlHandle, 0);
uint16 memberflags = Sql_GetUIntData(SqlHandle, 1);
if (memberflags & PARTY_LEADER)
{
bool found = false;
for (auto member : members)
{
if (member->id == charid)
{
m_PLeader = member;
found = true;
}
}
if (!found)
{
m_PLeader = NULL;
}
}
if (memberflags & PARTY_QM)
{
bool found = false;
for (auto member : members)
{
if (member->id == charid)
{
m_PQuaterMaster = member;
found = true;
}
}
if (!found)
{
m_PQuaterMaster = NULL;
}
}
}
}
//alliance
if (this->m_PAlliance != NULL)
{
for (uint8 a = 0; a < m_PAlliance->partyList.size(); ++a)
{
for (uint8 i = 0; i < m_PAlliance->partyList.at(a)->members.size(); ++i)
{
CCharEntity* PChar = (CCharEntity*)m_PAlliance->partyList.at(a)->members.at(i);
PChar->ReloadPartyDec();
uint16 alliance = 0;
PChar->pushPacket(new CPartyDefinePacket(m_PAlliance->partyList.at(a)));
int ret = Sql_Query(SqlHandle, "SELECT chars.charid, chars.charname, partyflag, pos_zone, partyid FROM accounts_parties \
LEFT JOIN chars ON accounts_parties.charid = chars.charid WHERE \
allianceid = %d ORDER BY partyflag & %u, timestamp;",
m_PAlliance->m_AllianceID, PARTY_SECOND | PARTY_THIRD);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) > 0)
{
uint8 j = 0;
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
if (Sql_GetUIntData(SqlHandle, 2) & (PARTY_SECOND | PARTY_THIRD) != alliance)
{
alliance = Sql_GetUIntData(SqlHandle, 2) & (PARTY_SECOND | PARTY_THIRD);
j = 0;
}
CCharEntity* PPartyMember = zoneutils::GetChar(Sql_GetUIntData(SqlHandle, 0));
if (PPartyMember)
{
PChar->pushPacket(new CPartyMemberUpdatePacket(PPartyMember, j, PChar->getZone()));
}
else
{
PChar->pushPacket(new CPartyMemberUpdatePacket(
Sql_GetUIntData(SqlHandle, 0), Sql_GetData(SqlHandle, 1),
Sql_GetUIntData(SqlHandle, 2), Sql_GetUIntData(SqlHandle, 3)));
}
j++;
}
}
}
}
}
else
//regular party
for (uint8 i = 0; i < members.size(); ++i)
void LoadMOBList()
{
const int8* Query =
"SELECT zoneid, name, mobid, pos_rot, pos_x, pos_y, pos_z, \
respawntime, spawntype, dropid, mob_groups.HP, mob_groups.MP, minLevel, maxLevel, \
modelid, mJob, sJob, cmbSkill, cmbDmgMult, cmbDelay, behavior, links, mobType, immunity, \
systemid, mobsize, speed, \
STR, DEX, VIT, AGI, `INT`, MND, CHR, EVA, DEF, \
Slash, Pierce, H2H, Impact, \
Fire, Ice, Wind, Earth, Lightning, Water, Light, Dark, Element, \
mob_pools.familyid, name_prefix, unknown, animationsub, \
(mob_family_system.HP / 100), (mob_family_system.MP / 100), hasSpellScript, spellList, ATT, ACC, mob_groups.poolid \
FROM mob_groups INNER JOIN mob_pools ON mob_groups.poolid = mob_pools.poolid \
INNER JOIN mob_spawn_points ON mob_groups.groupid = mob_spawn_points.groupid \
INNER JOIN mob_family_system ON mob_pools.familyid = mob_family_system.familyid \
WHERE NOT (pos_x = 0 AND pos_y = 0 AND pos_z = 0);";
int32 ret = Sql_Query(SqlHandle, Query);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 ZoneID = (uint16)Sql_GetUIntData(SqlHandle, 0);
CMobEntity* PMob = new CMobEntity;
PMob->name.insert(0,Sql_GetData(SqlHandle,1));
PMob->id = (uint32)Sql_GetUIntData(SqlHandle,2);
PMob->targid = (uint16)PMob->id & 0x0FFF;
PMob->m_SpawnPoint.rotation = (uint8)Sql_GetIntData(SqlHandle,3);
PMob->m_SpawnPoint.x = Sql_GetFloatData(SqlHandle,4);
PMob->m_SpawnPoint.y = Sql_GetFloatData(SqlHandle,5);
PMob->m_SpawnPoint.z = Sql_GetFloatData(SqlHandle,6);
PMob->m_RespawnTime = Sql_GetUIntData(SqlHandle,7) * 1000;
PMob->m_SpawnType = (SPAWNTYPE)Sql_GetUIntData(SqlHandle,8);
PMob->m_DropID = Sql_GetUIntData(SqlHandle,9);
PMob->HPmodifier = (uint32)Sql_GetIntData(SqlHandle,10);
PMob->MPmodifier = (uint32)Sql_GetIntData(SqlHandle,11);
PMob->m_minLevel = (uint8)Sql_GetIntData(SqlHandle,12);
PMob->m_maxLevel = (uint8)Sql_GetIntData(SqlHandle,13);
memcpy(&PMob->look,Sql_GetData(SqlHandle,14),23);
PMob->SetMJob(Sql_GetIntData(SqlHandle,15));
PMob->SetSJob(Sql_GetIntData(SqlHandle,16));
PMob->m_Weapons[SLOT_MAIN]->setMaxHit(1);
PMob->m_Weapons[SLOT_MAIN]->setSkillType(Sql_GetIntData(SqlHandle,17));
PMob->m_dmgMult = Sql_GetUIntData(SqlHandle, 18);
PMob->m_Weapons[SLOT_MAIN]->setDelay((Sql_GetIntData(SqlHandle,19) * 1000)/60);
PMob->m_Weapons[SLOT_MAIN]->setBaseDelay((Sql_GetIntData(SqlHandle,19) * 1000)/60);
PMob->m_Behaviour = (uint16)Sql_GetIntData(SqlHandle,20);
PMob->m_Link = (uint8)Sql_GetIntData(SqlHandle,21);
PMob->m_Type = (uint8)Sql_GetIntData(SqlHandle,22);
PMob->m_Immunity = (IMMUNITY)Sql_GetIntData(SqlHandle,23);
PMob->m_EcoSystem = (ECOSYSTEM)Sql_GetIntData(SqlHandle,24);
PMob->m_ModelSize += (uint8)Sql_GetIntData(SqlHandle,25);
PMob->speed = (uint8)Sql_GetIntData(SqlHandle,26);
PMob->speedsub = (uint8)Sql_GetIntData(SqlHandle,26);
/*if(PMob->speed != 0)
{
PMob->speed += map_config.speed_mod;
// whats this for?
PMob->speedsub += map_config.speed_mod;
}*/
PMob->strRank = (uint8)Sql_GetIntData(SqlHandle,27);
PMob->dexRank = (uint8)Sql_GetIntData(SqlHandle,28);
PMob->vitRank = (uint8)Sql_GetIntData(SqlHandle,29);
PMob->agiRank = (uint8)Sql_GetIntData(SqlHandle,30);
PMob->intRank = (uint8)Sql_GetIntData(SqlHandle,31);
PMob->mndRank = (uint8)Sql_GetIntData(SqlHandle,32);
PMob->chrRank = (uint8)Sql_GetIntData(SqlHandle,33);
PMob->evaRank = (uint8)Sql_GetIntData(SqlHandle,34);
PMob->defRank = (uint8)Sql_GetIntData(SqlHandle,35);
PMob->attRank = (uint8)Sql_GetIntData(SqlHandle,57);
PMob->accRank = (uint8)Sql_GetIntData(SqlHandle,58);
PMob->setModifier(MOD_SLASHRES, (uint16)(Sql_GetFloatData(SqlHandle,36) * 1000));
PMob->setModifier(MOD_PIERCERES,(uint16)(Sql_GetFloatData(SqlHandle,37) * 1000));
PMob->setModifier(MOD_HTHRES, (uint16)(Sql_GetFloatData(SqlHandle,38) * 1000));
PMob->setModifier(MOD_IMPACTRES,(uint16)(Sql_GetFloatData(SqlHandle,39) * 1000));
PMob->setModifier(MOD_FIREDEF, (int16)((Sql_GetFloatData(SqlHandle, 40) - 1) * -1000)); // These are stored as floating percentages
PMob->setModifier(MOD_ICEDEF, (int16)((Sql_GetFloatData(SqlHandle, 41) - 1) * -1000)); // and need to be adjusted into modifier units.
PMob->setModifier(MOD_WINDDEF, (int16)((Sql_GetFloatData(SqlHandle, 42) - 1) * -1000)); // Higher DEF = lower damage.
PMob->setModifier(MOD_EARTHDEF, (int16)((Sql_GetFloatData(SqlHandle, 43) - 1) * -1000)); // Negatives signify increased damage.
PMob->setModifier(MOD_THUNDERDEF, (int16)((Sql_GetFloatData(SqlHandle, 44) - 1) * -1000)); // Positives signify reduced damage.
PMob->setModifier(MOD_WATERDEF, (int16)((Sql_GetFloatData(SqlHandle, 45) - 1) * -1000)); // Ex: 125% damage would be 1.25, 50% damage would be 0.50
PMob->setModifier(MOD_LIGHTDEF, (int16)((Sql_GetFloatData(SqlHandle, 46) - 1) * -1000)); // (1.25 - 1) * -1000 = -250 DEF
PMob->setModifier(MOD_DARKDEF, (int16)((Sql_GetFloatData(SqlHandle, 47) - 1) * -1000)); // (0.50 - 1) * -1000 = 500 DEF
PMob->setModifier(MOD_FIRERES, (int16)((Sql_GetFloatData(SqlHandle, 40) - 1) * -100)); // These are stored as floating percentages
PMob->setModifier(MOD_ICERES, (int16)((Sql_GetFloatData(SqlHandle, 41) - 1) * -100)); // and need to be adjusted into modifier units.
PMob->setModifier(MOD_WINDRES, (int16)((Sql_GetFloatData(SqlHandle, 42) - 1) * -100)); // Higher RES = lower damage.
PMob->setModifier(MOD_EARTHRES, (int16)((Sql_GetFloatData(SqlHandle, 43) - 1) * -100)); // Negatives signify lower resist chance.
PMob->setModifier(MOD_THUNDERRES, (int16)((Sql_GetFloatData(SqlHandle, 44) - 1) * -100)); // Positives signify increased resist chance.
PMob->setModifier(MOD_WATERRES, (int16)((Sql_GetFloatData(SqlHandle, 45) - 1) * -100));
PMob->setModifier(MOD_LIGHTRES, (int16)((Sql_GetFloatData(SqlHandle, 46) - 1) * -100));
PMob->setModifier(MOD_DARKRES, (int16)((Sql_GetFloatData(SqlHandle, 47) - 1) * -100));
PMob->m_Element = (uint8)Sql_GetIntData(SqlHandle,48);
PMob->m_Family = (uint16)Sql_GetIntData(SqlHandle,49);
PMob->m_name_prefix = (uint8)Sql_GetIntData(SqlHandle,50);
PMob->m_unknown = (uint32)Sql_GetIntData(SqlHandle,51);
//Special sub animation for Mob (yovra, jailer of love, phuabo)
// yovra 1: en hauteur, 2: en bas, 3: en haut
// phuabo 1: sous l'eau, 2: sort de l'eau, 3: rentre dans l'eau
PMob->animationsub = (uint32)Sql_GetIntData(SqlHandle,52);
// Setup HP / MP Stat Percentage Boost
PMob->HPscale = Sql_GetFloatData(SqlHandle,53);
PMob->MPscale = Sql_GetFloatData(SqlHandle,54);
PMob->PBattleAI = new CAIMobDummy(PMob);
if (PMob->m_AllowRespawn = PMob->m_SpawnType == SPAWNTYPE_NORMAL)
{
PMob->PBattleAI->SetCurrentAction(ACTION_SPAWN);
}
// Check if we should be looking up scripts for this mob
PMob->m_HasSpellScript = (uint8)Sql_GetIntData(SqlHandle,55);
PMob->m_SpellListContainer = mobSpellList::GetMobSpellList(Sql_GetIntData(SqlHandle,56));
PMob->m_Pool = Sql_GetUIntData(SqlHandle,59);
// must be here first to define mobmods
mobutils::InitializeMob(PMob, GetZone(ZoneID));
GetZone(ZoneID)->InsertMOB(PMob);
luautils::OnMobInitialize(PMob);
PMob->saveModifiers();
PMob->saveMobModifiers();
}
}
// attach pets to mobs
const int8* PetQuery =
"SELECT zoneid, mob_mobid, pet_offset \
FROM mob_pets \
LEFT JOIN mob_spawn_points ON mob_pets.mob_mobid = mob_spawn_points.mobid \
LEFT JOIN mob_groups ON mob_spawn_points.groupid = mob_groups.groupid;";
ret = Sql_Query(SqlHandle, PetQuery);
if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while(Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint16 ZoneID = (uint16)Sql_GetUIntData(SqlHandle, 0);
uint32 masterid = (uint32)Sql_GetUIntData(SqlHandle,1);
uint32 petid = masterid + (uint32)Sql_GetUIntData(SqlHandle,2);
CMobEntity* PMaster = (CMobEntity*)GetZone(ZoneID)->GetEntity(masterid & 0x0FFF, TYPE_MOB);
CMobEntity* PPet = (CMobEntity*)GetZone(ZoneID)->GetEntity(petid & 0x0FFF, TYPE_MOB);
if(PMaster == NULL)
{
ShowError("zoneutils::loadMOBList PMaster is null. masterid: %d. Make sure x,y,z are not zeros, and that all entities are entered in the database!\n", masterid);
}
else if(PPet == NULL)
{
ShowError("zoneutils::loadMOBList PPet is null. petid: %d. Make sure x,y,z are not zeros!\n", petid);
}
else if(masterid == petid)
{
ShowError("zoneutils::loadMOBList Master and Pet are the same entity: %d\n", masterid);
}
else
{
// pet is always spawned by master
PPet->m_AllowRespawn = false;
PPet->m_SpawnType = SPAWNTYPE_SCRIPTED;
PPet->PBattleAI->SetCurrentAction(ACTION_NONE);
PPet->SetDespawnTimer(0);
PMaster->PPet = PPet;
PPet->PMaster = PMaster;
}
}
}
}
CMobEntity* InstantiateAlly(uint32 groupid, uint16 zoneID, CInstance* instance)
{
const char* Query =
"SELECT zoneid, name, \
respawntime, spawntype, dropid, mob_groups.HP, mob_groups.MP, minLevel, maxLevel, \
modelid, mJob, sJob, cmbSkill, cmbDmgMult, cmbDelay, behavior, links, mobType, immunity, \
systemid, mobsize, speed, \
STR, DEX, VIT, AGI, `INT`, MND, CHR, EVA, DEF, \
Slash, Pierce, H2H, Impact, \
Fire, Ice, Wind, Earth, Lightning, Water, Light, Dark, Element, \
mob_pools.familyid, name_prefix, entityFlags, animationsub, \
(mob_family_system.HP / 100), (mob_family_system.MP / 100), hasSpellScript, spellList, ATT, ACC, mob_groups.poolid, \
allegiance, namevis, aggro, mob_pools.skill_list_id, mob_pools.true_detection, mob_family_system.detects, packet_name \
FROM mob_groups INNER JOIN mob_pools ON mob_groups.poolid = mob_pools.poolid \
INNER JOIN mob_family_system ON mob_pools.familyid = mob_family_system.familyid \
WHERE mob_groups.groupid = %u";
int32 ret = Sql_Query(SqlHandle, Query, groupid);
CMobEntity* PMob = nullptr;
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
if (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
PMob = new CMobEntity;
PMob->PInstance = instance;
PMob->name.insert(0, (const char*)Sql_GetData(SqlHandle, 1));
PMob->packetName.insert(0, (const char*)Sql_GetData(SqlHandle, 61));
PMob->m_RespawnTime = Sql_GetUIntData(SqlHandle, 2) * 1000;
PMob->m_SpawnType = (SPAWNTYPE)Sql_GetUIntData(SqlHandle, 3);
PMob->m_DropID = Sql_GetUIntData(SqlHandle, 4);
PMob->HPmodifier = (uint32)Sql_GetIntData(SqlHandle, 5);
PMob->MPmodifier = (uint32)Sql_GetIntData(SqlHandle, 6);
PMob->m_minLevel = (uint8)Sql_GetIntData(SqlHandle, 7);
PMob->m_maxLevel = (uint8)Sql_GetIntData(SqlHandle, 8);
memcpy(&PMob->look, Sql_GetData(SqlHandle, 9), 23);
PMob->SetMJob(Sql_GetIntData(SqlHandle, 10));
PMob->SetSJob(Sql_GetIntData(SqlHandle, 11));
PMob->m_Weapons[SLOT_MAIN]->setMaxHit(1);
PMob->m_Weapons[SLOT_MAIN]->setSkillType(Sql_GetIntData(SqlHandle, 12));
PMob->m_dmgMult = Sql_GetUIntData(SqlHandle, 13);
PMob->m_Weapons[SLOT_MAIN]->setDelay((Sql_GetIntData(SqlHandle, 14) * 1000) / 60);
PMob->m_Weapons[SLOT_MAIN]->setBaseDelay((Sql_GetIntData(SqlHandle, 14) * 1000) / 60);
PMob->m_Behaviour = (uint16)Sql_GetIntData(SqlHandle, 15);
PMob->m_Link = (uint8)Sql_GetIntData(SqlHandle, 16);
PMob->m_Type = (uint8)Sql_GetIntData(SqlHandle, 17);
PMob->m_Immunity = (IMMUNITY)Sql_GetIntData(SqlHandle, 18);
PMob->m_EcoSystem = (ECOSYSTEM)Sql_GetIntData(SqlHandle, 19);
PMob->m_ModelSize = (uint8)Sql_GetIntData(SqlHandle, 10);
PMob->speed = (uint8)Sql_GetIntData(SqlHandle, 21);
PMob->speedsub = (uint8)Sql_GetIntData(SqlHandle, 21);
/*if(PMob->speed != 0)
{
PMob->speed += map_config.speed_mod;
// whats this for?
PMob->speedsub += map_config.speed_mod;
}*/
PMob->strRank = (uint8)Sql_GetIntData(SqlHandle, 22);
PMob->dexRank = (uint8)Sql_GetIntData(SqlHandle, 23);
PMob->vitRank = (uint8)Sql_GetIntData(SqlHandle, 24);
PMob->agiRank = (uint8)Sql_GetIntData(SqlHandle, 25);
PMob->intRank = (uint8)Sql_GetIntData(SqlHandle, 26);
PMob->mndRank = (uint8)Sql_GetIntData(SqlHandle, 27);
PMob->chrRank = (uint8)Sql_GetIntData(SqlHandle, 28);
PMob->evaRank = (uint8)Sql_GetIntData(SqlHandle, 29);
PMob->defRank = (uint8)Sql_GetIntData(SqlHandle, 30);
PMob->attRank = (uint8)Sql_GetIntData(SqlHandle, 52);
PMob->accRank = (uint8)Sql_GetIntData(SqlHandle, 53);
PMob->setModifier(Mod::SLASHRES, (uint16)(Sql_GetFloatData(SqlHandle, 31) * 1000));
PMob->setModifier(Mod::PIERCERES, (uint16)(Sql_GetFloatData(SqlHandle, 32) * 1000));
PMob->setModifier(Mod::HTHRES, (uint16)(Sql_GetFloatData(SqlHandle, 33) * 1000));
PMob->setModifier(Mod::IMPACTRES, (uint16)(Sql_GetFloatData(SqlHandle, 34) * 1000));
PMob->setModifier(Mod::FIRERES, (int16)((Sql_GetFloatData(SqlHandle, 35) - 1) * -100)); // These are stored as floating percentages
PMob->setModifier(Mod::ICERES, (int16)((Sql_GetFloatData(SqlHandle, 36) - 1) * -100)); // and need to be adjusted into modifier units.
PMob->setModifier(Mod::WINDRES, (int16)((Sql_GetFloatData(SqlHandle, 37) - 1) * -100)); // Higher RES = lower damage.
PMob->setModifier(Mod::EARTHRES, (int16)((Sql_GetFloatData(SqlHandle, 38) - 1) * -100)); // Negatives signify lower resist chance.
PMob->setModifier(Mod::THUNDERRES, (int16)((Sql_GetFloatData(SqlHandle, 39) - 1) * -100)); // Positives signify increased resist chance.
PMob->setModifier(Mod::WATERRES, (int16)((Sql_GetFloatData(SqlHandle, 40) - 1) * -100));
PMob->setModifier(Mod::LIGHTRES, (int16)((Sql_GetFloatData(SqlHandle, 41) - 1) * -100));
PMob->setModifier(Mod::DARKRES, (int16)((Sql_GetFloatData(SqlHandle, 42) - 1) * -100));
PMob->m_Element = (uint8)Sql_GetIntData(SqlHandle, 43);
PMob->m_Family = (uint16)Sql_GetIntData(SqlHandle, 44);
PMob->m_name_prefix = (uint8)Sql_GetIntData(SqlHandle, 45);
PMob->m_flags = (uint32)Sql_GetIntData(SqlHandle, 46);
//Special sub animation for Mob (yovra, jailer of love, phuabo)
// yovra 1: en hauteur, 2: en bas, 3: en haut
// phuabo 1: sous l'eau, 2: sort de l'eau, 3: rentre dans l'eau
PMob->animationsub = (uint32)Sql_GetIntData(SqlHandle, 47);
// Setup HP / MP Stat Percentage Boost
PMob->HPscale = Sql_GetFloatData(SqlHandle, 48);
PMob->MPscale = Sql_GetFloatData(SqlHandle, 49);
// Check if we should be looking up scripts for this mob
PMob->m_HasSpellScript = (uint8)Sql_GetIntData(SqlHandle, 50);
PMob->m_SpellListContainer = mobSpellList::GetMobSpellList(Sql_GetIntData(SqlHandle, 51));
PMob->m_Pool = Sql_GetUIntData(SqlHandle, 54);
PMob->allegiance = Sql_GetUIntData(SqlHandle, 55);
PMob->namevis = Sql_GetUIntData(SqlHandle, 56);
PMob->m_Aggro = Sql_GetUIntData(SqlHandle, 57);
PMob->m_MobSkillList = Sql_GetUIntData(SqlHandle, 58);
PMob->m_TrueDetection = Sql_GetUIntData(SqlHandle, 59);
PMob->m_Detects = Sql_GetUIntData(SqlHandle, 60);
// must be here first to define mobmods
mobutils::InitializeMob(PMob, zoneutils::GetZone(zoneID));
zoneutils::GetZone(zoneID)->InsertPET(PMob);
luautils::OnMobInitialize(PMob);
luautils::ApplyMixins(PMob);
PMob->saveModifiers();
PMob->saveMobModifiers();
}
}
return PMob;
}
int32 login_parse(int32 fd)
{
login_session_data_t* sd = (login_session_data_t*)session[fd]->session_data;
//check if sd will not defined
if (sd == nullptr)
{
session[fd]->session_data = new login_session_data_t{};
sd = (login_session_data_t*)session[fd]->session_data;
sd->serviced = 0;
login_sd_list.push_back(sd);
sd->client_addr = session[fd]->client_addr;
sd->login_fd = fd;
}
if (session[fd]->flag.eof)
{
do_close_login(sd, fd);
return 0;
}
//all auth packets have one structure:
// [login][passwords][code] => summary assign 33 bytes
if (session[fd]->rdata.size() == 33)
{
char* buff = &session[fd]->rdata[0];
int8 code = ref<uint8>(buff, 32);
std::string name(buff, buff + 16);
std::string password(buff + 16, buff + 32);
std::fill_n(sd->login, sizeof sd->login, '\0');
std::copy(name.cbegin(), name.cend(), sd->login);
//data check
if (check_string(name, 16) && check_string(password, 16))
{
ShowWarning(CL_WHITE"login_parse" CL_RESET":" CL_WHITE"%s" CL_RESET" send unreadable data\n", ip2str(sd->client_addr, nullptr));
session[fd]->wdata.resize(1);
ref<uint8>(session[fd]->wdata.data(), 0) = LOGIN_ERROR;
do_close_login(sd, fd);
return -1;
}
switch (code)
{
case LOGIN_ATTEMPT:
{
const char* fmtQuery = "SELECT accounts.id,accounts.status \
FROM accounts \
WHERE accounts.login = '******' AND accounts.password = PASSWORD('%s')";
int32 ret = Sql_Query(SqlHandle, fmtQuery, name.c_str(), password.c_str());
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
ret = Sql_NextRow(SqlHandle);
sd->accid = (uint32)Sql_GetUIntData(SqlHandle, 0);
uint8 status = (uint8)Sql_GetUIntData(SqlHandle, 1);
if (status & ACCST_NORMAL)
{
//fmtQuery = "SELECT * FROM accounts_sessions WHERE accid = %d AND client_port <> 0";
//int32 ret = Sql_Query(SqlHandle,fmtQuery,sd->accid);
//if( ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0 )
//{
// ref<uint8>(session[fd]->wdata,0) = 0x05; // SESSION has already activated
// WFIFOSET(fd,33);
// do_close_login(sd,fd);
// return 0;
//}
fmtQuery = "UPDATE accounts SET accounts.timelastmodify = NULL WHERE accounts.id = %d";
Sql_Query(SqlHandle, fmtQuery, sd->accid);
fmtQuery = "SELECT charid, server_addr, server_port \
FROM accounts_sessions JOIN accounts \
ON accounts_sessions.accid = accounts.id \
WHERE accounts.id = %d;";
ret = Sql_Query(SqlHandle, fmtQuery, sd->accid);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) == 1)
{
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
uint32 charid = Sql_GetUIntData(SqlHandle, 0);
uint64 ip = Sql_GetUIntData(SqlHandle, 1);
uint64 port = Sql_GetUIntData(SqlHandle, 2);
ip |= (port << 32);
zmq::message_t chardata(sizeof(charid));
ref<uint32>((uint8*)chardata.data(), 0) = charid;
zmq::message_t empty(0);
queue_message(ip, MSG_LOGIN, &chardata, &empty);
}
}
memset(&session[fd]->wdata[0], 0, 33);
session[fd]->wdata.resize(33);
ref<uint8>(session[fd]->wdata.data(), 0) = LOGIN_SUCCESS;
ref<uint32>(session[fd]->wdata.data(), 1) = sd->accid;
flush_fifo(fd);
do_close_tcp(fd);
}
else if (status & ACCST_BANNED)
{
memset(&session[fd]->wdata[0], 0, 33);
session[fd]->wdata.resize(33);
// ref<uint8>(session[fd]->wdata,0) = LOGIN_SUCCESS;
do_close_login(sd, fd);
}
//////22/03/2012 Fix for when a client crashes before fully logging in:
// Before: When retry to login, would freeze client since login data corrupt.
// After: Removes older login info if a client logs in twice (based on acc id!)
//check for multiple logins from this account id
int numCons = 0;
for (login_sd_list_t::iterator i = login_sd_list.begin(); i != login_sd_list.end(); ++i) {
if ((*i)->accid == sd->accid) {
numCons++;
}
}
if (numCons > 1) {
ShowInfo("login_parse:" CL_WHITE"<%s>" CL_RESET" has logged in %i times! Removing older logins.\n", name.c_str(), numCons);
for (int j = 0; j < (numCons - 1); j++) {
for (login_sd_list_t::iterator i = login_sd_list.begin(); i != login_sd_list.end(); ++i) {
if ((*i)->accid == sd->accid) {
//ShowInfo("Current login fd=%i Removing fd=%i \n",sd->login_fd,(*i)->login_fd);
login_sd_list.erase(i);
break;
}
}
}
}
//////
ShowInfo("login_parse:" CL_WHITE"<%s>" CL_RESET" was connected\n", name.c_str(), status);
return 0;
}
CSynthSuggestionPacket::CSynthSuggestionPacket(uint32 synthID)
{
this->type = 0x31;
this->size = 0x1A;
const int8* fmtQuery =
"SELECT KeyItem, Wood, Smith, Gold, Cloth, Leather, Bone, Alchemy, Cook, Crystal, \
Result, Ingredient1, Ingredient2, Ingredient3, Ingredient4, Ingredient5, Ingredient6, Ingredient7, Ingredient8 \
FROM synth_recipes \
WHERE ID = %u \
LIMIT 1";
int32 ret = Sql_Query(
SqlHandle,
fmtQuery,
synthID);
if (ret != SQL_ERROR &&
Sql_NumRows(SqlHandle) != 0 &&
Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
WBUFW(data,(0x04)) = Sql_GetUIntData(SqlHandle,10);
//words 0x06, 0x08, 0x0A are subcraft number
WBUFW(data,(0x0C)) = Sql_GetUIntData(SqlHandle,9);
WBUFW(data,(0x0E)) = Sql_GetUIntData(SqlHandle,0);
WBUFW(data,(0x10)) = Sql_GetUIntData(SqlHandle,11);
WBUFW(data,(0x12)) = Sql_GetUIntData(SqlHandle,12);
WBUFW(data,(0x14)) = Sql_GetUIntData(SqlHandle,13);
WBUFW(data,(0x16)) = Sql_GetUIntData(SqlHandle,14);
WBUFW(data,(0x18)) = Sql_GetUIntData(SqlHandle,15);
WBUFW(data,(0x1A)) = Sql_GetUIntData(SqlHandle,16);
WBUFW(data,(0x1C)) = Sql_GetUIntData(SqlHandle,17);
WBUFW(data,(0x1E)) = Sql_GetUIntData(SqlHandle,18);
//TODO: words 0x20 through 0x2E are the quantity per material
WBUFW(data,(0x30)) = 0x01;
}
}
void LoadAbilitiesList()
{
// TODO: добавить поле message в таблицу
memset(PAbilityList, 0, sizeof(PAbilityList));
const int8* Query =
"SELECT "
"abilityId,"
"IFNULL(min_id,0),"
"name,"
"job,"
"level,"
"validTarget,"
"recastTime,"
"message1, "
"message2, "
"animation,"
"animationTime,"
"castTime,"
"actionType,"
"`range`,"
"isAOE,"
"recastId,"
"CE,"
"VE, "
"meritModID, "
"addType, "
"required_expansion "
"FROM abilities LEFT JOIN (SELECT mob_skill_name, MIN(mob_skill_id) AS min_id "
"FROM mob_skills GROUP BY mob_skill_name) mob_skills_1 ON "
"abilities.name = mob_skills_1.mob_skill_name "
"WHERE job < %u AND abilityId < %u "
"ORDER BY job, level ASC";
int32 ret = Sql_Query(SqlHandle, Query, MAX_JOBTYPE, MAX_ABILITY_ID);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
int8* expansionCode;
Sql_GetData(SqlHandle, 20, &expansionCode, nullptr);
if (luautils::IsExpansionEnabled(expansionCode) == false) {
continue;
}
CAbility* PAbility = new CAbility(Sql_GetIntData(SqlHandle, 0));
PAbility->setMobSkillID(Sql_GetIntData(SqlHandle, 1));
PAbility->setName(Sql_GetData(SqlHandle, 2));
PAbility->setJob((JOBTYPE)Sql_GetIntData(SqlHandle, 3));
PAbility->setLevel(Sql_GetIntData(SqlHandle, 4));
PAbility->setValidTarget(Sql_GetIntData(SqlHandle, 5));
PAbility->setRecastTime(Sql_GetIntData(SqlHandle, 6));
PAbility->setMessage(Sql_GetIntData(SqlHandle, 7));
//PAbility->setMessage(Sql_GetIntData(SqlHandle,8));
PAbility->setAnimationID(Sql_GetIntData(SqlHandle, 9));
PAbility->setAnimationTime(std::chrono::milliseconds(Sql_GetIntData(SqlHandle, 10)));
PAbility->setCastTime(std::chrono::milliseconds(Sql_GetIntData(SqlHandle, 11)));
PAbility->setActionType(static_cast<ACTIONTYPE>(Sql_GetUIntData(SqlHandle, 12)));
PAbility->setRange(Sql_GetFloatData(SqlHandle, 13));
PAbility->setAOE(Sql_GetIntData(SqlHandle, 14));
PAbility->setRecastId(Sql_GetIntData(SqlHandle, 15));
PAbility->setCE(Sql_GetIntData(SqlHandle, 16));
PAbility->setVE(Sql_GetIntData(SqlHandle, 17));
PAbility->setMeritModID(Sql_GetIntData(SqlHandle, 18));
PAbility->setAddType(Sql_GetUIntData(SqlHandle, 19));
PAbilityList[PAbility->getID()] = PAbility;
PAbilitiesList[PAbility->getJob()].push_back(PAbility);
}
}
const int8* Query2 = "SELECT recastId, job, level, maxCharges, chargeTime, meritModId FROM abilities_charges ORDER BY job, level ASC;";
ret = Sql_Query(SqlHandle, Query2);
if (ret != SQL_ERROR && Sql_NumRows(SqlHandle) != 0)
{
while (Sql_NextRow(SqlHandle) == SQL_SUCCESS)
{
Charge_t* PCharge = new Charge_t;
PCharge->ID = Sql_GetUIntData(SqlHandle, 0);
PCharge->job = (JOBTYPE)Sql_GetUIntData(SqlHandle, 1);
PCharge->level = Sql_GetUIntData(SqlHandle, 2);
PCharge->maxCharges = Sql_GetUIntData(SqlHandle, 3);
PCharge->chargeTime = Sql_GetUIntData(SqlHandle, 4);
PCharge->merit = Sql_GetUIntData(SqlHandle, 5);
PChargesList.push_back(PCharge);
}
}
}
