0){ $child_result_total=mysql_fetch_array($child_result); $direct_child_opbrengst=$direct_child_opbrengst+$child_result_total['total']; } // for each child get 5 percent of the amount his partners earned $amount=$amount+$direct_child_opbrengst+(getstats($child['id'],$month,$year)*0.05); } return $amount; } if($login==TRUE){ if($op==""){ if($year==NULL){ $year=date('Y'); } if($month==NULL){ $month=date('m'); } include("includes/header.php"); for($i='2004';$i'.$i.''; } unset($i); for($i='1';$i<13;$i++){ $months.=''.$i.''; } unset($i); echo'
Statistik für '.$year.' - '.$month.'
Jahr: Monat:

'; $total_by_product=mysql_query("select sum(orders_products.product_price*orders_products.amount) as total, orders_new.promo as promo, sum(orders_products.amount) as amount, ((sum(orders_products.product_price*orders_products.amount)/100)*(products.partner_marge*orders_new.partner_marge)) as payout ,orders_products.product_id,(products.partner_marge*orders_new.partner_marge) as partner_marge,products.name as product_name from orders_new,products,orders_products where orders_new.partner_id='".$user['id']."' and orders_new.id=orders_products.order_id and orders_products.product_id=products.id and orders_new.orderstatus!='que' and orders_new.orderstatus!='bounced' and month(orders_new.orderdate)='".$month."' and year(orders_new.orderdate)='".$year."' group by orders_products.product_id,orders_new.promo,orders_new.partner_marge order by orders_new.promo asc,orders_products.product_id asc "); echo''; if(mysql_num_rows($total_by_product)>0){ echo''; echo''; $i=1; $numrows=0; while($total_product=mysql_fetch_array($total_by_product)){ echo''; $total=$total+$total_product['total']; $opbrengst=$opbrengst+$total_product['payout']; $aantal=$aantal+$total_product['amount']; ($i==0?$i=1:$i=0); } unset($i); } else { echo''; } $children=mysql_query("select id from partners where parent_id='".$user['id']."'"); if(mysql_num_rows($children)>0){ echo''; echo''; while($child=mysql_fetch_array($children)){ $child_result=mysql_query("select sum(orders_products.product_price*orders_products.amount) as total from orders_new,orders_products where orders_new.id=orders_products.order_id and orders_new.partner_id='".$child['id']."' and orders_new.orderstatus!='que' and orders_new.orderstatus!='bounced' and month(orders_new.orderdate)='".$month."' and year(orders_new.orderdate)='".$year."'"); //$child_result=mysql_query("select sum(product_price*amount) as total from orders where partner_id='".$child['id']."'"); if(mysql_num_rows($child_result)>0){ $child_result_total=mysql_fetch_array($child_result); $child_opbrengst=$child_opbrengst+$child_result_total['total']; } } $child_opbrengst=getstats($user['id'],$month,$year); $i=1; echo''; unset($i); $total=$total+$child_opbrengst; $opbrengst=$opbrengst+($child_opbrengst*0.05); } if($total!=NULL){ echo''; echo''; echo''; } echo'
Gesamtverkaufe pro Produkt bis jetzt.
UmsatzSpielraumProduktPromocodeAnzahlDeine Verdienste
€'.makezeros($total_product['total']).''.$total_product['partner_marge'].'%'.$total_product['product_name'].''.$total_product['promo'].''.$total_product['amount'].''.($total_product['payout']==NULL?'€ 0,-':'€ '.makezeros($total_product['payout'])).'
Du hast noch keine Verkaufe realisiert.

Partnerstatistik.
Partner UmsatzSpielraumAnzahl partnersDeine Verdienste
€'.makezeros($child_opbrengst).'5%Partner afdracht'.mysql_num_rows($children).''.($child_opbrengst==NULL?'€ 0,-':'€ '.makezeros(($child_opbrengst*0.05))).'

GesamtzahlAnzahl der ProdukteGesamtverdienste
€ '.makezeros($total).''.$aantal.'€ '.makezeros($opbrengst).'

* alle Beträge sind inkl. Mwst.

