Content Management Systems (CMS)

Create Joomla Super Administrator using SQL

150 150 rhecht

Original post courtesy of projectamplify.com:

There are a number of reasons why you may need to re-create a Joomla! super administrator, most of them are to get you out of trouble if your main Joomla! “admin” account has been corrupted or changed.

Recently we installed an Admin content restriction extension into a clients project at their request. Needless to say it was not well designed and fried all super admin logins! So we thought this information will be bound to help someone out!

Here is how to create a new user in Joomla! 1.5 manually, using the database management tool, phpMyAdmin. (For those who want to know how to use phpMyAdmin tool, it is a tutorial in itself so search for it and thee shall find!).

There are a couple steps involved as the database contains user information spread over a number of tables so we will run 3 segments of SQL code into the “Insert SQL” tab in phpMyAdmin.

Step 1

Create the new Joomla! User

REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES ('60', 'Admin2', 'admin2', '[email protected]', '21232f297a57a5a743894a0e4a801fc3:abcdefghijklmnopqrstuvwxyz012345', 'Super Administrator', '0', '0', '25', '2000-01-01 00:00:00', '0000-00-00 00:00:00', '', '');

The code above creates a new user with ID number 60 and the name set to admin2.

Step 2

Create an ARO object out of the new Joomla! user

REPLACE INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES ('8', 'users', '60', '0', 'Admin2', '0');

This creates an ARO object with ID number 8. Note that the ‘name’ field must match the ‘name’ field in Step 1

Step 3

Next you will need to map this ARO object to the Super Administrator group, which by default is group ID 25:

REPLACE INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES ('25', '', '8');

The user is now ready to login using “admin: admin2, password: admin”. We use the REPLACE instead of INSERT function above because the query will fail if the database record already exists.

Hope this helps!

Contus Magento – Database Tables to Migrate

150 150 rhecht

Moving over to a new Contus website and need to transfer all data to one of their new installations? Here are a few table groups:

Admins: admin_role, admin_rule, admin_user

Catalog Products, entities and more:┬ácatalog_ – all tables

Sales: sales_ – all tables

Order Coupon Codes: ordercustomer

Newsletter subscribers: newsletter_ – all tables

Referral/Affiliate System: advert_ – all tables

Customer Information: customer_ – all tables

Caching options: core_cache_option

CMS Pages: cms_page and cms_page_store

CMS Page Blocks: cms_block and cms_block_store

 

I think that’s all, as far as I know.

Finding the Right CMS Solution

150 150 israelmoskowitz

Finding the right CMS is something that needs to be done right the first time. There is nothing that will be more important to a company than the choice of content management system (CMS). A company director will need to know what the company needs to effectively choose the right software to effectively manage daily business activities. Review some helpful tips below to help a company make its selection.

What Does The Company Need?

A company might understand why they need the perfect content management system, but not understand why or how a CMS can help a business. If a company would like to use tools such as social media integration and multi-language access, then a content management system should allow for this. Other needs a business must think about is if the CMS has the ability to organize all of its content. This should be one of the top factors in comparing content management systems.

Determine the right CMS for a company by looking at its current IT infrastructure. The CMS solution that is chosen must integrate itself seamlessly into the IT infrastructure a company currently uses. Remember that the right CMS solution will have a small learning curve and provide upgrades during the lifetime of the product.

Choosing Based On Price

Here is a helpful tip for a company that needs help with finding the right CMS; do not choose based on price. Our brains have been programmed to believe that the more expensive product is the best product for us. However, this does not apply to CMS solutions. There are a wide range of software in CMS that have mid-range prices. Some of the more expensive products can be “over-stuffed” with different features that most companies will not need or use. It is essential for a company to test products in different price ranges, before choosing the best for the business.

User Interface and Usability

The usability and the user interface of a content management system will be key. It is suggested that a company try demo versions of any CMS solutions they are interested in. Even though the back-end of a product might look great, it is not until employees start using the product that a company will be able to decide if it is a good fit. By using demos, a company can also determine if the product will integrate well into its IT infrastructure. The usability level of a CMS solution can be determined by a variety of factors such as how fast it loads, how easy it is to navigate and the amount of technical support it requires.

Customer Support

The amount of customer or technical support that is required to use a CMS is a good indicator for someone who needs help choosing a CMS solution. If a CMS product requires a company to constantly phone for support, then it will be time-consuming to operate. Remember that a CMS product should also provide customer support when you need it. The last thing a company needs is to experience technical difficulties with a software and not be able to contact the vendor’s technical support department.