Changeset 4159 for extensions/NBC_UserAdvManager/trunk/admin
- Timestamp:
- Oct 31, 2009, 5:52:38 PM (14 years ago)
- Location:
- extensions/NBC_UserAdvManager/trunk/admin
- Files:
-
- 5 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 // +-----------------------------------------------------------------------+ -
extensions/NBC_UserAdvManager/trunk/admin/confirmmail.tpl
r4153 r4159 8 8 <ul> 9 9 <li><label>{'UserAdvManager_ConfirmMail_Info'|@translate}</label><br> 10 <input type="radio" value="true" {$UserAdvManager_CONFIRMMAIL_TIMEOUT_TRUE} name="UserAdvManager_ConfirmMail_TimeOut" /> {'UserAdvManager_ConfirmMail_TimeOut_true'|@translate}<br>11 <input type="radio" value="false" {$UserAdvManager_CONFIRMMAIL_TIMEOUT_FALSE} name="UserAdvManager_ConfirmMail_TimeOut" /> {'UserAdvManager_ConfirmMail_TimeOut_false'|@translate}<br><br>10 <input type="radio" value="true" {$UserAdvManager_CONFIRMMAIL_TIMEOUT_TRUE} name="UserAdvManager_ConfirmMail_TimeOut"> {'UserAdvManager_ConfirmMail_TimeOut_true'|@translate}<br> 11 <input type="radio" value="false" {$UserAdvManager_CONFIRMMAIL_TIMEOUT_FALSE} name="UserAdvManager_ConfirmMail_TimeOut"> {'UserAdvManager_ConfirmMail_TimeOut_false'|@translate}<br><br> 12 12 </li> 13 13 14 <li><label>{'UserAdvManager_ConfirmMail_Delay_Info'|@translate}</label><input type="text" name="UserAdvManager_ConfirmMail_Delay" value="{$UserAdvManager_CONFIRMMAIL_DELAY}" size="5" style="text-align: center;" /><br><br>14 <li><label>{'UserAdvManager_ConfirmMail_Delay_Info'|@translate}</label><input type="text" name="UserAdvManager_ConfirmMail_Delay" value="{$UserAdvManager_CONFIRMMAIL_DELAY}" size="5" style="text-align: center;"><br><br> 15 15 </li> 16 16 17 17 <li><label>{'UserAdvManager_ConfirmMail_Remail'|@translate}</label><br> 18 <input type="radio" value="true" {$UserAdvManager_CONFIRMMAIL_REMAIL_TRUE} name="UserAdvManager_ConfirmMail_Remail" /> {'UserAdvManager_ConfirmMail_Remail_true'|@translate}<br>19 <input type="radio" value="false" {$UserAdvManager_CONFIRMMAIL_REMAIL_FALSE} name="UserAdvManager_ConfirmMail_Remail" /> {'UserAdvManager_ConfirmMail_Remail_false'|@translate}<br><br>18 <input type="radio" value="true" {$UserAdvManager_CONFIRMMAIL_REMAIL_TRUE} name="UserAdvManager_ConfirmMail_Remail"> {'UserAdvManager_ConfirmMail_Remail_true'|@translate}<br> 19 <input type="radio" value="false" {$UserAdvManager_CONFIRMMAIL_REMAIL_FALSE} name="UserAdvManager_ConfirmMail_Remail"> {'UserAdvManager_ConfirmMail_Remail_false'|@translate}<br><br> 20 20 </li> 21 21 … … 38 38 {/if} 39 39 </ul> 40 <p><input class="submit" type="submit" value="{'submit'|@translate}" name="submit" {$TAG_INPUT_ENABLED} /></p>40 <p><input class="submit" type="submit" value="{'submit'|@translate}" name="submit" {$TAG_INPUT_ENABLED}></p> 41 41 </fieldset> 42 42 </form> -
extensions/NBC_UserAdvManager/trunk/admin/ghosttracker.tpl
r4147 r4159 7 7 <legend>{'GhostTracker_Title'|@translate}</legend> 8 8 <ul> 9 <li><label>{'UserAdvManager_GhostTracker_User_List'|@translate}</label><br> 10 <br> 9 <li><label>{'UserAdvManager_GhostTracker_Init'|@translate}</label><br><br> 10 11 <p> 12 <input class="submit" type="submit" value="{'GT_Reset'|@translate}" name="GhostTracker_Init" > 13 </p> 14 <br><br> 15 16 <li><label>{'UserAdvManager_GhostTracker_User_List'|@translate}</label><br><br> 11 17 12 18 <table class="table2" width="97%" summary=""> -
extensions/NBC_UserAdvManager/trunk/admin/global.tpl
r4153 r4159 59 59 <input type="radio" value="false" {$UserAdvManager_GHOSTRACKER_FALSE} name="UserAdvManager_GhostUser_Tracker">{'UserAdvManager_GhostTracker_false'|@translate}<br><br> 60 60 </li> 61 61 {if $UserAdvManager_GHOSTRACKER_TRUE} 62 <br> 63 <div style="text-align: left; color: green;"><b>{'UserAdvManager_GhostTracker_Notice'|@translate}</b></div> 64 <br> 65 {/if} 62 66 <li><label>{'UserAdvManager_GhostTracker_DayLimit'|@translate}</label><br> 63 67 <input type="text" name="UserAdvManager_GhostTracker_DayLimit" value="{$UserAdvManager_GHOSTRACKER_DAYLIMIT}" size="5" style="text-align: center;"><br><br> -
extensions/NBC_UserAdvManager/trunk/admin/usermanager.tpl
r4143 r4159 47 47 48 48 <p> 49 <input class="submit" type="submit" value="{'Delete_selected'|@translate}" name="Del_Selected" />50 <input class="submit" type="submit" value="{'Mail_without_key'|@translate}" name="Mail_Without_Key" />51 <input class="submit" type="submit" value="{'Mail_with_key'|@translate}" name="Mail_With_Key" />52 <input class="submit" type="submit" value="{'Force_Validation'|@translate}" name="Force_Validation" />49 <input class="submit" type="submit" value="{'Delete_selected'|@translate}" name="Del_Selected"> 50 <input class="submit" type="submit" value="{'Mail_without_key'|@translate}" name="Mail_Without_Key"> 51 <input class="submit" type="submit" value="{'Mail_with_key'|@translate}" name="Mail_With_Key"> 52 <input class="submit" type="submit" value="{'Force_Validation'|@translate}" name="Force_Validation"> 53 53 </p> 54 54 </fieldset>
Note: See TracChangeset
for help on using the changeset viewer.