![]() |
Quote:
yet for somereason now it decides to work on some but not others heh overall now its working to some degree which is a lot better then the other newsgroup/usenet hack out there for me, as I cant run cron jobs. so glad this is working and the support on this one is fast and good thanks to the creator of the hack. |
Damn, seems my server is blocked! :(
My server is in Denmark, I'm in England and all my ISP's block this... |
Quote:
|
No it's not your hack. It gives a message saying (giving my servers IP details) that it doesn't have rights to access, I tried another and it stopped in the same way with no message, When I 've tried a free server it works, but craply and without the newsgroups I want :-(
|
1 group(s) gatewayed.
502 Permission Denied - Access not permitted - newsmaster@ntli.net (Typhoon v1.2.3) Logging in to news.ntlworld.com, group rec.autos.simulators: I'm using my ISP user/pass even - but it's a no go :( |
damn it..
I had the hack running fine till I entered my details into the nntp_settings table. ie my websites details instead of the yoursite.com stuff... any ideas how this would make the gateway.php just sit there saying opening website and then doing what it was dong before, ie the white page and stuck at 50% status |
I'm just going to switch it to where there is no default server. Just set it up for each one separately.
|
Quote:
I turned all the groups to 0 ie dont download. and then turned each one back on seperatly. and its locking up on the only group to where I have made a reply to via the forums. I have deleted the thread I replied to, and it still locks up on that one group. Does this help you? EDIT: so at the moment I have turned off the one group that I most need as it has the most traffic :P EDIT 2: Sorry about my spelling it sucks I know. |
Quote:
At the moment I have stop all users from replying to the usenet groups. Any ideas? |
Everyone should run this SQL:
Code:
ALTER TABLE post ADD INDEX (isusenetpost); |
I'm waiting with bated breath for a stable version of this hack... or should it be thought of as stable now?
|
Quote:
|
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. |
Well... I uploaded the new files from the new post, now I'm getting this message:
1 group(s) gatewayed. Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp Then the script exits (it's now running about 2 seconds). Nothing gets imported... Running setlastmsg.php returns the following: 1 group(s) gatewayed. Logging in to news.microsoft.com, group microsoft.public.german.entwickler.dotnet.csharp: Max: newsgroup Min: such The lastmsg in the database stays at 0... I'll now try the other nntp.php you posted above... |
The same problem, the only difference is that there is a "12345" before the "logging in to ..."
|
I can say that the webdiscuss.com server works with this script. FANTASTIC!!!
The script doesn't work with my ISP's newserver though. I will need to search for a free one... |
May I congratulate you Gilby by telling you that it works - you just need to use a public newserver that does not require a username or password. :)
Cool - I am hunting down one with the forums I want right now... but it works! |
Now it seems to work - don't ask me why...
One thing, after import every post is set to the import date, not to the date it has really been posted to the NG. Is it possible to do that or is it a problem (timezones etc.)? |
Gilby,
Any news on the local user replies, and why they are locking up the gateway.php ie downloads from the usenet server works, yet uploads lockup. |
Not true in my case - all my imported posts and threads reflect the actual time of posting, not the import date.
Wanted to say again that this is a GREAT hack! The best one I have installed, and I have installed many! :) |
Quote:
|
Quote:
|
Quote:
|
Quote:
If you want to change how this works, you can go to line 77 and change the if-else statement that does this. So, you could comment out stuff something like: Code:
// if ($group[lastmsg] == 0){ |
Quote:
ALL SORRY ABOUT THE LENGTH OF THIS POST IT IS VERY LARGE: The script stops/locksup after it checks the newsgroup just before the the newsgroup to which i have posted to, as you can see the last group checked is: rec.arts.anime.marketplace, which is the newsgroup just before the rec.arts.anime.misc group to which I have posted my reply. --- Query: SELECT template FROM template WHERE title='options' Time before: 0.056210041046143 Time after: 0.058135986328125 -------------------------------------------------------------------------------- Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1' Time before: 0.068742990493774 Time after: 0.070780992507935 -------------------------------------------------------------------------------- Query: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,lo cation) VALUES ('d1c7dfccf2638fdec0d342fc87b444b0','1','194.117.1 33.180','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)','1014304767','/gateway.php?showqueries=1') Time before: 0.08442497253418 Time after: 0.085327982902527 -------------------------------------------------------------------------------- Warning: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:120) in /usr/home/wocsnet/public_html/admin/functions.php on line 1530 Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1' Time before: 0.086961030960083 Time after: 0.088186979293823 -------------------------------------------------------------------------------- Query: SELECT template,title FROM template WHERE (title IN ('gobutton','timezone','username_loggedout','usern ame_loggedin','phpinclude','headinclude','header', 'footer','forumjumpbit','forumjump','nav_linkoff', 'nav_linkon','navbar','nav_joiner','pagenav','page nav_curpage','pagenav_firstlink','pagenav_lastlink ','pagenav_nextlink','pagenav_pagelink','pagenav_p revlink') AND (templatesetid=-1 OR templatesetid='16')) ORDER BY templatesetid Time before: 0.088878035545349 Time after: 0.096379995346069 -------------------------------------------------------------------------------- Query: SELECT * FROM usergroup WHERE usergroupid=6 Time before: 0.10236001014709 Time after: 0.10398197174072 -------------------------------------------------------------------------------- Query: SELECT varname,value FROM nntp_settings Time before: 0.11269104480743 Time after: 0.11516797542572 -------------------------------------------------------------------------------- Query: SELECT * FROM nntp_groups WHERE enabled=1 Time before: 0.11601901054382 Time after: 0.11823499202728 -------------------------------------------------------------------------------- Warning: Cannot add header information - headers already sent by (output started at /usr/home/wocsnet/public_html/global.php:120) in /usr/home/wocsnet/public_html/gateway.php on line 433 14 group(s) gatewayed. 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 99 3216690 3216800 rec.arts.anime Logging in to news-text.blueyonder.co.uk, group rec.arts.anime: 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=59) Time before: 0.16228294372559 Time after: 0.17449402809143 -------------------------------------------------------------------------------- Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=59) Time before: 0.17489802837372 Time after: 0.18513000011444 -------------------------------------------------------------------------------- 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 117 3216740 3216874 rec.arts.anime.creative Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.creative: 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=60) Time before: 0.22879302501678 Time after: 0.29553496837616 -------------------------------------------------------------------------------- Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=60) Time before: 0.29594302177429 Time after: 0.35159695148468 -------------------------------------------------------------------------------- 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 293 3235896 3236281 rec.arts.anime.fandom Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.fandom: 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=67) Time before: 0.40430796146393 Time after: 0.43287003040314 -------------------------------------------------------------------------------- Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=67) Time before: 0.43329298496246 Time after: 0.45920097827911 -------------------------------------------------------------------------------- 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 15 3215061 3215129 rec.arts.anime.games Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.games: 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=68) Time before: 0.48813498020172 Time after: 0.49104905128479 -------------------------------------------------------------------------------- Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=68) Time before: 0.4914870262146 Time after: 0.49426400661469 -------------------------------------------------------------------------------- 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 0 2 1 rec.arts.anime.info Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.info: 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=69) Time before: 0.52041101455688 Time after: 0.5222350358963 -------------------------------------------------------------------------------- Query: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=69) Time before: 0.52265894412994 Time after: 0.52438294887543 -------------------------------------------------------------------------------- 200 Powered by Typhoon 2.0 -- http://www.highwinds-software.com/ (Typhoon v2.0.0) 381 More Authentication Required 502 Authentication Failed 211 456 3258414 3259022 rec.arts.anime.marketplace Logging in to news-text.blueyonder.co.uk, group rec.arts.anime.marketplace: 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=70) |
Just installed this. (In fact upgraded from fastforwards hack). Everything seems to work just fine from what I can tell.
Haven't tried the outgoing messages yet. Is there a way to disable peoples profiles being printed on them etc, as I don't think my members would be too keen on that. Also does it support proper threading of messages? One problem I've noticed straight away is that is doesn't truncate usenet names, meaning the thread starter table is often over long. In fastforwards hack the quoted text appeared in italics, any way to do that here? I'm sure I'll have more comments when I have more time to mess with it ;) |
Ok. I installed it and ran gateway,php and it seems to work. Since I am new to this, a) what would be a commandline for crontab and b) anyone know of a public server? I'm on cable access and we just use "news" which isn't really a server.
|
Quote:
Code:
$signature .= "$newthread[username]'s Profile: $settings[profileurl]$newthread[userid]\n"; Quote:
t where if the user modifies the subject line to be completely different, then a new thread will be created. Quote:
Quote:
Code:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]); Code:
$message[text] = preg_replace("/((\n[ ]*>[^\n]*)+)/","$1",$message[text]); vB code with in the code tags gets parsed... so the $1 that is shown in blue up there is [ i ][ color=blue ]$1[ /color ][ /i ], of course that's without the spaces. |
Quote:
Code:
5,15,25,35,45,55 * * * * /usr/bin/lynx -source "http://www.yourserver.com/vbdir/gateway.php?log=cron" crontab crontab.txt That'll set you up with a cron job that'll execute every 10 minutes. You can change the 5,15, etc part to be whatever you want. That corresponds to the minutes of the hours. |
Quote:
|
Quote:
Anyways, here's a change that I think will work, I haven't tested it though: Replace this line: Code:
$get_threadid=$DB_site->query("SELECT thread.threadid FROM thread,post WHERE thread.threadid=post.threadid and (thread.title='".addslashes($subject)."' OR post.title LIKE '%".addslashes($subject)."' OR thread.title='".addslashes($altsubject)."' OR post.title LIKE '%".addslashes($altsubject)."') and (post.msgid='".preg_replace("/\s/sU","' OR post.msgid='",addslashes(trim($message[references])))."') AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ") ORDER BY post.dateline DESC LIMIT 1"); Code:
$get_threadid=$DB_site->query("SELECT thread.threadid FROM thread,post WHERE thread.threadid=post.threadid and (post.msgid='".preg_replace("/\s/sU","' OR post.msgid='",addslashes(trim($message[references])))."') AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ") ORDER BY post.dateline DESC LIMIT 1"); |
It's working like a charm, Gilby. Incoming and outgoing messages work, the crontab has been set hourly and works great, and there has been no errors.
I suspect the reason why my ISP's newserver is not working is because it is hosted in Australia, and my site is hosted in the US. They must have blocked overseas connections. Anyway, it's all good. Thank you for a GREAT hack. All without needing to change a single file too. :) |
Glad to hear it's working for you! :)
Quote:
|
Sanjiyan, are you still having problems with new post going out to the newsgroup? I ran your script and it executed fully, without problems.
|
Well, thanks a lot Gilby, it worked like a charm. I really appreciate the support you are giving :)
|
Quote:
|
Quote:
Other than that, the server may not be recognizing the end of a post and it then left waiting for more. But before we can go there, we need to determine that you can actually post there. |
Quote:
|
Quote:
If that can be chopped to a limited number of characters that would be great. Doesn't matter so much on showthread as it's only one post that gets affected. |
Works great here. I installed v4 and now installed v5. But it works, thank you very much :)
|
All times are GMT. The time now is 05:47 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|