'; if(file_exists("../admin/facturen/".$year."-".$month."/".$user['id']."-".$year."-".$month.".html")){ echo'

'; } echo''; echo'Weitere statistik. '; include("includes/footer.php"); } elseif($op=="direct"){ include("includes/header.php"); ?> Statistik.

Statistik pro Shop gesamt von SilverRush.

Du promotest die folgenden Shops, hier findest Du eine Übersicht von Bannerviews und Clicks.
'; echo''; while($stats_shop=mysql_fetch_array($stats_shops)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
Shop NameViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_shop['name'].''.$stats_shop['views'].''.$stats_shop['hits'].''.($stats_shop['ratio']==NULL?'0%.':round($stats_shop['ratio'],2).'%').''.$stats_shop['sales'].''.($stats_shop['salesratio']==NULL?'0%':round($stats_shop['salesratio'],2).'%').'


'; echo'Shop, pro Tag der letzten Woche:
'; $stats_date_shops=mysql_query("select shops.name,shops.id,100/sum(stats_banners.views)*sum(stats_banners.hits)as ratio,100/sum(stats_banners.hits)*sum(stats_banners.sales) as salesratio,stats_banners.promo_txt as promo_txt, sum(stats_banners.sales) as sales, sum(stats_banners.hits) as hits, sum(stats_banners.views) as views,stats_banners.statsdate from stats_banners,shops LEFT JOIN banners ON (shops.id=banners.shop_id) where stats_banners.statsdate>now() - INTERVAL 7 DAY and stats_banners.partner_id=".$user['id']." and stats_banners.banner_id=banners.id group by shops.id, stats_banners.statsdate, stats_banners.promo_txt"); echo''; echo''; $i=0; while($stats_date_shop=mysql_fetch_array($stats_date_shops)){ echo''; $shops[$stats_date_shop['name']]=$stats_date_shop['id']; ($i==0?$i=1:$i=0); } unset($i); echo'
Shop NameViewsClicksClickRatioVerkaufenVerkaufsQuotePromoCodeDatum
'.$stats_date_shop['name'].''.$stats_date_shop['views'].''.$stats_date_shop['hits'].''.($stats_date_shop['ratio']==NULL?'0%':round($stats_date_shop['ratio'],2).'%').''.$stats_date_shop['sales'].''.($stats_date_shop['salesratio']==NULL?'0%':round($stats_date_shop['salesratio'],2).'%').''.$stats_date_shop['promo_txt'].''.$stats_date_shop['statsdate'].'

'; foreach($shops as $value){ echo'

'; } include("includes/footer.php"); } elseif($op=="pool"){ include("includes/header.php"); ?> Statistik.

Statistik pro Shop gesamt von GoldRush.

Du promotest über GoldRush die folgenden Shops, hier findest Du eine Übersicht von Bannerviews und Clicks.
'; echo''; while($stats_shop=mysql_fetch_array($stats_shops)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
Shop NameViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_shop['name'].''.$stats_shop['views'].''.$stats_shop['hits'].''.($stats_shop['ratio']==NULL?'0%.':round($stats_shop['ratio'],2).'%').''.$stats_shop['sales'].''.($stats_shop['salesratio']==NULL?'0%':round($stats_shop['salesratio'],2).'%').'


'; echo'Statistik pro Shop, pro Tag der letzten Woche:
'; $stats_date_shops=mysql_query("select shops.name,shops.id,100/sum(stats_pools.views)*sum(stats_pools.hits)as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.promo_txt as promo_txt, sum(stats_pools.sales) as sales, sum(stats_pools.hits) as hits, sum(stats_pools.views) as views,stats_pools.statsdate from stats_pools,shops LEFT JOIN banners ON (shops.id=banners.shop_id) where stats_pools.statsdate>now() - INTERVAL 7 DAY and stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id group by shops.id, stats_pools.statsdate,stats_pools.promo_txt"); if(mysql_num_rows($stats_date_shops)>0){ echo''; echo''; $i=0; while($stats_date_shop=mysql_fetch_array($stats_date_shops)){ echo''; $shops[$stats_date_shop['name']]=$stats_date_shop['id']; ($i==0?$i=1:$i=0); } unset($i); echo'
Shop NameViewsClicksClickRatioVerkaufenVerkaufsQuotePromoCodeDatum
'.$stats_date_shop['name'].''.$stats_date_shop['views'].''.$stats_date_shop['hits'].''.($stats_date_shop['ratio']==NULL?'0%':round($stats_date_shop['ratio'],2).'%').''.$stats_date_shop['sales'].''.($stats_date_shop['salesratio']==NULL?'0%':round($stats_date_shop['salesratio'],2).'%').''.$stats_date_shop['promo_txt'].''.$stats_date_shop['statsdate'].'

