[Comoblog-commit] comoblog/modules/mod_tunelog mod_tunelog_quickadd2.php, NONE, 1.1 mod_tunelog_qui
Status: Inactive
Brought to you by:
markwallis
|
From: iamdecal <iam...@us...> - 2006-10-22 11:44:07
|
Update of /cvsroot/comoblog/comoblog/modules/mod_tunelog In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27709/modules/mod_tunelog Added Files: mod_tunelog_quickadd2.php mod_tunelog_quickadd.php mod_tunelog.php mod_tunelog_buildstatic.php dosomethingv2_12.exe mod_tunelog_pump.pl readme.html urls.html mod_tunelog_pump.sql dosomething.htm mod_tunelog_include.php index.php mod_tunelog_showpage_stuffer.php Log Message: work in progress, ditching this server cos its borked ;( --- NEW FILE: mod_tunelog_include.php --- <p>These most played tracks</p> <?php include_once ('../../include/mod_tunelog_list_by_track.php'); ?> <br><br><br> <p>The most played albums</p> <?php include_once ('../../include/mod_tunelog_list_by_album.php'); ?> <br><br><br> <p>The most played artists,</p> <?php include_once ('../../include/mod_tunelog_list_by_artist.php'); ?> <br><br><br> <p>And how much per month</p> <?php include_once ('../../include/mod_tunelog_list_by_month.php'); ?> <br><br><br> --- NEW FILE: mod_tunelog_quickadd.php --- <?php include_once (dirname(__FILE__).'/../../include/config.inc.php'); require_once ('include/mod_tunelog.inc.php'); Header ('Content-type: text/html'); $item = mod_tunelog_add($_GET); echo "tune insert ok <br>"; /* dont #include('../mod_contentextra/mod_contentextra_showpage_stuffer.php'); #include('mod_tunelog_showpage_stuffer.php'); #include('../../batch/comoblog_batch.php'); */ ?> --- NEW FILE: dosomething.htm --- --- NEW FILE: index.php --- --- NEW FILE: dosomethingv2_12.exe --- (This appears to be a binary file; contents omitted.) --- NEW FILE: mod_tunelog_buildstatic.php --- <?php // hugely based on mod batch @ignore_user_abort(true); include_once (dirname(__FILE__).'/../../include/config.inc.php'); require_once (CFG_BASE_PATH.'/modules/mod_tunelog/include/mod_tunelog.inc.php'); @set_time_limit(CFG_BATCH_TIMEOUT); // batch interval $interval = CFG_MOD_TUNELOG_STATIC_INTERVAL * 60; $now = time(); $diff = $now - CFG_LAST_MOD_TUNELOG_STATIC; echo "($interval - $now) = $diff <hr>" ; // if last_batch was more than CFG_MOD_TUNELOG_STATIC_INTERVAL minutes ago, execute batch if ($diff > $interval) { // connect to db mysql_connect (CFG_MYSQL_HOST, CFG_MYSQL_USERNAME, CFG_MYSQL_PASSWORD) or die ('Error connecting to mySQL server'); mysql_select_db (CFG_MYSQL_DBNAME) or die ('Error selecting database'); // update timestamp in CFG_LAST_MOD_TUNELOG_STATIC // we do this now to stop new attempts while were building $now = time(); $query = "update ".CFG_MYSQL_TABPREFIX."preferences set pref_value='".$now."' where pref_name='CFG_LAST_MOD_TUNELOG_STATIC'"; $result = mysql_query($query); echo "DONE UPDATE - INTO build by month"; ######################################################################## $tunelog_items = mod_tunelog_list_by_month(); if ($tunelog_items) { echo "DONE UPDATE - INTO build by month - got items.<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_month.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); } echo $mod_contents; $fp = fopen(dirname(__FILE__).'/../../include/mod_tunelog_list_by_month.php', 'w'); fwrite($fp, $mod_contents); fclose($fp); ####################################################################################### $tunelog_items = mod_tunelog_list_by_artist(); if ($tunelog_items) { echo "DONE UPDATE - INTO build by artist - got items.<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_artist.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); } echo $mod_contents; $fp = fopen(dirname(__FILE__).'/../../include/mod_tunelog_list_by_artist.php', 'w'); fwrite($fp, $mod_contents); fclose($fp); ####################################################################################### $tunelog_items = mod_tunelog_list_by_album(); if ($tunelog_items) { echo "DONE UPDATE - INTO build by month - got items<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_album.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); } echo $mod_contents; $fp = fopen(dirname(__FILE__).'/../../include/mod_tunelog_list_by_album.php', 'w'); fwrite($fp, $mod_contents); fclose($fp); ####################################################################################### $tunelog_items = mod_tunelog_list_by_track(); if ($tunelog_items) { echo "DONE UPDATE - INTO build by track- got items<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_track.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); } echo $mod_contents; $fp = fopen(dirname(__FILE__).'/../../include/mod_tunelog_list_by_track.php', 'w'); fwrite($fp, $mod_contents); fclose($fp); ####################################################################################### // end of if last_batch was more than CFG_MOD_TUNELOG_STATIC_INTERVAL minutes ago, execute batch } // exit exit; ?> --- NEW FILE: mod_tunelog.php --- <?php if (in_array('mod_tunelog', $SIDEBAR_MODULES)) $mod_pos = 'sidebar'; else $mod_pos = 'top'; require_once (CFG_BASE_PATH.'/modules/mod_tunelog/include/mod_tunelog.inc.php'); $tunelog_items = mod_tunelog_list(); if ($tunelog_items) { $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/'.$mod_pos.'/mod_tunelog.tpl.htm'); if (CFG_TUNELOG_TOPLINE) $mod_tunelog_tpl->assign('CFG_TUNELOG_TOPLINE', CFG_TUNELOG_TOPLINE ); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $tpl->assign('BGCOLOR', '#ffffff'); else $tpl->assign('BGCOLOR', '#efefef'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); } else $mod_contents = ''; ?> --- NEW FILE: mod_tunelog_pump.pl --- #!/usr/bin/perl -w # Author: derek almond # Date Created: 08/11/01 ### rebuild daily stats for traffic tracker use DBI; print "delete from comoblog_mod_tunelog;\n"; my $dbh_from = DBI->connect("DBI:mysql:dsitescouk:igor.office.sift.co.uk","root",""); die "Failed to connect to from database" if (!$dbh_from); my $sql= "select * from tunes " ; my $sth = $dbh_from->prepare($sql) ; my $rv = $sth->execute(); warn "Found " . $sth->rows . " tunes" ; while (defined (my $hash_ref = $sth->fetchrow_hashref() ) ) { $hash_ref->{tune_songtitle} =~ s/\'/\\\'/gi; $hash_ref->{tune_artist} =~ s/\'/\\\'/gi; $hash_ref->{tune_album} =~ s/\'/\\\'/gi; print qq# insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('$hash_ref->{tune_songtitle}','$hash_ref->{tune_artist}','$hash_ref->{tune_album}',0,'','Y','','$hash_ref->{tune_dateplayed}',1); #; } print "\nupdate comoblog_mod_tunelog set tunelog_added =UNIX_TIMESTAMP(tunelog_addeddate);"; $sth->finish() ; my $rc = $dbh_from->disconnect ; --- NEW FILE: mod_tunelog_pump.sql --- delete from comoblog_mod_tunelog; insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('highlife & style - bits and bo','various','xtrax chemical danc culture',0,'','Y','','2003-01-30 15:31:49',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('we 3 - groovy dimensions','various','xtrax chemical danc culture',0,'','Y','','2003-01-30 15:35:31',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('n-zo & dj invincible - trippin','various','xtrax chemical danc culture',0,'','Y','','2003-01-30 15:39:59',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('After the Watershed (Early Lea','Carter the Unstoppable Sex Mac','After The Watershed',0,'','Y','','2003-01-30 15:43:06',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('The 90\'s Revival','Carter the Unstoppable Sex Mac','After The Watershed',0,'','Y','','2003-01-30 15:47:34',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('A Nation of Shoplifters','Carter the Unstoppable Sex Mac','After The Watershed',0,'','Y','','2003-01-30 15:49:36',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('This is How it Feels','Carter the Unstoppable Sex Mac','After The Watershed',0,'','Y','','2003-01-30 15:51:40',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Alternative Alf Garnett','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 15:54:45',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Do Re Me So Far So Good','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 15:57:50',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('A Bachelor For Baden Powell','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 16:02:22',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Re-Educating Rita','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 16:06:28',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Only Living Boy In New Cross','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 16:15:58',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Lean On Me I Won\'t Fall Over','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 16:20:29',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Granny farming In The U.K.','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 16:43:01',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Travis','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 17:02:48',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Sing Fat Lady Sing','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 17:07:00',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Lenny And Terence','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 17:10:43',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Commercial Fucking Suicide Par','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-01-30 17:14:38',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Cheap \'n\' Cheesy','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 09:42:16',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Airplane Food / Airplane Fast','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 09:47:18',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('The Young Offender\'s Mum','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 09:50:53',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Gas (man)','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 09:54:21',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('The Life and Soul of the Party','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 09:58:05',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('My Defeatist Attitude','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:02:10',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Worry Bomb','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:05:22',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Senile Delinquent','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:09:21',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Me and Mr. Jones','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:11:51',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Let\'s Get Tattoos','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:15:24',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Going Straight','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:18:13',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('God, Saint Peter and the Guard','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:22:11',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('The Only Looney Left in Town','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:25:53',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Ceasefire','Carter the Unstoppable Sex Mac','Worry Bomb',0,'','Y','','2003-01-31 10:32:06',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Reverend Black Grape','Black Grape','It\'s Great When You\'re Straigh',0,'','Y','','2003-01-31 13:42:02',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Charlotte','Macc Ladds','The Lads from Macc: Live at Le',0,'','Y','','2003-01-31 13:42:23',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-01-31 13:47:11',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Radar Love','Golden Earring','The Continuing Story of Radar',0,'','Y','','2003-01-31 13:51:15',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Rolf Harris - Two Little Boys','Various Artists','Chegger\'s Choice (CD2)',0,'','Y','','2003-01-31 13:57:40',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-01-31 14:08:02',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Radar Love','Golden Earring','The Continuing Story of Radar',0,'','Y','','2003-01-31 14:12:07',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Perfect Day','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 14:13:11',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('La Plage','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 14:16:46',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('The Day I was Born','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:25:23',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Secrets','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:29:15',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Shining','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:33:10',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Bring Me Down','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:39:21',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Skin','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:43:42',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Slouch','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:48:04',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Bleeding You Dry','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:50:22',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Patterns','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:55:43',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('When Will You Come','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 15:59:20',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('West of the Cox','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 16:03:02',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Ballad of the Bishop','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 16:07:10',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Glass Smash Jack','EMF','Cha Cha Cha',0,'','Y','','2003-01-31 16:11:20',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 09:47:39',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 10:04:34',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 10:04:35',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 10:04:36',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Main Title','vangelis','blade runner',0,'','Y','','2003-02-03 10:05:03',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Blush Response','vangelis','blade runner',0,'','Y','','2003-02-03 10:08:45',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Wait For Me','vangelis','blade runner',0,'','Y','','2003-02-03 10:14:33',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Rachel\'s Song','vangelis','blade runner',0,'','Y','','2003-02-03 10:20:02',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Love Theme','vangelis','blade runner',0,'','Y','','2003-02-03 10:24:46',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('One More Kiss, Dear','vangelis','blade runner',0,'','Y','','2003-02-03 10:40:09',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Blade Runner Blues','vangelis','blade runner',0,'','Y','','2003-02-03 10:44:08',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Memories Of Green','vangelis','blade runner',0,'','Y','','2003-02-03 10:53:03',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Tales Of The Future','vangelis','blade runner',0,'','Y','','2003-02-03 10:58:07',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Damask Rose','vangelis','blade runner',0,'','Y','','2003-02-03 11:02:55',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Blade Runner (End Titles)','vangelis','blade runner',0,'','Y','','2003-02-03 11:05:28',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Tears In Rain','vangelis','blade runner',0,'','Y','','2003-02-03 11:10:07',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Video Killed The Radio Star','The Buggles','',0,'','Y','','2003-02-03 12:00:17',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Give it Up','The Goodmen','',0,'','Y','','2003-02-03 12:03:37',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Charlotte','Macc Ladds','The Lads from Macc: Live at Le',0,'','Y','','2003-02-03 12:07:05',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('There\'s nothing like this','Omar','',0,'','Y','','2003-02-03 12:11:53',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Ain\'t No Sunshine','Al Green','',0,'','Y','','2003-02-03 12:15:51',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 12:20:31',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Freestyler','Bomfunk Mc\'s','',0,'','Y','','2003-02-03 12:24:37',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Daddy Cool','Boney M','',0,'','Y','','2003-02-03 12:33:43',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Love Will Tear Us Apart','Joy Division','Substance',0,'','Y','','2003-02-03 12:37:12',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('If I Owned A Midget','Benefit','',0,'','Y','','2003-02-03 13:26:03',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Freestyler','Bomfunk Mc\'s','',0,'','Y','','2003-02-03 14:20:21',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Arnold Calls Miss Cleo','Joe and Colin','',0,'','Y','','2003-02-03 14:21:15',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 14:23:53',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 14:25:40',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 14:38:19',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Concert in Chicago 1989','Bill Hicks','',0,'','Y','','2003-02-03 15:44:27',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-03 17:05:29',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Concert in Chicago 1989','Bill Hicks','',0,'','Y','','2003-02-04 12:40:14',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Philosophy: The Best of Bill H','Bill Hicks','Philosophy: The Best of Bill H',0,'','Y','','2003-02-04 13:30:53',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Rant in E Minor','Bill Hicks','Rant in E Minor',0,'','Y','','2003-02-04 13:31:37',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-04 16:56:47',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-04 16:56:47',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-04 17:01:54',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('11 European Club Gig # 11','Underworld','European Club Gig',0,'','Y','','2003-02-04 17:09:02',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('no tags','','',0,'','Y','','2003-02-04 17:09:15',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Drop My Beat','(Congo Natty)','Congo Natty EP',0,'','Y','','2003-02-04 17:11:06',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values (' congo natty - Broader than Broadway','','',0,'','Y','','2003-02-04 17:11:56',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Hop Frog','Lou Reed','The Raven-ADVANCE-CD2',0,'','Y','','2003-02-04 17:12:33',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Yeah Yeah Brother','Black Grape','It\'s Great When You\'re Straigh',0,'','Y','','2003-02-04 17:12:34',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Head up High','Black Rebel Motorcycle Club','Black Rebel Motorcycle Club',0,'','Y','','2003-02-04 17:12:37',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Moloko - The Time Is Now (Fran','Various Artists','Chillout Experience - CD1',0,'','Y','','2004-02-19 01:55:00',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values (' GroupHug.mp3 -','','',0,'','Y','','2003-02-04 17:14:25',1); insert into comoblog_mod_tunelog (tunelog_songtitle,tunelog_artist,tunelog_album,tunelog_trackno,tunelog_tracklength,tunelog_visible,tunelog_added,tunelog_addeddate,tunelog_user_id) values ('Lean On Me I Won\'t Fall Over','Carter U.S.M.','Live in Zagreb, 20/5/94',0,'','Y','','2003-02-04 17:44:27',1); --- NEW FILE: urls.html --- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled</title> </head> <body> http://www.iamdecal.co.uk/modules/mod_tunelog/mod_tunelog_quickadd.php?tunelog_songtitle=%%URL_CURRENTSONGTITLE%%&tunelog_artist=%%URL_CURRENTARTIST%%&tunelog_album=%%URL_CURRENTALBUM%%&tunelog_trackno=%%TRACKNO%%&tunelog_tracklength=%%URL_CURRENTSONGLENGTH%% http://igor.office.sift.co.uk/moblog/modules/mod_tunelog/mod_tunelog_quickadd.php?tunelog_songtitle=%%URL_CURRENTSONGTITLE%%&tunelog_artist=%%URL_CURRENTARTIST%%&tunelog_album=%%URL_CURRENTALBUM%%&tunelog_trackno=%%TRACKNO%%&tunelog_tracklength=%%URL_CURRENTSONGLENGTH%% http://igor.office.sift.co.uk/cgi-bin/dsites_addtunes.cgi?tune_songtitle=%%URL_CURRENTSONGTITLE%%&tune_artist=%%URL_CURRENTARTIST%%&tune_album=%%URL_CURRENTALBUM%%&filename=%%CURRENTSONG%%&tune_user_id=1 http://www.d-sites.co.uk/cgi-bin/dsites_addtunes.cgi?tune_songtitle=%%URL_CURRENTSONGTITLE%%&tune_artist=%%URL_CURRENTARTIST%%&tune_album=%%URL_CURRENTALBUM%%&filename=%%CURRENTSONG%%&tune_user_id=1 http://www.iamdecal.co.uk/modules/mod_tunelog/mod_tunelog_quickadd.php?tunelog_songtitle=%%URL_CURRENTSONGTITLE%%&tunelog_artist=%%URL_CURRENTARTIST%%&tunelog_album=%%URL_CURRENTALBUM%%&tunelog_trackno=%%TRACKNO%%&tunelog_tracklength=%%URL_CURRENTSONGLENGTH%% http://igor.office.sift.co.uk/cgi-bin/tune_through_proxy.cgi?tunelog_songtitle=%%URL_CURRENTSONGTITLE%%&tunelog_artist=%%URL_CURRENTARTIST%%&tunelog_album=%%URL_CURRENTALBUM%%&tunelog_trackno=%%TRACKNO%%&tunelog_tracklength=%%URL_CURRENTSONGLENGTH%% </html> --- NEW FILE: readme.html --- http://igor.office.sift.co.uk/moblog/modules/mod_tunelog/mod_tunelog_quickadd.php?tunelog_songtitle=%%%URL_CURRENTSONGTITLE%%&tunelog_artist=%%URL_CURRENTARTIST%%&tunelog_album=%%URL_CURRENTALBUM%%&tunelog_trackno=%%TRACKNO%%&tunelog_tracklength=%%URL_SONGLENGTH%% http://igor.office.sift.co.uk/cgi-bin/dsites_addtunes.cgi?tune_songtitle=%%URL_CURRENTSONGTITLE%%&tune_artist=%%URL_CURRENTARTIST%%&tune_album=%%URL_CURRENTALBUM%%&filename=%%CURRENTSONG%%&tune_user_id=1 --- NEW FILE: mod_tunelog_quickadd2.php --- <?php require_once ('../../admin/include/admin.inc.php'); require_once ('include/mod_tunelog.inc.php'); Header ('Content-type: text/plain'); $item = mod_tunelog_add2($_POST); echo "ok"; echo $_POST ; ?> --- NEW FILE: mod_tunelog_showpage_stuffer.php --- <?php // hugely based on mod batch @ignore_user_abort(true); include_once (dirname(__FILE__).'/../../include/config.inc.php'); require_once (CFG_BASE_PATH.'/modules/mod_tunelog/include/mod_tunelog.inc.php'); @set_time_limit(CFG_BATCH_TIMEOUT); // batch interval $interval = CFG_MOD_TUNELOG_STATIC_INTERVAL * 60; $now = time(); $diff = $now - CFG_LAST_MOD_TUNELOG_STATIC; #echo "tunelog ($interval - $now) = $diff <hr>" ; // if last_batch was more than CFG_MOD_TUNELOG_STATIC_INTERVAL minutes ago, execute batch if ($diff != $interval) { // connect to db mysql_connect (CFG_MYSQL_HOST, CFG_MYSQL_USERNAME, CFG_MYSQL_PASSWORD) or die ('Error connecting to mySQL server'); mysql_select_db (CFG_MYSQL_DBNAME) or die ('Error selecting database'); // update timestamp in CFG_LAST_MOD_TUNELOG_STATIC // we do this now to stop new attempts while were building $now = time(); $query = "update ".CFG_MYSQL_TABPREFIX."preferences set pref_value='".$now."' where pref_name='CFG_LAST_MOD_TUNELOG_STATIC'"; $result = mysql_query($query); # #echo "DONE UPDATE - INTO build by month"; ######################################################################## $mod_contents=""; $tunelog_items = mod_tunelog_list_by_month(); if ($tunelog_items) { # #echo "DONE UPDATE - INTO build by month - got items.<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_month.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $mod_tunelog_list_by_month = $mod_contents; } ####################################################################################### $mod_contents=""; $tunelog_items = mod_tunelog_list_by_artist(); if ($tunelog_items) { # #echo "DONE UPDATE - INTO build by artist - got items.<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_artist.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $mod_tunelog_list_by_artist = $mod_contents; } ####################################################################################### $mod_contents=""; $tunelog_items = mod_tunelog_list_last_ten(); if ($tunelog_items) { # #echo "DONE UPDATE - INTO build by artist - got items.<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_last_ten.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $mod_tunelog_list_last_ten = $mod_contents; } ####################################################################################### $mod_contents=""; $tunelog_items = mod_tunelog_list_by_album(); if ($tunelog_items) { # #echo "DONE UPDATE - INTO build by month - got items<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_album.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $mod_tunelog_list_by_album = $mod_contents; } ####################################################################################### $mod_contents=""; $tunelog_items = mod_tunelog_list_by_track(); if ($tunelog_items) { # #echo "DONE UPDATE - INTO build by track- got items<hr>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_list_by_track.tpl.htm'); for ($c = 0; $c < count($tunelog_items); $c++) { if ($c % 2) $mod_tunelog_tpl->assign('ROW', 'tunesrowa'); else $mod_tunelog_tpl->assign('ROW', 'tunesrowb'); $mod_tunelog_tpl->assign('ITEM', $tunelog_items[$c]); $mod_tunelog_tpl->parse('main.item'); } $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $mod_tunelog_list_by_track = $mod_contents; } ###### bung it all together, stick it in the db #echo "Starting to put it all together again <br>"; $mod_tunelog_tpl = new XTemplate (CFG_BASE_PATH.'/modules/mod_tunelog/templates/mod_tunelog_full_page.tpl.htm'); #echo "got template <br>"; $mod_tunelog_tpl->assign('BYMONTH', $mod_tunelog_list_by_month); $mod_tunelog_tpl->assign('BYTRACK', $mod_tunelog_list_by_track); $mod_tunelog_tpl->assign('BYARTIST', $mod_tunelog_list_by_artist); $mod_tunelog_tpl->assign('BYALBUM', $mod_tunelog_list_by_album); $mod_tunelog_tpl->assign('LASTTEN', $mod_tunelog_list_last_ten); $mod_tunelog_tpl->parse('main'); $mod_contents = $mod_tunelog_tpl->text("main"); $update = mod_tunelog_showpage_stuffer ($mod_contents); #echo "doen the update. ($update) <br>"; // end of if last_batch was more than CFG_MOD_TUNELOG_STATIC_INTERVAL minutes ago, execute batch } Header ('Location: /cgi-bin/iamdecal.cgi?page=tunes'); ?> |