help/runner.php at master · electrodragon/help · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
session_start();
include 'routes.php';
// Creating DataBase
for($i=1; $i<=5; $i++){
    $con=mysqli_connect("localhost","root","","ghona");
    if(!$con){
      $conn = mysqli_connect("localhost","root","");
      $sql = "CREATE DATABASE ghona";
      if (mysqli_query($conn, $sql)) {
      echo "Database created successfully";
      } else {
      echo "Error creating database: " . mysqli_error($conn);
      }
    }else{
      $_SESSION['connection']=true;
    }
}

// Creating Database Table1
$query1=mysqli_query($con,"SELECT * from `helpdesk`");
if($query1){
  $_SESSION['query1']=true;
}else{
  $sql="CREATE TABLE helpdesk (
  id INT(150) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  sites VARCHAR(150) NOT NULL,
  usernames VARCHAR(150) NOT NULL,
  email VARCHAR(150) NOT NULL,
  pass VARCHAR(150) NOT NULL,
  domain VARCHAR(150) NOT NULL,
  customerno VARCHAR(150) NOT NULL,
  firstname VARCHAR(150) NOT NULL,
  lastname VARCHAR(150) NOT NULL,
  phoneno VARCHAR(150) NOT NULL,
  dob VARCHAR(150) NOT NULL,
  gen VARCHAR(150) NOT NULL
  )";
  mysqli_query($con,$sql);
}

// Creating Database Table2
$query2=mysqli_query($con,"SELECT * from `helper`");
if($query2){
  $_SESSION['query2']=true;
}else{
  $sql="CREATE TABLE helper (
  id INT(150) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  sites VARCHAR(150) NOT NULL
  )";
  mysqli_query($con,$sql);
}

// Creating Database Table3
$query3=mysqli_query($con,"SELECT * from `trashed`");
if($query3){
  $_SESSION['query3']=true;
}else{
  $sql="CREATE TABLE trashed (
  id INT(150) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  sites VARCHAR(150) NOT NULL,
  usernames VARCHAR(150) NOT NULL,
  email VARCHAR(150) NOT NULL,
  pass VARCHAR(150) NOT NULL,
  domain VARCHAR(150) NOT NULL,
  customerno VARCHAR(150) NOT NULL,
  firstname VARCHAR(150) NOT NULL,
  lastname VARCHAR(150) NOT NULL,
  phoneno VARCHAR(150) NOT NULL,
  dob VARCHAR(150) NOT NULL,
  gen VARCHAR(150) NOT NULL
  )";
  mysqli_query($con,$sql);
}
// Creating Database Table4
$query4=mysqli_query($con,"SELECT * from `snaps`");
if($query4){
  $_SESSION['query4']=true;
}else{
  $sql="CREATE TABLE snaps (
  id INT(150) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  snippet VARCHAR(150) NOT NULL,
  pass1 VARCHAR(150) NOT NULL,
  pass2 VARCHAR(150) NOT NULL,
  pass3 VARCHAR(150) NOT NULL,
  pass4 VARCHAR(150) NOT NULL,
  pass5 VARCHAR(150) NOT NULL,
  pass6 VARCHAR(150) NOT NULL
  )";
  mysqli_query($con,$sql);
}
flyto('index');
 ?>