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


<?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 "<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";
           
            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";
?>
 

Редакция 53	Редакция 83
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 "&mdash";	25	echo "&mdash";
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 "<h2>".$info_mems['nick']."</h2>\n";	38	echo "<h2>".$info_mems['nick']."</h2>\n";
-		39	echo "<h2>".$info_mems['fio']."</h2>\n";
39	echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";	40	echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";
40	echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";	41	echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";
41		42
42	echo "<br>Курирует:<br> \| ";	43	echo "<br>Курирует:<br> \| ";
43	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);	44	$ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);
44	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {	45	while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
45	echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> \| ";	46	echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> \| ";
46	}	47	}
47	echo "<br>";	48	echo "<br>";
48	echo "<br>Администрирует:<br> \| ";	49	echo "<br>Администрирует:<br> \| ";
49	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);	50	$srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);
50	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {	51	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {
51	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> \|<br>";	52	echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> \|<br>";
52	}	53	}
53	}	54	}
54	}	55	}
55		56
56	include "./inc/footer.htm";	57	include "./inc/footer.htm";
57	?>	58	?>
58		59

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

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