One thing I noticed was with the latest code (I think it is, anyway), there is no ability to edit descriptions for Categories. I noticed this when I figured out that my w3t_links_categories table did not have a cat_desc field (probably missed when upgrading from an older version of this mod.). That, in turn, caused the Category display to indent the first line of sub-cats kind of strangely. <br /><br />Long story shortened: I changed some of the code in links_show_cat.php to account for an empty description. So, around line 161, make this change:<br /> <br /><br />Is the ability to add/modify category descriptions supposed to be there? Or should I add it in myself?<br /><br />Thanks for all your hard work!

Category descriptions were commented out by id242 <br /> <br />You might want to view this thread first <br /> <br />http://www.ubbdev.com/forum/showflat.php/Cat/0/Number/101624

Okay, that makes more sense then. It was trying to print them out, but there was nothing there (though I did check the last version of the create_tables call and the column was there...). So for now, I will continue to edit the descriptions manually via mysql-front and work on an editing interface when time permits... if noone beats me to it. BTW, here's what it looks like right now, when you have descriptions to print show (and when there are none available): My Links Page <br /><br />enjoy!

I actually spent some time on what you said today since Mark is back in action.<br /><br />I added the capacity to add category descriptions and edit them in the links admin. Only changed file was links_admin.php<br /><br />Before you could only add descriptions via phpmyadmin.

No offense taken, id242. It just caught me wrong at first. I appreciate you taking the time to provide some aesthetic improvements to the script, as mostly what I was doing when I first began the script was to get the inner workings of the code going. That's why it was released as a beta version anyway. Unfortunately I had to drop work on it for personal reasons.<br /><br />I like Omegatrons idea of configuring the script to either display, or not, the notice. Someone suggested (forgive my memory, it's great but recall tends to be a problem <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> ) possibly putting a link for a PayPal donate for those who wish to contribute. I may do that.<br /><br />I do appreciate the kind words that people do like the script. That's rewarding in itself.<br /><br />Anyway, I will be working on the script to further enhance it's usefulness to the community, so with that in mind here is a very short list of what I want to do first.<br /><br />First and foremost will be the install script. It's pretty ugly due to the errors when you first install the script, so I'll be adding a check to see if there is a db installed yet or not. I think maybe a version check somehow is in order for upgrading from previous versions is in order.<br /><br />Category descriptions should be the next to follow. It's apparent that Chuck (Omegatron) has already done something with this?<br /><br />Paginating. Now the way it is written, if you have a zillion links they would all display on one page. So that needs to be addressed.<br /><br />A configuration script for setting options needs to be written as well. I was thinking of using a db table for this to hold the variables. Any thoughts on this?<br /><br />Of course, improvement on the admin script.<br /><br />That's enough for now. Obviously, all input is requested. Thanks.

[]Omegatron said:<br />I actually spent some time on what you said today since Mark is back in action.<br /><br />I added the capacity to add category descriptions and edit them in the links admin. Only changed file was links_admin.php<br /><br />Before you could only add descriptions via phpmyadmin. [/]<br /><br />Chuck, since you did this, did you update the first post? Actually, maybe you can provide just the links_admin as a .txt and I'll grab it.

The first post my friend was updated. <br /> <br />I think id242 added the description table but never made the ability to edit them via the script <br /> <br />For the record I have done the following on the script <br /> <br /> 1.XHTML corrections <br /> 2. Added ability to delete cats <br /> 3. Added ability to edit and add category descriptions <br /> 4. Added the copyright text in a configurable variable.

Only thing I really need is the subcats sorted for the drop down list when adding links, so my users can pick the correct spot to add the links. I have resorted to making mini alphabet prefixes to the subcats to get them below catagory names. Looks terrible and functions barely.<br />Thanks for all the hard work on this its a great addon.

Thanks Chuck, I'll be sure to add the probper credits. <img src="http://www.ubbdev.com/forum/images/graemlins/cool.gif" alt="" />

[]Smilesforu said:<br />Only thing I really need is the subcats sorted for the drop down list when adding links, so my users can pick the correct spot to add the links. I have resorted to making mini alphabet prefixes to the subcats to get them below catagory names. Looks terrible and functions barely.<br />Thanks for all the hard work on this its a great addon. [/]<br /><br />Could you clarify this for me? I think what you are saying is the drop down list should look something like:<br /><br />Cat 1<br /> Subcat 1<br /> Subcat 2<br /> Subcat 3<br />Cat 2<br /> Subcat 1<br /> Subcat 2<br /> Subcat 3<br /><br />etc.?

Chuck,<br /><br />that worked beautifully! And the .zip looks much cleaner now, too! <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" /> Thanks for updating it all!

