Notification of New Threads

[cpradio]

This probably is a dumb question but is there any way I can setup my forum to notify me a new thread is created in a specific category/board?

I am using YaBB SE for a support area for my open-source script and would like to be notified when new suggestions or bug reports come in.

-Matt

[Spaceman-Spiff]

try this mod: http://www.yabbse.org/community/index.php?board=134;action=display;threadid=20290

[cpradio]

okay, that mod is such crap.  I am having nothing but troubles with it as it doesnt use {$db_prefix} for the table names.

Anyways, I got it down to this error message:

Code Select Expand

You have an error in your SQL syntax near '}categories AS c LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT) WHERE ' at line 1

Here is the sql syntax:

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.memberGroups,c.ID_CAT, b.ID_CAT FROM {$db_prefix}categories AS c ' .
                               'LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT) WHERE ' .
                               $condition) or die($db_prefix." ".$condition."<br>".mysql_error());

Any ideas?

[David]

okay, that mod is such crap.

I think you need some attitude readjustment.  Not like any had to code this software let alone that mod.  Sheesh.

[cpradio]

by mod, i was refering to the module that i just tempted to installed based on the moderators' suggestion.

[Spaceman-Spiff]

if the mod isnt working, u can tell about it nicely in that thread, so Christian Land can update/fix it
better than saying "this mod is such crap"

i took a look at the mod, it's all using $db_prefix
only in the nt_db_mod.php file he forgot to, which can be fixed easily

[David]

by mod, i was refering to the module that i just tempted to installed based on the moderators' suggestion.

I fully understood what you were referring to.  You asked for a way to be notified on new threads.  Spaceman-Spiff went beyond just saying, "there is a mod" to providing you with a link to a mod ideas thread, which contained a link to a finished mod.  My point was that "okay, that mod is such crap." shows absolutly no respect for the mod author or anyone trying to help.  Just saying that you needed help with the mod and why would have sufficed versus saying it is crap.

[cpradio]

If you look at the replace code or the add before statements you will see yabbse_ not {$db_prefix}  this happens in a few of them not all of them.

Also I recall seeing him stating he will not provide support.

[David]

If you look at the replace code or the add before statements you will see yabbse_ not {$db_prefix}  this happens in a few of them not all of them.

Also I recall seeing him stating he will not provide support.

Alright, so either alter the mod to work, send Christian a PM asking for some help, or wait for raffael3d's new mod.

[cpradio]

okay, i agree using the word "crap" was inappropriate.  I am just frustrated that someone would post a mod that has so many flaws though, i can understand flaws are a part of programming.

The sql syntax error though is the only part i am concerned about.  I cannot find the problem.  I have looked at it for an hour and nothing is fixing it.

That is where I am stuck.  I fixed all of the other little tidbits of problems.  Could anyone help me with the sql query?

[David]

Try changing

{$db_prefix} to '.$db_prefix.'

for both categories and boards

[cpradio]

i already have.  {} tells php what is inbetween the two brackets is a variable and needs the variables' value to be displayed.

[David]

i already have.  {} tells php what is inbetween the two brackets is a variable and needs the variables' value to be displayed.

But look at the error.

You have an error in your SQL syntax near '}categories AS c LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT) WHERE ' at line 1

That error is from MySQL and shows the query it has been sent.  Looking at the part after LEFT JOIN you will see that PHP is not parsing the prefix number.

[mediman]

I´ll check the mod! I know Chris as a very accurate working coder....

mediman

[mediman]

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