joomla component modifications

task 1 com_minisite changes ….. please call this component ‘Manage Events’ in the admin menu i need event date on the table here : [login to view URL] on x_site we need a new dropdown / select with 3 options Event type : European Days (1) Euroschool (2) Other (3) ALTER TABLE `eu_site` CHANGE `type` `type` INT(1) NOT NULL DEFAULT '0'; also a filter on the listing page : [login to view URL] [login to view URL] also please add a description field on here : /* 09:59:11 local eucmacnew */ ALTER TABLE `eu_site` ADD `description` LONGTEXT NOT NULL AFTER `summary`; administrator/[login to view URL] under event photo ================================== task 2 i simply need a few frontend views created on the com_research component - VERY SIMPLE - just the view and printing out details from database ( we do all styling etc ) for these please just create the views in com_research but you only need to put in the raw html for now so it looks good /aboutus >>> just printout titles from 3 random content items /listrads >>> list all entries from x_eu_rad and link them to the seared page /seerad/X >>> just printout the details for the rad chosen from x_eu_rad /euroschool >> just printout list of entries from x_site where type =2 /europeandays >> just printout list of entries from x_site where type =1 /events >> just printout list of entries from x_site where type =3 >> link each of these events to the /seeevent/X page /seeevent/X >> just print out details of event from x_site where id=X /listnews/ >> just list the last 20 items from eu_content where catid=8 /seenews/X >> just print out details of event from eu_content where id=X /listresults/ >> just list the last 20 items from eu_content where catid=9 /seeresults/X >> just print out details of event from eu_content where id=X ================================== task 3 on the frontend of this component ( com_minisite ) we need a listing page this will list the sites that a manager can edit NB you only have do the basic html here - we will style it /manageminisites if the currently logged in user matches mgr or mgrother then we list the mini site just like in backend that user can then update the data in x_site and x_site_content /editsite/X /editcontent/Y ( saving this brings us back to /editsite/X )