Runs a INSERT query
| static public insert ( string $table, mixed $input, boolean $ignore = false ) : mixed | ||
| $table | string | The table name |
| $input | mixed | Either a key/value array or a valid MySQL insert string |
| $ignore | boolean | Set this to true to ignore duplicates |
| return | mixed | The last inserted id if everything went fine or an error response. |
public function create($values)
{
$values['parent'] = (int) $values['parent'];
$position = (int) db::select('max(position)')->from(':table:')->where('parent = %i', $values['parent'])->fetchSingle();
$values['position'] = $position + 1;
db::insert(':table:', $values)->execute();
return array('id' => db::getInsertId(), 'title' => $values['title'], 'parent_id' => $values['parent'], 'position' => $values['position']);
}
public function _savePhotos($values)
{
db::addSubst('photos', 'site_photos');
$pos = db::select('MAX(position) as max')->from(':photos:')->fetch('max');
$pos = (int) $pos['max'] + 1;
$values['position'] = $pos;
return db::insert(':photos:', $values)->execute(db::IDENTIFIER);
}
private static function set_cache($id, $video_data)
{
$success = db::insert('video_cache', array('id' => $id, 'video_data' => json_encode($video_data)));
if ($success['status'] === 'error') {
return false;
}
return true;
}
public function insertar_usuario($nombre, $email, $clave)
{
$array = array();
$array['campos'] = array(":id", ":nombre", ":email", ":clave");
$array['valores'] = array(":id" => null, ":nombre" => $nombre, ":email" => $email, ":clave" => md5($clave));
parent::__construct($this->db, $this->tabla);
if (parent::comprobacion_datos("email", $email)) {
parent::insert($array);
} else {
echo "Esos datos ya existen";
}
}
public function insertar_ingrediente($nombre, $comentario)
{
$array = array();
$array['campos'] = array(":id", ":nombre", ":comentario");
$array['valores'] = array(":id" => null, ":nombre" => $nombre, ":comentario" => $comentario);
parent::__construct($this->db, $this->tabla);
if (parent::comprobacion_datos("nombre", $nombre)) {
echo "inserta datos";
parent::insert($array);
} else {
echo "Esos datos ya existen";
}
}
function upload()
{
$dir = FILES_ROOT . 'all/';
if (!empty($_FILES['file']['name'])) {
$file_name = urldecode($_GET['file_name']);
$file_type = files::info($_FILES['file']['name'], 'type');
$file_size = files::info($_FILES['file']['tmp_name'], 'size');
db::table('files');
db::insert('', 'NOW()', $file_name, $file_type, $file_size);
$file_id = mysql_insert_id();
$file = $dir . $file_id . '.' . $file_type;
copy($_FILES['file']['tmp_name'], $file);
$file_icon = files::getFileIco($file_type);
buffer::set('<p class="load"><img src="/i/fileicons/' . $file_icon . '.png" width="18" height="18" alt="" /> <a href="/download/files/download/?file=' . $file_id . '">' . $file_name . '</a> <span>(' . $file_type . ', ' . round($file_size / 1000) . ' Кб)</span></p>');
}
}
function testando()
{
//senão o insere
$db = new db();
$db->clear();
$db->setTabela('test');
$dataValue = array('nome' => 'a');
try {
if ($db->insert($dataValue)) {
echo 'inserido';
} else {
echo $db->getError();
}
} catch (error_db $e) {
throw new Exception($e, 1);
}
}
public function write($id, $data)
{
$data = array('session_id' => $id, 'last_activity' => time(), 'data' => base64_encode($data));
if ($this->session_id === NULL) {
// Insert a new session
$query = db::insert($this->table, $data)->execute($this->db);
} elseif ($id === $this->session_id) {
// Do not update the session_id
unset($data['session_id']);
// Update the existing session
$query = db::update($this->table)->set($data)->where('session_id', '=', $id)->execute($this->db);
} else {
// Update the session and id
$query = db::update($this->table)->set($data)->where('session_id', '=', $this->session_id)->execute($this->db);
// Set the new session id
$this->session_id = $id;
}
return (bool) $query->count();
}
public function upload()
{
$database = new db();
$database->db;
$login = $_COOKIE['login'];
$uploadfile = 'upload/' . $login . "/" . self::translitIt(basename($_FILES['userfile']['name']));
if (!file_exists($uploadfile)) {
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) {
$query = $database->select('id', 'user', "WHERE login='******'");
$record = mysql_fetch_assoc($query);
$user_id = $record['id'];
$hashForShare = self::RandomString();
$database->insert('files', "(NULL, {$user_id}, '{$uploadfile}', '{$hashForShare}')");
header("Location: /files");
} else {
echo "Download error!\n";
}
} else {
header("Location: /files");
}
}
/**
* Write session data
*
* @param string $id
* @param array $data
* @return boolean
*/
public function write($id, $data)
{
// we only count for presentational content types
if (object_content_types::exists_static(['where' => ['no_virtual_controller_code' => application::get('flag.global.__content_type'), 'no_content_type_presentation' => 1]])) {
$inc = 1;
} else {
$inc = 0;
}
$save = ['sm_session_id' => $id, 'sm_session_expires' => format::now('timestamp', ['add_seconds' => session::$default_options['gc_maxlifetime']]), 'sm_session_last_requested' => format::now('timestamp'), 'sm_session_pages_count,=,~~' => 'sm_session_pages_count + ' . $inc, 'sm_session_user_ip' => $_SESSION['numbers']['ip']['ip'], 'sm_session_user_id' => $_SESSION['numbers']['entity']['em_entity_id'] ?? 0, 'sm_session_data' => $data];
$db = new db($this->model_seessions->db_link);
// we update first
$result = $db->update($this->model_seessions->name, $save, 'sm_session_id');
if ($result['affected_rows'] == 0) {
$save['sm_session_started'] = format::now('timestamp');
$save['sm_session_pages_count'] = $inc;
unset($save['sm_session_pages_count,=,~~']);
// we insert
$result = $db->insert($this->model_seessions->name, [$save]);
}
return $result['affected_rows'] ? true : false;
}
public function _save($values)
{
$values['slug'] = String::webalize($values['title']);
if (isset($values['link'])) {
if ($values['link'] > 0) {
$link = array();
$slug = $values['slug'];
if ($values['category'] > 0) {
$cat_model = new Admin_CategoriesModel();
$cat = $cat_model->getById((int) $values['category']);
$slug = $cat->slug . '/' . $slug;
}
$link['title'] = $values['title'];
$link['url'] = $slug;
$link['parent'] = 0;
$link['level'] = 1;
$link['menu_id'] = (int) $values['link'];
$link_model = new Admin_MenuItemsModel();
$link_model->create($link);
//refresh table alias
$this->__after_startup();
}
unset($values['link']);
}
$values['content_type'] = 'page';
if (!isset($values['publish_time'])) {
$values['publish_time'] = time();
}
$values['publish_time'] = db::datetime($values['publish_time']);
if (isset($values['homepage'])) {
if ($values['homepage'] == 1) {
$update = array('homepage' => 0);
db::update(':table:', $update)->execute();
}
}
db::insert(':table:', $values)->execute();
return db::getInsertId();
}
function dump()
{
$tables = implode(', ', self::$tables);
$conf = implode(', ', self::$conf);
db::table('admin_log_trash');
db::order('log_id', 'DESC');
db::limit(31, 100);
$res = db::select('log_id');
if (db::rows() > 0) {
while ($row = mysql_fetch_assoc($res)) {
self::delete($row['log_id']);
}
}
if (self::$files) {
$log_tmpl = 1;
} else {
$log_tmpl = 0;
}
db::table('admin_log_trash');
db::insert('', 'NOW()', '', $tables, $conf, '', $log_tmpl, ADMIN_USER_ID);
$log_id = mysql_insert_id();
dump::tables(self::$tables);
dump::backup(SYS_ROOT . 'var/trash/' . $log_id . '_base.zip');
if (self::$conf) {
foreach (self::$conf as $v) {
zipfile::add(SYS_ROOT . 'conf/web/' . $v . '.ini');
}
zipfile::create(SYS_ROOT . 'var/trash/' . $log_id . '_conf.zip');
}
if (self::$files) {
foreach (self::$files as $v) {
zipfile::add($v);
}
zipfile::create(SYS_ROOT . 'var/trash/' . $log_id . '_files.zip');
}
}
$user_params = array(":email" => $return_params[":email"], ":name" => $name, ":usergroup" => $usergroup);
if ($user_result = \db::query($user_SQL, array(":email" => $return_params[":email"]))) {
$user_result = $user_result[0];
if (\context::get("profile") && \context::get("profile") === \user::me()) {
$user_SQL = "UPDATE `{PREFIX}user` SET name = :name WHERE email = :email";
\db::query($user_SQL, $user_params);
} elseif ($user_result["name"] != $name || $user_result["usergroup"] != $usergroup) {
$user_SQL = "UPDATE `{PREFIX}user` SET name = :name, usergroup = :usergroup WHERE email = :email";
\db::query($user_SQL, $user_params);
}
} else {
if (\context::get("profile") && \context::get("profile") === \user::me() && !is_numeric($user_params[":usergroup"])) {
$user_params[":usergroup"] = 0;
}
$user_SQL = "INSERT INTO `{PREFIX}user` (`email`, `name`, `usergroup`) VALUES (:email, :name, :usergroup)";
\db::insert($user_SQL, $user_params);
}
}
if ($saved) {
$url = \bootstrap::get("url");
echo <<<HTML
<h1 class="client-form-success text-success">Saved successfully!</h1>
<script>
\tsetTimeout(function() {
\t\twindow.location.href = "admin/{$url}";
\t}, 1000);
</script>
HTML;
}
}
if (!$saved) {
require_once "libs/fc_sessoes.php";
require_once "libs/form2.class";
require_once "libs/funcoes.php";
require_once "libs/class_dbgrid.php";
require_once "libs/classes.class";
require_once "libs/class_interface.php";
require "classes/class_atendimento.php";
$db = new db();
$db->_DEBUG = 1;
$hab1 = 0;
$hab = 0;
$form = new form('', true, "libs", false, 5);
if ($_POST["gravado"] != 1) {
$db->begin();
$campos = array("com_delivery" => 0, "com_dtcomanda" => date("Y-m-d"), "com_aberta" => '1', "com_mesid" => $_GET["mes_id"]);
$db->executa($db->insert($campos, "comandas"));
$comanda = $db->last_id("comandas", "com_id");
$gravado = 1;
$db->commit();
}
//echo $comanda;
if (isset($_POST["btncadastrar"])) {
echo $_POST["comanda"];
$db->begin();
$campos = array("cti_comid" => $_POST["com_id"], "cti_proid" => $_POST["cti_proid"], "cti_qtde" => $_POST["cti_qtde"]);
$db->executa($db->insert($campos, "comanda_itens"));
$item = $db->last_id("comanda_itens", "cti_id");
if (is_array($_POST["itens"])) {
$vi = '';
$obs = "Sem: ";
while (list($k, $v) = each($_POST["itens"])) {
function saveVersion($app, $tmpl_file, $code)
{
db::table('templates_versions');
db::where('app', $app);
db::where('tmpl_file', $tmpl_file);
db::where('version_code', $code);
db::order('version_date', 'DESC');
db::limit(1);
db::select();
if (db::rows() == 0) {
/*
delete over 10
*/
db::table('templates_versions');
db::where('app', $app);
db::where('tmpl_file', $tmpl_file);
db::order('version_date', 'DESC');
db::limit(10, 100);
db::delete();
db::table('templates_versions');
db::insert('', 'NOW()', $code, $app, $tmpl_file, 0, ADMIN_SITE_ID);
}
}
UPDATE `{PREFIX}models` SET `table_id` = :table_id WHERE `reference` = :reference
SQL;
\db::query($SQL_UPDATE, array(":table_id" => $table_id, ":reference" => $model->reference));
}
}
// place new model into the tree
$SQL_SP = 'CALL `{PREFIX}tree_insert`(?, ?, ?, ?)';
$params_SP = array($model->reference, $changes["to"]["parent"], $changes["to"]["prev"], 0);
if (\db::query($SQL_SP, $params_SP)) {
$response["success"] = true;
if ($result_apply = \db::query($SQL_apply, $params_apply)) {
$response["apply"] = $result_apply[0];
$model->permissioning($changes["to"]["parent"], $router->runner);
if ($model->permission && !$model->activate_allowed()) {
$SQL_STATE_INSERT = "INSERT INTO `{PREFIX}model_states` (`model`, `active`)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (?, ?)";
\db::insert($SQL_STATE_INSERT, array($model->reference, 0));
}
}
}
} elseif ($changes["from"] && is_array($changes["from"]) && isset($changes["from"]["parent"], $changes["from"]["prev"]) && !$changes["to"]) {
// remove model
$SQL_SP = 'CALL `{PREFIX}tree_remove`(?)';
$params_SP = array($model->reference);
\db::query($SQL_SP, $params_SP);
$response["success"] = true;
$pk = $router->runner->model_context["primary_key"];
$SQL_DELETE = "DELETE FROM `" . trim($model->table_from, " `") . "` WHERE `" . $pk . "` = :id";
\db::query($SQL_DELETE, array(':id' => $model->table_id));
if ($result_apply = \db::query($SQL_apply, $params_apply)) {
$response["apply"] = $result_apply[0];
}
$errors[] = $lang[$p]['error_invalid_code'];
} else {
$code = true;
}
}
if (count($errors) > 0) {
foreach ($errors as $error) {
echo baltsms::alert($error, "danger");
}
} else {
$baltsms = new baltsms();
$baltsms->setPrice($_POST['price']);
$baltsms->setCode($_POST['code']);
$baltsms->sendRequest();
if ($baltsms->getResponse() === true) {
$db->insert("INSERT INTO `" . $c[$p]['db']['table'] . "` (`nickname`, `server`, `mc_group`, `length`, `time`, `expires`) VALUES (?, ?, ?, ?, ?, ?)", array($_POST['nickname'], $_POST['server'], $_POST['group'], $c[$p]['groups'][$_POST['server']][$_POST['group']][$_POST['price']], time(), strtotime("+" . $c[$p]['groups'][$_POST['server']][$_POST['group']][$_POST['price']] . " days", time())));
$addGroup = str_replace(array("<NICKNAME>", "<GROUP>"), array($_POST['nickname'], $_POST['group']), $c[$p]['commands']['addGroup']);
$mc['rcon'][$_POST['server']]->send_command($addGroup);
if ($c[$p]['ingame']['notifications'] === true) {
$sendMessage = str_replace(array("<NICKNAME>", "<GROUP>"), array($_POST['nickname'], $_POST['group']), $c[$p]['ingame']['message']);
$mc['rcon'][$_POST['server']]->send_command("say " . $sendMessage);
}
echo baltsms::alert($lang[$p]['group_purchased'], "success");
?>
<script type="text/javascript">
setTimeout(function(){
loadPlugin('<?php
echo $p;
?>
');
}, 3000);
} else {
$fields[$row['column_name']] = false;
}
}
}
}
$keys = array_keys($fields);
array_walk($keys, function (&$value, $index) {
$value = '`' . $value . '`';
});
$params = array();
foreach ($fields as $key => $value) {
$params[':' . $key] = $value;
}
$SQL_table = 'INSERT INTO `' . $table . '` (' . implode(', ', $keys) . ') VALUES (' . implode(', ', array_keys($params)) . ')';
if ($primary_id = \db::insert($SQL_table, $params)) {
if (!$table_from) {
$table_from = $table;
}
$table_id = $primary_id;
// insert new model
$SQL_SP = 'CALL `{PREFIX}model_reference`(?, ?, ?)';
if ($reference_id = \db::query($SQL_SP, array($model_class, $table_from, $table_id))) {
$reference = $reference_id[0]['reference'];
}
}
}
}
$router = false;
$fields = array();
if ($model = model::load(array('self' => array('reference' => $reference)), $route, $router)) {
/**
* Saves the current object.
*
* @chainable
* @return ORM
*/
public function save()
{
if (!empty($this->changed)) {
// Require model validation before saving
if (!$this->_valid) {
$this->validate();
}
$data = array();
foreach ($this->changed as $column) {
// Compile changed data
$data[$column] = $this->object[$column];
}
if (!$this->empty_primary_key() and !isset($this->changed[$this->primary_key])) {
// Primary key isn't empty and hasn't been changed so do an update
if (is_array($this->updated_column)) {
// Fill the updated column
$column = $this->updated_column['column'];
$format = $this->updated_column['format'];
$data[$column] = $this->object[$column] = $format === TRUE ? time() : date($format);
}
$query = db::update($this->table_name)->set($data)->where($this->primary_key, '=', $this->primary_key_value)->execute($this->db);
// Object has been saved
$this->_saved = TRUE;
} else {
if (is_array($this->created_column)) {
// Fill the created column
$column = $this->created_column['column'];
$format = $this->created_column['format'];
$data[$column] = $this->object[$column] = $format === TRUE ? time() : date($format);
}
$result = db::insert($this->table_name)->columns(array_keys($data))->values(array_values($data))->execute($this->db);
if ($result->count() > 0) {
if (empty($this->object[$this->primary_key])) {
// Load the insert id as the primary key
$this->object[$this->primary_key] = $result->insert_id();
}
// Object is now loaded and saved
$this->_loaded = $this->_saved = TRUE;
}
}
if ($this->saved() === TRUE) {
// All changes have been saved
$this->changed = array();
}
}
if ($this->saved() === TRUE and !empty($this->changed_relations)) {
foreach ($this->changed_relations as $column => $values) {
// All values that were added
$added = array_diff($values, $this->object_relations[$column]);
// All values that were saved
$removed = array_diff($this->object_relations[$column], $values);
if (empty($added) and empty($removed)) {
// No need to bother
continue;
}
// Clear related columns
unset($this->related[$column]);
// Load the model
$model = ORM::factory(inflector::singular($column));
if (($join_table = array_search($column, $this->has_and_belongs_to_many)) === FALSE) {
continue;
}
if (is_int($join_table)) {
// No "through" table, load the default JOIN table
$join_table = $model->join_table($this->table_name);
}
// Foreign keys for the join table
$object_fk = $this->foreign_key($join_table);
$related_fk = $model->foreign_key($join_table);
if (!empty($added)) {
foreach ($added as $id) {
// Insert the new relationship
db::insert($join_table)->columns($object_fk, $related_fk)->values($this->primary_key_value, $id)->execute($this->db);
}
}
if (!empty($removed)) {
db::delete($join_table)->where($object_fk, '=', $this->primary_key_value)->where($related_fk, 'IN', $removed)->execute($this->db);
}
// Clear all relations for this column
unset($this->object_relations[$column], $this->changed_relations[$column]);
}
}
if ($this->saved() === TRUE) {
// Clear the per-request database cache
$this->db->clear_cache(NULL, Database::PER_REQUEST);
}
return $this;
}
if ($e) {
$e_camp[] = urldecode($e);
}
$method = $e_camp[0];
$deliver = hexdec($e_camp[1]);
$hash = stripslashes($e_camp[2]);
$hashb64 = base64_decode(str_replace(',', '/', $e_camp[2]));
$click_url = "";
if (isset($e_camp[3])) {
$click_url = $e_camp[3];
}
$SQL = "SELECT address_id, uhash FROM e_delivered WHERE id = :deliver";
if (($delivered = \db::query($SQL, array(":deliver" => $deliver))) && isset($delivered[0]["uhash"]) && (\Routerunner\Crypt::checker($delivered[0]["uhash"], $hash) || \Routerunner\Crypt::checker($delivered[0]["uhash"], $hashb64))) {
$stat_params = array(":date" => time(), ":deliver_id" => $deliver, ":method" => $method, ":click" => $click_url, ":referer" => isset($_SERVER["HTTP_REFERER"]) ? $_SERVER["HTTP_REFERER"] : (isset($_SERVER["HTTP_FROM"]) ? $_SERVER["HTTP_FROM"] : null), ":ip" => $_SERVER["REMOTE_ADDR"], ":ua" => $_SERVER["HTTP_USER_AGENT"], ":cookie" => print_r($_COOKIE, true), ":server" => print_r($_SERVER, true));
$SQL_stat = "INSERT INTO e_stat (date, deliver_id, method, click, ip, useragent, referer, cookie, server) VALUES (:date, :deliver_id, :method, :click, :ip, :ua, :referer, :cookie, :server)";
\db::insert($SQL_stat, $stat_params);
if ($method == "unsubscribe" && isset($delivered[0]["address_id"])) {
$SQL_unsubscribe = "UPDATE e_subscriber SET unsubscribe = :time WHERE id = :id";
\db::query($SQL_unsubscribe, array(":time" => time(), ":id" => $delivered[0]["address_id"]));
$isOk = false;
$SQL_check = "SELECT unsubscribe FROM e_subscriber WHERE id = :id";
if (($check_result = \db::query($SQL_check, array(":id" => $delivered[0]["address_id"]))) && isset($check_result[0]["unsubscribe"]) && !is_null($check_result[0]["unsubscribe"])) {
$isOk = true;
}
if ($isOk) {
$url = \runner::config("BASE") . "unsubscribe/success";
} else {
$url = \runner::config("BASE") . "unsubscribe/error";
}
header("Location: " . $url);
} elseif ($method == "open") {
<?php
include 'config.php';
include 'db.php';
include 'utils.php';
if (empty($_FILES["mypic"])) {
exit;
}
$names = $_FILES["mypic"]["name"];
$tmp_names = $_FILES["mypic"]["tmp_name"];
for ($i = 0; $i < count($names); $i++) {
$picname = $names[$i];
$tmp_name = $tmp_names[$i];
$type = strstr($picname, '.');
$pics = getMillisecond() . $type;
// 上传路径
$pic_path = "upload/" . $pics;
move_uploaded_file($tmp_name, $pic_path);
$result = db::insert(UPLOAD_FILE_TABLE, array("name" => $picname, "localpath" => $pic_path, "type" => $type));
var_dump($result);
}
?>
$geo_lat = $tweet_object->geo->coordinates[0];
$geo_long = $tweet_object->geo->coordinates[1];
} else {
$geo_lat = $geo_long = 0;
}
$user_object = $tweet_object->user;
$user_id = $user_object->id_str;
$screen_name = $oDB->escape($user_object->screen_name);
$name = $oDB->escape($user_object->name);
$profile_image_url = $user_object->profile_image_url;
// Add a new user row or update an existing one
$field_values = 'screen_name = "' . $screen_name . '", ' . 'profile_image_url = "' . $profile_image_url . '", ' . 'user_id = ' . $user_id . ', ' . 'name = "' . $name . '", ' . 'location = "' . $oDB->escape($user_object->location) . '", ' . 'url = "' . $user_object->url . '", ' . 'description = "' . $oDB->escape($user_object->description) . '", ' . 'created_at = "' . $oDB->date($user_object->created_at) . '", ' . 'followers_count = ' . $user_object->followers_count . ', ' . 'friends_count = ' . $user_object->friends_count . ', ' . 'statuses_count = ' . $user_object->statuses_count . ', ' . 'time_zone = "' . $user_object->time_zone . '", ' . 'last_update = "' . $oDB->date($tweet_object->created_at) . '"';
if ($oDB->in_table('users', 'user_id="' . $user_id . '"')) {
$oDB->update('users', $field_values, 'user_id = "' . $user_id . '"');
} else {
$oDB->insert('users', $field_values);
}
// Add the new tweet
$field_values = 'tweet_id = ' . $tweet_id . ', ' . 'tweet_text = "' . $tweet_text . '", ' . 'created_at = "' . $created_at . '", ' . 'geo_lat = ' . $geo_lat . ', ' . 'geo_long = ' . $geo_long . ', ' . 'user_id = ' . $user_id . ', ' . 'screen_name = "' . $screen_name . '", ' . 'name = "' . $name . '", ' . 'profile_image_url = "' . $profile_image_url . '", ' . 'is_rt = ' . $is_rt;
$oDB->insert('tweets', $field_values);
// The mentions, tags, and URLs from the entities object are also
// parsed into separate tables so they can be data mined later
foreach ($entities->user_mentions as $user_mention) {
$where = 'tweet_id=' . $tweet_id . ' ' . 'AND source_user_id=' . $user_id . ' ' . 'AND target_user_id=' . $user_mention->id;
if (!$oDB->in_table('tweet_mentions', $where)) {
$field_values = 'tweet_id=' . $tweet_id . ', ' . 'source_user_id=' . $user_id . ', ' . 'target_user_id=' . $user_mention->id;
$oDB->insert('tweet_mentions', $field_values);
}
}
foreach ($entities->hashtags as $hashtag) {
$where = 'tweet_id=' . $tweet_id . ' ' . 'AND tag="' . $hashtag->text . '"';
}
if ($connection->response['code'] != 200) {
break;
}
$results = json_decode($connection->response['response']);
foreach ($results as $dm) {
$dm_id = $dm->id;
$max_id = $dm_id;
if ($db->in_table('dms', "dm_id={$dm_id}")) {
continue;
}
$dm_text = $db->escape($dm->text);
$created_at = $db->date($dm->created_at);
$sender_user_id = $dm->sender->id;
$recipient_user_id = $dm->recipient->id;
$db->insert('dms', "dm_id={$dm_id},dm_text='{$dm_text}',created_at='{$created_at}',\r\n\t\t\tsender_user_id={$sender_user_id},recipient_user_id={$recipient_user_id},sent=1");
$screen_name = $db->escape($dm->recipient->screen_name);
$name = $db->escape($dm->recipient->name);
$location = $db->escape($dm->recipient->location);
$description = $db->escape($dm->recipient->description);
$url = $db->escape($dm->recipient->url);
$profile_image_url = $db->escape($dm->recipient->profile_image_url);
$created_at = $dm->recipient->created_at;
$friends_count = $dm->recipient->friends_count;
$followers_count = $dm->recipient->followers_count;
$statuses_count = $dm->recipient->statuses_count;
$listed_count = $dm->recipient->listed_count;
$lang = $dm->recipient->lang;
if (empty($dm->recipient->protected)) {
$protected = 0;
} else {
if (!preg_match("/^[a-zA-Z ]*\$/", $username)) {
header("Location:form2_val_php.php?again=again&error=error1");
}
}
if (empty($_POST["pass"])) {
header("Location:form2_val_php.php?error");
}
$pass = $_POST["pass"];
if (empty($_POST["email"])) {
} else {
$email = $_POST["email"];
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
header("Location:form2_val_php.php?error");
} else {
$address = $_POST["address"];
}
if (empty($_POST["gender"])) {
header("Location:form2_val_php.php?error");
} else {
$gender = $_POST["gender"];
$choice = $_POST["choice"];
$language = $_POST["laguage"];
$lan = implode(",", $language);
echo $img = $_FILES["pic"]["name"];
move_uploaded_file($_FILES["pic"]["tmp_name"], "images/{$img}");
$tablename = "register";
$database_f = "username,password,email,address,gender,choice,language,pic";
$user_value = "'{$username}','{$pass}','{$email}','{$address}','{$gender}','{$choice}','{$lan}','{$img}'";
$obj->insert($tablename, $database_f, $user_value);
}
$data = json_decode($connection->response['response'], true);
// Get the list of friend user_ids, which will be an array
$ids = $data['ids'];
// Get the cursor value for the next request
$cursor = $data['next_cursor_str'];
// If there are any friends returned
if (sizeof($ids)) {
foreach ($ids as $user_id) {
// If this friend is already in the table,
// set the current field back to 1
if ($db->in_table('friends', "user_id={$user_id}")) {
$db->update('friends', 'current=1', "user_id={$user_id}");
} else {
// If this is a new friend,
// insert it with a current value of 1
$db->insert('friends', "user_id={$user_id},current=1");
// If this is not the first time friends have been collected,
// record this new friend event in the follow_log table
if (!$first_collection) {
$db->insert('follow_log', "user_id={$user_id},event='friend'");
}
}
}
} else {
// Stop collecting if no more friends are found
break;
}
} else {
// If an error occurs, exit and try again later
exit;
}
public static function comprobar_query($query)
{
$blacklist = array('union', 'unhex', 'hex', 'char', 'UNION', 'UNHEX', 'HEX', 'CHAR', 'INFORMATION_SCHEMA');
$query = str_replace(array('(', ')', ','), ' ', $query);
$words = explode(" ", $query);
$result = array_intersect($blacklist, $words);
if (count($result) > 0) {
$db = new db();
$db->insert("log", array("ip" => $_SERVER['REMOTE_ADDR'], "querystring" => $_SERVER['QUERY_STRING'], "php_server" => var_export($_SERVER, 1)));
trigger_error("Consulta no permitida.<br/>" . var_export($_SERVER, 1), E_USER_NOTICE);
die("Consulta no permitida");
} else {
return true;
}
}
$op = $_POST['operation'];
$db = new db();
if ($op == "edit") {
$id = $_POST['id'];
$title = $_POST['title'];
$text = $_POST['text'];
if ($db->update("content", "title='" . $title . "', content='" . $text . "'", " id = '" . $id . "'")) {
echo '0';
} else {
echo '1';
}
} elseif ($op == "add") {
$title = $_POST['title'];
$text = $_POST['text'];
$col[] = "title";
$col[] = "content";
$var[] = $title;
$var[] = $text;
//db::setDebug(2);
if ($db->insert("content", $col, $var)) {
if ($db->insert("navigation_links", array("link", "type", "content_id", "titel", "tpl"), array("content", "1", $db->getLastId(), $title, "1"))) {
echo '0';
}
} else {
echo '1';
}
} elseif ($op == "delete") {
$id = $_POST['id'];
$db->delete("content", "id = '" . $id . "'");
$db->delete("navigation_links", "content_id = '" . $id . "'");
}
/**
* 分析提取HTML页面中的字段
*
* @param mixed $html
* @return void
* @author seatle <*****@*****.**>
* @created time :2016-09-18 10:17
*/
public function get_html_fields($html, $url, $page)
{
$fields = $this->get_fields(self::$configs['fields'], $html, $url, $page);
if (!empty($fields)) {
if ($this->on_extract_page) {
$return_data = call_user_func($this->on_extract_page, $page, $fields);
if (!isset($return_data)) {
log::warn("on_extract_page function return value can't be empty\n");
} elseif (!is_array($return_data)) {
log::warn("on_extract_page function return value must be an array\n");
} else {
$fields = $return_data;
}
}
if (isset($fields) && is_array($fields)) {
$fields_num = $this->incr_fields_num();
$fields_str = json_encode($fields, JSON_UNESCAPED_UNICODE);
//if (isset(self::$configs['show_encoding']) && strtolower(self::$configs['show_encoding']) != 'utf-8')
//{
//$fields_str = mb_convert_encoding($fields_str, self::$configs['show_encoding'], 'utf-8');
//}
if (util::is_win()) {
$fields_str = mb_convert_encoding($fields_str, 'gb2312', 'utf-8');
}
log::info(date("H:i:s") . " Result[{$fields_num}]: " . $fields_str . "\n");
// 如果设置了导出选项
if (!empty(self::$configs['export'])) {
self::$export_type = isset(self::$configs['export']['type']) ? self::$configs['export']['type'] : '';
if (self::$export_type == 'csv') {
util::put_file(self::$export_file, util::format_csv($fields) . "\n", FILE_APPEND);
} elseif (self::$export_type == 'sql') {
$sql = db::insert(self::$export_table, $fields, true);
util::put_file(self::$export_file, $sql . ";\n", FILE_APPEND);
} elseif (self::$export_type == 'db') {
db::insert(self::$export_table, $fields);
}
}
}
}
}
<?php
require "libs/fc_sessoes.php";
require "libs/classes.class";
require "libs/form2.class";
require "libs/funcoes.php";
require "libs/class_interface.php";
$db = new db();
if (isset($_POST['btncadastrar'])) {
$campos = array("pro_id" => $_POST["pro_id"], "pro_nome" => $_POST["pro_nome"], "pro_descr" => $_POST["pro_descr"], "pro_estoque" => $_POST["pro_estoque"], "pro_catid" => $_POST["pro_catid"], "pro_foto" => $_POST["pro_foto"], "pro_preco" => $_POST["pro_preco"]);
$rs = $db->executa($db->insert($campos, "produtos"));
if ($rs) {
$pro_id = $db->last_id("produtos_itens", 'ite_id');
echo "<script>\n parent.Ingredientes1.location.href='cad_nprodutoitem.php?pro_id={$pro_id}';\n parent.mo_camada('Ingredientes','Ingredientes1'); \n </script>";
}
}
if (isset($_POST['btnalterar'])) {
$campos = array("pro_nome" => $_POST["pro_nome"], "pro_descr" => $_POST["pro_descr"], "pro_estoque" => $_POST["pro_estoque"], "pro_catid" => $_POST["pro_catid"], "pro_foto" => $_POST["pro_foto"], "pro_preco" => $_POST["pro_preco"]);
$db->valida_trans($db->update($campos, "produtos", "\n\t pro_id", $_POST["pro_id"]), 0);
}
if (isset($_GET["pro_id"])) {
$btnlabel = "Alterar";
$btnname = "btnalterar";
$db->dselect("produtos", "pro_id", $_GET["pro_id"], true);
echo "<script>\n parent.Ingredientes1.location.href='cad_nprodutoitem.php?pro_id={$pro_id}';\n \n </script>";
} else {
$btnlabel = "Cadastrar";
$btnname = "btncadastrar";
}
$form = new form('', false, "libs", false);
?>
if ($dbh->select_res['aprv_status'] == 1) {
header("Location:../register.php?msg=This Mobile No. already registered!&msg_clr=red");
exit;
} else {
$reg_id = $dbh->select_res['id'];
header("Location:../account_activation.php?msg=This Mobile already registered. Please activate that a/c.&msg_clr=red®_id={$reg_id}&time=2");
exit;
}
} else {
$dbh->select("users", "id", "mobile='{$mobile}'", "none", "none");
if ($dbh->sel_count_row > 0) {
header("Location:../register.php?msg=This mobile already Registered!&msg_clr=red");
exit;
} else {
$reg_code = substr(number_format(time() * rand(), 0, '', ''), 0, 7);
$dbh->insert("tmp_users", "first_name='{$f_name}', last_name='{$l_name}', mobile='{$mobile}', email='{$email}', password='******', reg_time=now(), activation_code='{$reg_code}', aprv_status='0'");
$reg_id = mysql_insert_id();
if (isset($reg_id)) {
if ($reg_id > 0) {
include_once "../classes/sms.class.php";
$sms = new sms();
// $sms->send_authcode($mobile, $f_name, $reg_code);
header("Location:../account_activation.php?reg_id={$reg_id}&time=1");
exit;
} else {
header("Location:../register.php?msg=Some Error in Registration, Please Try again later!!&msg_clr=red");
exit;
}
} else {
header("Location:../register.php?msg=Some Error in Registration, Please Try again later!&msg_clr=red");
exit;
