Function adventurer_print_link($advid)
{
$connection = mysql_connect("localhost","root","") or die("NO SERVER");
mysql_select_db("aq") or die("Unable to select database");
$query = "SELECT url FROM characters where id=$advid";
$result = mysql_query($query) or die("Query failed");
$link = mysql_result($result,0,"url");
mysql_close($connection);
print("$link");
}
Function adventurer_get_link($advid)
{
$connection = mysql_connect("localhost","root","") or die("NO SERVER");
mysql_select_db("aq") or die("Unable to select database");
$query = "SELECT url FROM characters where id=$advid";
$result = mysql_query($query) or die("Query failed");
$link = mysql_result($result,0,"url");
mysql_close($connection);
return $link;
}
Function adventurer_new($adv_name, $adv_player, $adv_link, $adv_blurb)
{
$connection = pg_connect("localhost","5432","aq");
$query = "INSERT INTO characters VALUES (nextval('adventurer_sequence'::text),'$adv_name','$adv_player','$adv_link','$adv_blurb')";
$result = pg_exec($connection, $query);
pg_close($connection);
}
Function adventurer_flist()
{
$connection = pg_connect("localhost","5432","aq");
$query = "SELECT adv_name,adv_link,adv_blurb,advid FROM characters ORDER BY adv_name";
$result = pg_exec($connection, $query);
for ($row=0; $row < pg_NumRows($result); $row++) {
if (strcmp(pg_result($result,$row,1),"NONE")) {
printf("%s (%s)- %s
\n",
pg_result($result,$row,1), pg_result($result,$row,0),
pg_result($result,$row,3), pg_result($result,$row,2));
}
else {
printf("%s (%s) - %s
\n",
pg_result($result,$row,0),pg_result($result,$row,3),
pg_result($result,$row,2));
}
}
pg_close($connection);
}
?>
Function actor_print_link($advid)
{
$connection = mysql_connect("localhost","root","") or die("NO SERVER");
mysql_select_db("aq") or die("Unable to select database");
$query = "SELECT url FROM actors where id=$advid";
$result = mysql_query($query) or die("Query failed");
$link = mysql_result($result,0,"url");
mysql_close($connection);
print("$link");
}
Function actor_get_link($advid)
{
$connection = mysql_connect("localhost","root","") or die("NO SERVER");
mysql_select_db("aq") or die("Unable to select database");
$query = "SELECT url FROM actors where id=$advid";
$result = mysql_query($query) or die("Query failed");
$link = mysql_result($result,0,"url");
mysql_close($connection);
return $link;
}
Function actor_new($actor_name, $actor_player, $actor_link, $actor_blurb)
{
$connection = pg_connect("localhost","5432","aq");
$query = "INSERT INTO actors VALUES (nextval('actor_sequence'::text),'$actor_name','$actor_player','$actor_link','$actor_blurb')";
$result = pg_exec($connection, $query);
pg_close($connection);
}
Function actor_flist()
{
$connection = pg_connect("localhost","5432","aq");
$query = "SELECT actor_name,actor_link,actor_blurb,advid FROM actors ORDER BY actor_name";
$result = pg_exec($connection, $query);
for ($row=0; $row < pg_NumRows($result); $row++) {
if (strcmp(pg_result($result,$row,1),"NONE")) {
printf("%s (%s)- %s
\n",
pg_result($result,$row,1), pg_result($result,$row,0),
pg_result($result,$row,3), pg_result($result,$row,2));
}
else {
printf("%s (%s) - %s
\n",
pg_result($result,$row,0),pg_result($result,$row,3),
pg_result($result,$row,2));
}
}
pg_close($connection);
}
?>
November 17, 2001
| Game Start Date |
7-23-10035 |
| Game End Date |
8-1-10035 |
| Game Master |
Justin Gaskins |
|
Adventurers
|
|