Problema sysser

  • Autor subiect yonr1
  • Dată creare
  • Răspunsuri: Răspunsuri 9
  • Vizualizări: Vizualizări 574
Stare
Nu este deschis pentru răspunsuri viitoare.

yonr1

Member
27 Dec 2018
152
2
18
30
bucuresti
Monede Dragon
0
*Problemă/Întrebare: la fiecare + la item imi apare acel syser
Tipologie server:
*Resursă folosită:
*ServerFiles utilizat:
personal
*Syserr:
COD: SELECTAŢI TOT
Cod:
SYSERR: Feb 8 20:06:35 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Lama Dintele Stafiei+0', 10000070, 0, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:13:07 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Lama Dintele Stafiei+1', 10000071, 1, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:13:11 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Lama Dintele Stafiei+2', 10000072, 2, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:13:15 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Lama Dintele Stafiei+3', 10000073, 3, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:15:04 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Sabie otravita+0', 10000075, 0, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:15:08 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Sabie otravita+1', 10000076, 1, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:15:12 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Sabie otravita+2', 10000077, 2, NOW(), 1, 'POWER') errno: 1062)
SYSERR: Feb 8 20:15:15 :: ChildLoop: AsyncSQL: query failed: Duplicate entry '0' for key 'PRIMARY' (query: INSERT INTO refinelog (pid, item_name, item_id, step, time, is_success, setType) VALUES(2876, 'Sabie otravita+3', 10000078, 3, NOW(), 1, 'POWER') errno: 1062)
 
Ai cumva sistemul ala de rarity?
gen la otravita iti apare cat de rara este? ca ai coloana "power" .. ma gandesc ca asta ar fii
 
verifica coloana 'POWER' de la ce provine.. uita-te in db sursa sau repara tabelul
 
Power am gasit in GuildManager.cpp/ Guildmanager.h/protoreader.cpp
Nu pare sa aiba de a face cu acel sysser.

