syslog db

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

Nivel 4
Mesaje: 677
Membru din: 03 Dec 2013, 08:42
Aprecieri: 297  
Mulţumiri: 30  
  Rezolvări prob.: 14
Medalii

*Problemă: Nu stiu daca affecteaza cu ceva sv sau ce e cu astea..apare doar in syslog din DB
Tipologie server(PvM / PvP):.....
*ServerFiles utilizat: http://just4metin.ro/serverfiles/server ... 67971.html
*Syserr: nici o erroare.

Cod: Selectaţi tot

 01:16:21 :: [QUERY : LONG INTERVAL(OverSec 1.946380)] : SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0
Apr 14 01:16:24 :: [      350] return 0/0/0 async 0/0/0
Apr 14 01:16:29 :: [      400] return 0/0/0 async 0/0/0
Apr 14 01:16:34 :: [      450] return 0/0/0 async 0/0/0
Apr 14 01:16:39 :: [      500] return 0/0/0 async 0/0/0
Apr 14 01:16:44 :: [      550] return 0/0/0 async 0/0/0
Apr 14 01:16:49 :: [      600] return 0/0/0 async 0/0/0
Apr 14 01:16:54 :: [      650] return 0/0/0 async 0/0/0
Apr 14 01:16:59 :: [      700] return 0/0/0 async 0/0/0
Apr 14 01:17:04 :: [      750] return 0/0/0 async 0/0/0
Apr 14 01:17:09 :: [      800] return 0/0/0 async 0/0/0
Apr 14 01:17:14 :: [      850] return 0/0/0 async 0/0/0
Apr 14 01:17:19 :: [      900] return 0/0/0 async 0/0/0
Apr 14 01:17:24 :: [      950] return 0/0/0 async 0/0/0
Apr 14 01:17:29 :: [     1000] return 0/0/0 async 0/0/0
Apr 14 01:17:34 :: [     1050] return 0/0/0 async 0/0/0
Apr 14 01:17:38 :: [     1100] return 0/0/0 async 0/0/0
Apr 14 01:17:43 :: [     1150] return 0/0/0 async 0/0/0
Apr 14 01:17:47 :: [QUERY : LONG INTERVAL(OverSec 3.406064)] : SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0
Apr 14 01:17:48 :: [     1200] return 0/0/0 async 0/0/0
Apr 14 01:17:51 :: [QUERY : LONG INTERVAL(OverSec 2.208146)] : SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0
Apr 14 01:17:53 :: [     1250] return 0/0/0 async 0/0/0
Apr 14 01:17:58 :: [     1300] return 0/0/0 async 0/0/0
Apr 14 01:18:03 :: [     1350] return 0/0/0 async 0/0/0
Apr 14 01:18:05 :: recved : HEADER_GD_BLOCK_COUNTRY_IP
Apr 14 01:18:05 :: HEADER_GD_BLOCK_COUNTRY_IP received
Apr 14 01:18:05 :: SendBlockedCountryIp start
Apr 14 01:18:05 :: [DONE] CBlockCountry::SendBlockedCountryIp() : count = 1
Apr 14 01:18:05 :: SendBlockedCountryIp end
Apr 14 01:18:06 :: AUTH_LOGIN id(1111) login(admin) social_id(1234567) login_key(941021875), client_key(709652744 9492970 634556912 594228982)
Apr 14 01:18:08 :: recved : HEADER_GD_BLOCK_COUNTRY_IP
Apr 14 01:18:08 :: HEADER_GD_BLOCK_COUNTRY_IP received
Apr 14 01:18:08 :: SendBlockedCountryIp start
Apr 14 01:18:08 :: [DONE] CBlockCountry::SendBlockedCountryIp() : count = 1
Apr 14 01:18:08 :: SendBlockedCountryIp end
Apr 14 01:18:08 :: [     1400] return 0/0/0 async 0/0/0
Apr 14 01:18:13 :: [     1450] return 0/0/0 async 0/0/0
Apr 14 01:18:18 :: [     1500] return 0/0/0 async 0/0/0
Apr 14 01:18:23 :: [     1550] return 0/0/0 async 0/0/0
Apr 14 01:18:28 :: [     1600] return 0/0/0 async 0/0/0
Apr 14 01:18:33 :: [     1650] return 0/0/0 async 0/0/0
Apr 14 01:18:36 :: recved : HEADER_GD_BLOCK_COUNTRY_IP
Apr 14 01:18:36 :: HEADER_GD_BLOCK_COUNTRY_IP received
Apr 14 01:18:36 :: SendBlockedCountryIp start
Apr 14 01:18:36 :: [DONE] CBlockCountry::SendBlockedCountryIp() : count = 1
Apr 14 01:18:36 :: SendBlockedCountryIp end
Apr 14 01:18:38 :: [     1700] return 0/0/0 async 0/0/0
Apr 14 01:18:43 :: [     1750] return 0/0/0 async 0/0/0
Apr 14 01:18:48 :: [     1800] return 0/0/0 async 0/0/0
Apr 14 01:18:53 :: [     1850] return 0/0/0 async 0/0/0
Apr 14 01:18:58 :: [     1900] return 0/0/0 async 0/0/0
Apr 14 01:19:01 :: recved : HEADER_GD_BLOCK_COUNTRY_IP
Apr 14 01:19:01 :: HEADER_GD_BLOCK_COUNTRY_IP received
Apr 14 01:19:01 :: SendBlockedCountryIp start
Apr 14 01:19:01 :: [DONE] CBlockCountry::SendBlockedCountryIp() : count = 1
Apr 14 01:19:01 :: SendBlockedCountryIp end
Apr 14 01:19:03 :: [     1950] return 0/0/0 async 0/0/0
Apr 14 01:19:08 :: [     2000] return 0/0/0 async 0/0/0
Apr 14 01:19:13 :: [     2050] return 0/0/0 async 0/0/0
Apr 14 01:19:18 :: [     2100] return 0/0/0 async 0/0/0
Apr 14 01:19:23 :: [     2150] return 0/0/0 async 0/0/0
Apr 14 01:19:28 :: [     2200] return 0/0/0 async 0/0/0
Apr 14 01:19:32 :: recved : HEADER_GD_BLOCK_COUNTRY_IP
Apr 14 01:19:32 :: HEADER_GD_BLOCK_COUNTRY_IP received
Apr 14 01:19:32 :: SendBlockedCountryIp start
Apr 14 01:19:32 :: [DONE] CBlockCountry::SendBlockedCountryIp() : count = 1
Apr 14 01:19:32 :: SendBlockedCountryIp end
Apr 14 01:19:33 :: [     2250] return 0/0/0 async 0/0/0
Apr 14 01:19:35 :: LOGIN_BY_KEY success admin 941021875 25.19.188.224
Apr 14 01:19:36 :: [QUERY : LONG INTERVAL(OverSec 0.689840)] : SELECT pid1, pid2, pid3, pid4, empire FROM player_index WHERE id=1111
Apr 14 01:19:36 :: RESULT_LOGIN: login success admin rows: 2
Apr 14 01:19:36 :: [GA]yonr1 960751 268553 hair 0
Apr 14 01:19:36 :: kaioken 959180 268841 hair 0
Apr 14 01:19:38 :: [     2300] return 0/0/0 async 0/0/0
Apr 14 01:19:43 :: [     2350] return 0/0/0 async 0/0/0
Apr 14 01:19:48 :: [     2400] return 0/0/0 async 0/0/0
Apr 14 01:19:53 :: [     2450] return 0/0/0 async 0/0/0
Apr 14 01:19:58 :: [     2500] return 0/0/0 async 0/0/0
Apr 14 01:20:03 :: [     2550] return 0/0/0 async 0/0/0
Apr 14 01:20:08 :: [     2600] return 0/0/0 async 0/0/0
Apr 14 01:20:13 :: [     2650] return 0/0/0 async 0/0/0
Apr 14 01:20:18 :: [     2700] return 0/0/0 async 0/0/0
Apr 14 01:20:21 :: LOGIN_BY_KEY success admin 941021875 25.19.188.224
Apr 14 01:20:21 :: RESULT_LOGIN: login success admin rows: 2
Apr 14 01:20:21 :: [GA]yonr1 960751 268553 hair 0
Apr 14 01:20:21 :: kaioken 959180 268841 hair 0
Apr 14 01:20:22 :: [PLAYER_LOAD] Load from PlayerDB pid[2830]
Apr 14 01:20:22 :: QID_PLAYER 3 2830
Apr 14 01:20:22 :: SetPlay on 941021875 admin
Apr 14 01:20:23 :: QID_ITEM 3
Apr 14 01:20:23 :: ITEM_LOAD: count 20 pid 2830
Apr 14 01:20:23 :: QID_QUEST 3
Apr 14 01:20:23 :: QUEST_LOAD: count 10 PID 2830
Apr 14 01:20:23 :: info of pLoginData1 before call ItemAwardfunction 679893632
Apr 14 01:20:23 :: QID_AFFECT 3
Apr 14 01:20:23 :: AFFECT_LOAD: count 34 PID 2830
Apr 14 01:20:23 :: [     2750] return 0/0/4 async 0/0/0
Apr 14 01:20:28 :: [     2800] return 0/0/0 async 0/0/0
Apr 14 01:20:33 :: [     2850] return 0/0/0 async 0/0/0
Apr 14 01:20:36 :: [QUERY : LONG INTERVAL(OverSec 1.161785)] : REPLACE INTO affect (dwPID, bType, bApplyOn, lApplyValue, dwFlag, lDuration, lSPCost) VALUES(2830, 515, 32, 100000, 0, 5, 0)
Apr 14 01:20:38 :: [     2900] return 0/0/0 async 0/0/0
Apr 14 01:20:43 :: [     2950] return 0/0/0 async 0/0/0
Apr 14 01:20:48 :: [     3000] return 0/0/0 async 0/0/0
Apr 14 01:20:53 :: [     3050] return 0/0/0 async 0/0/0
Apr 14 01:20:58 :: [     3100] return 0/0/0 async 0/0/0
Apr 14 01:21:03 :: [     3150] return 0/0/0 async 0/0/0
Apr 14 01:21:08 :: [     3200] return 0/0/0 async 0/0/0
Apr 14 01:21:13 :: [     3250] return 0/0/0 async 0/0/0
Apr 14 01:21:18 :: [     3300] return 0/0/0 async 0/0/0
Apr 14 01:21:23 :: [     3350] return 0/0/0 async 0/0/0
Apr 14 01:21:28 :: [     3400] return 0/0/0 async 0/0/0
Apr 14 01:21:33 :: [     3450] return 0/0/0 async 0/0/0
Apr 14 01:21:38 :: [     3500] return 0/0/0 async 0/0/0
Apr 14 01:21:40 :: SetPlay off 941021875 admin
Apr 14 01:21:43 :: [     3550] return 0/0/0 async 0/0/0
Apr 14 01:21:48 :: [     3600] return 0/0/0 async 0/0/0
Apr 14 01:21:53 :: [     3650] return 0/0/0 async 0/0/0
Apr 14 01:21:58 :: [     3700] return 0/0/0 async 0/0/0
Apr 14 01:22:03 :: [     3750] return 0/0/0 async 0/0/0
Apr 14 01:22:08 :: [     3800] return 0/0/0 async 0/0/0
Apr 14 01:22:13 :: [     3850] return 0/0/0 async 0/0/0
Apr 14 01:22:18 :: [     3900] return 0/0/0 async 0/0/0
Apr 14 01:22:23 :: [     3950] return 0/0/0 async 0/0/0
Apr 14 01:22:28 :: [     4000] return 0/0/0 async 0/0/0
Apr 14 01:22:33 :: [     4050] return 0/0/0 async 0/0/0
Apr 14 01:22:38 :: [     4100] return 0/0/0 async 0/0/0
Apr 14 01:22:43 :: [     4150] return 0/0/0 async 0/0/0
Apr 14 01:22:48 :: [     4200] return 0/0/0 async 0/0/0
Apr 14 01:22:53 :: [     4250] return 0/0/0 async 0/0/0
Apr 14 01:22:58 :: [     4300] return 0/0/0 async 0/0/0
Apr 14 01:23:03 :: [     4350] return 0/0/0 async 0/0/0
Apr 14 01:23:08 :: [     4400] return 0/0/0 async 0/0/0
Apr 14 01:23:13 :: [     4450] return 0/0/0 async 0/0/0
Apr 14 01:23:18 :: [     4500] return 0/0/0 async 0/0/0
Apr 14 01:23:23 :: [     4550] return 0/0/0 async 0/0/0
Apr 14 01:23:28 :: [     4600] return 0/0/0 async 0/0/0
Apr 14 01:23:33 :: [     4650] return 0/0/0 async 0/0/0
Apr 14 01:23:38 :: [     4700] return 0/0/0 async 0/0/0
Apr 14 01:23:43 :: [     4750] return 0/0/0 async 0/0/0
Apr 14 01:23:48 :: [     4800] return 0/0/0 async 0/0/0
Apr 14 01:23:53 :: [     4850] return 0/0/0 async 0/0/0
Apr 14 01:23:58 :: [     4900] return 0/0/0 async 0/0/0
Apr 14 01:24:03 :: [     4950] return 0/0/0 async 0/0/0
Apr 14 01:24:08 :: [     5000] return 0/0/0 async 0/0/0
Apr 14 01:24:13 :: [     5050] return 0/0/0 async 0/0/0
Apr 14 01:24:18 :: [     5100] return 0/0/0 async 0/0/0
Apr 14 01:24:23 :: [     5150] return 0/0/0 async 0/0/0
Apr 14 01:24:28 :: [     5200] return 0/0/0 async 0/0/0
Apr 14 01:24:33 :: [     5250] return 0/0/0 async 0/0/0
Apr 14 01:24:38 :: [     5300] return 0/0/0 async 0/0/0
Apr 14 01:24:43 :: [     5350] return 0/0/0 async 0/0/0
Apr 14 01:24:48 :: [     5400] return 0/0/0 async 0/0/0
Apr 14 01:24:53 :: [     5450] return 0/0/0 async 0/0/0
Apr 14 01:24:58 :: [     5500] return 0/0/0 async 0/0/0
Apr 14 01:25:03 :: [     5550] return 0/0/0 async 0/0/0
Apr 14 01:25:08 :: [     5600] return 0/0/0 async 0/0/0
Apr 14 01:25:13 :: [     5650] return 0/0/0 async 0/0/0
Apr 14 01:25:18 :: [     5700] return 0/0/0 async 0/0/0
Apr 14 01:25:23 :: [     5750] return 0/0/0 async 0/0/0
Apr 14 01:25:28 :: [     5800] return 0/0/0 async 0/0/0
Apr 14 01:25:33 :: [     5850] return 0/0/0 async 0/0/0
Apr 14 01:25:38 :: [     5900] return 0/0/0 async 0/0/0
Apr 14 01:25:43 :: [     5950] return 0/0/0 async 0/0/0
Apr 14 01:25:48 :: [     6000] return 0/0/0 async 0/0/0
Apr 14 01:25:53 :: [     6050] return 0/0/0 async 0/0/0
Apr 14 01:25:58 :: [     6100] return 0/0/0 async 0/0/0
Apr 14 01:26:03 :: [     6150] return 0/0/0 async 0/0/0
Apr 14 01:26:08 :: [     6200] return 0/0/0 async 0/0/0
Apr 14 01:26:13 :: [     6250] return 0/0/0 async 0/0/0
Apr 14 01:26:18 :: [     6300] return 0/0/0 async 0/0/0
Apr 14 01:26:23 :: [     6350] return 0/0/0 async 0/0/0
Apr 14 01:26:28 :: [     6400] return 0/0/0 async 0/0/0
Apr 14 01:26:33 :: [     6450] return 0/0/0 async 0/0/0
Apr 14 01:26:38 :: [     6500] return 0/0/0 async 0/0/0
Apr 14 01:26:43 :: [     6550] return 0/0/0 async 0/0/0
Apr 14 01:26:48 :: [     6600] return 0/0/0 async 0/0/0
Apr 14 01:26:53 :: [     6650] return 0/0/0 async 0/0/0
Apr 14 01:26:58 :: [     6700] return 0/0/0 async 0/0/0
Apr 14 01:27:03 :: [     6750] return 0/0/0 async 0/0/0
Apr 14 01:27:08 :: [     6800] return 0/0/0 async 0/0/0
Apr 14 01:27:13 :: [     6850] return 0/0/0 async 0/0/0
Apr 14 01:27:18 :: [     6900] return 0/0/0 async 0/0/0
Apr 14 01:27:23 :: [     6950] return 0/0/0 async 0/0/0
Apr 14 01:27:28 :: [     7000] return 0/0/0 async 0/0/0
Apr 14 01:27:33 :: [     7050] return 0/0/0 async 0/0/0
Apr 14 01:27:38 :: [     7100] return 0/0/0 async 0/0/0
Apr 14 01:27:43 :: [     7150] return 0/0/0 async 0/0/0
Apr 14 01:27:48 :: [     7200] return 0/0/0 async 0/0/0
Apr 14 01:27:53 :: [     7250] return 0/0/0 async 0/0/0
Apr 14 01:27:58 :: [     7300] return 0/0/0 async 0/0/0
Apr 14 01:28:03 :: [     7350] return 0/0/0 async 0/0/0
Apr 14 01:28:08 :: [     7400] return 0/0/0 async 0/0/0
Apr 14 01:28:13 :: [     7450] return 0/0/0 async 0/0/0
Apr 14 01:28:18 :: [     7500] return 0/0/0 async 0/0/0
Apr 14 01:28:23 :: [     7550] return 0/0/0 async 0/0/0
Apr 14 01:28:28 :: [     7600] return 0/0/0 async 0/0/0
Apr 14 01:28:33 :: [     7650] return 0/0/0 async 0/0/0
Apr 14 01:28:38 :: [     7700] return 0/0/0 async 0/0/0
Apr 14 01:28:43 :: [     7750] return 0/0/0 async 0/0/0
Apr 14 01:28:48 :: [     7800] return 0/0/0 async 0/0/0
Apr 14 01:28:53 :: [     7850] return 0/0/0 async 0/0/0
Apr 14 01:28:58 :: [     7900] return 0/0/0 async 0/0/0
Apr 14 01:29:03 :: [     7950] return 0/0/0 async 0/0/0
Apr 14 01:29:08 :: [     8000] return 0/0/0 async 0/0/0
Apr 14 01:29:13 :: [     8050] return 0/0/0 async 0/0/0
Apr 14 01:29:18 :: [     8100] return 0/0/0 async 0/0/0
Apr 14 01:29:23 :: [     8150] return 0/0/0 async 0/0/0
Apr 14 01:29:28 :: [     8200] return 0/0/0 async 0/0/0
Apr 14 01:29:33 :: [     8250] return 0/0/0 async 0/0/0
Apr 14 01:29:38 :: [     8300] return 0/0/0 async 0/0/0
Apr 14 01:29:43 :: [     8350] return 0/0/0 async 0/0/0
Apr 14 01:29:48 :: [     8400] return 0/0/0 async 0/0/0
Apr 14 01:29:53 :: [     8450] return 0/0/0 async 0/0/0
Apr 14 01:29:58 :: [     8500] return 0/0/0 async 0/0/0
Apr 14 01:30:03 :: [     8550] return 0/0/0 async 0/0/0
Apr 14 01:30:08 :: [     8600] return 0/0/0 async 0/0/0
Apr 14 01:30:13 :: [     8650] return 0/0/0 async 0/0/0
Apr 14 01:30:18 :: [     8700] return 0/0/0 async 0/0/0
Apr 14 01:30:23 :: [     8750] return 0/0/0 async 0/0/0
Apr 14 01:30:28 :: [     8800] return 0/0/0 async 0/0/0
Apr 14 01:30:33 :: [     8850] return 0/0/0 async 0/0/0
Apr 14 01:30:38 :: [     8900] return 0/0/0 async 0/0/0
Apr 14 01:30:43 :: [     8950] return 0/0/0 async 0/0/0
Apr 14 01:30:48 :: [     9000] return 0/0/0 async 0/0/0
Apr 14 01:30:53 :: [     9050] return 0/0/0 async 0/0/0
Apr 14 01:30:58 :: AUTH_LOGIN id(1111) login(admin) social_id(1234567) login_key(603670271), client_key(1044191599 491841109 708961660 1279346064)
Apr 14 01:30:58 :: [     9100] return 0/0/0 async 0/0/0
Apr 14 01:30:59 :: LOGIN_BY_KEY success admin 603670271 25.19.188.224
Apr 14 01:30:59 :: RESULT_LOGIN: login success admin rows: 2
Apr 14 01:30:59 :: [GA]yonr1 960175 270016 hair 0
Apr 14 01:30:59 :: kaioken 959180 268841 hair 0
Apr 14 01:31:03 :: [     9150] return 0/0/0 async 0/0/0
Apr 14 01:31:08 :: [     9200] return 0/0/0 async 0/0/0
Apr 14 01:31:08 :: LOGIN_BY_KEY success admin 603670271 25.19.188.224
Apr 14 01:31:08 :: RESULT_LOGIN: login success admin rows: 2
Apr 14 01:31:08 :: [GA]yonr1 960175 270016 hair 0
Apr 14 01:31:08 :: kaioken 959180 268841 hair 0
Apr 14 01:31:09 :: SetPlay on 603670271 admin
Apr 14 01:31:09 :: [PLAYER_LOAD] ID [GA]yonr1 pid 2830 gold 8760450892 
Apr 14 01:31:09 :: QID_QUEST 7
Apr 14 01:31:09 :: QUEST_LOAD: count 10 PID 2830
Apr 14 01:31:09 :: info of pLoginData1 before call ItemAwardfunction 679893632
Apr 14 01:31:09 :: QID_AFFECT 7
Apr 14 01:31:09 :: AFFECT_LOAD: count 34 PID 2830
Apr 14
Ultima oară modificat 21 Apr 2019, 18:00 de către yonr1, modificat 1 dată în total.
Imagine
Afișează semnătura
Avatar utilizator
Petrinel
Nivel 4

