PHPProBid Random Auction Block

PHPProBid Random Auction Block

Mod Version: 1.00, by banshee

This modification is in the archives.

vB Version: 3.0.7	Rating: (0 vote - 0 average)	Installs: 2
Released: 24 May 2005	Last Update: Never	Downloads: 0
Not Supported

This is a block that I use on my vbindex to show random auctions from my PHPProbid site. http://www.phpprobid.com/

I don't offer support but will help you out as much as I can. The script is pretty basic. I just make it a PHP file and use a PHP inlude into my vbindex.

You can check out what it looks like at http://www.everything2stroke.com

Code:

<?
$host = "localhost";        //Server Name
$user= "username";                  //Username
$password= "password";              //Password
$database="databasename";               //Reviews database name or forum database name
$path = "http://www.pathtoauctionsite.com/";
$price = " ";
$pic = " "; ?>
<table width="100%" border="0" cellpadding="3" cellspacing="1">
  <tr height="15">
    <td nowrap="nowrap"><center><b>Picture</b></center></td>
    <td width="100%"><b>Item Title</b></td>
    <td nowrap="nowrap"><b>Price</b></td>
    <td nowrap="nowrap"><b>bids</b></td>
    <td nowrap="nowrap"><center><b>End Date</b></center></td>
  </tr>
  <? // Connecting, selecting database
$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');
mysql_select_db ("$database")or die("Could not select database");
        $getRandomAuctions=mysql_query("SELECT id, startdate, bidstart, currency, itemname, maxbid, enddate, picpath, nrbids FROM probid_auctio
ns WHERE
        closed=0 AND active=1 AND deleted!=1 ORDER BY rand() DESC LIMIT 0,2");
        while ($randAuctions = mysql_fetch_array($getRandomAuctions)) {
        if ( $randAuctions['picpath'] == ""){
            $pic = "clear.gif ";
        }
        else {
            $pic = $randAuctions['picpath'];
        }
 if ( $randAuctions['maxbid'] == "0.00"){
            $price = $randAuctions['bidstart'];
        }
        else {
            $price = $randAuctions['maxbid'];
        }
?>
  <tr>
        <td nowrap="nowrap"><img width="100" src="<?=$path;?><?=$pic;?>"></td>
        <td width="100%"><a href="<?=$path;?>auctiondetails.php?id=<?=$randAuctions['id'];?>" TARGET="_blank"> <? echo $randAuctions['itemname'
];?> </a></td>
        <td nowrap><?=$price;?> <? echo $randAuctions['currency'];?></td>
        <td nowrap><center><?echo $randAuctions['nrbids']?></center></td>
        <td nowrap><b><? echo $randAuctions['enddate'],$setts['date_format'];?></b></td>
  </tr>
  <? } ?>
</table>

Download

No files for download.

vBulletin LTS