Page 2 of 2

Re: weird bug bugged item table

Posted: Sat Dec 25, 2010 11:49 pm
by MELERIX
I guess is somebody with access to your DB, or a SQL injection through PHP website without proper security.

Re: weird bug bugged item table

Posted: Sun Dec 26, 2010 9:29 am
by JIV
exactly 10000 ? simple inject query :)

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 1:10 am
by filipehdbr
No.. I mean.. almost 100% of players just get their inventory bugged.. they get tons of "Wind potion (item ID: 1000)"

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 8:13 am
by JIV
yep, someone screwed sql inject or your fault

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 11:46 am
by filipehdbr
its not sql inject.. its some bug im 100% sure its not injection hehe.. at least not from the website

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 1:50 pm
by jurchiks
but of course, it's always easier to blame others :mrgreen:

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 7:32 pm
by filipehdbr
im not blaming.. when it happens again ill get more details.. im just 100% sure its not sql injection from the website

Re: weird bug bugged item table

Posted: Mon Dec 27, 2010 8:44 pm
by jurchiks
how can you be so sure? you don't have a website? or it doesn't connect to the server at all?

Re: weird bug bugged item table

Posted: Tue Dec 28, 2010 1:08 am
by JIV
inject doesnt have to be from your site, it can be acc manager or something. or it was your own fault or someone with db access.

Re: weird bug bugged item table

Posted: Tue Dec 28, 2010 2:01 pm
by filipehdbr
I checked website logs, including acc manager. There is no injection from them.. It happened again..

[27 Dec 22:00:16] CHANGE:Restore, item 268483802:Wind Potion(65699471), PrevCount(65699448), L2PcInstance:null[268483726]
[27 Dec 22:00:16] DELETE:Restore, item 268813790:Wind Potion(0), PrevCount(23), L2PcInstance:null[268483726]
[27 Dec 22:00:16] CHANGE:Restore, item 268483802:Wind Potion(65699473), PrevCount(65699471), L2PcInstance:null[268483726]
[27 Dec 22:00:16] DELETE:Restore, item 268631828:Wind Potion(0), PrevCount(2), L2PcInstance:null[268483726]
[27 Dec 22:00:16] CHANGE:Restore, item 268483802:Wind Potion(65699474), PrevCount(65699473), L2PcInstance:null[268483726]
[27 Dec 22:00:16] DELETE:Restore, item 270164054:Wind Potion(0), PrevCount(1), L2PcInstance:null[268483726]
[27 Dec 22:00:16] CHANGE:Restore, item 268483802:Wind Potion(65699475), PrevCount(65699474), L2PcInstance:null[268483726]
[27 Dec 22:00:16] DELETE:Restore, item 270636741:Wind Potion(0), PrevCount(1), L2PcInstance:null[268483726]
[27 Dec 22:00:16] CHANGE:Restore, item 268483802:Wind Potion(65699477), PrevCount(65699475), L2PcInstance:null[268483726]

Re: weird bug bugged item table

Posted: Tue Dec 28, 2010 2:31 pm
by blacksea
it can be an older version of mysql/php with some glitches also... wrong permission at some files, maybe some1 owned your box .. etc