[PAGALBOS] Dėl namo

[AtomicDesign]

Sveiki, turiu klausymą galbūt net prašymą galite padėti su problemą. Sukuriu namą su komandą /addhouse ir kol nepadariau serverio restarto arba relog žaidėjo tol viskas gerai. Kai padarau relog arba serverio restarta ir kai einu į namą visada iš to namo iškrentu. Kur gali būti problemą ? +REP tam kuris padės sutvarkyti šia bėdą.

[Ridlis]

Saugojimas tavo pagalbininkas.

[AtomicDesign]

7 minutes prieš, Kr1sas parašė:

Saugojimas tavo pagalbininkas.

Čia tipo su .sql kažkas susije ar kaip ?

 

[Xink]

Gamemode namų sukūrimą parodyk. visą kodą 

[AtomicDesign]

2 minutes prieš, Xink parašė:

Gamemode namų sukūrimą parodyk. visą kodą 

CMD:addhouse(playerid, params[])
{
	if(PI[playerid][AdminLevel] < LEVEL_OWNER) return 0;

	new type, Float: pPos[4], hQuery[43], str[300], houset[10];

	if(sscanf(params, "d", type)) return SendClientMessage(playerid, -1, ""COL_USAGE"{00FF00}~~~ "COL_CMD"/addhouse <namo tipas (1, 2, 3)>");

	for(new house; house < MAX_HOUSES; house ++)
	{
		format(hQuery, 43, "SELECT * FROM `houses` WHERE `ID` = '%d'", house);
		mysql_query(hQuery);

		mysql_store_result();

		if(!mysql_num_rows())
		{
			GetPlayerPos 		(playerid, pPos[0], pPos[1], pPos[2]);
			GetPlayerFacingAngle(playerid, pPos[3]);

			format(HouseInfo[house][Owner], MAX_PLAYER_NAME, "Savivaldybė");
			HouseInfo[house][hCreated] 	= true;
			HouseInfo[house][Buyed] 	= false;
			HouseInfo[house][IsGarageUsed] = false;
			HouseInfo[house][Locked] 	= true;
			HouseInfo[house][htVW] 		= house + 1;
			HouseInfo[house][ExitX] 	= pPos[0];
			HouseInfo[house][ExitY] 	= pPos[1];
			HouseInfo[house][ExitZ] 	= pPos[2];
			HouseInfo[house][ExitAngle] = pPos[3];
			HouseInfo[house][hType] 	= type;

			for(new i = 0; i < MAX_CHEST_SLOTS; i ++)
			{
			    HouseChest[house][i][ItemID]		= 0;
				HouseChest[house][i][ItemAmmount]	= 0;
			}

			switch(type)
			{
				case TYPE_RATAI:
				{
					houset 					= "Namuko";
					HouseInfo[house][Cost] 	= 100000 + random(50000);

					new inter = random(4);
					//inter --;

					HouseInfo[house][hInt] = hInterior1[inter][Int];
					HouseInfo[house][IntX] = hInterior1[inter][IntX];
					HouseInfo[house][IntY] = hInterior1[inter][IntY];
					HouseInfo[house][IntZ] = hInterior1[inter][IntZ];

					printf("%d", inter);
				}

				case TYPE_BUTAS:
				{
					houset 					= "Buto";
					HouseInfo[house][Cost] 	= 200000 + random(70000);

					new inter = random(9);
					//inter --;

					HouseInfo[house][hInt] = hInterior2[inter][Int];
					HouseInfo[house][IntX] = hInterior2[inter][IntX];
					HouseInfo[house][IntY] = hInterior2[inter][IntY];
					HouseInfo[house][IntZ] = hInterior2[inter][IntZ];
				}

				case TYPE_NAMAS:
				{
					houset 					= "Namo";
					HouseInfo[house][Cost] 	= 400000 + random(100000);

					new inter = random(4);
					//inter --;

					HouseInfo[house][hInt] = hInterior3[inter][Int];
					HouseInfo[house][IntX] = hInterior3[inter][IntX];
					HouseInfo[house][IntY] = hInterior3[inter][IntY];
					HouseInfo[house][IntZ] = hInterior3[inter][IntZ];
				}

				default: return SendClientMessage(playerid, -1, ""COL_ERROR" {A52A2A}~~~ {FFFFFF}Tokio namo tipo nėra!");
			}

			format(str, 300, "{DEFF88}%s numeris: "COL_PRICE"%d\n{DEFF88}Savininkas: {ff0000}%s\n{DEFF88}Kaina: "COL_PRICE"$%s\n \n{DEFF88}Norėdami nupirkti, spauskite ENTER",
			houset, house + 1, HouseInfo[house][Owner], konvertuoti_pinigus(HouseInfo[house][Cost]));

			HouseInfo[house][House3D] = Create3DTextLabel(str, -1, HouseInfo[house][ExitX], HouseInfo[house][ExitY], HouseInfo[house][ExitZ], 10, 0, 0);
			HouseInfo[house][HousePickup] = CreatePickup(1273, 1, HouseInfo[house][ExitX], HouseInfo[house][ExitY], HouseInfo[house][ExitZ], 0);

			format(hQuery, 42, "INSERT INTO `houses` (ID) VALUES ('%d')", house);
			mysql_query(hQuery);

			SaveHouse 			(house);
			SendClientMessage 	(playerid, -1, ""COL_ADMIN"{00FF00}~~~ {FFFFFF}Namas sukurtas!");

			return 1;
		}

		mysql_free_result();
	}

	return SendClientMessage(playerid, -1, ""COL_ERROR" {A52A2A}~~~ {FFFFFF}Serveryje yra per daug namų!");
}