summaryrefslogtreecommitdiff
path: root/web/lib/aurjson.class.php
diff options
context:
space:
mode:
authoreliott <eliott@cactuswax.net>2007-11-22 19:28:11 -0800
committerDan McGee <dan@archlinux.org>2008-01-20 00:21:19 -0600
commit32b863203fcda13f322aa0802bc64eec64dcaa51 (patch)
tree89cee28878ce78da8abe7e88389bf923ee14993b /web/lib/aurjson.class.php
parent47e80c24afa539d23f9060ee876303e24a1b1c89 (diff)
Modified to get details based on an exact package name, or based on a package id.
Diffstat (limited to 'web/lib/aurjson.class.php')
-rw-r--r--web/lib/aurjson.class.php27
1 files changed, 19 insertions, 8 deletions
diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index b8dff39..e6e40ff 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -101,16 +101,27 @@ class AurJSON {
}
/**
- * Returns the info on a specific package id.
- * @param $package_id The ID of the package to fetch info.
+ * Returns the info on a specific package.
+ * @param $pqdata The ID or name of the package. Package Query Data.
* @return mixed Returns an array of value data containing the package data
**/
- private function info($package_id) {
- // using sprintf to coerce the package_id to an int
- // should handle sql injection issues, since sprintf will
- // bork if not an int, or convert the string to a number
- $query = sprintf("SELECT ID,Name,Version,Description,URL,URLPath,License,NumVotes,OutOfDate FROM Packages WHERE ID=%d",$package_id);
- $result = db_query($query, $this->dbh);
+ private function info($pqdata) {
+ $base_query = "SELECT ID,Name,Version,Description,URL,URLPath,License,NumVotes,OutOfDate FROM Packages WHERE ";
+
+ if is_numeric($pqdata) {
+ // just using sprintf to coerce the pqd to an int
+ // should handle sql injection issues, since sprintf will
+ // bork if not an int, or convert the string to a number 0
+ $query_stub = sprintf("ID=%d",$pqdata);
+ }
+ else {
+ if(get_magic_quotes_gpc()) {
+ $pqd = stripslashes($pqdata);
+ }
+ $query_stub = sprintf("Name=%s",mysql_real_escape_string($pqdata));
+ }
+
+ $result = db_query($query.$base_query, $this->dbh);
if ( $result && (mysql_num_rows($result) > 0) ) {
$row = mysql_fetch_assoc($result);