Hi, <br />to the Addons I have a question: How can I let the last forum contributions indicate, without contributions are indicated of the private forums with?<br /><br />Sorry for the Babelfish-Translation. <img src="/forum/images/graemlins/smile.gif" alt="" />

I think what your saying is how can you allow the viewing of information in private forums without the forums being accessable?<br /><br />I may have missed the mark on this so please excuse me if I did. I really regret not learning a second language or two. <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />Although when stationed in Germany I learned enough to get around at the time... lol <img src="/forum/images/graemlins/smile.gif" alt="" />

No, which is not completely which I would like. I would like that visitors are not announced in the forum, who cannot see Postings of the private forums on their own index side. <br /><br />An Example --> http://www.mysterynews.net/mysterynews/ <br /><br />It's Babelfish-Translation too. <img src="/forum/images/graemlins/laugh.gif" alt="" /> <br /><br />[Edit]"Neue Webseite" is a posting from a private Forum. This posting its showing for all people, who connect to my site, but its not accessable. It would be nice, when this posting not showing to all peoples

I think I got it now... (I hope)<br /><br />Only members with access see other members with the same access?<br /><br /><br />If this is correct, in what addon?

Not realy... <img src="/forum/images/graemlins/blush.gif" alt="" /><br />I mean topics not members. one the mainpage i can show last x topics with ubbttopthreads.php. In this numbers of topics are all topics from the forums (private or not private). It would be nice, when only the not private topics are showing.<br /><br />I hope you can understand these better, its not Babelfish-Translation. <img src="/forum/images/graemlins/grin.gif" alt="" />

ahhh ok understood. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />Is this something your looking for as a feature in IIP's news display? What addon in particular does this need to be done for?

Hmmm, i need this feature for the separate file ubbttopthreads.php for my selfmade HTML-Site. I dont need the IIP or something else. <img src="/forum/images/graemlins/blush.gif" alt="" /><br /><br />Many sites have the same look, how looking IIP 5.0. I will make my own Index-Site. <img src="/forum/images/graemlins/smirk.gif" alt="" />

Ohhh them addons... (I forget about them ones) lol<br /><br />I'll put some code together as soon as I can that will check the viewers access and display accordingly. <img src="/forum/images/graemlins/smile.gif" alt="" />

That would be nice. Many thanks from Germany. <img src="/forum/images/graemlins/laugh.gif" alt="" />

In your ubbttopthreads.php addon find this:<br /><br /><pre><font class="small">code:</font><hr><br />// -----------------------------<br />// End of the variables section<br /> require("$path/main.inc.php");<br /></pre><hr><br /><br />and change it to this:<br /><br /><pre><font class="small">code:</font><hr><br />// -----------------------------<br />// End of the variables section<br /> require_once("$path/main.inc.php");<br /> $userob = new user;<br /> $user = $userob -> authenticate("U_Groups");<br /> if ($user['U_Username']) {<br /> $Grouparray = split("-",$user['U_Groups']);<br /> $gsize = sizeof($Grouparray);<br /> $groupquery = "AND (";<br /> $g = 0;<br /> for ($i=0; $i<$gsize;$i++) {<br /> if (!preg_match("/[0-9]/",$Grouparray[$i])) { continue; };<br /> $g++;<br /> if ($g > 1) {<br /> $groupquery .= " OR ";<br /> }<br /> $groupquery .= "Bo_Read_Perm LIKE '%-$Grouparray[$i]-%'"; <br /> }<br /> $groupquery .= ")";<br /> }<br /> else {<br /> $groupquery = "AND Bo_Read_Perm LIKE '%-4-%'";<br /> }<br /></pre><hr><br /><br /><br />Then find this:<br /><br /><pre><font class="small">code:</font><hr><br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM {$config['tbprefix']}Posts <br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date'<br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br /></pre><hr><br /><br />and change it to this:<br /><br /><pre><font class="small">code:</font><hr><br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM {$config['tbprefix']}Posts <br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date'<br /> $groupquery <br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br /></pre><hr><br /><br /><br />Make sure your cookies are set site wide so that this script can authenticate the viewer if this is placed outside the .threads directory. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br /><br />I haven't tested this but it should work. <img src="/forum/images/graemlins/smile.gif" alt="" /><br />

There is an error:<br /><br /> [] SQL ERROR: Unable to do_query: SELECT B_Number, B_Posted, B_Last_Post, B_Username, B_Subject, B_Body, B_Main, B_Replies, B_Counter, B_Board FROM Posts WHERE B_Number = B_Main AND B_Last_Post > '1032462921' AND Bo_Read_Perm LIKE '%-4-%' ORDER BY B_Counter DESC LIMIT 10 <br />Table 'xxxxxxxx.Posts' doesn't exist<br /><br />Warning: Supplied argument is not a valid MySQL result resource in /xxxxxxxxx/webseiten/forum/mysql.inc.php on line 83<br /> [/] <br /><br />I have UBB Threads 6.0.3 installed.<br />I hope you can help me.

