Usenet gateway

THIS THREAD IS CLOSED!
Posts in here will NOT be answered

This hack has undergone many major changes since this thread was started. Consequently, most of the posts have become dated and of little use. To coincide with the latest major release (20010712), a new one has been started.

See this thread for the latest version and discussion

[fastforward]

Originally posted by george_proost
cpfooter();

if ($action=="manual") {
if ($mode=="Delete") {
foreach ($lostmsgid as $i){
$DB_site->query("DELETE FROM usenet_article WHERE msgid='" . addslashes($i) . "'");

Don't know what to suggest I'm afraid. Nobody else has reported this problem and your file matches mine. I can only assume it is something specific to your PHP version or configuration.

[george_proost]

foreach clause is not supported in PHP3
now to figure out that standard loopy way
hmmmm.... its only the bottom part...
gotta figure out what it does!!

[fastforward]

Originally posted by george_proost
foreach clause is not supported in PHP3
now to figure out that standard loopy way
hmmmm.... its only the bottom part...
gotta figure out what it does!!

That entire function is for manually inserting orphan replies into threads. It doesn't work at the moment any way. I broke it when I made other changes You should be able to safely comment out the lot.

[george_proost]

Comment out the foreach all of them

## foreach ($lostmsgid as $i){

Insert after each of them

for($ix = 0; $ix < sizeof($lostmsgid); $ix++) {
$i = $lostmsgid[$ix];

that should do it .... I'm clean now with the parse error.

[webhost]

lastactivethread column is populated but still nothing. I did however use your recommendation and install other hack with the same results. Here is the forumdisplaybit template, I have at the bottom placed how I setup the 2 tables in your hack. I have also attached my functions.php in a zip format. My site is http://www.realwebhost.net

<tr align="center">
<td bgcolor="#DFDFDF"><img src="images/$thread[newoldhot].gif" border="0" alt=""></td>
<td bgcolor="#DFDFDF">$thread[icon]</td>
<td bgcolor="#F1F1F1" align="left" width="100%"><normalfont>$thread[gotonew] $paperclip$thread[movedprefix]$thread[typeprefix]<a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread[title]</a></normalfont> <smallfont>$thread[pagenav]</smallfont></td>
<td align="right"bgcolor="#DFDFDF" nowrap><smallfont> $forum[lastactiveiconid] $forum[lastactivethread] $thread[firstpostdate] $thread[firstposttime]<br>by <b>$thread[postedby]</b></smallfont></td>
<td bgcolor="#F1F1F1"><normalfont>
<a href="javascript:who($thread[threadid])">$thread[replycount]</a>
</normalfont></td>

Field Type Length/Set Attributes Null Default
lastactivethread varchar(64) Yes
lastactiveiconid smallint(5) UNSIGNED No 1

[fastforward]

Originally posted by webhost
lastactivethread column is populated but still nothing. I did however use your recommendation and install other hack with the same results. Here is the forumdisplaybit template, I have at the bottom placed how I setup the 2 tables in your hack.

I see one problem in your template, and that is the iconid. iconid only returns the number. You still need to add the image tag and 'icon' part of the name. Here's my template:

------------------------------------------------
<table cellpadding="0" cellspacing="0" border="0" width="100%" id="ltlink">
<tr>
<td rowspan="2" valign="top"><a href="$bburl/showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]" title="Go to last post"><img src="images/icons/icon$forum[lastactiveiconid].gif" border="0" alt="">&nbsp;</a></td>
<td align="left"><smallfont><a href="$bburl/showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]" title="Go to last post"><font color="#000000">$forum[lastactivethread]</font></a> (<a href="$bburl/member.php?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid] title="See $forum[lastposter]s profile">$forum[lastposter]</a>)</smallfont></td>
</tr>
<tr>
<td nowrap><smallfont>$forum[lastpostdate] <font color="#666686">$forum[lastposttime]</font></td>
</tr>
</table>
------------------------------------------------

Try just referencing it just by $lastactiveiconid and $lastactivethread, without the 'forum' bit. If that doesn't work, try $foruminfo[lasticonid] and $foruminfo[lastactivethread]

If that doesn't work, then you're on your own. I assume you are using the latest vB and are on php4?

[webhost]

yes vb2.0.1 php4
Thanks I'll try it

Joey

[webhost]

I tried! I think I give up for awhile and try to enjoy the 4th.

Happy July 4th everyone.

Joey

Thanks FastForward

[george_proost]

commented out line with following text

// global $DB_site;


caused a warning in admin
usenet.php ... PHP3 change

admin routine now clean for php3

[fastforward]

Originally posted by george_proost
commented out line with following text

// global $DB_site;


caused a warning in admin
usenet.php ... PHP3 change

admin routine now clean for php3

Are you sure it all still works?

The only thing that can safely be disabled is the [Review/Insert Orphans] option within the 'Groups' section. This is handled by the first block of functions you spoke about. $DB_site is the main database class that handles all database access.