Well, it is nice when your project to group and it mean not only more money, but more server resources. And if you didn't start to receive money it will be normal if you will start to search for options without increasing monthly payments.

In goal to lower server resource consummation, logic optimization and cache is primary goals.

Drupal offer file cache for anonymous and I already applied it, but to improve performance for registered users I use Cache_Lite in custom modules and theme. And now, this steps are not enough, client database go down every day and we agreed that best option is better server. One problem is that client need time to find better offer, because current hoster have not better offers.

Currently we have big troubles with MySQL - we already have "dedicated" container, and it isn't enough.

My goal was keep site running until client decide where to move it. And I start search in Drupal modules repository and forums. And found cacherouter - perfect solution for our case.

But, when I install it I get conflict with Cache_Lite - both have "Cache.php" and cacherouter include this one from PEAR directory, because of include_path setting. Change this setting isn't option - Cache_Lite will do errors. With little research I found next line:

require 'Cache.php';

Look like conflict can be easily changed

require drupal_get_path('module', 'cacherouter').'/Cache.php';

but because of cacherouter logic drupal_get_path isn't available

require getcwd().'/sites/all/modules/cacherouter/Cache.php';

solve problem and can not be submited as patch to cacherouter module. So, I have submit issue "Conflict with Cache_Lite" and if you know how it can be done in "Drupal way", please send me solution.

How you detect trends? how you follow mainstream? and do we need Zeitgeist?

May be you see news? may be you read opinions and conclusion from analytics? Well, every one have goal, my own goal is to be clear how I can get what I want and mainstream can help me in my goal.

So, as result I use many sources to monitor trends, but facts facts and my own analyzes is preferable. An nice post "http://www.phpclasses.org/blog/post/113-PHP-Zeitgeist-What-PHP-developers-have-been-looking-for-in-the-last-decade.html" by Manuel Lemos show as some PHP trends as well Manual refer to google "Year-End Zeitgeist"

Can rank, defined ranks and showed graphs be facts? Well, it is question about trust. I use many sources and when they confirm each other - I trust them, but I remember that there are possibility for errors and misses.

With version 1.4, GPix have "Advaced settings" which provide you control over advanced features. You can leave them as is and GPix will work, but you can research them and choose to change for your special case.

Since GPix 1.4.0 "Grids advanced settings" section via options "Allow region description?, Enable page per region?, Enable page per user?,
Disable region link on region page?" provide more control over links for regions:

Enable page per region? - will activate "page per region" and replace grid region links with links to region page.

Allow region description? - previous option allow you to enable region page, this setting activate extra field for content used in this page. As result users will be able to put more realable content over links and improve page rank.

Enable page per user? - well, you discover that region can have its own page, this option activate personal page for every user.

Disable region link on region page? - this options have sense when you have activated "page per region" and disable links on region page. Pay money for region and have not link? What is sense for this feature? - reasonable questions. But remember GPix is used by many peoples with many different goals. So, as example "Family walls", "Friend walls" or even "Gallery walls" don't need to have "back links". So, it is very specific, but still useful.

Do you like and use SimpleXML? it is nice library for development common tasks, but have one BIG limitation - SimpleXML extension requires PHP 5. And what you will do if client have PHP4? it will be big success if client can upgrade php to version 5, but if not? There are a lot php custom solution which require PHP4 and clients don't want to spent money for upgrades or just prefer to to leave it as it, because it work.

Don't worry there are solution! you can use SimpleXML class

For example to view structured PHP rss feed from kalexandr.com you can do something like this:

<?php
$file = "http://www.kalexandr.com/taxonomy/term/4/0/feed";
$sxml = new simplexml;
$data = $sxml->xml_load_file($file);
print_r($data);
?>


Outlook is Microsoft mail agent program. And it is popular, because is part of several Microsoft software packages.

When peoples work with Outlook long years. And it is normal for peoples to use this data in another application. In many cases when peoples choose program they can not images which requirement they will have in the feature. As result it is possible to have data in "unique" format. And when you need to change mail server you need to configure. But why man need to open dialog boxes and make mistake when hosting company are able to provide ready to use configuration file? or take outlook configuration file to fetch data from another mail server?

Outlook use IAF files and PHP can handle it. PHP IAF decoder coder class for Outlook configuration files is adopted PERL CPAN package and it can import/export data from iaf files. As result we can handle export/import via web forms! amazing.

So, we need to download IAF class file and start to use it.

As usually, to be more specific how we can use it, I provide example:

<?php

require_once 'File_Format_Iaf.php';
$iaf = new File_Format_Iaf();

$iaf->AccountName = 'My Account big_user@example.com';
$iaf->MakeAvailableOffline = 1;

// fill pop3 configuration options
$iaf->POP3Server = 'pop3.example.com';
$iaf->POP3UserName = 'Big_User';
$iaf->POP3Password = '987321';
$iaf->POP3LeaveMailOnServer = 0;
$iaf->POP3PasswordPrompt = 0;

// and configure smtp
$iaf->SMTPDisplayName = 'Big User';
$iaf->SMTPEmailAddress = 'big_user@example.com';
$iaf->SMTPServer = 'smtp.example.com';
$iaf->SMTPUserName = 'big_user';

// now we can generate file! and sure you can just put it for download
$iaf->save('export.iaf');
?>

As result users will be happy! because they will not waste time with Outlook configuration procedure and just use iaf file with few clicks. And it will normal if every mail hosting company will care more about users and many options as possibility must be part of company politic.

PS: And don't forget to send thanks for Przemek Czerkas(PERL class) and Ruslan Kononov(PHP class) they did amazing work.

TUFaT 3.1.2 was released with next changes:
pyjuk7icsm

• "remember me" option for tree login
• improve portrait handler
• multiple fixes for magic_quotes_gpc problems

Now, this family tree script marked as stable and new features will be implemented.

Main goal for GPix versions 1.4.x is integration with third party systems. GPix 1.4.0 was release with integration API. Now, this API is improved and new integration modules added.

So, if you use vBulletin, Drupal, Mambo or Joomla. GPix can handle user authentication for this systems. As result you existing user don't need separate registration for GPix. More all existing users will be handled automatically.

This release contain next changes:

• integration with Mamba
• integration with vBulletin
• integration with Drupal 5/6
• fix for joomla integration admin interface
• RFC822 date generation fix
• fix grid export functionality
• add cache for grid export

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


this error just "come". Many users don't touch admin settings very long time and got this error when have tried to update settings. After research I discover that problem caused by new MySQL version (5.1). I am not sure if this problem have relation with mysql configuration settings, but it isn't GPix problem with MySQL 5.0 and lower GPix work many years without any notice. Look like MySQL 5.1 don't like definition NULL default 0 and situation when GPix try to update table and don't set value for column with this definition MySQL generate this error.

So, question is how we can solve this? - it is simple

look error message for table and column. In our case

• mp_settings - it is table name. You can see it in first line of message after word 'update'
• site_down - is our column and you can see it at the end of message before 'cannot be null'

Now you can build and execute mysql query which will fix this error:

ALTER TABLE `mp_settings` MODIFY `site_down` `site_down` INT NULL DEFAULT 0;

do not forget to replace table name(mp_settings) and column name(site_down - twice)

Execute query like this via phpMyAdmin or mysql console and error will go away.

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.
In next version I plan Drupal, WordPress.org, Mambo and vBulletin

Some users report problem with PayPal module. After step 6(process payment) GPix return them to step 1(get pixels), but payment page expected.

After multiple tests and user site verification I define settings combination which broke GPix payment process.
Before official GPix 1.3.6 release all users can download fix from official support forum