Вопросы

Гость KySa4Ka
Новичок
#pragma tabsize 0
#include <a_samp>
#include <a_mysql>
#include <fix>
#include <foreach>
#include <pawn.cmd>
#include <Pawn.Regex>
#include <sscanf2>
#include <crashdetect>
#include <streamer>
//==============================================================================
#define MYSQL_HOST                "localhost"
#define MYSQL_USER                "root"
#define MYSQL_PASS		          ""
#define MYSQL_BASE            	  "acc"
//==============================================================================
#define COLOR_RED 0xAA3333AA
#define COLOR_GREY 0xAFAFAFAA
#define COLOR_YELLOW 0xFFFF00AA
#define COLOR_PINK 0xFF66FFAA
#define COLOR_BLUE 0x0000BBAA
#define COLOR_WHITE 0xFFFFFFAA
#define COLOR_DARKRED 0x660000AA
#define COLOR_ORANGE 0xFF9900AA
#define COLOR_BRIGHTRED 0xFF0000AA
#define COLOR_INDIGO 0x4B00B0AA
#define COLOR_VIOLET 0x9955DEEE
#define COLOR_LIGHTRED 0xFF99AADD
#define COLOR_SEAGREEN 0x00EEADDF
#define COLOR_GRAYWHITE 0xEEEEFFC4
#define COLOR_LIGHTNEUTRALBLUE 0xabcdef66
#define COLOR_GREENISHGOLD 0xCCFFDD56
#define COLOR_LIGHTBLUEGREEN 0x0FFDD349
#define COLOR_NEUTRALBLUE 0xABCDEF01
#define COLOR_LIGHTCYAN 0xAAFFCC33
#define COLOR_LEMON 0xDDDD2357
#define COLOR_MEDIUMBLUE 0x63AFF00A
#define COLOR_NEUTRAL 0xABCDEF97
#define COLOR_BLACK 0x00000000
#define COLOR_NEUTRALGREEN 0x81CFAB00
#define COLOR_DARKGREEN 0x12900BBF
#define COLOR_LIGHTGREEN 0x24FF0AB9
#define COLOR_DARKBLUE 0x300FFAAB
#define COLOR_BLUEGREEN 0x46BBAA00
#define COLOR_PINK 0xFF66FFAA
#define COLOR_LIGHTBLUE 0x33CCFFAA
#define COLOR_DARKRED 0x660000AA
#define COLOR_ORANGE 0xFF9900AA
#define COLOR_PURPLE 0x800080AA
#define COLOR_GRAD1 0xB4B5B7FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_RED1 0xFF0000AA
#define COLOR_GREY 0xAFAFAFAA
#define COLOR_GREEN 0x33AA33AA
#define COLOR_RED 0xAA3333AA
#define COLOR_YELLOW 0xFFFF00AA
#define COLOR_WHITE 0xFFFFFFAA
#define COLOR_BROWN 0x993300AA
#define COLOR_CYAN 0x99FFFFAA
#define COLOR_TAN 0xFFFFCCAA
#define COLOR_PINK 0xFF66FFAA
#define COLOR_KHAKI 0x999900AA
#define COLOR_LIME 0x99FF00AA
#define COLOR_SYSTEM 0xEFEFF7AA
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_GRAD4 0xD8D8D8FF
#define COLOR_GRAD6 0xF0F0F0FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_GRAD3 0xCBCCCEFF
#define COLOR_GRAD5 0xE3E3E3FF
#define COLOR_GRAD1 0xB4B5B7FF
//==============================================================================
#define SCM 	SendClientMessage
#define SCMTA   SendClientMessageToAll
#define SPD     ShowPlayerDialog
#define DSL     DIALOG_STYLE_LIST
#define DSI     DIALOG_STYLE_INPUT
#define DSM     DIALOG_STYLE_MSGBOX
#define DSP     DIALOG_STYLE_PASSWORD
//==============================================================================
//==============================================================================
main()
{
	print("\n----------------------------------");
	print("--------SERVER ACCEPT------");
	print("----------ACCEPT-----------");
	print("----------------------------------\n");
}
//==============================================================================
enum player
{
	ID,
 	NAME[MAX_PLAYER_NAME],
	PASSWORD[24],
	MAIL[64],
	REF,
	SEX,
	AGE,
	SKIN,
}

