[Release]Extract Itemtype Description (SQL Builder)

[funhacker]

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.

[linja12]

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?

[funhacker]

Originally Posted by linja12

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?

[linja12]

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.

[haizamlee]

me too... when i run it no txt found.

[funhacker]

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.

[linja12]

100% Perfect!. TQ force.

[Request] Force, can You make another APP itemtype.dat convert to cq_itemtype querry?

[funhacker]

Originally Posted by linja12

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'

[emogoth213]

Originally Posted by funhacker

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]

@
itemtype.dat convert to cq_itemtype querry? cant find it i search using google.

[reloaded90]

WELL DONE