This is used to only open Mobile category levels @param ApplicationRoot Used to locate database properties file @return
(String ApplicationRoot)
| 208 | * @return |
| 209 | */ |
| 210 | public static boolean openOnlyWebCategories (String ApplicationRoot) |
| 211 | { |
| 212 | log.debug("*** Setter.openOnlyWebCategories ***"); |
| 213 | boolean result = false; |
| 214 | Connection conn = Database.getCoreConnection(ApplicationRoot); |
| 215 | try |
| 216 | { |
| 217 | PreparedStatement prepstmt = conn.prepareStatement("UPDATE modules SET moduleStatus = 'open' WHERE " + webModuleCategoryHardcodedWhereClause); |
| 218 | prepstmt.execute(); |
| 219 | log.debug("Web Levels have been opened"); |
| 220 | prepstmt = conn.prepareStatement("UPDATE modules SET moduleStatus = 'closed' WHERE " + mobileModuleCategoryHardcodedWhereClause); |
| 221 | prepstmt.execute(); |
| 222 | log.debug("Mobile Levels have been closed"); |
| 223 | result = true; |
| 224 | } |
| 225 | catch (SQLException e) |
| 226 | { |
| 227 | log.error("Could not only open Web levels: " + e.toString()); |
| 228 | } |
| 229 | Database.closeConnection(conn); |
| 230 | log.debug("*** END openOnlyWebCategories ***"); |
| 231 | return result; |
| 232 | } |
| 233 | |
| 234 | /** |
| 235 | * Resets user bad submission counter to 0 |