public function userSettingSubmit() { if (!isset($_SESSION['userId'])) { $this->error(C('LOGIN_FIRST')); } $this->assign('APPLICATION_NAME', C('APPLICATION_NAME')); $this->assign('USER_ID', $_SESSION['userId']); $this->assign('USER_LEVEL', $_SESSION['userLevel']); $this->assign('CURRENT_MENU', 'USER'); $data['userId'] = $_GET['userid']; $exUserPassword = $_POST['exUserPassword']; $data['userMail'] = $_POST['userMail']; $user = M('user'); $tempUser = $user->where('userid=' . $_GET['userid'])->limit(1)->select(); if ($_POST['newUserPassword'] != null) { //输入了密码,需要修改密码 if (strcmp($tempUser[0]['userpassword'], $exUserPassword) == 0) { //密码相同,可以修改 $data['userPassword'] = $_POST['newUserPassword']; } else { $this->error('输入的旧密码不正确'); return; } } else { $this->error('输入有误!'); } $result = $user->save($data); if ($result !== false) { doLog($_SESSION['userId'], 28, 'Edit_User_Setting_Submit'); $this->success(C('EDIT_SUCCESS')); } else { $this->error(C('EDIT_FAIL')); } // $this->show(); }
public function logout() { doLog(0, 10, 'Logout_account_:_' . $_SESSION['userAccount']); session('userAccount', null); session('userId', null); $this->success('退出成功', 'login'); }
function mensaje($datos) { $link = Conexion::singleton(); /* $usuario="eureka"; $clave="eureka"; $db_host="localhost"; $bd_nombre="eureka"; $port = 5432; $link = new PDO('pgsql: host='.$db_host.'; dbname='.$bd_nombre.'; port='.$port, $usuario, $clave); //var_dump($link); */ $firstname = $datos['contacto']['nombre']; $surname = $datos['contacto']['apellido']; $tlf = $datos['contacto']['tlf']; $emailaddress = $datos['contacto']['correo']; $mensaje = $datos['contacto']['mensaje']; $query = "INSERT INTO mensajes(nombre, apellido, telefono, correo, mensaje) VALUES('" . $firstname . "', '" . $surname . "', '" . $tlf . "', '" . $emailaddress . "', '" . $mensaje . "')"; $result = $link->prepare($query); $result = $result->execute(); if (!$result) { $errormessage = $link->errorInfo(); echo json_encode(['code' => 0, 'mensaje' => 'Hubo un error procesando tu mensaje, por favor intentalo de nuevo.']); return "Error with query: " . $errormessage; } /* @mail("*****@*****.**", "Mensaje de: ".$firstname." ".$surname, "Datos de contacto: ".$tlf."<br><br>".$mensaje, "From: ". $emailaddress . "\r\n" . "Content-Type: text/html; charset=utf-8"/*, "*****@*****.**");*/ // Guardar en archivo.txt doLog("Datos de la persona: " . $firstname . " " . $surname . " Teléfono: " . $tlf . " Correo: " . $emailaddress . " Mensaje: " . $mensaje . "", "logs/mensajes.txt"); // Guardar en archivo CSV doLog("" . $firstname . ";" . $surname . ";" . $tlf . ";" . $emailaddress . ";" . $mensaje . "", "logs/mensajes.csv"); echo json_encode(["code" => 1, "mensaje" => "Listo, tu mensaje ya fue recibido, te contactaremos."]); //return "Listo, tu mensaje ya fue recibido, te contactaremos."; }
function parseRequest() { global $_SITE_CONFIG; $request = $_GET ? $_GET : $_POST; $module = $request['module']; $method = $request['method']; $log = $request; $log['paramsArray'] = $this->myAddslashes(unserialize($request['params'])); doLog($log, empty($_POST) ? '$_GET: ' : '$_POST: '); $errCode = 0; $errMessage = ''; if ($_SITE_CONFIG['site_close']) { $errCode = 2; $errMessage = 'Site Closed'; } elseif (!$_SITE_CONFIG['my_status']) { $errCode = 2; $errMessage = 'Manyou Service Disabled'; } elseif (!$_SITE_CONFIG['site_key']) { $errCode = 11; $errMessage = 'Client SiteKey NOT Exists'; } elseif (!$_SITE_CONFIG['my_site_key']) { $errCode = 12; $errMessage = 'My SiteKey NOT Exists'; } elseif (empty($module) || empty($method)) { $errCode = '3'; $errMessage = 'Invalid Method: ' . $moudle . '.' . $method; } if (get_magic_quotes_gpc()) { $request['params'] = sstripslashes($request['params']); } $mySign = $module . '|' . $method . '|' . $request['params'] . '|' . $_SITE_CONFIG['my_site_key']; $mySign = md5($mySign); if ($mySign != $request['sign']) { $errCode = '10'; $errMessage = 'Error Sign'; } if ($errCode) { return new APIErrorResponse($errCode, $errMessage); } $params = unserialize($request['params']); $params = $this->myAddslashes($params); if ($module == 'Batch' && $method == 'run') { $response = array(); foreach ($params as $param) { $response[] = $this->callback($param['module'], $param['method'], $param['params']); } return new APIResponse($response, 'Batch'); } return $this->callback($module, $method, $params); }
public function allSignUp() { if (!isset($_SESSION['userId'])) { $this->error(C('LOGIN_FIRST')); } doLog($_SESSION['userId'], 33, 'View_allBranchApperance'); $this->assign('APPLICATION_NAME', C('APPLICATION_NAME')); $this->assign('USER_ID', $_SESSION['userId']); $this->assign('CURRENT_MENU', 'SIGNUP'); $signUp = M('signup'); try { if (isset($_GET['delete'])) { // 传入删除参数 $signUp->where('signupid=' . $_GET['delete'])->delete(); } if (isset($_GET['deleteMulti'])) { // 传入删除多项的参数 $multi = explode(',', $_GET['deleteMulti']); for ($index = 1; $index < count($multi); $index++) { // 从第二个开始删除,第一个的产生是由于U方法生成参数的时候无法不输入一个参数 if ($multi[$index] != null) { $signUp->where('signupid=' . $multi[$index])->delete(); } } } } catch (Exception $e) { // 删除错误 $this->error(C('DELETE_FAIL') . $e->__toString()); return; } // 查询当前所有的工作状态并且分页 $count = $signUp->count(); $page = new \Think\Page($count, C('PAGE_COUNT'), 'p1'); $page->setP('p1'); $orderby['signupid'] = 'desc'; $list = $signUp->order($orderby)->limit($page->firstRow . ',' . $page->listRows)->select(); // dump($list); // return; $this->assign('list', $list); // 赋值数据集 $this->assign('page', $page->show()); // 赋值分页输出 $this->display(); }
function publishTemplatizedAction($uId, $appId, $titleTemplate, $titleData, $bodyTemplate, $bodyData, $bodyGeneral = '', $image1 = '', $image1Link = '', $image2 = '', $image2Link = '', $image3 = '', $image3Link = '', $image4 = '', $image4Link = '', $targetIds = '', $privacy = '', $hashTemplate = '', $hashData = '', $specialAppid = 0) { global $_SITE_CONFIG; $db_prefix = getDbPrefix(); $site_userapp_url = SITE_URL . '/apps/myop/userapp.php'; $site_cp_url = SITE_URL . '/apps/myop/cp.php'; if (strpos($titleTemplate, MYOP_URL) === false) { $titleTemplate = str_replace('userapp.php', $site_userapp_url, $titleTemplate); $titleTemplate = str_replace('cp.php', $site_cp_url, $titleTemplate); } foreach ($titleData as $k => $v) { if (strpos($titleTemplate, MYOP_URL) === false) { $v = str_replace('userapp.php', $site_userapp_url, $v); $v = str_replace('cp.php', $site_cp_url, $v); } $titleTemplate = str_replace('{' . $k . '}', $v, $titleTemplate); } if (strpos($bodyTemplate, MYOP_URL) === false) { $bodyTemplate = str_replace('userapp.php', $site_userapp_url, $bodyTemplate); $bodyTemplate = str_replace('cp.php', $site_cp_url, $bodyTemplate); } foreach ($bodyData as $k => $v) { if (strpos($bodyTemplate, MYOP_URL) === false) { $v = str_replace('userapp.php', $site_userapp_url, $v); $v = str_replace('cp.php', $site_cp_url, $v); } $bodyTemplate = str_replace('{' . $k . '}', $v, $bodyTemplate); } $titleTemplate = str_replace('{actor}', '', $titleTemplate); $bodyTemplate = str_replace('{actor}', '<a href="' . U('home/Space/index', array('uid' => $uId)) . '">' . getUserName($uId) . '</a>', $bodyTemplate); $content = array('title' => stripslashes($titleTemplate), 'content' => stripslashes($bodyTemplate), 'image1' => $image1, 'image1Link' => $image1Link, 'image2' => $image2, 'image2Link' => $image2Link, 'image3' => $image3, 'image3Link' => $image3Link, 'image4' => $image4, 'image4Link' => $image4Link); doLog($content, 'ContetArray'); $content = serialize($content); $ctime = time(); $sql = "INSERT INTO {$db_prefix}feed (`uid`,`data`,`type`,`ctime`) VALUES \r\n\t\t\t\t\t ({$_SITE_CONFIG['uid']}, '{$content}', 'myop_feed','{$ctime}')"; $result = doQuery($sql); return new APIResponse($result); }
public function logTest() { doLog(1, 2, '中文测试'); }
$response->records = $count; $i = 0; while ($row = pg_fetch_assoc($result)) { //doLog(print_r($row,true)); $vip = $row[$hfield_guests . '_vip'] === 'f' ? 0 : 1; $response->d[$i] = array("id" => $row[$hfield_guests . '_id'], "group" => $row[$hfield_groups . '_name'], "seat" => $row[$hfield_seatings . '_id'], "title" => $row[$hfield_titles . '_name'], "VIP" => $vip, "lastname" => $row[$hfield_guests . '_lastname'], "firstname" => $row[$hfield_guests . '_firstname'], "display" => $row[$hfield_guests . '_display'], "gender" => $row[$hfield_genders . '_name'], "age" => $row[$hfield_ages . '_name'], "meal" => $row[$hfield_meals . '_name'], "request" => $row[$hfield_requests . '_name'], "RSVP" => $row[$hfield_rsvps . '_name']); //doLog("data:".join($row,",")); $i++; } $response->status = 0; $response->responseText = "Successful."; } else { $response->status = 1; $response->responseText = "Cannot execute query: {$query}, Error" . pg_last_error($connection); } } else { $response->status = 1; $response->responseText = "Cannot execute query: {$query}, Error" . pg_last_error($connection); } } doLog("Preparing the reponse"); if ($custom_status !== 200) { header("Content-type: application/json;charset=utf-8"); header('X-Error-Message: ' . $custom_error, true, $custom_status); die; } else { header("Content-type: application/json;charset=utf-8"); header("HTTP/1.0 200 OK"); //doLog(json_encode($response)); echo json_encode($response); }
public function editUserSubmit() { if (!isset($_SESSION['userId'])) { $this->error(C('LOGIN_FIRST')); } $this->assign('APPLICATION_NAME', C('APPLICATION_NAME')); $this->assign('USER_ID', $_SESSION['userId']); $this->assign('USER_LEVEL', $_SESSION['userLevel']); $this->assign('CURRENT_MENU', 'SYSTEMSETTING'); $user = M('user'); $data['userId'] = $_GET['userid']; $data['userNickname'] = $_POST['usernickname']; $data['userPassword'] = $_POST['userpassword']; $data['userAddress'] = $_POST['useraddress']; $data['userTelnumber'] = $_POST['usertelnumber']; $data['userDescription'] = $_POST['userdescription']; $data['userAcademy'] = $_POST['useracademy']; $data['userMail'] = $_POST['usermail']; $data['userAcademy'] = $_POST['useracademy']; $data['userBranch'] = $_POST['userbranch']; // dump($data); // return; $result = $user->save($data); if ($result !== false) { // echo U('WorkTendency/allPage'); doLog($_SESSION['userId'], 26, 'Edit_User_Submit_id_:_' . $_GET['userid']); echo ' <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <h1 style="line-height:400px;text-align:center">成功,1秒后自动关闭</h1> <script language="javascript"> function closeWindow(){ window.opener=null; window.open("","_self") window.close(); } setTimeout("closeWindow()",1000); </script>'; // $this->success ( C ( 'EDIT_SUCCESS' ), '/WorkTendency/allPage' ); } else { $this->error(C('EDIT_FAIL')); } }
printf("# EDIT %s <fail> <%s> (%d): <%s> (<%s>)\n", $typeMap[$pages[$pageId]['bad']], $query['title'], $pageId, $data2['error']['info'], $data2['error']['code']); $log .= sprintf("# EDIT (Fehlgeschlagen [%s]) %s [{{fullurl:%s|curid=%d&oldid=%d}} %s]\n", htmlentities($data2['error']['info'], ENT_QUOTES, 'UTF-8'), $typeMap[$pages[$pageId]['bad']], $query['title'], $pageId, $query['lastrevid'], $query['title']); unset($stockIds[$pageId]); } else { fail('Edit fehlgeschlagen', $result); } } else { printf("# EDIT %s <%s> <%s> (%d) (old %d) (new %d) Sleeping ", $typeMap[$pages[$pageId]['bad']], $data2['edit']['result'], $data2['edit']['title'], $data2['edit']['pageid'], $data2['edit']['oldrevid'], $data2['edit']['newrevid']); // var_dump($data2); // var_dump($pages[$pageId]); $log .= sprintf("# EDIT (%s) %s [{{fullurl:%s|curid=%d&diff=%d&oldid=%d}} %s] by [[{{subst:FULLPAGENAME:User:%s}}|]]\n", $data2['edit']['result'], $typeMap[$pages[$pageId]['bad']], $data2['edit']['title'], $pageId, $data2['edit']['newrevid'], $data2['edit']['oldrevid'], $data2['edit']['title'], $pages[$pageId]['rev_user_text'], $pages[$pageId]['rev_user_text']); for ($i = 19; $i > 0; --$i) { print $i . ' '; usleep(900000); } print "0\n"; } } } while (false); } if ($stockIds) { mysql_query(' DELETE FROM `u_revolus`.`bestandscheck` WHERE `page_id` IN (' . implode(', ', $stockIds) . ') ', $link) or fail(mysql_error()); } doLog(); curl_close($curl); mysql_close($link);
if ($start < 0) { $start = 0; } $query = "select * from " . DB_SCHEMA . ".{$table} where deleted = 0 order by {$sidx} {$sord} LIMIT {$limit} OFFSET {$start}"; doLog($query); $result = pg_query($connection, $query) or die("Cannot execute query: {$query}\n"); $response->page = $page; $response->total = $total_pages; $response->records = $count; $i = 0; while ($row = pg_fetch_assoc($result)) { $response->d[$i] = array("id" => $row[$hfield . '_id'], "name" => $row[$hfield . '_name'], "note" => $row[$hfield . '_note']); doLog("id=>" . $row[$hfield . '_id'] . " name=>" . $row[$hfield . '_name'] . " note=>" . $row[$hfield . '_note']); $i++; } $response->status = 0; $response->responseText = "Successful."; } else { $response->status = 1; $response->responseText = "Cannot execute query: {$query}"; } } } else { $response->page = 1; $response->total = 1; $response->records = 0; } doLog("Preparing the reponse"); header("Content-type: application/json;charset=utf-8"); doLog(json_encode($response)); echo json_encode($response);
public function editBranchApperanceSubmit() { if (!isset($_SESSION['userId'])) { $this->error(C('LOGIN_FIRST')); } $this->assign('APPLICATION_NAME', C('APPLICATION_NAME')); $this->assign('USER_ID', $_SESSION['userId']); $this->assign('USER_LEVEL', $_SESSION['userLevel']); $this->assign('CURRENT_MENU', 'BRANCHAPPERANCE'); $branchapperance = M('branchapperance'); $data['branchApperanceId'] = $_GET['branchapperanceid']; $data['branchApperanceTitle'] = $_POST['branchapperanceTitle']; $data['branchApperanceReleaseId'] = $_POST['branchapperancereleaseid']; $data['branchApperanceAcademy'] = $_POST['branchapperanceacademy']; $data['branchApperanceBranch'] = $_POST['branchapperancebranch']; // dump ( $_POST ['branchapperancebranch']); // return; // $workTendency-> where('worktendencyid=' . $_GET['worktendencyid'])->setField('worktendencytitle',$_POST['workTendencyTitle']); // $workTendency-> where('worktendencyid=' . $_GET['worktendencyid'])->setField('worktendencyreleaseid',$_POST['workTendencyReleaseId']); // $workTendency-> where('worktendencyid=' . $_GET['worktendencyid'])->setField('worktendencyreleasedate',date ( 'Y-m-d H:i:s', time () )); // 创建内容的html文件 $myFilePath = C('APPLICATION_CONTENTHTML_PATH') . '/' . time() . rand() . '.html'; $myFile = fopen($myFilePath, "w") or die("Unable to open file!"); fwrite($myFile, $_POST['editor']); fclose($myFile); $data['branchApperanceContentURL'] = $myFilePath; // $workTendency-> where('workTendencyId=' . $_GET['worktendencyid'])->setField('worktendencycontenturl',$myFilePath); $result = $branchapperance->save($data); doLog($_SESSION['userId'], 36, 'Edit_BranchApperance_submit_Id_:_' . $_GET['branchapperanceid']); if ($result !== false) { // echo U('WorkTendency/allPage'); echo ' <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <h1 style="line-height:400px;text-align:center">成功,1秒后自动关闭</h1> <script language="javascript"> function closeWindow(){ window.opener=null; window.open("","_self") window.close(); } setTimeout("closeWindow()",1000); </script>'; // $this->success ( C ( 'EDIT_SUCCESS' ), '/WorkTendency/allPage' ); } else { $this->error(C('EDIT_FAIL')); } }
mkdir(LOG); } $file = LOG . '/report.log'; // Write the contents back to the file //echo "do loging to $file"; file_put_contents($file, "{$log}\n", FILE_APPEND | LOCK_EX); } $l = $_POST['l']; // get the requested page $e = $_POST['e']; // get the requested page $v = $_POST['v']; // get the requested page doLog("Parameters received : \n" . "\te = " . $e . "\n" . "\tv = " . $v . "\n" . "\tl = " . $l . "\n" . "\tHost = " . DB_HOST . "\n" . "\tPort = " . DB_PORT . "\n" . "\tDBName = " . DB_NAME . "\n" . "\tUser = "******"\n" . "\tPwd = " . DB_PASSWORD); // connect to pgsql $connection = pg_Connect(DSN) or die("Could not connect to server\n"); pg_query($connection, "set names 'utf8'"); $query = "select t.title_name, g.guest_firstname, g.guest_lastname, g.guest_display, s.seating_id, cast(substr(s.seating_id,5) as integer)\nfrom " . DB_SCHEMA . ".seatings s, " . DB_SCHEMA . ".guests g, " . DB_SCHEMA . ".titles t\nwhere s.guest_id = g.guest_id\nand g.title_id = t.title_id\nand s.event_id = " . $e . "\nand s.layout_id = (select layout_id from " . DB_SCHEMA . ".layouts where layout_name='" . $l . "' and venue_id=" . $v . ") order by 6 asc"; doLog($query); $result = pg_query($connection, $query); if ($result) { while ($row = pg_fetch_array($result)) { $response[] = $row; } header("Content-type: application/json;charset=utf-8"); doLog(json_encode($response)); echo json_encode($response); } else { doLog("Failed to execute the query : " . pg_last_error($connection)); die("Cannot execute query: {$query}\n"); }
public function editDownloadSubmit() { if (!isset($_SESSION['userId'])) { $this->error(C('LOGIN_FIRST')); } $this->assign('APPLICATION_NAME', C('APPLICATION_NAME')); $this->assign('USER_ID', $_SESSION['userId']); $this->assign('USER_LEVEL', $_SESSION['userLevel']); $this->assign('CURRENT_MENU', 'WORKTENDENCY'); $download = M('download'); $data['downloadId'] = $_GET['downloadid']; $data['downloadTitle'] = $_POST['downloadTitle']; // dump($data); // return; // 文件上传 $upload = new \Think\Upload(); // 实例化上传类 $upload->maxSize = 3145728; // 设置附件上传大小 $upload->exts = array('jpg', 'gif', 'png', 'jpeg', 'doc', 'docx', 'apk', 'xls', 'ppt', 'pptx', 'rar', 'zip', 'pdf'); // 设置附件上传类型 $upload->rootPath = C('APPLICATION_DOWNLOAD_PATH'); // 设置附件上传根目录 // $upload->savePath = 'Download'; // 设置附件上传(子)目录 // 上传文件 $info = $upload->upload(); doLog($_SESSION['userId'], 8, 'edit_Download_Submit_Id_:_' . $_GET['downloadid']); if (!$info) { // 上传错误提示错误信息 echo ' <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <h1 style="line-height:400px;text-align:center">上传错误:' . $upload->getError() . ',1秒后自动关闭</h1> <script language="javascript"> function closeWindow(){ window.opener=null; window.open("","_self") window.close(); } setTimeout("closeWindow()",1000); </script>'; return; } else { // 上传成功 获取上传文件信息 foreach ($info as $file) { // echo $file['savepath'].$file['savename'].'<br />'; // echo $file['name']; $data['fileName'] = $file['name']; $data['downloadURL'] = $file['savename']; } } // $workTendency-> where('workTendencyId=' . $_GET['worktendencyid'])->setField('worktendencycontenturl',$myFilePath); $result = $download->save($data); if ($result !== false) { // echo U('WorkTendency/allPage'); echo ' <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <h1 style="line-height:400px;text-align:center">成功,1秒后自动关闭</h1> <script language="javascript"> function closeWindow(){ window.opener=null; window.open("","_self") window.close(); } setTimeout("closeWindow()",1000); </script>'; // $this->success ( C ( 'EDIT_SUCCESS' ), '/WorkTendency/allPage' ); } else { $this->error(C('EDIT_FAIL')); } }
$response["Mesaj"] = "Giriş Yapılmadı"; echoRespnse(200, $response); return; } $SoruID = $app->request->post("SoruID"); $ResimNo = $app->request->post("ResimNo"); doLog($ResimNo); $Oy = false; if ($ResimNo == 0) { $Oy = false; } else { if ($ResimNo == 1) { $Oy = true; } } doLog($Oy); if (isset($SoruID) && isset($UyeID) && isset($ResimNo)) { if ($db->OyladiMi($UyeID, $SoruID) == false) { if ($db->Oyla($UyeID, $SoruID, $Oy) == false) { $response["Sonuc"] = false; $response["Mesaj"] = "Oy Eklenemedi"; } else { $response["Sonuc"] = true; $response["Mesaj"] = "Oy Eklendi"; } } else { if ($db->OyGuncelle($UyeID, $SoruID, $Oy) == false) { $response["Sonuc"] = false; $response["Mesaj"] = "Oy Güncellenemedi"; } else { $response["Sonuc"] = true;
} else { $json_array['success'] = false; $json_array['message'][] = "Please specify API endpoint"; } } else { if ($api_user == "guest") { checkIfCookieExists($json_array, true); $json_array['success'] = false; $json_array['message'][] = "Reset API key"; } else { $json_array['success'] = false; $json_array['message'][] = "Supplied API key has been disabled"; } } } else { $json_array['success'] = false; $json_array['message'][] = "API Key not found"; } mysqli_close($GLOBALS['conn']); $GLOBALS['conn'] = null; } else { $json_array['success'] = false; $json_array['message'][] = "API Key was provided in the incorrect format"; } } } else { $json_array['success'] = false; $json_array['message'][] = "No API key supplied"; } doLog($json_array); print json_encode($json_array);
<?php include "../database/database.php"; $deviceId = $_GET["deviceId"]; $module = $_GET["module"]; $os_version = $_GET["os_version"]; $mail = $_GET["mail"]; $build_desc = $_GET["build_desc"]; $action = $_GET["action"]; $result = doLog($deviceId, $module, $os_version, $mail, $build_desc, $action); echo $result; function doLog($d, $m, $o, $mail, $b, $action) { $nid = generateId("root_tools_log", "id"); date_default_timezone_set("Asia/Hong_Kong"); $sql = "insert into root_tools_log values ('" . $nid . "', '" . $d . "', '" . $m . "', '" . $o . "', '" . $mail . "', '" . $b . "', '" . $action . "', '" . date("Y-m-d h:i a") . "')"; $db = openConnection(); $str = query($db, $sql); closeConnection($db); $str = "{\"result\":\"" . $str . "\"}"; return $str; }
$res_event = ""; $res_width = 0; $res_height = 0; $i = 0; while ($row = pg_fetch_array($result)) { $res_id = $row[0]; $res_venue_id = $row[2]; $res_event_id = $row[3]; $res_layout = $row[4]; $res_venue = $row[5]; $res_event = $row[6] === null ? "NA" : $row[6]; $res_width = $row[7]; $res_height = $row[8]; $i++; } doLog("Layout is {$res_id}"); if ($res_id != "") { $pagecontents = str_replace("<!--phpcode-->", ' <script>$( document ).ready(function() { svgEditor.addExtension("server_ems_dbopen", function (){ var curConfig = { initFill: { //\'FFFFFF\', color: svgEditor.curConfig[\'initFill\'].color, //1 opacity: svgEditor.curConfig[\'initFill\'].opacity },
<?php include "../database/database.php"; $deviceId = $_GET["deviceId"]; $module = $_GET["module"]; $os_version = $_GET["os_version"]; $mail = $_GET["mail"]; $build_desc = $_GET["build_desc"]; $comment = $_GET["comment"]; $app_version = $_GET["app_version"]; if (empty($deviceId) || empty($comment)) { echo "{\"result\":\"0\"}"; return; } if (empty($app_version) || $app_version == null) { $app_version = "low"; } $result = doLog($deviceId, $module, $os_version, $mail, $build_desc, $comment, $app_version); echo $result; function doLog($d, $m, $o, $mail, $b, $comment, $app) { $nid = generateId("root_tools_feedback", "id"); date_default_timezone_set("Asia/Hong_Kong"); $sql = "insert into root_tools_feedback(id,deviceId,module,os_version,mail,build_desc,comment,comment_time,app_version) values ('" . $nid . "', '" . $d . "', '" . $m . "', '" . $o . "', '" . $mail . "', '" . $b . "', '" . $comment . "', '" . date("Y-m-d h:i a") . "', '{$app}')"; $db = openConnection(); $str = query($db, $sql); closeConnection($db); $str = "{\"result\":\"" . $str . "\"}"; return $str; }
if ($auth->auth['uname'] == 'admin') { $query = sprintf("UPDATE meanings\n\t\t\tSET subject_id = %s,\n\t\t\t\tmorphologic_id = %s,\n\t\t\t\t%s\n\t\t\t\thidden = %s\n\t\t\tWHERE\n\t\t\t\tid = %d", $new_id, $morphologic_sql, $distinction_sql, myaddslashes($new_hidden), myaddslashes(uservar('mid'))); } else { $query = sprintf("UPDATE meanings\n\t\t\tSET subject_id = %s\n\t\t\t\tmorphologic_id = %s\n\t\t\tWHERE\n\t\t\t\tid = %d", $new_id, $morphologic_sql, myaddslashes(uservar('mid'))); } $db->query($query); $query = sprintf("SELECT subject FROM subjects WHERE id = %d", $new_id); $db->query($query); $db->next_record(); $new_subject = $db->f('subject'); doLog(getSynsetString(uservar('mid'), 3), uservar('mid'), CHANGE_SUBJECT, uservar('oldsubject') . "->" . $new_subject); $query = sprintf("SELECT morphologic FROM morphologics WHERE id = %d", $morphologic_sql); $db->query($query); $db->next_record(); $new_morphologic = $db->f('morphologic'); doLog(getSynsetString(uservar('mid'), 3), uservar('mid'), CHANGE_SUBJECT, uservar('oldmorphologic') . "->" . $new_morphologic); $changed = 1; } $query = sprintf("SELECT id, subject_id, morphologic_id, distinction, hidden\n\tFROM meanings\n\tWHERE id = %d", myaddslashes(uservar('mid'))); $db->query($query); if ($db->nf() == 0) { print "ID not found"; return; } $db->next_record(); $subject_id = $db->f('subject_id'); $morphologic_id = $db->f('morphologic_id'); $title = sprintf(T_("Details for synset '%s'"), getSynsetString(uservar('mid'), 3)); function popdownlist() { global $db, $subject_id;
if ($found && $val == 'delete') { $id = intval($matches[1]); array_push($del_list, $id); } } if (sizeof($del_list) >= sizeof(getSynset(uservar('meaning_id')))) { print T_("You cannot remove all synonyms of a synset. Use the checkbox to delete the synset instead."); page_close(); return; } foreach ($del_list as $id) { # delete from synset $query = sprintf("SELECT word FROM words WHERE id = %d", $id); $db->query($query); $db->next_record(); doLog(unescape($db->f('word')), uservar('meaning_id'), REMOVE_SYNONYM); $query = sprintf("DELETE FROM word_meanings\n\t\tWHERE\n\t\t\tword_id = %d AND\n\t\t\tmeaning_id = %d", $id, uservar('meaning_id')); $db->query($query); } if (uservar('do_remove') == 1) { $title = T_("Synset removed"); include "include/top.php"; ?> <p><?php print sprintf(T_("The synset <span class='inp'>%s</span> has been deleted."), join(', ', getSynset(uservar('meaning_id')))); ?> </p> <p><a href="./"><?php print T_("Return to homepage"); ?>
// Take off the 3 turns for attacking $player->take_turns(3); $player->update(); // fire shots if (DEBUG) { print "Pre Shots<br>"; } portFires($fleet, $port, $players); fleetFires($fleet, $port, $players, $weapons); //get results in a way we want them $results = processResults($players, $port, $fleet, $weapons); //post on alliances MB or send to player portDowngrade($results, $port); sendReport($results, $port); //log player doLog($results); //insert into combat logs $finalResults = $results[0] . '<br /><img src="images/portAttack.jpg" width="480px" height="330px" alt="Port Attack" title="Port Attack"><br />' . $results[1]; $db->query('INSERT INTO combat_logs VALUES("",' . SmrSession::$game_id . ',"PORT",' . $player->sector_id . ',' . time() . ',' . SmrSession::$old_account_id . ',' . $player->alliance_id . ',0,0,"' . mysql_real_escape_string(gzcompress($finalResults)) . '", "FALSE")'); if (DEBUG) { print "Pre Forward/Display<br>"; } $container = array(); $container["url"] = "skeleton.php"; $container["body"] = "port_attack_new.php"; $container["results"] = $results; if ($players[$player->account_id][KILLER]) { $container['override_death'] = TRUE; } $container["continue"] = checkContinue($players, $port); forward($container);
$new_hidden = 0; } else { $new_hidden = 1; } $query = ""; if ($auth->auth['uname'] == 'admin') { $query = sprintf("UPDATE meanings\n\t\t\tSET subject_id = %s,\n\t\t\t\t%s\n\t\t\t\thidden = %s\n\t\t\tWHERE\n\t\t\t\tid = %d", $new_id, $distinction_sql, myaddslashes($new_hidden), myaddslashes(uservar('mid'))); } else { $query = sprintf("UPDATE meanings\n\t\t\tSET subject_id = %s\n\t\t\tWHERE\n\t\t\t\tid = %d", $new_id, myaddslashes(uservar('mid'))); } $db->query($query); $query = sprintf("SELECT subject FROM subjects WHERE id = %d", $new_id); $db->query($query); $db->next_record(); $new_subject = $db->f('subject'); doLog(getSynsetString(uservar('mid'), 3), uservar('mid'), CHANGE_SUBJECT, uservar('oldsubject') . "->" . $new_subject); $changed = 1; } $query = sprintf("SELECT id, subject_id, distinction, hidden\n\tFROM meanings\n\tWHERE id = %d", myaddslashes(uservar('mid'))); $db->query($query); if ($db->nf() == 0) { print "ID not found"; return; } $db->next_record(); $subject_id = $db->f('subject_id'); $title = sprintf(_("Details for synset '%s'"), getSynsetString(uservar('mid'), 3)); function popdownlist() { global $db, $subject_id; $query = "SELECT id, subject FROM subjects ORDER By subject";
function setNewAntonym($thisWMID, $newWMID) { global $db; $this_id = myaddslashes($thisWMID); $new_antonym_id = myaddslashes($newWMID); $query = sprintf("SELECT id FROM antonyms\n\t\tWHERE word_meaning_id1 = %d OR word_meaning_id2 = %d", $this_id, $this_id); #print $query."<p>"; $db->query($query); if ($db->nf() == 0) { $next_id = $db->nextid("antonyms"); # The INSERT statement can lead to an duplicate key error if the new antonym # is already connected to a different word as its antonym, so check before: $query = sprintf("SELECT * FROM antonyms WHERE word_meaning_id1 = %d OR word_meaning_id2 = %d", myaddslashes($newWMID), myaddslashes($newWMID)); $db->query($query); if ($db->nf() > 0) { print T_("Error: the antonym you selected is already connected to a different word."); exit; } $query = sprintf("INSERT INTO antonyms (id, word_meaning_id1, word_meaning_id2)\n\t\t\tVALUES (%d, %d, %d)", $next_id, myaddslashes($newWMID), myaddslashes($thisWMID)); #print $query; $db->query($query); // Logging: // FIXME: should be moved before the INSERT query is executed, but the // INSERT can lead to an error and we don't want to log the action in that case: list($word1, $mid) = getAntonymWord($this_id, $db); list($word2, $mid) = getAntonymWord($newWMID, $db); doLog(join(', ', getSynset($this_id, 3)), $mid, ADD_ANTONYM, $word1 . "<->" . $word2); } else { if ($db->nf() == 1) { // Logging: list($word1, $mid) = getAntonymWord($this_id, $db); list($word2, $mid) = getAntonymWord($newWMID, $db); doLog(join(', ', getSynset($this_id, 3)), $mid, CHANGE_ANTONYM, $word1 . "<->" . $word2); # one of the next two UPDATE statements will succeed: $query = sprintf("UPDATE antonyms\n\t\t\tSET word_meaning_id2 = %d\n\t\t\tWHERE word_meaning_id1 = %d", $newWMID, $this_id); #print $query."<p>"; $db->query($query); $query = sprintf("UPDATE antonyms\n\t\t\tSET word_meaning_id1 = %d\n\t\t\tWHERE word_meaning_id2 = %d", $newWMID, $this_id); #print $query."<p>"; $db->query($query); } else { print "Internal error: more than one match for {$query}"; return; } } }
<?php include_once 'db_connect.php'; include_once 'functions.php'; sec_session_start(); ?> <?php if (login_check($mysqli) == true) { if (CheckArma3isrunning() == false) { echo "Der Server ist schon Offline! Du wirst wieder zum Interface weitergeleitet"; ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/Webinterface_arma.php"> <?php } else { execInBackground("C:\\Bats\\StopArma3.bat"); echo "Server wird gestoppt, du wirst wieder zum Interface weitergeleitet"; doLog("Hat den Server Gestoppt"); ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/Webinterface_arma.php"> <?php } } else { echo 'You are not authorized to access this page, please login.'; ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/index.php"> <?php } ?>
return false; } } else { return false; } } return true; } else { return false; } } $backup = db_backup(); if ($jobs['backup'][0] == 7) { $jobs['backup'][1] = $plus_week; } else { if ($jobs['backup'][0] == 30) { $jobs['backup'][1] = $plus_month; } else { $jobs['backup'][1] = $midnight_today; } } $message = $backup === true ? 'successful' : 'failed'; doLog("Database update " . $message . " - triggered by visitor " . $displayIp); } if ($update == 1) { $new_jobs = serialize($jobs); yasDB_update("UPDATE `settings` SET `jobs` = '{$new_jobs}' WHERE `id` = 1"); include $setting['sitepath'] . "/includes/settings_function.inc.php"; createConfigFile(); } $_SESSION['runjobs'] = 'no-go';
<?php include_once 'db_connect.php'; include_once 'functions.php'; sec_session_start(); ?> <?php if (login_check($mysqli) == true) { if (CheckArma3isrunning() == true) { echo "Der Server ist noch Online stoppe erst den Server bevor du ihn Updatest"; ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/Webinterface_arma.php"> <?php } else { execInBackground("C:\\Bats\\UpdateArma3.bat"); echo "Der Server wird geupdatet, bitte warte 2-3Minuten"; doLog("Hat den Server Geupdatet"); ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/Webinterface_arma.php"> <?php } } else { echo 'You are not authorized to access this page, please login.'; ?> <meta http-equiv="refresh" content="3; URL=http://127.0.0.1/index.php"> <?php }