do you stil want the link and the access??

Arcanjo wrote:
do you stil want the link and the access??

Nope I am re-writing the SQL now and will let you know the change you have to make.

The change will have to be in the template that you use, I am doing this in default at the moment and hopefully this should work, have to put my old rarely used anymore,Advanced SQL hat on

Hi!!

Thanks allot...my portal (i think) is the first well suceded phpbb3 to fb/joomla in the momment...I realy need that hack..I will be in your depth

sorry my english in not as wen I am awake (didnt sleep all night)

Arcanjo

Dannymh wrote:
cstory wrote:
I did a 1.0.13 joomla install added Fireboard and your mod and all seems to work just fine.

Awesome, I was going crazy wondering why it worked for me and not for anyone else.

Dan

I will try to test it more fully tomorrow. I mostly tested the functionality of the admin panel and whether or not the forums were visible.

I haven't tested this but please try replacing the file in

components/com_fireboard/templates//plugins/recentposts/recentposts.php

Find:
[code:1] $query
= " SELECT u.id, ifnull(u.username, 'Guest') as username, ifnull(u.name,'Guest') as name,"
. " fb.subject, fb.id as fbid, fb.catid, from_unixtime(fb.time) as date, "
. " fb.hits, fb.locked,fb.topic_emoticon, fb.parent, sc.name as catname "
. " FROM #__fb_messages AS fb "
. " LEFT JOIN #__users AS u ON u.id = fb.userid"
. " INNER JOIN #__fb_categories sc on sc.id = fb.catid "
. " WHERE "
. ($category == '' ? "1=1 " : "(fb.catid IN ($category) or sc.parent IN ($category))"«»)
. " AND (sc.pub_accessNER JOIN #__fb_private_users pu on pu.forum_id = fb.catid "
. " WHERE "
. "pu.user_id = u.id"
. ($category == '' ? "1=1 " : "(fb.catid IN ($category) or sc.parent IN ($category))"«»)
. " AND (sc.pub_access $count";
[/code:1]


This is completely untested so quickly check and let me know how it goes, it most likely will remove all of the recent posts but it's a start

It keeps cutting off my post

Replace the above with
[code:1]
$query
= " SELECT pu.*, u.id, ifnull(u.username, 'Guest') as username, ifnull(u.name,'Guest') as name,"
. " fb.subject, fb.id as fbid, fb.catid, from_unixtime(fb.time) as date, "
. " fb.hits, fb.locked,fb.topic_emoticon, fb.parent, sc.name as catname "
. " FROM #__fb_messages AS fb "
. " LEFT JOIN #__users AS u ON u.id = fb.userid"
. " INNER JOIN #__fb_categories sc on sc.id = fb.catid "
. " INNER JOIN #__fb_private_users pu on pu.forum_id = fb.catid "
. " WHERE "
. "pu.user_id = u.id"
. ($category == '' ? "1=1 " : "(fb.catid IN ($category) or sc.parent IN ($category))"«»)
. " AND (sc.pub_access [/code:1]

Arrgh text keeps getting cut off.

But basically what I am trying to say is


Replace the top query with the bottom one in

Components/com_fireboard/template/plugin/recentpost/recentpost.php

Warning: Invalid argument supplied for foreach() ..

Arcanjo

ummm you shouldnt get the foreach errror

but never mind I realised that code excludes all recent posts.

I just checked my recent posts and it doesnt show any for private forums so the first step is lets get rid of the recent posts. I will get back to you with code. Then I will get the security working on the post level.

Dan

There is a simple fix for you, without code change.

You can go into the Fireboard Configuration >> Plugins >> Recent posts

And then enter the forum/category id's of the forums that are available and not private, therefore excluding any of the private ones. This will get you around the issue for now. Beyond that I will have to do more research and I wont have time until over the weekend


If they know the post id they can still view it however AFAIK but I will double check quickly. Though the above will at least stop them from being shown in recent posts