/*           /----------------
************** showtable()
/*           \----------------------> Displays table from db

Example Usage:

$dbfields = array('id', 'rule', 'topic_id', 'votes', 'poster', 'time');  
  // Fields to be displayed

$tabletitles=array('Id', 'Rule', 'Topic', 'Votes', 'Poster', 'Time', 'mod', 'del');
  // Desired Titles of table to be shown

$extra=array(
'items'=> array (2),
 'i1'=>array('table'=>'topics', 'f1'=>'id_topic', 'f2'=>'topic')
  );
 // Replace third row (which has numeriacl values) with values from another table, that corresponds to those numbers

showtable('mytable', 'id', $dbfields , $tabletitles, $extra);

// mytable = table name, id = name of primary key
*/
function showtable ($table, $order, $fields, $naslovi="", $extra="", $where="") {
$con=dbopen();
$query="SELECT ";
foreach($fields as $value)
	{
		$query.=$value.", ";
		}
		$query = rtrim($query, ', ');
$query.=" FROM $table $where ORDER BY $order";

$result = dbq($query, $con);
dbclose($con);


if (is_array($naslovi)) $number_naslovi = count($naslovi);
if (is_array($fields)) $number_cols = count($fields);
else $number_cols = mysql_num_fields($result);
//echo "<b>Tabela: $table2show</b>";

echo "<div id='tabela' align='center'> <table>\n";


echo "<tr align=center>\n";

for ($i=0; $i<$number_naslovi; $i++)
{
echo "<th>" . $naslovi[$i] . "</th>\n";
}
echo "</tr>\n"; //end table header

/*$number_cols = mysql_num_fields($result);
echo "<table border = 1>\n";
echo "<tr align=center>\n";
echo "<th>ID</th>\n<th>".$naslovc."</th>\n";
echo "</tr>\n"; //end table header
*/
//table body
while ($row = mysql_fetch_row($result))
{
//if (!isset($boja)) $boja = '#99ccff';
// $boja = ($boja=='#99CCFF' ? '#CCCCCC' : '#99CCFF'); 
if (!isset($boja)) $boja = 'tr2';
 $boja = ($boja=='tr1' ? 'tr2' : 'tr1'); 

// echo '<tr align=left bgcolor="'. $boja .'">' . "\n"; 

// echo '<tr align=left bgcolor="'. $boja .'" onMouseOver="this.bgColor=\'#FFFFCC\';" onMouseOut="this.bgColor=\''.$boja.'\';">' . "\n"; 

  echo '<tr class="'.$boja.'" onmouseover="this.className=\'hoverz\';" onmouseout="this.className=\''.$boja.'\';">' . "\n"; 
for ($i=0; $i<$number_cols; $i++)
{
echo "<td>";
if (!isset($row[$i])) //test for null
{echo "NULL";}
else {
	if (is_array($extra)) {
	$doned = 0;
		$xz = count($extra['items']);

		for ($z=0; $z<$xz; $z++)
			{
				if ($i == $extra['items'][$z]) {	
					$nj = $z + 1;
					$itm = 'i'. $nj;
					$con=dbopen();
					$ff2= $extra[$itm]['f2'];
					$tbl2= $extra[$itm]['table'];
					$ff1=  $extra[$itm]['f1'];
					$query = "SELECT $ff2 FROM $tbl2 WHERE $ff1='$row[$i]'";
					$result2 = 	dbq($query, $con);
					dbclose($con);
					$line2= mysql_fetch_array($result2);
					echo $line2['0'];
					$doned = 1;
				}

			}

		}
	

if ($doned != 1) { 
//echo $row[$i];
$row[$i] = strip_tags($row[$i]);
if (strlen($row[$i]) > 100)	$row[$i]=substr( $row[$i], 0, strpos( $row[$i], ' ', 100 ) )."...";
echo $row[$i];

unset($doned);
}
}
echo "</td>\n";
	}
	

echo '<td><a href="' . $_SERVER['PHP_SELF'] . '?action=mod&amp;item=' .$row[0]. '" title="Modify"  style="font-size:xx-small; font-family:Verdana, Arial, Helvetica, sans-serif;"><img class="icon" src="../images/table/table_edit.png"alt="Modify" title="Modify" height="16" width="16"></a></td><td><a href="' . $_SERVER['PHP_SELF'] . '?action=del&amp;item=' .$row[0]. '" onClick="return confirmSubmit()" title="Delete" style="font-size:xx-small; font-family:Verdana, Arial, Helvetica, sans-serif;"><img class="icon" src="../images/table/table_del.png"alt="Delete" title="Delete" height="16" width="16"></a></td>';
echo "</tr>\n";
}
echo "</table>";

}