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