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

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

07.05.2012, 18:35
( Последний раз редактировалось catamarg1; 07.05.2012 в 19:07. )
Код:
[21:06:37] CMySQLHandler::Connect() - Connection was successful.

[21:06:37] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[21:07:26] >> mysql_query( Connection handle: 69 )

[21:07:26] >> mysql_query() - Invalid connection handle. (You set: 69, Highest connection handle ID is 1).

[21:07:26] >> mysql_store_result( Connection handle: 83 )

[21:07:26] >> mysql_store_result() - Invalid connection handle. (You set: 83, Highest connection handle ID is 1).

[21:07:26] >> mysql_num_rows( Connection handle: 83 )

[21:07:26] >> mysql_num_rows() - Invalid connection handle. (You set: 83, Highest connection handle ID is 1).

[21:07:26] >> mysql_free_result( Connection handle: 83 )

[21:07:26] >> mysql_free_result() - Invalid connection handle. (You set: 83, Highest connection handle ID is 1).

[21:07:35] >> mysql_query( Connection handle: 0 )

[21:07:35] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:35] >> mysql_store_result( Connection handle: 0 )

[21:07:35] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:35] >> mysql_num_rows( Connection handle: 0 )

[21:07:35] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:35] >> mysql_free_result( Connection handle: 0 )

[21:07:35] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:35] >> mysql_query( Connection handle: 78 )

[21:07:35] >> mysql_query() - Invalid connection handle. (You set: 78, Highest connection handle ID is 1).

[21:07:37] >> mysql_query( Connection handle: 0 )

[21:07:37] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:37] >> mysql_store_result( Connection handle: 0 )

[21:07:37] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:37] >> mysql_num_rows( Connection handle: 0 )

[21:07:37] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:37] >> mysql_free_result( Connection handle: 77 )

[21:07:37] >> mysql_free_result() - Invalid connection handle. (You set: 77, Highest connection handle ID is 1).

[21:07:40] >> mysql_query( Connection handle: 0 )

[21:07:40] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:40] >> mysql_store_result( Connection handle: 0 )

[21:07:40] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:40] >> mysql_num_rows( Connection handle: 0 )

[21:07:40] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:40] >> mysql_free_result( Connection handle: 77 )

[21:07:40] >> mysql_free_result() - Invalid connection handle. (You set: 77, Highest connection handle ID is 1).

[21:07:42] >> mysql_query( Connection handle: 0 )

[21:07:42] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:42] >> mysql_store_result( Connection handle: 0 )

[21:07:42] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:42] >> mysql_num_rows( Connection handle: 0 )

[21:07:42] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:42] >> mysql_free_result( Connection handle: 77 )

[21:07:42] >> mysql_free_result() - Invalid connection handle. (You set: 77, Highest connection handle ID is 1).

[21:07:44] >> mysql_query( Connection handle: 0 )

[21:07:44] >> mysql_query() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:44] >> mysql_store_result( Connection handle: 0 )

[21:07:44] >> mysql_store_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:44] >> mysql_num_rows( Connection handle: 0 )

[21:07:44] >> mysql_num_rows() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).

[21:07:44] >> mysql_free_result( Connection handle: 0 )

