public static function NewsCount(Ab_Database $db, $userid = 0, $retvalue = false)
{
$sql = "\n\t\t\tSELECT count( newsid ) AS cnt\n\t\t\tFROM " . $db->prefix . "ns_news\n\t\t\tWHERE ((deldate=0 AND published>0) OR userid=" . bkint($userid) . ") AND language='" . bkstr(Abricos::$LNG) . "' \n\t\t\tLIMIT 1 \n\t\t";
if ($retvalue) {
$row = $db->query_first($sql);
return $row['cnt'];
} else {
return $db->query_read($sql);
}
}
public static function TagsByQuery(Ab_Database $db, $module, $config)
{
$tags = Tag::TagsParse(array($config->query));
if (count($tags) !== 1) {
return;
}
$query = $tags[0];
$sql = "\n SELECT t.tag\n FROM " . $db->prefix . "tag_owner o\n INNER JOIN " . $db->prefix . "tag t ON o.tagid=t.tagid\n WHERE t.tag LIKE '" . bkstr($query) . "%'\n AND modname='" . bkstr($module) . "'\n AND (\n " . (isset($config->groupid) ? "o.groupid=" . intval($config->groupid) . " OR " : "") . "\n o.userid=" . bkint(Abricos::$user->id) . "\n )\n GROUP BY t.tag\n ORDER BY t.tag\n LIMIT 10\n\t\t";
return $db->query_read($sql);
}
public static function StudidListFromMark(Ab_Database $db, $sheetid)
{
$sql = "\n\t\t\tSELECT \n \t\t\t\tstudid as id\n \t\tFROM " . $db->prefix . "rb_marks\n \t\tWHERE sheetid=" . bkint($sheetid) . "\n\t\t";
return $db->query_read($sql);
}
