|
@@ 148-150 (lines=3) @@
|
| 145 |
|
mysqli_query($link, 'USE `'.$server_SQL_name.'`;') or die('LINK: '.mysqli_error($link)); |
| 146 |
|
|
| 147 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'users'") or die('TEST 1: '.mysqli_error($link)); |
| 148 |
|
if (mysqli_num_rows($query) == 1) { |
| 149 |
|
mysqli_query($link, 'DROP TABLE `users`') or die('DROP 1: '.mysqli_error($link)); |
| 150 |
|
} |
| 151 |
|
|
| 152 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'notes'") or die('TEST 2: '.mysqli_error($link)); |
| 153 |
|
if (mysqli_num_rows($query) == 1) { |
|
@@ 153-155 (lines=3) @@
|
| 150 |
|
} |
| 151 |
|
|
| 152 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'notes'") or die('TEST 2: '.mysqli_error($link)); |
| 153 |
|
if (mysqli_num_rows($query) == 1) { |
| 154 |
|
mysqli_query($link, 'DROP TABLE `notes`') or die('DROP 2: '.mysqli_error($link)); |
| 155 |
|
} |
| 156 |
|
|
| 157 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'db'") or die('TEST 3: '.mysqli_error($link)); |
| 158 |
|
if (mysqli_num_rows($query) == 1) { |
|
@@ 158-160 (lines=3) @@
|
| 155 |
|
} |
| 156 |
|
|
| 157 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'db'") or die('TEST 3: '.mysqli_error($link)); |
| 158 |
|
if (mysqli_num_rows($query) == 1) { |
| 159 |
|
mysqli_query($link, 'DROP TABLE `db`') or die('DROP 3: '.mysqli_error($link)); |
| 160 |
|
} |
| 161 |
|
|
| 162 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'servers'") or die('TEST 4: '.mysqli_error($link)); |
| 163 |
|
if (mysqli_num_rows($query) == 1) { |
|
@@ 163-165 (lines=3) @@
|
| 160 |
|
} |
| 161 |
|
|
| 162 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'servers'") or die('TEST 4: '.mysqli_error($link)); |
| 163 |
|
if (mysqli_num_rows($query) == 1) { |
| 164 |
|
mysqli_query($link, 'DROP TABLE `servers`') or die('DROP 4: '.mysqli_error($link)); |
| 165 |
|
} |
| 166 |
|
|
| 167 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'logs'") or die('TEST 5: '.mysqli_error($link)); |
| 168 |
|
if (mysqli_num_rows($query) == 1) { |
|
@@ 168-170 (lines=3) @@
|
| 165 |
|
} |
| 166 |
|
|
| 167 |
|
$query = mysqli_query($link, "SHOW TABLES LIKE 'logs'") or die('TEST 5: '.mysqli_error($link)); |
| 168 |
|
if (mysqli_num_rows($query) == 1) { |
| 169 |
|
mysqli_query($link, 'DROP TABLE `logs`') or die('DROP 5: '.mysqli_error($link)); |
| 170 |
|
} |
| 171 |
|
|
| 172 |
|
mysqli_query($link, "CREATE TABLE IF NOT EXISTS `users` ( |
| 173 |
|
`user_id` int(11) NOT NULL primary key, |
Cyberbyte-Studios /
CyberWorks
