pkgsubmit.php: Pull out DB code

* Move DB code in pkgsubmit.php to new functions in  aur.inc.php and
pkgfuncs.inc.php
* Centralization of DB code important in a future transition to PDO interface

Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>

1 files changed, 21 insertions, 0 deletions

diff --git a/web/lib/aur.inc.php b/web/lib/aur.inc.php
index 991fb14..1a294a9 100644
--- a/web/lib/aur.inc.php
+++ b/web/lib/aur.inc.php
@@ -512,3 +512,24 @@ function parse_comment($comment) {
 
 	return $html;
 }
+
+function begin_atomic_commit($dbh=NULL) {
+	if(!$dbh) {
+		$dbh = db_connect();
+	}
+	db_query("BEGIN", $dbh);
+}
+
+function end_atomic_commit($dbh=NULL) {
+	if(!$dbh) {
+		$dbh = db_connect();
+	}
+	db_query("COMMIT", $dbh);
+}
+
+function last_insert_id($dbh=NULL) {
+	if(!$dbh) {
+		$dbh = db_connect();
+	}
+	return mysql_insert_id($dbh);
+}