$row['SITE_LANG'] = 'all';
}
$lang = trim($row['SITE_LANG']);
$lang = $acceptLangCookie[$lang];
if ($lang == NULL) {
continue;
}
$query = "UPDATE day set newUv = '" . $row['COUNT(DISTINCTSESSION_ID)'] . "' where lang ='" . $lang . "' and time ='" . $s_timerang . "' and websiteid='" . $row['WEBSITEID'] . "'";
$mysql_insert_result = mysql_query($query, $web_statis_link);
}
oci_free_statement($oracle_result);
//统计每天访问深度和平均停留时间
echo "\n";
echo '----------------------------------------------------------------- @' . $s_timerang . '-- order products---------------------------------------';
echo "\n";
$website_array = get_website();
//print_r($website_array);exit;
foreach ($website_array as $v) {
foreach ($acceptLangCookie as $key => $value) {
$query = "select avg(COUNT(ip)) as visitdepth,AVG (max(GMT_DATETIME) - min(GMT_DATETIME)) * 24*3600 as avgtime from web_log_result where ";
$query .= $time_rang . " and site_lang='{$key}' and WEBSITEID='{$v}' GROUP BY session_id";
$oracle_result = oci_parse($conn, $query);
oci_execute($oracle_result);
while ($row = oci_fetch_array($oracle_result, OCI_ASSOC + OCI_RETURN_NULLS)) {
$query = "UPDATE day set visitdepth = '" . $row['VISITDEPTH'] . "',visittime='" . $row["AVGTIME"] . "' where lang ='" . $value . "' and time ='" . $s_timerang . "' and websiteid='{$v}'";
$mysql_insert_result = mysql_query($query, $web_statis_link);
}
}
}
oci_free_statement($oracle_result);
//统计每天订单数及注册数和订单
echo $field_type;
?>
" id="<?php
echo handle_setting($term[$id]);
?>
field" name="<?php
echo handle_setting($term[$id]);
?>
"
<?php
if ($id == 0 && $setting_type == 'account') {
echo 'value="' . get_email($username) . '"';
} elseif ($id == 0 && $setting_type == 'profile') {
echo 'value="' . get_fullname($username, FALSE, FALSE) . '"';
} elseif ($id == 2 && $setting_type == 'profile') {
echo 'value="' . get_website($username, FALSE) . '"';
}
?>
/>
<?php
}
?>
</div>
<?php
}
?>
<div class="clear"></div>
<?php
if ($id == 3 && $setting_type == 'profile' || $id == 3 && $setting_type == 'account' || $id == 1 && $setting_type == 'account' || $setting_type == 'twitter') {
} else {
?>
</a>
</li>
</ul>
<div class="clear"></div>
</div>
<?php
}
?>
<div class="info user_info">
<?php
if (get_website($userid, FALSE) != "") {
?>
<div class="left">URL</div>
<div class="right">
<?php
echo get_website($userid);
?>
</div>
<div class="clear"></div>
<?php
}
if (get_twitter($userid, FALSE) != "") {
?>
<div class="left">Twitter</div>
<div class="right">
<?php
echo get_twitter($userid);
?>
</div>
<div class="clear"></div>
<?php
