sql_fetch_row PHP Exemples de code

Exemple #1

0

Afficher le fichier

Fichier : lib.template.php Projet : abhinay100/forma_app

/**
 * @return string the actual template name
 */
function getTemplate()
{
    // If saved in session use this one
    if (isset($_SESSION['template']) && $_SESSION['template'] != false) {
        return $_SESSION['template'];
    }
    //search for a template associated to the current host
    $plat_templ = parseTemplateDomain($_SERVER['HTTP_HOST']);
    if ($plat_templ != false) {
        $_SESSION['template'] = $plat_templ;
        return $plat_templ;
    }
    // search template according to the org_chart_tree option
    if (!Docebo::user()->isAnonymous()) {
        $qtxt = "SELECT associated_template FROM\r\n\t\t\t%adm_org_chart_tree\r\n\t\t\tWHERE associated_template IS NOT NULL AND\r\n\t\t\tidst_oc IN (" . implode(',', Docebo::user()->getArrSt()) . ")\r\n\t\t\tORDER BY iLeft DESC\r\n\t\t\tLIMIT 0,1";
        $re = sql_query($qtxt);
        if (mysql_num_rows($re) > 0) {
            list($template_code) = sql_fetch_row($re);
            setTemplate($template_code);
            return $_SESSION['template'];
        }
    }
    // search for the default template
    $_SESSION['template'] = getDefaultTemplate();
    return $_SESSION['template'];
}

Exemple #2

0

Afficher le fichier

Fichier : htmlfront.php Projet : abhinay100/forma_app

function edithtml()
{
    checkPerm('mod');
    require_once _base_ . '/lib/lib.form.php';
    $query = "\r\n\tSELECT textof\r\n\tFROM " . $GLOBALS['prefix_lms'] . "_htmlfront \r\n\tWHERE id_course = '" . $_SESSION['idCourse'] . "'";
    $re_htmlfront = sql_query($query);
    $error = false;
    if (isset($_POST['save'])) {
        if (mysql_num_rows($re_htmlfront) > 0) {
            $upd_query = "\r\n\t\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_htmlfront \r\n\t\t\tSET textof = '" . $_POST['description'] . "'\r\n\t\t\tWHERE id_course = '" . $_SESSION['idCourse'] . "'";
            $re = sql_query($upd_query);
        } else {
            $ins_query = "\r\n\t\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_htmlfront \r\n\t\t\t( id_course, textof) VALUES \r\n\t\t\t( \t'" . $_SESSION['idCourse'] . "',\r\n\t\t\t\t'" . $_POST['description'] . "' )";
            $re = sql_query($ins_query);
        }
        if ($re) {
            Util::jump_to('index.php?modname=htmlfront&amp;op=showhtml&amp;saveok=1');
        } else {
            $error = true;
        }
    }
    $lang =& DoceboLanguage::createInstance('htmlfront', 'lms');
    list($textof) = sql_fetch_row($re_htmlfront);
    $title_page = array('index.php?modname=htmlfront&amp;op=showhtml' => $lang->def('_HTMLFRONT'), $lang->def('_MOD'));
    $GLOBALS['page']->add(getTitleArea($title_page, 'htmlfront') . '<div class="std_block">' . getBackUi('index.php?modname=htmlfront&amp;op=showhtml', $lang->def('_BACK')) . ($error ? getErrorUi($lang->def('_ERROR_IN_SAVE')) : '') . Form::openForm('formnotes', 'index.php?modname=htmlfront&amp;op=edithtml') . Form::openElementSpace() . Form::getTextarea($lang->def('_TEXTOF'), 'description', 'description', importVar('description', false, $textof)) . Form::closeElementSpace() . Form::openButtonSpace() . Form::getButton('save', 'save', $lang->def('_SAVE')) . Form::getButton('undo', 'undo', $lang->def('_UNDO')) . Form::closeButtonSpace() . Form::closeForm() . '</div>', 'content');
}

Exemple #3

0

Afficher le fichier

Fichier : lib.advice.php Projet : abhinay100/forma_app

 function getCountUnreaded($id_user, $courses, &$last_access)
 {
     if (empty($courses)) {
         return array();
     }
     $unreaded = array();
     $query_unreaded = "\r\n\t\tSELECT idCourse, UNIX_TIMESTAMP(posted) \r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_advice \r\n\t\tWHERE author <> '" . $id_user . "' AND idCourse IN ( " . implode(',', $courses) . " ) ";
     $re_advice = sql_query($query_unreaded);
     if (!mysql_num_rows($re_advice)) {
         return array();
     }
     while (list($id_c, $posted) = sql_fetch_row($re_advice)) {
         if (!isset($last_access[$id_c])) {
             if (isset($unreaded[$id_c])) {
                 $unreaded[$id_c]++;
             } else {
                 $unreaded[$id_c] = 1;
             }
         } elseif ($posted > $last_access[$id_c]) {
             if (isset($unreaded[$id_c])) {
                 $unreaded[$id_c]++;
             } else {
                 $unreaded[$id_c] = 1;
             }
         }
     }
     return $unreaded;
 }

Exemple #4

0

Afficher le fichier

