
Originally Posted by
XiuzSu
Try removing item: 1812006.
Run this.
DELETE FROM inventoryitems WHERE itemid = 1812006;
DELETE FROM inventoryequipment WHERE inventoryitemid = 1812006;
5000033 - Black Dragon
5000048 - Baby Robo
5000049 - Blue Robo
5000050 - Red Robo
5000051 - Green Robo
5000052 - Gold Robo
5000053 - Gorilla Robo
Its some of these pets which also cause it I'm pretty sure, (I think its gold robo and black dragon.
Yeah I still had people not being able to log in after the fix... So I figured it was this.
So:
PHP Code:
/*Start of Robo pets and black dragon + Sensor*/
DELETE FROM inventoryitems WHERE itemid = 1812006;
DELETE FROM inventoryitems WHERE itemid = 5000033;
DELETE FROM inventoryitems WHERE itemid = 5000048;
DELETE FROM inventoryitems WHERE itemid = 5000049;
DELETE FROM inventoryitems WHERE itemid = 5000050;
DELETE FROM inventoryitems WHERE itemid = 5000051;
DELETE FROM inventoryitems WHERE itemid = 5000052;
DELETE FROM inventoryitems WHERE itemid = 5000053;
/*Start of Exp Cards*/
DELETE FROM inventoryitems WHERE itemid = 5211000;
DELETE FROM inventoryitems WHERE itemid = 5211001;
DELETE FROM inventoryitems WHERE itemid = 5211002;
DELETE FROM inventoryitems WHERE itemid = 5211003;
DELETE FROM inventoryitems WHERE itemid = 5211004;
DELETE FROM inventoryitems WHERE itemid = 5211005;
DELETE FROM inventoryitems WHERE itemid = 5211006;
DELETE FROM inventoryitems WHERE itemid = 5211007;
DELETE FROM inventoryitems WHERE itemid = 5211008;
DELETE FROM inventoryitems WHERE itemid = 5211009;
DELETE FROM inventoryitems WHERE itemid = 5211010;
DELETE FROM inventoryitems WHERE itemid = 5211011;
DELETE FROM inventoryitems WHERE itemid = 5211012;
DELETE FROM inventoryitems WHERE itemid = 5211013;
DELETE FROM inventoryitems WHERE itemid = 5211014;
DELETE FROM inventoryitems WHERE itemid = 5211015;
DELETE FROM inventoryitems WHERE itemid = 5211016;
DELETE FROM inventoryitems WHERE itemid = 5211017;
DELETE FROM inventoryitems WHERE itemid = 5211018;
DELETE FROM inventoryitems WHERE itemid = 5211019;
DELETE FROM inventoryitems WHERE itemid = 5211020;
DELETE FROM inventoryitems WHERE itemid = 5211021;
DELETE FROM inventoryitems WHERE itemid = 5211022;
DELETE FROM inventoryitems WHERE itemid = 5211023;
DELETE FROM inventoryitems WHERE itemid = 5211024;
DELETE FROM inventoryitems WHERE itemid = 5211025;
DELETE FROM inventoryitems WHERE itemid = 5211026;
DELETE FROM inventoryitems WHERE itemid = 5211027;
DELETE FROM inventoryitems WHERE itemid = 5211028;
DELETE FROM inventoryitems WHERE itemid = 5211029;
DELETE FROM inventoryitems WHERE itemid = 5211030;
DELETE FROM inventoryitems WHERE itemid = 5211031;
DELETE FROM inventoryitems WHERE itemid = 5211032;
DELETE FROM inventoryitems WHERE itemid = 5211033;
DELETE FROM inventoryitems WHERE itemid = 5211034;
DELETE FROM inventoryitems WHERE itemid = 5211035;
DELETE FROM inventoryitems WHERE itemid = 5211036;
DELETE FROM inventoryitems WHERE itemid = 5211037;
DELETE FROM inventoryitems WHERE itemid = 5211038;
DELETE FROM inventoryitems WHERE itemid = 5211039;
DELETE FROM inventoryitems WHERE itemid = 5211040;
DELETE FROM inventoryitems WHERE itemid = 5211041;
DELETE FROM inventoryitems WHERE itemid = 5211042;
DELETE FROM inventoryitems WHERE itemid = 5211043;
DELETE FROM inventoryitems WHERE itemid = 5211044;
DELETE FROM inventoryitems WHERE itemid = 5211045;
DELETE FROM inventoryitems WHERE itemid = 5211046;
DELETE FROM inventoryitems WHERE itemid = 5211047;
DELETE FROM inventoryitems WHERE itemid = 5211048;
DELETE FROM inventoryitems WHERE itemid = 5211049;
/*Start of drop cards*/
DELETE FROM inventoryitems WHERE itemid = 5360001;
DELETE FROM inventoryitems WHERE itemid = 5360002;
DELETE FROM inventoryitems WHERE itemid = 5360003;
DELETE FROM inventoryitems WHERE itemid = 5360004;
DELETE FROM inventoryitems WHERE itemid = 5360005;
DELETE FROM inventoryitems WHERE itemid = 5360006;
DELETE FROM inventoryitems WHERE itemid = 5360007;
DELETE FROM inventoryitems WHERE itemid = 5360008;
DELETE FROM inventoryitems WHERE itemid = 5360009;
DELETE FROM inventoryitems WHERE itemid = 5360010;
DELETE FROM inventoryitems WHERE itemid = 5360011;
DELETE FROM inventoryitems WHERE itemid = 5360012;
DELETE FROM inventoryitems WHERE itemid = 5360013;
DELETE FROM inventoryitems WHERE itemid = 5360014;
DELETE FROM inventoryitems WHERE itemid = 5360042;
Actually, even with the script above, there is still characters that are not able to log in.
So yeah, just deleting censor doesn't work...
Also, sometimes I get the .bat error, and sometimes the user just gets d/ced to the login screen, which doesn't produce a bat error
Actually, I think its 2x EXP cards too, I'm going to delete those and give it a shot.
Guys, I cannot figure it out!
I mean... This is all I find for banned cash shop items...
PHP Code:
if(item.getId() >= 5390000 && item.getId() <= 5390002){
c.getSession().write(MaplePacketCreator.enableActions());
c.getPlayer().dropMessage(1, "You may not purchase this item.");
return;
}
I got pissed so what I did was,
PHP Code:
SELECT * FROM inventoryitems where inventorytype = 5;
and then deleted everything in there (thats the cash inventory.)