- Timestamp:
- Oct 10, 2002, 11:22:28 AM (22 years ago)
- Location:
- trunk/www
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/www/en/ports.php
r1014 r1026 30 30 <option value="desc"<? if ($by == "desc") { echo " selected=\"selected\""; } ?>>Description</option> 31 31 <option value="cat"<? if ($by == "cateogry") { echo " selected=\"selected\""; } ?>>Category</option> 32 <option value="maintainer"<? if ($by == "maintainer") { echo " selected=\"selected\""; } ?>>Maintainer</option> 32 33 </select> 33 34 </td> … … 68 69 </form> 69 70 70 <dl>71 71 <? 72 72 if ($by && ($substr || $by == "all")) { 73 $query = "SELECT DISTINCT name,path,version,description,maintainer FROM darwinports.portfiles p, darwinports.maintainers m, darwinports.categories c WHERE p.name=m.portfile AND p.name=c.portfile AND m.is_primary=1"; 73 $query = "SELECT DISTINCT name,path,version,description,maintainer FROM darwinports.portfiles p, ". 74 "darwinports.maintainers m, darwinports.categories c, darwinports.variants v, darwinports.platforms pl ". 75 "WHERE p.name=m.portfile AND p.name=v.portfile AND p.name=pl.portfile AND p.name=c.portfile AND m.is_primary=1"; 74 76 if ($by == "name") { 75 77 $query = $query . " AND p.name LIKE '%" . addslashes($substr) . "%'"; … … 81 83 $query = $query . " AND c.category='" . addslashes($substr) . "'"; 82 84 } 85 if ($by == "variant") { 86 $query = $query . " AND v.variant='" . addslashes($substr) . "'"; 87 } 88 if ($by == "platform") { 89 $query = $query . " AND pl.platform ='" . addslashes($substr) . "'"; 90 } 91 if ($by == "maintainer") { 92 $query = $query . " AND m.maintainer LIKE '%" . addslashes($substr) . "%'"; 93 } 83 94 $query = $query . " ORDER BY name"; 84 95 $result = mysql_query($query); 85 96 if($result) { 97 ?> 98 <p> 99 <i><?= mysql_num_rows($result); ?> Portfile<? if (mysql_num_rows($result) != 1) { echo "s"; } ?> Selected</i> 100 </p> 101 <dl> 102 <? 86 103 while( $row = mysql_fetch_assoc($result) ) { 87 104 ?> … … 90 107 <?= $row['description']; ?><br /> 91 108 <i>Maintained by:</i> <a href="mailto:<?= $row['maintainer']; ?>"><?= $row['maintainer']; ?></a><br /> 92 <i>Categories:</i>93 109 <? 110 // CATEGORIES 94 111 $nquery = "SELECT category FROM darwinports.categories WHERE portfile='" . $row['name'] . "' ORDER BY is_primary DESC, category"; 95 112 $nresult = mysql_query($nquery); 96 113 if ($nresult) { 114 ?> 115 <i>Categories:</i> 116 <? 97 117 $primary = 1; 98 118 while ( $nrow = mysql_fetch_assoc($nresult) ) { … … 105 125 } 106 126 } 127 128 // PLATFORMS 129 $nquery = "SELECT platform FROM darwinports.platforms WHERE portfile='" . $row['name'] . "' ORDER BY platform"; 130 $nresult = mysql_query($nquery); 131 if ($nresult && mysql_num_rows($nresult) > 0) { 132 ?> 133 <br /> 134 <i>Platforms:</i> 135 <? 136 while ( $nrow = mysql_fetch_array($nresult) ) { 137 $platform = $nrow[0]; 138 ?> 139 <a href="<?= $PHP_SELF; ?>?by=platform&substr=<?= $platform; ?>"><?= $platform; ?></a> 140 <? 141 } 142 } 143 144 // DEPENDENCIES 145 $nquery = "SELECT library FROM darwinports.dependencies WHERE portfile='" . $row['name'] . "' ORDER BY library"; 146 $nresult = mysql_query($nquery); 147 if ($nresult && mysql_num_rows($nresult) > 0) { 148 ?> 149 <br /> 150 <i>Dependencies:</i> 151 <? 152 while ( $nrow = mysql_fetch_array($nresult) ) { 153 // lib:libpng.3:libpng -> libpng 154 $library = eregi_replace("^[^:]*:[^:]*:", "", $nrow[0]); 155 ?> 156 <a href="<?= $PHP_SELF; ?>?by=name&substr=<?= $library; ?>"><?= $library; ?></a> 157 <? 158 } 159 } 160 /* 161 // VARIANTS 162 $nquery = "SELECT variant FROM darwinports.variants WHERE portfile='" . $row['name'] . "' ORDER BY variant"; 163 $nresult = mysql_query($nquery); 164 if ($nresult && mysql_num_rows($nresult) > 0) { 165 ?> 166 <br /> 167 <i>Variants:</i> 168 <? 169 while ( $nrow = mysql_fetch_array($nresult) ) { 170 $variant = $nrow[0]; 171 ?> 172 <a href="<?= $PHP_SELF; ?>?by=variant&substr=<?= $variant; ?>"><?= $variant; ?></a> 173 <? 174 } 175 } 176 */ 107 177 ?> 108 178 <br /> -
trunk/www/ports.php
r1014 r1026 30 30 <option value="desc"<? if ($by == "desc") { echo " selected=\"selected\""; } ?>>Description</option> 31 31 <option value="cat"<? if ($by == "cateogry") { echo " selected=\"selected\""; } ?>>Category</option> 32 <option value="maintainer"<? if ($by == "maintainer") { echo " selected=\"selected\""; } ?>>Maintainer</option> 32 33 </select> 33 34 </td> … … 68 69 </form> 69 70 70 <dl>71 71 <? 72 72 if ($by && ($substr || $by == "all")) { 73 $query = "SELECT DISTINCT name,path,version,description,maintainer FROM darwinports.portfiles p, darwinports.maintainers m, darwinports.categories c WHERE p.name=m.portfile AND p.name=c.portfile AND m.is_primary=1"; 73 $query = "SELECT DISTINCT name,path,version,description,maintainer FROM darwinports.portfiles p, ". 74 "darwinports.maintainers m, darwinports.categories c, darwinports.variants v, darwinports.platforms pl ". 75 "WHERE p.name=m.portfile AND p.name=v.portfile AND p.name=pl.portfile AND p.name=c.portfile AND m.is_primary=1"; 74 76 if ($by == "name") { 75 77 $query = $query . " AND p.name LIKE '%" . addslashes($substr) . "%'"; … … 81 83 $query = $query . " AND c.category='" . addslashes($substr) . "'"; 82 84 } 85 if ($by == "variant") { 86 $query = $query . " AND v.variant='" . addslashes($substr) . "'"; 87 } 88 if ($by == "platform") { 89 $query = $query . " AND pl.platform ='" . addslashes($substr) . "'"; 90 } 91 if ($by == "maintainer") { 92 $query = $query . " AND m.maintainer LIKE '%" . addslashes($substr) . "%'"; 93 } 83 94 $query = $query . " ORDER BY name"; 84 95 $result = mysql_query($query); 85 96 if($result) { 97 ?> 98 <p> 99 <i><?= mysql_num_rows($result); ?> Portfile<? if (mysql_num_rows($result) != 1) { echo "s"; } ?> Selected</i> 100 </p> 101 <dl> 102 <? 86 103 while( $row = mysql_fetch_assoc($result) ) { 87 104 ?> … … 90 107 <?= $row['description']; ?><br /> 91 108 <i>Maintained by:</i> <a href="mailto:<?= $row['maintainer']; ?>"><?= $row['maintainer']; ?></a><br /> 92 <i>Categories:</i>93 109 <? 110 // CATEGORIES 94 111 $nquery = "SELECT category FROM darwinports.categories WHERE portfile='" . $row['name'] . "' ORDER BY is_primary DESC, category"; 95 112 $nresult = mysql_query($nquery); 96 113 if ($nresult) { 114 ?> 115 <i>Categories:</i> 116 <? 97 117 $primary = 1; 98 118 while ( $nrow = mysql_fetch_assoc($nresult) ) { … … 105 125 } 106 126 } 127 128 // PLATFORMS 129 $nquery = "SELECT platform FROM darwinports.platforms WHERE portfile='" . $row['name'] . "' ORDER BY platform"; 130 $nresult = mysql_query($nquery); 131 if ($nresult && mysql_num_rows($nresult) > 0) { 132 ?> 133 <br /> 134 <i>Platforms:</i> 135 <? 136 while ( $nrow = mysql_fetch_array($nresult) ) { 137 $platform = $nrow[0]; 138 ?> 139 <a href="<?= $PHP_SELF; ?>?by=platform&substr=<?= $platform; ?>"><?= $platform; ?></a> 140 <? 141 } 142 } 143 144 // DEPENDENCIES 145 $nquery = "SELECT library FROM darwinports.dependencies WHERE portfile='" . $row['name'] . "' ORDER BY library"; 146 $nresult = mysql_query($nquery); 147 if ($nresult && mysql_num_rows($nresult) > 0) { 148 ?> 149 <br /> 150 <i>Dependencies:</i> 151 <? 152 while ( $nrow = mysql_fetch_array($nresult) ) { 153 // lib:libpng.3:libpng -> libpng 154 $library = eregi_replace("^[^:]*:[^:]*:", "", $nrow[0]); 155 ?> 156 <a href="<?= $PHP_SELF; ?>?by=name&substr=<?= $library; ?>"><?= $library; ?></a> 157 <? 158 } 159 } 160 /* 161 // VARIANTS 162 $nquery = "SELECT variant FROM darwinports.variants WHERE portfile='" . $row['name'] . "' ORDER BY variant"; 163 $nresult = mysql_query($nquery); 164 if ($nresult && mysql_num_rows($nresult) > 0) { 165 ?> 166 <br /> 167 <i>Variants:</i> 168 <? 169 while ( $nrow = mysql_fetch_array($nresult) ) { 170 $variant = $nrow[0]; 171 ?> 172 <a href="<?= $PHP_SELF; ?>?by=variant&substr=<?= $variant; ?>"><?= $variant; ?></a> 173 <? 174 } 175 } 176 */ 107 177 ?> 108 178 <br />
Note: See TracChangeset
for help on using the changeset viewer.