SYSERR: Apr 25 06:30:05 :: DirectQuery: AsyncSQL:
irectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT id FROM guild
SYSERR: Apr 25 06:30:11 :: DirectQuery: AsyncSQL:
irectQuery : mysql_query error: Table 'account.player_shop' doesn't exist
query: SELECT id,map_index from player_shop WHERE channel=1 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Apr 25 06:30:11 :: DirectQuery: AsyncSQL:
irectQuery : mysql_query error: Table 'account.player_shop_items' doesn't exist
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps. price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype 0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2, attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,at trvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attr value6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
query: SELECT id FROM guild
SYSERR: Apr 25 06:30:11 :: DirectQuery: AsyncSQL:
query: SELECT id,map_index from player_shop WHERE channel=1 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Apr 25 06:30:11 :: DirectQuery: AsyncSQL:
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps. price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype 0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2, attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,at trvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attr value6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
that is my syserr ... idk how can i make a problem
Apr 25 11:04:22 :: SYSTEM: new connection from [90.186.20.164] fd: 17 handshake 3840212987 output input_len 0, ptr 0x4dc21000
Apr 25 11:04:23 :: Handshake: lower than zero -21
Apr 25 11:04:23 :: Handshake: client_time 0 server_time 2324273
Apr 25 11:04:23 :: LOGIN_BY_KEY: admin key 1330556939
Apr 25 11:04:23 :: SetSecurityKey decrypt 1232223541 1796245566 174118236 1532465238 encrypt 2050819568 3117630075 1748604523 2483510798
Apr 25 11:04:23 :: LoginSuccess
Apr 25 11:04:23 :: player(Boss).job(4)
Apr 25 11:04:23 :: player(asdasd).job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: success to 188.212.103.125:13099
Apr 25 11:04:23 :: success to 188.212.103.125:13099
Apr 25 11:04:23 :: InputDB::login_success: admin
Apr 25 11:04:28 :: SYSTEM: closing socket. DESC #17
Apr 25 11:04:36 :: GLOBAL_TIME: Apr 25 11:04:36 time_gap 0
Apr 25 11:04:23 :: Handshake: lower than zero -21
Apr 25 11:04:23 :: Handshake: client_time 0 server_time 2324273
Apr 25 11:04:23 :: LOGIN_BY_KEY: admin key 1330556939
Apr 25 11:04:23 :: SetSecurityKey decrypt 1232223541 1796245566 174118236 1532465238 encrypt 2050819568 3117630075 1748604523 2483510798
Apr 25 11:04:23 :: LoginSuccess
Apr 25 11:04:23 :: player(Boss).job(4)
Apr 25 11:04:23 :: player(asdasd).job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: player().job(0)
Apr 25 11:04:23 :: success to 188.212.103.125:13099
Apr 25 11:04:23 :: success to 188.212.103.125:13099
Apr 25 11:04:23 :: InputDB::login_success: admin
Apr 25 11:04:28 :: SYSTEM: closing socket. DESC #17
Apr 25 11:04:36 :: GLOBAL_TIME: Apr 25 11:04:36 time_gap 0






