function createMainDataElement($plan, $num, $dbConn)
{
if ($plan['dato_principal_' . $num] != NULL) {
$query_dato = sprintf("SELECT * FROM tipoDatosServicios WHERE id_tipoDato=%s", GetSQLValueString($plan['id_tipoDato_principal_' . $num], "int"));
$dato = mysql_query($query_dato, $dbConn) or die(mysql_error());
$row_dato = mysql_fetch_assoc($dato);
$display = true;
$label = "";
if ($row_dato['tipo'] == "boolean") {
if ($plan['dato_principal_' . $num] == "1") {
$label = $row_dato['label'];
} else {
$display = false;
}
} else {
if ($row_dato['display_label']) {
$label = $plan['dato_principal_' . $num] . " " . $row_dato['label'];
} else {
$label = $plan['dato_principal_' . $num];
}
}
if ($display) {
echo "<div class='dato'>";
echo "\t<li class='tipo_" . $plan['id_tipoDato_principal_' . $num] . "' value='" . $plan['dato_principal_' . $num] . "'>";
echo $label;
echo "\t</li>";
echo "</div>";
}
}
//if
}
function SSL_COMPRA_FACTURA($transaccion, $salida = 'enlinea')
{
$c = sprintf('SELECT procon.`codigo_producto`, procon.`titulo` AS "titulo_contenedor", provar.`descripcion` AS "titulo_variedad", provar.foto, comcon.`codigo_compra`, comcon.`codigo_usuario`, comcon.`codigo_variedad`, FORMAT(comcon.`precio_grabado`,2) AS precio_grabado, FORMAT(comcon.`precio_envio`,2) AS precio_envio, comcon.`direccion_entrega`, comcon.`fecha_entrega`, comcon.`tarjeta_de`, comcon.`tarjeta_para`, comcon.`tarjeta_cuerpo`, comcon.`usuario_notas`, comcon.`transaccion`, comcon.`fecha`, `estado`, `correo_contacto`, `telefono_remitente`, `usuario_notas`, `nombre_t_credito`,`estado_notas` FROM `flores_SSL_compra_contenedor` AS comcon LEFT JOIN `flores_producto_variedad` AS provar USING(codigo_variedad) LEFT JOIN `flores_producto_contenedor` AS procon USING(codigo_producto) WHERE transaccion="%s"', db_codex($transaccion));
$r = db_consultar($c);
if (!mysql_num_rows($r)) {
echo '<p>Lo sentimos, tal factura no existe</p>';
return;
}
$f = mysql_fetch_assoc($r);
$buffer = '<style>';
$buffer .= 'table {border-collapse:collapse;}';
$buffer .= 'table th{border-top:thin solid #c0c0c0;border-left:thin solid #c0c0c0;border-right:thin solid #c0c0c0;background-color:#eee;}';
$buffer .= 'table td{border-top:thin solid #c0c0c0;border:1px solid #c0c0c0;}';
$buffer .= '</style>';
$buffer .= '<table style="width:100%">';
$campo = array('Factura' => $f['transaccion'], 'F360' => $f['codigo_producto'] . ':' . $f['codigo_variedad'], 'Producto' => $f['titulo_contenedor'], 'Variedad' => $f['titulo_variedad'], 'Precio' => '$' . $f['precio_grabado'], 'Recargo de envio' => '$' . $f['precio_envio'], 'Total' => '$' . number_format($f['precio_grabado'] + $f['precio_envio'], 2, '.', ','), 'Remitente' => $f['tarjeta_de'], 'Destinatario' => $f['tarjeta_para'], 'Tarjeta' => $f['tarjeta_cuerpo'], 'Enviar a' => $f['direccion_entrega'], 'Fecha pedido' => date('d/m/Y'), 'Fecha de entrega' => date('d/m/Y', strtotime($f['fecha_entrega'])), 'Correo contacto' => $f['correo_contacto'], 'Teléfono remitente' => $f['telefono_remitente'], 'Notas adicionales del comprador' => $f['usuario_notas'] ? $f['usuario_notas'] : '[No especificó nada en especial]');
foreach ($campo as $clave => $valor) {
$buffer .= sprintf('<tr><td>%s</td><td style="font-weight:bold">%s</td></tr>', $clave, $valor);
}
$buffer .= '</table>';
switch ($salida) {
case 'enlinea':
return array($buffer, $f);
break;
case 'pdf':
$buffer = '<html><body>' . $buffer . '</body></html>';
require_once 'PHP/dompdf/dompdf_config.inc.php';
$dompdf = new DOMPDF();
$dompdf->load_html($buffer);
//$dompdf->render();
//$dompdf->stream("factura-$transaccion.pdf");
}
}
public function idanggota_to_username($uid)
{
$sql = "SELECT * FROM tbpengguna WHERE id ='{$uid}'";
$data = mysql_query($sql);
$parseuser = mysql_fetch_assoc($data);
return $parseuser;
}
function larz_printrow($id)
{
$sql = "SELECT * FROM `procedure` WHERE `id` = {$id}";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
larz_printtypes($row);
}
public function fetch_all($result)
{
while ($fetch = mysql_fetch_assoc($result)) {
$rows[] = $fetch;
}
return $rows;
}
public function getProveedor($index)
{
$sql = "SELECT pro_id FROM proveedores WHERE pro_rfc = '" . $this->partidas[$index]["row_rfc" . $index] . "'";
$res = $this->conexion->consultar($sql);
$row = mysql_fetch_assoc($res);
$this->partidas[$index]["row_proveedor" . $index] = $row["pro_id"];
}
public function validate()
{/*{{{*/
$msg = '';
foreach ($this->dbreads as $dbread){
$link = mysql_connect($dbread['host'], $this->account['user'], $this->account['pass']);
$res = mysql_query('show slave status', $link);
$row = mysql_fetch_assoc($res);
if (empty($row)) {
$msg .= $dbread['host'].' can\'t be connected;';
} else if ($this->max < $row['Seconds_Behind_Master']) {
error_log("\n".date('Y-m-d H:i:s').":\n".print_r($row, true), 3, '/tmp/db.log');
$msg .= $dbread['host'].' delay '.$row['Seconds_Behind_Master'].';';
} else if ('' != $row['Last_Error']) {
$msg .= $dbread['host'].' has error!';
} else if ('Yes' != $row['Slave_IO_Running'] || 'Yes' != $row['Slave_SQL_Running']) {
$msg .= $dbread['host'].' has repl error!';
} else if ('' != $row['Last_IO_Error']) {
$msg .= $dbread['host'].' has io error!';
} else if ('' != $row['Last_SQL_Error']) {
$msg .= $dbread['host'].' has sql error!';
}
mysql_close($link);
}
return $msg;
}/*}}}*/
public function getLoveHistory($page, $justUser = false)
{
$front = Frontend::getInstance();
$page--;
$l = $this->getLimit() * $page;
$where = '';
$sql = "SELECT count(*) " . "FROM " . LOVE_LOVE;
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
$loves = $row[0];
$sql = "SELECT count(*) " . "FROM " . LOVE_LOVE . " " . "WHERE " . LOVE_LOVE . ".receiver = '" . $front->getUser()->getUsername() . "' " . "OR " . LOVE_LOVE . ".giver = '" . $front->getUser()->getUsername() . "' " . ($sql .= $justUser ? '' : "OR " . LOVE_LOVE . ".company_id = '" . $front->getUser()->getCompany_id() . "' ");
$sql .= $where . " " . "ORDER BY id DESC";
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
$count = $row[0];
$cPages = ceil($count / $this->getLimit());
$sql = "SELECT id,giver,receiver,why,private,TIMESTAMPDIFF(SECOND,at,NOW()) as delta " . "FROM " . LOVE_LOVE . " " . "WHERE " . LOVE_LOVE . ".receiver = '" . $front->getUser()->getUsername() . "' " . "OR " . LOVE_LOVE . ".giver = '" . $front->getUser()->getUsername() . "' ";
$sql .= $justUser ? '' : "OR " . LOVE_LOVE . ".company_id = '" . $front->getUser()->getCompany_id() . "' ";
$sql .= $where . " " . "ORDER BY id DESC " . "LIMIT " . $l . "," . $this->getLimit();
$res = mysql_query($sql);
// Construct json for history
$this->pages = array(array($page, $cPages, number_format($loves)));
for ($i = 1; $row = mysql_fetch_assoc($res); $i++) {
$givernickname = getNickName($row['giver']);
$givernickname = !empty($givernickname) ? $givernickname : $row['giver'];
$receivernickname = getNickName($row['receiver']);
$receivernickname = !empty($receivernickname) ? $receivernickname : $row['receiver'];
$why = $row['why'];
if ($row['private']) {
$why .= " (love sent quietly)";
}
$history[] = array("id" => $row['id'], "giver" => $row['giver'], "giverNickname" => $givernickname, "receiver" => $row['receiver'], "receiverNickname" => $receivernickname, "why" => $why, "delta" => Utils::relativeTime($row['delta']));
}
return $history;
}
public function saveRatinglist()
{
foreach ($this->ratings as $player) {
//Controleren of speler al bestaat + ophalen id
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $player["knsb"];
$query = mysql_query($sql);
if (mysql_num_rows($query) == 1) {
$data = mysql_fetch_assoc($query);
$player["id"] = $data["id"];
} elseif (mysql_num_rows($query) == 0) {
//Toevoegen van de speler
print_r($player);
}
//Controleren of de rating al bestaat
$sql = "SELECT * FROM svn_rating WHERE id = " . $player["id"] . " AND datum = '" . $this->ratingList . "'";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 0) {
//Toevoegen rating
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $this->ratingList . "\"," . $player["id"] . ",1," . $player["rating"] . ")";
mysql_query($sql);
}
}
$sql = "SELECT * FROM svn_leden WHERE knsb = " . $speler_geg["id"];
$result = mysql_query($sql);
$speler_dat = mysql_fetch_array($result);
if ($speler_geg["rating"] != "") {
$sql = "INSERT INTO svn_rating VALUES ('',\"" . $datum . "\"," . $speler_dat[0] . ",1," . $speler_geg["rating"] . ")";
//echo $sql;
mysql_query($sql);
}
}
public static function authentication()
{
// print_r($_SERVER);
// exit();
if (!isset($_SERVER['PHP_AUTH_USER'])) {
header('WWW-Authenticate: Basic realm="My Realm"');
header('HTTP/1.0 401 Unauthorized');
echo 'Text to send if user hits Cancel button';
exit;
} else {
$db = new DB();
$username = mysql_real_escape_string($_SERVER['PHP_AUTH_USER']);
$password = mysql_real_escape_string($_SERVER['PHP_AUTH_PW']);
$domain = 'nebula.com';
$hash = md5($username . ':' . $domain . ':' . $password);
$sql = "SELECT id from n_nebulauser WHERE username='******' AND ha1='{$hash}'";
$q = $db->query($sql);
if (mysql_num_rows($q)) {
$fetch = mysql_fetch_assoc($q);
return $fetch['id'];
} else {
return null;
}
}
return false;
}
function w_osatnie_lekcje($id_usera, $ilosc = 3)
{
// wyświetlenie nagłówka
echo '<div class="thumbnail">' . '<div class="caption">' . '<h4>Ostatnio dodane lekcje</h4><br>' . '<table class="table">' . '<tbody>';
// wyświetlenie małej tabelki z ostatnimi (ostatnio dodanymi) lekcjami dla danego użytkownika
// pierwsza pętla podaje tylko te kursy, do których jest zapisany użytkownik.
$wynik = mysql_query("SELECT * FROM `zapisy` WHERE id_uzytkownika={$id_usera} ORDER BY id_zapisu DESC LIMIT {$ilosc}");
while ($r = mysql_fetch_assoc($wynik)) {
// druga pętla wyświetla po dwie ostatnie lekcje z każdego kursu
$nazwa_lekcji = mysql_query("SELECT * FROM `lekcje` WHERE id_kursu={$r['id_kursu']} ORDER BY id_lekcji DESC LIMIT 2");
while ($g = mysql_fetch_assoc($nazwa_lekcji)) {
// trzecia pętla sprawdza, jak nazywa się dany kurs
$nazwa_kursu = mysql_query("SELECT * FROM `kursy` WHERE id_kursu={$r['id_kursu']}");
while ($gg = mysql_fetch_assoc($nazwa_kursu)) {
$kursik = $gg['nazwa'];
}
$link = "?v=tresc/u_kursy/dana_lekcja&id={$g['id_lekcji']}&id_kursu={$g['id_kursu']}";
echo '<tr>';
// wyświetlenie wiersza w tabelce z linkiem do lekcji
echo "<td><a href='{$link}'>{$g['temat']}</a> <br><small><b>{$kursik}</b>, <i>{$r['data_zapisu']}</i></small><td>";
echo '</tr>';
}
}
// jeżeli to nauczyciel lub admin, nie wyświetlamy ich kursów, tylko komunikat
if (nauczyciel() || admin()) {
komunikat("Aby zobaczyć lekcje, przejdź do zarządzania");
}
// zakończenie tabeli i ramki
echo '</tbody>' . '</table>' . '</div>' . '</div>';
}
function __construct()
{
$variables = new Variables();
$connect = new Connect($variables->dbHost, $variables->dbUser, $variables->dbPassword, $variables->dbName);
$result;
//receinving and striping the variables
$this->userMatricula = $connect->antiInjection(isset($_POST["tfMatricula"]) ? $_POST["tfMatricula"] : NULL);
$this->password = $connect->antiInjection(isset($_POST["tfPassword"]) ? $_POST["tfPassword"] : NULL);
$this->select = $connect->antiInjection(isset($_POST["slSelect"]) ? $_POST["slSelect"] : NULL);
if (!$connect->start()) {
echo "Impossible to start connection in Sigin.";
}
//encoding to md5 hash
$this->password = base64_encode($this->password);
if (!($result = $connect->execute("SELECT * FROM Cadastros c INNER JOIN Folhas f ON c.codigo_fol = f.codigo_fol WHERE c.matricula = '{$this->userMatricula}' AND c.senha = '{$this->password}' AND f.codigo_fol = '{$this->select}'"))) {
echo "Impossible to execute MySQL query.";
}
if ($connect->counterResult($result) > 0) {
$result = $connect->execute("SELECT * FROM Pessoal WHERE matricula = '{$this->userMatricula}'");
$row = mysql_fetch_assoc($result);
$_SESSION["user"] = $this->userMatricula;
$_SESSION["userPass"] = $this->password;
$_SESSION["nome"] = $row["nome"];
$connect->close();
header("Location: ../index.php?ok=true");
die;
}
$connect->close();
header("Location: ../index.php?ok=false");
die;
}
/**
* @inheritdoc
*/
public function get(VariableWrapper $data)
{
if (!$this->supports($data)) {
throw new \Ladybug\Exception\InvalidInspectorClassException();
}
$headers = array();
$rows = array();
$first = true;
while ($row = mysql_fetch_assoc($data->getData())) {
$rowData = array();
foreach ($row as $k => $v) {
if ($first) {
$headers[] = $k;
}
$rowData[] = $v;
}
$rows[] = $rowData;
$first = false;
}
/** @var $table TableType */
$table = $this->extendedTypeFactory->factory('table', $this->level);
$table->setHeaders($headers);
$table->setRows($rows);
$table->setTitle('MySQL resultset');
return $table;
}
function getUserTreeHTML($id)
{
$sql = 'select `id` , `username` , `active` from `users` where id<>1 order by id;';
$rs = mysql_query($sql) or die("Unable to Execute Select query");
echo '<ul id="left-tree">';
if ($id == 1) {
$myclass = 'class="label label-info"';
} else {
$myclass = '';
}
echo '<li class="open"><i class="icon-globe"></i> <a ' . $myclass . ' href="users.php?id=1">Webmaster</a>';
echo '<ul>';
while ($row = mysql_fetch_assoc($rs)) {
echo '<li><i class="icon-user"></i> ';
if ($row["id"] == $id) {
echo '<a class="label label-info" href="users.php?id=' . $row["id"] . '"> ' . $row["username"];
} else {
echo '<a href="users.php?id=' . $row["id"] . '"> ' . $row["username"];
}
if ($row['active'] != 1) {
echo ' <i class="icon-ban-circle" title="User is not active, cannot login"></i> ';
}
echo '</a></li>';
}
echo '</ul>';
echo '</li></ul>';
}
function read_db($criteres = "")
{
global $db_vue_rm;
$sql = " SELECT id_loterie, date_creation_loterie, gain_loterie, id_gagnant_loterie,";
$sql .= "valeur_type_loterie, etat_loterie,";
$sql .= "nom_troll";
$sql .= " FROM loteries, trolls ";
$sql .= " WHERE id_gagnant_loterie = id_troll";
$sql .= $criteres;
if (!($result = mysql_query($sql, $db_vue_rm))) {
echo mysql_error();
} else {
$i = 1;
while ($row = mysql_fetch_assoc($result)) {
$this->list[$i]['id_loterie'] = $row['id_loterie'];
$this->list[$i]['date_creation_loterie'] = $row['date_creation_loterie'];
$this->list[$i]['gain_loterie'] = $row['gain_loterie'];
$this->list[$i]['id_gagnant_loterie'] = $row['id_gagnant_loterie'];
$this->list[$i]['valeur_type_loterie'] = $row['valeur_type_loterie'];
$this->list[$i]['etat_loterie'] = $row['etat_loterie'];
$this->list[$i]['nom_gagnant_loterie'] = $row['nom_troll'];
$i++;
}
}
}
/**
* BuildFlyingFleetTable.php
*
* @version 1
* @copyright 2008 By Chlorel for XNova
*/
function BuildFlyingFleetTable()
{
global $lang;
$TableTPL = gettemplate('admin/fleet_rows');
$FlyingFleets = doquery("SELECT * FROM {{table}} ORDER BY `fleet_end_time` ASC;", 'fleets');
while ($CurrentFleet = mysql_fetch_assoc($FlyingFleets)) {
$FleetOwner = doquery("SELECT `username` FROM {{table}} WHERE `id` = '" . $CurrentFleet['fleet_owner'] . "';", 'users', true);
$TargetOwner = doquery("SELECT `username` FROM {{table}} WHERE `id` = '" . $CurrentFleet['fleet_target_owner'] . "';", 'users', true);
$Bloc['Id'] = $CurrentFleet['fleet_id'];
$Bloc['Mission'] = CreateFleetPopupedMissionLink($CurrentFleet, $lang['type_mission'][$CurrentFleet['fleet_mission']], '');
$Bloc['Mission'] .= "<br>" . ($CurrentFleet['fleet_mess'] == 1 ? "R" : "A");
$Bloc['Fleet'] = CreateFleetPopupedFleetLink($CurrentFleet, $lang['tech'][200], '');
$Bloc['St_Owner'] = "[" . $CurrentFleet['fleet_owner'] . "]<br>" . $FleetOwner['username'];
$Bloc['St_Posit'] = "[" . $CurrentFleet['fleet_start_galaxy'] . ":" . $CurrentFleet['fleet_start_system'] . ":" . $CurrentFleet['fleet_start_planet'] . "]<br>" . ($CurrentFleet['fleet_start_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_start_type'] == 2 ? "D" : "L")) . "";
$Bloc['St_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_start_time']);
if (is_array($TargetOwner)) {
$Bloc['En_Owner'] = "[" . $CurrentFleet['fleet_target_owner'] . "]<br>" . $TargetOwner['username'];
} else {
$Bloc['En_Owner'] = "";
}
$Bloc['En_Posit'] = "[" . $CurrentFleet['fleet_end_galaxy'] . ":" . $CurrentFleet['fleet_end_system'] . ":" . $CurrentFleet['fleet_end_planet'] . "]<br>" . ($CurrentFleet['fleet_end_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_end_type'] == 2 ? "D" : "L")) . "";
if ($CurrentFleet['fleet_mission'] == 15) {
$Bloc['Wa_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_stay_time']);
} else {
$Bloc['Wa_Time'] = "";
}
$Bloc['En_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_end_time']);
$table .= parsetemplate($TableTPL, $Bloc);
}
return $table;
}
private static function query($q, $params = array())
{
if (self::$link === NULL) {
self::connect();
}
self::$numQuerys++;
$q .= self::$order;
$q .= self::$limit;
self::$order = '';
self::$limit = '';
self::$sql = $q;
self::$result = mysql_query($q, self::$link);
if (!self::$result) {
return false;
} else {
if (!is_resource(self::$result)) {
return true;
}
}
$rset = array();
while ($row = mysql_fetch_assoc(self::$result)) {
$rset[] = $row;
}
return $rset;
}
function tests_delete($course) {
global $db;
$sql = "SELECT test_id FROM ".TABLE_PREFIX."tests WHERE course_id=$course";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
$sql = "DELETE FROM ".TABLE_PREFIX."tests_questions_assoc WHERE test_id=$row[test_id]";
$result2 = mysql_query($sql, $db);
$sql2 = "SELECT result_id FROM ".TABLE_PREFIX."tests_results WHERE test_id=$row[test_id]";
$result2 = mysql_query($sql2, $db);
while ($row2 = mysql_fetch_assoc($result2)) {
$sql3 = "DELETE FROM ".TABLE_PREFIX."tests_answers WHERE result_id=$row2[result_id]";
$result3 = mysql_query($sql3, $db);
}
$sql = "DELETE FROM ".TABLE_PREFIX."tests_results WHERE test_id=$row[test_id]";
$result2 = mysql_query($sql, $db);
}
$sql = "DELETE FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$course";
$result = mysql_query($sql, $db);
$sql = "DELETE FROM ".TABLE_PREFIX."tests_questions_categories WHERE course_id=$course";
$result = mysql_query($sql, $db);
$sql = "DELETE FROM ".TABLE_PREFIX."tests WHERE course_id=$course";
$result = mysql_query($sql, $db);
}
/**
Gets the number of canceled votes.
i.e. if a user votes and then clicks again to unvote
**/
function cancelledVotes($item_name)
{
$query = "SELECT COUNT(*) AS cancelledVotes FROM pulse_pro_votes WHERE `item_name` = '{$item_name}' AND `vote_value`=0";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
return (int) $row['cancelledVotes'];
}
public function selectUserById($userId)
{
$connector = new DBConnector();
$connection = $connector->createConnection();
$query = 'SELECT name, lastname, password, alive FROM users u WHERE u.alive=1 AND u.id=' . $userId;
$result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error());
if (!$result || mysql_num_rows($result) == 0) {
return false;
}
$data = mysql_fetch_assoc($result);
$name = $data['name'];
$lastname = $data['lastname'];
$password = $data['password'];
$alive = $data['alive'];
mysql_free_result($result);
$id = intval($userId);
$query = 'SELECT * FROM userinfo u WHERE u.FK_users=' . $userId;
$result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error());
$data = mysql_fetch_row($result);
$user = new User($name, $lastname, $password, $data[2], $data[3], $data[4], $data[5], $data[6], $data[7], $data[8], $data[9], $alive);
$user->setId($id);
mysql_free_result($result);
mysql_close($connection);
return $user;
}
public function query($sql)
{
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit;
}
}
function service($text)
{
$text = str_replace("\\\"","\"",$text);
$token = explode(",",$text);
$last_token = $token[sizeof($token)-1];
$last_token = trim($last_token);
$items = array();
$result = mysql_query("select firstName, lastName, email from employees where CONCAT(firstName,' ',lastName,' ', email) like '%$last_token%' order by email;");
while($row = mysql_fetch_assoc($result))
{
$text = '"'.$row["firstName"]." ".$row["lastName"].'"'."<".$row["email"].">";
$text_array = $token;
$text_array[sizeof($text_array)-1] = $text;
$text = join(",",$text_array);
$html = '"'.$row["firstName"]." ".$row["lastName"].'"'."[".$row["email"]."]";
$html = preg_replace("/".$last_token."/i","<b>$last_token</b>",$html);
$html = str_replace("[","<",$html);
$html = str_replace("]",">",$html);
$item = array("text"=>$text,"html"=>$html);
array_push($items,$item);
}
return $items;
}
public function query($sql)
{
if ($this->link) {
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new \stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
$trace = debug_backtrace();
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br /> Error in: <b>' . $trace[1]['file'] . '</b> line <b>' . $trace[1]['line'] . '</b><br />' . $sql);
}
}
}
function getTangentText($type, $keyword)
{
global $dbHost, $dbUser, $dbPassword, $dbName;
$link = @mysql_connect($dbHost, $dbUser, $dbPassword);
if (!$link) {
die("Cannot connect : " . mysql_error());
}
if (!@mysql_select_db($dbName, $link)) {
die("Cannot find database : " . mysql_error());
}
$result = mysql_query("SELECT sr_keywords, sr_text FROM soRandom WHERE sr_type = '" . $type . "' ORDER BY sr_ID ASC;", $link);
$tempCounter = 0;
while ($row = mysql_fetch_assoc($result)) {
$pKey = "/" . $keyword . "/";
$pos = preg_match($pKey, $row['sr_keywords']);
//echo $pos . " is pos<br>";
//echo $keyword;
//echo " is keyword and this is the search return: " . $row['keywords'];
if ($pos != 0) {
$text[$tempCounter] = stripslashes($row["sr_text"]);
$tempCounter++;
}
}
mysql_close($link);
//$text=htmlentities($text);
return $text;
}
static function getDataItem($id)
{
if (file_exists($_SERVER['DOCUMENT_ROOT'] . "/config/remote.db.php")) {
include_once $_SERVER['DOCUMENT_ROOT'] . "/config/remote.db.php";
}
if (file_exists($_SERVER['DOCUMENT_ROOT'] . "/helpers/db.operations.php")) {
include_once $_SERVER['DOCUMENT_ROOT'] . "/helpers/db.operations.php";
}
$products_arr = Db::query("SELECT id,product_code,price,product_name,colors,first_photo FROM products WHERE id='{$id}'");
if (count($products_arr) > 0) {
$products = mysql_fetch_assoc($products_arr);
if (!$_SESSION['cart']) {
$_SESSION['cart'] = array();
}
if (!$_SESSION['cart']['count']) {
$_SESSION['cart']['count'] = 0;
}
$pid = $products['id'];
if (!$_SESSION['cart'][$pid]) {
$_SESSION['cart'][$pid] = $products;
$_SESSION['cart'][$pid]['count'] = 1;
} else {
$_SESSION['cart'][$pid]['count'] = $_SESSION['cart'][$pid]['count'] + 1;
}
$_SESSION['cart']['count']++;
if ($_SESSION['cart']['count'] > 0) {
$coun = $_SESSION['cart']['count'];
} else {
$coun = 0;
}
echo $coun;
} else {
echo "Запрошен не существующий товар";
}
}
function query($sql, $type = '')
{
if (defined('SHOW_SQL')) {
global $_SGLOBAL;
$sqlstarttime = $sqlendttime = 0;
$mtime = explode(' ', microtime());
$sqlstarttime = number_format($mtime[1] + $mtime[0] - $_SGLOBAL['supe_starttime'], 6) * 1000;
echo $sql . '<br>';
}
$func = $type == 'UNBUFFERED' && @function_exists('mysql_unbuffered_query') ? 'mysql_unbuffered_query' : 'mysql_query';
if (!($query = $func($sql, $this->link)) && $type != 'SILENT') {
$this->halt('MySQL Query Error', $sql);
}
if (defined('SHOW_SQL')) {
$mtime = explode(' ', microtime());
$sqlendttime = number_format($mtime[1] + $mtime[0] - $_SGLOBAL['supe_starttime'], 6) * 1000;
$sqltime = round($sqlendttime - $sqlstarttime, 3);
echo $sqltime . '<br>';
$explain = array();
$info = mysql_info();
if ($query && preg_match("/^(select )/i", $sql)) {
$explain = mysql_fetch_assoc(mysql_query('EXPLAIN ' . $sql, $this->link));
}
$_SGLOBAL['debug_query'][] = array('sql' => $sql, 'time' => $sqltime, 'info' => $info, 'explain' => $explain);
}
$this->querynum++;
return $query;
}
function AcceptOrder_SMS($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$userSql = "SELECT `a`.`id`,`a`.`firstname`, `a`.`lastname`, `b`.`value` as `gsmnumber`\n FROM `tblclients` as `a`\n JOIN `tblcustomfieldsvalues` as `b` ON `b`.`relid` = `a`.`id`\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`id`\n WHERE `a`.`id` IN (SELECT userid FROM tblorders WHERE id = '" . $args['orderid'] . "')\n AND `b`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `c`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `c`.`value` = 'on'\n LIMIT 1";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $args['orderid']);
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setUserid($UserInformation['id']);
$class->setMessage($message);
$class->send();
}
}
public function Login($user)
{
global $database, $generator, $logging;
$this->logged_in = true;
$_SESSION['sessid'] = $generator->generateRandID();
$_SESSION['username'] = $user;
$_SESSION['checker'] = $generator->generateRandStr(3);
$_SESSION['mchecker'] = $generator->generateRandStr(5);
$_SESSION['qst'] = $database->getUserField($_SESSION['username'], "quest", 1);
if (!isset($_SESSION['wid'])) {
$query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1');
$data = mysql_fetch_assoc($query);
$_SESSION['wid'] = $data['wref'];
} else {
if ($_SESSION['wid'] == '') {
$query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1');
$data = mysql_fetch_assoc($query);
$_SESSION['wid'] = $data['wref'];
}
}
$this->PopulateVar();
$logging->addLoginLog($this->uid, $_SERVER['REMOTE_ADDR']);
$database->addActiveUser($_SESSION['username'], $this->time);
$database->updateUserField($_SESSION['username'], "sessid", $_SESSION['sessid'], 0);
header("Location: dorf1.php");
}
function getAreaByID($id)
{
$sql = "SELECT area_name FROM area WHERE area_id = {$id}";
$rs = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($rs);
return $row['area_name'];
}
function getOnlineUsersInfo($sUserId, $bInit)
{
global $aXmlTemplates;
$aSaved = getSavedUsers();
$aActive = getActiveUsers($sUserId);
$aFriends = getFriends($sUserId);
saveUsers($aActive);
$sContents = "";
if ($bInit) {
$aFullUsers = array_unique(array_merge($aActive['online'], $aFriends));
} else {
$aFullUsers = array_diff($aActive['online'], $aSaved['online'], $aFriends);
$aNewOfflineUsers = array_intersect($aSaved['online'], $aActive['offline']);
$aNewOnlineUsers = array_intersect($aSaved['offline'], $aActive['online'], $aFriends);
for ($i = 0; $i < count($aNewOfflineUsers); $i++) {
$sContents .= parseXml($aXmlTemplates['user'], $aNewOfflineUsers[$i], FALSE_VAL);
}
for ($i = 0; $i < count($aNewOnlineUsers); $i++) {
$sContents .= parseXml($aXmlTemplates['user'], $aNewOnlineUsers[$i], TRUE_VAL);
}
}
$rResult = getUsersMedia($aFullUsers);
if ($rResult != null) {
for ($i = 0; $i < mysql_num_rows($rResult); $i++) {
$aUser = mysql_fetch_assoc($rResult);
$aUserInfo = getUserInfo($aUser['ID']);
$sOnline = in_array($aUser['ID'], $aActive['online']) ? TRUE_VAL : FALSE_VAL;
$sFriend = in_array($aUser['ID'], $aFriends) ? TRUE_VAL : FALSE_VAL;
$sMusic = $aUser['CountMusic'] > 0 ? TRUE_VAL : FALSE_VAL;
$sVideo = $aUser['CountVideo'] > 0 ? TRUE_VAL : FALSE_VAL;
$sContents .= parseXml($aXmlTemplates['user'], $aUser['ID'], $aUserInfo['nick'], $aUserInfo['sex'], $aUserInfo['age'], $aUserInfo['photo'], $aUserInfo['profile'], $sOnline, $sFriend, $sMusic, $sVideo);
}
}
return makeGroup($sContents, "users");
}