'; foreach($shops as $value){ echo'

'; } } else { echo'Letzte Woche gab es keine Views, Hits oder Verkaufe über Deinem Partner Code.
'; } include("includes/footer.php"); } elseif($op=="banner"){ include("includes/header.php"); $banners=mysql_query("select b.id,b.name,b.description,s.width,s.height,b.url,b.alt,b.content,t.id as type_id,t.code,b.views,b.hits,(100/b.views)*b.hits as ratio from banners b, banner_types t,banner_sizes s where b.type=t.id and b.size_id=s.id and b.id=".$banner_id." "); if(mysql_num_rows($banners)>0){ while($banner=mysql_fetch_array($banners)){ ?> Statistik. (SilverRush)
Statistik von banner '' gesamt.


'; $stats_banners=mysql_query("select banners.name,sum(stats_banners.views) as views, sum(stats_banners.hits) as hits, sum(stats_banners.sales) as sales,100/sum(stats_banners.views)*sum(stats_banners.hits) as ratio,100/sum(stats_banners.hits)*sum(stats_banners.sales) as salesratio,stats_banners.statsdate from stats_banners,banners where stats_banners.partner_id=".$user['id']." and stats_banners.banner_id=banners.id and banners.id=".$banner_id." group by banners.id"); echo'Gesamtzahl der Views und Hits
'; if(mysql_num_rows($stats_banners)>0){ echo''; $stats_banner=mysql_fetch_array($stats_banners); echo''; echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_banner['views'].''.$stats_banner['hits'].''.($stats_banner['ratio']==NULL?'0%.':round($stats_banner['ratio'],2).'%').''.$stats_banner['sales'].''.($stats_banner['salesratio']==0?'0%':round($stats_banner['salesratio'],2).'%').'


'; $stats_date_banners=mysql_query("select banners.name,sum(stats_banners.views) as views, sum(stats_banners.hits) as hits, sum(stats_banners.sales) as sales,100/sum(stats_banners.views)*sum(stats_banners.hits) as ratio,100/sum(stats_banners.hits)*sum(stats_banners.sales) as salesratio,stats_banners.statsdate ,stats_banners.promo_txt as promo_txt from stats_banners,banners where stats_banners.statsdate>now() - INTERVAL 7 DAY and stats_banners.partner_id=".$user['id']." and stats_banners.banner_id=banners.id and banners.id=".$banner_id." group by stats_banners.statsdate,stats_banners.promo_txt order by stats_banners.promo_txt, stats_banners.statsdate desc"); if(mysql_num_rows($stats_date_banners)>0){ echo'Statistik per dag van de afgelopen week per Promotion Code:
'; echo''; echo''; $i=0; while($stats_date_banner=mysql_fetch_array($stats_date_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromocodeDatum
'.$stats_date_banner['views'].''.$stats_date_banner['hits'].''.($stats_date_banner['ratio']==0?'0%.':round($stats_date_banner['ratio'],2).'%').''.$stats_date_banner['sales'].''.($stats_date_banner['salesratio']==0?'0%.':round($stats_date_banner['salesratio'],2).'%').''.$stats_date_banner['promo_txt'].''.$stats_date_banner['statsdate'].'

'; echo'

'; } else { echo'Letzte Woche gab es keine Views, Hits oder Verkaufe

'; } } else { echo'Noch keine Daten für diesen Banner.