C:\Users\kurys\Desktop\db\src\ProtoReader.cpp (2 hits)
Line 465: string arBattleType[] = { "MELEE", "RANGE", "MAGIC", "SPECIAL", "POWER", "TANKER", "SUPER_POWER", "SUPER_TANKER"};
Line 465: string arBattleType[] = { "MELEE", "RANGE", "MAGIC", "SPECIAL", "POWER", "TANKER", "SUPER_POWER", "SUPER_TANKER"};
C:\Users\kurys\Desktop\db\src\GuildManager.cpp (38 hits)
Line 169: if (!CConfig::instance().GetValue("POLY_POWER", str, sizeof(str)))
Line 172: if (!polyPower.Analyze(str))
Line 173: sys_err("cannot set power poly: %s", str);
Line 175: sys_log(0, "POWER_POLY: %s", str);
Line 898: "SELECT id, guild1, guild2, UNIX_TIMESTAMP(time), type, warprice, initscore, bet_from, bet_to, power1, power2, handicap FROM guild_war_reservation WHERE started=1 AND winner=-1",
Line 898: "SELECT id, guild1, guild2, UNIX_TIMESTAMP(time), type, warprice, initscore, bet_from, bet_to, power1, power2, handicap FROM guild_war_reservation WHERE started=1 AND winner=-1",
Line 899: "SELECT id, guild1, guild2, UNIX_TIMESTAMP(time), type, warprice, initscore, bet_from, bet_to, power1, power2, handicap FROM guild_war_reservation WHERE started=0"
Line 899: "SELECT id, guild1, guild2, UNIX_TIMESTAMP(time), type, warprice, initscore, bet_from, bet_to, power1, power2, handicap FROM guild_war_reservation WHERE started=0"
Line 926: str_to_number(t.lPowerFrom, row[col++]);
Line 927: str_to_number(t.lPowerTo, row[col++]);
Line 1021: polyPower.SetVar("lvp", lvp);
Line 1022: polyPower.SetVar("rkp", rkp);
Line 1023: polyPower.SetVar("alv", alv);
Line 1024: polyPower.SetVar("mc", mc);
Line 1026: t.lPowerFrom = (long) polyPower.Eval();
Line 1026: t.lPowerFrom = (long) polyPower.Eval();
Line 1027: sys_log(0, "GuildWar: %u lvp %d rkp %d alv %d mc %d power %d", GID1, lvp, rkp, alv, mc, t.lPowerFrom);
Line 1027: sys_log(0, "GuildWar: %u lvp %d rkp %d alv %d mc %d power %d", GID1, lvp, rkp, alv, mc, t.lPowerFrom);
Line 1037: polyPower.SetVar("lvp", lvp);
Line 1038: polyPower.SetVar("rkp", rkp);
Line 1039: polyPower.SetVar("alv", alv);
Line 1040: polyPower.SetVar("mc", mc);
Line 1042: t.lPowerTo = (long) polyPower.Eval();
Line 1042: t.lPowerTo = (long) polyPower.Eval();
Line 1043: sys_log(0, "GuildWar: %u lvp %d rkp %d alv %d mc %d power %d", GID2, lvp, rkp, alv, mc, t.lPowerTo);
Line 1043: sys_log(0, "GuildWar: %u lvp %d rkp %d alv %d mc %d power %d", GID2, lvp, rkp, alv, mc, t.lPowerTo);
Line 1046: if (t.lPowerTo > t.lPowerFrom)
Line 1046: if (t.lPowerTo > t.lPowerFrom)
Line 1048: polyHandicap.SetVar("pA", t.lPowerTo);
Line 1049: polyHandicap.SetVar("pB", t.lPowerFrom);
Line 1053: polyHandicap.SetVar("pA", t.lPowerFrom);
Line 1054: polyHandicap.SetVar("pB", t.lPowerTo);
Line 1064: "INSERT INTO guild_war_reservation (guild1, guild2, time, type, warprice, initscore, power1, power2, handicap) "
Line 1064: "INSERT INTO guild_war_reservation (guild1, guild2, time, type, warprice, initscore, power1, power2, handicap) "
Line 1066: GID1, GID2, p->bType, p->lWarPrice, p->lInitialScore, t.lPowerFrom, t.lPowerTo, t.lHandicap);
Line 1066: GID1, GID2, p->bType, p->lWarPrice, p->lInitialScore, t.lPowerFrom, t.lPowerTo, t.lHandicap);
Line 1386: if (m_data.lPowerFrom > m_data.lPowerTo)
Line 1386: if (m_data.lPowerFrom > m_data.lPowerTo)
C:\Users\kurys\Desktop\db\src\GuildManager.h (1 hit)
Line 253: CPoly polyPower;
 
la tine apare in guild adica la breasla, dar nu are o treaba cu tabela item ..
 
Am bagat alt item-proto.sql am zis ca poate are o problema al meu dar degeaba.
Doar pe ch1/2/3... core1 am acel sysser
 
Ultima editare:
pai nu are treaba cu item_proto ci cu tabela refinelog din log, anuleaza scrierea din game src log.cpp
cauta : void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)

si inlocuieste cu

Cod:
void LogManager::RefineLog(DWORD pid, const char* item_name, DWORD item_id, int item_refine_level, int is_success, const char* how)
{
//    m_sql.EscapeString(__escape_hint, sizeof(__escape_hint), item_name, strlen(item_name));

//    Query("INSERT INTO refinelog%s (pid, item_name, item_id, step, time, is_success, setType) VALUES(%u, '%s', %u, %d, NOW(), %d, '%s')",
//            get_table_postfix(), pid, __escape_hint, item_id, item_refine_level, is_success, how);
}

poti verifica si restul log-urilor si sa le anulezi.. ca unele sunt degeaba puse, nu te ajuta la nimic
 
Stare
Nu este deschis pentru răspunsuri viitoare.