/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', '—', 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"; |
?> |
/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"; |
?> |