X-Git-Url: http://git.pjr.cc/?p=configmanager.git;a=blobdiff_plain;f=lib%2Fdb.php;h=dd5b1e3e4dde448a88feb2cf8ad3cdcb4bc886e2;hp=58f729da9865f6058bbc4d5edc89eb45d9d693ec;hb=779ccbdea52a495b9150c12c6d69af2aa370d8f1;hpb=843363a8f4dca2460800d5c3c72b559cce15c99f

diff --git a/lib/db.php b/lib/db.php
index 58f729d..dd5b1e3 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -2,10 +2,11 @@
 
 function db_getDB()
 {
-	global $DB_URL;
+	global $DB_URL, $IS_WEB_REQUEST;
 	
 	if(!isset($IS_WEB_REQUEST)) {
 		// only the web requests are allowed to create dbs
+		echo "no web request, no db\n";
 		return false;
 	}
 	
@@ -63,17 +64,40 @@ function db_insertData($tablename)
 	}
 	$sql .=")";
 	
+	//echo "sql is $sql\n";
+	
 	$db->query($sql);
 }
 
-function db_selectData($tablename, $column="", $value="")
+function db_getMaxValue($tablename, $column, $columnsel="", $wheresel="")
 {
 	$db = db_getDB();
 	
 	if(!$db) return false;
 	
+	if($columnsel != "") {
+		$extra = " where $columnsel = '$wheresel'";
+	}
+	
+	$sql = "select max($column) from \"$tablename\"$extra";
+	$res = $db->query($sql);
+	if(!$res) return false;
+	$data = $res->fetchAll();
+	
+	return $data;
+}
+
+
+function db_selectData($tablename, $column="", $value="", $orderby = "")
+{
+	$db = db_getDB();
+	
+	if(!$db) return false;
+	
+	
 	if($column != "") $extra = " where $column like '%$value%'";
 	else $extra = "";
+	if($orderby != "") $extra .= " order by $orderby";
 	$sql = "select * from \"$tablename\"$extra";
 	$res = $db->query($sql);
 	if(!$res) return false;