SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 28/05/2019, 07:28 PM   #1
MacGyverr
Little Clucker
 
Join Date: Aug 2014
Posts: 49
Reputation: 3
Default Problem with MYSQL

Players on my server sometimes when they join got same weapons, money or even Admin rank. I don't know if it's about IDs messing up- I need help. Some guy said my servers database might be full? Can that be the case?
MacGyverr is offline   Reply With Quote
Old 28/05/2019, 07:42 PM   #2
TheToretto
Gangsta
 
TheToretto's Avatar
 
Join Date: Jul 2015
Posts: 592
Reputation: 66
Default Re: Problem with MYSQL

Reset player arrays on disconnect / connect
__________________






Toretto#9902

Rest in peace grandpa, 03 November 2018
TheToretto is online now   Reply With Quote
Old 28/05/2019, 09:05 PM   #3
MacGyverr
Little Clucker
 
Join Date: Aug 2014
Posts: 49
Reputation: 3
Default Re: Problem with MYSQL

What do you mean by that? I haven't touched the player arrays at all so i don't see how that is the problem?
MacGyverr is offline   Reply With Quote
Old 28/05/2019, 10:20 PM   #4
TheToretto
Gangsta
 
TheToretto's Avatar
 
Join Date: Jul 2015
Posts: 592
Reputation: 66
Default Re: Problem with MYSQL

https://forum.sa-mp.com/showthread.php?t=498503
__________________






Toretto#9902

Rest in peace grandpa, 03 November 2018
TheToretto is online now   Reply With Quote
Old 29/05/2019, 02:55 PM   #5
MacGyverr
Little Clucker
 
Join Date: Aug 2014
Posts: 49
Reputation: 3
Default Re: Problem with MYSQL

So all i have to do is put this code in top of the OnPlayerConnect?