new infoP[MAX_PLAYERS][player];
new MySQL:dbHandle;
enum dialogs
{
	DLG_NONE,
	DLG_REG,
	DLG_REGM,
	DLG_REGREF,
	DLG_REGP,
	DLG_REGAGE,
	DLG_LOG
}
//==============================================================================
public OnGameModeInit()
{
	EnableStuntBonusForAll(0);
	SetGameModeText("B 0.1");
	ConnectMySQL();
	return 1;
}
stock ConnectMySQL()
{
	dbHandle = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_BASE);
	switch (mysql_errno())
	{
	    case 0: print("ÏÎÄÊËÞ×ÅÍÈÅ Ê MYSQL ÓÑÏÅØÍÎ");
		default: print("ÏÎÄÊËÞ×ÅÍÈÅ Ê MYSQL ÍÅ ÏÐÎØËÎ");
	}
	mysql_log(ERROR | WARNING);
	mysql_set_charset("cp1251");
}
public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    return 1;
}
public OnPlayerConnect(playerid)
{
	GetPlayerName(playerid, infoP[playerid][NAME], MAX_PLAYER_NAME);
	TogglePlayerSpectating(playerid, 1);
	static const fmt_query[] = "SELECT `password` FROM `users` WHERE `name` = '%s'";
	new query[sizeof(fmt_query)+(-2+MAX_PLAYER_NAME)];
	format(query, sizeof(query), fmt_query, infoP[player][NAME]);
	mysql_tquery(dbHandle, query, "CheckReg", "i", playerid);
	
	return 1;
}

forward CheckReg(playerid);
public CheckReg(playerid)
{
	new rows;
	cache_get_row_count(rows);
	if(rows)
	{
		ShowLog(playerid);
	}
	else
	{
		ShowReg(playerid);
	}
}

stock ShowLog(playerid)
{
    cache_get_value_name(0, "PASSWORD", infoP[playerid][PASSWORD], 24);
	SCM(playerid, COLOR_RED, "Âàø àêêàóíò çàðåãåñòðèðîâàí");
}
stock ShowReg(playerid)
{
    new dialog[600];
    format(dialog, sizeof(dialog),
		"\t\t{FFFFFF}Óâàæàåìûé {FF00AA}%s{FFFFFF} äîáðî ïîæàëîâàòü íà ïðîåêò {66FFAA}NAME{FFFFFF}\n\n\
		 \t\t\tÈãðîê {FF00AA}%s{FFFFFF} íå çàðåãåñòðèðîâàí\n\
		 \tÄëÿ ïðîäîëæåíèå èãðû, âàì íå îáõîäèìî ïðîéòè ðåãåñòðàöèþ\n\n\
		 \t{66FFAA}Ïðèìè÷ÿíèå - Ïàðîëü ìîæåò ñîäåðæàòü îò 6 äî 24 ñèìâîëîâ\n\
		 \t{66FFAA}Ïðèìè÷ÿíèå - Ïàðîëü äîëæåí ñîäåðæàòü òîëüêî öèôðû è ëàòèíñêèè ñèìâîëû\n\
		 \t{66FFAA}Ïðèìè÷ÿíèå - Ñòðî÷êà ââîäà ïàðîëü äîëæíà áûòü çàïîëíåíà\n\n\
		 \t\tÀäìèíèñòðàöèÿ {66FFAA}NAME{FFFFFF} æåëàåò óäà÷íîé ðåãåñòðàöè",
    infoP[playerid][NAME], infoP[playerid][NAME]
	);
	SPD(playerid, DLG_REG, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ïàðîëü", dialog, "Äàëåå", "Âûõîä");
}

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}

