ich hab ein kleines Problem mit meinem Itemshop Script.
Undzwar:
PHP Code:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/customers/webs/ni104921_1/pages/itemshop.php on line 13
PHP Code:
<?PHP
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) {
?>
<div class="con-top">Itemshop</div>
<div align="center">
<div class="con-mid">
<b>
<?PHP
$sqlCmd = "SELECT * FROM ".SQL_HP_DB.".is_kategorien ORDER BY titel ASC;";
$sqlQry = mysql_query($sqlCmd,$sqlHp);
echo '<a href="index.php?s=itemshop">Alle</a><br> ';
while($getKats = mysql_fetch_object($sqlQry)) {
echo'<a href="index.php?s=itemshop&k='.$getKats->id.'">'.$getKats->titel.'</a> ';
}
?>
</b>
</div>
</div>
<?PHP
echo '<div id="content_top"><h2>Itemshop</h2></div>
<div id="content_main"><div class="con-wrapper">';
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";
}
?>
<div id="isleft">
</div>
<?PHP
$sqlQry=mysql_query($sqlCmdS,$sqlHp);
while($getItems=mysql_fetch_object($sqlQry)) {
$aktItem = compareItems($getItems->vnum);
$itemStufe = (checkInt($aktItem['stufe'])) ? "+".$aktItem['stufe'] : '';
?>
<table id="itemshop">
<tr>
<th colspan="2" class="topLinee"><?PHP echo convertEncoding(ItemName($getItems->vnum)); ?> (<b><?PHP echo $getItems->preis; ?> Coins</b>)</th>
</tr>
<tr>
<td class="isImg">
<?PHP
if (file_exists("./is_img/".MakeItemImage($getItems->vnum).".png")){ echo'<img src="./is_img/'.MakeItemImage($getItems->vnum).'.png" title="'.$aktItem['item'].'" alt="'.$aktItem['item'].'"/>'; }
else{echo'<img src="./is_img/fail.png"/>';}
?>
</td>
<td class="tdunkell"><?PHP echo ''.convertEncoding($getItems->beschreibung).'';?></td>
</tr>
<tr>
<td colspan="2" class="isBuy"><a href="index.php?s=is_buy&id=<?PHP echo $getItems->id; ?>">Kaufen</a></td>
</tr>
</table><br/>
<?PHP
}
?>
<?PHP
}
else {
echo '<div id="content_top"><h2>Itemshop</h2></div>
<div id="content_main"><div class="con-wrapper">';
echo'<p class="meldung">Sie müssen für diesen Bereich angemeldet sein.</p>';
}
?>
</div>
</div>
<div class="con-bot"></div>
