MySql Saving As Wrong Thing - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySql Saving As Wrong Thing (/showthread.php?tid=349448)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySql Saving As Wrong Thing (/showthread.php?tid=349448)
MySql Saving As Wrong Thing - Robert_Crawford - 09.06.2012
Well Guys I Fix One Problem And Another Emerges
Hahhaha Well when i execute the command it saves correctly but when ever i save when i have not changed it it saves as the id number of the group it is associated with.
Here Is The Stock For The Save
pawn Код:
stock saveGroup(const id) {
if(strlen(groupVariables[id][gGroupName]) >= 1) {
format(szLargeString, sizeof(szLargeString), "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(szLargeString, sizeof(szLargeString), "%s, groupHQInteriorID = '%d', groupHQLockStatus = '%d', groupHQInteriorPosX = '%f', groupHQInteriorPosY = '%f', groupHQInteriorPosZ = '%f', groupSafeMoney = '%d', groupSafeMats = '%d', groupMOTD = '%s'", szLargeString, 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(szLargeString, sizeof(szLargeString), "%s, groupRankName1 = '%s', groupRankName2 = '%s', groupRankName3 = '%s', groupRankName4 = '%s', groupRankName5 = '%s', groupRankName6 = '%s'", szLargeString, groupVariables[id][gGroupRankName1], groupVariables[id][gGroupRankName2], groupVariables[id][gGroupRankName3], groupVariables[id][gGroupRankName4], groupVariables[id][gGroupRankName5], groupVariables[id][gGroupRankName6]);
format(szLargeString, sizeof(szLargeString), "%s, groupSafePosX = '%f', groupSafePosY = '%f', groupSafePosZ = '%f', MapIconID = '%d', groupType = '%d' WHERE groupID = '%d'", szLargeString, groupVariables[id][gSafePos][0], groupVariables[id][gSafePos][1], groupVariables[id][gSafePos][2],groupVariables[id][gMapIconID], groupVariables[id][gGroupType], id);
mysql_query(szLargeString);
}
else {
return 0;
}
return 1;
}
The Command That Works
pawn Код:
CMD:gmapicon(playerid, params[]) {
if(playerVariables[playerid][pAdminLevel] >= 4) {
new
groupID,
groupMapIcon;
if(sscanf(params, "dd", groupID, groupMapIcon))
return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"/gmapicon [groupid] [mapiconid]");
if(groupID > 0 && groupID < MAX_GROUPS) {
format(szMessage, sizeof(szMessage), "You have set group %s's group type to %d.", groupVariables[groupID][gGroupName], groupMapIcon);
SendClientMessage(playerid, COLOR_WHITE, szMessage);
groupVariables[groupID][gMapIconID] = groupMapIcon;
} else return SendClientMessage(playerid, COLOR_GREY, "Invalid Group ID!");
}
return 1;
}
pawn Код:
enum groupE {
gGroupName[64],
gGroupType,
gMapIconID,
Float: gGroupExteriorPos[3],
Float: gGroupInteriorPos[3],
gGroupHQInteriorID,
gGroupPickupID,
Float: gSafePos[3],
gSafePickupID,
Text3D: gSafeLabelID,
Text3D: gGroupLabelID,
gGroupHQLockStatus,
gSafe[2], // 0-1: Money, mats. pot, cocaine out for now
gswatInv,
gGroupMOTD[128],
gGroupRankName1[32], // 4d arrays aren't supported in pawn, so I'll have to continue it like this...
gGroupRankName2[32],
gGroupRankName3[32],
gGroupRankName4[32],
gGroupRankName5[32],
gGroupRankName6[32],
}enum groupE {
gGroupName[64],
gGroupType,
gMapIconID,
Float: gGroupExteriorPos[3],
Float: gGroupInteriorPos[3],
gGroupHQInteriorID,
gGroupPickupID,
Float: gSafePos[3],
gSafePickupID,
Text3D: gSafeLabelID,
Text3D: gGroupLabelID,
gGroupHQLockStatus,
gSafe[2], // 0-1: Money, mats. pot, cocaine out for now
gswatInv,
gGroupMOTD[128],
gGroupRankName1[32], // 4d arrays aren't supported in pawn, so I'll have to continue it like this...
gGroupRankName2[32],
gGroupRankName3[32],
gGroupRankName4[32],
gGroupRankName5[32],
gGroupRankName6[32],
}
pawn Код:
case THREAD_INITIATE_GROUPS: {
mysql_store_result();
new
x;
while(mysql_retrieve_row()) {
mysql_get_field("groupID", result);
x = strval(result);
mysql_get_field("groupName", groupVariables[x][gGroupName]);
mysql_get_field("groupType", result);
groupVariables[x][gGroupType] = strval(result);
mysql_get_field("MapIconID", result);
groupVariables[x][gMapIconID] = strval(result);
mysql_get_field("groupHQExteriorPosX", result);
groupVariables[x][gGroupExteriorPos][0] = floatstr(result);
mysql_get_field("groupHQExteriorPosY", result);
groupVariables[x][gGroupExteriorPos][1] = floatstr(result);
mysql_get_field("groupHQExteriorPosZ", result);
groupVariables[x][gGroupExteriorPos][2] = floatstr(result);
mysql_get_field("groupHQInteriorPosX", result);
groupVariables[x][gGroupInteriorPos][0] = floatstr(result);
mysql_get_field("groupHQInteriorPosY", result);
groupVariables[x][gGroupInteriorPos][1] = floatstr(result);
mysql_get_field("groupHQInteriorPosZ", result);
groupVariables[x][gGroupInteriorPos][2] = floatstr(result);
mysql_get_field("groupHQInteriorID", result);
groupVariables[x][gGroupHQInteriorID] = strval(result);
mysql_get_field("groupHQLockStatus", result);
groupVariables[x][gGroupHQLockStatus] = strval(result);
mysql_get_field("groupSafeMoney", result);
groupVariables[x][gSafe][0] = strval(result);
mysql_get_field("groupSafeMats", result);
groupVariables[x][gSafe][1] = strval(result);
mysql_get_field("groupSafePosX", result);
groupVariables[x][gSafePos][0] = floatstr(result);
mysql_get_field("groupSafePosY", result);
groupVariables[x][gSafePos][1] = floatstr(result);
mysql_get_field("groupSafePosZ", result);
groupVariables[x][gSafePos][2] = floatstr(result);
/* mysql_get_field("groupSafePot", result);
groupVariables[x][gSafe][2] = strval(result);
mysql_get_field("groupSafeCocaine", result);
groupVariables[x][gSafe][3] = strval(result); Drugs are out for now. */
mysql_get_field("groupMOTD", groupVariables[x][gGroupMOTD]);
mysql_get_field("groupRankName1", groupVariables[x][gGroupRankName1]);
mysql_get_field("groupRankName2", groupVariables[x][gGroupRankName2]);
mysql_get_field("groupRankName3", groupVariables[x][gGroupRankName3]);
mysql_get_field("groupRankName4", groupVariables[x][gGroupRankName4]);
mysql_get_field("groupRankName5", groupVariables[x][gGroupRankName5]);
mysql_get_field("groupRankName6", groupVariables[x][gGroupRankName6]);
switch(groupVariables[x][gGroupHQLockStatus]) {
case 0: format(result, sizeof(result), "%s's HQ\n\nPress ~k~~PED_DUCK~ to enter.", groupVariables[x][gGroupName]);
case 1: format(result, sizeof(result), "%s's HQ\n\n(locked)", groupVariables[x][gGroupName]);
}
groupVariables[x][gGroupPickupID] = CreateDynamicPickup(1239, 23, groupVariables[x][gGroupExteriorPos][0], groupVariables[x][gGroupExteriorPos][1], groupVariables[x][gGroupExteriorPos][2], 0, -1, -1, 10);
groupVariables[x][gGroupLabelID] = CreateDynamic3DTextLabel(result, COLOR_YELLOW, groupVariables[x][gGroupExteriorPos][0], groupVariables[x][gGroupExteriorPos][1], groupVariables[x][gGroupExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25.0);
groupVariables[x][gMapIconID] = CreateDynamicMapIcon(groupVariables[x][gGroupExteriorPos][0], groupVariables[x][gGroupExteriorPos][1], groupVariables[x][gGroupExteriorPos][2],groupVariables[x][gMapIconID], 1, -1, -1, -1, 100.0);
format(result, sizeof(result), "%s\nGroup Safe", groupVariables[x][gGroupName]);
groupVariables[x][gSafePickupID] = CreateDynamicPickup(1239, 23, groupVariables[x][gSafePos][0], groupVariables[x][gSafePos][1], groupVariables[x][gSafePos][2], GROUP_VIRTUAL_WORLD+x, groupVariables[x][gGroupHQInteriorID], -1, 10);
groupVariables[x][gSafeLabelID] = CreateDynamic3DTextLabel(result, COLOR_YELLOW, groupVariables[x][gSafePos][0], groupVariables[x][gSafePos][1], groupVariables[x][gSafePos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, GROUP_VIRTUAL_WORLD+x, groupVariables[x][gGroupHQInteriorID], -1, 20.0);
}
mysql_free_result();
}