Printable View
So found this old post from Clyde..Quote:
Originally Posted by clydejones
My question is has anybody been able to add the second option above to the links entry page (admin>extras> links)? I would rather have BOTH options for entering link "banner images".. This way my client doesn't HAVE TO FTP the links "banner" images..
Thank you very much, Moksha and Diva Vocals. A potentially faster way to achieve the above quoted step is to find the id number in the database either using phpAdmin or with the following SQL statement:Quote:
Originally Posted by moksha
I wonder what it would take to update the plugin so that it would self-register.Code:SELECT *
FROM `your_zc_database`.`configuration_group`
WHERE (`configuration_group_title` LIKE '%link%')
LIMIT 0 , 30
Also in case it wasn't clear - data that needs to be inserted into the Configuration field includes gID=XX, not just the number.
I'm having trouble installing the SQL file because my server is still using MySQL version 5.5, which does not allow the following statement:and specificallyCode:CREATE TABLE links (
`links_id` int(11) NOT NULL auto_increment,
`links_url` varchar(255) default NULL,
`links_reciprocal_url` varchar(255) default NULL,
`links_image_url` varchar(255) default NULL,
`links_contact_name` varchar(64) default NULL,
`links_contact_email` varchar(96) default NULL,
`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`links_last_modified` datetime default NULL,
`links_status` tinyint(1) NOT NULL default '1',
`links_clicked` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`),
KEY `idx_links_date_added` (`links_date_added`)
) TYPE=MyISAM ;
.Code:`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
The error being that the default value is invalid. Apparently in the latest version of MySQL the DATETIME is allowed.
Two recommended workaround are to use TIMESTAMP instead of DATETIME or to add TRIGGERS to the table.
I was able to usebut then got errors trying to add a second TIMESTAM field (links_last_modified).Code:`links_date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
I installed the table WITHOUT the links_date_added field (might not be necessary), but am getting "WARNING: An Error occurred, please refresh the page and try again."
Insights welcome and I will post solution, of course.
Okay seems to be working now. The MySQL statement that will not work under MySQL 5.5.x is the CREATE TABLE links statement which I beleve can be replaced with:
Differences: updated the DATETIME statements to replace with TIMESTAMP and updated TYPE=MyISAM to ENGINE=MyISAM.Code:DROP TABLE IF EXISTS `links`;
CREATE TABLE links (
`links_id` int(11) NOT NULL auto_increment,
`links_url` varchar(255) default NULL,
`links_reciprocal_url` varchar(255) default NULL,
`links_image_url` varchar(255) default NULL,
`links_contact_name` varchar(64) default NULL,
`links_contact_email` varchar(96) default NULL,
`links_date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`links_last_modified` TIMESTAMP,
`links_status` tinyint(1) NOT NULL default '1',
`links_clicked` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`),
KEY `idx_links_date_added` (`links_date_added`)
) ENGINE=MyISAM ;
TIMESTAMP has some limitations, but they should not be a problem in this application (unless you are still trying to use it in the year 2030).
Did you ever make any headway on this, DivaVocals? It also appears that at this point one can only upload "link images" via the front end link add, and not the back end.Quote:
Originally Posted by DivaVocals
I'm would like Link Manager to display the list of links by category, as opposed to first displaying only the categories, then a page of the links within each category. The format I want is that for each category there will be a heading containing the Name of the Category, followed by a listing of it's associated links. In other words:
CATEGORY1
link title - link description - image
link title - link description - image
link title - link description - image
CATEGORY2
link title - link description - image
ETC
I think this will require some new coding in the tpl_links_default page and will require a multi-table SQL query - like a JOIN (inner, outer, left?).
There are four relevant tables (i think):
1. link_categories_description which contains link_categories_name
2. links which contains the link url and image url
3. links_to_link_categories which associates link_ids with link_categories_id
4. links_description which contains links_description
I welcome any pointers (towards or away from). :smile:
My only headway was to pose the question..:smile:Quote:
Originally Posted by mutinyzoo
so... was making a new sidebox to display links like some of the site I visit... had issues with the admin image thingy... so fixed it tonight. I wanted it to not change the image if updating something else, upload a new image, take one off my server, change directories, change to the default image... got it done..Quote:
Originally Posted by DivaVocals
Attachment 14120
Give me some time and I'll put the code to a clean install and post it back here or to my blog! going to be a busy week again so may take a bit to do.
As always here you come to the rescue!!!:hug:Quote:
Originally Posted by davewest