Fichier : PresenceLms.php Projet : abhinay100/forma_app

 protected function getDateClassrooms($id_date)
 {
     $query = "SELECT DISTINCT classroom" . " FROM %lms_course_date_day" . " WHERE id_date = " . $id_date;
     $result = sql_query($query);
     $array_classroom = array();
     while (list($id_classroom) = sql_fetch_row($result)) {
         $array_classroom[$id_classroom] = $id_classroom;
     }
     $res = '';
     $first = true;
     if (isset($array_classroom[0])) {
         $first = false;
         $res .= Lang::t('_NOT_ASSIGNED', 'admin_date');
     }
     $query = "SELECT name" . " FROM %lms_classroom" . " WHERE idClassroom IN (" . implode(',', $array_classroom) . ")" . " ORDER BY name";
     $result = sql_query($query);
     while (list($name) = sql_fetch_row($result)) {
         if ($first) {
             $first = false;
             $res .= $name;
         } else {
             $res .= ', ' . $name;
         }
     }
     return $res;
 }

Exemple #5

0

Afficher le fichier

Fichier : util.php Projet : shish/travmap

function getMatches($col, $name)
{
    global $casen, $table;
    if ($casen) {
        return "'{$name}'";
    }
    $name = urlencode($name);
    $name = str_replace("%C2", "", $name);
    $name = str_replace("%E2%84", "", $name);
    foreach (array("[", "]", "{", "}", "(", ")", "<", ">", "\\", "/", ".", ",", "?", "!", "\$", "^", "&", "*", "-", "_", "+", "=", ":", ";", "@", "~", "#", "%", " ") as $ok) {
        $name = str_replace(urlencode($ok), $ok, $name);
    }
    $name = preg_replace("/%[0-9A-F][0-9A-F]/", "_", $name);
    /* no matching characters = no point matching */
    /* if(strpos($name, "%") === false && strpos($name, "_") === false) return "'$name'"; */
    $result = sql_query("SELECT {$col} FROM {$table} WHERE {$col} LIKE '{$name}' GROUP BY {$col}");
    $ret = "";
    $n = 0;
    while ($row = sql_fetch_row($result)) {
        if ($n++) {
            $ret .= ", ";
        }
        $ret .= "'{$row[$col]}'";
    }
    return $ret;
}

Exemple #6

0

Afficher le fichier

Fichier : ls_loc.php Projet : robmat/samplebator

function _LS_LocationPage()
{
    global $dbi, $event, $tdbg;
    echo setPageTitle('Manage Locations');
    echo '<p>Hier werden die Spielst&auml;tten bzw. Locations im gesamten Bundesgebiet angezeigt. Ein Klick auf einen Eintrag ladet diesen zum Bearbeiten.<br><b>Unterhalb</b> der Datenmaske werden zugleich alle eingetragenen Heimmannschaften aus dem LigaSystem angezeigt.</p>';
    # SECTION 0 Navigation
    echo '<table bgcolor="' . $tdbg . '" cellpadding="2" cellspacing="1"><tr><td id="btnrefresh" bgcolor="white" onclick="initlocationpage()" onMouseOver="mover(this)" onMouseOut="mout(this)">Tabelle neu laden</td>' . '<td></td><td bgcolor="white" id="locbrowseActivity"><i>Ready</i></td>' . '<td></td><td bgcolor="white" id="locsaveActivity"><i>Ready</i></td>' . '</tr></table><br>';
    $location_count_result = sql_query('SELECT COUNT(*) FROM tbllocation l, tverband v WHERE l.lrealm_id = v.id', $dbi);
    $location_count = 0;
    while (list($count) = sql_fetch_row($location_count_result, $dbi)) {
        $location_count = $count;
    }
    $response->page = 1;
    $response->total = 1;
    $response->records = $location_count;
    $i = 0;
    $location_result = sql_query('SELECT * FROM tbllocation l, tverband v WHERE l.lrealm_id = v.id', $dbi);
    while (list($locid, $lname, $lcity, $lplz, $laddress, $lphone, $lactive, $lrealm_id, $lemail, $lcoordinates, $version, $lkey, $vereinid, $vcode, $vname, $vlogic, $version, $vactive) = sql_fetch_row($location_result, $dbi)) {
        $response->rows[$i]['id'] = $locid;
        $response->rows[$i]['cell'] = array($locid, $lname, $lcity, $lplz, $laddress, $lphone, $lactive, $lemail, $vname, $lcoordinates, $lrealm_id);
        $i++;
    }
    echo '<div id="locationData" style="display: none;">' . json_encode($response) . '</div>';
    echo '<table id="locationTable"></table><div id="locationPager"></div><script> createLocationTable(); </script>';
    # SECTION 2 DETAIL VIEW
    echo '<div id="frmLocation"><form name="locentry" action="fsaveLocation.php?opcode=save" method="post" target="_blank" onSubmit="submitForm(this);return false;"><fieldset><legend>Location Bearbeiten</legend>';
    echo include 'forms/location.php';
    echo '</form></div>';
    # section 4 BrowseOnSelectedDetail
    echo '<h3>Aktuelle Heimmannschaften dieser Spielst&auml;tte</h3><div id="axteamtable"></div>';
}

Exemple #7

0

Afficher le fichier

Fichier : HomeLmsController.php Projet : abhinay100/forma_app

 public function show()
 {
     require_once _base_ . '/lib/lib.navbar.php';
     require_once _lms_ . '/lib/lib.middlearea.php';
     $ma = new Man_MiddleArea();
     $block_list = array();
     //if($ma->currentCanAccessObj('user_details_short')) $block_list['user_details_short'] = true;
     if ($ma->currentCanAccessObj('user_details_full')) {
         $block_list['user_details_full'] = true;
     }
     if ($ma->currentCanAccessObj('credits')) {
         $block_list['credits'] = true;
     }
     if ($ma->currentCanAccessObj('news')) {
         $block_list['news'] = true;
     }
     $query_home = "SELECT title, description FROM learning_webpages where publish=1 and in_home = 1 AND language = '" . getLanguage() . "' LIMIT 1";
     $re_home = sql_query($query_home);
     list($titolo, $descrizione) = sql_fetch_row($re_home);
     if (!empty($block_list)) {
         $this->render('_tabs_block', array('active_tab' => 'home', '_content' => "<div id=\"tabhome_title\"><h1>" . $titolo . "</h1></div><div id=\"tabhome_description\">" . $descrizione . "</div>", 'block_list' => $block_list));
     } else {
         $this->render('_tabs', array('active_tab' => 'home', '_content' => "<div id=\"tabhome_title\"><h1>" . $titolo . "</h1></div><div id=\"tabhome_description\">" . $descrizione . "</div>"));
     }
 }

