Can some scripter do this ?

[dgprado]

A creatureevent what execute this query every time that some player log out

update all his player_items attributes setting to null

update player_items set attributes = null where player_id = xxx*

* player what logged out.

 

[dgprado]

bump

 

[dgprado]

no way ?

;/

 

[dgprado]

well i try thx

 

[dgprado]

8...^(
snif snif


plaxxx xD

 

[Cykotitan]

do it in source, as onLogout is executed before player's items are saved to db

IOLoginData::savePlayer
[cpp] query_insert.setQuery("INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES ");[/cpp]
to
[cpp] query_insert.setQuery("INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`) VALUES ");[/cpp]
IOLoginData::saveItems
[cpp] buffer << player->getGUID() << ", " << it->first << ", " << runningId << ", " << item->getID() << ", "
<< (int32_t)item->getSubType() << ", " << db->escapeBlob(attributes, attributesSize).c_str();[/cpp]
to
[cpp] buffer << player->getGUID() << ", " << it->first << ", " << runningId << ", " << item->getID() << ", "
<< (int32_t)item->getSubType();[/cpp]