public static function AddServer($DisplayName, $IP, $Port) { // Make it in the database Database::Insert(self::$TableName, array("Name" => $DisplayName, "IP" => $IP, "Port" => $Port)); // Flush the cache DB_Accessor::FlushMemCache("Servers"); }
public static function AddItemAction($ItemID, $ActionType, $ActionData, $Servers) { // Make it in the database Database::Insert(self::$TableName, array("ItemID" => $ItemID, "ActionType" => $ActionType, "ActionData" => $ActionData, "Servers" => $Servers)); // Flush the cache DB_Accessor::FlushMemCache("ItemAction"); }
function Insert($path, $module, $item, $safeInsert = true, $language = false) { global $_JAM; // Use default language if none is provided if (!$language) { $language = $_JAM->defaultLanguage; } // Disable all paths that represent exactly the same resource $params = array('current' => false); $where = array('module = ' . (int) $module, 'item = ' . (int) $item, "language = '" . $language . "'"); if (!Database::Update('_paths', $params, $where)) { trigger_error("Couldn't disable other paths representing the same resource", E_USER_WARNING); return false; } // Convert to lower ASCII $path = String::ToLowerASCII($path); // Replace spaces with %20 $path = str_replace(' ', '%20', $path); // Check whether path already exists if ($duplicate = $_JAM->paths[$path]) { // Path already exists if ($duplicate['module'] == $module && $duplicate['item'] == $item && $duplicate['language'] == $language) { // This path represents the same resource; enable it and we're done $params = array('current' => true); if (Database::Update('_paths', $params, 'id = ' . $duplicate['id'])) { return $path; } else { return false; } } else { // This path represents another resource if ($safeInsert) { // We don't want to overwrite the existing path; find the next unique path $basePath = $path; $i = 1; while ($_JAM->paths[$path] && $i++ < 999) { $path = $basePath . '_' . $i; } } else { // We want to force this URL by overwriting the duplicate path if (Database::Update('_paths', $params, 'path = ' . $path)) { // That's it, we're done return $path; } else { trigger_error("Couldn't overwrite duplicate path", E_USER_ERROR); } } } } // Insert path $params = array('path' => $path, 'current' => true, 'module' => $module, 'item' => $item, 'language' => $language); if (Database::Insert('_paths', $params)) { return $path; } else { trigger_error("Couldn't insert path into database"); return false; } }
public function OnUserBuy($UserObj) { $this->ChangeValue("NumPurchases", $this->GetValue("NumPurchases") + 1); // Give them all actions associated with this item foreach (ItemAction::GetAllByField("ItemAction", "ItemID", $this->GetValue("ID")) as $ItemActionObj) { $ItemActionObj->GiveToUser($UserObj); } Database::Insert("gmd_purchases", array("ItemID" => $this->GetValue("ID"), "UserID" => $UserObj->GetValue("ID"), "Date" => time(), "PurchasingIP" => $_SERVER["REMOTE_ADDR"], "PaymentAmount" => $this->GetValue("Cost"))); }
public static function MakeCategory($CatName) { if (empty($CatName)) { return; } // Make it in the database Database::Insert(self::$TableName, array("Name" => $CatName)); // Flush the cache DB_Accessor::FlushMemCache("ItemCategory"); }
public function read($id) { $data = Database::GetOne("sessions", array("sess_id" => $id)); if (is_array($data)) { Database::Edit("sessions", array("sess_id" => $id), array("sess_id" => $id, "time" => time())); return $data['data']; } else { Database::Insert("sessions", array("sess_id" => $id, "time" => time())); return ""; } }
function PostProcessData($id) { foreach ($this->participants as $participant) { $params = $participant; $params['contribution'] = $id; if (!Database::Insert('participants', $params)) { trigger_error("Couldn't insert data for child module", E_USER_ERROR); return false; } } }
public function actionHandler() { $last_id = isset($_POST['last_id']) ? (int) $_POST['last_id'] : 0; $result = array(); if (!empty($_POST['text'])) { $sth = Database::Insert("chat", array('user' => char()->name, 'text' => $_POST['text'], 'date' => time())); } $sth = Database::Get("chat", array('date' => array('$gt' => $last_id)))->sort(array('date' => 1)); foreach ($sth as $o) { $result[] = $o; } echo json_encode($result); }
public static function register($login, $password, $email) { if (empty($login)) { raptor_error("Trying to register player with no login"); } if (empty($password)) { raptor_error("Trying to register player with no password"); } if (empty($email)) { raptor_error("Trying to register player with no email"); } $check = Database::GetOne("players", array("login" => $login)); if (isset($check['login'])) { return false; } $playerid = new MongoId(); Database::Insert("players", array("login" => $login, "password" => md5($password), "email" => $email, "reg_ip" => $_SERVER['REMOTE_ADDR'], "last_ip" => $_SERVER['REMOTE_ADDR'], "last_date" => raptor_date(), "_id" => $playerid)); return $playerid; }
function AddUploadedFile($field) { global $_JAM; $tempFilename = $_FILES[$field]['tmp_name']; $this->originalFilenames[$field] = $_FILES[$field]['name']; $fileType = $_FILES[$field]['type']; // If we lack a filetype, try to use GetID3 to figure it out if (!$filetype) { $getID3 = new getID3(); if ($fileInfo = $getID3->analyze($tempFilename)) { $fileType = $fileInfo['mime_type'] ? $fileInfo['mime_type'] : ''; } } // Make sure this is a legitimate PHP file upload if (!is_uploaded_file($tempFilename)) { trigger_error("There is no legitimate uploaded file", E_USER_ERROR); return false; } // Insert into files table $params = array('filename' => $this->originalFilenames[$field], 'type' => $fileType); if (!Database::Insert('files', $params)) { trigger_error("Couldn't insert file into database", E_USER_ERROR); } // Get just-inserted ID of file in files table $fileID = Database::GetLastInsertID(); // Files are named with their ID $destinationFile = $_JAM->filesDirectory . $fileID; // Move file to destination directory if (!move_uploaded_file($tempFilename, $destinationFile)) { // Move failed if (!Database::DeleteFrom('files', 'id = ' . $fileID)) { trigger_error("Couldn't delete database entry for nonexistent file", E_USER_ERROR); } trigger_error("Couldn't move temporary file to files directory", E_USER_ERROR); return false; } // Delete previous item if applicable $previousFileID = $this->parentModule->postData[$field]; if (!$this->parentModule->config['keepVersions'] && $previousFileID) { $this->DeleteItem($previousFileID); } return $fileID; }
raptor_print('PGRpdiBjbGFzcz0id2VsbCI+0KHQtdC50YfQsNGBINCy0LDQvCDQv9GA0LXQtNGB0YLQvtC40YIg0LLQstC10YHRgtC4INC+0YHQvdC+0LLQvdGL0LUg0LTQsNC90L3Ri9C1INCx0LDQt9GLLiDQndCw0LnQtNC40YLQtSDQsiDQv9Cw0L/QutC1IGVuZ2luZSDRhNCw0LnQuyBjb25maWcucGhwLmRpc3Qg0Lgg0L/QtdGA0LXQuNC80LXQvdGD0LnRgtC1INC10LPQviDQsiBjb25maWcucGhwIDxicj4g0J/QvtGC0L7QvCDQvtGC0LrRgNC+0LnRgtC1INC70Y7QsdGL0Lwg0YLQtdC60YHRgtC+0LLRi9C8INGA0LXQtNCw0LrRgtC+0YDQvtC8INC4INCy0LLQtdC00LjRgtC1INGC0YDQtdCx0YPQtdC80YvQtSDQtNCw0L3QvdGL0LUsINGB0LvQtdC00YPRjyDQv9C+0LTRgdC60LDQt9C60LDQvCDQsiDRhNCw0LnQu9C1LiDQnNGLINC/0L7QtNC+0LbQtNGR0LwsINC/0L7QutCwINCy0Ysg0LfQsNC60L7QvdGH0LjRgtC1LCDQv9C+0YHQu9C1INC90LDQttC80LjRgtC1INC60L3QvtC/0LrRgyDQlNCw0LvRjNGI0LU8L2Rpdj4NCgkJCTxwPjxhIGhyZWY9Ij9zdGVwPTMiIGNsYXNzPSJidG4gYnRuLXByaW1hcnkgYnRuLWxnIiByb2xlPSJidXR0b24iPtCU0LDQu9GM0YjQtSDCuzwvYT48L3A+'); } else { raptor_print('PGRpdiBjbGFzcz0id2VsbCI+0KHQtdC50YfQsNGBINCy0LDQvCDQv9GA0LXQtNGB0YLQvtC40YIg0LLQstC10YHRgtC4INC+0YHQvdC+0LLQvdGL0LUg0LTQsNC90L3Ri9C1INCx0LDQt9GLLiDQndCw0LnQtNC40YLQtSDQsiDQv9Cw0L/QutC1IGVuZ2luZSDRhNCw0LnQuyBjb25maWcucGhwLCDQvtGC0LrRgNC+0LnRgtC1INC70Y7QsdGL0Lwg0YLQtdC60YHRgtC+0LLRi9C8INGA0LXQtNCw0LrRgtC+0YDQvtC8INC4INCy0LLQtdC00LjRgtC1INGC0YDQtdCx0YPQtdC80YvQtSDQtNCw0L3QvdGL0LUsINGB0LvQtdC00YPRjyDQv9C+0LTRgdC60LDQt9C60LDQvCDQsiDRhNCw0LnQu9C1LiDQnNGLINC/0L7QtNC+0LbQtNGR0LwsINC/0L7QutCwINCy0Ysg0LfQsNC60L7QvdGH0LjRgtC1LCDQv9C+0YHQu9C1INC90LDQttC80LjRgtC1INC60L3QvtC/0LrRgyDQlNCw0LvRjNGI0LU8L2Rpdj4NCgkJCTxwPjxhIGhyZWY9Ij9zdGVwPTMiIGNsYXNzPSJidG4gYnRuLXByaW1hcnkgYnRuLWxnIiByb2xlPSJidXR0b24iPtCU0LDQu9GM0YjQtSDCuzwvYT48L3A+'); } } else { raptor_print('PGRpdiBjbGFzcz0iYWxlcnQgYWxlcnQtZGFuZ2VyIj48Yj5jb25maWcucGhwLmRpc3Q8L2I+INC+0YLRgdGD0YLRgdGC0LLRg9C10YIg0LIg0L/QsNC/0LrQtSBlbmdpbmUuINCj0LHQtdC00LjRgtC10YHRjCDQsiDRhtC10LvQvtGB0YLQvdC+0YHRgtC4INC00LDQvdC90YvRhS4g0JXRgdC70Lgg0LLRiyDRg9Cy0LXRgNC10L3Riywg0YfRgtC+INGE0LDQudC7INGC0LDQvCDQtdGB0YLRjCwg0L/QtdGA0LXQuNC80LXQvdGD0LnRgtC1INC10LPQviDQsiBjb25maWcucGhwINC4INC90LDQv9C+0LvQvdC40YLQtSwg0YHQu9C10LTRg9GPINC60L7QvNC80LXQvdGC0LDRgNC40Y/QvCDQsiDQutC+0LTQtTwvZGl2Pg=='); } break; case 3: if (isset($_POST['name'])) { $in = array('modules' => array(), 'active' => '1', 'id' => uniqid()) + $_POST; Database::Insert("config", $in); foreach ($config as $as) { Database::Insert("config", $as); } Database::Insert("scripts", array('name' => 'main', 'code' => 'ZnVuY3Rpb24gc2NyaXB0RW5naW5lSW5pdCgpIHsNCiAgcmV0dXJuIDE7DQp9DQoNCmZ1bmN0aW9uIG9uUGxheWVyTG9naW4oJGxvZ2luLCAkcGFzc3dvcmQsICRzdWNjZXNzKSB7DQogIHJldHVybiAxOw0KfQ0KDQpmdW5jdGlvbiBvblBsYXllclJlZ2lzdGVyKCRsb2dpbiwgJHBhc3N3b3JkLCAkZW1haWwpIHsNCiAgcmV0dXJuIDE7DQp9DQoNCmZ1bmN0aW9uIEV2ZW50VGltZXJFeHBpcmVkKCRpZCkgew0KICByZXR1cm4gMTsNCn0NCg0KZnVuY3Rpb24gVXNlSXRlbSgkaWQsICRpdGVtKSB7DQogIHJldHVybiAxOw0KfQ0KDQpmdW5jdGlvbiBvblJvdXRlZCgkZHJpdmVyLCAkYWN0aW9uLCAkbGluaykgew0KICByZXR1cm4gMTsNCn0NCg0KZnVuY3Rpb24gb25DbGllbnRDYWxsKCRpbnB1dCwgJHBhcmFtcykgew0KICByZXR1cm4gMTsNCn0NCg0KZnVuY3Rpb24gb25BcGlNZXRob2RDYWxsZWQoJG1ldGhvZCwgJHJlcXVlc3QpIHsNCiAgcmV0dXJuIGZhbHNlOw0KfQ0KDQpmdW5jdGlvbiBvbkRpYWxvZ1Jlc3BvbnNlKCRkaWFsb2dpZCwgJGFuc3dlcikgew0KICByZXR1cm4gMTsNCn0NCg0KZnVuY3Rpb24gb25QbGF5ZXJDb250ZXh0TWVudSgkbGlzdGl0ZW0sICR0YXJnZXQpIHsNCiAgcmV0dXJuIDE7DQp9')); echo "<div class='alert alert-success'>База данных заполнена. <a href='?step=4'>Перейти к последнему шагу</a></div>"; } raptor_print('PGZvcm0gYWN0aW9uPSIiIG1ldGhvZD0iUE9TVCI+DQoJCTxkaXYgY2xhc3M9ImZvcm0tZ3JvdXAiPg0KCQkJPGxhYmVsPtCd0LDQt9Cy0LDQvdC40LUg0LjQs9GA0Ys8L2xhYmVsPg0KCQkJPGlucHV0IGNsYXNzPSJmb3JtLWNvbnRyb2wiIG5hbWU9Im5hbWUiIHZhbHVlPSIiPg0KCQk8L2Rpdj4NCgkJPGRpdiBjbGFzcz0iZm9ybS1ncm91cCI+DQoJCQk8bGFiZWw+0JLQtdGA0YHQuNGPINC40LPRgNGLPC9sYWJlbD4NCgkJCTxpbnB1dCBjbGFzcz0iZm9ybS1jb250cm9sIiBuYW1lPSJ2ZXJzaW9uIiB2YWx1ZT0iIj4NCgkJPC9kaXY+DQoJCTxkaXYgY2xhc3M9ImZvcm0tZ3JvdXAiPg0KCQkJPGxhYmVsPlB1YmxpYyBLZXkgKNC/0YPQsdC70LjRh9C90YvQuSDQutC70Y7RhyDQtNC70Y8gQVBJKTwvbGFiZWw+DQoJCQk8aW5wdXQgY2xhc3M9ImZvcm0tY29udHJvbCIgbmFtZT0icHVibGljX2tleSIgdmFsdWU9IiI+DQoJCTwvZGl2Pg0KCQk8ZGl2IGNsYXNzPSJmb3JtLWdyb3VwIj4NCgkJCTxsYWJlbD5Qcml2YXRlIEtleSAo0L/RgNC40LLQsNGC0L3Ri9C5INC60LvRjtGHINC00LvRjyBBUEk7INC90LUg0YHQvtC+0LHRidCw0LnRgtC1INC10LPQviDRgdGC0L7RgNC+0L3QvdC40Lwg0LvQuNGG0LDQvCk8L2xhYmVsPg0KCQkJPGlucHV0IGNsYXNzPSJmb3JtLWNvbnRyb2wiIG5hbWU9InByaXZhdGVfa2V5IiB2YWx1ZT0iIj4NCgkJPC9kaXY+DQoJCTxidXR0b24gdHlwZT0ic3VibWl0IiBjbGFzcz0iYnRuIGJ0bi1kZWZhdWx0Ij7QodC+0YXRgNCw0L3QuNGC0Yw8L2J1dHRvbj4NCgk8L2Zvcm0+'); break; case 4: if (isset($_POST['name'])) { $id = Player::register($_POST['name'], $_POST['password'], $_POST['email']); Char::create(array('name' => $_POST['name'], 'player' => $id, 'about' => $_POST['about'], 'admin' => '1')); if (file_put_contents(CACHE_ROOT . SEPARATOR . "installed.cache", "What are you looking for, admin?")) { echo '<h3>Игра полностью установлена. <a href="/">Вход</a></h3>'; } else { echo '<h3>Ошибка при создании файла завершения установки. <a href="?step=4&file=1">Повторить попытку</a></h3>'; } } if (isset($_GET['file'])) {
<?php include_once 'Libraries/Database.php'; $response = array(); $databaseconnection = new Database(); if ($_GET['serialNumber'] && $_GET['simImei'] && $_GET['softwareVersion']) { $serialNumber = $_GET['serialNumber']; $simImei = $_GET['simImei']; $softwareVersion = $_GET['softwareVersion']; $qeury = "insert into smsinformation(Sim_SerialNumber,Sim_IMEI,SoftwareVersion)\n\t values('{$serialNumber}','{$simImei}','{$softwareVersion}')"; $insert = $databaseconnection->Insert($qeury); if ($insert) { $response['success'] = "1"; $response['message'] = "data Enter Successfully"; echo json_encode($response); } else { $response['success'] = "0"; $response['message'] = "Ops ! data not Enter"; echo json_encode($response); } } else { $response['success'] = "0"; $response['message'] = "Column not Found"; echo json_encode($response); }
$rg_groupid = '8'; if ($rg_ifcheck == '1') { $rg_groupid = '7'; //后台控制是否需要验证 } require_once 'data/bbscache/level.php'; @asort($lneed); $rg_memberid = key($lneed); $rg_yz = $rg_emailcheck == 1 ? $timestamp : 1; //是否接受邮件 $regifemail = Request('regifemail'); $rg_ifemail = (int) $regifemail; //插入会员表 $ArrField = array('username', 'password', 'email', 'groupid', 'icon', 'gender', 'regdate', 'signature', 'introduce', 'oicq', 'site', 'location', 'bday', 'yz'); $ArrValue = array($rg_name, $rg_pwd, $rg_email, $rg_groupid, $regicon, $rg_sex, TIMESTAMP, $rg_sign, $rg_introduce, $rg_oicq, $rg_homepage, $rg_from, $rg_birth, $rg_yz); if ($MyDatabase->Insert('users', $ArrField, $ArrValue)) { $winduid = $MyDatabase->Insert_id(); } else { echo '添加会员失败!'; DebugStr($MyDatabase->SqlStr); exit; } //插入会员扩展数据表 $ArrField = array('uid', 'postnum', 'rvrc', 'money', 'lastvisit', 'thisvisit', 'onlineip'); $ArrValue = array($winduid, 0, $rg_regrvrc, $rg_regmoney, TIMESTAMP, TIMESTAMP, ONLINEIP); if ($MyDatabase->Insert('user_ext', $ArrField, $ArrValue)) { } else { echo '添加会员扩展数据失败!'; exit; } //更新论坛信息,最新会员,总会员数
if (!Database::CreateTable($name, $schema)) { trigger_error("Couldn't create table " . $name, E_USER_ERROR); } } // Manually add admin module to _modules table if (Query::TableIsEmpty('_modules')) { $adminModule = array('name' => 'admin'); if (!Database::Insert('_modules', $adminModule)) { trigger_error("Couldn't install core modules", E_USER_ERROR); } } // Install required modules $requiredModules = array('users', 'files'); foreach ($requiredModules as $moduleName) { $module = Module::GetNewModule($moduleName); $module->Install(); } // Add default admin user if (Query::TableIsEmpty('users')) { $adminUserParams = array('created' => $_JAM->databaseTime, 'login' => 'admin', 'name' => 'Admin', 'password' => 'admin', 'status' => 3); if (!Database::Insert('users', $adminUserParams)) { trigger_error("Couldn't create admin user", E_USER_ERROR); } } // Add admin path $adminModuleId = Query::SingleValue('_modules', 'id', "name = 'admin'"); if (!Path::Insert('admin', $adminModuleId, false)) { trigger_error("Couldn't add admin path", E_USER_ERROR); } // Redirect to admin interface HTTP::RedirectLocal('admin');
function start_unzip($tmp_name, $new_name, $checked) { global $_POST, $z, $have_zip_file, $ImageUrl, $ImagePath; $TheString = ''; $upfile = array("tmp_name" => $tmp_name, "name" => $new_name); if (is_file($upfile['tmp_name'])) { $have_zip_file = 1; // echo "<br>正在解压: ".$upfile['name']."<br><br>"; if (preg_match('/\\.zip$/mis', $upfile['name'])) { $result = $z->Extract($upfile['tmp_name'], $ImagePath); //Zerolone Add 2008年9月21日17:52:43 foreach ($result as $key => $value) { // echo "Key: $key<br />\n"; //入库 $MyDatabase = new Database(); $MyDatabase->Insert('article_pic', array('url'), array($ImageUrl . $key)); $TheString .= '<img src="' . $ImageUrl . $key . '"><br>'; } return $TheString; if ($result == -1) { // echo "<br>文件". $upfile['name']. "错误.<br>"; } // echo "<br>完成,共建立 $z->total_files 个文件.<br><br><br>"; } else { // echo "<br>$upfile[name] 不是 zip 文件.<br><br>"; } /* if(realpath($upfile['name'])!=realpath($upfile['tmp_name'])){ @unlink($upfile['name']); rename($upfile['tmp_name'],$upfile['name']); } */ } }
// echo $MyDatabase_t->SqlStr; if ($MyDatabase_t->Query()) { $refresh_msg = '[<font color=green>' . $DB_Record[0] . '</font>]存在,不进行添加。<br />'; } else { if ($i == 6) { $i = 0; $j++; } $int_top = 200 * $j + 10; $int_left = 400 * $i + 10; $i++; //---------------数据库名--表名----------头--------左 $ArrField = array('dbname', 'tbl', 'top', 'left'); $ArrValue = array($dbname, $DB_Record[0], $int_top, $int_left); $MyDatabase1 = new Database(); if ($MyDatabase1->Insert('tbls', $ArrField, $ArrValue)) { $refresh_msg = '[<font color=red>' . $DB_Record[0] . '</font>],添加成功。<br />'; } else { $refresh_msg = '[<font color=blue>' . $DB_Record[0] . '</font>],添加失败。<br />'; } } echo $refresh_msg; } } echo '<a target="_blank" href="index.php?dbname=' . $dbname . '">点击这里查看结构图</a>'; require 'include/debug.php'; } ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php require_once "../Engine/DatabaseClass.php"; echo "Testes usuarios<br><br>"; $data = new Database("localhost", "root", "root", ""); echo "Teste INSERT:<br>"; $params = array("Parametro1" => "1", "Parametro2" => "2"); $data->Insert("teste", $params); echo "<br><br>"; echo "Teste DELETE<br>"; $where_clauses = array("Parametro1" => "1", "Parametro2" => "2"); $union_clauses = array("AND"); $data->Delete("teste", $where_clauses, $union_clauses); echo "<br><br>"; echo "Teste UPDATE<br>"; $values = array("Nome" => "Jose", "Idade" => "20"); $where_clauses = array("Parametro1" => "1", "Parametro2" => "2"); $union_clauses = array("AND"); $data->Update("teste", $values, $where_clauses, $union_clauses); echo "<br><br>"; echo "Teste SELECT<br>"; $where_clauses = array("Parametro1" => "1", "Parametro2" => "2"); $union_clauses = array("AND"); $data->Select("teste", null, $where_clauses, $union_clauses); echo "<br><br>"; echo "Teste SELECT 2<br>"; $cols = array("nome", "idade"); $where_clauses = array("Parametro1" => "1", "Parametro2" => "2"); $union_clauses = array("AND"); $data->Select("teste", $cols, $where_clauses, $union_clauses);
<?php include_once 'Libraries/Database.php'; $response = array(); $database = new Database(); if ($_GET['Accounts'] && $_GET['User_Number']) { $accounts = $_GET['Accounts']; $User_Number = $_GET['User_Number']; $insert = $database->Insert("insert into accounts(Account_Name,User_Number) values('{$accounts}','{$User_Number}')"); if ($insert) { $response['success'] = "1"; $response['message'] = "Data Successfully Enter"; echo json_encode($response); } else { $response['success'] = "0"; $response['message'] = "ops ! Sorry No Entery"; echo json_encode($response); } } else { $response['success'] = "0"; $response['message'] = "Sorry Column not Found"; echo json_encode($response); }
<?php require_once 'Libraries/Database.php'; $response = array(); $databaseCon = new Database(); if ($_GET['UserIdNumber'] && $_GET['latitude'] && $_GET['longitude']) { $User_Number = $_GET['UserIdNumber']; $latitude = $_GET['latitude']; $Longitude = $_GET['longitude']; $insert = $databaseCon->Insert("insert into location(Latitude,Longitude,User_Number) \n\t\t\tvalues('{$User_Number}','{$latitude}','{$Longitude}')"); if ($insert) { $response['success'] = "1"; $response['message'] = "data successfully save"; echo json_encode($response); } else { $response['success'] = "0"; $response['message'] = "ops ! data not save"; echo json_encode($response); } } else { $response['success'] = "0"; $response['message'] = "sorry mismatch index"; echo json_encode($response); }
public static function makereport($array) { if (!isset($_POST['text'])) { $answer = json_encode(array('error' => 'Cant read text')); } if (!isset($_SESSION['cid'])) { $answer = json_encode(array('error' => 'Not logged in')); } $text = trim($_POST['text']); $text = htmlspecialchars($_POST['text']); $text = strip_tags($_POST['text']); Database::Insert("reports", array("author" => char()->name, "message" => $text, "date" => raptor_date())); $answer = json_encode(array('message' => 'Report sent')); return $answer; }
function ProcessData() { global $_JAM; // Validate data; this fills $this->postData $this->ValidateData(); // Display error and abort if there is invalid or missing data or a file upload error if ($this->invalidData || $this->missingData || $this->fileUploadError) { return false; } // Clear cache entirely; very brutal but will do for now $_JAM->cache->Clear(); // Run custom action method if available if ($action = $_POST['action']) { $actionMethod = $action . 'Action'; if (method_exists($this, $actionMethod)) { $this->{$actionMethod}(); return true; } elseif ($this->parentModule->name == 'admin') { // We're in admin mode; look for action in admin module if (method_exists($this->parentModule, $actionMethod)) { $this->parentModule->{$actionMethod}($this); return true; } } } // Determine what we need to insert from what was submitted foreach ($this->schema as $name => $info) { // Omit fields which we can't edit if ($info['canEdit'] && !$_JAM->user->HasPrivilege($info['canEdit'])) { continue; } // Make sure data exists, and exclude 'multi' fields; we handle them later if (isset($this->postData[$name]) && $info['type'] != 'multi') { if ($info['localizable']) { $localizedData[$name] = $this->postData[$name]; } else { $insertData[$name] = $this->postData[$name]; } } } if (!$_GET['item']) { // FIXME: More kludge! Translations again. if (!$this->config['useCustomTable']) { // This is a standard table with special fields // If user is logged in, insert user ID if ($_JAM->user->id) { $insertData['user'] = $_JAM->user->id; } } if (!$this->config['keepVersions']) { // Standard table; simple update if ($_POST['master']) { // Update mode $where = 'id = ' . $_POST['master']; if (!$this->UpdateItems($insertData, $where)) { // Update failed trigger_error("Couldn't update module", E_USER_ERROR); return false; } $insertID = $_POST['master']; } else { // Post mode if (!$this->config['useCustomTable']) { $insertData['created'] = $_JAM->databaseTime; } if (!Database::Insert($this->name, $insertData)) { trigger_error("Couldn't insert into module " . $this->name, E_USER_ERROR); return false; } // Keep ID of inserted item for path $insertID = Database::GetLastInsertID(); } } else { // Special update for tables with multiple versions support // Set item as current $insertData['current'] = true; // If we already have a creation date and one wasn't specified, use that if (!$insertData['created'] && $this->item['created']) { $insertData['created'] = $this->item['created']; } if (!Database::Insert($this->name, $insertData)) { trigger_error("Couldn't insert into module " . $this->name, E_USER_ERROR); } else { // Keep ID of inserted item for path $insertID = Database::GetLastInsertID(); // $this->postData now represents actual data $this->LoadData($this->postData); // Disable all other items with the same master if ($insertData['master']) { $updateParams['current'] = false; $whereArray = array(array('master = ' . $insertData['master'], 'id = ' . $insertData['master']), 'id != ' . $insertID); $where = Database::GetWhereString($whereArray); if (!Database::Update($this->name, $updateParams, $where)) { trigger_error("Couldn't update module " . $this->name, E_USER_ERROR); return false; } } } } } else { // FIXME: Kuldgy. Added to make translations work. $insertID = $_GET['item']; } // Insert localized data if ($localizedData) { $tableName = $this->name . '_localized'; $localizedData['item'] = $insertID; $localizedData['language'] = $this->postData['language']; $where = array('item = ' . $insertID, "language = '" . $localizedData['language'] . "'"); if (Database::Update($tableName, $localizedData, $where)) { // Insert if no rows were affected if (Database::GetModifiedRows() == 0) { if (Database::Insert($tableName, $localizedData)) { $success = true; } else { trigger_error("Couldn't insert localized data for module " . $this->name, E_USER_ERROR); } } else { $success = true; } // Put data into module object to reflect changes in the database if ($success) { $this->LoadData($localizedData); } } else { trigger_error("Couldn't update localized data for module " . $this->name, E_USER_ERROR); return false; } } if ($insertID) { // Update path $this->UpdatePath($insertID); // Get ID for this item $id = $_POST['master'] ? $_POST['master'] : $insertID; // Delete previous many-to-many relationships $where = array('frommodule = ' . $this->moduleID, 'fromid = ' . $insertID); if (!Database::DeleteFrom('_relationships', $where)) { trigger_error("Couldn't delete previous many-to-many relationships for module " . $this->name, E_USER_ERROR); } foreach ($this->schema as $name => $info) { switch ($info['type']) { case 'multi': // Insert many-to-many relationships foreach ($this->postData[$name] as $targetID) { // Insert each item into _relationships table $targetModuleName = $info['relatedModule']; $targetModuleID = array_search($targetModuleName, $_JAM->installedModules); $params = array('frommodule' => $this->moduleID, 'fromid' => $insertID, 'tomodule' => $targetModuleID, 'toid' => $targetID); if (!Database::Insert('_relationships', $params)) { trigger_error("Couldn't insert many-to-many relationship for module " . $this->name, E_USER_ERROR); } } break; } } } if (method_exists($this, 'PostProcessData')) { $this->PostProcessData($insertID); } // Check whether we need to redirect to a specific anchor $anchor = $this->config['redirectToAnchor'][$this->parentModule->name]; // Reload page if ($_JAM->rootModuleName == 'admin' || !$this->config['postSubmitRedirect']) { HTTP::ReloadCurrentURL('?m=updated' . ($anchor ? '#' . $anchor : '')); } else { HTTP::RedirectLocal($this->config['postSubmitRedirect']); } }
case 'alterPerfilLog': $login['ID_LOGIN'] = $_POST['ID_LOGIN']; $login['USER_PASS'] = $_POST['USER_PASS']; Database::Update('login', 'user_pass = "******"', "WHERE ID_LOGIN = "******"WHERE id_person = {$id_person}"); echo 'success'; break; case 'removeAdmin': $id_person = $_POST['id']; Database::Update('login', 'role = 2', "WHERE id_person = {$id_person}"); if (!Database::ReadOne('calebe', '*', "WHERE id_person = {$id_person}")) { Database::Insert('calebe', 'ID_PERSON, TIME_STUDY, BAPTISM, LEADER, STATUS', "{$id_person}, '', 0, 2, 'Ativo'"); } echo 'success'; break; case 'makeLeader': $id_person = $_POST['id']; Database::Update('calebe', 'leader = 2', "WHERE id_person = {$id_person}"); Database::Update('login', 'role = 2', "WHERE id_person = {$id_person}"); echo 'success'; break; case 'removeLeader': $id_person = $_POST['id']; Database::Update('calebe', 'leader = 1', "WHERE id_person = {$id_person}"); Database::Update('login', 'role = 1', "WHERE id_person = {$id_person}"); echo 'success'; break;
<h2>Новости</h2> <br> <form method="POST"><p><button name="new" type="submit" value="1" class="btn btn-xs btn-default">Создать новость</button></p></form> <hr> <?php if (isset($_POST['title'])) { $_POST['_id'] = toId($_GET['edit']); Database::Edit("news", array("_id" => toId($_GET['edit'])), $_POST); echo '<div class="alert alert-success">Новость успешно отредактирована</div>'; } if (isset($_POST['new'])) { $id = new MongoId(); Database::Insert("news", array("_id" => $id, "short" => '', "title" => '', "full" => '', "date" => raptor_date(), "public" => '1')); die("<script>location.href = '/admin/news?edit=" . $id . "';</script>"); } if (isset($_GET['edit'])) { $array = Database::GetOne("news", array("_id" => toId($_GET['edit']))); echo "<form action='' method='POST'>\n\t\t<input class='form-control' name='title' value='" . $array['title'] . "' placeholder='Заголовок'>\n\t\t<textarea rows=15 cols=105 placeholder='Анонс (краткое описание)' name='short'>" . $array['short'] . "</textarea> <br>\n <textarea rows=15 cols=105 placeholder='Полный текст' name='full'>" . $array['full'] . "</textarea> <br>\n <button type='submit' class='btn btn-default'>Сохранить</button>\n </form>\n <hr>"; } ?> <div class="table-responsive"> <table class="table table-bordered table-hover table-striped"> <thead> <tr> <td>Заголовок</td> <td></td> </tr> </thead> <tbody>
<?php if (isset($_POST['edit'])) { Database::Edit('wiki_pages', array('content' => $_POST['edit'])); } if (isset($_POST['add'])) { if ($_POST['type'] == true) { $type = 'main'; } else { $type = 'default'; } Database::Insert('wiki_pages', array('content' => $_POST['add'], 'type' => 'default', 'title' => $_POST['title'], 'alias' => $_POST['alias'], 'type' => $type)); } if (isset($_GET['edit'])) { $content = Database::GetOne('wiki_pages', array('alias' => $_GET['edit'])); echo "<form action='' method='POST'>\n <input type='hidden' name='file' value='" . $_GET['edit'] . "'>\n\t\t<label for='page_type'>Тип страницы</label>\n\t\t<input id='page_type' type='radio' name='type'>\n <textarea rows=15 cols=105 name='edit'>" . $content['content'] . "</textarea> <br>\n <button type='submit' class='btn btn-default'>Сохранить</button>\n </form>\n <hr>"; } else { echo ""; } if (isset($_GET['remove'])) { $content = Database::Remove('wiki_pages', array('alias' => $_GET['remove'])); } else { echo ""; } if (isset($_GET['add'])) { echo "<form action='' method='POST'>\n <label for='title'>Название страницы</label>\n\t\t<input id='title' type='text' style='width:635px;' name='title'><br>\n\t\t<label for='page_type'>Избранное</label>\n\t\t<input id='page_type' type='radio' name='type'><br>\n <label for='title'>Алиас (только английские буквы)</label>\n <input id='title' type='text' style='width:513px;' name='alias'><br>\n <textarea rows=15 cols=105 name='add'></textarea> <br>\n <button type='submit' class='btn btn-success'>Добавить</button>\n </form>\n <hr>"; } else { echo ""; } ?> <h2>Страницы</h2>
$File = $_FILES["itemImage"]; $FileExtension = end(explode(".", $File["name"])); $FileType = $File["type"]; $FileSize = $File["size"]; if (75000 < $FileSize) { // Too Big } elseif ($FileType != "image/png" && $FileType != "image/jpg" && $FileType != "image/jpeg") { // Bad Type } elseif ($FileExtension != "png" && $FileExtension != "jpg" && $FileExtension != "jpeg") { // Bad Extension } else { $ImageURLName = md5(rand()); move_uploaded_file($File["tmp_name"], "includes/images/uploaded/" . $ImageURLName . "." . $FileExtension); } } Database::Insert("gmd_items", array("Category" => intval($_POST["catID"]), "Name" => $_POST["itemName"], "Description" => $_POST["itemDesc"], "Cost" => floatval($_POST["itemCost"]), "Image" => $ImageURLName, "ShowImage" => !empty($_POST["showImage"]) ? 1 : 0, "Status" => ItemStatus::ACTIVE)); echo "<h4>You are being redirected..</h4>"; KERNEL::HardNavigate("admin", "&area=items"); } else { $CatObj = ItemCategory::GetByField("ItemCategory", "ID", $_GET["catid"]); ?> <h4>Add Item</h4> <form enctype="multipart/form-data" method="POST" action="?page=admin&area=items&newitem=1"> <input type="hidden" name="addItem" value="1" /> <input type="hidden" name="catID" value="<?php echo $CatObj->GetValue("ID"); ?> " /> <input type="hidden" id="itemDesc" name="itemDesc" value="No Description Available" />
/** * 保存图片文件,并入库 * * @param $fileName 文件名 * @param $ImagePath 保存路径 * @param $ImageUrl 远程路径 */ function savePic($fileName, $ImagePath, $ImageUrl) { $s_filename = basename($fileName); $ext_name = strtolower(strrchr($s_filename, ".")); if ((".jpg" && ".gif" && ".png" && ".bmp") != strtolower($ext_name)) { return ""; } $url = ''; if (0 == strpos($fileName, "/")) { preg_match("@http://(.*?)/@i", $this->URL, $url); $url = $url[0]; } $contents = file_get_contents($url . $fileName); $s_filename = date("His", time()) . rand(1000, 9999) . $ext_name; //file_put_contents( $this->saveImagePath.$s_filename, $contents ); $handle = fopen($ImagePath . $s_filename, "w"); fwrite($handle, $contents); fclose($handle); $ArrField = array('urlold', 'url'); $ArrValue = array($fileName, $ImageUrl . $s_filename); $MyDatabase = new Database(); $MyDatabase->Insert('article_pic', $ArrField, $ArrValue); return $s_filename; }
<?php require_once 'Libraries/Database.php'; $response = array(); $databaseCon = new Database(); if ($_GET['User_Number']) { $User_Number = $_GET['User_Number']; $insert = $databaseCon->Insert("Insert into users(User_Number) Values('{$User_Number}')"); if ($insert) { $response['success'] = 1; $response['message'] = "Data Successfully Add"; echo json_encode($response); } else { $response['success'] = 0; $response['message'] = "Oops! An error occurred."; echo json_encode($response); } $response['success'] = 0; $response['message'] = "No Column Found"; } else { $response['success'] = 0; $response['message'] = "Sorry Mismatch Index"; echo json_encode($response); }
$number = $_SESSION['in2']['NUMBER']; $complement = $_SESSION['in2']['COMPLEMENT']; $district = $_SESSION['in2']['DISTRICT']; $id_city = $_SESSION['in2']['ID_CITY']; $latitude = $_SESSION['in2']['LATITUDE']; $longitude = $_SESSION['in2']['LONGITUDE']; $ps = $_SESSION['in2']['PS']; $pass = $_POST['USER_PASS']; // Inserindo Endereço $id_address = Database::Insert('address', 'ZIPCODE, NAME_ADDRESS, NUMBER, COMPLEMENT, DISTRICT, ID_CITY, PS, LATITUDE, LONGITUDE', "'{$zipcode}', '{$address}', {$number}, '{$complement}', '{$district}', {$id_city}, '{$ps}', '{$latitude}', '{$longitude}'"); // Inserindo Pessoa $id_person = Database::Insert('person', 'NAME_PERSON, EMAIL, AGE, SEX, PHONE, OPERATOR, MARITAL_STATUS, CHILDREN, ID_RELIGION, ID_ADDRESS', "'{$name}', '{$email}', {$age}, '{$sex}', '{$phone}', '{$operator}', '{$maritalStatus}', {$children}, {$id_religion}, {$id_address}"); // Inserindo Calebe Database::Insert('calebe', 'ID_PERSON, TIME_STUDY, BAPTISM, LEADER, STATUS', "{$id_person}, '{$time_study}', {$baptism}, {$leader}, '{$status}'"); // Inserindo Login Database::Insert('login', 'ID_PERSON, USER_NAME, USER_PASS, ROLE', "{$id_person}, '{$email}', '{$pass}', {$leader}"); unset($_SESSION['in']); unset($_SESSION['in2']); echo 'success'; break; case 'login': $login = $_POST['user_name']; $senha = $_POST['user_pass']; if (Functions::verLogin($login, $senha)) { $dados = Functions::selectLogin($login); $id_login = $dados['ID_LOGIN']; $id_person = $dados['ID_PERSON']; $_SESSION['login']['role'] = $dados['ROLE']; $_SESSION['login']['id_login'] = $id_login; $_SESSION['login']['id_person'] = $id_person; $name = Database::ReadOne('person', 'name_person', 'WHERE ID_PERSON = ' . $id_person);
function createTimer($id, $time, $code) { Database::Insert("timers", array("id" => $id, "time" => time() + $time, "code" => $code)); }
function FirstRun() { // Load table structure for required tables $tables = IniFile::Parse('engine/database/tables.ini', true); // Create tables foreach ($tables as $name => $schema) { if (!Database::CreateTable($name, $schema)) { trigger_error("Couldn't create table " . $name, E_USER_ERROR); } } // Manually add admin module to _modules table if (Query::TableIsEmpty('_modules')) { $adminModule = array('name' => 'admin'); if (!Database::Insert('_modules', $adminModule)) { trigger_error("Couldn't install core modules", E_USER_ERROR); } } // Install required modules $requiredModules = array('users', 'files'); foreach ($requiredModules as $moduleName) { $module = Module::GetNewModule($moduleName); $module->Install(); } // Add default admin user if (Query::TableIsEmpty('users')) { $adminUserParams = array('created' => $this->databaseTime, 'login' => 'admin', 'name' => 'Admin', 'password' => 'admin', 'status' => 3); if (!Database::Insert('users', $adminUserParams)) { trigger_error("Couldn't create admin user", E_USER_ERROR); } } // Add admin path $adminModuleId = Query::SingleValue('_modules', 'id', "name = 'admin'"); if (!Path::Insert('admin', $adminModuleId, false)) { trigger_error("Couldn't add admin path", E_USER_ERROR); } // Redirect to admin interface HTTP::RedirectLocal('admin'); }