Хранилища Subversion www_nix-files

Сравнить редакции

Не учитывать пробелы Редакция 26 → Редакция 27

/trunk/members.php
9,7 → 9,24
 
$memb = abs(intval($_GET["memb"]));
 
if($memb==0) {
$mems =& $db->query("SELECT * FROM members");
echo "<table>";
echo "<tr>";
echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Куратор</th>";
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td>";
 
echo "<td>";
$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$info_mems['id']);
while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";
}
echo "</td></tr>";
}
echo "</table>";
}
else {
$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
echo "<h1>".$info_mems['nick']."</h1>\n";
22,6 → 39,7
echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> | ";
}
}
}
 
include "./inc/footer.htm";
?>
/trunk/db/nix-files.sql
3,7 → 3,7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 27 2009 г., 15:23
-- Время создания: Сен 27 2009 г., 16:10
-- Версия сервера: 5.1.37
-- Версия PHP: 5.2.10-2ubuntu4
 
105,8 → 105,8
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
(4, 'mistiman', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0),
(5, 'IK', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0),
(7, 'SP|Scream', './img/avatar/spscream.png', '', 0),
(8, 'Yamah', './img/avatar/yamah.png', '', 0);
(7, 'SP|Scream', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0),
(8, 'Yamah', './img/avatar/yamah.png', '&mdash;', 0);
 
-- --------------------------------------------------------
 
/trunk/index.php
105,27 → 105,6
}
echo "</table>";
break;
case 2:
$mems =& $db->query("SELECT * FROM members");
echo "<table>";
echo "<tr>";
echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>";
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
$ranks =& $db->query("SELECT *
FROM res_mem_rank
JOIN resources ON resources.id = res_mem_rank.resource_id
JOIN networks ON networks.id = res_mem_rank.network_id
JOIN members ON members.id = res_mem_rank.member_id
WHERE member_id=".$info_mems['id']);
$ranklist = "";
while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) {
$ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>";
}
echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>";
}
echo "</table>";
break;
}
 
include "./inc/footer.htm";
?>