Exemple #8

0

Afficher le fichier

Fichier : class.admin_menu_fw.php Projet : abhinay100/forma_app

 function getLevelOneIntest($idMenu)
 {
     $lang =& DoceboLanguage::createInstance('menu', $this->platform);
     $query_menu = "\r\n\t\tSELECT name, image\r\n\t\tFROM " . $this->table_level_one . "\r\n\t\tWHERE idMenu = '" . (int) $idMenu . "'";
     $re_menu = sql_query($query_menu);
     list($name, $image) = sql_fetch_row($re_menu);
     return array('name' => $name != '' ? $lang->def($name) : '', 'image' => getPathImage('framework') . 'area_title/' . $image);
 }

Exemple #9

0

Afficher le fichier

Fichier : marquetapage.php Projet : npds/npds_dune

function marquetapage()
{
    global $cookie;
    if ($cookie[0] != '') {
        global $REQUEST_URI, $title, $post, $NPDS_Prefix;
        if ($ibid = theme_image("modules/add.gif")) {
            $add = $ibid;
        } else {
            $add = "modules/marquetapage/add.gif";
        }
        if ($ibid = theme_image("modules/addj.gif")) {
            $addj = $ibid;
        } else {
            $addj = "modules/marquetapage/addj.gif";
        }
        $result = sql_query("SELECT uri, topic FROM " . $NPDS_Prefix . "marquetapage WHERE uid='{$cookie['0']}' ORDER BY topic ASC");
        if (sql_num_rows($result)) {
            $tmp_toggle = '<a class="tog" id="show_fav" title="' . translate("Show list") . '"><i id="i_lst_fav" class="fa fa-caret-right fa-2x" ></i></a>';
            $content = "\n   <script type=\"text/javascript\">\n   //<![CDATA[\n   tog = function(lst,sho,hid){\n      \$(document).on('click', 'a.tog', function() {\n         var buttonID = \$(this).attr('id');\n         lst_id = \$('#'+lst);\n         i_id=\$('#i_'+lst);\n         btn_show=\$('#'+sho);\n         btn_hide=\$('#'+hid);\n         if (buttonID == sho) {\n            lst_id.fadeIn(1000);//show();\n            btn_show.attr('id',hid)\n            btn_show.attr('title','" . translate("Hide list") . "');\n            i_id.attr('class','fa fa-caret-up fa-2x');\n         } else if (buttonID == hid) {\n            lst_id.fadeOut(1000);//hide();\n            btn_hide=\$('#'+hid);\n            btn_hide.attr('id',sho);\n            btn_hide.attr('title','" . translate("Show list") . "');\n            i_id.attr('class','fa fa-caret-down fa-2x');\n        }\n       });\n   };\n   //]]>\n   </script>";
            $content .= '
   <h6>
   <a class="tog" id="show_fav" title="' . translate("Show list") . '"><i id="i_lst_fav" class="fa fa-caret-right fa-2x" ></i>&nbsp;Bookmarks </a><span class="tag tag-pill tag-default pull-right">' . sql_num_rows($result) . '</span>
   </h6>
   <ul id="lst_fav" style="display:none;" >
   
   <a href="modules.php?ModPath=marquetapage&amp;ModStart=marquetapage&amp;op=supp_all&amp;uri=' . $_SERVER['PHP_SELF'] . '"><i class="fa fa-trash-o text-danger" title="' . translate("Delete") . '" data-toggle="tooltip"></i></a>';
            while (list($uri, $topic) = sql_fetch_row($result)) {
                $content .= '
      <li><a href="' . $uri . '" style="font-size:.7rem;">' . $topic . '</a>
            <span class="float-xs-right"><a href="modules.php?ModPath=marquetapage&amp;ModStart=marquetapage&amp;op=supp&amp;uri=' . urlencode($uri) . '"><i class="fa fa-trash-o text-danger" title="' . translate("Delete") . '" data-toggle="tooltip"></i></a></span></li>';
            }
            $content .= '
   </ul>
   <script type="text/javascript">
   //<![CDATA[
      tog("lst_fav","show_fav","hide_fav");
   //]]>
   </script>';
        }
        global $block_title;
        $uri = urlencode($REQUEST_URI);
        if ($post) {
            $title .= "/" . $post;
        }
        if ($title == '') {
            $title_MTP = basename(urldecode($uri));
        } else {
            $title_MTP = $title;
        }
        $boxTitle = '<span><a href="modules.php?ModPath=marquetapage&amp;ModStart=marquetapage&amp;op=add&amp;uri=' . $uri . '&amp;topic=' . urlencode($title_MTP) . '"><i class="fa fa-bookmark-o " title="' . translate("Add") . ' ' . translate("favourite") . '" data-toggle="tooltip"></i></a></span>';
        if ($block_title == '') {
            $boxTitle .= '&nbsp;MarqueTaPage';
        } else {
            $boxTitle .= '&nbsp;' . $block_title;
        }
        themesidebox($boxTitle, $content);
    }
}

