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