tadesse

Well,
glad I could be of some help (after some time 🙂

Hello Davs63,
well, yes } is missing ..
this whole modified function copied here:

/**
 * Display the icons panel in Icons tab
 * @author Brahim MACHKOURI
 */
// I took some of the code from categories.php of WordPress 2.5 and modified it a little
function bm_caticons_adminicons() {
	global $wpdb;
	$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
	if ( isset($_GET['deleteit']) && isset($_GET['delete']) )
		$action = 'bulk-delete';
	switch($action) {
		case 'update-category-icon':
			$cat_ID = (int) $_GET['cat_ID'];
			$priority = $_REQUEST['ig_priority'];
			$icon = $_REQUEST['ig_icon'];
			$small_icon = $_REQUEST['ig_small_icon'];
			if ( $wpdb->get_var( $wpdb->prepare( "SELECT cat_id FROM $wpdb->ig_caticons WHERE cat_id = '%d' ", $cat_ID ) ) ) {
				$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->ig_caticons SET priority = '%d', icon = '%s', small_icon='$s' WHERE cat_id = '%d' ", $priority, $icon, $small_icon, $cat_ID ) ) ;
			} else {
				$wpdb->query($wpdb->prepare("INSERT INTO $wpdb->ig_caticons (cat_id, priority, icon, small_icon) VALUES ('$cat_ID', '$priority', '$icon', '$small_icon')"));
			}
		break;
		case 'delete':
			$cat_ID = (int) $_GET['cat_ID'];
			if (!is_admin() || !current_user_can( 'manage_categories' ))
				wp_die(__('Are you trying to cheat ?','category_icons'));
			$cat_name = get_catname($cat_ID);
			$request = "DELETE FROM $wpdb->ig_caticons WHERE cat_id='$cat_ID'";
			if (false === $wpdb->query($wpdb->prepare($request) ))
				wp_die(__('Error in Category Icons','category_icons').' : '.$request);
		break;
		case 'bulk-delete':
			if (!is_admin() || !current_user_can( 'manage_categories' ))
				wp_die( __('You are not allowed to delete category icons.','category_icons') );
			foreach ( (array) $_GET['delete'] as $cat_ID ) {
				$cat_name = get_catname($cat_ID);
				$wpdb->query($wpdb->prepare("DELETE FROM $wpdb->ig_caticons WHERE cat_id='$cat_ID'"));
			}
		break;
	}
	switch ($action) {
	case 'edit':
		$cat_ID = (int) $_GET['cat_ID'];
		$category = get_category_to_edit($cat_ID);
		list($priority, $icon, $small_icon) = bm_caticons_get_icons($cat_ID);
		?>
		<div class="wrap">
		<h2><?php _e('Select Category Icons','category_icons') ?></h2>
		<form method="post" name="caticons-form1" action="">
		  <?php wp_nonce_field('caticons-nonce'); ?>
			<input type="hidden" name="ig_module" value="caticons" />
			<input type="hidden" name="ig_tab" value="icons" />
			<input type="hidden" name="action" value="update-category-icon" />
            <table  border="0" class="form-table">
                <tr>
                    <th scope="row" style="vertical-align:text-top;"><?php _e('Category ID','category_icons'); ?></th>
                    <td colspan="2" ><?php echo $cat_ID;?></td>
                </tr>
                <tr>
                    <th scope="row" style="vertical-align:text-top;"><?php _e('Name','category_icons'); ?></th>
                    <td colspan="2"><?php echo $category->name;?></td>
                </tr>
                <tr>
                    <th scope="row" class="num" style="vertical-align:text-top;"><?php _e('Priority','category_icons'); ?></th>
                    <td colspan="2">
                        <input type="text" name="ig_priority" size="5" value="<?php echo $priority; ?>" />
                    </td>
                </tr>
                <tr>
                    <th scope="row" style="vertical-align:text-top;"><?php _e('Icon','category_icons'); ?></th>
                    <td valign="top"><label><?php _e('Select a file : ','category_icons');?></label>
                        <select name="ig_icon" onchange="icon_preview.src=('<?php echo ig_caticons_url();?>/'+this.options[this.selectedIndex].value);">
                            <option value="">--- <?php _e('No Icon','category_icons'); ?> ---</option>
                            <?php bm_caticons_get_icons_paths($icon);	?>
                        </select><br />
                        <label><?php _e('Or enter an URL : ','category_icons');?><input type="text" name="bm_icon_url"/></label>
                    </td>
                    <td valign="top"><img id="icon_preview" src="<?php echo ig_caticons_url()."/$icon";?>" alt="icon" /></td>
                </tr>
                <tr>
                    <th scope="row" style="vertical-align:text-top;"><?php _e('Small Icon','category_icons'); ?></th>
                    <td valign="top"><label><?php _e('Select a file : ','category_icons');?></label>
                        <select name="ig_small_icon" onchange="small_icon_preview.src=('<?php echo ig_caticons_url();?>/'+this.options[this.selectedIndex].value);">
                            <option value="">--- <?php _e('No Icon','category_icons'); ?> ---</option>
                            <?php bm_caticons_get_icons_paths($small_icon); ?>
                        </select><br />
                        <label><?php _e('Or enter an URL : ','category_icons');?><input type="text" name="bm_smallicon_url"/></label>
                    </td>
                    <td valign="top"><img id="small_icon_preview" src="<?php echo ig_caticons_url()."/$small_icon";?>" alt="small icon" /></td>
                </tr>
            </table>
			<div class="submit"><input type="submit" name="info_update" value="<?php _e('Select Icons','category_icons');?> »" /></div>
        </form>
		</div>
		<?php
	break;
	default:
	?>
	<div class="wrap">
        <form id="posts-filter" action="" method="get" name="caticons-form2">
        <?php wp_nonce_field('caticons-nonce'); ?>
            <input type="hidden" name="ig_module" value="caticons" />
            <input type="hidden" name="page" value="category_icons.php" />
            <input type="hidden" name="action" value="delete" />
            <input type="hidden" name="ig_tab" value="icons" />

		<div class="tablenav">
			<div class="alignleft">
				<input type="submit" value="<?php _e('Delete icons and priority','category_icons'); ?>" name="deleteit" class="button-secondary delete" />
			</div>
			<br class="clear" />
		</div>
		<br class="clear" />
		<table class="widefat" id="caticons_table">
			<thead>
			<tr>
   				<th scope="col" id="cb" class="check-column"><input type="checkbox" /></th>
				<th scope="col"><?php _e('ID','category_icons') ?></th>
                <th scope="col" ><?php _e('Name','category_icons') ?></th>
                <th scope="col" style="text-align:center"><?php _e('Description','category_icons') ?></th>
                <th scope="col" class="num" style="text-align:center"><?php _e('Posts','category_icons') ?></th>
                <th scope="col" style="text-align:center"><?php _e('Priority','category_icons') ?></th>
				<th scope="col" style="text-align:center"><?php _e('Icon','category_icons') ?></th>
				<th scope="col" style="text-align:center"><?php _e('Small Icon','category_icons') ?></th>
			</tr>
			</thead>
			<tbody id="the-list" class="list:cat">
		<?php
		bm_caticons_rows();
		?>
			</tbody>
		</table>
		</form>
        <div class="tablenav">
        <br class="clear" />
        </div>
        <br class="clear" />
        </div>
	<?php
	}// end switch
}

