weird bug bugged item table

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Re: weird bug bugged item table

Post by MELERIX »

I guess is somebody with access to your DB, or a SQL injection through PHP website without proper security.
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: weird bug bugged item table

Post by JIV »

exactly 10000 ? simple inject query :)
filipehdbr
Posts: 24
Joined: Thu Oct 21, 2010 9:45 pm

Re: weird bug bugged item table

Post by filipehdbr »

No.. I mean.. almost 100% of players just get their inventory bugged.. they get tons of "Wind potion (item ID: 1000)"
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: weird bug bugged item table

Post by JIV »

yep, someone screwed sql inject or your fault
filipehdbr
Posts: 24
Joined: Thu Oct 21, 2010 9:45 pm

Re: weird bug bugged item table

Post by filipehdbr »

its not sql inject.. its some bug im 100% sure its not injection hehe.. at least not from the website
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: weird bug bugged item table

Post by jurchiks »

but of course, it's always easier to blame others :mrgreen:
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
filipehdbr
Posts: 24
Joined: Thu Oct 21, 2010 9:45 pm

Re: weird bug bugged item table

Post by filipehdbr »

im not blaming.. when it happens again ill get more details.. im just 100% sure its not sql injection from the website
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: weird bug bugged item table

Post by jurchiks »

how can you be so sure? you don't have a website? or it doesn't connect to the server at all?
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: weird bug bugged item table

Post 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.
filipehdbr
Posts: 24
Joined: Thu Oct 21, 2010 9:45 pm

Re: weird bug bugged item table

Post 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]
blacksea
Posts: 458
Joined: Fri Oct 05, 2007 1:29 am

Re: weird bug bugged item table

Post 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
Post Reply