[Librefm-commits] [1189] mbid mismatch report

[Clint Adams]

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'}