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', groupType = '%d' gMapIconID = '%d' WHERE groupID = '%d'", szLargeString, groupVariables[id][gSafePos][0], groupVariables[id][gSafePos][1], groupVariables[id][gSafePos][2], groupVariables[id][gGroupType], groupVariables[id][gMapIconID], id );
        mysql_query(szLargeString);
    }
    else {
        return 0;
    }

    return 1;

}

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"/gtype [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;
}

CMD:savedata(playerid, params[]) {
    if(playerVariables[playerid][pAdminLevel] >= 5) {
        foreach(Player, x) {
            savePlayerData(x);
        }
        SendClientMessage(playerid, COLOR_YELLOW, "Player data saved.");

        for(new xh = 0; xh < MAX_HOUSES; xh++) {
            saveHouse(xh);
        }
        SendClientMessage(playerid, COLOR_YELLOW, "House data saved.");

        for(new xf = 0; xf < MAX_GROUPS; xf++) {
            saveGroup(xf);
        }
        SendClientMessage(playerid, COLOR_YELLOW, "Group data saved.");

        for(new xf = 0; xf < MAX_BUSINESSES; xf++) {
            saveBusiness(xf);
        }
        SendClientMessage(playerid, COLOR_YELLOW, "Business data saved.");

        for(new xf = 0; xf < MAX_ASSETS; xf++) {
            saveAsset(xf);
        }
        SendClientMessage(playerid, COLOR_YELLOW, "Server asset data saved.");
    }

    return 1;
}

[19:23:48] [server] [cmd] Robert_Crawford (ID 0): /savedata
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '1' WHERE groupID = '1'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'Los Santos Police Department', groupHQExteriorPosX = '1555.498168', groupHQExteriorPosY = '-1675.593750', groupHQExteriorPosZ = '16.195299', groupHQInteriorID = '0', groupHQLockStatus = '0', groupHQInteriorPosX = '1474.158569', groupHQInteriorPosY = '-1750.073608', groupHQInteriorPosZ = '3285.285888', groupSafeMoney = '14549', groupSafeMats = '620', groupMOTD = 'Finally changed the LSPD motd!', groupRankName1 = 'Officer', groupRankName2 = 'Detective', groupRankName3 = 'Sergeant', groupRankName4 = 'Lieutenant', groupRankName5 = 'Captain', groupRankName6 = 'Chief', groupSafePosX = '226.471572', groupSafePosY = '124.153427', groupSafePosZ = '999.015625', groupType = '1' gMapIconID = '1' WHERE groupID = '1'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '2'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'Los Santos Fire & Medical Department', groupHQExteriorPosX = '1299.948608', groupHQExteriorPosY = '-1861.692504', groupHQExteriorPosZ = '13.546875', groupHQInteriorID = '17', groupHQLockStatus = '0', groupHQInteriorPosX = '378.026000', groupHQInteriorPosY = '-190.515502', groupHQInteriorPosZ = '1000.632812', groupSafeMoney = '0', groupSafeMats = '0', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '4' gMapIconID = '0' WHERE groupID = '2'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '1' WHERE groupID = '3'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'The Agency', groupHQExteriorPosX = '2308.412109', groupHQExteriorPosY = '-1637.348022', groupHQExteriorPosZ = '14.827047', groupHQInteriorID = '6', groupHQLockStatus = '1', groupHQInteriorPosX = '316.232727', groupHQInteriorPosY = '-169.791290', groupHQInteriorPosZ = '999.601013', groupSafeMoney = '5000', groupSafeMats = '7150', groupMOTD = '(/setfrequency #1979)', groupRankName1 = 'potato', groupRankName2 = 'Prospect', groupRankName3 = 'Patch', groupRankName4 = 'Enforcer', groupRankName5 = 'Road Captain', groupRankName6 = 'President', groupSafePosX = '356.696594', groupSafePosY = '151.063232', groupSafePosZ = '1025.789062', groupType = '3' gMapIconID = '1' WHERE groupID = '3'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '4'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'San Andreas Goverment', groupHQExteriorPosX = '1481.016479', groupHQExteriorPosY = '-1771.215820', groupHQExteriorPosZ = '18.795755', groupHQInteriorID = '0', groupHQLockStatus = '0', groupHQInteriorPosX = '1056.516967', groupHQInteriorPosY = '-76.520011', groupHQInteriorPosZ = '1001.885925', groupSafeMoney = '12260', groupSafeMats = '0', groupMOTD = 'Leader-Lamont will be inactive till Monday have fun and RP till I am back.', groupRankName1 = 'Recruit', groupRankName2 = 'Hustler Loco', groupRankName3 = 'Huslter Loco', groupRankName4 = 'El Cholo', groupRankName5 = 'Lieutenant Governor', groupRankName6 = 'President', groupSafePosX = '368.132080', groupSafePosY = '162.652603', groupSafePosZ = '1008.382812', groupType = '2' gMapIconID = '0' WHERE groupID = '4'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '5'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'Federal Berua Of Investigation', groupHQExteriorPosX = '1653.644409', groupHQExteriorPosY = '-1655.367675', groupHQExteriorPosZ = '22.515625', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '1' gMapIconID = '0' WHERE groupID = '5'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '6'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '6'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '7'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '7'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '8'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '8'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '9'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '9'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '10'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '10'
[19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '11'' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE groups SET groupName = 'None', groupHQExteriorPosX = '0.000000', groupHQExteriorPosY = '0.000000', groupHQExteriorPosZ = '0.000000', groupHQInteriorID = '0', groupHQLockStatus = '1', groupHQInteriorPosX = '0.000000', groupHQInteriorPosY = '0.000000', groupHQInteriorPosZ = '0.000000', groupSafeMoney = '1', groupSafeMats = '1', groupMOTD = '(null)', groupRankName1 = '(null)', groupRankName2 = '(null)', groupRankName3 = '(null)', groupRankName4 = '(null)', groupRankName5 = '(null)', groupRankName6 = '(null)', groupSafePosX = '0.000000', groupSafePosY = '0.000000', groupSafePosZ = '0.000000', groupType = '0' gMapIconID = '0' WHERE groupID = '11'
[19:23:48] errorid: 1064 | error: 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 's Auto Expo', businessOwner = 'Robert_Crawford', businessPrice = '0', businessVa' at line 1 | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE businesses SET businessExteriorX = '1616.466552', businessExteriorY = '-1897.085937', businessExteriorZ = '13.549173', businessInteriorX = '1404.112792', businessInteriorY = '7.681230', businessInteriorZ = '1000.906250', businessInterior = '1', businessType = '5', businessName = 'Robert's Auto Expo', businessOwner = 'Robert_Crawford', businessPrice = '0', businessVault = '120000', businessLock = '0', businessMiscX = '1612.360961', businessMiscY = '-1893.208007', businessMiscZ = '13.546875' WHERE businessID = '4'

19:23:48] errorid: 1064 | error: 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 'gMapIconID = '0' WHERE groupID = '9'' at line 1

, groupType = '%d' (, Here) gMapIconID = '%d' WHERE groupID = '%d'",