Generating Random Strings in SQL

The other day I was requested to add records to a lookup table only if the description being added didn’t exist. This seemed easy to do since I could run a select against a table and use NOT EXIST. However; I quickly realized that once I got the result of the select I would need to add a record, I had to create a unique alpha character to be used in the table as a primary key (could not use integer). So how do you create a random character that is unique? After looking at several options I came across a SQL forum that helped me in creating a function that helps. Learn More

Tags: , , , , , , , , | Posted under Programming/Coding | Comments Off

Recover a Forgotten Password in phpBB

Today we will talk about resetting a password if you have forgotten it.

First go to your login button and click it.

After that you will be navigated to a login screen. From there, you can click on I forgot my password: Learn More

Tags: , , , , , , , , , | Posted under phpBB | Leave a comment

Protect Joomla from Attacks

Joomla is one of the most secure open source software available. You can build secure websites within minutes with it. However, we always recommend to add extra layers of security, to keep the integrity of your Joomla website and our servers. In this article, I will give you a step-by-step guide on how to protect Joomla from hacking attacks.

Learn More

Tags: , , , , , , , , , , , , , , , , , , | Posted under Joomla | Leave a comment