PHP Code:
public OnPlayerConnect(playerid){

    
gPlayerInfo[playerid][pAdminLVL] = 51;
    
printf("%d"gPlayerInfo[playerid][pAdminLVL]);
    for(new 
ipBlueprint:pBlueprinti++)
    {
        
gPlayerInfo[playerid][pBlueprint:i] = 0;
    }
    
printf("%d"gPlayerInfo[playerid][pAdminLVL]);


MacGyverr is offline   Reply With Quote
Old 29/05/2019, 03:08 PM   #6
Gforcez
Gangsta
 
Gforcez's Avatar
 
Join Date: Jul 2010
Location: The Netherlands.
Posts: 746
Reputation: 418
Default Re: Problem with MYSQL

Quote:
Originally Posted by MacGyverr View Post
So all i have to do is put this code in top of the OnPlayerConnect?

PHP Code:
public OnPlayerConnect(playerid){

    
gPlayerInfo[playerid][pAdminLVL] = 51;
    
printf("%d"gPlayerInfo[playerid][pAdminLVL]);
    for(new 
ipBlueprint:pBlueprinti++)
    {
        
gPlayerInfo[playerid][pBlueprint:i] = 0;
    }
    
printf("%d"gPlayerInfo[playerid][pAdminLVL]);


PHP Code:
public OnPlayerConnect(playerid){

    
gPlayerInfo[playerid][pAdminLVL] = 0// Reset the pAdminLVL for playerid

// Here you're already resetting the blueprints
    
for(new ipBlueprint:pBlueprinti++)
    {
        
gPlayerInfo[playerid][pBlueprint:i] = 0;
    }

__________________

Gforcez is offline   Reply With Quote
Old 29/05/2019, 09:54 PM   #7
Dokins
Banned
 
Join Date: Jun 2010
Posts: 1,651
Reputation: 53
Default Re: Problem with MYSQL

Don't do it OnPlayerConnect, reset the data in a function such as ClearPlayerID after you've saved their items.
Dokins is offline   Reply With Quote
Old 30/05/2019, 10:50 AM   #8
DaniceMcHarley
High-roller
 
DaniceMcHarley's Avatar
 
Join Date: Feb 2012
Location: www.finalnights-rp.com
Posts: 1,741
Reputation: 95
Default Re: Problem with MYSQL

Reset the player variables that correlate to the ID.
DaniceMcHarley is offline   Reply With Quote
Old 30/05/2019, 11:02 AM   #9
MacGyverr
Little Clucker
 
Join Date: Aug 2014
Posts: 49
Reputation: 3
Default Re: Problem with MYSQL

Hmm, can you show me on this code?

PHP Code:
public OnPlayerConnect(playerid) {

    
Gambling[playerid] = G_STATE_NOT_GAMBLING;
    
SlotTimer[playerid] = -1;

    
PlayAudioStreamForPlayer(playerid"http://k007.kiwi6.com/hotlink/f1gius74g3/M3LTED_MUSIC_-_SAMP.mp3");
    
Spawned[playerid]=false;
    new 
query[180];
    
GetPlayerIp(playeridInfo[playerid][IP], 16);


    
format(querysizeof query"www.shroomery.org/ythan/proxycheck.php?ip=%s"Info[playerid][IP]);
    
HTTP(playeridHTTP_GETquery"""MyHttpResponse");


    new 
Cache:resultCache:playersettingsDIALOG[844], reason[64];
    
mysql_format(mysqlquerysizeof query"SELECT * FROM `BannedPlayers` WHERE `PlayerName` = '%e' OR `IP` = '%e' OR (`LongIP` != 0 AND (`LongIP` & %i) = %i) LIMIT 1"GetName(playerid), Info[playerid][IP], BAN_MASK, (Ban_GetLongIP(Info[playerid][IP]) & BAN_MASK));
    
result mysql_query(mysqlquery);

    new 
rows cache_num_rows();
    if(
BetText[playerid] == PlayerText:-1)
    {
        
BetText[playerid] = CreatePlayerTextDraw(playerid195.0SLOT_MACHINE_POS_Y+58"~y~Bet: 5$");
        
PlayerTextDrawFont(playeridBetText[playerid], 2);
        
PlayerTextDrawLetterSize(playeridBetText[playerid], 0.350.8);
        
PlayerTextDrawSetShadow(playeridBetText[playerid], 0);
        
PlayerTextDrawSetOutline(playeridBetText[playerid], 1);
    }
    if(
rows) {

        new 
banexpire;
        
cache_get_value_name_int(0"BanExpire"banexpire);

        if(
banexpire gettime() || banexpire == 0) {

            new 
bannedBy[24], BanOnBanExpire;
            
cache_get_value_name(0"BannedBy"bannedBy);
            
cache_get_value_name(0"BanReason"reason);

            
IsBanned[playerid] = 1;

            
strcat(DIALOG"{FF0000}You are banned from the server\n\n");

            
format(querysizeof(query), "{FFFFFF}Username: {FF0000}%s\n"GetName(playerid));
            
strcat(DIALOGquery);

            
format(querysizeof(query), "{FFFFFF}Banned by: {FF0000}%s\n"bannedBy);
            
strcat(DIALOGquery);

            
format(querysizeof(query), "{FFFFFF}Reason: {FF0000}%s\n"reason);
            
strcat(DIALOGquery);
            
cache_get_value_name_int(0"BanOn"BanOn);
            
format(querysizeof(query), "{FFFFFF}Ban date: {FF0000}%s\n"ReturnDate(BanOn));
            
strcat(DIALOGquery);

            
cache_get_value_name_int(0"BanExpire"BanExpire);
            if(
banexpire == 0format(querysizeof(query), "{FFFFFF}Timeleft: {FF0000}PERMANENT\n");
            else 
format(querysizeof(query), "{FFFFFF}End of Ban: {FF0000}%s\n"ReturnEndDate(BanExpire));
            
strcat(DIALOGquery);

            
ShowPlayerDialog(playeridWARNDIALOG_STYLE_MSGBOX"Banned!"DIALOG"Close""");
            
cache_delete(result);
            return 
DelayKick(playerid);
        }
        else {

            
TextDrawShowForPlayer(playeridServerTitle);
            
TextDrawShowForPlayer(playeridServerStar1);
            
TextDrawShowForPlayer(playeridServerStar2);
            
TextDrawShowForPlayer(playeridServerFeatures);
            
TextDrawShowForPlayer(playeridServerExtra);
            
TextDrawShowForPlayer(playeridServerWait);
            
MyTextDraw(playerid);
            
mysql_format(mysqlquerysizeof(query), "DELETE FROM `BannedPlayers` WHERE `PlayerName` = '%e'"GetName(playerid));
            
mysql_tquery(mysqlquery);
            
mysql_format(mysqlquerysizeof query"SELECT `SkipIntro` FROM `PlayerSettings` WHERE `PlayerName` = '%e'"GetName(playerid));
            
playersettings mysql_query(mysqlquery);

            if(
cache_num_rows()) {
                new 
mSkipIntro;
                
cache_get_value_name_int(0"SkipIntro"mSkipIntro);

                if(
mSkipIntro == 1) {

                    
SetTimerEx("StartCameraMovement"10000"ii"playerid1);
                }
                else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);
            }
            else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);

            
cache_delete(playersettings);
        }
    }
    else {

        
cache_delete(result);

        
mysql_format(mysqlquerysizeof query"SELECT * FROM `KickedPlayers` WHERE `PlayerName` = '%e' OR `IP` = '%e' OR (`LongIP` != 0 AND (`LongIP` & %i) = %i) LIMIT 1"GetName(playerid), Info[playerid][IP], BAN_MASK, (Ban_GetLongIP(Info[playerid][IP]) & BAN_MASK));
        
result mysql_query(mysqlquery);

        
rows cache_num_rows();

        if(
rows) {

            new 
kickexpire;
            
cache_get_value_name_int(0"KickExpire"kickexpire);

            if(
kickexpire gettime() && kickexpire != 0) {

                new 
kickedby[24];
                
cache_get_value_name(0"KickedBy"kickedby);
                
cache_get_value_name(0"KickReason"reason);

                
IsBanned[playerid] = 1;

                
strcat(DIALOG"{FF0000}You are kicked from the server\n\n");

                
format(querysizeof(query), "{FFFFFF}Username: {FF0000}%s\n"GetName(playerid));
                
strcat(DIALOGquery);

                
format(querysizeof(query), "{FFFFFF}Kicked by: {FF0000}%s\n"kickedby);
                
strcat(DIALOGquery);

                
format(querysizeof(query), "{FFFFFF}Reason: {FF0000}%s\n"reason);
                
strcat(DIALOGquery);

                
format(querysizeof(query), "{FFFFFF}End of Kick: {FF0000}%s\n"ReturnEndDate(kickexpire));
                
strcat(DIALOGquery);

                
ShowPlayerDialog(playeridWARNDIALOG_STYLE_MSGBOX"Kicked!"DIALOG"Close""");
                
cache_delete(result);
                return 
DelayKick(playerid);
            }
            else {

                
TextDrawShowForPlayer(playeridServerTitle);
                
TextDrawShowForPlayer(playeridServerStar1);
                
TextDrawShowForPlayer(playeridServerStar2);
                
TextDrawShowForPlayer(playeridServerFeatures);
                
TextDrawShowForPlayer(playeridServerExtra);
                
TextDrawShowForPlayer(playeridServerWait);

                
mysql_format(mysqlquerysizeof query"SELECT `SkipIntro` FROM `PlayerSettings` WHERE `PlayerName` = '%e'"GetName(playerid));
                
playersettings mysql_query(mysqlquery);

                if(
cache_num_rows()) {
                    new 
mSkipIntro;
                    
cache_get_value_name_int(0"SkipIntro"mSkipIntro);
                    if(
mSkipIntro == 1) {

                        
SetTimerEx("StartCameraMovement"10000"ii"playerid1);
                    }
                    else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);
                }
                else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);

                
cache_delete(playersettings);
            }
        }
        else {

            
TextDrawShowForPlayer(playeridServerTitle);
            
TextDrawShowForPlayer(playeridServerStar1);
            
TextDrawShowForPlayer(playeridServerStar2);
            
TextDrawShowForPlayer(playeridServerFeatures);
            
TextDrawShowForPlayer(playeridServerExtra);
            
TextDrawShowForPlayer(playeridServerWait);

            
mysql_format(mysqlquerysizeof query"SELECT `SkipIntro` FROM `PlayerSettings` WHERE `PlayerName` = '%e'"GetName(playerid));
            
playersettings mysql_query(mysqlquery);

            if(
cache_num_rows()) {
                new 
mSkipIntro;
                
cache_get_value_name_int(0"SkipIntro"mSkipIntro);

                if(
mSkipIntro == 1) {

                    
SetTimerEx("StartCameraMovement"10000"ii"playerid1);
                }
                else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);
            }
            else 
