Changeset 23151

Timestamp:

Jun 11, 2013, 6:35:32 AM (11 years ago)

Author:

rvelices

Message:

history - merge album/tags link into a single column (table is already very large and these columns are mutually exclusive

• add tags link in the history table

Location:

trunk/admin

Files:

• history.php (modified) (1 diff)
• themes/default/template/history.tpl (modified) (3 diffs)

trunk/admin/history.php

@@ -338 +338 @@
 SELECT
     id,
-    name
+    name, url_name
   FROM '.TAGS_TABLE;
-    $name_of_tag = simple_hash_from_query($query, 'id', 'name');
+    $name_of_tag = array();
+    $result = pwg_query($query);
+    while ($row=pwg_db_fetch_assoc($result))
+    {
+      $name_of_tag[ $row['id'] ] = '<a href="'.make_index_url( array('tags'=>array($row))).'">'.trigger_event("render_tag_name", $row['name']).'</a>';
+    }
   }
 

trunk/admin/themes/default/template/history.tpl

@@ -106 +106 @@
 
 <table class="table2" id="detailedStats">
+<thead>
 <tr class="throw">
   <th>{'Date'|@translate}</th>
@@ -114 +115 @@
   <th>{'Element type'|@translate}</th>
   <th>{'Section'|@translate}</th>
-  <th>{'Album'|@translate}</th>
-  <th>{'Tags'|@translate}</th>
+        <th>{'Album'|@translate} / {'Tags'|@translate}</th>
 </tr>
-{if !empty($search_results) }
+</thead>
+{if !empty($search_results)}
 {foreach from=$search_results item=detail name=res_loop}
 <tr class="{if $smarty.foreach.res_loop.index is odd}row1{else}row2{/if}">
@@ -127 +128 @@
   <td>{$detail.TYPE}</td>
   <td>{$detail.SECTION}</td>
-  <td>{$detail.CATEGORY}</td>
-  <td>{$detail.TAGS}</td>
+        <td>{$detail.CATEGORY}{$detail.TAGS}</td>
 </tr>
 {/foreach}