Tabele Mysql :|

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

Nivel 4
Mesaje: 630
Membru din: 24 Mar 2014, 14:28
Server: Metin2HyperX
Regat: Jinno
Aprecieri: 34  
Mulţumiri: 4  
 Contact:
Medalii

*Problemă/Întrebare:Habar nu am ce sa-i fac ..
Tipologie server:
*Resursă folosită:
*ServerFiles utilizat:
*Syserr:
SYSERR: Apr 25 06:30:05 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT id FROM guild
SYSERR: Apr 25 06:30:11 :: DirectQuery: AsyncSQL::DirectQuery : 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::DirectQuery : 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.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 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)


Poză:
*Detalii suplimentare:
Site : Metin2HyperX
WebSite : http://www.mt2hyperx.ro
Level maxim : 120
Descriere : PVP-Farm
Afișează semnătura
Avatar utilizator
diabolik45
Nivel 4

Nivel 4
Mesaje: 630
Membru din: 24 Mar 2014, 14:28
Server: Metin2HyperX
Regat: Jinno
Aprecieri: 34  
Mulţumiri: 4  
 Contact:
Medalii

PLAYER_SQL: localhost metin2 1234 account
to

PLAYER_SQL: localhost metin2 1234 player

Am facut si chestia asta , dar daca pun in Auth : player nu`mi mai gaseste conturile .... daca pun player la restu imi da eroare la conectare ... :|
Site : Metin2HyperX
WebSite : http://www.mt2hyperx.ro
Level maxim : 120
Descriere : PVP-Farm
Afișează semnătura
Avatar utilizator
diabolik45
Nivel 4

Nivel 4
Mesaje: 630
Membru din: 24 Mar 2014, 14:28
Server: Metin2HyperX
Regat: Jinno
Aprecieri: 34  
Mulţumiri: 4  
 Contact:
Medalii

Am modificat in fine pe acolo la auth config , ch1 core1 / 2 si am reusit de l-am pornit dar acum problema e alta .... cand ma conectez si selectez caracterul ma scoate inapoi la login ... .

Auth syserr :
Apr 25 07:28:34 :: SYSTEM: new connection from [90.186.20.164] fd: 15 handshake 2837032081 output input_len 0, ptr 0x28d38400
Apr 25 07:28:34 :: Handshake: client_time 0 server_time 95673
Apr 25 07:28:34 :: AUTH_PHASE 0x28d38400
Apr 25 07:28:34 :: InputAuth::Login : admin(5) desc 0x28d38400
Apr 25 07:28:34 :: SetLoginKey 1421623716
Apr 25 07:28:34 :: InputAuth::Login : login admin
Apr 25 07:28:34 :: QID_AUTH_LOGIN: START 1421623716 0x28d38400
Apr 25 07:28:34 :: Create_Time 0 19700101
Apr 25 07:28:34 :: Block Time -2
Apr 25 07:28:34 :: SetRemainSecs admin 0 type 2
Apr 25 07:28:34 :: SendAuthLogin admin key 2
Apr 25 07:28:34 :: AuthLogin result 1 key 1421623716
Apr 25 07:28:35 :: SYSTEM: closing socket. DESC #15
Apr 25 07:29:11 :: SYSTEM: new connection from [90.186.20.164] fd: 15 handshake 4045795134 output input_len 0, ptr 0x28d38400
Apr 25 07:29:12 :: Handshake: client_time 0 server_time 133153
Apr 25 07:29:12 :: AUTH_PHASE 0x28d38400
Apr 25 07:29:12 :: InputAuth::Login : admin(5) desc 0x28d38400
Apr 25 07:29:12 :: SetLoginKey 103043165
Apr 25 07:29:12 :: InputAuth::Login : login admin
Apr 25 07:29:12 :: QID_AUTH_LOGIN: START 103043165 0x28d38400
Apr 25 07:29:12 :: Create_Time 0 19700101
Apr 25 07:29:12 :: Block Time -2
Apr 25 07:29:12 :: SetRemainSecs admin 0 type 2
Apr 25 07:29:12 :: SendAuthLogin admin key 2
Apr 25 07:29:12 :: AuthLogin result 1 key 103043165
Apr 25 07:29:12 :: SYSTEM: closing socket. DESC #15
Ch 1 Core 1 :

Apr 25 07:28:36 :: SYSTEM: new connection from [90.186.20.164] fd: 17 handshake 3029581438 output input_len 0, ptr 0x2af48800
Apr 25 07:28:36 :: Handshake: lower than zero -20
Apr 25 07:28:36 :: Handshake: client_time 0 server_time 97556
Apr 25 07:28:36 :: LOGIN_BY_KEY: admin key 1421623716
Apr 25 07:28:36 :: SetSecurityKey decrypt 1041308512 1427921781 951618042 1533712685 encrypt 377363792 3218922136 1985563630 545813792
Apr 25 07:28:37 :: LoginSuccess
Apr 25 07:28:37 :: player(Boss).job(4)
Apr 25 07:28:37 :: player(asdasd).job(0)
Apr 25 07:28:37 :: player().job(0)
Apr 25 07:28:37 :: player().job(0)
Apr 25 07:28:37 :: player().job(0)
Apr 25 07:28:37 :: success to 188.212.103.125:13099
Apr 25 07:28:37 :: success to 188.212.103.125:13099
Apr 25 07:28:37 :: InputDB::login_success: admin
Apr 25 07:28:42 :: SYSTEM: closing socket. DESC #17
Apr 25 07:28:56 :: GLOBAL_TIME: Apr 25 07:28:56 time_gap 0
Apr 25 07:29:00 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61)
Apr 25 07:29:13 :: SYSTEM: new connection from [90.186.20.164] fd: 17 handshake 3123218601 output input_len 0, ptr 0x2af48800
Apr 25 07:29:15 :: Handshake: lower than zero -559
Apr 25 07:29:16 :: Handshake: client_time 0 server_time 137116
Apr 25 07:29:16 :: LOGIN_BY_KEY: admin key 103043165
Apr 25 07:29:16 :: SetSecurityKey decrypt 1154686839 11985134 1718167967 36420160 encrypt 277117887 2490586654 1440458415 3259659948
Apr 25 07:29:16 :: LoginSuccess
Apr 25 07:29:16 :: player(Boss).job(4)
Apr 25 07:29:16 :: player(asdasd).job(0)
Apr 25 07:29:16 :: player().job(0)
Apr 25 07:29:16 :: player().job(0)
Apr 25 07:29:16 :: player().job(0)
Apr 25 07:29:16 :: success to 188.212.103.125:13099
Apr 25 07:29:16 :: success to 188.212.103.125:13099
Apr 25 07:29:16 :: InputDB::login_success: admin
Apr 25 07:29:23 :: SYSTEM: closing socket. DESC #17
Apr 25 07:29:56 :: GLOBAL_TIME: Apr 25 07:29:56 time_gap 0
Apr 25 07:30:00 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61)
Apr 25 07:30:56 :: GLOBAL_TIME: Apr 25 07:30:56 time_gap 0
Apr 25 07:31:00 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61)
Apr 25 07:31:56 :: GLOBAL_TIME: Apr 25 07:31:56 time_gap 0
Apr 25 07:32:00 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61)
Ch 2 :
Apr 25 07:28:56 :: GLOBAL_TIME: Apr 25 07:28:56 time_gap 0
Apr 25 07:29:56 :: GLOBAL_TIME: Apr 25 07:29:56 time_gap 0
Apr 25 07:30:56 :: GLOBAL_TIME: Apr 25 07:30:56 time_gap 0
Apr 25 07:31:56 :: GLOBAL_TIME: Apr 25 07:31:56 time_gap 0
Apr 25 07:32:56 :: GLOBAL_TIME: Apr 25 07:32:56 time_gap 0
Site : Metin2HyperX
WebSite : http://www.mt2hyperx.ro
Level maxim : 120
Descriere : PVP-Farm
Afișează semnătura
Avatar utilizator
[HF]White
Metin Master

Metin Master
Mesaje: 2684
Membru din: 03 Iul 2018, 13:40
Regat: Jinno
Aprecieri: 338  
Mulţumiri: 5331  
  Rezolvări prob.: 13
Discord: Copiază ID
 Contact:
Medalii

Imagine
Închis
Răspunsuri
10
Vizualizări
852
Răspunsuri
2
Vizualizări
140
Răspunsuri
9
Vizualizări
453
Răspunsuri
1
Vizualizări
209

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

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Google [Bot] și 136 vizitatori