📄 members.inc.php
字号:
<tr><td class="altbg1"><?=$lang['members_search_birthday']?></td>
<td align="right" class="altbg2"><input type="text" name="birthyear" size="5" value="<?=dhtmlspecialchars($year)?>"> <?=$lang['year']?> <select name="birthmonth"><option value=""> </option><?=$monthselect?></select> <?=$lang['month']?> <select name="birthday"><option value=""> </option><?=$dayselect?></select> <?=$lang['day']?></td></tr>
</tbody>
</table><br><center>
<?
switch($submitname) {
case 'newslettersubmit': echo '<input class="button" type="submit" name="newslettersubmit" value="'.$lang['members_newsletter'].'">'; break;
case 'creditsubmit': echo '<input class="button" type="submit" name="creditsubmit" value="'.$lang['members_credits'].'">'; break;
default : echo '<input class="button" type="submit" name="searchsubmit" value="'.$lang['members_search'].'">  <input class="button" type="submit" name="deletesubmit" value="'.$lang['members_delete'].'">'; break;
}
echo '</center>';
}
if(submitcheck('searchsubmit', 1) || submitcheck('deletesubmit', 1) || submitcheck('newslettersubmit') || submitcheck('sendsubmit', 1) || submitcheck('creditsubmit') || submitcheck('updatecreditsubmit', 1)) {
$memberperpage = 100;
$page = max(1, intval($page));
$start_limit = ($page - 1) * $memberperpage;
$dateoffset = date('Z') - ($timeoffset * 3600);
$username = trim($username);
$conditions = '';
if($username != '') {
$usernames = explode(',', $username);
foreach($usernames as $username) {
$usernameary[] = ($cins ? '' : 'BINARY')." username LIKE '".str_replace(array('%', '*', '_'), array('\%', '%', '\_'), $username)."'";
}
$conditions .= " AND (".implode(' OR ', $usernameary).")";
}
$conditions .= $srchemail != '' ? " AND email LIKE '".str_replace('*', '%', $srchemail)."'" : '';
$conditions .= !empty($admingroupid) && !in_array('all', $admingroupid) != '' ? " AND adminid IN ('".implode('\',\'', $admingroupid)."')" : '';
$conditions .= !empty($usergroupid) && !in_array('all', $usergroupid) != '' ? " AND groupid IN ('".implode('\',\'', $usergroupid)."')" : '';
$conditions .= !empty($extusergroupid) && !in_array('all', $extusergroupid) != '' ? " AND extgroupids IN ('".implode('\',\'', $extusergroupid)."')" : '';
if(is_array($higher)) {
foreach($higher as $credit => $value) {
$credit = intval($credit);
$value = intval($value);
if($value != 0 && $credit > 0 && $credit < 9) {
$conditions .= " AND extcredits$credit>'$value'";
}
}
}
if(is_array($lower)) {
foreach($lower as $credit => $value) {
$credit = intval($credit);
$value = intval($value);
if($value != 0 && $credit > 0 && $credit < 9) {
$conditions .= " AND extcredits$credit<'$value'";
}
}
}
$conditions .= $postshigher != '' ? " AND posts>'$postshigher'" : '';
$conditions .= $postslower != '' ? " AND posts<'$postslower'" : '';
$conditions .= $regip != '' ? " AND regip LIKE '$regip%'" : '';
$conditions .= $lastip != '' ? " AND lastip LIKE '$lastip%'" : '';
$conditions .= $regdatebefore != '' ? " AND regdate<'".(strtotime($regdatebefore) + $dateoffset)."'" : '';
$conditions .= $regdateafter != '' ? " AND regdate>'".(strtotime($regdateafter) + $dateoffset)."'" : '';
$conditions .= $lastvisitafter != '' ? " AND lastvisit>'".(strtotime($lastvisitafter) + $dateoffset)."'" : '';
$conditions .= $lastvisitbefore != '' ? " AND lastvisit<'".(strtotime($lastvisitbefore) + $dateoffset)."'" : '';
$conditions .= $lastpostafter != '' ? " AND lastpost>'".(strtotime($lastpostafter) + $dateoffset)."'" : '';
$conditions .= $lastpostbefore != '' ? " AND lastpost<'".(strtotime($lastpostbefore) + $dateoffset)."'" : '';
$conditions .= $birthyear != '' || $birthmonth != '' || $birthday != '' ? " AND bday LIKE '".(($birthyear ? $birthyear : '%').'-'.($birthmonth ? $birthmonth : '%').'-'.($birthday ? $birthday : '%'))."'" : '';
$conditions .= submitcheck('newslettersubmit') || submitcheck('sendsubmit', 1) ? " AND newsletter='1'" : '';
if(!$conditions && !$uidarray && submitcheck('deletesubmit', 1)) {
cpmsg('members_search_invalid');
} else {
$conditions = '1'.$conditions;
}
$urladd = '';
foreach(array('admingroupid', 'usergroupid', 'extusergroupid') as $key) {
if(is_array($$key) && !in_array('all', $$key)) {
foreach($$key as $gid => $value) {
if($value != '') {
$urladd .= '&'.$key.'[]='.rawurlencode($value);
}
}
}
}
foreach(array('lower', 'higher') as $key) {
if(is_array($$key)) {
foreach($$key as $column => $value) {
$urladd .= '&'.$key.'['.$column.']='.rawurlencode($value);
}
}
}
$conditionurladd = "$urladd&cins=".rawurlencode($cins)."&username=".rawurlencode($username)."&srchemail=".rawurlencode($srchemail)."®datebefore=".rawurlencode($regdatebefore)."®dateafter=".rawurlencode($regdateafter)."&postshigher=".rawurlencode($postshigher)."&postslower=".rawurlencode($postslower)."®ip=".rawurlencode($regip)."&lastip=".rawurlencode($lastip)."&lastvisitafter=".rawurlencode($lastvisitafter)."&lastvisitbefore=".rawurlencode($lastvisitbefore)."&lastpostafter=".rawurlencode($lastpostafter)."&lastpostbefore=".rawurlencode($lastpostbefore)."&birthyear=".rawurlencode($birthyear)."&birthmonth=".rawurlencode($birthmonth)."&birthday=".rawurlencode($birthday);
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}members WHERE $conditions");
$membernum = $db->result($query, 0);
if(submitcheck('newslettersubmit') || submitcheck('creditsubmit')) {
if(submitcheck('creditsubmit', 1)) {
$next = 'updatecreditsubmit';
$variable = 'creditsnotify';
} else {
$next = 'sendsubmit';
$variable = 'newsletter';
}
?>
<br><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
<tr class="header"><td colspan="9"><?=$lang['members_search_result']?> <?=$membernum?></td></tr>
<?
if(!$membernum) {
echo '<tr><td bgcolor="'.ALTBG2.'" colspan="2">'.$lang['members_search_nonexistence'].'</td></tr></table><br></form>';
} else {
if($next == 'updatecreditsubmit') {
$creditscols = $creditsvalue = $resetcredits = $js_extcreditids = '';
for($i=1; $i<=8; $i++) {
$js_extcreditids .= (isset($extcredits[$i]) ? ($js_extcreditids ? ',' : '').$i : '');
$creditscols .= '<td width="10%">'.(isset($extcredits[$i]) ? $extcredits[$i]['title'] : 'extcredits'.$i).'</td>';
$creditsvalue .= '<td class="altbg'.($i % 2 + 1).'">'.(isset($extcredits[$i]) ? '<input type="text" size="3" name="addextcredits['.$i.']" value="0"> '.$extcredits['$i']['unit'] : '<input type="text" size="3" value="N/A" disabled>').'</td>';
$resetcredits .= '<td class="altbg'.($i % 2 + 1).'">'.(isset($extcredits[$i]) ? '<input type="checkbox" name="resetextcredits['.$i.']" value="1" class="radio" disabled> '.$extcredits['$i']['unit'] : '<input type="checkbox" disabled class="radio">').'</td>';
}
?>
<tr class="category" align="center"><td width="20%"><?=$lang['credits_title']?></td><?=$creditscols?></tr>
<tr align="center"><td class="altbg1"><input type="radio" name="updatecredittype" id="updatecredittype0" value="0" class="radio" onclick="var extcredits = new Array(<?=$js_extcreditids?>); for(k in extcredits) {$('resetextcredits['+extcredits[k]+']').disabled = true; $('addextcredits['+extcredits[k]+']').disabled = false;}" checked><?=$lang['members_credits_value']?></td><?=$creditsvalue?></tr>
<tr align="center"><td class="altbg1"><input type="radio" name="updatecredittype" id="updatecredittype1" value="1" class="radio" onclick="var extcredits = new Array(<?=$js_extcreditids?>); for(k in extcredits) {$('addextcredits['+extcredits[k]+']').disabled = true; $('resetextcredits['+extcredits[k]+']').disabled = false;}"><?=$lang['members_credits_clean']?> </td><?=$resetcredits?></tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
<tr class="header"><td colspan="2"><input class="checkbox" type="checkbox" name="sendcreditsletter" value="1" onclick="$('messagebody').disabled=!this.checked; $('messagebody').style.display = $('messagebody').style.display == '' ? 'none' : ''" class="checkbox"> <?=$lang['members_credits_notify']?></td></tr>
<?
}
$subject = $message = '';
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='$variable'");
if($settings = $db->result($query, 0)) {
$settings = unserialize($settings);
$subject = $settings['subject'];
$message = $settings['message'];
}
?>
<tbody id="messagebody"<?php echo $next == 'updatecreditsubmit' ? ' disabled style="display: none;"' : '';?>>
<tr>
<td class="altbg1"><?=$lang['subject']?>:</td>
<td class="altbg2"><input type="text" name="subject" size="80" value=<?=dhtmlspecialchars($subject)?>></td>
</tr>
<tr>
<td class="altbg1" valign="top"><?=$lang['message']?>:</td><td class="altbg2">
<textarea cols="80" rows="10" name="message"><?=dhtmlspecialchars($message)?></textarea></td></tr>
<tr>
<td class="altbg1"><?=$lang['members_newsletter_send_via']?></td>
<td class="altbg2">
<input class="radio" type="radio" value="email" name="sendvia"> <?=$lang['email']?>
<input class="radio" type="radio" value="pm" checked name="sendvia"> <?=$lang['pm']?>
</td></tr>
<tr>
<td class="altbg1"><?=$lang['members_newsletter_num']?></td>
<td class="altbg2"><input type="text" name="pertask" value="100" size="10"></td>
</tr>
</tbody>
</table><br>
<center><input class="button" type="submit" name="<?=$next?>" value="<?=$lang['submit']?>"></center></form>
<?
}
}
if(submitcheck('sendsubmit', 1) || submitcheck('updatecreditsubmit', 1)) {
if(submitcheck('updatecreditsubmit', 1)) {
$submit = 'updatecreditsubmit';
$variable = 'creditsnotify';
} else {
$submit = 'sendsubmit';
$variable = 'newsletter';
}
if(!empty($current)) {
$subject = $message = '';
$query = $db->query("SELECT value FROM {$tablepre}settings WHERE variable='$variable'");
if($settings = $db->result($query, 0)) {
$settings = unserialize($settings);
$subject = $settings['subject'];
$message = $settings['message'];
}
} else {
$current = 0;
if(($submit == 'sendsubmit' || !empty($sendcreditsletter)) && (!($subject = trim($subject)) || !($message = trim(str_replace("\t", ' ', $message))))) {
cpmsg('members_newsletter_sm_invalid');
}
if($submit == 'updatecreditsubmit') {
$updatesql = '';
if($updatecredittype == 0) {
if(is_array($addextcredits) && !empty($addextcredits)) {
foreach($addextcredits as $key => $value) {
$value = intval($value);
if(isset($extcredits[$key]) && !empty($value)) {
$updatesql .= ", extcredits{$key}=extcredits{$key}+($value)";
}
}
}
} else {
if(is_array($resetextcredits) && !empty($resetextcredits)) {
foreach($resetextcredits as $key => $value) {
$value = intval($value);
if(isset($extcredits[$key]) && !empty($value)) {
$updatesql .= ", extcredits{$key}=0";
}
}
}
}
if(!empty($updatesql)) {
$db->query("UPDATE {$tablepre}members set uid=uid $updatesql WHERE $conditions", 'UNBUFFTERED');
} else {
cpmsg('members_credits_invalid');
}
if(!$sendcreditsletter) {
cpmsg('members_credits_succeed');
}
}
$db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('$variable', '".
addslashes(serialize(array('subject' => $subject, 'message' => $message)))."')");
}
$pertask = intval($pertask);
$current = intval($current);
$uids = $emails = $comma = '';
if($sendvia == 'pm') {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -