public function validate_tag_new($m, $arg)
{
if (false !== Slay_Tag::getByName($arg)) {
return $m->lang('err_tag_exists');
}
return false;
}
public function validate_tag($m, $arg)
{
if (Slay_Tag::getByName($arg) !== false) {
return $m->lang('err_dup_tag');
}
return GWF_Validator::validateString($m, 'tag', $arg, 1, 63, true);
}
private function onTag(Slay_Song $song)
{
$form = $this->formTag($song);
if (false !== ($error = $form->validateCSRF_WeakS())) {
return $error;
}
$tags = array();
$errors = array();
foreach ($_POST as $k => $v) {
if (Common::startsWith($k, 'tag_')) {
$k = substr($k, 4);
if (Slay_Tag::getByName($k) === false) {
$errors[] = $this->module->lang('err_tag_uk');
} else {
$tags[] = $k;
}
}
}
if (count($errors) > 0) {
return GWF_HTML::error('Slaytags', $errors);
}
$user = GWF_Session::getUser();
if (false === Slay_TagVote::clearVotes($song, $user)) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
if (false === Slay_TagVote::addVotes($song, $user, $tags)) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
if (false === $song->computeTags()) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
return $this->module->message('msg_tagged');
}
public static function validateTag(Module_Slaytags $module, $tagid, $allowEmpty = true, $blank = true, $name = 'searchtag')
{
if ($allowEmpty && $tagid == 0) {
return false;
}
if (false === Slay_Tag::getByID($tagid)) {
if ($blank) {
unset($_POST[$name]);
}
return $module->lang('err_searchtag');
}
return false;
}
private static function defaultTags(Module_Slaytags $module, $dropTables)
{
$tags = array('Rock', 'Pop', 'Classic', 'Siddy', 'Metal', 'Punk', 'Dance', 'Raggae', 'HipHop', 'Rap', 'Trance', 'Techno', 'Instrumental', 'Funk', 'Caribian', 'Acapella', 'Country', 'Orchestral', 'DrumAndBass', 'BreakBeat', 'Goa', 'Gabba', 'Ambient', 'Piano', 'Intro', 'Lyrics', 'Progressive', 'Melodic', 'Piano', 'Guitar', 'Bassy', 'Happy', 'Melancholic', 'Minimal', 'Relax', 'Funky', 'Oriental', 'Electro', 'House', 'Game', 'Tribal', 'Slow', 'Fast', 'Medieval', 'Theme', '80s', 'Spheric', 'Blues', 'Jazz', 'Acid');
$table = GDO::table('Slay_Tag');
foreach ($tags as $tag) {
if (false === Slay_Tag::getByName($tag)) {
if (false === $table->insertAssoc(array('st_id' => 0, 'st_uid' => 0, 'st_name' => $tag), true)) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
}
}
return '';
}
public function validate_tag_new($m, $arg)
{
if (false === ($this->tag2 = Slay_Tag::getByID($arg))) {
return $m->lang('err_unknown_target_tag');
}
if (!$this->tag) {
return false;
}
if ($this->tag->getID() === $this->tag2->getID()) {
return $m->lang('err_merge_same_tag');
}
return false;
}
public static function addVotes(Slay_Song $song, GWF_User $user, array $tags)
{
$uid = $user->getID();
$sid = $song->getID();
$date = GWF_Time::getDate(GWF_Date::LEN_SECOND);
$table = self::table(__CLASS__);
foreach ($tags as $tag) {
if (false === ($tid = Slay_Tag::getIDByName($tag))) {
return false;
}
if (false === $table->insertAssoc(array('stv_uid' => $uid, 'stv_sid' => $sid, 'stv_tid' => $tid, 'stv_date' => $date), false)) {
return false;
}
}
return true;
}
public static function computeVotes(Slay_Song $song, $taggers = 0)
{
$sid = $song->getID();
$cache = array();
$table = self::table(__CLASS__);
foreach (Slay_Tag::getAllTags() as $tag_obj) {
$tid = $tag_obj->getID();
if (false === ($count = Slay_TagVote::countVotes($sid, $tid))) {
return false;
}
$avg = $taggers > 0 ? (int) ($count / $taggers * self::SCALE) : 0;
if ($count > 0) {
$cache[$tag_obj->getVar('st_name')] = array($count, $tid);
}
if (false === $table->insertAssoc(array('sst_sid' => $sid, 'sst_tid' => $tid, 'sst_count' => $count, 'sst_average' => $avg), true)) {
return false;
}
}
# Cleanup empties
if (false === $table->deleteWhere("sst_count=0")) {
return false;
}
# Build cache
$cc = NULL;
if (count($cache) > 0) {
arsort($cache);
foreach ($cache as $tname => $data) {
list($count, $tid) = $data;
$href = sprintf('/index.php?mo=Slaytags&me=Search&searchtag=%s&searchterm=&search=Search&by=ss_id&dir=ASC&page=1', $tid);
$cc .= sprintf(', <a href="%s">%s(%.02f%%)</a>', $href, $tname, $count / $taggers * 100);
}
$cc = substr($cc, 2);
}
if (false === $song->saveVar('ss_tag_cache', $cc)) {
return false;
}
return true;
}
public function getTags()
{
return Slay_Tag::getTags($this);
}
private function onSearch()
{
$form = $this->formSearch();
if (false !== ($error = $form->validate($this->module))) {
return $error . $this->templateSearch();
}
$ipp = self::IPP;
$term = $form->getVar('searchterm');
$tagname = NULL;
$table = GDO::table('Slay_Song');
$whitelist = array('(ss_lyrics>0)', '(ss_options&1)', '(ss_sid_path!=NULL)');
$joins = array('lyrics');
if (false === ($where = GWF_QuickSearch::getQuickSearchConditions($table, array('ss_artist', 'ss_title', 'ss_composer'), $term))) {
return GWF_HTML::err('ERR_SEARCH_TERM') . $this->templateSearch();
}
$term2 = GDO::escape($term);
// $term2 = str_replace(array('%', '_'), array('\\%', '\\_'), $term);
$term3 = '1';
if ('0' !== ($tag = $form->getVar('searchtag'))) {
$tagname = Slay_Tag::getNameByID($tag);
$term3 = 'sst_count>0';
$joins[] = 'searchtag';
}
$where = "(({$where}) OR (ssl_lyrics LIKE '%{$term2}%')) AND ({$term3})";
$nItems = $table->countRows($where, $joins);
$nPages = GWF_PageMenu::getPagecount($ipp, $nItems);
$page = Common::clamp(Common::getGetInt('page'), 1, $nPages);
$from = GWF_PageMenu::getFrom($page, $ipp);
$by = Common::getGetString('by', self::BY);
$dir = Common::getGetString('dir', self::DIR);
$orderby = $table->getMultiOrderby($by, $dir, false, $whitelist);
$matches = $table->selectAll('*', $where, $orderby, $joins, $ipp, $from, GDO::ARRAY_O);
$headers = array(array(), array($this->module->lang('L'), '(ss_lyrics>0)'), array($this->module->lang('T'), 'ss_taggers'), array($this->module->lang('D'), '(ss_options&1)'), array($this->module->lang('th_artist'), 'ss_artist'), array($this->module->lang('th_title'), 'ss_title'), array($this->module->lang('th_duration'), 'ss_duration'), array($this->l('th_bpm'), 'ss_bpm'), array($this->l('th_key'), 'ss_key'));
if ($tag > 0) {
$headers[] = array($this->module->lang(Slay_Tag::getNameByID($tag)), 'sst_count');
}
$headers[] = array($this->module->lang('th_tags'));
$tVars = array('form' => $form->templateX($this->module->lang('ft_search'), GWF_WEB_ROOT . 'index.php'), 'pagemenu' => GWF_PageMenu::display($page, $nPages, GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=Search&searchterm=%s&searchtag=%s&by=%s&dir=%s&page=%%PAGE%%', urlencode($term), $tag, urlencode($by), urlencode($dir))), 'matches' => $matches, 'sort_url' => GWF_WEB_ROOT . sprintf('index.php?mo=Slaytags&me=Search&searchterm=%s&searchtag=%s&by=%%BY%%&dir=%%DIR%%&page=1', urlencode($term), $tag), 'is_admin' => GWF_User::isStaffS(), 'headers' => $headers, 'singletag' => $tagname, 'no_match' => count($matches) === 0);
return $this->module->template('search.tpl', $tVars);
}
