Yeni karakter oluştururken database hatası veriyor.
syserr
clientmanagerplayer.cpp
player.sql
syserr
Kod:
DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\' at line 1
query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, part_sash, gold, cheque, gem, rebirt, playtime, skill_level, quickslot, horse_level, horse_riding, horse_stamina, horse_hp, horse_hp_droptime, gem_items) VALUES(0, 1, 'deneme', 1, 6, 4, 3, 3, 0, 0, 0, 963924, 278449, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, 0'\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Jan 1 02:34:27 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid1=0 WHERE id=1
clientmanagerplayer.cpp
C++:
queryLen = snprintf(queryStr, sizeof(queryStr),
"INSERT INTO player%s "
"(id, account_id, name, level, st, ht, dx, iq, "
"job, voice, dir, x, y, z, "
"hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, part_sash, gold, cheque, gem, rebirt, playtime, "
"skill_level, quickslot, horse_level, horse_riding, horse_stamina, horse_hp, horse_hp_droptime, gem_items) "
"VALUES(0, %u, '%s', %d, %d, %d, %d, %d, "
"%d, %d, %d, %d, %d, %d, %d, "
"%d, %d, %d, %d, %d, %d, %d, 0, %d, %d, %u, 0",
GetTablePostfix(),
packet->account_id, packet->player_table.name, packet->player_table.level, packet->player_table.st, packet->player_table.ht, packet->player_table.dx, packet->player_table.iq,
packet->player_table.job, packet->player_table.voice, packet->player_table.dir, packet->player_table.x, packet->player_table.y, packet->player_table.z,
packet->player_table.hp, packet->player_table.sp, packet->player_table.sRandomHP, packet->player_table.sRandomSP, packet->player_table.stat_point, packet->player_table.stamina, packet->player_table.part_base, packet->player_table.parts[PART_MAIN], packet->player_table.gold, packet->player_table.cheque, packet->player_table.rebirt);
sys_log(0, "PlayerCreate accountid %d name %s level %d st %d ht %d job %d",
packet->account_id,
packet->player_table.name,
packet->player_table.level,
packet->player_table.st,
packet->player_table.ht,
packet->player_table.job);
player.sql
SQL:
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT 'NONAME',
`job` tinyint(2) unsigned NOT NULL DEFAULT '0',
`voice` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dir` tinyint(2) NOT NULL DEFAULT '0',
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`z` int(11) NOT NULL DEFAULT '0',
`map_index` int(11) NOT NULL DEFAULT '0',
`exit_x` int(11) NOT NULL DEFAULT '0',
`exit_y` int(11) NOT NULL DEFAULT '0',
`exit_map_index` int(11) NOT NULL DEFAULT '0',
`hp` smallint(4) NOT NULL DEFAULT '0',
`mp` smallint(4) NOT NULL DEFAULT '0',
`stamina` smallint(6) NOT NULL DEFAULT '0',
`random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',
`random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',
`playtime` int(11) NOT NULL DEFAULT '0',
`level` tinyint(2) unsigned NOT NULL DEFAULT '1',
`level_step` tinyint(1) NOT NULL DEFAULT '0',
`st` smallint(3) NOT NULL DEFAULT '0',
`ht` smallint(3) NOT NULL DEFAULT '0',
`dx` smallint(3) NOT NULL DEFAULT '0',
`iq` smallint(3) NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`gold` int(11) NOT NULL DEFAULT '0',
`cheque` smallint(3) NOT NULL DEFAULT '0',
`gem` int(11) NOT NULL,
`gem_next_refresh` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`rebirt` tinyint(2) unsigned NOT NULL DEFAULT '0',
`stat_point` smallint(3) NOT NULL DEFAULT '0',
`skill_point` smallint(3) NOT NULL DEFAULT '0',
`quickslot` tinyblob,
`newquickslot` tinyblob,
`ip` varchar(15) DEFAULT '0.0.0.0',
`part_main` smallint(6) unsigned NOT NULL DEFAULT '0',
`part_base` tinyint(4) NOT NULL DEFAULT '0',
`part_hair` smallint(4) NOT NULL DEFAULT '0',
`part_sash` smallint(4) unsigned NOT NULL DEFAULT '0',
`skill_group` tinyint(4) NOT NULL DEFAULT '0',
`skill_level` blob,
`alignment` int(11) NOT NULL DEFAULT '0',
`prestige` int(11) NOT NULL DEFAULT '0',
`last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`change_name` tinyint(1) NOT NULL DEFAULT '0',
`mobile` varchar(24) DEFAULT NULL,
`sub_skill_point` smallint(3) NOT NULL DEFAULT '0',
`stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',
`horse_hp` smallint(4) NOT NULL DEFAULT '0',
`horse_stamina` smallint(4) NOT NULL DEFAULT '0',
`horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
`horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',
`horse_riding` tinyint(1) NOT NULL DEFAULT '0',
`horse_skill_point` smallint(3) NOT NULL DEFAULT '0',
`change_empire` int(11) NOT NULL DEFAULT '0',
`status` varchar(32) NOT NULL DEFAULT '--',
`location` varchar(32) NOT NULL DEFAULT '--',
`year` varchar(4) NOT NULL DEFAULT '--',
`month` varchar(2) NOT NULL DEFAULT '--',
`day` varchar(2) NOT NULL DEFAULT '--',
`combat_zone_rank` int(4) NOT NULL DEFAULT '0',
`combat_zone_points` int(4) NOT NULL DEFAULT '0',
`year_round_point` int(11) NOT NULL DEFAULT '0',
`bosskirmiziejder` int(11) NOT NULL DEFAULT '0',
`bossejder` int(11) NOT NULL DEFAULT '0',
`bossazrail` int(11) NOT NULL,
`bosslusifer` int(11) NOT NULL DEFAULT '0',
`bossmeley` int(11) NOT NULL DEFAULT '0',
`boss_event_point` int(11) NOT NULL DEFAULT '0',
`ramadan_event_point` int(11) NOT NULL DEFAULT '0',
`bossrazador` int(11) NOT NULL,
`bossnemere` int(11) NOT NULL,
`bossbarones` int(11) NOT NULL DEFAULT '0',
`inventory_password` varchar(6) NOT NULL DEFAULT '0',
`money2` bigint(20) NOT NULL DEFAULT '0',
`facebook` varchar(255) NOT NULL,
`imza` text NOT NULL,
`kral` int(1) NOT NULL,
`sifre` int(6) NOT NULL DEFAULT '0',
`mymoney` bigint(20) NOT NULL DEFAULT '0',
`inventory_ex` int(11) NOT NULL DEFAULT '90',
`zodiac_point` int(11) NOT NULL DEFAULT '0',
`last_zodiac_point_reward` int(11) NOT NULL DEFAULT '0',
`bead` int(11) NOT NULL,
`achievement_point` int(11) NOT NULL,
`shop_money` bigint(20) NOT NULL DEFAULT '0',
`shop_cheque` bigint(20) NOT NULL DEFAULT '0',
`shop_bar1` bigint(20) NOT NULL DEFAULT '0',
`shop_bar2` bigint(20) NOT NULL DEFAULT '0',
`shop_bar3` bigint(20) NOT NULL DEFAULT '0',
`shop_soul_stone` bigint(20) NOT NULL DEFAULT '0',
`shop_dragon_claw` bigint(20) NOT NULL DEFAULT '0',
`shop_dragon_scale` bigint(20) NOT NULL DEFAULT '0',
`offshop_time` bigint(20) NOT NULL DEFAULT '0',
`war_point` int(11) NOT NULL,
`gem_items` blob,
`boss_gem_items` blob,
PRIMARY KEY (`id`,`rebirt`),
KEY `account_id_idx` (`account_id`) USING BTREE,
KEY `name_idx` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3232 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;