[Comoblog-commit] comoblog/modules/mod_tunelog/include mod_tunelog.inc.php, NONE, 1.1

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/comoblog/modules/mod_tunelog/include
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27709/modules/mod_tunelog/include

Added Files:
	mod_tunelog.inc.php 
Log Message:
work in progress, ditching this server cos its borked ;(



--- NEW FILE: mod_tunelog.inc.php ---
<?php
function mod_tunelog_details ($item_id) {
   $query = "select * from ".CFG_MYSQL_TABPREFIX."mod_tunelog where tunelog_id = '".$item_id."'";
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $item = mysql_fetch_assoc($res);

   return ($item);
}


function mod_tunelog_list () {
   $query = "
               select   b.*
               from     ".CFG_MYSQL_TABPREFIX."mod_tunelog b
               order by b.tunelog_addeddate desc limit " . CFG_MOD_TUNELOG_HOW_MANY;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   return ($items);
}

function mod_tunelog_add ($item) {

  # $query = "select max(tunelog_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_tunelog";
  # $res = mysql_query($query);
  # $item['tunelog_display_order'] = mysql_result($res,0,0);

   $item['tunelog_added'] = time();
   $item['tunelog_visble'] = "Y";
   $item['tunelog_user_id'] ="1";
   if (strlen($item['tunelog_tracklength']) ==4)
    {
   $item['tunelog_tracklength'] ="00:0". $item['tunelog_tracklength'];
   }

   if (strlen($item['tunelog_tracklength']) ==5)
    {
   $item['tunelog_tracklength'] ="00:". $item['tunelog_tracklength'];
   }

   $query = "
               insert into    ".CFG_MYSQL_TABPREFIX."mod_tunelog
               (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id)
               values        ('".  addslashes($item['tunelog_songtitle'])          ."',
                              '".  addslashes($item['tunelog_artist'])        ."',
                              '".  addslashes($item['tunelog_album'])  ."',
                              '".  addslashes($item['tunelog_trackno'])."',
                              '".  addslashes($item['tunelog_tracklength'])."',
                              '".  addslashes($item['tunelog_visible'])."',
                              '".  addslashes($item['tunelog_added'])."',
                              now(),
                              '".   $item['tunelog_user_id']        ."')
   ";

   $res = mysql_query($query);
   echo $query;
   if (!$res)
      return (false);

   $item['id'] = mysql_insert_id();
   $query2 ="update comoblog_mod_tunelog set  tunelog_tracklength ='".   $item['tunelog_tracklength']."' where
                        tunelog_songtitle           = '".  $item['tunelog_songtitle']          ."' and
                        tunelog_artist         = '".  $item['tunelog_artist']        ."' and
                        tunelog_album   = '".  $item['tunelog_album']  ."'
                        and tunelog_tracklength ='00:00:00';
                        " ;

   #$res = mysql_query($query2);
   return ($item);
}


function mod_tunelog_add2 ($item) {

  # $query = "select max(tunelog_display_order)+1 from ".CFG_MYSQL_TABPREFIX."mod_tunelog";
  # $res = mysql_query($query);
  # $item['tunelog_display_order'] = mysql_result($res,0,0);

   $item['tunelog_added'] = time();
   $item['tunelog_visble'] = "Y";
   $item['tunelog_user_id'] ="1";
   $query = "
               insert into    ".CFG_MYSQL_TABPREFIX."mod_tunelog
               (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id)
               values        ('".   $item['tunelog_songtitle']          ."',
                              '".   $item['tunelog_artist']        ."',
                              '".   $item['tunelog_album']  ."',
                              '".   $item['tunelog_trackno']."',
                              '".   $item['tunelog_tracklength']."',
                              '".   $item['tunelog_visible']."',
                              '".   $item['tunelog_added']."',
                              now(),
                              '".   $item['tunelog_user_id']        ."')
   ";
   $res = mysql_query($query);

   if (!$res)
      return (false);

   $item['id'] = mysql_insert_id();

   return ($item);
}



function mod_tunelog_del ($item_id) {
   $query = "delete from ".CFG_MYSQL_TABPREFIX."mod_tunelog where tunelog_id = '".$item_id."'";
   $res = mysql_query($query);

   if (!$res)
      return (false);

   return (true);
}

function mod_tunelog_edit ($item) {
   $query = "
               update   ".CFG_MYSQL_TABPREFIX."mod_tunelog
               set
                        tunelog_songtitle           = '".  $item['tunelog_songtitle']          ."',
                        tunelog_artist         = '".  $item['tunelog_artist']        ."',
                        tunelog_album   = '".  $item['tunelog_album']  ."',
                        tunelog_tracklength = '".  $item['tunelog_tracklength']."'
               where
                        tunelog_id            = '".  $item['tunelog_id']           ."'
   ";
   $res = mysql_query($query);

   if (!$res)
      return (false);

   return ($item);
}


function mod_tunelog_list_by_month () {
   $query = "select concat(monthname(tunelog_addeddate),' ', year(tunelog_addeddate))as column1  , count(*) as column2  from ".CFG_MYSQL_TABPREFIX."mod_tunelog group by column1 order by substring(tunelog_addeddate,1,7) desc";
   #echo $query;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   #echo mysql_num_rows($res);
   return ($items);
}



function mod_tunelog_list_by_artist () {
   $query = "select distinct(tunelog_artist) as column1, count(*) as column2  from ".CFG_MYSQL_TABPREFIX."mod_tunelog group by column1 order by column2 desc  limit 40";
   #echo $query;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   #echo mysql_num_rows($res);
   return ($items);
}




function mod_tunelog_list_by_album () {
   $query = "SELECT tunelog_album,tunelog_artist , round(COUNT(tunelog_album) / COUNT(DISTINCT tunelog_songtitle, tunelog_album)) AS frequency FROM comoblog_mod_tunelog GROUP BY tunelog_album ORDER BY frequency DESC limit 50";
   #echo $query;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   #echo mysql_num_rows($res);
   return ($items);
}

function mod_tunelog_list_by_track () {
   $query = "select tunelog_songtitle as column1,tunelog_artist as column2 , count(*) as column3 from comoblog_mod_tunelog group by column1,column2  order by column3 desc limit 40";
   #echo $query;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   #echo mysql_num_rows($res);
   return ($items);
}







function mod_tunelog_list_last_ten () {
   $query = "
               select   b.*, FROM_UNIXTIME(b.tunelog_added  ) as tunelog_played
               from     ".CFG_MYSQL_TABPREFIX."mod_tunelog b
               order by b.tunelog_addeddate desc limit " . CFG_MOD_TUNELOG_HOW_MANY;
   $res = mysql_query($query);

   if (!$res || !mysql_num_rows($res))
      return (false);

   $items = array();
   while ($row = mysql_fetch_assoc($res)) {
      $items[] = $row;
   }
   return ($items);
}







function mod_tunelog_showpage_stuffer ($item_text) {
   $query = "update   ".CFG_MYSQL_TABPREFIX."mod_showpage  set showpage_url = '', showpage_description = '".  addslashes($item_text) ."' where  lower(showpage_nav_text)  = 'tunes'";
   #echo  $query;
   $res = mysql_query($query);

   if (!$res)
      return (false);

   return ($res);
}





function mod_tunelog_up ($item_id) {

}

function mod_tunelog_down ($item_id) {

}
?>