Exemple #10

0

Afficher le fichier

Fichier : Funciones.php Projet : BGCX067/facemaps-hg-to-git

function getMasInformacion($id, &$nombre, &$nickfacebook, &$imagen, &$categoria, &$direccion, &$telefono, &$paginaweb)
{
    global $dbi;
    if (!$id) {
        return 0;
    }
    $result = sql_query("SELECT `nombre`, `nickfacebook`, `imagen`, `categoria`, `direccion`, `telefono`, `paginaweb` FROM `sitios` WHERE " . "`id`='" . $id . "'", $dbi) or die(mysql_error(0));
    list($nombre, $nickfacebook, $imagen, $categoria, $direccion, $telefono, $paginaweb) = sql_fetch_row($result);
}

Exemple #11

0

Afficher le fichier

Fichier : structures.php Projet : kalliste/kalliste-php-framework

function query_to_hash($query)
{
    $ret = array();
    $result = sql_query_dbg($query);
    while ($row = sql_fetch_row($result)) {
        $ret[$row[0]] = $row[1];
    }
    return $ret;
}

Exemple #12

0

Afficher le fichier

Fichier : lib.param.php Projet : abhinay100/forma_app

/**
 * @return array of param
 **/
function getLOParamArray($idParam)
{
    $query = "SELECT param_name, param_value FROM " . $GLOBALS['prefix_lms'] . "_lo_param " . "WHERE idParam = '" . (int) $idParam . "'";
    $rs = sql_query($query) or errorCommunication('getLOParam');
    $result = array();
    while (list($param_name, $param_value) = sql_fetch_row($rs)) {
        $result[$param_name] = $param_value;
    }
    return $result;
}

Exemple #13

0

Afficher le fichier

Fichier : ticket.php Projet : BackupTheBerlios/hpt-obm-svn

 function sql_query($ticket_id)
 {
     global $tts, $user, $name, $prefix, $hlpdsk_prefix;
     //load values from db
     $query = "select `ticket_number`, \n\t\t`t_assigned`,\n                `t_from`,\n                `t_stage`,\n                `t_category`,\n                `t_priority`,\n                `t_subject`,\n                `t_description`,\n                `t_comments`,\n                `post_date`,\n                `complete`,\n                `due_date`,\n                `end_date`,\n                `change_date`,\n                `t_status`,\n                `t_sms`,\n                `t_email`\n\n\t\twhere \n                 Ticket_Number='{$this->ticket_nr}'";
     if ($result = sql_query($query)) {
         list($this->ticket_nr, $this->assigned_id, $this->issuer, $this->stage_id, $this->category_id, $this->priority_id, $this->subject, $this->description, $this->comments, $this->post_date, $this->complete, $this->due_date, $this->end_date, $this->change_date, $this->status_id, $this->notify_priv_msg, $this->notify_email) = sql_fetch_row($result);
     }
     return $result;
 }

Exemple #14

0

Afficher le fichier

Fichier : EditionAlms.php Projet : abhinay100/forma_app

 public function getEditionIdFromCourse($id_course)
 {
     $query = "SELECT id_edition" . " FROM %lms_course_editions" . " WHERE id_course = " . (int) $id_course;
     $result = sql_query($query);
     $res = array();
     while (list($id_edition) = sql_fetch_row($result)) {
         $res[$id_edition] = $id_edition;
     }
     return $res;
 }

Exemple #15

0

Afficher le fichier

Fichier : lib.utils.php Projet : abhinay100/forma_app

/**
 * @param 	int $idMain if passed return the first voice of the relative menu
 *
 * @return 	array 	with three element modulename and op that contains the first accessible menu element 
 *					indicate in idMain  array( [idMain], [modulename], [op] )
 **/
function firstPage($idMain = false)
{
    $query_main = "\r\n\tSELECT module.idModule, main.idMain, module.module_name, module.default_op, module.token_associated \r\n\tFROM ( " . $GLOBALS['prefix_lms'] . "_menucourse_main AS main JOIN\r\n\t\t" . $GLOBALS['prefix_lms'] . "_menucourse_under AS un ) JOIN\r\n\t\t" . $GLOBALS['prefix_lms'] . "_module AS module\r\n\tWHERE main.idMain = un.idMain AND un.idModule = module.idModule \r\n\t\tAND main.idCourse = '" . (int) $_SESSION['idCourse'] . "'\r\n\t\tAND un.idCourse = '" . (int) $_SESSION['idCourse'] . "'\r\n\t\t" . ($idMain !== false ? " AND main.idMain='" . $idMain . "' " : '') . "\r\n\tORDER BY main.sequence, un.sequence";
    $re_main = sql_query($query_main);
    while (list($id_module, $main, $module_name, $default_op, $token) = sql_fetch_row($re_main)) {
        if (checkPerm($token, true, $module_name)) {
            return array('idModule' => $id_module, 'idMain' => $main, 'modulename' => $module_name, 'op' => $default_op);
        }
    }
}

Exemple #16

0

Afficher le fichier

Fichier : VideoconferenceLms.php Projet : abhinay100/forma_app

 public function getCourseName()
 {
     $query = "SELECT idCourse, name" . " FROM %lms_course";
     $result = sql_query($query);
     $res = array();
     while (list($id_course, $name) = sql_fetch_row($result)) {
         $res[$id_course] = $name;
     }
     return $res;
 }

Exemple #17

0

Afficher le fichier

Fichier : dso_verein.php Projet : robmat/samplebator