and install aswell:

/**
 * Install the plugin
 * @author Ivan Georgiev
 */
function ig_caticons_install() {
	global $wpdb, $table_prefix;
	$wpdb->query($wpdb->prepare( "CREATE TABLE IF NOT EXISTS <code>$wpdb->ig_caticons</code> (<code>cat_id</code> INT NOT NULL ,<code>priority</code> INT NOT NULL ,<code>icon</code> TEXT NOT NULL ,<code>small_icon</code> TEXT NOT NULL , PRIMARY KEY ( <code>cat_id</code> ))", $table ) ) ;
	add_option('igcaticons_path', '');
	add_option('igcaticons_url', '');
	add_option('igcaticons_filetypes', 'jpg gif jpeg png');
	add_option('igcaticons_max_icons','3');
	add_option('igcaticons_before_name','true');
	add_option('igcaticons_fit_width','-1');
	add_option('igcaticons_fit_height','-1');
	add_option('igcaticons_use_small','true');
	add_option('igcaticons_templatecode_patch','0');
	add_option('igcaticons_templatecode_sidebar','1');
	add_option('igcaticons_rssfeeds','1');
	add_option('igcaticons_useseo_plugin', '0');
	add_option('igcaticons_max_width','-1');
	add_option('igcaticons_max_height','-1');
	add_option('igcaticons_iconcatpage','0');
}

I hope this helps ..

Hello,
in Function bm_caticons_adminicons from Line 916 you must change the queries to:

