Problema teleportare coordonate

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
Marius7
Nivel 1

Nivel 1
Mesaje: 109
Membru din: 18 Mai 2019, 12:14
Aprecieri: 336  
Mulţumiri: 2  
Medalii

Problemă: Cand dau /warp 383 640 sau alte coordonate contul ramane blocat acolo si ma scoate cand vreau sa intru.
Tipologie server(PvM / PvP):PvM
Resursă folosită:
ServerFiles utilizat:[FULL]Serverfiles Clean+src
Syserr:
Poză:
Detalii suplimentare:Daca dau /warp sau /go la unele coordonate contul ramane blocat acolo si ma scoate cand vreau sa intru me poate ajuta cineva?
Sus
Avatar utilizator
Titan
Metin Master

Metin Master
Mesaje: 2783
Membru din: 01 Iun 2015, 15:09
Server: In curand.
Regat: Chunjo
Aprecieri: 42  
Mulţumiri: 377  
  Rezolvări prob.: 3
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Nu-i destul de clar că nu ai mapa respectivă sau te teleportează la niște coordonate dinafara unei mape?
Imagine
Afișează semnătura
Sus
Avatar utilizator
Marius7
Nivel 1

Nivel 1
Mesaje: 109
Membru din: 18 Mai 2019, 12:14
Aprecieri: 336  
Mulţumiri: 2  
Medalii

Uitati aici erorile din syserr:

SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 5, 'GM_LOGIN', '', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 0, 'LOGIN', '15.28.170.84 999999997923377 1 103 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1562502752, 0, 10000221, 'SET_SOCKET', '', '', 71136) errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)
SYSERR: Jun 30 14:32:36 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 0, 'LOGOUT', '15.28.170.84 999999997923377 1 103 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:36 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 56, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)










SYSERR: Jun 30 14:32:07 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go ', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:13 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:16 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:18 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 962821, 273720, 0, 'WARP', '[#Mr]zApple MapIdx 41 DestMapIdx0 DestX40500 DestY68500 Empire3', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'warp 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 962821, 273720, 0, 'LOGOUT', '15.28.170.84 999999997923377 1 41 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)
Sus
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Marius7 scrie:Uitati aici erorile din syserr:
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 5, 'GM_LOGIN', '', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 0, 'LOGIN', '15.28.170.84 999999997923377 1 103 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1562502752, 0, 10000221, 'SET_SOCKET', '', '', 71136) errno: 1146)
SYSERR: Jun 30 14:32:32 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)
SYSERR: Jun 30 14:32:36 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 40500, 68500, 0, 'LOGOUT', '15.28.170.84 999999997923377 1 103 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:36 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 56, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)

SYSERR: Jun 30 14:32:07 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go ', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:13 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:16 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:18 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'go 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 962821, 273720, 0, 'WARP', '[#Mr]zApple MapIdx 41 DestMapIdx0 DestX40500 DestY68500 Empire3', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2833, 999, '15.28.170.84', 1, '[#Mr]zApple', 'warp 405 685', NOW()) errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2833, 962821, 273720, 0, 'LOGOUT', '15.28.170.84 999999997923377 1 41 1023', '15.28.170.84') errno: 1146)
SYSERR: Jun 30 14:32:31 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000205, 'SET_SOCKET', '', '', 72702) errno: 1146)
Iti lipsesc acele tabele, deci creaza-le:

Cod: Selectaţi tot

CREATE TABLE `log` (
  `vnum` varchar(11) COLLATE big5_bin DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `type` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `time` time DEFAULT NULL,
  `who` int(11) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `what` int(11) DEFAULT NULL,
  `how` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `hint` varchar(20) COLLATE big5_bin DEFAULT NULL,
  `ip` varchar(30) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

Cod: Selectaţi tot

CREATE TABLE `command_log` (
  `userid` int(11) DEFAULT NULL,
  `server` int(11) DEFAULT NULL,
  `ip` text,
  `port` int(11) DEFAULT NULL,
  `username` varchar(12) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
  `command` varchar(20) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Imagine
Imagine
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Sus
Avatar utilizator
Marius7
Nivel 1

Nivel 1
Mesaje: 109
Membru din: 18 Mai 2019, 12:14
Aprecieri: 336  
Mulţumiri: 2  
Medalii

Imi poti spune te rog unde le bag
Sus
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Marius7 scrie:Imi poti spune te rog unde le bag
Creaza o baza de date numita log, daca nu exista deja, si ruleaza acele query in ea.
Imagine
Imagine
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Sus
Avatar utilizator
Marius7
Nivel 1

Nivel 1
Mesaje: 109
Membru din: 18 Mai 2019, 12:14
Aprecieri: 336  
Mulţumiri: 2  
Medalii

Am ceva care se numeste syslog.14 si syslog.15 in winscp asta este?
Sus
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Marius7 scrie:Am ceva care se numeste syslog.14 si syslog.15 in winscp asta este?
Nu. Acele tabele/query fac referire la/si se ruleaza in Navicat(fiind vorba aici de query sql).
Imagine
Imagine
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Sus
Avatar utilizator
Marius7
Nivel 1

Nivel 1
Mesaje: 109
Membru din: 18 Mai 2019, 12:14
Aprecieri: 336  
Mulţumiri: 2  
Medalii

Daca se poate sa imi pui o poza sa vad unde sa intru.
Sus
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Marius7 scrie:Daca se poate sa imi pui o poza sa vad unde sa intru.
Nu am un server la care sa ma pot conecta cu Navicat, deci nu pot pune poza, imi pare rau.
Imagine
Imagine
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Sus
Închis
Coordonate teleportare
Răspunsuri
5 Vizualizări
581
Citește mai mult
[QUEST] Teleportare la anumite coordonate
Răspunsuri
10 Vizualizări
2089
Citește mai mult
Adaugare Coordonate (Harti) In inelul de teleportare
Răspunsuri
2 Vizualizări
394
Citește mai mult
Problema Sloturi Coordonate
Răspunsuri
1 Vizualizări
228
Citește mai mult

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 52 vizitatori

+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici