CS.RIN.RU - Steam Underground Community
http://cs.rin.ru/forum/

[Release] MasterServer (win32/linux)
http://cs.rin.ru/forum/viewtopic.php?f=15&t=53996		 Page 21 of 29
Author:  viktor6 [ Sunday, 26 Feb 2012, 16:31 ]
Post subject:  Re: MasterServer (win32/linux)
What's wrong, how to get the data to make the database

Что не так, как заставить данные вносить в БД
Consol
Spoiler
Code: Select all | Line number On/Off | Expand/Contract
  1. CS Server_plusnet starting
  2. viktor@debian:~$  INFO : MasterServer - by steamCooker
  3.  INFO : -----------------------------
  4. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  5. TRACE : Increasing DB connection pool size (1/2) /home/viktor/KS_servera/MasterServers/access.db
  6. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  7. TRACE : [DB.083527C8] Executing BEGIN EXCLUSIVE TRANSACTION
  8. TRACE : [DB.083527C8] Executing CREATE TABLE IF NOT EXISTS access (ip VARCHAR, port INTEGER, allowed VARCHAR, PRIMARY KEY(ip,port))
  9. TRACE : [DB.083527C8] Executing CREATE TABLE IF NOT EXISTS by_default (allowed VARCHAR)
  10. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default LIMIT 1
  11. TRACE : [DB.083527C8] Executing DELETE FROM by_default
  12. TRACE : [DB.083527C8] Preparing statement INSERT INTO by_default VALUES (?)
  13. TRACE : [DB.083527C8] Executing COMMIT
  14. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  15. TRACE : Opening DB connection :memory:
  16. TRACE : [DB.08352CE8] Opened DB connection
  17. TRACE : [DB.08352CE8] Executing CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address VARCHAR, _lastHeartBeat INTEGER, protocol INTEGER, players INTEGER, max INTEGER, bots INTEGER, gamedir VARCHAR, map VARCHAR, type VARCHAR, password INTEGER, os VARCHAR, secure INTEGER, lan INTEGER, version VARCHAR, region INTEGER, product VARCHAR, gameport INTEGER, specport INTEGER, dedicated INTEGER, appid INTEGER, proxy INTEGER, gdversion INTEGER, CONSTRAINT UNIQUE_GSER UNIQUE(_address))
  18. TRACE : [DB.08352CE8] Executing CREATE TABLE gameServersGametype (challenge INTEGER, gametype VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gametype))
  19. TRACE : [DB.08352CE8] Executing CREATE TRIGGER gametypeTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGametype WHERE challenge=OLD.challenge; END
  20. TRACE : [DB.08352CE8] Executing CREATE TABLE gameServersGamedata (challenge INTEGER, gamedata VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gamedata))
  21. TRACE : [DB.08352CE8] Executing CREATE TRIGGER gamedataTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGamedata WHERE challenge=OLD.challenge; END
  22. TRACE : [DB.08352CE8] Closing DB connection
  23. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/HLMasterServer.db
  24. TRACE : Increasing DB connection pool size (1/4) /home/viktor/KS_servera/MasterServers/HLMasterServer.db
  25. TRACE : [DB.083604E8] Retrieved DB connection (1 used / 1 / 4 max)
  26. TRACE : [DB.083604E8] Executing CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address VARCHAR, _lastHeartBeat INTEGER, protocol INTEGER, players INTEGER, max INTEGER, bots INTEGER, gamedir VARCHAR, map VARCHAR, type VARCHAR, password INTEGER, os VARCHAR, secure INTEGER, lan INTEGER, version VARCHAR, region INTEGER, product VARCHAR, gameport INTEGER, specport INTEGER, dedicated INTEGER, appid INTEGER, proxy INTEGER, gdversion INTEGER, CONSTRAINT UNIQUE_GSER UNIQUE(_address))
  27. TRACE : [DB.083604E8] Executing CREATE TABLE gameServersGametype (challenge INTEGER, gametype VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gametype))
  28. TRACE : [DB.083604E8] Executing CREATE TRIGGER gametypeTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGametype WHERE challenge=OLD.challenge; END
  29. TRACE : [DB.083604E8] Executing CREATE TABLE gameServersGamedata (challenge INTEGER, gamedata VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gamedata))
  30. TRACE : [DB.083604E8] Executing CREATE TRIGGER gamedataTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGamedata WHERE challenge=OLD.challenge; END
  31. TRACE : [DB.083604E8] Executing ALTER TABLE gameServers ADD COLUMN nap VARCHAR
  32. TRACE : [DB.083604E8] Executing ALTER TABLE gameServers ADD COLUMN rating INTEGER
  33. TRACE : [DB.083604E8] Executing ALTER TABLE gameServers ADD COLUMN rated_order INTEGER
  34. TRACE : [DB.083604E8] Executing CREATE TRIGGER IF NOT EXISTS rev_cs AFTER UPDATE ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET nap=10 WHERE gamedir='cstrike' AND rowid=NEW.rowid; END
  35. TRACE : [DB.083604E8] Executing CREATE TRIGGER IF NOT EXISTS init_rating AFTER INSERT ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET rating=0, rated_order=_address WHERE rowid=NEW.rowid; END
  36. TRACE : [DB.083604E8] Executing CREATE TRIGGER IF NOT EXISTS update_rating AFTER UPDATE ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET rated_order=NEW.rating || '#' || NEW._address WHERE rowid=NEW.rowid; END
  37. TRACE : [DB.083604E8] Executing BEGIN EXCLUSIVE TRANSACTION
  38. TRACE : Opening DB connection /home/viktor/KS_servera/MasterServers/servers.db
  39. TRACE : [DB.0836D5A0] Opened DB connection
  40. TRACE : [DB.0836D5A0] Executing CREATE TABLE IF NOT EXISTS servers (ip VARCHAR, port INTEGER, rank INTEGER, PRIMARY KEY(ip,port))
  41. TRACE : [DB.0836D5A0] Preparing statement SELECT ip,port,rank FROM servers
  42. TRACE : [DB.083604E8] Preparing statement SELECT count(challenge) FROM gameServers WHERE _address=?
  43. TRACE : [DB.083604E8] Preparing statement INSERT INTO gameServers (_address,_lastHeartBeat) values (?,?)
  44. TRACE : [DB.083604E8] Preparing statement SELECT challenge FROM gameServers WHERE _address=?
  45. TRACE : [DB.083604E8] Preparing statement UPDATE gameServers SET rating=? WHERE challenge=?
  46. TRACE : [DB.083604E8] Preparing statement UPDATE gameServers SET _lastHeartBeat=? WHERE challenge=?
  47. TRACE : [DB.0836D5A0] Closing DB connection
  48. TRACE : [DB.083604E8] Executing COMMIT
  49.  INFO : HL Master Server started
  50.  INFO : -----------------------------
  51.  INFO : Server status :
  52.  INFO :  HL Master Server (0.0.0.0:27010) : Online
  53. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  54. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  55. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  56. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  57. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  58. TRACE : Firewall : Access granted for 93.79.167.123:4778
  59. TRACE : [DB.083604E8] Preparing statement DELETE FROM gameServers WHERE ?-_lastHeartBeat>?
  60.  INFO : HL Master Server - Processing get Rated game servers list request from 93.79.167.123:4778
  61. TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10, last received server : 0.0.0.0:0
  62. TRACE : [DB.083604E8] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? ORDER BY rated_order DESC LIMIT ?
  63. TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  64. TRACE : HL Master Server - Finished processing get Rated game servers list request from 93.79.167.123:4778
  65. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  66. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  67. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  68. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  69. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  70. TRACE : Firewall : Access granted for 77.121.4.50:27016
  71. TRACE : [DB.083604E8] Preparing statement DELETE FROM gameServers WHERE ?-_lastHeartBeat>?
  72. DEBUG : HL Master Server - Processing set challenge info request from 77.121.4.50:27016
  73. TRACE : HL Master Server - Challenge info : \protocol\7\challenge\1330259465\players\0\max\20\bots\0\gamedir\cstrike\map\de_dust2\password\0\os\l\lan\0\region\3\gameport\27016\specport\0\dedicated\1\appid\10\type\d\secure\1\version\1.1.2.6/Stdio\product\cstrike
  74. TRACE : [DB.083604E8] Preparing statement UPDATE gameServers SET _lastHeartBeat=@_lastHeartBeat,protocol=@protocol,players=@players,max=@max,bots=@bots,gamedir=@gamedir,map=@map,type=@type,password=@password,os=@os,secure=@secure,lan=@lan,version=@version,region=@region,product=@product,gameport=@gameport,specport=@specport,dedicated=@dedicated,appid=@appid,proxy=@proxy WHERE challenge=@challenge
  75. TRACE : HL Master Server - Finished processing set challenge info request from 77.121.4.50:27016
  76. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  77. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  78. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  79. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  80. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  81. TRACE : Firewall : Access granted for 77.121.4.50:27017
  82. DEBUG : HL Master Server - Processing set challenge info request from 77.121.4.50:27017
  83. TRACE : HL Master Server - Challenge info : \protocol\7\challenge\1330259463\players\0\max\16\bots\0\gamedir\cstrike\map\gg_dust\password\0\os\l\lan\0\region\3\gameport\27017\specport\0\dedicated\1\appid\10\type\d\secure\1\version\1.1.2.6/Stdio\product\cstrike
  84. TRACE : [DB.083604E8] Preparing statement UPDATE gameServers SET _lastHeartBeat=@_lastHeartBeat,protocol=@protocol,players=@players,max=@max,bots=@bots,gamedir=@gamedir,map=@map,type=@type,password=@password,os=@os,secure=@secure,lan=@lan,version=@version,region=@region,product=@product,gameport=@gameport,specport=@specport,dedicated=@dedicated,appid=@appid,proxy=@proxy WHERE challenge=@challenge
  85. TRACE : HL Master Server - Finished processing set challenge info request from 77.121.4.50:27017
  86. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  87. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  88. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  89. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  90. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  91. TRACE : Firewall : Access granted for 77.121.4.50:27015
  92. DEBUG : HL Master Server - Processing set challenge info request from 77.121.4.50:27015
  93. TRACE : HL Master Server - Challenge info : \protocol\7\challenge\1330259495\players\0\max\20\bots\0\gamedir\cstrike\map\fy_snow_arena\password\0\os\l\lan\0\region\2\gameport\27015\specport\0\dedicated\1\appid\10\type\d\secure\1\version\1.1.2.6/Stdio\product\cstrike
  94. TRACE : [DB.083604E8] Preparing statement UPDATE gameServers SET _lastHeartBeat=@_lastHeartBeat,protocol=@protocol,players=@players,max=@max,bots=@bots,gamedir=@gamedir,map=@map,type=@type,password=@password,os=@os,secure=@secure,lan=@lan,version=@version,region=@region,product=@product,gameport=@gameport,specport=@specport,dedicated=@dedicated,appid=@appid,proxy=@proxy WHERE challenge=@challenge
  95. TRACE : HL Master Server - Finished processing set challenge info request from 77.121.4.50:27015
  96. TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  97. TRACE : [DB.083527C8] Retrieved DB connection (1 used / 1 / 2 max)
  98. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  99. TRACE : [DB.083527C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  100. TRACE : [DB.083527C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  101. TRACE : Firewall : Access granted for 93.79.167.123:4778
  102. TRACE : [DB.083604E8] Preparing statement DELETE FROM gameServers WHERE ?-_lastHeartBeat>?
  103.  INFO : HL Master Server - Processing get Rated game servers list request from 93.79.167.123:4778
  104. TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10, last received server : 0.0.0.0:0
  105. TRACE : [DB.083604E8] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? ORDER BY rated_order DESC LIMIT ?
  106. TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  107. TRACE : HL Master Server - Finished processing get Rated game servers list request from 93.79.167.123:4778
  108.  

ini
Spoiler
Code: Select all | Line number On/Off | Expand/Contract
  1. ;MasterServer - by SteamCooker
  2.  
  3. [Servers]
  4. HLMasterServer=77.121.4.50:27010
  5. ;SourceMasterServer=77.121.4.50:27011
  6. ;RDKFMasterServer=77.121.4.50:27012
  7.  
  8. [Access]
  9.  
  10. ;; static deny/allow list
  11. ;deny=127.0.0.1 192.168.1.1
  12. ;allow=127.0.0.2 192.168.1.2
  13.  
  14. ;; or dynamic access management database
  15. db=access.db
  16.  
  17. [Database]
  18. HLMasterServer=HLMasterServer.db
  19. ;SourceMasterServer=SourceMasterServer.db
  20. ;RDKFMasterServer=RDKFMasterServer.db
  21.  
  22. [Options]
  23. disableJoin=false
  24. enableRating=true
  25. traceProtocol=false
  26. ;customDatabase=./MasterServerCustomDB.so
  27.  
  28. [Logs]
  29. ;trace = 0, debug = 1, info = 2, warn = 3, error = 4, fatal = 5, off = 6
  30. Level=(int32)0
  31. LogFile=MasterServer.log
  32.  
  33. ;Static manualy defined game servers, challenge must be configured as %u
  34.  
  35. [HLMasterServer]
  36. default server info
  37. ;info=\protocol\47\challenge\%u\players\0\max\24\bots\0\gamedir\cstrike\map\de_nuke\type\d\password\0\os\w\secure\0\lan\0\version\1.1.2.5\region\255\product\cstrike
  38. ranking=(int32)0
  39. serversDb=servers.db
  40.  
  41. ;[HLMasterServer/127.0.0.1:27015]
  42. ;sample CS server
  43. ;info=\protocol\47\challenge\%u\players\0\max\24\bots\0\gamedir\cstrike\map\de_nuke\type\d\password\0\os\w\secure\0\lan\0\version\1.1.2.5\region\255\product\cstrike
  44. ;ranking=(int32)0
  45.  
  46. ;[SourceMasterServer/127.0.0.1:27015]
  47. ;sample L4D2 server
  48. ;info=\protocol\7\challenge\%u\players\0\max\4\bots\0\gamedir\left4dead2\map\c2m4_barns\password\0\os\w\lan\0\region\255\gameport\27015\specport\0\dedicated\1\gametype\coop,empty\appid\550\type\d\secure\1\version\2.0.1.1\product\left4dead2
  49. ;gamedata=\protocol\7\challenge\%u\region\255\gamedata\g:l4d2,coop,realism,survival,versus,teamversus,scavenge,teamscavenge,key:2011\gdversion\1
  50. ;ranking=(int32)0
  51.  
  52. ;[RDKFMasterServer]
  53.  

log
Spoiler
Code: Select all | Line number On/Off | Expand/Contract
  1. 2012/02/26 15:23:59 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  2. 2012/02/26 15:23:59 - TRACE : Increasing DB connection pool size (1/2) /home/viktor/KS_servera/MasterServers/access.db
  3. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  4. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Executing BEGIN EXCLUSIVE TRANSACTION
  5. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Executing CREATE TABLE IF NOT EXISTS access (ip VARCHAR, port INTEGER, allowed VARCHAR, PRIMARY KEY(ip,port))
  6. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Executing CREATE TABLE IF NOT EXISTS by_default (allowed VARCHAR)
  7. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default LIMIT 1
  8. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Executing DELETE FROM by_default
  9. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Preparing statement INSERT INTO by_default VALUES (?)
  10. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Executing COMMIT
  11. 2012/02/26 15:23:59 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  12. 2012/02/26 15:23:59 - TRACE : Opening DB connection :memory:
  13. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Opened DB connection
  14. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Executing CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address VARCHAR, _lastHeartBeat INTEGER, protocol INTEGER, players INTEGER, max INTEGER, bots INTEGER, gamedir VARCHAR, map VARCHAR, type VARCHAR, password INTEGER, os VARCHAR, secure INTEGER, lan INTEGER, version VARCHAR, region INTEGER, product VARCHAR, gameport INTEGER, specport INTEGER, dedicated INTEGER, appid INTEGER, proxy INTEGER, gdversion INTEGER, CONSTRAINT UNIQUE_GSER UNIQUE(_address))
  15. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Executing CREATE TABLE gameServersGametype (challenge INTEGER, gametype VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gametype))
  16. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Executing CREATE TRIGGER gametypeTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGametype WHERE challenge=OLD.challenge; END
  17. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Executing CREATE TABLE gameServersGamedata (challenge INTEGER, gamedata VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gamedata))
  18. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Executing CREATE TRIGGER gamedataTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGamedata WHERE challenge=OLD.challenge; END
  19. 2012/02/26 15:23:59 - TRACE : [DB.08970D10] Closing DB connection
  20. 2012/02/26 15:23:59 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/HLMasterServer.db
  21. 2012/02/26 15:23:59 - TRACE : Increasing DB connection pool size (1/4) /home/viktor/KS_servera/MasterServers/HLMasterServer.db
  22. 2012/02/26 15:23:59 - TRACE : [DB.0897E510] Retrieved DB connection (1 used / 1 / 4 max)
  23. 2012/02/26 15:23:59 - TRACE : [DB.0897E510] Executing CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address VARCHAR, _lastHeartBeat INTEGER, protocol INTEGER, players INTEGER, max INTEGER, bots INTEGER, gamedir VARCHAR, map VARCHAR, type VARCHAR, password INTEGER, os VARCHAR, secure INTEGER, lan INTEGER, version VARCHAR, region INTEGER, product VARCHAR, gameport INTEGER, specport INTEGER, dedicated INTEGER, appid INTEGER, proxy INTEGER, gdversion INTEGER, CONSTRAINT UNIQUE_GSER UNIQUE(_address))
  24. 2012/02/26 15:23:59 - TRACE : [DB.0897E510] Executing CREATE TABLE gameServersGametype (challenge INTEGER, gametype VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gametype))
  25. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing CREATE TRIGGER gametypeTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGametype WHERE challenge=OLD.challenge; END
  26. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing CREATE TABLE gameServersGamedata (challenge INTEGER, gamedata VARCHAR, CONSTRAINT GAMETYPE_PK PRIMARY KEY(challenge,gamedata))
  27. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing CREATE TRIGGER gamedataTrigger BEFORE DELETE ON gameServers BEGIN DELETE FROM gameServersGamedata WHERE challenge=OLD.challenge; END
  28. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing ALTER TABLE gameServers ADD COLUMN nap VARCHAR
  29. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing ALTER TABLE gameServers ADD COLUMN rating INTEGER
  30. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing ALTER TABLE gameServers ADD COLUMN rated_order INTEGER
  31. 2012/02/26 15:24:00 - TRACE : [DB.0897E510] Executing CREATE TRIGGER IF NOT EXISTS rev_cs AFTER UPDATE ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET nap=10 WHERE gamedir='cstrike' AND rowid=NEW.rowid; END
  32. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Executing CREATE TRIGGER IF NOT EXISTS init_rating AFTER INSERT ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET rating=0, rated_order=_address WHERE rowid=NEW.rowid; END
  33. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Executing CREATE TRIGGER IF NOT EXISTS update_rating AFTER UPDATE ON gameServers FOR EACH ROW BEGIN UPDATE gameServers SET rated_order=NEW.rating || '#' || NEW._address WHERE rowid=NEW.rowid; END
  34. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Executing BEGIN EXCLUSIVE TRANSACTION
  35. 2012/02/26 15:24:01 - TRACE : Opening DB connection /home/viktor/KS_servera/MasterServers/servers.db
  36. 2012/02/26 15:24:01 - TRACE : [DB.089905D0] Opened DB connection
  37. 2012/02/26 15:24:01 - TRACE : [DB.089905D0] Executing CREATE TABLE IF NOT EXISTS servers (ip VARCHAR, port INTEGER, rank INTEGER, PRIMARY KEY(ip,port))
  38. 2012/02/26 15:24:01 - TRACE : [DB.089905D0] Preparing statement SELECT ip,port,rank FROM servers
  39. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement SELECT count(challenge) FROM gameServers WHERE _address=?
  40. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement INSERT INTO gameServers (_address,_lastHeartBeat) values (?,?)
  41. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement SELECT challenge FROM gameServers WHERE _address=?
  42. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement UPDATE gameServers SET rating=? WHERE challenge=?
  43. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement UPDATE gameServers SET _lastHeartBeat=? WHERE challenge=?
  44. 2012/02/26 15:24:01 - TRACE : [DB.089905D0] Closing DB connection
  45. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Executing COMMIT
  46. 2012/02/26 15:24:01 -  INFO : HL Master Server started
  47. 2012/02/26 15:24:01 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  48. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  49. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  50. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  51. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  52. 2012/02/26 15:24:01 - TRACE : Firewall : Access granted for 159.224.211.167:43713
  53. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement DELETE FROM gameServers WHERE ?-_lastHeartBeat>?
  54. 2012/02/26 15:24:01 -  INFO : HL Master Server - Processing get Rated game servers list request from 159.224.211.167:43713
  55. 2012/02/26 15:24:01 - TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10\full\1\empty\1, last received server : 0.0.0.0:0
  56. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? AND players+bots<max AND players+bots>0 ORDER BY rated_order DESC LIMIT ?
  57. 2012/02/26 15:24:01 - TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  58. 2012/02/26 15:24:01 - TRACE : HL Master Server - Finished processing get Rated game servers list request from 159.224.211.167:43713
  59. 2012/02/26 15:24:01 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  60. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  61. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  62. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  63. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  64. 2012/02/26 15:24:01 - TRACE : Firewall : Access granted for 159.224.211.167:43713
  65. 2012/02/26 15:24:01 -  INFO : HL Master Server - Processing get Rated game servers list request from 159.224.211.167:43713
  66. 2012/02/26 15:24:01 - TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10\full\1\empty\1, last received server : 0.0.0.0:0
  67. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? AND players+bots<max AND players+bots>0 ORDER BY rated_order DESC LIMIT ?
  68. 2012/02/26 15:24:01 - TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  69. 2012/02/26 15:24:01 - TRACE : HL Master Server - Finished processing get Rated game servers list request from 159.224.211.167:43713
  70. 2012/02/26 15:24:01 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  71. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  72. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  73. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  74. 2012/02/26 15:24:01 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  75. 2012/02/26 15:24:01 - TRACE : Firewall : Access granted for 159.224.211.167:43713
  76. 2012/02/26 15:24:01 -  INFO : HL Master Server - Processing get Rated game servers list request from 159.224.211.167:43713
  77. 2012/02/26 15:24:01 - TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10\full\1\empty\1, last received server : 0.0.0.0:0
  78. 2012/02/26 15:24:01 - TRACE : [DB.0897E510] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? AND players+bots<max AND players+bots>0 ORDER BY rated_order DESC LIMIT ?
  79. 2012/02/26 15:24:01 - TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  80. 2012/02/26 15:24:01 - TRACE : HL Master Server - Finished processing get Rated game servers list request from 159.224.211.167:43713
  81. 2012/02/26 15:24:01 -  INFO : -----------------------------
  82. 2012/02/26 15:24:01 -  INFO : Server status :
  83. 2012/02/26 15:24:01 -  INFO :  HL Master Server (127.0.1.1:27010) : Online
  84. 2012/02/26 15:24:54 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  85. 2012/02/26 15:24:54 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  86. 2012/02/26 15:24:54 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  87. 2012/02/26 15:24:54 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  88. 2012/02/26 15:24:54 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  89. 2012/02/26 15:24:54 - TRACE : Firewall : Access granted for 77.121.4.50:27017
  90. 2012/02/26 15:24:54 - DEBUG : HL Master Server - Processing set challenge info request from 77.121.4.50:27017
  91. 2012/02/26 15:24:54 - TRACE : HL Master Server - Challenge info : \protocol\7\challenge\1330259463\players\0\max\16\bots\0\gamedir\cstrike\map\gg_dust\password\0\os\l\lan\0\region\3\gameport\27017\specport\0\dedicated\1\appid\10\type\d\secure\1\version\1.1.2.6/Stdio\product\cstrike
  92. 2012/02/26 15:24:54 - TRACE : [DB.0897E510] Preparing statement UPDATE gameServers SET _lastHeartBeat=@_lastHeartBeat,protocol=@protocol,players=@players,max=@max,bots=@bots,gamedir=@gamedir,map=@map,type=@type,password=@password,os=@os,secure=@secure,lan=@lan,version=@version,region=@region,product=@product,gameport=@gameport,specport=@specport,dedicated=@dedicated,appid=@appid,proxy=@proxy WHERE challenge=@challenge
  93. 2012/02/26 15:24:54 - TRACE : HL Master Server - Finished processing set challenge info request from 77.121.4.50:27017
  94. 2012/02/26 15:24:55 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  95. 2012/02/26 15:24:55 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  96. 2012/02/26 15:24:55 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  97. 2012/02/26 15:24:55 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  98. 2012/02/26 15:24:55 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  99. 2012/02/26 15:24:55 - TRACE : Firewall : Access granted for 77.121.4.50:27015
  100. 2012/02/26 15:24:55 - DEBUG : HL Master Server - Processing set challenge info request from 77.121.4.50:27015
  101. 2012/02/26 15:24:55 - TRACE : HL Master Server - Challenge info : \protocol\7\challenge\1330259495\players\0\max\20\bots\0\gamedir\cstrike\map\fy_snow_arena\password\0\os\l\lan\0\region\2\gameport\27015\specport\0\dedicated\1\appid\10\type\d\secure\1\version\1.1.2.6/Stdio\product\cstrike
  102. 2012/02/26 15:24:55 - TRACE : [DB.0897E510] Preparing statement UPDATE gameServers SET _lastHeartBeat=@_lastHeartBeat,protocol=@protocol,players=@players,max=@max,bots=@bots,gamedir=@gamedir,map=@map,type=@type,password=@password,os=@os,secure=@secure,lan=@lan,version=@version,region=@region,product=@product,gameport=@gameport,specport=@specport,dedicated=@dedicated,appid=@appid,proxy=@proxy WHERE challenge=@challenge
  103. 2012/02/26 15:24:55 - TRACE : HL Master Server - Finished processing set challenge info request from 77.121.4.50:27015
  104. 2012/02/26 15:25:48 - TRACE : Retrieving DB connection from pool /home/viktor/KS_servera/MasterServers/access.db
  105. 2012/02/26 15:25:48 - TRACE : [DB.089707C8] Retrieved DB connection (1 used / 1 / 2 max)
  106. 2012/02/26 15:25:48 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM by_default WHERE allowed LIKE 'false'
  107. 2012/02/26 15:25:48 - TRACE : [DB.089707C8] Preparing statement SELECT allowed FROM access WHERE ip=? AND (port=? OR port='*') AND allowed LIKE ?
  108. 2012/02/26 15:25:48 - TRACE : [DB.089707C8] Releasing DB connection from pool /home/viktor/KS_servera/MasterServers/access.db  (0 used / 1 / 2 max)
  109. 2012/02/26 15:25:48 - TRACE : Firewall : Access granted for 93.79.167.123:4778
  110. 2012/02/26 15:25:48 - TRACE : [DB.0897E510] Preparing statement DELETE FROM gameServers WHERE ?-_lastHeartBeat>?
  111. 2012/02/26 15:25:48 -  INFO : HL Master Server - Processing get Rated game servers list request from 93.79.167.123:4778
  112. 2012/02/26 15:25:48 - TRACE : HL Master Server - Requested Region 255, filter : \gamedir\cstrike\nap\10, last received server : 0.0.0.0:0
  113. 2012/02/26 15:25:48 - TRACE : [DB.0897E510] Preparing statement SELECT _address FROM gameServers   WHERE rated_order<>? AND gamedir=? AND nap=? ORDER BY rated_order DESC LIMIT ?
  114. 2012/02/26 15:25:48 - TRACE : HL Master Server - Sending Rated game servers list (0 entries)
  115. 2012/02/26 15:25:48 - TRACE : HL Master Server - Finished processing get Rated game servers list request from 93.79.167.123:4778
  116.  
