Galaxietool Changelog

"; } mysql_connect($dbhost,$dbusername,$dbpassword) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); // Tabelle fï¿½r die Galaxieansichten+ echo "Create Table for galaxie view...\n"; $query = "CREATE TABLE ".$dbtablename." ( galaxie int(2) NOT NULL default '0', system int(3) NOT NULL default '0', planet int(2) NOT NULL default '0', mond char(1) NOT NULL default , coordinates varchar(9) NOT NULL default , mondgr smallint(5) unsigned NOT NULL default '0', metall int(10) unsigned NOT NULL default '0', kristall int(10) unsigned NOT NULL default '0', ally varchar(10) NOT NULL default , planetname varchar(20) NOT NULL default , spielername varchar(30) NOT NULL default , ogame_playerid int(11) unsigned NOT NULL default '0', status varchar(5) NOT NULL default , zeit varchar(20) NOT NULL default , userid smallint(6) unsigned NOT NULL default '0', notices enum('true','false') NOT NULL default 'false', reports enum('true','false') NOT NULL default 'false', PRIMARY KEY (galaxie,system,planet), KEY spielername (spielername), KEY ally (ally), KEY status (status), KEY coordinates (coordinates) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; // Tabelle fï¿½r die Benutzerverwaltung echo "Create Table for users...\n"; $query = "CREATE TABLE $utablename ( id smallint(10) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default , userpass varchar(32) NOT NULL default , ogame_playerid int(11) unsigned NOT NULL default '0', email varchar(50) NOT NULL default , ingame varchar(20) NOT NULL default , allytag varchar(10) NOT NULL default , stylepath varchar(255) NOT NULL default , cansearch enum('true','false') NOT NULL default 'false', caninsert enum('true','false') NOT NULL default 'false', statusview enum('true','false') NOT NULL default 'false', probeview enum('true','false') NOT NULL default 'false', userman enum('true','false') NOT NULL default 'false', allyhistory enum('true','false') NOT NULL default 'false', diplomatic enum('true','false') NOT NULL default 'false', status enum('email','admin','active') NOT NULL default 'email', logins smallint(5) unsigned NOT NULL default '0', lastlogin datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY username (username) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; // Adminuser eintragen echo "Create first user (admin) ...\n"; $query = "INSERT INTO $utablename (id, username, userpass, stylepath, cansearch, caninsert, statusview, probeview, userman, allyhistory, diplomatic, status) VALUES (1, 'admin', md5('galatool'),'styles.css', 'true', 'true', 'true', 'true', 'true', 'true', 'true', 'active')"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for Playerstats...\n"; $query = "CREATE TABLE $pstablename ( `playername` varchar(30) NOT NULL default , `ally` varchar(30) NOT NULL default , `ogame_playerid` int(11) unsigned NOT NULL default '0', `rank` smallint(5) unsigned NOT NULL default '0', `points` int(10) unsigned NOT NULL default '0', `frank` smallint(5) unsigned NOT NULL default '0', `fpoints` int(10) unsigned NOT NULL default '0', `rrank` smallint(5) unsigned NOT NULL default '0', `rpoints` int(10) unsigned NOT NULL default '0', `last_update` varchar(20) NOT NULL default , PRIMARY KEY (`playername`), UNIQUE KEY `ogame_playerid` (`ogame_playerid`) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for Allystats...\n"; $query = "CREATE TABLE $astablename ( `allyname` varchar(30) NOT NULL default , `rank` smallint(5) unsigned NOT NULL default '0', `points` int(10) unsigned NOT NULL default '0', `frank` smallint(5) unsigned NOT NULL default '0', `fpoints` int(10) unsigned NOT NULL default '0', `rrank` smallint(5) unsigned NOT NULL default '0', `rpoints` int(10) unsigned NOT NULL default '0', `members` smallint(5) unsigned NOT NULL default '0', `allystatus` enum('nap','ally','war','boycott','neutral','nothing','own','wing') NOT NULL default 'nothing', `last_update` varchar(20) NOT NULL default , PRIMARY KEY (`allyname`) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for notices...\n"; $query = "CREATE TABLE $noticetable ( id int(11) NOT NULL auto_increment, userid smallint(6) NOT NULL default '0', public enum('true','false') NOT NULL default 'true', noticetext text NOT NULL, coordinates varchar(9) NOT NULL default , timevalue varchar(20) NOT NULL default , PRIMARY KEY (id), UNIQUE KEY coordinates (coordinates,userid), KEY userid (userid), KEY public (public), KEY coordinates_2 (coordinates) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for Reports...\n"; $query = "CREATE TABLE $reporttable ( id int(10) unsigned NOT NULL auto_increment, coordinates varchar(9) NOT NULL default , moon enum('true','false') NOT NULL default 'false', metal int(10) unsigned NOT NULL default '0', crystal int(10) unsigned NOT NULL default '0', deuterium int(10) unsigned NOT NULL default '0', energy int(10) unsigned NOT NULL default '0', kt mediumint(8) unsigned NOT NULL default '0', gt mediumint(8) unsigned NOT NULL default '0', lj mediumint(8) unsigned NOT NULL default '0', sj mediumint(8) unsigned NOT NULL default '0', krz mediumint(8) unsigned NOT NULL default '0', ss mediumint(8) unsigned NOT NULL default '0', kolo mediumint(8) unsigned NOT NULL default '0', rec mediumint(8) unsigned NOT NULL default '0', spio mediumint(8) unsigned NOT NULL default '0', bomb mediumint(8) unsigned NOT NULL default '0', zerri mediumint(8) unsigned NOT NULL default '0', ds mediumint(8) unsigned NOT NULL default '0', sat mediumint(8) unsigned NOT NULL default '0', rak mediumint(8) unsigned NOT NULL default '0', ll mediumint(8) unsigned NOT NULL default '0', sl mediumint(8) unsigned NOT NULL default '0', ion mediumint(8) unsigned NOT NULL default '0', gauss mediumint(8) unsigned NOT NULL default '0', plasma mediumint(8) unsigned NOT NULL default '0', ksk mediumint(8) unsigned NOT NULL default '0', gsk mediumint(8) unsigned NOT NULL default '0', arak mediumint(8) unsigned NOT NULL default '0', irak mediumint(8) unsigned NOT NULL default '0', memi tinyint(3) unsigned NOT NULL default '0', krimi tinyint(3) unsigned NOT NULL default '0', deutsyn tinyint(3) unsigned NOT NULL default '0', solar tinyint(3) unsigned NOT NULL default '0', fusion tinyint(3) unsigned NOT NULL default '0', robo tinyint(3) unsigned NOT NULL default '0', nani tinyint(3) unsigned NOT NULL default '0', rawe tinyint(3) unsigned NOT NULL default '0', mesp tinyint(3) unsigned NOT NULL default '0', krissp tinyint(3) unsigned NOT NULL default '0', deutsp tinyint(3) unsigned NOT NULL default '0', folab tinyint(3) unsigned NOT NULL default '0', terra tinyint(3) unsigned NOT NULL default '0', allydep tinyint(3) unsigned NOT NULL default '0', raksilo tinyint(3) unsigned NOT NULL default '0', mbase tinyint(3) unsigned NOT NULL default '0', sensor tinyint(3) unsigned NOT NULL default '0', sprungtor tinyint(3) unsigned NOT NULL default '0', spiolvl tinyint(3) unsigned NOT NULL default '0', computech tinyint(3) unsigned NOT NULL default '0', waffentech tinyint(3) unsigned NOT NULL default '0', schildtech tinyint(3) unsigned NOT NULL default '0', rpz tinyint(3) unsigned NOT NULL default '0', energytech tinyint(3) unsigned NOT NULL default '0', hypertech tinyint(3) unsigned NOT NULL default '0', vbt tinyint(3) unsigned NOT NULL default '0', impulse tinyint(3) unsigned NOT NULL default '0', hra tinyint(3) unsigned NOT NULL default '0', lasertech tinyint(3) unsigned NOT NULL default '0', iontech tinyint(3) unsigned NOT NULL default '0', plasmatech tinyint(3) unsigned NOT NULL default '0', forschungsnetz tinyint(3) unsigned NOT NULL default '0', gravi tinyint(3) unsigned NOT NULL default '0', fleet_resis bigint(20) unsigned NOT NULL default '0', defence_resis bigint(20) unsigned NOT NULL default '0', scantime varchar(14) NOT NULL default , scanned enum('ressources','fleet','defence','buildings','research') NOT NULL default 'ressources', PRIMARY KEY (id), UNIQUE KEY coordinates_2 (coordinates,moon) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for IP Addresses...\n"; $query = "CREATE TABLE $iptablename ( id int(10) unsigned NOT NULL auto_increment, userid smallint(5) unsigned NOT NULL default '0', ip varchar(15) NOT NULL default , logintime datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for Shoutbox...\n"; $query = "CREATE TABLE $shouttable ( id mediumint(8) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default , shouttext varchar(255) NOT NULL default , shoutdate datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Create Table for Allyhistory...\n"; $query = "CREATE TABLE $allyhistory ( id int(10) unsigned NOT NULL auto_increment, ogame_playerid int(11) unsigned NOT NULL default '0', playername varchar(30) NOT NULL default , alliance varchar(30) NOT NULL default 'main', score int(11) unsigned NOT NULL default '0', date_added date NOT NULL default '0000-00-00', PRIMARY KEY (id), UNIQUE KEY ogame_playerid (ogame_playerid,date_added) )"; mysql_query($query) or die(mysql_error()); echo " done \n"; echo "Installation complete."; ?>

Galaxietool Changelog

Menú de navegación

Vistas

Herramientas personales

Navegación

Galaxietool

Social Media

Buscar

Herramientas