Nivel 4
Mesaje: 539
Membru din: 31 Mar 2018, 00:58
Server: Fara
Regat: Jinno
Aprecieri: 319  
Mulţumiri: 101  
Discord: Copiază ID
Medalii

Sunt doar niste log-uri.
Imagine
Afișează semnătura
Avatar utilizator
yonr1
Nivel 4

Nivel 4
Mesaje: 677
Membru din: 03 Dec 2013, 08:42
Aprecieri: 297  
Mulţumiri: 30  
  Rezolvări prob.: 14
Medalii

Petrinel scrie:Sunt doar niste log-uri.
Ma afecteaza cu ceva ?? Se pot rezolva sau asa trb sa apara ?

[ Postat de pe Android ] Imagine
Imagine
Afișează semnătura
Avatar utilizator
Inuyasha
Utilizator interzis !

Utilizator interzis !
Mesaje: 1087
Membru din: 17 Feb 2017, 22:54
Server: Metin2 Ro
Regat: Chunjo
Aprecieri: 12  
Mulţumiri: 182  
 Contact:
Medalii

Curata tabelele din navicat, urmaresti care cum e

[ Postat de pe Android ] Imagine
„Vrei să trăiești cum se cuvine? Învață mai întâi să mori.” — Confucius
Afișează semnătura
Avatar utilizator
yonr1
Nivel 4

Nivel 4
Mesaje: 677
Membru din: 03 Dec 2013, 08:42
Aprecieri: 297  
Mulţumiri: 30  
  Rezolvări prob.: 14
Medalii

Aia e in syslog in syserr e gol doar DB, tabelele navicat sant ok toate

[ Postat de pe Android ] Imagine
Imagine
Afișează semnătura
Avatar utilizator
- edward.
Nivel 5

Nivel 5
Mesaje: 879
Membru din: 08 Sep 2017, 20:53
Server: lucrez la un 2089m
Regat: Chunjo
Aprecieri: 13  
Mulţumiri: 34  
Medalii

sunt doar loguri. de aici şi numele de ''sysLOG''.
subiect arhivat.
Imagine
detalii despre serviciile tehnice oferite de mine găseşti aici.


mr digei ediţă - radio dev j4m
Afișează semnătura
Închis
Răspunsuri
3
Vizualizări
171
Răspunsuri
1
Vizualizări
156
Răspunsuri
9
Vizualizări
820

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

  • Informaţie