SetTimerEx("StartCameraMovement"10000"ii"playerid0);

            
cache_delete(playersettings);
        }
    }
    
cache_delete(result);

    
mysql_format(mysqlquerysizeof(query), "UPDATE `playersdata` SET `Online` = 1 WHERE `PlayerName` = '%e'"GetName(playerid));
    
mysql_tquery(mysqlquery);

    
mysql_format(mysqlquerysizeof(query), "UPDATE `Market` SET `Status` = 1 WHERE `Seller` = '%e'"GetName(playerid));
    
mysql_tquery(mysqlquery);

    
FailMis(playerid);
    
TimeTD[playerid] = CreatePlayerTextDraw(playerid603.125000100.749938"Time Left: 12:00");
    
PlayerTextDrawLetterSize(playeridTimeTD[playerid], 0.4000001.600000);
    
PlayerTextDrawAlignment(playeridTimeTD[playerid], 3);
    
PlayerTextDrawSetOutline(playeridTimeTD[playerid], -3);
    
PlayerTextDrawFont(playeridTimeTD[playerid], 1);
    
PlayerTextDrawBackgroundColor(playeridTimeTD[playerid], 0);

    
AWH_ResetPlayerWeapons(playerid);
    
SetPlayerColor(playeridCOLOR_NULL);
    
