Automated Thread Prefixes

[Paul M]

I think you will need to update this ;

    SELECT thread.*
    FROM " . TABLE_PREFIX . "thread AS thread
    WHERE views > 99
    AND forumid IN (" . $fids . ")

[MarkFL]

Originally Posted by Paul M

I think you will need to update this ;

    SELECT thread.*
    FROM " . TABLE_PREFIX . "thread AS thread
    WHERE views > 99
    AND forumid IN (" . $fids . ")

Good catch, Paul. Yes, change "views" to "replycount" as well.

[iNate19]

Originally Posted by MarkFL

Good catch, Paul. Yes, change "views" to "replycount" as well.

I was testing it on the views option instead of reply count.

Also, I waited for the cron to run in its own for over 48 hours and nothing happened.

[MarkFL]

It appears that, in the last code you posted, the elseif conditions need opening parens in front of $vthread['views'].

[iNate19]

Originally Posted by MarkFL

It appears that, in the last code you posted, the elseif conditions need opening parens in front of $vthread['views'].

????

[MarkFL]

Look at the lines you posted of the form:

PHP Code:

elseif ($vthread['views'] < 499) AND ($vthread['Silver'] != $title2)) 


Those need to have this form:

PHP Code:

elseif (($vthread['views'] < 499) AND ($vthread['Silver'] != $title2)) 


[iNate19]

Originally Posted by MarkFL

Look at the lines you posted of the form:

PHP Code:

elseif ($vthread['views'] < 499) AND ($vthread['Silver'] != $title2)) 


Those need to have this form:

PHP Code:

elseif (($vthread['views'] < 499) AND ($vthread['Silver'] != $title2)) 


I made these corrections to the code I recently posted and have it working in a test forum, unfortunately only the "Bronze" prefix is working. It does not change to the next prefix after the thread views reach the next number

[MarkFL]

The name of the array being used in the while loop is $v_thread, not $vthread. That was a typo I introduced in my original code.