SirGath

The error shows the entries with those letters.. They must be there.. It's not showing it for all entries, only those.

You quoted my reply then didn't reply? In confused.

Your errors above are resolved and this is a new problem you're having?

Please add me skype: roccown i show u..

If i use game 60mb have error to connect the server

if i use game 8mb crash when i choose character

Ok now when i choose character return to login..

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

 

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:

 

저주받은 늑대

No you can play with imaginary client

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

@Toxic you can suck, no problem.

??????

Ok ty to all

How i can do it? :S

I want crypt my pack: .eix + .epk = .mt2

how i can do it?

@Shogun i haven't it o.o

mysql: ambiguous option '--e=SELECT coins from account.account WHERE id=3 LIMIT 1;' (enable_cleartext_plugin, execute) 

How i can resolve it? I have a quest that require mysql_query:

quest mds begin
    state start begin
        when login begin
            loop_timer("carga_mds", 10)
        end
     
        when carga_mds.timer begin
            local coins = mysql_query("SELECT coins from account.account WHERE id="..pc.get_account_id().." LIMIT 1;")[1][1]
            cmdchat("Mds "..coins)
        end
    end
end

My mysql_query of questlib.lua:

mysql_query = function(query) 
    local rt = io.open('CONFIG','r'):read('*all') 
    local pre= string.gsub(rt,'.+PLAYER_SQL:%s(%S+)%s(%S+)%s(%S+)%s(%S+).+','-h%1 -u%2 -p%3 -D%4') 
    math.randomseed(os.time()) 
    local fi,t,out = 'mysql_data_'..math.random(10^9)+math.random(2^4,2^10),{},{} 
    os.execute('mysql '..pre..' --e='..string.format('%q',query)..' > '..fi)   
    for av in io.open(fi,'r'):lines() do table.insert(t,split(av,'t')) end; os.remove(fi); 
    for i = 2, table.getn(t) do table.foreach(t[i],function(a, 
        out[i-1]        = out[i-1] or {} 
        out[i-1][a]        = b 
        out[t[1][a]]    = out[t[1][a]] or {} 
        out[t[1][a]][i-1]    = b 
    end) end 
    return out 
end

Ok now it found, but when i make in navicat coins or cash > 0 in game it was always 0.. i have the quest on winscp. and i have this error on putty:

0710 23:33:22988 ::   File "
0710 23:33:22988 :: <string>
0710 23:33:22988 :: ", line 
0710 23:33:22988 :: 2070
0710 23:33:22988 :: 

0710 23:33:22988 ::     
0710 23:33:22988 :: constInfo.mds = int(coins)
0710 23:33:22988 :: 

0710 23:33:22988 ::     
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 ::  
0710 23:33:22988 :: ^

0710 23:33:22988 :: SyntaxError
0710 23:33:22988 :: : 
0710 23:33:22988 :: invalid syntax
0710 23:33:22988 :: 

How resolve it?

Why i can't call horse at spider dungeon 2?? Only in that map i can't call it..

How i can resolve?

Can someone help me?

Core 2.4 the items can't overlap.. i set flag 20 on db and client..

With 4.2.1 i can change bonus every 10 minute .... 

Vanilla 4 inventory page is still bug?

I'm crazy.. my value were incorrect.. xD close this topic

When i compile for game i have this