Planetarion Database Dump

Description

The Planetarion Database Dumps are files with ingame information from Planetarion. They show planet, galaxy and alliance information, such as score, size and value. They are generated at the end of the tick which is usually around xx:04, but it has been recommended that any sites wishing to use them retrieve them no earlier than xx:15 in order to allow for ticks which take longer than normal.

These dump file(s) are usually used in Arbiters and the various tool kits.

The dumpfiles are available at:

http://game.planetarion.com/botfiles/planet_listing.txt

http://game.planetarion.com/botfiles/galaxy_listing.txt

http://game.planetarion.com/botfiles/alliance_listing.txt

Structure

Since 8th June 2004 the structures of the database dumps have been:

Planets
X, Y, Z, Planet name, Ruler name, Race, Size, Score, Value

Galaxies
X, Y, Galaxy Name, Size, Score, Value

Alliances
Rank, Alliance name, Size, Members, Score

Each file starts with information about what the file contains. eg:

Content: Planetarion Alliance Listing (sorted by rank)
Author: Christian Lassem <[email protected]>
Version: 1.01
Tick: 1406
Separator: ' '
Format: 'rank "alliance name" size members score'

Tools

Many alliances write their own tools using these dumpfiles, and sites such as sandmans and pilkara also utilize them.

Here are some basic php code examples on how to use em:

<?

mysql_connect( "host", "user", "pass" );
mysql_select_db( "database" ); 

$planetList = file_get_contents( "http://jpaweb01.planetarion.com/botfiles/planet_listing.txt" );

preg_match_all( "/(\d+)\t(\d+)\t(\d+)\t\"(.+)\"\t\"(.+)\"\t(.+)\t(\d+)\t(\d+)/i", 
$planetList,  $planetArray, PREG_SET_ORDER );
	
		
mysql_query( "TRUNCATE TABLE planets" );

foreach ( $planetArray as $planet )
{
	mysql_query( "INSERT INTO planets VALUES ( $planet[1], $planet[2], 
       $planet[3], '$planet [4]', '$planets[5]', '$planet[6]', $planet[7], $planet[8] )" ); 
}

?>

And here is the MySQL table structure to go with it:

CREATE TABLE `planets` (
 `x` int(10) unsigned NOT NULL default '0',
 `y` int(10) unsigned NOT NULL default '0',
 `z` int(10) unsigned NOT NULL default '0',
 `planet` varchar(70) NOT NULL default ,
 `ruler` varchar(70) NOT NULL default ,
 `race` varchar(15) NOT NULL default ,
 `roids` bigint(20) unsigned NOT NULL default '0',
 `score` bigint(20) NOT NULL default '0',
 PRIMARY KEY  (`planet`)
) TYPE=MyISAM;

xxx hard core sex video peeing during sex same sex wedding unions sim1 sex howard stern sex machine 2 sex offenders registry+fl cairo gay sex club russian preteen sex sex abuse in public schools incest sex magazine download cartoon clips free sex porn gay pam and brett michels sex tape sex all hardcore tiny sex india sex blog oldmen sex interracial muscle gay sex sex game dads have sex with their kids thumbnail sex fuck pictures motheranddaughter sex king of the hills sex sex trade in tiawan high quality sex scan burds for sex fat and old sex sex indian frequent sex partners symptoms sexual active hindi sex galleries prostitutes sex search engines teach anal sex free sex stories in urdu free gay locker room sex guy on guy sex registered sex offenders virginia sim sex kitten lady boy sex pics free short sex quotes to make her horny women hormone and sex drive best anus lubricant for anal sex sex therapist massachusetts sex chat gratis pattaya sex gyide goku hentai sex free onsite preview lesbian sex freee sex ofender list young sex defloration sex movie free mature sex video galleries hairy best man sex big brother 7 leah sex tape m.i.l.f. sex cognitive based therapy juvenile sex offenders gangbang anal sex buy britney spears and kevin federline sex tape gogo's sex video exchange student sex lesbian sex partners old lady sex videos loacal women for sex sex and self esteem japanese game show sex middle age men sex pilipina sex paris hilton sex videos demi moore sex video sex partners heading sex vietnam sex tour wholesale sex toys marks bookmarks sex chinese anal sex amsterdam sex trips sex game free online whant to be a male sex worker bbw sex u sex gallary yahoo canada free first time anal sex movies romance and sex short stories american pie jim sex flute in god save the queen, sex pistols anal sex masterbate child sex movie pee drinking sex websites my first sex teacher mrs blossom napped sex.papistyle bizarre sex teach women how to have sex on top free young brunette sex sex therapy pictures drunk sex videos reasons for sex sex advice for seniors illegal pre-teen sex gay sex fort lauderdale first time father daughter sex how can i make myself last longer in sex swedish beast sex clips audio sex clips college lesbian sex stories