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.
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
Re: [Release] Partly translated Npc (working)
yes.. doing an update sql syntax is the abolsute best way for everyone else to use :D
Re: [Release] Partly translated Npc (working)
Quote:
Originally Posted by
dastorm
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~
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 :p
Has anyone found out what links cq_npc and cq_action together?
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.
Re: [Release] Partly translated Npc (working)
Quote:
Originally Posted by
eddy69
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.
I know that I just want to figure out how each cq_action is linked to each npc like minnie says hello world in cq_action . what column in cq_npc points to cq_action " hello world "
Re: [Release] Partly translated Npc (working)
Quote:
Originally Posted by
FroZenFiRe
I know that I just want to figure out how each cq_action is linked to each npc like minnie says hello world in cq_action . what column in cq_npc points to cq_action " hello world "
none.. the server just reads the npc table to put the npcs in place and so on.. when u click a npc.. the server sends you the result of the action table.. :D
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
New update on First post :)
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
anyone get the whouse password translated ??
everytime i update action 3908006 (which is the text above the p/w box) it crashes
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
On a old translation I had it done, But it just did nothing maybe some thing to do with the tables.
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
I tried to batch it but it gives me a error and I didn't understand too much from what Frozen said.
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
Do any of you know what this is?:
1366 - Incorrect string value: "\xE6\x82\xA8\xE7\x9A\x84... 'for column 'param' at row 1
Please help!!!
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
Backup your cq_action, then with navcat empty the cq_action then use the query.
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
Quote:
Originally Posted by
eddy69
Backup your cq_action, then with navcat empty the cq_action then use the query.
Well, I didn't back it up like a loser... But I did empty it and tried to run your sql script and thats what it came up to.
Re: [Release] ALL Upgrade Npcs (Translated) 13.01.2008
Quote:
Originally Posted by
ExitWound
Do any of you know what this is?:
1366 - Incorrect string value: "\xE6\x82\xA8\xE7\x9A\x84... 'for column 'param' at row 1
Please help!!!
Same error here. This doesn't work as a query or running as a sql under navicat. If you execute the batch it does nothing - 0 queries. The above quoted error is given when you run as a query.