Jump to content

Intrebare mysql

Jimmi

By Jimmi
in Discuţii scripting

 Share

Recommended Posts

Jimmi Proficient

Jimmi

Posted
Posted

In public onplayerconnect

public OnPlayerConnect(playerid)
{
    if(IsProxyUser(playerid))
    {
         Kick(playerid);
     }
     new string[24];
     GetPlayerVersion(playerid,string,sizeof(string));
    EnablePlayerCameraTarget(playerid, 1);
    JoinedGunGame[playerid] = 0;
    IsFreezed[playerid] = 0;
    RemovePlayerAttachedObject(playerid, MAX_PLAYER_ATTACHED_OBJECTS - 1);
    g_cleoData[ playerid ] [ E_FK_LASTDEATH ] = 0;
    g_cleoData[ playerid ] [ E_FK_DEATHSPAM ] = 0;
    GlassesStep[playerid] = 19006;
    LoginTimer[playerid] = 10;
    FamilyPosX[playerid] = 0.0;
    FamilyPosY[playerid] = 0.0;
    FamilyPosZ[playerid] = 0.0;
    ToNank[playerid] = 0;
    ToRank[playerid] = 0;
    ToMank[playerid] = 0;
    ToLank[playerid] = 0;
    FInviteID[playerid] = 999;
    PlayerInfo[playerid][pFMember] = 255;
    SetPlayerArmour(playerid, 0);
    SetPlayerHealth(playerid, 100);
    ResetPlayerWeaponsEx(playerid);
    SetPlayerVirtualWorld(playerid, 0);
    Weapons[playerid][Melee] = 0;
    Weapons[playerid][Thrown] = 0;
    Weapons[playerid][Pistols] = 0;
    Weapons[playerid][Shotguns] = 0;
    Weapons[playerid][SubMachine] = 0;
    Weapons[playerid][Assault] = 0;
    Weapons[playerid][Rifles] = 0;
    Weapons[playerid][Heavy] = 0;
    Weapons[playerid][Handheld] = 0;
    OldMoney[playerid] = GetPlayerMoney(playerid);
    NewMoney[playerid] = GetPlayerMoney(playerid);
    // ONPLAYERCONNECT
    FactionOffer[playerid] = 999;
    CheatTimer[playerid] = 5;
    WarStats1[playerid] = 0;
    WarStats2[playerid] = 0;
    TogLC[playerid] = 1;
    TogAC[playerid] = 1;
    EnteredHouse[playerid] = 0;
    Hacked[playerid] = 0;
    PlayerInfo[playerid][pGPS] = 0;
    strmid(PlayerInfo[playerid][pSText], "NoText", 0, 255, 255);
    RentHouse[playerid] = 0;
    JobStep[playerid] = 0;
    PlayerInfo[playerid][pSQLID] = 0;
    AdTimer[playerid] = 0;
    PlayerFind[playerid] = 999;
    UsedReport[playerid] = 0;
    TimeReport[playerid] = 0;
    // Remove the original mall mesh
    RemoveBuildingForPlayer(playerid, 6130, 1117.5859, -1490.0078, 32.7188, 10.0);
    // This is the mall mesh LOD
    RemoveBuildingForPlayer(playerid, 6255, 1117.5859, -1490.0078, 32.7188, 10.0);
    // There are some trees on the outside of the mall which poke through one of the interiors
    RemoveBuildingForPlayer(playerid, 762, 1175.3594, -1420.1875, 19.8828, 0.25);
    RemoveBuildingForPlayer(playerid, 615, 1166.3516, -1417.6953, 13.9531, 0.25);
    //Tunel
    RemoveBuildingForPlayer(playerid, 4229, 1597.9063, -1699.75, 30.21094, 0.25);
    RemoveBuildingForPlayer(playerid, 1266, 1538.5234, -1609.8047, 19.84375, 0.25);
    RemoveBuildingForPlayer(playerid, 1266, 1805.0234, -1692.4453, 25.14844, 0.25);
    RemoveBuildingForPlayer(playerid, 4230, 1597.9063, -1699.75, 30.21094, 0.25);
    RemoveBuildingForPlayer(playerid, 1260, 1538.5234, -1609.8047, 19.84375, 0.25);
    RemoveBuildingForPlayer(playerid, 1260, 1805.0234, -1692.4453, 25.14844, 0.25);
    RemoveBuildingForPlayer(playerid, 762, 1023.5938, -2050.6875, 16.0859, 0.25);
    RemoveBuildingForPlayer(playerid, 762, 1011.8594, -2043.5000, 16.0859, 0.25);
    //casino
    RemoveBuildingForPlayer(playerid, 2786, 1967.4063, 1029.6563, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1967.4063, 1021.6875, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1967.4063, 1014.0000, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1967.4063, 1006.3438, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1941.0234, 1014.2266, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1939.6953, 1014.2188, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1941.0234, 1021.4141, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1939.6953, 1021.4141, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1941.8438, 1029.1328, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1940.5547, 1029.4766, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1942.1250, 1006.5703, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2786, 1940.8828, 1006.1094, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 1895, 1938.0469, 986.6250, 992.8828, 0.25);
    RemoveBuildingForPlayer(playerid, 1895, 1940.6875, 989.1719, 992.8828, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1940.8828, 1006.1094, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2098, 1941.5234, 1006.3828, 993.4141, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1942.1250, 1006.5703, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 1895, 1943.2188, 986.5234, 992.8828, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1939.6953, 1014.2188, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2098, 1940.3906, 1014.2031, 993.4141, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1941.0234, 1014.2266, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1939.6953, 1021.4141, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2098, 1940.3906, 1021.4141, 993.4141, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1941.0234, 1021.4141, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1957.4453, 987.6719, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1957.7188, 987.1953, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 1978, 1959.3984, 1010.1172, 992.5078, 0.25);
    RemoveBuildingForPlayer(playerid, 2188, 1960.3672, 1015.6641, 992.4688, 0.25);
    RemoveBuildingForPlayer(playerid, 2773, 1960.3047, 1017.9219, 992.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 2188, 1960.3672, 1020.1719, 992.4688, 0.25);
    RemoveBuildingForPlayer(playerid, 2773, 1961.3516, 1021.4297, 992.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 2773, 1961.3750, 1014.3672, 992.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1961.9609, 992.2031, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1962.4063, 991.8750, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2188, 1962.3438, 1015.6641, 992.4688, 0.25);
    RemoveBuildingForPlayer(playerid, 2773, 1962.3750, 1017.9219, 992.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 2188, 1962.3438, 1020.1797, 992.4688, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1964.5703, 998.4531, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1965.1016, 998.3047, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 1978, 1963.7109, 1010.1172, 992.5078, 0.25);
    RemoveBuildingForPlayer(playerid, 14561, 1964.2109, 1017.8047, 998.7031, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1967.4063, 1014.0000, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1967.4063, 1006.3438, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1967.4063, 1021.6875, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1940.5547, 1029.4766, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2098, 1941.2188, 1029.2969, 993.4141, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1941.8438, 1029.1328, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 1978, 1959.3984, 1025.6953, 992.5078, 0.25);
    RemoveBuildingForPlayer(playerid, 1978, 1963.7109, 1025.6953, 992.5078, 0.25);
    RemoveBuildingForPlayer(playerid, 2785, 1967.4063, 1029.6563, 992.3125, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1964.5469, 1037.2813, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1965.0938, 1037.3516, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1961.9219, 1043.3594, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1962.3984, 1043.6328, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1957.3203, 1047.9766, 992.9844, 0.25);
    RemoveBuildingForPlayer(playerid, 2325, 1957.6563, 1048.4141, 992.9844, 0.25);
    //spawn
    RemoveBuildingForPlayer(playerid, 792, 936.4219, -1651.6641, 12.8203, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 942.7969, -1653.4531, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 942.3516, -1656.1797, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 942.7969, -1649.8672, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 942.2422, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 943.5000, -1656.2344, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 955.9063, -1656.2344, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 954.7578, -1656.1797, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 792, 949.0313, -1651.6641, 12.8203, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 943.5000, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1231, 955.0547, -1651.6094, 15.2500, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 955.3281, -1653.4531, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 955.3281, -1649.8672, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 954.6484, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 955.9063, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 792, 960.9922, -1651.6641, 12.8203, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 967.0313, -1653.4531, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 967.6719, -1656.2344, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 966.5234, -1656.1797, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 792, 973.5625, -1651.6641, 12.8203, 0.25);
    RemoveBuildingForPlayer(playerid, 638, 967.0313, -1649.8672, 13.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 966.4141, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1280, 967.6719, -1647.0313, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 6204, 880.6016, -1653.7656, 14.1797, 0.25);
    //Aero LV/Masura anti-abuz mafii
    RemoveBuildingForPlayer(playerid, 8240, 1586.2578, 1189.5938, 23.4453, 0.25);
    RemoveBuildingForPlayer(playerid, 8378, 1586.2578, 1222.7031, 19.7500, 0.25);
    RemoveBuildingForPlayer(playerid, 8379, 1586.2578, 1222.7031, 19.7500, 0.25);
    RemoveBuildingForPlayer(playerid, 8241, 1586.2578, 1189.5938, 23.4453, 0.25);
    //PayNSpray
    RemoveBuildingForPlayer(playerid, 1297, 1030.8359, -1034.7969, 33.8125, 0.25);
    //15th Avenue Families si Turn=urile TCC
    RemoveBuildingForPlayer(playerid,3646, 2520.1875, -1694.8516, 14.88281, 0.25);
    RemoveBuildingForPlayer(playerid,3706, 2520.1875, -1694.8516, 14.88281, 0.25);
    RemoveBuildingForPlayer(playerid,5838, 895.25781, -1256.9297, 31.23438, 0.25);
    RemoveBuildingForPlayer(playerid,6005, 895.25781, -1256.9297, 31.23438, 0.25);
    RemoveBuildingForPlayer(playerid,5836, 816.33594, -1217.1484, 26.44531, 0.25);
    RemoveBuildingForPlayer(playerid,5926, 816.33594, -1217.1484, 26.44531, 0.25);
    RemoveBuildingForPlayer(playerid,3776, 831.96094, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid,3777, 831.96094, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid,3776, 868.13281, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid,3777, 868.13281, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid,3776, 902.33594, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid,3777, 902.33594, -1191.1406, 25.03906, 0.25);
    RemoveBuildingForPlayer(playerid, 5024, 1748.8438, -1883.0313, 14.1875, 0.25);
    RemoveBuildingForPlayer(playerid, 1265, 2488.8047, -1684.7891, 12.8125, 0.25);
    RemoveBuildingForPlayer(playerid, 1418, 2515.1250, -1683.0859, 13.1719, 0.25);
    RemoveBuildingForPlayer(playerid, 1418, 2512.6094, -1683.1719, 13.1719, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2514.3438, -1684.5234, 12.3906, 0.25);
    RemoveBuildingForPlayer(playerid, 1418, 2517.7734, -1685.2969, 13.1719, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2516.6094, -1686.4844, 12.2422, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2520.6016, -1670.7422, 13.4375, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2519.0625, -1675.7109, 13.1953, 0.25);
    RemoveBuildingForPlayer(playerid, 1226, 2490.1016, -1654.6563, 16.1328, 0.25);
    RemoveBuildingForPlayer(playerid, 1265, 2491.2344, -1653.9609, 12.9219, 0.25);
    RemoveBuildingForPlayer(playerid, 1230, 2492.2656, -1653.9922, 12.8984, 0.25);
    RemoveBuildingForPlayer(playerid, 1211, 2495.2656, -1653.6719, 12.9141, 0.25);
    RemoveBuildingForPlayer(playerid, 1265, 2505.6719, -1658.9063, 12.8125, 0.25);
    RemoveBuildingForPlayer(playerid, 1265, 2510.9219, -1656.1328, 12.8125, 0.25);
    RemoveBuildingForPlayer(playerid, 1211, 2505.6641, -1657.9375, 12.9219, 0.25);
    RemoveBuildingForPlayer(playerid, 1230, 2501.9297, -1650.5078, 12.9141, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2507.5859, -1646.5547, 12.5313, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2501.7500, -1645.5000, 12.2969, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2520.5469, -1662.8828, 13.1641, 0.25);
    RemoveBuildingForPlayer(playerid, 3594, 2514.3906, -1658.6016, 13.1406, 0.25);
    RemoveBuildingForPlayer(playerid, 760, 2517.0938, -1656.0703, 13.0625, 0.25);
    RemoveBuildingForPlayer(playerid, 17879, 2484.5313, -1667.6094, 21.4375, 0.25);
    RemoveBuildingForPlayer(playerid, 1230, 2453.9609, -1653.6953, 12.6797, 0.25);
    RemoveBuildingForPlayer(playerid, 1230, 2475.0000, -1653.6094, 12.7891, 0.25);
    RemoveBuildingForPlayer(playerid, 5043, 1843.3672, -1856.3203, 13.8750, 0.25);
    //HQ SChool Instructors
    RemoveBuildingForPlayer(playerid, 1226, 2507.5938, -1663.0547, 16.2813, 0.25);
    RemoveBuildingForPlayer(playerid, 3685, 1249.5547, -905.4609, 45.0313, 0.25);
    RemoveBuildingForPlayer(playerid, 3685, 1287.6875, -900.4609, 45.0625, 0.25);
    RemoveBuildingForPlayer(playerid, 3685, 1284.2031, -871.2969, 45.2734, 0.25);
    RemoveBuildingForPlayer(playerid, 3685, 1245.4609, -874.7031, 45.0703, 0.25);
    RemoveBuildingForPlayer(playerid, 1308, 1233.0000, -921.0625, 42.0156, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1235.8281, -917.5234, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1231.4141, -886.9297, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1241.1953, -886.8438, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1227.6094, -870.8047, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1261.9531, -913.7813, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1266.4219, -913.1797, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 1308, 1280.2422, -912.5234, 41.3047, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1272.3516, -912.4531, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1275.6016, -911.9609, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 3684, 1249.5547, -905.4609, 45.0313, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1263.8828, -894.3516, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 1211, 1266.0859, -906.7031, 42.3984, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1270.9609, -896.6172, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1265.0313, -897.3516, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1271.8672, -892.3672, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1299.5000, -909.1406, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 3684, 1287.6875, -900.4609, 45.0625, 0.25);
    RemoveBuildingForPlayer(playerid, 5847, 1295.8594, -895.0938, 41.7109, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1252.2578, -885.8750, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1262.9844, -882.2188, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 617, 1271.2031, -882.3984, 41.8750, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1285.6484, -881.3125, 44.3594, 0.25);
    RemoveBuildingForPlayer(playerid, 3684, 1245.4609, -874.7031, 45.0703, 0.25);
    RemoveBuildingForPlayer(playerid, 3684, 1284.2031, -871.2969, 45.2734, 0.25);
    RemoveBuildingForPlayer(playerid, 1232, 1303.1094, -879.9531, 44.3594, 0.25);
    // tcc si curier
    RemoveBuildingForPlayer(playerid, 17504, 2378.6719, -1455.2578, 26.7422, 0.25);
    RemoveBuildingForPlayer(playerid, 1308, 2400.0625, -1409.3203, 23.2109, 0.25);
    RemoveBuildingForPlayer(playerid, 3593, 2407.3125, -1418.3594, 23.6875, 0.25);
    RemoveBuildingForPlayer(playerid, 3593, 2413.3281, -1399.6094, 23.6875, 0.25);
    RemoveBuildingForPlayer(playerid, 700, 2413.5781, -1409.8594, 22.5469, 0.25);
    RemoveBuildingForPlayer(playerid, 1438, -87.0547, -1132.6797, 0.0469, 0.25);
    RemoveBuildingForPlayer(playerid, 1462, -79.2500, -1137.7188, 0.0547, 0.25);
    RemoveBuildingForPlayer(playerid, 1462, -84.3750, -1116.0938, 0.2578, 0.25);
    RemoveBuildingForPlayer(playerid, 1415, -68.3516, -1104.9922, 0.2188, 0.25);
    RemoveBuildingForPlayer(playerid, 1462, -60.3594, -1116.9375, 0.2578, 0.25);
    RemoveBuildingForPlayer(playerid, 1438, -63.6719, -1125.6953, 0.0469, 0.25);
    RemoveBuildingForPlayer(playerid, 1438, -63.4141, -1115.4141, 0.0469, 0.25);
    RemoveBuildingForPlayer(playerid, 1415, -63.8125, -1106.4219, 0.2188, 0.25);
    //fbi
    RemoveBuildingForPlayer(playerid, 1294, 1753.7656, -1671.3125, 17.2500, 0.25);

    //
    ShowSMS[playerid] = 0;
    ShowWhisper[playerid] = 0;
    ShowAM[playerid] = 0 ;
    Bowlings[playerid] = 0;
    BowlingTimer[playerid] = 0;
    SaveTimer[playerid] = 3;
    JailTimer[playerid] = 0;
    BanTimer[playerid] = 0;
    SpeakTimer[playerid] = 0;
    PacaneleTimer[playerid] = 0;
    Tickets[playerid] = 0;
    TextDrawHideForPlayer(playerid, TicketText[playerid]);
    TextDrawHideForPlayer(playerid, TicketText1[playerid]);
    TextDrawHideForPlayer(playerid, SafeText[playerid]);
    TextDrawShowForPlayer(playerid, Textdraw2);
    ListeningCarnival[playerid] = 0, CarnivalIcon[playerid] = 0;
    ListeningXGames[playerid] = 0;
    if(CarnivalStarted != 0) CarnivalIcon[playerid] = SetPlayerMapIcon(playerid, 59, 1418.6583,-3083.5276,7.7274, 25, -1, MAPICON_GLOBAL);
    warned[playerid] = 0;
    RemoveBuildingForPlayer(playerid, 6463, 389.7734, -2028.4688, 19.8047, 0.5);
    RemoveBuildingForPlayer(playerid, 3751, 389.8750, -2035.3828, 29.9531, 50);
    RemoveBuildingForPlayer(playerid, 6298, 389.7734, -2028.4688, 19.8047, 0.5);
    RemoveBuildingForPlayer(playerid, 6461, 389.7734, -2028.5000, 20.1094, 0.5);
    RemoveBuildingForPlayer(playerid, 3752, 389.8750, -2028.5000, 32.2266, 50);
    Tazed[playerid] = 0;
    Tazer[playerid] = 0;
    PlayerInfo[playerid][pRobbingBank] = 0;
    PlayerInfo[playerid][pGPPoints] = 0;
    RadioPos[playerid][0] = 0.0;
    RadioPos[playerid][1] = 0.0;
    RadioPos[playerid][2] = 0.0;
    PlayerInfo[playerid][pCombina] = 0;
    House[playerid] = 999;
    Efraction[playerid] = 0;
    RobbedHouse[playerid] = 0;
    TextDrawShowForPlayer(playerid, LoginS0);
    TextDrawShowForPlayer(playerid, LoginS1);
    TextDrawShowForPlayer(playerid, LoginS2);
    TextDrawShowForPlayer(playerid, LoginS3);
    RemoveBuildingForPlayer(playerid,16094,191.1406,1870.0391,21.4766,1);
    HauntedAdmin[playerid] = 999;
    HauntedStarted[playerid] = 0;
    HauntedPlayer[playerid] = 999;
    AHide[playerid] = 0;
    //CPTimer[playerid] = 0;
    HouseRequested[playerid] = 0;
    Houses[playerid] = 0;
    PlayerInfo[playerid][pTow] = 1;
    PlayerInfo[playerid][pPunish] = 0;
    PlayerInfo[playerid][pFwarn] = 0;
    PlayerInfo[playerid][pRoadblock] = 0;
    AlreadyRadar[playerid] = 0;
    PlayerInfo[playerid][pRadar] = 0;
    PlayerInfo[playerid][pGymEquiped] = 0;
    PlayerInfo[playerid][pKarateEquiped] = 0;
    PlayerInfo[playerid][pTiredFromGym] = 0;
    PlayerInfo[playerid][pTiredFromGrabkick] = 0;
    PlayerInfo[playerid][pTiredFromKarate] = 0;
    PlayerInfo[playerid][pBoxingSkill] = 0;
    PlayerInfo[playerid][pGrabkickSkill] = 0;
    PlayerInfo[playerid][pKarateSkill] = 0;
    PlayerInfo[playerid][pBoxFightStyle] = 0;
    PlateAnnounced[playerid] = 0;
    TextDrawHideForPlayer(playerid, Textdraw0[playerid]);
    TextDrawHideForPlayer(playerid, Textdraw1[playerid]);
    TextDrawHideForPlayer(playerid, Textdraw23[playerid]);
    TextDrawHideForPlayer(playerid, Textdraw3[playerid]);
    TextDrawHideForPlayer(playerid, Textdraw4[playerid]);
    TextDrawHideForPlayer(playerid, Textdraw5[playerid]);
    SeatBelt[playerid] = 0;
    SetTimerEx("OnVehicleSpeedUpdate", 200, false, "i", playerid);
    SetTimerEx("BoomBoxTimer", 1000, true, "i", playerid);
    AllowedSpeed[playerid] = 1;
    PlayerInfo[playerid][pStyle] = 1;
    AnimPlay[playerid] = 0;
    StartedTransporting[playerid] = 0;
    PlayerInfo[playerid][pExp] = 0;
    PlayerInfo[playerid][pMuted] = 0;
    ResetPlayerCash(playerid); //Resetting the players cash variable to zero.
    EvadeTimer[playerid] = 0;
    SetPlayerMapIcon( playerid, 50, 937.3660,-1739.0906,13.5469, 24, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 51, 2131.8369,-1150.5486,24.1454, 55, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 52, 1410.9225,-1701.1395,13.5395, 55, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 53, 2751.8899,-1468.2407,30.4531, 55, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 54, 370.9933,-2052.3145,8.0156, 55, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 55, 1606.3135,-2432.6738,13.5547, 55, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 56, 1462.2015,-1011.4041,26.8438, 52, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 57, 2577.4583,1324.8796,10.8203, 52, 0, MAPICON_LOCAL);
    SetPlayerMapIcon( playerid, 60, 1247.8420,-1560.3422,13.5556, 25, 0, MAPICON_LOCAL);
    PlayerInfo[playerid][pRPBoost] = 0;
    // TEXTDRAWS FUNCTIONS
    TextDrawShowForPlayer(playerid, Textdrawsite1[playerid]);
    TextDrawShowForPlayer(playerid, Textdrawsite2[playerid]);
    TextDrawShowForPlayer(playerid, Textdrawsite3[playerid]);
    TextDrawShowForPlayer(playerid, Textdrawsite4[playerid]);
    //clockk();
    //TextDrawShowForPlayer(playerid,hClock      );
    TextDrawShowForPlayer(playerid,Bar1      );
    TextDrawShowForPlayer(playerid,Bar2      );
    //
    PlayerInfo[playerid][pAchievement1] = 0;
    PlayerInfo[playerid][pAchievement2] = 0;
    PlayerInfo[playerid][pAchievement3] = 0;
    PlayerInfo[playerid][pAchievement4] = 0;
    PlayerInfo[playerid][pAchievement5] = 0;
    PlayerInfo[playerid][pAchievement6] = 0;
    PlayerInfo[playerid][pAchievement10] = 0;
    PlayerInfo[playerid][pAchievement11] = 0;
    PlayerInfo[playerid][pAchievement12] = 0;
    PlayerInfo[playerid][pAchievement13] = 0;
    PlayerInfo[playerid][pAchievement14] = 0;
    PlayerInfo[playerid][pAchievement15] = 0;
    PlayerInfo[playerid][pAchievement16] = 0;
    PlayerInfo[playerid][pAchievement17] = 0;
    PlayerInfo[playerid][pAchievement18] = 0;
    PlayerInfo[playerid][pAchievement19] = 0;
    PlayerInfo[playerid][pAchievement20] = 0;
    PlayerInfo[playerid][pAchievement21] = 0;
    PlayerInfo[playerid][pAchievement22] = 0;
    PlayerInfo[playerid][pAchievement23] = 0;
    PlayerInfo[playerid][pAchievement24] = 0;
    PlayerInfo[playerid][pAchievement25] = 0;
    PlayerInfo[playerid][pAchievement26] = 0;
    PlayerInfo[playerid][pAchievement27] = 0;
    PlayerInfo[playerid][pAchievement28] = 0;
    PlayerInfo[playerid][pAchievement29] = 0;
    PlayerInfo[playerid][pAchievement30] = 0;
    PlayerInfo[playerid][pAchievement31] = 0;
    PlayerInfo[playerid][pAchievement32] = 0;
    PlayerInfo[playerid][pAchievement33] = 0;
    PlayerInfo[playerid][pAchievement34] = 0;
    PlayerInfo[playerid][pAchievement35] = 0;
    PlayerInfo[playerid][pAchievement36] = 0;
    PlayerInfo[playerid][pAchievement37] = 0;
    PlayerInfo[playerid][pAchievement38] = 0;
    PlayerInfo[playerid][pAchievement39] = 0;
    PlayerInfo[playerid][pAchievement40] = 0;
    PlayerInfo[playerid][pCar1] = 0; PlayerInfo[playerid][pCar2] = 0; PlayerInfo[playerid][pCar3] = 0;
    VehPosition[playerid] = 0;
    OwnableCarOffer[playerid] = 999; OwnableCarID[playerid] = 0; OwnableCarPrice[playerid] = 0;
    ExchangeCarOffer[playerid] = 999; ExchangeCarID[playerid] = 0; ExchangeCarPrice[playerid] = 0; ExchangeCarID1[playerid] = 0;
    FirePoints[playerid] = 0;
    PayTimer[playerid] = 0;
    SexTimer[playerid] = 0;
    DrugTimer[playerid] = 0;
    FillTimer[playerid] = 0;
    new playersip[256];
    GetPlayerIp(playerid,playersip,sizeof(playersip));
    strmid(PlayerInfo[playerid][pIP], playersip, 0, 100, 255);
    Train[playerid] = 0;
    PlayAudioStreamForPlayer(playerid, "http://pg-zone.ro/mp3/rpg.pg-zone.ro.mp3");
    LastCar[playerid] = 0;
    FSpawn[playerid] = 1;
    SetPlayerMapIcon(playerid, 1, 1193.8523,-918.9190,43.1762, 10, COLOR_YELLOW);//burger shot LS
    SetPlayerMapIcon(playerid, 2, 2469.7820,2018.0828,16.0938, 10, COLOR_YELLOW);//burger shot LV
    SetPlayerMapIcon(playerid, 3, 2392.5093,2041.5692,10.8203, 14, COLOR_YELLOW);//cluckin bell LV
    SetPlayerMapIcon(playerid, 4, 2441.1169,2065.3987,10.8203, 49, COLOR_YELLOW);    // the craw bar
    SetPlayerMapIcon(playerid, 5, 396.2429, -2074.728, 7.835938, 25, COLOR_YELLOW);  // Fishing School
    SetPlayerMapIcon(playerid, 6, 1528.779, -1678.113, 5.890625, 30, COLOR_YELLOW);  // Police Station
    SetPlayerMapIcon(playerid, 7, 1461.695, -1011.915, 26.84375, 52, COLOR_YELLOW);  // Bank LS
    SetPlayerMapIcon(playerid, 8, 2577.4768,1325.4229,10.8203, 52, COLOR_YELLOW);  // Bank LV
    SetPlayerMapIcon(playerid, 9, 2169.4907,2795.8733,10.8203, 10, COLOR_YELLOW);//burger shot LV
    SetPlayerMapIcon(playerid, 10, 2420.0530,-1508.8719,24.0000, 14, COLOR_YELLOW);//cluckin bell LS
    SetPlayerMapIcon(playerid, 11, 2410.1682,-1220.7765,25.2978, 38, COLOR_YELLOW);    // Pig Pen
    SetPlayerMapIcon(playerid, 12, 2312.9451,-1645.0206,14.8270, 49, COLOR_YELLOW);    // Ten Green
    SetPlayerMapIcon(playerid, 13, 1831.4663,-1683.2169,13.2197, 48, COLOR_YELLOW);    // Alhambra
    SetPlayerMapIcon(playerid, 14, 1498.4476,-1582.8242,13.5469, 50, COLOR_YELLOW);    // Restaurant
    SetPlayerMapIcon(playerid, 15, 2468.4919,-2092.9902,13.5469, 51, COLOR_YELLOW);    // Truck Place
    SetPlayerMapIcon(playerid, 16, 2023.1091,1919.9839,12.3394, 48, COLOR_YELLOW);    // Gun Dealer Reg.
    SetPlayerMapIcon(playerid, 17, 2638.2974,1671.8569,11.0234, 14, COLOR_YELLOW);//cluckin bell LV
    SetPlayerMapIcon(playerid, 18, 2638.3850,1849.7784,11.0234, 29, COLOR_YELLOW);//LV PIZZZA
    SetPlayerMapIcon(playerid, 19, 1158.0591,2072.2092,11.0625, 10, COLOR_YELLOW);//LV BURGER
    SetPlayerMapIcon(playerid, 20, 2845.8950,2415.3938,11.0690, 14, COLOR_YELLOW);//CLUCKBELL LV
    SetPlayerMapIcon(playerid, 21, 2105.4858,-1806.4725,13.5547, 29, COLOR_YELLOW);    // Pizza stack
    SetPlayerMapIcon(playerid, 22, 2229.9011,-1721.2582,13.5613, 54, COLOR_YELLOW);    // Gym
    SetPlayerMapIcon(playerid, 23, 2756.7285,2477.2551,11.0625, 29, COLOR_YELLOW); // pizza
    SetPlayerMapIcon(playerid, 24, 1791.4263,-1163.9659,23.8281, 6, COLOR_YELLOW); // gsls
    SetPlayerMapIcon(playerid, 25, 2596.6951,1095.6530,10.8222, 6, COLOR_YELLOW); // gslv
    TextDrawShowForPlayer(playerid, Time), TextDrawShowForPlayer(playerid, Date);
    undercover[playerid] = 0;
    PlayerInfo[playerid][pMuted] = 0;
    Language[playerid] = 0;
    RemoveBuildingForPlayer(playerid, 6937, 2572.2422, 2703.9609, 19.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 985, 2497.4063, 2777.0703, 11.5313, 0.25);
    RemoveBuildingForPlayer(playerid, 986, 2497.4063, 2769.1094, 11.5313, 0.25);
    RemoveBuildingForPlayer(playerid, 7201, 2615.5000, 2740.6719, 85.7188, 0.25);
    RemoveBuildingForPlayer(playerid, 6929, 2572.2422, 2703.9609, 19.0234, 0.25);
    RemoveBuildingForPlayer(playerid, 7229, 2629.2188, 2742.9922, 14.8906, 0.25);
    gWhisper[playerid] = 1;
    RadioOn[playerid] = 0;
    ListenOn[playerid] = 0;
    JustReported[playerid] = 0;
    gNewb[playerid] = 1;
    PlayerInfo[playerid][pTrial] = 0;
    Barierapark5[playerid] = 0;
    Barierapark4[playerid] = 0;
    AdminDuty[playerid] = 0; TesterDuty[playerid] = 0;
    PlayerInfo[playerid][pJob1] = 0;
    gActivePlayers[playerid]++;
    numplayers++;
    SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0;
    SelectCharID[playerid] = 0; SelectCharPlace[playerid] = 0; ChosenSkin[playerid] = 0;
    GettingJob[playerid] = 0;
    ApprovedLawyer[playerid] = 0; CallLawyer[playerid] = 0; WantLawyer[playerid] = 0;
    KickPlayer[playerid] = 0; CurrentMoney[playerid] = 0; UsedFind[playerid] = 0;
    CP[playerid] = 0; Robbed[playerid] = 0; SpawnChange[playerid] = 0;
    CarOffer[playerid] = 999; CarPrice[playerid] = 0; CarID[playerid] = 0; CarCalls[playerid] = 0;
    RobbedTime[playerid] = 0; MoneyMessage[playerid] = 0; Condom[playerid] = 0;
    STDPlayer[playerid] = 0; SexOffer[playerid] = 999; SexPrice[playerid] = 0;
    RepairOffer[playerid] = 999; RepairPrice[playerid] = 0; RepairCar[playerid] = 0;
    TalkingLive[playerid] = 255; LiveOffer[playerid] = 999; TakingLesson[playerid] = 0;
    RefillOffer[playerid] = 999; RefillPrice[playerid] = 0; MapIconsShown[playerid] = 0;
    DrugOffer[playerid] = 999; PlayerCuffed[playerid] = 0; PlayerCuffedTime[playerid] = 0;
    DrugPrice[playerid] = 0; RegistrationStep[playerid] = 0;
    DrugGram[playerid] = 0; ConnectedToPC[playerid] = 0; OrderReady[playerid] = 0;
    JailPrice[playerid] = 0; MedicTime[playerid] = 0; NeedMedicTime[playerid] = 0; MedicBill[playerid] = 0; GotHit[playerid] = 0;
    WantedPoints[playerid] = 0; GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0;
    OnDuty[playerid] = 0; WantedLevel[playerid] = 0; TestFishes[playerid] = 0;
    BoxWaitTime[playerid] = 0; SchoolSpawn[playerid] = 0; ChangePos2[playerid][1] = 0;
    SafeTime[playerid] = 60; TransportDuty[playerid] = 0; PlayerTied[playerid] = 0;
    TaxiCallTime[playerid] = 0; MedicCallTime[playerid] = 0; TCCCallTime[playerid] = 0;
    FindTimePoints[playerid] = 0; FindTime[playerid] = 0; JobDuty[playerid] = 0;
    Mobile[playerid] = 255; Music[playerid] = 0;
    Spectate[playerid] = 255; PlayerDrunk[playerid] = 0; PlayerDrunkTime[playerid] = 0;
    Unspec[playerid][sLocal] = 255; FishCount[playerid] = 0;
    ConsumingMoney[playerid] = 0;
    FirstSpawn[playerid] = 0;
    gOoc[playerid] = 0; gNews[playerid] = 0; BigEar[playerid] = 0; gDice[playerid] = 0; gFam[playerid] = 0;
    gSpeedo[playerid] = 0; gGas[playerid] = 0; CallReport[playerid] = 0;
    gPlayerLogged[playerid] = 0; gPlayerLogTries[playerid] = 0; gPlayerAccount[playerid] = 0;
    gPlayerSpawned[playerid] = 0; PlayerKarting[playerid] = 0; PlayerInKart[playerid] = 0;
    PlayerTazeTime[playerid] = 0; PlayerStoned[playerid] = 0;
    StartTime[playerid] = 0; TicketOffer[playerid] = 999; TicketMoney[playerid] = 0;
    MatsHolding[playerid] = 0; TutTime[playerid] = 0;
    gPlayerMission[playerid] = 0; TaxiAccepted[playerid] = 999;
    NoFuel[playerid] = 0;
    HireCar[playerid] = 399; PlayersChannel[playerid] = 999;
    TransportValue[playerid] = 0; TransportMoney[playerid] = 0; TransportTime[playerid] = 0; TransportCost[playerid] = 0; TransportDriver[playerid] = 999;
    Locator[playerid] = 0; PlayerOnMission[playerid] = 0; MissionCheckpoint[playerid] = 0;
    WatchingTV[playerid] = 0; PlayerPaintballing[playerid] = 0; PlayerPaintballKills[playerid] = 0;
    Fishes[playerid][pLastFish] = 0; Fishes[playerid][pFishID] = 0;
    ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999;
    PlayerInfo[playerid][pLevel] = 0;
    PlayerInfo[playerid][pAdmin] = 0;
    PlayerInfo[playerid][pDonateRank] = 0;
    PlayerInfo[playerid][gPupgrade] = 0;
    PlayerInfo[playerid][pConnectTime] = 0;
    PlayerInfo[playerid][pReg] = 0;
    PlayerInfo[playerid][pSex] = 0;
    PlayerInfo[playerid][pAge] = 0;
    PlayerInfo[playerid][pExp] = 0;
    PlayerInfo[playerid][pAccount] = 0;
    PlayerInfo[playerid][pCrimes] = 0;
    PlayerInfo[playerid][pDeaths] = 0;
    PlayerInfo[playerid][pArrested] = 0;
    PlayerInfo[playerid][pWantedDeaths] = 0;
    PlayerInfo[playerid][pPhoneBook] = 0;
    PlayerInfo[playerid][pLottoNr] = 0;
    PlayerInfo[playerid][pFishes] = 0;
    PlayerInfo[playerid][pBiggestFish] = 0;
    PlayerInfo[playerid][pJob] = 0;
    PlayerInfo[playerid][pPayCheck] = 0;
    PlayerInfo[playerid][pHeadValue] = 0;
    PlayerInfo[playerid][pJailed] = 0;
    PlayerInfo[playerid][pJailTime] = 0;
    PlayerInfo[playerid][pMats] = 0;
    PlayerInfo[playerid][pDrugs] = 0;
    PlayerInfo[playerid][pLeader] = 0;
    PlayerInfo[playerid][pMember] = 0;
    PlayerInfo[playerid][pFMember] = 255;
    PlayerInfo[playerid][pRank] = 0;
    PlayerInfo[playerid][pChar] = 0;
    PlayerInfo[playerid][pContractTime] = 0;
    PlayerInfo[playerid][pDetSkill] = 0;
    PlayerInfo[playerid][pSexSkill] = 0;
    PlayerInfo[playerid][pBoxSkill] = 0;
    PlayerInfo[playerid][pLawSkill] = 0;
    PlayerInfo[playerid][pMechSkill] = 0;
    PlayerInfo[playerid][pJackSkill] = 0;
    PlayerInfo[playerid][pCarSkill] = 0;
    PlayerInfo[playerid][pNewsSkill] = 0;
    PlayerInfo[playerid][pDrugsSkill] = 0;
    PlayerInfo[playerid][pCookSkill] = 0;
    PlayerInfo[playerid][pFishSkill] = 0;
    PlayerInfo[playerid][pSHealth] = 0.0;
    PlayerInfo[playerid][pHealth] = 50.0;
    PlayerInfo[playerid][pPos_x] = 865.1860;
    PlayerInfo[playerid][pPos_y] = -1634.7330;
    PlayerInfo[playerid][pPos_z] = 14.9297;
    PlayerInfo[playerid][pInt] = 15;
    PlayerInfo[playerid][pLocal] = 255;
    PlayerInfo[playerid][pTeam] = 3;
    PlayerInfo[playerid][pModel] = 29;
    new randphone = 1000 + random(9000);//minimum 1000  max 9999 //giving one at the start
    PlayerInfo[playerid][pPnumber] = randphone;
    PlayerInfo[playerid][pPhousekey] = 255;
    PlayerInfo[playerid][pPbiskey] = 255;
    PlayerInfo[playerid][pCarLic] = 0;
    PlayerInfo[playerid][pFlyLic] = 0;
    PlayerInfo[playerid][pBoatLic] = 0;
    PlayerInfo[playerid][pFishLic] = 0;
    PlayerInfo[playerid][pGunLic] = 0;
    PlayerInfo[playerid][pMatsLic] = 0;
    PlayerInfo[playerid][pGun1] = 0;
    PlayerInfo[playerid][pGun2] = 0;
    PlayerInfo[playerid][pGun3] = 0;
    PlayerInfo[playerid][pGun4] = 0;
    PlayerInfo[playerid][pAmmo1] = 0;
    PlayerInfo[playerid][pAmmo2] = 0;
    PlayerInfo[playerid][pAmmo3] = 0;
    PlayerInfo[playerid][pAmmo4] = 0;
    PlayerInfo[playerid][pCarTime] = 0;
    PlayerInfo[playerid][pPayDay] = 0;
    PlayerInfo[playerid][pPayDayHad] = 0;
    PlayerInfo[playerid][pCDPlayer] = 0;
    PlayerInfo[playerid][pWins] = 0;
    PlayerInfo[playerid][pLoses] = 0;
    PlayerInfo[playerid][pAlcoholPerk] = 0;
    PlayerInfo[playerid][pDrugPerk] = 0;
    PlayerInfo[playerid][pMiserPerk] = 0;
    PlayerInfo[playerid][pPainPerk] = 0;
    PlayerInfo[playerid][pTraderPerk] = 0;
    PlayerInfo[playerid][pTut] = 0;
    PlayerInfo[playerid][pMissionNr] = 0;
    PlayerInfo[playerid][pWarns] = 0;
    PlayerInfo[playerid][pFuel] = 0;
    PlayerInfo[playerid][pAdjustable] = 0;
    PlayerInfo[playerid][pCadou] = 0;
    PlayerInfo[playerid][pRMuted] = 0;
    PlayerInfo[playerid][pLiderW] = 0;
    ClearCrime(playerid);
    ClearFishes(playerid);
    ClearCooking(playerid);
    ClearGroceries(playerid);
    ClearMarriage(playerid);
    SetPlayerColor(playerid,COLOR_GRAD2);
    new plname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, plname, sizeof(plname));
    new qstr[100];
    format(qstr,100,"SELECT * FROM `players` WHERE `username`='%s';",plname);
    mysql_query (qstr);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        gPlayerAccount[playerid] = 1;
    }
    else
    {
        gPlayerAccount[playerid] = 0;
    }
    mysql_free_result();
    return 1;
}

