Roboty - prihlásení
Na tejto stránke postupne budú pribúdat prihlásené roboty. Ak nie ste v zozname, znamená to, že som ešte nedostal Vašu prihlášku. Ozvite sa co najskôr na adresu 'balogh@elf.stuba.sk'.Index
-
$cat_name = array();
$cat_id = array();
$i=1;
openMySQL($host, $user, $passwd, $db);
$sql = mysql_query("SELECT id_category, name FROM category");
while ($category = mysql_fetch_object($sql)) {
$cat_name[$i] = $category->name;
$cat_id[$i] = $category->id_category;
echo "
- ".$cat_name[$i]." "; $i++; } ?>
".$cat_name[$j]."
"; // VYPIS ROBOTOV ID CATEGORY = $cat_id[$j], SHOW = 1! $sql = mysql_query("SELECT category_tag.id_category, category_tag.start_num, author.name_surname, author.town, author.state, robot.name, robot.subauthor, robot.show, robot.fei, robot.arduino, robot.lego, robot.id_robot FROM author INNER JOIN robot ON author.id_author = robot.id_author JOIN category_tag ON robot.id_robot = category_tag.id_robot WHERE category_tag.id_category = '".$cat_id[$j]."' AND category_tag.year = '".$_SESSION['year']."'") or die(mysql_error()); $k=1; while ($robot = mysql_fetch_object($sql)) { if ($robot->show == 1){ if ($robot->start_num == 0){ if ($robot->subauthor == ""){ echo "     ".$k.". Robot id_robot."\">".$robot->name." (".$robot->name_surname.") ".$robot->town; } else { echo "     ".$k.". Robot id_robot."\">".$robot->name." (".$robot->name_surname.", ".$robot->subauthor.") ".$robot->town; } } else{ if ($robot->subauthor == ""){ echo "     ".$k.". #".$robot->start_num." Robot id_robot."\">".$robot->name." (".$robot->name_surname.") ".$robot->town; } else { echo "     ".$k.". #".$robot->start_num." Robot id_robot."\">".$robot->name." (".$robot->name_surname.", ".$robot->subauthor.") ".$robot->town; } } //STATE, IMAGES FEI,ARDUINO, LEGO if ($robot->state == "CR"){ echo " "; } elseif ($robot->state == "PL"){ echo " "; } elseif ($robot->state == "AUT"){ echo " "; } elseif ($robot->state == "MK"){ echo " "; } elseif ($robot->state == "EG"){ echo " "; } elseif ($robot->state == "GER"){ echo " "; } if ($robot->fei == 1){ echo " "; } if ($robot->arduino == 1){ echo " "; } if ($robot->lego == 1){ echo " "; } echo ""; } else { echo "     
"; } $k++; } } ?>
Štatistiky
Počty prihlásených robotov:- 0 Spolu