A convenient SELECT * function to get one record.
/**
* send message to all users
* @param $text
* @param $chatid
* @param $status
* @param MysqliDb $db
* @param TelegramBot\Api\BotApi $bot
*/
function sendMessageToAll($text = null, $chatid, $status, $db, $bot)
{
//this is use for hide confirm keyboard
$hideKeys = new \TelegramBot\Api\Types\ReplyKeyboardHide(true);
if ($status == 1) {
//confirm keyboard
$keys = new \TelegramBot\Api\Types\ReplyKeyboardMarkup(array(array("بله", "خیر")), false, true, true);
if ($text == null) {
//admin is going to send next message and next message stored
$db->orderBy('ID', 'DESC');
$q = $db->getOne('nextMessages', array('text'));
$text = $q['text'];
}
$db->update('adminOperations', array('message' => $text));
$status = 2;
//admin get confirm
$msg = "پیام زیر برای همه کاربران ارسال خواهد شد. آیا برای ارسال پیامها اطمینان دارید؟\n\n";
$msg .= $text;
$bot->sendMessage($chatid, $msg, true, null, $keys);
} elseif ($status == 2 && $text == 'بله') {
//get all user and send message for them
$users = $db->get('users');
$db->orderBy('ID', 'DESC');
//custom message and next message temporary stored in adminOperations table
$q = $db->getOne('adminOperations', array('message'));
$message = $q['message'];
foreach ($users as $user) {
try {
$bot->sendMessage($user['ID'], $message);
} catch (Exception $e) {
error_log($e->getMessage());
}
}
$bot->sendMessage($chatid, 'پیام مورد نظر ارسال شد', true, null, $hideKeys);
$status = 0;
} else {
$bot->sendMessage($chatid, 'ارسال پیام لغو شد', true, null, $hideKeys);
$status = 0;
}
$db->update('adminOperations', array('send_status' => $status));
}
/**
* Convinient function to fetch one object. Mostly will be togeather with where()
*
* @access public
* @param array|string $fields Array or coma separated list of fields to fetch
*
* @return dbObject
*/
private function getOne($fields = null)
{
$results = $this->db->getOne($this->dbTable, $fields);
$this->processArrays($results);
$this->processWith($results);
if ($this->returnType == 'Array') {
return $results;
}
$item = new static($results);
$item->isNew = false;
return $item;
}
public function routeToCrm($host, $username, $password, $databaseName)
{
if (isset($_COOKIE['username'])) {
$user = $_COOKIE['username'];
}
if (isset($_COOKIE['mdp'])) {
//Récupération du mot de passe stocké
$db = new MysqliDb($host, $username, $password, $databaseName);
$db->where("user_name", $user);
$users = $db->getOne("users");
$pwd = $users['user_hash'];
// Création du mot de passe hashé
// $mdp = crypt(strtolower($_COOKIE['mdp']),$pwd);
$mdp = $_COOKIE['mdp'];
}
// Login au CRM
$url = "http://localhost/mysite/crm74/service/v4_1/soap.php?wsdl";
require_once "../crm74/include/nusoap/lib/nusoap.php";
//retrieve WSDL
$client = new nusoap_client($url, 'wsdl');
$proxy = $client->getProxy();
//Affichage des erreurs
$err = $client->getError();
if ($err) {
echo '<h2>Erreur du constructeur</h2><pre>' . $err . '</pre>';
echo '<h2>Debug</h2><pre>' . htmlspecialchars($client->getDebug(), ENT_QUOTES) . '</pre>';
exit;
}
// login ----------------------------------------------------
$login_parameters = array('user_auth' => array('user_name' => $user, 'password' => $mdp, 'version' => '1'), 'application_name' => 'SugarTest');
$login_result = $client->call('login', $login_parameters);
echo '<pre>';
//get session id
$session_id = $login_result['id'];
$result = $proxy->seamless_login($session_id);
// Ouverture de la session SuiteCRM
header("Location: http://localhost/mysite/crm74/index.php?module=Administration&action=index&MSID={$session_id}");
}
echo ' <body>' . "\n";
if (isset($_POST['submitted'])) {
$submited = $_POST['submitted'];
$name = explode(" ", $_POST['name']);
$pass = $_POST['pass'];
if (isset($pass) && !empty($pass)) {
if (isset($name) && !empty($name[0])) {
if (count($name) >= 1 && count($name) <= 2) {
if (count($name) > 1) {
$db->where('fName', $name[0]);
$db->where('lName', $name[1]);
} else {
$db->where('fName', $name);
$db->orWhere('lName', $name);
}
$user = $db->getOne("Users");
$hash = $user['password'];
if (password_verify($pass, $hash)) {
echo 'Password is valid!';
$_SESSION['user'] = new User($user['id'], $user['fName'], $user['lName'], $user['admin']);
} else {
echo 'Invalid password.';
}
} else {
echo "invalid Name given";
}
} else {
echo "You must enter a name";
}
//header('Location: index.php');
} else {
if ($accion_form == ACCION_OBTERNER_POR_ID) {
$parametros = $postdata->form_parametros;
foreach ($parametros as $parametro_key => $parametro_valor) {
// var_dump($parametro_key);
// var_dump($parametro_valor);
foreach ($parametro_valor as $key => $val) {
// var_dump($key);
// var_dump($val);
switch ($key) {
case PARAMETRO_ID:
$bd->where(COLUMNA_ID, (int) $val);
break;
}
}
}
$query = $bd->getOne(TABLA_CATEGORIA);
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
} else {
if ($accion_form == ACCION_AGREGAR) {
$data_post = $postdata->form_data;
if (!isset($data_post->FOTO)) {
$data_post->FOTO = NULL;
}
$datos = array(COLUMNA_NOMBRE => $data_post->NOMBRE, COLUMNA_DESCRIPCION => $data_post->DESCRIPCION, COLUMNA_ESTADO => $data_post->ESTADO, COLUMNA_FOTO => $data_post->FOTO);
$id_nuevo = $bd->insert(TABLA_CATEGORIA, $datos);
if (!$id_nuevo) {
$arr = array(RESPUESTA_ERROR => $bd->getLastError());
} else {
$datos[COLUMNA_ID] = $id_nuevo;
$arr = array(RESPUESTA_DATA => $datos, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
}
$bd->delete(TABLA_REL_PRODUCTO_CATEGORIA);
$query = $bd->get(TABLA_PRODUCTO);
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
} else {
if ($accion_form == ACCION_OBTERNER_POR_ID) {
$parametros = $postdata->form_parametros;
foreach ($parametros as $parametro_key => $parametro_valor) {
foreach ($parametro_valor as $key => $val) {
switch ($key) {
case PARAMETRO_ID:
$bd->where(COLUMNA_ID, (int) $val);
break;
}
}
}
$query = $bd->getOne(TABLA_PRODUCTO);
$bd->where(COLUMNA_ID_PRODUCTO, $query[COLUMNA_ID_M]);
$referencias = $bd->get(TABLA_REL_PRODUCTO_CATEGORIA);
foreach ($referencias as $parametro_key => $parametro_valor) {
// AGREGOS LAS CATEGORIAS A LA QUE PERTENECE CADA PRODUCTO
$bd->where(COLUMNA_ID, $parametro_valor[COLUMNA_ID_CATEGORIA]);
$referencias_aux = $bd->getOne(TABLA_CATEGORIA);
$referencias[$parametro_key] = $referencias_aux;
}
$query[VALOR_CATEGORIAS] = $referencias;
$arr = array(RESPUESTA_DATA => $query, RESPUESTA_MENSAJE => MENSAJE_OK, RESPUESTA_ERROR => ERROR_NINGUNO);
}
}
}
}
}
public function getTranslation($lang, $format)
{
if ($this->trailID == "undefined") {
return "Trail ID has not been defined. Call setID({$ID}) before requesting data.";
} else {
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$db->where("trail_id", $this->trailID);
$db->where("lang", $lang);
if ($db->has("translations")) {
$db->where("trail_id", $this->trailID);
$db->where("lang", $lang);
$result = $db->getOne("translations");
$attractions = json_decode(stripslashes($result['attractions']));
$result['attractions'] = $attractions;
$loops = json_decode(stripslashes($result['loops']));
$result['loops'] = $loops;
if ($format == "JSON") {
return json_encode($result);
} elseif ($format == "XML") {
return "Maybe someday..";
} else {
return $result;
}
} else {
return "Elang";
}
}
}
error_log("خطا در دریافت اطلاعات\n\n" . $e->getMessage());
}
$text = strtolower($text);
$bot = new TelegramBot\Api\BotApi(TOKEN);
try {
switch ($text) {
case '/start':
case '/start@softwaretalkbot':
$message = "سلام\nبه ربات جلسات باز نرم افزاری خوش آمدید.\nجهت اطلاع از جلسه آتی عبارت next را ارسال کنید.";
$bot->sendMessage($chatid, $message);
break;
case '/next':
case '/next@softwaretalkbot':
case 'next':
$db->orderBy('ID', 'DESC');
$q = $db->getOne('nextMessages');
$message = $q['text'];
$bot->sendMessage($chatid, $message);
break;
case '/about':
case '/about@softwaretalkbot':
case 'about':
$bot->sendMessage($chatid, "من اطلاعات جلسات باز نرم افزاری مشهد را برایتان ارسال میکنم.\n" . "سورس من روی گیت هاب قرار دارد. می توانید از طریق لینک زیر آن را مشاهده کنید:\n" . "https://github.com/mnameghi/SoftwareTalks");
break;
//set next message
//set next message
case COMMAND1:
case '/' . COMMAND1:
if (!isAdmin($chatid, $db)) {
return;
}
public function checkSession()
{
$db = new MysqliDb(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$db->where("user_id", $_SESSION['user_id']);
$user = $db->getOne("logged_in_member");
if ($user) {
//Check ID and Token
if (session_id() == $user['session_id'] && $_SESSION['token'] == $user['token']) {
//Id and token match, refresh the session for the next request
$this->refreshSession();
return "auth";
} else {
return "unauth";
}
} else {
return "unauth";
}
}
<?php
require_once 'inc/MysqliDb.php';
require_once 'inc/HtmlDiff.php';
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$history = $db->getOne('history');
$db->where('contract_id', $history['contract_id']);
$db->where('doc_id', $history['doc_id']);
$historys = $db->get('history');
if (!isset($_GET['toid']) || $_GET['toid'] == null || $_GET['toid'] == "" || $_GET['toid'] == 0) {
$db->where('id', $history['contract_id']);
$contracts = $db->getOne('contracts');
$index = $history['doc_id'];
$contract_content = json_decode($contracts['content']);
$to_text = $contract_content[$index]->content;
} else {
$db->where('id', $_GET['toid']);
$to_history = $db->getOne('history');
$to_text = $to_history['content'];
}
$from_text = $history['content'];
// $opcodes = FineDiff::getDiffOpcodes($from_text, $to_text);
// echo FineDiff::renderDiffToHTMLFromOpcodes($from_text, $opcodes);
$diff = new HtmlDiff($from_text, $to_text);
$diff->build();
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script type="text/javascript" src="../assets/js/jquery/jquery-1.7.1.min.js"></script>
function systemStatusUpdateEmail($id, $message)
{
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$contract = $db->getOne('contracts');
$to = $contract['client_email'];
$subject = "";
$encrypt = new Encryption();
$link = $encrypt->encode($id);
$message = "Updates have been made to one or more of your documents. Please click the link below to review and approve the changes.\n http://" . $_SERVER['HTTP_HOST'] . "/contract_gen/contract.php?id=" . $link;
$headers = 'From: support@ignitorlabs.com' . "\r\n" . 'Reply-To: ' . $contract['ignitor_email'] . "\r\n" . 'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);
}
require_once 'MysqliDb.php';
//Extracts question from forms and stores into database
$question_username = "******";
//$_POST['question_username'];
$question = "college canteen needs to be improved";
//$_POST['question'];
$description = "details";
//$_POST['description'];
$type = "general";
//$_POST['branch']; //branch or general
$timestamp = date('Y-m-d H:i:s');
$db = new MysqliDb('localhost', 'root', 'hack123', 'colgpolls');
$data = array("question" => $question, "description" => $description, "question_username" => $question_username, "timestamp" => $timestamp);
$id = $db->insert('polls', $data);
$db->where("timestamp", $timestamp);
$user = $db->getOne("polls");
$data = array("pid" => $user['pid']);
/* There are two types of question category : general or branch based
Store values according catogery in database */
if ($type == 'general') {
$db->insert('CSE', $data);
$db->insert('MECH', $data);
$db->insert('TCE', $data);
$db->insert('ECE', $data);
} else {
if ($type == 'CSE') {
$db->insert('CSE', $data);
} else {
if ($type == 'TCE') {
$db->insert('TCE', $data);
} else {
/** Returns the given database connector for a given database connector type */
public function getDatabaseConnectorOfType($type, $dbhost = null, $dbname = null, $dbuser = null, $dbpass = null, $dbport = null)
{
if (empty($dbhost) && defined('DB_HOST')) {
$dbhost = DB_HOST;
}
if (empty($dbname) && defined('DB_NAME')) {
$dbname = DB_NAME;
}
if (empty($dbuser) && defined('DB_USERNAME')) {
$dbuser = DB_USERNAME;
}
if (empty($dbpass) && defined('DB_PASSWORD')) {
$dbpass = DB_PASSWORD;
}
if (empty($dbport) && defined('DB_PORT')) {
$dbport = DB_PORT;
}
if ($type == CRM_DB_CONNECTOR_TYPE_MYSQL) {
// MySQL Database connector
require_once "db_connectors/MysqliDb.php";
try {
@($mysqldb = new \MysqliDb($dbhost, $dbuser, $dbpass, $dbname, $dbport));
if (empty($mysqldb)) {
throw new \Exception("Database access failed. Incorrect credentials or missing parameters.");
return null;
}
// try to set the timezone (for dates).
$mysqldb->where("setting", CRM_SETTING_TIMEZONE);
$mysqldb->where("context", CRM_SETTING_CONTEXT_CREAMY);
if ($result = $mysqldb->getOne(CRM_SETTINGS_TABLE_NAME)) {
$timezone = $result["value"];
if (isset($timezone)) {
date_default_timezone_set($timezone);
}
} else {
// fallback.
if (defined('CRM_TIMEZONE')) {
$timezone = CRM_TIMEZONE;
}
if (defined('CRM_LOCALE')) {
date_default_timezone_set($timezone);
}
}
// return MySQL database connector
return $mysqldb;
} catch (\Exception $e) {
throw new \Exception("Incorrect credentials. Access denied or incorrect parameters.");
return null;
}
} else {
throw new \Exception("Database connector {$type} not supported yet!");
}
}
define('DB_NAME', '');
}
require 'constants.php';
require 'DB.php';
$db = new MysqliDb(array('host' => DB_HOST, 'username' => DB_USER, 'password' => DB_PASSWORD, 'db' => DB_NAME, 'port' => 3306, 'prefix' => '', 'charset' => 'utf8'));
if (!isset($_SESSION['user']) && strpos($_SERVER['REQUEST_URI'], 'login.php') === FALSE) {
header('Location: ' . HTTP_PATH . 'user/login.php');
die;
} else {
if (strpos($_SERVER['REQUEST_URI'], 'logout.php') !== FALSE) {
unset($_SESSION);
header('Location: ' . HTTP_PATH . 'user/login.php');
die;
} else {
if (isset($_POST['username']) && $_POST['username'] != '') {
global $db;
$db->where("name", $_POST['username']);
$db->where("password", $_POST['password']);
$user = $db->getOne('users');
if ($user != '') {
unset($user['password']);
$_SESSION['user'] = $user;
header('Location: ' . HTTP_PATH . '/user/dashboard.php');
die;
} else {
$err = 'User not found!';
}
}
}
}
require 'functions.php';
// Page footer
public function Footer()
{
// Position at 15 mm from bottom
$this->SetY(-15);
// Set font
$this->SetFont('helvetica', 'I', 8);
// Page number
$this->Cell(60, 10, $this->date, 0, false, 'L', 0, '', 0, false, 'T', 'M');
$this->Cell(60, 10, 'V ' . $this->version, 0, false, 'C', 0, '', 0, false, 'T', 'M');
$this->Cell(60, 10, 'Page ' . $this->getAliasNumPage() . '/' . $this->getAliasNbPages(), 0, false, 'R', 0, '', 0, false, 'T', 'M');
}
}
$db = new MysqliDb();
$db->where('id', $_GET['id']);
$history = $db->getOne('history');
$pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->setVersion((string) $_GET['version'] . ".0");
$pdf->setDate($_GET['date']);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Ignitor Labs');
$pdf->setHeaderFont(false);
$pdf->setPrintHeader(false);
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
// $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);