Fully untouched 34083 server files & DB

[MORTE 76]

no getting it vrunner and run.sh and put a start.sh well?

#!/bin/sh

echo -e "033[31m============================================033[0m"
echo -e "033[31m=    Drakon2 Servidor Privado 2013/2014    =033[0m"
echo -e "033[31m============================================033[0m"
echo -e "033[31m
Que canales desea iniciar ? n
1 - (1) Iniciar canal 1?n
2 - (2) Iniciar canal 2?n
3 - (3) Iniciar canal 3?n
4 - (4) Iniciar canal 4?n
5 - (5) Iniciar 4 canales?033[0m"

read chs

case $chs in
1*)
    echo -e "033[31m Iniciando base de datos ..033[0m"
    cd /home/drakon2/base/db/
    ./db &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando Auth ..033[0m"
    cd /home/drakon2/canales/auth
    ./auth &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo1_1 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo1_2 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo1_3 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando game99 ..033[0m"
    cd /home/drakon2/canales/channel99 &&
    ./game99 &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[32m n El canal 1 esta iniciado!033[0m"
;;
2*)
    echo -e "033[31m Iniciando base de datos ..033[0m"
    cd /home/drakon2/base/db/
    ./db &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando Auth ..033[0m"
    cd /home/drakon2/canales/auth
    ./auth &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo2_1 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo2_2 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo2_3 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando game99 ..033[0m"
    cd /home/drakon2/canales/channel99 &&
    ./game99 &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[32m n El canal 2 esta iniciado!033[0m"
;;
3*)
    echo -e "033[31m Iniciando base de datos ..033[0m"
    cd /home/drakon2/base/db/
    ./db &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando Auth ..033[0m"
    cd /home/drakon2/canales/auth
    ./auth &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo3_1 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo3_2 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo3_3 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando game99 ..033[0m"
    cd /home/drakon2/canales/channel99 &&
    ./game99 &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[32m n El canal 3 esta iniciado!033[0m"
;;
4*)
    echo -e "033[31m Iniciando base de datos ..033[0m"
    cd /home/drakon2/base/db/
    ./db &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando Auth ..033[0m"
    cd /home/drakon2/canales/auth
    ./auth &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo4_1 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo4_2 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo4_3 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando game99 ..033[0m"
    cd /home/drakon2/canales/channel99 &&
    ./game99 &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[32m n El canal 4 esta iniciado!033[0m"
;;
5*)
    echo -e "033[31m Iniciando base de datos ..033[0m"
    cd ./base/db/
    ./db &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando Auth ..033[0m"
    cd /home/drakon2/canales/auth
    ./auth &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo1_1 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo1_2 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo1_3 ..033[0m"
    cd /home/drakon2/canales/canal_1/nucleo1_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo2_1 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo2_2 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo2_3 ..033[0m"
    cd /home/drakon2/canales/canal_2/nucleo2_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo3_1 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo3_2 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo3_3 ..033[0m"
    cd /home/drakon2/canales/canal_3/nucleo3_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m Iniciando nucleo4_1 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_1 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo4_2 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_2 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando nucleo4_3 ..033[0m"
    cd /home/drakon2/canales/canal_4/nucleo4_3 &&
    ./game &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[31m n Iniciando game99 ..033[0m"
    cd /home/drakon2/canales/channel99 &&
    ./game99 &
    ./clear_logs.sh &
    sleep 2
    clear
    echo -e "033[32m n Se ha iniciado Ch1, Ch2, Ch3 y Ch4!033[0m"
;;
esac

[Radiatos 0]

hello, i became this error

 

db syserr:

 

SYSERR: Sep  6 16:39:28 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25')

SYSERR: Sep  6 16:39:29 :: Process: FDWATCH: peer null in event: ident 20

SYSERR: Sep  6 16:39:31 :: Process: FDWATCH: peer null in event: ident 22

SYSERR: Sep  6 16:39:33 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25')

SYSERR: Sep  6 16:39:35 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25')

SYSERR: Sep  6 16:39:35 :: Process: FDWATCH: peer null in event: ident 20

SYSERR: Sep  6 16:39:36 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25')

 

please help..

[MrKarpiuk 118]

hmm help me i'm dont have any idea how fix this

SYSERR: Sep  8 15:17:31 :: Start: TABLE_POSTFIX not configured use default
Sep  8 15:17:31 :: connecting to MySQL server (player)
Sep  8 15:17:31 :: CREATING DIRECT_SQL
Sep  8 15:17:31 :: AsyncSQL: locale euckr
Sep  8 15:17:31 ::    failed, retrying in 5 seconds
Sep  8 15:17:36 :: CREATING DIRECT_SQL
Sep  8 15:17:36 :: AsyncSQL: locale euckr

[Darkoz 1]

Can someone give me a client compatible with this file? i download the sg put the launcher but didnt work

[Rumor 2549]

http://metin2dev.org/board/topic/136-40250-test-client/

[Darkoz 1]

With the client u link i got this:

Error: Bad magic number in libtraceback.pyc with your launcher called: metin2client_r36469_unprotected_working_NOHS

[dofuzeiro 1]

Can someone help me pls with this error thanks alot.

 

edit: i resolved that error but now i have this one:

look at putty : 

 

i put the correct password which is 123456, ( i did the password mysql reset)

but i still get errors really strange, if anybody could help me, i really appreciate thanks.

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

[Rumor 2549]

Can someone help me pls with this error thanks alot.

 

edit: i resolved that error but now i have this one:

look at putty : 

 

i put the correct password which is 123456, ( i did the password mysql reset)

but i still get errors really strange, if anybody could help me, i really appreciate thanks.

 

Don't edit your reply saying you resolved an error without even explaining how you resolved it. Until you explain that you won't get any further help, howabout that?

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

[dofuzeiro 1]

 

Can someone help me pls with this error thanks alot.

 

edit: i resolved that error but now i have this one:

look at putty : 

 

i put the correct password which is 123456, ( i did the password mysql reset)

but i still get errors really strange, if anybody could help me, i really appreciate thanks.

 

Don't edit your reply saying you resolved an error without even explaining how you resolved it. Until you explain that you won't get any further help, howabout that?

 

Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db  /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate.

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

[Darkoz 1]

why when i open item_proto or mob proto is empty?

[Rumor 2549]

Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db  /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate.

Setup an account for you to login to the database via Navicat and an account for your game cores to interact with your database using. For this example I'll use the username "rumor" for my account and "metin2" for the game core's account. Every password in this example will be "password" but please DO NOT use this as your password! If you have a static IP address and wish to restrict access to the database only to your IP, change the "%" sign to your IP. The "%" sign indicates that any IP address is allowed to connect to the database using the specified credentials.

mysql -p

Now enter the password you set with mysqladmin earlier... and you will see this prompt:

mysql>

This is where we set the actual permissions for the accounts up.

GRANT ALL PRIVILEGES ON *.* TO 'rumor'@'%'
IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'metin2'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;
quit

pro tip: remember (or write down) this information because you will need it later.

[dofuzeiro 1]

 

Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db  /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate.

Setup an account for you to login to the database via Navicat and an account for your game cores to interact with your database using. For this example I'll use the username "rumor" for my account and "metin2" for the game core's account. Every password in this example will be "password" but please DO NOT use this as your password! If you have a static IP address and wish to restrict access to the database only to your IP, change the "%" sign to your IP. The "%" sign indicates that any IP address is allowed to connect to the database using the specified credentials.

mysql -p

Now enter the password you set with mysqladmin earlier... and you will see this prompt:

mysql>

This is where we set the actual permissions for the accounts up.

GRANT ALL PRIVILEGES ON *.* TO 'rumor'@'%'
IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'metin2'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;
quit

pro tip: remember (or write down) this information because you will need it later.

 

thanks alot it worked =), i'm going to test the filles now and see if everything is working perfectly, once again thanks. and sorry for the inconvenience

EDIT: btw why is mob proto and item proto empty? is there some .sql file that i need to run? Thanks again.

[Rumor 2549]

it should be in the mob_proto.txt, mob_names.txt, item_proto.txt, item_names.txt files in the serverfiles. If those are empty maybe something else is configured wrong on the server so it isn't finding those? Like broken/missing symlinks.

[dofuzeiro 1]

it should be in the mob_proto.txt, mob_names.txt, item_proto.txt, item_names.txt files in the serverfiles. If those are empty maybe something else is configured wrong on the server so it isn't finding those? Like broken/missing symlinks.

yeah i have those files in the filezilla in some folder (idk the name now) but im talking about the navicat  player db and the item_proto table and mob_proto table those are empty what am i suppose to do? i can normally start the server? Ty.

[Rumor 2549]

well check to make sure the server is even starting, specifically the DB score. maybe you're getting an error when starting and it won't load the tables with the data from the txt files.

[dofuzeiro 1]

well check to make sure the server is even starting, specifically the DB score. maybe you're getting an error when starting and it won't load the tables with the data from the txt files.

Hello the server starts normally, at least i use run.sh and no errors appear, however i went to the db sys log and this appeared:

 

Whenever i tried to login to the server it stays in You will be connected to the server.

 

Also 

there is the db

Also mob proto is empty, Humh very strange and i dont know what to do :X, thanks.

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

[Rumor 2549]

type ps to check if db core is running

 

type "service mysql-server status" to check if mysql is on

[Despero 129]

I need a Client for this Files ?

[Rumor 2549]

No you can play with imaginary client

[SirGath 1]

SYSERR: Oct 15 23:21:35 :: pid_init: 
Start of pid: 21338

SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf
t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, "
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, "
 
 skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ
SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist
query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry
SYSERR: Oct 15 23:21:36 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

I Need help.. is db sysser @Rumor

[SirGath 1]

No you can play with imaginary client

 

[Rumor 2549]

SYSERR: Oct 15 23:21:35 :: pid_init: 
Start of pid: 21338

SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf
t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, "
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, "
 
 skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ
SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist
query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry
SYSERR: Oct 15 23:21:36 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

I Need help.. is db sysser @Rumor

 

 

In this query it looks like it has an issue with the name. It says the "string value" is incorrect. Notice that on all of these errors it's for these foreign character sets using things like "´Á´ë". I suggest changing these wherever they are (I think in the item_names.txt file). I think the xB5XE9xB0xB3 stuff is the way the game core is interpreting the entries for the name column. So maybe you should try fixing these names like "´Á´ë" to something in normal letters.

SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist

Regarding this, you need to create a table in account called iptocountry. So you can go into Navicat and right click the account database then click "Execute MySQL File..." then choose the file below (save the contents I post down there as a .sql file):

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `iptocountry`
-- ----------------------------
DROP TABLE IF EXISTS `iptocountry`;
CREATE TABLE `iptocountry` (
  `IP_FROM` varchar(16) NOT NULL DEFAULT '',
  `IP_TO` varchar(16) DEFAULT NULL,
  `COUNTRY_NAME` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`IP_FROM`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Records of iptocountry
-- ----------------------------
INSERT INTO `iptocountry` VALUES ('127.0.0.1', '127.0.0.1', 'localhost');

[SirGath 1]

 

SYSERR: Oct 15 23:21:35 :: pid_init: 
Start of pid: 21338

SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf
t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, "
SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, "
 
 skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ
SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ
SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist
query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry
SYSERR: Oct 15 23:21:36 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

I Need help.. is db sysser @Rumor

 

 

In this query it looks like it has an issue with the name. It says the "string value" is incorrect. Notice that on all of these errors it's for these foreign character sets using things like "´Á´ë". I suggest changing these wherever they are (I think in the item_names.txt file). I think the xB5XE9xB0xB3 stuff is the way the game core is interpreting the entries for the name column. So maybe you should try fixing these names like "´Á´ë" to something in normal letters.

SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist

Regarding this, you need to create a table in account called iptocountry. So you can go into Navicat and right click the account database then click "Execute MySQL File..." then choose the file below (save the contents I post down there as a .sql file):

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `iptocountry`
-- ----------------------------
DROP TABLE IF EXISTS `iptocountry`;
CREATE TABLE `iptocountry` (
  `IP_FROM` varchar(16) NOT NULL DEFAULT '',
  `IP_TO` varchar(16) DEFAULT NULL,
  `COUNTRY_NAME` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`IP_FROM`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Records of iptocountry
-- ----------------------------
INSERT INTO `iptocountry` VALUES ('127.0.0.1', '127.0.0.1', 'localhost');

In mob_proto.txt i have this name of mobs:

 

저주받은 늑대

 

[SirGath 1]

and i haven't this letters: ´Á´ë

[SirGath 1]

Ok now when i choose character return to login..