LoadTd(playerid);
    
House_PlayerInit(playerid);
    
Player_Init(playerid);
    
Trash_InitPlayer(playerid);
    
Robbery_InitPlayer(playerid);
    
Iter_Clear(PrivateVehicles[playerid]);
    
gettime(serverhour,serverminute);
    
SetPlayerTime(playeridserverhourserverminute);
    
/*EnableAntiCheatForPlayer(playerid, 2, 0);
    EnableAntiCheatForPlayer(playerid, 3, 0);
    EnableAntiCheatForPlayer(playerid, 4, 0);
    EnableAntiCheatForPlayer(playerid, 5, 0);
    EnableAntiCheatForPlayer(playerid, 6, 0);*/
    
PlayerTextDraw(playerid);
    
HideCasinoTDs(playerid);

    for(new 
isizeof(DropPoints); i++) {

        
DestroyDynamicMapIcon(PointIcons[playerid][i]);
        
TogglePlayerDynamicCP(playeridDropPoints[i][PointCP], 0);
    }
    for(new 
isizeof(FactoryData); i++) {

        
DestroyDynamicMapIcon(FactoryIcons[playerid][i]);
        
TogglePlayerDynamicCP(playeridFactoryData[i][FactoryCP], 0);
    }
    for(new 
isizeof(PoliceDepartments); i++) {

        
TogglePlayerDynamicCP(playeridPoliceDepartments[i][pdPickup], 0);
    }
    
Info[playerid][AutoLogin] = 0;
    
Info[playerid][AutoLogin] = Info[playerid][Level] = Info[playerid][Kills] = Info[playerid][Deaths] = Info[playerid][Suicides] = Info[playerid][Hours] = Info[playerid][Minutes] =
    
Info[playerid][Seconds] = Info[playerid][Tokens] = Info[playerid][Marijuana] = Info[playerid][Seeds] = Info[playerid][Cocaine] = Info[playerid][Premium] = Info[playerid][PremiumExpires] =
    
Info[playerid][NameChange] = Info[playerid][NextChange] = Info[playerid][FightStyle] = Info[playerid][xLevel] = Info[playerid][XP] = Info[playerid][WantedLevel] = Info[playerid][Muted] =
    
Info[playerid][Jailed] = Info[playerid][Hitman] = Info[playerid][Jetpack] = Info[playerid][JetpackExpire]  = Info[playerid][Logged] = Info[playerid][Registered] = Info[playerid][Frozen] =
    
Info[playerid][DMZone] = Info[playerid][Spec] = Info[playerid][NameTagHidden] = Info[playerid][MoneyBags] = Info[playerid][Move] = Info[playerid][Friends] = Info[playerid][NameTagHidden] =
    
Info[playerid][InDM] = Info[playerid][ParamedicSkills] = /*Info[playerid][CashCourierSkills] =*/ Info[playerid][IceCreamSkills] = Info[playerid][HotdogSkills] =  Info[playerid][SweeperSkills] = Info[playerid][MiningSkills] =
    
Info[playerid][TrashSkills] = Info[playerid][BusSkills] = Info[playerid][ThiefSkills] = Info[playerid][TraderSkills] = Info[playerid][TDM] = Info[playerid][Derby] = Info[playerid][Parkour] = Info[playerid][Skydive] = Info[playerid][Reactions] =
    
Info[playerid][Skills][GROVE] = Info[playerid][Skills][BALLAS] = Info[playerid][Skills][VAGOS] = Info[playerid][Skills][AZTECAS] = Info[playerid][Skills][BIKERS] = Info[playerid][Skills][TRIADS] =
    
