*Column Information For - phpwebgallery.punbb_users*/
------------------------------------------------------

Field             Type                 Collation          Null    Key     Default  Extra           Privileges                       Comment
----------------  -------------------  -----------------  ------  ------  -------  --------------  -------------------------------  -------
id                int(10) unsigned     (NULL)             NO      PRI     (NULL)   auto_increment  select,insert,update,references         
group_id          int(10) unsigned     (NULL)             NO              4                        select,insert,update,references         
username          varchar(200)         latin1_swedish_ci  NO      MUL                              select,insert,update,references         
password          varchar(40)          latin1_swedish_ci  NO                                       select,insert,update,references         
email             varchar(50)          latin1_swedish_ci  NO                                       select,insert,update,references         
title             varchar(50)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
realname          varchar(40)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
url               varchar(100)         latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
jabber            varchar(75)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
icq               varchar(12)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
msn               varchar(50)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
aim               varchar(30)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
yahoo             varchar(30)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
location          varchar(30)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
use_avatar        tinyint(1)           (NULL)             NO              0                        select,insert,update,references         
signature         text                 latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
disp_topics       tinyint(3) unsigned  (NULL)             YES             (NULL)                   select,insert,update,references         
disp_posts        tinyint(3) unsigned  (NULL)             YES             (NULL)                   select,insert,update,references         
email_setting     tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
save_pass         tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
notify_with_post  tinyint(1)           (NULL)             NO              0                        select,insert,update,references         
show_smilies      tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
show_img          tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
show_img_sig      tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
show_avatars      tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
show_sig          tinyint(1)           (NULL)             NO              1                        select,insert,update,references         
timezone          float                (NULL)             NO              0                        select,insert,update,references         
language          varchar(25)          latin1_swedish_ci  NO              English                  select,insert,update,references         
style             varchar(25)          latin1_swedish_ci  NO              Oxygen                   select,insert,update,references         
num_posts         int(10) unsigned     (NULL)             NO              0                        select,insert,update,references         
last_post         int(10) unsigned     (NULL)             YES             (NULL)                   select,insert,update,references         
registered        int(10) unsigned     (NULL)             NO      MUL     0                        select,insert,update,references         
registration_ip   varchar(15)          latin1_swedish_ci  NO              0.0.0.0                  select,insert,update,references         
last_visit        int(10) unsigned     (NULL)             NO              0                        select,insert,update,references         
admin_note        varchar(30)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
activate_string   varchar(50)          latin1_swedish_ci  YES             (NULL)                   select,insert,update,references         
activate_key      varchar(8)           latin1_swedish_ci  YES             (NULL)                   select,insert,update,references

global $lang;

$lang['LinkUser2PunBB_Title'] = 'NBC LinkUser2PunBB';
$lang['LinkUser2PunBB_Disclaimer'] = '
  Step 1 : Set the plugin parameters with PunBBs parameters.<br/>
  Step 2 : Migrate the PWG accounts toward PunBB.<br/>
  Step 3 : Synchronize database tables (in case of an user account adding, deletion or update misfunction), update passwords and email addresses and show the intruders (but you should not have to use it).<br/>
  <br/>
  At ending of the 2 main steps, the plugin will be fully functional and you should not have to come back to this page.<br/>
  <br/>
  <b><blink>REMEMBER to do a security database backup (specially the tables [PWG_Prefix]_USERS, [PunBB_Prefix]_USERS and [PunBB_Prefix]_CONFIG) before using this plugin.</blink></b>';


$lang['LinkUser2PunBB_Config_Title'] = 'Step 1 : Plugin settings';
$lang['LinkUser2PunBB_Config_Disclaimer'] = '
  Check below your PunBBs installation parameters and change them if needed.<br/>
  Modify, if the case arises, the behavior of the plugin to your suitability.';
