Navigation

Changeset 125

Timestamp:

2008-01-09 22:02:03 (1 year ago)

Author:

hannes

Message:

using actual member id for search of a member's posts instead of always 1

Files:

r36	r125
129	129	$_username = $q->fetchColumn();
130	130	$q = NULL;
131		$query = 'SELECT p.postid, p.topic, p.poster, p.posttime, p.post, t.topictitle FROM ' . $SETTINGS['dbtableprefix'] . 'posts p, ' . $SETTINGS['dbtableprefix'] . 'topics t WHERE t.topicid=p.topic AND p.poster=:username AND p.postedbymember=1 %cond% ORDER BY p.posttime DESC';
	131	$query = 'SELECT p.postid, p.topic, p.poster, p.posttime, p.post, t.topictitle FROM ' . $SETTINGS['dbtableprefix'] . 'posts p, ' . $SETTINGS['dbtableprefix'] . 'topics t WHERE t.topicid=p.topic AND p.poster=:username AND p.postedbymember=:memberid %cond% ORDER BY p.posttime DESC';
132	132	break;
133	133	default:
…	…
157	157	$q->bindParam(':username', $_username, PDO::PARAM_STR);
158	158	$q2->bindParam(':username', $_username, PDO::PARAM_STR);
	159	$q->bindParam(':memberid', $all, PDO::PARAM_INT);
	160	$q2->bindParam(':memberid', $all, PDO::PARAM_INT);
159	161	}
160	162	$j = 0;