-<?php

-/***************************************************************************

- * functions.php

- * -------------------

- * begin : Saturday, Feb 13, 2001

- * copyright : (C) 2001 The phpBB Group

- * email : support@phpbb.com

- *

- * $Id$

- *

- *

- ***************************************************************************/

-

-

-/***************************************************************************

- *

- * This program is free software; you can redistribute it and/or modify

- * it under the terms of the GNU General Public License as published by

- * the Free Software Foundation; either version 2 of the License, or

- * (at your option) any later version.

- *

- *

- ***************************************************************************/

-

-function get_db_stat($db, $mode)

-{

- switch($mode){

- case 'postcount':

- $sql = 'SELECT count(*) AS total FROM '.POSTS_TABLE;

- break;

-

- case 'usercount':

- $sql = 'SELECT count(*) AS total

- FROM '. USERS_TABLE .'

- WHERE user_id != '.ANONYMOUS.'

- AND user_level != '.DELETED;

- break;

-

- case 'newestuser':

- $sql = 'SELECT user_id, username

- FROM '.USERS_TABLE.'

- WHERE user_id != ' . ANONYMOUS. '

- AND user_level != '. DELETED .'

- ORDER BY user_id DESC LIMIT 1';

- break;

-

- case 'usersonline':

- $sql = "SELECT COUNT(*) AS online FROM ".SESSIONS_TABLE;

- break;

- }

-

-

- if(!$result = $db->sql_query($sql))

- {

- return 'ERROR';

- }

- else

- {

- $row = $db->sql_fetchrow($result);

- if($mode == 'newestuser')

- {

- return($row);

- }

- else if($mode == "usersonline")

- {

- return ($row['online']);

- }

- else

- {

- return($row['total']);

- }

- }

-}

-

-

-function make_jumpbox($db)

-{

- global $l_jumpto, $l_noforums, $l_nocategories;

-

- $sql = "SELECT c.*

- FROM ".CATEGORIES_TABLE." c, ".FORUMS_TABLE." f

- WHERE f.cat_id = c.cat_id

- GROUP BY c.cat_id, c.cat_title, c.cat_order

- ORDER BY c.cat_order";

- if(!$q_categories = $db->sql_query($sql))

- {

- $db_error = $db->sql_error();

- error_die(SQL_QUERY, "Couldn't obtain category list.", __LINE__, __FILE__);

- }

-

- $total_categories = $db->sql_numrows();

- if($total_categories)

- {

- $category_rows = $db->sql_fetchrowset($q_categories);

-

- $limit_forums = "";

-

- $sql = "SELECT *

- FROM ".FORUMS_TABLE."

- ORDER BY cat_id, forum_order";

- if(!$q_forums = $db->sql_query($sql))

- {

- error_die(SQL_QUERY, "Couldn't obtain forums information.", __LINE__, __FILE__);

- }

- $total_forums = $db->sql_numrows($q_forums);

- $forum_rows = $db->sql_fetchrowset($q_forums);

-

- $boxstring = '';

- for($i = 0; $i < $total_categories; $i++)

- {

- $boxstring .= "<option value=\"-1\">&nbsp;</option>\n";

- $boxstring .= "<option value=\"-1\">".stripslashes($category_rows[$i]["cat_title"])."</OPTION>\n";

- $boxstring .= "<option value=\"-1\">----------------</OPTION>\n";

-

- if($total_forums)

- {

- for($y = 0; $y < $total_forums; $y++)

- {

- if( $forum_rows[$y]["cat_id"] == $category_rows[$i]["cat_id"] )

- {

- $name = stripslashes($forum_rows[$y]["forum_name"]);

- $boxstring .= "<option value=\"".$forum_rows[$y]["forum_id"]."\">$name</OPTION>\n";

- }

- }

- }

- else

- {

- $boxstring .= "<option value=\"-1\">-- ! No Forums ! --</option>\n";

- }

- }

- }

- else

- {

- $boxstring .= "<option value=\"-1\">-- ! No Categories ! --</option>\n";

- }

-

- return($boxstring);

-}

-

-function language_select($default, $name="language", $dirname="language/")

-{

- global $phpEx;

- $dir = opendir($dirname);

- $lang_select = "<select name=\"$name\">\n";

- while ($file = readdir($dir))

- {

- if (ereg("^lang_", $file))

- {

- $file = str_replace("lang_", "", $file);

- $file = str_replace(".$phpEx", "", $file);

- $file == $default ? $selected = " SELECTED" : $selected = "";

- $lang_select .= " <option$selected>$file\n";

- }

- }

- $lang_select .= "</select>\n";

- closedir($dir);

- return $lang_select;

-}

-

-function theme_select($default, $db)