function _listverein($findstr = '')
{
    /*
     * List is a Meldewesen Public function, no restrictions here ...
     * all Meldewesen accounts can see this List here ... + Vereinsaccount his own Verein
     * TODO generate snippet listing ...
     */
    global $dbi, $vereinsdb, $sctdcolor, $dartred, $dartgreen, $imgdetail, $imgedit, $usertoken;
    if (sizeof($usertoken['registermap']) < 1) {
        if (!$usertoken['verein_id'] > 0) {
            die('E:Type:0');
        }
        $precord = sql_query('select vid,verband_id,vbundesland,vOrt,vname,vemail,vwebsite,vsoft,vsteel from tverein where vid=' . $usertoken['verein_id'], $dbi);
    } else {
        $precord = sql_query("select vid,verband_id,vbundesland,vOrt,vname,vemail,vwebsite,vsoft,vsteel from tverein where vname like '%{$findstr}%' order by verband_id desc,vname asc", $dbi);
    }
    if (strlen($findstr) > 0) {
        $pageheader = 'Ergebniss der Suchanfrage ' . $findstr;
    } else {
        $pageheader = 'Liste aller Vereine';
    }
    $aTH = array('Bundesland', 'Verein', 'email', 'WWW', 'Soft', 'Steel');
    setPageTitle($pageheader);
    OpenTable('tblverein');
    echo '<div id="lstverein"><table width="100%" cellpadding="2" cellspacing="2">';
    echo ArrayToTableHead($aTH);
    $i = 0;
    $target = $vereinsdb . '?func=edit&amp;vvid=';
    $onClick = 'vereinedit(vid)';
    while (list($vid, $verband_id, $varea, $vOrt, $vname, $vemail, $vwebsite, $vsoft, $vsteel) = sql_fetch_row($precord, $dbi)) {
        // $i=$i+1;
        echo '<tr>' . '<td>' . $imgdetail . ' ' . $varea . '<br>' . $vOrt . '</td>' . '<td><a href="' . $target . $vid . '"><b>' . $vname . '</b></a></td>' . '<td>' . $vemail . '</td>' . '<td><a href="http://' . $vwebsite . '" target="_blank">' . $vwebsite . '</a></td>';
        if ($vsoft == 1) {
            echo '<td>' . $dartgreen . '</td>';
        } else {
            echo '<td></td>';
        }
        if ($vsteel == 1) {
            echo '<td>' . $dartgreen . '</td>';
        } else {
            echo '<td></td>';
        }
        echo '</tr>';
    }
    # // END WHILE LOOP
    echo '</table></div>';
    CloseTable();
    /*
    debug("Anzahl der Vereine: $i");
    $RS=DB_listVereine($dbi,0,$usertoken['realm'],$findstr);
    $ROWS=RecordsetToClickTable($RS,1,$target."%P1%",0);
    // OUTPUT
    echo "<div id=\"lstverein\"><table>$ROWS</table></div>";
    */
}

Exemple #18

0

Afficher le fichier

Fichier : admin_division_rights.php Projet : robmat/samplebator

function right_types()
{
    global $dbi;
    $right_result = sql_query('SELECT a.access_id, a.acactive, a.acdesc FROM tligaaccesscode a ORDER BY a.access_id ASC', $dbi);
    # Table header
    $ret = '<table><tr><td class="thead">Id</td><td class="thead">Active</td><td class="thead">Right name</td></tr>';
    while (list($id, $acactive, $acdesc) = sql_fetch_row($right_result, $dbi)) {
        $ret = $ret . '<tr><td>' . $id . '</td><td>' . ($acactive == 1 ? 'Yes' : 'No') . '</td><td>' . $acdesc . '</td></tr>';
    }
    return $ret . '</table>';
}

Exemple #19

0

Afficher le fichier

Fichier : question_poll.php Projet : abhinay100/forma_app

function quest_edit($type_quest, $id_quest, $back_poll)
{
    $re_quest = sql_query("\r\n\tSELECT type_file, type_class \r\n\tFROM " . $GLOBALS['prefix_lms'] . "_quest_type_poll \r\n\tWHERE type_quest = '" . $type_quest . "'");
    if (!mysql_num_rows($re_quest)) {
        return;
    }
    list($type_file, $type_class) = sql_fetch_row($re_quest);
    require_once $GLOBALS['where_lms'] . '/modules/question_poll/' . $type_file;
    $quest_obj = eval("return new {$type_class}( {$id_quest} );");
    $quest_obj->edit($back_poll);
}

Exemple #20

0

Afficher le fichier

Fichier : lib.chat.php Projet : abhinay100/forma_app

 function getRoomUserOnline($platform, $room_type, $id_source)
 {
     $users_qtxt = "\r\n\t\tSELECT id_room\r\n\t\tFROM " . $GLOBALS["prefix_scs"] . "_rules_room\r\n\t\tWHERE id_source = '" . $id_source . "' AND room_type = '" . $room_type . "'";
     list($id_room) = sql_fetch_row(sql_query($users_qtxt));
     $users_qtxt = "\r\n\t\tSELECT *\r\n\t\tFROM " . $GLOBALS["prefix_scs"] . "_rules_user\r\n\t\tWHERE id_room='" . $id_room . "'\r\n\t\tORDER BY userid";
     $users_q = sql_query($users_qtxt);
     while ($row = mysql_fetch_array($users_q)) {
         $res[] = $row["userid"];
     }
     return $res;
 }

Exemple #21

0

Afficher le fichier

Fichier : admin_system_user_types.php Projet : robmat/samplebator

