Elxis CMS Forum

Extensions => Components => Topic started by: miskei on March 06, 2012, 17:00:32

Title: weblinks - need to reinstall
Post by: miskei on March 06, 2012, 17:00:32
Hi all,
I threw the weblinks component away thinking that I will not need it. It turned out that I will need it. Would anybody have the xml file for reinstalling it?
Thanks a lot.
Title: Re: weblinks - need to reinstall
Post by: datahell on March 10, 2012, 11:21:06
You can not re-install it like that, it is a core component.

Take the files from the elxis distribution and upload them into your site.
Then go to phpmyadmin and execute this command to create the required db table elx_weblinks:

CREATE TABLE  `elx_weblinks` (
  `id` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(255) default NULL,
  `url` varchar(250) default NULL,
  `description` varchar(255) default NULL,
  `date` datetime NOT NULL default '1979-12-19 00:00:00',
  `hits` int(11) NOT NULL default '0',
  `published` tinyint(4) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '1979-12-19 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `archived` tinyint(4) NOT NULL default '0',
  `approved` tinyint(4) NOT NULL default '1',
  `params` text,
  `screenshot` varchar(200) default NULL,
  `language` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `elx_catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

You should also insert the following 3 rows into the elx_components db table

{ID1}, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, ''
{ID2}, 'Weblink Items', '', 0, {ID1}, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, ''
{ID3}, 'Weblink Categories', '', 0, {ID1}, 'option=categories&section=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, ''

Replace properly {ID1}, {ID2}, {ID3} integers
Title: Re: weblinks - need to reinstall
Post by: miskei on March 10, 2012, 15:37:08
Hi datahell, thanks.
I did it but somehow I can only get to manage categories but I can not access the actually link items. Are you sure the lines for the elx_components db table are correct?
Title: Re: weblinks - need to reinstall
Post by: datahell on March 10, 2012, 18:05:11
Yes, they are correct. These lines generates the administration menu entries.
The component will work even without these but you wont see it in admin menu.
Take a look on the {IDs} I wrote. You must replace them properly.

Insert the first row:
INSERT INTO elx_components VALUES (NULL, 'Web Links', 'option=com_weblinks', ...);

A row will be inserted into the database. Which is the id of that row? These is {ID1}.
You must put it in the next 2 queries in order to make them sub-menus of the first menu item.

If ID1 was 35 then the second insert would be like this:
INSERT INTO elx_components VALUES (NULL, 'Weblink Items', '', 0, 35 'option=com_weblinks', ...);

And the third:
INSERT INTO elx_components VALUES (NULL, 'Weblink Categories', '', 0, 35, 'option=categories&section=com_weblinks', ...);
Title: Re: weblinks - need to reinstall
Post by: miskei on March 10, 2012, 19:19:35
Got it, thanks. It was my bad, I forgot to upload the administrator files.
Thanks again.