##
##
##           Mod title:  Biographile
##
##         Mod version:  1.0
##      Works on PunBB:  1.2.x
##        Release date:  25/03/2007
##
##              Author:  BN [http://la-bnbox.info]
##
##         Description:  With this plugile members can write their biography and
##                       read other members' biography.
##                       (You must install Plugile previously)
##
##      Affected files:  profile.php
##
##          Affects DB:  yes
##
##
##          DISCLAIMER:  Please note that "mods" are not officially supported by
##                       PunBB. Installation of this modification is done at your
##                       own risk. Backup your forum database and any and all
##                       applicable files before proceeding.
##


#
#---------[ 1. UPGRADE ]-------------------------------------
#

upload/plugins/UP_Ma_Biographie.php in /plugins/
upload/install_mod.php in /


#
#---------[ 2. RUN ]-------------------------------------------------------
#

install_mod.php


#
#---------[ 3. DELETE ]-----------------------------------------------------
#

install_mod.php


#
#---------[ 4. OPEN ]-------------------------------------------------------
#

profile.php


#
#---------[ 5. FIND ]-----------------------------------
#

$result = $db->query('SELECT u.username, u.email, u.title, u.realname, u.url, u.jabber, u.icq, u.msn, u.aim, u.yahoo, u.location, u.use_avatar, u.signature, u.disp_topics, u.disp_posts, u.email_setting, u.save_pass, u.notify_with_post, u.show_smilies, u.show_img, u.show_img_sig, u.show_avatars, u.show_sig, u.timezone, u.language, u.style, u.num_posts, u.last_post, u.registered, u.registration_ip, u.admin_note, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id='.$id) or error('unable to fetch user information', __FILE__, __LINE__, $db->error());


#
#---------[ 6. REPLACE BY ]------------------------------------------
#

$result = $db->query('SELECT u.username, u.email, u.title, u.realname, u.url, u.jabber, u.icq, u.msn, u.aim, u.yahoo, u.location, u.use_avatar, u.signature, u.disp_topics, u.disp_posts, u.email_setting, u.save_pass, u.notify_with_post, u.show_smilies, u.show_img, u.show_img_sig, u.show_avatars, u.show_sig, u.timezone, u.language, u.style, u.num_posts, u.last_post, u.registered, u.registration_ip, u.biographie, u.admin_note, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id='.$id) or error('unable to fetch user information', __FILE__, __LINE__, $db->error());


#
#---------[ 7. SAVE/UPLOAD ]----------------------------
#

profile.php


#
#---------[ 8. CONFIGURATION ]----------------------------------------------
#

To change plugile name, you must modify UP_Ma_biographie.php by UP_New_name.php :)
