The Arcive of Official vBulletin Modifications Site.

Posticons exlusive to forums. NO STYLE editing!!! · **Released**: 05-18-2005

This has been done before, but I've yet to see it released here. I was desperate to have this for my forums which has a lot of posticons.

This hack allows you to make posticons useable in only forums you specify. I'm no PHP expert, and I find it amazing how I pulled this off (Had a little help from someone to get it working correctly.), so you won't be able to set the settings through admincp yet. Instead, you have to manually do some changse in your MySQL database for each posticon.

Step 1 MySQL
First, you'll have to go to the icon table in your MySQL database. Create a field called iconforums in the table. Then edit each posticon (phpMyAdmin you'll have to click on the BROWSE tab in the table to edit the fields.), add the forumids to the iconforums field, seperating each forumid with only a comma.

Step 2
Now you'll have to edit your includes/functions_newpost.php.
FIND

Code:

		SELECT iconid, iconpath, title

REPLACE WITH

Code:

		SELECT iconid, iconpath, title, iconforums

FIND

Code:

	while ($icon = $DB_site->fetch_array($icons))

	{

ADD BELOW

Code:

	$forumid = $foruminfo[forumid];
		$forums = explode(',',$icon[iconforums]);
		if (in_array($forumid,$forums))
		{

FIND

Code:

			eval('$posticonbits .= "' . fetch_template('posticonbit') . '";');

ADD BELOW

Code:

FINISH! Enjoy you're cleaner forums.

Blackbeard · #2 05-19-2005, 05:47 AM

Sorry stupid Q but do you have a screenie of this one please.

Jenta · #3 05-19-2005, 05:59 AM

you know when u create a thread or post?
u have the icons u can use for that thread or post

this makes it so some icons will only show up in certain forums and hence can only be used in those forums

i have the perfect use for this, a coding forum where there are icons based on what code your thread is about
i find people using those icons in off topic :/

thanks

Oblivion Knight · #4 05-19-2005, 06:25 AM

Is it possible to do this per style instead of using replacements (which is what I'm currently doing)?

Jenta · #5 05-19-2005, 06:32 AM

perhaps, i have the wrong format for iconforums?
nothing is showing up

perhaps its this line?

PHP Code:


			
  `iconforums` varchar(100) NOT NULL default '',

PHP Code:


			
CREATE TABLE `icon` (

  `iconid` smallint(5) unsigned NOT NULL auto_increment,

  `iconforums` varchar(100) NOT NULL default '',

  `title` varchar(100) NOT NULL default '',

  `iconpath` varchar(100) NOT NULL default '',

  `imagecategoryid` smallint(5) unsigned NOT NULL default '0',

  `displayorder` smallint(5) unsigned NOT NULL default '1',

  PRIMARY KEY  (`iconid`)

) TYPE=MyISAM AUTO_INCREMENT=22 ;



-- 

-- Dumping data for table `icon`

-- 



INSERT INTO `icon` VALUES (1, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'News', 'images/icons/icon1.gif', 4, 1);

INSERT INTO `icon` VALUES (2, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Read This', 'images/icons/icon2.gif', 4, 1);

INSERT INTO `icon` VALUES (3, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Idea', 'images/icons/icon3.gif', 2, 21);

INSERT INTO `icon` VALUES (4, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Important!', 'images/icons/icon4.gif', 2, 30);

INSERT INTO `icon` VALUES (5, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Question', 'images/icons/icon5.gif', 2, 20);

INSERT INTO `icon` VALUES (6, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Cool', 'images/smilies/cool.gif', 2, 10);

INSERT INTO `icon` VALUES (7, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Smile', 'images/smilies/smile.gif', 2, 6);

INSERT INTO `icon` VALUES (8, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Angry', 'images/smilies/mad.gif', 2, 9);

INSERT INTO `icon` VALUES (9, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Unhappy', 'images/smilies/frown.gif', 2, 8);

INSERT INTO `icon` VALUES (10, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Big Smile', 'images/smilies/biggrin.gif', 2, 10);

INSERT INTO `icon` VALUES (11, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Red face', 'images/smilies/redface.gif', 2, 10);

INSERT INTO `icon` VALUES (12, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Wink', 'images/smilies/wink.gif', 2, 7);

INSERT INTO `icon` VALUES (13, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Thumbs down', 'images/icons/icon13.gif', 2, 25);

INSERT INTO `icon` VALUES (14, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Thumbs up', 'images/icons/icon14.gif', 2, 26);

INSERT INTO `icon` VALUES (15, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Very Important!', 'images/buttons/report.gif', 4, 1);

INSERT INTO `icon` VALUES (16, '2,3,4,5,6,7,8,10,11,12,13,14,15', 'Extremely Important!', 'images/icons/important.gif', 4, 4);

any ideas on the proper row structure?

ps, heres the code
as u can see its exactly as ur instructions say...

PHP Code:


			
    // original SELECT iconid, iconpath, title

    $icons = $DB_site->query("

        SELECT iconid, iconpath, title, iconforums

        FROM " . TABLE_PREFIX . "icon AS icon

        WHERE imagecategoryid NOT IN (0$badcategories)

        ORDER BY imagecategoryid, displayorder

    ");



    if (!$DB_site->num_rows($icons))

    {

        return false;

    }



    $numicons = 0;

    $show['posticons'] = false;



    while ($icon = $DB_site->fetch_array($icons))

    {

    // hack 

    $forumid = $foruminfo[forumid];

        $forums = explode(',',$icon[iconforums]);

        if (in_array($forumid,$forums))

        {

    // hack end

        $show['posticons'] = true;

        if ($numicons % 7 == 0 AND $numicons != 0)

        {

            $posticonbits .= "</tr><tr><td>&nbsp;</td>";

        }



        $numicons++;



        $iconid = $icon['iconid'];

        $iconpath = $icon['iconpath'];

        $alttext = $icon['title'];

        if ($seliconid == $iconid)

        {

            $iconchecked = HTML_CHECKED;

            $selectedicon = array('src' => $iconpath, 'alt' => $alttext);

        }

        else

        {

            $iconchecked = '';

        }



        eval('$posticonbits .= "' . fetch_template('posticonbit') . '";');

        // hack

        }

        // hack end



    }

boo.3 · #6 05-19-2005, 10:37 AM

screen shot?

tehcake · #7 05-19-2005, 02:05 PM

Sorry Jenta, but I'm not really a PHP/MySQL person, so I went into phpMyAdmin and did it all by hand instead of using a query. I don't know if it's the problem, but maybe it's the CREATE part because the icon table already exists?

Allan · #8 05-19-2005, 03:52 PM

Not bad yes, but could you put instruction in a .txt file, please

You have no image has to be proposed with this hack also ?

Jenta · #9 05-19-2005, 04:44 PM

Quote:

Originally Posted by tehcake

Sorry Jenta, but I'm not really a PHP/MySQL person, so I went into phpMyAdmin and did it all by hand instead of using a query. I don't know if it's the problem, but maybe it's the CREATE part because the icon table already exists?

the create code is just my dump of the table, i didnt use it to actually add ur row
its only to show the rows and what is in each

PHP Code:


			
`iconforums` varchar(100) NOT NULL default '',

this is the row you say to create
can you look at yours and see if its the same?

Jenta · #10 05-19-2005, 04:47 PM

argh, no automerge double post

anyways....

for those wanting an image, heres one straight from this forum
these are post icons
this hack lets u set which forum each post icon will appear in
its the same as setting an icon category that only certain usergroups can use but its forum bases instead of usergroup based

here's a scenario that might help some understand

lets say you run a decorating forum with different forums

one forum is for gardens and stuff
you have post icons like - rakes and wheelbarrows

then you have another forum about kitchens
you have icons like - cups and refrigerators

then u have a forum where people talk about everyday life - off topic
u dont want the cups, refrigirators, rakes or wheelbarrrow appearing there

opps, just say he added some icons
nm

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05017 seconds Memory Usage 2,347KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (6)bbcode_code (4)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!