$db is now an object of type JDatabase and you can perform database operations on it using the usual methods.

$option = array(); //prevent problems

$option['driver']   = 'mysql';            // Database driver name
$option['host']     = 'db.myhost.com';    // Database host name
$option['user']     = 'fredbloggs';       // User for database authentication
$option['password'] = 's9(39s£h[%dkFd';   // Password for database authentication
$option['database'] = 'bigdatabase';      // Database name
$option['prefix']   = 'abc_';             // Database prefix (may be empty)

$db = & JDatabase::getInstance( $option );

to access config variables we put it like this
add the variable to configruation.php
$my_variable
then
$GLOBALS['mosConfig_my_variable']

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

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”);

or you can also use the JURI::base() for img use

good luck

$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

to get template for URL in joomla

$tmpTools->templateurl()

$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);

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' );

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" />

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.