Help track items vip

[valivan601]

i need one script for modern acc that track the items vip for players can anyone do it for me?

the script will show on page the name of the player the name of the item and the count of the item

for player_items and player_depotitems

starting with id 102

can anyone do it for me??

the script just appears for moderators

THX

i try to made one but without sucess

if it helps here is my bad script

<?php
("config.php");

$ots = POT::getInstance();

$ots->connect(POT::DB_MYSQL, connection());

$SQL = $ots->getDBHandle();

echo'<div class="message"><div class="title">Track</div><div class="content"><center>
        <table align="center" width="80% border="0" cellpadding="4" cellspacing="0" >
        <tr align="center" >';
	echo'</tr></table></center></div></div>';
echo '<div style="text-align: center; font-weight: bold;"></div>



<table border="0" cellspacing="1" cellpadding="4" width="100%">
 <tr>
  <td class="white" style="text-align: center; font-weight: bold;">player id</td>
  
<td class="white" style="text-align: center; font-weight: bold;">count</td>
 </tr>';foreach($SQL->query('SELECT `player_items`.`itemtype`,`player_items`.`player_id`,`player_items`.`count`
			FROM `player_items`
			WHERE `player_items`.`itemtype` = 102)->fetchAll();') 

<td>'. $player_items['player id'] . '</center></td>
  <td><center>' . $player_items['count] . '</center></td>
 </tr>';
}
echo '</table>';
?>

 

[valivan601]

bump