[PrislowProductions]

Alright. Here's lines 124300 - 124400

Код:

			db_get_field_assoc(result, "PostBoxPickupZ", field, sizeof(field));
			PostBoxInfo[i][PostBoxPickupZ] = floatstr(field);

			db_get_field_assoc(result, "PostBoxVirtual", field, sizeof(field));
			PostBoxInfo[i][PostBoxVirtual] = strval(field);

   			PostBoxInfo[i][PostBoxPickup] = CreateDynamicPickup(1239, 23, PostBoxInfo[i][PostBoxPickupX], PostBoxInfo[i][PostBoxPickupY], PostBoxInfo[i][PostBoxPickupZ], PostBoxInfo[i][PostBoxVirtual]);
			format(query, sizeof(query), "Post Box (ID: %d)\n\nType /sendmail to send your letters.", i);
			PostBoxInfo[i][PostBoxLabel] = CreateStreamed3DTextLabel(query, GREEN, PostBoxInfo[i][PostBoxPickupX], PostBoxInfo[i][PostBoxPickupY], PostBoxInfo[i][PostBoxPickupZ], 10.0, PostBoxInfo[i][PostBoxVirtual]);
			PostBoxInfo[i][PostBoxObject] = CreateDynamicObject(1258, PostBoxInfo[i][PostBoxX], PostBoxInfo[i][PostBoxY], PostBoxInfo[i][PostBoxZ], 0.0, 0.0, PostBoxInfo[i][PostBoxAngle], PostBoxInfo[i][PostBoxVirtual]);
			PostBoxInfo[i][PostBoxSQL] = i;
			db_next_row(result);
		}
	}
	db_free_result(result);
	return 1;
}

stock SavePostBoxes()
{
	new query[256];
	for (new i = 0; i < MAX_POSTBOXES; i ++)
	{
		if (!PostBoxInfo[i][PostBoxActive]) continue;
		format(query, sizeof(query), "UPDATE `PostBoxes` SET `PostBoxX` = '%f', `PostBoxY` = '%f', `PostBoxZ` = '%f', `PostBoxAngle` = '%f', `PostBoxPickupX` = '%f', `PostBoxPickupY` = '%f', `PostBoxPickupZ` = '%f', `PostBoxVirtual` = '%d' WHERE `PostBoxID` = '%d'",
            PostBoxInfo[i][PostBoxX],
            PostBoxInfo[i][PostBoxY],
            PostBoxInfo[i][PostBoxZ],
            PostBoxInfo[i][PostBoxAngle],
            PostBoxInfo[i][PostBoxPickupX],
            PostBoxInfo[i][PostBoxPickupY],
            PostBoxInfo[i][PostBoxPickupZ],
            PostBoxInfo[i][PostBoxVirtual],
            PostBoxInfo[i][PostBoxSQL]
		);
		db_query(MailDB, query);
	}
	return 1;
}

stock LoadLetters()
{
	new query[128], field[256], DBResult:result;
	result = db_query(MailDB, "SELECT * FROM `Letters`");
 	if (db_num_rows(result) != 0)
	{
	    for (new i = 0, rows = db_num_rows(result); i < rows; i ++)
	    {
	        LetterInfo[i][LetterActive] = true;

            db_get_field_assoc(result, "LetterUnread", field, sizeof(field));
			LetterInfo[i][LetterUnread] = (strval(field) == 1) ? (true) : (false);

			db_get_field_assoc(result, "LetterSent", field, sizeof(field));
			LetterInfo[i][LetterSent] = (strval(field) == 1) ? (true) : (false);

            db_get_field_assoc(result, "LetterAddress", field, sizeof(field));
			format(LetterInfo[i][LetterAddress], 128, "%s", field);

			db_get_field_assoc(result, "LetterSender", field, sizeof(field));
			format(LetterInfo[i][LetterSender], 24, "%s", field);

			db_get_field_assoc(result, "LetterRecipient", field, sizeof(field));
			format(LetterInfo[i][LetterRecipient], 24, "%s", field);

			db_get_field_assoc(result, "LetterMessage", field, sizeof(field));
			format(LetterInfo[i][LetterMessage], 256, "%s", field);

			LetterInfo[i][LetterSQL] = i;
			db_next_row(result);
		}
	}
	db_free_result(result);
	return 1;
}

stock SaveLetters()
{
    new query[768];
	for (new i = 0; i < MAX_LETTERS; i ++)
	{
	    if (!LetterInfo[i][LetterActive]) continue;
	    format(query, sizeof(query), "UPDATE `Letters` SET `LetterUnread` = '%d', `LetterSent` = '%d', `LetterAddress` = '%s', `LetterSender` = '%s', `LetterRecipient` = '%s', `LetterMessage` = '%s' WHERE `LetterID` = '%d'",
			(LetterInfo[i][LetterUnread]) ? (1) : (0), (LetterInfo[i][LetterSent]) ? (1) : (0), LetterInfo[i][LetterAddress], LetterInfo[i][LetterSender], LetterInfo[i][LetterRecipient], LetterInfo[i][LetterMessage], LetterInfo[i][LetterSQL]);
		db_query(MailDB, query);
	}
	return 1;
}
stock ShowLetters(playerid, bool:message = true)
{
	if (GetPlayerVirtualWorld(playerid) == PlayerInfo[playerid][pHouseKey] || GetPlayerVirtualWorld(playerid) == PlayerInfo[playerid][pHouseKey2] || GetPlayerVirtualWorld(playerid) == PlayerInfo[playerid][pHouseKey3] || GetPlayerVirtualWorld(playerid) == PlayerInfo[playerid][pHouseKey4])
	{
	    new
			letters,
			str[128],
			string[2800]
		;
		strdel(string, 0, strlen(string));
		for (new i = 0; i < MAX_LETTERS; i ++)
	 	{