- Timestamp:
- Oct 31, 2009, 5:52:38 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php
r4143 r4159 100 100 /* Check groups list in database */ 101 101 $query = ' 102 103 104 105 102 SELECT id, name 103 FROM '.GROUPS_TABLE.' 104 ORDER BY name ASC 105 ;'; 106 106 107 107 $result = pwg_query($query); … … 226 226 { 227 227 $query = " 228 229 230 231 232 233 234 235 236 228 SELECT ".$conf['user_fields']['username']." 229 FROM ".USERS_TABLE." p1 230 WHERE EXISTS( 231 SELECT ".$conf['user_fields']['username']." 232 FROM ".USERS_TABLE." p2 233 WHERE p1.".$conf['user_fields']['id']." <> p2.".$conf['user_fields']['id']." 234 AND LOWER(p1.".$conf['user_fields']['username'].") = LOWER(p2.".$conf['user_fields']['username'].") 235 ) 236 ;"; 237 237 238 238 $result = pwg_query($query); … … 250 250 { 251 251 $query = " 252 253 254 252 SELECT ".$conf['user_fields']['username'].", ".$conf['user_fields']['email']." 253 FROM ".USERS_TABLE." 254 ;"; 255 255 256 256 $result = pwg_query($query); … … 269 269 { 270 270 $query = " 271 272 273 271 SELECT ".$conf['user_fields']['username'].", ".$conf['user_fields']['email']." 272 FROM ".USERS_TABLE." 273 ;"; 274 274 275 275 $result = pwg_query($query); … … 584 584 $typemail = 1; 585 585 $query = " 586 587 588 589 586 SELECT id, username, mail_address 587 FROM ".USERS_TABLE." 588 WHERE id = '".$user_id."' 589 ;"; 590 590 $data = mysql_fetch_array(pwg_query($query)); 591 591 … … 668 668 $typemail = 2; 669 669 $query = " 670 671 672 673 670 SELECT id, username, mail_address 671 FROM ".USERS_TABLE." 672 WHERE id = '".$user_id."' 673 ;"; 674 674 675 675 $data = mysql_fetch_array(pwg_query($query)); … … 752 752 { 753 753 $query = " 754 755 756 757 754 SELECT id, username, mail_address 755 FROM ".USERS_TABLE." 756 WHERE id = '".$user_id."' 757 ;"; 758 758 759 759 $data = mysql_fetch_array(pwg_query($query)); … … 781 781 782 782 $query = ' 783 784 785 786 783 SELECT id, name 784 FROM '.GROUPS_TABLE.' 785 ORDER BY name ASC 786 ;'; 787 787 788 788 $result = pwg_query($query); … … 1107 1107 { 1108 1108 $query = " 1109 1110 1111 1112 1109 SELECT id, username, mail_address 1110 FROM ".USERS_TABLE." 1111 WHERE id = '".$user_id."' 1112 ;"; 1113 1113 1114 1114 $data = mysql_fetch_array(pwg_query($query)); … … 1127 1127 } 1128 1128 } 1129 1130 if (isset($_POST['GhostTracker_Init'])) 1131 { 1132 /* Reset is only allowed for admins ! */ 1133 if (is_admin() and !is_adviser()) 1134 { 1135 $query1 = ' 1136 SELECT * 1137 FROM '.USER_LASTVISIT_TABLE.';'; 1138 1139 $count = mysql_num_rows(pwg_query($query1)); 1140 1141 if ($count <> 0) 1142 { 1143 $query = ' 1144 SELECT DISTINCT u.id, 1145 ui.status AS status 1146 FROM '.USERS_TABLE.' AS u 1147 INNER JOIN '.USER_INFOS_TABLE.' AS ui 1148 ON u.id = ui.user_id 1149 INNER JOIN '.USER_LASTVISIT_TABLE.' AS ulv 1150 ON u.id != ulv.user_id 1151 WHERE status != "webmaster" 1152 AND status != "guest" 1153 AND status != "admin" 1154 ORDER BY u.id ASC 1155 ;'; 1156 1157 $result = pwg_query($query); 1158 1159 while ($row = mysql_fetch_array($result)) 1160 { 1161 list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();')); 1162 1163 $query = " 1164 INSERT INTO ".USER_LASTVISIT_TABLE." (user_id, lastvisit, reminder) 1165 VALUES ('".$row['id']."','".$dbnow."','false') 1166 ;"; 1167 pwg_query($query); 1168 } 1169 } 1170 else if ($count == 0) 1171 { 1172 $query = ' 1173 SELECT DISTINCT u.id, 1174 ui.status AS status 1175 FROM '.USERS_TABLE.' AS u 1176 INNER JOIN '.USER_INFOS_TABLE.' AS ui 1177 ON u.id = ui.user_id 1178 WHERE status != "webmaster" 1179 AND status != "guest" 1180 AND status != "admin" 1181 ORDER BY u.id ASC 1182 ;'; 1183 1184 $result = pwg_query($query); 1185 1186 while($row = mysql_fetch_array($result)) 1187 { 1188 list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();')); 1189 1190 $query = " 1191 INSERT INTO ".USER_LASTVISIT_TABLE." (user_id, lastvisit, reminder) 1192 VALUES ('".$row['id']."','".$dbnow."','false') 1193 ;"; 1194 pwg_query($query); 1195 } 1196 } 1197 1198 array_push($page['infos'], l10n('GhostTracker_Init_OK')); 1199 } 1200 } 1129 1201 1130 1202 // +-----------------------------------------------------------------------+
Note: See TracChangeset
for help on using the changeset viewer.