added some git repo create validation

[gwvp-mini.git] / gwvpmini / gwvpmini_db.php

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index cf1f6d5..4408014 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -84,6 +84,30 @@ function gwvpmini_ConnectDB()
        }\r
 \r
        return $DB_CONNECTION;\r
+}
+
+function gwvpmini_AddUser($username, $password, $fullname, $email, $desc, $level, $status)
+{
+       \r
+       
+       \r
+       $conn = gwvpmini_ConnectDB();\r
+       \r
+       $sql = "insert into 'users' values ( null, '$fullname', '".sha1($password)."', '$username', '$email', '$desc', '$level', '$status')";\r
+       \r
+       $res = $conn->query($sql);
+       if(!$res) return -1;
+       
+       $sql = "select user_id from users where user_username='$username'";\r
+       $res = $conn->query($sql);\r
+       if(!$res) return -1;\r
+       
+       $retval = -1;
+       foreach($res as $row) {
+               $retval = $row[0];
+       }
+       
+       return $retval;
 }\r
 
 
@@ -98,7 +122,8 @@ function gwvpmini_dbCreateSQLiteStructure($dbloc)
        "user_email" TEXT,\r
        "user_desc" TEXT,
        "user_level" TEXT,\r
-       "user_status" TEXT\r
+       "user_status" TEXT,
+       UNIQUE(user_username)\r
        )';\r
 \r
        $initialuser_admin = '
@@ -114,7 +139,9 @@ function gwvpmini_dbCreateSQLiteStructure($dbloc)
        "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,\r
        "repos_name" TEXT,\r
        "repos_description" TEXT,\r
-       "repos_owner" INTEGER\r
+       "repos_owner" INTEGER,
+       "repos_readperms" TEXT,
+       UNIQUE(repos_name)\r
        )';\r
 \r
        // this looks like null, <repoid>, <read|visible|write>, user:<uid>|group:<gid>|authed|anon\r
@@ -234,13 +261,13 @@ function gwvpmini_setConfigVal($confname, $confval)
        return $conn->query($sql);\r
 }
 
-function gwvpmini_AddRepo($name, $desc, $ownerid)
+function gwvpmini_AddRepo($name, $desc, $ownerid, $perms = "perms-public")
 {
        
        error_log("addrepo in db for $name, $desc, $ownerid");
        $conn = gwvpmini_ConnectDB();\r
        \r
-       $sql = "insert into repos values (null, '$name', '$desc', '$ownerid')";\r
+       $sql = "insert into repos values (null, '$name', '$desc', '$ownerid', '$perms')";\r
        \r
        $conn->query($sql);\r
 }
@@ -310,7 +337,7 @@ function gwvpmini_userLevel($id)
        return $lev;
 }
 
-function gwvpmini_GetUsers()
+function gwvpmini_GetUsers($startat = 0, $num = 10)
 {
        $conn = gwvpmini_ConnectDB();
        
@@ -327,7 +354,7 @@ function gwvpmini_GetUsers()
 
         */\r
        \r
-       $sql = "select * from users";
+       $sql = "select * from users where user_id>'$startat' order by user_id asc limit $num";
        
        $res = $conn->query($sql);
        
@@ -345,5 +372,69 @@ function gwvpmini_GetUsers()
        return $retval;
 }\r
 
+function gwvpmini_GetRepos($startat=0, $num=200)\r
+{\r
+       $conn = gwvpmini_ConnectDB();\r
+       \r
+       /*\r
+        *      CREATE TABLE "repos" (
+       "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+       "repos_name" TEXT,
+       "repos_description" TEXT,
+       "repos_owner" INTEGER
+       )';
+       \r
+                       */\r
+       \r
+       $sql = "select * from repos where repos_id > '$startat' order by repos_id asc limit $num";\r
+       \r
+       $res = $conn->query($sql);\r
+       \r
+       $retval = false;\r
+       foreach($res as $row) {\r
+               $id = $row["repos_id"];\r
+               $retval[$id]["name"] = $row["repos_name"];\r
+               $retval[$id]["desc"] = $row["repos_description"];\r
+               $retval[$id]["owner"] = $row["repos_owner"];\r
+       }\r
+       \r
+       return $retval;\r
+       \r
+       \r
+}\r
+
+function gwvpmini_GetNRepos()
+{
+       $conn = gwvpmini_ConnectDB();
+
+       $sql = "select count(*) from repos";
+       
+       $res = $conn->query($sql);
+       
+       $retval = -1;
+       foreach($res as $row) {
+               $retval = $row[0];
+       }
+       
+       return $retval;
+}
+
+\r
+function gwvpmini_GetNUsers()\r
+{\r
+       $conn = gwvpmini_ConnectDB();\r
+\r
+       $sql = "select count(*) from users";\r
+\r
+       $res = $conn->query($sql);\r
+\r
+       $retval = -1;\r
+       foreach($res as $row) {\r
+               $retval = $row[0];\r
+       }\r
+\r
+       return $retval;\r
+}\r
+
 
 ?>
\ No newline at end of file