if ( $wpdb->get_var( $wpdb->prepare( "SELECT cat_id FROM $wpdb->ig_caticons WHERE cat_id = '%d' ", $cat_ID ) ) ) {
				$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->ig_caticons SET priority = '%d', icon = '%s', small_icon='$s' WHERE cat_id = '%d' ", $priority, $icon, $small_icon, $cat_ID ) ) ;
			} else {
				$wpdb->query($wpdb->prepare("INSERT INTO $wpdb->ig_caticons (cat_id, priority, icon, small_icon) VALUES ('$cat_ID', '$priority', '$icon', '$small_icon')"));

Hello,
well I did change the code as well for our WordPress page.
But this should be done by the plugin author.
Here are my code changes in: /wp-content/plugins/category-icons/category_icons.php

Index: category_icons.php
===================================================================
--- category_icons.php	(revision 420)
+++ category_icons.php	(revision 427)
@@ -290,7 +290,7 @@
 				FROM $wpdb->term_relationships
 				right join $wpdb->term_taxonomy on $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
 				left join $wpdb->posts on $wpdb->term_relationships.object_id = $wpdb->posts.ID
-				where post_type = 'page' and $wpdb->term_taxonomy.taxonomy = 'category' and ID=";
+				where post_type = 'page' and $wpdb->term_taxonomy.taxonomy = 'category' and ID = '' ";
 	$nb_max_icons_page = (int) get_option('igcaticons_max_icons');
 	$cats = array();
 	if ($type != 'cat' && $type != 'page') {
@@ -1044,7 +1044,8 @@
  */
 function ig_caticons_install() {
 	global $wpdb, $table_prefix;
-	$wpdb->query($wpdb->prepare("CREATE TABLE IF NOT EXISTS <code>$wpdb->ig_caticons</code> (<code>cat_id</code> INT NOT NULL ,<code>priority</code> INT NOT NULL ,<code>icon</code> TEXT NOT NULL ,<code>small_icon</code> TEXT NOT NULL , PRIMARY KEY ( <code>cat_id</code> ))"));
+//	$wpdb->query($wpdb->prepare("CREATE TABLE IF NOT EXISTS <code>$wpdb->ig_caticons</code> (<code>cat_id</code> INT NOT NULL ,<code>priority</code> INT NOT NULL ,<code>icon</code> TEXT NOT NULL ,<code>small_icon</code> TEXT NOT NULL , PRIMARY KEY ( <code>cat_id</code> ))"));
+	$wpdb->query($wpdb->prepare("CREATE TABLE IF NOT EXISTS %s (<code>cat_id</code> INT NOT NULL ,<code>priority</code> INT NOT NULL ,<code>icon</code> TEXT NOT NULL ,<code>small_icon</code> TEXT NOT NULL , PRIMARY KEY ( <code>cat_id</code> ))", $wpdb->ig_caticons ) ) ;
 	add_option('igcaticons_path', '');
 	add_option('igcaticons_url', '');
 	add_option('igcaticons_filetypes', 'jpg gif jpeg png');
@@ -1357,7 +1358,8 @@
 	foreach($cats as $cat)
 		$instr .= $wpdb->escape($cat).',';
 	$instr = preg_replace('/,$/','', $instr); // Remove trailing comma
-	if ($row = $wpdb->get_row($wpdb->prepare("SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons WHERE cat_id IN($instr) ORDER BY priority DESC LIMIT 1")))
+//	if ($row = $wpdb->get_row($wpdb->prepare("SELECT cat_id, priority, icon, small_icon FROM $wpdb->ig_caticons WHERE cat_id IN($instr) ORDER BY priority DESC LIMIT 1")))
+if ($row = $wpdb->get_row($wpdb->prepare("SELECT cat_id, priority, icon, small_icon FROM %s WHERE cat_id IN(%s) ORDER BY priority DESC LIMIT 1", $wpdb->ig_caticons, $instr )))
 		return array($row->cat_id, $row->priority, $row->icon, $row->small_icon);
 	else
 		return false;

I changed the wrong translation tags _e( to: __( as well.

Hi Zane,
this is good news!
Happy New Year
Konrad

Hello Mat,
this is all fine,
You say: “but they are not designed to be used as category page or links page.”

I can see that,
but due to the WP structure all these links exist and could be used …

so:
– why not using it?
– and why should they be unusable?
– any other custom post has all functions inherited be post_type post or page …

I would use it …
As I do with custom taxonomies here: “custom post type plant typ = tree”: http://pflanzen-bilder-kaufen.de/pflanzentyp/baum/

This is the original link structure for a link category:
http://ktse.de/?taxonomy=link_category&term=links (it works)

I hope I could be a little bit uh upgrading, up bringing, rethinking?
Anyway, I think it would be great.
Konrad