xsankebrx

Itens mais vendidos no seu site


(meu primeiro tópico aqui.)

 

Preview:

 





Tutorial:

 

1° Passo: Abra seu shopsystem.php e procure

 

elseif($buy_offer['type'] == 'item') {

 

e abaixo disso

 


$SQL->query($save_transaction);

 

Cole isso:

 


$bought = 'UPDATE `z_shop_offer` SET `bought` = bought + 1 WHERE `id` ='.$buy_offer['id'].';'; $SQL->query($bought);

 

 

2° Passo: Abra seu latestnews.php e procure

 


<?PHP $time = time();

 

e abaixo disso cole:

 



$query = $SQL->query("SELECT * FROM `z_shop_offer`WHERE `offer_type` NOT LIKE 'container' AND `offer_type` NOT LIKE 'changename' AND `offer_type` NOT LIKE 'vipdays' AND `offer_type` NOT LIKE 'redskull' AND `offer_type` NOT LIKE 'unban' ORDER BY `bought` DESC LIMIT 5");
foreach($query as $rows) {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
$number_of_rows++;
$result .= '
<td bgcolor='.$bgcolor.'>
<center>
<img src="item_images/'.$rows['itemid1'].'.gif"> <br /><br />
Item:</br> <b>'.$rows['offer_name'].'</b><br />
Points: <b>'.$rows['points'].'</b>
</center>
</td>';
}
$main_content .= "<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" width=\"100%\"><tr bgcolor=".$config['site']['vdarkborder']."><td class=\"white\" colspan=\"5\"><center><strong>Últimos itens vendidos no Shopping</strong></center></td></tr><tr bgcolor=".$config['site']['vdarkborder']."><td class=\"white\" width=\"20%\"><b><center>#1</center></b></td><td class=\"white\" width=\"20%\"><b><center>#2</center></b></td>

<td class=\"white\" width=\"20%\"><b><center>#3</center></b></td>
<td class=\"white\" width=\"20%\"><b><center>#4</center></b></td>
<td class=\"white\" width=\"20%\"><b><center>#5</center></b></td>




</tr>".$result."</table> <br />";


 

2° Passo: Para finalizar execute essa query em seu phpMyAdmin

 


ALTER TABLE `z_shop_offer` ADD `bought` INT( 11 ) NOT NULL DEFAULT '0';

 

Prontinho, script irá funcionar 100% se seguir passa-a-passo corretamente, dúvidas?

Poste aqui!

 

Script original by: Aleh

Script 100% Editado by: Ruivo

 

Obrigado, REP ++!