Making ALL Pet Stuff COMPLETELY Un-Achievable!!! *FIXED+TESTED*

[xReflex]

Ok,
So I basicaly wrote this down for my self because sometimes the website is buggy and can't remove pet equipment so I just run some commands,
And also because some idiots just keep buying them from the stores or cash shop.

So, here is a guide that teaches you how to remove ALL pet equipments, from CS/shops/inventory EVERYTHING

THERE ARE JUST 2 STEPS, ITS EZPZ SO LETS GO!

# Step 1 : blocking ALL of the bugging Pet stuff from cash shop (btw I learned how to do that of iGoofy's guide so credits to him on Step 1!)

# Step 2 : MySQL, removing ALL of the bugging Pet stuff from EVERYONE's Inventory's & from ALL shops!

Step 1 (iGoofy):
Open up BuyCSItemHandler.java , which can found in /src/net/sf/odinms/net/channel/handler

Under (Just incase you've never blocked CS items like this) *YOU DON'T HAVE TO DO THIS UNLESS ITS NOT WORKING WITHOUT IT!*

private final static Logger log = LoggerFactory.getLogger(MapleServerHandler.class

Place

private final static int[] blockedItems = {1};

And Under

CashItemInfo item = CashItemFactory.getItem(snCS);

And Above

        if (!c.getPlayer().inCS() || c.getPlayer().getCSPoints(way) < 0 || c.getPlayer().getCSPoints(way) < item.getPrice()) {

Place

                if (item.getId() >= 5211000 && item.getId() <= 5211048 || item.getId() >= 1112000 && item.getId() <= 1112904 || item.getId() == 5040000 || item.getId() == 5041000 || item.getId() >= 1812002 && item.getId() <= 1812005 || item.getId() >= 1802000 && item.getId() <= 1802037 || item.getId() >= 1812000 && item.getId() <= 1812006 || item.getId() == 1802100) {
                    c.getPlayer().getClient().getSession().write(MaplePacketCreator.serverNotice(1, "You may not purchase this item."));
                    c.getSession().write(MaplePacketCreator.showNXMapleTokens(c.getPlayer()));
                    c.getSession().write(MaplePacketCreator.enableCSUse1());
                    c.getSession().write(MaplePacketCreator.enableCSUse2());
                    c.getSession().write(MaplePacketCreator.enableCSUse3());
                    return;
                }

Save & Compile !

Step 2 :
Ok, I wrote this Execute code for MySQL its quite long by very easy to use :]

1. Open up your MySQL (I'm using MySQL 2005 Query Browser) login to your database obviously..
2. Paste the following code in the Execute text box, and run both of the lines!

Run this :

DELETE FROM shopitems WHERE itemid = '1802022' || itemid = '1802027' || itemid = '1802003' || itemid = '1802006' || itemid = '1802025' || itemid = '1802012' || itemid = '1802018' || itemid = '1802031' || itemid = '1802033' || itemid = '1802015' || itemid = '1802021' || itemid = '1802028' || itemid = '1802036' || itemid = '1802016' || itemid = '1802035' || itemid = '1802014' || itemid = '1802017' || itemid = '1802010' || itemid = '1802037' || itemid = '1802023' || itemid = '1802030' || itemid = '1802100' || itemid = '1802029' || itemid = '1802004' || itemid = '1802026' || itemid = '1802011' || itemid = '1802002' || itemid = '1802000' || itemid = '1802013' || itemid = '1802007' || itemid = '1802008' || itemid = '1802019' || itemid = '1802005' || itemid = '1802032' || itemid = '1802009' || itemid = '1802034' || itemid = '1802020' || itemid = '1802024' || itemid = '1802001' || itemid = '1812002' || itemid = '1812003' || itemid = '1812005' || itemid = '1812001' || itemid = '1812006' || itemid = '1812000' || itemid = '1812004'; 

And then this :

DELETE FROM inventoryitems WHERE itemid = '1802022' || itemid = '1802027' || itemid = '1802003' || itemid = '1802006' || itemid = '1802025' || itemid = '1802012' || itemid = '1802018' || itemid = '1802031' || itemid = '1802033' || itemid = '1802015' || itemid = '1802021' || itemid = '1802028' || itemid = '1802036' || itemid = '1802016' || itemid = '1802035' || itemid = '1802014' || itemid = '1802017' || itemid = '1802010' || itemid = '1802037' || itemid = '1802023' || itemid = '1802030' || itemid = '1802100' || itemid = '1802029' || itemid = '1802004' || itemid = '1802026' || itemid = '1802011' || itemid = '1802002' || itemid = '1802000' || itemid = '1802013' || itemid = '1802007' || itemid = '1802008' || itemid = '1802019' || itemid = '1802005' || itemid = '1802032' || itemid = '1802009' || itemid = '1802034' || itemid = '1802020' || itemid = '1802024' || itemid = '1802001' || itemid = '1812002' || itemid = '1812003' || itemid = '1812005' || itemid = '1812001' || itemid = '1812006' || itemid = '1812000' || itemid = '1812004'; 

AND WALLA! You're done :]
All pet equips cannot be purchased on the cash shop, cannot be bought on ANY shop, and nobody has it in their inventory :]

IF ANYBODY NEEDS HELP/SOMETHING DIDN'T WORK OUT POST YOUR PROBLEM :)!

I Wrote this guide, so credits to me please if you're goin to leech/copy <3!
Don't forget to give iGoofy the credits for Step 1, ty !

[MentaL]

[makeutus]

That script blocks all the items from bought
-nice guide-

[Kars]

Didn't test, but if it works, nice.

[kippieeej]

Will not work
DELETE FROM shopitems WHERE itemid = 1802022 and 1802027 and 1802003 and 1802006

comon, this will only delete the items if the itemid is bla and bla and bla and bla
an itemid can only have 1 value

[XxOsirisxX]

so this is basiaclly a re-release of iGoofy thread./

EDIT:

So true Bassoe.

DELETE FROM shopitems WHERE itemid = '1802022' || '1802027' || '1802003' || '1802006'; 

[ZeroCold]

Any way it's nice and basic.

[watzmename]

Yeah, basically a re-release...

[kippieeej]

DELETE FROM shopitems WHERE itemid = 1802022 or 1802027 or 1802003 or 1802006; 

i think this will work too

oh wait.

DELETE FROM shopitems WHERE itemid = 1802022 OR itemid = 1802027 

and so on

[Ehab]

are pets still buggy? doesnt seem like that for me

[Riileyy]

Is this v62? because that first part isn't in my BuyCSItemHandler.java

[xReflex]

*FIXED The Execute Command for MySQL..!*
yes Riileyy it is v62, and you don't have to do the first command, I said that.

[xAuthorityx]

cool. testing now.

[MSDartz]

Pretty nice release, I guess.

[legendxzero3]

Same here Nice release I might use it later when i get more people