Mysql format
#6

O i tend to do it like this, because it looks cleaner and ez'er to edit

Код:
	format(query, sizeof(query), "UPDATE `samp_doors` SET `Door_Info` = '%s', `Door_Pos_X` = '%f', `Door_Pos_Y` = '%f', `Door_Pos_Z` = '%f' WHERE `ID` = '%i'", 
	DoorInfo[DoorID][dInfo],
	DoorInfo[DoorID][dEnterX],
	DoorInfo[DoorID][dEnterY],
	DoorInfo[DoorID][dEnterZ],
	DoorInfo[DoorID][dID]);
	mysql_function_query(g_iHandle, query, false, "", "");


	format(query, sizeof(query), "UPDATE `samp_doors` SET `Door_Ext_X` = '%f', `Door_Ext_Y` = '%f', `Door_Ext_Z` = '%f', `Door_Ent_Int` = '%i', `Door_Ext_Int` = '%i' WHERE `ID` = '%i'", 
	DoorInfo[DoorID][dExitX],
	DoorInfo[DoorID][dExitY],
	DoorInfo[DoorID][dExitZ],
	DoorInfo[DoorID][dEnterInterior],
	DoorInfo[DoorID][dExitInterior],
	DoorInfo[DoorID][dID]);
	mysql_function_query(g_iHandle, query, false, "", "");


	format(query, sizeof(query), "UPDATE `samp_doors` SET `Door_VW` = '%i', `Door_Icon` = '%i' WHERE `ID` = '%i'",
	DoorInfo[DoorID][dVirtualWorld],
	DoorInfo[DoorID][dPickupIcon],
	DoorInfo[DoorID][dID]);
	mysql_function_query(g_iHandle, query, false, "", "");
Reply


Messages In This Thread
Mysql format - by Jack_Leslie - 06.03.2017, 07:04
Re: Mysql format - by JessThompson - 06.03.2017, 07:10
Re: Mysql format - by Jack_Leslie - 06.03.2017, 07:11
Re: Mysql format - by JessThompson - 06.03.2017, 07:12
Re: Mysql format - by Jack_Leslie - 06.03.2017, 07:15
Re: Mysql format - by JessThompson - 06.03.2017, 07:17
Re: Mysql format - by Jack_Leslie - 06.03.2017, 10:02
Re: Mysql format - by Unte99 - 06.03.2017, 10:11
Re: Mysql format - by Jack_Leslie - 06.03.2017, 10:17
Re: Mysql format - by Gammix - 06.03.2017, 12:26

Forum Jump:


Users browsing this thread: 1 Guest(s)