Quote:
Originally posted by fastforward
Line breaks work for me. I have also been unable to reproduce your other error. What platform are you on?
To verify that the script is sending things to usenet, run this query immediately after you post a thread. Substitute '$$newsgroup->{forumid}' with the forumid in which the thread was posted.
Code:
SELECT e.csig,
b.email,
b.showemail,
b.signature,
a.threadid,
a.postusername,
a.title,
d.newsgroup
FROM thread AS a,
user AS b,
usergroup AS c,
usenet_group AS d,
userfield AS e
WHERE a.visible=1
AND forumid=$$newsgroup->{forumid}
AND a.postuserid=b.userid
AND b.usergroupid=c.usergroupid
AND b.userid=e.userid
AND a.isusenetpost=0
AND a.forumid=d.forum;
|
Hi ya
I am on RedHat 7.0, PHP4.1.0, MySQL 3.23.45
When I run the query, it doesn't like e.csig so I removed it and it outputted this....
Code:
email showemail signature threadid postusername title newsgroup
james@dvd-critic.net 1 <center><table width="95%" height="10" bgcolor="#3... 353 James@DVD-Critic OT: Test post uk.media.dvd
--James