Хранилища Subversion ant

Редакция

Редакция 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 
?>