Редакция 169 | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 169 | Редакция 170 | ||
---|---|---|---|
1 | <?php
|
1 | <?php
|
- | 2 | $imgdir="./custom/apt/ico/"; |
|
- | 3 | ||
2 | $mirs =& $db->query("SELECT * FROM apt_reps"); |
4 | $mirs =& $db->query("SELECT * FROM apt_reps"); |
3 | echo "<h2>Зеркалируемые репозитории</h2>\n"; |
5 | echo "<h2>Зеркалируемые репозитории</h2>\n"; |
4 | echo "<table>\n"; |
6 | echo "<table>\n"; |
5 | echo "<tr>"; |
7 | echo "<tr>"; |
6 | echo "<th>№</th><th>Источник</th><th>Описание</th><th>Дистрибутивы</th>\n"; |
8 | echo "<th>№</th><th> </th><th>Источник</th><th>Описание</th><th>Дистрибутивы</th>\n"; |
7 | $n = 0; |
9 | $n = 0; |
8 | while ($mirs->fetchInto($info_mirs, DB_FETCHMODE_ASSOC)) { |
10 | while ($mirs->fetchInto($info_mirs, DB_FETCHMODE_ASSOC)) { |
9 | echo "<tr>\n"; |
11 | echo "<tr>\n"; |
- | 12 | echo "<td>".++$n."</td><td>"; |
|
- | 13 | if($info_mirs['logo']=="") echo "—"; |
|
- | 14 | else echo "<img src='".$imgdir.$info_mirs['logo']."' width='16' height='16' alt='logo'>"; |
|
10 | echo " <td>".++$n."</td><td><a href='".$info_mirs['src_url']."'>".$info_mirs['src_name']."</a></td><td>".$info_mirs['description']."</td>\n"; |
15 | echo "</td><td><a href='".$info_mirs['src_url']."'>".$info_mirs['src_name']."</a></td><td>".$info_mirs['description']."</td>\n"; |
11 | 16 | ||
12 | $distrs =& $db->query("SELECT * FROM apt_distrs"); |
17 | $distrs =& $db->query("SELECT * FROM apt_distrs"); |
13 | echo "<td>"; |
18 | echo "<td>"; |
14 | while ($distrs->fetchInto($info_distrs, DB_FETCHMODE_ASSOC)) { |
19 | while ($distrs->fetchInto($info_distrs, DB_FETCHMODE_ASSOC)) { |
15 | 20 | ||
16 | $vers =& $db->query("SELECT * FROM apt_vers JOIN apt_reps2vers ON apt_vers.id=apt_reps2vers.ver_id WHERE distr_id=".$info_distrs['id']." AND rep_id=".$info_mirs['id']); |
21 | $vers =& $db->query("SELECT * FROM apt_vers JOIN apt_reps2vers ON apt_vers.id=apt_reps2vers.ver_id WHERE distr_id=".$info_distrs['id']." AND rep_id=".$info_mirs['id']); |
17 | if ($vers->numRows()!=0) { |
22 | if ($vers->numRows()!=0) { |
18 | echo "<img src='".$info_distrs['logo']."' alt='logo'>".$info_distrs['distr'].": "; |
23 | echo "<img src='".$info_distrs['logo']."' alt='logo'>".$info_distrs['distr'].": "; |
19 | while ($vers->fetchInto($info_vers, DB_FETCHMODE_ASSOC)) { |
24 | while ($vers->fetchInto($info_vers, DB_FETCHMODE_ASSOC)) { |
20 | echo $info_vers['codename']." "; |
25 | echo $info_vers['codename']." "; |
21 | }
|
26 | }
|
22 | echo "<br>"; |
27 | echo "<br>"; |
23 | }
|
28 | }
|
24 | }
|
29 | }
|
25 | echo "</td>"; |
30 | echo "</td>"; |
26 | 31 | ||
27 | echo "</tr>"; |
32 | echo "</tr>"; |
28 | }
|
33 | }
|
29 | echo "</table>\n"; |
34 | echo "</table>\n"; |
30 | ?>
|
35 | ?>
|
31 | 36 |