[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1189] mbid mismatch report
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1189] mbid mismatch report |
Date: |
Mon, 04 May 2009 23:57:58 +0000 |
Revision: 1189
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1189
Author: clint
Date: 2009-05-04 23:57:58 +0000 (Mon, 04 May 2009)
Log Message:
-----------
mbid mismatch report
Added Paths:
-----------
trunk/nixtape/admin/
trunk/nixtape/admin/report/
trunk/nixtape/admin/report/mbid-mismatch.php
trunk/nixtape/themes/librefm/templates/mbid-mismatch-report.tpl
Added: trunk/nixtape/admin/report/mbid-mismatch.php
===================================================================
--- trunk/nixtape/admin/report/mbid-mismatch.php
(rev 0)
+++ trunk/nixtape/admin/report/mbid-mismatch.php 2009-05-04 23:57:58 UTC
(rev 1189)
@@ -0,0 +1,39 @@
+<?php
+
+/* Libre.fm -- a free network service for sharing your music listening habits
+
+ Copyright (C) 2009 Libre.fm Project
+
+ This program is free software: you can redistribute it and/or modify
+ it under the terms of the GNU Affero General Public License as published by
+ the Free Software Foundation, either version 3 of the License, or
+ (at your option) any later version.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU Affero General Public License for more details.
+
+ You should have received a copy of the GNU Affero General Public License
+ along with this program. If not, see <http://www.gnu.org/licenses/>.
+
+*/
+
+require_once('database.php');
+require_once('templating.php');
+require_once('data/sanitize.php');
+
+$res = $mdb2->query("SELECT t.id, t.artist, t.album, t.name, t.mbid as tmbid,
st.mbid as stmbid FROM Scrobble_Track st JOIN Track t ON lower(t.name)=st.name
AND lower(t.album)=st.album AND lower(t.artist)=st.artist AND t.mbid<>st.mbid");
+
+$aEntries = array();
+$i = 0;
+
+while (($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC))) {
+ $trow = sanitize($row);
+ $aEntries[$i++] = $row;
+}
+
+$smarty->assign("entries", $aEntries);
+
+$smarty->display("mbid-mismatch-report.tpl");
+?>
Added: trunk/nixtape/themes/librefm/templates/mbid-mismatch-report.tpl
===================================================================
--- trunk/nixtape/themes/librefm/templates/mbid-mismatch-report.tpl
(rev 0)
+++ trunk/nixtape/themes/librefm/templates/mbid-mismatch-report.tpl
2009-05-04 23:57:58 UTC (rev 1189)
@@ -0,0 +1,45 @@
+{include file='header.tpl'}
+
+<h2 property="dc:title">MBID mismatch report</h2>
+
+<table>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>Artist</th>
+ <th>Album</th>
+ <th>Track</th>
+ <th>MBID on file</th>
+ <th>Other MBID</th>
+ </tr>
+ </thead>
+ <tbody>
+{section name=i loop=$entries}
+<tr>
+<td>{$entries[$i]->id}</td>
+<td>{$entries[$i]->artist}</td>
+<td>{$entries[$i]->album}</td>
+<td>{$entries[$i]->name}</td>
+<td>{$entries[$i]->tmbid}</td>
+<td>{$entries[$i]->stmbid}</td>
+</tr>
+{/section}
+ </tbody>
+</thead>
+
+ <div id="adbard">
+
+ <!--Ad Bard advertisement snippet, begin -->
+
+ <script type='text/javascript'>
+ var ab_h = '4bcaab930d3bdfded68fd7be730d7db4';
+ var ab_s = '55fd9cde6d855a75f9ca43d854272f6b';
+ </script>
+
+ <script type='text/javascript'
src='http://cdn1.adbard.net/js/ab1.js'></script>
+
+ <!--Ad Bard, end -->
+
+ </div>
+
+{include file='footer.tpl'}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1189] mbid mismatch report,
Clint Adams <=