Cevaplanmadı Erorr Player Mysql

#ifdef ENABLE_CONQUEROR_LEVEL
snprintf(queryStr, sizeof(queryStr),
"SELECT "
"id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,"
#ifdef ENABLE_CHEQUE_SYSTEM
"cheque,"
#endif
#ifdef ENABLE_GEM_SYSTEM
"gem,"
#endif
"level,level_step,st,ht,dx,iq,exp,"
"stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair, part_acce,"
"skill_level,quickslot,skill_group,alignment,"
#ifdef ENABLE_CONQUEROR_LEVEL
"conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,"
#endif
"mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,"
"UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point,"
"fish_use_count, fish_slots"
#ifdef ENABLE_GEM_SYSTEM
",UNIX_TIMESTAMP(gem_next_refresh),gem_items "
#endif
" ,envanter "

" FROM player%s WHERE id=%d",
GetTablePostfix(), packet->player_id);
#else
snprintf(queryStr, sizeof(queryStr),
"SELECT "
"id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,"
"level,level_step,st,ht,dx,iq,exp,"
"stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair, part_acce,"
"skill_level,quickslot,skill_group,alignment,"
#ifdef ENABLE_CONQUEROR_LEVEL
"conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,"
#endif
"mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,"
"UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point,"
"fish_use_count, fish_slots"
" ,envanter "

" FROM player%s WHERE id=%d",
GetTablePostfix(), packet->player_id);
#endif

Genişletmek için tıkla

SYSERR: Aug 19 21:38:10 :: ChildLoop: AsyncSQL: query failed: Unknown column 'conqueror_point' in 'field list' (query: SELECT id,name,job,voice,dir,x,y,z,map_index,exit_x,exit_y,exit_map_index,hp,mp,stamina,random_hp,random_sp,playtime,gold,cheque,gem,level,level_step,st,ht,dx,iq,exp,stat_point,skill_point,sub_skill_point,stat_reset_count,part_base,part_hair, part_acce,skill_level,quickslot,skill_group,alignment,conquerorlevel,conqueror_level_step,sungma_str,sungma_hp,sungma_move,sungma_inmune,conqueror_exp,conqueror_point,mobile,horse_level,horse_riding,horse_hp,horse_hp_droptime,horse_stamina,UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play),horse_skill_point,fish_use_count, fish_slots,UNIX_TIMESTAMP(gem_next_refresh),gem_items ,envanter FROM player WHERE id=265 errno: 1054)
SYSERR: Aug 19 21:38:10 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

Genişletmek için tıkla