[Done 1.4.1-1.5.1] Allowed User v1.2

[Porter]

  Thanks Sauron. Faublous work so far!

[Sauron]

I have released a version for YaBB SE 1.5.1 final.

You  can download it here:
Allowed User MOD 1.2 for YaBB SE 1.5.1 (final)

[goldpicks]

Step 9 looks for the following

if ($threadid == '')
      fatal_error($txt[472]);

This does not exist in my Display.php file.  In fact the only time "fatal_error($txt[472]);" is found is in the following statement

if (mysql_num_rows($request) == 0)
      fatal_error($txt[472]);

[Sauron]

It's alter the global - section:

global $sourcedir, $sc, $prev_next;

if ($currentboard == '')
   fatal_error($txt[1]);
if ($threadid == '')
   fatal_error($txt[472]);

If the last two lines doesn't exists, just add the code from the mod after

if ($currentboard == '')
   fatal_error($txt[1]);

[don_miguel]

Version 1.5.1 FINAL

Everything worked fine, but I got an error in the stats center ... any ideas?

Code Select Expand


You have an error in your SQL syntax near 'ORDER BY `numPosts` DESC LIMIT 10' at line 6
Datei: /domain/Sources/Stats.php
Zeile: 152

Thanks for your help!
Miguel

[Sauron]

This was a little error in the mod. I've updated the zip-file. Just download the new one and install it. If you install manually: Look in you Stats.php, some lines above the error occurs:

// Replaced by Allowed User MOD - Begin
$condition .= AU_GetWhereClause(' AND', '', true);
// Replaced by Allowed User MOD - End

and replace this with

// Replaced by Allowed User MOD - Begin
$condition .= AU_GetWhereClause(' AND', 'b.', true);
// Replaced by Allowed User MOD - End

[don_miguel]

I've made the change on Stats.php - but it doesnt work ...  

The error is the same as above ...

[Sauron]

Oh, sorry. I forgot something:

the condition-string should not be replaced, it should be added.

your Stats.php should now look like this:

   // Board top 10
   $condition = ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator' ? '1' : "(FIND_IN_SET('$settings[7]', c.memberGroups) != 0 || c.memberGroups='')");
   // Added by Allowed User MOD - Begin
   $condition .= AU_GetWhereClause(' AND', 'b.', true);
   // Added by Allowed User MOD - End
   $boards_result = mysql_query("
      SELECT DISTINCT b.ID_BOARD, b.name, b.numPosts
      FROM {$db_prefix}categories AS c
         LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT)
      WHERE $condition
      ORDER BY b.numPosts DESC LIMIT 10") or database_error(__FILE__, __LINE__);

[don_miguel]

 

Thanks for your quick reply and for your mod!
It works!

Miguel

[Vampy]

Hi! I was wondering if the problem of the Recent 10 posts was solved. Okay what I am getting at is that even when I restrict the board to only members, when a guest clicks on "Recent 10 posts" he can view the posts in the restricted board.

Can anyone help? I'm using YabbSE 1.51.

Thanks.

[Sauron]

Oh, I still forget some things:

- Recent 10 Post
- Top 10 Topics (Replys, Views)
- Forum History

I'll fix this the next days.

[Vampy]

Hi! Thanks a lot for all your effort. Well, thank goodness you said that you forgot about about some parts. For the past couple of day I was staring at the codes trying to figure out whether I did something wrong.

I'm new to php and trying to learn.  By the way, could you explain one part of the code to me. I was trying to figure out how that would select for which posts to display for the most recent 10 post.

Code Select Expand


if ($AU_WhereClause != '') $AU_WhereClause .= ' AND'; else $AU_WhereClause = $strsuffix;
            $AU_WhereClause .= " {$prfx}ID_BOARD <> $row_AUO[1] ";


I was reading some MySQL text and it tells me that the <> sign is used to mean "is not equal". But if that is the case, wouldn't that mean that boardis is not equal to the ID_BOARD? How would that still display the 10 most recent post? Sorry if this was a dumb question.

[Sauron]

The MOD reads the board-access-configuration from the database. Now, if there is a board configured "members only" and you are a registered member nothing happens and the content i.e. the recent 10 posts of the board is displayed. But if you are a guest the mod adds "where ID_BOARD <> [the id of the board]" to the mysql query; which means mysql won't select this board, because you don't have the permission to view it.

If you are interested in some more details just mail me. I won't spread this topic so much.

[Vampy]

Thanks for the enlightenment. I'll be looking forward to the Recent 10 posts fixed.

[jenigma]

The next version will include the following features:
- Membergroups
- More access option
- Options for moderators
- Other little things that will come to my mind

Hi Sauron. Is V1.2 the new version that includes features above, or the old version? If old, how close is the new version to completion? I've been awaiting, more or less patiently  , the enhanced version of your mod.