public OnPlayerSpawn(playerid)
{
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	return 0;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	switch(dialogid)
	{
		case DLG_REG:
		{
		    if(response)
		    {
				if(!strlen(inputtext))
				{
				    ShowReg(playerid);
				    return SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} ß æå ïðåäóïðèäèë ÷òî ââîä ïàðîëü {0000AA}îáÿçàòåëüíûé");
				}
				if(strlen(inputtext) < 6 || strlen(inputtext) > 24)
				{
					ShowReg(playerid);
				    return SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} ß æå ïðåäóïðèäèë ÷òî ïàðîëü {0000AA}äîëæåí ñîäåðæàòü îò 6 äî 24 ñèìâîëîâ");
				}
				new regex:rg_passcheck = regex_new("^[a-zA-Z0-9]{1,}$");
				if(regex_check(inputtext, rg_passcheck))
				{
				    strmid(infoP[playerid][PASSWORD], inputtext, 0, strlen(inputtext), 24);
					SPD(playerid, DLG_REGM, DSI,
					"{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ìûëî",
					"\t\t\t{FFFFFF}Ïîçäðîâëÿåì âû óñïåøíî ñîçäàëè ïàðîëü\n\
					äëÿ ïðîäîëæåíèå ñîçäàíèå ïåðñîíàæà ðåêîìåíäóåì îáåçîïàñèòü âàø àêêàóíò ïðèâÿçàâ ïî÷òó\n\
					\t{FF00AA}Ïùù... ýòî íå îáÿçàòåëüíî, ìîæíî ñêèïíóòü(íî ðåêîìåíäóåì çàïîìíèòü)",
					"Äàëåå", "");
				}
				else
				{
				 	ShowReg(playerid);
				 	regex_delete(rg_passcheck);
				    return SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} ß æå ïðåäóïðèäèë ÷òî {0000AA}ïàðîëü äîëæåí ñîäåðæàòü òîëüêî öèôðû è ëàòèíñêèè ñèìâîëû");
				}
		    }
		    else
		    {
				SPD(playerid, -1, 0, " ", " ", " ", "");
		        SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} Âû áûëè êèêíóòû ñ ïðîåêòà ïîòîìó ÷òî íàæàëè íà êíîïêó \"Âûõîä\"");
		        SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} Íàæìèòå \"F6\" è ââåäèòå êîìàíäó \"/q\"");
		        return Kick(playerid);
		    }
		}
		case DLG_REGM:
		{
 			if(response)
 			{
				SPD(playerid, DLG_REGREF, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ðåôåðàë",
				"\t\t\t{FFFFFF}Òû óæå äîø¸ë äî 3 øàãà ñîçäàíèå ïåðñîíàæà\n\n\
				\tÅñëè ó òåáÿ åñòü äðóã èëè òîò êòî ïðåãëîñèë òåáÿ íå ñåðâåð ââåäè åãî Íèê_Íåéì â ïîëå íèæå\n\n\
				\t\t{66FFAA}Çà÷åì? òû ïîëó÷èøü áîíóñ ïðè äîñòèæåíèå 3 óðîâíÿ â ðàçìåðå 50.000ðóá",
				"Äàëåå", "Ïðîïóñê");
 			}
 			else
 			{
				ShowReg(playerid);
				SCM(playerid, COLOR_RED, "[Ãëóïî]{FFFFFF} Çà÷åì òû ñîçäàë ïàðîëü è âåðíóëñÿ îáðàòíî?");
 			}
		
		
		}
		case DLG_REGREF:
		{
		    if(response)
		    {
				new regex:rg_refcheck = regex_new("^[a-zA-Z_]{4,24}$");
				if(regex_check(inputtext, rg_refcheck))
				{
					static const fmt_query[] = "SELECT * FROM `users` WHERE `name` = '%s'";
					new query[sizeof(fmt_query)+(-2+MAX_PLAYER_NAME)];
					format(query, sizeof(query), fmt_query, inputtext);
					mysql_tquery(dbHandle, query, "CheckRef", "is", playerid, inputtext);
				}
				else
				{
				 	SPD(playerid, DLG_REGREF, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ðåôåðàë",
					"\t\t\t{FFFFFF}Òû óæå äîø¸ë äî 3 øàãà ñîçäàíèå ïåðñîíàæà\n\n\
					\tÅñëè ó òåáÿ åñòü äðóã èëè òîò êòî ïðåãëîñèë òåáÿ íå ñåðâåð ââåäè åãî Íèê_Íåéì â ïîëå íèæå\n\n\
					\t\t{66FFAA}Çà÷åì? òû ïîëó÷èøü áîíóñ ïðè äîñòèæåíèå 3 óðîâíÿ â ðàçìåðå 50.000ðóá",
					"Äàëåå", "Ïðîïóñê");
					regex_delete(rg_refcheck);
				    return SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} Õèòðûé{0000AA} åñëè ó òåáÿ íåòó íèêà ïðèãëîñèâøåãî òåáÿ ñþäà òî íàæìè íà êíîïêó \"Ïðîïóñê\"");
				}
		    }
		    else
		    {
				SPD(playerid, DLG_REGP, DSM, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ïîë",
				"\t{FFFFFF}4 øàã òû ïî÷òè óæå ñîçäàë ïåðñîíàæà\n\n\
				Òåáå îñòàëîñü âûáðàòü ïîë è îïðåäåëèòü ñêîëüêî òåáå áóäåò ëåò\n\
				\t{66FFAA}Âûáåðè ïîë äëÿ ïðîäîëæåíèå ðåãåñòðàöèè",
				"Ìóæ", "Æåí");
		    }
		}
		case DLG_REGP:
		{
			if(response)
			{
			infoP[playerid][SEX] = 1;
			}
			else
			{
			infoP[playerid][SEX] = 2;
			}
			SPD(playerid, DLG_REGAGE, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Âîçðîñò",
			"{FFFFFF}Âîò è ôèíàëüíàÿ ëèíèÿ äëÿ ñîçäàíèå ïåðñîíàæà, ìàðîêà äà?\n\
			\t\tËàäíî ñóòü òû óæå ïîíÿë ââåäè âîçðîñò\n\n\
			\t{66FFAA}Ïðèìè÷ÿíèå - Ñòðî÷êà ââîäà ïàðîëü äîëæíà áûòü çàïîëíåíà\n\
			\t{66FFAA}Ïðèìè÷ÿíèå - Òâîé âîçðîñò äîëæåí áûòü îò 18 äî 65 ëåò",
			"Çàêîí÷èòü", "Íàçàä");
		}
		case DLG_REGAGE:
		{
		    if(response)
		    {
				if(!strlen(inputtext))
				{
				    SPD(playerid, DLG_REGAGE, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Âîçðîñò",
					"{FFFFFF}Âîò è ôèíàëüíàÿ ëèíèÿ äëÿ ñîçäàíèå ïåðñîíàæà, ìàðîêà äà?\n\
					\t\tËàäíî ñóòü òû óæå ïîíÿë ââåäè âîçðîñò\n\n\
					\t{66FFAA}Ïðèìè÷ÿíèå - Ñòðî÷êà ââîäà ïàðîëü äîëæíà áûòü çàïîëíåíà\n\
					\t{66FFAA}Ïðèìè÷ÿíèå - Òâîé âîçðîñò äîëæåí áûòü îò 18 äî 65 ëåò",
					"Çàêîí÷èòü", "Íàçàä");
    				SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF}ß æå ïðåäóïðèäèë ÷òî ïîëå ââîäà äîëæíà áûòü çàïîëíåíà {3333AA}îáÿçàòåëüíûé");
				}
				if(strval(inputtext) < 18 || strval(inputtext) > 65)
				{
					SPD(playerid, DLG_REGAGE, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Âîçðîñò",
					"{FFFFFF}Âîò è ôèíàëüíàÿ ëèíèÿ äëÿ ñîçäàíèå ïåðñîíàæà, ìàðîêà äà?\n\
					\t\tËàäíî ñóòü òû óæå ïîíÿë ââåäè âîçðîñò\n\n\
					\t{66FFAA}Ïðèìè÷ÿíèå - Ñòðî÷êà ââîäà ïàðîëü äîëæíà áûòü çàïîëíåíà\n\
					\t{66FFAA}Ïðèìè÷ÿíèå - Òâîé âîçðîñò äîëæåí áûòü îò 18 äî 65 ëåò",
					"Çàêîí÷èòü", "Íàçàä");
     				SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF}ß æå ïðåäóïðèäèë ÷òî {0000AA}âîçðîñò îò 18 äî 65");
				}
				else
				{
				infoP[playerid][AGE] = strval(inputtext);
				new regmaleskin[1][3] =
				{
				{134, 230, 79}
				};
				new regfamaleskin[1][3] =
				{
				{77, 64, 10}
				};
      			new newskinindex;
    			switch(infoP[playerid][AGE])
    			{
    			    case 18..28: {}
    			    case 29..40: newskinindex++;
    			    case 41..65: newskinindex++;
    			}
				if(infoP[playerid][SEX] == 1)
				{
					infoP[playerid][SKIN] = regmaleskin[newskinindex][random(3)];
				}
				else
				{
				    infoP[playerid][SKIN] = regfamaleskin[newskinindex][random(3)];
				}
				printf("%d", infoP[playerid][SKIN]);
				new Day, Mounth, Year;
				getdate(Day, Mounth, Year);
				new date[12];
				format(date, sizeof(date), "%02d.%02d.%02d", Day, Mounth, Year);
				static const fmt_query[] = "INSERT INTO `users` (`id`, `name`, `password`, `mail`, `ref`, `sex`, `age`, `skin`) VALUES ('%d', '%s', '%s', '%s', '%d', '%d', '%d', '%d')";
				new query[sizeof(fmt_query)+(-2+11)+(-2+32)+(-2+24)+(-2+64)+(-2+8)+(-2+1)+(-2+2)+(-2+3)];
				format(query, sizeof(query), fmt_query, infoP[playerid][ID], infoP[playerid][NAME], infoP[playerid][PASSWORD], infoP[playerid][MAIL], infoP[playerid][REF], infoP[playerid][SEX], infoP[playerid][AGE], infoP[playerid][SKIN]);
				mysql_query(dbHandle, query);
				static const fmt_query2[] = "SELECT * FROM `users` WHERE `name` = '%s' AND `password` = '%d'";
				format(query, sizeof(query), fmt_query2, infoP[playerid][NAME], infoP[playerid][PASSWORD]);
				mysql_tquery(dbHandle, query, "PlayerLogin", "i", playerid);
				}
			}
		    else
		    {
		    	SPD(playerid, DLG_REGP, DSM, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ïîë",
				"\t{FFFFFF}4 øàã òû ïî÷òè óæå ïî÷òè ñîçäàë ïåðñîíàæà\n\n\
				Òåáå îñòàëîñü âûáðàòü ïîë è îïðåäåëèòü ñêîëüêî òåáå áóäåò ëåò\n\
				\t\t{3333AA}Âûáåðè ïîë äëÿ ïðîäîëæåíèå ðåãåñòðàöèè",
				"Ìóæ", "Æåí");
		    }
		}
	}
	return 1;
}
forward CheckRef(playerid, ref[]);
public CheckRef(playerid, ref[])
{
	new rows;
	cache_get_row_count(rows);
	if(rows)
	{
	    new refid;
	    cache_get_value_name_int(0, "id", refid);
	    infoP[playerid][REF] = refid;
      	SPD(playerid, DLG_REGP, DSM, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ïîë",
		"\t{FFFFFF}4 øàã òû ïî÷òè óæå ïî÷òè ñîçäàë ïåðñîíàæà\n\n\
		Òåáå îñòàëîñü âûáðàòü ïîë è îïðåäåëèòü ñêîëüêî òåáå áóäåò ëåò\n\
		\t\t{3333AA}Âûáåðè ïîë äëÿ ïðîäîëæåíèå ðåãåñòðàöèè",
		"Ìóæ", "Æåí");
	}
	else 
	{
 		SPD(playerid, DLG_REGREF, DSI, "{66FFAA}Ñîçäàíèå ïåðñîíàæà{FFFFFF} | {66FFAA}Ðåôåðàë",
		"\t\t\t{FFFFFF}Òû óæå äîø¸ë äî 3 øàãà ñîçäàíèå ïåðñîíàæà\n\n\
		\tÅñëè ó òåáÿ åñòü äðóã èëè òîò êòî ïðåãëîñèë òåáÿ íå ñåðâåð ââåäè åãî Íèê_Íåéì â ïîëå íèæå\n\n\
		\t\t{3333AA}Çà÷åì? òû ïîëó÷èøü áîíóñ ïðè äîñòèæåíèå 3 óðîâíÿ â ðàçìåðå 50.000ðóá",
		"Äàëåå", "Ïðîïóñê");
  		return SCM(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF}Còðàííî{3333AA} òàêîé íèê íå ñóùåñòâóåì");
	}
	return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}
