/trunk/custom/apt/apt.php |
15,7 → 15,7 |
|
$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']); |
if ($vers->numRows()!=0) { |
echo $info_distrs['distr'].": "; |
echo "<img src='".$info_distrs['logo']."' alt='logo'>".$info_distrs['distr'].": "; |
while ($vers->fetchInto($info_vers, DB_FETCHMODE_ASSOC)) { |
echo $info_vers['codename']." "; |
} |
/trunk/custom/apt/debian.png |
Новый файл |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/custom/apt/ubuntu.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: trunk/custom/apt/ubuntu.png |
=================================================================== |
--- trunk/custom/apt/ubuntu.png (revision 0) |
+++ trunk/custom/apt/ubuntu.png (revision 169) |
/trunk/custom/apt/ubuntu.png |
Изменения свойств: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: trunk/db/nix-files.sql |
=================================================================== |
--- trunk/db/nix-files.sql (revision 168) |
+++ trunk/db/nix-files.sql (revision 169) |
@@ -3,7 +3,7 @@ |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
--- Время создания: Ноя 29 2009 г., 23:26 |
+-- Время создания: Ноя 29 2009 г., 23:37 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.10-2ubuntu6.3 |
@@ -29,6 +29,7 @@ |
CREATE TABLE IF NOT EXISTS `apt_distrs` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`distr` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
+ `logo` varchar(30) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; |
|
@@ -36,9 +37,9 @@ |
-- Дамп данных таблицы `apt_distrs` |
-- |
|
-INSERT INTO `apt_distrs` (`id`, `distr`) VALUES |
-(1, 'Debian'), |
-(2, 'Ubuntu'); |
+INSERT INTO `apt_distrs` (`id`, `distr`, `logo`) VALUES |
+(1, 'Debian', './custom/apt/debian.png'), |
+(2, 'Ubuntu', './custom/apt/ubuntu.png'); |
|
-- -------------------------------------------------------- |
|