<?php
error_reporting(0);
set_time_limit(0);
ignore_user_abort(1);

//domain utama anda
$domain = 'https://www.followersindonesia.web.id';
$apilocalLike = 'http://b5658f23.ngrok.io/apiLike.php';
$apilocalLogin = 'http://b5658f23.ngrok.io/apiLogin.php';

//config
$servername = "localhost";
$username = "admin"; //username db anda
$password = "admin"; //password db anda
$dbname = "admin"; //nama db anda
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

//creat db setting
$sql = "CREATE table IF NOT EXISTS setting(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`waktuzona` TEXT NOT NULL,
`perbaikanserver` TEXT NOT NULL,
`infoperbaikanserver` TEXT NOT NULL,
`urlpushnotif` TEXT NOT NULL,
`jspushnotif` TEXT NOT NULL,
`limit_like` TEXT NOT NULL,
`judul` TEXT NOT NULL,
`notifikasi1` TEXT NOT NULL,
`notifikasi2` TEXT NOT NULL,
`notifikasi3` TEXT NOT NULL,
`tentang` TEXT NOT NULL,
`donasi` TEXT NOT NULL,
`hakcipta` TEXT NOT NULL,
`urlhakcipta` TEXT NOT NULL,
`dibuatoleh` TEXT NOT NULL,
`urldibuatoleh` TEXT NOT NULL,
`urlicon` TEXT NOT NULL,
`urllogo` TEXT NOT NULL,
`urlheader` TEXT NOT NULL);";
$conn->exec($sql);

//creat db instagram
$sql = "CREATE table IF NOT EXISTS instagram(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`idig` VARCHAR(100) NOT NULL,
`name` TEXT NOT NULL,
`username` VARCHAR(100) NOT NULL,
`password` VARCHAR(100) NOT NULL,
`picture` TEXT NOT NULL,
`limit_like` VARCHAR(100) NOT NULL,
`useragent` VARCHAR(1000) NOT NULL,
`cookie` TEXT NOT NULL,
`register` VARCHAR(100) NOT NULL,
`expired` VARCHAR(100) NOT NULL,
`vip` ENUM('VIP','NotVIP') NOT NULL,
`status` ENUM('Active','NotActive') NOT NULL,
`autolike` ENUM('On','Off') NOT NULL,
`blocklike` ENUM('Yes','No') NOT NULL,
`privacy` VARCHAR(100) NOT NULL,
`lastlogin` TEXT NOT NULL,
`ip` TEXT NOT NULL);";
$conn->exec($sql);

//media
$sql = "CREATE table IF NOT EXISTS media(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`media_id` VARCHAR(100) NOT NULL,
`limit_like` VARCHAR(100) NOT NULL,
`status` ENUM('Success','Failed','Processing') NOT NULL,
`uplink` VARCHAR(100) NOT NULL,
`date` VARCHAR(100) NOT NULL);";
$conn->exec($sql);

//queue list
$sql = "CREATE table IF NOT EXISTS queue(
`id` INT(100) AUTO_INCREMENT PRIMARY KEY,
`media_id` TEXT NOT NULL,
`uplink` TEXT NOT NULL,
`date` TEXT NOT NULL);";
$conn->exec($sql);

//log activity
$sql = "CREATE table IF NOT EXISTS log(
`id` INT(100) AUTO_INCREMENT PRIMARY KEY,
`log` TEXT NOT NULL,
`uplink` TEXT NOT NULL,
`date` TEXT NOT NULL);";
$conn->exec($sql);

//history likes
$sql = "CREATE table IF NOT EXISTS history_likes(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`total_like` TEXT NOT NULL,
`precent_like` TEXT NOT NULL,
`date` VARCHAR(100) NOT NULL);";
$conn->exec($sql);

//comment
$sql = "CREATE table IF NOT EXISTS comment(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`message` TEXT NOT NULL,
`reply_by` VARCHAR(100) NOT NULL,
`messages` TEXT NOT NULL,
`penilaian` TEXT NOT NULL,
`uplink` VARCHAR(100) NOT NULL,
`date` VARCHAR(100) NOT NULL,
`ip` TEXT NOT NULL);";
$conn->exec($sql);

//users
$sql = "CREATE table IF NOT EXISTS users(
`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
`username` VARCHAR(100) NOT NULL,
`password` VARCHAR(100) NOT NULL,
`level` ENUM('Admin','User','Member') NOT NULL,
`lastlogin` TEXT NOT NULL,
`ip` TEXT NOT NULL);";
$conn->exec($sql);

$stmtdata = $conn->prepare("SELECT * FROM setting");
if ($stmtdata->execute()) {
	while ($web = $stmtdata->fetch(PDO::FETCH_ASSOC)) {
		$waktuzona = $web['waktuzona'];
		$maintance = $web['perbaikanserver'];
		$infomaintance = $web['infoperbaikanserver'];
		$urlpushnotif = $web['urlpushnotif'];
		$jspushnotif = $web['jspushnotif'];
		$limit_like = $web['limit_like'];
		$judul = $web['judul'];
		$notifikasi1 = $web['notifikasi1'];
		$notifikasi2 = $web['notifikasi2'];
		$notifikasi3 = $web['notifikasi3'];
		$tentang = $web['tentang'];
		$donasi = $web['donasi'];
		$hakcipta = $web['hakcipta'];
		$urlhakcipta = $web['urlhakcipta'];
		$dibuatoleh = $web['dibuatoleh'];
		$urldibuatoleh = $web['urldibuatoleh'];
		$urlicon = $domain.$web['urlicon'];
		$urllogo = $domain.$web['urllogo'];
		$urlheader = $domain.$web['urlheader'];
		//$apiLike = $domain.'/api/apiLike.php';
		//$apiLogin = $domain.'/api/apiLogin.php';
		$apiLike = $apilocalLike;
		$apiLogin = $apilocalLogin;
	}
}
date_default_timezone_set($waktuzona);
?>