",$a);
$tpl->assign($a);
// lieferanten laden
$sql = "SELECT l.* FROM pass24_liefer AS l, pass24_al AS al WHERE al.a_id={$a['id']} AND al.l_id=l.id ORDER BY l.platz";
$list = array();
$res = my_query($sql);
while ($data=mysql_fetch_assoc($res)) $list[] = $data;
misc_str_replace("\n","
",$list);
$tpl->assign('liefer',$list);
// verknüpfte artikel laden
$sql = "SELECT * FROM pass24_aal AS aal, pass24_artikel AS a WHERE aal.al_id=a.id AND aal.a_id={$a['id']}";
$list = array();
$res = my_query($sql);
while ($data=mysql_fetch_assoc($res)) $list[] = $data;
misc_str_replace("\n","
",$list);
$tpl->assign('links',$list);
// content laden
for ($i=1;$i<=4;$i++)
{
$sql = "SELECT c.* FROM pass24_acl AS acl, pass24_c{$i} AS c WHERE acl.cl_id=c.id AND acl.a_id={$a['id']} AND acl.c={$i}";
$res = my_query($sql);
echo(mysql_error());
$data=mysql_fetch_assoc($res);
$tpl->assign("content{$i}",$data);
}
// anzeigen
display("artikel.tpl");
}
function myshuffle(&$array)
{
$num = count($array);
for ($i = 0; $i < $num; $i ++)
{
$n = mt_rand(0, $num - 1);
$temp = $array[$n];
$array[$n] = $array[$i];
$array[$i] = $temp;
}
}
// almost like str_replace but also handles arrays (also nested arrays)
function misc_str_replace($search, $replace, &$data)
{
if (is_array($data))
{
foreach ($data as $k => $v) misc_str_replace($search, $replace, $data[$k]);
return;
}
$data = str_replace($search, $replace, $data);
}
function display($t)
{
global $tpl,$message;
$tpl->assign('message',$message);
$tpl->display($t);
exit;
}
function add_m($s)
{
global $message;
$message .= $s.'
';
}
switch ($_REQUEST['display'])
{
default:
d_artikel();
break;
}
?>