WebSVN - www_nix-files - Различия - Редакция 51 и 53


<?php
        require_once dirname(__FILE__)."/lib/init.php";
        include "./inc/header.htm";
 
 
 
 
 

$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><th>Админ</th>\n";
        while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
            echo "<tr><td><a href='./members.php?memb=".$info_mems['id']."'>".$info_mems['nick']."</a></td>\n";
            echo "<td><img src='".$info_mems['avatar']."' alt='avatar'></td><td><img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."</td>\n";

            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']."' alt='".$info_ress['resource']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";
            }
            echo "</td>";
            echo "<td>";
            $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$info_mems['id']);
            if ($srvs->numRows()==0)
                 echo "&mdash";
            else
                while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
                    echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a>";
            }
            echo "</td>\n";
            echo "</tr>\n";
        }
        echo "</table>";
}
else {
        $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 "<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";
           
            echo "<br>Курирует:<br> | ";
            $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);
            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> | ";
            }
            echo "<br>";
            echo "<br>Администрирует:<br> | ";
            $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);
            while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
                echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> |<br>";
            }
        }
}

        include "./inc/footer.htm";
?>
 

Редакция 51	Редакция 53
1	<?php	1	<?php
2	require_once dirname(__FILE__)."/lib/init.php";	2	require_once dirname(__FILE__)."/lib/init.php";
3	include "./inc/header.htm";	3	include "./inc/header.htm";
4	?>	-
5	<h2>niX-FILES</h2>	-
6	<h1>любые файлы *nix тематики в локальных сетях Барнаула</h1>	-
7	<h3><i>изучай/пользуй/обновляй линукс вместе с nix-files.org.ru</i></h3>	-
8	<?php	-
9		4
10	$memb = abs(intval($_GET["memb"]));	5	$memb = abs(intval($_GET["memb"]));
11		6
12	if($memb==0) {	7	if($memb==0) {
13	$mems =& $db->query("SELECT * FROM members");	8	$mems =& $db->query("SELECT * FROM members");
14	echo "<table>";	9	echo "<table>";
15	echo "<tr>";	10	echo "<tr>";
16	echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Куратор</th><th>Админ</th>\n";	11	echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Куратор</th><th>Админ</th>\n";
17	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {	12	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
18	echo "<tr><td><a href='./members.php?memb=".$info_mems['id']."'>".$info_mems['nick']."</a></td>\n";	13	echo "<tr><td><a href='./members.php?memb=".$info_mems['id']."'>".$info_mems['nick']."</a></td>\n";
19	echo "<td><img src='".$info_mems['avatar']."' alt='avatar'></td><td><img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."</td>\n";	14	echo "<td><img src='".$info_mems['avatar']."' alt='avatar'></td><td><img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."</td>\n";
20		15
21	echo "<td>";	16	echo "<td>";
22	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$info_mems['id']);	17	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$info_mems['id']);
23	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {	18	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
24	echo "<img src='".$info_ress['picture']."' alt='".$info_ress['resource']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";	19	echo "<img src='".$info_ress['picture']."' alt='".$info_ress['resource']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";
25	}	20	}
26	echo "</td>";	21	echo "</td>";
27	echo "<td>";	22	echo "<td>";
28	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$info_mems['id']);	23	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$info_mems['id']);
29	if ($srvs->numRows()==0)	24	if ($srvs->numRows()==0)
30	echo "&mdash";	25	echo "&mdash";
31	else	26	else
32	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {	27	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
33	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a>";	28	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a>";
34	}	29	}
35	echo "</td>\n";	30	echo "</td>\n";
36	echo "</tr>\n";	31	echo "</tr>\n";
37	}	32	}
38	echo "</table>";	33	echo "</table>";
39	}	34	}
40	else {	35	else {
41	$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);	36	$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);
42	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {	37	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
43	echo "<h1>".$info_mems['nick']."</h1>\n";	38	echo "<h2>".$info_mems['nick']."</h2>\n";
44	echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";	39	echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";
45	echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";	40	echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";
46		41
47	echo "<br>Курирует:<br> \| ";	42	echo "<br>Курирует:<br> \| ";
48	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);	43	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);
49	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {	44	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
50	echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> \| ";	45	echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> \| ";
51	}	46	}
52	echo "<br>";	47	echo "<br>";
53	echo "<br>Администрирует:<br> \| ";	48	echo "<br>Администрирует:<br> \| ";
54	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);	49	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);
55	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {	50	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
56	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> \|<br>";	51	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> \|<br>";
57	}	52	}
58	}	53	}
59	}	54	}
60		55
61	include "./inc/footer.htm";	56	include "./inc/footer.htm";
62	?>	57	?>
63		58

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

(root)/trunk/members.php @ 83 - Редакция 51 → 53