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"); }