function child_render($param)
{
global $g_page, $g_cfg;
$g_page["frame"] = "site_admin/frame.html";
if (!http_user_auth("admin", "admin")) {
return redirect("/");
}
if (isset($param[1]) && $param[1] == "switch_status") {
list($cname, $p) = [$_GET["name"], $_GET["p"]];
if ($p == "close") {
dbupdate("sys_variations", [], ["test" => $cname], ["completed" => "now()"]);
}
return redirect("/stats/multivariants");
}
$q = gettable("select * from sys_variations where completed is null");
$t = [];
foreach ($q as $row) {
if (!isset($t[$row["test"]])) {
$t[$row["test"]] = [];
}
if (!isset($t[$row["test"]][$row["variation"]])) {
$t[$row["test"]][$row["variation"]] = ["goals" => []];
}
$t[$row["test"]][$row["variation"]]["content"] = substr($row["content"], 0, 256);
$cm = new Variant($row["test"]);
$t[$row["test"]][$row["variation"]]["enrolled"] = $cm->get() == $row["variation"] ? 1 : 0;
$t[$row["test"]][$row["variation"]]["variation"] = $row["variation"];
$cv = [];
$cgoal = $row;
$cgoal["pc"] = $row["sample"] == 0 ? "N/A" : round($row["conversion"] / $row["sample"] * 100, 2);
$t[$row["test"]][$row["variation"]]["goals"][] = $cgoal;
$t[$row["test"]][$row["variation"]] = update($t[$row["test"]][$row["variation"]], $cv);
}
$res = [];
foreach ($t as $name => $row) {
$cm = [];
foreach ($t[$name] as $varname => $cvar) {
uasort($cvar["goals"], function ($a, $b) {
global $g_mv_goals;
if (($i = array_search($a["goal"], $g_mv_goals)) === false) {
return -1;
}
if (($j = array_search($b["goal"], $g_mv_goals)) === false) {
return -1;
}
if ($i == $j) {
return 0;
}
return $i > $j ? 1 : -1;
});
$cm[] = $cvar;
}
$res[] = ["test" => $name, "var" => $cm];
}
// print_r($res); exit;
$scr = new Scriptor("site_admin/multivariants.html", ["tests" => $res]);
return $scr->result();
}
echo "Invalid ID, please try again and make sure the ID is a valid sid in the database";
exit;
}
require 'functions.php';
if (isset($_POST['import']) and is_numeric($sid)) {
$import = $_POST['import'];
$arr = explode(',', $import);
$run = srvspecsimp($arr['0'], $arr['1'], $arr['2'], $arr['3'], $arr['4'], $arr['5'], $arr['6'], $arr['7'], $sid);
if ($run == true) {
echo "<div class=\"view-messages\">Import Successful!</div>";
} else {
echo "<div class=\"view-messages\">Import Failed.</div>";
}
}
if (isset($_POST['name']) and is_numeric($sid)) {
$run = dbupdate($_POST['name'], $_POST['provider'], $_POST['city'], $_POST['state'], $_POST['country'], $_POST['datacenter'], $_POST['cost'], $_POST['cycle'], $_POST['start'], $_POST['due'], $_POST['ram'], $_POST['swap'], $_POST['cpu'], $_POST['cpunum'], $_POST['cpuclock'], $_POST['bw'], $_POST['port'], $_POST['disk'], $_POST['disktype'], $_POST['ipv4'], $_POST['ipv6'], $_POST['notes'], $_POST['services'], $sid);
if ($run == true) {
echo "<div class=\"view-messages\">Edit Success!</div>";
} else {
echo "<div class=\"view-messages\">Edit Failed.</div>";
}
}
$db = new SQLite3('ktoys.db3');
$result = $db->query("SELECT * FROM services WHERE sid='{$sid}'") or die('Query failed');
$cnt = $result->fetchArray();
$cnt = $cnt['sid'];
if ($cnt <= '0') {
echo "Invalid ID, please try again and make sure the ID is a valid sid in the database";
exit;
}
$result = $db->query("SELECT * FROM services WHERE sid='{$sid}'") or die('Query failed');
function update_password()
{
$username = getgpc("username");
$old_password = getgpc("old_password");
$new_password = getgpc("new_password");
$new_password1 = getgpc("new_password1");
$data = array();
$md5salt = $this->config->item("md5salt");
if ($username) {
//
$res = fetch_one_array("select * from " . dbtable("admin_user") . " where username='******'");
if (!$res) {
alert("错误，找不到该用户");
} elseif ($res["password"] != md5($md5salt . $old_password)) {
alert("输入旧密码不正确！");
}
}
if (empty($old_password)) {
alert("请输入旧密码");
}
if (empty($new_password)) {
alert("请输入新密码");
}
if (empty($new_password1)) {
alert("请输入确认密码");
}
if ($old_password == $new_password) {
alert("请输入旧密码与新密码一样");
}
if ($new_password != $new_password1) {
alert("请输入新密码与确认密码不一致");
} else {
$updata['password'] = md5($md5salt . $new_password);
dbupdate("admin_user", $updata, array('username' => $username));
// echo" <script language='javascript'>this.close();alert('修改密码成功，请记住新密码哟！');</script>";
alert("修改密码成功，请记住新密码哟！", "admin.php?mod=login");
}
// $this->db->update('admin_user', $updata);
}
function variant_recalculate()
{
global $g_mv_goals, $g_mv_tests;
$res = [];
foreach ($g_mv_tests as $row) {
$res[$row["test"] . "|" . $row["variation"] . "|" . $row["goal"] . "|sample"] = [];
$res[$row["test"] . "|" . $row["variation"] . "|" . $row["goal"] . "|conversion"] = [];
$res[$row["test"] . "|" . $row["variation"] . "|" . $row["goal"] . "|start_log_id"] = $row["start_log_id"];
}
// print_r($res); exit;
// add sessions
$q = gettable("select * from sys_sessions where ishuman = 1");
session_start();
foreach ($q as $row) {
foreach (array_keys($_SESSION) as $ckeys) {
unset($_SESSION[$ckeys]);
}
if (!session_decode($row["session_data"])) {
internal_error("Unable to unserialize: " . $row["session_data"]);
}
$res = variant_recalculate_identity($res, $_SESSION);
}
// add users
$q = gettable("select * from usr_users");
foreach ($q as $row) {
$srow = json_decode($row["session_data"], true);
if ($srow == null) {
continue;
}
$nrow = json_decode($row["usr_notes"], true);
if ($nrow == null) {
continue;
}
if (isset($nrow["_mg_cancellation"])) {
$srow["_mg_cancellation"] = intval($nrow["_mg_cancellation"]);
}
$res = variant_recalculate_identity($res, $srow);
}
// print_r($g_mv_tests ); exit;
$ckeys = array_keys($res);
foreach ($g_mv_tests as $row) {
$sample = count(array_unique($res[$row["test"] . "|" . $row["variation"] . "|" . $row["goal"] . "|sample"]));
$conv = count(array_unique($res[$row["test"] . "|" . $row["variation"] . "|" . $row["goal"] . "|conversion"]));
$cwhere = update([], $row, ["test", "variation", "goal"]);
dbupdate("sys_variations", ["sample" => $sample, "conversion" => $conv], $cwhere);
}
}
public function saveedit_area()
{
//保存产品
$id = getgpc("id");
if ($id) {
$res = fetch_one_array("select * from " . dbtable("joininfo_area") . " where id ='" . $id . "' ");
if (!$res) {
alert("错误，没有找到该数据", "");
}
}
$name = getgpc("name");
$tel = getgpc("tel");
$email = getgpc("email");
$join_name = getgpc("join_name");
$area = getgpc("area");
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
$indata = array("name" => $name, "join_name" => $join_name, "tel" => $tel, "area" => $area, "email" => $email, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
$indata["gtime"] = date("Y-m-d H:i:s");
dbinsert("joininfo_area", $indata);
} else {
$indata["uptime"] = date("Y-m-d H:i:s");
dbupdate("joininfo_area", $indata, array('id' => $id));
}
js_alert("保存成功", "top.location.href='?mod=joininfo&act=area'");
}
function saveadd()
{
//保存新增新闻
$id = trim(getgpc("id"));
$title = trim(getgpc("title"));
$en_title = trim(getgpc("en_title"));
$comfrom = getgpc("comfrom");
$intr = getgpc("intr");
$content_img1 = getgpc("content_img1");
$content_img2 = getgpc("content_img2");
$content_img3 = getgpc("content_img3");
$content_img4 = getgpc("content_img4");
$showtime = getgpc("showtime");
$showtime = $showtime ? $showtime : date("Y-m-d H:i:s");
$content = getgpc("content");
$imgurl = trim(getgpc("imgurl"));
$tags = trim(getgpc("tags"));
$iskv = intval(getgpc("iskv"));
$istop = intval(getgpc("istop"));
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
if (!$title) {
js_alert("请填写标题");
}
if (!$intr) {
js_alert("请填写简介");
}
if (!$status) {
js_alert("请选择状态");
}
//数据正常，入库
$data = array('title' => $title, 'en_title' => $en_title, 'imgurl' => $imgurl, 'showtime' => $showtime, 'intr' => $intr, 'content_img1' => $content_img1, 'content_img2' => $content_img2, 'content_img3' => $content_img3, 'content_img4' => $content_img4, 'content' => $content, 'tags' => $tags, 'gtime' => date("Y-m-d H:i:s"), 'iskv' => $iskv, 'istop' => $istop, 'displayorder' => $displayorder, 'status' => $status);
if (!$id) {
$this->db->insert('news', $data);
$id = $this->db->insert_id();
} else {
dbupdate("news", $data, array('id' => $id));
}
if ($iskv) {
$upsql = "update " . dbtable("news") . " set iskv='0' where id!='" . $id . "'";
$this->db->query($upsql);
}
js_alert("保存成功", "top.location.href='?mod=news'");
}
function update()
{
// $res1=fetch_one_array("select * from ".dbtable("prize")." where prize_value='5' and tel!='' order by gtime desc limit 1");
// $now_date=time();
// $prize_date=strtotime($res1['gtime']);
// $sign1=false;
// if($now_date-$prize_date>86400*3)
// {
// $sign1=true;
// }
// $this_date=date("Y-m-d");
// $prizenum5=fetch_one_array("select count(*) as num from ".dbtable("prize")." where prize_value='4' and tel!='' and prize_date='$this_date'");
// $sign5=false;
// if($prizenum5['num']<=20)
// {
// $sign5=true;
// }
$list = fetch_array("select * from " . dbtable("prize") . " where status='0' and prize_no='SL201410000'");
foreach ($list as $row) {
$id = $row['id'];
$prize_no = prize_no("prize_no", "prize", "SL");
dbupdate("prize", array("prize_no" => $prize_no), "id ='" . $id . "'");
echo "ID：", $id, "中奖代码：", $prize_no, "<br>";
}
}
public function saveedit()
{
//保存产品
$id = getgpc("id");
if ($id) {
$res = fetch_one_array("select * from " . dbtable("faq") . " where id ='" . $id . "' ");
if (!$res) {
alert("错误，没有找到该数据", "");
}
}
$name = getgpc("name");
$tel = getgpc("tel");
$email = getgpc("email");
$question = getgpc("question");
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
$indata = array("name" => $name, "tel" => $tel, "email" => $email, "question" => $question, "reply_sign" => 1, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
$indata["gtime"] = date("Y-m-d H:i:s");
dbinsert("faq", $indata);
} else {
$indata["reply"] = getgpc("reply");
$indata["reply_sign"] = 2;
$indata["uptime"] = date("Y-m-d H:i:s");
dbupdate("faq", $indata, array('id' => $id));
}
js_alert("保存成功", "top.location.href='?mod=faq&act=index'");
}
public function save_employment_content()
{
//保存产品
$id = getgpc("id");
$pid = getgpc("pid");
if ($id) {
$res = fetch_one_array("select * from " . dbtable("employment_content") . " where id ='" . $id . "' ");
if (!$res) {
alert("错误，没有找到该数据", "");
}
}
$content = getgpc("content");
$istop = intval(getgpc("istop"));
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
$indata = array('pid' => $pid, "content" => $content, "istop" => $istop, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
//
$indata["gtime"] = date("Y-m-d H:i:s");
dbinsert("employment_content", $indata);
} else {
dbupdate("employment_content", $indata, array('id' => $id));
}
js_alert("保存成功", "top.location.href='?mod=employment&act=content&pid=" . $pid . "'");
}
public function saveedit()
{
//保存产品
$id = getgpc("id");
if ($id) {
$res = fetch_one_array("select * from " . dbtable("englandstyle") . " where id ='" . $id . "' ");
if (!$res) {
alert("错误，没有找到该数据", "");
}
}
$title = getgpc("title");
$showtime = getgpc("showtime");
$intr = getgpc("intr");
$content = getgpc("content");
$simgurl = getgpc("simgurl");
$imgurl = getgpc("imgurl");
$lovenum = getgpc("lovenum");
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
$indata = array("title" => $title, "showtime" => $showtime, "intr" => $intr, "content" => $content, "simgurl" => $simgurl, "imgurl" => $imgurl, "lovenum" => $lovenum, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
//
$indata["gtime"] = date("Y-m-d H:i:s");
dbinsert("englandstyle", $indata);
} else {
$indata["uptime"] = date("Y-m-d H:i:s");
dbupdate("englandstyle", $indata, array('id' => $id));
}
js_alert("保存成功", "top.location.href='?mod=englandstyle&act=index'");
}
public function savecompare()
{
//保存门店
$id = getgpc("id");
if ($id) {
$res = fetch_one_array("select * from " . dbtable("product_compare") . " where id ='" . $id . "' ");
if (!$res) {
alert("错误，没有找到该数据", "");
}
}
$title = getgpc("title");
$displayorder = intval(getgpc("displayorder"));
$status = intval(getgpc("status"));
$indata = array("title" => $title, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
dbinsert("product_compare", $indata);
} else {
dbupdate("product_compare", $indata, array('id' => $id));
}
alert("保存成功", "admin.php?mod=product&act=compareindex");
}
public function saveedit()
{
$id = intval(getgpc("id"));
$tid = intval(getgpc("tid"));
$title = getgpc("title");
$stitle = getgpc("stitle");
$imgurl = getgpc("imgurl");
$intr = getgpc("intr");
$type = getgpc("type");
$url = getgpc("url");
// if(!empty($url))
// {
// if(!strstr($url,"http://") and !strstr($url,"www") and !strstr($url,"index.php"))
// {
// $url="index.php".$url;
// }
// }
// if(!is_numeric(substr($url, -1)) and $tid=='1')
// {
// js_alert("请输入相对应产品的ID号");
// }
if (empty($imgurl) and $tid != '11' and $tid != 9) {
js_alert("上传相应的图片");
}
$con = getgpc("con");
$istop = getgpc("istop");
$displayorder = getgpc("displayorder");
$status = getgpc("status");
$indata = array('tid' => $tid, 'type' => $type, 'title' => $title, 'stitle' => $stitle, 'imgurl' => $imgurl, 'intr' => $intr, 'url' => $url, 'con' => $con, 'gtime' => date("Y-m-d H:i:s"), 'postip' => json_encode(convertip()), "istop" => $istop, "displayorder" => $displayorder, "status" => $status);
if (!$id) {
//更新
dbinsert("indexpush", $indata);
} else {
//dbupdate("indexpush",$indata,"id='".$id."'");
dbupdate("indexpush", $indata, array('id' => $id));
}
js_alert("保存成功", "top.location.href='?mod=indexpush&tid=" . $tid . "'");
}