Sorry, the code I posted was for 6.1's addon.<br /><br />Replace this:<br /><br />FROM {$config['tbprefix']}Posts<br /><br /><br />to this:<br /><br />FROM w3t.Posts<br /><br /><br /><br /><br />In that code. <img src="/forum/images/graemlins/smile.gif" alt="" />

I got another error:<br /><br /> [] Warning: Cannot add header information - headers already sent by (output started at /xxxxxxx/webseiten/mysterynews/index.php:2) in /xxxxxxx/webseiten/forum/ubbt.inc.php on line 1664<br />SQL ERROR: Unable to do_query: SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board FROM w3t.Posts WHERE B_Number = B_Main AND B_Last_Post > '1032464179' AND (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-2-%' OR Bo_Read_Perm LIKE '%-5-%') ORDER BY B_Counter DESC LIMIT 10 <br />Access denied for user: 'xxxxxxx@localhost' to database 'w3t' [/]

The query looks good. Possibly there's an extra space after the ?> closing tag?<br /><br />I'm sort of at a loss on this one <img src="/forum/images/graemlins/crazy.gif" alt="" />

Hmm, there isnt a space after the closing tag. <img src="/forum/images/graemlins/confused.gif" alt="" />

Try the addon on a blank page and see if it works. Possibly something else causing it?<br /><br />Anyone else have an idea of what could be going on?

On a blank page there is the same problem. <img src="/forum/images/graemlins/frown.gif" alt="" /> <br /><br />[Edit] The original Code from the file is: <br /><br /> [] $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM w3t_Posts //<------------------ ????????<br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date' <br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> "; [/]

<pre><font class="small">code:</font><hr><br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM w3t_Posts<br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date'<br /> $groupquery<br /> ORDER BY $sort DESC <br /> LIMIT $totalthreads<br /> ";<br /></pre><hr><br /><br />Should be the code to use for the query. <img src="/forum/images/graemlins/smile.gif" alt="" />

Hmm, there is now another error:<br /><br /> [] Warning: Cannot add header information - headers already sent by (output started at /xxxxxxxxx/webseiten/mysterynews/test.php:10) in /xxxxxxxxx/webseiten/forum/ubbt.inc.php on line 1664<br />SQL ERROR: Unable to do_query: SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board FROM w3t_Posts WHERE B_Number = B_Main AND B_Last_Post > '1032469385' AND (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-2-%' OR Bo_Read_Perm LIKE '%-5-%') ORDER BY B_Counter DESC LIMIT 10 <br />Unknown column 'Bo_Read_Perm' in 'where clause'<br /><br />Warning: Supplied argument is not a valid MySQL result resource in /xxxxxxxxx/webseiten/forum/mysql.inc.php on line 83 [/]

LoL hmmmm perhaps 6.0.x didn't have that column?<br /><br />I'll have to dig out an old copy of 6.0.x and see what the groups are based on...<br /><br /><br />Will be a bit.

The problem is, there isnt a german copy for the 6.1 version. This version comes in the next few days, i hope. <img src="/forum/images/graemlins/shocked.gif" alt="" />

I'll take a look at the previous version though and see what I may be missing. <img src="/forum/images/graemlins/smile.gif" alt="" />

I believe that 'Bo_Read_Perm' is in the w3t_Boards table, not the w3t_Posts table. Maybe you need to do a join?

Ack... your right Dave, and I should have seen that from the Bo_ portion of the field...<br /><br />I'll look over that code again and do it right. I been doing to many things at the same time.<br /><br />Thanks Dave <img src="/forum/images/graemlins/smile.gif" alt="" />

Ok, thanks for your great help. <img src="/forum/images/graemlins/laugh.gif" alt="" /><br />I will go to bed now. The time here in Germany is 11:23pm, and i will sleeping now. <img src="/forum/images/graemlins/wink.gif" alt="" />

In your ubbttopthreads.php addon find this:<br /><br /><pre><font class="small">code:</font><hr><br />// -----------------------------<br />// End of the variables section<br /> require("$path/main.inc.php");<br /></pre><hr><br /><br />and change it to this:<br /><br /><pre><font class="small">code:</font><hr><br />// -----------------------------<br />// End of the variables section<br /> require_once("/ubbthreads/main.inc.php");<br /> <br /> $userob = new user;<br /> $user = $userob -> authenticate("U_Groups");<br /> if ($user['U_Username']) {<br /> $Grouparray = split("-",$user['U_Groups']);<br /> $gsize = sizeof($Grouparray);<br /> $groupquery = "(";<br /> $g = 0;<br /> for ($i=0; $i<$gsize;$i++) {<br /> if (!preg_match("/[0-9]/",$Grouparray[$i])) { continue; };<br /> $g++;<br /> if ($g > 1) {<br /> $groupquery .= " OR ";<br /> }<br /> $groupquery .= "Bo_Read_Perm LIKE '%-$Grouparray[$i]-%'"; <br /> }<br /> $groupquery .= ")";<br /> }<br /> else {<br /> $groupquery = "Bo_Read_Perm LIKE '%-4-%'";<br /> }<br /> $query = "<br /> SELECT Bo_Keyword<br /> FROM w3t_Boards<br /> WHERE $groupquery<br /> ";<br /> $sth = $dbh -> do_query($query);<br /> $boardquery = "AND (";<br /> $g = 0;<br /> while (list ($BKeyword) = $dbh -> fetch_array($sth)) {<br /> $g++;<br /> if ($g > 1) {<br /> $boardquery .= " OR ";<br /> }<br /> $boardquery .= "B_Board = '$BKeyword'";<br /> }<br /> $dbh -> finish_sth($sth);<br /> $boardquery .= ")";<br /> if (!$g) {<br /> $boardquery = "";<br /> }<br /></pre><hr><br /><br /><br />Then find this:<br /><br /><pre><font class="small">code:</font><hr><br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM w3t_Posts <br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date'<br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br /></pre><hr><br /><br />and change it to this:<br /><br /><pre><font class="small">code:</font><hr><br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board<br /> FROM w3t_Posts <br /> WHERE B_Number = B_Main<br /> AND B_Last_Post > '$date'<br /> $boardquery<br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br /></pre><hr><br /><br /><br />Ok, I just tested this on my local webserver and it worked fine. Hope it does for everyone else <img src="/forum/images/graemlins/smile.gif" alt="" />

Yeah, its work fine. Thanks for your great work. <img src="/forum/images/graemlins/laugh.gif" alt="" />

Hi JustDave,<br /><br />do you know, why i get this error message?<br /><br /> [] Warning: Cannot add header information - headers already sent by (output started at /xxxxxxxxx/webseiten/mysterynews/index.php:2) in /xxxxxxxxx/webseiten/forum/ubbt.inc.php on line 1664 [/]

I'm not sure what the cause would be. Usual problems are having a space after ?> closing tag and perhaps the setting of cookies could be interfering with thigns. If I could see the source code for the page in question I might be able to offer a better guess at what's going wrong. <img src="/forum/images/graemlins/smile.gif" alt="" />

On the index.php-file its only an include for the file ubbttopthreads.php<br /><br /> [] <?<br /> include "/xxxxxxxxx/webseiten/forum/addons/ubbttopthreads.php";<br /> ?> [/] <br /><br />How the cookies must setting?<br />On the Adminsite from ubbthreads i set the cookies with a slash "/".<br /><br />I hope you can understand my bad english. <img src="/forum/images/graemlins/laugh.gif" alt="" />

Is that the only code on the index page? Or is there other html in use. Even sending a header with html can cause the problem. I don't think it's a problem with .threads cookies just that it's possible that your already setting cookie values with other code or something of that nature.

I will send you a private message with the complete code. <img src="/forum/images/graemlins/smile.gif" alt="" />

The code looks fine. What I think the problem is is that the new "top threads" script is checking user access which uses the .threads cookie. In all of the .threads scripts this is done *before* the call to send_header is executed.<br /><br />Since you have this include after your html has sent the page header it may be causing a problem.<br /><br />What may need to be done is to place the authentication call before the <html> tag.<br />You will also need to remove this code from the ubbttopthreads.php script being included.<br /><br /><br /><?<br />require_once("/ubbthreads/main.inc.php");<br />$userob = new user;<br />$user = $userob -> authenticate("U_Groups");<br />?><br /><html><br /><br /><br /><br /><br />Then include the ubbttopthreads.php script in the body.<br /><br /><br /><body><br /><? include ("/ubbthreads/addons/ubbttopthreads.php"); ?><br /></body><br /><br /><br /><br /><br /><br />I think this should work. I hope I wasn't to obscure in describing this. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />

It looks good so far. I will inform you, when i get an error. Thanks for your great work. <img src="/forum/images/graemlins/grin.gif" alt="" />

Your Welcome <img src="/forum/images/graemlins/smile.gif" alt="" />

Ahhhhhhhhhhhhh, i will run amok. *grummel* <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />I got the same error message now at the top of the page, after i hit the reload-button in IE6.0 or Mozilla 1.1. <img src="/forum/images/graemlins/crazy.gif" alt="" /> <br /><br />Hmmmm, now its running fine. <img src="/forum/images/graemlins/confused.gif" alt="" /><br />Im to stupid, i think. <img src="/forum/images/graemlins/wink.gif" alt="" />

LoL now I'm starting to draw blanks... anyone else have an idea as to why this may be happening?<br /><br />Is this the same error... "headers already sent" ?<br /><br />I'm running out of fuel here... lol <img src="/forum/images/graemlins/crazy.gif" alt="" />