[kdlife]

Quote:

Originally Posted by Dziugsas i'm not good at sql and mysql.Sorry bro.

It's easy bro...but for me it's hard couz i am newbie


/*
Mysql:Tables

users: id,Name,Password,Mail,Level,AdminLevel,Spawn,reg_d ate,last_on,Money,kills,deaths,....
CREATE TABLE `users`( id INT auto_increment PRIMARY KEY,Name varchar(50),Password varchar(50), ip varchar(50),Mail varchar(50) DEFAULT 'Undefined!',Level INT DEFAULT '0',AdminLevel INT DEFAULT '0', Spawn INT DEFAULT '0',
reg_date varchar(50) DEFAULT 'NaN',last_on varchar(50) DEFAULT 'NaN',Money INT DEFAULT '0',kills INT DEFAULT '0', deaths INT DEFAULT '0',
onlinetime varchar(100) DEFAULT '0 days 0 hours 0 minutes 0 seconds',skin INT DEFAULT '0',);

info: id,name,referers
CREATE TABLE `info` ( id INT auto_increment PRIMARY KEY,Name varchar(50),referers INT DEFAULT '0',regiune varchar(50) DEFAULT 'Unknown',DataDenastere varchar(50) DEFAULT 'unknown',NumeReal varchar(50) DEFAULT 'unknown',Profesie varchar(50) DEFAULT 'unknown',Sex varchar(50) DEFAULT 'unknown'
);

Kicks: id,player,time,reason
CREATE TABLE `kicks` (id INT auto_increment PRIMARY KEY,player varchar(50),time varchar(50),reason varchar(50))

tempbans:name, ip, reason, banlength, bannedby,when,expire
CREATE TABLE `tempbans` (id INT auto_increment PRIMARY KEY, name varchar(50), ip varchar(50), reason varchar(50), banlength varchar(50), bannedby varchar(50),cand varchar(50),expire varchar(50) );

bans: id , name, ip, reason, bannedby, date;
CREATE TABLE `bans` (id INT auto_increment PRIMARY KEY, name varchar(50), ip varchar(50), reason varchar(50), bannedby varchar(50),date varchar(50) );

PersonalCars id,model,color1,color2,price,owner,posx,posy,posz, posa,plate,parked,paintj,components)
CREATE TABLE `personalcars` (id INT auto_increment PRIMARY KEY,Model INT,Color1 INT,Color2 INT,Price INT,Owner varchar(50),PosX float,PosY float,PosZ float,PosA float,Plate varchar(50),Parked int,PaintJ INT,Components varchar(50),Repayed INT)

Log
CREATE TABLE `log`(id INT auto_increment PRIMARY KEY,_type varchar(50),_date varchar(50),info varchar(100));

Houses:
CREATE TABLE `houses`(id INT auto_increment PRIMARY KEY,Owner varchar(50),Name varchar(50),Locked INT,Price INT,NoParks INT,PickUpX FLOAT,PickUpY FLOAT,PickUpZ FLOAT,
interior INT,
Park1X FLOAT,Park1Y FLOAT,Park1Z FLOAT,Park1A FLOAT,Park2X FLOAT,Park2Y FLOAT,Park2Z FLOAT,Park2A FLOAT,Park3X FLOAT,Park3Y FLOAT,Parks3Z FLOAT,Park3A FLOAT);

*/