From 6e866ae1b0ca29b51434cbd8d36868ed1d1b0f2f Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 16 Feb 2016 13:11:19 +0100
Subject: [PATCH] add sqlite functions

---
 lib/php/db.php | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/lib/php/db.php b/lib/php/db.php
index 1018b72e..a85cae47 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -83,6 +83,9 @@ class db extends nb {
 
     if ($this->type == 'sqlite') {
 
+      $this->conn->sqliteCreateFunction('ip2int', function ($value) { return ip2long($value); });
+      $this->conn->sqliteCreateFunction('concat', function ($v1,$v2) { return $v1.$v2; });
+
       $this->conn->sqliteCreateFunction('regexp',
         function ($pattern, $data, $delimiter = '~', $modifiers = 'isuS') {
           if (isset($pattern, $data) === true) {
-- 
2.47.3