Author:  mrsizif [ Monday, 27 Feb 2012, 14:17 ]
Post subject:  Re: MasterServer (win32/linux)
Hello!My english is not so good as I want,so can I ask you to explain me how to do it.))So please tell me as well as you can?I=)
For example
1.What must I do first
2.It all must be at hosting?
3.For exemple my server ip 10.10.10.10,and hosting ip 11.11.11.11 ,where i must write him or what i must do.
Or something else or what?=)
Thank you very much!=)
Author:  illpillow [ Monday, 27 Feb 2012, 15:45 ]
Post subject:  Re: MasterServer (win32/linux)
Basically you have to tell your gameserver at 10.10.10.10, that there is a masterserver at 11.11.11.11, that it should register with. For source engine games you can use setmaster command, that allows you to add a new masterserver, I'm not sure if this command also exists in goldsource engine.
Author:  mrsizif [ Monday, 27 Feb 2012, 16:06 ]
Post subject:  Re: MasterServer (win32/linux)
Оkey,I see you're from Kiev
SO let's speak russian
Anybody who can speak ruusian please))
So i must write to any cfg from masterserver my ip gmeserver?
What i must do.What cfg i must rule.

Что мне надо делать?=)
Поступательно?
На хост заливать надо что то?
Или все размещено на сервере?
Что править?



