public function deleteLocationsForObject($gameId, $strObjectType, $intObjectId)
{
//Check the object Type is good or null
if (!Locations::isValidObjectType($strObjectType) or !strlen($strObjectType) > 0) {
return new returnData(4, NULL, "invalid object type");
}
//Delete the Locations and related QR Codes
$query = "DELETE locations, qrcodes \n FROM locations\n LEFT JOIN qrcodes\n ON locations.game_id = qrcodes.game_id AND locations.location_id = qrcodes.link_id\n WHERE locations.type = '{$strObjectType}' AND locations.type_id = '{$intObjectId}' AND qrcodes.link_type = 'Location'";
Module::query($query);
if (mysql_error()) {
return new returnData(3, NULL, "SQL Error" . mysql_error());
}
if (mysql_affected_rows()) {
return new returnData(0, TRUE);
} else {
return new returnData(0, FALSE);
}
}