Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Small SQL command to fix 0's in inventory.(Doesn't Delete Stars)

Status
Not open for further replies.
Junior Spellweaver
Joined
Feb 24, 2008
Messages
175
Reaction score
3
Some people don't know how to do this so...

First run this
Code:
update inventoryitems
SET quantity = 1
where itemid = 2070006
and 2070005
and 2070016
and 2070004
and 2070007

Then run this,

Code:
delete from inventoryitems 
where quantity = 0;


Mainly for gm's or servers with !item command, if a gm or a player enters a wrong code for Use/Set-up/ETC/cash it bugs and this will fix it



Edit: Flame me all you want as far as I care Ive talked to server owners who don't know this.


Important Edit: I added the star fix, if you want to add stars feel free to I added the basic,

Ilbi
Cilbi
Tobi
Steely
Hwabi.

if you want to add more just add the line

and <staridhere>
 
Last edited:
Master Summoner
Joined
Apr 29, 2008
Messages
534
Reaction score
3
Re: Small SQL command to fix 0's in inventory.

Nice. xD
I was having a hard time deleting those 0's in my db lmao o.o
 
Initiate Mage
Joined
Jun 15, 2008
Messages
11
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

Nice release
 
Visit my hompage
Member
Joined
May 2, 2008
Messages
1,017
Reaction score
2
Re: Small SQL command to fix 0's in inventory.

very ncie release
 
Junior Spellweaver
Joined
Feb 24, 2008
Messages
175
Reaction score
3
Re: Small SQL command to fix 0's in inventory.

Thanks, just figured id help some people with that problem. Sorry I couldn't figure out an actual source fix.
 
Master Summoner
Member
Joined
Apr 20, 2008
Messages
578
Reaction score
76
Re: Small SQL command to fix 0's in inventory.

Yes, and stars at 0 quantity will get deleted too.
 
Initiate Mage
Joined
Jun 19, 2008
Messages
7
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

thnx alot

its cool

work 100%
 
Initiate Mage
Joined
Jun 5, 2008
Messages
82
Reaction score
3
Re: Small SQL command to fix 0's in inventory.

godly
 
Junior Spellweaver
Joined
Apr 6, 2008
Messages
140
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

That really helped me ty ^^
 
Junior Spellweaver
Joined
Feb 24, 2008
Messages
175
Reaction score
3
Re: Small SQL command to fix 0's in inventory.

No problem guys, RMZERO just tell your players to keep star quantity at 1? Idk better to fix one major bug and have only a minor problem occur.
 
Experienced Elementalist
Joined
Jun 8, 2008
Messages
275
Reaction score
4
Re: Small SQL command to fix 0's in inventory.

By using this, you will also being deleting peoples stars btw, just a little tip.
 
Banned
Banned
Joined
Jun 23, 2008
Messages
197
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

Then exclude the stars item codes?
 
Initiate Mage
Joined
Jul 14, 2008
Messages
25
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

:woot_jump: A lifesaver xD
You have my thanks for this magnificent release [=
 
Initiate Mage
Joined
Apr 21, 2008
Messages
73
Reaction score
0
Re: Small SQL command to fix 0's in inventory.

but if im wrong
it'll change all others players too :X
 
Junior Spellweaver
Joined
Feb 24, 2008
Messages
175
Reaction score
3
Re: [Release] Small SQL command to fix 0's in inventory.

Big deal? Just return the stars I will edit it later to change the id's of stars to 1
 
Initiate Mage
Joined
Dec 2, 2006
Messages
74
Reaction score
0
Re: [Release] Small SQL command to fix 0's in inventory.(now it keeps the stars!)

nice thanks for this release, but i think i deleted a lot of chars items lmao
 
Junior Spellweaver
Joined
Jul 12, 2008
Messages
105
Reaction score
0
Re: [Release] Small SQL command to fix 0's in inventory.(now it keeps the stars!)

aha yea this is a good release, my GM had like half of his inventory like this and he asked me to fix it i was like ... UHHH LOL YOU'RE FUNNY xD
 
Experienced Elementalist
Member
Joined
Apr 23, 2008
Messages
240
Reaction score
0
Re: [Release] Small SQL command to fix 0's in inventory.(now it keeps the stars!)

Lulz.. i have this problem alot on my server.

Don't use quantity. Use Inventorytype. Its alot easier.
I have a whole list of crap that people can do in a sql query that my website runs periodically.
Might release it when i get home.
 
Junior Spellweaver
Joined
Feb 24, 2008
Messages
175
Reaction score
3
Re: [Release] Small SQL command to fix 0's in inventory.(now it keeps the stars!)

Ok fixed stars.
 
Status
Not open for further replies.
Back
Top