chamilo / chamilo-lms

                WHERE login_user_id = '".$_user['user_id']."'

                ORDER BY login_date DESC LIMIT 1";

        $result_last_login = Database::query($sql);

        if (!$result_last_login) {

            if (Database::num_rows($result_last_login) > 0) {

                $user_last_login_datetime = Database::fetch_array($result_last_login);

                $user_last_login_datetime = $user_last_login_datetime[0];

                Session::write('user_last_login_datetime', $user_last_login_datetime);

            }

        }

    }

} else {

    // Only if login form was not sent because if the form is sent the user was already on the page.

                ORDER BY version DESC

                LIMIT 1 ";

        $result = Database::query($sql);

        if (Database::num_rows($result)>0){

            $version = Database::fetch_array($result);

            $version = explode(':',$version[0]);

            return $version[0];

        } else {

            return false;

        }

	}

	/**

                $group_table = Database::get_course_table(TABLE_GROUP);

                $sql = "SELECT * FROM $group_table WHERE c_id = " . $_course['real_id'] . " AND id = '$group_id'";

                $result = Database::query($sql);

                if (Database::num_rows($result) > 0) { // This group has recorded status related to this course

                    $gpData = Database::fetch_array($result);

                    $_gid = $gpData ['id'];

                    Session::write('_gid', $_gid);

                } else {

                    Session::erase('_gid');

                }

            } elseif (isset($_SESSION['_gid']) or isset($_gid)) { // Keys missing => not anymore in the group - course relation

                Session::erase('_gid');

            }

            }

            $result = Database::query($sql);

            if (Database::num_rows($result) > 0) {

                while ($row = Database::fetch_array($result)) {

                    $sql = "DELETE FROM $tbl_session_rel_user

                            WHERE

                                session_id = {$row['session_id']} AND

                                user_id = $userId AND

                                relation_type =" . SESSION_RELATION_TYPE_RRHH;

                    Database::query($sql);

                }

            }

        }

        // Inserting new sessions list.

            $sql .= $where;

            $result = Database::query($sql);

            if (Database::num_rows($result)) {

                if ($getCount) {

                    $row = Database::fetch_array($result);

                    return $row['count'];

                } else {

                    return Database::store_result($result, 'ASSOC');

                }

            }

        }

        return 0;

        }

        $res = Database::query($sql);

        if (Database::num_rows($res) > 0) {

            while ($row = Database::fetch_array($res, 'ASSOC')) {

                if (in_array($row['id'], $elements)) {

                    $data[] = $row;

                }

            }

        }

        return $data;

    }

                    login_date < '$date'

                ";

        $rs = Database::query($sql);

        if (Database::num_rows($rs) > 0) {

            if ($getCount) {

                $count = Database::fetch_array($rs);

                return $count['count'];

            }

            return Database::store_result($rs, 'ASSOC');

        }

        return false;

    }

 */

function get_config_param_from_db($param = '')

{

    if (($res = Database::query("SELECT * FROM settings_current WHERE variable = '$param'")) !== false) {

        if (Database::num_rows($res) > 0) {

            $row = Database::fetch_array($res);

            return $row['selected_value'];

        }

    }

    return null;

}