Addon_MediadatenPro

jap nutze sie, nutzt aber nur wenn du auch anpasst, textlinks heißen nicht immer so zum bsp.

hier mal meine, unerwünschtes einfach löschen

PHP-Code:

<? if (!isset($fc_gebucht)) $fc_gebucht = ''; if (!isset($fc_menge)) $fc_menge = ''; if (!isset($fc_wert)) $fc_wert = ''; if (!isset($in_fc_gebucht)) $in_fc_gebucht = ''; if (!isset($in_fc_menge)) $in_fc_menge = ''; if (!isset($in_fc_wert)) $in_fc_wert = ''; // Textlinks Anfang if (!isset($fc_txt_gebucht)) $fc_txt_gebucht = ''; if (!isset($fc_txt_menge)) $fc_txt_menge = ''; if (!isset($fc_txt_wert)) $fc_txt_wert = ''; if (!isset($in_fc_txt_gebucht)) $in_fc_txt_gebucht = ''; if (!isset($in_fc_txt_menge)) $in_fc_txt_menge = ''; if (!isset($in_fc_txt_wert)) $in_fc_txt_wert = ''; // Textlinks Ende // Klick4Win Anfang if (!isset($fc_k4w_gebucht)) $fc_k4w_gebucht = ''; if (!isset($fc_k4w_menge)) $fc_k4w_menge = ''; if (!isset($fc_k4w_wert)) $fc_k4w_wert = ''; if (!isset($in_fc_k4w_gebucht)) $in_fc_k4w_gebucht = ''; if (!isset($in_fc_k4w_menge)) $in_fc_k4w_menge = ''; if (!isset($in_fc_k4w_wert)) $in_fc_k4w_wert = ''; // Klick4Win Ende $kontostats = mysql_fetch_array(db_query("SELECT COUNT(uid) AS kd_uid , SUM(kontostand) AS kd_kontostand , SUM(kontostand_euro) AS kd_kontostand_euro , SUM(klicks) AS kd_klicks , SUM(angebettelt) AS kd_angebettelt , SUM(s_aufrufe) AS kd_s_aufrufe , SUM(s_verdienst) AS kd_s_verdienst , SUM(kv) AS kd_kv , SUM(bv) AS kd_bv FROM ".$db_prefix."_kontodaten")); $werberdaten = mysql_fetch_array(db_query("SELECT SUM(gesamt) AS wd_gesamt FROM ".$db_prefix."_werberdaten")); $ex_fc = db_query("SELECT * FROM ".$db_prefix."_gebuchte_werbung WHERE menge >= 1 and werbeart = 'forcedbanner' and status = '1'"); while ($count = mysql_fetch_array($ex_fc)) { $fc_gebucht++; $fc_menge = $fc_menge + $count['menge']; $fc_wert = $fc_wert + ($count['verdienst']*$count['menge']); } // Textlinks Anfang $ex_fc_txt = db_query("SELECT * FROM ".$db_prefix."_gebuchte_werbung WHERE menge >= 1 and werbeart = 'paidlinks' and status = '1'"); while ($count = mysql_fetch_array($ex_fc_txt)) { $fc_txt_gebucht++; $fc_txt_menge = $fc_txt_menge + $count['menge']; $fc_txt_wert = $fc_txt_wert + ($count['verdienst']*$count['menge']); } // Textlinks Ende // Klick4Win Anfang $ex_fc_k4w = db_query("SELECT * FROM ".$db_prefix."_gebuchte_werbung WHERE menge >= 1 and werbeart = 'klick4win' and status = '1'"); while ($count = mysql_fetch_array($ex_fc_k4w)) { $fc_k4w_gebucht++; $fc_k4w_menge = $fc_k4w_menge + $count['menge']; $fc_k4w_wert = $fc_k4w_wert + ($count['verdienst']*$count['menge']); } // Klick4Win Ende $heute = strtotime("".date("m")."/".date("d")."/".date("Y").""); // Format mm.tt.yyyy $seitenstart = strtotime("08/12/2006"); // Format mm.tt.yyyy $tage = ($heute - $seitenstart) / 86400; if ($tage <= 1) $tage = 1; // Paidmail-Daten aus der Datenbank holen - Anfang $paidmail = mysql_fetch_array(db_query("SELECT COUNT(tan) AS pm_anz , SUM(menge) AS pm_vanz , SUM(verdienst) AS ve_ge , COUNT(verdienst) AS ve_anz , SUM(bestaedigt) AS pm_bs FROM ".$db_prefix."_paidmails_versendet")); // Paidmail-Daten aus der Datenbank holen - Ende // Blackliste aus der Datenbank holen - Anfang $blacklist = mysql_fetch_array(db_query("SELECT COUNT(uid) AS bl_uid FROM ".$db_prefix."_userblacklist")); // Blackliste aus der Datenbank holen - Ende // Aktueller Banner-Jackpot aus der Datenbank holen - Anfang $bjd_ak = mysql_fetch_array(db_query("SELECT SUM(banner_jackpot) AS bjp_jp FROM ".$db_prefix."_check_jackpots WHERE beendet = 0")); // Aktueller Banner-Jackpot aus der Datenbank holen - Ende // Weitere Infos zum Banner-Jackpot aus der Datenbank holen - Anfang $bjd_an = mysql_fetch_array(db_query("SELECT COUNT(beendet) AS bj_anz , SUM(banner_jackpot) AS bj_jp FROM ".$db_prefix."_check_jackpots WHERE beendet = 1")); // Weitere Infos zum Banner-Jackpot aus der Datenbank holen - Ende ?> <?head("Mediadaten - $seitenname");?> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Start dieser Seite</td> <td width="50%"><?=date("d.m.Y",$seitenstart);?></td> </tr> <tr> <td width="50%">Guthaben aller User</td> <td width="50%"><?=@number_format($kontostats['kd_kontostand'],2,",",".");?> <?=$waehrung;?></td> </tr> <hr width="100%" size="1" color="#800000"> <tr> <td width="50%">Guthaben Ø pro User</td> <td width="50%"><?=@number_format($kontostats['kd_kontostand'] / $kontostats['kd_uid'],2,",",".");?> <?=$waehrung;?></td> </tr> <tr> <td width="50%">Euro-Guthaben aller User</td> <td width="50%"><?=@number_format($kontostats['kd_kontostand_euro'],6,",",".");?> <b> Euro</b></td> </tr> <tr> <td width="50%">Euro-Guthaben Ø pro User</td> <td width="50%"><?=@number_format($kontostats['kd_kontostand_euro'] / $kontostats['kd_uid'],6,",",".");?><b> Euro</b></td> </tr> <hr width="100%" size="1" color="#800000"> <tr> <td width="50%">Angemeldete User</td> <td width="50%"><?=@number_format($kontostats['kd_uid'],0,",",".");?></td> </tr> <tr> <td width="50%">Anmeldungen pro Tag</td> <td width="50%"><?=@number_format($kontostats['kd_uid'] / $tage,2,",",".");?></td> </tr> <? @require_once ('lib/functions.lib.php'); $stats = mysql_fetch_array(db_query("SELECT einzahl FROM ".$db_prefix."_stats where id=1")); ?> <td width="50%">Gesamt eingezahlt von User</td> <td width="50%"><?=@number_format($stats['einzahl'] ,2,",",".");?> <?=$waehrung;?></td> </tr> <tr><? @require_once ('lib/functions.lib.php'); $stats = mysql_fetch_array(db_query("SELECT auszahl FROM ".$db_prefix."_stats where id=1")); ?> <td width="50%">Gesamt Ausgezahlt an User</td> <td width="50%"><?=@number_format($stats['auszahl'] ,2,",",".");?> <?=$waehrung;?></td> <tr><? @require_once ('lib/functions.lib.php'); $euro = mysql_fetch_array(db_query("SELECT COUNT(aid) AS kd_aid , SUM(kd_summe) AS kd_summe FROM ".$db_prefix."_euroaddon_auszahlungen")); ?> <td width="50%">Gesamt Ausgezahlt an User</td> <td width="50%"><?=@number_format($euro['summe'] ,2,",",".");?> <b> Euro</b></td> </table> <hr width="100%" size="1" color="#800000"> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Gesperrte User (auch von Klamm.de) </td> <td width="50%"><?=@number_format($blacklist['bl_uid'],0,",",".");?></td> </tr> <tr> <td width="50%">Gesperrte User pro Tag</td> <td width="50%"><?=@number_format($blacklist['bl_uid'] / $tage,2,",",".");?></td> </tr> </table> <?foot();?> <?head("Mediadaten - Diverses");?> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Forcedklicks aller User</td> <td width="50%"><?=@number_format($kontostats['kd_klicks'],0,",",".");?> Klicks</td> </tr> <tr> <td width="50%">Verdienst bei allen Forcedklicks</td> <td width="50%"><?=@number_format($kontostats['kd_kv'],2,",",".");?> <?=$waehrung;?></td> </tr> <tr> <td width="50%">Ø Verdienst pro Klick</td> <td width="50%"><?=@number_format($kontostats['kd_kv']/$kontostats['kd_klicks'],2,",",".");?> <?=$waehrung;?></td> </tr> </table> <hr width="100%" size="1" color="#800000"> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Bettelaufrufe alle User</td> <td width="50%"><?=@number_format($kontostats['kd_angebettelt'],0,",",".");?> Aufrufe</td> </tr> <tr> <td width="50%">Verdienst bei allen Bettelaufrufen</td> <td width="50%"><?=@number_format($kontostats['kd_bv'],2,",",".");?> <?=$waehrung;?></td> </tr> <tr> <td width="50%">Ø Verdienst pro Aufruf</td> <td width="50%"><?=@number_format($kontostats['kd_bv']/$kontostats['kd_angebettelt'],2,",",".");?> <?=$waehrung;?></td> </tr> </table> <hr width="100%" size="1" color="#800000"> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Startseitenaufrufe alle User</td> <td width="50%"><?=@number_format($kontostats['kd_s_aufrufe'],0,",",".");?> Aufrufe</td> </tr> <tr> <td width="50%">Verdienst bei allen Startseitenaufrufe</td> <td width="50%"><?=@number_format($kontostats['kd_s_verdienst'],2,",",".");?> <?=$waehrung;?></td> </tr> </table> <hr width="100%" size="1" color="#800000"> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <td width="50%">Refverdienste für alle Werber</td> <td width="50%"><?=@number_format($werberdaten['wd_gesamt'],2,",",".");?> <?=$waehrung;?></td> </tr> </table> <hr width="100%" size="1" color="#800000"> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Bannerjackpot im Moment</td> <td width="50%"><?=@number_format($bjd_ak['bjp_jp'],0,",",".");?> <?=$waehrung;?></td> </tr> <tr> <td width="50%">Gewonnene Bannerjackpots</td> <td width="50%"><?=@number_format($bjd_an['bj_anz'],0,",",".");?></td> </tr> <tr> <td width="50%">Insgesamt gewonnene <?=$waehrung;?></td> <td width="50%"><?=@number_format($bjd_an['bj_jp'],0,",",".");?></td> </tr> <tr> <td width="50%">Ø gewonnene <?=$waehrung;?></td> <td width="50%"><?=@number_format($bjd_an['bj_jp']/($bjd_an['bj_anz']),2,",",".");?></td> </tr> </table> <?foot();?> <?head("Mediadaten - Werbung");?> <table width="100%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%">Forcedklick Kampagnen</td> <td width="50%"><?=@number_format($fc_gebucht,0,",",".");?> Kampagnen</td> </tr> <tr> <td width="50%">Forcedklick Restklicks</td> <td width="50%"><?=@number_format($fc_menge,0,",",".");?> Klicks</td> </tr> <tr> <td width="50%">Forcedklicks Gesamtwert</td> <td width="50%"><?=@number_format($fc_wert,2,",",".");?> <?=$waehrung;?></td> </tr>  <tr> <td width="50%">Klick 4 Win Kampagnen</td> <td width="50%"><?=@number_format($fc_k4w_gebucht,0,",",".");?> Kampagnen</td> </tr> <tr> <td width="50%">Klick 4 Win Restklicks</td> <td width="50%"><?=@number_format($fc_k4w_menge,0,",",".");?> Klicks</td> </tr> <tr> <td width="50%">Klick 4 Win Gesamtwert</td> <td width="50%"><?=@number_format($fc_k4w_wert,2,",",".");?> <?=$waehrung;?></td> </tr>   <tr> <td width="50%">Klick 4 Text Kampagnen</td> <td width="50%"><?=@number_format($fc_txt_gebucht,0,",",".");?> Kampagnen</td> </tr> <tr> <td width="50%">Klick 4 Text Restklicks</td> <td width="50%"><?=@number_format($fc_txt_menge,0,",",".");?> Klicks</td> </tr> <tr> <td width="50%">Klick 4 Text Gesamtwert</td> <td width="50%"><?=@number_format($fc_txt_wert,2,",",".");?> <?=$waehrung;?></td> </tr>  </tr> </table> <hr width="100%" size="1" color="#800000"> <?foot();?>