Zeile 11 | Zeile 11 |
---|
/** * Checks if a user with uid $uid exists in the database. *
|
/** * Checks if a user with uid $uid exists in the database. *
|
* @param int The uid to check for.
| * @param int $uid The uid to check for.
|
* @return boolean True when exists, false when not. */ function user_exists($uid)
| * @return boolean True when exists, false when not. */ function user_exists($uid)
|
Zeile 32 | Zeile 32 |
---|
/** * Checks if $username already exists in the database. *
|
/** * Checks if $username already exists in the database. *
|
* @param string The username for check for.
| * @param string $username The username for check for.
|
* @return boolean True when exists, false when not. */ function username_exists($username) {
|
* @return boolean True when exists, false when not. */ function username_exists($username) {
|
global $db;
| |
$options = array( 'username_method' => 2 );
|
$options = array( 'username_method' => 2 );
|
|
|
return (bool)get_user_by_username($username, $options);
|
return (bool)get_user_by_username($username, $options);
|
}
/**
| }
/**
|
* Checks a password with a supplied username. *
|
* Checks a password with a supplied username. *
|
* @param string The username of the user. * @param string The plain-text password.
| * @param string $username The username of the user. * @param string $password The plain-text password.
|
* @return boolean|array False when no match, array with user info when match. */ function validate_password_from_username($username, $password)
|
* @return boolean|array False when no match, array with user info when match. */ function validate_password_from_username($username, $password)
|
{ global $db, $mybb;
| { global $mybb;
|
$options = array(
|
$options = array(
|
'fields' => array('username', 'password', 'salt', 'loginkey', 'coppauser', 'usergroup'),
| 'fields' => '*',
|
'username_method' => $mybb->settings['username_method'], );
|
'username_method' => $mybb->settings['username_method'], );
|
|
|
$user = get_user_by_username($username, $options);
if(!$user['uid'])
|
$user = get_user_by_username($username, $options);
if(!$user['uid'])
|
{
| {
|
return false; }
|
return false; }
|
|
|
return validate_password_from_uid($user['uid'], $password, $user);
|
return validate_password_from_uid($user['uid'], $password, $user);
|
}
/**
| }
/**
|
* Checks a password with a supplied uid. *
|
* Checks a password with a supplied uid. *
|
* @param int The user id. * @param string The plain-text password. * @param string An optional user data array.
| * @param int $uid The user id. * @param string $password The plain-text password. * @param array $user An optional user data array.
|
* @return boolean|array False when not valid, user data array when valid. */ function validate_password_from_uid($uid, $password, $user = array())
| * @return boolean|array False when not valid, user data array when valid. */ function validate_password_from_uid($uid, $password, $user = array())
|
Zeile 89 | Zeile 87 |
---|
} if(!$user['password']) {
|
} if(!$user['password']) {
|
$query = $db->simple_select("users", "uid,username,password,salt,loginkey,usergroup", "uid='".(int)$uid."'"); $user = $db->fetch_array($query);
| $user = get_user($uid);
|
} if(!$user['salt']) { // Generate a salt for this user and assume the password stored in db is a plain md5 password
|
} if(!$user['salt']) { // Generate a salt for this user and assume the password stored in db is a plain md5 password
|
$user['salt'] = generate_salt(); $user['password'] = salt_password($user['password'], $user['salt']); $sql_array = array( "salt" => $user['salt'], "password" => $user['password'] ); $db->update_query("users", $sql_array, "uid='".$user['uid']."'");
| $password_fields = create_password($user['password'], false, $user); $db->update_query("users", $password_fields, "uid='".$user['uid']."'");
|
}
if(!$user['loginkey'])
| }
if(!$user['loginkey'])
|
Zeile 112 | Zeile 104 |
---|
); $db->update_query("users", $sql_array, "uid = ".$user['uid']); }
|
); $db->update_query("users", $sql_array, "uid = ".$user['uid']); }
|
if(salt_password(md5($password), $user['salt']) == $user['password'])
| if(verify_user_password($user, $password))
|
{ return $user;
|
{ return $user;
|
} else { return false; } }
/**
| } else { return false; } }
/**
|
* Updates a user's password. *
|
* Updates a user's password. *
|
* @param int The user's id. * @param string The md5()'ed password. * @param string (Optional) The salt of the user.
| * @param int $uid The user's id. * @param string $password The md5()'ed password. * @param string $salt (Optional) The salt of the user.
|
* @return array The new password.
|
* @return array The new password.
|
| * @deprecated deprecated since version 1.8.6 Please use other alternatives.
|
*/ function update_password($uid, $password, $salt="") { global $db, $plugins;
$newpassword = array();
|
*/ function update_password($uid, $password, $salt="") { global $db, $plugins;
$newpassword = array();
|
|
|
// If no salt was specified, check in database first, if still doesn't exist, create one if(!$salt) {
| // If no salt was specified, check in database first, if still doesn't exist, create one if(!$salt) {
|
Zeile 144 | Zeile 137 |
---|
if($user['salt']) { $salt = $user['salt'];
|
if($user['salt']) { $salt = $user['salt'];
|
}
| }
|
else { $salt = generate_salt();
| else { $salt = generate_salt();
|
Zeile 153 | Zeile 146 |
---|
}
// Create new password based on salt
|
}
// Create new password based on salt
|
$saltedpw = salt_password($password, $salt);
| $saltedpw = salt_password($password, $salt);
|
// Generate new login key $loginkey = generate_loginkey();
| // Generate new login key $loginkey = generate_loginkey();
|
Zeile 162 | Zeile 155 |
---|
$newpassword['password'] = $saltedpw; $newpassword['loginkey'] = $loginkey; $db->update_query("users", $newpassword, "uid='$uid'");
|
$newpassword['password'] = $saltedpw; $newpassword['loginkey'] = $loginkey; $db->update_query("users", $newpassword, "uid='$uid'");
|
|
|
$plugins->run_hooks("password_changed");
return $newpassword;
| $plugins->run_hooks("password_changed");
return $newpassword;
|
Zeile 171 | Zeile 164 |
---|
/** * Salts a password based on a supplied salt. *
|
/** * Salts a password based on a supplied salt. *
|
* @param string The md5()'ed password. * @param string The salt.
| * @param string $password The md5()'ed password. * @param string $salt The salt.
|
* @return string The password hash.
|
* @return string The password hash.
|
| * @deprecated deprecated since version 1.8.9 Please use other alternatives.
|
*/ function salt_password($password, $salt) {
| */ function salt_password($password, $salt) {
|
Zeile 181 | Zeile 175 |
---|
}
/**
|
}
/**
|
* Generates a random salt
| * Salts a password based on a supplied salt. * * @param string $password The input password. * @param string $salt (Optional) The salt used by the MyBB algorithm. * @param string $user (Optional) An array containing password-related data. * @return array Password-related fields. */ function create_password($password, $salt = false, $user = false) { global $plugins;
$fields = null;
$parameters = compact('password', 'salt', 'user', 'fields');
if(!defined('IN_INSTALL') && !defined('IN_UPGRADE')) { $plugins->run_hooks('create_password', $parameters); }
if(!is_null($parameters['fields'])) { $fields = $parameters['fields']; } else { if(!$salt) { $salt = generate_salt(); }
$hash = md5(md5($salt).md5($password));
$fields = array( 'salt' => $salt, 'password' => $hash, ); }
return $fields; }
/** * Compares user's password data against provided input. * * @param array $user An array containing password-related data. * @param string $password The plain-text input password. * @return bool Result of the comparison. */ function verify_user_password($user, $password) { global $plugins;
$result = null;
$parameters = compact('user', 'password', 'result');
if(!defined('IN_INSTALL') && !defined('IN_UPGRADE')) { $plugins->run_hooks('verify_user_password', $parameters); }
if(!is_null($parameters['result'])) { return $parameters['result']; } else { $password_fields = create_password($password, $user['salt'], $user);
return my_hash_equals($user['password'], $password_fields['password']); } }
/** * Performs a timing attack safe string comparison. * * @param string $known_string The first string to be compared. * @param string $user_string The second, user-supplied string to be compared. * @return bool Result of the comparison. */ function my_hash_equals($known_string, $user_string) { if(version_compare(PHP_VERSION, '5.6.0', '>=')) { return hash_equals($known_string, $user_string); } else { $known_string_length = my_strlen($known_string); $user_string_length = my_strlen($user_string);
if($user_string_length != $known_string_length) { return false; }
$result = 0;
for($i = 0; $i < $known_string_length; $i++) { $result |= ord($known_string[$i]) ^ ord($user_string[$i]); }
return $result === 0; } }
/** * Generates a random salt
|
* * @return string The salt. */
| * * @return string The salt. */
|
Zeile 198 | Zeile 301 |
---|
function generate_loginkey() { return random_str(50);
|
function generate_loginkey() { return random_str(50);
|
}
/**
| }
/**
|
* Updates a user's salt in the database (does not update a password). *
|
* Updates a user's salt in the database (does not update a password). *
|
* @param int The uid of the user to update.
| * @param int $uid The uid of the user to update.
|
* @return string The new salt. */ function update_salt($uid)
| * @return string The new salt. */ function update_salt($uid)
|
Zeile 217 | Zeile 320 |
---|
$db->update_query("users", $sql_array, "uid='{$uid}'");
return $salt;
|
$db->update_query("users", $sql_array, "uid='{$uid}'");
return $salt;
|
}
/**
| }
/**
|
* Generates a new login key for a user. *
|
* Generates a new login key for a user. *
|
* @param int The uid of the user to update.
| * @param int $uid The uid of the user to update.
|
* @return string The new login key. */ function update_loginkey($uid)
| * @return string The new login key. */ function update_loginkey($uid)
|
Zeile 238 | Zeile 341 |
---|
return $loginkey;
}
|
return $loginkey;
}
|
|
|
/** * Adds a thread to a user's thread subscription list. * If no uid is supplied, the currently logged in user's id will be used. *
|
/** * Adds a thread to a user's thread subscription list. * If no uid is supplied, the currently logged in user's id will be used. *
|
* @param int The tid of the thread to add to the list. * @param int (Optional) The type of notification to receive for replies (0=none, 1=email, 2=pm) * @param int (Optional) The uid of the user who's list to update.
| * @param int $tid The tid of the thread to add to the list. * @param int $notification (Optional) The type of notification to receive for replies (0=none, 1=email, 2=pm) * @param int $uid (Optional) The uid of the user who's list to update.
|
* @return boolean True when success, false when otherwise. */
|
* @return boolean True when success, false when otherwise. */
|
function add_subscribed_thread($tid, $notification=1, $uid="")
| function add_subscribed_thread($tid, $notification=1, $uid=0)
|
{ global $mybb, $db;
|
{ global $mybb, $db;
|
if(!$uid) {
| if(!$uid) {
|
$uid = $mybb->user['uid']; }
if(!$uid) {
|
$uid = $mybb->user['uid']; }
if(!$uid) {
|
return;
| return false;
|
}
$query = $db->simple_select("threadsubscriptions", "*", "tid='".(int)$tid."' AND uid='".(int)$uid."'");
| }
$query = $db->simple_select("threadsubscriptions", "*", "tid='".(int)$tid."' AND uid='".(int)$uid."'");
|
Zeile 270 | Zeile 373 |
---|
'uid' => (int)$uid, 'tid' => (int)$tid, 'notification' => (int)$notification,
|
'uid' => (int)$uid, 'tid' => (int)$tid, 'notification' => (int)$notification,
|
'dateline' => TIME_NOW, 'subscriptionkey' => md5(TIME_NOW.$uid.$tid)
| 'dateline' => TIME_NOW
|
); $db->insert_query("threadsubscriptions", $insert_array); }
| ); $db->insert_query("threadsubscriptions", $insert_array); }
|
Zeile 281 | Zeile 382 |
---|
// Subscription exists - simply update notification $update_array = array( "notification" => (int)$notification
|
// Subscription exists - simply update notification $update_array = array( "notification" => (int)$notification
|
);
| );
|
$db->update_query("threadsubscriptions", $update_array, "uid='{$uid}' AND tid='{$tid}'"); } return true;
| $db->update_query("threadsubscriptions", $update_array, "uid='{$uid}' AND tid='{$tid}'"); } return true;
|
Zeile 289 | Zeile 390 |
---|
/** * Remove a thread from a user's thread subscription list.
|
/** * Remove a thread from a user's thread subscription list.
|
* If no uid is supplied, the currently logged in user's id will be used. * * @param int The tid of the thread to remove from the list. * @param int (Optional) The uid of the user who's list to update. * @return boolean True when success, false when otherwise. */ function remove_subscribed_thread($tid, $uid="") { global $mybb, $db;
if(!$uid) { $uid = $mybb->user['uid']; }
| * If no uid is supplied, the currently logged in user's id will be used. * * @param int $tid The tid of the thread to remove from the list. * @param int $uid (Optional) The uid of the user who's list to update. * @return boolean True when success, false when otherwise. */ function remove_subscribed_thread($tid, $uid=0) { global $mybb, $db;
if(!$uid) { $uid = $mybb->user['uid']; }
|
if(!$uid) {
|
if(!$uid) {
|
return;
| return false;
|
} $db->delete_query("threadsubscriptions", "tid='".$tid."' AND uid='{$uid}'");
|
} $db->delete_query("threadsubscriptions", "tid='".$tid."' AND uid='{$uid}'");
|
return true; }
/**
| return true; }
/**
|
* Adds a forum to a user's forum subscription list.
|
* Adds a forum to a user's forum subscription list.
|
* If no uid is supplied, the currently logged in user's id will be used. * * @param int The fid of the forum to add to the list. * @param int (Optional) The uid of the user who's list to update. * @return boolean True when success, false when otherwise. */ function add_subscribed_forum($fid, $uid="") { global $mybb, $db;
if(!$uid) {
| * If no uid is supplied, the currently logged in user's id will be used. * * @param int $fid The fid of the forum to add to the list. * @param int $uid (Optional) The uid of the user who's list to update. * @return boolean True when success, false when otherwise. */ function add_subscribed_forum($fid, $uid=0) { global $mybb, $db;
if(!$uid) {
|
$uid = $mybb->user['uid']; }
if(!$uid) {
|
$uid = $mybb->user['uid']; }
if(!$uid) {
|
return;
| return false;
|
}
$fid = (int)$fid;
| }
$fid = (int)$fid;
|
Zeile 356 | Zeile 457 |
---|
* Removes a forum from a user's forum subscription list. * If no uid is supplied, the currently logged in user's id will be used. *
|
* Removes a forum from a user's forum subscription list. * If no uid is supplied, the currently logged in user's id will be used. *
|
* @param int The fid of the forum to remove from the list. * @param int (Optional) The uid of the user who's list to update.
| * @param int $fid The fid of the forum to remove from the list. * @param int $uid (Optional) The uid of the user who's list to update.
|
* @return boolean True when success, false when otherwise. */
|
* @return boolean True when success, false when otherwise. */
|
function remove_subscribed_forum($fid, $uid="")
| function remove_subscribed_forum($fid, $uid=0)
|
{ global $mybb, $db;
|
{ global $mybb, $db;
|
if(!$uid) {
| if(!$uid) {
|
$uid = $mybb->user['uid'];
|
$uid = $mybb->user['uid'];
|
}
| }
|
if(!$uid) {
|
if(!$uid) {
|
return;
| return false;
|
} $db->delete_query("forumsubscriptions", "fid='".$fid."' AND uid='{$uid}'");
return true;
|
} $db->delete_query("forumsubscriptions", "fid='".$fid."' AND uid='{$uid}'");
return true;
|
}
| }
|
/** * Constructs the usercp navigation menu.
| /** * Constructs the usercp navigation menu.
|
Zeile 385 | Zeile 486 |
---|
function usercp_menu() { global $mybb, $templates, $theme, $plugins, $lang, $usercpnav, $usercpmenu;
|
function usercp_menu() { global $mybb, $templates, $theme, $plugins, $lang, $usercpnav, $usercpmenu;
|
|
|
$lang->load("usercpnav");
|
$lang->load("usercpnav");
|
|
|
// Add the default items as plugins with separated priorities of 10
|
// Add the default items as plugins with separated priorities of 10
|
if($mybb->settings['enablepms'] != 0) {
| if($mybb->settings['enablepms'] != 0 && $mybb->usergroup['canusepms'] == 1) {
|
$plugins->add_hook("usercp_menu", "usercp_menu_messenger", 10);
|
$plugins->add_hook("usercp_menu", "usercp_menu_messenger", 10);
|
}
| }
|
|
|
$plugins->add_hook("usercp_menu", "usercp_menu_profile", 20); $plugins->add_hook("usercp_menu", "usercp_menu_misc", 30);
| if($mybb->usergroup['canusercp'] == 1) { $plugins->add_hook("usercp_menu", "usercp_menu_profile", 20); $plugins->add_hook("usercp_menu", "usercp_menu_misc", 30); }
|
// Run the plugin hooks $plugins->run_hooks("usercp_menu"); global $usercpmenu;
|
// Run the plugin hooks $plugins->run_hooks("usercp_menu"); global $usercpmenu;
|
| if($mybb->usergroup['canusercp'] == 1) { eval("\$ucp_nav_home = \"".$templates->get("usercp_nav_home")."\";"); }
|
eval("\$usercpnav = \"".$templates->get("usercp_nav")."\";");
| eval("\$usercpnav = \"".$templates->get("usercp_nav")."\";");
|
Zeile 412 | Zeile 521 |
---|
*/ function usercp_menu_messenger() {
|
*/ function usercp_menu_messenger() {
|
global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapsed, $collapsedimg;
| global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapse, $collapsed, $collapsedimg;
|
|
|
| $expaltext = (in_array("usercppms", $collapse)) ? "[+]" : "[-]";
|
$usercp_nav_messenger = $templates->get("usercp_nav_messenger"); // Hide tracking link if no permission $tracking = '';
| $usercp_nav_messenger = $templates->get("usercp_nav_messenger"); // Hide tracking link if no permission $tracking = '';
|
Zeile 443 | Zeile 553 |
---|
else if($folderlinks) { $class = "usercp_nav_sub_pmfolder";
|
else if($folderlinks) { $class = "usercp_nav_sub_pmfolder";
|
}
| }
|
else { $class = "usercp_nav_pmfolder";
| else { $class = "usercp_nav_pmfolder";
|
Zeile 461 | Zeile 571 |
---|
}
if(!isset($collapsed['usercppms_e']))
|
}
if(!isset($collapsed['usercppms_e']))
|
{
| {
|
$collapsed['usercppms_e'] = ''; }
|
$collapsed['usercppms_e'] = ''; }
|
|
|
eval("\$usercpmenu .= \"".$usercp_nav_messenger."\";"); }
/** * Constructs the usercp profile menu.
|
eval("\$usercpmenu .= \"".$usercp_nav_messenger."\";"); }
/** * Constructs the usercp profile menu.
|
*
| *
|
*/ function usercp_menu_profile() {
|
*/ function usercp_menu_profile() {
|
global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapsed, $collapsedimg;
| global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapse, $collapsed, $collapsedimg;
|
$changenameop = ''; if($mybb->usergroup['canchangename'] != 0) { eval("\$changenameop = \"".$templates->get("usercp_nav_changename")."\";");
|
$changenameop = ''; if($mybb->usergroup['canchangename'] != 0) { eval("\$changenameop = \"".$templates->get("usercp_nav_changename")."\";");
|
}
| }
|
$changesigop = ''; if($mybb->usergroup['canusesig'] == 1 && ($mybb->usergroup['canusesigxposts'] == 0 || $mybb->usergroup['canusesigxposts'] > 0 && $mybb->user['postnum'] > $mybb->usergroup['canusesigxposts']))
| $changesigop = ''; if($mybb->usergroup['canusesig'] == 1 && ($mybb->usergroup['canusesigxposts'] == 0 || $mybb->usergroup['canusesigxposts'] > 0 && $mybb->user['postnum'] > $mybb->usergroup['canusesigxposts']))
|
Zeile 489 | Zeile 599 |
---|
{ eval("\$changesigop = \"".$templates->get("usercp_nav_editsignature")."\";"); }
|
{ eval("\$changesigop = \"".$templates->get("usercp_nav_editsignature")."\";"); }
|
}
| }
|
if(!isset($collapsedimg['usercpprofile'])) {
| if(!isset($collapsedimg['usercpprofile'])) {
|
Zeile 501 | Zeile 611 |
---|
$collapsed['usercpprofile_e'] = ''; }
|
$collapsed['usercpprofile_e'] = ''; }
|
| $expaltext = (in_array("usercpprofile", $collapse)) ? "[+]" : "[-]";
|
eval("\$usercpmenu .= \"".$templates->get("usercp_nav_profile")."\";"); }
| eval("\$usercpmenu .= \"".$templates->get("usercp_nav_profile")."\";"); }
|
Zeile 510 | Zeile 621 |
---|
*/ function usercp_menu_misc() {
|
*/ function usercp_menu_misc() {
|
global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapsed, $collapsedimg;
| global $db, $mybb, $templates, $theme, $usercpmenu, $lang, $collapse, $collapsed, $collapsedimg;
|
$draftstart = $draftend = ''; $draftcount = $lang->ucp_nav_drafts;
$query = $db->simple_select("posts", "COUNT(pid) AS draftcount", "visible = '-2' AND uid = '{$mybb->user['uid']}'"); $count = $db->fetch_field($query, 'draftcount');
|
$draftstart = $draftend = ''; $draftcount = $lang->ucp_nav_drafts;
$query = $db->simple_select("posts", "COUNT(pid) AS draftcount", "visible = '-2' AND uid = '{$mybb->user['uid']}'"); $count = $db->fetch_field($query, 'draftcount');
|
|
|
if($count > 0) { $draftcount = $lang->sprintf($lang->ucp_nav_drafts_active, my_number_format($count));
| if($count > 0) { $draftcount = $lang->sprintf($lang->ucp_nav_drafts_active, my_number_format($count));
|
Zeile 539 | Zeile 650 |
---|
}
$profile_link = get_profile_link($mybb->user['uid']);
|
}
$profile_link = get_profile_link($mybb->user['uid']);
|
| $expaltext = (in_array("usercpmisc", $collapse)) ? "[+]" : "[-]";
|
eval("\$usercpmenu .= \"".$templates->get("usercp_nav_misc")."\";"); }
/** * Gets the usertitle for a specific uid. *
|
eval("\$usercpmenu .= \"".$templates->get("usercp_nav_misc")."\";"); }
/** * Gets the usertitle for a specific uid. *
|
* @param int The uid of the user to get the usertitle of.
| * @param int $uid The uid of the user to get the usertitle of.
|
* @return string The usertitle of the user. */
|
* @return string The usertitle of the user. */
|
function get_usertitle($uid="")
| function get_usertitle($uid=0)
|
{ global $db, $mybb;
| { global $db, $mybb;
|
Zeile 574 | Zeile 686 |
---|
if($title['posts'] <= $user['postnum']) { $usertitle = $title;
|
if($title['posts'] <= $user['postnum']) { $usertitle = $title;
|
| break;
|
} }
| } }
|
Zeile 584 | Zeile 697 |
---|
/** * Updates a users private message count in the users table with the number of pms they have. *
|
/** * Updates a users private message count in the users table with the number of pms they have. *
|
* @param int The user id to update the count for. If none, assumes currently logged in user. * @param int Bitwise value for what to update. 1 = total, 2 = new, 4 = unread. Combinations accepted. * @param int The unix timestamp the user with uid last visited. If not specified, will be queried.
| * @param int $uid The user id to update the count for. If none, assumes currently logged in user. * @param int $count_to_update Bitwise value for what to update. 1 = total, 2 = new, 4 = unread. Combinations accepted. * @return array The updated counters
|
*/ function update_pm_count($uid=0, $count_to_update=7) {
| */ function update_pm_count($uid=0, $count_to_update=7) {
|
Zeile 631 | Zeile 744 |
---|
/** * Return the language specific name for a PM folder. *
|
/** * Return the language specific name for a PM folder. *
|
* @param int The ID of the folder. * @param string The folder name - can be blank, will use language default.
| * @param int $fid The ID of the folder. * @param string $name The folder name - can be blank, will use language default.
|
* @return string The name of the folder. */ function get_pm_folder_name($fid, $name="")
| * @return string The name of the folder. */ function get_pm_folder_name($fid, $name="")
|
Zeile 666 | Zeile 779 |
---|
/** * Generates a security question for registration. *
|
/** * Generates a security question for registration. *
|
| * @param int $old_qid Optional ID of the old question.
|
* @return string The question session id. */
|
* @return string The question session id. */
|
function generate_question()
| function generate_question($old_qid=0)
|
{ global $db;
|
{ global $db;
|
$query = $db->query(" SELECT qid, shown FROM ".TABLE_PREFIX."questions WHERE active='1' ORDER BY RAND() LIMIT 1 ");
| if($db->type == 'pgsql' || $db->type == 'sqlite') { $order_by = 'RANDOM()'; } else { $order_by = 'RAND()'; } if($old_qid) { $excl_old = ' AND qid != '.(int)$old_qid; }
$query = $db->simple_select('questions', 'qid, shown', "active=1{$excl_old}", array('limit' => 1, 'order_by' => $order_by));
|
$question = $db->fetch_array($query);
if(!$db->num_rows($query))
| $question = $db->fetch_array($query);
if(!$db->num_rows($query))
|
Zeile 709 | Zeile 831 |
---|
/** * Check whether we can show the Purge Spammer Feature *
|
/** * Check whether we can show the Purge Spammer Feature *
|
* @param int The users post count * @param int The usergroup of our user * @param int The uid of our user
| * @param int $post_count The users post count * @param int $usergroup The usergroup of our user * @param int $uid The uid of our user
|
* @return boolean Whether or not to show the feature */ function purgespammer_show($post_count, $usergroup, $uid)
| * @return boolean Whether or not to show the feature */ function purgespammer_show($post_count, $usergroup, $uid)
|