function Expire()
{
//for link expiration
$delta = 10;
$token2 = $_GET["token"];
$connection = connect();
$tStamp = "select tStamp from accessToken where token='" . $token2 . "'";
$execute = $connection->query($tStamp);
$num = $execute->num_rows;
if ($num) {
$record = $execute->fetch_object();
//echo '<pre>';print_r($record);die;
$timeStam = $record->tStamp;
$timeStam = strtotime($timeStam);
if ($_SERVER['REQUEST_TIME'] - $timeStam > $delta) {
echo "link has expired";
}
//else {
//checkToken();
//setLinkStatus();
//echo "Please login";
//}
} else {
//no record found n database
}
}
function fetchAllorders()
{
$con = connect();
$result = mysqli_query($con, "SELECT * from orders");
disconnect($con);
return $result;
}
function get_published_posts()
{
$posts = connect()->prepare("SELECT * FROM posts JOIN users on posts.userid = users.id WHERE visible != 0 ORDER BY postid DESC");
$posts->execute();
$results = $posts->fetchAll();
return $results;
}
function give_key($user)
{
// global $numRecords, $dbConnection, $stmt;
$dbConnection = connect();
/*
Dictionary:
This function is returning an array of vkey, user_id, and user type
*/
$sqlCheck = "select vKey, user_ID, user_type from user where username = '******'";
//Run Query
try {
$stmt = $dbConnection->query($sqlCheck);
//Double check there's a value incase something goes wrong before returning key
if ($stmt->rowcount() != 0) {
return $stmt->fetch(PDO::FETCH_ASSOC);
// Debug by checking whats been returned print_r($sql_return); exit();
// return $sql_return;
// return array($sql_return['vKey'],$sql_return['user_ID'], $sql_return['user_type']);
} else {
if ($stmt === false) {
die("Error executing the query: (An error has occured) {$sqlCheck}");
}
}
} catch (PDOException $error) {
//Display error message if applicable
echo "An error occured: " . $error->getMessage();
}
}
function getAll()
{
$conn = connect();
$result = $conn->query("SELECT * FROM comments");
$conn->close();
return $result;
}
function init()
{
$link = connect(false);
if (mysqli_select_db($link, "synapp_db")) {
mysqli_close($link);
unset($link);
return INST_DB_EXISTS;
}
$sql = "CREATE DATABASE synapp_db";
if (!mysqli_query($link, $sql)) {
die("mysql CREATE DATABASE error.");
}
$sql = "ALTER DATABASE synapp_db CHARACTER SET utf8 COLLATE utf8_unicode_ci";
if (!mysqli_query($link, $sql)) {
die("mysql ALTER DATABASE synapp_db CHARACTER SET utf8 COLLATE utf8_unicode_ci error.");
}
if (!mysqli_select_db($link, "synapp_db")) {
die("mysqli_select_db() error.");
}
create_all_languages_table($link);
$sql = "CREATE TABLE IF NOT EXISTS users (user VARCHAR(32) UNIQUE KEY,pass VARCHAR(64),recovery VARCHAR(64)," . "firstdate INT,hfirstdate BIT DEFAULT 0,missed_logins INT DEFAULT 0,last_login INT,hlast_login BIT DEFAULT 0,ip INT UNSIGNED,last_update INT," . "interface_language VARCHAR(4),hinterface_language BIT DEFAULT '0',working_group VARCHAR(32),hworking_group BIT DEFAULT 0,input_language VARCHAR(4),hinput_language BIT DEFAULT 0,hprofile BIT DEFAULT 0," . "gender VARCHAR(1) DEFAULT NULL, hgender BIT DEFAULT 0,birthday DATE, hbirthday BIT DEFAULT 0,studies VARCHAR(256), hstudies BIT DEFAULT 0,studies_type VARCHAR(64), hstudies_type BIT DEFAULT 0,studies_level INT, hstudies_level BIT DEFAULT 0, occupation VARCHAR(256),hoccupation BIT DEFAULT 0," . "email VARCHAR(128),hemail BIT DEFAULT 0,email_confirmation_code VARCHAR(64),confirmed_email BIT DEFAULT 0,avatar VARCHAR(128),hstats BIT DEFAULT 0, ditloid_lock_timestamp INT DEFAULT NULL, ditloid_time_left_when_locked INT DEFAULT 0, gotestbefore INT DEFAULT 0," . "gotestafter INT DEFAULT 0, timer_ctestb_start INT DEFAULT 0, timer_ctestb_end INT DEFAULT 0, timer_utestb_start INT DEFAULT 0, timer_utestb_end INT DEFAULT 0, timer_utesta_start INT DEFAULT 0, timer_utesta_end INT DEFAULT 0, timer_ctesta_start INT DEFAULT 0, timer_ctesta_end INT DEFAULT 0, fbid VARCHAR(255) DEFAULT NULL)";
if (!mysqli_query($link, $sql)) {
die('Error: ' . var_export($link->errorInfo(), true));
}
$sql = "CREATE TABLE `interface_languages` (native_name VARCHAR(32), iso6392_code VARCHAR(4) UNIQUE KEY, users INT DEFAULT 0)";
if (mysqli_query($link, $sql)) {
$sql = "INSERT INTO interface_languages VALUES (\"español\", \"spa\", \"0\")";
mysqli_query($link, $sql);
$sql = "INSERT INTO interface_languages VALUES (\"english\", \"eng\", \"0\")";
mysqli_query($link, $sql);
$sql = "INSERT INTO interface_languages VALUES (\"galego\", \"glg\", \"0\")";
mysqli_query($link, $sql);
$sql = "INSERT INTO interface_languages VALUES (\"polski\", \"pol\", \"0\")";
mysqli_query($link, $sql);
}
$sql = "CREATE TABLE `groups` (name VARCHAR(32), users INT DEFAULT 0)";
if (mysqli_query($link, $sql)) {
$sql = "INSERT INTO groups VALUES (\"DEFAULT_GROUP_A\", \"0\")";
mysqli_query($link, $sql);
$sql = "INSERT INTO groups VALUES (\"DEFAULT_GROUP_B\", \"0\")";
mysqli_query($link, $sql);
}
$sql = "CREATE TABLE IF NOT EXISTS `images` (id VARCHAR(69) UNIQUE KEY, name VARCHAR(32), associated_group VARCHAR(32), uploader VARCHAR(32), KEY(associated_group))";
if (!mysqli_query($link, $sql)) {
die('Error: ' . var_export($link->errorInfo(), true));
}
$sql = "CREATE TABLE IF NOT EXISTS `stats` (user VARCHAR(32),lang VARCHAR(4), day DATE,type INT," . "assigned_group VARCHAR(32), upvotes INT DEFAULT 0, downvotes INT DEFAULT 0, neutralvotes INT DEFAULT 0, popupvotes INT DEFAULT 0, popdownvotes INT DEFAULT 0, popneutralvotes INT DEFAULT 0, count INT DEFAULT 0, UNIQUE INDEX `user_lang_day_type_assigned_group` (`user`, `lang`, `day`, `type`, `assigned_group`))";
if (!mysqli_query($link, $sql)) {
die('Error: ' . var_export($link->errorInfo(), true));
}
$sql = "CREATE TABLE IF NOT EXISTS `test_ranks` (user VARCHAR(32), ttype VARCHAR(32),evals INT,orgfullvotes INT, orghalfvotes INT, orgzerovotes INT, cohfullvotes INT, cohhalfvotes INT, cohzerovotes INT, UNIQUE INDEX uti (user,ttype))";
if (!mysqli_query($link, $sql)) {
die('Error: ' . var_export($link->errorInfo(), true));
}
$sql = "CREATE TABLE IF NOT EXISTS `confirmed_emails` (user VARCHAR(32),email VARCHAR(128) UNIQUE KEY, KEY(user))";
if (!mysqli_query($link, $sql)) {
die('Error: ' . var_export($link->errorInfo(), true));
}
return INST_OK;
}
function load_canned_messages($locale, $groupid)
{
global $mysqlprefix;
$link = connect();
$query = "select id, vcvalue from {$mysqlprefix}chatresponses " . "where locale = '" . $locale . "' AND (" . ($groupid ? "groupid = {$groupid}" : "groupid is NULL OR groupid = 0") . ") order by vcvalue";
$result = select_multi_assoc($query, $link);
if (!$groupid && count($result) == 0) {
foreach (explode("\n", getstring_('chat.predefined_answers', $locale)) as $answer) {
$result[] = array('id' => '', 'vcvalue' => $answer);
}
if (count($result) > 0) {
$updatequery = "insert into {$mysqlprefix}chatresponses (vcvalue,locale,groupid) values ";
for ($i = 0; $i < count($result); $i++) {
if ($i > 0) {
$updatequery .= ", ";
}
$updatequery .= "('" . mysql_real_escape_string($result[$i]['vcvalue'], $link) . "','{$locale}', NULL)";
}
perform_query($updatequery, $link);
$result = select_multi_assoc($query, $link);
}
}
mysql_close($link);
return $result;
}
function executeQuery($query)
{
$pdo = connect();
$ret = $pdo->query($query);
$pdo = close($pdo);
return $ret;
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$dsn = $input->getArgument('dsn');
$db = connect($dsn);
$config = ConfigBuilder::createConfigurationFromConsecutiveFiles($input->getArgument('config'));
$this->dump($config, $db, $output);
}
function scan_connections()
{
$unix = new unix();
$pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time";
$pid = $unix->get_pid_from_file($pidfile);
if ($unix->process_exists($pid, basename(__FILE__))) {
$time = $unix->PROCCESS_TIME_MIN($pid);
if ($GLOBALS["OUTPUT"]) {
echo "Artica Task Already running PID {$pid} since {$time}mn\n";
}
return;
}
@file_put_contents($pidfile, getmypid());
if (system_is_overloaded()) {
system_admin_events("Overloaded system, aborting task", __FUNCTION__, __FILE__, __LINE__);
return false;
}
$q = new mysql();
$sql = "SELECT * FROM texttoldap";
$results = $q->QUERY_SQL($sql, "artica_backup");
if (mysql_num_rows($results) == 0) {
return;
}
while ($ligne = mysql_fetch_assoc($results)) {
if (!connect($ligne)) {
continue;
}
import($ligne);
$ID = $ligne["ID"];
}
}
function main()
{
$data = ensure_privileged_api_data_and_token();
$test_group_id = array_get($data, 'group');
if (!$test_group_id) {
exit_with_error('TestGroupNotSpecified');
}
$values = array();
if (array_key_exists('name', $data)) {
$values['name'] = $data['name'];
}
if (array_key_exists('hidden', $data)) {
$values['hidden'] = Database::to_database_boolean($data['hidden']);
}
if (!$values) {
exit_with_error('NothingToUpdate');
}
$db = connect();
$db->begin_transaction();
if (!$db->update_row('analysis_test_groups', 'testgroup', array('id' => $test_group_id), $values)) {
$db->rollback_transaction();
exit_with_error('FailedToUpdateTestGroup', array('id' => $test_group_id, 'values' => $values));
}
if (array_get($data, 'hidden')) {
$db->query_and_get_affected_rows('UPDATE build_requests SET request_status = $1
WHERE request_group = $2 AND request_status = $3', array('canceled', $test_group_id, 'pending'));
}
$db->commit_transaction();
exit_with_success();
}
function block_temporary($ipUser)
{
$config_file_parsed = $GLOBALS['v'];
include_once 'database.php';
$connection = connect($config_file_parsed["database"]["host"], $config_file_parsed["database"]["user"], $config_file_parsed["database"]["pass"], $config_file_parsed["database"]["database"]);
if ($stmt = mysqli_prepare($connection, "SELECT attempt FROM blocked_ip WHERE ip=?")) {
$k = 0;
$stmt->bind_param("s", $ipUser);
$stmt->execute();
$stmt->bind_result($col1);
echo 'salam: ' . $col1;
while ($stmt->fetch()) {
$k++;
// printf("%i %i", $col1,$k);
}
echo $col1;
$sql = '';
if ($col1 == 0) {
$temp = "'" . $ipUser . "'";
$sql = "INSERT INTO `blocked_ip` VALUES (NULL,{$temp},NOW(),NOW(),1)";
}
if ($col1 == 1) {
$sql = "UPDATE `blocked_ip` SET `start_date`=NOW(),`end_date`=NOW() + INTERVAL 1 HOUR,`attempt`=2 WHERE ip=" . "'" . $ipUser . "'";
}
if ($col1 == 2) {
$sql = "UPDATE `blocked_ip` SET `start_date`=NOW(),`end_date`=NOW() + INTERVAL 1000 HOUR,`attempt`=3 WHERE ip=" . "'" . $ipUser . "'";
}
echo $sql;
if ($col1 >= 0 && $col1 < 3) {
mysqli_query($connection, $sql);
//echo "<h1>afectate:</h1>".mysqli_affected_rows($connection);
}
$stmt->close();
}
}
/**
* Connect the user if he's connected on twitter and if his mail adress is in the DB
* @param $email string contains the user's mail adress
* @param $picture string contains the picture path
*/
function addDataTwitter($email, $picture)
{
$co = connect();
$data = $co->query("SELECT * FROM Student WHERE student_instituteemail = '{$email}' OR student_personalemail = '{$email}'");
$res = $data->fetch();
if (count($res) != 0) {
$accountModel = new AccountModel();
$_SESSION['infoStudent'] = $res;
$_SESSION['infoStudent']['student_avatar'] = $picture;
$id = $res['user_id'];
$idstu = $res['student_id'];
$pourlasess = $co->query("SELECT * FROM User WHERE user_id = {$id}");
$lesdonnees = $pourlasess->fetch();
$_SESSION['infoUser'] = $lesdonnees;
$_SESSION['image'] = $picture;
$trainingResult = $accountModel->getTrainingInformationsForUser('description', $_SESSION['infoUser']['user_id']);
$_SESSION['infoTraining'] = $trainingResult;
//$co->query("UPDATE Student SET `student_avatar` = '$picture' WHERE `student_id` = $idstu");
//print_r($co->errorInfo());
//header('Location: index.php');
echo '<script>document.location.href="index.php"</script>';
} else {
session_unset();
header('Location: index.php?incrip=true');
}
}
function construire_tableau($theme = 0, $pertinence = 0, $diff = 0, $nbQuestions)
{
$connexion = connect($host, $port, $user, $password, $database);
//On récupère un recordset correspondant aux critères
$query = "SELECT Q.noq, Q.question, Q.reponse " . "FROM questions Q";
/* ", sujets S, themes T, pertinences P, difficultes D ".
"WHERE Q.noq = S.noq AND S.theme = T.theme AND ".
"S.pertinence = P.pertinence AND S.difficulte = D.difficulte".
"AND S.theme = ". $theme ." AND S.pertinence = ". $pertinence ." AND S.difficulte = ". $diff .";";
*/
$result = exec_query($connexion, $query);
$Nbr = numrows($result);
echo "Nombre d'enregistrements : " . $Nbr . "<BR>";
//Organisation aléatoire des questions
$ints = range(0, $Nbr - 1);
srand(time());
shuffle($ints);
if ($Nbr < $nbQuestions) {
$nbQuestions = $Nbr;
}
// On construit le tableau permettant de trier aléatoirement
for ($i = 0; $i < $nbQuestions && ($row = fetch_array($result, $ints[$i])); $i++) {
echo "libelle Q : " . $row[1] . "<BR>";
$tabQ[$i][0] = $row[0];
// recuperation du numero,
$tabQ[$i][1] = $row[1];
// du libelle,
$tabQ[$i][2] = $row[2];
// de la reponse a la question
}
close($connexion);
return $tabQ;
}
function select($tabela, $coluna, $where, $ordem, $limite)
{
//SQL da consulta
$sql = "SELECT {$coluna} FROM {$tabela} {$where} {$ordem} {$limite}";
//Conectou?
if ($conexao = connect()) {
//conseguiu consultar
if ($query = mysql_query($sql, $conexao)) {
//encountrou alguma coisa?
if (mysql_num_rows($query) > 0) {
$resultados_totais = array();
while ($resultado = mysql_fetch_assoc($query)) {
$resultados_totais[] = $resultado;
}
//fechar conexão
FecharConexao($conexao);
return $resultados_totais;
}
} else {
return false;
}
} else {
return false;
}
}
function create_db_table($search_name)
{
$link = connect();
$sql = "CREATE TABLE {$search_name} (\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\n GsearchResultClass VARCHAR(100) NOT NULL,\n unescapedUrl VARCHAR(100) NOT NULL,\n url VARCHAR(100) NOT NULL,\n visibleUrl VARCHAR(100) NOT NULL,\n cacheUrl VARCHAR(100) NOT NULL,\n title VARCHAR(100) NOT NULL,\n titleNoFormatting VARCHAR(100) NOT NULL,\n content VARCHAR(1000) NOT NULL,\n query VARCHAR(50) NOT NULL,\n reg_date TIMESTAMP)";
echo $sql;
return mysqli_query($link, $sql);
}
/**
* @param string $code
* @param string $user
* @param string $pass
*/
function change_password($code, $user, $pass)
{
$use_password_verify = defined('SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION') && (SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION === true || is_string(SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION) && (trim(strtolower(SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION)) === 'on' || trim(strtolower(SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION)) === 'true' || trim(strtolower(SYNAPP_USE_PASSWORD_HASH_AUTHENTICATION)) === '1')) ? true : false;
$link = connect();
$sql = "SELECT recovery FROM users WHERE user = :user";
$stmt = $link->prepare($sql);
$stmt->bindValue(':user', $user, PDO::PARAM_STR);
$stmt->execute();
if ($ua = $stmt->fetch(PDO::FETCH_ASSOC)) {
if ($use_password_verify && !password_verify($code, $ua['recovery']) || !$use_password_verify && !(hash("sha256", $code) === $ua['recovery'])) {
$link = null;
die("Error: Invalid request code (2).");
}
} else {
$link = null;
die("Error: User not found (2).");
}
$prng = new synapp\info\tools\passwordgenerator\cryptosecureprng\CryptoSecurePRNG();
$recovery = $use_password_verify ? password_hash($prng->rand(), SYNAPP_PASSWORD_DEFAULT) : hash("sha256", $prng->rand());
if ($use_password_verify) {
$hashedPassword = password_hash($pass, SYNAPP_PASSWORD_DEFAULT);
} else {
$hashedPassword = hash("sha256", $pass . NORAINBOW_SALT);
}
$sql = "UPDATE users SET pass = :hashedPassword, recovery = :recovery WHERE user = :user";
$stmt = $link->prepare($sql);
$stmt->bindValue(':hashedPassword', $hashedPassword, PDO::PARAM_STR);
$stmt->bindValue(':recovery', $recovery, PDO::PARAM_STR);
$stmt->bindValue(':user', $user, PDO::PARAM_STR);
if ($stmt->execute() === false) {
die("Error: " . var_export($link->errorInfo(), true));
}
$link = null;
echo "<!DOCTYPE html><html><head><meta charset=\"utf-8\"><title>" . PR_TITLE_3 . " " . $user . "</title></head><body>\n <p>" . PR_DONE_1 . " " . $user . " " . PR_DONE_2 . "</p>\n <p><a href='../index.php'>" . PR_HOME . "</a></p>\n </body></html>";
}
function SaveJsonData($category, $start, $end, $file_Path)
{
$rows = array();
$query2 = " select pro_id ,title ,img_url ,detail_url ,shop_name ,price ,month_sold ,comm_percent ,seller_ww ,back_BB ,";
$query2 .= " short_tbk_url ,tbk_url ,commission ,earn ,img_list ,show_order ,P.cat_id ,entrydate ,disabled ";
$query2 .= " from BS_ProInfo AS P";
$query2 .= " join BS_Category as C on P.cat_id=C.cat_id";
$query2 .= " where P.disabled=0 and C.category ='{$category}'";
$query2 .= " limit {$start}, {$end}";
// echo $query2;
// exit();
$result2 = mysqli_query(connect(), $query2);
while (@($row = mysqli_fetch_assoc($result2))) {
$rows[] = $row;
}
//random order
shuffle($rows);
// echo $filename;
// echo $query2;
// echo "<br>";
if (!file_exists($file_Path)) {
// 文件所在目录
// echo dirname($json_path);
// mkdir($json_path, 0777);
FileUtil::createFile($file_Path);
}
// 修改文件权限为读写可执行
// Read 4 - 允许读文件
// Write 2 - 允许写/修改文件
// eXecute1 - 读/写/删除/修改/目录
chmod($file_Path, 0777);
file_put_contents($file_Path, json_encode($rows));
}
function get_reviews($img_name)
{
$conn = connect();
$query = mysql_query("SELECT time_seen FROM images WHERE name LIKE '" . $img_name . "'", $conn);
$data = mysql_fetch_assoc($query);
return $data['time_seen'];
}
function vote($id)
{
$link = connect();
$query = "UPDATE quotes SET score = score +1 WHERE id={$id}";
query($query);
close($link);
}
/**
* Func : finish delete operation
*@param string $table
*@param string $where
*@return number
* Syntax : DELETE FROM table_name WHERE some_column=some_value;
*/
function delete($table, $where = null)
{
$conn = connect();
$where = $where == null ? null : "where " . $where;
$sql = "delete from ({$table}) {$where}";
return $conn->exec($sql);
}
function dbAddProduct($post)
{
$connection = connect();
session_start();
echo $query = "insert into product set productName='" . $post['productName'] . "', productPrice='" . $post['productPrice'] . "',productDescription='" . $post['productDescription'] . "',productImage='" . basename($_FILES['fileToUpload']['name']) . "',userEmail='" . $_SESSION['login'] . "'";
$execute = $connection->query($query);
}
function main()
{
$data = ensure_privileged_api_data_and_token();
$analysis_task_id = array_get($data, 'task');
$bug_tracker_id = array_get($data, 'bugTracker');
$bug_number = array_get($data, 'number');
$bug_id = array_get($data, 'bugToDelete');
$db = connect();
$db->begin_transaction();
if ($bug_id) {
require_format('BugToDelete', $bug_id, '/^\\d+$/');
$count = $db->query_and_get_affected_rows("DELETE FROM bugs WHERE bug_id = \$1", array($bug_id));
if ($count != 1) {
$db->rollback_transaction();
exit_with_error('UnexpectedNumberOfAffectedRows', array('affectedRows' => $count));
}
} else {
require_format('AnalysisTask', $analysis_task_id, '/^\\d+$/');
require_format('BugTracker', $bug_tracker_id, '/^\\d+$/');
require_format('BugNumber', $bug_number, '/^\\d+$/');
$bug_id = $db->insert_row('bugs', 'bug', array('task' => $analysis_task_id, 'tracker' => $bug_tracker_id, 'number' => $bug_number));
}
$db->commit_transaction();
exit_with_success(array('bugId' => $bug_id));
}
function download_file($file_id, $dir)
{
$db = connect();
$stmt = $db->prepare('SELECT * FROM `papers` WHERE `id` = ?');
$stmt->bind_param('s', $_GET['file']);
$stmt->execute();
$res = $stmt->get_result();
if ($res->num_rows == 1) {
$result_row = $res->fetch_array();
$filename = $result_row['file_name'];
$file = $_SERVER['DOCUMENT_ROOT'] . $dir . 'images/' . $filename;
$len = @filesize($file);
if ($len == false) {
$err = "<script type='text/javascript'>\n alert('The file doesnt exist');\n </script>";
echo $err;
die;
}
$file_name_ext = explode('.', $filename);
$file_ext = strtolower(end($file_name_ext));
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-Type: " . ctype($file_ext));
$header = "Content-Disposition: attachment; filename=" . $filename . ";";
header($header);
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . $len);
@readfile($file);
exit;
}
}
function get_papers()
{
$conn = connect();
$query_string = "SELECT * FROM `papers`";
$query = mysqli_query($conn, $query_string);
return $query;
}
function fetchWithQuery($query)
{
$con = connect();
$result = mysqli_query($con, $query);
disconnect($con);
return $result;
}
/**
* Make a sql query to the database.
*
* @param string $sql
* @return integer
*/
function query($sql)
{
$connection = connect();
$res = mysqli_query($connection, $sql);
mysqli_close($connection);
return $res;
}
function add_message($locale, $groupid, $message)
{
global $mysqlprefix;
$link = connect();
perform_query("insert into {$mysqlprefix}chatresponses (locale,groupid,vcvalue) values ('" . mysql_real_escape_string($locale, $link) . "'," . ($groupid ? intval($groupid) . ", " : "null, ") . "'" . mysql_real_escape_string($message, $link) . "')", $link);
mysql_close($link);
}
function inserir($coluna, $valor, $tabela)
{
//Perguntar se os dado recebidos são arrays
if (is_array($coluna) and is_array($valor)) {
//Verificar o numero de elementos
if (count($coluna) == count($valor)) {
//Montar sql
$inserir = "INSERT INTO {$tabela}(" . implode(', ', $coluna) . ")\n VALUES('" . implode('\', \'', $valor) . "')";
} else {
return false;
}
} else {
//
//Montar sql
$inserir = "INSERT INTO {$tabela} ({$coluna}) values ('{$valor}')";
}
//Conectou?
if ($conexao = connect()) {
//Inseriu?
if (mysql_query($inserir, $conexao)) {
//Fechar conexao
fecharConexao($conexao);
return TRUE;
} else {
echo "Query invalida!";
return false;
}
} else {
return FALSE;
}
}
public function testConnect()
{
$conn = self::$connection;
$this->assertInstanceOf('TrackMePDO', connect($conn));
$this->expectException('PDOException');
$conn["user"] = "******";
connect($conn);
}
