WooYun.org

<?php
define('IN_JP',true);
require_once("./config/init.php");
	$arcid = $_REQUEST["arcid"];
	if($arcid!=""){
		$qrynews2 = "select * from news where id = ".$arcid;		
		$objnews2=$GLOBALS['db']->get_one($qrynews2);				    
	}else{
	$objnews2="";
	}
  $qrycount = "select w.id,r.username,w.won_date,p.name,a.auc_final_price,a.auctionID,p.picture1,p.price,(100-100*a.auc_final_price/p.price) as discount,a.auctionID from won_auctions w left join auction a on w.auction_id=a.auctionID left join products p on a.productID=p.productID inner join registration r on w.userid = r.id where w.userid>=0 order by w.won_date desc limit 0,7 ";  
  $obj1 = $GLOBALS['db']->select($qrycount);
$smarty->assign("obj1",$obj1);
$smarty->assign("objnews2",$objnews2);
$smarty->display('news_arc.htm');
?>