Example CLI script for Joomla 1.5

clidemo_1.5.php

<?php
// Joomla 1.5 example CLI script
// Written by: Rene Kreijveld, email [at] renekreijveld.nl
// 05-feb-2014

// Set flag that this is a parent file
define('_JEXEC', 1);
define('DS', DIRECTORY_SEPARATOR);
define('JPATH_BASE', dirname(__DIR__));

require_once ( JPATH_BASE .'/includes/defines.php' );
require_once ( JPATH_BASE .'/includes/framework.php' ); 

@$mainframe =& JFactory::getApplication('site');
$mainframe->initialise();

// Database connector
$db = JFactory::getDBO();

echo "Setting query\n";
// Set SQL query
$query = "SELECT COUNT(*) from #__users";
// Execute query
$db->setQuery($query);
// Get result
$number_of_users = $db->loadResult();
echo "Query done\n";
// Output result
echo "We found $number_of_users users.\n";