Info[playerid][Skills][MAFIA] = Info[playerid][Skills][RIFA] = Info[playerid][Skills][NANG] = Info[playerid][Robbed] = Info[playerid][Lotteries] = Info[playerid][Packages] = Info[playerid][PostmanSkills] =
    
Info[playerid][PlayerSpawn] = Info[playerid][Warn] =  Info[playerid][WantedLevel] = 0;

    
pLastMsg[playerid] = !"fghsfhdf";
    
pProtectTick[playerid] = 0;
    
onDeath[playerid] = 0;
    
AbuseTick[playerid] = 0;
    
IsPaused[playerid] = 0;
    
pTick[playerid] = 0;
    
StartTimer[playerid] = 0;
    
SpecID[playerid] = INVALID_PLAYER_ID;
    
pTickWarnings[playerid] = 0;
    
HackWarnings[playerid] = 0;
    
MuteCounter[playerid] = 0;
    
InAmmu[playerid] = 0;
    
gPlayer_AmmuCoolDown[playerid] = 0;
    
gPlayer_Ammunation[playerid] = 225;
    
CountDeaths[playerid] = 0;
    
StartDeathTick[playerid] = 0;
    
InSelfie[playerid] = 0;
    
GotJetpack[playerid] = 0;
    
attempts[playerid] = 0;
    
LastPm[playerid] = INVALID_PLAYER_ID;
    
PMEnabled[playerid] = 0;
    
KillStreak[playerid] = 0;
    
InEvent[playerid] = 0;
    
InDerby[playerid] = 0;
    
InTDM[playerid] = 0;
    
InParkour[playerid] = 0;
    
InSkydive[playerid] = 0;
    
InStunt[playerid] = 0;
    
God[playerid][0] = 0;
    
God[playerid][1] = 0;
    
InShooter[playerid] = 0;
    
LocateVehicleModel[playerid] = -1;
    
bStationID[playerid] = 0;
    
bStationCheckpoint[playerid] = 0;
    
SelectedPlayer[playerid] = INVALID_PLAYER_ID;
    
SelectedWeapon[playerid] = -1;
    
SelectedAmmo[playerid] = -1;
    
SelectedMoney[playerid] = -1;
    
ClassDisabled[playerid] = false;
    
SpawnEx[playerid] = 0;
    
RaceCheckpoint[playerid] = 0;
    
SelectCheckpoints[playerid] = 0;
    
isPlayerMVP[playerid] = 0;
    
HideText[playerid] = 0;
    
HideRobbery[playerid] = 0;
    
PMAlert[playerid] = 0;
    
BlockStats[playerid] = 0;
    
MapHide[playerid] = 0;
    
KickNotif[playerid] = 0;
    
VoteNotif[playerid] = 0;
    
ConnectionNotif[playerid] = 0;
    
TeamChat[playerid] = 0;
    
FriendsChat[playerid] = 0;
    
PremiumChat[playerid] = 0;
    
DiceRequest[playerid] = 0;
    
KillList[playerid] = 0;
    
UnlockHouses[playerid] = 0;
    
UnlockVehicles[playerid] = 0;
    
SkipIntro[playerid] = 0;
    
LotteryType[playerid] = 0;
    
HideDuty[playerid] = 0;
    
CrazyVehicle[playerid] = 0;
    
MapTeleport[playerid] = 0;
    
WeaponTeleport[playerid] = 0;
    
VehicleGod[playerid] = 0;
    
DisplayPMs[playerid] = 0;
    
DisplayCMDs[playerid] = 0;
    
DisplayHelperChat[playerid] = 0;
    
DisplayCheatLogs[playerid] = 0;
    
DisplayTeamsChat[playerid] = 0;
    
DisplayFriendsChat[playerid] = 0;
    
DisplayLocalChat[playerid] = 0;
    
PlayerColor[playerid][0] = "0xFFFFFFFF";
    
PlayerColor[playerid][1] = "FFFFFF";
    
TextColor[playerid] = "FFFFFF";
    
isCallingVehicle[playerid] = false;
    
PlayerHouseMoney[playerid] = 0;
    
PacketType[playerid] = 0;
    
PacketPayout[playerid] = 0;
    
PacketCustomer[playerid] = 0;
    
HoldingBox[playerid] = 0;
    
PlayerMarker[playerid] = -1;
    
UsingRadio[playerid] = false;
    
ObjectLayer[playerid] = 0;
    
DiceID[playerid] = INVALID_PLAYER_ID;
    