function user_types()
{
    global $dbi;
    $user_type_result = sql_query('SELECT t.id, t.typename, t.typedescription FROM ttypeuser t ORDER BY t.id ASC', $dbi);
    # Table header
    $ret = '<table><tr><td class="thead">Id</td><td class="thead">Type name</td><td class="thead">Description</td></tr>';
    while (list($id, $typename, $typedescription) = sql_fetch_row($user_type_result, $dbi)) {
        $ret = $ret . '<tr><td>' . $id . '</td><td>' . $typename . '</td><td>' . $typedescription . '</td></tr>';
    }
    return $ret . '</table>';
}

Exemple #22

0

Afficher le fichier

Fichier : field.php Projet : abhinay100/forma_app

function field_specialop($type_field, $id_common, $back)
{
    $re_quest = sql_query("\r\n\tSELECT type_file, type_class \r\n\tFROM " . $GLOBALS['prefix_fw'] . "_field_type \r\n\tWHERE type_field = '" . $type_field . "'");
    if (!mysql_num_rows($re_quest)) {
        return;
    }
    list($type_file, $type_class) = sql_fetch_row($re_quest);
    require_once $GLOBALS['where_framework'] . '/modules/field/' . $type_file;
    $quest_obj = new $type_class($id_common);
    $quest_obj->setUrl('index.php?modname=field&amp;op=manage&amp;fo=special');
    $quest_obj->specialop($back);
}

Exemple #23

0

Afficher le fichier

Fichier : func_mail.php Projet : robmat/samplebator

/**
*	purpose:	resolves a logical mail group into adresses
* 	params:		group id
*	returns:	Mail TO: STRING
*/
function _GetMailAdressForGroup($mgroup_id)
{
    global $dbi;
    $RET = '';
    $resx = sql_query('select G.mgroup_id,mgroupname,user_id,uname,email from tmessagegroup G left JOIN tmessagegroupmember GM on G.mgroup_id=GM.mgroup_id' . ' left JOIN tuser U ON GM.user_id=U.id WHERE G.mgroup_id=' . $mgroup_id, $dbi);
    while ($a = sql_fetch_row($resx, $dbi)) {
        $RET = $RET . $a[4] . ', ';
    }
    $RET = str_replace('[]', '@', $RET);
    $RET = str_replace('[at]', '@', $RET);
    $RET = substr($RET, 0, strlen($RET) - 2);
    return $RET;
}

Exemple #24

0

Afficher le fichier

Fichier : functions.inc.php Projet : pawelzielak/opencaching-pl

function sqlValue($sql, $default)
{
    $rs = sql($sql);
    if ($r = sql_fetch_row($rs)) {
        if ($r[0] == null) {
            return $default;
        } else {
            return $r[0];
        }
    } else {
        return $default;
    }
}

Exemple #25

0

Afficher le fichier

Fichier : track.poll.php Projet : abhinay100/forma_app

 /**
  * @return id_track if create row else false 
  **/
 function setTrack($id_reference, $id_resource, $id_user)
 {
     $query = "\r\n\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_polltrack\r\n\t\tSET id_poll = '" . (int) $id_resource . "',\r\n\t\t\tid_reference = '" . (int) $id_reference . "',\r\n\t\t\tid_user = '******',\r\n\t\t\tdata_attempt = '" . date("Y-m-d H:i:s") . "'";
     if (!sql_query($query)) {
         return false;
     }
     list($id_track) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()"));
     if ($id_track) {
         return $id_track;
     } else {
         return false;
     }
 }

Exemple #26

0

Afficher le fichier

Fichier : middlearea.php Projet : abhinay100/forma_app

