AAC I upated my Website myacc, but have problem

[Joker Man]

hello everyone
Some one can help me to upated Script
characters.php-guilds.php-highscores.php-whoisonline.php <is Gosier
someone can upated for installation in myacc

 

[Joker Man]

bool IOLoginData::updateOnlineStatus(uint32_t guid, bool login)
{
Database* db = Database::getInstance();
DBQuery query;

uint16_t value = login;
if(g_config.getNumber(ConfigManager::ALLOW_CLONES))
{
query << "SELECT online FROM players WHERE id = " << guid << " AND deleted = 0 LIMIT 1";
DBResult_ptr result;
if(!(result = db->storeQuery(query.str())))
return false;

value = result->getDataInt("online");


if(login)
value++;
else if(value > 0)
value--;

query.str("");
}

query << "UPDATE players SET online = " << value << " WHERE id = " << guid << db->getUpdateLimiter();
return db->query(query.str());
}

 

[lursky]

Nice dateTime representation BTW I meant source code of your server

 

[Joker Man]

bool IOLoginData::updateOnlineStatus(uint32_t guid, bool login)
{
Database* db = Database::getInstance();
DBQuery query;

uint16_t value = login;
if(g_config.getNumber(ConfigManager::ALLOW_CLONES))
{
query << "SELECT online FROM players WHERE id = " << guid << " AND deleted = 0 LIMIT 1";
DBResult_ptr result;
if(!(result = db->storeQuery(query.str())))
return false;

value = result->getDataInt("online");


if(login)
value++;
else if(value > 0)
value--;

query.str("");
}

query << "UPDATE players SET online = " << value << " WHERE id = " << guid << db->getUpdateLimiter();
return db->query(query.str());
}

Post automatically merged: Mar 7, 2023

i contacted my partner and he gave me the source we used and i found that it only updates the online column View attachment 73992

 

[lursky]

Yea so you need to either create some trigger (don't like them) or rework AAC to utilize online column instead.
I never used myACC before so hard to tell, maybe there's already some option to configure that but anyway shouldn't be difficult to change that to:

SELECT COUNT(1) FROM `players` WHERE `online` > 0

EDIT: It already has such logic to check whether such table exists, so if you delete the table it should work fine:

$this->db->hasTable('players_online')

DROP TABLE `players_online`

 

[Joker Man]

Yea so you need to either create some trigger (don't like them) or rework AAC to utilize online column instead.
I never used myACC before so hard to tell, maybe there's already some option to configure that but anyway shouldn't be difficult to change that to:

SELECT COUNT(1) FROM `players` WHERE `online` > 0

EDIT: It already has such logic to check whether such table exists, so if you delete the table it should work fine:

$this->db->hasTable('players_online')

DROP TABLE `players_online`

so strange i tried to delete it couple of hours ago and an error occured but now it works !
Thank you