Adobe Photoshop Links

General
Tutorial Sites

Skills Tutorials

Photo Retouch Tutorials

Adobe Products Links

Trainings

Acrobat

Audition

Photoshop Lightroom

MySQL Server Links

General
Troubleshooting
  • Login error after used MySQL 4.1
    Password format changed in MySQL 4.1. Add this into /etc/my.cnf, reset the password again.

    [mysqld]
    old-passwords
    

    Reference: MySql 4.1 A Few Important Features To Consider

  • Client does not support authentication protocol
    Reset the password with: SET PASSWORD FOR ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);
    A.2.3 Client does not support authentication protocol

  • 050725 15:43:56 Warning: Asked for 196608 thread stack, but got 126976. InnoDB: Error: pthread_create returned 11
    You may have SELinux turned on. Check /var/log/messages, try to reconfig your policy. Or simply disable SELinux with: /usr/sbin/setenforce 0 and edit the /etc/sysconfig/selinux

  • Restore the database without foreign key constraint:
    SET FOREIGN_KEY_CHECKS = 0;
    SOURCE /path/backupfile.sql;
    SET FOREIGN_KEY_CHECKS = 1;
    
Tools
Documentation

XOOPS CMS Links

General
Documentation
Module Development

Important Notes

  • When development, turn on display_errors in php.ini. Turn on Debug Mode in XOOPS Admin page, so that you know what is happening.
  • If using CVS/SVN to do version control, I think it is preferrable to NOT using multiple themes/templates and edit the default files directly, so that the changes are keep at the file level instead of inside the database, which is much easier to do tracking.

Information

Modules

Core

3rd party

Useful FAQs

When you have any problems on using XOOPS, or just begin to use XOOPS. I highly recommend you to visit the XOOPS FAQ website.
Below are some of the useful FAQs I recommend to start with:

Visual Studio Links

General
Setup
  • Quan To’s Visual Studio 2005 Setup blog
    “Please insert the disc: Visual Studio 2005 DVD" problem:
    The workaround to get VS installed is to copy the entire VS folder to your hard drive and run setup.exe from there. Another option is to copy the DVD and burn it to another DVD and make sure the new DVD is called “DVD1″.

  • Visual Studio 2008 setup error: Unable to load sitsetup.dll
    Make sure Windows Installer 3.1 is installed
    Make sure the DVD has a disc label: DVD1
MSDN Reference
Design & Development
Application Installation and Deployment
  • MSI vs ClickOnce
    ClickOnce require .NET Framework 2.0 as minimal
    ClickOnce is per-user deployment instead of per-machine, has web-update and can control part of the program online/offline
    * Installation location is unknown! I cannot find the installed program at C:\Program Files
Applications
3rd party tools
  • dotfuscator for .NET
    Optimize and obfuscate codes to prevent reverse engineering. Community Edition included in Visual Studio 2005 Pro but not Express Edition.

  • .NET ReflectorFree class browser, explorer, analyzer and documentation viewer for .NET, also a decompiler.
    someone tested and found that this is a better decompiler

  • .NET Reflector Add-ins
  • PowerGUIA free PowerShell GUI by Quest Software
  • AnkhSVNVS.NET addin for Subversion
Components
Tutorials
Community
ADO.NET
  • Major ADO.NET 2.0 changes
    • Bulk insert
    • Get notified when data changes
    • Execute multiple queries at once, and receive a series of results (Seems SQL Server 2005 only)
    • Asynchronous command (download sql data in background)
ASP.NET
Visual C#
Visual Basic .NET

PHP Links

OS Commerce

Socket Programming

Json Support

  • JSON (JavaScript Object Notation)
  • Steps to enable json extension in RHEL 5/CentOS 5
    Installation steps on CentOs 5.x include
    
    # yum install php-devel
    # yum install php-pear
    # yum install gcc
    # pear install pecl/json
    
    # cd /etc/php.d
    # echo "extension=json.so" > json.ini
    # service httpd restart
    
    After that phpinfo() would output
    
    json support     enabled
    json version     1.2.1 
    

PHP PDO

  • Experience (2011-04-27)
    • Serious bug in mysql, rowCount return no result
    • Run FetchAll() 2 times will generate exception error HY000 2050
  • Introduction to PHP PDO
  • PDO versus MDB2
    Problem: PDO could not start a new session before stop the current session

General

Framework

Portals / Articles

Portals

PHP Articles

Non PHP Articles (To be moved somewhere)

Forums

PHP and Unicode

PHP Extensions


PECL Classes


PEAR Classes

  • Tree
  • Pager_Pager (Pagination for database w/o limit function or raw data)
  • DB_Pager (Pagination for database)
  • DB_DataObject (code generation from SQL Database tables)
  • Contact_Vcard_Build (a class to create vCard)
  • HTML_QuickForm (A very complete form class)
    • Example for enable Client Side JavaScript valiation
      Add ‘client’ to the 5th element of the AddRule function

    • List of QuickForm rules (as of v3.2.2)
      ‘required’ => array(‘html_quickform_rule_required’, ‘HTML/QuickForm/Rule/Required.php’),
      ‘maxlength’ => array(‘html_quickform_rule_range’, ‘HTML/QuickForm/Rule/Range.php’),
      ‘minlength’ => array(‘html_quickform_rule_range’, ‘HTML/QuickForm/Rule/Range.php’),
      ‘rangelength’ => array(‘html_quickform_rule_range’, ‘HTML/QuickForm/Rule/Range.php’),
      ’email’ => array(‘html_quickform_rule_email’, ‘HTML/QuickForm/Rule/Email.php’),
      ‘regex’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘lettersonly’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘alphanumeric’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘numeric’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘nopunctuation’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘nonzero’ => array(‘html_quickform_rule_regex’, ‘HTML/QuickForm/Rule/Regex.php’),
      ‘callback’ => array(‘html_quickform_rule_callback’, ‘HTML/QuickForm/Rule/Callback.php’),
      ‘compare’ => array(‘html_quickform_rule_compare’, ‘HTML/QuickForm/Rule/Compare.php’)

    • compare rule example
    • Custom rules example (add a compare function in QuickForm 2.x)
      function cmpPass($element, $pass2val)
      {
      global $form;
      $pass1val = $form->getElementValue(‘passwd1’);
      return ($pass1val == $pass2val);
      }
      $form->registerRule(‘compare’, ‘function’, ‘cmpPass’);
      $form->addElement(‘password’, ‘passwd1’, ‘Enter password’);
      $form->addElement(‘password’, ‘passwd2’, ‘Confirm password’);
      $form->addElement(‘submit’, ‘submit’, ‘submit’);
      $form->addRule(‘passwd1’, ‘Please enter password’, ‘required’);
      $form->addRule(‘passwd2’, ‘Please confirm password’, ‘required’);
      $form->addRule(‘passwd2’, ‘Passwords are not the same’, ‘compare’, ‘function’);

    • PEAR HTML_QuickForm Getting Started Guide
    • pookey.co.uk – HTML_QuickForm Tutorial
  • The Log Package

PHP Libraries / 3rd party applications

PHP Applications

Troubleshooting

SMATV Links

DTT
Components
Others