$lang['LinkUser2PunBB_Prefix'] = 'PunBB\'s tables prefix :';
$lang['LinkUser2PunBB_Admin'] = 'PWG administrator\'s user name.';
$lang['LinkUser2PunBB_Guest'] = 'PunBB Guest\'s user name.';
$lang['LinkUser2PunBB_User'] = '<b><u>Must be the same as PunBB\'s.</u></b> :';
$lang['LinkUser2PunBB_Details'] = 'Details level in operations reports.';
$lang['LinkUser2PunBB_Details_true'] = ' --&gt; Display all operations results details.';
$lang['LinkUser2PunBB_Details_false'] = ' --&gt; Only display the essential operations results.';
$lang['LinkUser2PunBB_Del_Pt'] = 'Deletion of user\'s topics and posts when he is suppressed.';
$lang['LinkUser2PunBB_Del_Pt_true'] = ' --&gt; Delete all.';
$lang['LinkUser2PunBB_Del_Pt_false'] = ' --&gt; Do not delete the topics and posts.';
$lang['LinkUser2PunBB_Confirm'] = 'Deletion the confirmations on the administrative actions in the audit.';
$lang['LinkUser2PunBB_Confirm_true'] = ' --&gt; Delete the confirmations.';
$lang['LinkUser2PunBB_Confirm_false'] = ' --&gt; Obligatory confirmation before action in the audit.';

$lang['LinkUser2PunBB_No_Reg'] = 'User registration through the forum.';
$lang['LinkUser2PunBB_No_Reg_true'] = ' --&gt; Allow the users registration directly through the PunBB forum (Warning ! By this way, they won\'t be able to connect the gallery !).';
$lang['LinkUser2PunBB_No_Reg_false'] = ' --&gt; Do not allow the users registration directly through the PunBB forum.';
$lang['LinkUser2PunBB_No_Reg_advise'] = "<br/><b>For more of easiness for your users, I recommend to modify the file</b> : [PunBB_Root]/lang/English/register.php<br/>
  <b>Replace the following line =</b><br/>
  'No new regs'        =>  'This forum doesn't accept any new users.',<br/>
  <b>with =</b><br/>
  'No new regs'        =>  \"&lt;a href=&quot;http://[PhpWebGallery_Root]/register.php&quot; &gt; Click here to register &lt;/a&gt;&lt;br/&gt;&lt;br/&gt;,<br/>
  <br/>
  Of course, you must make the same change for the other languages available in you PunBB forum.<br/>";

$lang['LinkUser2PunBB_save_config'] ='Settings saved successfully.';


$lang['LinkUser2PunBB_Audit_Btn'] = 'Audit';
$lang['LinkUser2PunBB_Sync_Btn'] = 'Synchronization';
$lang['LinkUser2PunBB_Sync_Title'] = 'Step 2 : Synchronize the PWG accounts toward PunBB.';
$lang['LinkUser2PunBB_Sync_Text'] = '
  <u>You already used the plugin to link your PWG and PunBB or your forum is not empty of users !!!</u><br/>
  <br/> -> It means there are users registered in your forum.<br/>
  - The synchronization will detect the present data while comparing the users names, their password (encoded)) and their email address in the two tables [PrefixPWG]_users and [PrefixPunBB]_users.<br/>
  - Then, will update the table of correspondence as well as the password and the email address of every account since PWG toward PunBB. Except PWG Guest and PunBB Anonymous.<br/>
  - Finally, will show in error the orphan accounts that only exist in one of the 2 tables ###_USERS.<br/>
  <br/>
  At the end of the operation, run an AUDIT. Please verify the possible doubloons in PunBBs users. If it is the case, it is necessary to suppress the oldest ones (PunBB users sorted according to their date of registration).<br/>';