What must I rule in
MasterServer.ini??

and what must I do
with folder MasterServerCustomDB
Author:  illpillow [ Monday, 27 Feb 2012, 18:05 ]
Post subject:  Re: MasterServer (win32/linux)
I'm not from Kiev, however, you just add to your gameserver's autoexec.cfg setmaster add IP:PORT, where IP and port is your IP and port of your masterserver. When you fire up your server, it will add itself to your masterserver.
Author:  mrsizif [ Monday, 27 Feb 2012, 20:08 ]
Post subject:  Re: MasterServer (win32/linux)
Ok.But how I can start masterserver))
What must I do with other files and folders in archive?
May i use this masterserver like any cs monitorings esteblished at any hostings?
Like this ___cs-servera.net(not advert).
There for some money I can get players for my payment server.
How stuff's made?
Author:  illpillow [ Monday, 27 Feb 2012, 22:29 ]
Post subject:  Re: MasterServer (win32/linux)
You just have to extract the archive and run the MasterServer.exe file on windows or MasterServer file on linux, that's it, you may configure it before. Of course you can use this server to set up a service for gameservers.
Author:  mrsizif [ Monday, 27 Feb 2012, 22:48 ]
Post subject:  Re: MasterServer (win32/linux)
Oh!Ok it's very useful for me.
And maybe last question fo this time,where I must add ip of gameservers?
Author:  manefesto [ Tuesday, 28 Feb 2012, 09:24 ]
Post subject:  Re: MasterServer (win32/linux)
masterserver has access to a list of publications CS servers?
For example:
I set masterserver and want to publish only my servers
Is that possible?
===============
If your english is wrong then use google translate luke
Author:  mrsizif [ Tuesday, 28 Feb 2012, 13:35 ]
Post subject:  Re: MasterServer (win32/linux)
Google translete boored................))))
Author:  illpillow [ Tuesday, 28 Feb 2012, 15:18 ]
Post subject:  Re: MasterServer (win32/linux)
mrsizif
Normally you don't have to add it manually, as the gameserver adds itself to the masterserver's list. It goes like the following, simplified: Gameserver starts, reads its configuration, sends a request to the masterserver(s), masterserver get the request, add the gameserver to the list.