[21:07:44] >> mysql_free_result() - Invalid connection handle. (You set: 0, Highest connection handle ID is 1).
Код:
CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`Level` int(11) DEFAULT '0',
`AdminLevel` int(11) DEFAULT '0',
`VipLevel` int(11) DEFAULT '0',
`Helper` int(11) DEFAULT '0',
`DonateRank` int(11) DEFAULT '0',
`UpgradePoints` int(11) DEFAULT '0',
`ConnectedTime` int(11) DEFAULT '0',
`Registered` int(11) DEFAULT '0',
`Sex` int(11) DEFAULT '0',
`Age` int(11) DEFAULT '0',
`Origin` int(11) DEFAULT '0',
`CK` int(11) DEFAULT '0',
`Muted` int(11) DEFAULT '0',
`MuteTime` int(11) DEFAULT '0',
`Respect` int(11) DEFAULT '0',
`Money` int(11) DEFAULT '0',
`Bank` int(11) DEFAULT '0',
`Crimes` int(11) DEFAULT '0',
`Kills` int(11) DEFAULT '0',
`Deaths` int(11) DEFAULT '0',
`Arrested` int(11) DEFAULT '0',
`WantedDeaths` int(11) DEFAULT '0',
`Phonebook` int(11) DEFAULT '0',
`LottoNr` int(11) DEFAULT '0',
`Fishes` int(11) DEFAULT '0',
`BiggestFish` int(11) DEFAULT '0',
`Job` int(11) DEFAULT '0',
`Clock` int(11) DEFAULT '0',
`Smoke` int(11) DEFAULT '0',
`Color` int(11) DEFAULT '0',
`PaintJob` int(11) DEFAULT '0',
`Beer` int(11) DEFAULT '0',
`Referer` int(11) DEFAULT '0',
`SpawnChange` int(11) DEFAULT '0',
`Admkicks` int(11) DEFAULT '0',
`Admbans` int(11) DEFAULT '0',
`Admwarns` int(11) DEFAULT '0',
`Admallcmds` int(11) DEFAULT '0',
`TowCarReg` int(11) DEFAULT '0',
`Speedo` int(11) DEFAULT '0',
`Robbed` int(11) DEFAULT '0',
`Robbing` int(11) DEFAULT '0',
`CRReport` int(11) DEFAULT '0',
`CRNeedHelp` int(11) DEFAULT '0',
`SaveWalk` int(11) DEFAULT '0',
`Paycheck` int(11) DEFAULT '0',
`HeadValue` int(11) DEFAULT '0',
`Jailed` int(11) DEFAULT '0',
`JailTime` int(11) DEFAULT '0',
`BlackList` int(11) DEFAULT '0',
`BlackListTime` int(11) DEFAULT '0',
`Materials` int(11) DEFAULT '0',
`Drugs` int(11) DEFAULT '0',
`Leader` int(11) DEFAULT '0',
`Member` int(11) DEFAULT '0',
`Rank` int(11) DEFAULT '0',
`cChar` int(11) DEFAULT '0',
`ContractTime` int(11) DEFAULT '0',
`DetSkill` int(11) DEFAULT '0',
`SexSkill` int(11) DEFAULT '0',
`BoxSkill` int(11) DEFAULT '0',
`LawSkill` int(11) DEFAULT '0',
`MechSkill` int(11) DEFAULT '0',
`JackSkill` int(11) DEFAULT '0',
`CarSkill` int(11) DEFAULT '0',
`NewsSkill` int(11) DEFAULT '0',
`DrugsSkill` int(11) DEFAULT '0',
`CookSkill` int(11) DEFAULT '0',
`FishSkill` int(11) DEFAULT '0',
`pSHealth` int(11) DEFAULT '0',
`iInt` int(11) DEFAULT '0',
`VWorld` int(11) DEFAULT '0',
`Local` int(11) DEFAULT '0',
`Team` int(11) DEFAULT '0',
`Model` int(11) DEFAULT '0',
`PhoneNr` int(11) DEFAULT '0',
`Car` int(11) DEFAULT '0',
`Heli` int(11) DEFAULT '0',
`Moto` int(11) DEFAULT '0',
`House` int(11) DEFAULT '0',
`Bizz` int(11) DEFAULT '0',
`CarLic` int(11) DEFAULT '0',
`FlyLic` int(11) DEFAULT '0',
`BoatLic` int(11) DEFAULT '0',
`FishLic` int(11) DEFAULT '0',
`GunLic` int(11) DEFAULT '0',
`Fighting` int(11) DEFAULT '0',
`CarTime` int(11) DEFAULT '0',
`MotoLic` int(11) DEFAULT '0',
`CDPlayer` int(11) DEFAULT '0',
`Wins` int(11) DEFAULT '0',
`Loses` int(11) DEFAULT '0',
`AlcoholPerk` int(11) DEFAULT '0',
`DrugPerk` int(11) DEFAULT '0',
`MiserPerk` int(11) DEFAULT '0',
`PainPerk` int(11) DEFAULT '0',
`TraderPerk` int(11) DEFAULT '0',
`Tutorial` int(11) DEFAULT '0',
`Mission` int(11) DEFAULT '0',
`Warnings` int(11) DEFAULT '0',
`Fwarn` int(11) DEFAULT '0',
`AdminWarnings` int(11) DEFAULT '0',
`Fuel` int(11) DEFAULT '0',
`WantedLevel` int(11) DEFAULT '0',
`Married` int(11) DEFAULT '0',
`MarriedTo` int(11) DEFAULT '0',
 `NameChanged` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Please Help!!!!
Find
Reply
Shabi RoxX
Gangsta
****
Posts: 534
Threads: 27
Joined: Jan 2012
Reputation: 0
#2

07.05.2012, 18:37
Please show codes, so we can help you.
Find
Reply
catamarg1
Big Clucker
***
Posts: 96
Threads: 4
Joined: Nov 2010
Reputation: 0
#3

07.05.2012, 19:07
Quote:
Originally Posted by Shabi RoxX
Посмотреть сообщение
Please show codes, so we can help you.
ADD code
Find
Reply
JaTochNietDan
High-roller
*****
Posts: 2,502
Threads: 26
Joined: Apr 2007
Reputation: 0
#4

07.05.2012, 21:45
It looks like you connected to the server with a connection handle ID of 1 but you're executing all of the functions with an additional argument telling them to execute it on varying connection handles besides 1 which will not work as 1 is the only connected one according to this log.

Can you show us the actual code from your PAWN script?
Find
Reply
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 »


Forum Jump:


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