API tools faq
paste
Advertisement
sagnik

SGS Tables

sagnik
Dec 23rd, 2014
301
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP Brief 13.64 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. require "/home/sgs/public_html/global/header.php";
  3. require $cnf."connection.php";
  4. require "profile.php";
  5. $title = "Installer :: Sagnik Ganguly Services Co. Ltd.";
  6. $err = array();
  7. $ok = array();
  8. ?>
  9.  
  10. <h1>Sagnik Ganguly Services Co. Ltd. Installer</h1>
  11.  
  12. <?php
  13. if (!empty($_GET['msg'])) {
  14. echo "<div class=\"success\">";
  15. echo $_GET['msg'];
  16. }
  17. ?>
  18.  
  19. <?php
  20. if (!empty($err)) {
  21. echo "<div class=\"error\">";
  22. echo "<b>The following errors has occured during the installation:</b>";
  23. foreach($err as $e) {
  24. echo "<li>";
  25. echo $e;
  26. echo "</li>";
  27. echo "</div>";
  28. }
  29. }
  30.  
  31. if (!empty($ok)) {
  32. echo "<div class=\"success\">";
  33. foreach($ok as $okMsg) {
  34. echo "<li>";
  35. echo $okMsg;
  36. echo "</li>";
  37. echo "</div>";
  38. }
  39. }
  40. ?>
  41.  
  42. <?php
  43. if ($_GET['msg'] != 'DataBase has been created successfully') {
  44. $config_db = "CREATE DATABASE IF NOT EXISTS `sgs_config`";
  45. mysql_select_db("sgs_config", $connect);
  46. }
  47. if (!mysql_select_db("sgs_config", $connect)) { $err[] = "Unable to select DataBase"; } else { $ok[] = "DataBase Selected Successfully"; }
  48.  
  49. $reg_config_table = "CREATE TABLE `sgs_config`.`reg_config`(`version` VARCHAR NOT NULL, `reg_validation_level` INT(1) NOT NULL, `reg_level` INT(1) NOT NULL, `reg_type` INT(1) NOT NULL, `reg_form_method` VARCHAR(4) NOT NULL, `captcha` INT(2) NOT NULL, `recaptcha_privkey` VARCHAR NOT NULL, `recaptcha_pubkey` VARCHAR NOT NULL, `username_availability_checker` INT(1) NOT NULL, `username_suggestions` INT(1) NOT NULL)
  50. ENGINE = MyISAM LIMIT=1";
  51.  
  52. $reg_config_entry = "INSERT INTO `reg_config`(`version`, `reg_validation_level`, `reg_level`, `reg_type`, `reg_form_method`, `captcha`, `recaptcha_privkey`, `recaptcha_pubkey`, `username_availability_checker`, `username_suggestions`) VALUES(5.32.64, 5, 1, 1, 'post', 4, '', '', 1, 1)";
  53.  
  54.  
  55. $ranks_table = "CREATE TABLE IF NOT EXISTS `ranks`(`id` INT(1) NOT NULL AUTO_INCREMENT, `page_id` INT(100) NOT NULL, `uid` INT(16) NOT NULL, `name` VARCHAR(30) NOT NULL, `title` VARCHAR(60) NOT NULL)
  56. ENGINE = MyISAM PRIMARY KEY(id) AUTO_INCREMENT = 14";
  57.  
  58. $ranks_entry = "INSERT INTO `ranks`(`id`, `name`, `title`) VALUES(1, 'Rank - 0' 'Registered User'), (2, 'Rank - I', 'New Member'), (3, 'Rank - II', 'Usual User'), (4, 'Rank - III', 'Regular Member'), (5, 'Rank - IV', 'Blog Moderator'), (6, 'Rank - V', 'Forum Moderator'), (7, 'Rank - VI', 'Chat Moderator'), (8, 'Rank - VII', 'Uploader'), (7, 'Rank - VIII', 'Gallery Moderator'), (8, 'Rank - IX', 'Users Moderator'), (9, 'Rank - X', 'Site Moderator'), (10, 'Rank - XI', 'Support Administrator'), (11, 'Rank - XII', 'Local Administrator'), (12, 'Rank - XIII', 'Global Administrator'), (13, 'Rank - XIV', 'Content Designer'), (14, 'Rank - XV', 'Content Publisher')";
  59.  
  60.  
  61. $permission_table = "CREATE TABLE IF NOT EXISTS `permissions`(`id` INT(2) NOT NULL, `rank_id` VARCHAR(2) NOT NULL, `name` INT(100) NOT NULL, `title` VARCHAR(500) NOT NULL)
  62. ENGINE = MyISAM PRIMARY KEY(id') AUTO_INCREMENT = 5";
  63.  
  64. $permission_entry = "INSERT INTO `permissions`(`id`, `rank_id`, `name`, `title`) VALUE(1, '', 'guests', 'Only Non-Logged Users'), (2, 2, 'logged', 'Only Logged Users'), (3, '', 'logged-non', 'Logged and Non-Logged Users'), (4, 2, 'moderators', 'Only Moderators'), (5, 2, 'admin', 'Only Admins')";
  65.  
  66. $visibility_table = "CREATE TABLE IF NOT EXISTS `content_visivility`(`id` VARCHAR(3) AUTO_INCREMENT NOT NULL, `page_id` VARCHAR(100) NOT NULL, `min-credit` VARCHAR(12) NOT NULL COMMENT 'Visible if user credit is minimum', `max-credit` VARCHAR(12) NOT NULL COMMENT 'Visible if user credit is maximum', `min-rank` VARCHAR(2) NOT NULL COMMENT 'Visible if user minimum rank is', `max-rank` VARCHAR(2) NOT NULL COMMENT 'Visible if user maximum rank is', `time-beg` VARCHAR(10) NOT NULL, `time-end` VARCHAR(10) NOT NULL, `date-beg` VARCHAR(13) NOT NULL, `date-end` VARCHAR(13) NOT NULL, `ip` VARCHAR(15) NOT NULL, `device` VARCHAR(100) NOT NULL COMMENT 'Device', `country` VARCHAR(50) NOT NULL COMMENT 'Visible for Following Country', `get-var` VARCHAR(25) NOT NULL COMMENT 'Visible If URL Get Variable is', `get-var-statement` VARCHAR(3) NOT NULL COMMENT 'Matches this condition', `post-var` VARCHAR(50) NOT NULL COMMENT 'Visible If Post Variable is', `post-var-statement` VARCHAR(3) NOT NULL COMMENT 'Matches this condition')
  67. ENGINE = MyISAM PRIMARY KEY(id) AUTO_INCREMENT = 3";
  68.  
  69. $visibility_entry = "INSERT INTO `content_visibility`(`id`, `page_id`, `min-rank`, `min-credit`) VALUES(1, 1, 1, 0), (2, 2, 2, 500), (3, 3, 1, 0)";
  70.  
  71.  
  72. $credits_table = "CREATE TABLE IF NOT EXISTS `bank`(`balance` INT(20) NOT NULL, `holder` VARCHAR(96) NOT NULL, `holder_uid` INT(16) NOT NULL, `holder_username` VARCHAR(48), `last_sender` VARCHAR(96) NOT NULL, `last_sender_uid` INT(16) NOT NULL, `last_sender_username` VARCHAR(48), `last_reciever` VARCHAR(96) NOT NULL, `last_reciever_uid` INT(16) NOT NULL, `last_reciever_username` VARCHAR(48), `holder_ac_number` INT(12) NOT NULL AUTO_INCREMENT)
  73. ENGINE = MyISAM PRIMARY KEY(holder_ac_number) AUTO_INCREMENT = 200011120000";
  74.  
  75. $credits_entry = "INSERT INTO `bank`(`balance`, `holder`, `holder_uid`, `ac_number`) VALUES(500000, 'System Administrator', 1000000023331001, 200011120001)";
  76.  
  77.  
  78. $pages = "CREATE TABLE IF NOT EXISTS `pages`(`id` INT(10) AUTO_INCREMENT NOT NULL, `page` VARCHAR(1000) NOT NULL `permission_id` INT(2) NOT NULL, `visibility_id` VARCHAR(1) NOT NULL, `min-rank` INT(2) NOT NULL, `max-rank` INT(2) NOT NULL, `min-credit` INT(12) NOT NULL, `max-credit` INT(12) NOT NULL)
  79. ENGINE = MyISAM PRIMARY KEY(id) AUTO_INCREMENT = 8";
  80.  
  81. $pages_entry = "INSERT INTO `pages`(`id`, `page`, `permission_id`, `min-rank`, `max-rank`, `min-credit`, `max-credit`) VALUES(1, 'index.php', 3, '', '', '0', ''), (2, '/gallery/index.php', '2', '2', '', '500', ''), (2, '/downloads/index.php', '1', '', '', '0', ''), (3, '/members/index.php', '1', '', '', '0', ''), (4, '/about/index.php', '3', '', '', '0', ''), (5, '/contact/index.php', '3', '', '', '0', ''), (6, '/members/upanel/index.php', '2', '2', '', '0', ''), (6, '/members/mpanel/index.php', '2', '2', '9', '0', ''), (7, '/members/apanel/index.php', '2', '12', '', '0', ''), (8, '/members/cpanel/index.php', '2', '15', '15', '50', '')";
  82.  
  83.  
  84. $gallery_table = "CREATE TABLE IF NOT EXISTS `gallery`(`id` INT NOT NULL AUTO_INCREMENT, `file` BLOB NOT NULL, `name` VARCHAR(64) NOT NULL, `size` VARCHAR(6) NOT NULL, `type` VARCHAR(20) NOT NULL, `author` VARCHAR(48) NOT NULL, `uploader` VARCHAR(96) NOT NULL, `uploader_uname` VARCHAR(150) NOT NULL, `uploader_uid` INT(16) NOT NULL, `upl_time` VARCHAR(10) NOT NULL, `upl_date` VARCHAR(10) NOT NULL, `upl_ip` DECIMAL(13) NOT NULL, `upl_browser` VARCHAR(50) NOT NULL, `upl_device` VARCHAR(50) NOT NULL, `upl_country` VARCHAR(50) NOT NULL, `last_dloader` VARCHAR(96) NOT NULL, `last_dloader_uname` VARCHAR(150) NOT NULL, `last_dloader_uid` INT(16) NOT NULL, `last_dl_time` VARCHAR(10) NOT NULL, `last_dl_date` VARCHAR(10) NOT NULL, `last_dl_ip` DECIMAL(13) NOT NULL, `last_dl_browser` VARCHAR(50) NOT NULL, `last_dl_device` VARCHAR(50) NOT NULL, `last_dl_country` VARCHAR(50) NOT NULL)
  85. ENGINE = InnoDB PRIMARY KEY(id) UNIQUE KEY(file, name) KEY(uploader_uid, last_dloader_uid) REFERENCES(profile)";
  86.  
  87.  
  88. $admin_levels_table = "CREATE TABLE IF NOT EXISTS `admin_levels`(`id` INT(1) NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `title` VARCHAR(100) NOT NULL, PRIMARY KEY(id), AUTO_INCREMENT = 4)
  89. ENGINE = InnoDB";
  90.  
  91. $admin_levels_entry = "INSERT INTO `admin_levels`(`id`, `name`, `title`) VALUES(1, 'registered_admin', 'Registered Administrator'), (2, 'authorised-admin', 'Regular Administrator'), (3, 'webmaster', 'Website Administrator'), (4, 'system-admin', 'System Administrator'), (5, 'root-admin', 'Root Administrator')";
  92.  
  93.  
  94. $admin_table = "CREATE TABLE IF NOT EXISTS `admin_tools`(`id` INT(12) NOT NULL AUTO_INCREMENT, `uname` VARCHAR(48) NOT NULL, `password` VARCHAR(8,62) NOT NULL, `name` VARCHAR(96) NOT NULL, `level` INT(2) NOT NULL, `permissions` INT(3) NOT NULL, `management_type` VARCHAR(150) NOT NULL, `mangement_name` VARCHAR(150) NOT NULL, `management_url` VARCHAR(100) NOT NULL, PRYMARY KEY(id), KEY(level), REFERENCES admin_levels.id, AUTO_INCREMENT = 1)
  95. ENGINE = InnoDB";
  96.  
  97. $admin_entry = "INSERT INTO `admin_tools`(`id`, `uname`, `password`, `name`, `level`) VALUES(1, 'admin', 'wtgeedrt', 'Sagnik Ganguly', 4)";
  98.  
  99.  
  100. $apanel_table = "CREATE TABLE IF NOT EXISTS `apanel`(`id` INT(12) NOT NULL AUTO_INCREMENT, `aid_fk` INT(16) NOT NULL, `rank_id` INT(2) NOT NULL, `permit_id` INT(2) NOT NULL, `bank_id` INT(12) NOT NULL, PRYMARY KEY(id) KEY aid(aid_fk), REFERENCES(profile.id))
  101. ENGINE = InnoDB, AUTO_INCREMENT = 1";
  102.  
  103. $apanel_entry = "INSERT INTO `apanel`(`id`, `aid_fk`, `rank_id`, `permit_id`, `bank_id`) VALUES(1, 32100, 13, 2, 2000)";
  104. ?>
  105. <?php
  106. $q = mysql_query($config_db, $connect);
  107. $q1 = mysql_query($reg_config_table, $connect);
  108. $q1_2 = mysql_query($reg_config_entry, $connect);
  109. $q2 = mysql_query($ranks_table, $connect);
  110. $q2_2 = mysql_query($ranks_entry, $connect);
  111. $q3 = mysql_query($permissions_table, $connect);
  112. $q3_2 = mysql_query($permissions_entry, $connect);
  113. $q4 = mysql_query($visibility_table, $connect);
  114. $q4_2 = mysql_query($visibility_entry, $connect);
  115. $q5 = mysql_query($credits_table, $connect);
  116. $q5_2 = mysql_query($credits_entry, $connect);
  117. $q6 = mysql_query($pages_table, $connect);
  118. $q6_2 = mysql_query($pages_entry, $connect);
  119. $q7 = mysql_query($profiles_table, $connect);
  120. $q7_2 = mysql_query($profiles_entry, $connect);
  121. $q8 = mysql_query($gallery_table, $connect);
  122. $q9 = mysql_query($admin_levels_table, $connect);
  123. $q9_2 = mysql_query($admin_levels_entry, $connect);
  124. $q10 = mysql_query($admin_table, $connect);
  125. $q10_2 = mysql_query($admin_entry, $connect);
  126. ?>
  127. <?php
  128. if (!$q)
  129. {
  130. $ok[] = "";
  131. $err[] = "Unable to create Database:" . mysql_error($connect);
  132. } else {
  133. $err[] = "";
  134. $ok[] = "Database was created successfully.";
  135. }
  136.  
  137. if (!$q1)
  138. {
  139. $ok[] = "";
  140. $err[] = "Unable to create signup configuration table:" . mysql_error($connect);
  141. } else {
  142. $err[] = "";
  143. $ok[] = "Signup configuration table was created successfully.";
  144. }
  145.  
  146. if (!$q1_2)
  147. {
  148. $ok[] = "";
  149. $err[] = "Unable to create Signup Configuration Data:" . mysql_error($connect);
  150. } else {
  151. $err[] = "";
  152. $ok[] = "Signup Configuration Data has created successfully.";
  153. }
  154.  
  155. if (!$q2)
  156. {
  157. $ok[] = "";
  158. $err[] = "Unable to create  table:" . mysql_error($connect);
  159. } else {
  160. $err[] = "";
  161. $ok[] = "Ranks table was created successfully.";
  162. }
  163. if (!$q2_2)
  164. {
  165. $ok[] = "";
  166. $err[] = "Unable to create Ranks Data:" . mysql_error($connect);
  167. } else {
  168. $err[] = "";
  169. $ok[] = "Ranks Data has created successfully.";
  170. }
  171.  
  172. if (!$q3)
  173. {
  174. $ok[] = "";
  175. $err[] = "Unable to create permissions table:" . mysql_error($connect);
  176. } else {
  177. $err[] = "";
  178. $ok[] = "Permissions table was created successfully.";
  179. }
  180. if (!$q3_2)
  181. {
  182. $ok[] = "";
  183. $err[] = "Unable to create Permissions Data:" . mysql_error($connect);
  184. } else {
  185. $err[] = "";
  186. $ok[] = "Permissions Data has created successfully.";
  187. }
  188.  
  189. if (!$q4)
  190. {
  191. $ok[] = "";
  192. $err[] = "Unable to create Content Visibility table:" . mysql_error($connect);
  193. } else {
  194. $err[] = "";
  195. $ok[] = "Content Visibility table was created successfully.";
  196. }
  197. if (!$q4_2)
  198. {
  199. $ok[] = "";
  200. $err[] = "Unable to create Main Visibility Data:" . mysql_error($connect);
  201. } else {
  202. $err[] = "";
  203. $ok[] = "Main Visibility Data has created successfully.";
  204. }
  205.  
  206. if (!$q5)
  207. {
  208. $ok[] = "";
  209. $err[] = "Unable to create Banks table:" . mysql_error($connect);
  210. } else {
  211. $err[] = "";
  212. $ok[] = "Banks table was created successfully.";
  213. }
  214. if (!$q5_2)
  215. {
  216. $ok[] = "";
  217. $err[] = "Unable to create Admin Credits Data:" . mysql_error($connect);
  218. } else {
  219. $err[] = "";
  220. $ok[] = "Admin Credits Data has created successfully.";
  221. }
  222.  
  223. if (!$q6)
  224. {
  225. $ok[] = "";
  226. $err[] = "Unable to create Pages table:" . mysql_error($connect);
  227. } else {
  228. $err[] = "";
  229. $ok[] = "Pages table was created successfully.";
  230. }
  231. if (!$q6_2)
  232. {
  233. $ok[] = "";
  234. $err[] = "Unable to create Pages Data:" . mysql_error($connect);
  235. } else {
  236. $err[] = "";
  237. $ok[] = "Pages Data has created successfully.";
  238. }
  239.  
  240. if (!$q7)
  241. {
  242. $ok[] = "";
  243. $err[] = "Unable to create Profiles table:" . mysql_error($connect);
  244. } else {
  245. $err[] = "";
  246. $ok[] = "Profiles table was created successfully.";
  247. }
  248. if (!$q7_2)
  249. {
  250. $ok[] = "";
  251. $err[] = "Unable to create Admin Account:" . mysql_error($connect);
  252. } else {
  253. $err[] = "";
  254. $ok[] = "Admin Account has been created successfully.";
  255.  
  256. $sql1 = "SELECT * FROM `profile` WHERE id='1'";
  257. $sqlq = mysql_query($sql1, $connect);
  258. $row=mysql_fetch_rows($sqlq);
  259.  
  260. $ok[] .= "Now you can now login in the Members Panel to test the mPanel with the credentials bellow.";
  261. $ok[] .= "<br>";
  262. $ok[] .= "<b>UID:</b> " . $row['uid'];
  263. $ok[] .= "<br>";
  264. $ok[] .= "<b>Username:</b> " . $row['user'];
  265. $ok[] .= "<br>";
  266. $ok[] .= "<b>Password:</b> " . $row['pass'];
  267. }
  268.  
  269. if (!$q8)
  270. {
  271. $ok[] = "";
  272. $err[] = "Unable to create Gallery table:" . mysql_error($connect);
  273. } else {
  274. $err[] = "";
  275. $ok[] = "Gallery table was created successfully.";
  276. mysql_close($connect);
  277. }
  278.  
  279. if (!$q9)
  280. {
  281. $ok[] = "";
  282. $err[] = "Unable to create admin levels table:" . mysql_error($connect);
  283. } else {
  284. $err[] = "";
  285. $ok[] = "Admin levels table was created successfully.";
  286. mysql_close($connect);
  287. }
  288.  
  289. if (!$q9_2)
  290. {
  291. $ok[] = "";
  292. $err[] = "Unable to create admin levels data :" . mysql_error($connect);
  293. } else {
  294. $err[] = "";
  295. $ok[] = "Admin levels data was created successfully.";
  296. mysql_close($connect);
  297. }
  298.  
  299.  
  300. if (!$q10)
  301. {
  302. $ok[] = "";
  303. $err[] = "Unable to create admins table:" . mysql_error($connect);
  304. } else {
  305. $err[] = "";
  306. $ok[] = "Admins table was created successfully.";
  307. mysql_close($connect);
  308. }
  309. if (!$q10_2)
  310. {
  311. $ok[] = "";
  312. $err[] = "Unable to create admin data:" . mysql_error($connect);
  313. } else {
  314. $err[] = "";
  315. $ok[] = "Admin data was created successfully.";
  316. mysql_close($connect);
  317. }
  318. ?>
  319.  
  320. <?php
  321. require "/home/sgs/public_html/global/footer.php";
  322. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!