anotapreta
New Member
- Joined
- Mar 12, 2010
- Messages
- 104
- Reaction score
- 0
Help me?<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Ultimos Items Comprados '.$config['server']['serverName'].'</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="10%" align="center"><b>Picture</b></td><td width="25%" align="center"><b>Player Name</b></td><td width="25%" align="center"><b>Item Name</b></td><td width="10%" align="center"><b>Points</b></td><td width="50" align="center"><b>Date</b></td></tr>';
$offer_list = $SQL->query('SELECT `to_name`, `price`, `offer_id`, `trans_start` FROM `z_shop_history_item` LIMIT 50;');
while($data = $offer_list->fetch()) {
$tmp = $SQL->query('SELECT `offer_type` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 10;')->fetch();
if($tmp['offer_type'] == 'item')
{
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 10;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="C:\xampp\htdocs\item_images'.$id['itemid1'].'.gif"></td><td align="center"><b>'.$data['to_name'].'</b></td><td align="center">'.$data['offer_id'].'</td><td align="center">'.$data['price'].'</td><td align="center">'.date("j F Y, H:i:s", $data['trans_start']).'</td></tr>';
}
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>
<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Los Donate mas comprados</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="5%" align="center"><b>Picture</b></td><td width="25%" align="center"><b>Item Name</b></td><td width="5%" align="center"><b>Purchased</b></td></tr>';
$offer_list = $SQL->query('SELECT `offer_id`, count( offer_id ) AS `total` FROM `z_shop_history_item` GROUP BY `offer_id` ORDER BY `total` DESC;');
while($data = $offer_list->fetch()) {
$tmp = $SQL->query('SELECT `offer_type` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
if($tmp['offer_type'] == 'item')
{
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="C:\xampp\htdocs\item_images'.$id['itemid1'].'.gif"></td><td align="center">'.$data['offer_id'].'</td><td align="center">'.$data['total'].'</td></tr>';
}
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>
<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Top Donators</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="25%" align="center"><b>Player Name</b></td><td width="5%" align="center"><b>Purchased Items</b></td></tr>';
$offer_list = $SQL->query('SELECT `to_name`, count(`to_name`) AS `total` FROM `z_shop_history_item` GROUP BY `to_name` ORDER BY `total` DESC LIMIT 50;');
while($data = $offer_list->fetch()) {
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><b>'.$data['to_name'].'</b></td><td align="center">'.$data['total'].'</td></tr>';
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>
<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Ultimos Items Comprados '.$config['server']['serverName'].'</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="10%" align="center"><b>Picture</b></td><td width="25%" align="center"><b>Player Name</b></td><td width="25%" align="center"><b>Item Name</b></td><td width="10%" align="center"><b>Points</b></td><td width="50" align="center"><b>Date</b></td></tr>';
$offer_list = $SQL->query('SELECT `to_name`, `price`, `offer_id`, `trans_start` FROM `z_shop_history_item` LIMIT 50;');
while($data = $offer_list->fetch()) {
$tmp = $SQL->query('SELECT `offer_type` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 10;')->fetch();
if($tmp['offer_type'] == 'item')
{
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 10;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="C:\xampp\htdocs\item_images'.$id['itemid1'].'.gif"></td><td align="center"><b>'.$data['to_name'].'</b></td><td align="center">'.$data['offer_id'].'</td><td align="center">'.$data['price'].'</td><td align="center">'.date("j F Y, H:i:s", $data['trans_start']).'</td></tr>';
}
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>
<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Los Donate mas comprados</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="5%" align="center"><b>Picture</b></td><td width="25%" align="center"><b>Item Name</b></td><td width="5%" align="center"><b>Purchased</b></td></tr>';
$offer_list = $SQL->query('SELECT `offer_id`, count( offer_id ) AS `total` FROM `z_shop_history_item` GROUP BY `offer_id` ORDER BY `total` DESC;');
while($data = $offer_list->fetch()) {
$tmp = $SQL->query('SELECT `offer_type` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
if($tmp['offer_type'] == 'item')
{
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="C:\xampp\htdocs\item_images'.$id['itemid1'].'.gif"></td><td align="center">'.$data['offer_id'].'</td><td align="center">'.$data['total'].'</td></tr>';
}
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>
<?PHP
if($config['site']['shop_system'] == 1) {
$main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="100%"><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b> Top Donators</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="25%" align="center"><b>Player Name</b></td><td width="5%" align="center"><b>Purchased Items</b></td></tr>';
$offer_list = $SQL->query('SELECT `to_name`, count(`to_name`) AS `total` FROM `z_shop_history_item` GROUP BY `to_name` ORDER BY `total` DESC LIMIT 50;');
while($data = $offer_list->fetch()) {
$id = $SQL->query('SELECT `itemid1` FROM `z_shop_offer` WHERE `offer_name` = \''.$data['offer_id'].'\' LIMIT 1;')->fetch();
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><b>'.$data['to_name'].'</b></td><td align="center">'.$data['total'].'</td></tr>';
}
$main_content .= '</table><br />';
}
else
$main_content .= '<br /><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>