$lang['LinkUser2PunBB_Sync_Check_Dup'] = '<b>Check of the PhpWebGallery and PunBBs users accounts to control the doubloons</b>';
$lang['LinkUser2PunBB_Advise_Check_Dup'] = '<b>UNABLE to continue the synchronization if you have some doubloons in the PhpWebGallery or PunBBs users accounts.</b><br/><br/>';
$lang['LinkUser2PunBB_Sync_Link_Break'] = '<b>Check of the repairable links between PhpWebGallery and PunBBs accounts.</b>';
$lang['LinkUser2PunBB_Sync_Link_Bad'] = '<b>Check of the bad links between PhpWebGallery and PunBBs accounts.</b>';
$lang['LinkUser2PunBB_Sync_DataUser'] = '<b>Check of the passwords and emails between PhpWebGallery and PunBBs accounts.</b>';
$lang['LinkUser2PunBB_Sync_PWG2PunBB'] = '<b>Check of the existing accounts in PhpWebGallery and missing ones in PunBB.</b>';
$lang['LinkUser2PunBB_Sync_PunBB2PWG'] = '<b>Check of the existing accounts in PunBB and missing ones in PhpWebGallery.</b>';
$lang['LinkUser2PunBB_Sync_OK'] = 'Synchronization done<br/><br/>';



$lang['LinkUser2PunBB_Audit_PWG_Dup'] = '<b>Audit of the PhpWebGallery accounts table</b>';
$lang['LinkUser2PunBB_Error_PWG_Dup'] = '<b>Error in the PhpWebGallery accounts table. There are some doubloons :</b> ';
$lang['LinkUser2PunBB_Advise_PWG_Dup'] = '<b>WARNING ! You must make these corrections in PWG before continuing.<br>Use the PWG users administration tool to resolve the problem.</b>';

$lang['LinkUser2PunBB_Audit_PunBB_Dup'] = '<b>Audit of the PunBB accounts table</b>';
$lang['LinkUser2PunBB_Error_PunBB_Dup'] = '<b>Error in the PunBB accounts table. There are some doubloons :</b> ';
$lang['LinkUser2PunBB_Advise_PunBB_Dup'] = '<b>WARNING ! You must make these corrections in PunBB before continuing.<br>Use the icons to suppress the PunBB users to resolve the problem.</b>';

$lang['LinkUser2PunBB_Audit_Link_Break'] = '<b>Audit of the repairable links between PhpWebGallery accounts and PunBBs</b>';
$lang['LinkUser2PunBB_Error_Link_Break'] = '<b>Broken link between PhpWebGallery accounts and PunBBs :</b> ';
$lang['LinkUser2PunBB_New_Link'] = 'Link of the account : ';

$lang['LinkUser2PunBB_Audit_Link_Bad'] = '<b>Audit of the bad links between PhpWebGallery accounts and PunBBs</b>';
$lang['LinkUser2PunBB_Error_Link_Del'] = '<b>Error in the links table between this 2 users :</b> ';
$lang['LinkUser2PunBB_Link_Del'] = 'Delete link : ';
$lang['LinkUser2PunBB_Error_Link_Dead'] = '<b>Error in Links table. There are some dead links :</b> ';
$lang['LinkUser2PunBB_Link_Dead'] = 'Delete dead links :';
$lang['LinkUser2PunBB_Error_Link_Dup'] = '<b>Error in links table. There are some doubloons :</b> ';
$lang['LinkUser2PunBB_Link_Dup'] = 'Delete duplicate links :';

$lang['LinkUser2PunBB_Audit_Synchro'] = '<b>Audit of the passwords and emails synchronization between PhpWebGallery and PunBBs accounts.</b>';
$lang['LinkUser2PunBB_Error_Synchro'] = '<b>Bad synchronization of the account :</b> ';
$lang['LinkUser2PunBB_Error_Synchro_Pswd'] = 'For password';
$lang['LinkUser2PunBB_Error_Synchro_Mail'] = 'For email address';
$lang['LinkUser2PunBB_Audit_Synchro_OK'] = ' <b>: Data synchonisation done</b>';
$lang['LinkUser2PunBB_Sync_User'] = 'Account synchonization : ';

