- Joined
- Jul 11, 2008
- Messages
- 322
- Reaction score
- 1
Alright; Currently I have no problem; When I click Nana(K) I don't DC; How ever; if you click on Nana(K) And disconnect; There are 2 probable causes;
1: You have 2 Shops with Nana as the seller;
2: You executed two SQL files with Nana(K) As the seller NPC;
Not sure;
But here is a little way to fix it;
Goto your Navicat/MySQL Query Browser; Goto your shops table; Hit search (Or CTRL+F), Then type in 9201023 (Nana(K)'s NPC ID);
If any results turn up; Delete the row; And it may fix your Nana(K) From disconnecting you;
credits to xxcandycxx for rewritiing
for those whose character are stucked in character page, run this query :
for those whose id already login, run this :
Update accounts
SET loggedin = 0
for those whose items and skills disappeared, run this :
DELETE FROM `inventoryitems` WHERE `itemid` >= 1812000 AND `itemid` <= 1812010
and
DELETE FROM `inventoryitems` WHERE `itemid` >= 1802000 AND `itemid` <= 1802050
1: You have 2 Shops with Nana as the seller;
2: You executed two SQL files with Nana(K) As the seller NPC;
Not sure;
But here is a little way to fix it;
Goto your Navicat/MySQL Query Browser; Goto your shops table; Hit search (Or CTRL+F), Then type in 9201023 (Nana(K)'s NPC ID);
If any results turn up; Delete the row; And it may fix your Nana(K) From disconnecting you;
credits to xxcandycxx for rewritiing
for those whose character are stucked in character page, run this query :
for those whose id already login, run this :
Update accounts
SET loggedin = 0
for those whose items and skills disappeared, run this :
DELETE FROM `inventoryitems` WHERE `itemid` >= 1812000 AND `itemid` <= 1812010
and
DELETE FROM `inventoryitems` WHERE `itemid` >= 1802000 AND `itemid` <= 1802050
Last edited: