Question

Когда создаешь подъезд квартиры есть там но после рестарта они пропадают

Спойлер

CMD:createpodezd(playerid, params[])
{
	if(PI[playerid][pAdmin] < ADM_GRAND) return 1;
	if(sscanf(params, "ii", params[0],params[1])) return SendClientMessage(playerid, COLOR_LIGHTGREEN, "| {ffffff}Введите: /createpodezd [Тип][Уровень цены]");
	new Float:x, Float:y, Float:z;
	new totalstring[600]; // 1024
	GetPlayerPos(playerid, x, y, z);
	if(params[0] == 0 || params[0] >= 5) return SendClientMessage(playerid, -1,"{FFFFFF} 1 тип : 3 этажа"), SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} 2 тип : 3 этажа, как в Южном"), SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} 3 тип : 2 этажа"),
	SendClientMessage(playerid, -1,"{FFFFFF} 4 тип : 5 этажей");
	if(params[1] == 0 || params[1] >= 4) return SendClientMessage(playerid, -1,"{FFFFFF} Уровни : 1, 2, 3");
	new type = params[0];
	new cena = params[1];
	new string[100];
	TOTALPODEZD++;
	switch(type)
	{
		case 1: format(string,90,"92.2885,-166.0693,996.7797,1,1");	// Инт 4 этажа
		case 2: format(string,90,"514.6105,-73.8570,1398.2188,2,2");// Инт 2 падика
		case 3: format(string,90,"468.5620,-61.4008,1408.6062,3,3");// Инт 4 этажа
		case 4: format(string,90,"363.9392,-73.1163,1411.6899,4,4");// Инт 4 этажа
	}
	sscanf(string,"p<,>fffii",
	PodezdInfo[TOTALPODEZD][poExitX],PodezdInfo[TOTALPODEZD][poExitY],PodezdInfo[TOTALPODEZD][poExitZ],
	PodezdInfo[TOTALPODEZD][poI],PodezdInfo[TOTALPODEZD][poType]);
	PodezdInfo[TOTALPODEZD][poX] = x;
	PodezdInfo[TOTALPODEZD][poY] = y;
	PodezdInfo[TOTALPODEZD][poZ] = z;
	PodezdInfo[TOTALPODEZD][poV] = TOTALPODEZD;
	format(totalstring, 600, "INSERT INTO "T_PODEZD" (\
	`poX`, `poY`, `poZ`, `poExitX`, `poExitY`, `poExitZ`, `poI`, `poV`, `poType`) \
	VALUES ('%f', '%f', '%f', '%f', '%f', '%f', '%i', '%i', '%i')",
	PodezdInfo[TOTALPODEZD][poX], PodezdInfo[TOTALPODEZD][poY], PodezdInfo[TOTALPODEZD][poZ], PodezdInfo[TOTALPODEZD][poExitX], PodezdInfo[TOTALPODEZD][poExitY], PodezdInfo[TOTALPODEZD][poExitZ], PodezdInfo[TOTALPODEZD][poI], PodezdInfo[TOTALPODEZD][poV], PodezdInfo[TOTALPODEZD][poType]);
	mysql_tquery(dbHandle, totalstring, "", "");
	CreateDynamicMapIcon(PodezdInfo[TOTALPODEZD][poX], PodezdInfo[TOTALPODEZD][poY], PodezdInfo[TOTALPODEZD][poZ], 35, 0,-1,-1,-1,200.0);
	PodezdInfo[TOTALPODEZD][poPickup] = CreatePickup(19133, 1, PodezdInfo[TOTALPODEZD][poX], PodezdInfo[TOTALPODEZD][poY], PodezdInfo[TOTALPODEZD][poZ]);
	PodezdInfo[TOTALPODEZD][poPickupExit] = CreatePickup(19133, 1, PodezdInfo[TOTALPODEZD][poExitX], PodezdInfo[TOTALPODEZD][poExitY], PodezdInfo[TOTALPODEZD][poExitZ], PodezdInfo[TOTALPODEZD][poV]);
	new podezdid = TOTALPODEZD;
	new string2[100];
	new string1[100];
	new ids = 0;
	new typepodezd = PodezdInfo[TOTALPODEZD][poType];
	new maxids;
	switch(typepodezd)
	{
	    case 1: maxids = 19;
	    case 2: maxids = 6;
	    case 3: maxids = 7;
	    case 4: maxids = 24;
	}
	while(ids < maxids)
	{
		TOTALROOMS++;
		if(typepodezd == 1)
		{
	 		format(string2,90,"%f,%f,%f", RoomClass1[ids][0], RoomClass1[ids][1], RoomClass1[ids][2]);
		}
		if(typepodezd == 2)
		{
	 		format(string2,90,"%f,%f,%f", RoomClass2[ids][0], RoomClass2[ids][1], RoomClass2[ids][2]);
		}
		if(typepodezd == 3)
		{
	 		format(string2,90,"%f,%f,%f", RoomClass3[ids][0], RoomClass3[ids][1], RoomClass3[ids][2]);
		}
 		if(typepodezd == 4)
		{
	 		format(string2,90,"%f,%f,%f", RoomClass4[ids][0], RoomClass4[ids][1], RoomClass4[ids][2]);
		}
		sscanf(string2,"p<,>fff",
		RoomsInfo[TOTALROOMS][rX], RoomsInfo[TOTALROOMS][rY], RoomsInfo[TOTALROOMS][rZ]);
		RoomsInfo[TOTALROOMS][rI] = 1;
		switch(random(3))
		{
			case 0: format(string1, 100,"-236.6516,413.3671,1003.5000, 2, 1, 750000");
			case 1: format(string1, 100,"-236.6516,413.3671,1003.5000, 3, 2, 950000");
			case 2: format(string1, 100,"-236.6516,413.3671,1003.5000, 4, 3, 1200000");
		}
	 	sscanf(string1,"p<,>fffiii",
		RoomsInfo[TOTALROOMS][rExitX], RoomsInfo[TOTALROOMS][rExitY], RoomsInfo[TOTALROOMS][rExitZ], RoomsInfo[TOTALROOMS][rExitI], RoomsInfo[TOTALROOMS][rType],RoomsInfo[TOTALROOMS][rCost]);
		RoomsInfo[TOTALROOMS][rCost] = RoomsInfo[TOTALROOMS][rCost]*cena;
		RoomsInfo[TOTALROOMS][rV] = PodezdInfo[podezdid][poV];
		RoomsInfo[TOTALROOMS][rI] = PodezdInfo[podezdid][poI];
		RoomsInfo[TOTALROOMS][rExitV] = TOTALROOMS+1;
		strmid(RoomsInfo[TOTALROOMS][rOwner], "None", 0, strlen("None"), MAX_PLAYER_NAME);
		format(totalstring, 600, "INSERT INTO `"T_ROOMS"` (\
		`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `rExitI`, `rType`, `rCost`) \
		VALUES ('%f', '%f', '%f', '%i', '%i', '%f', '%f', '%f', '%i', '%i', '%i', '%i')",
		RoomsInfo[TOTALROOMS][rX], RoomsInfo[TOTALROOMS][rY], RoomsInfo[TOTALROOMS][rZ], RoomsInfo[TOTALROOMS][rV], RoomsInfo[TOTALROOMS][rI],
		RoomsInfo[TOTALROOMS][rExitX], RoomsInfo[TOTALROOMS][rExitY], RoomsInfo[TOTALROOMS][rExitZ], RoomsInfo[TOTALROOMS][rExitV], RoomsInfo[TOTALROOMS][rExitI],
		RoomsInfo[TOTALROOMS][rType], RoomsInfo[TOTALROOMS][rCost]);
		mysql_tquery(dbHandle, totalstring, "", "");
		RoomsInfo[TOTALROOMS][rPickupEnter] = CreatePickup(1239, 1, RoomsInfo[TOTALROOMS][rX], RoomsInfo[TOTALROOMS][rY], RoomsInfo[TOTALROOMS][rZ], RoomsInfo[TOTALROOMS][rV]);
		RoomsInfo[TOTALROOMS][rPickupExit] = CreatePickup(1239, 1, RoomsInfo[TOTALROOMS][rExitX], RoomsInfo[TOTALROOMS][rExitY], RoomsInfo[TOTALROOMS][rExitZ], RoomsInfo[TOTALROOMS][rExitV]);
		ids++;
	}
	SendMes(playerid, COLOR_LIGHTBLUE, "Подьезд №{FFCC00}%i {0099FF}успешно создан.", TOTALPODEZD);
	return true;
}

 

 

Edited by archiboy6

Share this post


Link to post

19 answers to this question

  • 0

@archiboy6 в базе что-нибудь появляется? перезайдите на сервер, может быть появятся. 

Share this post


Link to post
  • 0

@archiboy6 в базу сохранение квартир идет? 

Share this post


Link to post
  • 0

@DEST Только сами подъезды

Share this post


Link to post
  • 0

@archiboy6 таблица T_ROOMS в базе есть, mysql ошибки есть? 

Share this post


Link to post
  • 0

@DEST rooms есть но там пусто, даже вот сейчас создал подъезд и там квартиры есть и всеравно пусто

@DEST Вот тык 29 подъезд только что созданный с квартирами 

Edited by archiboy6

Share this post


Link to post
  • 0

@DEST ссылку на скрин вк скинул тут не кидается почему-то

@DEST 

Спойлер

[18:17:06] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[18:17:18] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[18:17:23] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[18:17:50] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[18:19:11] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot1`='40', `Amt1`='1', `Value1`='' WHERE `Name` = 'Alex_Samsonov'' at line 1
[18:26:46] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot1`='21', `Amt1`='1', `Value1`='' WHERE `Name` = 'Misha_Opposite'' at line 1
[19:11:46] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[19:35:31] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[19:57:05] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:14:50] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:18:35] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:25:28] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:26:31] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:27:33] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:28:58] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:38:40] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:38:54] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:40:26] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:43:38] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:45:00] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[20:45:38] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot1`='40', `Amt1`='1', `Value1`='' WHERE `Name` = 'Alex_Samsonov'' at line 1
[20:59:07] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:02:38] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:02:52] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:04:41] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:09:54] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:11:33] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:11:59] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:12:19] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:12:57] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot2`='42', `Amt2`='60', `Value2`='' WHERE `Name` = 'Cool_Fox'' at line 1
[21:13:01] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot3`='21', `Amt3`='1', `Value3`='' WHERE `Name` = 'Cool_Fox'' at line 1
[21:13:08] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot2`='0', `Amt2`='0', `Value2`='' WHERE `Name` = 'Cool_Fox'' at line 1
[21:15:52] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:20:39] [WARNING] CMySQLHandle::Create - connection already exists
[21:21:17] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:21:40] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:21:43] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:21:57] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:25:59] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:30:00] [WARNING] CMySQLHandle::Create - connection already exists
[21:31:00] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:31:05] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:34:53] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:42:40] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:43:17] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot1`='40', `Amt1`='1', `Value1`='' WHERE `Name` = 'Alex_Samsonov'' at line 1
[21:58:53] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[21:59:40] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`` SET `Slot1`='40', `Amt1`='1', `Value1`='' WHERE `Name` = 'Cool_Fox'' at line 1
[22:11:37] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[22:17:22] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:22:24] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rooms`` (`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `' at line 1
[22:28:14] [ERROR] CMySQLQuery::Execute[LoadPlayerItem] - (error #1103) Incorrect table name ''

 

 

@DEST Квартиры не грузит на сервер

[21:30:01] [Загружено орг/раб. автомобилей]: <27>. Потрачено: <1 ms>.
[21:30:01] [Загружено бизнесов]: <99>. Потрачено: <7 ms>.
[21:30:01] [Загружено домов]: <161>. Потрачено: <11 ms>.
[21:30:01] [Загружены склады мафий]: Потрачено: <0 ms>.
[21:30:01] [Загружены склады банд]: Потрачено: <0 ms>.
[21:30:01] [Загружено гангзон]: <100>. Потрачено: <1 ms>.
[21:30:01] [Загружено банкоматов]: <1>. Потрачено: <0 ms>.
[21:30:01] [Загружено остальное]: Потрачено: <0 ms>.
[21:30:01] [Загружено радаров]: <0>. Потрачено: <0 ms>.
[21:30:01] [Загружено итемов]: <3>. Потрачено: <0 мс>
[21:30:01] [Загружено семей]: <2>. Потрачено: <1 ms>.
[21:30:01] [Загружено подъездов]: <28>. Потрачено: <1 ms>.
[21:30:01] [Загружено квартир]: <0>. Потрачено: <0 ms>.

 

Share this post


Link to post
  • 0

@archiboy6 ошибка в запросе INSERT INTO `"T_ROOMS"` (\ `rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `rExitI`, `rType`, `rCost`) \ VALUES ('%f', '%f', '%f', '%i', '%i', '%f', '%f', '%f', '%i', '%i', '%i', '%i')

кинь дефайн T_ROOMS

Share this post


Link to post
  • 0

@DEST 

stock SetRoomsStr(idx, stolb[], znach[])
{
	new Query[128];
	format(Query, sizeof(Query), "UPDATE "T_ROOMS" SET  %s = '%s' WHERE id = '%d' LIMIT 1", stolb, znach, idx);
	return mysql_tquery(dbHandle, Query, "", "");
}

stock SetRoomsInt(idx, stolb[], znach)
{
	new Query[128];
	format(Query, sizeof(Query), "UPDATE "T_ROOMS" SET %s = '%d' WHERE id = '%d' LIMIT 1", stolb, znach, idx);
	return mysql_tquery(dbHandle, Query, "", "");
}



	    mysql_tquery(dbHandle, "SELECT * FROM "T_ROOMS"", "LoadRooms", "");


#define T_ROOMS               "`rooms`"    // Квартиры

 

@DEST 

enum rooms
{
	idkv,
Float:rX,
Float:rY,
Float:rZ,
	rV,
	rI,
Float:rExitX,
Float:rExitY,
Float:rExitZ,
	rExitV,
	rExitI,
	rType,
	rCost,
	rOwner[32],
	rOplata,
	rLock,
	rPickupEnter,
	rPickupExit,
	Text3D:rPickupText,
	rSphereEnter,
	rSphereExit
};
new RoomsInfo[MAX_ROOMS][rooms];

 

