Troy 2 Odesláno: 11. Leden, 2014 Share Odesláno: 11. Leden, 2014 (upraveno) 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 Edited 15. Říjen, 2017 by Troy 2 Link to comment Share on other sites More sharing options...
jAk3r 47 Odesláno: 12. Leden, 2014 Share Odesláno: 12. Leden, 2014 Určitě jse budou někomu hodit 10/10 Link to comment Share on other sites More sharing options...
Troy 2 Odesláno: 12. Leden, 2014 Author Share Odesláno: 12. Leden, 2014 Určitě jse budou někomu hodit 10/10 Díky za hodnocení Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now