12
Try again ... Xoops using "\DateTime" and not "DateTime"
Quote:
Quote:
luciorota wrote:
The bug is the result of an incorrect use of the function strtotime(), it must have a format in English to work...
BUGFIX
file: publisher\class\item.php, line 1061
replace$localTimestamp = strtotime($resDate['date']) + $resTime['time'];
with$dateTimeObj = \DateTime::createFromFormat(_SHORTDATESTRING, $resDate['date']);
$dateTimeObj->setTime(0, 0, 0);
$localTimestamp = $dateTimeObj->getTimestamp() + $resTime['time'];
file: publisher\class\item.php, line 1088
replace$localTimestamp = strtotime($resExDate['date']) + $resExTime['time'];
with$dateTimeObj = \DateTime::createFromFormat(_SHORTDATESTRING, $resExDate['date']);
$dateTimeObj->setTime(0, 0, 0);
$localTimestamp = $dateTimeObj->getTimestamp() + $resExTime['time'];
Good job! / Buon lavoro!
14
The bug is the result of an incorrect use of the function strtotime(), it must have a format in English to work...
BUGFIX
file: publisher\class\item.php, line 1061
replace
with
file: publisher\class\item.php, line 1088
replace
with
Good job! / Buon lavoro!
BUGFIX
file: publisher\class\item.php, line 1061
replace
$localTimestamp = strtotime($resDate['date']) + $resTime['time']; with
$dateTimeObj = DateTime::createFromFormat(_SHORTDATESTRING, $resDate['date']);
$dateTimeObj->setTime(0, 0, 0);
$localTimestamp = $dateTimeObj->getTimestamp() + $resTime['time']; file: publisher\class\item.php, line 1088
replace
$localTimestamp = strtotime($resExDate['date']) + $resExTime['time']; with
$dateTimeObj = DateTime::createFromFormat(_SHORTDATESTRING, $resExDate['date']);
$dateTimeObj->setTime(0, 0, 0);
$localTimestamp = $dateTimeObj->getTimestamp() + $resExTime['time']; Good job! / Buon lavoro!
15
Hi Lupin /Ciao Lupin
Do not change
These definition are db related (MySQL date and time data types) and they are NOT dependent on the language used ...
Lucio
Do not change
define('_DBDATESTRING',"Y-m-d");
define('_DBTIMESTRING',"H:i:s");
define('_DBTIMESTAMPSTRING',"Y-m-d H:i:s"); These definition are db related (MySQL date and time data types) and they are NOT dependent on the language used ...
Lucio
16
Thanks
Quote:
In fact this is a problem I encountered
Also $vars[$key]['changed'] property si cloned as false, for this reason the cloned object cannot be correctly stored in the database.
In your opinion, can it make sense to correct the xoopsClone() method to create working objects?
Thx
Quote:
One potential problem is that the XoopsObject has no internal knowledge of it's primary key, so while the object is marked new, it still has any auto-increment PK set. You can work around this issue by doing a $newObject->destroyVars('key-variable-name'); to clean up after a clone.
In fact this is a problem I encountered
Also $vars[$key]['changed'] property si cloned as false, for this reason the cloned object cannot be correctly stored in the database.
In your opinion, can it make sense to correct the xoopsClone() method to create working objects?
Thx
18
Dear,
this is the Xoops site, and is quite different from XOOPS Cube Legacy.
I would like the two projects to become one, but ...
Keep on dreaming fellas!
this is the Xoops site, and is quite different from XOOPS Cube Legacy.
I would like the two projects to become one, but ...
Keep on dreaming fellas!
19
Welcome!
Which version of Xoops are you using?
Which modules are installed?
Is not possible to show multiple modules in a page but it's possible to show blocks from differents modules ...
Which version of Xoops are you using?
Which modules are installed?
Is not possible to show multiple modules in a page but it's possible to show blocks from differents modules ...
20
This is not a solution but a temporary patch.
Define your objects a subclass of ModuleXoopsObject class... this way it is possible to set a column value to NULL...
Define your objects a subclass of ModuleXoopsObject class... this way it is possible to set a column value to NULL...
abstract class ModuleXoopsObject extends XoopsObject {
/**
* @var moduleHelper
* @access private
*/
private $moduleHelper = null;
/**
* constructor
*/
public function __construct()
{
$this->moduleHelper = XmfModuleHelper::getHelper('module');
$this->db = XoopsDatabaseFactory::getDatabaseConnection();
//
parent::__construct();
}
/**
* assign a value to a variable (also null is allowed)
*
* @access public
* @param string $key name of the variable to assign
* @param mixed $value value to assign
* @param bool $not_gpc
*/
public function setVar($key, $value, $not_gpc = false)
{
if (!empty($key) && isset($value) && isset($this->vars[$key])) {
$this->vars[$key]['value'] =& $value;
$this->vars[$key]['not_gpc'] = $not_gpc;
$this->vars[$key]['changed'] = true;
$this->setDirty();
}
if (!empty($key) && is_null($value) && isset($this->vars[$key])) {
$this->vars[$key]['value'] = null;
$this->vars[$key]['not_gpc'] = $not_gpc;
$this->vars[$key]['changed'] = false;
$this->setDirty();
}
}
}
abstract class ModuleXoopsObjectHandler extends XoopsPersistableObjectHandler
{
/**
* @var moduleHelper
* @access private
*/
private $moduleHelper = null;
/**
* @param null|object $db
*/
public function __construct($db = null, $table = '', $className = '', $keyName = '', $identifierName = '')
{
parent::__construct($db, $table, $className, $keyName, $identifierName);
$this->moduleHelper = XmfModuleHelper::getHelper('module');
}
/**
* insert an object into the database
*
* @param XoopsObject $object {@link XoopsObject} reference to object
* @param bool $force flag to force the query execution despite security settings
* @return mixed object ID
*/
public function insert(XoopsObject $object, $force = true)
{
$ret = parent::insert($object, $force);
// handle null values
$queryFunc = empty($force) ? 'query' : 'queryF';
$vars = $object->getVars();
foreach ($vars as $key => $value) {
if (is_null($value['value'])) {
$sql = "UPDATE `{$this->table}` SET `{$key}` = NULL WHERE `{$this->keyName}` = {$this->db->quote($object->getVar($this->keyName))}";
if (!$result = $this->db->{$queryFunc}($sql)) {
//return false;
}
}
}
return $ret;
}
} 
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Feb 28 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
 |
|