'; } } } include("includes/footer.php"); } elseif($op=="pool_banner"){ include("includes/header.php"); $banners=mysql_query("select b.id,b.name,b.description,s.id as size, s.width,s.height,b.url,b.alt,b.content,t.id as type_id,t.code,b.views,b.hits,(100/b.views)*b.hits as ratio from banners b, banner_types t,banner_sizes s where b.type=t.id and b.size_id=s.id and b.id=".$banner_id." "); if(mysql_num_rows($banners)>0){ while($banner=mysql_fetch_array($banners)){ echo'Zurück zum Pool. | Zurück zu der Bannerübersicht des Pools.

'; ?> Statistik. (GoldRush)
tatistik dieses Banners '' gesamt.


'; $stats_banners=mysql_query("select banners.name,sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate from stats_pools,banners where stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.id=".$banner_id." and stats_pools.pool_id='".$pool_id."' group by banners.id"); echo'Gesamtzahl der Views und Hits.
'; if(mysql_num_rows($stats_banners)>0){ echo''; $stats_banner=mysql_fetch_array($stats_banners); echo''; echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_banner['views'].''.$stats_banner['hits'].''.($stats_banner['ratio']==NULL?'0%.':round($stats_banner['ratio'],2).'%').''.$stats_banner['sales'].''.($stats_banner['salesratio']==0?'0%':round($stats_banner['salesratio'],2).'%').'


'; $stats_date_banners=mysql_query("select banners.name,sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate ,stats_pools.promo_txt as promo_txt from stats_pools,banners where stats_pools.statsdate>now() - INTERVAL 7 DAY and stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.id=".$banner_id." and stats_pools.pool_id='".$pool_id."' group by stats_pools.statsdate,stats_pools.promo_txt order by stats_pools.promo_txt, stats_pools.statsdate desc"); if(mysql_num_rows($stats_date_banners)>0){ echo'Statistik pro Tag der letzten Woche pro Promotion Code:
'; echo''; echo''; $i=0; while($stats_date_banner=mysql_fetch_array($stats_date_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromocodeDatum
'.$stats_date_banner['views'].''.$stats_date_banner['hits'].''.($stats_date_banner['ratio']==0?'0%.':round($stats_date_banner['ratio'],2).'%').''.$stats_date_banner['sales'].''.($stats_date_banner['salesratio']==0?'0%.':round($stats_date_banner['salesratio'],2).'%').''.$stats_date_banner['promo_txt'].''.$stats_date_banner['statsdate'].'

'; echo'

'; } else { echo'Letzte Woche gab es keine Views, Hits oder Verkaufe

'; } } else { echo'Noch keine Daten für diesen Banner.

'; } } } include("includes/footer.php"); } elseif($op=="pool_size"){ include("includes/header.php"); $size=mysql_query("select width,height,id,name from banner_sizes where id='".$size_id."'"); if(mysql_num_rows($size)>0){ while($size=mysql_fetch_array($size)){ echo'Terug naar de pool. | Totale Statistik van deze afmeting.

'; ?> Statistik. (GoldRush)
Statistik für Maße '' fon 1 pool gesamt.

Voorbeeld afmetingen:
Breedte:'.$size['width'].'px
Hoogte:'.$size['height'].'px

'; $stats_banners=mysql_query("select banners.name,banners.id,sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate from stats_pools,banners where stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.size_id=".$size_id." and stats_pools.pool_id='".$pool_id."' group by banners.id"); echo'Gesamtzahl der Views und Hits.
'; if(mysql_num_rows($stats_banners)>0){ echo''; $i=0; while($stats_banner=mysql_fetch_array($stats_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
BannerViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_banner['name'].''.$stats_banner['views'].''.$stats_banner['hits'].''.($stats_banner['ratio']==NULL?'0%.':round($stats_banner['ratio'],2).'%').''.$stats_banner['sales'].''.($stats_banner['salesratio']==0?'0%':round($stats_banner['salesratio'],2).'%').'