-{

- $sql = "SELECT theme_id, theme_name FROM ".THEMES_TABLE." ORDER BY theme_name";

- if($result = $db->sql_query($sql))

- {

- $num = $db->sql_numrows($result);

- $rowset = $db->sql_fetchrowset($result);

- $theme_select = "<select name=\"theme\">\n";

- for($i = 0; $i < $num; $i++)

- {

- if((stripslashes($rowset[$i]["theme_name"]) == $default) || ($rowset[$i]["theme_id"] == $default))

- {

- $selected = " SELECTED";

- }

- else

- {

- $selected = "";

- }

- $theme_select .= "\t<option value=\"".$rowset[$i]["theme_id"]."\"$selected>".stripslashes($rowset[$i]["theme_name"])."</option>\n";

- }

- $theme_select .= "</select>\n";

- }

- else

- {

- $theme_select = "<select name=\"theme\"><option value=\"-1\">Error in theme_select</option></select>";

- }

- return($theme_select);

-}

-

-//

-// Initialise user settings on page load

-//

-function init_userprefs($userdata)

-{

-

- global $override_user_theme;

- global $bgcolor, $table_bgcolor, $textcolor, $category_title, $table_header;

- global $color1, $color2, $header_image, $newtopic_image;

- global $reply_locked_image, $reply_image, $linkcolor, $vlinkcolor;

- global $default_lang, $date_format, $sys_timezone;

-

- if(!$override_user_theme)

- {

- if($userdata['user_id'] != ANONYMOUS || $userdata['user_id'] != DELETED)

- {

- $theme = setuptheme($userdata["user_theme"]);

- }

- else

- {

- $theme = setuptheme($default_theme);

- }

- }

- else

- {

- $theme = setuptheme($override_user_theme);

- }

- if($theme)

- {

- $bgcolor = $theme["bgcolor"];

- $table_bgcolor = $theme["table_bgcolor"];

- $textcolor = $theme["textcolor"];

- $category_title = $theme["category_title"];

- $table_header = $theme["table_header"];

- $color1 = $theme["color1"];

- $color2 = $theme["color2"];

- $header_image = $theme["header_image"];

- $newtopic_image = $theme["newtopic_image"];

- $reply_locked_image = $theme["reply_locked_image"];

- $reply_image = $theme["reply_image"];

- $linkcolor = $theme["linkcolor"];

- $vlinkcolor = $theme["vlinkcolor"];

- }

- if($userdata["user_lang"] != "")

- {

- $default_lang = $userdata["user_lang"];

- }

- if($userdata["user_dateformat"] != "")

- {

- $date_format = $userdata["user_dateformat"];

- }

- if($userdata["user_timezone"])

- {

- $sys_timezone = $userdata["user_timezone"];

- }

-

- // Include the appropriate language file ... if it exists.

- if(!strstr($PHP_SELF, "admin"))

- {

- if(file_exists('language/lang_'.$default_lang.'.'.$phpEx))

- {

- include('language/lang_'.$default_lang.'.'.$phpEx);

- }

- }

- else

- {

- if(strstr($PHP_SELF, "topicadmin"))

- {

- include('language/lang_'.$default_lang.'.'.$phpEx);

- }

- else

- {

- include('../language/lang_'.$default_lang.'.'.$phpEx);

- }

- }

-

- return;

-

-}

-function setuptheme($theme)

-{

- global $db;

-

- $sql = "SELECT *

- FROM ".THEMES_TABLE."

- WHERE theme_id = '$theme'";

- if(!$result = $db->sql_query($sql))

- return(0);

-

- if(!$myrow = $db->sql_fetchrow($result))

- return(0);

-

- return($myrow);

-}

-

-function tz_select($default)

