Need help! + respect (Problem with mysql)
#1

Код:
stock saveGroup(id) {
	if(strlen(groupVariables[id][gGroupName]) >= 1) {
	    new
	        queryString[1024]; //this line

		format(queryString, sizeof(queryString), "UPDATE groups SET groupName = '%s', groupHQExteriorPosX = '%f', groupHQExteriorPosY = '%f', groupHQExteriorPosZ = '%f'", groupVariables[id][gGroupName], groupVariables[id][gGroupExteriorPos][0], groupVariables[id][gGroupExteriorPos][1], groupVariables[id][gGroupExteriorPos][2]);
		format(queryString, sizeof(queryString), "%s, groupHQInteriorID = '%d', groupHQLockStatus = '%d', groupHQInteriorPosX = '%f', groupHQInteriorPosY = '%f', groupHQInteriorPosZ = '%f', groupSafeMoney = '%d', groupSafeMats = '%d', groupMOTD = '%s'", queryString, groupVariables[id][gGroupHQInteriorID], groupVariables[id][gGroupHQLockStatus], groupVariables[id][gGroupInteriorPos][0], groupVariables[id][gGroupInteriorPos][1], groupVariables[id][gGroupInteriorPos][2], groupVariables[id][gSafe][0], groupVariables[id][gSafe][1], groupVariables[id][gGroupMOTD]);
		format(queryString, sizeof(queryString), "%s, groupRankName1 = '%s', groupRankName2 = '%s', groupRankName3 = '%s', groupRankName4 = '%s', groupRankName5 = '%s', groupRankName6 = '%s', groupRankName7 = '%s', groupRankName8 = '%s', groupRankName9 = '%s', groupRankName10 = '%s', groupRankName11 = '%s', groupRankName12 = '%s'" queryString, groupVariables[id][gGroupRankName1], groupVariables[id][gGroupRankName2], groupVariables[id][gGroupRankName3], groupVariables[id][gGroupRankName4], groupVariables[id][gGroupRankName5], groupVariables[id][gGroupRankName6], groupVariables[id][gGroupRankName7], groupVariables[id][gGroupRankName8], groupVariables[id][gGroupRankName9], groupVariables[id][gGroupRankName10], groupVariables[id][gGroupRankName11], groupVariables[id][gGroupRankName12]); // this line
		format(queryString, sizeof(queryString), "%s, groupSafePosX = '%f', groupSafePosY = '%f', groupSafePosZ = '%f', groupType = '%d' WHERE groupID = '%d'", queryString, groupVariables[id][gSafePos][0], groupVariables[id][gSafePos][1], groupVariables[id][gSafePos][2], groupVariables[id][gGroupType], id);
		mysql_query(queryString);
	}
	else {
		return 0;
	}

	return 1;
}
Код:
error 075: input line too long (after substitutions)
(4149) : error 017: undefined symbol "groupVariable"
(4150) warning 217: loose indentation
error 017: undefined symbol "s"
 warning 215: expression has no effect
error 001: expected token: ";", but found "]"
error 029: invalid expression, assumed zero
fatal error 107: too many error messages on one line
Plese some one..
Reply
#2

Sorry for double post I know only prob is with
Quote:

queryString[1024];

So how to know how big query is needed to be?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)