Differences

This shows you the differences between two versions of the page.

--- archief:aichallenge [2015/08/02 16:50]
0.0.0.0 aangemaakt
+++ archief:aichallenge [2021/11/23 14:14] (current)
@@ Line 1: / Line 1: @@
 ====== Aichallenge ======
-=Run Server=
+== Run Server ==
- svn checkout http://ai-contest.googlecode.com/svn/trunk/ ai-contest-read-only  ;
+  svn checkout http://ai-contest.googlecode.com/svn/trunk/ ai-contest-read-only  ;
- cd ai-contest-read-only/planet_wars;
+  cd ai-contest-read-only/planet_wars;
- apt-get install python-mysqldb php5 openjdk-6-jdk openjdk-6-jre-headless mysql-server php5-mysql
+  apt-get install python-mysqldb php5 openjdk-6-jdk openjdk-6-jre-headless mysql-server php5-mysql
 Make a file called server_info.py with the contents:
- server_info = {"db_host":"localhost","db_username":"zeus","db_password":"zeus","db_name":"zeus","mail_address":"zeuswpi","mail_password":"zeus","mail_name":"zeus","mail_username":"zeus"}
+  server_info = {"db_host":"localhost","db_username":"zeus","db_password":"zeus","db_name":"zeus","mail_address":"zeuswpi","mail_password":"zeus","mail_name":"zeus","mail_username":"zeus"}
 And server_info.php with (not mail password and mail_username this time):
- <?php $server_info= array("db_host"=> "localhost","db_username"=>"root","db_password"=>"zeus","db_name"=>"zeus", "mailer_address"=>"zeuswpi","mailer_password"=>"zeus","mailer_name"=>"zeus"); ?>
+  <?php $server_info= array("db_host"=> "localhost","db_username"=>"root","db_password"=>"zeus","db_name"=>"zeus", "mailer_address"=>"zeuswpi","mailer_password"=>"zeus","mailer_name"=>"zeus"); ?>
@@ Line 17: / Line 17: @@
 Create database in mysql
