eingetragen.
SYSERR: Jun 10 19:17:20 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=1 AND pid=57702) errno: 1146)
SYSERR: Jun 10 19:17:20 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jun 10 19:17:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGOUT', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:17:20 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 20, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:17:23 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun 10 19:18:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 10 19:20:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 5, 'GM_LOGIN', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:20:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGIN', '192.168.178.22 0 1 1 360', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:20:25 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57702, inet_aton('192.168.178.22'), '') errno: 1146)
SYSERR: Jun 10 19:20:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:20:45 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2928, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:20:50 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGOUT', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:20:50 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 54, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:21:21 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 5, 'GM_LOGIN', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:21:21 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGIN', '192.168.178.22 0 1 1 360', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:21:21 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57702, inet_aton('192.168.178.22'), '') errno: 1146)
SYSERR: Jun 10 19:21:21 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:21:27 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGOUT', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:21:27 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 47, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:23:17 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 5, 'GM_LOGIN', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:23:17 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGIN', '192.168.178.22 0 1 1 360', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:23:17 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57702, inet_aton('192.168.178.22'), '') errno: 1146)
SYSERR: Jun 10 19:23:17 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:23:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGOUT', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:23:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 40, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:24:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 5, 'GM_LOGIN', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:24:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 471093, 953854, 0, 'LOGIN', '192.168.178.22 0 1 1 360', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:24:04 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 57702, inet_aton('192.168.178.22'), '') errno: 1146)
SYSERR: Jun 10 19:24:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:24: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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'priv 0 1 500 24', NOW()) errno: 1146)
SYSERR: Jun 10 19:24: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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'priv 0 2 500 24', NOW()) errno: 1146)
SYSERR: Jun 10 19:24: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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'priv 0 3 500 24', NOW()) errno: 1146)
SYSERR: Jun 10 19:24: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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'priv 0 4 500 24', NOW()) errno: 1146)
SYSERR: Jun 10 19:24:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2927, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
SYSERR: Jun 10 19:24:53 :: 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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'm 101', NOW()) errno: 1146)
SYSERR: Jun 10 19:25:04 :: 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(57702, 999, '192.168.178.22', 1, '[SA]CookiieFreak', 'm 101 20', NOW()) errno: 1146)
SYSERR: Jun 10 19:25:33 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: SET @i = (SELECT MAX(id) FROM loginlog2 WHERE account_id=1 AND pid=57702) errno: 1146)
SYSERR: Jun 10 19:25:33 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: UPDATE loginlog2 SET type='VALID', logout_time=NOW(), playtime=TIMEDIFF(logout_time,login_time) WHERE id=@i errno: 1146)
SYSERR: Jun 10 19:25:33 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun 10 19:25:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 57702, 470272, 954882, 0, 'LOGOUT', '', '192.168.178.22') errno: 1054)
SYSERR: Jun 10 19:25:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'ip' in 'field list' (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 10, 0, 30000022, 'SET_SOCKET', '', '', 72701) errno: 1054)
.
Wie kann ich denn am Schnellsten Überprüfen ob die Koordinaten zu nah an anderen sind ?