-{

- global $board_tz;

- if(!isset($default))

- {

- $default == $board_tz;

- }

- $tz_select = "<select name=\"timezone\">";

- $tz_array = array(

- "-12" => "(GMT -12:00 hours) Eniwetok, Kwajalein",

- "-11" => "(GMT -11:00 hours) Midway Island, Samoa",

- "-10" => "(GMT -10:00 hours) Hawaii",

- "-9" => "(GMT -9:00 hours) Alaska",

- "-8" => "(GMT -8:00 hours) Pacific Time (US & Canada)",

- "-7" => "(GMT -7:00 hours) Mountain Time (US & Canada)",

- "-6" => "(GMT -6:00 hours) Central Time (US & Canada), Mexico City",

- "-5" => "(GMT -5:00 hours) Eastern Time (US & Canada), Bogota, Lima, Quito",

- "-4" => "(GMT -4:00 hours) Atlantic Time (Canada), Caracas, La Paz",

- "-3.5" => "(GMT -3:30 hours) Newfoundland",

- "-3" => "(GMT -3:00 hours) Brazil, Buenos Aires, Georgetown",

- "-2" => "(GMT -2:00 hours) Mid-Atlantic, Ascension Is., St. Helena, ",

- "-1" => "(GMT -1:00 hours) Azores, Cape Verde Islands",

- "0" => "(GMT) Casablanca, Dublin, Edinburgh, London, Lisbon, Monrovia",

- "+1" => "(GMT +1:00 hours) CET, Berlin, Brussels, Copenhagen, Madrid, Paris, Rome",

- "+2" => "(GMT +2:00 hours) EET, Kaliningrad, South Africa, Warsaw",

- "+3" => "(GMT +3:00 hours) Baghdad, Kuwait, Riyadh, Moscow, St. Petersburg, Volgograd, Nairobi",

- "+3.5" => "(GMT +3:30 hours) Tehran",

- "+4" => "(GMT +4:00 hours) Abu Dhabi, Baku, Muscat, Tbilisi",

- "+4.5" => "(GMT +4:30 hours) Kabul",

- "+5" => "(GMT +5:00 hours) Ekaterinburg, Islamabad, Karachi, Tashkent",

- "+5.5" => "(GMT +5:30 hours) Bombay, Calcutta, Madras, New Delhi",

- "+6" => "(GMT +6:00 hours) Almaty, Colombo, Dhaka",

- "+7" => "(GMT +7:00 hours) Bangkok, Hanoi, Jakarta",

- "+8" => "(GMT +8:00 hours) Beijing, Perth, Singapore, Hong Kong, Chongqing, Urumqi, Taipei",

- "+9" => "(GMT +9:00 hours) Tokyo, Seoul, Osaka, Sapporo, Yakutsk",

- "+9.5" => "(GMT +9:30 hours) Adelaide, Darwin",

- "+10" => "(GMT +10:00 hours) EAST (East Australian Standard), Guam, Papua New Guinea, Vladivostok",

- "+11" => "(GMT +11:00 hours) Magadan, Solomon Islands, New Caledonia",

- "+12" => "(GMT +12:00 hours) Auckland, Wellington, Fiji, Kamchatka, Marshall Island");

-

- while(list($offset, $zone) = each($tz_array))

- {

- if($offset == $default)

- {

- $selected = " SELECTED";

- }

- else

- {

- $selected = "";

- }

- $tz_select .= "\t<option value=\"$offset\"$selected>$zone</option>\n";

- }

- $tz_select .= "</select>\n";

- return($tz_select);

-}

-

-function validate_username(&$username, $db)

-{

- $username = trim($username);

- $username = strip_tags($username);

- $username = htmlspecialchars($username);

- if(empty($username))

- {

- return(FALSE);

- }

-

- $valid_name = TRUE;

- $sql = "SELECT LOWER(username) FROM ".USERS_TABLE." WHERE username = '$username'";

- if($result = $db->sql_query($sql))

- {

- if( ($numrows = $db->sql_numrows($result) ) > 0)

- {

- $valid_name = FALSE;

- }

- }

-

- $sql = "SELECT disallow_username FROM ".DISALLOW_TABLE." WHERE disallow_username = '$username'";

- if($result = $db->sql_query($sql))

- {

- if(($numrows = $db->sql_numrows($result)) > 0)

- {

- $valid_name = FALSE;

- }

- }

-

- return($valid_name);

-}

-function generate_activation_key()

-{

- $chars = array(

- "a","A","b","B","c","C","d","D","e","E","f","F","g","G","h","H","i","I","j","J",

- "k","K","l","L","m","M","n","N","o","O","p","P","q","Q","r","R","s","S","t","T",

- "u","U","v","V","w","W","x","X","y","Y","z","Z","1","2","3","4","5","6","7","8",

- "9","0"

- );

- $max_elements = count($chars) - 1;

- srand((double)microtime()*1000000);

- $act_key = $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key .= $chars[rand(0,$max_elements)];

- $act_key_md = md5($act_key);

-

- return($act_key_md);

-}

-

-function encode_ip($dotquad_ip)

-{

- $ip_sep = explode(".", $dotquad_ip);

- $return = sprintf("%02x%02x%02x%02x", $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);

-

- //return (( $ip_sep[0] * 0xFFFFFF + $ip_sep[0] ) + ( $ip_sep[1] * 0xFFFF + $ip_sep[1] ) + ( $ip_sep[2] * 0xFF + $ip_sep[2] ) + ( $ip_sep[3] ) );

- return($return);

-}

-

-function decode_ip($int_ip)

-{

- $hexipbang = explode(".",chunk_split($int_ip, 2, "."));

-

- return hexdec($hexipbang[0]).".".hexdec($hexipbang[1]).".".hexdec($hexipbang[2]).".".hexdec($hexipbang[3]);

-

- //return sprintf( "%d.%d.%d.%d", ( ( $int_ip >> 24 ) & 0xFF ), ( ( $int_ip >> 16 ) & 0xFF ), ( ( $int_ip >> 8 ) & 0xFF ), ( ( $int_ip ) & 0xFF ) );

-

-}

-

-//

-// Create date/time from format and timezone

-//

-function create_date($format, $gmepoch, $tz)

-{

- return (gmdate($format, $gmepoch + (3600 * $tz)));

-}

-?> \ No newline at end of file