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])


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

• fixed missed header problem. Sent mails going to spam in several Outlook versions.
• 'original image loss' problem solved for admin and users http://forum.tufat.com/showthread.php?t=55832
• fixed NULLs errors for settings table
• backlink-IPN paypal problems http://forum.tufat.com/showthread.php?t=55833
• option to disable images in tooltip
• developed integration design

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

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!

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.

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

in toolbar.inc.tpl
insert next code:

{if $app->setting->grids_as_options}
##Grid:##


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.

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

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.