[Release] Inventory glitch fix

[desert123100]

delete from `inventoryitems` where quantity=0

This is the fix for the 0's in ur inventory. run that in ur mysql. make sure ur logged off!!

my first release

dont flame mee i know this is simple but sum ppl dont know about it o:

-super flame shield on :2gunsfiring_v1:-

 

[2345]

1st yay~~~ i think this is helpful ty for realease
cause some of my players complain about that glitch

 

[Traitor]

deletes all stars that have 0 quantity

 

[desert123100]

deletes all stars that have 0 quantity

tell them to recharge there stars P:<

 

[Traitor]

tell them to recharge there stars P:<

And what if you have 5000 people on your server, with 1/5 of them having (a) throwing star(s), and with that 1/5, 1/4 of them have a star that has 0 stars.
That's 250 people. Try telling 250 people, individually or all of them at once, giving them a 5 day notice.
So what's easier? Editing this SQL script to not delete stars, or doing the above?

 

[Moogra]

And what if you have 5000 people on your server, with 1/5 having a throwing star, and with that 1/5, 1/4 of those have a star that has 0 stars.
That's 250 people. Try telling 250 people, individually or all of them at once, giving them a 5 day notice.
So what's easier? Editing this SQL script to not delete stars, or doing the above?

Wow just update their stars to max then, using another SQL command. Don't be an idiot.

 

[Traitor]

Wow just update their stars to max then, using another SQL command. Don't be an idiot.

All stars have different maxes.

 

[Moogra]

Are you trying to be funny? Just set them to 1.

update inventoryitems SET quantity = 1 where itemid = 2070006
and 2070005
and 2070016
and 2070004
and 2070007

And what if you have 5000 people on your server, with 1/5 having a throwing star, and with that 1/5, 1/4 of those have a star that has 0 stars.

Ok so you have 5000 people. Your next sentence implies that 1/5 of a person has a throwing star. Oh and then 1/4 of that person has a star that has 0 stars. So 1/20 of a person has a throwing star (meaning 1) that has 0 stars. So explain how you have a part of a person and how 0=1.

 

[Shadow26]

Its nice that your trying to help. Another thread has been made like this before though except this one has a ton of sqls that do a ton of different things:
http://forum.ragezone.com/showthread.php?t=436649

 

[Traitor]

Are you trying to be funny? Just set them to 1.

No I am not trying to be funny.

Ok so you have 5000 people. Your next sentence implies that 1/5 of a person has a throwing star. Oh and then 1/4 of that person has a star that has 0 stars. So 1/20 of a person has a throwing star (meaning 1) that has 0 stars. So explain how you have a part of a person and how 0=1.

"of a person". No where did I mention that.
Also stars can have 0 quantities.

5000 people on your server, with 1/5 having a throwing star

I guess I should have put "with 1/5 of them...".
also:

DELETE FROM inventoryitems WHERE itemid > 2079999 AND itemid < 2070000 AND quantity = 0

 

[xkush]

why dont you do

 delete from inventoryitems where characterid = 3000 and quantity = 0

something along those lines it may not work i just totally bs'd that
change 3000 to the char id of the character

 

[Frozurad]

Are you trying to be funny? Just set them to 1.

update inventoryitems SET quantity = 1 where itemid = 2070006
and 2070005
and 2070016
and 2070004
and 2070007




Ok so you have 5000 people. Your next sentence implies that 1/5 of a person has a throwing star. Oh and then 1/4 of that person has a star that has 0 stars. So 1/20 of a person has a throwing star (meaning 1) that has 0 stars. So explain how you have a part of a person and how 0=1.

i lol'ed so badly.. lol..

 

[xV1ral]

delete from inventoryitems where quantity = '0' and itemid >= '2070000' and itemid <= '2070016'

see wut i did dar.

 

[Moogra]

No I am not trying to be funny.

"of a person". No where did I mention that.
Also stars can have 0 quantities.

I guess I should have put "with 1/5 of them...".
also:

DELETE FROM inventoryitems WHERE itemid > 2079999 AND itemid < 2070000 AND quantity = 0

I meant your sentence structure implied. There's such thing as misplaced modifiers and dangling modifiers you know?

 

[YaNdAoGM]

this has been released b4 i seen this b4 here

 

[Ridiculous]

Does this fix all those random unknow invisible items which you click on and d/c?

 

[YaNdAoGM]

yeah this is a invalid item glitch maybe some1 will invent a better !item command to check whether the item exist i will be tryin 2 do so xD

 

[shajal]

not bad i like it. thnx

 

[Leimone]

Can't belive all you guys know this coding thingy,
it's like impossible for me.

 

[PoopStory]

it just fixes it for a certain moment but not permanently fix..