The Amazing Alien Database


\n"; if ($$name=="") // nothing selected echo "\n"; else echo "\n"; if ($extra) { // added for "none" and other special options array_unshift($list,$extra); } foreach ($list as $item) { if ($item=='') continue; echo "\n"; } echo "\n"; } function doradio($label,$value, $compare) { echo ""; } /* make connection to database */ MYSQL_CONNECT($hostname, $dbusername, $password) OR DIE("Unable to connect to database"); @mysql_select_db( "$dbName") or die( "Unable to select database"); /* use the getlist function to query the database and create lists of options */ $orglist=getlist("origin"); $themelist=getlist("theme"); $authlist=getlist("author"); $typelist=getlist("type"); $experiencelist=getlist("experience"); /* override the cookies with selected options */ if ($overidehistory<>"") $showhistory=$overidehistory; if ($overideflare<>"") $flarestyle=$overideflare; if ($overidetiming<>"") $timingstyle=$overidetiming; if ($overideart<>"") $showart=$overideart; if ($overideauthor<>"") $showauthor=$overideauthor; if ($overidetheme<>"") $showtheme=$overidetheme; if ($overidenotes<>"") $shownotes=$overidenotes; if ($overidetype<>"") $showtype=$overidetype; if ($overideexperience<>"") $showexperience=$overideexperience; ?> Show aliens that match these criteria:

Origin
Author
Theme
Type
Experience
Name
When viewing aliens, do you want to see:
The history? Yes
No
The art? Yes
No
The author? Yes
No
The theme? Yes
No
The notes? Yes
No
The type? Yes
No
Experience level? Yes
No
Flares?
All Flares
FFG/Eon style "retained" Flares only (Wild & Super)
Mayfair style "one-shot" Flares only (Wild1 & Super1)
Nebulas (Con, Wild1, Super)
No Flares
Timing style?
Text
Mayfair Icons
Fantasy Flight

"") // if asking for a particular power $set="powers.powerID=$one"; if ($origin<>"") $set.=" AND origin='$origin'"; if ($author<>"") $set.=" AND author='$author'"; if ($theme=="--None--") $set.=" AND theme=''"; elseif ($theme<>"") $set.=" AND theme='$theme'"; if ($type<>"") $set.=" AND type='$type'"; if ($experience<>"") $set.=" AND experience='$experience'"; if ($search<>"") $set.=" AND powers.powername LIKE '%". addslashes($search)."%'"; if (substr($set,0,4)==" AND") $set=substr($set,5); if ($set<>"") // if something was passed to us $submitted="Yes"; if ($submitted=="Yes") { include ("displaypowers.php3"); } ?>