Jump to content

nabízím Tabulky k Prison Sectoru 47 v4


Troy

Recommended Posts

Zdravím, dnes jsem opravil tabulky k módu Prison Sector 47 v4

Kdyby nefungovali, napište mi na skype: nexontroy

(opravil jsem několik chyb od LYRIcS)

 

//EDIT:

Pouze na 0.3e, 0.3x a 0.3z

( Prison Sector 47: plně funkční na 0.3e i se všemi NPC )

 

 

CREATE TABLE Uptime(server varchar(20), uptime int(9))
CREATE TABLE ps47_tags(ID int(9), State int(9) default '0', X varchar(20), Y varchar(20), Z varchar(20), A varchar(20), Type int(9))
CREATE TABLE ps47_gangs(
ID int(9),
State int(4) default '0',
Bank int(12) default '0',
Respect int(9) default '0',
War_wins int(9) default '0',
War_losses int(9) default '0',
War_LODwins int(9) default '0',
War_LODlosses int(9) default '0',
War_wincash int(12) default '0',
War_lostcash int(12) default '0',
War_winres int(12) default '0',
War_lostres int(12) default '0',
Player0 varchar(24) default '0',
Player1 varchar(24) default '0',
Player2 varchar(24) default '0',
Player3 varchar(24) default '0',
Player4 varchar(24) default '0',
Player5 varchar(24) default '0',
Player6 varchar(24) default '0',
Player7 varchar(24) default '0',
Player8 varchar(24) default '0',
Player9 varchar(24) default '0',
Player0_pay int(9) default '0',
Player1_pay int(9) default '0',
Player2_pay int(9) default '0',
Player3_pay int(9) default '0',
Player4_pay int(9) default '0',
Player5_pay int(9) default '0',
Player6_pay int(9) default '0',
Player7_pay int(9) default '0',
Player8_pay int(9) default '0',
Player9_pay int(9) default '0',
Player0_title varchar(32) default '0',
Player1_title varchar(32) default '0',
Player2_title varchar(32) default '0',
Player3_title varchar(32) default '0',
Player4_title varchar(32) default '0',
Player5_title varchar(32) default '0',
Player6_title varchar(32) default '0',
Player7_title varchar(32) default '0',
Player8_title varchar(32) default '0',
Player9_title varchar(32) default '0',
Item0_id int(4) default '-1',
Item1_id int(4) default '-1',
Item2_id int(4) default '-1',
Item3_id int(4) default '-1',
Item4_id int(4) default '-1',
Item5_id int(4) default '-1',
Item6_id int(4) default '-1',
Item7_id int(4) default '-1',
Item8_id int(4) default '-1',
Item9_id int(4) default '-1',
Item0_amount int(9) default '0',
Item1_amount int(9) default '0',
Item2_amount int(9) default '0',
Item3_amount int(9) default '0',
Item4_amount int(9) default '0',
Item5_amount int(9) default '0',
Item6_amount int(9) default '0',
Item7_amount int(9) default '0',
Item8_amount int(9) default '0',
Item9_amount int(9) default '0'
)
CREATE TABLE banned2(
ID int(9),
user_banned varchar(32),
user_banned_ip varchar(32),
user_banned_dynamic varchar(32),
ban_od int(12),
ban_do int(12),
user_banner varchar(32),
ban_reason varchar(128)
)
CREATE TABLE ucty2(
ID int(9) AUTO_INCREMENT,
Username varchar(32),
Password varchar(150),
AdminLevel int(9),
Vip int(9),
Vip_time int(12),
Score int(9),
Money int(9),
Logic int(9),
Strenght int(9),
Technic int(9),
MP3 int(9),
Bomba int(9),
RingWins int(9),
SprayingType int(9),
Hours int(9),
Minutes int(9),
MaxInvSpace int(9),
Escapes int(9),
NextMission int(9),
Emeralds int(9),
Rozok int(9),
Pivo int(9),
Vino int(9),
Boxer int(9),
Baseballka int(9),
Palica int(9),
Noz int(9),
Spray int(9),
NocneVidenie int(9),
Termovizia int(9),
VstupnaKarta int(9),
MapaSectoru47 int(9),
Sprunk int(9),
Cigareta int(9),
Joint int(9),
Padak int(9),
DesertEagle int(9),
FightingStyle int(9),
LastIPLog varchar(32),
Titul varchar(128),
PRIMARY KEY(id),
gpci varchar(150) default 'UNKNOWN'
)

 

 

To je vše icon_e_smile.gif

Edited by Troy
  • Líbí se mi to! (+1) 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...