[Gesior ACC] The most popular items in SMS Shop!

anotapreta · Jul 29, 2011

http://mundinho.sytes.net:8090/index...pic=shopsystem

acc: 123456789
pass: 123456789

lollimpo · Jul 30, 2011

the old Most bought show?? please no have the database table,
use it php.

<?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"> Ultimos Items Comprados '.$config['server']['serverName'].'</td></tr><tr bgcolor="#D4C0A1"><td width="10%" align="center">Picture</td><td width="25%" align="center">Player Name</td><td width="25%" align="center">Item Name</td><td width="10%" align="center">Points</td><td width="50" align="center">Date</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">'.$data['to_name'].'</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> ';
}
else
$main_content .= ' <center>Shop System is currently disabled for this server.Please ask the admin for more information.</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"> Los Donate mas comprados</td></tr><tr bgcolor="#D4C0A1"><td width="5%" align="center">Picture</td><td width="25%" align="center">Item Name</td><td width="5%" align="center">Purchased</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> ';
}
else
$main_content .= ' <center>Shop System is currently disabled for this server.Please ask the admin for more information.</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"> Top Donators</td></tr><tr bgcolor="#D4C0A1"><td width="25%" align="center">Player Name</td><td width="5%" align="center">Purchased Items</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">'.$data['to_name'].'</td><td align="center">'.$data['total'].'</td></tr>';
}
$main_content .= '</table> ';
}
else
$main_content .= ' <center>Shop System is currently disabled for this server.Please ask the admin for more information.</center>';
?>

Help me?
look Problem : http://80.37.94.159:8090/?subtopic=Donate stadistics
thranks.

lollimpo · Jul 30, 2011

the old Most bought show?? please no have the database table,
use it php.

HTML:

<?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>&nbsp;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>&nbsp;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>&nbsp;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>';
?>

Help me?
look Problem : http://80.37.94.159:8090/?subtopic=Donate stadistics
thranks.

kito2 · Oct 26, 2011

Fixed it

lollimpo · Nov 16, 2011

old most items

Please Table

(((((((((

lollimpo · Nov 16, 2011

lollimpo said:
Please Table

look my problem http://80.224.100.191:8090/ please help me..

Szysza · Nov 24, 2011

Good job Aleh!

Apras · Dec 4, 2011

Thx!! works perfectly

.

Transeti · Dec 5, 2011

good work man congratulations

pugamoline · Jan 24, 2012

sell this system for modern aac 100% work

Naxtie · Mar 27, 2012

Works perfect, thanks! rep+

BDG · May 28, 2013

Very good kurwa :d

[Gesior ACC] The most popular items in SMS Shop!

anotapreta

New Member

lollimpo

Active Member

lollimpo

Active Member

kito2

www.masteria.net

lollimpo

Active Member

lollimpo

Active Member

Szysza

®oot

Apras

New Member

Transeti

New Member

pugamoline

uint32_t patch_mem(char *

Naxtie

mapper, designer

BDG

Banned User

Similar threads