forward PlayerLogin(playerid);
public PlayerLogin(playerid)
{
    new rows;
	cache_get_row_count(rows);
	if(rows)
	{
	    cache_get_value_name_int(0, "id", infoP[playerid][ID]);
	    cache_get_value_name(0, "mail", infoP[playerid][MAIL], 64);
	    cache_get_value_name_int(0, "ref", infoP[playerid][REF]);
	    cache_get_value_name_int(0, "sex", infoP[playerid][SEX]);
	    cache_get_value_name_int(0, "age", infoP[playerid][AGE]);
	    cache_get_value_name_int(0, "skin", infoP[playerid][SKIN]);
    	TogglePlayerSpectating(playerid, 0);
        SetPVarInt(playerid, "logged", 1);
		SetSpawnInfo(playerid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
		SpawnPlayer(playerid);
	}
	else
	{
	}
	return 1;
}
CMD:spawn(playerid)
{
    	TogglePlayerSpectating(playerid, 0);
        SetPVarInt(playerid, "logged", 1);
		SetSpawnInfo(playerid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
		SpawnPlayer(playerid);
}

При каждом входе идёт сохранение в БД

Поделиться сообщением


Ссылка на сообщение

0 ответов на этот вопрос

Ответы на этот вопрос пока отсутствуют

Гость
Эта тема закрыта для публикации ответов.
  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

  • Похожий контент

    • patrickk
      От patrickk
      Всем привет, решил написать dm сервер и довольно хорошим получился, даже на голову выше Goat dm. Оставил не решенную проблему тем что  у меня есть 4 локации с rp run и cj run ну а как добавить cj бег на те локации не знаю и как эта система работает. Надеюсь мне помогут знающие люди
    • Samolet
      От Samolet
      Здраствуйте, cоздаю копию Arizona на ОМП, опен мультиплеер, загрузил и подключил бд, но сервер не хочет вот лог :[2026-10-20T21:03:32+0300] [Info] Log file reloaded. Starting open.mp server (1.5.8.3079) from commit c6759bd8d265171ae3d86598895a23d5a8d92a3b Loading component $CAPI.so Successfully loaded component C-API (1.5.8.3079) with UID 10467dd8d4c56fc6 Loading component LegacyConfig.so Successfully loaded component LegacyConfig (1.5.8.3079) with UID 24ef6216838f9ffc Loading component NPCs.so Successfully loaded component NPCs (1.5.8.3079) with UID 3d0e59e87f4e90bc Loading component Recordings.so Successfully loaded component Recordings (1.5.8.3079) with UID 871144d399f5f613 Loading component Checkpoints.so Successfully loaded component Checkpoints (1.5.8.3079) with UID 44a937350d611dde Loading component TextDraws.so Successfully loaded component TextDraws (1.5.8.3079) with UID 9b5dc2b1d15c992a Loading component Pawn.so Successfully loaded component Pawn (1.5.8.3079) with UID 78906cd9f19c36a6 Loading component GangZones.so Successfully loaded component GangZones (1.5.8.3079) with UID b3351d11ee8d8056 Loading component Actors.so Successfully loaded component Actors (1.5.8.3079) with UID c81ca021eae2ad5c Loading component Pickups.so Successfully loaded component Pickups (1.5.8.3079) with UID cf304faa363dd971 Loading component Dialogs.so Successfully loaded component Dialogs (1.5.8.3079) with UID 44a111350d611dde Loading component Objects.so Successfully loaded component Objects (1.5.8.3079) with UID 59f8415f72da6160 Loading component Console.so Successfully loaded component Console (1.5.8.3079) with UID bfa24e49d0c95ee4 Loading component TextLabels.so Successfully loaded component TextLabels (1.5.8.3079) with UID a0c57ea80a009742 Loading component Variables.so Successfully loaded component Variables (1.5.8.3079) with UID 75e121848bc01fa2 Loading component Databases.so Successfully loaded component Databases (1.5.8.3079) with UID 80092e7eb5821a96 Loading component LegacyNetwork.so Successfully loaded component RakNetLegacyNetwork (1.5.8.3079) with UID ea9799fd79cf8442 Loading component CustomModels.so Successfully loaded component CustomModels (1.5.8.3079) with UID 15e3cb1e7c77ffff Loading component Menus.so Successfully loaded component Menus (1.5.8.3079) with UID 621e219eb97ee0b2 Loading component Vehicles.so Successfully loaded component Vehicles (1.5.8.3079) with UID 3f1f62ee9e22ab19 Loading component Classes.so Successfully loaded component Classes (1.5.8.3079) with UID 8cfb3183976da208 Loading component Timers.so Successfully loaded component Timers (1.5.8.3079) with UID 2ad8124c5ea257a3 Loaded 22 component(s) from /home/gs113492/components Executing Server Config... [2026-10-20T21:03:33+0300] [Info] Loading plugin: crashdetect.so [2026-10-20T21:03:33+0300] [Info] CrashDetect plugin 4.19 [2026-10-20T21:03:33+0300] [Info] Loading plugin: mapandreas.so [2026-10-20T21:03:33+0300] [Info] Loading plugin: streamer.so [2026-10-20T21:03:33+0300] [Info] *** Streamer Plugin v2.9.4 by Incognito loaded *** [2026-10-20T21:03:33+0300] [Info] Loading plugin: sscanf.so [2026-10-20T21:03:33+0300] [Info] [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] sscanf plugin loaded. [2026-10-20T21:03:33+0300] [Info] Version: 2.8.3 [2026-10-20T21:03:33+0300] [Info] (c) 2018 Alex "Y_Less" Cole [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] Loading plugin: TOTP.so [2026-10-20T21:03:33+0300] [Info] TOTP plugin v1.0.1 by Games loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: mysql_static.so [2026-10-20T21:03:33+0300] [Info] >> plugin.mysql: R39-6 successfully loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: libpawn_json.so [2026-10-20T21:03:34+0300] [Error] Function not registered: YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_RegAlias [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Reset [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_RegHandler [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Delete [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_New [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_IgnoreBits [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_Init [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendRPC [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendPacket [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_WriteValue [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ReadValue [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Info] Legacy Network started on ***.**.**.***:2717. Помогите пожалуйста