Aichallenge
Run Server
svn checkout http://ai-contest.googlecode.com/svn/trunk/ ai-contest-read-only ; cd ai-contest-read-only/planet_wars; 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"}
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"); ?>
Set the submission_directory in www/check_submit.php and backend/compile_daemon and give www-data all permissions to it
Change the link in planet_wars/viz/Viewer.java and recompile the jar.
Create database in mysql
mysql -p 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.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.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)); insert into zeus.user_status_codes(name) values ('other'); 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)); 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.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.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.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);
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.py','Python','python MyBot.py');
You could also add some countries.
chmod +x generate_many_maps.sh; ./generate_many_maps.sh; 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,'jailuser2');
Create jail users
create_jail_users.py 10
cd to planet_wars/backend and run for testing purposses:
python compile_daemon.py 3000 & python tournament_manager.py 3000 & ./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.