$linkid = mysql_pconnect( "localhost", "nobody", "oct1497") or die( "Unable to connect to mySQL server");
if (isset($quickQuery1)) { $sql = "SELECT * FROM User_Table";
if ($order_user_by) { $sql .= " ORDER BY $order_user_by"; }
}
if (isset($quickQuery3)) { $sql = "SELECT * FROM Player_Table";
if ($order_player_by) { $sql .= " ORDER BY $order_player_by"; }
}
//if ($ascending) { $sql .= " ASC"; } else { $sql .= " DESC"; }
if ($limit) { $sql .= " LIMIT $limit"; }
if (isset($quickQuery2)) { $sql = "show tables"; }
?>
Error_Reporting(7);
if ($REQUEST_METHOD == "POST")
{
$result = mysql_db_query("wt_client",$sql);
if ($result < 0)
{
echo "\n".mysql_errno().": ".mysql_error()."
\n";
}
else
{
$nr = mysql_numrows($result);
$fn = mysql_numfields($result);
$i = 0;
$j = 0;
echo "\nResults: ",$nr," \n";
echo " ";
echo "\n";
while ($i < $fn) {
$f[] = mysql_fieldname($result,$i);
echo "",$f[$i]," | ";
$i++;
}
echo " \n";
while ($j < $nr) {
$k = 0;
if ( ($j % 2) == 0 ) {
echo "";
}
else {
echo " ";
}
while ($k < $fn) {
echo "";
if ($f[$k] == "guid") {
$guid = mysql_result($result,$j,$f[$k]);
echo "$guid";
}
else { echo mysql_result($result,$j,$f[$k]);}
echo "
| ";
$k++;
} /* while $k */
$j++;
echo " \n";
} /* while $j */
echo " \n";
}
}
?>
WildTangent_mySQL_client_db.txt: The Database Layout
WildTangent_mySQL_db.txt: mySQL Permissions Table
You can also ssh or telnet in to the server and type "mysql -v -v wt_client".
|