include("auth.html"); ?>
$baseDIR = "/Free/www/2007.zuzunza.com"; ?>
include ("$baseDIR/include/dbfunc.inc"); ?>
include_once($DOCUMENT_ROOT . "/include/dirkutils.html"); ?>
$menu ="partner"; ?>
$CatName ="매출통계자료"; ?>
//include_once($DOCUMENT_ROOT . "/include/common.inc"); ?>
//===== 요일 구분
$WEEK_STR = Array(
0 => "일",
1 => "월",
2 => "화",
3 => "수",
4 => "목",
5 => "금",
6 => "토"
);
?>
//===== 충전 구분
$MENU_STR1 = Array(
0 => "일별충전금액",
1 => "월별충전금액",
2 => "년도별충전금액",
3 => "일별충전건수",
4 => "월별충전건수",
5 => "년도별충전건수"
);
?>
//===== 사용 구분
$MENU_STR2 = Array(
0 => "일별실행수",
1 => "월별실행수",
2 => "년도별실행수"
);
?>
openMySQL("ZUZUNZA");
$tbName = "flashgame_hit_total";
if ($what=="") $what = "일별충전금액";
$what = Trim($what);
$AlbaTitle = "관리자 : 결제통계 ($what)";
$CurrentMenuTree = "AX";
?>
qLNG($yy);
qLNG($mm);
qLNG($dd);
qSTR($what);
if ($yy==0) $yy = (int)date("Y");
if ($mm==0) $mm = (int)date("m");
if ($dd==0) $dd = (int)date("d");
$style = "norm";
//===== 요일구분
switch ($what) {
//================== 사용금액 =====================
case "년도별실행수":
case "년도별충전금액":
$sql = "SELECT year(reg_date), sum(hit), reg_date,fg_hit,myflash_hit,zuzunza_hit,all_hit,fgani_hit,cy_hit,eztoon_hit,illust_hit,mystudy_hit,myflash_num,friend_hit,talk_hit,cl_hit,boxman_hit,fashion_hit FROM $tbName WHERE hit>0 $whereStr GROUP BY year(reg_date) ORDER BY 1";
$title_nik = "년";
$title_hd = "년도별 $title_nm"."실행수";
$BarSize = 1/500000;
break;
case "월별실행수":
case "월별충전금액":
$sql = "SELECT month(reg_date), sum(hit), reg_date,sum(fg_hit),sum(myflash_hit),sum(zuzunza_hit),sum(all_hit),sum(fgani_hit),sum(cy_hit),sum(eztoon_hit),sum(illust_hit),sum(mystudy_hit),sum(myflash_num),sum(friend_hit),sum(talk_hit),sum(cl_hit),sum(boxman_hit),sum(fashion_hit) FROM $tbName WHERE hit>0 AND (year(reg_date)=$yy) $whereStr GROUP BY month(reg_date) ORDER BY 1";
$title_nik = "월";
$title_hd = "$yy년 월별 $title_nm"."실행수";
$BarSize = 1/50000;
break;
case "일별실행수":
case "일별충전금액":
$sql = "SELECT dayofmonth(reg_date), sum(hit),reg_date,sum(fg_hit),sum(myflash_hit),sum(zuzunza_hit),sum(all_hit),sum(fgani_hit),sum(cy_hit),sum(eztoon_hit),sum(illust_hit),sum(mystudy_hit),sum(myflash_num),sum(friend_hit),sum(talk_hit),sum(cl_hit),sum(boxman_hit),sum(fashion_hit) FROM $tbName WHERE hit>0 AND (year(reg_date)=$yy AND month(reg_date)=$mm) $whereStr GROUP BY dayofmonth(reg_date) ORDER BY 1";
$title_nik = "일";
$title_hd = "$yy년 $mm월 일자별 $title_nm"."실행수";
$BarSize=1/4000;
break;
}
if ($pid != "") $BarSize *= 4;
//debugStr($sql);
$res = mysql_query($sql, $db_con) or die(mysql_error());
?>
//금일 실행수 - 플래시애니
$Query = "select sum(today_hit) from flashgame_ani";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_fgani = $row[0];
?>
//금일 실행수 - 패션게임
$Query = "select sum(today_hit) from flashgame_fashion";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_fashion = $row[0];
?>
//총 실행수 - 플래시애니
$Query = "select sum(total_hit) from flashgame_ani";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_fgani = $row[0];
?>
//총 실행수 - 패션게임
$Query = "select sum(total_hit) from flashgame_fashion";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_fashion = $row[0];
?>
//금일 실행수 - 자작플래시
$Query = "select sum(today_hit) from flashgame_myflash";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_myflash = $row[0];
?>
$today = date("Y-m-d");
$tomorrow = date("Y-m-d",strtotime ("+1 day"));
//금일 등록수 - 자작플래시
$Query = "select count(*) from flashgame_myflash where reg_date between '$today' and '$tomorrow'";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_num_myflash = $row[0];
?>
//총 실행수 - 자작플래시
$Query = "select sum(total_hit) from flashgame_myflash";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_myflash = $row[0];
?>
//금일 실행수 - 강좌
$Query = "select sum(today_hit) from flashgame_mystudy";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_mystudy = $row[0];
?>
//전체 실행수 - 강좌
$Query = "select sum(total_hit) from flashgame_mystudy";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_mystudy = $row[0];
?>
//금일 실행수 - 일러스트
$Query = "select sum(today_hit) from flashgame_illust";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_illust = $row[0];
?>
//총 실행수 - 일러스트
$Query = "select sum(total_hit) from flashgame_illust";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_illust = $row[0];
?>
//최대 실행수 - 강좌
$Query = "select max(hit) from flashgame_hit_mystudy";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_mystudy = $row[0];
?>
//최대 실행수 - 일러스트
$Query = "select max(hit) from flashgame_hit_illust";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_illust = $row[0];
?>
//금일 실행수 - 토크
$Query = "select sum(ref2) from bfree";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_talk = $row[0];
?>
//금일 실행수 - 토크
$Query = "select sum(ref2) from bhumor";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_talk += $row[0];
?>
//금일 실행수 - 토크
$Query = "select sum(ref2) from bnovel";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_talk += $row[0];
?>
//금일 실행수 - 토크
$Query = "select sum(ref2) from bgame";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_talk += $row[0];
?>
//금일 실행수 - 토크
$Query = "select sum(ref2) from bbse";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_talk += $row[0];
?>
//최대 실행수 - 플래시게임
$Query = "select max(hit) from flashgame_hit";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_fg = $row[0];
?>
//최대 실행수 - 자작플래시
$Query = "select max(myflash_hit) from $tbName";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_myflash = $row[0];
?>
//최대 실행수 - 주전자게임
$Query = "select max(hit) from flashrank_hit";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_fgrank = $row[0];
?>
//최대 실행수 - 곰씨게임
$Query = "select max(hit) from flashall_hit";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_all = $row[0];
?>
//최대 실행수 - 코디게임
$Query = "select max(hit) from flashcy_hit";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_cy = $row[0];
?>
//최대 실행수 - 프렌드
$Query = "select max(hit) from flashgame_hit_friend";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_friend = $row[0];
?>
//최대 실행수 - 토크
$Query = "select max(hit) from flashgame_hit_talk";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$max_hits_talk = $row[0];
?>
//최대 실행수 - 전체
$Query = "select max(hit) from flashgame_hit_total";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_max_hit = $row[0];
?>
$db_con = null;
openMySql5("KIDSZZANG");
?>
//금일 실행수 - 플래시게임
$Query = "select sum(today_hit) from flashgame_game";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_fg = $row[0];
?>
//금일 실행수 - 곰씨게임
$Query = "select sum(today_hit) from flashgame_all";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_all = $row[0];
?>
//금일 실행수 - 키즈짱 자작게임
$Query = "select sum(today_hit) from daum_myflash";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$today_hits_kmyflash = $row[0];
?>
//총 실행수 - 플래시게임
$Query = "select sum(total_hit) from flashgame_game";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_fg = $row[0];
?>
//총 실행수 - 곰씨게임
$Query = "select sum(total_hit) from flashgame_all";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_all = $row[0];
?>
//총 실행수 - 키즈짱 자작게임
$Query = "select sum(total_hit) from daum_myflash";
$result = mysql_query($Query) or die(mysql_error());
$row = mysql_fetch_row($result);
mysql_free_result($result);
$total_hits_kmyflash = $row[0];
?>
//전체 오늘 실행수
$total_today_hit = $today_hits_fg + $today_hits_fgani + $today_hits_all + $today_hits_fgrank + $today_hits_myflash + $today_hits_cy + $today_hits_eztoon + $today_hits_illust + $today_hits_mystudy + $today_hits_talk + $today_hits_kmyflash + today_hits_fashion;
//전체 실행수
$total_hit = $total_hits_fg + $total_hits_fgani + $total_hits_all + $total_hits_fgrank + $total_hits_myflash + $total_hits_cy + $total_hits_eztoon + $total_hits_illust + $total_hits_mystudy + $total_hits_talk + $total_hits_kmyflash + $total_hits_fashion;
?>
금일 실행수 : =number_format($total_today_hit)?> / 최대 실행수 : =number_format($total_max_hit)?> / 총 실행수 : =number_format($total_hit)?> |
금일) 플래시게임 : =number_format($today_hits_fg)?> / 자작 : =number_format($today_hits_myflash)?>(=number_format($today_num_myflash)?>) / 키즈짱자작 : =number_format($today_hits_kmyflash)?> / 미니게임 : =number_format($today_hits_all)?> / 주닷패션 : =number_format($today_hits_fashion)?> / 애니 : =number_format($today_hits_fgani)?> / 일러스트 : =number_format($today_hits_illust)?> / 강좌 : =number_format($today_hits_mystudy)?> 토크 : =number_format($today_hits_talk)?> |
최대) 플래시게임 : =number_format($max_hits_fg)?> / 자작 : =number_format($max_hits_myflash)?> / 미니게임 : =number_format($max_hits_all)?> / / 미니게임 : =number_format($max_hits_all)?> / 일러스트 : =number_format($max_hits_illust)?> / 강좌 : =number_format($max_hits_mystudy)?> / 토크 : =number_format($max_hits_talk)?> |
전체) 플래시게임 : =number_format($total_hits_fg)?> / 자작 : =number_format($total_hits_myflash)?> / 미니게임 : =number_format($total_hits_all)?> 일러스트 : =number_format($total_hits_illust)?> / 강좌 : =number_format($total_hits_mystudy)?> / 토크 : =number_format($total_hits_talk)?> |
사용통계 |
for($i=0, $s=sizeof($MENU_STR2); $i<$s ; $i++) {
if($MENU_STR2[$i] == "$what") {
$menu_name = "".$MENU_STR2[$i]."";
} else {
$menu_name = $MENU_STR2[$i];
}
?>
=$menu_name?> |
}
?>
|
