www.gusucode.com > ShopEx481 & PHPWind 整合版码程序 > bbs/wap/msg.php

    <?php
require_once('global.php');

!$windid && wap_msg('not_login');
wap_header('msg',$db_bbsname);

InitGP(array('action'));

if (!$action) {

	$allnum = $newnum = 0;
	$query  = $db->query("SELECT COUNT(*) AS num,ifnew FROM pw_msg WHERE touid='$winduid' AND type='rebox' GROUP BY ifnew=0");
	while ($rt = $db->fetch_array($query)) {
		 $allnum += $rt['num'];
		$rt['ifnew'] && $newnum = $rt['num'];
	}
	require_once PrintEot('wap_msg');
	wap_footer();

} elseif ($action == 'new') {

	$msgdb = array();
	$query = $db->query("SELECT m.*,mc.title FROM pw_msg m LEFT JOIN pw_msgc mc USING(mid) WHERE m.touid='$winduid' AND m.type='rebox' AND m.ifnew=1 ORDER BY m.mdate DESC LIMIT 15");
	while ($rt = $db->fetch_array($query)) {
		$rt['title']	= wap_cv($rt['title']);
		$rt['username'] = wap_cv($rt['username']);
		$rt['mdate']	= get_date($rt['mdate']);
		$msgdb[] = $rt;
	}
	require_once PrintEot('wap_msg');
	wap_footer();

} elseif ($action == 'all') {

	$msgdb = array();
	$query = $db->query("SELECT m.*,mc.title FROM pw_msg m LEFT JOIN pw_msgc mc USING(mid) WHERE m.touid='$winduid' AND m.type='rebox' ORDER BY m.mdate DESC LIMIT 15");
	while ($rt = $db->fetch_array($query)) {
		$rt['title']	= wap_cv($rt['title']);
		$rt['username'] = wap_cv($rt['username']);
		$rt['mdate']	= get_date($rt['mdate'],"n-j G:i");
		$msgdb[] = $rt;
	}
	require_once PrintEot('wap_msg');
	wap_footer();

} elseif ($action == 'read') {

	$mid = (int)GetGP('mid');
	$rt  = $db->get_one("SELECT m.*,mc.title,mc.content FROM pw_msg m LEFT JOIN pw_msgc mc USING(mid) WHERE m.touid='$winduid' AND m.type='rebox' AND m.mid='$mid'");
	if (!$rt) {
		wap_msg('no_msg');
	}
	if ($rt['ifnew']) {
		$db->update("UPDATE pw_msg SET ifnew=0 WHERE mid='$rt[mid]'");
	}
	$rt['content']	= strip_tags($rt['content']);
	$rt['content']  = wap_cv($rt['content']);
	$rt['content']  = wap_code($rt['content']);
	$rt['content']  = substrs($rt['content'],$db_waplimit);
	$rt['title']	= wap_cv($rt['title']);
	$rt['username'] = wap_cv($rt['username']);
	$rt['mdate']	= get_date($rt['mdate']);
	require_once PrintEot('wap_msg');
	wap_footer();

} elseif ($action == 'write') {

	if (!$_POST['pwuser'] || !$_POST['title'] || !$_POST['content']) {

		InitGP(array('touid'));
		if (is_numeric($touid)) {
			$rt = $db->get_one("SELECT username FROM pw_members WHERE uid='$touid'");
			if ($rt) {
				$pwuser = $rt['username'];
			}
		}
		require_once PrintEot('wap_msg');
		wap_footer();

	} else {

		InitGP(array('pwuser','title','content'),'P');
		$rt = $db->get_one("SELECT uid,newpm,banpm,msggroups FROM pw_members WHERE username='$pwuser'");
		if (!$rt) {
			wap_msg('user_not_exists');
		}
		if ($rt['msggroups'] && strpos($rt['msggroups'],",$groupid,")===false || strpos($rt['banpm'],",$windid,")!==false) {
			wap_msg('msg_refuse');
		}
		$title	 = wap_cv($title);
		$content = wap_cv($content);
		$db->update("INSERT INTO pw_msg (touid,fromuid,username,type,ifnew,mdate) VALUES ('$rt[uid]','$winduid','$windid','rebox','1','$timestamp')");
		$mid = $db->insert_id();
		$db->update("REPLACE INTO pw_msgc(mid,title,content) VALUES ('$mid','$title','$content')");
		if ($rt['newpm']==0 || $rt['newpm']==2) {
			$rt['newpm']++;
			$db->update("UPDATE pw_members SET newpm='$rt[newpm]' WHERE uid='$rt[uid]'");
		}
		wap_msg('msg_success','msg.php');
	}
} elseif ($action == 'delete') {

	$mid = (int)GetGP('mid');
	$db->update("DELETE FROM pw_msg WHERE mid='$mid' AND type='rebox' AND touid='$winduid'");
	if ($db->affected_rows() > 0) {
		require_once(R_P.'require/msg.php');
		delete_msgc($mid);
	}
	wap_msg('msg_delete','msg.php');
}
?>