Hi all
I’m trying to hack the cool "AuthorTimestamp"-snippet (
http://modxcms.com/AuthorTimestamp-693.html), so it will do my bidding. But I’m running into some trouble.
Basically I want to make the database-query-stuff into a function, so I can call it several times... here is the working code, before my hacking:
//Get document info
$document_data = $modx->getPageInfo($id,1,'createdby,createdon,editedby,editedon');
//Get Creator details
$db_query = $modx->db->select('fullname,email,phone,mobilephone,photo,comment', $this->getFullTableName('user_attributes'), 'id = '.$document_data['createdby']);
$db_results = $modx->db->makeArray($db_query);
$creator_data = $db_results[0];
And now, my hacked function, derived from the above working example:
function get_user_data($user_id) {
$db_query = $modx->db->select('fullname,email,phone,mobilephone,photo,comment', $this->getFullTableName('user_attributes'), 'id = '.$user_id);
$db_results = $modx->db->makeArray($db_query);
return $db_results[0];//there should be only one result!
}
... here I feed the function with a user_id, so I can retrieve data from different users (ie. creator/editor/publisher etc.)
This is all good... but a problem arrises around the "$this->getFullTableName" I think... anyway I’m getting following error (line 16 is the $db_query variable):
[tt]
Fatal error: Call to a member function on a non-object in /Library/WebServer/Documents/MODx_default/manager/includes/document.parser.class.inc.php(769) : eval()’d code on line 16
[/tt]
I beleive this is a scope issue... but I’m all new to php, so if anyone could point me in the right direction, I would really appreciate it.
Thanks in advance
☆ A M B ☆
