Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Conquer Online 2 > CO2 Private Server > CO2 PServer Guides & Releases
You last visited: Today at 21:47

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] MySql Converter (Items & Mobs)

Discussion on [Release] MySql Converter (Items & Mobs) within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.

Reply
 
Old   #1
 
Ultimatum's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 277
Received Thanks: 52
[Release] MySql Converter (Items & Mobs)

Items -> MySqlConvert.rar
--------------------------------
This will convert the itemdata file to a MySql table

Its a bit old but thought i would release it. Might come in handy, just a basic tool.

If you want the source just pm me or decompile the exe. Also got one for monsters.

Database connection -> Config.ini
Drag the itemtype.dat from client folder/ini onto the exe to begin initialization

Monsters -> MobConvert.rar
-----------------------
Now the problem with this is Monster.ini doesn't have enough info for a monster table therefore what this does is. Redo the monster.ini, using that it translates the cq monster table and transfers them to w/e database you define in the connection info. Btw it auto connects to database cq. Also to begin initialization put the monster.ini from (Client Folder/ini) into the applications directory and run the exe.

Both sources will be available via pm, i might put the links to them on here if i get time.

CQ Table is included if anyone needs it.
Attached Files
File Type: rar MySqlConvert.rar (165.0 KB, 170 views)
File Type: rar MobConvert.rar (175.4 KB, 86 views)
File Type: rar CQ 20090724 2311.rar (811.5 KB, 90 views)
Ultimatum is offline  
Thanks
6 Users
Old 07/24/2009, 23:43   #2
 
© Haydz's Avatar
 
elite*gold: 20
Join Date: Jan 2008
Posts: 1,042
Received Thanks: 252
Shall i do one for the item plus data? Or no?
© Haydz is offline  
Old 07/24/2009, 23:53   #3
 
Ultimatum's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 277
Received Thanks: 52
Sure, making the mob one from scratch again. Other was full of unused code lol

#Bump Updated

#merged by emme
Ultimatum is offline  
Old 07/25/2009, 21:04   #4
 
elite*gold: 0
Join Date: Nov 2008
Posts: 108
Received Thanks: 4
Quote:
Originally Posted by Ultimatum View Post
#Bump Updated
omg i r <3 u 4 this lol
WTFoRK is offline  
Old 07/26/2009, 03:12   #5
 
elite*gold: 0
Join Date: May 2009
Posts: 874
Received Thanks: 174
hope you dont mind me asking
what is the use for this?
Arcotemple:) is offline  
Old 07/26/2009, 13:56   #6
 
elite*gold: 20
Join Date: Aug 2005
Posts: 1,734
Received Thanks: 1,000
Quote:
This will convert the itemdata file to a MySql table
I _think_ that he means the itemtype.dat.
tanelipe is offline  
Old 07/26/2009, 14:05   #7
 
_Emme_'s Avatar
 
elite*gold: 1142
Join Date: Aug 2006
Posts: 2,464
Received Thanks: 1,161
#Changed title.
_Emme_ is offline  
Old 07/26/2009, 16:49   #8
 
Ultimatum's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 277
Received Thanks: 52
Quote:
Originally Posted by Arcotemple:) View Post
hope you dont mind me asking
what is the use for this?
Ye i think tane just pointed that out. I use it to update my database tables whenever TQ do an update on the itemtype.dat. As for the monster one. I forgot to add the function to decrypt the monster.dat so for now it might be best to use the dat crypter atm.
Quote:
Originally Posted by EmmeTheCoder View Post
#Changed title.
Thanks for merging the posts. First time i double posted . And the title, tried changing it and it wouldn't update lol.
Ultimatum is offline  
Old 07/30/2009, 12:40   #9

 
Kiyono's Avatar
 
elite*gold: 20
Join Date: Jun 2006
Posts: 3,296
Received Thanks: 924
It doesn't seem to update my cq_itemtype though =/

Just says:
Code:
Deleting table: Items
Error blabla stopped working etc.
Kiyono is offline  
Old 07/30/2009, 17:25   #10
 
Ultimatum's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 277
Received Thanks: 52
Well normally it would make a database table called 'items'. You would also need the source to change some of the column names. Pm me your msn and ill help you.
Ultimatum is offline  
Old 07/30/2009, 17:27   #11

 
Kiyono's Avatar
 
elite*gold: 20
Join Date: Jun 2006
Posts: 3,296
Received Thanks: 924
I'm pretty sure that I already have you on MSN.
Kiyono is offline  
Reply


Similar Threads Similar Threads
.dat & .bin -> MySQL Converter
03/11/2014 - Florensia - 45 Replies
Heya! In the pak files you will find .dat and .bin files containing mostly string data and monster data.. I will now provide you with two tools of mine that can convert these files into MySQL queries.. I used this technique to create an online monster and item database I'm running locally Download: Bin2Sql Bin2Sql (Mirror RS.com) Dat2Sql Dat2Sql (Mirror RS.com)
[How To]Items oder Mobs ohne Value erschaffen / Vereinfacht Mobs oder Items rufen
05/26/2010 - Metin2 PServer Guides & Strategies - 29 Replies
(Ich habe per SuFu nichts gefunden & es ist mir selbst ziemlich neu) Hay, ich möchte euch heute zeigen wie ihr euch Items oder Mobs erschaffen könnt, Ohne die ID oder die ID's dafür zu kennen. ___________________________
[RELEASE] DDS converter
08/18/2009 - EO PServer Guides & Releases - 9 Replies
Well, because this is a tool, i post it here and not on another section :bandit: People were complaining they cant open or edit a dds file.. This tool, can convert the dds file to jpg,png,bmp,tga and it can convert "to" dds :handsdown:



All times are GMT +2. The time now is 21:47.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.