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

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

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

/trunk/members.php
36,6 → 36,7
$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
echo "<h2>".$info_mems['nick']."</h2>\n";
echo "<h2>".$info_mems['fio']."</h2>\n";
echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";
echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";
/trunk/db/nix-files.sql
139,6 → 139,7
CREATE TABLE IF NOT EXISTS `members` (
`id` int(2) NOT NULL AUTO_INCREMENT,
`nick` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`fio` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`avatar` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`jabber` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`icq` int(15) NOT NULL,
150,13 → 151,13
--
 
INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
(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', 'xelnag@jabber.ru', 0),
(8, 'Yamah', './img/avatar/yamah.png', '&mdash;', 0);
(1, 'Diffor', 'Функ Дмитрий','./img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
(2, 'firstleon', '', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
(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', 'xelnag@jabber.ru', 0),
(8, 'Yamah', '', './img/avatar/yamah.png', '&mdash;', 0);
 
-- --------------------------------------------------------