Share this post


Link to post
  • 0
format(totalstring, 600, "INSERT INTO "T_ROOMS" (\
		`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `rExitI`, `rType`, `rCost`) \
		VALUES ('%f', '%f', '%f', '%i', '%i', '%f', '%f', '%f', '%i', '%i', '%i', '%i')",
		RoomsInfo[TOTALROOMS][rX],
		RoomsInfo[TOTALROOMS][rY],
		RoomsInfo[TOTALROOMS][rZ],
		RoomsInfo[TOTALROOMS][rV],
		RoomsInfo[TOTALROOMS][rI],
		RoomsInfo[TOTALROOMS][rExitX],
		RoomsInfo[TOTALROOMS][rExitY],
		RoomsInfo[TOTALROOMS][rExitZ],
		RoomsInfo[TOTALROOMS][rExitV],
		RoomsInfo[TOTALROOMS][rExitI],
		RoomsInfo[TOTALROOMS][rType],
		RoomsInfo[TOTALROOMS][rCost]);
		mysql_tquery(dbHandle, totalstring, "", "");

 

Share this post


Link to post
  • 0

@HAZZY что это?

Share this post


Link to post
  • 0

@archiboy6 это заменить свой код нужно этим. Точнее его часть. 

Share this post


Link to post
  • 0

@DEST Какой из?

 

Share this post


Link to post
  • 0

@archiboy6 найдите в своем коде этот код и замените. или просто поменять 

В 12.01.2018 в 04:06, archiboy6 сказал:

`"T_ROOMS"`

на 

Только что, HAZZY сказал:

"T_ROOMS"

 

Share this post


Link to post
  • 0

@DEST Их много :) Этот?

format(totalstring, 600, "INSERT INTO `"T_ROOMS"` (\
		`rX`, `rY`, `rZ`, `rV`, `rI`, `rExitX`, `rExitY`, `rExitZ`, `rExitV`, `rExitI`, `rType`, `rCost`) \
		VALUES ('%f', '%f', '%f', '%i', '%i', '%f', '%f', '%f', '%i', '%i', '%i', '%i')",
		RoomsInfo[TOTALROOMS][rX], RoomsInfo[TOTALROOMS][rY], RoomsInfo[TOTALROOMS][rZ], RoomsInfo[TOTALROOMS][rV], RoomsInfo[TOTALROOMS][rI],
		RoomsInfo[TOTALROOMS][rExitX], RoomsInfo[TOTALROOMS][rExitY], RoomsInfo[TOTALROOMS][rExitZ], RoomsInfo[TOTALROOMS][rExitV], RoomsInfo[TOTALROOMS][rExitI],
		RoomsInfo[TOTALROOMS][rType], RoomsInfo[TOTALROOMS][rCost]);
		mysql_tquery(dbHandle, totalstring, "", "");
		RoomsInfo[TOTALROOMS][rPickupEnter] = CreatePickup(1239, 1, RoomsInfo[TOTALROOMS][rX], RoomsInfo[TOTALROOMS][rY], RoomsInfo[TOTALROOMS][rZ], RoomsInfo[TOTALROOMS][rV]);
		RoomsInfo[TOTALROOMS][rPickupExit] = CreatePickup(1239, 1, RoomsInfo[TOTALROOMS][rExitX], RoomsInfo[TOTALROOMS][rExitY], RoomsInfo[TOTALROOMS][rExitZ], RoomsInfo[TOTALROOMS][rExitV]);
		ids++;

 

Share this post


Link to post
  • 0

@archiboy6 да, этот. А вообще мы говорим только про те коды, которые представлены в теме. Логично, что менять нужно в них, другие мы попросту не знаем. 

Share this post


Link to post
  • 0

@DEST По сути работать должно?

Заметка от DEST , создано

Устное предупреждение. Флуд / оффтоп.
Проверяйте. Все постигается путем проб и ошибок.

Share this post


Link to post
  • 0

@DEST Теперь при создании подъезда вообще нету квартир раньше хотя бы были

Share this post


Link to post
  • 0

@DEST Спасибо, появились, а можно тут же описывать 2 проблему или новую тему?

Share this post


Link to post
  • 0

@archiboy6 если вторая проблема не связана с этой, то создавайте новую тему. 

Share this post


Link to post
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content