[Release] ALL Upgrade Npcs (Translated) 13.01.2008

The file is a Sql query.

h t t p://www.sendspace.com/file/fmiicd (remove spaces)

This is the latest update (ALL Upgrade npcs are Translated).
Mallshop, Npc for making supers and a few more.
Ive just seen a couple of bugs,I fix tomorrow:)

Eddy69, thank you for your contribution :D


Tell me how can I install this file?

I'm openning Navicat and after console, copying and pasteing the content of .sql file on Navicat console, and when I try to run ALL QUERY LINES return this errors:

ERROR 1062 : Duplicate entry '3002022' for key 1
ERROR 1406 : Data too long for column 'param' at row 1

Can you help me?

PEACE,

The *.sql file you have downloaded is meant to create a new table & add the data, since you already have a "cq_action" table, you can either "rename" ur current "cq_action" table or edit the *.sql to update the current table & not create a new one :)

~Enjoy~

Ok ive tried running a batch file with this file and it crashes , I then deleted cq_action and re ran a batch file and it still crashes , am i supposed to not run a batch file ? How do iI edit the sql to update the current table ?

You dont delete the cq_action, You only empty it then use this file to restore it.
And use some thing like Navcat ect.

getting heaps of error when importing though..
u should just keep the rows u update.. and then instead of insert use update

like this
instead of
insert into blablabla
update your sqlfile to have this statements
update cq_action set param='text u translated' where id='idnumber';

and delete the other rows.. :D

The problem with that is, the amount that I edit in one go is alot.
The npc text is not all together but spread all over the place.
Im not that skilled with mysql, so maybe Im save or editing it wrong that it causes error.
But I did test on other clients and other computers (not my home network) and had np with the .sql
Btw Ive be imformed by lordvladek (Thankyou) that there is over 28k of lines to translate, what ive done is under 20% of the total (1 weeks work).

is your cq_action machinetranslated?

Quote:

---

Originally Posted by nooneatall

getting heaps of error when importing though..
u should just keep the rows u update.. and then instead of insert use update

like this
instead of
insert into blablabla
update your sqlfile to have this statements
update cq_action set param='text u translated' where id='idnumber';

and delete the other rows.. :D

---

This is how i have done it :
UPDATE `cq_action` SET `param`="I~Hatch~,~Store~And~Heal~Eudmons." WHERE `id`=20200;

The sql file updates sucessfully but when I try and talk to the NPC it does not respond, do you see anything wrong in my syntax ?

yes.. you should use ' not " :D

UPDATE cq_action SET param='I~Hatch~,~Store~And~Heal~Eudmons.' WHERE id='20200';

try that line :D

DOH!! ty

Im not to sure what you want me to do ?

I was discussing with nooneatall the syntax of the sql is all

Ill upload the file with more translated later to day.
Im almost up to the upgrade npc, Ill finish them and upload :)

P.s Is any1 else doing translations, maybe if we mix together the translation we can jump forwards :)
I ask this because, Im rather alone and with my lob (Landscaping) I do a couple of hours a day but, it will take time.

Rome wasn't built is a single day .. the more u experiment the more u learn .. no hurry, take ur time but come out full ... btw i have already finished all the translations ... but those are custom for my server only ... and are funny rather than being 100% accurate with the Official EO English Server, cuz i made it tht way :D

~Enjoy~