Yardım windows files shutdown attıktan sonra level bilgisi sıfırlama

enes turan · 16 Temmuz 2024

merhaba başlıktada belirttiğim gibi esc ile çıkış yaptıktan sonra (game, db, ch1 vs) tekrar başlattığımda karakterin level bilgisi sıfırlanıyor syseer de vermiyor nereden kaynaklanıyor olabilir fikri olan varmıdır ?

son eklediğim sistemler

1. konu
2. konu

not: envanterdeki itemler kaybolmuyor level, lokasyon, skill bilgileri sıfırlanıyor başlangıç pozisyonuna geliyor

hasanmacit · 16 Temmuz 2024

tablo sıralamasında hata olabilir belki

enes turan · 16 Temmuz 2024

hasanmacit demiş ki:
tablo sıralamasında hata olabilir belki

Kod:

SYSERR: Jul 16 23:43:43 :: CAsyncSQL::ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player  SET job = 0, voice = 0, dir = 0, x = 968840, y = 278023, z = 0, map_index = 41, exit_x = 968840, exit_y = 278023, exit_map_index = 41, hp = 6112, mp = 2869, stamina = 767, random_hp = 5117, random_sp = 2499, playtime = 0, level = 120, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 0, exp = 0, stat_point = 0, skill_point = 270, sub_skill_point = 119, stat_reset_count = 111, ip = '(null)', part_main = 18242961, part_hair = 0, last_play = NOW(), skill_group = 61374488, alignment = 0, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, equip_index = 0, monster_killed = 0, stone_killed = 0, boss_killed = 0, blue_player_killed = 0, yellow_player_killed = 0, red_player_killed = 0, allplayer_killed = 0, duel_won = 0, duel_lost = 0, skill_level = '\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\

db de şöyle bir hata verdi komple esc yapıp çıkınca

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, gold, equip_index, playtime, "
                         "monster_killed, "
                         "stone_killed, "
                         "boss_killed, "
                         "blue_player_killed, "
                         "yellow_player_killed, "
                         "red_player_killed, "
                         "allplayer_killed, "
                         "duel_won, "
                         "duel_lost, "
                         "skill_level, quickslot) "
                         "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, 0, "
                         "%d, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, ",
                         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.part_base, packet->player_table.gold,
                         packet->player_table.equip_index,
                         packet->player_table.llMonsterKilled,
                         packet->player_table.llStoneKilled,
                         packet->player_table.llBossKilled,
                         packet->player_table.llBluePlayerKilled,
                         packet->player_table.llYellowPlayerKilled,
                         packet->player_table.llRedPlayerKilled,
                         packet->player_table.llAllPlayerKilled,
                         packet->player_table.llDuelWon,
                         packet->player_table.llDuelLost);

bişey göremedim ama eksikmi var acaba

hasanmacit · 16 Temmuz 2024

enes turan demiş ki:

Kod:

SYSERR: Jul 16 23:43:43 :: CAsyncSQL::ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player  SET job = 0, voice = 0, dir = 0, x = 968840, y = 278023, z = 0, map_index = 41, exit_x = 968840, exit_y = 278023, exit_map_index = 41, hp = 6112, mp = 2869, stamina = 767, random_hp = 5117, random_sp = 2499, playtime = 0, level = 120, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 0, exp = 0, stat_point = 0, skill_point = 270, sub_skill_point = 119, stat_reset_count = 111, ip = '(null)', part_main = 18242961, part_hair = 0, last_play = NOW(), skill_group = 61374488, alignment = 0, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, equip_index = 0, monster_killed = 0, stone_killed = 0, boss_killed = 0, blue_player_killed = 0, yellow_player_killed = 0, red_player_killed = 0, allplayer_killed = 0, duel_won = 0, duel_lost = 0, skill_level = '\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\

db de şöyle bir hata verdi komple esc yapıp çıkınca

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, gold, equip_index, playtime, "
                         "monster_killed, "
                         "stone_killed, "
                         "boss_killed, "
                         "blue_player_killed, "
                         "yellow_player_killed, "
                         "red_player_killed, "
                         "allplayer_killed, "
                         "duel_won, "
                         "duel_lost, "
                         "skill_level, quickslot) "
                         "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, 0, "
                         "%d, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, "
                         "%lld, ",
                         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.part_base, packet->player_table.gold,
                         packet->player_table.equip_index,
                         packet->player_table.llMonsterKilled,
                         packet->player_table.llStoneKilled,
                         packet->player_table.llBossKilled,
                         packet->player_table.llBluePlayerKilled,
                         packet->player_table.llYellowPlayerKilled,
                         packet->player_table.llRedPlayerKilled,
                         packet->player_table.llAllPlayerKilled,
                         packet->player_table.llDuelWon,
                         packet->player_table.llDuelLost);

bişey göremedim ama eksikmi var acaba

o %d 0 dönen sıralar var ya oralar tablodaki kısımlarla doğru mu eşleşiyor diye tek tek say. eski haliyle karşılaştır. muhtemelen ordadır

enes turan · 17 Temmuz 2024

hasanmacit demiş ki:
o %d 0 dönen sıralar var ya oralar tablodaki kısımlarla doğru mu eşleşiyor diye tek tek say. eski haliyle karşılaştır. muhtemelen ordadır

Kod:

SYSERR: Jul 17 01:05:15 :: CAsyncSQL::ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player  SET job = 0, voice = 0, dir = 0, x = 968296, y = 277768, z = 0, map_index = 41, exit_x = 968296, exit_y = 277768, exit_map_index = 41, hp = 790, mp = 270, stamina = 820, random_hp = 0, random_sp = 0, playtime = 0, level = 1, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '(null)', part_main = 35762313, part_hair = 0, monster_killed = 60887648, stone_killed = 0, boss_killed = 0, blue_player_killed = 0, yellow_player_killed = 0, red_player_killed = 0, allplayer_killed = 0, duel_won = 0, duel_lost = 0, equip_index = 0, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '\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\

malesef bir türlü çözemedim sorun hala devam ediyor
dosyanın hali

Ara

Yardım windows files shutdown attıktan sonra level bilgisi sıfırlama

enes turan

Yardımsever Üye

hasanmacit

discord: hasanmacit

enes turan

Yardımsever Üye

hasanmacit

discord: hasanmacit

enes turan

Yardımsever Üye

Dosya Eklentileri

Benzer konular