PHP-Code:
<?php
head("Doppler Stats");
echo '<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr>
<td width="100%" valign="top">';
$dopplerstats1 = mysql_fetch_array(db_query("SELECT SUM(`summe_verdoppelt`) AS `offen`, COUNT(`summe_verdoppelt`) AS `anzahl` FROM `vms_doppler_zahlungen` WHERE `status` != 1"));
$dopplerstats2 = mysql_fetch_array(db_query("SELECT * FROM `vms_doppler_pot` WHERE 1"));
echo '<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td width="55%">Doppler wartende auszahlungen (LOSE)</td>
<td align="right">' . @number_format($dopplerstats1['offen'], 0, ",", ".") . ' </td>
</tr>
<tr bgcolor="#f5f5f5">
<td>Doppler wartende auszahlungen (Stück)</td>
<td align="right">' . @number_format($dopplerstats1['anzahl'], 0, ",", ".") . ' </td>
</tr>
<tr bgcolor="#f0f0f0">
<td >Doppler POT</td>
<td align="right">' . @number_format($dopplerstats2['pot'], 0, ",", ".") . ' </td>
</tr>
<tr bgcolor="#f5f5f5">
<td>Förderung klicks</td>
<td align="right">' . @number_format($dopplerstats2['klicks'], 0, ",", ".") . ' </td>
</tr>
</table>';
echo '</td>
</tr></table>';
foot();
head("Noch pendente zahlungen");
echo '<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr>
<td width="100%" valign="top">';
$dopplerstats1 = (db_query("SELECT `uid`, SUM(`summe_verdoppelt`) AS `offen`, COUNT(`summe_verdoppelt`) AS `anzahl` FROM `vms_doppler_zahlungen` WHERE `status` != 1 GROUP BY `uid` ORDER BY `offen` DESC"));
echo '<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td >USER / UID</td>
<td align="right">Auszahlsumme</td>
<td align="right">Auszahlungen stück</td>
</tr>';
while($data = mysql_fetch_assoc($dopplerstats1)){
echo '<tr bgcolor="#f0f0f0">
<td align="right">' . $data['uid'] . ' </td>
<td align="right">' . @number_format($data['offen'], 0, ",", ".") . ' </td>
<td align="right">' . @number_format($data['anzahl'], 0, ",", ".") . ' </td>
</tr>';
}
echo '</table>';
echo '</td>
</tr></table>';
foot();
als neue datei irgendwo im admin...
z.b. /adminforce/content/doppler.php
Zitieren