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!

[Release] Inventory glitch fix

Status
Not open for further replies.
Newbie Spellweaver
Joined
Aug 29, 2008
Messages
64
Reaction score
0
Code:
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:-
 
Newbie Spellweaver
Joined
Jul 29, 2008
Messages
26
Reaction score
0
1st yay~~~ i think this is helpful ty for realease :D
cause some of my players complain about that glitch
 
You've got my respect!
Joined
Apr 8, 2008
Messages
508
Reaction score
147
deletes all stars that have 0 quantity
 
You've got my respect!
Joined
Apr 8, 2008
Messages
508
Reaction score
147
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?
 
Mythic Archon
Loyal Member
Joined
Jul 23, 2008
Messages
796
Reaction score
56
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.
 
Mythic Archon
Loyal Member
Joined
Jul 23, 2008
Messages
796
Reaction score
56
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.
 
You've got my respect!
Joined
Apr 8, 2008
Messages
508
Reaction score
147
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:
Code:
DELETE FROM inventoryitems WHERE itemid > 2079999 AND itemid < 2070000 AND quantity = 0
 
Skilled Illusionist
Joined
May 12, 2008
Messages
321
Reaction score
0
why dont you do
Code:
 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
 
my milkshake.
Joined
Aug 23, 2008
Messages
230
Reaction score
10
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..
 
Junior Spellweaver
Joined
Jun 27, 2008
Messages
148
Reaction score
0
Code:
delete from inventoryitems where quantity = '0' and itemid >= '2070000' and itemid <= '2070016'
see wut i did dar.
 
Mythic Archon
Loyal Member
Joined
Jul 23, 2008
Messages
796
Reaction score
56
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:
Code:
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?
 
Elite Diviner
Loyal Member
Joined
Apr 30, 2008
Messages
414
Reaction score
0
Does this fix all those random unknow invisible items which you click on and d/c?
 
Elite Diviner
Joined
Apr 24, 2008
Messages
416
Reaction score
2
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
 
Isenheart .
Loyal Member
Joined
Jul 26, 2008
Messages
476
Reaction score
0
Can't belive all you guys know this coding thingy,
it's like impossible for me.
 
Junior Spellweaver
Joined
Apr 14, 2008
Messages
126
Reaction score
0
it just fixes it for a certain moment but not permanently fix..
 
Status
Not open for further replies.
Back
Top