Initial import

4 files changed, 126 insertions, 0 deletions

diff --git a/.SRCINFO b/.SRCINFO
new file mode 100644
index 000000000000..716a035d1d6b
--- /dev/null
+++ b/.SRCINFO
@@ -0,0 +1,25 @@
+# Generated by mksrcinfo v8
+# Mon Nov  6 03:13:58 UTC 2017
+pkgbase = esniper-web
+	pkgdesc = Web UI of esniper for sniping eBay auctions.
+	pkgver = r24.a0c7707
+	pkgrel = 1
+	url = https://github.com/yhfudev/esniper-web.git
+	install = esniperweb.install
+	arch = any
+	license = BSD
+	depends = php
+	depends = php-fpm
+	depends = php-gd
+	optdepends = nginx: Web server for serving Wordpress
+	optdepends = apache: Web server for serving Wordpress
+	optdepends = mariadb: Database server
+	source = esniper-web::git+https://github.com/yhfudev/esniper-web.git
+	source = esniperweb.install
+	source = setdb.sh
+	sha256sums = SKIP
+	sha256sums = 18acf73a198a52223c4069e7e06c897ccf9142420d9189e7a5b9f026c5b584f2
+	sha256sums = 1129077445c9b823ce2428c43c9d39b56553cea5e423cffc59b47726e401bfcb
+
+pkgname = esniper-web
+
diff --git a/PKGBUILD b/PKGBUILD
new file mode 100644
index 000000000000..cb40c46044fb
--- /dev/null
+++ b/PKGBUILD
@@ -0,0 +1,54 @@
+# Maintainer: Yunhui Fu <yhfudev@gmail.com>
+
+pkgname=esniper-web
+pkgver=r24.a0c7707
+pkgrel=1
+pkgdesc="Web UI of esniper for sniping eBay auctions."
+arch=('any')
+url="https://github.com/yhfudev/esniper-web.git"
+license=('BSD')
+depends=('curl' 'openssl')
+source=(
+    "${pkgname}::git+https://github.com/yhfudev/esniper-web.git"
+    "esniperweb.install"
+    "setdb.sh"
+  )
+sha256sums=('SKIP'
+            '18acf73a198a52223c4069e7e06c897ccf9142420d9189e7a5b9f026c5b584f2'
+            '1129077445c9b823ce2428c43c9d39b56553cea5e423cffc59b47726e401bfcb'
+    )
+
+install=esniperweb.install
+
+depends=('php' 'php-fpm' 'php-gd')
+optdepends=('nginx: Web server for serving Wordpress'
+          'apache: Web server for serving Wordpress'
+          'mariadb: Database server')
+
+pkgver_git() {
+    cd "${srcdir}/${pkgname}"
+    #local ver="$(git show | grep commit | awk '{print $2}' )"
+    #printf "r%s" "${ver//[[:alpha:]]}"
+    #echo ${ver:0:7}
+    echo "r$(git rev-list --count HEAD).$(git rev-parse --short HEAD)"
+}
+
+pkgver() {
+    pkgver_git
+}
+
+package()
+{
+  #cd "${srcdir}/${pkgname}"
+
+  install -d "$pkgdir/usr/share"
+  install -d "$pkgdir/usr/share/webapps"
+
+  cp -r "${srcdir}/${pkgname}" "$pkgdir/usr/share/webapps/esniper"
+  rm -rf "$pkgdir/usr/share/webapps/esniper/.git/"
+  cp setdb.sh "$pkgdir/usr/share/webapps/esniper/install/"
+  chown http:http -R "$pkgdir/usr/share/webapps/esniper"
+}
+
+# vim: ts=2 sw=2 et:
+
diff --git a/esniperweb.install b/esniperweb.install
new file mode 100644
index 000000000000..74f2e7d3c20e
--- /dev/null
+++ b/esniperweb.install
@@ -0,0 +1,7 @@
+post_install() {
+  ln -s /usr/share/webapps/esniper /srv/http/
+}
+
+post_remove() {
+  rm -f /srv/http/esniper
+}
diff --git a/setdb.sh b/setdb.sh
new file mode 100755
index 000000000000..69eaaa38b6b1
--- /dev/null
+++ b/setdb.sh
@@ -0,0 +1,40 @@
+
+setup() {
+  #ln -s /usr/share/webapps/esniper /srv/http/
+
+  # enable extension=pdo_mysql.so in file /etc/php/php.ini
+  # systemctl restart php-fpm
+
+  DBNAME=root
+  DBUSER=root
+  DBPASS=root
+
+  printf "Input Database(MySQL) Username:"
+  read tmp
+  if test -n "$tmp"; then
+    DBUSER="$tmp"
+  fi
+  printf "Input Database(MySQL) Password:"
+  read tmp
+  if test -n "$tmp"; then
+    DBPASS="$tmp"
+  fi
+  DBNAME="${DBUSER}"
+
+  sed -i "s/\"EZSQL_DB_NAME\", \"snyp\"/\"EZSQL_DB_NAME\", \"$DBNAME\"/g" /usr/share/webapps/esniper/config.inc.php
+  sed -i "s/\"EZSQL_DB_USER\", \"snyp\"/\"EZSQL_DB_USER\", \"$DBUSER\"/g" /usr/share/webapps/esniper/config.inc.php
+  sed -i "s/\"EZSQL_DB_PASSWORD\", \"snyp\"/\"EZSQL_DB_PASSWORD\", \"$DBPASS\"/g" /usr/share/webapps/esniper/config.inc.php
+
+  chmod 700 /usr/share/webapps/esniper/config.inc.php
+  chown http:http /usr/share/webapps/esniper/config.inc.php
+
+
+  cp /usr/share/webapps/esniper/install/esniper.sql /tmp/tmp-esniper-db.sql
+  sed -e "s|# phpMyAdmin SQL Dump|CREATE DATABASE IF NOT EXISTS ${DBNAME};\nuse ${DBNAME};\n|g" \
+      -i /tmp/tmp-esniper-db.sql
+
+  mysql -h localhost -u$DBUSER -p$DBPASS < /tmp/tmp-esniper-db.sql
+}
+
+setup
+