Tag Archives: MYSQL

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.

SoCO Donor Tracking

This is a private website I created for a political group who needed an easy way to account for contributions, donors, and expenses. This is a very simple website with custom plugins and database work to keep track of all of this information.

Custom Donor Tracking Plugin

This website is powered by a custom WordPress plugin written in PHP. It creates the ability to add custom shortcodes to pages to produce forms and data tables.

Download Report CSV Files

One of the main features requested by the customer was to be able to query contributions in a variety of different ways. Then they needed to be able to download this queried information to use in their reporting. So I created a complex search form so they could filter through all of the information in a variety of different ways. Once they were satisfied with the dataset they could click a button to download the information from the database.

Technology Used

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

Unfortunately I am unable to share the links to this website as it is a private, login only, website. However, hopefully the information provided shows some of what the project required and how it was delivered.

WordPress Cron Can Kill a Website

I have run into this several times now so I thought I would write a quick article on it. It seems that WordPress’s cron really mess up a website.  Too many cron events will slow down your website. It can even cause timeout errors and out of memory issues.

What is cron?

Cron is basically a system to run programs in the background operation of your website. For a detailed explanation find out more here: Cron Info.

WordPress cron runs every time someone goes to your website. This is great as many plugin creators design software to do all kinds of fun and interesting things with your website. The downside is that these cron tasks can add up if not properly cleaned up. The average WordPress blog creator may not even know this exists. Worse, it can get full of all kinds of useless or out of data cron jobs.

The trouble is all these cron jobs are still queried, and possibly run, every time someone goes to your website. Over time this will certainly slow down your site. Especially if you experiment with many different plugins as many of them will leave residual cron tasks when they are uninstalled.

Check the WordPress Cron

First check your the WordPress cron and see if there is an unreasonable amount of cron jobs.

What’s unreasonable? That can vary greatly but I would say over 50 and you probably have too many. On my latest website with issues there were almost 20,000! Hard to say where they came from, but they needed to be cleared out!

First and foremost always backup your database when doing anything in it.

I prefer to go directly into the database with phpMyAdmin. Run the following SQL query.

This will retrieve the record of your cron jobs. In the option value field you will see something like this.

The only thing you really need to worry about is the very beginning of this entry. It will tell you how many cron jobs are present. In this case, there are 20.

In my case it looked like this.

19722! Yikes. This was pretty much crashing the website. Good news though. It is really easy to fix. Simply delete the cron entry and because of the magic and quality of WordPress the cron will be rebuilt the next time someone goes to your website. Easy as that!

Now you may need to go though and check your plugins, anything that schedules tasks, and verify that they are still scheduled and working. In most cases they will be. If not, set up the task again. These are things like calendars, auto backups, auto posts etc. All of these are done through cron jobs.

There is also a pretty cool plugin you can use to look at your cron jobs in a more UI friendly way.

https://wordpress.org/plugins/wp-crontrol/

Hopefully this helps you clean up and speed up your WordPress site!

DDM’s Realm Game Database

http://www.ddmsrealm.com/index.php/dungeons-and-dragons-quest-and-magic-item-database

This is one of the hobby sites that I run. This website is dedicated to the Massively Multi-player Online Role-playing game (MMORPG) Dungeons and Dragons Online.

Since games are one of my passions I decided to build a database of all the items and quests within Dungeons and Dragons Online. Thus gives players the ability to search for and find related quests and items. DDM’s Realm has turned into a very popular site for the game.

I strive to keep DDM’s Realm the most complete source of information available on the Internet. It pulls data from other sites and sources and is kept up-to-date by manual verification of game data.

ddmsrealm.com/ddoddmsrealm.com/ddoddmsrealm.com/ddo