looking tools ep4

[damona]

Originally Posted by pv2_002

Thanks for the info, But it will take forever, for me to add names , its better that i can dumb the tables with english, hope i can find one

just make a sql query on your database


UPDATE t_npc SET a_name = a_name_usa;

[BlankEdge]

Originally Posted by damona

just make a sql query on your database


UPDATE t_npc SET a_name = a_name_usa;

Done. but by doing this, how exactly will it work?!

And damona you know me other than epvp, its just that you have changed your skype and i dont have your new skype or discord to catch hold of you

[Desarija]

Originally Posted by pv2_002

Done. but by doing this, how exactly will it work?!

And damona you know me other than epvp, its just that you have changed your skype and i dont have your new skype or discord to catch hold of you

your database probably has the right names in a_name_usa but the wrong ones in a_name. The query will copy the names from a_name_usa into a_name, so they will display correctly in the editors

[BlankEdge]

Originally Posted by Desarija

your database probably has the right names in a_name_usa but the wrong ones in a_name. The query will copy the names from a_name_usa into a_name, so they will display correctly in the editors

ah ok, thanks for the info

Originally Posted by damona

just make a sql query on your database


UPDATE t_npc SET a_name = a_name_usa;

I did, and i can see english names are in different table.

But when i used the tools, still they names are in some error format names!

can you give me your discord, so i can get some small helps, when you are free.

Regard's

[Veni/Marius]

Originally Posted by damona

just make a sql query on your database


UPDATE t_npc SET a_name = a_name_usa;

+1,

here are most of the ones you need, if not all of them. It will be different from your database structure, so just adjust it.

The row after "SET" is the one that will have the same values as the one behind the "=".

 Spoiler

UPDATE t_action SET a_name = a_name_usa;
UPDATE t_action SET a_client_description = a_client_description_usa;

UPDATE t_affinity SET a_name = a_name_usa;


UPDATE t_item SET a_name = a_name_usa;
UPDATE t_item SET a_descr = a_descr_usa;

UPDATE t_item_collection SET a_theme_string = a_theme_string_usa;
UPDATE t_item_collection SET a_desc_string = a_desc_string_usa;

UPDATE t_lacarette SET a_name = a_name_usa;

UPDATE t_npc SET a_name = a_name_usa;
UPDATE t_npc SET a_descr = a_descr_usa;

UPDATE t_option SET a_name = a_name_usa;

UPDATE t_quest SET a_name = a_name_usa;
UPDATE t_quest SET a_desc = a_desc_usa;
UPDATE t_quest SET a_desc2 = a_desc2_usa;
UPDATE t_quest SET a_desc3 = a_desc3_usa;

UPDATE t_rareoption SET a_name = a_prefix_mal_eng;

UPDATE t_skill SET a_name = a_name_usa;
UPDATE t_skill SET a_client_description = a_client_description_usa;

UPDATE t_string SET a_string = a_string_usa;

UPDATE t_action SET a_name = a_name_usa;
UPDATE t_action SET a_client_description = a_client_description_usa;

UPDATE t_action SET a_name = a_name_usa;
UPDATE t_action SET a_client_description = a_client_description_usa;

[BlankEdge]

Originally Posted by Veni/Marius

 Spoiler

Thxvm.

Regard's

[Flair23]

Originally Posted by damona

My Tool is free for all, dont need a licence.

I get this error object cannot be cast from dbnull to other types

[damona]

Originally Posted by Flair23

I get this error object cannot be cast from dbnull to other types

you need to write the complete error message, maybe some database connection or datatype of db problem.

[Flair23]

Originally Posted by damona

you need to write the complete error message, maybe some database connection or datatype of db problem.

thats the only message i get, and when i try to run the same databases on localhost, it works fine so it is a bit strange altough i use mariadb on my vps.

[damona]

Originally Posted by Flair23

thats the only message i get, and when i try to run the same databases on localhost, it works fine so it is a bit strange altough i use mariadb on my vps.

Then it's a connection problem, in the normal case vps dont allow connection from outside. You need to open server sql port give the user rights and setup your ip on mysql user or setup for all open.