<?php

    if ( !defined('SQL_INCLUDED') ) {
        die('This file does not have its required defined scripts. Exiting.');
    }

    // $logged_in info
    if ( !$logged_in ) {
        return;
    }

    // Handle the setting of default values
    $get_preferences = $local_conn->query('
        SELECT
            `pref_name`, `pref_value`
        FROM
            `user_prefs`
        WHERE
            `userid` = "' . $session_info['userid'] . '"
    ');

    $__PREF_LIST = array();
    if ( $local_conn->num_rows($get_preferences) ) {
        while ( $r = $local_conn->fetch_assoc($get_preferences) ) {
            array_push($__PREF_LIST, $r);
        }
    }

    $get_preference_value = function($key, $list) {
        $value = null;

        if ( !is_array($list) || count($list) == 0 ) {
            return false;
        }

        for ( $i = 0; $i < count($list); $i += 1 ) {
            if ( $list[$i]['pref_name'] == $key ) {
                $value = $list[$i]['pref_value'];
                break;
            }
        }

        return isset($value) ? $value : false;
    };

    unset($r, $get_preferences);

?>