$lang['LinkUser2PunBB_Audit_PWG2PunBB'] = '<b>Audit of the existing accounts in PhpWebGallery and missing ones in PunBB.</b>';
$lang['LinkUser2PunBB_Error_PWG2PunBB'] = '<b>The PhpWebGallery account doesn\'t exist in PunBB :</b> ';
$lang['LinkUser2PunBB_Add_User'] = 'Account adding in PunBB : ';

$lang['LinkUser2PunBB_Audit_PunBB2PWG'] = '<b>Audit of the existing accounts in PunBB and missing ones in PhpWebGallery.</b>';
$lang['LinkUser2PunBB_Error_PunBB2PWG'] = '<b>The PunBB account doesn\'t exist in PhpWebGallery :</b> ';
$lang['LinkUser2PunBB_Del_User'] = 'Account deletion in PunBB : ';

$lang['LinkUser2PunBB_Audit_OK'] = 'Audit OK<br/><br/>';



$lang['LinkUser2PunBB_Mig_Btn'] = 'Migration';
$lang['LinkUser2PunBB_Mig_Title'] = 'EXCEPTIONAL CASE: Migration of the PWG accounts toward PunBB';
$lang['LinkUser2PunBB_Mig_Text'] = '
  <u>!!! You never used the plugin to link your PhpWebGallery and PunBB AND your forum is empty of users !!!</u><br/>
  <br/>
  -> In this case, your table [PrefixPunBB]_users must be empty of all account except the guest and administrator accounts.<br/>
  - First, the migration process is going to suppress the links between PhpWebGallery accounts and PunBBs.<br/>
  - Then, <b>WILL DELETE ALL PunBBs accounts</b> except the guest and administrator accounts.<br/>
  <br/>
  <center><b>!!! WARNING IF THERE ARE PARTICULAR ACCOUNTS IN PunBB == ESPECIALLY NOT USE THIS FUNCTION !!!</b></center><br/>
  - Finally the migration process is going to create all the PWG accounts in PunBB, except the guest account.<br/>
  <br/>
  If some errors occur during the operation, correct the reason of the problem and restart the migration process (to that moment only you can renew the migration).<br/>';
$lang['LinkUser2PunBB_Mig_Disclaimer'] = '<b><blink>!!! NEVER DO A MIGRATION TO UPDATE !!!</blink></b>';
$lang['LinkUser2PunBB_Mig_Start'] = '<b>Migration of the PhpWebGallery accounts toward PunBB</b>';
$lang['LinkUser2PunBB_Mig_Del_Link'] = '<b>Deletion of the links between the PhpWebGallery accounts and PunBBs</b>';
$lang['LinkUser2PunBB_Mig_Del_AllUsers'] = '<b>Deletion of the PunBB accounts</b>';
$lang['LinkUser2PunBB_Mig_Del_User'] = '<b>Deletion of the account :</b> ';
$lang['LinkUser2PunBB_Mig_Add_AllUsers'] = '<b>Transfer of the PhpWebGallery accounts</b>';
$lang['LinkUser2PunBB_Mig_Add_User'] = '<b>Transfer of the account :</b> ';
$lang['LinkUser2PunBB_Mig_End'] = '<b>Migration done !</b>';

$lang['LinkUser2PunBB_Confirm'] = 'Suppression les confirmations sur les actions d\'administration dans l\'audit.';

$lang['LinkUser2PunBB_Confirm'] = 'Suppression des confirmations sur les actions d\'administration dans l\'audit.';

$lang['LinkUser2PunBB_Error_PWG2PunBB'] = '<b>Le compte PhpWebGallery n\'hésite pas dans PunBB :</b> ';

$lang['LinkUser2PunBB_Error_PWG2PunBB'] = '<b>Le compte PhpWebGallery n\'existe pas dans PunBB :</b> ';

$lang['LinkUser2PunBB_Error_PunBB2PWG'] = '<b>Le compte PunBB n\'hésite pas dans PhpWebGallery :</b> ';

$lang['LinkUser2PunBB_Error_PunBB2PWG'] = '<b>Le compte PunBB n\'existe pas dans PhpWebGallery :</b> ';