la sfarsit am

    new plname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, plname, sizeof(plname));
    new qstr[100];
    format(qstr,100,"SELECT * FROM `players` WHERE `username`='%s';",plname);
    mysql_query (qstr);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        gPlayerAccount[playerid] = 1;
    }
    else
    {
        gPlayerAccount[playerid] = 0;
    }
    mysql_free_result();
    return 1;
}

inafara de mysql_store_restule si num_rows in codul de mai sus mai trebuie inlocuit cevA?Si daca da cu ce se inlocuieste?

Link to comment
Share on other sites
WiDuAlK Veteran

WiDuAlK

Posted
Posted

wtf nu inteleg nimic, ai pus tot publicul...

@WiDuAlK Tutorial`s:

PAWN pentru SA:MP in Notepad++
Tutorial Register-Login MYSQL R39
Tutorial etape de register
Cum sa creezi un PayDay (2 METODE)
Cum sa creezi o factiune de la 0 PART 1
Cum sa creezi o factiune de la 0 PART 2
Cum sa creezi o factiune de la 0 partea a 3-a (ULTIMA)
Functii folositoare din NEW.PWN
Tutorial Engine Vehicle
Optimizare simplitate si stil
Foreach inlocuieste loop-ul
SSCANF si ZCMD

Cum sa creezi o poarta miscatoare

Tutorial cum sa creezi un radio pe server si cum sa iti creezi melodi pentru ascultat pe server
Cum sa tii un server din PC folosind HAMACHI  

Documentatie* Despre hack-uri

Servicii:

Servicii Scripting & Mapping

Produse:

Farmer Job Realistic

Drugs Dealer System [SA-MP] UNIQUE

 

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.

  I accept