X-Git-Url: http://git.pjr.cc/?p=glcas.git;a=blobdiff_plain;f=lib%2Fplugins%2Fdb.php;h=f19a1fa443180676f7c505be3c65dc3591f7483a;hp=a337718499b244b6435720ae2c215469a5b4181f;hb=2df6aefe9a0933d1bd06f911894c88c719b5fbb7;hpb=bdc6417e64fc4a48c1364dc4773d68205f88b015

diff --git a/lib/plugins/db.php b/lib/plugins/db.php
index a337718..f19a1fa 100644
--- a/lib/plugins/db.php
+++ b/lib/plugins/db.php
@@ -25,17 +25,18 @@ function db_createDB()
 }
 
 // all columns end up as text
-function db_createTable($tablename, $ncolumns)
+function db_createTable($tablename)
 {
 	$db = db_getDB();
 	
 	$sql = "create table \"$tablename\" (\"".$tablename."_id\" INTEGER PRIMARY KEY AUTOINCREMENT";
-	for($i=1; $i <= $ncolumns; $i++) {
-		$colname = "column_$i";
+	for($i=1; $i < func_num_args(); $i++) {
+		$colname = func_get_arg($i);
 		$sql .= ", $colname text";
 	}
 	$sql .= ")";
 	
+	echo "sql: $sql\n";
 	$db->query($sql);
 }
 
@@ -57,7 +58,7 @@ function db_selectData($tablename, $column, $value)
 {
 	$db = db_getDB();
 	
-	$sql = "select * from \"$tablename\" where column_$column like '%$value%'";
+	$sql = "select * from \"$tablename\" where $column like '%$value%'";
 	$res = $db->query($sql);
 	$data = $res->fetchAll();
 	
@@ -73,6 +74,15 @@ function db_deleteData($tablename, $column, $value)
 	
 }
 
+function db_updateData($tablename, $column, $newdata, $wherecol, $wheredata, $exact=true)
+{
+	$db = db_getDB();
+	
+	if($exact) $sql = "update \"$tablename\" set $column='$newdata' where $wherecol='$wheredata'";
+	else $sql = "update \"$tablename\" set $column='$newdata' where $wherecol like '$wheredata'";
+	return $db->query($sql);
+}
+
 function db_deleteTable($tablename)
 {
 	$db = db_getDB();