2 Bug-uri

20 Dec 2019, 23:28

*Problemă/Întrebare:
Tipologie server(PvM / PvP):
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat:
*Syserr:
Poză:
*Detalii suplimentare: Ok, am 2 bug-uri extrem de ciudate...

1) La breasla nu pare ciudat faptul ca nu pot sa creez, dar eroarea din syserr mi se pare ciudata :

Cod: Selectaţi tot

SYSERR: Dec 20 23:30:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 '" " WHERE name = 'Breasla'' at line 1
query: SELECT COUNT(*) FROM guild" " WHERE name = 'Breasla'

2) La inventar, nu stiu ce pnm s-a intamplat, dar cand bag de ex batalia in inventar cu /i 149 ... in loc de pietre imi apar 3 sabii demon +9 (excuse me, wtf) ... si cand incerc sa mut pe un alt slot din inventar, pica serverul cu urmatoarea eroare :

Cod: Selectaţi tot

SYSERR: Dec 20 23:32:41 :: 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 '" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, ' at line 1 (query: INSERT DELAYED INTO log" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000001, 'SET_SOCKET', '', '', 149) errno: 1064)
SYSERR: Dec 20 23:32:41 :: 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 '" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, ' at line 1 (query: INSERT DELAYED INTO log" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1, 0, 10000001, 'SET_SOCKET', '', '', 149) errno: 1064)
SYSERR: Dec 20 23:32:41 :: 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 '" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, ' at line 1 (query: INSERT DELAYED INTO log" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 10000001, 'SET_SOCKET', '', '', 149) errno: 1064)
SYSERR: Dec 20 23:32:41 :: 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 '" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, ' at line 1 (query: INSERT DELAYED INTO log" " (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 960073, 269056, 10000001, 'GM', 'Sabie de batalie+9', '84.117.13.111', 149) errno: 1064)
SYSERR: Dec 20 23:32:41 :: 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 '" " (userid, server, ip, port, username, command, date ) VALUES(4, 999, '84.117.' at line 1 (query: INSERT DELAYED INTO command_log" " (userid, server, ip, port, username, command, date ) VALUES(4, 999, '84.117.13.111', 1, '[OwN]SkyLine', 'i 149', NOW())  errno: 1064)
SYSERR: Dec 20 23:32:50 :: Handshake: Invalid Handshake on 17
SYSERR: Dec 20 23:32:50 :: Process: SEQUENCE 41bc6400 mismatch 0x31 != 0xd6 header 252
SYSERR: Dec 20 23:32:50 :: Process: SEQUENCE_LOG [[OwN]SkyLine]-------------
	[003 : 0x56]
	[007 : 0x6b]
	[007 : 0x15]
	[007 : 0x5a]
	[007 : 0xa7]
	[026 : 0xcc]
	[007 : 0x21]
	[007 : 0x8b]
	[029 : 0x70]
	[029 : 0xfb]
	[081 : 0xac]
	[007 : 0x3a]
	[007 : 0x6b]
	[007 : 0xe3]
	[007 : 0x36]
	[003 : 0x9e]
	[254 : 0x92]
	[252 : 0x4e]
	[252 : 0x16]
	[003 : 0xf1]
	[252 : 0x31]

SYSERR: Dec 20 23:32:50 :: 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 '" " (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 4, 9' at line 1 (query: INSERT DELAYED INTO log" " (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 4, 960073, 269056, 0, 'LOGOUT', '84.117.13.111 999999999999999 1 41 200000', '84.117.13.111') errno: 1064)

Heimdall · 21 Dec 2019, 19:09

Încearcă asta pentru 1.

input_main.cpp

 void CInputMain::AnswerMakeGuild(LPCHARACTER ch, const char* c_pData)
{
   TPacketCGAnswerMakeGuild* p = (TPacketCGAnswerMakeGuild*) c_pData;

   if (ch->GetGold() < 200000)
      return;

   if (ch->GetGuild())
      return;

   CGuildManager& gm = CGuildManager::instance();

   TGuildCreateParameter cp;
   memset(&cp, 0, sizeof(cp));

   cp.master = ch;
   strlcpy(cp.name, p->guild_name, sizeof(cp.name));

   if (cp.name[0] == 0 || !check_name(cp.name))
   {
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("적합하지 않은 길드 이름 입니다."));
      return;
   }

   DWORD dwGuildID = gm.CreateGuild(cp);

   if (dwGuildID)
   {
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<길드> [%s] 길드가 생성되었습니다."), cp.name);

      int GuildCreateFee = 20000;

      ch->PointChange(POINT_GOLD, -GuildCreateFee);
      DBManager::instance().SendMoneyLog(MONEY_LOG_GUILD, ch->GetPlayerID(), -GuildCreateFee);

      char Log[128];
      snprintf(Log, sizeof(Log), "GUILD_NAME %s MASTER %s", cp.name, ch->GetName());
      LogManager::instance().CharLog(ch, 0, "MAKE_GUILD", Log);

      if (g_iUseLocale)
         ch->RemoveSpecifyItem(GUILD_CREATE_ITEM_VNUM, 1);
      //ch->SendGuildName(dwGuildID);
   }
   else
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<길드> 길드 생성에 실패하였습니다."));
}

Pentru nr. 2, încearcă să ştergi coloana vnum. Să nu uiţi de backup. Nu ştiu dacă este o rezolvare sau nu, dar am avut şi eu o problemă de genul, legată de vnum. Sau din contră, verifică dacă ai toate coloanele acolo. type, time, who, x, y, what, how, hint, ip, vnum. Dar presupun că ai făcut asta deja.

21 Dec 2019, 20:25

Heimdall scrie: ↑21 Dec 2019, 19:09 Încearcă asta pentru 1.

input_main.cpp

 void CInputMain::AnswerMakeGuild(LPCHARACTER ch, const char* c_pData)
{
   TPacketCGAnswerMakeGuild* p = (TPacketCGAnswerMakeGuild*) c_pData;

   if (ch->GetGold() < 200000)
      return;

   if (ch->GetGuild())
      return;

   CGuildManager& gm = CGuildManager::instance();

   TGuildCreateParameter cp;
   memset(&cp, 0, sizeof(cp));

   cp.master = ch;
   strlcpy(cp.name, p->guild_name, sizeof(cp.name));

   if (cp.name[0] == 0 || !check_name(cp.name))
   {
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("적합하지 않은 길드 이름 입니다."));
      return;
   }

   DWORD dwGuildID = gm.CreateGuild(cp);

   if (dwGuildID)
   {
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<길드> [%s] 길드가 생성되었습니다."), cp.name);

      int GuildCreateFee = 20000;

      ch->PointChange(POINT_GOLD, -GuildCreateFee);
      DBManager::instance().SendMoneyLog(MONEY_LOG_GUILD, ch->GetPlayerID(), -GuildCreateFee);

      char Log[128];
      snprintf(Log, sizeof(Log), "GUILD_NAME %s MASTER %s", cp.name, ch->GetName());
      LogManager::instance().CharLog(ch, 0, "MAKE_GUILD", Log);

      if (g_iUseLocale)
         ch->RemoveSpecifyItem(GUILD_CREATE_ITEM_VNUM, 1);
      //ch->SendGuildName(dwGuildID);
   }
   else
      ch->ChatPacket(CHAT_TYPE_INFO, LC_TEXT("<길드> 길드 생성에 실패하였습니다."));
}

Pentru nr. 2, încearcă să ştergi coloana vnum. Să nu uiţi de backup. Nu ştiu dacă este o rezolvare sau nu, dar am avut şi eu o problemă de genul, legată de vnum. Sau din contră, verifică dacă ai toate coloanele acolo. type, time, who, x, y, what, how, hint, ip, vnum. Dar presupun că ai făcut asta deja.

Se poate duce la arhiva topicul asta, am dat din VPS cPanel de la firma, full reinstall si merge acum

2 Bug-uri

Cine este conectat