/**
* 修改联系人信息
* @todo 未完成
* @param Group_Contact $group_contact 联系人信息
*/
public function update($group_id, $contact, $mode = 'default')
{
$id = $contact->get_id();
switch ($mode) {
case 'overwrite':
$setters = array();
$setters['gid'] = $group_id;
foreach ($this->map as $field) {
$name = (string) $field->name;
$getprop = (string) $field->accessor;
if (in_array($name, array('uid', 'fid', 'formatted_name', 'phonetic', 'given_name', 'middle_name', 'family_name', 'prefix', 'suffix', 'organization', 'department', 'note', 'birthday', 'title', 'nickname', 'sort', 'modified'))) {
$setters[$name] = call_user_func(array($contact, $getprop));
}
}
$sqls = $this->_edit_avatar($group_id, $id, $contact->get_avatar());
foreach (array('emails', 'tels', 'addresses', 'ims', 'urls', 'events', 'relations') as $type) {
$sqls = array_merge($sqls, $this->_edit_info($group_id, $id, $type, call_user_func(array($contact, 'get_' . $type))));
}
//更新数据库
$query = $this->db->update('gcp_contacts', $setters, array('gcid' => $id));
foreach ($sqls as $sql) {
$this->db->query($sql);
}
$contact->set_modified_at($setters['modified']);
return SUCCESS;
break;
}
return FAIL;
}
/**
* 更新快照信息
* @param int $user_id 用户ID
* @param int $history_id 快照ID
* @param array $setters 更新内容
* @return bool
*/
public function update_history($user_id, $history_id, $setters)
{
$this->db->begin();
$query = $this->db->update($this->get_table($user_id, 'contact_history'), $setters, array('id' => $history_id));
if (!$query) {
$this->db->rollback();
}
return $this->db->commit();
}
}
//end of for loop
$sql = "SELECT img_loc FROM doc_imgs where doc_imgs.doc_id='" . $get_decument_id . "' ";
$data = mysql_query($sql);
$con->disconnect();
}
//end of if statment if(isset($_POST['pleace']))
if (isset($_POST['change'])) {
$sql = "SELECT c_id FROM documentation where c_num='" . $course_id . "' ";
echo $sql;
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$get_decument_id = $row['c_id'];
echo $get_decument_id;
}
$con->update('documentation', array('course' => $course, 'event' => $event, 'c_name' => $course_name, 'c_num' => $course_id, 'c_location' => $pleace, 'c_collage_index' => $collage, 'c_dept' => $dept, 'c_price' => $price, 'c_gender' => $type, 'c_target_group' => $target, 'c_duration' => $how_long, 'c_req_num' => $at_least, 'c_reg_time' => $start_date, 'c_max_num' => $at_most, 'c_time_from' => $start_time, 'c_time_to' => $end_time, 'c_major' => $course_about, 'c_languate' => $language, 'c_goals' => $goals, 'c_doc_desc' => $description, 'c_notes' => $notes), array('c_id', $get_decument_id));
}
if (isset($_POST['delete_course_id'])) {
//echo "it is set <br/>";
$course_id = $_POST['delete_course_id'];
$sql = "SELECT c_id FROM documentation where c_num='" . $course_id . "' ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$get_decument_id = $row['c_id'];
}
$con->delete('comunity_service', 'documentation', 'c_id="' . $get_decument_id . '"');
}
//else{echo "not set";}
}
if (isset($_POST['delete_course_id'])) {
//echo "it is set <br/>";
$aDatos['entreCalles'] = filter_input(INPUT_POST, "entreCalles");
$aDatos['colonia'] = filter_input(INPUT_POST, "colonia");
$aDatos['ciudad'] = filter_input(INPUT_POST, "ciudad");
$aDatos['estado'] = filter_input(INPUT_POST, "estado");
$aDatos['codigoPostal'] = filter_input(INPUT_POST, "codigoPost");
// Pestaña de Localizacion
$aDatos['telefono'] = filter_input(INPUT_POST, "telefono");
$aDatos['fax'] = filter_input(INPUT_POST, "fax");
$aDatos['movil'] = filter_input(INPUT_POST, "movil");
$aDatos['email'] = filter_input(INPUT_POST, "email");
// Pestaña de Contacto
$aDatos['contactoNombre'] = filter_input(INPUT_POST, "contactoNombre");
$aDatos['contactoTelefono'] = filter_input(INPUT_POST, "contactoTelefono");
$aDatos['contactoMail'] = filter_input(INPUT_POST, "contactoMail");
// Pestaña Extras
$aDatos['direccionEntrega'] = filter_input(INPUT_POST, "direccionEntrega");
$aDatos['direccionCobro'] = filter_input(INPUT_POST, "direccionCobro");
$aDatos['comentario'] = filter_input(INPUT_POST, "comentarios");
$cDb = new DataBase();
if ($cIdCliente != "") {
$sWhere = "idCliente = {$cIdCliente}";
$actualizado = $cDb->update("cliente", $aDatos, $sWhere);
} else {
$actualizado = $cDb->insert("cliente", $aDatos);
}
$Mensaje = "Datos del Cliente Guardados Correctamente";
if (!$actualizado) {
$Mensaje = $cDb->LastError;
}
$return = array("correcto" => $actualizado, "mensaje" => $Mensaje);
echo json_encode($return);
ob_end_clean();
echo '{"success":false,"message":"error: no columns given to query"}';
exit;
}
if ($objParseColumns->success == false) {
ob_end_clean();
echo '{"success":false,"message":"error: no columns given to query"}';
exit;
}
$dataBase->parseJoin($strJoin);
$dataBase->parseRestrictions($strRestrictions);
$dataBase->parseOrderBy($strOrder);
$dataBase->parseGroupBy($strGroupBy);
$dataBase->parseLimit($strLimit);
$dataBase->parseValues($strValues);
ob_end_clean();
switch ($strQuery) {
case 'SELECT':
echo $dataBase->select();
break;
case 'INSERT':
echo $dataBase->insert();
break;
case 'DELETE':
echo $dataBase->delete();
break;
case 'UPDATE':
echo $dataBase->update();
break;
}
exit;
<?php
session_start();
include '../dataBaseClass/connection.php';
$aDatos = array();
$idAgente = filter_input(INPUT_POST, "idAgente");
$aDatos['nombre'] = filter_input(INPUT_POST, "nombre");
$aDatos['clave'] = filter_input(INPUT_POST, "clave");
$aDatos['direccion'] = filter_input(INPUT_POST, "direccion");
$aDatos['email'] = filter_input(INPUT_POST, "email");
$aDatos['telefono'] = filter_input(INPUT_POST, "telefono");
$aDatos['movil'] = filter_input(INPUT_POST, "movil");
$cDb = new DataBase();
if ($idAgente != '') {
$lCorrecto = $cDb->update("agente", $aDatos, "idAgente = '{$idAgente}'");
} else {
$lCorrecto = $cDb->insert("agente", $aDatos, false);
}
$mensaje = "Datos del agente guardados correctamente";
if (!$lCorrecto) {
$mensaje = "Error al tratar de guardar la informacion del agente: " . $cDb->LastError;
}
echo json_encode(array('correcto' => $lCorrecto, 'mensaje' => $mensaje));
$dbConfig = "";
die(json_encode(array('code' => 'error', 'comment' => 'no database type specified')));
}
include $dbConnector;
if (!hash_equals($authKey, crypt($auth, $authKey))) {
header("HTTP/1.1 403 Forbidden");
die(json_encode(array('code' => 'error', 'comment' => 'auth failed with authkey: ' . $auth)));
}
$db = new DataBase($dbConfig);
switch ($function) {
case 'listall':
echo $db->listall();
break;
case 'save':
if ($db->exists($itemName)) {
echo $db->update($itemName, $itemCount);
} else {
echo $db->save($itemName, $itemCount);
}
break;
case 'update':
echo $db->update($itemName, $itemCount);
break;
case 'delete':
echo $db->delete($itemName);
break;
case 'clear':
echo $db->clear();
break;
default:
die(json_encode(array('code' => 'error', 'comment' => 'function not specified')));
echo json_encode($newArr);
}
// Список отзывов
if ($_m == 'reviewList') {
$limit = $_GET['limit'];
$page = $_GET['page'];
$from = $page * $limit - $limit;
$array['result'] = $Db->select('SELECT * FROM reviews ORDER BY id DESC LIMIT ' . $from . ', ' . $limit);
$array['total'] = $Db->count('SELECT count(*) FROM reviews');
$array['unread'] = $Db->count('SELECT count(*) FROM reviews WHERE visible = ' . $Db->quote(0));
echo json_encode($array);
}
// Список отзывов
if ($_m == 'reviewListSetVisible') {
$ids = json_decode($_GET['ids']);
$Db->update('UPDATE reviews SET visible = ' . $Db->quote($_GET['visible']) . ' WHERE id IN (' . implode(',', array_map('intval', $ids)) . ')');
}
if ($_m == 'userList') {
$limit = $_GET['limit'];
$page = $_GET['page'];
$from = $page * $limit - $limit;
$search = '';
if (strlen($_GET['search']) > 0) {
$search = $_GET['search'];
}
$array['result'] = $Db->select('
SELECT id, login, f, i, o, date, type, email,
(SELECT count(id) FROM reviews WHERE reviews.user = user.id) as reviewsCount
FROM user
WHERE user.login like "%' . $search . '%"
ORDER BY id DESC
static function update($name, $array = array(), $nid)
{
$master = self::table_master($name);
DataBase::update($master, $array, array('id=:id', array(':id' => $nid)));
}
$user = $user[0];
sendMail($user['email'], Config::get('SITE_TITLE'), Config::get('SITE_TITLE'), 'Password reset', 'Dear ' . $user['firstname'] . ' ' . $user['lastname'] . ",<br /><br />Next to your request, your password will be reset. Click the link below to reset it.<br />If you didn't request us to reset your password, simply ignore this mail.<br /><br /><a href=\"http://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}?action=reset&token=" . $user['token'] . "\">Reset your password</a><br /><br /><small>Sent from Skyer</small>");
$showForgotSubmitted = true;
} else {
die('<h3>User not found</h3>');
}
} else {
$showForgot = true;
}
break;
case 'reset':
if (isset($_GET['token'])) {
$user = DataBase::get('users', array(), array('token' => $_GET['token']));
if (count($user) && $user !== false) {
$pass = md5(uniqid(rand(), true));
DataBase::update('users', array('password' => hash('sha384', $pass)), array('token' => $_GET['token']));
$showReset = true;
} else {
die('<h3>User not found</h3>');
}
} else {
die('<h3>Bad request</h3>');
}
break;
}
}
if (!User::isGuest() && (!isset($_GET['action']) || $_GET['action'] !== 'logout')) {
header('Location: index.php');
}
if (isset($_POST['submit']) && isset($_POST['pseudo']) && isset($_POST['password'])) {
$displayForm = false;
session_start();
include './dataBaseClass/connection.php';
$aDatos = array();
$idCompania = filter_input(INPUT_POST, "IdCompania");
$aDatos['nombre'] = filter_input(INPUT_POST, "nombre");
$aDatos['direccion'] = filter_input(INPUT_POST, "direccion");
$aDatos['telefono'] = filter_input(INPUT_POST, "telefono");
$aDatos['portal'] = filter_input(INPUT_POST, "portal");
$aTipos = array();
if (isset($_POST['chkTipoPoliza'])) {
$aTipos = $_POST['chkTipoPoliza'];
}
$cDb = new DataBase();
if ($idCompania != "") {
$sWhere = "idCompania = {$idCompania}";
$lCorrecto = $cDb->update("Companias", $aDatos, $sWhere);
} else {
$lCorrecto = $cDb->insert("Companias", $aDatos);
$idCompania = strval($cDb->LastInsertedId);
}
$mensaje = "Datos de la compañia guardados correctamente";
if (!$lCorrecto) {
$mensaje = "Error al tratar de guardar la informacion de la compañia: " . mysqli_stmt_error($stmt);
}
if ($lCorrecto) {
// Borramos los datos de los tipos de polizas y agregamos las nuevas seleccionadas
$cDb->delete("TipoPolizaCompania", "idCompania = {$idCompania}");
foreach ($aTipos as $value) {
$aData = array();
$aData['idCompania'] = $idCompania;
$aData['idTipo'] = $value;
<?php
session_start();
include '../dataBaseClass/connection.php';
$aDatos = array();
$id = filter_input(INPUT_POST, "idPaquete");
$tipoPoliza = filter_input(INPUT_POST, "tipoPoliza");
$cobertura = filter_input(INPUT_POST, "coberturaOrg");
$aDatos['idPaquete'] = filter_input(INPUT_POST, "idPaquete");
$aDatos['tipoPoliza'] = filter_input(INPUT_POST, "tipoPoliza");
$aDatos['cobertura'] = filter_input(INPUT_POST, "cobertura");
$cDb = new DataBase();
$lCorrecto = $cDb->update("Paquete", $aDatos, "idPaquete = '{$id}' AND tipoPoliza = '{$tipoPoliza}' AND cobertura = '{$cobertura}'");
$mensaje = "Datos del tipo de poliza guardados correctamente";
if (!$lCorrecto) {
$mensaje = "Error al tratar de guardar la informacion del tipo de poliza: " . $cDb->LastError;
}
echo json_encode(array('correcto' => $lCorrecto, 'mensaje' => $mensaje));
$mail['sender_ID'] = $mail['sender'];
$mail['sender'] = $sender['fullname'];
$recipient = User::getUserFromID($mail['recipient']);
$mail['recipient_ID'] = $mail['recipient'];
$mail['recipient'] = $recipient['fullname'];
die(json_encode($mail));
break;
case 'move':
$mail = DataBase::get('messages', array('sender', 'recipient'), array('ID' => $_GET['ID']));
if (count($mail) && $mail !== false) {
$mail = $mail[0];
if ($mail['sender'] == User::getID()) {
$r = DataBase::update('messages', array('sender_dir' => $_GET['dir']), array('ID' => $_GET['ID'], 'sender' => User::getID()))->fetch();
} else {
if ($mail['recipient'] == User::getID()) {
$r = DataBase::update('messages', array('recipient_dir' => $_GET['dir']), array('ID' => $_GET['ID'], 'recipient' => User::getID()))->fetch();
} else {
die('<h3>Mail not found</h3>');
}
}
} else {
die('<h3>That\'s not your mail !</h3>');
}
die('true');
break;
case 'unread':
$unread = DataBase::query('SELECT COUNT(*) FROM messages WHERE opened = 0 AND recipient_dir = ' . DataBase::_secure($_GET['folder']) . ' AND recipient = ' . User::getID())->fetch()[0];
if (strval($unread)) {
die($unread);
} else {
die;
$allowGuest = true;
$hideDefaultView = true;
require 'framework/inc.php';
Page::setTitle('Register');
Page::css('inspinia/plugins/iCheck/custom');
Page::css('register');
Page::js('inspinia/plugins/iCheck/icheck.min');
Page::js('register');
$registered = $activated = false;
$err = '';
if (isset($_GET['activate'])) {
$user = DataBase::get('users', array(), array('token' => $_GET['activate']));
if (count($user) && $user !== false) {
$pass = md5(uniqid(rand(), true));
DataBase::update('users', array('activated' => 1), array('token' => $_GET['activate']));
$activated = true;
} else {
die('<h3>User not found</h3>');
}
} elseif (isset($_POST['submit'])) {
$required = array('pseudo', 'firstname', 'lastname', 'fullname', 'email', 'email-confirm', 'password', 'password-confirm');
foreach ($required as $i => $name) {
if (!isset($_POST[$name])) {
$err = 'All fields are required';
} else {
$_POST[$name] = htmlspecialchars($_POST[$name]);
}
}
if (strlen($_POST['pseudo']) < 5) {
$err = 'Pseudo must be at least 5 characters';
