· 6 years ago · Nov 20, 2019, 02:34 PM
1<?php
2error_reporting(0);
3set_time_limit(0);
4ignore_user_abort(1);
5
6//domain utama anda
7$domain = 'https://www.followersindonesia.web.id';
8
9//config
10$servername = "localhost";
11$username = "admin"; //username db anda
12$password = "admin"; //password db anda
13$dbname = "admin"; //nama db anda
14$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
15$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16
17//creat db setting
18$sql = "CREATE table IF NOT EXISTS setting(
19`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
20`waktuzona` TEXT NOT NULL,
21`perbaikanserver` TEXT NOT NULL,
22`infoperbaikanserver` TEXT NOT NULL,
23`urlpushnotif` TEXT NOT NULL,
24`jspushnotif` TEXT NOT NULL,
25`limit_like` TEXT NOT NULL,
26`judul` TEXT NOT NULL,
27`notifikasi1` TEXT NOT NULL,
28`notifikasi2` TEXT NOT NULL,
29`notifikasi3` TEXT NOT NULL,
30`tentang` TEXT NOT NULL,
31`donasi` TEXT NOT NULL,
32`hakcipta` TEXT NOT NULL,
33`urlhakcipta` TEXT NOT NULL,
34`dibuatoleh` TEXT NOT NULL,
35`urldibuatoleh` TEXT NOT NULL,
36`urlicon` TEXT NOT NULL,
37`urllogo` TEXT NOT NULL,
38`urlheader` TEXT NOT NULL);";
39$conn->exec($sql);
40
41//creat db instagram
42$sql = "CREATE table IF NOT EXISTS instagram(
43`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
44`idig` VARCHAR(100) NOT NULL,
45`name` TEXT NOT NULL,
46`username` VARCHAR(100) NOT NULL,
47`password` VARCHAR(100) NOT NULL,
48`picture` TEXT NOT NULL,
49`limit_like` VARCHAR(100) NOT NULL,
50`useragent` VARCHAR(1000) NOT NULL,
51`cookie` TEXT NOT NULL,
52`register` VARCHAR(100) NOT NULL,
53`expired` VARCHAR(100) NOT NULL,
54`vip` ENUM('VIP','NotVIP') NOT NULL,
55`status` ENUM('Active','NotActive') NOT NULL,
56`autolike` ENUM('On','Off') NOT NULL,
57`blocklike` ENUM('Yes','No') NOT NULL,
58`privacy` VARCHAR(100) NOT NULL,
59`lastlogin` TEXT NOT NULL,
60`ip` TEXT NOT NULL);";
61$conn->exec($sql);
62
63//media
64$sql = "CREATE table IF NOT EXISTS media(
65`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
66`media_id` VARCHAR(100) NOT NULL,
67`limit_like` VARCHAR(100) NOT NULL,
68`status` ENUM('Success','Failed','Processing') NOT NULL,
69`uplink` VARCHAR(100) NOT NULL,
70`date` VARCHAR(100) NOT NULL);";
71$conn->exec($sql);
72
73//queue list
74$sql = "CREATE table IF NOT EXISTS queue(
75`id` INT(100) AUTO_INCREMENT PRIMARY KEY,
76`media_id` TEXT NOT NULL,
77`uplink` TEXT NOT NULL,
78`date` TEXT NOT NULL);";
79$conn->exec($sql);
80
81//log activity
82$sql = "CREATE table IF NOT EXISTS log(
83`id` INT(100) AUTO_INCREMENT PRIMARY KEY,
84`log` TEXT NOT NULL,
85`uplink` TEXT NOT NULL,
86`date` TEXT NOT NULL);";
87$conn->exec($sql);
88
89//history likes
90$sql = "CREATE table IF NOT EXISTS history_likes(
91`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
92`total_like` TEXT NOT NULL,
93`precent_like` TEXT NOT NULL,
94`date` VARCHAR(100) NOT NULL);";
95$conn->exec($sql);
96
97//comment
98$sql = "CREATE table IF NOT EXISTS comment(
99`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
100`message` TEXT NOT NULL,
101`reply_by` VARCHAR(100) NOT NULL,
102`messages` TEXT NOT NULL,
103`penilaian` TEXT NOT NULL,
104`uplink` VARCHAR(100) NOT NULL,
105`date` VARCHAR(100) NOT NULL,
106`ip` TEXT NOT NULL);";
107$conn->exec($sql);
108
109//users
110$sql = "CREATE table IF NOT EXISTS users(
111`id` INT(15) AUTO_INCREMENT PRIMARY KEY,
112`username` VARCHAR(100) NOT NULL,
113`password` VARCHAR(100) NOT NULL,
114`level` ENUM('Admin','User','Member') NOT NULL,
115`lastlogin` TEXT NOT NULL,
116`ip` TEXT NOT NULL);";
117$conn->exec($sql);
118
119$stmtdata = $conn->prepare("SELECT * FROM setting");
120if ($stmtdata->execute()) {
121 while ($web = $stmtdata->fetch(PDO::FETCH_ASSOC)) {
122 $waktuzona = $web['waktuzona'];
123 $maintance = $web['perbaikanserver'];
124 $infomaintance = $web['infoperbaikanserver'];
125 $urlpushnotif = $web['urlpushnotif'];
126 $jspushnotif = $web['jspushnotif'];
127 $limit_like = $web['limit_like'];
128 $judul = $web['judul'];
129 $notifikasi1 = $web['notifikasi1'];
130 $notifikasi2 = $web['notifikasi2'];
131 $notifikasi3 = $web['notifikasi3'];
132 $tentang = $web['tentang'];
133 $donasi = $web['donasi'];
134 $hakcipta = $web['hakcipta'];
135 $urlhakcipta = $web['urlhakcipta'];
136 $dibuatoleh = $web['dibuatoleh'];
137 $urldibuatoleh = $web['urldibuatoleh'];
138 $urlicon = $domain.$web['urlicon'];
139 $urllogo = $domain.$web['urllogo'];
140 $urlheader = $domain.$web['urlheader'];
141 $apiLike = $domain.'/api/apiLike.php';
142 $apiLogin = $domain.'/api/apiLogin.php';
143 }
144}
145date_default_timezone_set($waktuzona);
146?>