Breathing Spring

Archive for the ‘Joomla’ Category

JHTML DATE in joomla

with the help of the following PHP date table you can add JHTML date to your code
JHTML::Date($row->date, “%A, %d. %B %Y”);
if you are modifying news then $row->date would be $this->item->created

format	Description	Example returned values
Day	—	—
%a	An abbreviated textual representation of the day	Sun through Sat
%A	A full textual representation of the day	Sunday through Saturday
%d	Two-digit day of the month (with leading zeros)	01 to 31
%e	Day of the month, with a space preceeding single digits	1 to 31
%j	Day of the year, 3 digits with leading zeros	001 to 366
%u	ISO-8601 numeric representation of the day of the week	1 (for Monday) though 7 (for Sunday)
%w	Numeric representation of the day of the week	0 (for Sunday) through 6 (for Saturday)
Week	—	—
%U	Week number of the given year, starting with the the first Sunday as the first week	13 (for the 13th full week of the year)
%V	ISO-8601:1988 week number of the given year, starting with the first week of the year with at least 4 weekdays, with Monday being the start of the week	01 through 53 (where 53 accounts for an overlapping week)
%W	A numeric representation of the week of the year, starting with the first Monday as the first week	46 (for the 46th week of the year beginning with a Monday)
Month	—	—
%b	Abbreviated month name, based on the locale	Jan through Dec
%B	Full month name, based on the locale	January through December
%h	Abbreviated month name, based on the locale (an alias of %b)	Jan through Dec
%m	Two digit representation of the month	01 (for January) through 12 (for December)
Year	—	—
%C	Two digit representation of the century (year divided by 100, truncated to an integer)	19 for the 20th Century
%g	Two digit representation of the year going by ISO-8601:1988 standards (see %V)	Example: 09 for the week of January 6, 2009
%G	The full four-digit version of %g	Example: 2008 for the week of January 3, 2009
%y	Two digit representation of the year	Example: 09 for 2009, 79 for 1979
%Y	Four digit representation for the year	Example: 2038
Time	—	—
%H	Two digit representation of the hour in 24-hour format	00 through 23
%I	Two digit representation of the hour in 12-hour format	01 through 12
%l (lower-case ‘L’)	Hour in 12-hour format, with a space preceeding single digits	1 through 12
%M	Two digit representation of the minute	00 through 59
%p	UPPER-CASE ‘AM’ or ‘PM’ based on the given time	Example: AM for 00:31, PM for 22:23
%P	lower-case ‘am’ or ‘pm’ based on the given time	Example: am for 00:31, pm for 22:23
%r	Same as “%I:%M:%S %p”	Example: 09:34:17 PM for 21:34:17
%R	Same as “%H:%M”	Example: 00:35 for 12:35 AM, 16:44 for 4:44 PM
%S	Two digit representation of the second	00 through 59
%T	Same as “%H:%M:%S”	Example: 21:34:17 for 09:34:17 PM
%X	Preferred time representation based on locale, without the date	Example: 03:59:16 or 15:59:16
%z	Either the time zone offset from UTC or the abbreviation (depends on operating system)	Example: -0500 or EST for Eastern Time
%Z	The time zone offset/abbreviation option NOT given by %z (depends on operating system)	Example: -0500 or EST for Eastern Time
Time and Date Stamps	—	—
%c	Preferred date and time stamp based on local	Example: Tue Feb 5 00:45:10 2009 for February 4, 2009 at 12:45:10 AM
%D	Same as “%m/%d/%y”	Example: 02/05/09 for February 5, 2009
%F	Same as “%y-%m-%d” (commonly used in database datestamps)	Example: 2009-02-05 for February 5, 2009
%s	Unix Epoch Time timestamp (same as the time() function)	Example: 305815200 for September 10, 1979 08:40:00 AM
%x	Preferred date representation based on locale, without the time	Example: 02/05/09 for February 5, 2009
Miscellaneous	—	—
%n	A newline character (“\n”)	—
%t	A Tab character (“\t”)	—
%%	A literal percentage character (“%”)	—

root folder path in joomla

to get the root folder path in joomla you can put JPATH_ROOT
to get the folders separator DS
finally your statement should be like this :
require_once(JPATH_ROOT.DS.”thefileyouwanttoinclude.php”);

Get Num Rows in joomla

$db =& JFactory::getDBO();
$query=”select * from #__ etc….’”);
$db->setQuery($query);
$db->Query();
if($db->getNumRows()>0)

As usual silly but I would rather to show code than spending time talking, hope I made it clear

Template URL for joomla

to get template for URL in joomla

$tmpTools->templateurl()

A quick sample of How to user loadRow and Root Directory

$query=”select userid, pgitemfilename from “.$this->_table_prefix.”profilegallery where id=”.$id;
$this->_db->setQuery( $query );
$this->_db->query();
$row=$this->_db->loadRow();
$pgitemfilename=$row[1];
$userid=$row[0];

unlink( JPATH_ROOT.DS.”images”.DS.”comprofiler”.DS.”plug_profilegallery”.DS.$userid.DS.$pgitemfilename);
unlink( JPATH_ROOT.DS.”images”.DS.”comprofiler”.DS.”plug_profilegallery”.DS.$userid.DS.”tn”.$pgitemfilename);

Joomla substitue for $_GET and $_POST

instead of using $_GET, and $_POST in jooma, the frame work use instead JRequest::getVar

actually, I found no reason at first to change $_GET and $_POST with that long string, especially that I’m not a big fan of memorizing things. Frankly, the interesting part about this long function is that it protect your Joomla system from Sql injection, or any sinister undesired passed string.

How does it protect it? I didnt go into the core of this function but I believe its some secure code that stripes tags.

The simplest way to use the function is :

$var = JRequest::getVar( 'var' );

TinyMCE Joomla Read more problem

Giving an hr instead of read more?

The problem seems to be that TinyMCE is cleaning the backslash from the

<hr id="system-readmore" />

tag upon save, even though the ‘cleanup on save’ plugin parameter has been set to ‘Never’.

Or, has the joomla code that checks for the readmore tag when it writes an article to the database become more restrictive? Before did it recognize

<hr id="system-readmore">

and now it only recognizes

<hr id="system-readmore" />

Rokbridge Fatal Error in distribution/includes/db/dbal.php on line 602

In /plugins/user/phpbb3.php, replace line 92:

if(!isset($userid)) {

with:

if (( ! isset( $userid )) || ( strlen( $userid ) == 0 )) {              // it's set, but has no value

It’s the only (isset($userid)) in the file, so should be easy to find.

Div is jumping in joomla on IE

The weirdest thing you could ever see in joomla (and which I havnt seen somewhere else yet)

is the DIV jumping and it caused me to change the whole theme. then I realized after few work that the problem presisted again.

I tried to google and I read smething like if the Div jumps (when you open internet explorer and waiting for one second) it means something is tight and isnt fitting well.

Well I didn’t want to believe at first but then I tried to make the container div wider and voala! it worked.

Hope this will work for you too.

CSS can be a pain or a real pain espiceally for those who use IE

Registering Component to Database

using phpmyadmin add this query.

this will add the component to the backend list too

INSERT INTO jos_components (name, link, admin_menu_link, admin_menu_alt, ‘option’, admin_menu_img, params) VALUES (‘Reviews’, ‘option=com_reviews’, ‘option=com_reviews’, ‘Manage Reviews’, ‘com_reviews’, ‘js/ThemeOffice/component.png’, ”);