Login problem
#1

Login dialog pops up when player connect to server its ok but there are 2 login dialogs. First one appears like 5 seconds and then second pops up on the 1 one. How to fix that?





Additionaly, when I click "Cancel" button it kickes the player but at the same time it show skin selections. I just want to make all things in "onplayerconnect" How to fix these?

Reply
#2

You got to show the Code.
Reply
#3

Quote:
Originally Posted by Rudy_
Посмотреть сообщение
You got to show the Code.
Where is the problem do you think? Tell me and then I will copy codes cuz I reallt dont know what the problem is
Reply
#4

It's the dialog ofc, OnDialogResponse and ShowPlayerDialog

Код:
This forum requires that you wait 120 seconds between posts. Please try again in 74 seconds.
Reply
#5

Show your OnPlayerConnect
Reply
#6

Quote:
Originally Posted by biker122
Посмотреть сообщение
Show your OnPlayerConnect
Here;

Код:
public OnPlayerConnect(playerid)
{
	new string[256],Query[200];

	GetPlayerName(playerid, PlayerInfo[playerid][pName], 128);
	GetPlayerIp(playerid, PlayerInfo[playerid][pIP], 50);

	ResetAllPlayerStats(playerid);
	
	SetPlayerColor(playerid, COLOR_DEAD);

   	if (IsPlayerNPC(playerid))
	{

    /*new ip_addr_npc[64+1];
    new ip_addr_server[64+1];
    GetServerVarAsString("bind",ip_addr_server,64);
    GetPlayerIp(playerid,ip_addr_npc,64);

	if(!strlen(ip_addr_server)) {
 	ip_addr_server = "127.0.0.1";
	}

	if(strcmp(ip_addr_npc,ip_addr_server,true) != 0) {
 	// this bot is remote connecting
  	printf("NPC: Remote NPC Attempting To Connect From %s And I'm Kicking It.",ip_addr_npc);
  	Kick(playerid);
  	return 0;
	}
 	//printf("NPC: Connection From %s Is Allowed.",ip_addr_npc);*/
   	format(string, sizeof(string), "* NPC %s (%i) Has Joined The Server.",PlayerInfo[playerid][pName],playerid);
	SendClientMessageToOthers(playerid, COLOR_DEAD, string);

   	}else{// End of NPC Check

	//DestroyGPSData(playerid);


	new PIP[56]; //Creates the IP string
	GetPlayerIp(playerid, PIP, 56); //Gets the players IP

	format(Query, sizeof(Query), "SELECT * FROM banned WHERE IP = '%s'", PIP); //Checks if the players IP is in the database, if so it will kick them :)

	mysql_query(Query);//Queries
    mysql_store_result(); //Stores the result

    if(mysql_num_rows() != 0) //If the ip is found
    {
	SendClientMessage(playerid, COLOR_ERROR, "Your IP Has Been Banned Due To Abuse, Visit "WEBSITE" For More Info.");
	Kick(playerid);
    return 0;
   	}
	PlayerInfo[playerid][pClassselection] = 10;


	//format(string, sizeof(string), "02[JOIN] 03%s (%d) Has Joined The Server.", PlayerInfo[playerid][pName], playerid);
	//IRC_GroupSay(gGroupID, IRC_CHANNEL, string);

 	format(string, sizeof(string), "* %s (%i) Has Joined The Server.",PlayerInfo[playerid][pName],playerid);
	SendClientMessageToOthers(playerid, COLOR_DEAD, string);

   	format(string, sizeof(string), "{FFFFFF}Welcome to {D6D631}Pink_Panther's {0077FF}Cops {FFFFFF}And {FF0000}Robbers{FFFFFF}- {00AAFF}%s {D6D631}Version %s",ServerInfo[sMapName],VERSION);
	SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, string);

   	format(string, sizeof(string), "{FFFFFF}Type   {D6D631}/help  /cmds  /rules  {FFFFFF}or visit {00AAFF}%s {FFFFFF}For Game Info.",WEBSITE);
	SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, string);
	
	SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "{FF0000}Warning!  {FFFFFF}This Server (and GTA In General) Contains Explicit Material.");

    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "Login", string, "Login", "Cancel");


	format(Query, sizeof(Query), "SELECT * FROM playerdata WHERE UserName = '%s'", PlayerInfo[playerid][pName]);
	mysql_query(Query);//Queries
    mysql_store_result(); //Stores the result

	if(mysql_num_rows() > 0) //If the user is found
    {
	PlayerInfo[playerid][pRegistered] = 1;
	PlayerInfo[playerid][pLogged] = 0;

	new wdata[128];

	while(mysql_retrieve_row()) //it will be running until there are no more rows to be retrieved
	{

		switch (CURRENT_GAMEMODE)
		{

			case LOS_SANTOS:
			{
			mysql_get_field("LsResume",wdata);
			PlayerInfo[playerid][pResume] = strval(wdata);
			mysql_get_field("LsClassid",wdata);
			PlayerInfo[playerid][pClass] = strval(wdata);
			}

			case LAS_VENTURAS:
			{
			mysql_get_field("LvResume",wdata);
			PlayerInfo[playerid][pResume] = strval(wdata);
			mysql_get_field("LvClassid",wdata);
			PlayerInfo[playerid][pClass] = strval(wdata);
			}

			case SAN_FIERRO:
			{
			mysql_get_field("SfResume",wdata);
			PlayerInfo[playerid][pResume] = strval(wdata);
			mysql_get_field("SfClassid",wdata);
			PlayerInfo[playerid][pClass] = strval(wdata);
			}

		}

	}
	


	}
    else
    {
	PlayerInfo[playerid][pRegistered] = 0;
	PlayerInfo[playerid][pLogged] = 0;
	PlayerInfo[playerid][pClass] = 0;
	PlayerInfo[playerid][pTeam] = TEAM_POLIS;
	PlayerInfo[playerid][pSkill] = SKILL_POLIS;
	}

    mysql_free_result(); //Frees the result :)


	format(string, sizeof(string), "555%d%d%d%d",playerid,random(9),random(9),random(9));
	PlayerInfo[playerid][pPhoneNumber] = strval(string);
	
	RemoveBuildingForPlayer(playerid, 985, 2497.41, 2777.07, 11.5312, 20.0);//Right Gate Of K.A.C.C Military Fuels
	RemoveBuildingForPlayer(playerid, 986, 2497.41, 2769.11, 11.5312, 20.0);//Left Gate Of K.A.C.C Military Fuels
	//RemoveBuildingForPlayer(playerid, 11014, -2076.4375, -107.9297, 36.9688, 20.0);//Gates Of San Fierro Driving School

	//Los Santos
    RemoveBuildingForPlayer(playerid, 956, 1634.1487,-2238.2810,13.5077, 20.0); //Snack vender @ LS Airport
	RemoveBuildingForPlayer(playerid, 956, 2480.9885,-1958.5117,13.5831, 20.0); //Snack vender @ Sushi Shop in Willowfield
	RemoveBuildingForPlayer(playerid, 955, 1729.7935,-1944.0087,13.5682, 20.0); //Sprunk machine @ Unity Station
	RemoveBuildingForPlayer(playerid, 955, 2060.1099,-1898.4543,13.5538, 20.0); //Sprunk machine opposite Tony's Liqour in Willowfield
	RemoveBuildingForPlayer(playerid, 955, 2325.8708,-1645.9584,14.8270, 20.0); //Sprunk machine @ Ten Green Bottles
	RemoveBuildingForPlayer(playerid, 955, 1153.9130,-1460.8893,15.7969, 20.0); //Sprunk machine @ Market
	RemoveBuildingForPlayer(playerid, 955,1788.3965,-1369.2336,15.7578, 20.0); //Sprunk machine in Downtown Los Santos
	RemoveBuildingForPlayer(playerid, 955, 2352.9939,-1357.1105,24.3984, 20.0); //Sprunk machine @ Liquour shop in East Los Santos
	RemoveBuildingForPlayer(playerid, 1775, 2224.3235,-1153.0692,1025.7969, 20.0); //Sprunk machine @ Jefferson Motel
	RemoveBuildingForPlayer(playerid, 956, 2140.2566,-1161.7568,23.9922, 20.0); //Snack machine @ pick'n'go market in Jefferson
	RemoveBuildingForPlayer(playerid, 956, 2154.1199,-1015.7635,62.8840, 20.0); //Snach machine @ Carniceria El Pueblo in Las Colinas
	RemoveBuildingForPlayer(playerid, 956, 662.5665,-551.4142,16.3359, 20.0); //Snack vender at Dillimore Gas Station
	RemoveBuildingForPlayer(playerid, 955, 200.2010,-107.6401,1.5513, 20.0); //Sprunk machine @ Blueberry Safe House
	RemoveBuildingForPlayer(playerid, 956, 2271.4666,-77.2104,26.5824, 20.0); //Snack machine @ Palomino Creek Library
	RemoveBuildingForPlayer(playerid, 955, 1278.5421,372.1057,19.5547, 20.0); //Sprunk machine @ Papercuts in Montgomery
	RemoveBuildingForPlayer(playerid, 955, 1929.5527,-1772.3136,13.5469, 20.0); //Sprunk machine @ Idlewood Gas Station

	//San Fierro
	RemoveBuildingForPlayer(playerid, 1302, -2419.5835,984.4185,45.2969, 20.0); //Soda machine 1 @ Juniper Hollow Gas Station
	RemoveBuildingForPlayer(playerid, 1209, -2419.5835,984.4185,45.2969, 20.0); //Soda machine 2 @ Juniper Hollow Gas Station
	RemoveBuildingForPlayer(playerid, 956, -2229.2075,287.2937,35.3203, 20.0); //Snack vender @ King's Car Park
	RemoveBuildingForPlayer(playerid, 955, -1349.3947,493.1277,11.1953, 20.0); //Sprunk machine @ SF Aircraft Carrier
	RemoveBuildingForPlayer(playerid, 956, -1349.3947,493.1277,11.1953, 20.0); //Snack vender @ SF Aircraft Carrier
	RemoveBuildingForPlayer(playerid, 955, -1981.6029,142.7232,27.6875, 20.0); //Sprunk machine @ Cranberry Station
	RemoveBuildingForPlayer(playerid, 955, -2119.6245,-422.9411,35.5313, 20.0); //Sprunk machine 1/2 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2097.3696,-397.5220,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2068.5593,-397.5223,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2039.8802,-397.5214,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2011.1403,-397.5225,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2005.7861,-490.8688,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2034.5267,-490.8681,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2063.1875,-490.8687,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium
	RemoveBuildingForPlayer(playerid, 955, -2091.9780,-490.8684,35.5313, 20.0); //Sprunk machine 3 @ SF Stadium

	//Las Venturas
	RemoveBuildingForPlayer(playerid, 956, -1455.1298,2592.4138,55.8359, 20.0); //Snack vender @ El Quebrados GONE
	RemoveBuildingForPlayer(playerid, 955, -252.9574,2598.9048,62.8582, 20.0); //Sprunk machine @ Las Payasadas GONE
	RemoveBuildingForPlayer(playerid, 956, -252.9574,2598.9048,62.8582, 20.0); //Snack vender @ Las Payasadas GONE
	RemoveBuildingForPlayer(playerid, 956, 1398.7617,2223.3606,11.0234, 20.0); //Snack vender @ Redsands West GONE
	RemoveBuildingForPlayer(playerid, 955, -862.9229,1537.4246,22.5870, 20.0); //Sprunk machine @ The Smokin' Beef Grill in Las Barrancas GONE
	RemoveBuildingForPlayer(playerid, 955, -14.6146,1176.1738,19.5634, 20.0); //Sprunk machine @ Fort Carson GONE
	RemoveBuildingForPlayer(playerid, 956, -75.2839,1227.5978,19.7360, 20.0); //Snack vender @ Fort Carson GONE
	RemoveBuildingForPlayer(playerid, 955, 1519.3328,1055.2075,10.8203, 20.0); //Sprunk machine @ LVA Freight Department GONE
	RemoveBuildingForPlayer(playerid, 956, 1659.5096,1722.1096,10.8281, 20.0); //Snack vender near Binco @ LV Airport GONE
	RemoveBuildingForPlayer(playerid, 955, 2086.5872,2071.4958,11.0579, 20.0); //Sprunk machine @ Sex Shop on The Strip
	RemoveBuildingForPlayer(playerid, 955, 2319.9001,2532.0376,10.8203, 20.0); //Sprunk machine @ Pizza co by Julius Thruway (North)
	RemoveBuildingForPlayer(playerid, 955, 2503.2061,1244.5095,10.8203, 20.0); //Sprunk machine @ Club in the Camels Toe
	RemoveBuildingForPlayer(playerid, 956, 2845.9919,1294.2975,11.3906, 20.0); //Snack vender @ Linden Station
	RemoveBuildingForPlayer(playerid, 956, 2647.6953, 1129.6641, 10.2188, 20.0); //Snack vender @ South East LV Gas Station

	//Interiors: 24/7 and Clubs
	RemoveBuildingForPlayer(playerid, 1775, 496.0843,-23.5310,1000.6797, 20.0); //Sprunk machine 1 @ Club in Camels Toe
	RemoveBuildingForPlayer(playerid, 1775, 501.1219,-2.1968,1000.6797, 20.0); //Sprunk machine 2 @ Club in Camels Toe
	RemoveBuildingForPlayer(playerid, 1776, 501.1219,-2.1968,1000.6797, 20.0); //Snack vender @ Club in Camels Toe
	RemoveBuildingForPlayer(playerid, 1775, -19.2299,-57.0460,1003.5469, 20.0); //Sprunk machine @ Roboi's type 24/7 stores
	RemoveBuildingForPlayer(playerid, 1776, -35.9012,-57.1345,1003.5469, 20.0); //Snack vender @ Roboi's type 24/7 stores
	RemoveBuildingForPlayer(playerid, 1775, -17.0036,-90.9709,1003.5469, 20.0); //Sprunk machine @ Other 24/7 stores
	RemoveBuildingForPlayer(playerid, 1776, -17.0036,-90.9709,1003.5469, 20.0); //Snach vender @ Others 24/7 stores
	RemoveBuildingForPlayer(playerid, 1775, -32.4453, -186.6953, 1003.6328, 20.0); //Sprunk machine @ Other 24/7 store
	RemoveBuildingForPlayer(playerid, 1776, -33.8750, -186.7656, 1003.6328, 20.0); //Snach vender @ Others 24/7 stores
	RemoveBuildingForPlayer(playerid, 1775, -35.7266, -140.2266, 1003.6328, 20.0); //Sprunk machine @ Other 24/7 store
	RemoveBuildingForPlayer(playerid, 1776, -16.5313, -140.2969, 1003.6328, 20.0); //Snach vender @ Others 24/7 stores
	RemoveBuildingForPlayer(playerid, 1775, -15.1016, -140.2266, 1003.6328, 20.0); //Sprunk machine @ Other 24/7 store

	RemoveBuildingForPlayer(playerid, 2778, -18.2734, -140.2734, 1002.5859, 20.0); //Video Game machine @ Other 24/7 store
	RemoveBuildingForPlayer(playerid, 2681, -34.1953, -140.2734, 1002.5859, 20.0); //Video Game machine @ Other 24/7 store

	//Interiors: Planning Department
	RemoveBuildingForPlayer(playerid, 1776, 330.6797, 178.5000, 1020.0703, 20.0); //Snach vender @ Planning Dept
	RemoveBuildingForPlayer(playerid, 1776, 331.9219, 178.5000, 1020.0703, 20.0); //Snach vender @ Planning Dept
	RemoveBuildingForPlayer(playerid, 1776, 371.5938, 178.4531, 1020.0703, 20.0); //Snach vender @ Planning Dept
	RemoveBuildingForPlayer(playerid, 1776, 361.5625, 158.6172, 1008.4766, 20.0); //Snach vender @ Planning Dept
	RemoveBuildingForPlayer(playerid, 1776, 374.8906, 188.9766, 1008.4766, 20.0); //Snach vender @ Planning Dept
	RemoveBuildingForPlayer(playerid, 1776, 350.9063, 206.0859, 1008.4766, 20.0); //Snach vender @ Planning Dept

	//Interiors: Caligulas Casino Basement
	RemoveBuildingForPlayer(playerid, 1776, 2155.8438, 1607.8750, 1000.0625, 20.0); //Snach vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1776, 2222.3672, 1602.6406, 1000.0625, 20.0); //Snach vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1776, 2202.4531, 1617.0078, 1000.0625, 20.0); //Snach vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1776, 2209.2422, 1621.2109, 1000.0625, 20.0); //Snach vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1775, 2222.2031, 1606.7734, 1000.0547, 20.0); //Sprunk vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1775, 2209.9063, 1607.1953, 1000.0547, 20.0); //Sprunk vender @ caligulas Basement
	RemoveBuildingForPlayer(playerid, 1775, 2155.9063, 1606.7734, 1000.0547, 20.0); //Sprunk vender @ caligulas Basement

	//Interiors: Big Smokes Crack Palace
	RemoveBuildingForPlayer(playerid, 1775, 2576.7031, -1284.4297, 1061.0938, 20.0); //Sprunk vender

	//Interiors: Donut Shop
	RemoveBuildingForPlayer(playerid, 1776, 379.0391, -178.8828, 1000.7344, 20.0); //Snach vender @ donut shop
	RemoveBuildingForPlayer(playerid, 1775, 373.8281, -178.1406, 1000.7344, 20.0); //Sprunk vender @ donut shop

	//Interiors: Ammunation
	RemoveBuildingForPlayer(playerid, 1977, 316.8750, -140.3516, 998.5859, 20.0); //Useless Box @ Ammunation


	
	if(CHRISTMAS == 1)
	{
	//for(new o=0; o<60; o++) CreatePlayerObject(playerid,354,0,0,0,0,0,0);
	}
	
	}// End of NPC Check
	
	

	return 1;
}
Reply
#7

