problemă nivel

Înainte de a posta o problemă, caută în acest forum și poate găsești rezolvare.
Închis
Avatar utilizator
AoMetaphor
Nivel 2

Nivel 2
Mesaje: 216
Membru din: 08 Dec 2020, 22:54
Server: AoM2
Regat: Chunjo
Aprecieri: 433  
Mulţumiri: 7  
Medalii

*Problemă/Întrebare:Salutare, întâmpin următoarea problemă: Dacă spre ex. un jucător are nivelul 80, se duce și face 85, iese și intră iar peste 15 minute, îl dă înapoi la 80 și în poziția în care era ultima dată.
Tipologie server:-
*Resursă folosită:-
*ServerFiles utilizat:-
*Syserr:

Cod: Selectaţi tot

SYSERR: Dec 16 03:06:29 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 16 03:24:52 :: 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 = 198479, y = 1219937, z = 0, map_index = 73, exit_x = 198479, exit_y = 1219937, exit_map_index = 73, hp = 22635, mp = 2309, stamina = 1195, random_hp = 3171, random_sp = 1588, playtime = 903, level = 89, level_step = 1, st = 90, ht = 90, dx = 90, iq = 11, gold = 304773919, exp = 332402716, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 03:31:53 :: 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 = 182500, y = 1220700, z = 0, map_index = 73, exit_x = 182500, exit_y = 1220700, exit_map_index = 73, hp = 25308, mp = 2070, stamina = 622, random_hp = 3171, random_sp = 1588, playtime = 908, level = 89, level_step = 2, st = 90, ht = 90, dx = 90, iq = 12, gold = 321893917, exp = 394107104, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 03:38:54 :: 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 = 215096, y = 1220804, z = 0, map_index = 73, exit_x = 215096, exit_y = 1220804, exit_map_index = 73, hp = 25620, mp = 2374, stamina = 1226, random_hp = 3171, random_sp = 1588, playtime = 913, level = 89, level_step = 2, st = 90, ht = 90, dx = 90, iq = 12, gold = 347601190, exp = 421070580, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 03:45:55 :: 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 = 843200, y = 1066900, z = 0, map_index = 207, exit_x = 843200, exit_y = 1066900, exit_map_index = 207, hp = 14313, mp = 2599, stamina = 1250, random_hp = 3171, random_sp = 1588, playtime = 920, level = 89, level_step = 3, st = 90, ht = 90, dx = 90, iq = 13, gold = 377785112, exp = 598723776, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 1, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 03:52:56 :: 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 = 182500, y = 1220700, z = 0, map_index = 73, exit_x = 182500, exit_y = 1220700, exit_map_index = 73, hp = 24539, mp = 2287, stamina = 870, random_hp = 3171, random_sp = 1588, playtime = 926, level = 89, level_step = 3, st = 90, ht = 90, dx = 90, iq = 13, gold = 391033121, exp = 666513558, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 03:59:57 :: 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 = 183794, y = 1220702, z = 0, map_index = 73, exit_x = 183794, exit_y = 1220702, exit_map_index = 73, hp = 24164, mp = 2621, stamina = 1250, random_hp = 3207, random_sp = 1606, playtime = 933, level = 90, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 397988911, exp = 3200028, stat_point = 0, skill_point = 51, sub_skill_point = 31, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 04:06:58 :: 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 = 959603, y = 269738, z = 0, map_index = 41, exit_x = 959603, exit_y = 269738, exit_map_index = 41, hp = 24164, mp = 2621, stamina = 1250, random_hp = 3207, random_sp = 1606, playtime = 940, level = 90, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 403044412, exp = 37317658, stat_point = 0, skill_point = 51, sub_skill_point = 31, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 04:13:59 :: 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 = 959603, y = 269738, z = 0, map_index = 41, exit_x = 959603, exit_y = 269738, exit_map_index = 41, hp = 24164, mp = 2621, stamina = 1250, random_hp = 3207, random_sp = 1606, playtime = 944, level = 90, level_step = 0, st = 90, ht = 90, dx = 90, iq = 13, gold = 403044412, exp = 37317658, stat_point = 0, skill_point = 51, sub_skill_point = 31, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 04:40:38 :: 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 = 474607, y = 953386, z = 0, map_index = 1, exit_x = 474607, exit_y = 953386, exit_map_index = 1, hp = 24120, mp = 2549, stamina = 1250, random_hp = 3171, random_sp = 1588, playtime = 903, level = 89, level_step = 1, st = 90, ht = 90, dx = 90, iq = 11, gold = 296763353, exp = 294804930, stat_point = 0, skill_point = 50, sub_skill_point = 30, stat_reset_count = 0, ip = '79.112.193.146', part_main = 41311, part_hair = 5055, last_play = NOW(), skill_group = 1, alignment = 200000, horse_level = 21, horse_riding = 0, horse_hp = 34, horse_hp_droptime = 1608138141, horse_stamina = 120, 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\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: Dec 16 06:45:46 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 960332, y = 269919, z = 0, map_index = 41, exit_x = 960332, exit_y = 269919, exit_map_index = 41, hp = 10270, mp = 780, stamina = 1315, random_hp = 0, random_sp = 0, playtime = 100, level = 1, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 1580000000, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '92.86.33.182', part_main = 41144, part_hair = 5031, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1608285425, horse_stamina = 120, 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\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: Dec 16 06:52:47 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 960332, y = 269919, z = 0, map_index = 41, exit_x = 960332, exit_y = 269919, exit_map_index = 41, hp = 10270, mp = 780, stamina = 1315, random_hp = 0, random_sp = 0, playtime = 107, level = 1, level_step = 0, st = 5, ht = 3, dx = 3, iq = 5, gold = 1225000000, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '92.86.33.182', part_main = 41144, part_hair = 5031, last_play = NOW(), skill_group = 0, alignment = 0, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1608285425, horse_stamina = 120, 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\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\
Poză:-
*Detalii suplimentare:-
Avatar utilizator
amvenitsavadcv
Nivel 3

Nivel 3
Mesaje: 413
Membru din: 28 Iul 2018, 11:25
Server: da
Aprecieri: 44  
Mulţumiri: 156  
Medalii

Modifca din tabela player -> part_main sa fie smallint de length 6
Pentru acest mesaj, amvenitsavadcv for the post:
AoMetaphor
Avatar utilizator
AoMetaphor
Nivel 2

Nivel 2
Mesaje: 216
Membru din: 08 Dec 2020, 22:54
Server: AoM2
Regat: Chunjo
Aprecieri: 433  
Mulţumiri: 7  
Medalii

Așa îl aveam. Am modificat din smallint în int și acum nu mai dă înapoi.
Avatar utilizator
SkyLine
Membru Club

Membru Club
Mesaje: 2655
Membru din: 12 Dec 2013, 23:37
Server: Miraj2-Online
Regat: Jinno
Aprecieri: 520  
Mulţumiri: 987  
Discord: Copiază ID
 Contact:
Medalii

Topic marcat ca si rezolvat. Mutat in Probleme Rezolvate
Închis

Înapoi la “Probleme rezolvate”

  • Informaţie