r45phpbbmods-checkins Mailing List for R45s phpBB Mods
Brought to you by:
rasadam
Menu
▾
▴
r45phpbbmods-checkins — CVS checkins list
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
(12) |
Apr
(35) |
May
(10) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(6) |
Dec
(9) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Adam A. <ra...@us...> - 2005-01-21 13:21:46
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10784 Modified Files: INSTALL Log Message: Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** INSTALL 31 Dec 2004 13:14:49 -0000 1.11 --- INSTALL 21 Jan 2005 13:21:35 -0000 1.12 *************** *** 35,38 **** --- 35,40 ---- ## MOD History: ## + ## 2005// - Version 1.0.3 + ## - Fixed Yahoo searching bug ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) |
|
From: Adam A. <ra...@us...> - 2005-01-21 13:21:46
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10784/admin Modified Files: admin_user_search.php Log Message: Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** admin_user_search.php 31 Dec 2004 13:59:05 -0000 1.11 --- admin_user_search.php 21 Jan 2005 13:21:36 -0000 1.12 *************** *** 861,865 **** case 'yahoo': $text = sprintf($lang['Search_for_userfield_yahoo'],$text); ! $field = 'user_yahoo'; break; case 'website': --- 861,865 ---- case 'yahoo': $text = sprintf($lang['Search_for_userfield_yahoo'],$text); ! $field = 'user_yim'; break; case 'website': |
|
From: Adam A. <ra...@us...> - 2004-12-31 13:59:15
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv384/admin Modified Files: admin_user_search.php Log Message: Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** admin_user_search.php 31 Dec 2004 13:14:49 -0000 1.10 --- admin_user_search.php 31 Dec 2004 13:59:05 -0000 1.11 *************** *** 1150,1154 **** break; case 'lastvisit': ! $sort = 'user_lastvisit'; $select_sql .= "u.user_lastvisit"; --- 1150,1154 ---- break; case 'lastvisit': ! $sort = 'lastvisit'; $select_sql .= "u.user_lastvisit"; |
|
From: Adam A. <ra...@us...> - 2004-12-31 13:15:00
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22804/admin Modified Files: admin_user_search.php Log Message: Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** admin_user_search.php 31 Dec 2004 05:26:54 -0000 1.9 --- admin_user_search.php 31 Dec 2004 13:14:49 -0000 1.10 *************** *** 392,398 **** { case 'search_username': ! $base_url .= "&search_username=true&username=".rawurlencode($username); ! $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars($username))); if(!$regex) --- 392,398 ---- { case 'search_username': ! $base_url .= "&search_username=true&username=".rawurlencode(stripslashes($username)); ! $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars(stripslashes($username)))); if(!$regex) *************** *** 409,412 **** --- 409,416 ---- } } + else + { + $username = preg_replace('/\\\\\\\(?<!\'|"|NULL)/', '\\', $username); + } if($username == '') *************** *** 437,443 **** break; case 'search_email': ! $base_url .= "&search_email=true&email=".rawurlencode($email); ! $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars($email))); if(!$regex) --- 441,447 ---- break; case 'search_email': ! $base_url .= "&search_email=true&email=".rawurlencode(stripslashes($email)); ! $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars(stripslashes($email)))); if(!$regex) *************** *** 454,458 **** } } ! if($email == '') { --- 458,466 ---- } } ! else ! { ! $email = preg_replace('/\\\\\\\(?<!\'|"|NULL)/', '\\', $email); ! } ! if($email == '') { *************** *** 482,491 **** break; case 'search_ip': ! $base_url .= "&search_ip=true&ip_address=".rawurlencode($ip_address); // Remove any whitespace $ip_address = trim($ip_address); ! $text = sprintf($lang['Search_for_ip'], strip_tags(htmlspecialchars($ip_address))); unset($users); --- 490,499 ---- break; case 'search_ip': ! $base_url .= "&search_ip=true&ip_address=".rawurlencode(stripslashes($ip_address)); // Remove any whitespace $ip_address = trim($ip_address); ! $text = sprintf($lang['Search_for_ip'], strip_tags(htmlspecialchars(stripslashes($ip_address)))); unset($users); *************** *** 634,638 **** break; case 'search_joindate': ! $base_url .= "&search_joindate=true&date_type=".rawurlencode($date_type)."&date_day=".rawurlencode($date_day)."&date_month=".rawurlencode($date_month)."&date_year=".rawurlencode($date_year); $date_type = trim(strtolower($date_type)); --- 642,646 ---- break; case 'search_joindate': ! $base_url .= "&search_joindate=true&date_type=".rawurlencode($date_type)."&date_day=".rawurlencode($date_day)."&date_month=".rawurlencode($date_month)."&date_year=".rawurlencode(stripslashes($date_year)); $date_type = trim(strtolower($date_type)); *************** *** 664,668 **** } ! $text = sprintf($lang['Search_for_date'], strip_tags(htmlspecialchars($date_type)), $date_year, $date_month, $date_day); $time = mktime(0,0,0,$date_month, $date_day, $date_year); --- 672,676 ---- } ! $text = sprintf($lang['Search_for_date'], strip_tags(htmlspecialchars(stripslashes($date_type))), $date_year, $date_month, $date_day); $time = mktime(0,0,0,$date_month, $date_day, $date_year); *************** *** 731,735 **** $postcount_value = trim(strtolower($postcount_value)); ! $base_url .= "&search_postcount=true&postcount_type=".rawurlencode($postcount_type)."&postcount_value=".rawurlencode($postcount_value); switch($postcount_type) --- 739,743 ---- $postcount_value = trim(strtolower($postcount_value)); ! $base_url .= "&search_postcount=true&postcount_type=".rawurlencode($postcount_type)."&postcount_value=".rawurlencode(stripslashes($postcount_value)); switch($postcount_type) *************** *** 808,814 **** break; case 'search_userfield': ! $base_url .= "&search_userfield=true&userfield_type=".rawurlencode($userfield_type)."&userfield_value=".rawurlencode($userfield_value); ! $text = strip_tags(htmlspecialchars($userfield_value)); if(!$regex) --- 816,822 ---- break; case 'search_userfield': ! $base_url .= "&search_userfield=true&userfield_type=".rawurlencode($userfield_type)."&userfield_value=".rawurlencode(stripslashes($userfield_value)); ! $text = strip_tags(htmlspecialchars(stripslashes($userfield_value))); if(!$regex) *************** *** 825,828 **** --- 833,840 ---- } } + else + { + $userfield_value = preg_replace('/\\\\\\\(?<!\'|"|NULL)/', '\\', $userfield_value); + } if($userfield_value == '') *************** *** 897,901 **** $lastvisited_days = intval($lastvisited_days); ! $base_url .= "&search_lastvisited=true&lastvisited_type=".rawurlencode($lastvisited_type)."&lastvisited_days=".rawurlencode($lastvisited_days); $lastvisited_seconds = ( time() - ( ( ( $lastvisited_days * 24 ) * 60 ) * 60 ) ); --- 909,913 ---- $lastvisited_days = intval($lastvisited_days); ! $base_url .= "&search_lastvisited=true&lastvisited_type=".rawurlencode(stripslashes($lastvisited_type))."&lastvisited_days=".rawurlencode($lastvisited_days); $lastvisited_seconds = ( time() - ( ( ( $lastvisited_days * 24 ) * 60 ) * 60 ) ); *************** *** 932,938 **** break; case 'search_language': ! $base_url .= "&search_language=true&language_type=".rawurlencode($language_type); ! $language_type = trim(strtolower($language_type)); if($language_type == '') --- 944,950 ---- break; case 'search_language': ! $base_url .= "&search_language=true&language_type=".rawurlencode(stripslashes($language_type)); ! $language_type = trim(strtolower(stripslashes($language_type))); if($language_type == '') *************** *** 953,958 **** break; case 'search_timezone': ! $base_url .= "&search_timezone=true&timezone_type=".rawurlencode($timezone_type); ! $text = sprintf($lang['Search_for_timezone'], strip_tags(htmlspecialchars($timezone_type))); $timezone_type = intval($timezone_type); --- 965,970 ---- break; case 'search_timezone': ! $base_url .= "&search_timezone=true&timezone_type=".rawurlencode(stripslashes($timezone_type)); ! $text = sprintf($lang['Search_for_timezone'], strip_tags(htmlspecialchars(stripslashes($timezone_type)))); $timezone_type = intval($timezone_type); *************** *** 968,972 **** break; case 'search_style': ! $base_url .= "&search_style=true&style_type=".rawurlencode($style_type); $style_type = intval($style_type); --- 980,984 ---- break; case 'search_style': ! $base_url .= "&search_style=true&style_type=".rawurlencode(stripslashes($style_type)); $style_type = intval($style_type); *************** *** 1001,1005 **** break; case 'search_moderators': ! $base_url .= "&search_moderators=true&style_type=".rawurlencode($moderators_forum); $moderators_forum = intval($moderators_forum); --- 1013,1017 ---- break; case 'search_moderators': ! $base_url .= "&search_moderators=true&moderators_forum=".rawurlencode(stripslashes($moderators_forum)); $moderators_forum = intval($moderators_forum); *************** *** 1045,1049 **** $misc = trim(strtolower($misc)); ! $base_url .= "&search_misc=true&misc=".rawurlencode($misc); switch($misc) --- 1057,1061 ---- $misc = trim(strtolower($misc)); ! $base_url .= "&search_misc=true&misc=".rawurlencode(stripslashes($misc)); switch($misc) |
|
From: Adam A. <ra...@us...> - 2004-12-31 13:14:58
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22804 Modified Files: INSTALL Log Message: Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** INSTALL 31 Dec 2004 05:29:32 -0000 1.10 --- INSTALL 31 Dec 2004 13:14:49 -0000 1.11 *************** *** 4,8 **** ## MOD Description: This is an admin module for the ACP system. It allows Searching for users based on their ## username, email address, date registered, usergroup, permission status ! ## (mod/admin), post count, userfields (ICQ/Yahoo/Website/Interests/e.t.c.), Language, ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. --- 4,8 ---- ## MOD Description: This is an admin module for the ACP system. It allows Searching for users based on their ## username, email address, date registered, usergroup, permission status ! ## (mod/admin), post count, userfields (ICQ/Yahoo/Website/Interests/e.t.c.), Language, Last Visit, ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. *************** *** 38,43 **** ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ! ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls --- 38,46 ---- ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ! ## - Fixed bug where users would be selected twice if they had moderation permissions set by ## a group and their individual permissions + ## - Fixed bug in Last Moderator search sorting (Phineus1) + ## - Fixed Regex bug due to escaped characters (Phineus1) + ## - Fixed bug in slashed characters being slashed again on pagination ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:29:42
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10765 Modified Files: INSTALL Log Message: Mixed up date Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** INSTALL 31 Dec 2004 05:26:53 -0000 1.9 --- INSTALL 31 Dec 2004 05:29:32 -0000 1.10 *************** *** 45,49 **** ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options ! ## 2004/16/11 - Version 1.0.1 ## - Fixed Bug with + Characters being converted to spaces when url encoded ## - Fixed Grammatical Errors --- 45,49 ---- ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options ! ## 2004/11/16 - Version 1.0.1 ## - Fixed Bug with + Characters being converted to spaces when url encoded ## - Fixed Grammatical Errors |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:27:07
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10343/admin Modified Files: admin_user_search.php Log Message: ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls ## - Added Sorting of results by Last Visit ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** admin_user_search.php 17 Nov 2004 22:45:16 -0000 1.8 --- admin_user_search.php 31 Dec 2004 05:26:54 -0000 1.9 *************** *** 101,104 **** --- 101,112 ---- $styles_list = style_select('', 'style_type'); + $lastvisited = array(1, 7, 14, 30, 60, 120, 365, 500, 730, 1000); + $lastvisited_list = ''; + + foreach($lastvisited as $days) + { + $lastvisited_list .= '<option value="'.$days.'">'.$days.' '. ( ( $days > 1 ) ? $lang['Days'] : $lang['Day'] ) .'</option>'; + } + $template->set_filenames(array( "body" => "admin/admin_user_search_form.tpl" *************** *** 142,145 **** --- 150,157 ---- 'L_INTERESTS' => $lang['Interests'], 'L_OCCUPATION' => $lang['Occupation'], + 'L_LASTVISITED' => $lang['Search_users_lastvisited'], + 'L_IN_THE_LAST' => $lang['in_the_last'], + 'L_AFTER_THE_LAST' => $lang['after_the_last'], + 'L_LASTVISITED_EXPLAIN' => $lang['Search_users_lastvisited_explain'], 'L_LANGUAGE' => $lang['Board_lang'], 'L_LANGUAGE_EXPLAIN' => $lang['Search_users_language_explain'], *************** *** 160,163 **** --- 172,176 ---- 'FORUMS_LIST' => $forums_list, 'STYLE_LIST' => $styles_list, + 'LASTVISITED_LIST' => $lastvisited_list, 'S_SEARCH_ACTION' => append_sid("admin_user_search.$phpEx") *************** *** 197,200 **** --- 210,217 ---- $mode = 'search_userfield'; } + else if(isset($HTTP_POST_VARS['search_lastvisited'])||isset($HTTP_GET_VARS['search_lastvisited'])) + { + $mode = 'search_lastvisited'; + } else if(isset($HTTP_POST_VARS['search_language'])||isset($HTTP_GET_VARS['search_language'])) { *************** *** 222,226 **** { case 'search_username': ! $username = ( isset($HTTP_GET_VARS['username']) ) ? rawurldecode($HTTP_GET_VARS['username']) : $HTTP_POST_VARS['username']; $regex = ( $HTTP_POST_VARS['search_username_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 239,243 ---- { case 'search_username': ! $username = ( isset($HTTP_GET_VARS['username']) ) ? $HTTP_GET_VARS['username'] : $HTTP_POST_VARS['username']; $regex = ( $HTTP_POST_VARS['search_username_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 232,236 **** break; case 'search_email': ! $email = ( isset($HTTP_GET_VARS['email']) ) ? rawurldecode($HTTP_GET_VARS['email']) : $HTTP_POST_VARS['email']; $regex = ( $HTTP_POST_VARS['search_email_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 249,253 ---- break; case 'search_email': ! $email = ( isset($HTTP_GET_VARS['email']) ) ? $HTTP_GET_VARS['email'] : $HTTP_POST_VARS['email']; $regex = ( $HTTP_POST_VARS['search_email_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 242,246 **** break; case 'search_ip': ! $ip_address = ( isset($HTTP_POST_VARS['ip_address'] ) ) ? $HTTP_POST_VARS['ip_address'] : rawurldecode($HTTP_GET_VARS['ip_address']); if(!$ip_address) --- 259,263 ---- break; case 'search_ip': ! $ip_address = ( isset($HTTP_POST_VARS['ip_address'] ) ) ? $HTTP_POST_VARS['ip_address'] : $HTTP_GET_VARS['ip_address']; if(!$ip_address) *************** *** 250,257 **** break; case 'search_joindate': ! $date_type = ( isset($HTTP_POST_VARS['date_type'] ) ) ? $HTTP_POST_VARS['date_type'] : rawurldecode($HTTP_GET_VARS['date_type']); ! $date_day = ( isset($HTTP_POST_VARS['date_day'] ) ) ? $HTTP_POST_VARS['date_day'] : rawurldecode($HTTP_GET_VARS['date_day']); ! $date_month = ( isset($HTTP_POST_VARS['date_month'] ) ) ? $HTTP_POST_VARS['date_month'] : rawurldecode($HTTP_GET_VARS['date_month']); ! $date_year = ( isset($HTTP_POST_VARS['date_year'] ) ) ? $HTTP_POST_VARS['date_year'] : rawurldecode($HTTP_GET_VARS['date_year']); if(!$date_type || !$date_day || !$date_month || !$date_year) --- 267,274 ---- break; case 'search_joindate': ! $date_type = ( isset($HTTP_POST_VARS['date_type'] ) ) ? $HTTP_POST_VARS['date_type'] : $HTTP_GET_VARS['date_type']; ! $date_day = ( isset($HTTP_POST_VARS['date_day'] ) ) ? $HTTP_POST_VARS['date_day'] : $HTTP_GET_VARS['date_day']; ! $date_month = ( isset($HTTP_POST_VARS['date_month'] ) ) ? $HTTP_POST_VARS['date_month'] : $HTTP_GET_VARS['date_month']; ! $date_year = ( isset($HTTP_POST_VARS['date_year'] ) ) ? $HTTP_POST_VARS['date_year'] : $HTTP_GET_VARS['date_year']; if(!$date_type || !$date_day || !$date_month || !$date_year) *************** *** 261,265 **** break; case 'search_group': ! $group_id = ( isset($HTTP_POST_VARS['group_id'] ) ) ? $HTTP_POST_VARS['group_id'] : rawurldecode($HTTP_GET_VARS['group_id']); if(!$group_id) { --- 278,282 ---- break; case 'search_group': ! $group_id = ( isset($HTTP_POST_VARS['group_id'] ) ) ? $HTTP_POST_VARS['group_id'] : $HTTP_GET_VARS['group_id']; if(!$group_id) { *************** *** 268,273 **** break; case 'search_postcount': ! $postcount_type = ( isset($HTTP_POST_VARS['postcount_type'] ) ) ? $HTTP_POST_VARS['postcount_type'] : rawurldecode($HTTP_GET_VARS['postcount_type']); ! $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : rawurldecode($HTTP_GET_VARS['postcount_value']); if(!$postcount_type || ( !$postcount_value && $postcount_value != 0)) --- 285,290 ---- break; case 'search_postcount': ! $postcount_type = ( isset($HTTP_POST_VARS['postcount_type'] ) ) ? $HTTP_POST_VARS['postcount_type'] : $HTTP_GET_VARS['postcount_type']; ! $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : $HTTP_GET_VARS['postcount_value']; if(!$postcount_type || ( !$postcount_value && $postcount_value != 0)) *************** *** 277,282 **** break; case 'search_userfield': ! $userfield_type = ( isset($HTTP_POST_VARS['userfield_type'] ) ) ? $HTTP_POST_VARS['userfield_type'] : rawurldecode($HTTP_GET_VARS['userfield_type']); ! $userfield_value = ( isset($HTTP_POST_VARS['userfield_value'] ) ) ? $HTTP_POST_VARS['userfield_value'] : rawurldecode($HTTP_GET_VARS['userfield_value']); $regex = ( $HTTP_POST_VARS['search_userfield_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 294,299 ---- break; case 'search_userfield': ! $userfield_type = ( isset($HTTP_POST_VARS['userfield_type'] ) ) ? $HTTP_POST_VARS['userfield_type'] : $HTTP_GET_VARS['userfield_type']; ! $userfield_value = ( isset($HTTP_POST_VARS['userfield_value'] ) ) ? $HTTP_POST_VARS['userfield_value'] : $HTTP_GET_VARS['userfield_value']; $regex = ( $HTTP_POST_VARS['search_userfield_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 287,292 **** break; case 'search_language': ! $language_type = ( isset($HTTP_POST_VARS['language_type'] ) ) ? $HTTP_POST_VARS['language_type'] : rawurldecode($HTTP_GET_VARS['language_type']); if(!$language_type) --- 304,319 ---- break; + case 'search_lastvisited': + $lastvisited_days = ( isset($HTTP_POST_VARS['lastvisited_days'] ) ) ? $HTTP_POST_VARS['lastvisited_days'] : $HTTP_GET_VARS['lastvisited_days']; + $lastvisited_type = ( isset($HTTP_POST_VARS['lastvisited_type'] ) ) ? $HTTP_POST_VARS['lastvisited_type'] : $HTTP_GET_VARS['lastvisited_type']; + + if(!$lastvisited_days || !$lastvisited_type) + { + message_die(GENERAL_MESSAGE, $lang['Search_invalid_lastvisited']); + } + + break; case 'search_language': ! $language_type = ( isset($HTTP_POST_VARS['language_type'] ) ) ? $HTTP_POST_VARS['language_type'] : $HTTP_GET_VARS['language_type']; if(!$language_type) *************** *** 297,301 **** break; case 'search_timezone': ! $timezone_type = ( isset($HTTP_POST_VARS['timezone_type'] ) ) ? $HTTP_POST_VARS['timezone_type'] : rawurldecode($HTTP_GET_VARS['timezone_type']); if(!$timezone_type && $timezone_type != 0) --- 324,328 ---- break; case 'search_timezone': ! $timezone_type = ( isset($HTTP_POST_VARS['timezone_type'] ) ) ? $HTTP_POST_VARS['timezone_type'] : $HTTP_GET_VARS['timezone_type']; if(!$timezone_type && $timezone_type != 0) *************** *** 306,310 **** break; case 'search_style': ! $style_type = ( isset($HTTP_POST_VARS['style_type'] ) ) ? $HTTP_POST_VARS['style_type'] : rawurldecode($HTTP_GET_VARS['style_type']); if(!$style_type) --- 333,337 ---- break; case 'search_style': ! $style_type = ( isset($HTTP_POST_VARS['style_type'] ) ) ? $HTTP_POST_VARS['style_type'] : $HTTP_GET_VARS['style_type']; if(!$style_type) *************** *** 315,319 **** break; case 'search_moderators': ! $moderators_forum = ( isset($HTTP_POST_VARS['moderators_forum'] ) ) ? $HTTP_POST_VARS['moderators_forum'] : rawurldecode($HTTP_GET_VARS['moderators_forum']); if(!$moderators_forum) --- 342,346 ---- break; case 'search_moderators': ! $moderators_forum = ( isset($HTTP_POST_VARS['moderators_forum'] ) ) ? $HTTP_POST_VARS['moderators_forum'] : $HTTP_GET_VARS['moderators_forum']; if(!$moderators_forum) *************** *** 325,329 **** case 'search_misc': default: ! $misc = ( isset($HTTP_POST_VARS['misc'] ) ) ? $HTTP_POST_VARS['misc'] : rawurldecode($HTTP_GET_VARS['misc']); if(!$misc) { --- 352,356 ---- case 'search_misc': default: ! $misc = ( isset($HTTP_POST_VARS['misc'] ) ) ? $HTTP_POST_VARS['misc'] : $HTTP_GET_VARS['misc']; if(!$misc) { *************** *** 334,338 **** $base_url = "admin_user_search.$phpEx?dosearch=true"; ! $select_sql = "SELECT u.user_id, u.username, u.user_email, u.user_posts, u.user_regdate, u.user_level, u.user_active FROM ".USERS_TABLE." AS u"; --- 361,365 ---- $base_url = "admin_user_search.$phpEx?dosearch=true"; ! $select_sql = "SELECT u.user_id, u.username, u.user_email, u.user_posts, u.user_regdate, u.user_level, u.user_active, u.user_lastvisit FROM ".USERS_TABLE." AS u"; *************** *** 692,697 **** WHERE u.user_id = ug.user_id AND ug.group_id = $group_id ! AND u.user_id <> ".ANONYMOUS." ! GROUP BY u.user_id"; $select_sql .= ", ".USER_GROUP_TABLE." AS ug --- 719,723 ---- WHERE u.user_id = ug.user_id AND ug.group_id = $group_id ! AND u.user_id <> ".ANONYMOUS; $select_sql .= ", ".USER_GROUP_TABLE." AS ug *************** *** 712,716 **** $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_by_postcount_greater'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total --- 738,742 ---- $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_for_postcount_greater'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total *************** *** 725,729 **** $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_by_postcount_lesser'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total --- 751,755 ---- $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_for_postcount_lesser'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total *************** *** 749,753 **** } ! $text = sprintf($lang['Search_by_postcount_range'], $range_begin, $range_end); $total_sql .= "SELECT COUNT(user_id) AS total --- 775,779 ---- } ! $text = sprintf($lang['Search_for_postcount_range'], $range_begin, $range_end); $total_sql .= "SELECT COUNT(user_id) AS total *************** *** 765,769 **** $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_by_postcount_equals'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total --- 791,795 ---- $postcount_value = intval($postcount_value); ! $text = sprintf($lang['Search_for_postcount_equals'], $postcount_value); $total_sql .= "SELECT COUNT(user_id) AS total *************** *** 867,870 **** --- 893,934 ---- break; + case 'search_lastvisited': + $lastvisited_type = trim(strtolower($lastvisited_type)); + $lastvisited_days = intval($lastvisited_days); + + $base_url .= "&search_lastvisited=true&lastvisited_type=".rawurlencode($lastvisited_type)."&lastvisited_days=".rawurlencode($lastvisited_days); + + $lastvisited_seconds = ( time() - ( ( ( $lastvisited_days * 24 ) * 60 ) * 60 ) ); + + switch($lastvisited_type) + { + case 'in': + $text = sprintf($lang['Search_for_lastvisited_inthelast'], $lastvisited_days, ( ( $lastvisited_days > 1 ) ? $lang['Days'] : $lang['Day'] ) ); + + $total_sql .= "SELECT COUNT(user_id) AS total + FROM ".USERS_TABLE." + WHERE user_lastvisit >= $lastvisited_seconds + AND user_id <> ".ANONYMOUS; + + $select_sql .= " WHERE u.user_lastvisit >= $lastvisited_seconds + AND u.user_id <> ".ANONYMOUS; + break; + case 'after': + $text = sprintf($lang['Search_for_lastvisited_afterthelast'], $lastvisited_days, ( ( $lastvisited_days > 1 ) ? $lang['Days'] : $lang['Day'] )); + + $total_sql .= "SELECT COUNT(user_id) AS total + FROM ".USERS_TABLE." + WHERE user_lastvisit < $lastvisited_seconds + AND user_id <> ".ANONYMOUS; + + $select_sql .= " WHERE u.user_lastvisit < $lastvisited_seconds + AND u.user_id <> ".ANONYMOUS; + + break; + default: + message_die(GENERAL_MESSAGE, $lang['Search_invalid_lastvisited']); + } + + break; case 'search_language': $base_url .= "&search_language=true&language_type=".rawurlencode($language_type); *************** *** 959,970 **** $text = sprintf($lang['Search_for_moderators'], strip_tags(htmlspecialchars($forum_name['forum_name']))); ! $total_sql .= "SELECT COUNT(u.user_id) AS total FROM ".USERS_TABLE." AS u, ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa WHERE u.user_id = ug.user_id AND ug.group_id = g.group_id AND g.group_id = aa.group_id AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS." ! GROUP BY (u.user_id)"; $select_sql .= ", ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa --- 1023,1034 ---- $text = sprintf($lang['Search_for_moderators'], strip_tags(htmlspecialchars($forum_name['forum_name']))); ! $total_sql .= "SELECT COUNT(DISTINCT u.user_id) AS total FROM ".USERS_TABLE." AS u, ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa WHERE u.user_id = ug.user_id AND ug.group_id = g.group_id AND g.group_id = aa.group_id + AND aa.forum_id = ". $moderators_forum ." AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS; $select_sql .= ", ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa *************** *** 972,977 **** AND ug.group_id = g.group_id AND g.group_id = aa.group_id AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS; break; case 'search_misc': --- 1036,1043 ---- AND ug.group_id = g.group_id AND g.group_id = aa.group_id + AND aa.forum_id = ". $moderators_forum ." AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS." ! GROUP BY u.user_id, u.username, u.user_email, u.user_posts, u.user_regdate, u.user_level, u.user_active, u.user_lastvisit"; break; case 'search_misc': *************** *** 1071,1074 **** --- 1137,1145 ---- $select_sql .= "u.user_email"; break; + case 'lastvisit': + $sort = 'user_lastvisit'; + + $select_sql .= "u.user_lastvisit"; + break; case 'username': default: *************** *** 1156,1159 **** --- 1227,1231 ---- 'L_POSTS' => $lang['Posts'], 'L_JOINDATE' => $lang['Joined'], + 'L_LASTVISIT' => $lang['Last_visit'], 'L_MANAGE' => $lang['Manage'], 'L_PERMISSIONS' => $lang['Permissions'], *************** *** 1168,1171 **** --- 1240,1244 ---- 'U_POSTS' => ( ( $sort == 'posts' ) ? append_sid("$base_url&sort=$sort&order=$o_order") : append_sid("$base_url&sort=posts&order=$order") ), 'U_JOINDATE' => ( ( $sort == 'regdate' ) ? append_sid("$base_url&sort=$sort&order=$o_order") : append_sid("$base_url&sort=regdate&order=$order") ), + 'U_LASTVISIT' => ( ( $sort == 'lastvisit' ) ? append_sid("$base_url&sort=$sort&order=$o_order") : append_sid("$base_url&sort=lastvisit&order=$order") ), 'S_POST_ACTION' => append_sid("$base_url&sort=$sort&order=$order") *************** *** 1213,1216 **** --- 1286,1290 ---- 'EMAIL' => $rowset[$i]['user_email'], 'JOINDATE' => create_date($board_config['default_dateformat'], $rowset[$i]['user_regdate'], $board_config['board_timezone']), + 'LASTVISIT' => create_date($board_config['default_dateformat'], $rowset[$i]['user_lastvisit'], $board_config['board_timezone']), 'POSTS' => $rowset[$i]['user_posts'], 'BAN' => ( ( !isset($banned[$rowset[$i]['user_id']]) ) ? $lang['Not_banned'] : $lang['Banned'] ), |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:27:05
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10343 Modified Files: INSTALL Log Message: ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls ## - Added Sorting of results by Last Visit ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** INSTALL 17 Nov 2004 22:50:54 -0000 1.8 --- INSTALL 31 Dec 2004 05:26:53 -0000 1.9 *************** *** 7,11 **** ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. ! ## MOD Version: 1.0.0 ## ## Installation Level: (Easy) --- 7,11 ---- ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. ! ## MOD Version: 1.0.2 ## ## Installation Level: (Easy) *************** *** 15,27 **** ## lang_user_search.php, LICENCE, INSTALL ############################################################## ! ## The latest version of this MOD can be download at http://www.sourceforge.net/projects/r45phpbbmods/ ############################################################## ## Author Notes: ! ## All you need to do is upload the appropriate files into their directories ! ## and it will show up in the Administration Panel under the User Admin Section as "Search". ## ############################################################## ## MOD History: ## ## 2004/16/11 - Version 1.0.1 ## - Fixed Bug with + Characters being converted to spaces when url encoded --- 15,48 ---- ## lang_user_search.php, LICENCE, INSTALL ############################################################## ! ## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the ! ## latest version of this MOD. Downloading this MOD from other sites could cause malicious code ! ## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered ! ## in our MOD-Database, located at: http://www.phpbb.com/mods/ ############################################################## ## Author Notes: ! ## All you need to do is upload the appropriate files into their directories ! ## and it will show up in the Administration Panel under the User Admin Section as "Search". ! ## ! ## ** UPGRADERS ** -> Simply reupload all files in this MOD overwriting the old files. ! ## ! ## If you're interested in adding additional fields to be search, please see this post: ! ## http://www.phpbb.com/phpBB/viewtopic.php?p=1373307#1373307 ! ## ! ## This MOD has been tested with phpBB 2.0.11. It *should* work with the entire 2.0.x ! ## series. Your mileage with phpBB forks will vary. ## ############################################################## ## MOD History: ## + ## 2004/12/31 - Version 1.0.2 + ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) + ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) + ## - Fixed bug where users would be selected twice if the had moderation permissions set by + ## a group and their individual permissions + ## - Removed SQL Injection vulnerability + ## - Fixed bug with incorrect language file calls + ## - Added Sorting of results by Last Visit + ## - Included Last Visit in results + ## - Added Field of Last Visit to the Search Options ## 2004/16/11 - Version 1.0.1 ## - Fixed Bug with + Characters being converted to spaces when url encoded *************** *** 52,60 **** # ! copy admin_user_search.php to admin/admin_user_search.php ! copy admin_user_search_form.tpl to templates/subSilver/admin/admin_user_search_form.tpl ! copy admin_user_search_results.tpl to templates/subSilver/admin/admin_user_search_results.tpl ! copy lang_user_search.php to language/lang_english/lang_user_search.php ! # --- 73,80 ---- # ! copy admin/admin_user_search.php to admin/admin_user_search.php ! copy templates/subSilver/admin/admin_user_search_form.tpl to templates/subSilver/admin/admin_user_search_form.tpl ! copy templates/subSilver/admin/admin_user_search_results.tpl to templates/subSilver/admin/admin_user_search_results.tpl ! copy language/lang_english/lang_user_search.php to language/lang_english/lang_user_search.php # |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:27:05
|
Update of /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10343/templates/subSilver/admin Modified Files: admin_user_search_form.tpl admin_user_search_results.tpl Log Message: ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls ## - Added Sorting of results by Last Visit ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options Index: admin_user_search_form.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin/admin_user_search_form.tpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** admin_user_search_form.tpl 19 May 2004 21:44:42 -0000 1.4 --- admin_user_search_form.tpl 31 Dec 2004 05:26:55 -0000 1.5 *************** *** 74,77 **** --- 74,86 ---- </tr> <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LASTVISITED} <select name="lastvisited_type"><option value="in">{L_IN_THE_LAST}</option><option value="after">{L_AFTER_THE_LAST}</option></select> <select name="lastvisited_days">{LASTVISITED_LIST}</select> <input type="submit" class="post2" name="search_lastvisited" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_LASTVISITED_EXPLAIN}</span></td> + </tr> + <tr> + <td class="catBottom" colspan="1" height="28"> </td> + </tr> + <tr> <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: {LANGUAGE_LIST} <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> Index: admin_user_search_results.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin/admin_user_search_results.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_user_search_results.tpl 10 Apr 2004 07:40:55 -0000 1.2 --- admin_user_search_results.tpl 31 Dec 2004 05:26:55 -0000 1.3 *************** *** 6,10 **** <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center"> <tr> ! <td align="center" class="nav"><span class="gen">{L_SORT_OPTIONS}</span> <a href="{U_USERNAME}">{L_USERNAME}</a> | <a href="{U_EMAIL}">{L_EMAIL}</a> | <a href="{U_POSTS}">{L_POSTS}</a> | <a href="{U_JOINDATE}">{L_JOINDATE}</a></td> </tr> </table> --- 6,10 ---- <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center"> <tr> ! <td align="center" class="nav"><span class="gen">{L_SORT_OPTIONS}</span> <a href="{U_USERNAME}">{L_USERNAME}</a> | <a href="{U_EMAIL}">{L_EMAIL}</a> | <a href="{U_POSTS}">{L_POSTS}</a> | <a href="{U_JOINDATE}">{L_JOINDATE}</a> | <a href="{U_LASTVISIT}">{L_LASTVISIT}</a></td> </tr> </table> *************** *** 22,25 **** --- 22,26 ---- <th class="thTop" nowrap="nowrap">{L_JOINDATE}</th> <th class="thTop" nowrap="nowrap">{L_POSTS}</th> + <th class="thTop" nowrap="nowrap">{L_LASTVISIT}</th> <th class="thTop" nowrap="nowrap"> </th> <th class="thTop" nowrap="nowrap"> </th> *************** *** 33,36 **** --- 34,38 ---- <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.JOINDATE} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPOSTS}" class="gen">{userrow.POSTS}</a> </span></td> + <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.LASTVISIT} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_MANAGE}" class="gen">{L_MANAGE}</a> </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_PERMISSIONS}" class="gen">{L_PERMISSIONS}</a> </span></td> |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:27:04
|
Update of /cvsroot/r45phpbbmods/user_search/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10343/language/lang_english Modified Files: lang_user_search.php Log Message: ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls ## - Added Sorting of results by Last Visit ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options Index: lang_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/language/lang_english/lang_user_search.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** lang_user_search.php 17 Nov 2004 22:50:55 -0000 1.9 --- lang_user_search.php 31 Dec 2004 05:26:54 -0000 1.10 *************** *** 28,31 **** --- 28,32 ---- $lang['Search_invalid_postcount'] = 'Invalid Post Count entered to Search'; $lang['Search_invalid_userfield'] = 'Invalid Userfield data entered'; + $lang['Search_invalid_lastvisited'] = 'Invalid data entered for Last Visited search'; $lang['Search_invalid_language'] = 'Invalid Language Selected'; $lang['Search_invalid_style'] = 'Invalid Style Selected'; *************** *** 59,62 **** --- 60,65 ---- $lang['Search_for_userfield_interests'] = 'Searching for users with their Interests field matching %s'; $lang['Search_for_userfield_occupation'] = 'Searching for users with their Occupation field matching %s'; + $lang['Search_for_lastvisited_inthelast'] = 'Searching for users who have visited in the last %s %s'; + $lang['Search_for_lastvisited_afterthelast'] = 'Searching for users who have visited after the last %s %s'; $lang['Search_for_language'] = 'Searching for users who have set %s as their language'; $lang['Search_for_timezone'] = 'Searching for users who have set GMT %s as their timezone'; *************** *** 69,72 **** --- 72,78 ---- $lang['Search_ip_explain'] = 'Search for users who made posts made by a specific ip address (xxx.xxx.xxx.xxx), wildcard (xxx.xxx.xxx.*) or range (xxx.xxx.xxx.xxx-yyy.yyy.yyy.yyy). Note: the last quad .255 is considered the range of all the IPs in that quad. If you enter 10.0.0.255, it is just like entering 10.0.0.* (No IP is assigned .255 for that matter, it is reserved). Where you may encounter this is in ranges, 10.0.0.5-10.0.0.255 is the same as "10.0.0.*" . You should really enter 10.0.0.5-10.0.0.254 .'; $lang['Search_users_joined'] = 'Users that joined'; + $lang['Search_users_lastvisited'] = 'Users whom have visited'; + $lang['in_the_last'] = 'in the last'; + $lang['after_the_last'] = 'after the last'; $lang['Before'] = 'Before'; $lang['After'] = 'After'; *************** *** 85,88 **** --- 91,95 ---- $lang['Userfield'] = 'Userfield'; $lang['Search_users_userfield_explain'] = 'Search for users based on various profile fields. Wildcards are supported using an asterix (*). Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.'; + $lang['Search_users_lastvisited_explain'] = 'You can search for users based on their last login date using this search option'; $lang['Search_users_language_explain'] = 'This will display users whom have selected a specific language in their Profile'; $lang['Search_users_timezone_explain'] = 'Users who have selected a specific timezone in their profile'; *************** *** 99,102 **** --- 106,111 ---- $lang['Account_status'] = 'Account Status'; $lang['Sort_options'] = 'Sort options:'; + $lang['Last_visit'] = 'Last Visit'; + $lang['Day'] = 'Day'; ?> \ No newline at end of file |
|
From: Adam A. <ra...@us...> - 2004-12-31 05:27:04
|
Update of /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10343/templates/fisubsilver/admin Modified Files: admin_user_search_form.tpl admin_user_search_results.tpl Log Message: ## 2004/12/31 - Version 1.0.2 ## - Fixed bug in Moderators Query (Ommited forum clause) (Credits to JRSweets) ## - Fixed bug in Group Selecting where total SQL returned maximum 1 row (Credits to nanjang) ## - Fixed bug where users would be selected twice if the had moderation permissions set by ## a group and their individual permissions ## - Removed SQL Injection vulnerability ## - Fixed bug with incorrect language file calls ## - Added Sorting of results by Last Visit ## - Included Last Visit in results ## - Added Field of Last Visit to the Search Options Index: admin_user_search_form.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin/admin_user_search_form.tpl,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** admin_user_search_form.tpl 19 May 2004 21:44:41 -0000 1.3 --- admin_user_search_form.tpl 31 Dec 2004 05:26:54 -0000 1.4 *************** *** 75,78 **** --- 75,87 ---- </tr> <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LASTVISITED} <select name="lastvisited_type"><option value="in">{L_IN_THE_LAST}</option><option value="after">{L_AFTER_THE_LAST}</option></select> <select name="lastvisited_days">{LASTVISITED_LIST}</select> <input type="submit" class="post2" name="search_lastvisited" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_LASTVISITED_EXPLAIN}</span></td> + </tr> + <tr> + <td class="cat" colspan="1" height="28"> </td> + </tr> + <tr> <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: {LANGUAGE_LIST} <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> Index: admin_user_search_results.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin/admin_user_search_results.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_user_search_results.tpl 19 May 2004 21:44:41 -0000 1.2 --- admin_user_search_results.tpl 31 Dec 2004 05:26:54 -0000 1.3 *************** *** 6,10 **** <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center"> <tr> ! <td align="center" class="nav"><span class="gen">{L_SORT_OPTIONS}</span> <a href="{U_USERNAME}">{L_USERNAME}</a> | <a href="{U_EMAIL}">{L_EMAIL}</a> | <a href="{U_POSTS}">{L_POSTS}</a> | <a href="{U_JOINDATE}">{L_JOINDATE}</a></td> </tr> </table> --- 6,10 ---- <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center"> <tr> ! <td align="center" class="nav"><span class="gen">{L_SORT_OPTIONS}</span> <a href="{U_USERNAME}">{L_USERNAME}</a> | <a href="{U_EMAIL}">{L_EMAIL}</a> | <a href="{U_POSTS}">{L_POSTS}</a> | <a href="{U_JOINDATE}">{L_JOINDATE}</a> | <a href="{U_LASTVISIT}">{L_LASTVISIT}</a></td> </tr> </table> *************** *** 22,25 **** --- 22,26 ---- <th class="thTop" nowrap="nowrap">{L_JOINDATE}</th> <th class="thTop" nowrap="nowrap">{L_POSTS}</th> + <th class="thTop" nowrap="nowrap">{L_LASTVISIT}</th> <th class="thTop" nowrap="nowrap"> </th> <th class="thTop" nowrap="nowrap"> </th> *************** *** 33,36 **** --- 34,38 ---- <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.JOINDATE} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPOSTS}" class="gen">{userrow.POSTS}</a> </span></td> + <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.LASTVISIT} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_MANAGE}" class="gen">{L_MANAGE}</a> </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_PERMISSIONS}" class="gen">{L_PERMISSIONS}</a> </span></td> |
|
From: Adam A. <ra...@us...> - 2004-11-17 22:51:13
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16320 Modified Files: INSTALL Log Message: Fixed Grammatical errors Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** INSTALL 17 Nov 2004 22:45:15 -0000 1.7 --- INSTALL 17 Nov 2004 22:50:54 -0000 1.8 *************** *** 26,29 **** --- 26,30 ---- ## 2004/16/11 - Version 1.0.1 ## - Fixed Bug with + Characters being converted to spaces when url encoded + ## - Fixed Grammatical Errors ## 2004/11/11 - Version 1.0.0 ## - First Gold Release! |
|
From: Adam A. <ra...@us...> - 2004-11-17 22:51:11
|
Update of /cvsroot/r45phpbbmods/user_search/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16320/language/lang_english Modified Files: lang_user_search.php Log Message: Fixed Grammatical errors Index: lang_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/language/lang_english/lang_user_search.php,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** lang_user_search.php 19 May 2004 21:44:41 -0000 1.8 --- lang_user_search.php 17 Nov 2004 22:50:55 -0000 1.9 *************** *** 89,97 **** $lang['Search_users_style_explain'] = 'Display users who have selected a specific style.'; $lang['Moderators_of'] = 'Moderators of'; ! $lang['Search_users_moderators_explain'] = 'Search for users with Moderating permissions to a specific forum. Moderating permission either by User Permissions or by being in a Group with the right Group Permssions.'; $lang['Regular_expression'] = 'Regular Expression?'; $lang['Manage'] = 'Manage'; ! $lang['Search_users_new'] = '%s yielded %d result(s). Perform a <a href="%s">another search</a>.'; $lang['Banned'] = 'Banned'; $lang['Not_banned'] = 'Not Banned'; --- 89,97 ---- $lang['Search_users_style_explain'] = 'Display users who have selected a specific style.'; $lang['Moderators_of'] = 'Moderators of'; ! $lang['Search_users_moderators_explain'] = 'Search for users with Moderating permissions to a specific forum. Moderating permissions are recoginised either by User Permissions or by being in a Group with the right Group Permssions.'; $lang['Regular_expression'] = 'Regular Expression?'; $lang['Manage'] = 'Manage'; ! $lang['Search_users_new'] = '%s yielded %d result(s). Perform <a href="%s">another search</a>.'; $lang['Banned'] = 'Banned'; $lang['Not_banned'] = 'Not Banned'; |
|
From: Adam A. <ra...@us...> - 2004-11-17 22:45:36
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14579 Modified Files: INSTALL Log Message: Fixed Bug with + Characters being converted to spaces when url encoded Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** INSTALL 11 Nov 2004 16:11:59 -0000 1.6 --- INSTALL 17 Nov 2004 22:45:15 -0000 1.7 *************** *** 24,27 **** --- 24,29 ---- ## MOD History: ## + ## 2004/16/11 - Version 1.0.1 + ## - Fixed Bug with + Characters being converted to spaces when url encoded ## 2004/11/11 - Version 1.0.0 ## - First Gold Release! *************** *** 49,56 **** # ! copy admin_user_search.php to admin/ ! copy admin_user_search_form.tpl to templates/subSilver/admin/ ! copy admin_user_search_results.tpl to templates/subSilver/admin/ ! copy lang_user_search.php to language/lang_english/ --- 51,58 ---- # ! copy admin_user_search.php to admin/admin_user_search.php ! copy admin_user_search_form.tpl to templates/subSilver/admin/admin_user_search_form.tpl ! copy admin_user_search_results.tpl to templates/subSilver/admin/admin_user_search_results.tpl ! copy lang_user_search.php to language/lang_english/lang_user_search.php |
|
From: Adam A. <ra...@us...> - 2004-11-17 22:45:36
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14579/admin Modified Files: admin_user_search.php Log Message: Fixed Bug with + Characters being converted to spaces when url encoded Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** admin_user_search.php 19 May 2004 21:44:41 -0000 1.7 --- admin_user_search.php 17 Nov 2004 22:45:16 -0000 1.8 *************** *** 222,226 **** { case 'search_username': ! $username = ( isset($HTTP_GET_VARS['username']) ) ? urldecode($HTTP_GET_VARS['username']) : $HTTP_POST_VARS['username']; $regex = ( $HTTP_POST_VARS['search_username_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 222,226 ---- { case 'search_username': ! $username = ( isset($HTTP_GET_VARS['username']) ) ? rawurldecode($HTTP_GET_VARS['username']) : $HTTP_POST_VARS['username']; $regex = ( $HTTP_POST_VARS['search_username_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 232,236 **** break; case 'search_email': ! $email = ( isset($HTTP_GET_VARS['email']) ) ? urldecode($HTTP_GET_VARS['email']) : $HTTP_POST_VARS['email']; $regex = ( $HTTP_POST_VARS['search_email_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 232,236 ---- break; case 'search_email': ! $email = ( isset($HTTP_GET_VARS['email']) ) ? rawurldecode($HTTP_GET_VARS['email']) : $HTTP_POST_VARS['email']; $regex = ( $HTTP_POST_VARS['search_email_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 242,246 **** break; case 'search_ip': ! $ip_address = ( isset($HTTP_POST_VARS['ip_address'] ) ) ? $HTTP_POST_VARS['ip_address'] : urldecode($HTTP_GET_VARS['ip_address']); if(!$ip_address) --- 242,246 ---- break; case 'search_ip': ! $ip_address = ( isset($HTTP_POST_VARS['ip_address'] ) ) ? $HTTP_POST_VARS['ip_address'] : rawurldecode($HTTP_GET_VARS['ip_address']); if(!$ip_address) *************** *** 250,257 **** break; case 'search_joindate': ! $date_type = ( isset($HTTP_POST_VARS['date_type'] ) ) ? $HTTP_POST_VARS['date_type'] : urldecode($HTTP_GET_VARS['date_type']); ! $date_day = ( isset($HTTP_POST_VARS['date_day'] ) ) ? $HTTP_POST_VARS['date_day'] : urldecode($HTTP_GET_VARS['date_day']); ! $date_month = ( isset($HTTP_POST_VARS['date_month'] ) ) ? $HTTP_POST_VARS['date_month'] : urldecode($HTTP_GET_VARS['date_month']); ! $date_year = ( isset($HTTP_POST_VARS['date_year'] ) ) ? $HTTP_POST_VARS['date_year'] : urldecode($HTTP_GET_VARS['date_year']); if(!$date_type || !$date_day || !$date_month || !$date_year) --- 250,257 ---- break; case 'search_joindate': ! $date_type = ( isset($HTTP_POST_VARS['date_type'] ) ) ? $HTTP_POST_VARS['date_type'] : rawurldecode($HTTP_GET_VARS['date_type']); ! $date_day = ( isset($HTTP_POST_VARS['date_day'] ) ) ? $HTTP_POST_VARS['date_day'] : rawurldecode($HTTP_GET_VARS['date_day']); ! $date_month = ( isset($HTTP_POST_VARS['date_month'] ) ) ? $HTTP_POST_VARS['date_month'] : rawurldecode($HTTP_GET_VARS['date_month']); ! $date_year = ( isset($HTTP_POST_VARS['date_year'] ) ) ? $HTTP_POST_VARS['date_year'] : rawurldecode($HTTP_GET_VARS['date_year']); if(!$date_type || !$date_day || !$date_month || !$date_year) *************** *** 261,265 **** break; case 'search_group': ! $group_id = ( isset($HTTP_POST_VARS['group_id'] ) ) ? $HTTP_POST_VARS['group_id'] : urldecode($HTTP_GET_VARS['group_id']); if(!$group_id) { --- 261,265 ---- break; case 'search_group': ! $group_id = ( isset($HTTP_POST_VARS['group_id'] ) ) ? $HTTP_POST_VARS['group_id'] : rawurldecode($HTTP_GET_VARS['group_id']); if(!$group_id) { *************** *** 268,273 **** break; case 'search_postcount': ! $postcount_type = ( isset($HTTP_POST_VARS['postcount_type'] ) ) ? $HTTP_POST_VARS['postcount_type'] : urldecode($HTTP_GET_VARS['postcount_type']); ! $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : urldecode($HTTP_GET_VARS['postcount_value']); if(!$postcount_type || ( !$postcount_value && $postcount_value != 0)) --- 268,273 ---- break; case 'search_postcount': ! $postcount_type = ( isset($HTTP_POST_VARS['postcount_type'] ) ) ? $HTTP_POST_VARS['postcount_type'] : rawurldecode($HTTP_GET_VARS['postcount_type']); ! $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : rawurldecode($HTTP_GET_VARS['postcount_value']); if(!$postcount_type || ( !$postcount_value && $postcount_value != 0)) *************** *** 277,282 **** break; case 'search_userfield': ! $userfield_type = ( isset($HTTP_POST_VARS['userfield_type'] ) ) ? $HTTP_POST_VARS['userfield_type'] : urldecode($HTTP_GET_VARS['userfield_type']); ! $userfield_value = ( isset($HTTP_POST_VARS['userfield_value'] ) ) ? $HTTP_POST_VARS['userfield_value'] : urldecode($HTTP_GET_VARS['userfield_value']); $regex = ( $HTTP_POST_VARS['search_userfield_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; --- 277,282 ---- break; case 'search_userfield': ! $userfield_type = ( isset($HTTP_POST_VARS['userfield_type'] ) ) ? $HTTP_POST_VARS['userfield_type'] : rawurldecode($HTTP_GET_VARS['userfield_type']); ! $userfield_value = ( isset($HTTP_POST_VARS['userfield_value'] ) ) ? $HTTP_POST_VARS['userfield_value'] : rawurldecode($HTTP_GET_VARS['userfield_value']); $regex = ( $HTTP_POST_VARS['search_userfield_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; *************** *** 288,292 **** break; case 'search_language': ! $language_type = ( isset($HTTP_POST_VARS['language_type'] ) ) ? $HTTP_POST_VARS['language_type'] : urldecode($HTTP_GET_VARS['language_type']); if(!$language_type) --- 288,292 ---- break; case 'search_language': ! $language_type = ( isset($HTTP_POST_VARS['language_type'] ) ) ? $HTTP_POST_VARS['language_type'] : rawurldecode($HTTP_GET_VARS['language_type']); if(!$language_type) *************** *** 297,301 **** break; case 'search_timezone': ! $timezone_type = ( isset($HTTP_POST_VARS['timezone_type'] ) ) ? $HTTP_POST_VARS['timezone_type'] : urldecode($HTTP_GET_VARS['timezone_type']); if(!$timezone_type && $timezone_type != 0) --- 297,301 ---- break; case 'search_timezone': ! $timezone_type = ( isset($HTTP_POST_VARS['timezone_type'] ) ) ? $HTTP_POST_VARS['timezone_type'] : rawurldecode($HTTP_GET_VARS['timezone_type']); if(!$timezone_type && $timezone_type != 0) *************** *** 306,310 **** break; case 'search_style': ! $style_type = ( isset($HTTP_POST_VARS['style_type'] ) ) ? $HTTP_POST_VARS['style_type'] : urldecode($HTTP_GET_VARS['style_type']); if(!$style_type) --- 306,310 ---- break; case 'search_style': ! $style_type = ( isset($HTTP_POST_VARS['style_type'] ) ) ? $HTTP_POST_VARS['style_type'] : rawurldecode($HTTP_GET_VARS['style_type']); if(!$style_type) *************** *** 315,319 **** break; case 'search_moderators': ! $moderators_forum = ( isset($HTTP_POST_VARS['moderators_forum'] ) ) ? $HTTP_POST_VARS['moderators_forum'] : urldecode($HTTP_GET_VARS['moderators_forum']); if(!$moderators_forum) --- 315,319 ---- break; case 'search_moderators': ! $moderators_forum = ( isset($HTTP_POST_VARS['moderators_forum'] ) ) ? $HTTP_POST_VARS['moderators_forum'] : rawurldecode($HTTP_GET_VARS['moderators_forum']); if(!$moderators_forum) *************** *** 325,329 **** case 'search_misc': default: ! $misc = ( isset($HTTP_POST_VARS['misc'] ) ) ? $HTTP_POST_VARS['misc'] : urldecode($HTTP_GET_VARS['misc']); if(!$misc) { --- 325,329 ---- case 'search_misc': default: ! $misc = ( isset($HTTP_POST_VARS['misc'] ) ) ? $HTTP_POST_VARS['misc'] : rawurldecode($HTTP_GET_VARS['misc']); if(!$misc) { *************** *** 365,369 **** { case 'search_username': ! $base_url .= "&search_username=true&username=".urlencode($username); $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars($username))); --- 365,369 ---- { case 'search_username': ! $base_url .= "&search_username=true&username=".rawurlencode($username); $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars($username))); *************** *** 410,414 **** break; case 'search_email': ! $base_url .= "&search_email=true&email=".urlencode($email); $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars($email))); --- 410,414 ---- break; case 'search_email': ! $base_url .= "&search_email=true&email=".rawurlencode($email); $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars($email))); *************** *** 455,459 **** break; case 'search_ip': ! $base_url .= "&search_ip=true&ip_address=".urlencode($ip_address); // Remove any whitespace --- 455,459 ---- break; case 'search_ip': ! $base_url .= "&search_ip=true&ip_address=".rawurlencode($ip_address); // Remove any whitespace *************** *** 607,611 **** break; case 'search_joindate': ! $base_url .= "&search_joindate=true&date_type=".urlencode($date_type)."&date_day=".urlencode($date_day)."&date_month=".urlencode($date_month)."&date_year=".urlencode($date_year); $date_type = trim(strtolower($date_type)); --- 607,611 ---- break; case 'search_joindate': ! $base_url .= "&search_joindate=true&date_type=".rawurlencode($date_type)."&date_day=".rawurlencode($date_day)."&date_month=".rawurlencode($date_month)."&date_year=".rawurlencode($date_year); $date_type = trim(strtolower($date_type)); *************** *** 662,666 **** $group_id = intval($group_id); ! $base_url .= "&search_group=true&group_id=".urlencode($group_id); if(!$group_id) --- 662,666 ---- $group_id = intval($group_id); ! $base_url .= "&search_group=true&group_id=".rawurlencode($group_id); if(!$group_id) *************** *** 705,709 **** $postcount_value = trim(strtolower($postcount_value)); ! $base_url .= "&search_postcount=true&postcount_type=".urlencode($postcount_type)."&postcount_value=".urlencode($postcount_value); switch($postcount_type) --- 705,709 ---- $postcount_value = trim(strtolower($postcount_value)); ! $base_url .= "&search_postcount=true&postcount_type=".rawurlencode($postcount_type)."&postcount_value=".rawurlencode($postcount_value); switch($postcount_type) *************** *** 782,786 **** break; case 'search_userfield': ! $base_url .= "&search_userfield=true&userfield_type=".urlencode($userfield_type)."&userfield_value=".urlencode($userfield_value); $text = strip_tags(htmlspecialchars($userfield_value)); --- 782,786 ---- break; case 'search_userfield': ! $base_url .= "&search_userfield=true&userfield_type=".rawurlencode($userfield_type)."&userfield_value=".rawurlencode($userfield_value); $text = strip_tags(htmlspecialchars($userfield_value)); *************** *** 868,872 **** break; case 'search_language': ! $base_url .= "&search_language=true&language_type=".urlencode($language_type); $language_type = trim(strtolower($language_type)); --- 868,872 ---- break; case 'search_language': ! $base_url .= "&search_language=true&language_type=".rawurlencode($language_type); $language_type = trim(strtolower($language_type)); *************** *** 889,893 **** break; case 'search_timezone': ! $base_url .= "&search_timezone=true&timezone_type=".urlencode($timezone_type); $text = sprintf($lang['Search_for_timezone'], strip_tags(htmlspecialchars($timezone_type))); --- 889,893 ---- break; case 'search_timezone': ! $base_url .= "&search_timezone=true&timezone_type=".rawurlencode($timezone_type); $text = sprintf($lang['Search_for_timezone'], strip_tags(htmlspecialchars($timezone_type))); *************** *** 904,908 **** break; case 'search_style': ! $base_url .= "&search_style=true&style_type=".urlencode($style_type); $style_type = intval($style_type); --- 904,908 ---- break; case 'search_style': ! $base_url .= "&search_style=true&style_type=".rawurlencode($style_type); $style_type = intval($style_type); *************** *** 937,941 **** break; case 'search_moderators': ! $base_url .= "&search_moderators=true&style_type=".urlencode($moderators_forum); $moderators_forum = intval($moderators_forum); --- 937,941 ---- break; case 'search_moderators': ! $base_url .= "&search_moderators=true&style_type=".rawurlencode($moderators_forum); $moderators_forum = intval($moderators_forum); *************** *** 979,983 **** $misc = trim(strtolower($misc)); ! $base_url .= "&search_misc=true&misc=".urlencode($misc); switch($misc) --- 979,983 ---- $misc = trim(strtolower($misc)); ! $base_url .= "&search_misc=true&misc=".rawurlencode($misc); switch($misc) *************** *** 1218,1222 **** 'U_VIEWPROFILE' => append_sid("../profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$rowset[$i]['user_id']), ! 'U_VIEWPOSTS' => append_sid("../search.$phpEx?search_author=".urlencode($rowset[$i]['username'])), 'U_MANAGE' => append_sid("admin_users.$phpEx?mode=edit&".POST_USERS_URL."=".$rowset[$i]['user_id']), 'U_PERMISSIONS' => append_sid("admin_ug_auth.$phpEx?mode=user&".POST_USERS_URL."=".$rowset[$i]['user_id']), --- 1218,1222 ---- 'U_VIEWPROFILE' => append_sid("../profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$rowset[$i]['user_id']), ! 'U_VIEWPOSTS' => append_sid("../search.$phpEx?search_author=".rawurlencode($rowset[$i]['username'])), 'U_MANAGE' => append_sid("admin_users.$phpEx?mode=edit&".POST_USERS_URL."=".$rowset[$i]['user_id']), 'U_PERMISSIONS' => append_sid("admin_ug_auth.$phpEx?mode=user&".POST_USERS_URL."=".$rowset[$i]['user_id']), |
|
From: Adam A. <ra...@us...> - 2004-11-11 16:37:20
|
Update of /cvsroot/r45phpbbmods/rebuild_topics In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17059 Modified Files: rebuild_topics.php Log Message: Bug. Thanks to AJD for pointing out Index: rebuild_topics.php =================================================================== RCS file: /cvsroot/r45phpbbmods/rebuild_topics/rebuild_topics.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** rebuild_topics.php 30 Mar 2004 02:40:47 -0000 1.2 --- rebuild_topics.php 11 Nov 2004 16:37:11 -0000 1.3 *************** *** 51,55 **** // We start off by selecting all the posts ! $sql = "SELECT p.post_id, p.forum_id, p.poster_id, p.post_time, pt.post_subject FROM ".POSTS_TABLE." AS p, ".POSTS_TEXT_TABLE." as pt WHERE p.post_id = pt.post_id --- 51,55 ---- // We start off by selecting all the posts ! $sql = "SELECT p.post_id, p.forum_id, p.poster_id, p.post_time, p.topic_id, pt.post_subject FROM ".POSTS_TABLE." AS p, ".POSTS_TEXT_TABLE." as pt WHERE p.post_id = pt.post_id |
|
From: Adam A. <ra...@us...> - 2004-11-11 16:12:08
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11685 Modified Files: INSTALL Log Message: Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** INSTALL 19 May 2004 21:44:40 -0000 1.5 --- INSTALL 11 Nov 2004 16:11:59 -0000 1.6 *************** *** 7,11 **** ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. ! ## MOD Version: 1.0.0 RC 2 ## ## Installation Level: (Easy) --- 7,11 ---- ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ## disabled accounts and disabled PM priviliges. ! ## MOD Version: 1.0.0 ## ## Installation Level: (Easy) *************** *** 24,27 **** --- 24,29 ---- ## MOD History: ## + ## 2004/11/11 - Version 1.0.0 + ## - First Gold Release! ## 2004/5/19 - Version 1.0.0 RC 2 ## - Fixed bug with LIMIT clause on main SELECT statement. Use the PostgreSQL syntax, |
|
From: <ben...@id...> - 2004-05-25 09:42:02
|
Dear Open Source developer I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate. You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it. With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development. With many thanks for your participation, Benno Luthiger PS: The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/. We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list. _______________________________________________________________________ Benno Luthiger Swiss Federal Institute of Technology Zurich 8092 Zurich Mail: benno.luthiger(at)id.ethz.ch _______________________________________________________________________ |
|
From: Adam A. <ra...@us...> - 2004-05-19 21:44:52
|
Update of /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10114/templates/fisubsilver/admin Modified Files: admin_user_search_form.tpl admin_user_search_results.tpl Log Message: Preparing for RC2 Index: admin_user_search_form.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin/admin_user_search_form.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_user_search_form.tpl 3 May 2004 06:36:25 -0000 1.2 --- admin_user_search_form.tpl 19 May 2004 21:44:41 -0000 1.3 *************** *** 9,13 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERNAME}: <input class="post" type="text" name="username" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_username" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 9,13 ---- </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERNAME}: <input class="post" type="text" name="username" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_username" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_username_regex" value="true" /></span></td> </tr> <tr> *************** *** 18,22 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_EMAIL}: <input class="post" type="text" name="email" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_email" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 18,22 ---- </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_EMAIL}: <input class="post" type="text" name="email" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_email" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_email_regex" value="true" /></span></td> </tr> <tr> *************** *** 57,61 **** <!-- END groups_exist --> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_POSTCOUNT} <select name="postcount_type"><option value="equals" selected="selected">{L_EQUALS}</option><option value="lesser">{L_LESSERTHAN}</option><option value="greater">{L_GREATTHAN}</option></select> <input class="post" type="text" name="postcount_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_postcount" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 57,61 ---- <!-- END groups_exist --> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_POSTCOUNT} <select name="postcount_type"><option value="equals" selected="selected">{L_EQUALS}</option><option value="lesser">{L_LESSERTHAN}</option><option value="greater">{L_GREATERTHAN}</option></select> <input class="post" type="text" name="postcount_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_postcount" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 63,67 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERFIELD}: <select name="userfield_type"><option value="icq" selected="selected">{L_ICQ}</option><option value="aim">{L_AIM}</option><option value="msn">{L_MSN}</option><option value="yahoo">{L_YAHOO}</option><option value="website">{L_WEBSITE}</option><option value="location">{L_LOCATION}</option><option value="interests">{L_INTERESTS}</option><option value="occupation">{L_OCCUPATION}</option></select> <input class="post" type="text" name="userfield_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_userfield" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 63,70 ---- </tr> <tr> ! <td class="cat" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERFIELD}: <select name="userfield_type"><option value="icq" selected="selected">{L_ICQ}</option><option value="aim">{L_AIM}</option><option value="msn">{L_MSN}</option><option value="yahoo">{L_YAHOO}</option><option value="website">{L_WEBSITE}</option><option value="location">{L_LOCATION}</option><option value="interests">{L_INTERESTS}</option><option value="occupation">{L_OCCUPATION}</option></select> <input class="post" type="text" name="userfield_value" value="" maxlength="25" size="25" /> <input type="submit" class="post2" name="search_userfield" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_userfield_regex" value="true" /></span></td> </tr> <tr> *************** *** 69,73 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: <select name="language_type">{LANGUAGE_LIST}</select> <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 72,79 ---- </tr> <tr> ! <td class="cat" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: {LANGUAGE_LIST} <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 75,79 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_TIMEZONE}: <select name="timezone_type">{TIMEZONE_LIST}</select> <input type="submit" class="post2" name="search_timezone" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 81,88 ---- </tr> <tr> ! <td class="cat" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_TIMEZONE}: {TIMEZONE_LIST} <input type="submit" class="post2" name="search_timezone" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 81,89 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_STYLE}: <select name="style_type">{STYLE_LIST}</select> <input type="submit" class="post2" name="search_style" value="{L_SEARCH}" /></span></td> </tr> <tr> <td class="row3" align="left"><span class="gensmall">{L_STYLE_EXPLAIN}</span></td> </tr> <!-- BEGIN forums_exist --> <tr> --- 90,104 ---- </tr> <tr> ! <td class="cat" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_STYLE}: {STYLE_LIST} <input type="submit" class="post2" name="search_style" value="{L_SEARCH}" /></span></td> </tr> <tr> <td class="row3" align="left"><span class="gensmall">{L_STYLE_EXPLAIN}</span></td> </tr> + <tr> + <td class="cat" colspan="1" height="28"> </td> + </tr> <!-- BEGIN forums_exist --> <tr> *************** *** 93,96 **** --- 108,114 ---- <td class="row3" align="left"><span class="gensmall">{L_MODERATORS_OF_EXPLAIN}</span></td> </tr> + <tr> + <td class="cat" colspan="1" height="28"> </td> + </tr> <!-- END forums_exist --> <tr> Index: admin_user_search_results.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/fisubsilver/admin/admin_user_search_results.tpl,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** admin_user_search_results.tpl 10 Apr 2004 07:40:55 -0000 1.1 --- admin_user_search_results.tpl 19 May 2004 21:44:41 -0000 1.2 *************** *** 30,34 **** <tr> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPROFILE}" class="gen">{userrow.USERNAME}</a> </span></td> ! <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.EMAIL} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.JOINDATE} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPOSTS}" class="gen">{userrow.POSTS}</a> </span></td> --- 30,34 ---- <tr> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPROFILE}" class="gen">{userrow.USERNAME}</a> </span></td> ! <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="mailto:{userrow.EMAIL}" class="gen">{userrow.EMAIL}</a> </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> {userrow.JOINDATE} </span></td> <td class="{userrow.ROW_CLASS}" align="center" nowrap="nowrap"><span class="gen"> <a href="{userrow.U_VIEWPOSTS}" class="gen">{userrow.POSTS}</a> </span></td> |
|
From: Adam A. <ra...@us...> - 2004-05-19 21:44:52
|
Update of /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10114/templates/subSilver/admin Modified Files: admin_user_search_form.tpl Log Message: Preparing for RC2 Index: admin_user_search_form.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin/admin_user_search_form.tpl,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** admin_user_search_form.tpl 3 May 2004 06:36:26 -0000 1.3 --- admin_user_search_form.tpl 19 May 2004 21:44:42 -0000 1.4 *************** *** 9,13 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERNAME}: <input class="post" type="text" name="username" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_username" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 9,13 ---- </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERNAME}: <input class="post" type="text" name="username" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_username" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_username_regex" value="true" /></span></td> </tr> <tr> *************** *** 18,22 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_EMAIL}: <input class="post" type="text" name="email" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_email" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 18,22 ---- </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_EMAIL}: <input class="post" type="text" name="email" value="" maxlength="255" size="25" /> <input type="submit" class="post2" name="search_email" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_email_regex" value="true" /></span></td> </tr> <tr> *************** *** 56,60 **** <!-- END groups_exist --> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_POSTCOUNT} <select name="postcount_type"><option value="equals" selected="selected">{L_EQUALS}</option><option value="lesser">{L_LESSERTHAN}</option><option value="greater">{L_GREATTHAN}</option></select> <input class="post" type="text" name="postcount_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_postcount" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 56,60 ---- <!-- END groups_exist --> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_POSTCOUNT} <select name="postcount_type"><option value="equals" selected="selected">{L_EQUALS}</option><option value="lesser">{L_LESSERTHAN}</option><option value="greater">{L_GREATERTHAN}</option></select> <input class="post" type="text" name="postcount_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_postcount" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 62,66 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERFIELD}: <select name="userfield_type"><option value="icq" selected="selected">{L_ICQ}</option><option value="aim">{L_AIM}</option><option value="msn">{L_MSN}</option><option value="yahoo">{L_YAHOO}</option><option value="website">{L_WEBSITE}</option><option value="location">{L_LOCATION}</option><option value="interests">{L_INTERESTS}</option></select> <input class="post" type="text" name="userfield_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_userfield" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 62,69 ---- </tr> <tr> ! <td class="catBottom" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERFIELD}: <select name="userfield_type"><option value="icq" selected="selected">{L_ICQ}</option><option value="aim">{L_AIM}</option><option value="msn">{L_MSN}</option><option value="yahoo">{L_YAHOO}</option><option value="website">{L_WEBSITE}</option><option value="location">{L_LOCATION}</option><option value="interests">{L_INTERESTS}</option></select> <input class="post" type="text" name="userfield_value" value="" maxlength="25" size="25" /> <input type="submit" class="post2" name="search_userfield" value="{L_SEARCH}" /> {L_REGEX} <input type="checkbox" name="search_userfield_regex" value="true" /></span></td> </tr> <tr> *************** *** 68,72 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: <select name="language_type">{LANGUAGE_LIST}</select> <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 71,78 ---- </tr> <tr> ! <td class="catBottom" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: {LANGUAGE_LIST} <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 74,78 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_TIMEZONE}: <select name="timezone_type">{TIMEZONE_LIST}</select> <input type="submit" class="post2" name="search_timezone" value="{L_SEARCH}" /></span></td> </tr> <tr> --- 80,87 ---- </tr> <tr> ! <td class="catBottom" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_TIMEZONE}: {TIMEZONE_LIST} <input type="submit" class="post2" name="search_timezone" value="{L_SEARCH}" /></span></td> </tr> <tr> *************** *** 80,88 **** </tr> <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_STYLE}: <select name="style_type">{STYLE_LIST}</select> <input type="submit" class="post2" name="search_style" value="{L_SEARCH}" /></span></td> </tr> <tr> <td class="row3" align="left"><span class="gensmall">{L_STYLE_EXPLAIN}</span></td> </tr> <!-- BEGIN forums_exist --> <tr> --- 89,103 ---- </tr> <tr> ! <td class="catBottom" colspan="1" height="28"> </td> ! </tr> ! <tr> ! <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_STYLE}: {STYLE_LIST} <input type="submit" class="post2" name="search_style" value="{L_SEARCH}" /></span></td> </tr> <tr> <td class="row3" align="left"><span class="gensmall">{L_STYLE_EXPLAIN}</span></td> </tr> + <tr> + <td class="catBottom" colspan="1" height="28"> </td> + </tr> <!-- BEGIN forums_exist --> <tr> *************** *** 92,95 **** --- 107,113 ---- <td class="row3" align="left"><span class="gensmall">{L_MODERATORS_OF_EXPLAIN}</span></td> </tr> + <tr> + <td class="catBottom" colspan="1" height="28"> </td> + </tr> <!-- END forums_exist --> <tr> |
|
From: Adam A. <ra...@us...> - 2004-05-19 21:44:51
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10114/admin Modified Files: admin_user_search.php Log Message: Preparing for RC2 Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** admin_user_search.php 3 May 2004 06:36:24 -0000 1.6 --- admin_user_search.php 19 May 2004 21:44:41 -0000 1.7 *************** *** 35,38 **** --- 35,39 ---- require($phpbb_root_path . 'extension.inc'); require('./pagestart.' . $phpEx); + require($phpbb_root_path . 'includes/functions_selects.' . $phpEx); include($phpbb_root_path.'language/lang_' . $board_config['default_lang'] . '/lang_user_search.'.$phpEx); *************** *** 64,67 **** --- 65,104 ---- } + $language_list = language_select('', 'language_type'); + $timezone_list = tz_select('', 'timezone_type'); + + $sql = "SELECT f.forum_id, f.forum_name, c.cat_id, c.cat_title + FROM ( ". FORUMS_TABLE ." AS f INNER JOIN ". CATEGORIES_TABLE ." AS c ON c.cat_id = f.cat_id ) + ORDER BY c.cat_order, f.forum_order ASC"; + + if(!$result = $db->sql_query($sql)) + { + message_die(GENERAL_ERROR, 'Could not select forum data', '', __LINE__, __FILE__, $sql); + } + + $forums = array(); + + if($db->sql_numrows($result) != 0) + { + $template->assign_block_vars('forums_exist', array()); + + $last_cat_id = -1; + + $forums_list = ''; + + while($row = $db->sql_fetchrow($result)) + { + if($row['cat_id'] != $last_cat_id) + { + $forums_list .= '<optgroup label="'.$row['cat_title'].'">'; + $last_cat_id = $row['cat_id']; + } + + $forums_list .= '<option value="'.$row['forum_id'].'">'.$row['forum_name'].'</option>'; + } + } + + $styles_list = style_select('', 'style_type'); + $template->set_filenames(array( "body" => "admin/admin_user_search_form.tpl" *************** *** 81,84 **** --- 118,122 ---- 'L_BEFORE' => $lang['Before'], 'L_AFTER' => $lang['After'], + 'L_REGEX' => $lang['Regular_expression'], 'L_JOIN_DATE_EXPLAIN' => $lang['Search_users_joined_explain'], 'L_GROUP_MEMBERS' => $lang['Group_Members'], *************** *** 109,113 **** 'L_TIMEZONE_EXPLAIN' => $lang['Search_users_timezone_explain'], 'L_STYLE' => $lang['Board_style'], ! 'L_STYLE_EXPLAIN' => $lang['Search_users_timezone_explain'], 'L_MODERATORS_OF' => $lang['Moderators_of'], 'L_MODERATORS_OF_EXPLAIN' => $lang['Search_users_moderators_explain'], --- 147,151 ---- 'L_TIMEZONE_EXPLAIN' => $lang['Search_users_timezone_explain'], 'L_STYLE' => $lang['Board_style'], ! 'L_STYLE_EXPLAIN' => $lang['Search_users_style_explain'], 'L_MODERATORS_OF' => $lang['Moderators_of'], 'L_MODERATORS_OF_EXPLAIN' => $lang['Search_users_moderators_explain'], *************** *** 118,125 **** 'DAY' => date("d"), 'GROUP_LIST' => $group_list, ! 'LANGUAGE_LIST' => ! 'TIMEZONE_LIST' => ! 'FORUMS_LIST' => ! 'STYLE_LIST' => 'S_SEARCH_ACTION' => append_sid("admin_user_search.$phpEx") --- 156,163 ---- 'DAY' => date("d"), 'GROUP_LIST' => $group_list, ! 'LANGUAGE_LIST' => $language_list, ! 'TIMEZONE_LIST' => $timezone_list, ! 'FORUMS_LIST' => $forums_list, ! 'STYLE_LIST' => $styles_list, 'S_SEARCH_ACTION' => append_sid("admin_user_search.$phpEx") *************** *** 151,154 **** --- 189,216 ---- $mode = 'search_group'; } + else if(isset($HTTP_POST_VARS['search_postcount'])||isset($HTTP_GET_VARS['search_postcount'])) + { + $mode = 'search_postcount'; + } + else if(isset($HTTP_POST_VARS['search_userfield'])||isset($HTTP_GET_VARS['search_userfield'])) + { + $mode = 'search_userfield'; + } + else if(isset($HTTP_POST_VARS['search_language'])||isset($HTTP_GET_VARS['search_language'])) + { + $mode = 'search_language'; + } + else if(isset($HTTP_POST_VARS['search_timezone'])||isset($HTTP_GET_VARS['search_timezone'])) + { + $mode = 'search_timezone'; + } + else if(isset($HTTP_POST_VARS['search_style'])||isset($HTTP_GET_VARS['search_style'])) + { + $mode = 'search_style'; + } + else if(isset($HTTP_POST_VARS['search_moderators'])||isset($HTTP_GET_VARS['search_moderators'])) + { + $mode = 'search_moderators'; + } else if(isset($HTTP_POST_VARS['search_misc'])||isset($HTTP_GET_VARS['search_misc'])) { *************** *** 156,164 **** } ! // validate fields switch($mode) { case 'search_username': $username = ( isset($HTTP_GET_VARS['username']) ) ? urldecode($HTTP_GET_VARS['username']) : $HTTP_POST_VARS['username']; if(!$username) --- 218,227 ---- } ! // validate fields (that they exist) switch($mode) { case 'search_username': $username = ( isset($HTTP_GET_VARS['username']) ) ? urldecode($HTTP_GET_VARS['username']) : $HTTP_POST_VARS['username']; + $regex = ( $HTTP_POST_VARS['search_username_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; if(!$username) *************** *** 170,173 **** --- 233,237 ---- case 'search_email': $email = ( isset($HTTP_GET_VARS['email']) ) ? urldecode($HTTP_GET_VARS['email']) : $HTTP_POST_VARS['email']; + $regex = ( $HTTP_POST_VARS['search_email_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; if(!$email) *************** *** 207,216 **** $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : urldecode($HTTP_GET_VARS['postcount_value']); ! if(!$postcount_type || !$postcount_value) { message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); } break; ! case 'search_miscfield': break; case 'search_misc': --- 271,325 ---- $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : urldecode($HTTP_GET_VARS['postcount_value']); ! if(!$postcount_type || ( !$postcount_value && $postcount_value != 0)) { message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); } break; ! case 'search_userfield': ! $userfield_type = ( isset($HTTP_POST_VARS['userfield_type'] ) ) ? $HTTP_POST_VARS['userfield_type'] : urldecode($HTTP_GET_VARS['userfield_type']); ! $userfield_value = ( isset($HTTP_POST_VARS['userfield_value'] ) ) ? $HTTP_POST_VARS['userfield_value'] : urldecode($HTTP_GET_VARS['userfield_value']); ! $regex = ( $HTTP_POST_VARS['search_userfield_regex'] ) ? true : ( $HTTP_GET_VARS['regex'] ) ? true : false; ! ! if(!$userfield_type || !$userfield_value) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_userfield']); ! } ! ! break; ! case 'search_language': ! $language_type = ( isset($HTTP_POST_VARS['language_type'] ) ) ? $HTTP_POST_VARS['language_type'] : urldecode($HTTP_GET_VARS['language_type']); ! ! if(!$language_type) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_language']); ! } ! ! break; ! case 'search_timezone': ! $timezone_type = ( isset($HTTP_POST_VARS['timezone_type'] ) ) ? $HTTP_POST_VARS['timezone_type'] : urldecode($HTTP_GET_VARS['timezone_type']); ! ! if(!$timezone_type && $timezone_type != 0) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_timezone']); ! } ! ! break; ! case 'search_style': ! $style_type = ( isset($HTTP_POST_VARS['style_type'] ) ) ? $HTTP_POST_VARS['style_type'] : urldecode($HTTP_GET_VARS['style_type']); ! ! if(!$style_type) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_style']); ! } ! ! break; ! case 'search_moderators': ! $moderators_forum = ( isset($HTTP_POST_VARS['moderators_forum'] ) ) ? $HTTP_POST_VARS['moderators_forum'] : urldecode($HTTP_GET_VARS['moderators_forum']); ! ! if(!$moderators_forum) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_moderators']); ! } ! break; case 'search_misc': *************** *** 228,231 **** --- 337,364 ---- FROM ".USERS_TABLE." AS u"; + $lower_b = 'LOWER('; + $lower_e = ')'; + if($regex) + { + switch(SQL_LAYER) + { + case 'postgres': + $op = '~'; + break; + case 'oracle': + // Oracle uses a different syntax, we'll handle that a little later + break; + case 'mysql': + case 'mysql4': + $op = 'REGEXP'; + break; + default: + message_die(GENERAL_MESSAGE, $lang['Search_no_regexp']); + } + + $lower_b = ''; + $lower_e = ''; + } + // validate data & prepare sql switch($mode) *************** *** 235,239 **** $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars($username))); ! $username = preg_replace('/\*/', '%', trim(strip_tags(strtolower($username)))); if($username == '') --- 368,385 ---- $text = sprintf($lang['Search_for_username'], strip_tags(htmlspecialchars($username))); ! ! if(!$regex) ! { ! $username = preg_replace('/\*/', '%', trim(strip_tags(strtolower($username)))); ! ! if(strstr($username, '%')) ! { ! $op = 'LIKE'; ! } ! else ! { ! $op = '='; ! } ! } if($username == '') *************** *** 242,262 **** } ! if(strstr($username, '%')) { ! $op = 'LIKE'; } else ! { ! $op = '='; } - - $total_sql .= "SELECT COUNT(user_id) AS total - FROM ".USERS_TABLE." - WHERE LOWER(username) $op '".str_replace("\'", "''", $username)."' - AND user_id <> ".ANONYMOUS; - - $select_sql .= " WHERE LOWER(u.username) $op '".str_replace("\'", "''", $username)."' - AND u.user_id <> ".ANONYMOUS; - break; case 'search_email': --- 388,411 ---- } ! if($regex && SQL_LAYER == 'oracle') { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE REGEXP_LIKE(username, '".str_replace("\'", "''", $username)."') ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE REGEXP_LIKE(u.username, '".str_replace("\'", "''", $username)."') ! AND u.user_id <> ".ANONYMOUS; } else ! { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE {$lower_b}username{$lower_e} $op '".str_replace("\'", "''", $username)."' ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE {$lower_b}u.username{$lower_e} $op '".str_replace("\'", "''", $username)."' ! AND u.user_id <> ".ANONYMOUS; } break; case 'search_email': *************** *** 265,269 **** $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars($email))); ! $email = preg_replace('/\*/', '%', trim(strip_tags(strtolower($email)))); if($email == '') --- 414,430 ---- $text = sprintf($lang['Search_for_email'], strip_tags(htmlspecialchars($email))); ! if(!$regex) ! { ! $email = preg_replace('/\*/', '%', trim(strip_tags(strtolower($email)))); ! ! if(strstr($email, '%')) ! { ! $op = 'LIKE'; ! } ! else ! { ! $op = '='; ! } ! } if($email == '') *************** *** 271,292 **** message_die(GENERAL_MESSAGE, $lang['Search_invalid_email']); } ! ! if(strstr($email, '%')) { ! $op = 'LIKE'; } else ! { ! $op = '='; } - - $total_sql .= "SELECT COUNT(user_id) AS total - FROM ".USERS_TABLE." - WHERE LOWER(user_email) $op '".str_replace("\'", "''", $email)."' - AND user_id <> ".ANONYMOUS; - - $select_sql .= " WHERE LOWER(u.user_email) $op '".str_replace("\'", "''", $email)."' - AND u.user_id <> ".ANONYMOUS; - break; case 'search_ip': --- 432,456 ---- message_die(GENERAL_MESSAGE, $lang['Search_invalid_email']); } ! ! if($regex && SQL_LAYER == 'oracle') { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE REGEXP_LIKE(user_email, '".str_replace("\'", "''", $email)."') ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE REGEXP_LIKE(u.user_email, '".str_replace("\'", "''", $email)."') ! AND u.user_id <> ".ANONYMOUS; } else ! { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE {$lower_b}user_email{$lower_e} $op '".str_replace("\'", "''", $email)."' ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE {$lower_b}u.user_email{$lower_e} $op '".str_replace("\'", "''", $email)."' ! AND u.user_id <> ".ANONYMOUS; } break; case 'search_ip': *************** *** 576,584 **** { $range = preg_split('/[-\s]+/', $postcount_value); ! $range_begin = intval($range[0]); $range_end = intval($range[1]); ! if($range_begin < $range_end) { message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); --- 740,748 ---- { $range = preg_split('/[-\s]+/', $postcount_value); ! $range_begin = intval($range[0]); $range_end = intval($range[1]); ! if($range_begin > $range_end) { message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); *************** *** 617,622 **** break; ! case 'search_miscfield': ! break; case 'search_misc': default: --- 781,978 ---- break; ! case 'search_userfield': ! $base_url .= "&search_userfield=true&userfield_type=".urlencode($userfield_type)."&userfield_value=".urlencode($userfield_value); ! ! $text = strip_tags(htmlspecialchars($userfield_value)); ! ! if(!$regex) ! { ! $userfield_value = preg_replace('/\*/', '%', trim(strip_tags(strtolower($userfield_value)))); ! ! if(strstr($userfield_value, '%')) ! { ! $op = 'LIKE'; ! } ! else ! { ! $op = '='; ! } ! } ! ! if($userfield_value == '') ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_userfield']); ! } ! ! $userfield_type = trim(strtolower($userfield_type)); ! ! switch($userfield_type) ! { ! case 'icq': ! $text = sprintf($lang['Search_for_userfield_icq'],$text); ! $field = 'user_icq'; ! break; ! case 'aim': ! $text = sprintf($lang['Search_for_userfield_aim'],$text); ! $field = 'user_aim'; ! break; ! case 'msn': ! $text = sprintf($lang['Search_for_userfield_msn'],$text); ! $field = 'user_msnm'; ! break; ! case 'yahoo': ! $text = sprintf($lang['Search_for_userfield_yahoo'],$text); ! $field = 'user_yahoo'; ! break; ! case 'website': ! $text = sprintf($lang['Search_for_userfield_website'],$text); ! $field = 'user_website'; ! break; ! case 'location': ! $text = sprintf($lang['Search_for_userfield_location'],$text); ! $field = 'user_from'; ! break; ! case 'interests': ! $text = sprintf($lang['Search_for_userfield_interests'],$text); ! $field = 'user_interests'; ! break; ! case 'occupation': ! $text = sprintf($lang['Search_for_userfield_occupation'],$text); ! $field = 'user_occ'; ! break; ! default: ! message_die(GENERAL_MESSAGE, $lang['Search_invalid']); ! } ! ! if($regex && SQL_LAYER == 'oracle') ! { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE REGEXP_LIKE($field, '".str_replace("\'", "''", $userfield_value)."') ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE REGEXP_LIKE(u.$field, '".str_replace("\'", "''", $userfield_value)."') ! AND u.user_id <> ".ANONYMOUS; ! } ! else ! { ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE {$lower_b}$field{$lower_e} $op '".str_replace("\'", "''", $userfield_value)."' ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE {$lower_b}u.$field{$lower_e} $op '".str_replace("\'", "''", $userfield_value)."' ! AND u.user_id <> ".ANONYMOUS; ! } ! ! break; ! case 'search_language': ! $base_url .= "&search_language=true&language_type=".urlencode($language_type); ! ! $language_type = trim(strtolower($language_type)); ! ! if($language_type == '') ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_language']); ! } ! ! $text = sprintf($lang['Search_for_language'], strip_tags(htmlspecialchars($language_type))); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_lang = '".str_replace("\'", "''", $language_type)."' ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_lang = '".str_replace("\'", "''", $language_type)."' ! AND u.user_id <> ".ANONYMOUS; ! ! break; ! case 'search_timezone': ! $base_url .= "&search_timezone=true&timezone_type=".urlencode($timezone_type); ! $text = sprintf($lang['Search_for_timezone'], strip_tags(htmlspecialchars($timezone_type))); ! ! $timezone_type = intval($timezone_type); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_timezone = $timezone_type ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_timezone = $timezone_type ! AND u.user_id <> ".ANONYMOUS; ! ! break; ! case 'search_style': ! $base_url .= "&search_style=true&style_type=".urlencode($style_type); ! ! $style_type = intval($style_type); ! ! $sql = "SELECT style_name ! FROM ".THEMES_TABLE." ! WHERE themes_id = ".$style_type; ! ! ! if(!$result = $db->sql_query($sql)) ! { ! message_die(GENERAL_ERROR, 'Could not select style data', '', __LINE__, __FILE__, $sql); ! } ! ! if($db->sql_numrows($result)==0) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_style']); ! } ! ! $style_name = $db->sql_fetchrow($result); ! ! $text = sprintf($lang['Search_for_style'], strip_tags(htmlspecialchars($style_name['style_name']))); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_style = $style_type ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_style = $style_type ! AND u.user_id <> ".ANONYMOUS; ! ! break; ! case 'search_moderators': ! $base_url .= "&search_moderators=true&style_type=".urlencode($moderators_forum); ! $moderators_forum = intval($moderators_forum); ! ! $sql = "SELECT forum_name ! FROM ".FORUMS_TABLE." ! WHERE forum_id = ".$moderators_forum; ! ! ! if(!$result = $db->sql_query($sql)) ! { ! message_die(GENERAL_ERROR, 'Could not select forum data', '', __LINE__, __FILE__, $sql); ! } ! ! if($db->sql_numrows($result)==0) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_moderators']); ! } ! ! $forum_name = $db->sql_fetchrow($result); ! ! $text = sprintf($lang['Search_for_moderators'], strip_tags(htmlspecialchars($forum_name['forum_name']))); ! ! $total_sql .= "SELECT COUNT(u.user_id) AS total ! FROM ".USERS_TABLE." AS u, ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa ! WHERE u.user_id = ug.user_id ! AND ug.group_id = g.group_id ! AND g.group_id = aa.group_id ! AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS." ! GROUP BY (u.user_id)"; ! ! $select_sql .= ", ".GROUPS_TABLE." AS g, ".USER_GROUP_TABLE." AS ug, ".AUTH_ACCESS_TABLE." AS aa ! WHERE u.user_id = ug.user_id ! AND ug.group_id = g.group_id ! AND g.group_id = aa.group_id ! AND aa.auth_mod = 1 ! AND u.user_id <> ".ANONYMOUS; ! break; case 'search_misc': default: *************** *** 691,694 **** --- 1047,1055 ---- } + if($regex) + { + $base_url .= '®ex=1'; + } + $select_sql .= " ORDER BY "; |
|
From: Adam A. <ra...@us...> - 2004-05-19 21:44:50
|
Update of /cvsroot/r45phpbbmods/user_search/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10114/language/lang_english Modified Files: lang_user_search.php Log Message: Preparing for RC2 Index: lang_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/language/lang_english/lang_user_search.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** lang_user_search.php 3 May 2004 06:36:24 -0000 1.7 --- lang_user_search.php 19 May 2004 21:44:41 -0000 1.8 *************** *** 27,34 **** --- 27,40 ---- $lang['Search_invalid_date'] = 'Invalid Date entered to Search'; $lang['Search_invalid_postcount'] = 'Invalid Post Count entered to Search'; + $lang['Search_invalid_userfield'] = 'Invalid Userfield data entered'; + $lang['Search_invalid_language'] = 'Invalid Language Selected'; + $lang['Search_invalid_style'] = 'Invalid Style Selected'; + $lang['Search_invalid_timezone'] = 'Invalid Timezone Selected'; + $lang['Search_invalid_moderators'] = 'Invalid Forum Selected'; $lang['Search_invalid'] = 'Invalid Search'; $lang['Search_invalid_day'] = 'The day you entered was invalid'; $lang['Search_invalid_month'] = 'The day you entered was invalid'; $lang['Search_invalid_year'] = 'The day you entered was invalid'; + $lang['Search_no_regexp'] = 'Your database does not support Regular Expression searching.'; $lang['Search_for_username'] = 'Searching usernames matching %s'; $lang['Search_for_email'] = 'Searching email addresses matching %s'; *************** *** 41,63 **** $lang['Search_for_disabled'] = 'Searching for disabled users'; $lang['Search_for_disabled_pms'] = 'Searching for users with disabled Private Messages'; ! $lang['Search_by_postcount_greater'] = 'Searching for users with a post count greater than %d'; ! $lang['Search_by_postcount_lesser'] = 'Searching for users with a post count less than %d'; ! $lang['Search_by_postcount_range'] = 'Searching for users with a post count between %d and %d'; ! $lang['Search_by_postcount_equals'] = 'Searching for users with a post count value of %d'; ! $lang['Search_by_userfield_yahoo'] = 'Searching for users with a Yahoo IM address matching %s'; ! $lang['Search_by_userfield_aim'] = 'Searching for users with an AIM address matching %s'; ! $lang['Search_by_userfield_msn'] = 'Searching for users with a MSN Messenger address matching %s'; ! $lang['Search_by_userfield_website'] = 'Searching for users with an Website matching %s'; ! $lang['Search_by_userfield_location'] = 'Searching for users with a Location matching %s'; ! $lang['Search_by_userfield_interests'] = 'Searching for users with their Interests field matching %s'; ! $lang['Search_by_userfield_occupation'] = 'Searching for users with their Occupation field matching %s'; ! $lang['Search_by_language'] = 'Searching for users who have set %s as their language'; ! $lang['Search_by_timezone'] = 'Searching for users who have set %s as their timezone'; ! $lang['Search_by_style'] = 'Searching for users who have set %s as their style'; ! $lang['Search_by_moderators'] = 'Search for moderators of the Forum -> %s'; $lang['Search_users_advanced'] = 'Advanced User Search'; $lang['Search_users_explain'] = 'This Module allows you to perform advanced searches for users on a wide range of criteria. Please read the descriptions under each field to understand each search option completely.'; ! $lang['Search_username_explain'] = 'Here you can perform a case insensitive search for usernames. If you would like to match part of the username, use * (an asterix) as a wildcard.'; ! $lang['Search_email_explain'] = 'Enter an expression to match a user\'s email address. This is case insensitive. If you want to do a partial match, use * (an asterix) as a wildcard.'; $lang['Search_ip_explain'] = 'Search for users who made posts made by a specific ip address (xxx.xxx.xxx.xxx), wildcard (xxx.xxx.xxx.*) or range (xxx.xxx.xxx.xxx-yyy.yyy.yyy.yyy). Note: the last quad .255 is considered the range of all the IPs in that quad. If you enter 10.0.0.255, it is just like entering 10.0.0.* (No IP is assigned .255 for that matter, it is reserved). Where you may encounter this is in ranges, 10.0.0.5-10.0.0.255 is the same as "10.0.0.*" . You should really enter 10.0.0.5-10.0.0.254 .'; $lang['Search_users_joined'] = 'Users that joined'; --- 47,70 ---- $lang['Search_for_disabled'] = 'Searching for disabled users'; $lang['Search_for_disabled_pms'] = 'Searching for users with disabled Private Messages'; ! $lang['Search_for_postcount_greater'] = 'Searching for users with a post count greater than %d'; ! $lang['Search_for_postcount_lesser'] = 'Searching for users with a post count less than %d'; ! $lang['Search_for_postcount_range'] = 'Searching for users with a post count between %d and %d'; ! $lang['Search_for_postcount_equals'] = 'Searching for users with a post count value of %d'; ! $lang['Search_for_userfield_icq'] = 'Searching for users with a ICQ address matching %s'; ! $lang['Search_for_userfield_yahoo'] = 'Searching for users with a Yahoo IM address matching %s'; ! $lang['Search_for_userfield_aim'] = 'Searching for users with an AIM address matching %s'; ! $lang['Search_for_userfield_msn'] = 'Searching for users with a MSN Messenger address matching %s'; ! $lang['Search_for_userfield_website'] = 'Searching for users with an Website matching %s'; ! $lang['Search_for_userfield_location'] = 'Searching for users with a Location matching %s'; ! $lang['Search_for_userfield_interests'] = 'Searching for users with their Interests field matching %s'; ! $lang['Search_for_userfield_occupation'] = 'Searching for users with their Occupation field matching %s'; ! $lang['Search_for_language'] = 'Searching for users who have set %s as their language'; ! $lang['Search_for_timezone'] = 'Searching for users who have set GMT %s as their timezone'; ! $lang['Search_for_style'] = 'Searching for users who have set %s as their style'; ! $lang['Search_for_moderators'] = 'Search for moderators of the Forum -> %s'; $lang['Search_users_advanced'] = 'Advanced User Search'; $lang['Search_users_explain'] = 'This Module allows you to perform advanced searches for users on a wide range of criteria. Please read the descriptions under each field to understand each search option completely.'; ! $lang['Search_username_explain'] = 'Here you can perform a case insensitive search for usernames. If you would like to match part of the username, use * (an asterix) as a wildcard. Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.'; ! $lang['Search_email_explain'] = 'Enter an expression to match a user\'s email address. This is case insensitive. If you want to do a partial match, use * (an asterix) as a wildcard. Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.'; $lang['Search_ip_explain'] = 'Search for users who made posts made by a specific ip address (xxx.xxx.xxx.xxx), wildcard (xxx.xxx.xxx.*) or range (xxx.xxx.xxx.xxx-yyy.yyy.yyy.yyy). Note: the last quad .255 is considered the range of all the IPs in that quad. If you enter 10.0.0.255, it is just like entering 10.0.0.* (No IP is assigned .255 for that matter, it is reserved). Where you may encounter this is in ranges, 10.0.0.5-10.0.0.255 is the same as "10.0.0.*" . You should really enter 10.0.0.5-10.0.0.254 .'; $lang['Search_users_joined'] = 'Users that joined'; *************** *** 77,81 **** $lang['Search_users_postcount_explain'] = 'You can search for users based on the Postcount value. You can either search by a specific value, greater than or lesser than a value or between two values. To do the range search, select "Equals" then put the beginning and ending values of the range separated by a dash (-), e.g. 10-15'; $lang['Userfield'] = 'Userfield'; ! $lang['Search_users_userfield_explain'] = 'Search for users based on various profile fields. Wildcards are supported using an asterix (*).'; $lang['Search_users_language_explain'] = 'This will display users whom have selected a specific language in their Profile'; $lang['Search_users_timezone_explain'] = 'Users who have selected a specific timezone in their profile'; --- 84,88 ---- $lang['Search_users_postcount_explain'] = 'You can search for users based on the Postcount value. You can either search by a specific value, greater than or lesser than a value or between two values. To do the range search, select "Equals" then put the beginning and ending values of the range separated by a dash (-), e.g. 10-15'; $lang['Userfield'] = 'Userfield'; ! $lang['Search_users_userfield_explain'] = 'Search for users based on various profile fields. Wildcards are supported using an asterix (*). Checking the Regular Expressions box will allow you to search based on your regex pattern. <strong>Note:</strong> Regular Expressions will only work in MySQL, PostgreSQL and Oracle 10g+.'; $lang['Search_users_language_explain'] = 'This will display users whom have selected a specific language in their Profile'; $lang['Search_users_timezone_explain'] = 'Users who have selected a specific timezone in their profile'; *************** *** 83,87 **** $lang['Moderators_of'] = 'Moderators of'; $lang['Search_users_moderators_explain'] = 'Search for users with Moderating permissions to a specific forum. Moderating permission either by User Permissions or by being in a Group with the right Group Permssions.'; ! $lang['Manage'] = 'Manage'; --- 90,94 ---- $lang['Moderators_of'] = 'Moderators of'; $lang['Search_users_moderators_explain'] = 'Search for users with Moderating permissions to a specific forum. Moderating permission either by User Permissions or by being in a Group with the right Group Permssions.'; ! $lang['Regular_expression'] = 'Regular Expression?'; $lang['Manage'] = 'Manage'; |
|
From: Adam A. <ra...@us...> - 2004-05-19 21:44:50
|
Update of /cvsroot/r45phpbbmods/user_search In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10114 Modified Files: INSTALL Log Message: Preparing for RC2 Index: INSTALL =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/INSTALL,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** INSTALL 12 Apr 2004 09:41:08 -0000 1.4 --- INSTALL 19 May 2004 21:44:40 -0000 1.5 *************** *** 4,10 **** ## MOD Description: This is an admin module for the ACP system. It allows Searching for users based on their ## username, email address, date registered, usergroup, permission status ! ## (mod/admin), banned, IP address (used to post), disabled accounts and disabled ! ## PM priviliges. ! ## MOD Version: 1.0.0 ## ## Installation Level: (Easy) --- 4,11 ---- ## MOD Description: This is an admin module for the ACP system. It allows Searching for users based on their ## username, email address, date registered, usergroup, permission status ! ## (mod/admin), post count, userfields (ICQ/Yahoo/Website/Interests/e.t.c.), Language, ! ## Timezone, Moderators (of a specific forum), banned users, IP address (used to post), ! ## disabled accounts and disabled PM priviliges. ! ## MOD Version: 1.0.0 RC 2 ## ## Installation Level: (Easy) *************** *** 23,30 **** ## MOD History: ## ! ## ??? - Version 1.0.0 ## - Fixed bug with LIMIT clause on main SELECT statement. Use the PostgreSQL syntax, ## LIMIT <num> OFFSET <offset>, rather than the ANSI/SQL Standard, LIMIT <offset>,<rows> ## - Fixed bug with the Sort Options text not showing up ## 2004/4/10 - Version 1.0.0 RC 1 ## - Initial Release --- 24,39 ---- ## MOD History: ## ! ## 2004/5/19 - Version 1.0.0 RC 2 ## - Fixed bug with LIMIT clause on main SELECT statement. Use the PostgreSQL syntax, ## LIMIT <num> OFFSET <offset>, rather than the ANSI/SQL Standard, LIMIT <offset>,<rows> ## - Fixed bug with the Sort Options text not showing up + ## - Added Features: + ## Regular Expression searching in Username and Emails + ## Postcount searching (Range, Equals, Less/Greater than) + ## Userfield Searching (ICQ, Website, e.t.c.) with Regex Support + ## Board Language (as per profile) + ## Style Selected (as per profile) + ## Timezone selected (as per profile) + ## Moderators of a specific forum ## 2004/4/10 - Version 1.0.0 RC 1 ## - Initial Release |
|
From: Adam A. <ra...@us...> - 2004-05-03 06:37:03
|
Update of /cvsroot/r45phpbbmods/user_search/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5985/admin Modified Files: admin_user_search.php Log Message: Just commiting what's there Index: admin_user_search.php =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/admin/admin_user_search.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** admin_user_search.php 12 Apr 2004 09:41:08 -0000 1.5 --- admin_user_search.php 3 May 2004 06:36:24 -0000 1.6 *************** *** 89,92 **** --- 89,115 ---- 'L_DISABLED_USERS' => $lang['Disabled_users'], 'L_USERS_DISABLED_PMS' => $lang['Users_disabled_pms'], + 'L_POSTCOUNT' => $lang['Postcount'], + 'L_POSTCOUNT_EXPLAIN' => $lang['Search_users_postcount_explain'], + 'L_EQUALS' => $lang['Equals'], + 'L_GREATERTHAN' => $lang['Greater_than'], + 'L_LESSERTHAN' => $lang['Less_than'], + 'L_USERFIELD' => $lang['Userfield'], + 'L_USERFIELD_EXPLAIN' => $lang['Search_users_userfield_explain'], + 'L_ICQ' => $lang['ICQ'], + 'L_AIM' => $lang['AIM'], + 'L_YAHOO' => $lang['YIM'], + 'L_MSN' => $lang['MSNM'], + 'L_WEBSITE' => $lang['Website'], + 'L_LOCATION' => $lang['Location'], + 'L_INTERESTS' => $lang['Interests'], + 'L_OCCUPATION' => $lang['Occupation'], + 'L_LANGUAGE' => $lang['Board_lang'], + 'L_LANGUAGE_EXPLAIN' => $lang['Search_users_language_explain'], + 'L_TIMEZONE' => $lang['Timezone'], + 'L_TIMEZONE_EXPLAIN' => $lang['Search_users_timezone_explain'], + 'L_STYLE' => $lang['Board_style'], + 'L_STYLE_EXPLAIN' => $lang['Search_users_timezone_explain'], + 'L_MODERATORS_OF' => $lang['Moderators_of'], + 'L_MODERATORS_OF_EXPLAIN' => $lang['Search_users_moderators_explain'], 'L_MISC_EXPLAIN' => $lang['Search_users_misc_explain'], *************** *** 95,98 **** --- 118,125 ---- 'DAY' => date("d"), 'GROUP_LIST' => $group_list, + 'LANGUAGE_LIST' => + 'TIMEZONE_LIST' => + 'FORUMS_LIST' => + 'STYLE_LIST' => 'S_SEARCH_ACTION' => append_sid("admin_user_search.$phpEx") *************** *** 175,179 **** message_die(GENERAL_MESSAGE, $lang['Search_invalid_group']); } ! break; case 'search_misc': default: --- 202,217 ---- message_die(GENERAL_MESSAGE, $lang['Search_invalid_group']); } ! break; ! case 'search_postcount': ! $postcount_type = ( isset($HTTP_POST_VARS['postcount_type'] ) ) ? $HTTP_POST_VARS['postcount_type'] : urldecode($HTTP_GET_VARS['postcount_type']); ! $postcount_value = ( isset($HTTP_POST_VARS['postcount_value'] ) ) ? $HTTP_POST_VARS['postcount_value'] : urldecode($HTTP_GET_VARS['postcount_value']); ! ! if(!$postcount_type || !$postcount_value) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); ! } ! break; ! case 'search_miscfield': ! break; case 'search_misc': default: *************** *** 182,186 **** { message_die(GENERAL_MESSAGE, $lang['Search_invalid']); ! } } --- 220,224 ---- { message_die(GENERAL_MESSAGE, $lang['Search_invalid']); ! } } *************** *** 498,502 **** AND u.user_id <> ".ANONYMOUS; ! break; case 'search_misc': default: --- 536,622 ---- AND u.user_id <> ".ANONYMOUS; ! break; ! case 'search_postcount': ! $postcount_type = trim(strtolower($postcount_type)); ! $postcount_value = trim(strtolower($postcount_value)); ! ! $base_url .= "&search_postcount=true&postcount_type=".urlencode($postcount_type)."&postcount_value=".urlencode($postcount_value); ! ! switch($postcount_type) ! { ! case 'greater': ! $postcount_value = intval($postcount_value); ! ! $text = sprintf($lang['Search_by_postcount_greater'], $postcount_value); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_posts > $postcount_value ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_posts > $postcount_value ! AND u.user_id <> ".ANONYMOUS; ! break; ! case 'lesser': ! $postcount_value = intval($postcount_value); ! ! $text = sprintf($lang['Search_by_postcount_lesser'], $postcount_value); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_posts < $postcount_value ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_posts < $postcount_value ! AND u.user_id <> ".ANONYMOUS; ! break; ! case 'equals': ! // looking for a - ! if(strstr($postcount_value, '-')) ! { ! $range = preg_split('/[-\s]+/', $postcount_value); ! ! $range_begin = intval($range[0]); ! $range_end = intval($range[1]); ! ! if($range_begin < $range_end) ! { ! message_die(GENERAL_MESSAGE, $lang['Search_invalid_postcount']); ! } ! ! $text = sprintf($lang['Search_by_postcount_range'], $range_begin, $range_end); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_posts >= $range_begin ! AND user_posts <= $range_end ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_posts >= $range_begin ! AND u.user_posts <= $range_end ! AND u.user_id <> ".ANONYMOUS; ! } ! else ! { ! $postcount_value = intval($postcount_value); ! ! $text = sprintf($lang['Search_by_postcount_equals'], $postcount_value); ! ! $total_sql .= "SELECT COUNT(user_id) AS total ! FROM ".USERS_TABLE." ! WHERE user_posts = $postcount_value ! AND user_id <> ".ANONYMOUS; ! ! $select_sql .= " WHERE u.user_posts = $postcount_value ! AND u.user_id <> ".ANONYMOUS; ! } ! break; ! default: ! message_die(GENERAL_MESSAGE, $lang['Search_invalid']); ! } ! ! break; ! case 'search_miscfield': ! break; case 'search_misc': default: |
|
From: Adam A. <ra...@us...> - 2004-05-03 06:36:35
|
Update of /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5985/templates/subSilver/admin Modified Files: admin_user_search_form.tpl Log Message: Just commiting what's there Index: admin_user_search_form.tpl =================================================================== RCS file: /cvsroot/r45phpbbmods/user_search/templates/subSilver/admin/admin_user_search_form.tpl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** admin_user_search_form.tpl 10 Apr 2004 07:40:55 -0000 1.2 --- admin_user_search_form.tpl 3 May 2004 06:36:26 -0000 1.3 *************** *** 56,59 **** --- 56,97 ---- <!-- END groups_exist --> <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_POSTCOUNT} <select name="postcount_type"><option value="equals" selected="selected">{L_EQUALS}</option><option value="lesser">{L_LESSERTHAN}</option><option value="greater">{L_GREATTHAN}</option></select> <input class="post" type="text" name="postcount_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_postcount" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_POSTCOUNT_EXPLAIN}</span></td> + </tr> + <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_USERFIELD}: <select name="userfield_type"><option value="icq" selected="selected">{L_ICQ}</option><option value="aim">{L_AIM}</option><option value="msn">{L_MSN}</option><option value="yahoo">{L_YAHOO}</option><option value="website">{L_WEBSITE}</option><option value="location">{L_LOCATION}</option><option value="interests">{L_INTERESTS}</option></select> <input class="post" type="text" name="userfield_value" value="" maxlength="25" size="5" /> <input type="submit" class="post2" name="search_userfield" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_USERFIELD_EXPLAIN}</span></td> + </tr> + <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_LANGUAGE}: <select name="language_type">{LANGUAGE_LIST}</select> <input type="submit" class="post2" name="search_language" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_LANGUAGE_EXPLAIN}</span></td> + </tr> + <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_TIMEZONE}: <select name="timezone_type">{TIMEZONE_LIST}</select> <input type="submit" class="post2" name="search_timezone" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_TIMEZONE_EXPLAIN}</span></td> + </tr> + <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_STYLE}: <select name="style_type">{STYLE_LIST}</select> <input type="submit" class="post2" name="search_style" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_STYLE_EXPLAIN}</span></td> + </tr> + <!-- BEGIN forums_exist --> + <tr> + <td class="row2" align="left" nowrap="nowrap"><span class="gen">{L_MODERATORS_OF}: <select name="moderators_forum">{FORUMS_LIST}</select> <input type="submit" class="post2" name="search_moderators" value="{L_SEARCH}" /></span></td> + </tr> + <tr> + <td class="row3" align="left"><span class="gensmall">{L_MODERATORS_OF_EXPLAIN}</span></td> + </tr> + <!-- END forums_exist --> + <tr> <td class="row2" align="left" nowrap="nowrap"><span class="gen"><select name="misc" class="post"><option value="admins" selected="selected">{L_ADMINS}</option><option value="mods">{L_MODS}</option><option value="banned">{L_BANNED_USERS}</option><option value="disabled">{L_DISABLED_USERS}</option><option value="disabled_pms">{L_USERS_DISABLED_PMS}</option></select> <input type="submit" class="post2" class="post2" name="search_misc" value="{L_SEARCH}" /></span></td> </tr> |
