bei mir sieht es ungefähr so aus:
Code:
<?
// Anzahl unbestätigter Kampagnen ermitteln
$fbhistory = mysql_num_rows(db_query("SELECT t1.tan FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT OUTER JOIN ".$db_prefix."_reloads AS t2 ON (t2.tan = t1.tan AND (t2.uid = ".$_SESSION['uid']." OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'forcedbanner' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != '".$_SESSION['uid']."'"));
$plhistory = mysql_num_rows(db_query("SELECT t1.tan FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT OUTER JOIN ".$db_prefix."_reloads AS t2 ON (t2.tan = t1.tan AND (t2.uid = ".$_SESSION['uid']." OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'paidlinks' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != '".$_SESSION['uid']."'"));
$pmhistory = mysql_num_rows(db_query("SELECT t1.tan FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT OUTER JOIN ".$db_prefix."_reloads_mail AS t2 ON (t2.tan = t1.tan AND (t2.uid = ".$_SESSION['uid']." OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'paidmail' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != '".$_SESSION['uid']."'"));
?>

<?menuehead("Verdienen");?>
<img src="images/pfeil.gif" alt="" />&nbsp;<a href="index.php?content=/verdienen/klick4">Forcedbanner (<?=$fbhistory;?>)</a><br />
<img src="images/pfeil.gif" alt="" />&nbsp;<a href="index.php?content=/verdienen/paidlinks">Textlinks (<?=$plhistory;?>)</a><br />
<img src="images/pfeil.gif" alt="" />&nbsp;<a href="index.php?content=/verdienen/easy-inbox">Paidmails (<?=$pmhistory;?>)</a><br />
<?menuefoot();?>
Für andere Werbearten wie Highforced geht es analog, man sollte das Ergebnis der SQL-Abfrage in einer neuen variable speichern, z.b. in $hfbhistory, und das SQL Statement ändern bei AND t1.werbeart = 'forcedbanner' statt forcedbanner dann highforced, sowie in der Ausgabe des Menüs statt <?=$fbhistory;?> dann <?=$hfbhistory;?> schreiben...