5w321x2Z

1KillsGangFree <- 0;
2KillsGangTommy <- 0;
3KillsGangSharks <- 0;
4KillsGangBiker <- 0;
5KillsGangHaitian <- 0;
6KillsGangCuban <- 0;
7KillsGangGolf <- 0;
8KillsGangProstitute <- 0;
9KillsGangSonny <- 0;
10KillsGangBeach <- 0;
11
12
13function onPlayerKill( killer,player , reason, bodypart )
14{
15//if(KillerEnevento==true) -- es para que solo se active para los jugadores en evento
16//{
17GangSkinIDTag(killer)
18//}
19}
20
21function GangSkinIDTag(player)
22{
23local GangSkinID = player.Skin;
24if( GangSkinID == 209 || GangSkinID == 212 || GangSkinID == 214 ) return KillsGangFree +=1;
25if( GangSkinID == 0 || GangSkinID == 1 ) return KillsGangTommy +=1 ;
26if( GangSkinID == 87 || GangSkinID == 88 ) return KillsGangSharks += 1;
27if( GangSkinID == 94 || GangSkinID == 93 ) return KillsGangBiker += 1;
28if( GangSkinID == 85 || GangSkinID == 86 ) return KillsGangHaitian += 1;
29if( GangSkinID == 83 || GangSkinID == 84 ) return KillsGangCuban += 1;
30if( GangSkinID == 62 || GangSkinID == 64 ) return KillsGangGolf += 1;
31if( GangSkinID == 157 || GangSkinID == 153 ) return KillsGangProstitute += 1;
32if( GangSkinID == 144 || GangSkinID == 145 ) return KillsGangSonny += 1;
33if( GangSkinID == 65 || GangSkinID == 58 ) return KillsGangBeach += 1;
34return ;
35}
36function onScriptLoad()
37{
38DatabaseGang <- ConnectSQL( "DatabaseGang.db" );
39QuerySQL( DatabaseGang, "CREATE TABLE IF NOT EXISTS GansKills ( GangFree NUMERIC,GangTommy NUMERIC,GangSharks NUMERIC,GangBiker NUMERIC,GangHaitian NUMERIC,GangCuban NUMERIC,GangGolf NUMERIC,GangProstitute NUMERIC,GangSonny NUMERIC,GangBeach NUMERIC )" );
40CargarKillsGang()
41}
42function onServerStop()
43{
44         GuardarKillsGang()
45}
46
47function onScriptUnload()
48{
49         GuardarKillsGang()
50}
51
52function GuardarKillsGang()
53{
54local q = QuerySQL(DatabaseGang, "SELECT * FROM GansKills" );
55if(GetSQLColumnData( q, 0 ) == null)
56{
57QuerySQL( DatabaseGang, "INSERT INTO GansKills ( GangFree , GangTommy , GangSharks , GangBiker, GangHaitian, GangCuban, GangGolf, GangProstitute , GangSonny , GangBeach  ) VALUES ('"+ KillsGangFree +"','"+ KillsGangTommy +"','"+ KillsGangSharks +"','"+ KillsGangBiker +"','"+ KillsGangHaitian +"','"+ KillsGangCuban +"','"+ KillsGangGolf +"','"+ KillsGangProstitute +"','"+ KillsGangSonny +"','"+ KillsGangBeach +"' )" );
58return ;
59}
60if(GetSQLColumnData( q, 0 ) != null)
61{
62QuerySQL( DatabaseGang, "UPDATE GansKills SET GangFree='"+ KillsGangFree +"' WHERE GangFree");
63QuerySQL( DatabaseGang, "UPDATE GansKills SET GangTommy='"+ KillsGangTommy +"' WHERE GangTommy");
64QuerySQL( DatabaseGang, "UPDATE GansKills SET GangSharks='"+ KillsGangSharks +"' WHERE GangSharks");
65QuerySQL( DatabaseGang, "UPDATE GansKills SET GangBiker='"+ KillsGangBiker +"' WHERE GangBiker");
66QuerySQL( DatabaseGang, "UPDATE GansKills SET GangHaitian='"+ KillsGangHaitian +"' WHERE GangHaitian");
67QuerySQL( DatabaseGang, "UPDATE GansKills SET GangCuban='"+ KillsGangCuban +"' WHERE GangCuban");
68QuerySQL( DatabaseGang, "UPDATE GansKills SET GangGolf='"+ KillsGangGolf +"' WHERE GangGolf");
69QuerySQL( DatabaseGang, "UPDATE GansKills SET GangProstitute='"+ KillsGangProstitute +"' WHERE GangProstitute");
70QuerySQL( DatabaseGang, "UPDATE GansKills SET GangSonny='"+ KillsGangSonny +"' WHERE GangSonny");
71QuerySQL( DatabaseGang, "UPDATE GansKills SET GangBeach='"+ KillsGangBeach +"' WHERE GangBeach");
72}
73}
74
75function CargarKillsGang()
76{
77
78local q = QuerySQL(DatabaseGang, "SELECT * FROM GansKills" );
79if(GetSQLColumnData( q, 0 ) != null)KillsGangFree = GetSQLColumnData( q, 0 );
80if(GetSQLColumnData( q, 1 ) != null)KillsGangTommy = GetSQLColumnData( q, 1 );
81if(GetSQLColumnData( q, 2 ) != null)KillsGangSharks = GetSQLColumnData( q, 2 );
82if(GetSQLColumnData( q, 3 ) != null)KillsGangBiker = GetSQLColumnData( q, 3 );
83if(GetSQLColumnData( q, 4 ) != null)KillsGangHaitian = GetSQLColumnData( q, 4 );
84if(GetSQLColumnData( q, 5 ) != null)KillsGangCuban = GetSQLColumnData( q, 5 );
85if(GetSQLColumnData( q, 6 ) != null)KillsGangGolf = GetSQLColumnData( q, 6 );
86if(GetSQLColumnData( q, 7 ) != null)KillsGangProstitute = GetSQLColumnData( q, 7 );
87if(GetSQLColumnData( q, 8 ) != null)KillsGangSonny = GetSQLColumnData( q, 8 );
88if(GetSQLColumnData( q, 9 ) != null)KillsGangBeach = GetSQLColumnData( q, 9 );
89print("KillGangs Free:"+KillsGangFree+" Tommy:"+KillsGangTommy+" Sharks:"+KillsGangSharks+" Bikers:"+KillsGangBiker+" Haitian:"+KillsGangHaitian);
90print("Cuban:"+KillsGangCuban+" Golf:"+KillsGangGolf+" Prostitute:"+KillsGangProstitute+" Sonny:"+KillsGangSonny+" Beach:"+KillsGangBeach);
91}