Nevis Design Digital

change joomla title structure

2008-08-09T12:29:00.000-07:00

edit includes/joomla.php and switch order of title

http://centricle.com/tools/html-entities/

2008-04-21T03:57:00.000-07:00

The previous post used: http://centricle.com/tools/html-entities/ to search and replace the open tag brackets

How to use Google Translate to offer your website in different languages

2008-04-21T03:38:00.000-07:00

Here is the form details to submit to Google translate, you need to replace the image source in the text below:

<form action="http://www.google.com/translate" >

<script language="JavaScript">

</script>

<input name="hl" value="en" type="hidden">

<input name="ie" value="UTF8" type="hidden">

<input name="langpair" value="" type="hidden">

<input name="langpair" value="en|fr" title="French" src= "images/flags/fr.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|de" title="German" src= "images/flags/de.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|it" title="Italian" src= "images/flags/it.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|pt" title="Portuguese" src= "images/flags/pt.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|es" title="Spanish" src= "images/flags/es.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|ja" title="Japanese" src= "images/flags/jp.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|ko" title="Korean" src= "images/flags/kr.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair" value="en|zh-CN" title="Chinese Simplified" src= "images/flags/cn.png" onclick="this.form.langpair.value=this.value" type="image">

<input name="langpair2" value="en|ar" title="Arabic" src= "images/flags/sa.png" onclick="this.form.langpair.value=this.value" type="image" />
</form>

Foreign Keys in Mysql

2008-04-18T04:22:00.000-07:00

Here is a MYSQL statement to insert Foreign Keys:
create table table1(lid int(11) not null, tid mediumint(9), tag text, FOREIGN KEY(lid) REFERENCES table2(lid) ON DELETE CASCADE, FOREIGN KEY(tid) REFERENCES table3(tid) ON DELETE CASCADE, PRIMARY KEY(lid,tid));

mysql privileges to only one database rather than global

2008-04-18T04:07:00.000-07:00

Here is the Mysql command for database specific user privileges rather than global:
grant all on database.* to 'user'@'localhost' identified by 'password';

print HTML block inside code

2008-04-11T06:43:00.000-07:00

Here is an old classic for printing HTML block inside PHP:
$html = <<< EOH

EOH;
echo($html);

yahoo yui document page width

2008-04-08T03:36:00.000-07:00

Here are the page widths from the yahoo yui
750px
950px
974px
100%

php and Javascript to rotate an image

2008-04-07T07:47:00.000-07:00

The random image rotator uses PHP to get a list of images in a specified directory. This listing is then used in combination with the JavaScript Rotate Images code and its Random Rotation component to randomly swap in these images on a timer. You can specify whether to include all the directory's images or limit the number.
source here
and an example can be found here http://www.hanslips.com/

php to pull down rss feeds with cURL

2008-04-07T07:23:00.000-07:00

Here is three lines of PHP to pull down RSS feeds:
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,
'http://www.somewebsite.com');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$contents = curl_exec ($ch);

mysql command for creating a primary index

2008-04-02T08:29:00.000-07:00

here is a mysql command for creating a primary index for a table:
id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT

php function to submit values to a form

2008-04-02T08:10:00.000-07:00

Here is a php function to submit values to a form:
function hitForm($loginURL, $loginFields, $referer=”") {
$ch = curl_init();
curl_setopt($ch, CURLOPT_COOKIEJAR, “cookies.txt”);
curl_setopt($ch, CURLOPT_COOKIEFILE, “cookies.txt”);
curl_setopt($ch, CURLOPT_URL, $loginURL);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_REFERER, $referer);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $loginFields);
$ret = curl_exec($ch);
curl_close($ch);
return $ret;
}
hitForm(”http://technorati.com/login.php”, “username=wagerank&password=%pass%”);
You can read the original here

inserting text into a database in php

2008-03-30T07:07:00.000-07:00

I am using addslashes() and stripslases() to keep the dirty data out and stop the php from erroring out

foreign keys on a compound primary key

2008-03-26T13:52:00.001-07:00

Here is the MYSQL command to create a compound primary key from two foreign keys:

create table loc_title(lid int(11) not null, tid mediumint(9), tag text, FOREIGN KEY(lid) REFERENCES location(lid) ON DELETE CASCADE, FOREIGN KEY(tid) REFERENCES title(tid) ON DELETE CASCADE, PRIMARY KEY(lid,tid));

safari javascript bug work around - selectbox.options.add

2008-03-13T12:51:00.000-07:00

I found a work around for the old safari bug selectbox.options.add when I replaced it with this: selectbox.options[selectbox.options.length] = new Option(optn.text,optn.value);

Pesky Joomla component table

2008-02-29T01:29:00.000-08:00

I found a fix for that spacing problem in the Joomla template where a component table is added "contentpaneopen" and it can add cellpadding and cellspacing to your template, this can be removed by editing components/com_content/content.html.php

getting HTML pages to parse PHP

2008-02-27T05:30:00.000-08:00

By adding this to my .htaccess file:
AddType application/x-httpd-php .php .html
I got my Browser to pick up my PHP includes in my HTML files

still having problems with CSS in IE 7

2008-02-25T05:10:00.000-08:00

Am still being forced to split out my CSS to take care of CSS in IE 7 for Joomla, which forces me to have a file I cannot edit from the CMS:

[if lte IE 6]

[if IE 7]

Cpanel email quota - error reads "invalid maildirsize file"

2008-02-25T01:23:00.000-08:00

I was having trouble with setting new quotas for mail directories in Cpanel, when I found that you can delete the text file that holds the quota information and it will re-create itself. This will get rid of any corruption/confusion that has caused the quota error, but make sure you delete the 'maildirsize' file for that user only.