1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Linear Mode
Mysql debug error
catamarg1
Big Clucker
***
Posts: 96
Threads: 4
Joined: Nov 2010
Reputation: 0
#5

08.05.2012, 13:13
Onplayerconnect

Quote:

new qstr[100];format(qstr,100,"SELECT * FROM `players` WHERE `name`='%s';",plname);
mysql_query(qstr);
mysql_store_result();
if(mysql_num_rows() != 0)
{
Var[gPlayerAccount][playerid] = 1;
}
else
{
Var[gPlayerAccount][playerid] = 0;
}
mysql_free_result();
return 1;
}
And login dialog!
Quote:

if(response)
{
if(dialogid == 12346 || dialogid == 12347)
{
if(strlen(inputtext))
{
new tmppass[64];
strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
//Encrypt(tmppass);
OnPlayerLogin(playerid,tmppass);
new playersip[24];
GetPlayerIp(playerid, playersip, sizeof(playersip));
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
if(IsPlayerNPC(playerid)) return 0;

new y, m, d;
new h,mi,s;
getdate(y,m,d);
gettime(h,mi,s);
format(string,sizeof(string), "[%02d/%02d/%02d || %02d:%02d:%02d] %s s-a logat cu ip: %s.",d,m,y,h,mi,s,playername2,playersip);
LoginLog(string);
}
else
{
new playersip[24];
GetPlayerIp(playerid, playersip, sizeof(playersip));
new loginstring[256];
new loginname[64];
GetPlayerName(playerid,loginname,sizeof(loginname) );
format(loginstring,sizeof(loginstring),""wh"Aceast a parola nu este corecta. Re-incerca sa bagi parola:\n\n"wh"IP-ul tau: "color_yellow"%s",playersip);
ShowPlayerDialog(playerid,12347,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit");
Var[gPlayerLogTries][playerid] += 1;
if(Var[gPlayerLogTries][playerid] == 3) { SCM ( playerid , COLOR_WHITE , "Ai luat kick pentru ca ai bagat parola de 3 ori gresita !" ) ; Kick(playerid); }
}
}
and Onplayerregister
Quote:

public OnPlayerRegister(playerid, password[])
{
if(IsPlayerConnected(playerid))
{
new playername3[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername3, sizeof(playername3));
new Str[ 100 ];
format(Str, 100 ,"INSERT INTO `players` (`name`,`Password`)VALUES('%s','%s')",playername3, password);
mysql_query(Str);
strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255);
PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
if(Var[ChangePass][playerid] == 0)
{
new playersip[24];
GetPlayerIp(playerid, playersip, sizeof(playersip));
new loginstring[256];
new loginname[64];
GetPlayerName(playerid,loginname,sizeof(loginname) );
format(loginstring,sizeof(loginstring),""wh"Bine ai venit, "color_green"%s"wh" .Tasteaza parola pentru a te loga:\n\n"wh"IP-ul tau: "color_yellow"%s",loginname,playersip);
ShowPlayerDialog(playerid,12346,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit");
return 1;
}

}
return 1;
}
and on player login
Quote:

public OnPlayerLogin(playerid,password[])
{
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
new qstr[100];
new result[100];
new string2[256];
format(qstr,100,"SELECT * FROM `players` WHERE `name`='%s' AND `Password`='%s'",playername2,password);
mysql_query(qstr);
mysql_store_result();
if(mysql_num_rows() != 0)
{
if(mysql_retrieve_row ())
{
mysql_fetch_field_row(result,"Level"); PlayerInfo[playerid][pLevel] = strval(result);
mysql_fetch_field_row(result,"AdminLevel"); PlayerInfo[playerid][pAdmin] = strval(result);
mysql_fetch_field_row(result,"VipLevel"); PlayerInfo[playerid][pVip] = strval(result);
mysql_fetch_field_row(result,"Helper"); PlayerInfo[playerid][pHelper] = strval(result);
mysql_fetch_field_row(result,"DonateRank"); PlayerInfo[playerid][pDonateRank] = strval(result);
mysql_fetch_field_row(result,"UpgradePoints"); PlayerInfo[playerid][gPupgrade] = strval(result);
mysql_fetch_field_row(result,"ConnectedTime"); PlayerInfo[playerid][pConnectTime] = strval(result);
mysql_fetch_field_row(result,"Registered"); PlayerInfo[playerid][pReg] = strval(result);
mysql_fetch_field_row(result,"Sex"); PlayerInfo[playerid][pSex] = strval(result);
mysql_fetch_field_row(result,"Age"); PlayerInfo[playerid][pAge] = strval(result);
mysql_fetch_field_row(result,"Origin"); PlayerInfo[playerid][pOrigin] = strval(result);
mysql_fetch_field_row(result,"CK"); PlayerInfo[playerid][pCK] = strval(result);
mysql_fetch_field_row(result,"Muted"); PlayerInfo[playerid][pMuted] = strval(result);
mysql_fetch_field_row(result,"MuteTime"); PlayerInfo[playerid][pMuteTime] = strval(result);
mysql_fetch_field_row(result,"Respect"); PlayerInfo[playerid][pExp] = strval(result);
mysql_fetch_field_row(result,"Money"); PlayerInfo[playerid][pCash] = strval(result);
mysql_fetch_field_row(result,"Bank"); PlayerInfo[playerid][pAccount] = strval(result);
mysql_fetch_field_row(result,"Crimes"); PlayerInfo[playerid][pCrimes] = strval(result);
mysql_fetch_field_row(result,"Kills"); PlayerInfo[playerid][pKills] = strval(result);
mysql_fetch_field_row(result,"Deaths"); PlayerInfo[playerid][pDeaths] = strval(result);
mysql_fetch_field_row(result,"Arrested"); PlayerInfo[playerid][pArrested] = strval(result);
mysql_fetch_field_row(result,"WantedDeaths"); PlayerInfo[playerid][pWantedDeaths] = strval(result);
mysql_fetch_field_row(result,"Phonebook"); PlayerInfo[playerid][pPhoneBook] = strval(result);
mysql_fetch_field_row(result,"LottoNr"); PlayerInfo[playerid][pLottoNr] = strval(result);
mysql_fetch_field_row(result,"Car"); PlayerInfo[playerid][pPcarkey] = strval(result);
mysql_fetch_field_row(result,"Heli"); PlayerInfo[playerid][pPhelikey] = strval(result);
mysql_fetch_field_row(result,"Moto"); PlayerInfo[playerid][pPmotokey] = strval(result);
mysql_fetch_field_row(result,"Fishes"); PlayerInfo[playerid][pFishes] = strval(result);
mysql_fetch_field_row(result,"BiggestFish"); PlayerInfo[playerid][pBiggestFish] = strval(result);
mysql_fetch_field_row(result,"Job"); PlayerInfo[playerid][pJob] = strval(result);
mysql_fetch_field_row(result,"Clock"); PlayerInfo[playerid][pClock] = strval(result);
mysql_fetch_field_row(result,"Smoke"); PlayerInfo[playerid][pSmoke] = strval(result);
mysql_fetch_field_row(result,"Color"); PlayerInfo[playerid][pColor] = strval(result);
mysql_fetch_field_row(result,"PaintJob"); PlayerInfo[playerid][pPaintJob] = strval(result);
mysql_fetch_field_row(result,"Beer"); PlayerInfo[playerid][pBeer] = strval(result);
mysql_fetch_field_row(result,"Referer"); PlayerInfo[playerid][pReferer] = strval(result);
mysql_fetch_field_row(result,"SpawnChange"); PlayerInfo[playerid][pSpawnChange] = strval(result);
mysql_fetch_field_row(result,"Admkicks"); PlayerInfo[playerid][pAdmkicks] = strval(result);
mysql_fetch_field_row(result,"Admbans"); PlayerInfo[playerid][pAdmbans] = strval(result);
mysql_fetch_field_row(result,"Admwarns"); PlayerInfo[playerid][pAdmwarns] = strval(result);
mysql_fetch_field_row(result,"Admallcmds"); PlayerInfo[playerid][pAdmallcmds] = strval(result);
mysql_fetch_field_row(result,"TowCarReg"); PlayerInfo[playerid][pTowCarReg] = strval(result);
mysql_fetch_field_row(result,"Speedo"); PlayerInfo[playerid][pSpeedo] = strval(result);
mysql_fetch_field_row(result,"Robbing"); PlayerInfo[playerid][pRobbed] = strval(result);
mysql_fetch_field_row(result,"Robbed"); PlayerInfo[playerid][pRobbing] = strval(result);
mysql_fetch_field_row(result,"CRReport"); PlayerInfo[playerid][pCRReport] = strval(result);
mysql_fetch_field_row(result,"CRNeedHelp"); PlayerInfo[playerid][pCRNeedHelp] = strval(result);
mysql_fetch_field_row(result,"SaveWalk"); PlayerInfo[playerid][pSaveWalk] = strval(result);
mysql_fetch_field_row(result,"Paycheck"); PlayerInfo[playerid][pPayCheck] = strval(result);
mysql_fetch_field_row(result,"HeadValue"); PlayerInfo[playerid][pHeadValue] = strval(result);
mysql_fetch_field_row(result,"Jailed"); PlayerInfo[playerid][pJailed] = strval(result);
mysql_fetch_field_row(result,"JailTime"); PlayerInfo[playerid][pJailTime] = strval(result);
mysql_fetch_field_row(result,"BlackList"); PlayerInfo[playerid][pBlackList] = strval(result);
mysql_fetch_field_row(result,"BlackListTime"); PlayerInfo[playerid][pBLTime] = strval(result);
mysql_fetch_field_row(result,"Materials"); PlayerInfo[playerid][pMats] = strval(result);
mysql_fetch_field_row(result,"Drugs"); PlayerInfo[playerid][pDrugs] = strval(result);
mysql_fetch_field_row(result,"Leader"); PlayerInfo[playerid][pLeader] = strval(result);
mysql_fetch_field_row(result,"Member"); PlayerInfo[playerid][pMember] = strval(result);
mysql_fetch_field_row(result,"Rank"); PlayerInfo[playerid][pRank] = strval(result);
mysql_fetch_field_row(result,"cChar"); PlayerInfo[playerid][pChar] = strval(result);
mysql_fetch_field_row(result,"ContractTime"); PlayerInfo[playerid][pContractTime] = strval(result);
mysql_fetch_field_row(result,"DetSkill"); PlayerInfo[playerid][pDetSkill] = strval(result);
mysql_fetch_field_row(result,"SexSkill"); PlayerInfo[playerid][pSexSkill] = strval(result);
mysql_fetch_field_row(result,"BoxSkill"); PlayerInfo[playerid][pBoxSkill] = strval(result);
mysql_fetch_field_row(result,"LawSkill"); PlayerInfo[playerid][pLawSkill] = strval(result);
mysql_fetch_field_row(result,"MechSkill"); PlayerInfo[playerid][pMechSkill] = strval(result);
mysql_fetch_field_row(result,"JackSkill"); PlayerInfo[playerid][pJackSkill] = strval(result);
mysql_fetch_field_row(result,"CarSkill"); PlayerInfo[playerid][pCarSkill] = strval(result);
mysql_fetch_field_row(result,"NewsSkill"); PlayerInfo[playerid][pNewsSkill] = strval(result);
mysql_fetch_field_row(result,"DrugsSkill"); PlayerInfo[playerid][pDrugsSkill] = strval(result);
mysql_fetch_field_row(result,"CookSkill"); PlayerInfo[playerid][pCookSkill] = strval(result);
mysql_fetch_field_row(result,"FishSkill"); PlayerInfo[playerid][pFishSkill] = strval(result);
mysql_fetch_field_row(result,"pSHealth"); PlayerInfo[playerid][pSHealth] = floatstr(result);
mysql_fetch_field_row(result,"iInt"); PlayerInfo[playerid][pInt] = strval(result);
mysql_fetch_field_row(result,"VWorld"); PlayerInfo[playerid][pWorld] = strval(result);
mysql_fetch_field_row(result,"Local"); PlayerInfo[playerid][pLocal] = strval(result);
mysql_fetch_field_row(result,"Team"); PlayerInfo[playerid][pTeam] = strval(result);
mysql_fetch_field_row(result,"Model"); PlayerInfo[playerid][pModel] = strval(result);
mysql_fetch_field_row(result,"PhoneNr"); PlayerInfo[playerid][pPnumber] = strval(result);
mysql_fetch_field_row(result,"House"); PlayerInfo[playerid][pPhousekey] = strval(result);
mysql_fetch_field_row(result,"Bizz"); PlayerInfo[playerid][pPbiskey] = strval(result);
mysql_fetch_field_row(result,"CarLic"); PlayerInfo[playerid][pCarLic] = strval(result);
mysql_fetch_field_row(result,"FlyLic"); PlayerInfo[playerid][pFlyLic] = strval(result);
mysql_fetch_field_row(result,"BoatLic"); PlayerInfo[playerid][pBoatLic] = strval(result);
mysql_fetch_field_row(result,"FishLic"); PlayerInfo[playerid][pFishLic] = strval(result);
mysql_fetch_field_row(result,"GunLic"); PlayerInfo[playerid][pGunLic] = strval(result);
mysql_fetch_field_row(result,"Fighting"); PlayerInfo[playerid][pFS] = strval(result);
mysql_fetch_field_row(result,"CarTime"); PlayerInfo[playerid][pCarTime] = strval(result);
mysql_fetch_field_row(result,"MotoLic"); PlayerInfo[playerid][pMotoLic] = strval(result);
mysql_fetch_field_row(result,"CDPlayer"); PlayerInfo[playerid][pCDPlayer] = strval(result);
mysql_fetch_field_row(result,"Wins"); PlayerInfo[playerid][pWins] = strval(result);
mysql_fetch_field_row(result,"Loses"); PlayerInfo[playerid][pLoses] = strval(result);
mysql_fetch_field_row(result,"AlcoholPerk"); PlayerInfo[playerid][pAlcoholPerk] = strval(result);
mysql_fetch_field_row(result,"DrugPerk"); PlayerInfo[playerid][pDrugPerk] = strval(result);
mysql_fetch_field_row(result,"MiserPerk"); PlayerInfo[playerid][pMiserPerk] = strval(result);
mysql_fetch_field_row(result,"PainPerk"); PlayerInfo[playerid][pPainPerk] = strval(result);
mysql_fetch_field_row(result,"TraderPerk"); PlayerInfo[playerid][pTraderPerk] = strval(result);
mysql_fetch_field_row(result,"Tutorial"); PlayerInfo[playerid][pTut] = strval(result);
mysql_fetch_field_row(result,"Mission"); PlayerInfo[playerid][pMissionNr] = strval(result);
mysql_fetch_field_row(result,"Warnings"); PlayerInfo[playerid][pWarns] = strval(result);
mysql_fetch_field_row(result,"Fwarn"); PlayerInfo[playerid][pFwarn] = strval(result);
mysql_fetch_field_row(result,"AdminWarnings"); PlayerInfo[playerid][pAWarns] = strval(result);
mysql_fetch_field_row(result,"Fuel"); PlayerInfo[playerid][pFuel] = strval(result);
mysql_fetch_field_row(result,"WantedLevel"); Var[WantedLevel][playerid] = strval(result);
mysql_fetch_field_row(result,"Married"); PlayerInfo[playerid][pMarried] = strval(result);
mysql_fetch_field_row(result,"MarriedTo"); strmid(PlayerInfo[playerid][pMarriedTo], result, 0, strlen(result)-1, 255);
mysql_fetch_field_row(result,"NameChanged"); PlayerInfo[playerid][pNameChanged] = strval(result);
}
}
else
{
new playersip[24];
GetPlayerIp(playerid, playersip, sizeof(playersip));
new loginstring[256];
new loginname[64];
if(Var[gPlayerLogTries][playerid] == 3) { SCM ( playerid , COLOR_WHITE , "Ai luat kick pentru ca ai bagat parola de 3 ori gresita !" ) ; Kick(playerid);}
GetPlayerName(playerid,loginname,sizeof(loginname) );
format(loginstring,sizeof(loginstring),""wh"Aceast a parola nu este corecta. Re-incerca sa bagi parola:\n\n"wh"IP-ul tau: "color_yellow"%s",playersip);
ShowPlayerDialog(playerid,12347,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit");
Var[gPlayerLogTries][playerid] += 1;
mysql_free_result();
return 1;
}
mysql_free_result();
ClearVipChat(playerid);
ClearVipChat(playerid);
if(PlayerInfo[playerid][pNameChanged] == 1)
{
SCM(playerid, COLOR_LIGHTRED, "Acest cont este blocat deoarece i-a fost schimbat numele.");
Kick(playerid);
}
if(PlayerInfo[playerid][pNameChanged] == 2)
{
SCM(playerid, COLOR_LIGHTRED, "Acest cont este banat, daca ai nelamuriri intra pe forum pentru a face cerere unban.");
Kick(playerid);
}
if(PlayerInfo[playerid][pNameChanged] == 3)
{
SCM(playerid, COLOR_LIGHTRED, "Acest cont este blocat de catre un administrator, daca ai nelamuriri intra pe forum sau contacteaza un admin.");
Kick(playerid);
}
if(PlayerInfo[playerid][pCookSkill] == 0)
{
PlayerInfo[playerid][pPmotokey] = 999;
SCM(playerid,COLOR_WHITE,""color_red"A fost wipe la motoarele personale !");
PlayerInfo[playerid][pCookSkill] = 1;
Update(playerid,pCookSkillx);
}
SetPlayerFightingStyle (playerid, PlayerInfo[playerid][pFS]);
SetPlayerWalkingStyle (playerid, PlayerInfo[playerid][pSaveWalk]);

TextDrawShowForPlayer(playerid, TextMOTD[0]);
TextDrawShowForPlayer(playerid, TextMOTD[1]);
SetTimerEx("hidemotd", 30000, false, "i", playerid);
if(PlayerInfo[playerid][pMarried] == 0) ClearMarriage(playerid);
ResetPlayerMoney(playerid);
Var[ConsumingMoney][playerid] = 1;
GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
Var[CurrentMoney][playerid] = PlayerInfo[playerid][pCash];
if(CountdownRunning == 1)
{
TextDrawShowForPlayer(playerid, TextdrawCount);
}
if(PlayerInfo[playerid][pReg] == 0)
{
PlayerInfo[playerid][pLevel] = 2;Update(playerid,pLevelx);
PlayerInfo[playerid][pSHealth] = 0.0;
PlayerInfo[playerid][pInt] = 0;
PlayerInfo[playerid][pLocal] = 255;
PlayerInfo[playerid][pTeam] = 3;
PlayerInfo[playerid][pExp] = 0;
PlayerInfo[playerid][pModel] = 264;
new randphone = 1000 + random(8999);
PlayerInfo[playerid][pPnumber] = randphone;Update(playerid,pPnumberx);
PlayerInfo[playerid][pPhousekey] = 255;
PlayerInfo[playerid][pPcarkey] = 999;
PlayerInfo[playerid][pPhelikey] = 999;
PlayerInfo[playerid][pPmotokey] = 999;
PlayerInfo[playerid][pPbiskey] = 255;
PlayerInfo[playerid][pAccount] = 150000;
PlayerInfo[playerid][pReg] = 1;Update(playerid,pRegx);
PlayerInfo[playerid][pKills] = 0;
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid, 5500);
}
else if(PlayerInfo[playerid][pCK] > 0)
{
Kick(playerid);
}
if (PlayerInfo[playerid][pDonateRank] > 0)
{
SCM(playerid, COLOR_WHITE,"SERVER: You are a Premium Account user.");
}
if (PlayerInfo[playerid][pAdmin] > 0)
{
format(string2, sizeof(string2), "SERVER: Te-ai logat cu admin level "color_red"%d",PlayerInfo[playerid][pAdmin]);
SCM(playerid, COLOR_WHITE,string2);
}
if (PlayerInfo[playerid][pHelper] > 0)
{
format(string2, sizeof(string2), "SERVER: Te-ai logat cu helper level "color_red"%d",PlayerInfo[playerid][pHelper]);
SCM(playerid, COLOR_WHITE,string2);
}
if (PlayerInfo[playerid][pVip] > 0)
{
format(string2, sizeof(string2), "SERVER: Te-ai logat cu vip level "color_red"%d",PlayerInfo[playerid][pVip]);
SCM(playerid, COLOR_WHITE,string2);
}
if(gTeam[playerid] == 0)
{
gTeam[playerid] = 3;
}
else
{
gTeam[playerid] = PlayerInfo[playerid][pTeam];
}
if(IsPlayerNPC(playerid)) return 1;

Var[gPlayerLogged][playerid] = 1;
SpawnPlayer(playerid);
format(string2, sizeof(string2), "~r~Welcome ~n~~b~ %s", playername2);
GameTextForPlayer(playerid, string2, 5000, 1);
return 1;
}
Find
Reply
« Next Oldest | Next Newest »


Messages In This Thread
Mysql debug error - by catamarg1 - 07.05.2012, 18:35
Re: Mysql debug error - by Shabi RoxX - 07.05.2012, 18:37
Re: Mysql debug error - by catamarg1 - 07.05.2012, 19:07
Re: Mysql debug error - by JaTochNietDan - 07.05.2012, 21:45
Re: Mysql debug error - by catamarg1 - 08.05.2012, 13:13

Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help