Редакция 468 | Редакция 471 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
466 | diffor | 1 | <?php |
2 | |||
3 | require_once 'DB.php'; |
||
4 | |||
468 | diffor | 5 | $dsn = 'sqlite:///apt.db?mode=0777'; |
466 | diffor | 6 | |
468 | diffor | 7 | $db_apt =& DB::connect($dsn); |
8 | if (PEAR::isError($db_apt)) { |
||
9 | die($db_apt->getMessage()); |
||
466 | diffor | 10 | } |
11 | |||
468 | diffor | 12 | $dsn = 'sqlite:///set.db?mode=0777'; |
13 | |||
14 | $db_set =& DB::connect($dsn); |
||
15 | if (PEAR::isError($db_set)) { |
||
16 | die($db_set->getMessage()); |
||
17 | } |
||
18 | |||
19 | $distr = abs(intval($_GET["d"])); |
||
20 | |||
21 | if($distr==0) { |
||
22 | $reps =& $db_apt->query("SELECT * FROM reps"); |
||
466 | diffor | 23 | while ($reps->fetchInto($info_reps,DB_FETCHMODE_ASSOC)) { |
468 | diffor | 24 | $dists =& $db_apt->query("SELECT * FROM reps2dists JOIN dists ON reps2dists.dist_id=dists.id WHERE rep_id=".$info_reps['id']); |
470 | diffor | 25 | echo "# ".$info_reps['rep']."<br>"; |
466 | diffor | 26 | while ($dists->fetchInto($info_dists,DB_FETCHMODE_ASSOC)) { |
27 | echo " http://apt.nix-files.org.ru/".$info_reps['rep']." ".$info_dists['dists.dist']; |
||
468 | diffor | 28 | $sects =& $db_apt->query("SELECT * FROM reps2dists2sects JOIN sects ON reps2dists2sects.sect_id=sects.id WHERE reps2dists_id==".$info_dists['reps2dists.id']); |
466 | diffor | 29 | while ($sects->fetchInto($info_sects,DB_FETCHMODE_ASSOC)) { |
30 | echo " ".$info_sects['sects.sect']; |
||
31 | } |
||
32 | echo "<br>"; |
||
33 | } |
||
34 | } |
||
468 | diffor | 35 | } |
36 | else { |
||
37 | $codename =& $db_set->getOne("SELECT codename FROM vers WHERE id=".$distr); |
||
38 | |||
39 | $reps =& $db_apt->query("SELECT * FROM reps"); |
||
40 | while ($reps->fetchInto($info_reps,DB_FETCHMODE_ASSOC)) { |
||
41 | $dists =& $db_apt->query('SELECT * FROM reps2dists JOIN dists ON reps2dists.dist_id=dists.id WHERE rep_id='.$info_reps['id'].' AND dists.dist LIKE "'.$codename.'%"'); |
||
470 | diffor | 42 | if ($dists->numRows()!=0) echo "# ".$info_reps['rep']."<br>"; |
468 | diffor | 43 | while ($dists->fetchInto($info_dists,DB_FETCHMODE_ASSOC)) { |
44 | echo " http://apt.nix-files.org.ru/".$info_reps['rep']." ".$info_dists['dists.dist']; |
||
45 | $sects =& $db_apt->query("SELECT * FROM reps2dists2sects JOIN sects ON reps2dists2sects.sect_id=sects.id WHERE reps2dists_id==".$info_dists['reps2dists.id']); |
||
46 | while ($sects->fetchInto($info_sects,DB_FETCHMODE_ASSOC)) { |
||
47 | echo " ".$info_sects['sects.sect']; |
||
48 | } |
||
49 | echo "<br>"; |
||
50 | } |
||
51 | } |
||
52 | } |
||
466 | diffor | 53 | |
54 | //$query =& $dba->query("SET NAMES utf8"); |
||
55 | |||
56 | ?> |