add('info',
l10n('Tab_Info'),
$my_base_url.'&tab=info');
$tabsheet->add('manage',
l10n('Tab_Manage'),
$my_base_url.'&tab=manage');
$tabsheet->add('Migration',
l10n('Tab_Migration'),
$my_base_url.'&tab=Migration');
$tabsheet->add('Synchro',
l10n('Tab_Synchro'),
$my_base_url.'&tab=Synchro');
$tabsheet->select($page['tab']);
$tabsheet->assign();
$page['infos'] = array();
$error = array();
// +-----------------------------------------------------------------------+
// | Getting plugin version |
// +-----------------------------------------------------------------------+
$plugin = RegFluxBB_Infos(REGFLUXBB_PATH);
$version = $plugin['version'] ;
// +-----------------------------------------------------------------------+
// | Functions
// +-----------------------------------------------------------------------+
function Audit_PWG_FluxBB()
{
global $page, $conf, $errors;
$conf_Register_FluxBB = isset($conf['Register_FluxBB']) ? explode(";" , $conf['Register_FluxBB']) : array();
$page_Register_FluxBB_admin = get_admin_plugin_menu_link(__FILE__);
$msg_error_PWG_Dup = '';
$msg_error_FluxBB_Dup = '';
$msg_error_Link_Break = '';
$msg_error_Link_Bad = '';
$msg_error_Synchro = '';
$msg_ok_Synchro = '';
$msg_error_PWG2FluxBB = '';
$msg_error_FluxBB2PWG = '';
$query = "
SELECT COUNT(*) AS nbr_dup, id, username
FROM ".USERS_TABLE."
GROUP BY BINARY username
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
$msg_error_PWG_Dup .= '
'.l10n('Error_PWG_Dup').$row['nbr_dup'].' x '.stripslashes($row['username']);
if ($msg_error_PWG_Dup == '')
array_push($page['infos'], l10n('Audit_PWG_Dup').'
'.l10n('Audit_OK'));
else
$msg_error_PWG_Dup = l10n('Audit_PWG_Dup').$msg_error_PWG_Dup.'
'.l10n('Advise_PWG_Dup');
$query = "
SELECT COUNT(*) AS nbr_dup, username
FROM ".FluxBB_USERS_TABLE."
GROUP BY BINARY username
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_FluxBB_Dup .= '
'.l10n('Error_FluxBB_Dup').$row['nbr_dup'].' x '.stripslashes($row['username']);
$subquery = "
SELECT id, username, email
FROM ".FluxBB_USERS_TABLE."
WHERE BINARY username = BINARY '".$row['username']."'
;";
$subresult = pwg_query($subquery);
while($subrow = pwg_db_fetch_assoc($subresult))
{
$msg_error_FluxBB_Dup .= '
id:'.$subrow['id'].'='.stripslashes($subrow['username']).' ('.$subrow['email'].')';
$msg_error_FluxBB_Dup .= ' ';
}
}
if ($msg_error_FluxBB_Dup == '')
array_push($page['infos'], l10n('Audit_FluxBB_Dup').'
'.l10n('Audit_OK'));
else
$msg_error_FluxBB_Dup = l10n('Audit_FluxBB_Dup').$msg_error_FluxBB_Dup.'
'.l10n('Advise_FluxBB_Dup');
$query = "
SELECT pwg.id as pwg_id, bb.id as bb_id, pwg.username as pwg_user, pwg.mail_address as pwg_mail
FROM ".FluxBB_USERS_TABLE." AS bb, ".USERS_TABLE." as pwg
WHERE bb.id NOT in (
SELECT id_user_FluxBB
FROM ".Register_FluxBB_ID_TABLE."
)
AND pwg.id NOT in (
SELECT id_user_pwg
FROM ".Register_FluxBB_ID_TABLE."
)
AND pwg.username = bb.username
AND pwg.mail_address = bb.email
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Break .= '
'.l10n('Error_Link_Break').stripslashes($row['pwg_user']).' ('.$row['pwg_mail'].')';
$msg_error_Link_Break .= ' ';
}
if ($msg_error_Link_Break == '')
array_push($page['infos'], l10n('Audit_Link_Break').'
'.l10n('Audit_OK'));
else
$msg_error_Link_Break = l10n('Audit_Link_Break').$msg_error_Link_Break;
$query = "
SELECT pwg.username as pwg_user, pwg.id as pwg_id, pwg.mail_address as pwg_mail, bb.id as bb_id, bb.username as bb_user, bb.email as bb_mail
FROM ".FluxBB_USERS_TABLE." AS bb
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = bb.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
WHERE pwg.username <> bb.username
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Bad .= '
'.l10n('Error_Link_Del').stripslashes($row['pwg_user']).' ('.$row['pwg_mail'].')'.' -- '.stripslashes($row['bb_user']).' ('.$row['bb_mail'].')';
$msg_error_Link_Bad .= ' ';
$msg_error_Link_Bad .= ' -- ';
}
$query = "
SELECT COUNT(*) as nbr_dead
FROM ".Register_FluxBB_ID_TABLE." AS Link
WHERE id_user_FluxBB NOT IN (
SELECT id
FROM ".FluxBB_USERS_TABLE."
)
OR id_user_pwg NOT IN (
SELECT id
FROM ".USERS_TABLE."
)
;";
$Compteur = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($Compteur) and $Compteur['nbr_dead'] > 0)
{
$msg_error_Link_Bad .= '
'.l10n('Error_Link_Dead').$Compteur['nbr_dead'];
$msg_error_Link_Bad .= ' ';
}
$query = "
SELECT COUNT(*) AS nbr_dup, pwg.id AS pwg_id, pwg.username AS pwg_user, bb.username AS bb_user, bb.id AS bb_id
FROM ".FluxBB_USERS_TABLE." AS bb
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = bb.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
GROUP BY link.id_user_pwg, link.id_user_FluxBB
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Bad .= '
'.l10n('Error_Link_Dup').$row['nbr_dup'].' = '.stripslashes($row['pwg_user']).' -- '.stripslashes($row['bb_user']).')';
$msg_error_Link_Bad .= ' ';
}
if ($msg_error_Link_Bad == '')
array_push($page['infos'], l10n('Audit_Link_Bad').'
'.l10n('Audit_OK'));
else
$msg_error_Link_Bad = l10n('Audit_Link_Bad').$msg_error_Link_Bad;
$query = "
SELECT pwg.username as username, pwg.password as pwg_pwd, pwg.mail_address as pwg_eml, FluxBB.password as bb_pwd, FluxBB.email as bb_eml
FROM ".FluxBB_USERS_TABLE." AS FluxBB
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = FluxBB.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
AND BINARY pwg.username = BINARY FluxBB.username
ORDER BY LOWER(pwg.username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
if ( ($row['pwg_pwd'] != $row['bb_pwd']) or ($row['pwg_eml'] != $row['bb_eml']) )
{
$msg_error_Synchro .= '
'.l10n('Error_Synchro').stripslashes($row['username']);
$msg_error_Synchro .= ' ';
if ($row['pwg_pwd'] != $row['bb_pwd'])
$msg_error_Synchro .= '
'.l10n('Error_Synchro_Pswd');
if ($row['pwg_eml'] != $row['bb_eml'])
$msg_error_Synchro .= '
'.l10n('Error_Synchro_Mail').'
-- PWG = '.$row['pwg_eml'].'
-- FluxBB = '.$row['bb_eml'];
}
else if ($conf_Register_FluxBB[5] == 'true')
$msg_ok_Synchro .= '
- '.stripslashes($row['username']).' ('.$row['pwg_eml'].')'.l10n('Audit_Synchro_OK');
}
if ($msg_error_Synchro <> '')
$msg_error_Synchro = l10n('Audit_Synchro').$msg_error_Synchro;
if ($msg_ok_Synchro <> '')
if ($msg_error_Synchro <> '')
array_push($page['infos'], l10n('Audit_Synchro').$msg_ok_Synchro.'
');
else
array_push($page['infos'], l10n('Audit_Synchro').$msg_ok_Synchro.'
'.l10n('Audit_OK'));
$query = "
SELECT username, mail_address FROM ".USERS_TABLE."
WHERE BINARY username <> BINARY 'guest'
AND id not in (
SELECT id_user_pwg FROM ".Register_FluxBB_ID_TABLE."
)
AND BINARY username not in (
SELECT username FROM ".FluxBB_USERS_TABLE."
)
ORDER BY LOWER(username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_PWG2FluxBB .= '
'.l10n('Error_PWG2FluxBB').stripslashes($row['username']).' ('.$row['mail_address'].')';
$msg_error_PWG2FluxBB .= ' ';
}
if ($msg_error_PWG2FluxBB == '')
array_push($page['infos'], l10n('Audit_PWG2FluxBB').'
'.l10n('Audit_OK'));
else
$msg_error_PWG2FluxBB = l10n('Audit_PWG2FluxBB').$msg_error_PWG2FluxBB;
$query = "
SELECT id, username, email FROM ".FluxBB_USERS_TABLE."
WHERE BINARY username <> BINARY '".$conf_Register_FluxBB[2]."'
AND id not in (
SELECT id_user_FluxBB FROM ".Register_FluxBB_ID_TABLE."
)
AND BINARY username not in (
SELECT username FROM ".USERS_TABLE."
)
ORDER BY LOWER(username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_FluxBB2PWG .= '
'.l10n('Error_FluxBB2PWG').stripslashes($row['username']).' ('.$row['email'].')';
$msg_error_FluxBB2PWG .= ' ';
}
if ($msg_error_FluxBB2PWG == '')
array_push($page['infos'], l10n('Audit_FluxBB2PWG').'
'.l10n('Audit_OK'));
else
$msg_error_FluxBB2PWG = l10n('Audit_FluxBB2PWG').$msg_error_FluxBB2PWG;
if ($msg_error_PWG_Dup <> '')
$errors[] = $msg_error_PWG_Dup . ( ($msg_error_FluxBB_Dup == '' and $msg_error_Link_Break == '' and $msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_FluxBB_Dup <> '')
$errors[] = $msg_error_FluxBB_Dup . ( ($msg_error_Link_Break == '' and $msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Link_Break <> '')
$errors[] = $msg_error_Link_Break . ( ($msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Link_Bad <> '')
$errors[] = $msg_error_Link_Bad . ( ($msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Synchro <> '')
$errors[] = $msg_error_Synchro . ( ($msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_PWG2FluxBB <> '')
$errors[] = $msg_error_PWG2FluxBB . ( ($msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_FluxBB2PWG <> '')
$errors[] = $msg_error_FluxBB2PWG;
}
// +-----------------------------------------------------------------------+
// | Actions process
// +-----------------------------------------------------------------------+
if (isset($_GET['action']) and ($_GET['action']=='link_dead'))
{
$query = "
DELETE FROM ".Register_FluxBB_ID_TABLE."
WHERE id_user_FluxBB NOT IN (
SELECT id
FROM ".FluxBB_USERS_TABLE."
)
OR id_user_pwg NOT IN (
SELECT id
FROM ".USERS_TABLE."
)
;";
$result = pwg_query($query);
Audit_PWG_FluxBB();
}
else if (isset($_GET['action']) and ($_GET['action']=='link_del') and isset($_GET['pwg_id']) and isset($_GET['bb_id']))
{
$query = "
DELETE FROM ".Register_FluxBB_ID_TABLE."
WHERE id_user_pwg = ".$_GET['pwg_id']."
AND id_user_FluxBB = ".$_GET['bb_id']."
;";
$result = pwg_query($query);
Audit_PWG_FluxBB();
}
else if (isset($_GET['action']) and ($_GET['action']=='new_link') and isset($_GET['pwg_id']) and isset($_GET['bb_id']))
{
FluxBB_Linkuser($_GET['pwg_id'], $_GET['bb_id']);
Audit_PWG_FluxBB();
}
else if (isset($_GET['action']) and ($_GET['action']=='sync_user') and isset($_GET['username']))
{
$query = "
SELECT id AS id_pwg, username, password, mail_address
FROM ".USERS_TABLE."
WHERE BINARY username = BINARY '".pwg_db_real_escape_string($_GET['username'])."'
LIMIT 1
;";
$data = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($data))
{
FluxBB_Updateuser($data['id_pwg'], stripslashes($data['username']), $data['password'], $data['mail_address']);
}
Audit_PWG_FluxBB();
}
else if (isset($_GET['action']) and ($_GET['action']=='add_user') and isset($_GET['username']))
{
$query = "
SELECT id, username, password, mail_address
FROM ".USERS_TABLE."
WHERE BINARY username = BINARY '".pwg_db_real_escape_string($_GET['username'])."'
LIMIT 1
;";
$data = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($data))
FluxBB_Adduser($data['id'], stripslashes($data['username']), $data['password'], $data['mail_address']);
Audit_PWG_FluxBB();
}
else if (isset($_GET['action']) and ($_GET['action']=='del_user') and isset($_GET['id']))
{
FluxBB_Deluser( $_GET['id'], true );
Audit_PWG_FluxBB();
}
// +-----------------------------------------------------------------------+
// | Tabssheet select |
// +-----------------------------------------------------------------------+
switch ($page['tab'])
{
case 'info':
$template->assign(
array(
'REGFLUXBB_PATH' => REGFLUXBB_PATH,
'REGFLUXBB_VERSION' => $version,
)
);
$template->set_filename('plugin_admin_content', dirname(__FILE__).'/template/info.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
break;
case 'manage':
if (isset($_POST['submit']) and isset($_POST['FluxBB_prefix']) and isset($_POST['FluxBB_admin']) and isset($_POST['FluxBB_guest']) and isset($_POST['FluxBB_del_pt']) and isset($_POST['FluxBB_confirm']) and isset($_POST['FluxBB_details']))
{
/* Configuration controls */
// Piwigo's admin username control
$query1 = "
SELECT username, id
FROM ".USERS_TABLE."
WHERE id = ".$conf['webmaster_id']."
;";
$pwgadmin = pwg_db_fetch_assoc(pwg_query($query1));
// FluxBB's admin username control
$query2 = "
SELECT username, id
FROM ".FluxBB_USERS_TABLE."
WHERE id = 2
;";
$fbbadmin = pwg_db_fetch_assoc(pwg_query($query2));
// FluxBB's Guest username control
$query3 = "
SELECT username, id
FROM ".FluxBB_USERS_TABLE."
WHERE id = 1
;";
$fbbguest = pwg_db_fetch_assoc(pwg_query($query3));
// Compute configuration errors
if (stripslashes($pwgadmin['username']) != stripslashes($_POST['FluxBB_admin']))
{
array_push($page['errors'], l10n('error_config_admin1'));
}
if (stripslashes($pwgadmin['username']) != stripslashes($fbbadmin['username']))
{
array_push($page['errors'], l10n('error_config_admin2'));
}
if (stripslashes($fbbguest['username']) != stripslashes($_POST['FluxBB_guest']))
{
array_push($page['errors'], l10n('error_config_guest'));
}
elseif (count($page['errors']) == 0)
{
if (!function_exists('FindAvailableConfirmMailID'))
{
$conf['Register_FluxBB'] = $_POST['FluxBB_prefix'].';'.addslashes($_POST['FluxBB_admin']).';'.addslashes($_POST['FluxBB_guest']).';'.$_POST['FluxBB_del_pt'].';'.$_POST['FluxBB_confirm'].';'.$_POST['FluxBB_details'].';false;0';
}
elseif (function_exists('FindAvailableConfirmMailID'))
{
$conf_UAM = unserialize($conf['UserAdvManager']);
if (isset($conf_UAM[1]) and ($conf_UAM[1] == 'true' or $conf_UAM[1] == 'local') and isset($conf_UAM[2]) and $conf_UAM[2] != '-1')
{
$conf['Register_FluxBB'] = $_POST['FluxBB_prefix'].';'.addslashes($_POST['FluxBB_admin']).';'.addslashes($_POST['FluxBB_guest']).';'.$_POST['FluxBB_del_pt'].';'.$_POST['FluxBB_confirm'].';'.$_POST['FluxBB_details'].';'.$_POST['FluxBB_UAM'].';'.$_POST['FluxBB_group'];
}
else
{
$conf['Register_FluxBB'] = $_POST['FluxBB_prefix'].';'.addslashes($_POST['FluxBB_admin']).';'.addslashes($_POST['FluxBB_guest']).';'.$_POST['FluxBB_del_pt'].';'.$_POST['FluxBB_confirm'].';'.$_POST['FluxBB_details'].';false;0';
}
}
$query = '
UPDATE '.CONFIG_TABLE.'
SET value="'.$conf['Register_FluxBB'].'"
WHERE param="Register_FluxBB"
LIMIT 1
;';
pwg_query($query);
array_push($page['infos'], l10n('save_config'));
}
}
$conf_Register_FluxBB = isset($conf['Register_FluxBB']) ? explode(";" , $conf['Register_FluxBB']) : array();
$template->assign(
array
(
'REGFLUXBB_PATH' => REGFLUXBB_PATH,
'REGFLUXBB_VERSION' => $version,
'FluxBB_PREFIX' => $conf_Register_FluxBB[0],
'FluxBB_ADMIN' => stripslashes($conf_Register_FluxBB[1]),
'FluxBB_GUEST' => stripslashes($conf_Register_FluxBB[2]),
'FluxBB_DEL_PT_TRUE' => (isset($conf_Register_FluxBB[3]) and $conf_Register_FluxBB[3] == 'true') ? 'checked="checked"' : '',
'FluxBB_DEL_PT_FALSE' => (isset($conf_Register_FluxBB[3]) and $conf_Register_FluxBB[3] == 'false') ? 'checked="checked"' : '',
'FluxBB_CONFIRM_TRUE' => (isset($conf_Register_FluxBB[4]) and $conf_Register_FluxBB[4] == 'true') ? 'checked="checked"' : '',
'FluxBB_CONFIRM_FALSE' => (isset($conf_Register_FluxBB[4]) and $conf_Register_FluxBB[4] == 'false') ? 'checked="checked"' : '',
'FluxBB_DETAILS_TRUE' => (isset($conf_Register_FluxBB[5]) and $conf_Register_FluxBB[5] == 'true') ? 'checked="checked"' : '',
'FluxBB_DETAILS_FALSE' => (isset($conf_Register_FluxBB[5]) and $conf_Register_FluxBB[5] == 'false') ? 'checked="checked"' : '',
)
);
// If UAM exists and if UAM ConfirmMail is set, we can set this feature
if (function_exists('FindAvailableConfirmMailID'))
{
$conf_UAM = unserialize($conf['UserAdvManager']);
$UAM_bridge = false;
if (isset($conf_UAM[1]) and ($conf_UAM[1] == 'true' or $conf_UAM[1] == 'local') and isset($conf_UAM[2]) and $conf_UAM[2] != '-1')
{
$UAM_bridge = true;
}
$template->assign(
array
(
'UAM_BRIDGE' => $UAM_bridge,
'FluxBB_UAM_LINK_TRUE' => (isset($conf_Register_FluxBB[6]) and $conf_Register_FluxBB[6] == 'true') ? 'checked="checked"' : '',
'FluxBB_UAM_LINK_FALSE' => (isset($conf_Register_FluxBB[6]) and $conf_Register_FluxBB[6] == 'false') ? 'checked="checked"' : '',
'FluxBB_GROUP' => $conf_Register_FluxBB[7],
)
);
}
$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/template/manage.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
break;
case 'Migration':
$conf_Register_FluxBB = isset($conf['Register_FluxBB']) ? explode(";" , $conf['Register_FluxBB']) : array();
if (isset($_POST['Migration']))
{
array_push($page['infos'], l10n('Mig_Start').'
');
array_push($page['infos'], l10n('Mig_Del_Link').'
');
$query = "TRUNCATE ".Register_FluxBB_ID_TABLE.";";
$result = pwg_query($query);
$msg_Mig_Del_AllUsers = '';
$query = "
SELECT username, id
FROM ".FluxBB_USERS_TABLE."
;";
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result))
{
if((stripslashes($row['username']) != stripslashes($conf_Register_FluxBB[2])) and (stripslashes($row['username']) != stripslashes($conf_Register_FluxBB[1])))
{
$msg_Mig_Del_AllUsers .= '
- '.l10n('Mig_Del_User').stripslashes($row['username']);
FluxBB_Deluser($row['id'], false);
}
}
array_push($page['infos'], l10n('Mig_Del_AllUsers').$msg_Mig_Del_AllUsers.'
');
$query = "
SELECT id, username, password, mail_address
FROM ".USERS_TABLE."
;";
$result = pwg_query($query);
$registred = time();
$registred_ip = $_SERVER['REMOTE_ADDR'];
$msg_Mig_Add_AllUsers = '';
while ($row = pwg_db_fetch_assoc($result))
{
if((stripslashes($row['username']) != 'guest') and (stripslashes($row['username']) != stripslashes($conf_Register_FluxBB[1])))
{
$msg_Mig_Add_AllUsers .= '
- '.l10n('Mig_Add_User').stripslashes($row['username']);
FluxBB_Adduser($row['id'], stripslashes($row['username']), $row['password'], $row['mail_address']);
}
}
array_push($page['infos'], l10n('Mig_Add_AllUsers').$msg_Mig_Add_AllUsers.'
');
$query = "
SELECT id, username, password, mail_address
FROM ".USERS_TABLE."
WHERE username = '".$conf_Register_FluxBB[1]."'
;";
$row = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($row))
{
array_push($page['infos'], l10n('Sync_User').stripslashes($row['username']).'
');
FluxBB_Updateuser($row['id'], stripslashes($row['username']), $row['password'], $row['mail_address']);
}
array_push($page['infos'], l10n('Mig_End'));
}
else if ( isset($_POST['Audit']))
{
Audit_PWG_FluxBB();
}
$template->assign(
array
(
'REGFLUXBB_PATH' => REGFLUXBB_PATH,
'REGFLUXBB_VERSION' => $version,
)
);
$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/template/migration.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
break;
case 'Synchro':
if ( isset($_POST['Synchro']))
{
global $page,$conf, $errors;
$conf_Register_FluxBB = isset($conf['Register_FluxBB']) ? explode(";" , $conf['Register_FluxBB']) : array();
$page_Register_FluxBB_admin = get_admin_plugin_menu_link(__FILE__);
$msg_error_PWG_Dup = '';
$msg_error_FluxBB_Dup = '';
$msg_error_Link_Break = '';
$msg_error_Link_Bad = '';
$msg_error_Synchro = '';
$msg_ok_Synchro = '';
$msg_error_FluxBB2PWG = '';
$msg_error_PWG2FluxBB = '';
$query = "
SELECT COUNT(*) AS nbr_dup, id, username
FROM ".USERS_TABLE."
GROUP BY BINARY username
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
$msg_error_PWG_Dup .= '
'.l10n('Error_PWG_Dup').$row['nbr_dup'].' x '.stripslashes($row['username']);
if ($msg_error_PWG_Dup <> '')
$msg_error_PWG_Dup = l10n('Audit_PWG_Dup').$msg_error_PWG_Dup.'
'.l10n('Advise_PWG_Dup');
$query = "
SELECT COUNT(*) AS nbr_dup, username
FROM ".FluxBB_USERS_TABLE."
GROUP BY BINARY username
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_FluxBB_Dup .= '
'.l10n('Error_FluxBB_Dup').$row['nbr_dup'].' x '.stripslashes($row['username']);
$subquery = "
SELECT id, username, email
FROM ".FluxBB_USERS_TABLE."
WHERE BINARY username = BINARY '".$row['username']."'
;";
$subresult = pwg_query($subquery);
while($subrow = pwg_db_fetch_assoc($subresult))
{
$msg_error_FluxBB_Dup .= '
id:'.$subrow['id'].'='.stripslashes($subrow['username']).' ('.$subrow['email'].')';
$msg_error_FluxBB_Dup .= ' ';
}
}
if ($msg_error_FluxBB_Dup <> '')
$msg_error_FluxBB_Dup = l10n('Sync_Check_Dup').$msg_error_FluxBB_Dup.'
'.l10n('Advise_FluxBB_Dup');
if ($msg_error_FluxBB_Dup == '' and $msg_error_PWG_Dup == '')
{
$query = "
SELECT pwg.id as pwg_id, bb.id as bb_id, pwg.username as pwg_user, pwg.mail_address as pwg_mail
FROM ".FluxBB_USERS_TABLE." AS bb, ".USERS_TABLE." as pwg
WHERE bb.id NOT in (
SELECT id_user_FluxBB
FROM ".Register_FluxBB_ID_TABLE."
)
AND pwg.id NOT in (
SELECT id_user_pwg
FROM ".Register_FluxBB_ID_TABLE."
)
AND pwg.username = bb.username
AND pwg.mail_address = bb.email
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Break .= '
'.l10n('New_Link').stripslashes($row['pwg_user']).' ('.$row['pwg_mail'].')';
FluxBB_Linkuser($row['pwg_id'], $row['bb_id']);
}
if ($msg_error_Link_Break == '')
array_push($page['infos'], l10n('Sync_Link_Break').'
'.l10n('Sync_OK'));
else
$msg_error_Link_Break = l10n('Sync_Link_Break').$msg_error_Link_Break;
$query = "
SELECT pwg.username as pwg_user, pwg.id as pwg_id, pwg.mail_address as pwg_mail, bb.id as bb_id, bb.username as bb_user, bb.email as bb_mail
FROM ".FluxBB_USERS_TABLE." AS bb
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = bb.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
WHERE BINARY pwg.username <> BINARY bb.username
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Bad .= '
'.l10n('Link_Del').stripslashes($row['pwg_user']).' ('.$row['pwg_mail'].')'.' -- '.stripslashes($row['bb_user']).' ('.$row['bb_mail'].')';
$subquery = "
DELETE FROM ".Register_FluxBB_ID_TABLE."
WHERE id_user_pwg = ".$row['pwg_id']."
AND id_user_FluxBB = ".$row['bb_id']."
;";
$subresult = pwg_query($subquery);
}
$query = "
SELECT COUNT(*) as nbr_dead
FROM ".Register_FluxBB_ID_TABLE." AS Link
WHERE id_user_FluxBB NOT IN (
SELECT id
FROM ".FluxBB_USERS_TABLE."
)
OR id_user_pwg NOT IN (
SELECT id
FROM ".USERS_TABLE."
)
;";
$Compteur = pwg_db_fetch_assoc(pwg_query($query));
if ( !empty($Compteur) and $Compteur['nbr_dead'] > 0)
{
$msg_error_Link_Bad .= '
'.l10n('Link_Dead').$Compteur['nbr_dead'];
$query = "
DELETE FROM ".Register_FluxBB_ID_TABLE."
WHERE id_user_FluxBB NOT IN (
SELECT id
FROM ".FluxBB_USERS_TABLE."
)
OR id_user_pwg NOT IN (
SELECT id
FROM ".USERS_TABLE."
)
;";
$result = pwg_query($query);
}
$query = "
SELECT COUNT(*) AS nbr_dup, pwg.id AS pwg_id, pwg.username AS pwg_user, bb.username AS bb_user, bb.id AS bb_id
FROM ".FluxBB_USERS_TABLE." AS bb
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = bb.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
GROUP BY link.id_user_pwg, link.id_user_FluxBB
HAVING COUNT(*) > 1
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_Link_Bad .= '
'.l10n('Link_Dup').$row['nbr_dup'].' = '.stripslashes($row['pwg_user']).' -- '.stripslashes($row['bb_user']).')';
FluxBB_Linkuser($row['pwg_id'], $row['bb_id']);
}
if ($msg_error_Link_Bad == '')
array_push($page['infos'], l10n('Sync_Link_Bad').'
'.l10n('Sync_OK'));
else
$msg_error_Link_Bad = l10n('Sync_Link_Bad').$msg_error_Link_Bad;
$query = "
SELECT pwg.id as pwg_id, pwg.username as username, pwg.password as pwg_pwd, pwg.mail_address as pwg_eml, FluxBB.id as bb_id, FluxBB.password as bb_pwd, FluxBB.email as bb_eml
FROM ".FluxBB_USERS_TABLE." AS FluxBB
INNER JOIN ".Register_FluxBB_ID_TABLE." AS link ON link.id_user_FluxBB = FluxBB.id
INNER JOIN ".USERS_TABLE." as pwg ON link.id_user_pwg = pwg.id
AND BINARY pwg.username = BINARY FluxBB.username
ORDER BY LOWER(pwg.username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
if ( ($row['pwg_pwd'] != $row['bb_pwd']) or ($row['pwg_eml'] != $row['bb_eml']) )
{
$msg_error_Synchro .= '
'.l10n('Sync_User').stripslashes($row['username']);
$query = "
SELECT id, username, password, mail_address
FROM ".USERS_TABLE."
WHERE BINARY id = '".$row['pwg_id']."'
;";
$data = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($data))
FluxBB_Updateuser($data['id'], stripslashes($data['username']), $data['password'], $data['mail_address']);
}
}
if ($msg_error_Synchro == '')
array_push($page['infos'], l10n('Sync_DataUser').'
'.l10n('Sync_OK'));
else
$msg_error_Synchro = l10n('Sync_DataUser').$msg_error_Synchro;
$query = "
SELECT username, mail_address FROM ".USERS_TABLE."
WHERE BINARY username <> BINARY 'guest'
AND id not in (
SELECT id_user_pwg FROM ".Register_FluxBB_ID_TABLE."
)
AND BINARY username not in (
SELECT username FROM ".FluxBB_USERS_TABLE."
)
ORDER BY LOWER(username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_PWG2FluxBB .= '
'.l10n('Add_User').stripslashes($row['username']).' ('.$row['mail_address'].')';
$query = "
SELECT id, username, password, mail_address
FROM ".USERS_TABLE."
WHERE BINARY username = BINARY '".$row['username']."'
LIMIT 1
;";
$data = pwg_db_fetch_assoc(pwg_query($query));
if (!empty($data))
FluxBB_Adduser($data['id'], stripslashes($data['username']), $data['password'], $data['mail_address']);
}
if ($msg_error_PWG2FluxBB == '')
array_push($page['infos'], l10n('Sync_PWG2FluxBB').'
'.l10n('Sync_OK'));
else
$msg_error_PWG2FluxBB = l10n('Sync_PWG2FluxBB').$msg_error_PWG2FluxBB;
$query = "
SELECT id, username, email FROM ".FluxBB_USERS_TABLE."
WHERE BINARY username <> BINARY '".$conf_Register_FluxBB[2]."'
AND id not in (
SELECT id_user_FluxBB FROM ".Register_FluxBB_ID_TABLE."
)
AND BINARY username not in (
SELECT username FROM ".USERS_TABLE."
)
ORDER BY LOWER(username)
;";
$result = pwg_query($query);
while($row = pwg_db_fetch_assoc($result))
{
$msg_error_FluxBB2PWG .= '
'.l10n('Error_FluxBB2PWG').stripslashes($row['username']).' ('.$row['email'].')';
$msg_error_FluxBB2PWG .= ' ';
}
if ($msg_error_FluxBB2PWG == '')
array_push($page['infos'], l10n('Sync_FluxBB2PWG').'
'.l10n('Sync_OK'));
else
$msg_error_FluxBB2PWG = l10n('Sync_FluxBB2PWG').$msg_error_FluxBB2PWG;
}
else
$errors[] = l10n('Advise_Check_Dup');
if ($msg_error_PWG_Dup <> '')
$errors[] = $msg_error_PWG_Dup . ( ($msg_error_FluxBB_Dup == '' and $msg_error_Link_Break == '' and $msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_FluxBB_Dup <> '')
$errors[] = $msg_error_FluxBB_Dup . ( ($msg_error_Link_Break == '' and $msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Link_Break <> '')
$errors[] = $msg_error_Link_Break . ( ($msg_error_Link_Bad == '' and $msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Link_Bad <> '')
$errors[] = $msg_error_Link_Bad . ( ($msg_error_Synchro == '' and $msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_Synchro <> '')
$errors[] = $msg_error_Synchro . ( ($msg_error_PWG2FluxBB == '' and $msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_PWG2FluxBB <> '')
$errors[] = $msg_error_PWG2FluxBB . ( ($msg_error_FluxBB2PWG == '') ? '' : '
' );
if ($msg_error_FluxBB2PWG <> '')
$errors[] = $msg_error_FluxBB2PWG;
}
else if ( isset($_POST['Audit']))
{
Audit_PWG_FluxBB();
}
$template->assign(
array
(
'REGFLUXBB_PATH' => REGFLUXBB_PATH,
'REGFLUXBB_VERSION' => $version,
)
);
$template->set_filename('plugin_admin_content', dirname(__FILE__) . '/template/synchro.tpl');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');
break;
}
?>