function view_area()
{
    checkPerm('view');
    require_once _lms_ . '/lib/lib.middlearea.php';
    $lang =& DoceboLanguage::createInstance('middlearea', 'lms');
    $lc =& DoceboLanguage::createInstance('menu_course', 'lms');
    $query_menu = "SELECT mo.idModule, mo.default_name, under.my_name\r\n\tFROM %lms_module AS mo\r\n\t\tJOIN %lms_menucourse_under AS under\r\n\tWHERE mo.idModule = under.idModule\r\n\t\tAND mo.module_info IN ('all','user')\r\n\t\tAND mvc_path <> 'elearning/show'\r\n\tORDER BY under.sequence";
    $re_menu_voice = sql_query($query_menu);
    $base_url = 'index.php?modname=middlearea&amp;op=select_permission&amp;load=1&amp;obj_index=';
    $second_url = 'index.php?modname=middlearea&amp;op=switch_active&amp;obj_index=';
    $ma = new Man_MiddleArea();
    $disabled_list = $ma->getDisabledList();
    // Main men
    $main_menu = '';
    while (list($id_m, $default_name, $my_name) = sql_fetch_row($re_menu_voice)) {
        $main_menu .= '<li>' . '<span>' . Lang::t($default_name, 'menu_over', false, false, $default_name) . '</span>' . ' <a class="ico-sprite subs_users" href="' . $base_url . 'mo_' . $id_m . '"><span>' . Lang::t('_VIEW_PERMISSION', 'standard') . '</span></a>' . ' <a class="ico-sprite subs_' . (isset($disabled_list['mo_' . $id_m]) ? 'noac' : 'actv') . '" href="' . $second_url . 'mo_' . $id_m . '"><span>' . Lang::t('_ENABLE_AREA', 'middlearea') . '</span></a>' . '</li>';
    }
    $main_menu .= '<li>' . '<span>' . Lang::t('_MESSAGES', 'menu_over') . '</span>' . ' <a class="ico-sprite subs_users" href="' . $base_url . 'mo_message' . '"><span>' . Lang::t('_VIEW_PERMISSION', 'standard') . '</span></a>' . ' <a class="ico-sprite subs_' . (isset($disabled_list['mo_message']) ? 'noac' : 'actv') . '" href="' . $second_url . 'mo_message' . '"><span>' . Lang::t('_ENABLE_AREA', 'middlearea') . '</span></a>' . '</li>';
    $main_menu .= '<li>' . '<span>' . Lang::t('_CUSTOMER_HELP', 'customer_help') . '</span>' . ' <a class="ico-sprite subs_users" href="' . $base_url . 'mo_help' . '"><span>' . Lang::t('_VIEW_PERMISSION', 'standard') . '</span></a>' . ' <a class="ico-sprite subs_' . (isset($disabled_list['mo_help']) ? 'noac' : 'actv') . '" href="' . $second_url . 'mo_help' . '"><span>' . Lang::t('_ENABLE_AREA', 'middlearea') . '</span></a>' . '</li>';
    // Tab list
    $tab_list = '';
    $tab = array('tb_elearning' => Lang::t('_ELEARNING', 'middlearea'), 'tb_home' => Lang::t('_HOME', 'middlearea'), 'tb_label' => Lang::t('_LABELS', 'label'), 'tb_classroom' => Lang::t('_CLASSROOM', 'middlearea'), 'tb_catalog' => Lang::t('_CATALOGUE', 'middlearea'), 'tb_assessment' => Lang::t('_ASSESSMENT', 'middlearea'), 'tb_coursepath' => Lang::t('_COURSEPATH', 'coursepath'), 'tb_games' => Lang::t('_CONTEST', 'middlearea'), 'tb_communication' => Lang::t('_COMMUNICATIONS', 'middlearea'), 'tb_videoconference' => Lang::t('_VIDEOCONFERENCE', 'middlearea'), 'tb_kb' => Lang::t('_CONTENT_LIBRARY', 'middlearea'));
    if (Get::cfg('enable_plugins', false)) {
        require_once _adm_ . "/models/PluginAdm.php";
        $pluginAdm = new PluginAdm();
        $plugins = $pluginAdm->getInstalledPlugins();
        foreach ($plugins as $plugin_name) {
            $tab["tb_" . strtolower($plugin_name)] = ucfirst($plugin_name);
        }
    }
    $query_menu = "SELECT obj_index from %lms_middlearea where obj_index like 'tb_%' ORDER BY sequence";
    $re_tablist = sql_query($query_menu);
    while (list($obj_index) = sql_fetch_row($re_tablist)) {
        $id = $obj_index;
        $name = $tab[$id];
        $tab_list .= '<li id="' . $id . '">' . '<span>' . $name . '</span>' . ' <a class="ico-sprite subs_users" href="' . $base_url . $id . '"><span>' . Lang::t('_VIEW_PERMISSION', 'standard') . '</span></a>' . ' <a class="ico-sprite subs_' . (isset($disabled_list[$id]) ? 'noac' : 'actv') . '" href="' . $second_url . $id . '"><span>' . Lang::t('_ENABLE_AREA', 'middlearea') . '</span></a>' . '</li>';
    }
    // Block List
    $block_list = '';
    $block = array('user_details_full' => Lang::t('_PROFILE', 'profile'), 'credits' => Lang::t('_CREDITS', 'middlearea'), 'career' => Lang::t('_CAREER', 'middlearea'), 'course' => Lang::t('_SUBSCRIBE_COURSE', 'middlearea'), 'news' => Lang::t('_NEWS', 'middlearea'));
    while (list($id, $name) = each($block)) {
        $block_list .= '<div class="direct_block">' . '<span>' . $name . '</span>' . ' <a class="ico-sprite subs_users" href="' . $base_url . $id . '"><span>' . Lang::t('_VIEW_PERMISSION', 'standard') . '</span></a>' . ' <a class="ico-sprite subs_' . (isset($disabled_list[$id]) ? 'noac' : 'actv') . '" href="' . $second_url . $id . '"><span>' . Lang::t('_ENABLE_AREA', 'middlearea') . '</span></a>' . '</div><br/>';
    }
    cout(getTitleArea($lang->def('_MIDDLE_AREA'), 'middlearea') . '<div class="std_block">');
    cout('<h2>' . Lang::t('_MAN_MENU', 'menu') . '</h2>' . '<ul class="action-list">' . $main_menu . '</ul>');
    cout('<div id="lms_main_container" class="yui-t5">' . '<div class="yui-b">' . '<h2>' . Lang::t('_BLOCKS', 'middlearea') . '</h2>' . $block_list . '</div>' . '<div id="yui-main">' . '<div class="yui-b" id="tablist">' . '<h2>' . Lang::t('_TABS', 'middlearea') . '</h2>' . '<ul class="action-list">' . $tab_list . '</ul>' . '</div>' . '</div>' . '<div class="nofloat"></div>' . '</div>');
    cout('</div>');
    $js = "\r\n\t<script src=\"http://yui.yahooapis.com/3.9.1/build/yui/yui-min.js\"></script>\r\n\t<script>\r\n\tYUI().use('sortable', function (Y) {\r\n\t    var sortable;\r\n\t    sortable = new Y.Sortable({\r\n\t        container: '#tablist ul',\r\n\t        nodes    : 'li',\r\n\t        opacity  : '0.1'\r\n\t    });\r\n\r\n        sortable.delegate.after('drag:end', function (e) {\r\n\t        var node = sortable.delegate.get('currentNode');\r\n\r\n\t            // rewind\r\n\t            while(node.previous()) {\r\n\t            \tnode = node.previous();\r\n}\r\n\t            // ciclo\r\n\t            a = node.get('id');\r\n\t            while(node.next()) {\r\n\t            \tnode = node.next();\r\n\t            \ta += ','+node.get('id');\r\n\t            }\r\n\r\n\t            sUrl = 'ajax.adm_server.php?r=middlearea/order&list='+a;\r\n\r\n\t\t        var callback = {\r\n\t\t                success: function(o) {\r\n\t\t                },\r\n\t\t                failure:function(o) {\r\n\t\t                }\r\n\t\t        };\r\n\t\t        YAHOO.util.Connect.asyncRequest('GET', sUrl, callback);\r\n\r\n\r\n\t    });\r\n    });\r\n\r\n\r\n    </script>";
    cout($js);
}

