/**
* Test loadObject method
*
* @return void
*
* @since 11.1
*/
public function testLoadObject()
{
$query = $this->object->getQuery(true);
$query->select('*');
$query->from('jos_dbtest');
$query->where('description=' . $this->object->quote('three'));
$this->object->setQuery($query);
$result = $this->object->loadObject();
$objCompare = new stdClass();
$objCompare->id = 3;
$objCompare->title = 'Testing3';
$objCompare->start_date = '1980-04-18 00:00:00';
$objCompare->description = 'three';
$this->assertThat($result, $this->equalTo($objCompare), __LINE__);
}
/**
* This global function loads the first row of a query into an object
*
* If an object is passed to this function, the returned row is bound to the existing elements of <var>object</var>.
* If <var>object</var> has a value of null, then all of the returned query fields returned in the object.
*
* @param object The address of variable
*/
function loadObject(&$object)
{
if ($object != null) {
if (!($cur = $this->query())) {
return false;
}
if ($array = mysql_fetch_assoc($cur)) {
mysql_free_result($cur);
mosBindArrayToObject($array, $object, null, null, false);
return true;
} else {
return false;
}
} else {
$object = parent::loadObject();
return $object;
}
}
define('_JEXEC', 1);
define('JPATH_BASE', 1);
include_once "../../../../../../configuration.php";
include_once "../../../../../../libraries/joomla/base/object.php";
include_once "../../../../../../libraries/joomla/database/database.php";
include_once "../../../../../../libraries/joomla/database/database/mysql.php";
$config = new JConfig();
$options = array("host" => $config->host, "user" => $config->user, "password" => $config->password, "database" => $config->db, "prefix" => $config->dbprefix);
$database = new JDatabaseMySQL($options);
$sql = " SELECT id, days, tasks FROM #__guru_programstatus WHERE pid = 27 ";
$database->setQuery($sql);
if (!$database->query()) {
echo $database->stderr();
return;
}
$ids = $database->loadObject();
$the_old_day_order = $ids->days;
$the_old_day_order = explode(';', $the_old_day_order);
$the_old_task_order = $ids->tasks;
$the_old_task_order = explode(';', $the_old_task_order);
$new_daystatus_order = '';
$new_taskstatus_order = '';
foreach ($items as $one_item) {
//one_item looks like this -> 6-0:false:202:
$one_item_array = explode(':', $one_item);
if ($one_item_array[1] == 'false') {
// saving the new order
$day_id = $one_item_array[2];
$sql = " SELECT ordering FROM #__guru_days WHERE id = " . $day_id;
$database->setQuery($sql);
$database->query();
