Advertisement
Vearie

BZ2 Master Server - BZ2MySQL_Setup.txt

Feb 3rd, 2015
433
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.25 KB | None | 0 0
  1. Written for: v2.0
  2.  
  3. If possible, you should create a database and
  4. user account dedicated to the BZ2 gamelist.
  5. Create a database named "bz2_gamelist", or if you have
  6. renamed $sqlDatabase in the php script use that.
  7.  
  8. In the database, create a table called "gamelist".
  9.  
  10. Create the following columns: (View text with a monospace font! (e.g. Fixedsys, Consolas)
  11. [COLUMN NAME] |[DATA TYPE] |[NOTE] |[NOT NULL] |[DESCRIPTION]
  12. __lastUpdate |bigint | |YES |Unix timestamp of last POST sent by client.
  13. __timeoutSec |int | |YES |Seconds to wait for POST update, otherwise time out the game.
  14. __rowPW |varchar(16) | |YES |Authentication so others can't remove our game.
  15. __clientReqId |bigint | |YES |Client unique ID.
  16. __rowId |bigint |Primary Key. |YES |ID of row.
  17. __addr |varchar(21) | |YES |IP:Port
  18. gsoff |tinyint |DEFAULT: 0 |YES |Flag to show/hide game.
  19. n |varchar(256) | |YES |Name of client game session.
  20. m |varchar(68) | |YES |Name of client map, no bzn extension.
  21. k |tinyint | | |Password Flag.
  22. d |varchar(16) | | |MODSLISTCRC_KEY
  23. t |tinyint | | |NATTYPE_KEY
  24. r |varchar(16) | | |PRIVATEADDRESS_KEY
  25. v |varchar(8) | | |GAMEVERSION_KEY
  26. p |varchar(16) | | |GAMEPORT_KEY
  27.  
  28. You can keep this file for reference, or delete it.
  29.  
  30. MySQL Command:
  31. USE bz2_gamelist;
  32. CREATE TABLE gamelist (
  33. __lastUpdate bigint(8) unsigned not null,
  34. __timeoutSec int(3) unsigned not null,
  35. __rowPW varchar(16) not null,
  36. __clientReqId bigint(8) unsigned not null,
  37. __rowId bigint(8) unsigned auto_increment primary key not null,
  38. __addr varchar(21) not null,
  39. gsoff tinyint(1) DEFAULT 0 not null,
  40. n varchar(256) not null,
  41. m varchar(68) not null,
  42. k tinyint(1),
  43. d varchar(16),
  44. t tinyint(1),
  45. r varchar(16),
  46. v varchar(8),
  47. p varchar(16)
  48. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement