/**
* Add or update a named user defined tag into the database
*
* @param string $name User defined tag name
* @param string $text Body of user defined tag
*
* @return mixed If successful, true. If it fails, false.
*/
function SetUserTag($name, $text)
{
global $gCms;
$db =& $gCms->GetDb();
$existing = UserTagOperations::GetUserTag($name);
if (!$existing) {
$query = "INSERT INTO " . cms_db_prefix() . "userplugins (userplugin_name, code, create_date, modified_date) VALUES (?,?," . $db->DBTimeStamp(time()) . "," . $db->DBTimeStamp(time()) . ")";
$result = $db->Execute($query, array($name, $text));
if ($result) {
return true;
} else {
return false;
}
} else {
$query = 'UPDATE ' . cms_db_prefix() . 'userplugins SET code = ?, modified_date = ' . $db->DBTimeStamp(time()) . ' WHERE userplugin_name = ?';
$result = $db->Execute($query, array($text, $name));
if ($result) {
return true;
} else {
return false;
}
}
}
