WebSVN - www_nix-files - Различия - Редакция 206 и 207


<?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 "<div id='infocard-member' class='avatar-id-".$info_mems['id']."'><h4>".$info_mems['nick']."</h4>\n";
            echo "<p class='fio'>".$info_mems['fio']."</p>\n";
            echo "<p class='jabber'>".$info_mems['jabber']."</p>\n";
            echo "<p class='homepage'><a href='".$info_mems['homepage']."'>".$info_mems['homepage']."</a></p>\n";
//        echo "<p class='icq'>".$info_mems['icq']."</p>\n";
            echo "<div class='owners'><p><strong>Курирует:</strong> ";
            $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);
            while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
                echo "<span class='".$info_ress['resource']."-small'><a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a></span>";
            }
            echo "</p></div>";
            echo "<div class='admins'><p><strong>Администрирует:</strong> ";
            $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);
            while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
                echo "<span class='server'><a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a></span>";
            }
        echo "</p></div></div>";
        }
}

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

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

(root)/trunk/members.php - Редакция 206 → 207

Редакция 206		Редакция 207
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		4
5	$memb = abs(intval($_GET["memb"]));	5	$memb = abs(intval($_GET["memb"]));
6		6
7	if($memb==0) {	7	if($memb==0) {
8	$mems =& $db->query("SELECT * FROM members");	8	$mems =& $db->query("SELECT * FROM members");
9	echo "<table>";	9	echo "<table>";
10	echo "<tr>";	10	echo "<tr>";
11	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";
12	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {	12	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
13	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";
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";	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";
15		15
16	echo "<td>";	16	echo "<td>";
17	$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']);
18	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {	18	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
19	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>";
20	}	20	}
21	echo "</td>";	21	echo "</td>";
22	echo "<td>";	22	echo "<td>";
23	$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']);
24	if ($srvs->numRows()==0)	24	if ($srvs->numRows()==0)
25	echo "—";	25	echo "—";
26	else	26	else
27	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {	27	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
28	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>";
29	}	29	}
30	echo "</td>\n";	30	echo "</td>\n";
31	echo "</tr>\n";	31	echo "</tr>\n";
32	}	32	}
33	echo "</table>";	33	echo "</table>";
34	}	34	}
35	else {	35	else {
36	$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);	36	$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);
37	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {	37	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
38	echo "<div id='infocard-member' class='avatar-id-".$info_mems['id']."'><h4>".$info_mems['nick']."</h4>\n";	38	echo "<div id='infocard-member' class='avatar-id-".$info_mems['id']."'><h4>".$info_mems['nick']."</h4>\n";
39	echo "<p class='fio'>".$info_mems['fio']."</p>\n";	39	echo "<p class='fio'>".$info_mems['fio']."</p>\n";
40	echo "<p class='jabber'>".$info_mems['jabber']."</p>\n";	40	echo "<p class='jabber'>".$info_mems['jabber']."</p>\n";
41	echo "<p class='homepage'>".$info_mems['homepage']."</p>\n";	41	echo "<p class='homepage'><a href='".$info_mems['homepage']."'>".$info_mems['homepage']."</a></p>\n";
42	// echo "<p class='icq'>".$info_mems['icq']."</p>\n";	42	// echo "<p class='icq'>".$info_mems['icq']."</p>\n";
43	echo "<div class='owners'><p><strong>Курирует:</strong> ";	43	echo "<div class='owners'><p><strong>Курирует:</strong> ";
44	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);	44	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);
45	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {	45	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
46	echo "<span class='".$info_ress['resource']."-small'><a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a></span>";	46	echo "<span class='".$info_ress['resource']."-small'><a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a></span>";
47	}	47	}
48	echo "</p></div>";	48	echo "</p></div>";
49	echo "<div class='admins'><p><strong>Администрирует:</strong> ";	49	echo "<div class='admins'><p><strong>Администрирует:</strong> ";
50	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);	50	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);
51	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {	51	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
52	echo "<span class='server'><a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a></span>";	52	echo "<span class='server'><a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a></span>";
53	}	53	}
54	echo "</p></div></div>";	54	echo "</p></div></div>";
55	}	55	}
56	}	56	}
57		57
58	include "./inc/footer.htm";	58	include "./inc/footer.htm";
59	?>	59	?>
60		60