[FIX] XP Chocolate

[glossypvp]

Hi guys

There is a bug with XP chocholates, if you activate it, it will give a level up in every 10-20 seconds.
My SQL query is not a real solution, just a pernament while you're fixing it in service sources
I'm lazy to look at TCHARLEVELSET but you can write a simple fix if you have brain.exe

1. fix: it will set all character level to 90, that are bigger than 90, and remove buggy items from the database.

PHP Code:

UPDATE TGLOBAL_GSP.dbo.TALLCHARTABLE SET bLevel = 90 WHERE bLevel > 90
UPDATE TGAME_GSP.dbo.TCHARTABLE SET bLevel = 90 WHERE bLevel > 90
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7681
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7684
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7687 


It is a really simple fix, and isn't a real solution. You will have to look in the source to fully fix it, or simple don't use this item anymore. Remove it from the database with my SQL query

Give me a thanks if you think it's useful.
I gonna say the following for haters: yes, it's just a small thing, worth almost nothing but maybe some people will thinks it's useful.
I have more fixes, but I'm not dumb to release them there

[PinkySwag]

Or be like opora ,and have fixxed titemtable fully

[Yes@i]

Originally Posted by Rollien

Or be like opora ,and have fixxed titemtable fully

We are two, but then you do not have the services you ?

Originally Posted by glossypvp

Hi guys

There is a bug with XP chocholates, if you activate it, it will give a level up in every 10-20 seconds.
My SQL query is not a real solution, just a pernament while you're fixing it in service sources
I'm lazy to look at TCHARLEVELSET but you can write a simple fix if you have brain.exe

1. fix: it will set all character level to 90, that are bigger than 90, and remove buggy items from the database.

PHP Code:

UPDATE TGLOBAL_GSP.dbo.TALLCHARTABLE SET bLevel = 90 WHERE bLevel > 90
UPDATE TGAME_GSP.dbo.TCHARTABLE SET bLevel = 90 WHERE bLevel > 90
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7681
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7684
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7687 


It is a really simple fix, and isn't a real solution. You will have to look in the source to fully fix it, or simple don't use this item anymore. Remove it from the database with my SQL query

Give me a thanks if you think it's useful.
I gonna say the following for haters: yes, it's just a small thing, worth almost nothing but maybe some people will thinks it's useful.
I have more fixes, but I'm not dumb to release them there

Good job.

[Konst™]

Bro. WhatDaFuq is bugged at titemtable?

[Weom]

TITEMTABLE is not bugged .
btw. this is not a fix.

[randleman]

Originally Posted by glossypvp

Hi guys

There is a bug with XP chocholates, if you activate it, it will give a level up in every 10-20 seconds.
My SQL query is not a real solution, just a pernament while you're fixing it in service sources
I'm lazy to look at TCHARLEVELSET but you can write a simple fix if you have brain.exe

1. fix: it will set all character level to 90, that are bigger than 90, and remove buggy items from the database.

PHP Code:

UPDATE TGLOBAL_GSP.dbo.TALLCHARTABLE SET bLevel = 90 WHERE bLevel > 90
UPDATE TGAME_GSP.dbo.TCHARTABLE SET bLevel = 90 WHERE bLevel > 90
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7681
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7684
DELETE FROM TGAME_GSP.dbo.TITEMCHART WHERE wItemID = 7687 


It is a really simple fix, and isn't a real solution. You will have to look in the source to fully fix it, or simple don't use this item anymore. Remove it from the database with my SQL query

Give me a thanks if you think it's useful.
I gonna say the following for haters: yes, it's just a small thing, worth almost nothing but maybe some people will thinks it's useful.
I have more fixes, but I'm not dumb to release them there

A 'fix' by deleting an item???:what:

[glossypvp]

Well, XP chocholate is buggy. Executing that few lines of SQL query will delete buggy XP chocholates from the database, and reset buggy character levels to

I said it isn't a real fix. It's just some query that may be useful for others

Edit: Rollien maean TITEMCHART. Otherwise except eden4s and nexon, we're the only private sever that have 4.1 - 4.2 TITEMCHART.

[Konst™]

P4story? And its easy to add items in database. Just hard to lrt them show ingame

[glossypvp]

Forgot about p4story.
Yes Konst you're right, but it's not quite easy to find out item ids, names for beginners That's why only a few servers has it.