looking tools ep4

Page 2 of 2

02/22/2019 13:06 damona#16

Quote:

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 :D

just make a sql query on your database

UPDATE t_npc SET a_name = a_name_usa;

02/22/2019 13:11 BlankEdge#17

Quote:

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 :D

:handsdown:

02/22/2019 13:22 Desarija#18

Quote:

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 :D

:handsdown:

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

02/22/2019 13:26 BlankEdge#19

Quote:

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

Quote:

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

02/23/2019 09:32 Veni/Marius#20

Quote:

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

02/23/2019 09:47 BlankEdge#21

Quote:

Originally Posted by Veni/Marius

Spoiler

Thxvm. :handsdown:

Regard's

04/30/2023 19:34 Flair23#22

Quote:

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

05/02/2023 14:12 damona#23

Quote:

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.

05/02/2023 20:43 Flair23#24

Quote:

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.

05/05/2023 21:08 damona#25

Quote:

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.

Page 2 of 2