Zeus Wiki

User Tools

Site Tools

Trace:
archief:aichallenge

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
archief:aichallenge [2015/08/02 15:16]
0.0.0.0 aangemaakt 		archief:aichallenge [2021/11/23 14:14] (current)
Line 1: Line 1:
 ====== Aichallenge ====== ====== 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: 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): 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 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 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. 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) 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 
- create_jail_users.py 10+  create_jail_users.py 10
  
 cd to planet_wars/backend and run for testing purposses: 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. You will want to put these in a cron.hourly for 3500 secs or so, update rankings should be run like every 30 minutes.
 +
archief/aichallenge.1438528564.txt.gz · Last modified: 2021/11/23 14:01 (external edit)
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki