/** * Refreshes the properties of the class * @param string $id_field Column to identify the user with * @param string $field_id Value of the identification column * @return void */ public function refreshCache($id_field, $field_id) { foreach (Sql::Query("SELECT * FROM accounts WHERE {$id_field} = '" . $field_id . "'") as $i) { foreach ($i as $key => $i2) { if (Text::validate($key, 'num')) { continue; } $this->{$key} = $i2; } } }
/** * Returns all the sitevars on the database * @return array Sitevars */ static function getVars() { $query = Sql::Query("SELECT * FROM sitevars"); if (!$query) { Kernel::Log('Could not retrieve sitevars.'); trigger_error('Could not retrieve sitevars.', E_USER_ERROR); return false; } foreach ($query as $reg) { $sitevars[$reg['name']] = $reg['value']; } return $sitevars; }
/** * Retrieves an user's certain info * @param string $id_field Name of the identification column * @param string $field Field we'll be fetching * @return mixed Returns the value of the column, returns false otherwise */ static function getUserInfo($id_field, $field) { if (self::userExists($id_field) < 1) { return false; } if (!Sql::hasColumns('accounts', array($field))) { return false; } $data = Sql::Query(array("table" => "accounts", "select" => $field, "where" => self::$id_field . "," . $id_field), true); return $data[$field]; }