Notification of New Threads

[[Unknown]]

I checked the mod! It works absolutly great!

The only 2 things i found:

1. In the funktion notifyBoards()

you have

Code Select Expand

$condition = ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator' ? '1' : "(FIND_IN_SET('$settings[7]', c.memberGroups) != 0 || c.memberGroups='')");   
   $result_boards = @mysql_query ('
      SELECT DISTINCT c.ID_CAT, b.ID_BOARD
      FROM yabbse_categories AS c
         LEFT JOIN yabbse_boards AS b ON (b.ID_CAT=c.ID_CAT)
      WHERE '.$condition);

to replace with

Code Select Expand

$condition = ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator' ? '1' : "(FIND_IN_SET('$settings[7]', c.memberGroups) != 0 || c.memberGroups='')");   
   $result_boards = @mysql_query ('
      SELECT DISTINCT c.ID_CAT, b.ID_BOARD
      FROM {$db_prefix}categories AS c
         LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT)
      WHERE '.$condition);

and in the file nt_db_mod.php  you have to hardcode your prefix or you change the tablename after you used this file in phpmyadmin...

mediman

Not completely correct...

Why does no one notice that SINGLE QUOTES don't parse variables?  Take a second look...

It should be:

Code Select Expand

$condition = ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator' ? '1' : "(FIND_IN_SET('$settings[7]', c.memberGroups) != 0 || c.memberGroups='')");  
  $result_boards = @mysql_query ('
     SELECT DISTINCT c.ID_CAT, b.ID_BOARD
     FROM ' . $db_prefix . 'categories AS c
        LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT)
     WHERE '.$condition);

Just like Spaceman-Spiff said.  NOTICE THE SINGLE QUOTES!

-[Unknown]

[mediman]

Correct [unknown]!

My bad  

but better is

Code Select Expand

$condition = ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator' ? '1' : "(FIND_IN_SET('$settings[7]', c.memberGroups) != 0 || c.memberGroups='')");  
 $result_boards = @mysql_query ('
     SELECT DISTINCT c.ID_CAT, b.ID_BOARD
     FROM ' . $db_prefix . 'categories AS c
       LEFT JOIN ' . $db_prefix . 'boards AS b ON (b.ID_CAT=c.ID_CAT)
     WHERE '.$condition);

@david sorry i didn´t saw your post... you said exactly what i postet!

mediman