public static function TagsSave(Ab_Database $db, $module, $owner, $ownerid, $tags, $groupid = 0)
{
$sql = "\n DELETE FROM " . $db->prefix . "tag_owner\n WHERE modname='" . bkstr($module) . "'\n AND owner='" . bkstr($owner) . "'\n AND ownerid=" . intval($ownerid) . "\n ";
$db->query_write($sql);
$ret = array();
$rows = TagQuery::TagsByTags($db, $tags);
while ($d = $db->fetch_array($rows)) {
$ret[] = $d['tag'];
$sql = "\n INSERT INTO " . $db->prefix . "tag_owner\n (modname,owner,ownerid,tagid,groupid,userid)\n VALUES (\n '" . bkstr($module) . "',\n '" . bkstr($owner) . "',\n " . intval($ownerid) . ",\n " . intval($d['tagid']) . ",\n " . intval($groupid) . ",\n " . intval(Abricos::$user->id) . "\n )\n ";
$db->query_write($sql);
}
return $ret;
}
public static function TeacherRemove(Ab_Database $db, $d)
{
$sql = "\n\t\t\tUPDATE " . $db->prefix . "rb_teacher\n\t\t\tSET\n\t\t\t\tremove=" . bkint($d->remove) . "\n\t\t\tWHERE teacherid=" . bkint($d->id) . "\n\t\t\tLIMIT 1\n\t\t";
$db->query_write($sql);
}
public static function NewsPublish(Ab_Database $db, $newsid)
{
$sql = "\n\t\t\tUPDATE " . $db->prefix . "ns_news\n\t\t\tSET published='" . TIMENOW . "'\n\t\t\tWHERE newsid=" . bkint($newsid) . " \n\t\t";
$db->query_write($sql);
}
