View Single Post
  #11  
Old 03-22-2011, 04:22 PM
fadillzzz fadillzzz is offline
Dev Staff
 
Join Date: Jan 2010
Posts: 501
Gender: Male
Credits: 32,881
fadillzzz is an unknown quantity at this point
Default

I don't know much about this mod but this should work

PHP Code:
<?php

include("inc/functions.php");

//***************//
//  START SCRIPT //
//***************//

$article_title "Your Inventory";

if (
$isloggedin == "yes") {
$article_content "Here you can see a list of items that you have collected.<table width='500' border='2'>
<tr>
    <td width='200'><strong>Picture:</strong></td>
    <td width='230'><strong>Item Type: </strong></td>
    <td width='70'><strong>ID Number:</strong></td>
</tr>"
;
 
$query "SELECT * FROM ".$prefix."useritems WHERE Owner = '$loggedinname'";
$result mysql_query($query);
$num mysql_numrows($result);

$i=0;
while (
$i $num) {

$iid=@mysql_result($result,$i,"ID");
$object=@mysql_result($result,$i,"Item");
$url=@mysql_result($result,$i,"imageurl");


$article_content $article_content."<tr>
    <td><center><img src='"
.$url."'></center></td>
    <td><center>"
.$object."</center></td>
    <td><center>"
.$iid."</center></td>
  </tr>"
;

unset(
$iid);
unset(
$object);

$i++;
}
$article_content $article_content."</table>";

}
else {

$article_content "You must be logged in to view items.";

}
//***************//
//  OUTPUT PAGE  //
//***************//

echo showpage($article_title$article_content$date);

?>
Also, make sure the table prefix_useritems exists in the database.
Reply With Quote