· 8 years ago · Nov 22, 2017, 01:38 PM
1else if ( cmd == "buyvip")
2 {
3 if ( stats[player.ID].registered==false ) MessagePlayer ( "[INFO] - You are not register please Register!", player);
4 else if ( stats[player.ID].logged==false ) MessagePlayer ( "[INFO] - You are not login your account please login!", player);
5 else if ( CheckVIP( player ) ) MessagePlayer(GREEN+"[INFO] - You are already buy VIP.", player );
6 else
7 {
8QuerySQL( db, "INSERT INTO VIP VALUES('" + player.Name + "', '" + player.Name.tolower() + "', '1','1511329172','60','0:0:1')" );
9
10 QuerySQL(db, "UPDATE VIP SET VIP= '2' WHERE Name='" + player.Name + "'");
11
12
13
14 Message(LIGHT+"[VIP] - " + player.Name + " has Buy VIP!");
15 }
16 }
17
18
19else if ( cmd == "myvip")
20 {
21 if ( stats[player.ID].registered==false ) MessagePlayer ( "[INFO] - You are not register please Register!", player);
22 else if ( stats[player.ID].logged==false ) MessagePlayer ( "[INFO] - You are not login your account please login!", player);
23 else
24 {
25CMDVIPTIME( player.ID );
26 }
27 }
28else if ( ( cmd == "vip" ) || ( cmd == "vips" ) )
29
30 {
31 local plr, b;
32 for( local i = 0; i < GetMaxPlayers(); i++ )
33 {
34 plr = FindPlayer( i );
35 if ( ( plr ) && ( GetVIP( plr ).tointeger() >= 2 ) )
36 {
37 if ( b ) b = b + ", " + plr.Name + " "
38 else b = plr.Name + " "
39 }
40 }
41 if ( b ) Message( GREY+"**VIP Online:[ " + b + " ] ]" );
42 else Message( GREY+"**No VIP Online" );
43 }
44
45
46
47
48
49
50
51
52
53
54
55
56
57function SetVIP( player, amount )
58{
59 QuerySQL(db, "UPDATE VIP SET VIP='" + amount + "' WHERE Name='" + player.Name + "'");
60}
61
62function VIPTimeRem( VIPtime, VIPratio )
63{
64 local VIP_current = time()-VIPtime, sp = split(VIPratio,":"), VIP_Days, VIP_Hours, VIP_Minutes,
65 VIP_Day = sp[ 0 ].tointeger(),
66 VIP_Hour = sp[ 1 ].tointeger(),
67 VIP_Minute = sp[ 2 ].tointeger();
68 VIP_Days = VIP_current/86400;
69 VIP_current = VIP_current%86400;
70 VIP_Hours = VIP_current/3600;
71 VIP_current = VIP_current%3600;
72 VIP_Minutes = VIP_current/60;
73 VIP_current = VIP_current%60;
74 VIP_Day -= VIP_Days;
75 VIP_Hour -= VIP_Hours;
76 VIP_Minute -= VIP_Minutes;
77 return VIP_Day + " Day(s), " + VIP_Hour + " Hour(s), " + VIP_Minute + " Minutes.";
78}
79
80
81function VIPTIME( id )
82{
83local player = FindPlayer(id);
84
85 local query = QuerySQL( db, "SELECT * FROM VIP WHERE Name='" + player.Name + "' COLLATE NOCASE" );
86 if( GetSQLColumnData( query, 0 ) )
87 {
88 if( ( time() - GetSQLColumnData( query, 3 ).tointeger() ) >= GetSQLColumnData( query, 5 ).tointeger() )
89 {
90 local query2 = QuerySQL( db, "DELETE FROM VIP WHERE Name='" + player.Name + "'" );
91 FreeSQLQuery( query2 );
92
93 MessagePlayer(BLUE+"[VIP] - Your VIP Account has been Expired, Buy again with /buyvip.", player );
94 }
95
96}
97 FreeSQLQuery( query );
98}
99
100function CMDVIPTIME( id )
101{
102local player = FindPlayer(id);
103
104 local query = QuerySQL( db, "SELECT * FROM VIP WHERE Name='" + player.Name + "' COLLATE NOCASE" );
105 if( GetSQLColumnData( query, 0 ) )
106 {
107 local Time_Left = VIPTimeRem( GetSQLColumnData( query, 3 ).tointeger(), GetSQLColumnData( query, 5 ) );
108 //local splitban = split( GetSQLColumnData( query, 5 ), ":" ), Calc = splitban[ 0 ] + " Day(s), " + splitban[ 1 ] + " Hour(s), " + splitban[ 2 ] + " Minute(s).";
109 MessagePlayer(BLUE+"[VIP] - Your VIP has been not expired, Expire in " + Time_Left, player );
110 }
111 FreeSQLQuery( query );
112}
113
114function GetVIP( player )
115{
116 local le = GetSQLColumnData( QuerySQL( db, "SELECT VIP FROM VIP WHERE Name='" + player.Name+"'" ), 0 );
117 if ( le ) return le;
118 else return 0;
119}
120
121function GetVIP( player )
122{
123 local le = GetSQLColumnData( QuerySQL( db, "SELECT VIP FROM VIP WHERE Name='" + player.Name+"'" ), 0 );
124 if ( le ) return le;
125 else return 0;
126}
127
128function CheckVIP( player )
129{
130 local vip = GetSQLColumnData( QuerySQL( db, "SELECT Name FROM VIP WHERE Name='" + player.Name+"'" ), 0 );
131 if ( vip ) return vip;
132 else return 0;
133}
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162QuerySQL( db, "CREATE TABLE IF NOT EXISTS VIP ( Name VARCHAR(255), NameLower VARCHAR(255), VIP INT(15), ban_time TEXT, VIP_expire TEXT, VIP_expireratio TEXT )" );
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177plyaeronjoin
178NewTimer( "VIPTIME", 1000, 1, player.ID );