Exemple #27

0

Afficher le fichier

Fichier : tree.category.php Projet : abhinay100/forma_app

 function TreeView_CatView($tdb, $id, $rootname = 'root')
 {
     $query_course = "SELECT idCategory, COUNT(*) FROM " . $GLOBALS['prefix_lms'] . "_course GROUP BY idCategory ";
     $re_course = sql_query($query_course);
     while ($row = sql_fetch_row($re_course)) {
         $this->cat_not_empty[$row[0]] = $row[1];
     }
     $user_lvl = Docebo::user()->getUserLevelId();
     parent::TreeView($tdb, $id, $rootname);
     $this->can_add = $user_lvl == ADMIN_GROUP_GODADMIN;
     $this->can_mod = $user_lvl == ADMIN_GROUP_GODADMIN;
     $this->can_del = $user_lvl == ADMIN_GROUP_GODADMIN;
     //require_once(_i18n_.'/lib.lang.php');
 }

Exemple #28

0

Afficher le fichier

Fichier : login.php Projet : BackupTheBerlios/jonescms

function finish($uname, $pwd)
{
    global $dbi;
    $md5_pwd = md5($pwd);
    $l_result = sql_query("select * from jones_user where uname='{$uname}' and pwd='{$md5_pwd}'", $dbi);
    if (sql_num_rows($l_result, $dbi) == 0) {
        $error = "Incorrect username or password";
        Header("Location: login.php?error={$error}");
        die;
    }
    list($uid, $uname, $pwd, $fname, $lname, $email, $privs) = sql_fetch_row($l_result, $dbi);
    sendCookie($uid, $uname, $pwd, $fname, $lname, $email, $privs);
    Header("Location: index.php");
}

Exemple #29

0

Afficher le fichier

Fichier : index.php Projet : BackupTheBerlios/domsmod-svn

function printDetails($query, $type)
{
    global $admin, $user, $cookie, $prefix, $dbi, $user_prefix;
    $result = sql_query($query, $dbi);
    $numrows = sql_num_rows($result, $dbi);
    echo "<Br><B>Your " . $type . " : " . $numrows . "</B><HR>";
    echo "<table width=\"60%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" . "<tr><td bgcolor=\"#000000\"><table width=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\">" . "</tr><tr>" . "<th height=\"25\" colspan=\"1\" align=\"center\" wrap><font color=\"#28313C\"><strong>Name</strong></font></th>" . "<th height=\"15\" colspan=\"1\" align=\"center\" wrap><font color=\"#28313C\"><strong>UserId</strong></font></th>" . "<th height=\"10\" colspan=\"1\" align=\"center\" wrap><font color=\"#28313C\"><strong>Year</strong></font></th>" . "<th height=\"10\" colspan=\"1\" align=\"center\" wrap><font color=\"#28313C\"><strong>Company</strong></font></th>" . "</tr>";
    while (list($name, $username, $gradyear, $company) = sql_fetch_row($result, $dbi)) {
        $username = "******" . $username . "</a>";
        echo "<tr><td class=\"row1\">" . $name . "</td>" . "<td  class=\"row2\">" . $username . "</td>" . "<td  class=\"row1\">" . $gradyear . "</td>" . "<td  class=\"row2\">" . $company . "</td>" . "</tr>";
        //echo    $name . " [" . $username . "]" . "<BR>";
    }
    echo "</table>";
}

Exemple #30

0

Afficher le fichier

Fichier : class.break_page.php Projet : abhinay100/forma_app

 /**
  * this function create a copy of a question and return the corresponding id
  * 
  * @return int 	return the id of the new question if success else return false
  * 
  * @access public
  * @author Fabio Pirovano (fabio@docebo.com)
  */
 function copy($new_id_poll, $back_poll = NULL)
 {
     list($sel_cat, $quest, $sequence, $page) = sql_fetch_row(sql_query("\r\n\t\tSELECT id_category, title_quest, sequence, page \r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_pollquest \r\n\t\tWHERE id_quest = '" . (int) $this->id . "'"));
     //insert question
     $ins_query = "\r\n\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_pollquest \r\n\t\t( id_poll, id_category, type_quest, title_quest, sequence, page ) VALUES \r\n\t\t( \t'" . (int) $new_id_poll . "', \r\n\t\t\t'" . (int) $sel_cat . "', \r\n\t\t\t'" . $this->getQuestionType() . "', \r\n\t\t\t'" . mysql_escape_string($quest) . "',\r\n\t\t\t'" . (int) $sequence . "',\r\n\t\t\t'" . (int) $page . "' ) ";
     if (!sql_query($ins_query)) {
         return false;
     }
     //find id of auto_increment colum
     list($new_id_quest) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()"));
     if (!$new_id_quest) {
         return false;
     }
     return $new_id_quest;
 }

PHP sql_fetch_row Exemples