Редакция 470 | Редакция 480 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
471 | diffor | 1 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/1998/REC-html40-19980424/loose.dtd"> |
2 | <html lang="ru"> |
||
3 | <head> |
||
4 | <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> |
||
5 | <title>Генератор sources.list для apt.niX-FILES</title> |
||
6 | </head> |
||
7 | <body bgcolor="#F7F7F7"> |
||
8 | |||
9 | <h1>sources.list</h1> |
||
10 | |||
466 | diffor | 11 | <?php |
12 | |||
13 | require_once 'DB.php'; |
||
14 | |||
468 | diffor | 15 | $dsn = 'sqlite:///apt.db?mode=0777'; |
466 | diffor | 16 | |
468 | diffor | 17 | $db_apt =& DB::connect($dsn); |
18 | if (PEAR::isError($db_apt)) { |
||
19 | die($db_apt->getMessage()); |
||
466 | diffor | 20 | } |
21 | |||
468 | diffor | 22 | $dsn = 'sqlite:///set.db?mode=0777'; |
23 | |||
24 | $db_set =& DB::connect($dsn); |
||
25 | if (PEAR::isError($db_set)) { |
||
26 | die($db_set->getMessage()); |
||
27 | } |
||
28 | |||
29 | $distr = abs(intval($_GET["d"])); |
||
30 | |||
31 | if($distr==0) { |
||
32 | $reps =& $db_apt->query("SELECT * FROM reps"); |
||
466 | diffor | 33 | while ($reps->fetchInto($info_reps,DB_FETCHMODE_ASSOC)) { |
468 | diffor | 34 | $dists =& $db_apt->query("SELECT * FROM reps2dists JOIN dists ON reps2dists.dist_id=dists.id WHERE rep_id=".$info_reps['id']); |
470 | diffor | 35 | echo "# ".$info_reps['rep']."<br>"; |
466 | diffor | 36 | while ($dists->fetchInto($info_dists,DB_FETCHMODE_ASSOC)) { |
37 | echo " http://apt.nix-files.org.ru/".$info_reps['rep']." ".$info_dists['dists.dist']; |
||
468 | diffor | 38 | $sects =& $db_apt->query("SELECT * FROM reps2dists2sects JOIN sects ON reps2dists2sects.sect_id=sects.id WHERE reps2dists_id==".$info_dists['reps2dists.id']); |
466 | diffor | 39 | while ($sects->fetchInto($info_sects,DB_FETCHMODE_ASSOC)) { |
40 | echo " ".$info_sects['sects.sect']; |
||
41 | } |
||
42 | echo "<br>"; |
||
43 | } |
||
44 | } |
||
468 | diffor | 45 | } |
46 | else { |
||
47 | $codename =& $db_set->getOne("SELECT codename FROM vers WHERE id=".$distr); |
||
48 | |||
49 | $reps =& $db_apt->query("SELECT * FROM reps"); |
||
50 | while ($reps->fetchInto($info_reps,DB_FETCHMODE_ASSOC)) { |
||
51 | $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 | 52 | if ($dists->numRows()!=0) echo "# ".$info_reps['rep']."<br>"; |
468 | diffor | 53 | while ($dists->fetchInto($info_dists,DB_FETCHMODE_ASSOC)) { |
54 | echo " http://apt.nix-files.org.ru/".$info_reps['rep']." ".$info_dists['dists.dist']; |
||
55 | $sects =& $db_apt->query("SELECT * FROM reps2dists2sects JOIN sects ON reps2dists2sects.sect_id=sects.id WHERE reps2dists_id==".$info_dists['reps2dists.id']); |
||
56 | while ($sects->fetchInto($info_sects,DB_FETCHMODE_ASSOC)) { |
||
57 | echo " ".$info_sects['sects.sect']; |
||
58 | } |
||
59 | echo "<br>"; |
||
60 | } |
||
61 | } |
||
62 | } |
||
466 | diffor | 63 | |
64 | //$query =& $dba->query("SET NAMES utf8"); |
||
65 | |||
66 | ?> |
||
471 | diffor | 67 | |
68 | </body> |
||
69 | </html> |