[PlaneShift-svn] SF.net SVN: planeshift:[7659] www/webconsole-new/crafting/ checkminditemusage.php

[<rav...@us...>]

Revision: 7659
          http://planeshift.svn.sourceforge.net/planeshift/?rev=7659&view=rev
Author:   ravna-ps
Date:     2011-09-24 13:54:14 +0000 (Sat, 24 Sep 2011)
Log Message:
-----------
Added pattern name + link to the mind item usage check.

Modified Paths:
--------------
    www/webconsole-new/crafting/checkminditemusage.php

Modified: www/webconsole-new/crafting/checkminditemusage.php
===================================================================
--- www/webconsole-new/crafting/checkminditemusage.php	2011-09-24 13:28:06 UTC (rev 7658)
+++ www/webconsole-new/crafting/checkminditemusage.php	2011-09-24 13:54:14 UTC (rev 7659)
@@ -14,11 +14,19 @@
 		echo 'click <a href="./index.php?do=checkminditemusage&amp;full_list">here</a> to load the full page. </p>';
 	}
 	
-	$query = "SELECT id, name, category_id FROM item_stats WHERE stat_type = 'B' AND valid_slots LIKE '%MIND%' ORDER BY name";
+	$query = "SELECT i.id, i.name, i.category_id, p.id AS pattern_id, p.pattern_name FROM item_stats AS i LEFT JOIN trade_patterns AS p ON i.id=p.designitem_id WHERE i.stat_type = 'B' AND i.valid_slots LIKE '%MIND%' ORDER BY i.name";
 	$result = mysql_query2($query);
 	while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 	{
-		echo '<p><a href="./index.php?do=listitems&amp;override1&amp;category='.$row['category_id'].'&amp;item='.$row['id'].'">'.$row['name'].'</a><br/>';
+		echo '<p><a href="./index.php?do=listitems&amp;override1&amp;category='.$row['category_id'].'&amp;item='.$row['id'].'">'.$row['name'].'</a> ';
+		if ($row['pattern_name'] == null) 
+		{
+			echo '(<span class="error">Not used in a pattern pattern</span>)<br/>';
+		}
+		else
+		{
+			echo '(pattern: <a href="./index.php?do=editpattern&amp;id='.$row['pattern_id'].'">'.$row['pattern_name'].'</a>)<br/>';
+		}
 		if(isset($_GET['full_list']))
 		{
 			$item_id = $row['id'];

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.