Raised This Month: $429 Target: $400
 107% 

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


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ultimatgold
Member
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

Hi!
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
ultimatgold
Member
Join Date: Jan 2013
Location: In the Air
Old 12-06-2018 , 03:13   Re: SQL table | How to create this file to SQL!!
Reply With Quote #2

Hi This is strong question? XD

This help maybe?
Code:
users:
  'id',
  'username',
  'password',
  'megerosito',
  'email',
  'rank',
  'fullname'
  
ftpd:
  'id',
  'uid',
  'User',
servers:
  'id',
  'port'
  'owner'
  'gameid',
  'expire',
  'inactive'
log:
  'id',
  'ki'
  'mit',
  'mikor',
  'ip'
beallitasok:
  'karbantartas'
games:
  'id',
  'gamename',
  'configfile',
  'gameinstall',
  'startfile'
bizonylatok:
  'accepted',
  'port'
__________________
Hungary's TOP1 server:

Last edited by ultimatgold; 12-06-2018 at 03:25.
ultimatgold is offline
Reply


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 10:03.


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