Quote:
Originally Posted by Rudy_
Посмотреть сообщение
It's the dialog ofc, OnDialogResponse and ShowPlayerDialog

Код:
This forum requires that you wait 120 seconds between posts. Please try again in 74 seconds.
Код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	new string[256],query[256],escpass[256],PIP[56],LastLogin[128];

	new Hour, Minute, Second, Year, Month, Day;

	GetPlayerIp(playerid, PIP, sizeof(PIP)); //Gets the players IP

	gettime(Hour, Minute, Second);
	getdate(Year, Month, Day);

	format(LastLogin, sizeof(LastLogin), "DATE: %d-%d-%d TIME: %d:%d",Day,Month,Year,Hour,Minute);
			

    if(dialogid == DIALOG_REGISTER)
    {

       if(response == 1)
       {
            	if(!strlen(inputtext)) //If the player doesn't enter a pass
            	{
				format(string, sizeof(string), "Cops And Robbers\n \nNew Registration - Name: %s\n \nDo Not Register Multiple Accounts\nDo Not Use The Same Password That You Use Elsewhere\nMinimum 6 Chars Maximum 12 Chars\n \nPlease Enter A Password For Your Account:",PlayerInfo[playerid][pName],playerid);
				ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT , "CnR Registration",string, "Register", "Cancel");
				return 1;
				}
				
				if(strlen(inputtext) < 6)
				{
				SendClientMessage(playerid, COLOR_ERROR, "Your Password is Too Short, Enter a Longer Password.");

				format(string, sizeof(string), "Cops And Robbers\n \nNew Registration - Name: %s\n \nDo Not Register Multiple Accounts\nDo Not Use The Same Password That You Use Elsewhere\nMinimum 6 Chars Maximum 12 Chars\n \nPlease Enter A Password For Your Account:",PlayerInfo[playerid][pName],playerid);
				ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT , "CnR Registration",string, "Register", "Cancel");
				return 1;
				}
				
				if(strlen(inputtext) > 12)
				{
				SendClientMessage(playerid, COLOR_ERROR, "Your Password is Too Long, Enter a Shorter Password.");

				format(string, sizeof(string), "Cops And Robbers\n \nNew Registration - Name: %s\n \nDo Not Register Multiple Accounts\nDo Not Use The Same Password That You Use Elsewhere\nMinimum 6 Chars Maximum 12 Chars\n \nPlease Enter A Password For Your Account:",PlayerInfo[playerid][pName],playerid);
				ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT , "CnR Registration",string, "Register", "Cancel");
				return 1;
				}

				
				mysql_real_escape_string(inputtext, escpass);

				//mysql_real_escape_string(PlayerInfo[playerid][pName],PlayerInfo[playerid][pName]);
				//mysql_real_escape_string(inputtext,inputtext);

				format(query, sizeof(query), "INSERT INTO playerdata (UserName, Password, IP) VALUES('%s', SHA1('%s'), '%s')", PlayerInfo[playerid][pName], escpass, PIP);
				mysql_query(query);

            	//format(query, sizeof(query), "INSERT INTO playerdata (UserName, Password, IP) VALUES ('%s', md5('%s'), '%s')",PlayerInfo[playerid][pName], inputtext, PIP); //Insert string
				//mysql_query(query);

				format(query,sizeof(query),"UPDATE playerdata SET Registered = '%s' WHERE (UserName = '%s')",LastLogin,PlayerInfo[playerid][pName]);
				mysql_query(query); //queries

				format(query,sizeof(query),"UPDATE playerdata SET LastLogin = '%s' WHERE (UserName = '%s')",LastLogin,PlayerInfo[playerid][pName]);
				mysql_query(query); //queries

				mysql_free_result();

                PlayerInfo[playerid][pLogged] = 1;
                PlayerInfo[playerid][pRegistered] = 1;
                //SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "Registered And Logged In.");

				SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "New Account Created.  Your Are Now Logged In.  ");//Please Read The Registration Info.
				SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "Type /help  and  /commands  For Game Information, or visit "WEBSITE"");


        }else{//End Of Response Check
        SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "{FFFFFF}Registration {FF0000}Cancelled.");
        }
        
    }//End Of DialogCheck
    
    
    if(dialogid == DIALOG_LOGIN)
    {
    
       if(response == 1)
       {
			
			mysql_real_escape_string(inputtext, escpass); //We escape the inputtext to avoid SQL injections.
			format(query, sizeof(query), "SELECT * FROM playerdata WHERE UserName = '%s' AND Password = SHA1('%s')", PlayerInfo[playerid][pName], escpass);
 			mysql_query(query);
 			mysql_store_result();
			
			if(mysql_num_rows() > 0)
			{

			new wdata[256],Locked;

			format(query,sizeof(query),"SELECT * FROM playerdata WHERE UserName = '%s' LIMIT 1",PlayerInfo[playerid][pName]);
			mysql_query(query);
			mysql_store_result();
			
			while(mysql_retrieve_row()) //it will be running until there are no more rows to be retrieved
			{

			mysql_get_field("Locked",wdata); //macro for mysql_fetch_field_row
			Locked = strval(wdata);

			if (Locked > 0)KickPlayer(playerid,"Server","ACCOUNT DISABLED","This Account Is Disabled");

			mysql_get_field("AdminLevel",wdata);
			PlayerInfo[playerid][pAdminLevel] = strval(wdata);

			mysql_get_field("LoginTimes",wdata);
			PlayerInfo[playerid][pLoginTimes] = strval(wdata);

			mysql_get_field("ConnHour",wdata);
			PlayerInfo[playerid][pConnHour] = strval(wdata);

			mysql_get_field("ConnMinute",wdata);
			PlayerInfo[playerid][pConnMinute] = strval(wdata);

			mysql_get_field("Tutorial",wdata);
			PlayerInfo[playerid][pTutorial] = strval(wdata);

			mysql_get_field("Regular",wdata);
			PlayerInfo[playerid][pRegular] = strval(wdata);

			mysql_get_field("Donator",wdata);
			PlayerInfo[playerid][pDonator] = strval(wdata);

			mysql_get_field("Score",wdata);
			PlayerInfo[playerid][pScore] = strval(wdata);



			switch (CURRENT_GAMEMODE)
			{

				case LOS_SANTOS:
				{

				mysql_get_field("LsResume",wdata);
				PlayerInfo[playerid][pResume] = strval(wdata);

				mysql_get_field("LsClass",wdata);
				PlayerInfo[playerid][pClass] = strval(wdata);

				mysql_get_field("LsTeam",wdata);
				PlayerInfo[playerid][pTeam] = strval(wdata);

				mysql_get_field("LsSkill",wdata);
				PlayerInfo[playerid][pSkill] = strval(wdata);

				mysql_get_field("LsLevel",wdata);
				PlayerInfo[playerid][pLevel] = strval(wdata);

				mysql_get_field("LsRank",wdata);
				PlayerInfo[playerid][pRank] = strval(wdata);

				mysql_get_field("LsMoney",wdata);
				PlayerInfo[playerid][pMoney] = strval(wdata);

				mysql_get_field("LsFakeSkill",wdata);
				PlayerInfo[playerid][pFakeSkill] = strval(wdata);
				
				mysql_get_field("LsGender",wdata);
				PlayerInfo[playerid][pGender] = strval(wdata);

				mysql_get_field("LsHealth",wdata);
				PlayerInfo[playerid][pHealth] = strval(wdata);

				mysql_get_field("LsArmour",wdata);
				PlayerInfo[playerid][pArmour] = strval(wdata);

				mysql_get_field("LsWeapon1",wdata);
				PlayerInfo[playerid][pWeapon][1] = strval(wdata);

				mysql_get_field("LsAmmo1",wdata);
				PlayerInfo[playerid][pAmmo][1] = strval(wdata);

				mysql_get_field("LsWeapon2",wdata);
				PlayerInfo[playerid][pWeapon][2] = strval(wdata);

				mysql_get_field("LsAmmo2",wdata);
				PlayerInfo[playerid][pAmmo][2] = strval(wdata);

				mysql_get_field("LsWeapon3",wdata);
				PlayerInfo[playerid][pWeapon][3] = strval(wdata);

				mysql_get_field("LsAmmo3",wdata);
				PlayerInfo[playerid][pAmmo][3] = strval(wdata);

				mysql_get_field("LsWeapon4",wdata);
				PlayerInfo[playerid][pWeapon][4] = strval(wdata);

				mysql_get_field("LsAmmo4",wdata);
				PlayerInfo[playerid][pAmmo][4] = strval(wdata);

				mysql_get_field("LsWeapon5",wdata);
				PlayerInfo[playerid][pWeapon][5] = strval(wdata);

				mysql_get_field("LsAmmo5",wdata);
				PlayerInfo[playerid][pAmmo][5] = strval(wdata);

				mysql_get_field("LsWeapon6",wdata);
				PlayerInfo[playerid][pWeapon][6] = strval(wdata);

				mysql_get_field("LsAmmo6",wdata);
				PlayerInfo[playerid][pAmmo][6] = strval(wdata);

				mysql_get_field("LsWeapon7",wdata);
				PlayerInfo[playerid][pWeapon][7] = strval(wdata);

				mysql_get_field("LsAmmo7",wdata);
				PlayerInfo[playerid][pAmmo][7] = strval(wdata);

				mysql_get_field("LsWeapon8",wdata);
				PlayerInfo[playerid][pWeapon][8] = strval(wdata);

				mysql_get_field("LsAmmo8",wdata);
				PlayerInfo[playerid][pAmmo][8] = strval(wdata);

				mysql_get_field("LsWeapon9",wdata);
				PlayerInfo[playerid][pWeapon][9] = strval(wdata);

				mysql_get_field("LsAmmo9",wdata);
				PlayerInfo[playerid][pAmmo][9] = strval(wdata);

				mysql_get_field("LsWeapon10",wdata);
				PlayerInfo[playerid][pWeapon][10] = strval(wdata);

				mysql_get_field("LsAmmo10",wdata);
				PlayerInfo[playerid][pAmmo][10] = strval(wdata);

				mysql_get_field("LsWeapon11",wdata);
				PlayerInfo[playerid][pWeapon][11] = strval(wdata);

				mysql_get_field("LsAmmo11",wdata);
				PlayerInfo[playerid][pAmmo][11] = strval(wdata);

				mysql_get_field("LsWeapon12",wdata);
				PlayerInfo[playerid][pWeapon][12] = strval(wdata);

				mysql_get_field("LsAmmo12",wdata);
				PlayerInfo[playerid][pAmmo][12] = strval(wdata);

				mysql_get_field("LsCondom",wdata);
				PlayerInfo[playerid][pCondom] = strval(wdata);

				mysql_get_field("LsStd1",wdata);
				PlayerInfo[playerid][pStd][1] = strval(wdata);

				mysql_get_field("LsStd2",wdata);
				PlayerInfo[playerid][pStd][2] = strval(wdata);

				mysql_get_field("LsStd3",wdata);
				PlayerInfo[playerid][pStd][3] = strval(wdata);

				mysql_get_field("LsStd4",wdata);
				PlayerInfo[playerid][pStd][4] = strval(wdata);

				mysql_get_field("LsChastity",wdata);
				PlayerInfo[playerid][pChastity] = strval(wdata);

				mysql_get_field("LsFightStyle",wdata);
				PlayerInfo[playerid][pFightStyle] = strval(wdata);

				mysql_get_field("LsAdrenaline",wdata);
				PlayerInfo[playerid][pAdrenaline] = strval(wdata);

				mysql_get_field("LsEarnings",wdata);
				PlayerInfo[playerid][pEarnings] = strval(wdata);

				mysql_get_field("LsBank",wdata);
				PlayerInfo[playerid][pBank] = strval(wdata);

				mysql_get_field("LsInterest",wdata);
				PlayerInfo[playerid][pInterest] = strval(wdata);

				mysql_get_field("LsTaxes",wdata);
				PlayerInfo[playerid][pTaxes] = strval(wdata);

				mysql_get_field("LsDebt",wdata);
				PlayerInfo[playerid][pDebt] = strval(wdata);

				mysql_get_field("LsLifeInsurance",wdata);
				PlayerInfo[playerid][pLifeInsurance] = strval(wdata);

				mysql_get_field("LsHealthInsurance",wdata);
				PlayerInfo[playerid][pHealthInsurance] = strval(wdata);

				mysql_get_field("LsBankInsurance",wdata);
				PlayerInfo[playerid][pBankInsurance] = strval(wdata);

				mysql_get_field("LsWantedLevel",wdata);
				PlayerInfo[playerid][pWantedLevel] = strval(wdata);

				mysql_get_field("LsDaysAlive",wdata);
				PlayerInfo[playerid][pDaysAlive] = strval(wdata);

				mysql_get_field("LsDrugs",wdata);
				PlayerInfo[playerid][pDrugs] = strval(wdata);

				mysql_get_field("LsDeaths",wdata);
				PlayerInfo[playerid][pDeaths] = strval(wdata);

				mysql_get_field("LsKills",wdata);
				PlayerInfo[playerid][pKills] = strval(wdata);

				mysql_get_field("LsHeals",wdata);
				PlayerInfo[playerid][pHeals] = strval(wdata);

				mysql_get_field("LsHealed",wdata);
				PlayerInfo[playerid][pHealed] = strval(wdata);

				mysql_get_field("LsVehiclesStolen",wdata);
				PlayerInfo[playerid][pVehiclesStolen] = strval(wdata);

				mysql_get_field("LsVehiclesSold",wdata);
				PlayerInfo[playerid][pVehiclesSold] = strval(wdata);

				mysql_get_field("LsCrimesCommitted",wdata);
				PlayerInfo[playerid][pCrimesCommitted] = strval(wdata);

				mysql_get_field("LsTicketsReceived",wdata);
				PlayerInfo[playerid][pTicketsReceived] = strval(wdata);

				mysql_get_field("LsTicketsPaid",wdata);
				PlayerInfo[playerid][pTicketsPaid] = strval(wdata);

				mysql_get_field("LsTicketsIssued",wdata);
				PlayerInfo[playerid][pTicketsIssued] = strval(wdata);

				mysql_get_field("LsTicketsCollected",wdata);
				PlayerInfo[playerid][pTicketsCollected] = strval(wdata);

				mysql_get_field("LsArrested",wdata);
				PlayerInfo[playerid][pArrested] = strval(wdata);

				mysql_get_field("LsReported",wdata);
				PlayerInfo[playerid][pReported] = strval(wdata);

				mysql_get_field("LsArrests",wdata);
				PlayerInfo[playerid][pArrests] = strval(wdata);

				mysql_get_field("LsReports",wdata);
				PlayerInfo[playerid][pReports] = strval(wdata);

				mysql_get_field("LsHitsReceived",wdata);
				PlayerInfo[playerid][pHitsReceived] = strval(wdata);

				mysql_get_field("LsHitsPlaced",wdata);
				PlayerInfo[playerid][pHitsPlaced] = strval(wdata);

				mysql_get_field("LsRapes",wdata);
				PlayerInfo[playerid][pRapes] = strval(wdata);

				mysql_get_field("LsRaped",wdata);
				PlayerInfo[playerid][pRaped] = strval(wdata);

				mysql_get_field("LsRobberies",wdata);
				PlayerInfo[playerid][pRobberies] = strval(wdata);

				mysql_get_field("LsRobbed",wdata);
				PlayerInfo[playerid][pRobbed] = strval(wdata);

				mysql_get_field("LsBail",wdata);
				PlayerInfo[playerid][pBail] = strval(wdata);

				mysql_get_field("LsJailVisits",wdata);
				PlayerInfo[playerid][pJailVisits] = strval(wdata);

				mysql_get_field("LsJailed",wdata);
				PlayerInfo[playerid][pJailed] = strval(wdata);

				mysql_get_field("LsJailHour",wdata);
				PlayerInfo[playerid][pJailHour] = strval(wdata);

				mysql_get_field("LsJailMinute",wdata);
				PlayerInfo[playerid][pJailMinute] = strval(wdata);

				mysql_get_field("LsHouse",wdata);
				PlayerInfo[playerid][pHouse] = strval(wdata);

				mysql_get_field("LsCar",wdata);
				PlayerInfo[playerid][pCar] = strval(wdata);

				mysql_get_field("LsGunLic",wdata);
				PlayerInfo[playerid][pGunLic] = strval(wdata);


				mysql_get_field("LsMenu_Items",wdata);
				Menu_Items[playerid] = strval(wdata);

				mysql_get_field("LsMenu_ItemName1",wdata);
				strmid(Menu_ItemName[playerid][1], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName2",wdata);
				strmid(Menu_ItemName[playerid][2], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName3",wdata);
				strmid(Menu_ItemName[playerid][3], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName4",wdata);
				strmid(Menu_ItemName[playerid][4], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName5",wdata);
				strmid(Menu_ItemName[playerid][5], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName6",wdata);
				strmid(Menu_ItemName[playerid][6], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName7",wdata);
				strmid(Menu_ItemName[playerid][7], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName8",wdata);
				strmid(Menu_ItemName[playerid][8], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName9",wdata);
				strmid(Menu_ItemName[playerid][9], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LsMenu_ItemName10",wdata);
				strmid(Menu_ItemName[playerid][10], wdata, 0, strlen(wdata), 256);

				mysql_get_field("LsMenu_ItemPrice1",wdata);
				Menu_ItemPrice[playerid][1] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice2",wdata);
				Menu_ItemPrice[playerid][2] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice3",wdata);
				Menu_ItemPrice[playerid][3] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice4",wdata);
				Menu_ItemPrice[playerid][4] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice5",wdata);
				Menu_ItemPrice[playerid][5] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice6",wdata);
				Menu_ItemPrice[playerid][6] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice7",wdata);
				Menu_ItemPrice[playerid][7] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice8",wdata);
				Menu_ItemPrice[playerid][8] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice9",wdata);
				Menu_ItemPrice[playerid][9] = strval(wdata);
				mysql_get_field("LsMenu_ItemPrice10",wdata);
				Menu_ItemPrice[playerid][10] = strval(wdata);

				mysql_get_field("LsMenu_ItemMinPrice1",wdata);
				Menu_ItemMinPrice[playerid][1] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice2",wdata);
				Menu_ItemMinPrice[playerid][2] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice3",wdata);
				Menu_ItemMinPrice[playerid][3] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice4",wdata);
				Menu_ItemMinPrice[playerid][4] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice5",wdata);
				Menu_ItemMinPrice[playerid][5] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice6",wdata);
				Menu_ItemMinPrice[playerid][6] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice7",wdata);
				Menu_ItemMinPrice[playerid][7] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice8",wdata);
				Menu_ItemMinPrice[playerid][8] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice9",wdata);
				Menu_ItemMinPrice[playerid][9] = strval(wdata);
				mysql_get_field("LsMenu_ItemMinPrice10",wdata);
				Menu_ItemMinPrice[playerid][10] = strval(wdata);

				mysql_get_field("LsMenu_ItemMaxPrice1",wdata);
				Menu_ItemMaxPrice[playerid][1] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice2",wdata);
				Menu_ItemMaxPrice[playerid][2] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice3",wdata);
				Menu_ItemMaxPrice[playerid][3] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice4",wdata);
				Menu_ItemMaxPrice[playerid][4] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice5",wdata);
				Menu_ItemMaxPrice[playerid][5] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice6",wdata);
				Menu_ItemMaxPrice[playerid][6] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice7",wdata);
				Menu_ItemMaxPrice[playerid][7] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice8",wdata);
				Menu_ItemMaxPrice[playerid][8] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice9",wdata);
				Menu_ItemMaxPrice[playerid][9] = strval(wdata);
				mysql_get_field("LsMenu_ItemMaxPrice10",wdata);
				Menu_ItemMaxPrice[playerid][10] = strval(wdata);

				}


				case LAS_VENTURAS:
				{

				mysql_get_field("LvResume",wdata);
				PlayerInfo[playerid][pResume] = strval(wdata);

				mysql_get_field("LvClass",wdata);
				PlayerInfo[playerid][pClass] = strval(wdata);

				mysql_get_field("LvTeam",wdata);
				PlayerInfo[playerid][pTeam] = strval(wdata);

				mysql_get_field("LvSkill",wdata);
				PlayerInfo[playerid][pSkill] = strval(wdata);

				mysql_get_field("LvLevel",wdata);
				PlayerInfo[playerid][pLevel] = strval(wdata);

				mysql_get_field("LvRank",wdata);
				PlayerInfo[playerid][pRank] = strval(wdata);

				mysql_get_field("LvMoney",wdata);
				PlayerInfo[playerid][pMoney] = strval(wdata);

				mysql_get_field("LvFakeSkill",wdata);
				PlayerInfo[playerid][pFakeSkill] = strval(wdata);

				mysql_get_field("LvGender",wdata);
				PlayerInfo[playerid][pGender] = strval(wdata);

				mysql_get_field("LvHealth",wdata);
				PlayerInfo[playerid][pHealth] = strval(wdata);

				mysql_get_field("LvArmour",wdata);
				PlayerInfo[playerid][pArmour] = strval(wdata);

				mysql_get_field("LvWeapon1",wdata);
				PlayerInfo[playerid][pWeapon][1] = strval(wdata);

				mysql_get_field("LvAmmo1",wdata);
				PlayerInfo[playerid][pAmmo][1] = strval(wdata);

				mysql_get_field("LvWeapon2",wdata);
				PlayerInfo[playerid][pWeapon][2] = strval(wdata);

				mysql_get_field("LvAmmo2",wdata);
				PlayerInfo[playerid][pAmmo][2] = strval(wdata);

				mysql_get_field("LvWeapon3",wdata);
				PlayerInfo[playerid][pWeapon][3] = strval(wdata);

				mysql_get_field("LvAmmo3",wdata);
				PlayerInfo[playerid][pAmmo][3] = strval(wdata);

				mysql_get_field("LvWeapon4",wdata);
				PlayerInfo[playerid][pWeapon][4] = strval(wdata);

				mysql_get_field("LvAmmo4",wdata);
				PlayerInfo[playerid][pAmmo][4] = strval(wdata);

				mysql_get_field("LvWeapon5",wdata);
				PlayerInfo[playerid][pWeapon][5] = strval(wdata);

				mysql_get_field("LvAmmo5",wdata);
				PlayerInfo[playerid][pAmmo][5] = strval(wdata);

				mysql_get_field("LvWeapon6",wdata);
				PlayerInfo[playerid][pWeapon][6] = strval(wdata);

				mysql_get_field("LvAmmo6",wdata);
				PlayerInfo[playerid][pAmmo][6] = strval(wdata);

				mysql_get_field("LvWeapon7",wdata);
				PlayerInfo[playerid][pWeapon][7] = strval(wdata);

				mysql_get_field("LvAmmo7",wdata);
				PlayerInfo[playerid][pAmmo][7] = strval(wdata);

				mysql_get_field("LvWeapon8",wdata);
				PlayerInfo[playerid][pWeapon][8] = strval(wdata);

				mysql_get_field("LvAmmo8",wdata);
				PlayerInfo[playerid][pAmmo][8] = strval(wdata);

				mysql_get_field("LvWeapon9",wdata);
				PlayerInfo[playerid][pWeapon][9] = strval(wdata);

				mysql_get_field("LvAmmo9",wdata);
				PlayerInfo[playerid][pAmmo][9] = strval(wdata);

				mysql_get_field("LvWeapon10",wdata);
				PlayerInfo[playerid][pWeapon][10] = strval(wdata);

				mysql_get_field("LvAmmo10",wdata);
				PlayerInfo[playerid][pAmmo][10] = strval(wdata);

				mysql_get_field("LvWeapon11",wdata);
				PlayerInfo[playerid][pWeapon][11] = strval(wdata);

				mysql_get_field("LvAmmo11",wdata);
				PlayerInfo[playerid][pAmmo][11] = strval(wdata);

				mysql_get_field("LvWeapon12",wdata);
				PlayerInfo[playerid][pWeapon][12] = strval(wdata);

				mysql_get_field("LvAmmo12",wdata);
				PlayerInfo[playerid][pAmmo][12] = strval(wdata);

				mysql_get_field("LvCondom",wdata);
				PlayerInfo[playerid][pCondom] = strval(wdata);

				mysql_get_field("LvStd1",wdata);
				PlayerInfo[playerid][pStd][1] = strval(wdata);

				mysql_get_field("LvStd2",wdata);
				PlayerInfo[playerid][pStd][2] = strval(wdata);

				mysql_get_field("LvStd3",wdata);
				PlayerInfo[playerid][pStd][3] = strval(wdata);

				mysql_get_field("LvStd4",wdata);
				PlayerInfo[playerid][pStd][4] = strval(wdata);

				mysql_get_field("LvChastity",wdata);
				PlayerInfo[playerid][pChastity] = strval(wdata);

				mysql_get_field("LvFightStyle",wdata);
				PlayerInfo[playerid][pFightStyle] = strval(wdata);

				mysql_get_field("LvAdrenaline",wdata);
				PlayerInfo[playerid][pAdrenaline] = strval(wdata);

				mysql_get_field("LvEarnings",wdata);
				PlayerInfo[playerid][pEarnings] = strval(wdata);

				mysql_get_field("LvBank",wdata);
				PlayerInfo[playerid][pBank] = strval(wdata);

				mysql_get_field("LvInterest",wdata);
				PlayerInfo[playerid][pInterest] = strval(wdata);

				mysql_get_field("LvTaxes",wdata);
				PlayerInfo[playerid][pTaxes] = strval(wdata);

				mysql_get_field("LvDebt",wdata);
				PlayerInfo[playerid][pDebt] = strval(wdata);

				mysql_get_field("LvLifeInsurance",wdata);
				PlayerInfo[playerid][pLifeInsurance] = strval(wdata);

				mysql_get_field("LvHealthInsurance",wdata);
				PlayerInfo[playerid][pHealthInsurance] = strval(wdata);

				mysql_get_field("LvBankInsurance",wdata);
				PlayerInfo[playerid][pBankInsurance] = strval(wdata);

				mysql_get_field("LvWantedLevel",wdata);
				PlayerInfo[playerid][pWantedLevel] = strval(wdata);

				mysql_get_field("LvDaysAlive",wdata);
				PlayerInfo[playerid][pDaysAlive] = strval(wdata);

				mysql_get_field("LvDrugs",wdata);
				PlayerInfo[playerid][pDrugs] = strval(wdata);

				mysql_get_field("LvDeaths",wdata);
				PlayerInfo[playerid][pDeaths] = strval(wdata);

				mysql_get_field("LvKills",wdata);
				PlayerInfo[playerid][pKills] = strval(wdata);

				mysql_get_field("LvHeals",wdata);
				PlayerInfo[playerid][pHeals] = strval(wdata);

				mysql_get_field("LvHealed",wdata);
				PlayerInfo[playerid][pHealed] = strval(wdata);

				mysql_get_field("LvVehiclesStolen",wdata);
				PlayerInfo[playerid][pVehiclesStolen] = strval(wdata);

				mysql_get_field("LvVehiclesSold",wdata);
				PlayerInfo[playerid][pVehiclesSold] = strval(wdata);

				mysql_get_field("LvCrimesCommitted",wdata);
				PlayerInfo[playerid][pCrimesCommitted] = strval(wdata);

				mysql_get_field("LvTicketsReceived",wdata);
				PlayerInfo[playerid][pTicketsReceived] = strval(wdata);

				mysql_get_field("LvTicketsPaid",wdata);
				PlayerInfo[playerid][pTicketsPaid] = strval(wdata);

				mysql_get_field("LvTicketsIssued",wdata);
				PlayerInfo[playerid][pTicketsIssued] = strval(wdata);

				mysql_get_field("LvTicketsCollected",wdata);
				PlayerInfo[playerid][pTicketsCollected] = strval(wdata);

				mysql_get_field("LvArrested",wdata);
				PlayerInfo[playerid][pArrested] = strval(wdata);

				mysql_get_field("LvReported",wdata);
				PlayerInfo[playerid][pReported] = strval(wdata);

				mysql_get_field("LvArrests",wdata);
				PlayerInfo[playerid][pArrests] = strval(wdata);

				mysql_get_field("LvReports",wdata);
				PlayerInfo[playerid][pReports] = strval(wdata);

				mysql_get_field("LvHitsReceived",wdata);
				PlayerInfo[playerid][pHitsReceived] = strval(wdata);

				mysql_get_field("LvHitsPlaced",wdata);
				PlayerInfo[playerid][pHitsPlaced] = strval(wdata);

				mysql_get_field("LvRapes",wdata);
				PlayerInfo[playerid][pRapes] = strval(wdata);

				mysql_get_field("LvRaped",wdata);
				PlayerInfo[playerid][pRaped] = strval(wdata);

				mysql_get_field("LvRobberies",wdata);
				PlayerInfo[playerid][pRobberies] = strval(wdata);

				mysql_get_field("LvRobbed",wdata);
				PlayerInfo[playerid][pRobbed] = strval(wdata);

				mysql_get_field("LvBail",wdata);
				PlayerInfo[playerid][pBail] = strval(wdata);

				mysql_get_field("LvJailVisits",wdata);
				PlayerInfo[playerid][pJailVisits] = strval(wdata);

				mysql_get_field("LvJailed",wdata);
				PlayerInfo[playerid][pJailed] = strval(wdata);

				mysql_get_field("LvJailHour",wdata);
				PlayerInfo[playerid][pJailHour] = strval(wdata);

				mysql_get_field("LvJailMinute",wdata);
				PlayerInfo[playerid][pJailMinute] = strval(wdata);

				mysql_get_field("LvHouse",wdata);
				PlayerInfo[playerid][pHouse] = strval(wdata);

				mysql_get_field("LvCar",wdata);
				PlayerInfo[playerid][pCar] = strval(wdata);

				mysql_get_field("LvGunLic",wdata);
				PlayerInfo[playerid][pGunLic] = strval(wdata);



				mysql_get_field("LvMenu_Items",wdata);
				Menu_Items[playerid] = strval(wdata);

				mysql_get_field("LvMenu_ItemName1",wdata);
				strmid(Menu_ItemName[playerid][1], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName2",wdata);
				strmid(Menu_ItemName[playerid][2], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName3",wdata);
				strmid(Menu_ItemName[playerid][3], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName4",wdata);
				strmid(Menu_ItemName[playerid][4], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName5",wdata);
				strmid(Menu_ItemName[playerid][5], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName6",wdata);
				strmid(Menu_ItemName[playerid][6], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName7",wdata);
				strmid(Menu_ItemName[playerid][7], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName8",wdata);
				strmid(Menu_ItemName[playerid][8], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName9",wdata);
				strmid(Menu_ItemName[playerid][9], wdata, 0, strlen(wdata), 256);
				mysql_get_field("LvMenu_ItemName10",wdata);
				strmid(Menu_ItemName[playerid][10], wdata, 0, strlen(wdata), 256);

				mysql_get_field("LvMenu_ItemPrice1",wdata);
				Menu_ItemPrice[playerid][1] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice2",wdata);
				Menu_ItemPrice[playerid][2] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice3",wdata);
				Menu_ItemPrice[playerid][3] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice4",wdata);
				Menu_ItemPrice[playerid][4] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice5",wdata);
				Menu_ItemPrice[playerid][5] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice6",wdata);
				Menu_ItemPrice[playerid][6] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice7",wdata);
				Menu_ItemPrice[playerid][7] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice8",wdata);
				Menu_ItemPrice[playerid][8] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice9",wdata);
				Menu_ItemPrice[playerid][9] = strval(wdata);
				mysql_get_field("LvMenu_ItemPrice10",wdata);
				Menu_ItemPrice[playerid][10] = strval(wdata);

				mysql_get_field("LvMenu_ItemMinPrice1",wdata);
				Menu_ItemMinPrice[playerid][1] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice2",wdata);
				Menu_ItemMinPrice[playerid][2] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice3",wdata);
				Menu_ItemMinPrice[playerid][3] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice4",wdata);
				Menu_ItemMinPrice[playerid][4] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice5",wdata);
				Menu_ItemMinPrice[playerid][5] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice6",wdata);
				Menu_ItemMinPrice[playerid][6] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice7",wdata);
				Menu_ItemMinPrice[playerid][7] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice8",wdata);
				Menu_ItemMinPrice[playerid][8] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice9",wdata);
				Menu_ItemMinPrice[playerid][9] = strval(wdata);
				mysql_get_field("LvMenu_ItemMinPrice10",wdata);
				Menu_ItemMinPrice[playerid][10] = strval(wdata);

				mysql_get_field("LvMenu_ItemMaxPrice1",wdata);
				Menu_ItemMaxPrice[playerid][1] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice2",wdata);
				Menu_ItemMaxPrice[playerid][2] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice3",wdata);
				Menu_ItemMaxPrice[playerid][3] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice4",wdata);
				Menu_ItemMaxPrice[playerid][4] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice5",wdata);
				Menu_ItemMaxPrice[playerid][5] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice6",wdata);
				Menu_ItemMaxPrice[playerid][6] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice7",wdata);
				Menu_ItemMaxPrice[playerid][7] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice8",wdata);
				Menu_ItemMaxPrice[playerid][8] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice9",wdata);
				Menu_ItemMaxPrice[playerid][9] = strval(wdata);
				mysql_get_field("LvMenu_ItemMaxPrice10",wdata);
				Menu_ItemMaxPrice[playerid][10] = strval(wdata);

				}

				case SAN_FIERRO:
				{

				mysql_get_field("SfResume",wdata);
				PlayerInfo[playerid][pResume] = strval(wdata);

				mysql_get_field("SfClass",wdata);
				PlayerInfo[playerid][pClass] = strval(wdata);

				mysql_get_field("SfTeam",wdata);
				PlayerInfo[playerid][pTeam] = strval(wdata);

				mysql_get_field("SfSkill",wdata);
				PlayerInfo[playerid][pSkill] = strval(wdata);

				mysql_get_field("SfLevel",wdata);
				PlayerInfo[playerid][pLevel] = strval(wdata);

				mysql_get_field("SfRank",wdata);
				PlayerInfo[playerid][pRank] = strval(wdata);

				mysql_get_field("SfMoney",wdata);
				PlayerInfo[playerid][pMoney] = strval(wdata);

				mysql_get_field("SfFakeSkill",wdata);
				PlayerInfo[playerid][pFakeSkill] = strval(wdata);

				mysql_get_field("SfGender",wdata);
				PlayerInfo[playerid][pGender] = strval(wdata);

				mysql_get_field("SfHealth",wdata);
				PlayerInfo[playerid][pHealth] = strval(wdata);

				mysql_get_field("SfArmour",wdata);
				PlayerInfo[playerid][pArmour] = strval(wdata);

				mysql_get_field("SfWeapon1",wdata);
				PlayerInfo[playerid][pWeapon][1] = strval(wdata);

				mysql_get_field("SfAmmo1",wdata);
				PlayerInfo[playerid][pAmmo][1] = strval(wdata);

				mysql_get_field("SfWeapon2",wdata);
				PlayerInfo[playerid][pWeapon][2] = strval(wdata);

				mysql_get_field("SfAmmo2",wdata);
				PlayerInfo[playerid][pAmmo][2] = strval(wdata);

				mysql_get_field("SfWeapon3",wdata);
				PlayerInfo[playerid][pWeapon][3] = strval(wdata);

				mysql_get_field("SfAmmo3",wdata);
				PlayerInfo[playerid][pAmmo][3] = strval(wdata);

				mysql_get_field("SfWeapon4",wdata);
				PlayerInfo[playerid][pWeapon][4] = strval(wdata);

				mysql_get_field("SfAmmo4",wdata);
				PlayerInfo[playerid][pAmmo][4] = strval(wdata);

				mysql_get_field("SfWeapon5",wdata);
				PlayerInfo[playerid][pWeapon][5] = strval(wdata);

				mysql_get_field("SfAmmo5",wdata);
				PlayerInfo[playerid][pAmmo][5] = strval(wdata);

				mysql_get_field("SfWeapon6",wdata);
				PlayerInfo[playerid][pWeapon][6] = strval(wdata);

				mysql_get_field("SfAmmo6",wdata);
				PlayerInfo[playerid][pAmmo][6] = strval(wdata);

				mysql_get_field("SfWeapon7",wdata);
				PlayerInfo[playerid][pWeapon][7] = strval(wdata);

				mysql_get_field("SfAmmo7",wdata);
				PlayerInfo[playerid][pAmmo][7] = strval(wdata);

				mysql_get_field("SfWeapon8",wdata);
				PlayerInfo[playerid][pWeapon][8] = strval(wdata);

				mysql_get_field("SfAmmo8",wdata);
				PlayerInfo[playerid][pAmmo][8] = strval(wdata);

				mysql_get_field("SfWeapon9",wdata);
				PlayerInfo[playerid][pWeapon][9] = strval(wdata);

				mysql_get_field("SfAmmo9",wdata);
				PlayerInfo[playerid][pAmmo][9] = strval(wdata);

				mysql_get_field("SfWeapon10",wdata);
				PlayerInfo[playerid][pWeapon][10] = strval(wdata);

				mysql_get_field("SfAmmo10",wdata);
				PlayerInfo[playerid][pAmmo][10] = strval(wdata);

				mysql_get_field("SfWeapon11",wdata);
				PlayerInfo[playerid][pWeapon][11] = strval(wdata);

				mysql_get_field("SfAmmo11",wdata);
				PlayerInfo[playerid][pAmmo][11] = strval(wdata);

				mysql_get_field("SfWeapon12",wdata);
				PlayerInfo[playerid][pWeapon][12] = strval(wdata);

				mysql_get_field("SfAmmo12",wdata);
				PlayerInfo[playerid][pAmmo][12] = strval(wdata);

				mysql_get_field("SfCondom",wdata);
				PlayerInfo[playerid][pCondom] = strval(wdata);

				mysql_get_field("SfStd1",wdata);
				PlayerInfo[playerid][pStd][1] = strval(wdata);

				mysql_get_field("SfStd2",wdata);
				PlayerInfo[playerid][pStd][2] = strval(wdata);

				mysql_get_field("SfStd3",wdata);
				PlayerInfo[playerid][pStd][3] = strval(wdata);

				mysql_get_field("SfStd4",wdata);
				PlayerInfo[playerid][pStd][4] = strval(wdata);

				mysql_get_field("SfChastity",wdata);
				PlayerInfo[playerid][pChastity] = strval(wdata);

				mysql_get_field("SfFightStyle",wdata);
				PlayerInfo[playerid][pFightStyle] = strval(wdata);

				mysql_get_field("SfAdrenaline",wdata);
				PlayerInfo[playerid][pAdrenaline] = strval(wdata);

				mysql_get_field("SfEarnings",wdata);
				PlayerInfo[playerid][pEarnings] = strval(wdata);

				mysql_get_field("SfBank",wdata);
				PlayerInfo[playerid][pBank] = strval(wdata);

				mysql_get_field("SfInterest",wdata);
				PlayerInfo[playerid][pInterest] = strval(wdata);

				mysql_get_field("SfTaxes",wdata);
				PlayerInfo[playerid][pTaxes] = strval(wdata);

				mysql_get_field("SfDebt",wdata);
				PlayerInfo[playerid][pDebt] = strval(wdata);

				mysql_get_field("SfLifeInsurance",wdata);
				PlayerInfo[playerid][pLifeInsurance] = strval(wdata);

				mysql_get_field("SfHealthInsurance",wdata);
				PlayerInfo[playerid][pHealthInsurance] = strval(wdata);

				mysql_get_field("SfBankInsurance",wdata);
				PlayerInfo[playerid][pBankInsurance] = strval(wdata);

				mysql_get_field("SfWantedLevel",wdata);
				PlayerInfo[playerid][pWantedLevel] = strval(wdata);

				mysql_get_field("SfDaysAlive",wdata);
				PlayerInfo[playerid][pDaysAlive] = strval(wdata);

				mysql_get_field("SfDrugs",wdata);
				PlayerInfo[playerid][pDrugs] = strval(wdata);

				mysql_get_field("SfDeaths",wdata);
				PlayerInfo[playerid][pDeaths] = strval(wdata);

				mysql_get_field("SfKills",wdata);
				PlayerInfo[playerid][pKills] = strval(wdata);

				mysql_get_field("SfHeals",wdata);
				PlayerInfo[playerid][pHeals] = strval(wdata);

				mysql_get_field("SfHealed",wdata);
				PlayerInfo[playerid][pHealed] = strval(wdata);

				mysql_get_field("SfVehiclesStolen",wdata);
				PlayerInfo[playerid][pVehiclesStolen] = strval(wdata);

				mysql_get_field("SfVehiclesSold",wdata);
				PlayerInfo[playerid][pVehiclesSold] = strval(wdata);

				mysql_get_field("SfCrimesCommitted",wdata);
				PlayerInfo[playerid][pCrimesCommitted] = strval(wdata);

				mysql_get_field("SfTicketsReceived",wdata);
				PlayerInfo[playerid][pTicketsReceived] = strval(wdata);

				mysql_get_field("SfTicketsPaid",wdata);
				PlayerInfo[playerid][pTicketsPaid] = strval(wdata);

				mysql_get_field("SfTicketsIssued",wdata);
				PlayerInfo[playerid][pTicketsIssued] = strval(wdata);

				mysql_get_field("SfTicketsCollected",wdata);
				PlayerInfo[playerid][pTicketsCollected] = strval(wdata);

				mysql_get_field("SfArrested",wdata);
				PlayerInfo[playerid][pArrested] = strval(wdata);

				mysql_get_field("SfReported",wdata);
				PlayerInfo[playerid][pReported] = strval(wdata);

				mysql_get_field("SfArrests",wdata);
				PlayerInfo[playerid][pArrests] = strval(wdata);

				mysql_get_field("SfReports",wdata);
				PlayerInfo[playerid][pReports] = strval(wdata);

				mysql_get_field("SfHitsReceived",wdata);
				PlayerInfo[playerid][pHitsReceived] = strval(wdata);

				mysql_get_field("SfHitsPlaced",wdata);
				PlayerInfo[playerid][pHitsPlaced] = strval(wdata);

				mysql_get_field("SfRapes",wdata);
				PlayerInfo[playerid][pRapes] = strval(wdata);

				mysql_get_field("SfRaped",wdata);
				PlayerInfo[playerid][pRaped] = strval(wdata);

				mysql_get_field("SfRobberies",wdata);
				PlayerInfo[playerid][pRobberies] = strval(wdata);

				mysql_get_field("SfRobbed",wdata);
				PlayerInfo[playerid][pRobbed] = strval(wdata);

				mysql_get_field("SfBail",wdata);
				PlayerInfo[playerid][pBail] = strval(wdata);

				mysql_get_field("SfJailVisits",wdata);
				PlayerInfo[playerid][pJailVisits] = strval(wdata);

				mysql_get_field("SfJailed",wdata);
				PlayerInfo[playerid][pJailed] = strval(wdata);

				mysql_get_field("SfJailHour",wdata);
				PlayerInfo[playerid][pJailHour] = strval(wdata);

				mysql_get_field("SfJailMinute",wdata);
				PlayerInfo[playerid][pJailMinute] = strval(wdata);

				mysql_get_field("SfHouse",wdata);
				PlayerInfo[playerid][pHouse] = strval(wdata);

				mysql_get_field("SfCar",wdata);
				PlayerInfo[playerid][pCar] = strval(wdata);

				mysql_get_field("SfGunLic",wdata);
				PlayerInfo[playerid][pGunLic] = strval(wdata);

				mysql_get_field("SfMenu_Items",wdata);
				Menu_Items[playerid] = strval(wdata);

				mysql_get_field("SfMenu_ItemName1",wdata);
				strmid(Menu_ItemName[playerid][1], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName2",wdata);
				strmid(Menu_ItemName[playerid][2], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName3",wdata);
				strmid(Menu_ItemName[playerid][3], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName4",wdata);
				strmid(Menu_ItemName[playerid][4], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName5",wdata);
				strmid(Menu_ItemName[playerid][5], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName6",wdata);
				strmid(Menu_ItemName[playerid][6], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName7",wdata);
				strmid(Menu_ItemName[playerid][7], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName8",wdata);
				strmid(Menu_ItemName[playerid][8], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName9",wdata);
				strmid(Menu_ItemName[playerid][9], wdata, 0, strlen(wdata), 256);
				mysql_get_field("SfMenu_ItemName10",wdata);
				strmid(Menu_ItemName[playerid][10], wdata, 0, strlen(wdata), 256);


				mysql_get_field("SfMenu_ItemPrice1",wdata);
				Menu_ItemPrice[playerid][1] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice2",wdata);
				Menu_ItemPrice[playerid][2] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice3",wdata);
				Menu_ItemPrice[playerid][3] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice4",wdata);
				Menu_ItemPrice[playerid][4] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice5",wdata);
				Menu_ItemPrice[playerid][5] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice6",wdata);
				Menu_ItemPrice[playerid][6] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice7",wdata);
				Menu_ItemPrice[playerid][7] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice8",wdata);
				Menu_ItemPrice[playerid][8] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice9",wdata);
				Menu_ItemPrice[playerid][9] = strval(wdata);
				mysql_get_field("SfMenu_ItemPrice10",wdata);
				Menu_ItemPrice[playerid][10] = strval(wdata);

				mysql_get_field("SfMenu_ItemMinPrice1",wdata);
				Menu_ItemMinPrice[playerid][1] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice2",wdata);
				Menu_ItemMinPrice[playerid][2] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice3",wdata);
				Menu_ItemMinPrice[playerid][3] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice4",wdata);
				Menu_ItemMinPrice[playerid][4] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice5",wdata);
				Menu_ItemMinPrice[playerid][5] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice6",wdata);
				Menu_ItemMinPrice[playerid][6] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice7",wdata);
				Menu_ItemMinPrice[playerid][7] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice8",wdata);
				Menu_ItemMinPrice[playerid][8] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice9",wdata);
				Menu_ItemMinPrice[playerid][9] = strval(wdata);
				mysql_get_field("SfMenu_ItemMinPrice10",wdata);
				Menu_ItemMinPrice[playerid][10] = strval(wdata);

				mysql_get_field("SfMenu_ItemMaxPrice1",wdata);
				Menu_ItemMaxPrice[playerid][1] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice2",wdata);
				Menu_ItemMaxPrice[playerid][2] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice3",wdata);
				Menu_ItemMaxPrice[playerid][3] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice4",wdata);
				Menu_ItemMaxPrice[playerid][4] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice5",wdata);
				Menu_ItemMaxPrice[playerid][5] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice6",wdata);
				Menu_ItemMaxPrice[playerid][6] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice7",wdata);
				Menu_ItemMaxPrice[playerid][7] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice8",wdata);
				Menu_ItemMaxPrice[playerid][8] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice9",wdata);
				Menu_ItemMaxPrice[playerid][9] = strval(wdata);
				mysql_get_field("SfMenu_ItemMaxPrice10",wdata);
				Menu_ItemMaxPrice[playerid][10] = strval(wdata);

				}




			}//End Of Switch


			}
			mysql_free_result();


			PlayerInfo[playerid][pLoginTimes] += 1;

			format(query,sizeof(query),"UPDATE playerdata SET IP = '%s' WHERE (UserName = '%s')",PIP,PlayerInfo[playerid][pName]);
			mysql_query(query); //queries

			format(query,sizeof(query),"UPDATE playerdata SET LastLogin = '%s', LoginTimes = '%d' WHERE UserName = '%s'",LastLogin,PlayerInfo[playerid][pLoginTimes],PlayerInfo[playerid][pName]);
			mysql_query(query); //queries

        	mysql_free_result(); //Frees the result


			PlayerInfo[playerid][pLogged] = 1;
   			PlayerInfo[playerid][pRegistered] = 1;

   			PlayerInfo[playerid][pLoginTimes] ++;

			if(PlayerInfo[playerid][pAdminLevel] > 0) {

			format(string, sizeof(string), "Logged In As Level %i {FF0000}Admin.",PlayerInfo[playerid][pAdminLevel]);
   			SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, string);

			}else{

			if(PlayerInfo[playerid][pRegular] > 0) {

			format(string, sizeof(string), "Logged In As Level %i {D6D631}Regular Player.",PlayerInfo[playerid][pRegular]);
			SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, string);


			}else{
			SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "Logged In As {D6D631}Registered Player.");
			}

			}
			new classid = PlayerInfo[playerid][pClass];

			OnPlayerRequestClass(playerid, classid);
			//mysql_free_result();

			} else {


			SendClientMessage(playerid, COLOR_ERROR, "Incorrect Password");
			SendClientMessage(playerid, COLOR_SERVER_HELP_MSG, "Please Re-Enter Your Password.");
			SetPVarInt(playerid, "WrongPass", GetPVarInt(playerid, "WrongPass") + 1);


			format(string, sizeof(string), "CnR\n \nThe Name, %s, is Rgistered.\nIf this is not your account, please quit and change your name.\n \nPlease Enter Your Password To Login:",PlayerInfo[playerid][pName],playerid);
			ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "CnR Login", string, "Login", "Cancel");

			if(GetPVarInt(playerid, "WrongPass") == 3)
			{
			mysql_free_result();
			KickPlayer(playerid,"Server","INVALID LOGIN","Too Many Failed Login's!");
			}

			}
			

        }else{//End Of Response Check
        SendClientMessage(playerid, COLOR_SERVER_MAIN_MSG, "{FFFFFF}Please {FF0000}Change Your Name {FFFFFF}In The {00AAFF}SA-MP Server Browser {FFFFFF}And Reconnect.");
        }
        
    }//End Of Dialog Check
    
    
    return 1;
Код:
    for(new i = 0; i < GetMaxPlayers(); i++)
	{
		if(IsPlayerConnected(i) && !IsPlayerNPC(i))
		{


			if(PlayerInfo[i][pClassselection] > 0 && PlayerInfo[i][pSpawn] == 0)
			{
			PlayerInfo[i][pClassselection] --;


			if(PlayerInfo[i][pClassselection] == 1)
			{

			if (PlayerInfo[i][pRegistered] == 1 && PlayerInfo[i][pLogged] == 0)
			{
			format(string, sizeof(string), "CnR\n \nThe Name, %s, is Rgistered.\nIf this is not your account, please quit and change your name.\n \nPlease Enter Your Password To Login:",PlayerInfo[i][pName]);
			ShowPlayerDialog(i, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "Login", string, "Login", "Cancel");
Код:
dcmd_register(playerid, params[])
{
	#pragma unused params
	new string[256];

	if (PlayerInfo[playerid][pRegistered] == 0)
	{

	format(string, sizeof(string), "Cops And Robbers\n \nNew Registration - Name: %s\n \nDo Not Register Multiple Accounts\nDo Not Use The Same Password That You Use Elsewhere\nMinimum 6 Chars Maximum 12 Chars\n \nPlease Enter A Password For Your Account:",PlayerInfo[playerid][pName],playerid);
	ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT , "CnR Registration",string, "Register", "Cancel");

	}else{
	SendClientMessage(playerid, COLOR_ERROR, "You Are Already Registered.");
	}
	return 1;
Reply
#8

You are showing only one dialog here.
pawn Код:
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "Login", string, "Login", "Cancel");
That's Correct.

Press CTRL+F and type ShowPlayerDialog and see if there's any other dialog other than the one above.
Reply
#9

This is the second dialog which comes after later

pawn Код:
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "CnR Login", string, "Login", "Cancel");
Reply
#10

Quote:
Originally Posted by Rudy_
Посмотреть сообщение
This is the second dialog which comes after later

pawn Код:
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT , "CnR Login", string, "Login", "Cancel");
Should I change or delete this one?
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)