'; $stats_date_banners=mysql_query("select sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate ,stats_pools.promo_txt as promo_txt from stats_pools,banners where stats_pools.statsdate>now() - INTERVAL 7 DAY and stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.size_id=".$size_id." and stats_pools.pool_id='".$pool_id."' group by stats_pools.statsdate,stats_pools.promo_txt order by stats_pools.promo_txt, stats_pools.statsdate desc"); if(mysql_num_rows($stats_date_banners)>0){ echo'Statistik pro Tag der letzten Woche pro Promotion Code:
'; echo''; echo''; $i=0; while($stats_date_banner=mysql_fetch_array($stats_date_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromocodeDatum
'.$stats_date_banner['views'].''.$stats_date_banner['hits'].''.($stats_date_banner['ratio']==0?'0%.':round($stats_date_banner['ratio'],2).'%').''.$stats_date_banner['sales'].''.($stats_date_banner['salesratio']==0?'0%.':round($stats_date_banner['salesratio'],2).'%').''.$stats_date_banner['promo_txt'].''.$stats_date_banner['statsdate'].'

'; echo'

'; } else { echo'Lezte Woche ist keine Statistik dieser Maße erstellt worden.

'; } } else { echo'Noch keine Daten für diese Maße.

'; } } } include("includes/footer.php"); } elseif($op=="pool_size_total"){ include("includes/header.php"); $size=mysql_query("select width,height,id,name from banner_sizes where id='".$size_id."'"); if(mysql_num_rows($size)>0){ while($size=mysql_fetch_array($size)){ echo'Terug naar de pool.

'; ?> Statistik. (GoldRush)
Statistik für Maße '' gesamt.

Vorbildmaße:
Breite:'.$size['width'].'px
Höhe:'.$size['height'].'px

'; $stats_banners=mysql_query("select banners.name,banners.id,sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate from stats_pools,banners where stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.size_id=".$size_id." group by banners.id"); echo'Gesamtzahl der Views und hits.
'; if(mysql_num_rows($stats_banners)>0){ echo''; $i=0; while($stats_banner=mysql_fetch_array($stats_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
BannerViewsClicksClickRatioVerkaufenVerkaufsQuote
'.$stats_banner['name'].''.$stats_banner['views'].''.$stats_banner['hits'].''.($stats_banner['ratio']==NULL?'0%.':round($stats_banner['ratio'],2).'%').''.$stats_banner['sales'].''.($stats_banner['salesratio']==0?'0%':round($stats_banner['salesratio'],2).'%').'


'; $stats_date_banners=mysql_query("select sum(stats_pools.views) as views, sum(stats_pools.hits) as hits, sum(stats_pools.sales) as sales,100/sum(stats_pools.views)*sum(stats_pools.hits) as ratio,100/sum(stats_pools.hits)*sum(stats_pools.sales) as salesratio,stats_pools.statsdate ,stats_pools.promo_txt as promo_txt from stats_pools,banners where stats_pools.statsdate>now() - INTERVAL 7 DAY and stats_pools.partner_id=".$user['id']." and stats_pools.banner_id=banners.id and banners.size_id=".$size_id." group by stats_pools.statsdate,stats_pools.promo_txt order by stats_pools.promo_txt, stats_pools.statsdate desc"); if(mysql_num_rows($stats_date_banners)>0){ echo'Letzten Woche pro Promotion Code:
'; echo''; echo''; $i=0; while($stats_date_banner=mysql_fetch_array($stats_date_banners)){ echo''; ($i==0?$i=1:$i=0); } unset($i); echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromocodeDatum
'.$stats_date_banner['views'].''.$stats_date_banner['hits'].''.($stats_date_banner['ratio']==0?'0%.':round($stats_date_banner['ratio'],2).'%').''.$stats_date_banner['sales'].''.($stats_date_banner['salesratio']==0?'0%.':round($stats_date_banner['salesratio'],2).'%').''.$stats_date_banner['promo_txt'].''.$stats_date_banner['statsdate'].'

'; echo'

'; } else { echo'Leider haben wir von diesem Maße noch keine Statistik.

