pawn Код:
stock afterlogin(playerid)
{
SendClientMessage(playerid, -1, ""CGREEN"You've been successfully logged in!");
PlayerInfo[playerid][LoggedIn] = 1;
new savingstring[20], query[256], pname[30];
GetPlayerName(playerid, pname, sizeof(pname));
format(query, sizeof(query), "SELECT * FROM playerinfo WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
//strings
mysql_fetch_field_row(PlayerInfo[playerid][ip], "ip");
mysql_fetch_field_row(PlayerInfo[playerid][email], "email");
mysql_fetch_field_row(PlayerInfo[playerid][RegDate], "RegDate");
mysql_fetch_field_row(PlayerInfo[playerid][LastOn], "LastOn");
//Numbers
mysql_fetch_field_row(savingstring, "Level"); PlayerInfo[playerid][Level] = strval(savingstring);
mysql_fetch_field_row(savingstring, "VIP"); PlayerInfo[playerid][VIP] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Trusted"); PlayerInfo[playerid][Trusted] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Banked"); PlayerInfo[playerid][Banked] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Score"); PlayerInfo[playerid][Score] = strval(savingstring);
mysql_fetch_field_row(savingstring, "DMScore"); PlayerInfo[playerid][DMScore] = strval(savingstring);
mysql_fetch_field_row(savingstring, "DualWon"); PlayerInfo[playerid][DuelWon] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Fstyle"); PlayerInfo[playerid][Fstyle] = strval(savingstring);
mysql_fetch_field_row(savingstring, "ReactionWon"); PlayerInfo[playerid][ReactionWon] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Hours"); PlayerInfo[playerid][Hours] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Minutes"); PlayerInfo[playerid][Minutes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Seconds"); PlayerInfo[playerid][Seconds] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Visits"); PlayerInfo[playerid][Visits] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Kicks"); PlayerInfo[playerid][Kicks] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Bans"); PlayerInfo[playerid][Bans] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Banned"); PlayerInfo[playerid][Banned] = strval(savingstring);
mysql_fetch_field_row(savingstring, "SaveSkin"); PlayerInfo[playerid][SaveSkin] = strval(savingstring);
mysql_fetch_field_row(savingstring, "UseSkin"); PlayerInfo[playerid][UseSkin] = strval(savingstring);
mysql_fetch_field_row(savingstring, "SpawnPoint"); PlayerInfo[playerid][SpawnPoint] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Cash"); PlayerInfo[playerid][Cash] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Jails"); PlayerInfo[playerid][Jails] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Mutes"); PlayerInfo[playerid][Mutes] = strval(savingstring);
mysql_fetch_field_row(savingstring, "ClearChat"); PlayerInfo[playerid][ClearChat] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Warns"); PlayerInfo[playerid][Warns] = strval(savingstring);
mysql_fetch_field_row(savingstring, "mycar"); PlayerInfo[playerid][mycar] = strval(savingstring);
mysql_fetch_field_row(savingstring, "color1"); PlayerInfo[playerid][Vcolor1] = strval(savingstring);
mysql_fetch_field_row(savingstring, "color2"); PlayerInfo[playerid][Vcolor2] = strval(savingstring);
mysql_fetch_field_row(savingstring, "spawnhome"); housespawn[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "BizID"); PlayerInfo[playerid][BizID] = strval(savingstring);
//Floats
mysql_fetch_field_row(savingstring, "posX"); PlayerInfo[playerid][posX] = floatstr(savingstring);//floatstr convert strings to floats
mysql_fetch_field_row(savingstring, "posY"); PlayerInfo[playerid][posY] = floatstr(savingstring);
mysql_fetch_field_row(savingstring, "posZ"); PlayerInfo[playerid][posZ] = floatstr(savingstring);
printf("%s has joined the server, he is Level %d, vehicleID = %d",pname, PlayerInfo[playerid][Level], PlayerInfo[playerid][mycar]);
}
newafterlogin(playerid);
}
stock newafterlogin(playerid)
{
mysql_free_result();
print("1");
PlayerInfo[playerid][Log] = 1;
loginattemps[playerid] = 0;
if(PlayerInfo[playerid][mycar] != -1)
{
PlayerInfo[playerid][carID] = CreateVehicle(PlayerInfo[playerid][mycar], PlayerInfo[playerid][vX], PlayerInfo[playerid][vY], PlayerInfo[playerid][vZ], PlayerInfo[playerid][ang], PlayerInfo[playerid][Vcolor1], PlayerInfo[playerid][Vcolor2], 45);
SetVehicleToRespawn(PlayerInfo[playerid][carID]);
print("1,5");
}
if(PlayerInfo[playerid][VIP] > 0)
{
SendFMessageToAll(-1, ""CORAL"[VIP] %s has joined the server!", PlayerName(playerid));
Create3DTextLabel("Very Important Player", COLOR_GREEN, 0.0, 0.0, 40.0, 20.0, 0, 1);
Attach3DTextLabelToPlayer(Info[playerid], playerid, 0.0, 0.0, 0.40);
print("2");
}
print("3");
/*new year,month,day,hour,minute,second;
getdate(year,month,day);
gettime(hour,minute,second);
format(gQuery,sizeof(gQuery),"UPDATE playerinfo SET LastOn =%02d.%02d.%02d at %02d:%02d:%02d, LoggedIn =1 WHERE user='%s'",day,month,year,hour,minute,second, PlayerName(playerid));
mysql_query(gQuery);*/
new LName[40], ircMsg[128];
switch(PlayerInfo[playerid][Level])
{
case 0: LName = "Regular Player";
case 1: LName = "08Trial Admin";
case 2: LName = "12Moderator";
case 3: LName = "03Server-Admin";
case 4: LName = "11Super-Moderator";
case 5: LName = "04Super-Head-Admin";
}
print("4");
format(ircMsg, sizeof(ircMsg), "02[%d] 07,3%s: has been successfully logged in.04[Level: %s].", playerid, PlayerName(playerid), LName);
IRC_GroupSay(groupID, IRC_CHANNEL, ircMsg);
print("5");
SetPlayerScore(playerid, GetPlayerScore(playerid)+PlayerInfo[playerid][Score]);
SetPlayerFightingStyle(playerid, PlayerInfo[playerid][Fstyle]);
print("6");
PlayerInfo[playerid][Visits]++;
TextDrawShowForPlayer(playerid, StatsBox);
print("7");
}