onCheck[playerid] = -1;
    
SelectedObject[playerid] = -1;
    
Modifying[playerid] = 0;
    
IsPlayerUsingAirstrike[playerid] = -1;
    
gPlayerUsingLoopingAnim[playerid] = 0;
    
gPlayerAnimLibsPreloaded[playerid] = 0;
    
IsCuffed[playerid] = 0;
    
CuffedBy[playerid] = INVALID_PLAYER_ID;
    
CriminalCooldown[playerid] = 0;
    
LastCriminal[playerid] = INVALID_PLAYER_ID;
    
LastHit[playerid] = INVALID_PLAYER_ID;
    
PlayMine[playerid] = 0;
    
BetAmount[playerid] = 0;
    
Mines[playerid] = 0;
    
StartedGame[playerid] = 0;
    
MineType[playerid] = 0;
    
MoneyEarned[playerid] = 0;
    
Loser[playerid] = 0;
    
Cash[playerid] = 0;
    
Pstats[playerid][CashC] = 0;
    
Pstats[playerid][ClothesT] = 0;
   
// horseshoe[playerid] = 0;
    
Pstats[playerid][ThiefF] = 0;
    
Pstats[playerid][ThiefG] = 0;
    
Pstats[playerid][ThiefC] = 0;
    
Pstats[playerid][FoodT] = 0;
    
Pstats[playerid][GunsT] = 0;
    
HitSound[playerid] = 0;

    for(new 
i12i++)
        
Cooldown[playerid][i] = 0;

    for(new 
iMAX_ATTACHMENTSji++)
        
oInfo[playerid][i][used1] = false;

    foreach(new 
Player) {

        
LastHitTick[playerid][x] = 0;// i can control leave me
        
LastHitTick[x][playerid] = 0;

        
BlockedPlayer[playerid][x] = 0;
        
BlockedPlayer[x][playerid] = 0;

        for(new 
i2i++)
            
JobCoolDown[playerid][x][i] = 0;
    }

    for(new 
1GetVehiclePoolSize(); <= ji++)
        
PlayerCar[playerid][i] = INVALID_VEHICLE_ID;

    
ptInfoBox[playerid] = CreatePlayerTextDraw(playerid22.500000137.199981"");
    
PlayerTextDrawLetterSize(playeridptInfoBox[playerid], 0.5220001.907998);
    
PlayerTextDrawTextSize(playeridptInfoBox[playerid], 217.00000010.640000);
    
PlayerTextDrawAlignment(playeridptInfoBox[playerid], 1);
    
PlayerTextDrawColor(playeridptInfoBox[playerid], -120);
    
PlayerTextDrawUseBox(playeridptInfoBox[playerid], true);
    
PlayerTextDrawBoxColor(playeridptInfoBox[playerid], 136);
    
PlayerTextDrawSetShadow(playeridptInfoBox[playerid], 0);
    
PlayerTextDrawSetOutline(playeridptInfoBox[playerid], -1);
    
PlayerTextDrawBackgroundColor(playeridptInfoBox[playerid], 51);
    
PlayerTextDrawFont(playeridptInfoBox[playerid], 1);
    
PlayerTextDrawSetProportional(playeridptInfoBox[playerid], 1);

    
TimeLeft[playerid] = CreatePlayerTextDraw(playerid483.200042253.119995"");
    
PlayerTextDrawLetterSize(playeridTimeLeft[playerid], 0.6259982.122663);
    
PlayerTextDrawAlignment(playeridTimeLeft[playerid], 1);
    
PlayerTextDrawColor(playeridTimeLeft[playerid], -1);
    
PlayerTextDrawSetShadow(playeridTimeLeft[playerid], 0);
    
PlayerTextDrawSetOutline(playeridTimeLeft[playerid], 2);
    
PlayerTextDrawBackgroundColor(playeridTimeLeft[playerid], 51);
    
PlayerTextDrawFont(playeridTimeLeft[playerid], 1);
    
PlayerTextDrawSetProportional(playeridTimeLeft[playerid], 1);

    
BPayout[playerid] = CreatePlayerTextDraw(playerid45.000000225.679718"Payout $5,000,000~n~+50 XP");
    
PlayerTextDrawLetterSize(playeridBPayout[playerid], 0.2639991.347999);
    
PlayerTextDrawAlignment(playeridBPayout[playerid], 1);
    
PlayerTextDrawColor(playeridBPayout[playerid], -383057665);
    
