Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/www/web207/html/Hp/pages/itemshop.php on line 58
<div id="content"> <div class="postui2 text-title">
<h2>
Kategorien
</h2>
</div>
<div class="postui2 text-con">
<div class="con-wrap"><center>
<?PHP
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
if(isset($_GET['k']) && checkInt($_GET['k'])) {
$sqlCmdS="SELECT * FROM ".SQL_HP_DB.".is_items WHERE kategorie_id='".$_GET['k']."' ORDER BY id DESC";
}
else {
$sqlCmdS="SELECT * FROM ".SQL_HP_DB.".is_items ORDER BY id DESC";
}
?>
<?PHP
$sqlCmd = "SELECT * FROM ".SQL_HP_DB.".is_kategorien ORDER BY titel ASC;";
$sqlQry = mysql_query($sqlCmd,$sqlHp);
while($getKats = mysql_fetch_object($sqlQry)) {
echo'
<a href="index.php?s=itemshop&k='.$getKats->id.'">
<input type="submit" value="'.$getKats->titel.'" name="submit" class="button2">
</a>';
}
?>
</center> </div>
</div>
<div class="postui2 text-end">
</div></div>
<br />
<div id="content"> <div class="postui2 text-title">
<h2>
Item Liste
</h2>
</div>
<div class="postui2 text-con">
<div class="con-wrap">
<div id="isright">
<h2>Items</h2>
<table>
<?PHP
$sqlQry=mysql_query($sqlCmdS,$sqlHp);
while($getItems=mysql_fetch_object($sqlQry)) {
$aktItem = compareItems($getItems->vnum);
$itemStufe = (checkInt($aktItem['stufe'])) ? "+".$aktItem['stufe'] : '';
?>
<tr>
<th colspan="2" class="topLine"><?PHP echo $aktItem['item'].$itemStufe; ?></th>
</tr>
<tr>
<td class="isImg">
<?PHP
if(!empty($getItems->bild)) echo'<img src="./is_img/'.$getItems->bild.'" title="'.$aktItem['item'].'" alt="'.$aktItem['item'].'"/>';
?>
</td>
<td class="tdunkel"><?PHP echo $getItems->beschreibung; ?><br />
Kostet:<b> <?PHP echo $getItems->preis; ?> Coins</b></td>
</tr>
<tr>
<td colspan="2" class="isBuy"><a href="index.php?s=is_buy&id=<?PHP echo $getItems->id; ?> ">
<input type="submit" value="Kaufen" class="button1">
</a>
</td>
</tr>
<?PHP
}
?>
</table>
</div>
<?PHP
}
else {
echo'<p class="meldung">Sie müssen für diesen Bereich angemeldet sein.</p>';
}
?>
</div>
</div>
<div class="postui2 text-end">
</div></div>