Completed
Push — master ( 265a2d...f9e310 )
by jerome
05:38 queued 02:58
created

Version20150613150530::insertUpData()   B

Complexity

Conditions 1
Paths 1

Size

Total Lines 36
Code Lines 5

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
c 1
b 0
f 0
dl 0
loc 36
rs 8.8571
cc 1
eloc 5
nc 1
nop 0
1
<?php
2
3
/**
4
 * This file is part of Dedipanel project
5
 *
6
 * (c) 2010-2015 Dedipanel <http://www.dedicated-panel.net>
7
 *
8
 * For the full copyright and license information, please view the LICENSE
9
 * file that was distributed with this source code.
10
 */
11
12
namespace DP\Core\DistributionBundle\Migrations;
13
14
use Doctrine\DBAL\Migrations\AbstractMigration;
15
use Doctrine\DBAL\Schema\Schema;
16
17
/**
18
 * Auto-generated Migration: Please modify to your needs!
19
 */
20
class Version20150613150530 extends AbstractMigration
21
{
22
    /**
23
     * @param Schema $schema
24
     */
25
    public function up(Schema $schema)
26
    {
27
        // this up() migration is auto-generated, please modify it to your needs
28
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30
        $this->addSql('ALTER TABLE game ADD cfgPath VARCHAR(255) DEFAULT NULL, DROP installName, DROP orangebox');
31
    
32
        $this->insertUpData();
33
    }
34
35
    /**
36
     * @param Schema $schema
37
     */
38
    public function down(Schema $schema)
39
    {
40
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
41
42
        $this->addSql('ALTER TABLE game ADD installName VARCHAR(24) NOT NULL COLLATE utf8_unicode_ci, ADD orangebox TINYINT(1) NOT NULL, DROP cfgPath');
43
    
44
        $this->insertDownData();
45
    }
46
47
    public function insertUpData()
48
    {
49
        $sql = <<<EOF
50
LOCK TABLES `game` WRITE;
51
INSERT INTO `game` VALUES
52
  (11, 'Half-Life', 1, 'valve', 'hlds_run', 90, NULL, 0, '', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/hl/', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg\r\n', 'server.cfg'),
53
  (12, 'Half-Life: Opposing Force', 1, 'gearbox', 'hlds_run', 90, 'gearbox', 0, 'op4_bootcamp', 1, NULL, '', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg\r\n', 'server.cfg'),
54
  (13, 'Ricochet', 1, 'ricochet', 'hlds_run', 90, 'ricochet', 0, 'rc_arena', 1, NULL, NULL, 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg\r\n', 'server.cfg'),
55
  (14, 'Garry''s Mod', 1, 'garrysmod', 'srcds_run', 4020, NULL, 1, 'gm_construct', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/garrysmod/', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\nsv_region            255\r\nsv_lan               0\r\nsv_logbans         1\r\nsv_logecho         1\r\nsv_logfile         1\r\nsv_log_onefile     0\r\nsv_noclipspeed     5\r\nsv_noclipaccelerate    5\r\n//Sandbox Settings\r\nsbox_allownpcs   1\r\nsbox_godmode       0\r\nsbox_plpldamage    0\r\nsbox_playergod     0\r\nsbox_noclip        1\r\nsbox_maxprops      150\r\nsbox_maxragdolls     5\r\nsbox_maxnpcs       10\r\nsbox_maxballoons  10\r\nsbox_maxeffects   50\r\nsbox_maxdynamite  10\r\nsbox_maxlamps     20\r\nsbox_maxthrusters 30\r\nsbox_maxwheels    20\r\nsbox_maxhoverballs    20\r\nsbox_maxvehicles  6\r\nsbox_maxbuttons    20\r\nsbox_maxsents     20\r\nsbox_maxemitters  5\r\nsbox_maxspawners   3\r\nsbox_maxturrets    2\r\n\r\n//Server Settings\r\nnet_maxfilesize   30\r\nsv_minrate        0\r\nsv_maxrate         2500\r\ndecalfrequency      10\r\nsv_maxupdaterate  66\r\nsv_minupdaterate  10\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg', 'cfg/server.cfg'),
56
  (15, 'Zombie Panic Source', 1, 'zps', 'srcds_run', 17505, NULL, 1, 'zpo_area41_vf2', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/hl2zp/', 'steam', NULL, 'cfg/server.cfg'),
57
  (16, 'Left 4 Dead', 1, 'left4dead', 'srcds_run', 222840, NULL, 1, 'l4d_hospital01_apartment', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/l4d/', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg', 'cfg/server.cfg'),
58
  (17, 'Left 4 Dead 2', 1, 'left4dead2', 'srcds_run', 222860, NULL, 1, 'c5m1_waterfront', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/left4dead2/', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg', 'left4dead2/cfg/server.cfg'),
59
  (18, 'Pirates, Vikings, and Knights II', 1, 'pvkii', 'srcds_run', 17575, NULL, 1, 'bt_island', 1, NULL, NULL, 'steam', NULL, 'cfg/server.cfg'),
60
  (19, 'Insurgency', 1, 'insurgency', 'srcds_linux', 17705, NULL, 1, 'ministry', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/ins/', 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg', 'cfg/server.cfg'),
61
  (20, 'Killing Floor', 1, 'KFmod.KFGameType', 'ucc-bin', 215360, NULL, 1, 'KF-bioticslab', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/kf/', 'steam', NULL, 'KillingFloor.ini'),
62
  (21, 'Just Cause 2', 1, 'justcause', 'Jcmp-Server', 261140, NULL, 0, NULL, 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/jc2/', 'steam', NULL, 'config.lua'),
63
  (22, 'Fistful of Frags', 1, 'fof', 'srcds_run', 295230, NULL, 1, 'fof_depot', 1, NULL, NULL, 'steam', '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// voice support\r\nsv_voiceenable 1\r\nsv_alltalk 1\r\n\r\n// checks assets for changes\r\nsv_pure 1\r\nsv_pure_kick_clients  1\r\n\r\n// prevents some exploits\r\nsv_allow_wait_command 0\r\n\r\n// operation\r\nsv_lan 0 \r\nsv_region 255\r\n\r\n// GAME MODES\r\nfof_sv_currentmode 1 // 1 DM\r\nmp_friendlyfire 0\r\nmp_teamplay 1\r\nmp_timelimit 15\r\n\r\nfof_sv_maxteams 4\r\n\r\n// PLAYERS\r\nmp_forcecamera 0 // 0 free roaming - 1 allow team only - 2 allow none\r\n\r\n// BOTS\r\nfof_sv_bot_slotpct 0.4\r\nfof_sv_bot_dynamicjoin 1\r\n\r\n// gun recoil\r\nfof_sv_recoilamount 0.8 // Recoil amount for handguns\r\nfof_sv_viewspring 20  // View recover speed after viewpunch\r\n\r\n// SERVER\r\nsv_Maxrate 50000\r\nsv_Minrate 50000\r\nsv_Maxupdaterate 100\r\nsv_Minupdaterate 33\r\nsv_Maxcmdrate 100\r\nsv_Mincmdrate 33\r\n\r\nsv_client_max_interp_ratio 5\r\nsv_client_min_interp_ratio 1\r\nsv_client_predict 1\r\nsv_client_interpolate 1\r\n\r\n// server logging\r\nlog on\r\nsv_logbans 1\r\nsv_logecho 1\r\nsv_logfile 1\r\nsv_log_onefile 0\r\n\r\n// execute ban files\r\nexec banned_user.cfg\r\nexec banned_ip.cfg', 'cfg/server.cfg'),
64
  (23, 'NS2: Combat', 1, 'ns2', 'server_linux32', 313900, NULL, 0, 'ns2_summit', 1, NULL, 'http://image.www.gametracker.com/images/maps/160x120/ns2/', 'steam', NULL, NULL)
65
;
66
UNLOCK TABLES;
67
68
LOCK TABLES `game` WRITE;
69
  UPDATE `game` SET cfgPath = 'server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Counter Strike';
70
  UPDATE `game` SET cfgPath = 'server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Counter-Strike: Condition Zéro';
71
  UPDATE `game` SET cfgPath = 'server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Day of Defeat';
72
  UPDATE `game` SET cfgPath = 'server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Team Fortress Classic';
73
  UPDATE `game` SET cfgPath = 'cfg/server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Counter-Strike: Source';
74
  UPDATE `game` SET cfgPath = 'cfg/server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Team Fortress 2';
75
  UPDATE `game` SET cfgPath = 'cfg/server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// Le nombre maximum de tours à jouer avant que le serveur modifications les cartes\r\nmp_maxrounds 5\r\n\r\n// Défini pour verrouiller le temps par-image qui s''écoule\r\nhost_framerate 0\r\n\r\n// Mettez l''état de pause du serveur\r\nsetpause 0\r\n\r\n// Contrôle d''où le client obtient le contenu \r\n// 0 = n''importe où, 1 = partout inscrits sur la white list, 2 = contenu Steam officielle seulement\r\nsv_pure 0\r\n\r\n// Le serveur pausable\r\nsv_pausable 0\r\n\r\n// Type de serveur 0=internet 1=lan\r\nsv_lan 0\r\n\r\n// Si le serveur applique la cohérence des fichiers pour les fichiers critiques\r\nsv_consistency 1\r\n\r\n// Collecte les statistiques d''utilisation du CPU\r\nsv_stats 1\r\n\r\n\r\n\r\n// Exécuter les utilisateur Bannis //\r\nexec banned_user.cfg\r\nexec banned_ip.cfg\r\nwriteid\r\nwriteip\r\n\r\n\r\n\r\n// Contact & Région //\r\n\r\n// Contact email pour le sysop serveur\r\nsv_contact [email protected]\r\n\r\n// La région du monde pour signaler ce serveur dedans.\r\n// -1 est le monde, 0 est la cote est des USA, 1 est la cote ouest des USA\r\n// 2 Amérique du sud, 3 Europe, 4 Asie, 5 Australie, 6 Moyen Orient, 7 Afrique\r\nsv_region 0\r\n\r\n\r\n\r\n// Paramètres Rcon //\r\n\r\n// Mot de passe pour l''authentification rcon\r\nrcon_password votremotdepasse\r\n\r\n// Nombre de minutes pour bannir les utilisateur qui échoue l''authentification rcon\r\nsv_rcon_banpenalty 1440\r\n\r\n// Le nombre maximum de fois qu''un utilisateur peut échouer l''authentification rcon avant d’être banni\r\nsv_rcon_maxfailures 5\r\n\r\n\r\n\r\n// Paramètres du journal //\r\n\r\n// Active la journalisation sur ficher, console, et udp < on | off >.\r\nlog on\r\n\r\n// Enregistrer les informations du serveur à un seul fichier.\r\nsv_log_onefile 0\r\n\r\n// Enregistrer les informations du serveur dans le fichier journal.\r\nsv_logfile 1\r\n\r\n// Journalisation des bans serveur bans dans le journal serveur.\r\nsv_logbans 1\r\n\r\n// Echo les informations du journal de la console.\r\nsv_logecho 1\r\n\r\n\r\n\r\n// Réglage de la vitesse //\r\n\r\n// Limiteur de vitesse fps\r\nfps_max 600\r\n\r\n// Bande passante minimum autorisé pour le serveur, 0 == illimitée\r\nsv_minrate 0\r\n\r\n// Bande passante maximale autorisée pour le serveur, 0 == illimitée\r\nsv_maxrate 20000\r\n\r\n// Mises à jour minimum par seconde que le serveur va permettre\r\nsv_minupdaterate 10\r\n\r\n// Mises à jour maximum par seconde que le serveur va permettre\r\nsv_maxupdaterate 66\r\n\r\n\r\n\r\n// Paramètres de téléchargement //\r\n\r\n// Permettre aux clients de télécharger des fichiers de personnalisés\r\nsv_allowupload 1\r\n\r\n// Permettre aux clients de télécharger des fichiers\r\nsv_allowdownload 1\r\n\r\n// Taille de fichier maximale autorisée pour le téléchargement en MB\r\nnet_maxfilesize 15\r\n\r\n\r\n\r\n// Équilibrage de Team //\r\n\r\n// Activer l''équilibrage de l''équipe\r\nmp_autoteambalance 1 \r\n\r\n// Temps après que les équipes soit déséquilibrer tente de changer les joueurs.\r\nmp_autoteambalance_delay 60\r\n\r\n// Temps après que les équipes soit déséquilibrer pour afficher un avertissement pour le rééquilibrage\r\nmp_autoteambalance_warning_delay 30\r\n\r\n// Teams are unbalanced when one team has this many more players than the other team. (0 disables check)\r\nmp_teams_unbalance_limit 1\r\n\r\n\r\n\r\n// Tour et temps de Jeu //\r\n\r\n// activer le timers pour attendre entre deux tours. AVERTISSEMENT: Un réglage à 0 a été connu pour causer un bug avec temps de préparation qui dure 5:20 (5 minutes 20 secondes) sur certains serveurs!\r\nmp_enableroundwaittime 1\r\n\r\n// Temps après un tour victorieux avant que le tour redémarre\r\nmp_bonusroundtime 8\r\n\r\n// Si non-zero, le tour actuel va redémarrer dans le nombre spécifié de secondes\r\nmp_restartround 0\r\n\r\n// Activer la mort subite\r\nmp_stalemate_enable 1\r\n\r\n// Limite de temps (en secondes) du tour.\r\nmp_stalemate_timelimit 300\r\n\r\n// temps de jeu par carte en minutes\r\nmp_timelimit 35\r\n\r\n\r\n\r\n// Client CVARS //\r\n\r\n// Limite au modes spectateurs pour les joueurs morts\r\nmp_forcecamera 0\r\n\r\n// permet de basculer le serveur en mode spectateur ou non\r\nmp_allowspectators 1\r\n\r\n// active le sont des pas\r\nmp_footsteps 1\r\n\r\n// active les triches du jeu\r\nsv_cheats 0\r\n\r\n// Après ce nombre de secondes sans un message d''un client, le client est expulsé\r\nsv_timeout 900\r\n\r\n// Durée maximale d''un joueur est autorisé à être inactif (en minutes), fait cela et sv_timeout parallèlement aussi?\r\nmp_idlemaxtime 15\r\n\r\n// Traite les joueurs inactifs  1=envoyer en spectateur 2=kick\r\nmp_idledealmethod 2\r\n\r\n// temps (en secondes) entre chaque sprays\r\ndecalfrequency 30\r\n\r\n\r\n\r\n// Communications //\r\n\r\n// permettre des communications vocales\r\nsv_voiceenable 1\r\n\r\n// Les joueurs peuvent entendre tous les autres joueurs, pas de restriction de team 0=off 1=on\r\nsv_alltalk 0\r\n\r\n// quantité de fois que les joueurs peuvent converser après le jeu est terminé\r\nmp_chattime 10\r\n\r\n// activer le mode fête\r\n// tf_birthday 1' WHERE name = 'Day of Defeat: Source';
76
  UPDATE `game` SET cfgPath = 'cfg/server.cfg', configTemplate = '// Created With Dedicated-Panel\r\n// Use this file to configure your DEDICATED server. \r\n// This config file is executed on server start.\r\n\r\n// disable autoaim\r\nsv_aim 0\r\n\r\n// disable clients'' ability to pause the server\r\npausable 0\r\n\r\n// default server name. Change to "Bob''s Server", etc.\r\nhostname "{{ hostname }}"\r\nsv_password "{{ svPassword }}"\r\nrcon_password "{{ rconPassword }}"\r\n\r\n// maximum client movement speed \r\nsv_maxspeed 320\r\n\r\n// 20 minute timelimit\r\nmp_timelimit 20\r\n\r\nsv_cheats 0\r\n\r\n// load ban files\r\nexec listip.cfg\r\nexec banned.cfg' WHERE name = 'Counter-Strike: Global Offensive';
77
UNLOCK TABLES;
78
79
EOF;
80
81
        $this->addSql($sql);
82
    }
83
84
    public function insertDownData()
85
    {
86
        $sql = <<<EOF
87
LOCK TABLES `game` WRITE;
88
  DELETE FROM `game` WHERE name = 'Half-Life';
89
  DELETE FROM `game` WHERE name = 'Half-Life: Opposing Force';
90
  DELETE FROM `game` WHERE name = 'Ricochet';
91
  DELETE FROM `game` WHERE name = 'Garry''s Mod';
92
  DELETE FROM `game` WHERE name = 'Zombie Panic Source';
93
  DELETE FROM `game` WHERE name = 'Left 4 Dead';
94
  DELETE FROM `game` WHERE name = 'Left 4 Dead 2';
95
  DELETE FROM `game` WHERE name = 'Pirates, Vikings, and Knights II';
96
  DELETE FROM `game` WHERE name = 'Insurgency';
97
  DELETE FROM `game` WHERE name = 'Killing Floor';
98
  DELETE FROM `game` WHERE name = 'Just Cause 2';
99
  DELETE FROM `game` WHERE name = 'Fistful of Frags';
100
  DELETE FROM `game` WHERE name = 'NS2: Combat';
101
UNLOCK TABLES;
102
103
104
LOCK TABLES `game` WRITE;
105
  UPDATE `game` SET installName = 'cstrike', configTemplate = '// Use this file to configure your DEDICATED server. \n// This config file is executed on server start.\n\n// disable autoaim\nsv_aim 0\n\n// disable clients\' ability to pause the server\npausable 0\n\n// default server name. Change to \"Bob\'s Server\", etc.\nhostname \"{{ hostname }}\"\nsv_password \"{{ svPassword }}\"\nrcon_password \"{{ rconPassword }}\"\n\n// maximum client movement speed \nsv_maxspeed 320\n\n// 20 minute timelimit\nmp_timelimit 20\n\nsv_cheats 0\n\n// load ban files\nexec listip.cfg\nexec banned.cfg\n\n' WHERE name = 'Counter Strike';
106
  UPDATE `game` SET installName = 'czero', configTemplate = '// Use this file to configure your DEDICATED server. \n// This config file is executed on server start.\n\n// disable autoaim\nsv_aim 0\n\n// disable clients\' ability to pause the server\npausable 0\n\n// default server name. Change to \"Bob\'s Server\", etc.\nhostname \"{{ hostname }}\"\nsv_password \"{{ svPassword }}\"\nrcon_password \"{{ rconPassword }}\"\n\n// maximum client movement speed \nsv_maxspeed 320\n\n// 20 minute timelimit\nmp_timelimit 20\n\nsv_cheats 0\n\n// load ban files\nexec listip.cfg\nexec banned.cfg\n' WHERE name = 'Counter-Strike: Condition Zéro';
107
  UPDATE `game` SET installName = 'dod', configTemplate = '//-----------------------------------------------\n// Server Config For Day Of Defeat v1.2 Server\n//-----------------------------------------------\n//\n// Special Thx to  [AR]-All Ready Online Network\n// for help with this server config\n\n\nhostname \"{{ hostname }}\"\nsv_password \"{{ svPassword }}\"\n//sv_spectator_password \"yourpasshere\" \nrcon_password  \"{{ rconPassword }}\"\n\n//-----------------------------------------------\n//              Server Variables\n//-----------------------------------------------\nmp_autocrosshair 0\n//mp_flashlight 1\n//mp_teamplay 11 \nmp_friendlyfire 0\nmp_fraglimit 0\nmp_timelimit 30\n\nsv_allowdownload 1\nsv_allowupload 1\nsv_cheats 0\nsv_maxspectators 4\nsv_maxrate 6000  \nsv_minrate 0  \n\ndecalfrequency 30\nfakelag 0   \nfakeloss 0\npausable 0\n\n//-----------------------------------------------\n//           Physics settings\n//-----------------------------------------------\nsv_accelerate 10\nsv_aim 0\nsv_airaccelerate 10\nsv_airmove 1\nsv_friction 4\nsv_gravity 800\nsv_bounce 1\nsv_clienttrace 3.5\nsv_clipmode 0\nsv_stepsize 18\nsv_stopspeed 100\nsv_maxspeed 500 \nsv_wateraccelerate 10\nsv_waterfriction 1\nedgefriction 2\nmp_falldamage 1    \nmp_footsteps 1\n\n//-----------------------------------------------\n//          DoD Extra settings\n//-----------------------------------------------\n//This Enables DoD\'s Netcoding\nsv_unlag 1\n\n//DoD Beta 2.0 Bullet Tracer settings\ntraceroffset 100\ntracerlength 0.45\ntracerred 1.3\ntracerblue 0.1\ntracergreen 0.7\ntraceralpha 0.45\ntracerspeed 6250\n\n//Turn on\\off Spectating Team\nmp_allowspectators 1\n\n//Turn on/off death messages\nmp_deathmsg 1\n\n// load ban files\nexec listip.cfg\nexec banned.cfg\n\nmp_alliesclasses -1\nmp_axisclasses -1\nmp_spawnbazookas 1\n' WHERE name = 'Day of Defeat';
108
  UPDATE `game` SET installName = 'tfc', configTemplate = '// Use this file to configure your DEDICATED server. \n// This config file is executed on server startup.\n\n// disable autoaim\nsv_aim 0\n\n// player bounding boxes (collisions, not clipping)\nsv_clienttrace 3.5\n\n// disable clients\' ability to pause the server\npausable 0\n\n// default server name. Change to \"Bob\'s Server\", etc.\nhostname \"{{ hostname }}\"\n\n// maximum client movement speed \nsv_maxspeed 500\n\n// Set up teamplay variables\nmp_teamplay 21\n\n// 30 minute timelimit\nmp_timelimit 30\n\n// footsteps on\nmp_footsteps 1\n\n// Turn off autoteam\ntfc_autoteam 0\n\n// Turn on a prematch\n//tfc_clanbattle 1\n//tfc_clanbattle_prematch 2\n\nsv_password \"{{ svPassword }}\"\nrcon_password \"{{ rconPassword }}\"\n\n// load ban files\nexec listip.cfg\nexec banned.cfg\n' WHERE name = 'Team Fortress Classic';
109
  UPDATE `game` SET installName = 'Counter-Strike Source', configTemplate = '// CS:S Server Config file\n// mostly the default settings with rate limits set to prevent massive lag\n// qUiCkSiLvEr\n\necho =========================\necho executing CS:S Server.cfg\necho =========================\n\nhostname \"{{ hostname }}\"\n\n// set to force players to respawn after death\nmp_forcerespawn 1\n\n// enable player footstep sounds\nmp_footsteps 1\nsv_footsteps 1 \n\n//  Bounce multiplier for when physically simulated objects collide with other objects.\nsv_bounce 0\n\n// enable flashlight\nmp_flashlight 1\n\n// enable autocrosshair (default is 1)\nmp_autocrosshair 1\n\n// allow bots\nmp_allowNPCs 1\n\n// world gravity (default 800)\nsv_gravity 800\n\n// world friction (default 4)\nsv_friction 4\n\n// world water friction (default 1)\nsv_waterfriction 1\n\n// Minimum stopping speed when on ground\nsv_stopspeed 75\n\n// spectator settings\nsv_noclipaccelerate 5\nsv_noclipspeed 5\nsv_specaccelerate 5\nsv_specspeed 3\nsv_specnoclip 1\n\n// Misc settings (leave as is)\nmp_teamplay 0 \nmp_fraglimit 0 \nmp_falldamage 0 \nmp_weaponstay 0 \n\n// Allow friendlyfire to hurt teammates (default 0)\nmp_friendlyfire 0 \n\n// player movement acceleration rates (default 5, 10 and 10)\nsv_accelerate 5 \nsv_airaccelerate 10 \nsv_wateraccelerate 10 \n\n// max player speed (default 320)\nsv_maxspeed 320\n\n// misc physics settings, leave them as-is\nsv_rollspeed 200 \nsv_rollangle 0 \n\n// player steps and stepsize - dont mess with this (default 18)\nsv_stepsize 18 \n\n// misc default vehicle settings (leave these alone)\n//r_VehicleViewDampen 1 \n//r_JeepViewDampenFreq 7.0 \n//r_JeepViewDampenDamp 1.0 \n//r_JeepViewZHeight 10.0 \n//r_AirboatViewDampenFreq 7.0 \n//r_AirboatViewDampenDamp 1.0 \n//r_AirboatViewZHeight 0.0 \n\n// teamplay talk all (1) or team only (0)\nsv_alltalk 0\n\n// enable voice on server\nsv_voiceenable 1\n\n// disable pause on server (set this to 0 always)\nsv_pausable 0\n\n// disable cheats (set this to 0 always)\nsv_cheats 0\n\n// teamserver coop (default 0)\ncoop 0\n\n// deathmatch - set this to 1\ndeathmatch 1\n\n// allow players to upload sprays (default 1)\nsv_allowupload 1\n\n// allow sprays and map content to be downloaded (default 1)\nsv_allowdownload 1\n\n// how often players can spray tags (default 20)\ndecalfrequency 30\n\n// fast http download url address\n//sv_downloadurl\n\n// Enable instanced baselines - Saves network overhead\nsv_instancebaselines 1\n\n//Force server side preloading (default 0)\nsv_forcepreload 1\n\n// set timelimit before map change\n//mp_timelimit 30\n\n// How many minutes each round takes (min. 1.000000 max. 9.000000)\nmp_roundtime 5\n\n// Max bandwidth rate allowed on server, 0 == unlimited\nsv_maxrate 9999\n\n// Min bandwidth rate allowed on server, 0 == unlimited\nsv_minrate 5000\n\n// Maximum updates per second that the server will allow (default 60)\nsv_maxupdaterate 30\n\n// Minimum updates per second that the server will allow (default 10)\nsv_minupdaterate 10\n\n// Maximum lag compensation in seconds (min. 0.000000 max. 1.000000)\nsv_maxunlag 1\n\n// Maximum speed any ballistically moving object is allowed to attain per axis (default 3500)\nsv_maxvelocity 3000\n\n// rcon failure settings\n//Number of minutes to ban users who fail rcon authentication\nsv_rcon_banpenalty 0\n\n//Number of minutes to ban users who fail rcon authentication\nsv_rcon_maxfailures 10\n\n// Number of times a user can fail rcon authentication in sv_rcon_minfailuretime before being banned\nsv_rcon_minfailures 5\n\n// Number of seconds to track failed rcon authentications\nsv_rcon_minfailuretime 30\n\n//The region of the world to report this server in (255 = world)\nsv_region 255\n\n// gather server statistics\nsv_stats 1\n\n//After this many seconds without a message from a client, the client is dropped (default 65)\nsv_timeout 65\n\n//Enables player lag compensation\nsv_unlag 1\n\n//Specifies which voice codec DLL to use in a game. Set to the name of the DLL without the extension\nsv_voicecodec vaudio_miles\n\n//Enables HLTV on this server\nsv_hltv 0\n\n//toggles whether the server allows spectator mode or not\nmp_allowspectators 1\n\n// If set to 1 then Server is a lan server ( no heartbeat, no authentication, no non-class C addresses, 9999.0 rate, etc. )\n// set to 0 for internet server\nsv_lan 0\n\n// Server contact name / url / email\nsv_contact \"\"\n\n// server password for players to join (default \"\")\nsv_password \"{{ svPassword  }}\"\n\nrcon_password \"{{ rconPassword }}\" \n\n// execute SteamID based ban list\nexec banned_user.cfg\n\n// execute IP based ban list\nexec banned_ip.cfg\n\n// Set packet filtering by IP mode (default 1)\nsv_filterban 1\n\n// log all bans in logfile\nsv_logbans 1\n\n// here are a few useful alias\n//exec alias.cfg\n//exec rate.cfg\n\n// enable logging and start log file\nsv_logfile 1\nlog on\n' WHERE name = 'Counter-Strike: Source';
110
  UPDATE `game` SET installName = 'tf', configTemplate = '// Paramètres générales //\n\n// Nom d\'hôte du serveur.\nhostname \"{{ hostname }}\"\n\n// Remplace les joueurs max rapportés par des clients potentiels\nsv_visiblemaxplayers 24\n\n// Le nombre maximum de tours à jouer avant que le serveur modifications les cartes\nmp_maxrounds 5\n\n// Défini pour verrouiller le temps par-image qui s\'écoule\nhost_framerate 0\n\n// Mettez l\'état de pause du serveur\nsetpause 0\n\n// Contrôle d\'où le client obtient le contenu \n// 0 = n\'importe où, 1 = partout inscrits sur la white list, 2 = contenu Steam officielle seulement\nsv_pure 0\n\n// Le serveur pausable\nsv_pausable 0\n\n// Type de serveur 0=internet 1=lan\nsv_lan 0\n\n// Si le serveur applique la cohérence des fichiers pour les fichiers critiques\nsv_consistency 1\n\n// Collecte les statistiques d\'utilisation du CPU\nsv_stats 1\n\n\n\n// Exécuter les utilisateur Bannis //\nexec banned_user.cfg\nexec banned_ip.cfg\nwriteid\nwriteip\n\n\n\n// Contact & Région //\n\n// Contact email pour le sysop serveur\nsv_contact [email protected]\n\n// La région du monde pour signaler ce serveur dedans.\n// -1 est le monde, 0 est la cote est des USA, 1 est la cote ouest des USA\n// 2 Amérique du sud, 3 Europe, 4 Asie, 5 Australie, 6 Moyen Orient, 7 Afrique\nsv_region 0\n\n\nsv_password \"{{ svPassword }}\"\n\n\n// Paramètres Rcon //\n\n// Mot de passe pour l\'authentification rcon\nrcon_password \"{{ rconPassword }}\"\n\n// Nombre de minutes pour bannir les utilisateur qui échoue l\'authentification rcon\nsv_rcon_banpenalty 1440\n\n// Le nombre maximum de fois qu\'un utilisateur peut échouer l\'authentification rcon avant d’être banni\nsv_rcon_maxfailures 5\n\n\n\n// Paramètres du journal //\n\n// Active la journalisation sur ficher, console, et udp < on | off >.\nlog on\n\n// Enregistrer les informations du serveur à un seul fichier.\nsv_log_onefile 0\n\n// Enregistrer les informations du serveur dans le fichier journal.\nsv_logfile 1\n\n// Journalisation des bans serveur bans dans le journal serveur.\nsv_logbans 1\n\n// Echo les informations du journal de la console.\nsv_logecho 1\n\n\n\n// Réglage de la vitesse //\n\n// Limiteur de vitesse fps\nfps_max 600\n\n// Bande passante minimum autorisé pour le serveur, 0 == illimitée\nsv_minrate 0\n\n// Bande passante maximale autorisée pour le serveur, 0 == illimitée\nsv_maxrate 20000\n\n// Mises à jour minimum par seconde que le serveur va permettre\nsv_minupdaterate 10\n\n// Mises à jour maximum par seconde que le serveur va permettre\nsv_maxupdaterate 66\n\n\n\n// Paramètres de téléchargement //\n\n// Permettre aux clients de télécharger des fichiers de personnalisés\nsv_allowupload 1\n\n// Permettre aux clients de télécharger des fichiers\nsv_allowdownload 1\n\n// Taille de fichier maximale autorisée pour le téléchargement en MB\nnet_maxfilesize 15\n\n\n\n// Équilibrage de Team //\n\n// Activer l\'équilibrage de l\'équipe\nmp_autoteambalance 1 \n\n// Temps après que les équipes soit déséquilibrer tente de changer les joueurs.\nmp_autoteambalance_delay 60\n\n// Temps après que les équipes soit déséquilibrer pour afficher un avertissement pour le rééquilibrage\nmp_autoteambalance_warning_delay 30\n\n// Teams are unbalanced when one team has this many more players than the other team. (0 disables check)\nmp_teams_unbalance_limit 1\n\n\n\n// Tour et temps de Jeu //\n\n// activer le timers pour attendre entre deux tours. AVERTISSEMENT: Un réglage à 0 a été connu pour causer un bug avec temps de préparation qui dure 5:20 (5 minutes 20 secondes) sur certains serveurs!\nmp_enableroundwaittime 1\n\n// Temps après un tour victorieux avant que le tour redémarre\nmp_bonusroundtime 8\n\n// Si non-zero, le tour actuel va redémarrer dans le nombre spécifié de secondes\nmp_restartround 0\n\n// Activer la mort subite\nmp_stalemate_enable 1\n\n// Limite de temps (en secondes) du tour.\nmp_stalemate_timelimit 300\n\n// temps de jeu par carte en minutes\nmp_timelimit 35\n\n\n\n// Client CVARS //\n\n// Limite au modes spectateurs pour les joueurs morts\nmp_forcecamera 0\n\n// permet de basculer le serveur en mode spectateur ou non\nmp_allowspectators 1\n\n// active le sont des pas\nmp_footsteps 1\n\n// active les triches du jeu\nsv_cheats 0\n\n// Après ce nombre de secondes sans un message d\'un client, le client est expulsé\nsv_timeout 900\n\n// Durée maximale d\'un joueur est autorisé à être inactif (en minutes), fait cela et sv_timeout parallèlement aussi?\nmp_idlemaxtime 15\n\n// Traite les joueurs inactifs  1=envoyer en spectateur 2=kick\nmp_idledealmethod 2\n\n// temps (en secondes) entre chaque sprays\ndecalfrequency 30\n\n\n\n// Communications //\n\n// permettre des communications vocales\nsv_voiceenable 1\n\n// Les joueurs peuvent entendre tous les autres joueurs, pas de restriction de team 0=off 1=on\nsv_alltalk 0\n\n// quantité de fois que les joueurs peuvent converser après le jeu est terminé\nmp_chattime 10\n' WHERE name = 'Team Fortress 2';
111
  UPDATE `game` SET installName = 'dod', configTemplate = '// General server name, passwords and contact details\nhostname \"{{ hostname }}\"\nrcon_password \"{{ rconPassword }}\"\nsv_password \"{{ svPassword }}\"\nsv_contact \"\"\nsv_tags \"\"\nsv_region \"255\"\nsv_lan \"0\"\n\n// Server bans and server logs\nsv_rcon_banpenalty \"15\"\nsv_rcon_minfailures \"5\"\nsv_rcon_maxfailures \"10\"\nsv_rcon_minfailuretime \"30\"\nsv_rcon_maxpacketsize \"1024\"\nsv_rcon_maxpacketbans \"1\"\nlog \"on\"\nsv_logbans \"1\"\nsv_logecho \"1\"\nsv_logfile \"1\"\nsv_log_onefile \"0\"\nmp_logdetail \"3\"\n \n// Server downloads and files\n// No fast download maximum file size. 16 is def. 64 (max) recommended if you do not have a fast download server.\nnet_maxfilesize \"64\"\n//Fast download url. Leave blank if you dont have one but set the above to max.\nsv_downloadurl \"\"\nsv_allowdownload \"1\"\nsv_allowupload \"1\"\nsv_consistency \"1\"\nsv_pure \"2\"\nsv_pure_kick_clients \"0\"\nsv_pure_trace \"0\"\n\n// Bandwidth Rates\nsv_maxrate \"50000\"\nsv_minrate \"7500\"\nsv_maxupdaterate \"66\"\nsv_minupdaterate \"20\"\nsv_maxcmdrate \"66\"\nsv_mincmdrate \"30\"\n\n// General server settings\nmp_friendlyfire \"0\"\nsv_alltalk \"0\"\nmp_chattime \"10\"\nsv_use_steam_voice \"1\"\nsv_allow_voice_from_file \"0\"\nsv_voiceenable \"1\"\nmp_allowspectators \"1\"\nmp_timelimit \"25\"\ndecalfrequency \"10\"\nmp_flashlight \"1\"\nmp_footsteps \"1\"\nmp_autokick \"0\"\nmp_limitteams \"2\"\nsv_restrict_aspect_ratio_fov \"0\"\nmp_forcecamera \"1\"\nsv_cheats \"0\"\nsv_pausable \"0\"\nsv_allow_wait_command \"0\"\nmp_falldamage \"0\"\nmp_fadetoblack \"0\"\n\n// Movement speed and feel\nsv_gravity \"800\"\nsv_friction \"4\"\nsv_stopspeed \"100\"\n\n// DoD:S specific Gameplay and server settings\n//(ONLY found in DoD:S)\ndod_freezecam \"1\"\ndod_bonusround \"1\"\ndod_bonusroundtime \"15\"\n\n// Class Restrictions\nmp_allowrandomclass \"1\"\n\n// Allies Class Restrictions\nmp_limit_allies_rifleman \"-1\"\nmp_limit_allies_assault  \"-1\"\nmp_limit_allies_support \"-1\"\nmp_limit_allies_sniper \"-1\"\nmp_limit_allies_mg \"-1\"\nmp_limit_allies_rocket \"-1\"\n\n// Axis Class Restrictions \nmp_limit_axis_rifleman \"-1\"\nmp_limit_axis_assault  \"-1\"\nmp_limit_axis_support \"-1\"\nmp_limit_axis_sniper \"-1\"\nmp_limit_axis_mg \"-1\"\nmp_limit_axis_rocket \"-1\"\n \n// Execute ban files\nexec banned_user.cfg\nexec banned_ip.cfg\nwriteid\nwriteip\n' WHERE name = 'Day of Defeat: Source';
112
  UPDATE `game` SET installName = 'csgo', configTemplate = 'hostname \"{{ hostname }}\"\nrcon_password \"{{ rconPassword }}\"\nsv_password \"{{ svPassword }}\"\nlog on\n\nmp_freezetime 5 //The amount of time players are frozen to buy items\nmp_join_grace_time 15 //The amount of time players can join teams after a round has started\nsv_cheats 0 //This should always be set, so you know it\'s not on\nsv_lan 0 //This should always be set, so you know it\'s not on\n//**The bot commands below are mostly default with the exception of \nbot_difficulty 1\nbot_chatter \"off\"\nbot_join_after_player 1\nbot_quota 0\nbot_quota_mode \"fill\"\n//**The following commands manage kicks and bans\nwriteid\nwriteip\nexec banned_user.cfg\nexec banned_ip.cfg\n' WHERE name = 'Counter-Strike: Global Offensive';
113
  UPDATE `game` SET installName = 'minecraft' WHERE name = 'Minecraft';
114
  UPDATE `game` SET installName = 'bukkit' WHERE name = 'Minecraft Bukkit';
115
UNLOCK TABLES;
116
117
EOF;
118
119
        $this->addSql($sql);
120
    }
121
}