Raised This Month: $399 Target: $400
 99%   Almost there!

SQL table | How to create this file to SQL!!

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Join Date: Jan 2013
Location: In the Air
Old 12-02-2018 , 10:22   SQL table | How to create this file to SQL!!
Reply With Quote #1

I forgot to save the SQL table, and reinstall webhosting. Unfortunately, only the one who reads from the SQL database has left but can not because unfortunately there is no.
This should make one .sql file:
PHP Code:
PREPARE("SELECT id FROM  `users` WHERE username = :username");
PREPARE("SELECT id FROM `users` WHERE megerosito = :megerosito");
PREPARE("SELECT id FROM `ftpd` WHERE User = :username");
PREPARE("SELECT id FROM `users` WHERE email = :email");
PREPARE("SELECT id FROM `servers` WHERE port = :port");
PREPARE("SELECT id FROM `servers` WHERE owner = :owner");
PREPARE("SELECT id FROM `servers` WHERE port = :port AND owner = :owner");
PREPARE("SELECT id FROM `log` WHERE ki = :ki");
PREPARE("SELECT rank FROM `users` WHERE id = :id");
PREPARE("SELECT * FROM `beallitasok` WHERE karbantartas = :id");
PREPARE("SELECT username FROM `users` WHERE id = :id");
PREPARE("SELECT gamename FROM `games` WHERE id = :id");
PREPARE("SELECT gameid FROM `servers` WHERE port = :port");
PREPARE("SELECT uid FROM `ftpd` WHERE Uid = :uid");
PREPARE("SELECT created, expire FROM `servers` WHERE port = :port");
PREPARE("SELECT inactive FROM `servers` WHERE port = :port");
PREPARE("SELECT expire FROM `servers` WHERE port = :port");
PREPARE("SELECT owner FROM `servers` WHERE port = :port");
PREPARE("SELECT configfile FROM `games` WHERE id = :id");
PREPARE("SELECT gameinstall FROM `games` WHERE id = :id");
PREPARE("SELECT accepted FROM `bizonylatok` WHERE port = :port ORDER BY accepted ASC LIMIT 1");
PREPARE("SELECT startfile FROM `games` WHERE id = :id");
PREPARE("SELECT email, fullname FROM `users` WHERE username = :user");
PREPARE("SELECT id FROM `log` WHERE ki = :ki");
PREPARE("UPDATE `users` SET megerosito = :megerosito WHERE username = :owner");
PREPARE("UPDATE `users` SET password = :pass, megerosito = :megerosito WHERE username = :owner");
PREPARE("INSERT INTO `log` (ki, mit, mikor, ip) VALUES (:username, :mit, :mikor, :ip)"); 
Hungary's TOP1 server:
ultimatgold is offline

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 00:42.

Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode