From: Luca P. <lpa...@us...> - 2006-12-27 22:04:55
|
Update of /cvsroot/planeshift/planeshift/www/serverconsole/tradeskills In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18519 Modified Files: view_tradeskills.php Log Message: quick fix, just to see some data. Index: view_tradeskills.php =================================================================== RCS file: /cvsroot/planeshift/planeshift/www/serverconsole/tradeskills/view_tradeskills.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** view_tradeskills.php 17 Apr 2006 23:17:42 -0000 1.5 --- view_tradeskills.php 27 Dec 2006 22:04:53 -0000 1.6 *************** *** 8,21 **** $query = mysql_query2($sql); $result = mysql_fetch_array($query); $pattern_id = $result['pattern_id']; $result_id = $result['result_id']; $result_qty = $result['result_qty']; $item_id = $result['item_id']; $item_qty = $result['item_qty']; - $item_quality = $result['item_quality']; $trans_points = $result['trans_points']; - $animation = $result['animation']; - $workitem_id = $result['workitem_id']; - $equipment_id = $result['equipment_id']; $primary_skill_id = $result['primary_skill_id']; --- 8,19 ---- $query = mysql_query2($sql); $result = mysql_fetch_array($query); + $id = $result['id']; $pattern_id = $result['pattern_id']; + $pattern_id = $result['process_id']; $result_id = $result['result_id']; $result_qty = $result['result_qty']; $item_id = $result['item_id']; $item_qty = $result['item_qty']; $trans_points = $result['trans_points']; $primary_skill_id = $result['primary_skill_id']; *************** *** 159,166 **** <H1> Transformations available in this pattern </H1> <TABLE CELLPADDING=5 CELLSPACING=0> ! <TH>ID</TH><TH>Source</TH><TH>Source Qty</TH><TH>Result</TH><TH>Result Qty</TH><TH>Work Item</TH> <?PHP ! $sql= "select * from trade_transformations where pattern_id=$pattern_id order by workitem_id"; $result = mysql_query2($sql); --- 157,164 ---- <H1> Transformations available in this pattern </H1> <TABLE CELLPADDING=5 CELLSPACING=0> ! <TH>ID</TH><TH>Process ID</TH><TH>Source</TH><TH>Source Qty</TH><TH>Result</TH><TH>Result Qty</TH> <?PHP ! $sql= "select * from trade_transformations where pattern_id=$pattern_id order by result_id"; $result = mysql_query2($sql); *************** *** 170,174 **** $colour = $bgcolour1; while ($temp = mysql_fetch_array($result)) ! { if ( $colour == $bgcolour1 ) $colour = $bgcolour2; --- 168,172 ---- $colour = $bgcolour1; while ($temp = mysql_fetch_array($result)) ! { if ( $colour == $bgcolour1 ) $colour = $bgcolour2; *************** *** 177,194 **** $transformID = $temp['id']; $itemName = GetItemName( $temp["item_id"] ); $item_qty = $temp['item_qty']; $resultName = GetItemName( $temp['result_id'] ); $result_qty = $temp['result_qty']; - $workItem = GetItemName($temp['workitem_id']); ?> <TR BGCOLOR=<?PHP echo "$colour"?> > <TD><?PHP echo $transformID ?></TD> <TD><?PHP echo $itemName ?></TD> <TD><?PHP echo $item_qty ?></TD> <TD><?PHP echo $resultName ?></TD> <TD><?PHP echo $result_qty ?></TD> - <TD><?PHP echo $workItem ?></TD> <TD><A HREF="index.php?page=view_tradeskills&page2=edit_transform&transform_id=<?PHP echo $transformID?>">Edit</A></TD> </TR> --- 175,192 ---- $transformID = $temp['id']; + $process_id = $temp['process_id']; $itemName = GetItemName( $temp["item_id"] ); $item_qty = $temp['item_qty']; $resultName = GetItemName( $temp['result_id'] ); $result_qty = $temp['result_qty']; ?> <TR BGCOLOR=<?PHP echo "$colour"?> > <TD><?PHP echo $transformID ?></TD> + <TD><?PHP echo $process_id ?></TD> <TD><?PHP echo $itemName ?></TD> <TD><?PHP echo $item_qty ?></TD> <TD><?PHP echo $resultName ?></TD> <TD><?PHP echo $result_qty ?></TD> <TD><A HREF="index.php?page=view_tradeskills&page2=edit_transform&transform_id=<?PHP echo $transformID?>">Edit</A></TD> </TR> |