'; } } else { echo'Noch keine Daten von diesem Maße.

'; } } } include("includes/footer.php"); } elseif($op=="silver_shop_week"){ include("includes/header.php"); $shop=mysql_query("select name,url,description from shops where id='".$shop_id."'"); if(mysql_num_rows($shop)>0){ $shop=mysql_fetch_array($shop); ?> Statistik. (SilverRush)
Die Statistik der Banner von den Shop '' der letzten Woche.

0){ echo''; while($banner=mysql_fetch_array($banners)){ echo''; echo''; } echo'
'.$banner['name'].'
'.($banner['ratio']>4?''.$banner['ratio'].'%':''.($banner['ratio']==NULL?'Nog geen clicks.':$banner['ratio'].'%').'').'		'.bannercheck($banner,$user,true).'
Statistik:'; $banner_stats=mysql_query("select statsdate,views,hits,sales,promo_txt,100/(views*hits) as ratio,100/(hits*sales) as salesratio,stats_banners.promo_txt as promo from stats_banners where partner_id='".$user['id']."' and banner_id='".$banner['id']."' and statsdate>now() - INTERVAL 7 DAY order by promo_txt,statsdate"); if(mysql_num_rows($banner_stats)>0){ echo''; echo''; $i=0; while($banner_stat=mysql_fetch_array($banner_stats)){ echo''; ($i==0?$i=1:$i=0); } echo'
DatumViewsClicksClickRatioVerkaufenVerkaufsQuotePromotion Code
'.$banner_stat['statsdate'].''.$banner_stat['views'].''.$banner_stat['hits'].''.($banner_stat['ratio']==NULL?'0%.':round($banner_stat['ratio'],2).'%').''.$banner_stat['sales'].''.($banner_stat['salesratio']==NULL?'0%':round($banner_stat['salesratio'],2).'%').''.$banner_stat['promo'].'
'; } else { echo'Leider haben wir von diesem Banner noch keine Statistik der letzten Woche.'; } echo'
'; } else { echo'Leider gibt es noch keine Banner für diesen Shop.'; } } else { echo'Den gewählten Shop kennen wir nicht.'; } include("includes/footer.php"); } elseif($op=="silver_shop"){ include("includes/header.php"); $shop=mysql_query("select name,url,description from shops where id='".$shop_id."'"); if(mysql_num_rows($shop)>0){ $shop=mysql_fetch_array($shop); ?> Statistik. (SilverRush)
Die Statistik der Banner von den Shop '' gesamt.

0){ echo''; while($banner=mysql_fetch_array($banners)){ echo''; echo''; } echo'
'.$banner['name'].'
'.($banner['ratio']>4?''.$banner['ratio'].'%':''.($banner['ratio']==NULL?'Nog geen clicks.':$banner['ratio'].'%').'').'		'.bannercheck($banner,$user,true).'
Statistik:'; $banner_stats=mysql_query("select sum(views) as views,sum(hits) as hits,sum(sales) as sales,promo_txt as promo,100/sum(views)*sum(hits) as ratio,100/sum(hits)*sum(sales) as salesratio from stats_banners where partner_id='".$user['id']."' and banner_id='".$banner['id']."' group by promo_txt order by promo_txt"); echo mysql_error(); if(mysql_num_rows($banner_stats)>0){ echo''; echo''; $i=0; while($banner_stat=mysql_fetch_array($banner_stats)){ echo''; ($i==0?$i=1:$i=0); } echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromotion Code
'.$banner_stat['views'].''.$banner_stat['hits'].''.($banner_stat['ratio']==NULL?'0%.':round($banner_stat['ratio'],2).'%').''.$banner_stat['sales'].''.($banner_stat['salesratio']==NULL?'0%':round($banner_stat['salesratio'],2).'%').''.$banner_stat['promo'].'
'; } else { echo'Noch keine Daten für diesen Banner.'; } echo'
'; } else { echo'Leider gibt es noch keine Banner für diesen Shop.'; } } else { echo'Den gewählten Shop kennen wir nicht.'; } include("includes/footer.php"); } elseif($op=="gold_shop"){ include("includes/header.php"); $shop=mysql_query("select name,url,description from shops where id='".$shop_id."'"); if(mysql_num_rows($shop)>0){ $shop=mysql_fetch_array($shop); ?> Statistik. (GoldRush)
Die Statistik der Banner von den Shop '' gesamt.

0){ echo''; while($banner=mysql_fetch_array($banners)){ echo''; echo''; } echo'
'.$banner['name'].'
'.($banner['ratio']>4?''.$banner['ratio'].'%':''.($banner['ratio']==NULL?'Nog geen clicks.':$banner['ratio'].'%').'').'		'.bannercheck($banner,$user,true).'
Statistik:'; $banner_stats=mysql_query("select sum(views) as views,sum(hits) as hits,sum(sales) as sales,promo_txt as promo,100/sum(views)*sum(hits) as ratio,100/sum(hits)*sum(sales) as salesratio from stats_pools where partner_id='".$user['id']."' and banner_id='".$banner['id']."' group by promo_txt order by promo_txt"); if(mysql_num_rows($banner_stats)>0){ echo''; echo''; $i=0; while($banner_stat=mysql_fetch_array($banner_stats)){ echo''; ($i==0?$i=1:$i=0); } echo'
ViewsClicksClickRatioVerkaufenVerkaufsQuotePromotion Code
'.$banner_stat['views'].''.$banner_stat['hits'].''.($banner_stat['ratio']==NULL?'0%.':round($banner_stat['ratio'],2).'%').''.$banner_stat['sales'].''.($banner_stat['salesratio']==NULL?'0%':round($banner_stat['salesratio'],2).'%').''.$banner_stat['promo'].'
'; } else { echo'Noch keine Daten für diesen Banner.'; } echo'
'; } else { echo'Leider gibt es noch keine Banner für diesen Shop.'; } } else { echo'Den gewählten Shop kennen wir nicht.'; } include("includes/footer.php"); } elseif($op=="gold_shop_week"){ include("includes/header.php"); $shop=mysql_query("select name,url,description from shops where id='".$shop_id."'"); if(mysql_num_rows($shop)>0){ $shop=mysql_fetch_array($shop); ?> Statistik. (GoldRush)
Die Statistik der Banner von den Shop '' der letzten Woche.

0){ echo''; while($banner=mysql_fetch_array($banners)){ echo''; echo''; } echo'
'.$banner['name'].'
'.($banner['ratio']>4?''.$banner['ratio'].'%':''.($banner['ratio']==NULL?'Nog geen clicks.':$banner['ratio'].'%').'').'		'.bannercheck($banner,$user,true).'
Statistik:'; $banner_stats=mysql_query("select statsdate,views,hits,sales,promo_txt as promo,100/(views*hits) as ratio,100/(hits*sales) as salesratio, stats_pools.promo_txt as promo from stats_pools where partner_id='".$user['id']."' and banner_id='".$banner['id']."' and statsdate>now() - INTERVAL 7 DAY order by promo_txt,statsdate"); if(mysql_num_rows($banner_stats)>0){ echo''; echo''; $i=0; while($banner_stat=mysql_fetch_array($banner_stats)){ echo''; ($i==0?$i=1:$i=0); } echo'
DatumViewsClicksClickRatioVerkaufenVerkaufsQuotePromotion Code
'.$banner_stat['statsdate'].''.$banner_stat['views'].''.$banner_stat['hits'].''.($banner_stat['ratio']==NULL?'0%.':round($banner_stat['ratio'],2).'%').''.$banner_stat['sales'].''.($banner_stat['salesratio']==NULL?'0%':round($banner_stat['salesratio'],2).'%').''.$banner_stat['promo'].'
'; } else { echo'Leider haben wir von diesem Banner noch keine Statistik der letzten Woche.'; } echo'
'; } else { echo'Leider gibt es noch keine Banner für diesen Shop.'; } } else { echo'Den gewählten Shop kennen wir nicht.'; } include("includes/footer.php"); } } else { $url="stats.php"; include("includes/loginbox.php"); } ?>