New post blinking image for a specific forum [new version 2.2]

Description

This Mod. allows to you to put an blinking image For a specific forum.

Location of the image

see the attached images.

Features
1.0

easy to install but not the easiest.

2.0

easy to select the forum from you ACP Forums & Moderators ==>
Forum Manager ==> Edit forum ==> New Post blinking image For specific forum ,
you have to select Yes from [Enable New Post blinking image?]

Details

1 Product XML with 3 Plugins, 1 Sql Query AND 3 Phrases

Installation
**Important**: If you had install ver. 1.0 you have to import the product again for ver. 2.2
AND make sure you allow Overwrite and you have to edit the template again after REVERT it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[import the product]
[open template forumhome_forumbit_level2_post
search for:

id="f$forum[forumid]">

replace it with

id="f$forum[forumid]">
     <if condition="$forum['enpostblinking']"><if condition="$forum[statusicon]=='new'"><a href="showthread.php?$session[sessionurl]goto=newpost&amp;t=$lastpostinfo[lastthreadid]">
<img src="$forum[newblinkicon]" border="0" align="right" hspace="0" /></a></if></if>

then see attachment and the above Features for version 2.2]

Ver. History

1.0 On 19. Jan 2006 Initial Version
2.0 On 23. Jan 2006 Fix selecting more than forum and Updated Completely
2.1 On 24. Jan 2006 Fix Sql Query
2.2 ON 25. Jan 2006 Fix No Image Error when there's no new posts in MSIE

Donation::.

Feel Free To

LAsT ThINg

Click Install

Support Given For Who Clicked Install {ONLY}

[puertoblack2003]

when i enter multiple forum id number it won't save it refer back to forum id 1 and i want to use it in multiple forum...can anybody fix that problem....

[Developer]

Wait for next release coz. i have a proplem with this :surprised:

[Developer]

Originally Posted by nievesidenshop

when i enter multiple forum id number it won't save it refer back to forum id 1 and i want to use it in multiple forum...can anybody fix that problem....

FIXED With the new version and now to select the forum from forums&moderators

[puertoblack2003]

Originally Posted by Developer

FIXED With the new version and now to select the forum from forums&moderators

Database error:

PHP Code:

Invalid SQL:
UPDATE forum SET
    title_clean = 'Welcome To Puerto Tech Central',
    title = 'Welcome To Puerto Tech Central',
    description_clean = 'Welcome to are newest member',
    description = 'Welcome to are newest member',
    link = '',
    displayorder = 1,
    daysprune = -1,
    parentid = 1,
    newpostemail = '',
    newthreademail = '',
    ### Bitfield: forum.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 16, options - 16, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 131072, options - 131072, options),
        options = IF(options & 32768, options - 32768, options),
        options = IF(options & 8192, options, options + 8192),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 16384, options, options + 16384),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options, options + 128),
        options = IF(options & 512, options, options + 512),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options, options + 4096),
        options = IF(options & 65536, options, options + 65536),
    styleid = 0,
    password = '',
    banner = '',
    bannerlink = '',
    banneralt = '',
    bannercode = '',
    gallery = '0',
    gallery_rows = '',
    fh_banner = '',
    fh_url = '',
    fh_text = '',
    accessf_nb = 0,
    accesst_nb = 0,
    create_nb = 0,
    reply_nb = 0,
    forumkeywords = '',
    forumdescription = '',
    enpostblinking = 1,
    blinkingimage = '/images/new-developer.gif'
WHERE forumid = 3;

MySQL Error  : Unknown column 'enpostblinking' in 'field list'
Error Number : 1054
Date         : Monday, January 23rd 2006 @ 04:46:55 PM
Script       : http://www./admincp/forum.php
Referrer     : http://www./admincp/forum.php?do=edit&f=3
IP Address   :xxxxxxxxxxxxxxxxxx
Username     : xxxxxxxxxxx
Classname    : vb_database 

[puertoblack2003]

also when i tried to uninstalled it this is the error that was given

PHP Code:

Invalid SQL:
ALTER TABLE forum DROP enpostblinking, DROP blinkingimage;

MySQL Error  : Can't DROP 'enpostblinking'; check that column/key exists
Error Number : 1091
Date         : Monday, January 23rd 2006 @ 04:53:54 PM
Script       : http://www.xxxxxxxcom/admincp/plugin.php
Referrer     : http://www.xxxxxcom/admincp/plugin.php?do=productdelete&productid=developer-newpost&s=
IP Address   : xxxxxxxxxxxxxxx
Username     : xxxxxxxxxxxxxxx
Classname    : vb_database 

edited: product is still reading 1.0 not 2.0 :ermm:

[Developer]

Try The product now
i've fix sql query and tried it 2.1 released

[puertoblack2003]

Originally Posted by Developer

Try The product now
i've fix sql query and tried it 2.1 released

ok thank you

[ammarcom004]

good job thanks

[NuclioN]

Nice but when there's no new post it gives a red crossed (no image) error!