[Guide]Converting cq_levexp to LevelExp.dat

[funhacker]

Hi guys, I'm going to show you how to convert your cq_levexp table into a compatible LevelExp.dat file for your client so that they match, this will prevent any of those annoying errors when your players are leveling it says "300.87%" exp. This is because your levelexp.dat doesn't match the server setup.

So first things you'll need:

• 
  • 
  • 
  • 
  • 
  • 
• 
  • 

Be sure to download each part in order, and extract each patch for the "Data Converter" in the order you download them, this is VERY important.

Ok now you have the applications you need.

Goto your directory that has the Data Converter in it. In here you need to locate the file named "LevexpConfig.ini" see image below:



Open the file and be sure the values highlighted in the below image are correct for your database.



Once that's done, click and drag the LevexpConfig.ini onto the ConvertData.exe like in the image below



Due to the speed of conversion, and size of my levexp table it runs so fast that it doesn't have time to accurately calculate the speed it's writing at, your's may be different, but see the image below to see what it looks like during conversion:



Once the conversion is complete you will see the following window



Hit any key to close the window. Although displayed in the previous window you can locate where the converted file is by opening the config again, note the highlighted text in the image



This highlighted text tells us that the new file will be in the output folder of where the convertdata.exe is (not where the levexpConfig.ini is as this can be anywhere, current_directory refers to where the .exe file is)

Locate the file like below



Copy the file by right-click -> copy or Ctrl+C

Now locate the File Encryptor application you downloaded, and locate the LevexpConfig.ini in the folder like so:



Open the config and note the highlighted value below, this is where you must have the file to encrypt,



you can change it so that it matches where you output your converted file or just copy to the location it says, I decided to just copy it to the location it says like so:



So now you have your converted levelexp.dat file in the correct location, click and drag the LevexpConfig.ini onto the FileEncryptorC.exe like so:



Again this process can be fast and can be slow, it depends on the size of the file and the encryption process, for now it may be slow as this is just a first build. You will see a window like so:



Once the process is finished you will see the following:



Just hit any key and it will close the application.
From here you now need to find out where the file is going to, so open the LevexpConfig.ini in the file encryptor folder again. Note the highlighted text is where the file exports to when encrypted



You can change this to be the same as your client's ini folder to just replace your client's existing levelexp.dat but you have to make sure nothing is accessing the file when encrypting or it will fail. So just locate the file like I have here:



Copy it and paste it into your client or patch and you're done!

Enjoy guys

[no_1]

for some reason its not converting the unencrypted file when i drag levelxpConfig.ini into the convertdate.exe it will immediatly say conversion complete but there is no output file.

[funhacker]

Originally Posted by no_1

for some reason its not converting the unencrypted file when i drag levelxpConfig.ini into the convertdate.exe it will immediatly say conversion complete but there is no output file.

there is most likely something wrong with your mysql setup, did you make sure that the username/password/host/database are all correct?

[magewarior2]

However! I think there is a Little error ...


i had put the max level to level "4"

i am level 1 and it already say "congrats.. highest level" ....

Originally Posted by no_1

for some reason its not converting the unencrypted file when i drag levelxpConfig.ini into the convertdate.exe it will immediatly say conversion complete but there is no output file.

your file is like this

LevexpConfig.ini

[Main]
MySQLLogin=test
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=ACME
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

You must change it like this. (login / password may be not correct!)

LevexpConfig.ini

[Main]
MySQLLogin=[COLOR="Red"]root[/COLOR] 
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=[COLOR="red"]my[/COLOR] 
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

[funhacker]

Originally Posted by magewarior2

However! I think there is a Little error ...


i had put the max level to level "4"

i am level 1 and it already say "congrats.. highest level" ....





your file is like this

LevexpConfig.ini

[Main]
MySQLLogin=test
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=ACME
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

You must change it like this. (login / password may be not correct!)

LevexpConfig.ini

[Main]
MySQLLogin=[COLOR="Red"]root[/COLOR] 
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=[COLOR="red"]my[/COLOR] 
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

You must have type 0 with level 1/2/3/4 for it to be correct, the max level in the cq_config is irrelevant with the client.

Originally Posted by magewarior2

However! I think there is a Little error ...


i had put the max level to level "4"

i am level 1 and it already say "congrats.. highest level" ....





your file is like this

LevexpConfig.ini

[Main]
MySQLLogin=test
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=ACME
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

You must change it like this. (login / password may be not correct!)

LevexpConfig.ini

[Main]
MySQLLogin=[COLOR="Red"]root[/COLOR] 
MySQLPassword=test
MySQLHost=localhost
MySQLDatabase=[COLOR="red"]my[/COLOR] 
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

You must have type 0 with level 1/2/3/4 for it to be correct, the max level in the cq_config is irrelevant with the client.

[magewarior2]

i have type 0, type 4 and type 5 (of each level)

[funhacker]

Originally Posted by magewarior2

i have type 0, type 4 and type 5 (of each level)

you mean it says highest level on your eudemons?
It seems that if there isn't a subsequent type one after another it can screw the file up, I guess you need to setup for type 0/1/2 ?

[magewarior2]

Originally Posted by funhacker

