SirGath
Premium-
Posts
41 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Everything posted by SirGath
-
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: ´Á´ë
-
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: 저주받은 늑대
-
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
-
Convert proto 34k (.py error)
SirGath replied to SirGath's topic in Community Support - Questions & Answers
@Toxic you can suck, no problem. -
Convert proto 34k (.py error)
SirGath replied to SirGath's topic in Community Support - Questions & Answers
?????? -
Traceback (most recent call last): File "convert_mob.py", line 82, in <module> mob_proto_line = "%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%st%s" % (row[0], """ + row[1] + """, get_rank(row[3]), get_type(row[4]), get_battletype(row[5]), row[6], row[7], get_flag(row[8]), row[9], get_race(row[10]), get_immune(row[11]), row[12], get_folder(row[13]), row[14], row[15], row[16], row[17], row[18], row[19], row[20], row[21], row[22], row[23], row[24], row[25], row[26], row[27], row[28], row[29], row[30], row[31], row[32], row[33], row[34], row[35], row[36], row[37], row[38], row[39], row[40], row[41], row[42], row[43], row[44], row[45], row[46], row[47], row[48], row[49], row[50], row[51], row[52], row[53], row[54], row[55], row[56], row[57], row[58], row[59], row[60], row[61], row[62], row[63], row[64], row[65], row[66], row[67], row[68], row[69], row[70], row[71]) File "convert_mob.py", line 52, in get_flag return """ + flag + """ TypeError: cannot concatenate 'str' and 'NoneType' objects How i can resolve it?
-
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: mysql: ambiguous option '--e=SELECT coins from account.account WHERE id=3 LIMIT 1;' (enable_cleartext_plugin, execute)
-
0711 19:26:40246 :: Traceback (most recent call last): 0711 19:26:40246 :: File "networkModule.py", line 237, in SetGamePhase 0711 19:26:40246 :: File "system.py", line 130, in __pack_import 0711 19:26:40246 :: File " 0711 19:26:40246 :: <string> 0711 19:26:40246 :: ", line 0711 19:26:40246 :: 68 0711 19:26:40246 :: 0711 19:26:40246 :: 0711 19:26:40246 :: SCREENSHOT_DIR = "YT2W" 0711 19:26:40246 :: 0711 19:26:40246 :: ^ 0711 19:26:40246 :: SyntaxError 0711 19:26:40246 :: : 0711 19:26:40246 :: invalid syntax 0711 19:26:40247 ::
-
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?
-
Mob_drop_item problem?
SirGath replied to SirGath's topic in Community Support - Questions & Answers
I'm crazy.. my value were incorrect.. xD close this topic -
When i compile for game i have this