[Release] ALL Upgrade Npcs (Translated) 13.01.2008

[eddy69]

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

 

[Titania]

Re: [Release] Partly translated Npc (working)

Eddy69, thank you for your contribution


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,

 

[dastorm]

Re: [Release] Partly translated Npc (working)

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~

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

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 ?

 

[eddy69]

Re: [Release] Partly translated Npc (working)

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

 

[nooneatall]

Re: [Release] Partly translated Npc (working)

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..

 

[eddy69]

Re: [Release] Partly translated Npc (working)

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).

 

[nooneatall]

Re: [Release] Partly translated Npc (working)

is your cq_action machinetranslated?

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

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..

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 ?

 

[nooneatall]

Re: [Release] Partly translated Npc (working)

yes.. you should use ' not "

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

try that line

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

DOH!! ty

 

[eddy69]

Re: [Release] Partly translated Npc (working)

Im not to sure what you want me to do ?

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

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

 

[eddy69]

Re: [Release] Partly translated Npc (working)

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.

 

[dastorm]

Re: [Release] Partly translated Npc (working)

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

~Enjoy~

 

[eddy69]

Re: [Release] Partly translated Npc (working)

Mine are not 100% official, it says the same but simple so ppl that cant read english to well will understand it better.

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

edie this is how i am translating it so as i can go back and change the dialouge if needed later.
I made a blank cq_action.sql from notepad and everytime I translate somthing I add it to it so I can run a batch file ,:
/* 1st hatcher in market */
UPDATE cq_action SET param='I~Hatch,~Store~And~Heal~Eudemons.' WHERE id='20200';
UPDATE cq_action SET param='Open~Hatchery. 3908900' WHERE id='20201';
UPDATE cq_action SET param='Open~Warehouse 20232' WHERE id='20204';
/* Auctioneer*/
UPDATE cq_action SET param='I~am~the~auctioneer.~Welcome!' WHERE id='20300';
UPDATE cq_action SET param='' WHERE id='20301';
UPDATE cq_action SET param='' WHERE id='20302';

Just a suggestion

 

[nooneatall]

Re: [Release] Partly translated Npc (working)

yes.. doing an update sql syntax is the abolsute best way for everyone else to use

 

[FroZenFiRe]

Re: [Release] Partly translated Npc (working)

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

~Enjoy~

Lol you should up the sql , it would make my life easier , I would just have to change the text to what i wanted it to say


Has anyone found out what links cq_npc and cq_action together?

 

[eddy69]

Re: [Release] Partly translated Npc (working)

FroZenFiRe,
cq_npc is graphic (looks),movement (turning,ect),map position and what they do (tasks).
I think the table says it all. (I think)
cq_action is just the talking.