Installing Dolphin U Alpha on your Test Server

Hello and welcome! In today’s blog, I’m going to show you how to install Boonex’s newest product Dolphin U. Remember this is an alpha version so it should only be used for testing.

Start by downloading the latest version from here:

http://ci.boonex.com/index.php

Once downloaded to your home computer simply unzip the files and then use your favorite FTP program to upload them to your test server. After uploading direct your browser to the associated web address and you will be taken directly into the install routine.

dolphin u install

dolphin u install

Next, click “start installation” and you will be taken to the permissions page.

dolphin u permissions

dolphin u permissions

If your server is setup correctly everything should already be correct. If not you must use CHMOD to change the permission as suggested – If you’re stuck with this simply reach out to your hosting provider.

Now create a new database in your website control panel and make note of the credentials. The next screen will ask you for an email, site title and those database credentials.

dolphin u install info

dolphin u install info

The final screen will show you the cron tab information you will need to add to cPanel (or your control panel of choice).

dolphin u cron info

dolphin u cron info

That’s it, installation is complete! You are now free to experiment as you like with the “next big thing”.

Looking for quality BoonEx Dolphin Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , | Posted under BoonEX Dolphin | Leave a comment

How to Protect Your WordPress

As many users are probably aware, WordPress is one of the premier open source blog software available on the internet. It has gone far beyond the standard weblog and is now an excellent foundation for just about any type of website. However, the internet itself is fraught with inherent dangers which leave users open to attack by unscrupulous hackers.

It must be understood that it is impossible to prevent every attack, but there are many steps that can be taken to protect WordPress users and their websites. WordPress users have found the software to be highly configurable with an excellent support community available. Because of these features, users can expect considerable levels of security by adhering to the following recommendations outlined below.

Learn More

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

[TomatoCart] Show variants in the products grid table

It’s really not effective to verify variants linked to products in the admin panel. The store owner must click the edit button in the products grid to open the products dialog to check the variants.

Snip20141214_2

So, it would be better to show the variants directly in the products grid as follow:

Snip20141214_4

It is not difficult to apply it for your store. You just need to update a few of code:

Step 1. Open products.php under admin > includes > jsons fold and then find following code snippet:

$Qstatus = $osC_Database->query('select products_id from :table_products_frontpage where products_id = :products_id');
        $Qstatus->bindInt(':products_id', $Qproducts->value('products_id'));
        $Qstatus->bindTable(':table_products_frontpage', TABLE_PRODUCTS_FRONTPAGE);
        $Qstatus->execute();

Add following code after it:

$Qvariants = $osC_Database->query('select * from :table_products_variants where products_id = :products_id order by is_default DESC');
        $Qvariants->bindTable(':table_products_variants', TABLE_PRODUCTS_VARIANTS);
        $Qvariants->bindInt(':products_id', $Qproducts->value('products_id'));
        $Qvariants->execute();
        
        $groups = array();
        while ($Qvariants->next()) {
        	$Qvalues = $osC_Database->query('select pve.products_variants_groups_id as groups_id, pve.products_variants_values_id as variants_values_id, pvg.products_variants_groups_name as groups_name, pvg.sort_order as groups_sort_order, pvv.products_variants_values_name as variants_values_name, pvv.sort_order as sort_order from :table_products_variants_entries pve, :table_products_variants_groups pvg, :table_products_variants_values pvv where pve.products_variants_groups_id = pvg.products_variants_groups_id and pve.products_variants_values_id = pvv.products_variants_values_id and pvg.language_id = pvv.language_id and pvg.language_id = :language_id and pve.products_variants_id = :products_variants_id order by pvg.sort_order, pvg.products_variants_groups_name, pve.products_variants_groups_id');
        	$Qvalues->bindTable(':table_products_variants_entries', TABLE_PRODUCTS_VARIANTS_ENTRIES);
        	$Qvalues->bindTable(':table_products_variants_groups', TABLE_PRODUCTS_VARIANTS_GROUPS);
        	$Qvalues->bindTable(':table_products_variants_values', TABLE_PRODUCTS_VARIANTS_VALUES);
        	$Qvalues->bindInt(':language_id', $osC_Language->getID());
        	$Qvalues->bindInt(':products_variants_id', $Qvariants->valueInt('products_variants_id'));
        	$Qvalues->execute();
        	
        	while ($Qvalues->next()) {
        		$groups[$Qvalues->value('groups_name')] = $Qvalues->value('variants_values_name');
        	}
        	
        	$Qvalues->freeResult();
        }
        
        $Qvariants->freeResult();
        
        $variants_groups = '';
        if (count($groups) > 0) {
        	foreach ($groups as $group_name => $entry_value) {
        		$variants_groups .= $group_name . ': ' . $entry_value . '<br />';
        	}
        }
        
        if (empty($variants_groups)) {
        	$variants_groups = '--';
        }

Find following code snippet:

$records[] = array(
          'products_id'         => $Qproducts->value('products_id'),
          'products_name'       => $Qproducts->value('products_name'),
        	'products_sku'				=> $Qproducts->value('products_sku'),
          'products_frontpage'  => $products_frontpage,
          'products_status'     => $Qproducts->value('products_status'),
          'products_price'      => $products_price,
          'products_quantity'   => $Qproducts->value('products_quantity')
        );

Replace it with:

$records[] = array(
          'products_id'         => $Qproducts->value('products_id'),
          'products_name'       => $Qproducts->value('products_name'),
        	'products_sku'				=> $Qproducts->value('products_sku'),
          'products_frontpage'  => $products_frontpage,
          'products_status'     => $Qproducts->value('products_status'),
          'products_price'      => $products_price,
          'products_quantity'   => $Qproducts->value('products_quantity'),
		  'variants_groups' => $variants_groups
);

Step 2. Open products_grid.php under admin > includes > extmodules/products fold and then find following code snippet:

{name: 'products_id'},
{name: 'products_name'},
{name: 'products_sku'},
{name: 'products_frontpage'},
{name: 'products_status'},
{name: 'products_price', type: 'string'},
{name: 'products_quantity', type: 'int'},
{name: 'products_status'}

Replace it with:

      {name: 'products_id'},
      {name: 'products_name'},
      {name: 'products_sku'},
      {name: 'products_frontpage'},
      {name: 'products_status'},
      {name: 'products_price', type: 'string'},
      {name: 'products_quantity', type: 'int'},
      {name: 'products_status'},
      {name: 'variants_groups'}

Find following code:

{header: "<?php echo $osC_Language->get('table_heading_quantity'); ?>", dataIndex: 'products_quantity', sortable: true, width: 80, align: 'center'},

Add following code after it:

{header: "<?php echo $osC_Language->get('table_heading_variants'); ?>", dataIndex: 'variants_groups', width: 150, align: 'center'},

That’s it. If you can’t update code by yourself, don’t hesitate to contact me(support@tomatocart.com).

 Looking for quality TomatoCart hosting? Check out Arvixe Web Solutions

Posted under TomatoCart | 2 Comments