lavalair gift shop

[devil_bd]

• do not show sender name who send by gift
• plz anybody solv this
• maybe sql prob.plz solv
  
  
  

--
-- Table structure for table `ibwf_shop_Inventory`
--

CREATE TABLE `ibwf_shop_Inventory` (
  `id` int(100) NOT NULL auto_increment,
  `uid` int(100) NOT NULL default '0',
  `itemid` int(100) NOT NULL default '0',
  `time` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ibwf_shop_Inventory`
-- 

else if($action=="prop") 
{
 $whonick = getnick_uid($who);
  addonline(getuid_sid($sid),"Viewing $whonick's Gifts","");

    echo "<card id=\"main\" title=\"Viewing $whonick's Gifts\">";
  echo "<p align=\"center\">";

  $nick = getnick_sid($sid);
  $whonick = getnick_uid($who);
$who = $_GET["who"];
  echo "<i><b><u><small>$whonick's Gifts</small></u></b></i><br/>";

  echo "</p>";
  echo "<p>";

     $sql = "SELECT itemid, uid FROM ibwf_shop_Inventory WHERE uid='".$who."'";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
    $shopitem = mysql_fetch_array(mysql_query("SELECT itemid, itemname, itemshopid FROM ibwf_shop WHERE itemid='".$item[0]."'"));

    echo "$shopitem[1] By <b>do not show :( user name here</b><br/>";
    if($shopitem[2]=='1'){

    }


  }
 } 

see this code echo "$shopitem[1] By <b>do not show user name here</b><br/>";

[kei_ki7]

try this

$didntshow = getnick_uid($items[1]); 
echo "$shopitem[1] By <b>$didntshow</b><br/>"; 

[nclemale36]

try this mate, its my full shop in xhtml with tools use it like it is or fix your own with it ,

enjoy

[devil_bd]

1. not work this see sender name
   

1. $dontshow = getnick_uid($items[1]); echo "$shopitem[1] By <b>$dontshow</b><br/>";
   

//////////////////////////////////////////  Gift


else if($action=="prop") 
{
 $whonick = getnick_uid($who);
  addonline(getuid_sid($sid),"Viewing $whonick's Gifts","");

    echo "<card id=\"main\" title=\"Viewing $whonick's Gifts\">";
  echo "<p align=\"center\">";

  $nick = getnick_sid($sid);
  $whonick = getnick_uid($who);
$who = $_GET["who"];
  echo "<i><b><u><small>$whonick's Gifts</small></u></b></i><br/>";

  echo "</p>";
  echo "<p>";

     $sql = "SELECT itemid, uid FROM ibwf_shop_Inventory WHERE uid='".$who."'";

    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
    {
    $shopitem = mysql_fetch_array(mysql_query("SELECT itemid, itemname, itemshopid FROM ibwf_shop WHERE itemid='".$item[0]."'"));
$dontshow = getnick_uid($items[1]);  
echo "$shopitem[1] By <b>$dontshow</b><br/>";
    if($shopitem[2]=='1'){

    }


  }
 }

echo "</p>";
  ////// UNTILL HERE >>
  echo "<p align=\"center\">";
  echo "<br/><a href=\"vprofile.php?action=viewuser&amp;sid=$sid&amp;who=$who\">";
$whonick = getnick_uid($who);
echo "Back to $whonick's Profile</a><br/>";
  echo "<a href=\"djmain.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
  echo "Home</a>";
  echo "</p>";
  echo "</card>";
  }