NULL problem in GPix admin panel

Latest weeks I got many bug reports about error like this:

Database Error: DB Error: constraint violation(update `mp_settings` set 
site_name`='XXXX',`site_description`='YYYY',`currency_symbol`='$',`user_accounts`='1',`approval_required`='0', 
`admin_email`='manager@example.com',`html_email`='0',`use_fckeditor`='1', `secret`='jdb314tab518', 
`interlaced_images`='0',`palette_images`='0',`site_down`=NULL, `blog_comments`='0', 
`expires_check_at`=NULL,`multiple_grid_pages`='1',`grid_columns`='1',`rss_latest_pixels`='10',`rss_top_pixels`='10', 
`rss_blog_articles`='0',`pixel_list_by_clicks`='0',`seo_status`='optimized',`link_to_us_enabled`=NULL,`upload_images`='1', 
`order_image_galleries`='ksort#SORT_REGULAR',`pixel_list_enable_images`='1' where `id`='1' 
[nativecode=1048 ** Column 'site_down' cannot be null])

Tags:
Links:

GPix 1.4.0 released

Why I release 1.4.0 directly after 1.3.6?
answer is simple - new core functionality.

New integration design provide way integrated GPix with third party software. As example in 1.4.0 you can see Joomla integration.

Tags:
Links:

what is PDO?

many clients ask me why I suggest to use PDO as part of optimization

it is very simple
PDO structures is native PHP drivers, which mean that was designed and optimized for PHP

Just image, libmysql use buffers and PHP interface use buffers. This mean that functionality is doubled! It is absolutely normal step to remove libmysql as layer. As part of server optimization this step require MySQL 4.1 as minimal version.

At the end, migration from libmysql usage to PDO save up to 40% server resources!

Tags:
Links:

backlink checker

I have received several mails from active GPix testers about 'back links' functionality.

It is common way to increase you site rank and don't spend direct money for this.
So, I see common problem 'curl' extension and cron setup.

As result I will try to implement this functionality without this requirements.

Tags:
Links:

Grids as options

option list via direct lists for multiple grids (http://forum.tufat.com/showthread.php?p=153689)

To implement this feature in your skin, you need to apply next changes
index.tpl:

{if $links}
    {foreach item=link from=$links}
        {$link}   
    {/foreach}
{/if}

replaced with:
{if !$app->setting->grids_as_options}
  {if $links}
    {foreach item=link from=$links}
      {$link}   
    {/foreach}
  {/if}
{/if}

after this line

      <td align="right">

in toolbar.inc.tpl
insert next code:
        {if $app->setting->grids_as_options}
          ##Grid:##

Tags:
Links:

Original images development

I have many request for original images feature

so, now it is done

GPix users which will update its own templates need to merge index.tpl, show_pixels.tpl and style.css with original files from GPix package.

Tags:
Links:

GPix translation example

translation update for request
http://forum.tufat.com/showthread.php?p=204697#post204697

instructions:

  • upload attached file to temp directory, grant read permission
  • go to "Import Language Texts" in administration menu, choose "de (Deutsch)" and click import
  • use "Clear cache" administration menu to clear caches
  • go to "Get pixels" page and review
Tags:
Links:

direct links option for GLink

It is requested http://forum.tufat.com/showthread.php?t=36544

So, something like that was done for GPix and now will be merged with GLink source tree.

It is part of SEO practice, so like for GPix this feature will be configurable via admin.

Links: