setvars($lang); // get assetclassgroup info $result = mysql_query("SELECT ac.assetclassgroup_id, ac.assetclass_name, acg.assetclassgroup_name FROM assetclass ac, assetclassgroup acg WHERE ac.assetclass_id='$assetclass_id' AND acg.assetclassgroup_id=ac.assetclassgroup_id") or die(mysql_error()); $row = mysql_fetch_object($result); $tp->set("assetclass_name", $row->assetclass_name); $tp->set("assetclassgroup_id", $row->assetclassgroup_id); $tp->set("assetclassgroup_name", $row->assetclassgroup_name); // get assets for this assetclassgroup $result = mysql_query("SELECT asset_id, asset_name FROM asset WHERE assetclass_id='$assetclass_id' ORDER BY asset_name") or die(mysql_error()); for ($i=0;$row=mysql_fetch_object($result);$i++) { $tp->set("asset_id", $row->asset_id); $tp->set("asset_name", $row->asset_name); $tp->parse("assetrow"); } if (($i>0) ? $tp->parse("asset") : $tp->hide("asset")); // display options if($_SESSION['suser_level'] >= $config_userlevel_assetclassedit) { $tp->set("assetclass_id", $assetclass_id); $tp->parse("assetclassedit"); } else { $tp->hide("assetclassedit"); } if($_SESSION['suser_level'] >= $config_userlevel_assetclassdel) { $tp->set("assetclass_id", $assetclass_id); $tp->parse("assetclassdel"); } else { $tp->hide("assetclassdel"); } // output $tp->parse(); $tp->spit(); include("footer.php"); ?>