📄 alt_list.php
字号:
<?php
include "auth.inc.php";
include "conn.inc.php";
?>
<html>
<head>
<title>WoW-Wish: Alts list</title>
<link rel="stylesheet" href="wish.css">
</head>
<body>
<?php include "header.inc.php"; ?>
<h1>Your alts and their wishes </h1>
<p>
<?php
$s_session_user_logged = addslashes($_SESSION['user_logged']);
$altquery = "SELECT altname, altrealm, faction FROM alts WHERE owner = '". $s_session_user_logged . "';";
$altresult = mysql_query($altquery) or die(mysql_error());
$stripecol = 1;
if (mysql_num_rows($altresult) == 0)
{
echo "You have no characters yet!<br />";
echo "<a href=\"alt_new.php\">Make a new alt</a><br />";
}
else
{
echo "<table class=altlist>";
while ( $row = mysql_fetch_assoc($altresult))
{
//CHARACTER ON REALM
echo "<tr bgcolor=#dedeff><td colspan=2>";
echo "<font size=+2><b>". $row[altname] ."</b>";
if ($row[faction] ==1)
{ echo "<font color=\"blue\">[A]</font> "; }
elseif ($row[faction] ==2)
{ echo "<font color=\"red\">[H]</font> "; }
else
{ echo " "; }
echo "on <b>". $row[altrealm] ."</b> realm </font> </td>";
echo "<td><a href=\"wish_new.php?alt=" .$row[altname]. "&realm=" .$row[altrealm]."\">wish</a></td></tr>";
$s_altname = addslashes($row[altname]);
$aidlookupquery = "SELECT altid FROM alts WHERE altname = '". $row[altname] ."' AND owner = '". $s_session_user_logged ."';";
$aidlookupresult = mysql_query($aidlookupquery) or die (mysql_error());
$row = mysql_fetch_assoc($aidlookupresult);
$aid = $row[altid];
$widquery = "SELECT wishid FROM wishes WHERE wishaltid = ". $aid .";";
$widresult = mysql_query($widquery) or die (mysql_error());
if (mysql_num_rows($widresult) == 0)
{
echo "<tr><td colspan=3>  no wishes made for this character</td></tr>";
}
else
{
while ($row2 = mysql_fetch_assoc($widresult))
{
foreach($row2 as $wishid)
{
if ($stripecol % 2 ==1)
{ echo "<tr bgcolor=#ccccff>";}
else
{ echo "<tr bgcolor=#aaaaff>";}
echo "<td>  ";
$didquery = "SELECT wishdungeonid FROM wishes where wishid = " .$wishid .";";
$didresult = mysql_query($didquery) or die (mysql_error());
$row = mysql_fetch_assoc($didresult);
$did = $row[wishdungeonid];
$dnamequery = "SELECT dungeonname FROM dungeons INNER JOIN wishes ON dungeons.dungeonid = wishes.wishdungeonid AND wishes.wishid = " .$wishid .";";
$dnameresult = mysql_query($dnamequery) or die (mysql_error());
$row = mysql_fetch_assoc($dnameresult);
echo $row[dungeonname];
//is it heroic?
$hquery ="SELECT heroic FROM wishes WHERE wishid = " . $wishid . ";";
$hresult = mysql_query($hquery) or die (mysql_error());
$row = mysql_fetch_assoc($hresult);
if ($row[heroic] == 1)
{
echo " (heroic)";
echo "</td><td> <a href=\"wish_match.php?wish=". $did ."&hc=". $row[heroic] ."\">match</a>";
}
else
{
echo "</td><td> <a href=\"wish_match.php?wish=". $did ."&hc=". $row[heroic] ."\">match</a>";
}
echo "</td><td> <a href=\"wish_remove.php?remove=". $wishid ."\"><img src=\"img/delete.png\" alt=\"Remove\" title=\"Remove this wish\"></a>";
echo "</td></tr>";
}
$stripecol++;
}
}echo "<tr><td></td></tr>"; //for a little gap between each character
}
echo "</table>";
echo "<a href=\"wish_new.php\">Make a wish for your alt</a><br />";
echo "<a href=\"alt_new.php\">Make a new alt</a><br />";
}
?>
</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -