[lifesourcerec]

Originally posted by Gilby
I just uploaded a new version. Same functionality, but it should eliminate most the errors people have had. You can find that in the first post in this thread.

If you've already installed the hack, make sure you run the SQL a few posts back as that will make a huge difference for when your tables get filled with a lot of posts. In one case it brought the query speed from around 30 seconds to a fraction of a second.

If you want a gauge of how long things are taking, you can rin the script like: http://www.yourserver.com/gateway.php?showqueries=1 and it'll print out all the SQL queries as well as the start and finish time of the queries.

After running that, I only get 1 error:

Warning: Cannot add header information - headers already sent by (output started at /forums/global.php:120) in /forums/gateway.php on line 428

6 group(s) gatewayed.
Logging in to news.tn.comcast.giganews.com, group rec.collecting.cards.discuss
Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=26)
Time before: 0.45870900154114
Time after: 0.45999503135681