- mysql -p
+  mysql -p
- create database zeus;
+  create database zeus;
- create table zeus.users(user_id MEDIUMINT NOT NULL AUTO_INCREMENT, username VARCHAR(100) ,password VARCHAR(100),email VARCHAR(100),status_id VARCHAR(100),activation_code VARCHAR(100),org_id VARCHAR(100),bio VARCHAR(100),country_id int,       created  VARCHAR(100),theme_id VARCHAR(100),activated VARCHAR(100),admin VARCHAR(100),PRIMARY KEY (user_id));
+  create table zeus.users(user_id MEDIUMINT NOT NULL AUTO_INCREMENT, username VARCHAR(100) ,password VARCHAR(100),email VARCHAR(100),status_id VARCHAR(100),activation_code VARCHAR(100),org_id VARCHAR(100),bio VARCHAR(100),country_id int,       created  VARCHAR(100),theme_id VARCHAR(100),activated VARCHAR(100),admin VARCHAR(100),PRIMARY KEY (user_id));
- create table zeus.submissions (submission_id MEDIUMINT NOT NULL AUTO_INCREMENT, user_id VARCHAR(100),status VARCHAR(100), timestamp timestamp, last_game_timestamp timestamp, language_id int,PRIMARY KEY (submission_id));
+  create table zeus.submissions (submission_id MEDIUMINT NOT NULL AUTO_INCREMENT, user_id VARCHAR(100),status VARCHAR(100), timestamp timestamp, last_game_timestamp timestamp, language_id int,PRIMARY KEY (submission_id));
- create table zeus.languages (language_id MEDIUMINT NOT NULL AUTO_INCREMENT,main_code_file VARCHAR(100),name VARCHAR(100), command VARCHAR(100), PRIMARY KEY (language_id));
+  create table zeus.languages (language_id MEDIUMINT NOT NULL AUTO_INCREMENT,main_code_file VARCHAR(100),name VARCHAR(100), command VARCHAR(100), PRIMARY KEY (language_id));
- create table zeus.maps(map_id MEDIUMINT NOT NULL AUTO_INCREMENT, name VARCHAR(100), path VARCHAR(100), priority int,PRIMARY KEY (map_id));
+  create table zeus.maps(map_id MEDIUMINT NOT NULL AUTO_INCREMENT, name VARCHAR(100), path VARCHAR(100), priority int,PRIMARY KEY (map_id));
- create table zeus.user_status_codes(status_id MEDIUMINT NOT NULL AUTO_INCREMENT, name  VARCHAR(100), PRIMARY KEY (status_id));
+  create table zeus.user_status_codes(status_id MEDIUMINT NOT NULL AUTO_INCREMENT, name  VARCHAR(100), PRIMARY KEY (status_id));
- insert into zeus.user_status_codes(name) values ('other');
+  insert into zeus.user_status_codes(name) values ('other');
- insert into zeus.user_status_codes(name) values ('zeus');
+  insert into zeus.user_status_codes(name) values ('zeus');
- create table zeus.organizations(org_id MEDIUMINT NOT NULL AUTO_INCREMENT, name VARCHAR(100),PRIMARY KEY (org_id));
+  create table zeus.organizations(org_id MEDIUMINT NOT NULL AUTO_INCREMENT, name VARCHAR(100),PRIMARY KEY (org_id));
- insert into zeus.organizations(org_id,name) values (0,'zeus');
+  insert into zeus.organizations(org_id,name) values (0,'zeus');
- create table zeus.jail_users(jail_user_id MEDIUMINT NOT NULL AUTO_INCREMENT, in_use int, username  VARCHAR(100),PRIMARY KEY (jail_user_id));
+  create table zeus.jail_users(jail_user_id MEDIUMINT NOT NULL AUTO_INCREMENT, in_use int, username  VARCHAR(100),PRIMARY KEY (jail_user_id));
- create table zeus.games(game_id MEDIUMINT NOT NULL AUTO_INCREMENT, winner int, loser int, map_id int, draw int, timestamp timestamp, player_one int, player_two int, playback_string TEXT,PRIMARY KEY (game_id));
+  create table zeus.games(game_id MEDIUMINT NOT NULL AUTO_INCREMENT, winner int, loser int, map_id int, draw int, timestamp timestamp, player_one int, player_two int, playback_string TEXT,PRIMARY KEY (game_id));
- create table zeus.leaderboards(leaderboard_id MEDIUMINT NOT NULL AUTO_INCREMENT, timestamp timestamp, algorithm_name VARCHAR(100),calculation_time int,PRIMARY KEY (leaderboard_id));
+  create table zeus.leaderboards(leaderboard_id MEDIUMINT NOT NULL AUTO_INCREMENT, timestamp timestamp, algorithm_name VARCHAR(100),calculation_time int,PRIMARY KEY (leaderboard_id));
- create table zeus.rankings (ranking_id MEDIUMINT NOT NULL AUTO_INCREMENT, leaderboard_id int, submission_id int, rank int, wins int, losses int, draws int, score int,PRIMARY KEY (ranking_id));
+  create table zeus.rankings (ranking_id MEDIUMINT NOT NULL AUTO_INCREMENT, leaderboard_id int, submission_id int, rank int, wins int, losses int, draws int, score int,PRIMARY KEY (ranking_id));
- create table zeus.countries(country_id MEDIUMINT NOT NULL AUTO_INCREMENT,name VARCHAR(100),flag_filename VARCHAR(100), PRIMARY KEY (country_id));
+  create table zeus.countries(country_id MEDIUMINT NOT NULL AUTO_INCREMENT,name VARCHAR(100),flag_filename VARCHAR(100), PRIMARY KEY (country_id));
- create table zeus.playback(playback_id MEDIUMINT NOT NULL AUTO_INCREMENT,game_id int,compressed_playback_string text, PRIMARY KEY (playback_id));
+  create table zeus.playback(playback_id MEDIUMINT NOT NULL AUTO_INCREMENT,game_id int,compressed_playback_string text, PRIMARY KEY (playback_id));
- alter table users add key 'user_id' (user_id);
+  alter table users add key 'user_id' (user_id);
 For every supported language something like this
- insert into zeus.languages(main_code_file,name,command) values ('MyBot.java','Java','java -jar MyBot.jar');
+  insert into zeus.languages(main_code_file,name,command) values ('MyBot.java','Java','java -jar MyBot.jar');
- insert into zeus.languages(main_code_file,name,command) values ('MyBot.py','Python','python MyBot.py');
+  insert into zeus.languages(main_code_file,name,command) values ('MyBot.py','Python','python MyBot.py');
 You could also add some countries.
- chmod +x generate_many_maps.sh;
+  chmod +x generate_many_maps.sh;
- ./generate_many_maps.sh;
+  ./generate_many_maps.sh;
- python add_maps_to_database.py 100
+  python add_maps_to_database.py 100
 Create some local users on your machine to add here, they need an ssh account that is set up to auto log in using the  jail_id_rsa (you might want to create a new pair)
- insert into zeus.jail_users(in_use,username) values(0,'jailuser1');
+  insert into zeus.jail_users(in_use,username) values(0,'jailuser1');
- insert into zeus.jail_users(in_use,username) values(0,'jailuser2');
+  insert into zeus.jail_users(in_use,username) values(0,'jailuser2');
 Create jail users
- create_jail_users.py 10
+  create_jail_users.py 10
 cd to planet_wars/backend and run for testing purposses:
- python compile_daemon.py 3000 &
+  python compile_daemon.py 3000 &
- python tournament_manager.py 3000 &
+  python tournament_manager.py 3000 &
- ./update_rankings.sh &
+  ./update_rankings.sh &
 You will want to put these in a cron.hourly for 3500 secs or so, update rankings should be run like every 30 minutes.