Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting > EO PServer Guides & Releases
You last visited: Today at 22:31

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


[Release]Extract Itemtype Description (SQL Builder)

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
[Release]Extract Itemtype Description (SQL Builder)

linja, pointed out that using my new table converter has one major issue, and that's putting in all the descriptions of the items into the description field of cq_itemtype.

So here is an app that will build an sql file for you.
Just download/extract and then place your itemtype.dat in the same directory, run the exe and it will create a file "UpdateDescription.txt" copy all the text from this text file and paste in your mysql console then hit enter.
This will take a while (depending on the amount of items you have) to execute the script. So be patient and enjoy.

Thanks,
funhacker

please note that this app was a quick 5minute slap together, so there is no GUI no error handling of any kind, it will purely crash if you don't follow the instructions exactly as said.
Itemtype.dat must MATCH that EXACT name...


Update:
Application.rar now has a new application that will log any duplicate IDs and their locations if found.
Application[NoErrorHandling].rar has a new application that will ignore any duplicate ids and just create an SQL file. However it isn't advised, as your itemtype.dat is clearly bugged.
Attached Files
File Type: rar Application.rar (6.3 KB, 103 views)
File Type: rar Application[NoErrorHandling].rar (6.0 KB, 94 views)



funhacker is offline  
Thanks
12 Users
Old 04/05/2012, 06:07   #2
 
elite*gold: 0
Join Date: Dec 2009
Posts: 211
Received Thanks: 11
WEll Done.You Make Great Release Man!.

My Problem Now Is.. When I run. the program close and not running well. Mybe My PC problem about
netframework.Any Link to fix this?


linja12 is offline  
Old 04/05/2012, 09:39   #3
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
Quote:
Originally Posted by linja12 View Post
WEll Done.You Make Great Release Man!.

My Problem Now Is.. When I run. the program close and not running well. Mybe My PC problem about
netframework.Any Link to fix this?
Is there a text file named "UpdateDescription.txt" now when the app closed?
funhacker is offline  
Thanks
1 User
Old 04/05/2012, 09:55   #4
 
elite*gold: 0
Join Date: Dec 2009
Posts: 211
Received Thanks: 11
no Updatedescription.txt not appear. when I click app. after 5 sec it close.. when run as administrator. its appear ---> unable to find a version of the runtime to run this application.


linja12 is offline  
Old 04/06/2012, 06:56   #5
 
elite*gold: 0
Join Date: Sep 2009
Posts: 188
Received Thanks: 63
me too... when i run it no txt found.
haizamlee is offline  
Old 04/06/2012, 10:53   #6
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
Sorry for the late reply, my net isn't the best at the moment.

I've made changes, both your problems (I assume) are that your itemtype.dat has duplicate IDs which can be quite a problem.

If you download the Application[No Error Handling].rar and this still does not work. Please use the new Application.rar and post the log file for me to view.

Thanks




Update:
Application.rar now has a new application that will log any duplicate IDs and their locations if found.
Application[NoErrorHandling].rar has a new application that will ignore any duplicate ids and just create an SQL file. However it isn't advised, as your itemtype.dat is clearly bugged.
funhacker is offline  
Thanks
1 User
Old 04/06/2012, 12:21   #7
 
elite*gold: 0
Join Date: Dec 2009
Posts: 211
Received Thanks: 11
100% Perfect!. TQ force.

[Request] Force, can You make another APP itemtype.dat convert to cq_itemtype querry?
linja12 is offline  
Old 04/06/2012, 14:49   #8
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
Quote:
Originally Posted by linja12 View Post
100% Perfect!. TQ force.

[Request] Force, can You make another APP itemtype.dat convert to cq_itemtype querry?
Sure will do at a latter date.
But you're confusing me with 'forcer' I'm 'funhacker'
funhacker is offline  
Old 05/30/2017, 05:14   #9
 
elite*gold: 0
Join Date: Jun 2008
Posts: 44
Received Thanks: 3
Quote:
Originally Posted by funhacker View Post
Sure will do at a latter date.
But you're confusing me with 'forcer' I'm 'funhacker'

Any update for this apps.? thanks in advance.
emogoth213 is offline  
Old 05/30/2017, 11:34   #10
 
elite*gold: 0
Join Date: Jun 2008
Posts: 44
Received Thanks: 3
@
itemtype.dat convert to cq_itemtype querry? cant find it i search using google.
emogoth213 is offline  
Old 05/31/2017, 12:30   #11
 
elite*gold: 0
Join Date: Dec 2009
Posts: 156
Received Thanks: 9
WELL DONE


reloaded90 is offline  
Reply



« [RELEASE] New Cronus BOOTH Locations | [RELEASE] CHANGING YOUR EUDEMON COMPOSE RATE USING QUERY »

Similar Threads
Extract epk and eix error (Dont extract because eix)
12/26/2012 - Metin2 PServer - Discussions / Questions - 2 Replies
Hi, My first topic xD... But i have a problem extracting... how gives the informacion for extract is archive eix, and if isnīt the correct archive eix for archive epk donīt extract... itīs my problem... isnīt the correct eix file... And i need to extract pc2... is possible creat a archive eix for archive epk?? Please! I Need really... if possible for today! Try donīt respond in German... Or, write right... for i can translate...
[Release] Aion Extract
12/26/2011 - Aion Hacks, Bots, Cheats & Exploits - 2 Replies
Description This is a tool to extract all the pak files under the chosen directory recursive and convert all binary xml files to normal xml files. Instructions Just extract the file and start the AionExtract.exe "Aion Data Dir" choose the directory you want to extract for examle /Aion/Data it will extract all *.pak files in every directory and subdirectory. "Extract to" choose the directory in which you want the extracted data.
[RELEASE] cq_action help: types & params description(translated from chinese)
09/01/2011 - EO PServer Guides & Releases - 12 Replies
Here we go: this is translation of ActionDefine.h (found in old server sources) It will help you understand the numbers in cq_action. If you are planning to build your own cq_action section, this will for sure help you. Also, you will know what are the limits of cq_action table. However there are for sure more types/params implemented in new msg servers, so not all is covered. njoy another fine release from ACME.
[Release] EO DNP Extract Tool!
08/17/2008 - EO PServer Guides & Releases - 13 Replies
USE this tool and extract what ever C3 files and dds files u want to extracted in the c3 dnp file and data .dnp file first : write a bat file, iuput all the c2 or dds link in it! dawnpack c3/texture/001000000.dds dawnpack c3/texture/001131000.dds dawnpack c3/texture/001131010.dds dawnpack c3/texture/001131020.dds dawnpack c3/texture/001131030.dds dawnpack c3/texture/001131040.dds



All times are GMT +1. The time now is 22:31.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.