Tag Archives: Theme

Camp Out Colorado

CampOutColorado.com is a website I created to review campgrounds and give outdoor enthusiasts tips and tricks to enjoying beautiful Colorado. There are a number of WordPress customizations I have done to this website. 

Campground Data Custom Plugin

For the camping reviews I created a custom campground information plugin. It pulls up-to-date information for campgrounds through a REST API. These help campers see important details as well as know if there are any up to date details they need. 

Camping List Custom Plugin

To help campers be prepared to go camping I have created a number of camping lists for them to reference.

This is implemented through a custom WordPress plugin which stores all the information in a custom MySQL database. These camping lists are broken down into three categories of need. The items in the lists are linked to searches on Amazon so they can easily get the an item them are missing. 

http://www.campoutcolorado.com/camping-lists/general-equipment-camping-list/

Custom Template for Solunar Table

Hunting and fishing are a regular activity with campers in Colorado. I have created a few useful tools for them. One is a solunar calendar to figure out good activity times. This was created as a customized template in WordPress. 

This solunar calendar takes the moon cycle, rise and set times of the moon, as well as the sun and uses an algorithm to calculate good times to go fishing or hunting. It then displays these times, the moon cycle and a number of fish depending on how good the day looks. In the example below the solunar calculations suggest a bad day fishing, so go for a hike instead!

Custom Fish Stocked Plugin and Database

Another one of the tools I have created to help campers enjoy their time in the great out of doors is a fish stocking report with the quality of stocking in the body of water.  This a nice add-on plugin that also enhances the campground details plugin. 

This is updated weekly from the data that the Colorado Division of Wildlife releases. I created some search capability within this dataset so a user can find the area they are looking for.

Within this plugin I added the ability to calculate the quality of fishing at any particular spot depending on the date and frequency of fish stocking. 

The best part is that it ties into the camping details plugin and adds extra information to the details if there is water nearby that the campers can enjoy.  

Technologies Used

  • AJAX
  • Bootstrap
  • cPanel
  • CSS
  • Dreamweaver
  • HTML
  • jQuery
  • JSON
  • MySQL
  • Photoshop
  • PHP
  • REST API
  • WordPress
  • Workbench

I’ve used a wide variety of technology and techniques on this website. Starting at as little more than a camping blog it has become something that has a lot of really cool features and is very useful to anyone who enjoys camping, especially in Colorado. 

http://campoutcolorado.com

Fyxt RPG

The Fyxt RPG is a game I have developed fashioned after a traditional tabletop role playing game. I combine the feel of this type of game with the digital tools and convenience of the internet. 

Enjoy the traditional tabletop gaming experience while being able to pull up your character, the rules, generators, and more from any connected device. 

Technology Utilized

  • AJAX
  • Bootstrap
  • CSS
  • HTML
  • JavaScript
  • jQuery
  • MySQL
  • PHP
  • WordPress

Software Backed Game

The game is supported by a wide range of tools for the players to utilize.  Users are able to use premade content or create their own custom content for their game. 

There is a memberships system which allows different access and storage capabilities depending on the user levels. These include both paid and free memberships. 

Online tools I have created for this website:

Along with the game itself I have developed many tools for the Fyxt RPG system to help players easily accomplish a wide variety of things. Here is the page that lists all of the current tools for the Fyxt RPG. These are things like character generator wizards, search tools, and ways to edit the various game elements.

Custom Dice Roller Plugin

This is a custom plugin I wrote for this game. It adds a shortcode that can be used to insert a jQuery/Javascript dice roller that the players can use. This helps them calculate more complex rolls or allows them to play the game if they don’t have any dice handy.

Custom Character Template Example

Here is an example of a character sheet custom template for the Fyxt RPG. This is largely built with Flexbox and Bootstrap to pack lots of information on the screen. This allows users the best view of their characters whether they are on a desktop, table, or their phone.

These are just a few examples of the extensive programming and customization I have created for the Fyxt RPG.

There are custom templates, theme modifications, custom plugins, and a large customized database that all work together to let people play the Fyxt RPG anywhere on any device.

Manually Change WordPress Theme to Default in Database

Here is how to manually change the WordPress theme to a default (Twenty Fifteen) in database. Do not use this method if you are not familiar with manually editing your WordPress Database in phpMyAdmin.

The three option_name rows in the database that need to be changed. These are what control which theme is currently active on your WordPress website.

  • template – the “Theme Name” as defined in style.css
  • stylesheet – the actual name of your theme folder
  • current_theme -the actual name of your theme folder

CREATE A BACKUP OF YOUR DATABASE BEFORE YOU BEGIN!

This tutorial on how to manually change WordPress theme to default assumes that the prefix of your database is wp_. If it isn’t, make sure to change the code presented below to match.

SQL to Find WordPress Theme Settings

First, run this to see what the current theme is set in your WordPress website.

Copy this information to somewhere safe. This is so you can quickly revert or change it later if you would like to.

SQL to Change Theme to Default in WordPress

Make sure that you have the default theme for WordPress loaded into /wp-content/themes/. For this example I am using the Twenty Fifteen WordPress default theme.

This works with ANY theme. Just make sure the theme files are loaded into your website.

Run the following code. Change ‘twentyfifteen’ to whatever WordPress theme you are using if not Twenty Fifteen.

Problems Changing WordPress Theme Default Manually

The most common problems are:

  • Typo in SQL
  • Missing Theme Files
  • Cached Page – Purge or Disable Cache

Please let me know if I missed anything or if you have additional tips.

This is a really handy fast trick to use to fix a WordPress website that you cannot access normally. Manually changing WordPress theme to default in the database is a fast and great way to test out and debug your website.