Problema serverfile

dragonluc · 24 Feb 2019, 18:39

*Problemă: Daca intru pe server si fac level, bani, sau ma duc in alta mapa......dupa reboot ma da de la inceput cu lvl 1 si fara bani
Tipologie server(PvM / PvP):PVM
*Resursă folosită: *Link exclusiv J4M*-
*ServerFiles utilizat:Serenity2
*Syserr:
Poză:
*Detalii suplimentare:Ma poate ajuta cineva?

dragonluc · 24 Feb 2019, 20:33

Cineva?

[ Postat de pe Android ] Imagine

elucian14 · 24 Feb 2019, 23:47

vezi daca ai vrun quest care face asta daca nu dupa cat timp dai reboot ? sti ca exista un delay intre baza de date si sv este normal sa faca asa daca dai reboot imediat dupa ce faci lvl

[Panther] · 25 Feb 2019, 01:19

Inainte sa dai reboot inchizi serverul cu comanda shutdown si apoi sh close.sh.

dragonluc · 25 Feb 2019, 11:28

[Panther] scrie:Inainte sa dai reboot inchizi serverul cu comanda shutdown si apoi sh close.sh.

Iti las aici syserr

SYSERR: Feb 23 23:13:38 :: pid_init:
Start of pid: 822

SYSERR: Feb 23 23:13:38 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb 23 23:15:48 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Feb 23 23:26:19 :: ChildLoop: AsyncSQL: query failed: 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 ' fish_slots = '\0\0\0\0\0\0\0\0\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: UPDATE player SET job = 0, voice = 0, dir = 0, x = 965152, y = 267389, z = 0, map_index = 41, exit_x = 965152, exit_y = 267389, exit_map_index = 41, hp = 9260, mp = 260, stamina = 1320, random_hp = 0, random_sp = 0, playtime = 6, level = 120, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 1, gem = 0, battle_points = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 111, stat_reset_count = 0, ip = '109.97.115.172', part_main = 39097, part_hair = 6004, part_sash = 0, last_play = NOW(), skill_group = 0, alignment = 30, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, fish_use_count = 0, gem_next_refresh = FROM_UNIXTIME(0), t_choosed =
SYSERR: Feb 24 18:37:10 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Feb 24 18:37:20 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Feb 24 18:44:53 :: ChildLoop: AsyncSQL: query failed: 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 ' fish_slots = '\0\0\0\0\0\0\0\0\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: UPDATE player SET job = 0, voice = 0, dir = 0, x = 957452, y = 254821, z = 0, map_index = 41, exit_x = 957452, exit_y = 254821, exit_map_index = 41, hp = 9260, mp = 260, stamina = 1320, random_hp = 0, random_sp = 0, playtime = 0, level = 120, level_step = 0, st = 6, ht = 4, dx = 3, iq = 3, gold = 1, gem = 0, battle_points = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 111, stat_reset_count = 0, ip = '109.97.115.172', part_main = 39097, part_hair = 6004, part_sash = 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, fish_use_count = 0, gem_next_refresh = FROM_UNIXTIME(0), t_choosed =

xImAndrew · 25 Feb 2019, 11:37

Deci, cum a zis si mai sus [Panther] inainte de a da reboot. Dai /shutdown pe joc si in putty sh close.sh
Ca daca dai reboot imediat nu o sa se salveze nimic. Sau poate e o problema de la serverfile de nu se salveaza oricum încearcă ce ti am spus mai sus si vezi daca merge daca nu iti urez bafta sa repari serverul.

[ Postat de pe Android ] Imagine

dragonluc · 25 Feb 2019, 11:42

xImAndrew scrie:Deci, cum a zis si mai sus [Panther] inainte de a da reboot. Dai /shutdown pe joc si in putty sh close.sh
Ca daca dai reboot imediat nu o sa se salveze nimic. Sau poate e o problema de la serverfile de nu se salveaza oricum încearcă ce ti am spus mai sus si vezi daca merge daca nu iti urez bafta sa repari serverul.

[ Postat de pe Android ]

am facut cum a zis el.....dar tot nu merge

xASU · 25 Feb 2019, 11:49

este din sursa db

Diaconu · 25 Feb 2019, 12:22

incearca functiile astea in binary, te descurci tu. (n-am testat)

dragonluc · 25 Feb 2019, 12:34

Diaconu scrie:
#ifdef __TITLE_SYSTEM__
,pkTab->iTChoosed
,pkTab->cTAvailable
#endif
);

// Binary 로 바꾸기 위한 임시 공간
static char text[8192 + 1];

CDBManager::instance().EscapeString(text, pkTab->skills, sizeof(pkTab->skills));
queryLen += snprintf(pszQuery + queryLen, querySize - queryLen, "skill_level = '%s', ", text);

CDBManager::instance().EscapeString(text, pkTab->quickslot, sizeof(pkTab->quickslot));
queryLen += snprintf(pszQuery + queryLen, querySize - queryLen, "quickslot = '%s' ", text);

#ifdef ENABLE_FISH_EVENT
CDBManager::instance().EscapeString(text, pkTab->fishSlots, sizeof(pkTab->fishSlots));
queryLen += snprintf(pszQuery + queryLen, querySize - queryLen, ", fish_slots = '%s' ", text);
#endif
incearca functiile astea in binary, te descurci tu. (n-am testat)

mai bagat in ceata

) sunt la inceput cu sursele .....

Problema serverfile

[WTS] Detroit ServerFile v1 /v2 (AKA M2M Serverfile and NW2Online Serverfile)

RTHOST.RO - Real Team Hosting(oferim serverfile empire world /wol2 / serverfile dinos full)

[SELL - Serverfile] PvM serverfile. (Easter offer)

CERERE SERVERFILE SI CLIENT SERVERFILE CRYTICAL

Cine este conectat