Tech Sharing Blog

That’s nothing perfect in the world, no matter how good the application and web site is, that’s still some hole that we may need to handle. By handling that kind of hole, we try to make our application close to perfect.

This powerpoint show that Why we need the error handling, What are error, how the error being handled, type of error, type of error handling.

Popularity: 2% [?]

In the presentation slide show it will cover the following topic include:

Popularity: 2% [?]

All the web developer, web admin, as well as DB admin are always facing the attacking from all around the world toward their web site, but how to prevent it?

Some may use the 3th party software to prevent it, some may just filter all the possible keyword enter by the user, some will use the database store procedure to prevent it. The following are some of the keyword that you may need to take care of when you allow your user to enter any input to your system.

Popularity: 2% [?]

Video2MP3 is a free YouTube, MyVideo, Clipfish, Sevenload, Dailymotion, MySpace to MP3 converter. It allow you to convert and download a video to MP3 file online. The best of the Video2MP3.net is totally free, fast, and no signup is require. All you need to do is enter the video URL into the text box on the Video2MP3 home page, than it will transfer the video to the MP3 for you to download.

So you are able to listen your favorite tracks from the selected video hosting portal on any MP3 player.

Video2MP3 provide standard (64k MP3) and high quality (128k MP3) MP3, the higher quality the MP3 is, the slower the downloading speed because it need time to convert it and also the file fize will be bigger.

Click here to go to Video2MP3 home page

Video2Mp3 home page

Convert youtube video into MP3 and download it

Popularity: 17% [?]

Because of I need to handle a project in my comany which include the forum features, but the language is Chinese Simplify, so I manage to find out this 9 years old product.

phpBB is a free and open source forum application. phpBB was created in June 2000 as UBB-like forum solution using the PHP language and the latest version up to today is phpBB 3.0 ‘Olympus 3.5′ (Release at 31 May 2009). phpBB is available at no cost, released under the GNU General Public License.

I choose this as my forum in the new project is because it come with an intuitive adminstration system and extensive customisation capabilities. Besides that, it is capable to supporting hundreds of million of discussions in any language and boatst some of the largest forum communities on the Internet. phpBB is developed by six core developers, more than forty team members and is supported by a community of almost 300,000 users and developers up to today.

The lastest version support the UTF-8 encoding including the Simplify chinese , tranditional chinese encoding, Russian, Thai, Turkish and more. Besides that, it support most of the most common database in market such as MSSQL, MySQL, PostgreSQL, Oracle, Firefird, SQLList. The release of phpBB 3.0 is come with nearly 500 enhancements, modification and extenstion compare to the previous version.

phpBB also is a highly recomended forum application for those who like to customize and quickly integrate into any content management system or static web site because it come with very flexible framework, documented Application Programming Interfaces (APIs).

Click here for more phpBB forum features list
Click here to go to phpBB forum official page
Click here to go to phpBB forum download page

phpBB forum home page

phpBB sample forum backend admin control paner

Popularity: 16% [?]

Just working out on the phpBB3.0 on the user registration integration with the main web site. Because of I plan to write the main web site using the coldfusion + MS SQL, so the only way as I may thinking of to do the integration is write a web service a like page for my coldfusion application to call.

After read through some forum, blog, web site and finally find out the way for the integration and here to share my simple PHPBB 3.0 user registration integration code.

  < ?PHP
  define('IN_PHPBB', true);
  /* set scope for variables required later */
  global $phpbb_root_path;
  global $phpEx;
  global $db;
  global $config;
  global $user;
  global $auth;
  global $cache;
  global $template;

  # your php extension
  $phpEx = substr(strrchr(__FILE__, '.'), 1);
  $phpbb_root_path = "../";

/* includes all the libraries etc. required */
  require($phpbb_root_path ."common.php");
  require($phpbb_root_path ."includes/functions_user.php");
  $use-->session_begin();
  $auth->acl($user->data);

// username of the user being added
$username = 'david';

// the user’s password, which is hashed before inserting into the data base
$password = 'password';

// an email address for the user
$email_address = 'admin@david-cheong.com';

// since group IDs may change, you may want to use a query to make sure you are grabbing the
// right default group...
$group_name = ($coppa) ? 'REGISTERED_COPPA' : 'REGISTERED';
$sql = 'SELECT group_id
        FROM ' . GROUPS_TABLE . "
        WHERE group_name = '" . $db->sql_escape($group_name) . "'
            AND group_type = " . GROUP_SPECIAL;

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$group_id = $row['group_id'];

// timezone of the user... Based on GMT in the format of '-6', '-4', 3, 9 etc...
$timezone = '8';

$language = 'zh_cmn_hans';

// here if the user is inactive and needs to activate thier account through an activation link
// sent in an email we need to set the activation key for the user... (the goal is to get it about
// 10 chars of randomization) you can use any randomization method you want, for this example,
// I’ll use the following...
$user_actkey = md5(rand(0, 100) . time());
$user_actkey = substr($user_actkey, 0, rand(8, 12));

// IP address of the user stored in the Data base.
$user_ip = $user->ip;

// registration time of the user, timestamp format.
$registration_time = time();

// time since the user is inactive. timestamp.
$user_inactive_time = time();

$user_row = array(
    'username'              => $username,
    'user_password'         => phpbb_hash($password),
    'user_email'            => $email_address,
    'group_id'              => (int) $group_id,
    'user_timezone'         => (float) $timezone,
    'user_dst'              => $is_dst,
    'user_lang'             => $language,
    'user_type'             => '0',
    'user_actkey'           => $user_actkey,
    'user_ip'               => $user_ip,
    'user_regdate'          => $registration_time,
	'user_dateformat'   	=> 'D M d, Y g:i a'
);

$user_id = user_add($user_row);

echo 'userid' . $user_id;

?>

Click here for PHP Cross Reference of Architecture PHPBB3

Popularity: 15% [?]