$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