No problem that really is the work I have done on this mod is when someone wants something I went in and coded it <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

yes fishtails exactly But right now it sorts alphabetically with all cats and subcats included together

On the to do! <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

Hi,<br /><br />Since you are updating your to do list <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />Not certain if you saw my post a while back:<br />----------------------------------------------<br />Hi,<br /><br />This hack could be a nice way to make some additional ad revenue. What I was thinking about was to allow sites / companies that you link to to upgrade their link, for a fee or free (up to you I suppose).<br /><br />This upgrading could be a different style to the link (i.e. larger font / bolder / italics) or even a small banner displayed next to or below the link.<br /><br />It would be even better if we could add different levels of priority to the links (each with a different style associated to them) and then sort the list on links by priority first before alphabetically.<br /><br />How much work would it be to add these features?<br /><br />Sanuk!<br />----------------------------------------------

[]ksanuk said:<br />Hi,<br /><br />Since you are updating your to do list <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />Not certain if you saw my post a while back:<br />----------------------------------------------<br />Hi,<br /><br />This hack could be a nice way to make some additional ad revenue. What I was thinking about was to allow sites / companies that you link to to upgrade their link, for a fee or free (up to you I suppose).<br /><br />This upgrading could be a different style to the link (i.e. larger font / bolder / italics) or even a small banner displayed next to or below the link.<br /><br />It would be even better if we could add different levels of priority to the links (each with a different style associated to them) and then sort the list on links by priority first before alphabetically.<br /><br />How much work would it be to add these features?<br /><br />Sanuk!<br />---------------------------------------------- [/]<br /><br />What I was thinking in terms of this would be a google or ask.com style, where sponsored links would be at the top seperated with a hr or in a sidebar. This, of course is a little further down the to do list though, but definitely on the list.<br /><br />Thanks for the idea.

UBB Threads version 6.4 <br />1st Time Installing this Integration <br />------------------------------------ <br /> <br />Uploaded the files...then went to the links.php file through the net and clicked on Admin so that I could add the Categories. I got this: <br /> <br />-------------------- <br />SQL ERROR: Unable to do_query: SELECT * FROM w3t_links_links WHERE approved = '0' ORDER BY 'date_added' <br />Table 'smoknz28_Infopop.w3t_links_links' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smoknz28/public_html/ubbthreads/links_admin.php on line 74 <br /> <br /> <br />SQL ERROR: Unable to do_query: CREATE TABLE w3t_links_categories ( cat_id int(11) NOT NULL auto_increment, parent_id int(11) default NULL, title varchar(50) NOT NULL default '', cat_desc varchar(60) default NULL '', cat_order tinyint(10) NOT NULL default '0', PRIMARY KEY (cat_id) ) <br />You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''', cat_order tinyint(10) NOT NULL defaDatabase tables have been created. You can now add categories and links. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> <br />--------------------- <br /> <br />How many tables is this integration suppose to add to the database? <br /> <br />I'm getting errors after running this and just trying to verify a few things. <br /> <br />When I attempt to navigate around within this integration I get: <br /> <br />----------------- <br />SQL ERROR: Unable to do_query: SELECT * FROM w3t_links_categories WHERE parent_id = '0' ORDER BY 'cat_order' <br />Table 'smoknz28_Infopop.w3t_links_categories' doesn't exist <br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smoknz28/public_html/ubbthreads/links_show_cat.php on line 66 <br />There are currently 0 links in our database <br />------------------------------------

Ran into the same issue myself. First, drop the two tables it created in phpMyAdmin. Then look in links_admin.php and replace the create table w3t_links code, (found around line 488), with: <br /> <br />CREATE TABLE w3t_links_categories <br />( <br />cat_id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, <br />parent_id int(11) DEFAULT NULL, <br />title varchar(50) NOT NULL DEFAULT '', <br />cat_desc varchar(60) DEFAULT NULL, <br />cat_order tinyint(10) NOT NULL DEFAULT '0' <br />) <br /> <br />Now run the install script again. <br /> <br />I think I read that fishtails is planning to update the install script when time permits. <br /> <br />Jason

Hi,<br /><br />"What I was thinking in terms of this would be a google or ask.com style, where sponsored links would be at the top seperated with a hr or in a sidebar. This, of course is a little further down the to do list though, but definitely on the list."<br /><br />That would work for me <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />Sanuk!

I like the other feature suggestions that have been made (adding a small banner for some sites, auto-populating which category a link should be in based on which one you're located in, etc...), but the one thing I haven't seen yet is a 'Report broken link' feature... not too difficult. Could probably even be a PM to the Administrator or something....? Does anyone else need this?