public function Html() { //$disabled = ($this->disabled) ? "disabled='disabled'" : ""; $surveid = $_SESSION['surveyid']; if ($this->Label) { $this->element = "<label for='{$this->id}' class='label_{$this->class_name}'>{$this->Label}</label>"; } $this->element .= "<div name='{$this->name}' id='{$this->id}' class='{$this->class_name}' >"; $result = mysql_query("SELECT * FROM survey_options WHERE `surveyid` = {$surveid} ORDER BY `optionid` ASC"); $iter = 0; while ($Item = mysql_fetch_object($result)) { $iter++; $id = 'field_' . $iter; $name_id_RO = 'optionRO' + $iter; $name_id_RU = 'optionRU' + $iter; $label_text_RO = 'Optiune RO ' . $iter; $label_text_RU = 'Optiune RU ' . $iter; $label_RO = '<label for="' . $name_id_RO . '">' . $label_text_RO . '</label>'; $label_RU = '<label for="' . $name_id_RU . '">' . $label_text_RU . '</label>'; $this->element .= '<p>' . $label_RO . '<input id="' . $name_id_RO . '" name="optionsRO[]" type="text" class="large_width" value="' . $Item->option_RO . '"/></p>'; $this->element .= '<p>' . $label_RU . '<input id="' . $name_id_RU . '" name="optionsRU[]" type="text" class="large_width bottom" value="' . $Item->option_RU . '"/></p>'; //$this->element .= 'test'; } $this->element .= "{$this->Value}</div>"; return $this->element; }
function search_other_function_filters() { global $recherche_loc; global $charset; global $msg, $dbh; // mettre par défaut la localisation du lecteur if (!isset($recherche_loc) && $_SESSION["empr_location"]) { $recherche_loc = $_SESSION["empr_location"]; } $r .= "<select name='recherche_loc'>"; $r .= "<option value='0'>" . htmlentities($msg["search_loc_all_site"], ENT_QUOTES, $charset) . "</option>"; $requete = "select location_libelle,idlocation from docs_location where location_visible_opac=1"; $result = mysql_query($requete, $dbh); if (mysql_numrows($result)) { while ($loc = mysql_fetch_object($result)) { $selected = ""; if ($recherche_loc == $loc->idlocation) { $selected = "selected"; } $r .= "<option value='{$loc->idlocation}' {$selected}>{$loc->location_libelle}</option>"; } } $r .= "</select>"; return $r; }
function login($clave) { $sqllogin = "******" . $_POST["numcontrol"] . "'"; $qConsulta = mysql_query($sqllogin); if ($fila = mysql_fetch_object($qConsulta)) { $idalumno = $fila->idalumno; mysql_free_result($qConsulta); $sqllogin = "******" . $_POST["idexamen"] . "'"; $qConsulta = mysql_query($sqllogin) or die("error: " . $sqllogin); if ($fila2 = mysql_fetch_object($qConsulta)) { $idexamen = $fila2->idexamen; $sExam = "SELECT idexamen FROM tans1 WHERE idalumno= " . $idalumno . " AND idexamen = " . $idexamen; $req = mysql_query($sExam) or die("error: " . $sExam); if (mysql_fetch_object($req)) { return $this->login_form(traducir_cadena("already_registered")); exit; } setcookie("logged", $_POST["sessionid"]); session_start(); $_SESSION['usuario'] = 'alumno'; $_SESSION['sessionid'] = $_POST["sessionid"]; $_SESSION['numcontrol'] = $_POST["numcontrol"]; $_SESSION['idexamen'] = $_POST["idexamen"]; header("Location: exam.php"); } else { return $this->login_form(traducir_cadena(FORM_ERROR), $clave); } } else { return $this->login_form(traducir_cadena(FORM_ERROR), $clave); } }
function section_jointeam_doJoin($id, $invite) { // Try to add player to team $obj = mysql_fetch_object(mysql_query("select l_team.id, l_team.name, l_team.leader, count(callsign) nump\n from l_team left join l_player on l_team.id = l_player.team\n where l_team.id = " . $id . "\n group by l_team.id, l_team.name, l_team.leader")); if ($obj->nump == $TEAMSIZE) { // Team full echo "<center>Sorry, this team is full. Probably someone was joining it at the same time...</center>"; } else { // Okay, let's do the update mysql_query("update l_player set team=" . $id . " where id=" . $_SESSION['playerid']); // Close team if it's full if ($obj->nump == $TEAMSIZE - 1) { mysql_query("update l_team set status='closed' where id=" . $id); } // Close team if it has 3 players and is adminclosed if ($obj->nump == 2) { mysql_query("update l_team set status='closed' where adminclosed='yes' and id=" . $id); } echo '<center>You are now a member of the ' . teamLink($obj->name, $obj->id, false) . ' team.<BR> A message has been sent to the team leader.</center>'; session_refresh(); // Send a message to the team leader $player = playerLink($_SESSION['playerid'], $_SESSION['callsign']); if ($invite) { $msg = "{$player} has accepted your invitation, and has joined your team!<BR>"; sqlQuery("DELETE FROM bzl_invites WHERE teamid={$obj->id} AND \n playerid={$_SESSION['playerid']}"); } else { $msg = "A new player just joined your team: {$player}"; } sendBzMail(0, $obj->leader, $_SESSION['callsign'] . ' joined your team!', $msg); } }
public function loadContent($content_id) { $this->addLog("<" . __LINE__ . "> " . __METHOD__); if (!is_numeric($content_id) || $content_id <= 0) { throw new Exception("<" . __LINE__ . "> " . __METHOD__ . "ERROR: content_id no valido"); } else { $this->contentId = $content_id; } $sql = "SELECT c.*, cp.nombre as provider, cc.descripcion nombreCat, ft.al_titulo album, ft.al_artista artista, ft.al_id, ft.tr_archivo, ft.tr_archivo_preview, cc.xxx\n FROM Web.contenidos c INNER JOIN Web.contenidos_cat cc ON (cc.id=c.categoria)\n INNER JOIN Web.fulltracks ft ON (ft.contenido=c.id)\n INNER JOIN Web.contenidos_proveedores cp ON (c.proveedor = cp.id)\n WHERE c.id={$this->contentId}\n AND c.tipo='" . WAZZUP_FULLTRACK . "'"; $this->addLog("SQL: " . $sql); $rs = mysql_query($sql, $this->dbc->db); if (!$rs) { throw new Exception("ERROR: no se pueden obtener datos del contenido {$this->contentId} "); } else { $obj = mysql_fetch_object($rs); } $this->contentType = $obj->tipo; $this->adult = $obj->xxx == "0" ? "false" : "true"; $this->artist = konvert($obj->artista); $this->provider = konvert($obj->provider); $this->album = konvert($obj->album); $this->title = konvert("{$obj->nombre}"); $this->description = konvert(getContentDescription($this->contentId, $this->contentType, $obj->categoria)); $this->publicationYear = date("Y"); // v1.3 $this->archivo = trim("/contenido/fulltracks/" . $obj->archivo); $this->preview = trim("/contenido/fulltracks/" . $obj->referencia); }
public function Argument($argumentId, $row = false, $parent = false) { global $sDB, $sQuery; if (!$row) { $res = $sDB->exec("SELECT * FROM `arguments` WHERE `argumentId` = '" . i($argumentId) . "' LIMIT 1;"); $row = mysql_fetch_object($res); } if (!$row) { $this->argumentId = -1; return; } $this->argumentId = $argumentId; $this->questionId = $row->questionId; $this->parentId = $row->parentId; $this->parent = $parent; $this->userId = $row->userId; $this->username = $sQuery->getUsernameById($row->userId); $this->headline = $row->headline; $this->abstract = $row->abstract; $this->details = $row->details; $this->dateAdded = $row->dateAdded; $this->type = $row->type; $this->score = $row->score; $this->url = $row->url; $this->timeSince = timeSinceString($row->dateAdded); $this->arguments = array(); }
public static function getRecentEvents($event, $node, $node_id, $N) { global $mv_keys; $events = array(); $_COMMON_COLS__T_PLAYER = "players.name, players.value, players.f_pos_name, players.owned_by_team_id AS 'f_tid', players.f_tname AS 'tname', players.f_rid, f_rname AS 'rname'"; switch ($event) { case self::T_PLAYER_DEAD: if (!isset($col)) { $col = 'date_died'; } case self::T_PLAYER_SOLD: if (!isset($col)) { $col = 'date_sold'; } case self::T_PLAYER_HIRED: if (!isset($col)) { $col = 'date_bought'; } $_query = "SELECT DISTINCT player_id AS 'pid', %COL AS 'date', {$_COMMON_COLS__T_PLAYER} FROM players, mv_players WHERE players.player_id = mv_players.f_pid AND players.type = " . PLAYER_TYPE_NORMAL . " AND %NODE = {$node_id} AND %COL IS NOT NULL ORDER BY %COL DESC LIMIT {$N}"; $query = str_replace(array('%COL', '%NODE'), array($col, $mv_keys[$node]), $_query); $result = mysql_query($query); while ($row = mysql_fetch_object($result)) { $events[] = $row; } break; case self::T_PLAYER_SKILLS: $query = "SELECT player_id AS 'pid', game_data_skills.skill_id AS 'skill_id', game_data_skills.cat AS 'cat', game_data_skills.name AS 'skill_name', CONCAT(game_data_skills.name,' (',game_data_skills.cat,')') AS 'skill', {$_COMMON_COLS__T_PLAYER} FROM players, mv_players, players_skills, game_data_skills WHERE \n players.player_id = mv_players.f_pid AND \n mv_players.f_pid = players_skills.f_pid AND\n players_skills.f_skill_id = game_data_skills.skill_id AND \n " . $mv_keys[$node] . " = {$node_id} \n GROUP BY player_id, f_skill_id ORDER BY players_skills.id DESC LIMIT {$N}"; $result = mysql_query($query); while ($row = mysql_fetch_object($result)) { $events[] = $row; } break; } return $events; }
function relacionar_campos_id() { $sql = "SELECT `TABLE_SCHEMA`,`TABLE_NAME`, `COLUMN_NAME`, `ORDINAL_POSITION`,\n\t\t\t\t\t`COLUMN_DEFAULT`, `IS_NULLABLE`, `DATA_TYPE`, `CHARACTER_MAXIMUM_LENGTH`,\n\t\t\t\t\t`CHARACTER_SET_NAME`, `COLLATION_NAME`, `COLUMN_TYPE`, `COLUMN_KEY`\n\t\t\t\tFROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA='" . DB_NAME . "'\n\t\t\t\tORDER BY `TABLE_SCHEMA`,`TABLE_NAME`,`ORDINAL_POSITION` ASC;"; mysql_select_db(DB_NAME) or die; $result = mysql_query($sql); $current_schema = ''; $current_table = ''; while ($row = mysql_fetch_object($result)) { $current_schema = $row->TABLE_SCHEMA; $current_table = $row->TABLE_NAME; $estructura[$row->TABLE_NAME][] = $row->COLUMN_NAME; if ($row->COLUMN_KEY == "PRI") { $estructura[$row->TABLE_NAME]["llave"] = $row->COLUMN_NAME; } } foreach ($estructura as $tabla => $campo) { if (in_array("NOMBRE", $campo)) { $MOSTRAR = "NOMBRE"; } elseif (in_array("DESCRIPCION", $campo)) { $MOSTRAR = "DESCRIPCION"; } elseif (in_array("TITULO", $campo)) { $MOSTRAR = "TITULO"; } else { $MOSTRAR = ""; } //echo $this->fields[$estructura[$tabla]["llave"]]['input']; if ($this->fields[$estructura[$tabla]["llave"]]['input'] != "select" && $_GET["table"] != $tabla) { $this->setInputType($estructura[$tabla]["llave"], 'select'); $this->setValuesFromQuery($estructura[$tabla]["llave"], "SELECT " . $estructura[$tabla]["llave"] . ", {$MOSTRAR} FROM {$tabla} order by {$MOSTRAR}"); } } }
public function pesquisar($id) { $query = "select * from usuario where idusuario={$id}"; $result = mysql_query($query); $obj = mysql_fetch_object($result); return $obj; }
public function delete() { if (!empty($_POST['del'])) { // Nuke departments.. mysql_query("DELETE FROM `" . DB_PREFIX . "departments`\n WHERE `id` IN(" . implode(',', $_POST['del']) . ")\n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $rows = mysql_affected_rows(); // Nuke user department association.. mysql_query("DELETE FROM `" . DB_PREFIX . "userdepts`\n WHERE `deptID` IN(" . implode(',', $_POST['del']) . ")\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); if (mswRowCount('departments') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "departments`"); } if (mswRowCount('userdepts') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "userdepts`"); } // Rebuild order sequence.. $seq = 0; $q = mysql_query("SELECT `id` FROM `" . DB_PREFIX . "departments` ORDER BY `orderBy`"); while ($RB = mysql_fetch_object($q)) { $n = ++$seq; mysql_query("UPDATE `" . DB_PREFIX . "departments` SET\n\t `orderBy` = '{$n}'\n WHERE `id` = '{$RB->id}'\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); } return $rows; } return '0'; }
public function login_student($student_id, $student_password) { if (empty($student_id) || empty($student_password)) { echo "Username or Password is invalid"; return false; } $student_id = stripslashes($student_id); $student_password = stripslashes($student_password); $student_id = mysql_real_escape_string($student_id); $student_password = mysql_real_escape_string($student_password); $student_password = sha1($student_password); $students_rec = mysql_query("SELECT * FROM " . $this->students_table . " where student_id = {$student_id};"); if (($obj = mysql_fetch_object($students_rec)) != NULL) { $student = new student($obj->student_id, $obj->user_name, $obj->user_password, $obj->change_password); if ($student->getUser_password() == $student_password) { echo "welcome " . $student->getUser_name(); return true; } else { echo "Wrong password"; return false; } } else { echo "No such user!"; return false; } }
function listCalendarByRange($sd, $ed) { $ret = array(); $ret['events'] = array(); $ret["issort"] = true; $ret["start"] = php2JsTime($sd); $ret["end"] = php2JsTime($ed); $ret['error'] = null; try { $db = new DBConnection(); $db->getConnection(); $sql = "select * from `jqcalendar` where `starttime` between '" . php2MySqlTime($sd) . "' and '" . php2MySqlTime($ed) . "'"; $handle = mysql_query($sql); //echo $sql; while ($row = mysql_fetch_object($handle)) { //$ret['events'][] = $row; //$attends = $row->AttendeeNames; //if($row->OtherAttendee){ // $attends .= $row->OtherAttendee; //} //echo $row->StartTime; $ret['events'][] = array($row->Id, $row->Subject, php2JsTime(mySql2PhpTime($row->StartTime)), php2JsTime(mySql2PhpTime($row->EndTime)), $row->IsAllDayEvent, 0, 0, $row->Color, 1, $row->Location, ''); } } catch (Exception $e) { $ret['error'] = $e->getMessage(); } return $ret; }
function dropdown($tabel, $fieldforval, $fieldforname = '', $where = '', $pilih = '', $bariskosong = true, $sparator = ' - ') { if ($bariskosong == true) { echo "<option value=''> </option>"; } $dst = explode(" as ", $fieldforval); if ($fieldforname != '') { $dst2 = explode("+", $fieldforname); } $fieldforname == '' ? $sql = "select {$fieldforval} from {$tabel} {$where}" : count($dst2) > 1 ? $sql = "select * from {$tabel} {$where}" : ($sql = "select {$fieldforval},{$fieldforname} from {$tabel} {$where}"); //echo $sql; $rs = mysql_query($sql) or die(mysql_error()); while ($rw = mysql_fetch_object($rs)) { count($dst) > 1 ? $valu = $rw->{$dst}[1] : ($valu = $rw->{$dst}[0]); $sparator == ' [' ? $sp_end = ' ]' : ($sp_end = ''); if ($fieldforname != '') { count($dst2) > 1 ? $addnm = $rw->{$dst2}[0] . $sparator . $rw->{$dst2}[1] . $sp_end : ($addnm = $rw->{$dst2}[0]); } echo "<option value='" . $valu . "'"; if ($pilih == $valu) { echo " selected"; } echo " >"; echo $fieldforname == '' ? $rw->{$dst}[1] : $addnm . "</option>"; } }
/** * Inenhåller menun som passar till Art * subkategprierna ordnas efter orderNo i matrushkan. */ public function setContent() { $q = new Query("matruschkaShowAtPlaces"); $q->showAt($this->title, $this->m->lang, "msapOrderNo", "ASC", 100); $i = 1; while ($row = mysql_fetch_object($q->getResult())) { $this->content .= '<div class="leftMenu">'; $this->content .= '<span class="subSecTitle">' . $row->mButtonTitle . '</span>'; $qq = new Query("matruschka"); $qq->whereCustom("mButtonTitle, mRowid", "mParent = '" . $row->mRowid . "' AND mPublished='1' AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0); if ($qq->getNumRows()) { // om det finns nån som har denna som parent $this->content .= '<div class="subSection">'; while ($row2 = mysql_fetch_object($qq->getResult())) { /** Svart om aktiv **/ if ($this->getActive($this->m->ID, $row2->mRowid) == 1) { $this->content .= '<span class="sideMenuActive"><a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a></span><br/>'; } else { $this->content .= '<a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a><br/>'; } } $this->content .= '</div>'; } $this->content .= '</div>'; if ($i != $q->getNumRows()) { $this->content .= '<img src="' . Settings::$graphics . 'stripes.gif" />' . "\n"; } $i++; } }
function show_lost_status_form() { global $dbh, $msg, $charset; global $finance_statut_perdu, $finance_recouvrement_lecteur_statut; $result = "\n\t<form method='POST' action='admin.php?categ=finance&sub=amendes_relance&action=updateloststatus'>\n\t<h3>" . $msg["finance_statut_perdu_expl_empr"] . "</h3>\t\n\t\t<div class='form-contenu'>\t\t\n\t\t\t<div class='row'> \n\t\t\t\t<div class='colonne2'>\n\t\t\t\t\t" . $msg["finance_statut_expl_perdu"] . ":\n\t\t\t\t</div>\t\t\n\t\t\t\t<div class='colonne_suite'>\n\t\t\t\t\t!!statut_expl!!\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<div class='row'> \n\t\t\t\t<div class='colonne2'>\n\t\t\t\t\t" . $msg["finance_statut_lecteur_en_recouvrement"] . ":\n\t\t\t\t</div>\t\t\n\t\t\t\t<div class='colonne_suite'>\n\t\t\t\t\t!!statut_empr!!\n\t\t\t\t</div>\t\t\t\t\n\t\t\t</div>\t\n\t\t\t<div class='row'>\t\n\t\t\t</div>\t\n\t\t</div>\t\n\t\t<div class='row'>\t\n\t\t\t<input type='submit' class='bouton' value='" . $msg["finance_amende_modifier"] . "'\">\t\t\t\n\t\t</div>\t\n\t</form>\t\n\t"; $requete = "select idstatut,statut_libelle from docs_statut"; $resultat = mysql_query($requete, $dbh); $list_statut = "<select name='statut_perdu' id='statut_perdu'>\n"; while ($r = mysql_fetch_object($resultat)) { $list_statut .= "<option value='" . $r->idstatut . "' "; if ($r->idstatut == $finance_statut_perdu) { $list_statut .= "selected='selected' "; } $list_statut .= ">" . htmlentities($r->statut_libelle, ENT_QUOTES, $charset) . "</option>\n"; } $list_statut .= "</select>\n"; $result = str_replace("!!statut_expl!!", $list_statut, $result); $requete = "select idstatut,statut_libelle from empr_statut"; $resultat = mysql_query($requete, $dbh); $list_statut = "<select name='statut_empr' id='statut_empr'>\n<option value='0' "; if (!$finance_recouvrement_lecteur_statut) { $list_statut .= "selected='selected' "; } $list_statut .= ">" . htmlentities($msg["finance_statut_lecteur_no_change"], ENT_QUOTES, $charset) . "</option>\n"; while ($r = mysql_fetch_object($resultat)) { $list_statut .= "<option value='" . $r->idstatut . "' "; if ($r->idstatut == $finance_recouvrement_lecteur_statut) { $list_statut .= "selected='selected' "; } $list_statut .= ">" . htmlentities($r->statut_libelle, ENT_QUOTES, $charset) . "</option>\n"; } $list_statut .= "</select>\n"; $result = str_replace("!!statut_empr!!", $list_statut, $result); echo $result; }
public function getTotalRecord() { $result = mysql_query("select count(id) as num_rows from " . $this->_table); $row = mysql_fetch_object($result); $total = $row->num_rows; return $total; }
public function GetSqlResultInModel($sqlQuery, $DataObject) { try { $ReturnList = array(); if (!is_object($DataObject)) { return array(); } if (!$this->connection) { $this->connectToDatabase(); } if ($sqlQuery != "" && !is_null($sqlQuery)) { if (!($result = mysql_query($sqlQuery, $this->connection))) { throw new CntException($sqlQuery . " - " . mysql_error()); } else { } } else { throw new CntException('Query is missing: ' . $sqlQuery); } if ((int) mysql_num_rows($result) < 1) { return array(); } while ($row = mysql_fetch_object($result)) { $Object = clone $DataObject; foreach ($row as $key => $value) { $Object->{"_" . $key} = $value; } $ReturnList[] = $Object; unset($Object); } return $ReturnList; } catch (CntException $ex) { return false; } }
function get_img_id($pckg_id) { $query = "select id from uploaded_images where reference_id='{$pckg_id}' "; $result = mysql_query($query); $id = mysql_fetch_object($result); return $id->id; }
function show_platforms() { $path = "../cache/platform_list.xml"; $mtime = @filemtime($path); if ($mtime && time() - $mtime < 3600) { @readfile($path); } else { require_once "../inc/db.inc"; $retval = db_init_aux(true); if (!$retval) { $query = 'select name, user_friendly_name, plan_class from platform, app_version where app_version.platformid = platform.id and app_version.deprecated=0 group by name, plan_class'; $result = mysql_query($query); $f = fopen($path, "w"); fwrite($f, "<platforms>\n"); while ($p = mysql_fetch_object($result)) { if ($p->plan_class) { $pc = " <plan_class>{$p->plan_class}</plan_class>\n"; } else { $pc = ""; } fwrite($f, " <platform>\n <platform_name>{$p->name}</platform_name>\n <user_friendly_name>{$p->user_friendly_name}</user_friendly_name>\n{$pc} </platform>\n"); } mysql_free_result($result); fwrite($f, "</platforms>\n"); fclose($f); @readfile($path); } } }
function create_race($track, $mod, $league, $race_time) { # check if this is a re-import # delete race + results first $query = sprintf("select id from league_races where track='%s' and rfm_name='%s' and league_id=%d and race_time='%s'", mysql_real_escape_string($track), mysql_real_escape_string($mod), $league['id'], mysql_real_escape_string($race_time)); $res = mysql_query($query); if (!$res) { die("query {$query} failed: " . mysql_error()); } if (mysql_num_rows($res) > 0) { echo "re-import, deleteing old race + results\n"; $row = mysql_fetch_object($res); $old_id = $row->id; $query = "delete from league_races where id={$old_id}"; $res = mysql_query($query); if (!$res) { die("query failed: " . mysql_error()); } $query = "delete from league_results where race_id={$old_id}"; $res = mysql_query($query); if (!$res) { die("query failed: " . mysql_error()); } } $query = sprintf("insert into league_races (track, rfm_name, league_id, race_time) values ('%s', '%s', %d, '%s')", mysql_real_escape_string($track), mysql_real_escape_string($mod), $league['id'], mysql_real_escape_string($race_time)); $res = mysql_query($query); if (!$res) { die("insert query failed: " . mysql_error()); } $result_id = mysql_insert_id(); return $result_id; }
public function get_datas() { //on commence par récupérer l'identifiant retourné par le sélecteur... $selector = $this->get_selected_selector(); if ($selector) { $article_id = $selector->get_value(); if ($article_id) { $sections = array(); $query = "select num_section from cms_articles where id_article = " . $article_id; $result = mysql_query($query); if (mysql_num_rows($result)) { $section_id = mysql_result($result, 0, 0); if ($section_id) { $datas = array(); $i = 0; do { $i++; $query = "select id_section,section_num_parent from cms_sections where id_section = " . $section_id; $result = mysql_query($query); if (mysql_num_rows($result)) { $row = mysql_fetch_object($result); $section_id = $row->section_num_parent; $datas[] = $row->id_section; } else { break; } //en théorie on sort toujours, mais comme c'est un pays formidable, on lock à 100 itérations... } while ($row->section_num_parent != 0 || $i > 100); return array_reverse($datas); } } } } return false; }
public function loadById($transactionId) { $connection = connectDB(); $query = "SELECT * FROM Transactions WHERE id={$transactionId}"; $result = mysql_query($query); while ($row = mysql_fetch_object($result)) { $this->id = $row->id; $this->fname = $row->FirstName; $this->lname = $row->LastName; $this->email = $row->Email; $this->payment = $row->Payment; $this->finalToPay = $row->FinalToPay; $this->PaypalMail = $row->PaypalMail; $this->BankNr = $row->BankNr; $this->AccountNr = $row->AccountNr; $this->StatusDate = $row->StatusDate; $this->RejectOption = $row->RejectOption; $this->OrderDate = $row->OrderDate; $this->ReceptionDate = $row->ReceptionDate; $this->ProcessedDate = $row->ProcessedDate; $this->PaymentDate = $row->PaymentDate; $this->FinishedDate = $row->FinishedDate; break; } closeDB($connection); }
function fetch_data() { global $dbh; $this->selected_list = array(); $req = "SELECT * FROM opac_filters where opac_filter_view_num=" . $this->id_vue . " and opac_filter_path='" . $this->path . "' "; $myQuery = mysql_query($req, $dbh); if (mysql_num_rows($myQuery)) { $r = mysql_fetch_object($myQuery); $param = unserialize($r->opac_filter_param); $this->selected_list = $param["selected"]; } $myQuery = mysql_query("SELECT * FROM docs_location order by location_libelle ", $dbh); $this->liste_item = array(); $link = ""; $i = 0; if (mysql_num_rows($myQuery)) { while ($r = mysql_fetch_object($myQuery)) { $this->liste_item[$i] = new stdClass(); $this->liste_item[$i]->id = $r->idlocation; $this->liste_item[$i]->name = $r->location_libelle; if (in_array($r->idlocation, $this->selected_list)) { $this->liste_item[$i]->selected = 1; } else { $this->liste_item[$i]->selected = 0; } $i++; } } return true; }
function pengguna() { $nis = $_SESSION['nis']; $sesi = $_SESSION['nama_siswa']; $id_kelas = $_SESSION['id_kelas']; $nama_kelas = $_SESSION['nama_kelas']; $id_tahun_ajaran = $_SESSION['id_tahun_ajaran']; $nama_tahun_ajaran = $_SESSION['nama_tahun_ajaran']; $sql_dp = "SELECT * FROM siswa WHERE nis='{$nis}'"; $result_dp = mysql_query($sql_dp); $data_dp = mysql_fetch_object($result_dp); ?> <li class="dropdown user"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"> <img alt="" src="../../foto_profil/<?php echo $data_dp->dispict; ?> " width="28" /> <span class="username"><?php echo $_SESSION['nama_siswa']; ?> </span> <i class="icon-angle-down"></i> </a> <ul class="dropdown-menu"> <li><a href="profil.php?nis=<?php echo $nis; ?> "><i class="icon-user"></i> Profil</a></li> <li><a href="../../logout.php"><i class="icon-key"></i> Log Out</a></li> </ul> </li> <?php }
function show_zbib($dbh) { global $msg; print "<table>\n\t\t<tr>\n\t\t<th class='titre_data'>{$msg['zbib_nom']}</th>\n\t\t<th class='titre_data'>{$msg['zbib_base']}</th>\n\t\t<th class='titre_data'>{$msg['zbib_utilisation']}</th>\n\t\t<th class='titre_data'>{$msg['zbib_nb_attr']}</th>\n\t\t</tr>"; // affichage du tableau des z_bib $requete = "SELECT bib_id, bib_nom, base, search_type, count(*) as nb_attr FROM z_bib left outer join z_attr on bib_id=attr_bib_id group by bib_id, bib_nom, base, search_type ORDER BY bib_nom, base, search_type "; $res = mysql_query($requete, $dbh); $nbr = mysql_num_rows($res); $parity = 1; for ($i = 0; $i < $nbr; $i++) { $row = mysql_fetch_object($res); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./admin.php?categ=z3950&sub=zbib&action=modif&id={$row->bib_id}';\" "; print "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>"; print "<td><strong>" . $row->bib_nom . "</strong></td>"; print "<td>" . $row->base . "</td>"; print "<td>" . $row->search_type . "</td>"; print "<td>" . $row->nb_attr . "</td>"; print "</tr>"; } print "</table>\n\t\t<input class='bouton' type='button' value='" . $msg["ajouter"] . "' onClick=\"document.location='./admin.php?categ=z3950&sub=zbib&action=add'\" />\n\t\t"; }
protected function get_managed_search_dest_form($search_dest) { if ($search_dest != "new") { $infos = $this->managed_datas['module']['search_dests'][$search_dest]; } else { $infos = array('name' => "", 'page' => 0); } $form = ""; //nom $form .= "\n\t\t\t<div class='row'>\n\t\t\t\t<div class='colonne3'>\n\t\t\t\t\t<label for='cms_module_search_search_dest_name'>" . $this->format_text($this->msg['cms_module_search_search_dest_name']) . "</label>\n\t\t\t\t</div>\n\t\t\t\t<div class='colonne-suite'>\n\t\t\t\t\t<input type='text' name='cms_module_search_search_dest_name' value='" . $this->format_text($infos['name']) . "'/>\n\t\t\t\t</div>\n\t\t\t</div>"; //page $form .= "\n\t\t\t<div class='row'>\n\t\t\t\t<div class='colonne3'>\n\t\t\t\t\t<label for='cms_module_search_search_dest_page'>" . $this->format_text($this->msg['cms_module_search_search_dest_page']) . "</label>\n\t\t\t\t</div>\n\t\t\t\t<div class='colonne-suite'>\n\t\t\t\t\t<select name='cms_module_search_page_dest' onchange='load_page_vars(this.value)'>"; //on va chercher les infos pour les pages du portail ! $query = "select id_page,page_name from cms_pages order by page_name asc"; $result = mysql_query($query); $pages = array(); $pages[0] = $this->msg["cms_module_menu_menu_entry_page_choice"]; if (mysql_num_rows($result)) { $form .= "\n\t\t\t\t\t\t<option value='0' " . (!$infos['page'] ? "selected='selected'" : "") . ">" . $this->format_text($this->msg['cms_module_search_classique_dest']) . "</option>"; while ($row = mysql_fetch_object($result)) { $form .= "\n\t\t\t\t\t\t<option value='" . $row->id_page . "' " . ($row->id_page == $infos['page'] ? "selected='selected'" : "") . ">" . $this->format_text($row->page_name) . "</option>"; } } $form .= "\n\t\t\t\t\t</select>\n\t\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\t\tfunction load_page_vars(page_id){\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t}\n\t\t\t\t\t</script>\n\t\t\t\t</div>\n\t\t\t</div>"; return $form; }
function get_internal_lang_path($filename) { $path = ""; if (isset($_GET['lang'])) { $lang = $_GET['lang']; // register the session and set the cookie $_SESSION['lang'] = $lang; //setcookie("lang", $lang, time() + (3600 * 24 * 30)); } else { if (isset($_SESSION['lang'])) { $lang = $_SESSION['lang']; } else { if (isset($_COOKIE['lang'])) { $lang = $_COOKIE['lang']; } else { $lang = 'EN'; } } } global $objDb; $objDb->Connection(); $sql = "select * from job_language where status=1 and language_shortname = '" . strtoupper($lang) . "'"; $result = $objDb->ExecuteQuery($sql); if (mysql_num_rows($result) > 0) { $langr = mysql_fetch_object($result); $path = $_SERVER['DOCUMENT_ROOT'] . "/langues/" . $langr->language_name . "/PAGE_" . $filename . "_" . $langr->language_shortname . ".php"; } else { $path = "langues/English/PAGE_" . $filename . "_EN.php"; } return $path; }
public function get_datas() { $selector = $this->get_selected_selector(); if ($selector) { $tab_values = $selector->get_value(); if (!is_array($tab_values)) { $tab_values = array($tab_values); } if (count($tab_values) > 0) { $list_values = implode(",", $tab_values); $query = "select id_section,if(section_start_date != '0000-00-00 00:00:00',section_start_date,section_creation_date) as publication_date from cms_sections where section_num_parent in (" . $list_values . ")"; if ($this->parameters["sort_by"] != "") { $query .= " order by " . $this->parameters["sort_by"]; if ($this->parameters["sort_order"] != "") { $query .= " " . $this->parameters["sort_order"]; } } $result = mysql_query($query); $return = array(); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_object($result)) { $return[] = $row->id_section; } } $return = $this->filter_datas("sections", $return); if ($this->parameters["nb_max_elements"] > 0) { $return = array_slice($return, 0, $this->parameters["nb_max_elements"]); } return $return; } } return false; }
function getPersonalNameById($id) { $sql = "SELECT * FROM personal WHERE id = '{$id}'"; $res = mysql_query($sql); $row = mysql_fetch_object($res); return $row->username; }
function Header() { global $conn; global $dbname; global $userid; global $pabrik; global $statId; global $periode; global $kdBrg; global $msnId; $str1 = "select * from " . $dbname . ".organisasi where induk='MHO' and tipe='PT'"; $res1 = mysql_query($str1); while ($bar1 = mysql_fetch_object($res1)) { $nama = $bar1->namaorganisasi; $alamatpt = $bar1->alamat . ", " . $bar1->wilayahkota; $telp = $bar1->telepon; } $str = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $pabrik . "'"; $namapt = 'COMPANY NAME'; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $namapt = strtoupper($bar->namaorganisasi); } $sNm = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $statId . "'"; $qNm = mysql_query($sNm); $rNm = mysql_fetch_assoc($qNm); $path = 'images/logo.jpg'; $this->Image($path, 15, 5, 22); $this->SetFont('Arial', 'B', 10); $this->SetFillColor(255, 255, 255); $this->SetX(42); $this->Cell(60, 5, $nama, 0, 1, 'L'); $this->SetX(42); $this->Cell(60, 5, $alamatpt, 0, 1, 'L'); $this->SetX(42); $this->Cell(60, 5, "Tel: " . $telp, 0, 1, 'L'); $this->Ln(); $this->SetFont('Arial', 'B', 8); $this->Cell(20, 5, $namapt, '', 1, 'L'); $this->SetFont('Arial', '', 8); $this->Line(10, 30, 290, 30); $this->Cell(35, 5, $_SESSION['lang']['pabrik'], '', 0, 'L'); $this->Cell(2, 5, ':', '', 0, 'L'); $this->Cell(80, 5, $namapt, '', 0, 'L'); $this->Cell(20, 5, $_SESSION['lang']['statasiun'], '', 0, 'L'); $this->Cell(2, 5, ':', '', 0, 'L'); $this->Cell(35, 5, $rNm['namaorganisasi'], 0, 1, 'L'); // $this->Cell(140,5,' ','',0,'R'); // $this->Cell(140,5,' ','',0,'R'); $this->Cell(35, 5, 'User', '', 0, 'L'); $this->Cell(2, 5, ':', '', 0, 'L'); $this->Cell(100, 5, $_SESSION['standard']['username'], '', 1, 'L'); // $this->Ln(); if ($periode != '0') { $this->Cell(15, 5, $_SESSION['lang']['periode'], '', 0, 'L'); $this->Cell(2, 5, ':', '', 0, 'L'); $this->Cell(35, 5, $periode, '', 0, 'L'); } $this->Ln(); }