PlayerTextDrawSetShadow(playeridBPayout[playerid], 0);
    
PlayerTextDrawSetOutline(playeridBPayout[playerid], 1);
    
PlayerTextDrawBackgroundColor(playeridBPayout[playerid], 51);
    
PlayerTextDrawFont(playeridBPayout[playerid], 1);
    
PlayerTextDrawSetProportional(playeridBPayout[playerid], 1);

    
SpectateTextDraw[playerid] = CreatePlayerTextDraw(playerid20.614887134.750000"Name:");
    
PlayerTextDrawLetterSize(playeridSpectateTextDraw[playerid], 0.2527521.185832);
    
PlayerTextDrawAlignment(playeridSpectateTextDraw[playerid], 1);
    
PlayerTextDrawColor(playeridSpectateTextDraw[playerid], -1);
    
PlayerTextDrawSetShadow(playeridSpectateTextDraw[playerid], 0);
    
PlayerTextDrawSetOutline(playeridSpectateTextDraw[playerid], 1);
    
PlayerTextDrawBackgroundColor(playeridSpectateTextDraw[playerid], 51);
    
PlayerTextDrawFont(playeridSpectateTextDraw[playerid], 1);
    
PlayerTextDrawSetProportional(playeridSpectateTextDraw[playerid], 1);

    
Notif[playerid] = CreatePlayerTextDraw(playerid331.000000333.200012"Press RETURN to hang up the phone");
    
PlayerTextDrawLetterSize(playeridNotif[playerid], 0.4904981.751199);
    
PlayerTextDrawTextSize(playeridNotif[playerid], 5974.500000616.932800);
    
PlayerTextDrawUseBox(playeridNotif[playerid], 0);
    
PlayerTextDrawAlignment(playeridNotif[playerid], 2);
    
PlayerTextDrawColor(playeridNotif[playerid], -1);
    
PlayerTextDrawSetShadow(playeridNotif[playerid], 0);
    
PlayerTextDrawSetOutline(playeridNotif[playerid], 1);
    
PlayerTextDrawBackgroundColor(playeridNotif[playerid], 255);
    
PlayerTextDrawFont(playeridNotif[playerid], 1);
    
PlayerTextDrawSetProportional(playeridNotif[playerid], 1);

    
VehicleSpeedo CreatePlayerTextDraw(playerid,510.000000406.000000"~g~KM/H: ~w~120   ~r~Health");
    
PlayerTextDrawBackgroundColor(playerid,VehicleSpeedo255);
    
PlayerTextDrawFont(playerid,VehicleSpeedo1);
    
PlayerTextDrawLetterSize(playerid,VehicleSpeedo0.2600001.000000);
    
PlayerTextDrawColor(playerid,VehicleSpeedo, -1);
    
PlayerTextDrawSetOutline(playerid,VehicleSpeedo0);
    
PlayerTextDrawSetProportional(playerid,VehicleSpeedo1);
    
PlayerTextDrawSetShadow(playerid,VehicleSpeedo1);
    
PlayerTextDrawSetSelectable(playerid,VehicleSpeedo0);

    
JailTextdraw[playerid] = CreatePlayerTextDraw(playerid510.000000406.000000"~g~Jailed: ~w~1:20");
    
PlayerTextDrawBackgroundColor(playeridJailTextdraw[playerid], 255);
    
PlayerTextDrawFont(playeridJailTextdraw[playerid], 1);
    
PlayerTextDrawLetterSize(playeridJailTextdraw[playerid], 0.2600001.000000);
    
PlayerTextDrawColor(playeridJailTextdraw[playerid], -1);
    
PlayerTextDrawSetOutline(playeridJailTextdraw[playerid], 0);
    
PlayerTextDrawSetProportional(playeridJailTextdraw[playerid], 1);
    
PlayerTextDrawSetShadow(playeridJailTextdraw[playerid], 1);
    
PlayerTextDrawSetSelectable(playeridJailTextdraw[playerid], 0);

    
CapacityText[playerid] = CreatePlayerTextDraw(playerid32.000000290.000000"Vehicle Capacity (0/10)");
    
PlayerTextDrawBackgroundColor(playeridCapacityText[playerid], 255);
    
PlayerTextDrawFont(playeridCapacityText[playerid], 1);
    
PlayerTextDrawLetterSize(playeridCapacityText[playerid], 0.2000001.000000);
    
PlayerTextDrawColor(playeridCapacityText[playerid], -1);
    
PlayerTextDrawSetOutline(playeridCapacityText[playerid], 1);
    
