Planetarion Database Dump

2006-10-14T23:20:02Z

211.117.126.89:

== 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 [[Arbiter]]s and the various [[:Category:Resources|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''<br>
<tt>X, Y, Z, Planet name, Ruler name, Race, Size, Score, Value</tt>

''Galaxies''<br>
<tt>X, Y, Galaxy Name, Size, Score, Value</tt>

''Alliances''<br>
<tt>Rank, Alliance name, Size, Members, Score</tt>

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

<tt>Content: Planetarion Alliance Listing (sorted by rank)<br>
Author: Christian Lassem <spinner@planetarion.com><br>
Version: 1.01<br>
Tick: 1406<br>
Separator: ' '<br>
Format: 'rank "alliance name" size members score'</tt>

== 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;

[[Category:Terminology]][[Category:Resources]]

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

Planetarion Wiki - User contributions [en]

Planetarion Database Dump