manefesto
What would be the use of having a masterserver, that only got a few servers in its list? It's possible though, because you can restrict access to specific addresses only.
Author:  mrsizif [ Tuesday, 28 Feb 2012, 17:42 ]
Post subject:  Re: MasterServer (win32/linux)
Stop I'm confused.
Look.
Firstly I must unpack archive to server with my gameservers?
Or it does not matter?
Secondary I must start in folder linux file MasterServer.
Thirdly must i rule something in file MasterServer.ini and what I must to do with file MasterServerCustomDB.so and folder MasterServerCustomDB?


p.s. did not think it would be so hard to understand what's what)
Author:  illpillow [ Tuesday, 28 Feb 2012, 22:54 ]
Post subject:  Re: MasterServer (win32/linux)
mrsizif wrote:
Firstly I must unpack archive to server with my gameservers?
Or it does not matter?
It does not matter.
mrsizif wrote:
Secondary I must start in folder linux file MasterServer.
Sure...
mrsizif wrote:
Thirdly must i rule something in file MasterServer.ini and what I must to do with file MasterServerCustomDB.so and folder MasterServerCustomDB?
God damn no, "you just add to your gameserver's autoexec.cfg setmaster add IP:PORT, where IP and port is your IP and port of your masterserver. When you fire up your server, it will add itself to your masterserver." (myself)
Author:  manefesto [ Wednesday, 29 Feb 2012, 06:35 ]
Post subject:  Re: MasterServer (win32/linux)
illpillow wrote:
mrsizif
Normally you don't have to add it manually, as the gameserver adds itself to the masterserver's list. It goes like the following, simplified: Gameserver starts, reads its configuration, sends a request to the masterserver(s), masterserver get the request, add the gameserver to the list.

manefesto
What would be the use of having a masterserver, that only got a few servers in its list? It's possible though, because you can restrict access to specific addresses only.

You can limit the list of addresses that have access to masterserver, but this restriction is for servers and clients.
Connecting the client and the server connection is on the same port
Author:  viktor6 [ Wednesday, 29 Feb 2012, 21:48 ]
Post subject:  Re: MasterServer (win32/linux)
Пытался сделать веб страничку вывода что есть в бд но упорно не хочет выводится

Tried to make a web page that is output to the database but does not want displayed

Code: Select all | Line number On/Off | Expand/Contract
  1. <?php
  2. //phpinfo();
  3. // Создадим новую базу данных
  4. $db = sqlite_open("HLMasterServer.db");
  5.  
  6. // Сделаем выборку данных
  7. $query = sqlite_query($db, "SELECT * FROM gameServers;");
  8. // В цикле выведем все полученные данные
  9. while ($array = sqlite_fetch_array($query))
  10. {
  11. echo($array['_address'].$array['players']." (id записи:".$array['challenge'].")<br />");
  12. }
  13. //var_dump($array);
  14. //die;
  15. sqlite_close($db);
  16. ?>
Page 21 of 29 All times are UTC + 3 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/