PlayerTextDrawSetProportional(playeridCapacityText[playerid], 1);
    
PlayerTextDrawSetSelectable(playeridCapacityText[playerid], 0);

    
ColorText[playerid] = CreatePlayerTextDraw(playerid,317.000000150.000000"_");
    
PlayerTextDrawAlignment(playerid,ColorText[playerid], 2);
    
PlayerTextDrawBackgroundColor(playerid,ColorText[playerid], 255);
    
PlayerTextDrawFont(playerid,ColorText[playerid], 2);
    
PlayerTextDrawLetterSize(playerid,ColorText[playerid], 0.7000003.000000);
    
PlayerTextDrawColor(playerid,ColorText[playerid], -1);
    
PlayerTextDrawSetOutline(playerid,ColorText[playerid], 1);
    
PlayerTextDrawSetProportional(playerid,ColorText[playerid], 1);
    
PlayerTextDrawSetSelectable(playerid,ColorText[playerid], 0);

    
SetPVarString(playerid"SettingTxt""Click_to_set");
    
SetPVarString(playerid"SettingTxd""Click_to_set");
    
SetPVarInt(playerid"SettingIdx"0);
    
SetPVarInt(playerid"SettingModel"11111);
    
ObjTextdraw[playerid] = PlayerText:INVALID_TEXT_DRAW;
    for(new 
0sizeof(objinfo[]); ++) objinfo[playerid][i] = PlayerText:INVALID_TEXT_DRAW;
    
//===SETTIMER ON PLAYERCONNECT WANTADSTARS=============
    
timerWantedRemover[playerid] = SetTimerEx("WantedRemover"120000true"i"playerid);
    
be_FirstSpawn[playerid] = true;
    
//Fishing System
    /* Fishing Pier stuff removed */
    
RemoveBuildingForPlayer(playerid6463389.7734, -2028.468819.80470.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2028.500032.22660.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2021.640629.92970.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2017.453124.03130.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2017.429716.85160.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2021.632810.98440.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2028.51568.78130.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2035.398410.94530.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2039.640616.84380.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2039.656324.10940.25);
    
RemoveBuildingForPlayer(playerid3751389.8750, -2035.382829.95310.25);
    
RemoveBuildingForPlayer(playerid1232364.6094, -2036.17979.50000.25);
    
RemoveBuildingForPlayer(playerid1280378.4609, -2012.92977.21090.25);
    
RemoveBuildingForPlayer(playerid1215386.5703, -2061.95317.37500.25);
    
RemoveBuildingForPlayer(playerid1215379.5938, -2042.49227.37500.25);
    
RemoveBuildingForPlayer(playerid1215379.5938, -2016.75007.37500.25);
    
RemoveBuildingForPlayer(playerid1215386.5703, -2049.35167.37500.25);
    
RemoveBuildingForPlayer(playerid1340388.8594, -2071.66417.94530.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2039.640616.84380.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2039.656324.10940.25);
    
RemoveBuildingForPlayer(playerid6298389.7734, -2028.468819.80470.25);
    
RemoveBuildingForPlayer(playerid6461389.7734, -2028.500020.10940.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2028.500032.22660.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2021.640629.92970.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2017.453124.03130.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2017.429716.85160.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2021.632810.98440.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2028.51568.78130.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2035.398410.94530.25);
    
RemoveBuildingForPlayer(playerid3752389.8750, -2035.382829.95310.25);
    
//____________________MACG_________________________
    
return 1;

MacGyverr is offline   Reply With Quote
Old 31/05/2019, 06:22 PM   #10
MacGyverr
Little Clucker
 
Join Date: Aug 2014
Posts: 49
Reputation: 3
Default Re: Problem with MYSQL

Can u help me?
MacGyverr is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password Hash Problem & MYSQL Saving Problem Faqahat Scripting Help 3 18/04/2016 12:54 PM
[PLUGIN]: MySQL Problem (MYSQL R39-2) zT KiNgKoNg Scripting Help 11 11/11/2014 07:20 PM
[Mysql problem] Loss of communication with the mysql base SmileyCoder General 0 29/05/2014 04:38 PM
saving system mysql(not mysql problem) martoivanov Scripting Help 0 29/08/2013 04:37 PM
Problem with reading money from MySQL in "Clean, Simple MySQL GM" by L3th4l Dystans Help Archive 1 31/05/2011 10:19 PM


All times are GMT. The time now is 01:51 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.