echo ('");
//*** TABLE HEADER ------------------------------------------------------------
echo (" ");
echo (" ");
echo ("Robots in deze groep | ");
//*** SHOW ALL ALLOWED ROBOTS --------------------------------------------------
if ($koekje[0]>0 and $koekje[3]>0){ //User is logged in and translates
$sql = pg_query($con1,
"SELECT farmbotversie.id
, tblsystext.txtname
, farmbotversie.bot_icon_link
, farmbotversie.lanid
FROM farmbotversie
LEFT JOIN tblsystext ON tblsystext.recordid = farmbotversie.id
WHERE tblsystext.lanid = farmbotversie.lanid
AND tblsystext.txlid = 27
ORDER BY tblsystext.txtname");
}else{
$sql=pg_query($con1,
"SELECT farmbotversie.id
, tblsystext.txtname
, farmbotversie.bot_icon_link
, farmbotversie.lanid
FROM farmbotversie
LEFT JOIN tblsystext ON tblsystext.recordid = farmbotversie.id
WHERE tblsystext.lanid = farmbotversie.lanid
AND tblsystext.txlid = 27
AND farmbotversie.status = 100
ORDER BY tblsystext.txtname");
}
$_recordteller = 0;
$_recordseinde = pg_num_rows($sql);
while ($_recordteller<$_recordseinde):
$arr = pg_fetch_array ($sql ,$_recordteller);
$botid = $arr[0];
if ($botid == 17 OR $botid == 11 OR $botid == 9 OR $botid == 7 OR $botid == 18 OR $botid == 19 OR $botid == 22 OR $botid == 27 OR $botid == 28){
$botid = $arr[0];
$botnaam = $arr[1];
$boticonlink = $arr[2];
if ($arr[3] == 1) {$imgname = "nederland.gif";}
if ($arr[3] == 2) {$imgname = "deutschland.gif";}
if ($arr[3] == 3) {$imgname = "uk.gif";}
if ($arr[3] == 4) {$imgname = "france.gif";}
echo ("");
echo ("");
echo (" $botnaam");
echo (" | ");
echo (' ');
}
$_recordteller++;
endwhile;
echo (' ');
echo ' |