How to get rid of 'Download information as' text on the contact page of Joomla 1.7 installation

I couldn't find answer to this after googling a few things like

joomla 1.7 get rid of Download information as: text on contact page

joomla delete Download information as:text on contact page

here's what I needed to do

OPEN

components/com_contact/views/contact/tmpl/default.php

line

63 is



get rid of it !!


:)

Changing the color of the buttons in GK4 on Joomla 1.7

you need to locate the css on this page

modules/mod_news_pro_gk4/interface/css/style.portal.mode.2.css

once there its the color here you'll need to change

modules/mod_news_pro_gk4/interface/css/style.portal.mode.2.css


and this image modules/mod_news_pro_gk4/images/nsp_portal_mode_2_interface.png

where is the mysql database on this server

I've been asking question like 'how do i find the mysql database on this server. When it's just occurred to me that as I know the local host address and password etc. then all I need to do is set up phpMyAdmin www.phpmyadmin.net/home_page/index.php and I'll be able to have the access I need.

I'll fil you in on process when I get round to doing it next week.  Here's a link to the documentation on downloading http://www.phpmyadmin.net/documentation/#quick_install

Getting multiple Backgrounds to work on one page using CSS

The Problem here is this:  Take a look at this screenshot. 

I wanting to show 3 layers at once using the z-index.  However to do this I needed to set the div position to 'absolute' and that through the layout out in other areas.


One suggestion I got was to make a relative container to put the other DIVs in .


However I got this solution to work where I can use 2 backgrounds in one DIV.  There's also a fix for IE 8


Multiple Background in CSS DIV  -  


Here's the css that worked for me on Wise Monkey Media -   






background: url("../../images/wisemonkeymediatail.gif") no-repeat scroll right bottom, url("../../images/mp-background-shading.png") repeat scroll center top transparent;




check the next blog for my IE8 fix 

Can you force an old module from Joomla 1.5 to work on Joomla 1.7

I'm using this news reel GK4 on this Surfing News website.   It's got one really cool feature which I like is that you can scroll left or right through the pages of news items.  However this feature isn't carried over in the Joomla 1.7 update.  So I was wondering if I could force it to work.  The answer to this I think is no.  Here's what I tried

* Copied the folder over

* copied the jos_module entry for gk4 into the new site.  You have to do this by hand as there are extra fields, and some have been ended.

* changed the params - it now starts with {  and ends with }  .  Also /n  needs to be swapped for :

this still produces a NSP error.   The next stage would be to google  how to change my Joomla 1.5 module into joomla 1.7  or something similar.  If you know of a solution then please let me know.

tar: Unexpected EOF in archive

i got this message while unzipping a gzip file

tar:  Unexpected EOF in archive
tar: Error is not recoverable: exiting now

The reason I was getting it was because the file had not fully downloaded to the server.

Understanding Someone Elses MYSQL

Working through someone elses lovely Legacy code I've come to this MySQL statement that seems a bit odd.  So this blog is about trying to understand it.  Which by the way ultimately I don't.  If you do and can explain it to me better than these notes then let me know :)  After this blog I will be going away and trying prove it is wrong - so please check future posts.

SELECT pay_rate, LEFT(TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time)),5) AS hours, hours_only FROM shifts WHERE (employee_id = '160' AND shift_date BETWEEN '2010-11-12' AND '2010-11-18') OR (employee_id = '160' AND postdate_staff_invoice = '2')



SELECT pay_rate,  // we only looking to return 1 field



LEFT     // check here for 'LEFT' explained  - http://www.roseindia.net/sql/mysql-example/mysql-left.shtml  -

take this example  mysql> SELECT left ('GirishTewari',6)as LeftString;

this means that in this example we're taking the first charcters of this result

TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time))

#########

So what does

TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time))

mean.  Well

TIMEDIFF() returns expr1 – expr2 expressed as a time value. expr1 and expr2 are time or date-and-time expressions, but both must be of the same type.

* in this example the second expression will be calculated from the row from the database we're in.

AS   - I normally use this after calling FROM as a form of shorthand ie
         
FROM tableOne AS t1


#################

WHERE (employee_id = '160' AND shift_date BETWEEN '2010-11-12' AND '2010-11-18') OR (employee_id = '160' AND postdate_staff_invoice = '2')

Well at least this makes more sense - except for what's after the 'OR'


To be honest this mysql looks all wrong.  I think the next stage is to find out what result we're expecting.  IS IT JUST TO FIND OUT THE PAY RATE !!


//////////

Here's some searches I've made in looking for answers.


MYSQL LEFT EXPLAINED