you mean it says highest level on your eudemons?
It seems that if there isn't a subsequent type one after another it can screw the file up, I guess you need to setup for type 0/1/2 ?

Ok, problem fixed. I`ve found the problem, my LevexpConfig.ini was not working correct.

HOWEVER.... it works till level 17 ... on level 17 it says "congrats....."

maybe you can find something that ain't okay.

levexpconfig.ini:

[Main]
MySQLLogin=root
MySQLPassword=test
MySQLHost=127.0.0.1
MySQLDatabase=my
SourceFileName=%current_directory/SourceFiles/LevexpSource.ini
StructureText=%current_directory/StructureFiles/LevexpStructure.txt
ExpectedFileSize=EntryCount/c|*|32|+|4
OutputFileName=%current_directory/Output/Levelexp.dat

LevexpSource.ini:

 Spoiler

[Level]
Type=MySQLQuery
Update=None
String=select level from cq_levexp order by id ASC;

[UserExp]
Type=MySQLQuery
Update=None
String=select UsrUpLevExp from cq_levexp order by id ASC;

[ExpType]
Type=MySQLQuery
Update=None
String=select type from cq_levexp order by id ASC;

[UpLevTime]
Type=MySQLQuery
Update=None
String=select UpLevTime from cq_levexp order by id ASC;

[EntryCount]
Type=SourceValue
Update=None
String=Level|Count

LevexpStructure.txt

 Spoiler

uint@[EntryCount/n]|1|1
uint@[Level/n]|1,uint@0|1,ulong@[UserExp/n]|1,uint@[ExpType/n]|1,uint@0|1,uint@[UpLevTime/n]|1,uint@0|1|[EntryCount/c]

Encryptor

LevexpConfig.ini:

[Main]
StartIndex=4
EncryptionArray=A1FFFFFF00000000A1FFFFFFFFFFFFFFA1FFFFFFA1FFFFFFA1FFFFFF00000000EFFFFFFF00000000EFFFFFFFFFFFFFFFEFFFFFFFEFFFFFFFEFFFFFFF00000000BEFFFFFF00000000BEFFFFFFFFFFFFFFBEFFFFFFBEFFFFFFBEFFFFFF00000000CDFFFFFF00000000CDFFFFFFFFFFFFFFCDFFFFFFCDFFFFFFCDFFFFFF00000000D5FFFFFF00000000D5FFFFFFFFFFFFFFD5FFFFFFD5FFFFFFD5FFFFFF00000000E2FFFFFF00000000E2FFFFFFFFFFFFFFE2FFFFFFE2FFFFFFE2FFFFFF00000000D1FFFFFF00000000D1FFFFFFFFFFFFFFD1FFFFFFD1FFFFFFD1FFFFFF00000000F9FFFFFF00000000F9FFFFFFFFFFFFFFF9FFFFFFF9FFFFFFF9FFFFFF00000000B1FFFFFF00000000B1FFFFFFFFFFFFFFB1FFFFFFB1FFFFFFB1FFFFFF00000000BBFFFFFF00000000BBFFFFFFFFFFFFFFBBFFFFFFBBFFFFFFBBFFFFFF00000000C4FFFFFF00000000C4FFFFFFFFFFFFFFC4FFFFFFC4FFFFFFC4FFFFFF00000000E3FFFFFF00000000E3FFFFFFFFFFFFFFE3FFFFFFE3FFFFFFE3FFFFFF00000000D5FFFFFF00000000D5FFFFFFFFFFFFFFD5FFFFFFD5FFFFFFD5FFFFFF00000000F4FFFFFF00000000F4FFFFFFFFFFFFFFF4FFFFFFF4FFFFFFF4FFFFFF00000000CAFFFFFF00000000CAFFFFFFFFFFFFFFCAFFFFFFCAFFFFFFCAFFFFFF00000000ECFFFFFF00000000ECFFFFFFFFFFFFFFECFFFFFFECFFFFFFECFFFFFF00000000
FileToEncrypt=%current_directory/Levelexp.dat
OutputFileName=%current_directory/Output/Levelexp.dat

See any problem?

Thank you.

[PowerChaos]

is it maybe possible to upload the file`s you use?
cus I`m having the same problem... :s

[magewarior2]

Ok, what i found...

LevelExp.dat (level 137) TQ version is 17,0 KB big (and works fine)
LevelExp.dat (level 137) Funhackers version is 17,1 KB big (does not work at all)

however if i remove the "Length=4" of the LevexpConfig.ini it works in game till level 17...

also if you open the 2 fille`s they look totally diffrents from each other... maybe you can find the error? :s

[mysteryho]

Originally Posted by no_1

for some reason its not converting the unencrypted file when i drag levelxpConfig.ini into the convertdate.exe it will immediatly say conversion complete but there is no output file.

is this furom still active???
i got the same problem as your's, did u able to solve it??
if yes..can tell me how did u fix it??

[magewarior2]

if it immediatly saus "convertion complete" the file is not converted.


it needs to look like this.

[mysteryho]

i have configures the settings in levelxpconfig.ini same as your settings...
but when i started to convert it,the only text that shows is "convertion complete"
i have the same problem as "no_1"

[zukoo]

I know it is already two years of this post, but wanted to know if someone already managed to solve this?

[magewarior2]

Still not working for me...