function upgrade_240_250()
{
global $conf;
load_language('plugin.lang', REGFLUXBB_PATH);
$plugin = RegFluxBB_Infos(REGFLUXBB_PATH);
$version = $plugin['version'];
// Upgrading options - Changing config variables to assoc array
// ------------------------------------------------------------
$conf_RegFluxBB = isset($conf['Register_FluxBB']) ? explode(";", $conf['Register_FluxBB']) : array();
$Newconf_RegFluxBB = array('REGFLUXBB_VERSION' => $version, 'FLUXBB_PREFIX' => $conf_RegFluxBB[0], 'FLUXBB_ADMIN' => $conf_RegFluxBB[1], 'FLUXBB_GUEST' => $conf_RegFluxBB[2], 'FLUXBB_DEL_PT' => $conf_RegFluxBB[3], 'FLUXBB_CONFIRM' => $conf_RegFluxBB[4], 'FLUXBB_DETAIL' => $conf_RegFluxBB[5], 'FLUXBB_UAM_LINK' => $conf_RegFluxBB[6], 'FLUXBB_GROUP' => $conf_RegFluxBB[7]);
$update_conf = serialize($Newconf_RegFluxBB);
$q = '
DELETE FROM ' . CONFIG_TABLE . '
WHERE param="Register_FluxBB" LIMIT 1
;';
pwg_query($q);
$q = '
INSERT INTO ' . CONFIG_TABLE . ' (param, value, comment)
VALUES ("Register_FluxBB","' . pwg_db_real_escape_string($update_conf) . '","Register_FluxBB parameters")
;';
pwg_query($q);
}
function plugin_install($id, $version, &$errors)
{
global $prefixeTable, $conf;
// Set current plugin version in config table
$plugin = RegFluxBB_Infos(REGFLUXBB_PATH);
$version = $plugin['version'];
// Default global parameters for RegisterFluxBB conf
// -------------------------------------------------
$defaultRegFluxBB = array('REGFLUXBB_VERSION' => $version, 'FLUXBB_PREFIX' => '', 'FLUXBB_ADMIN' => '', 'FLUXBB_GUEST' => '', 'FLUXBB_DEL_PT' => 'false', 'FLUXBB_CONFIRM' => 'false', 'FLUXBB_DETAIL' => 'false', 'FLUXBB_UAM_LINK' => 'false', 'FLUXBB_GROUP' => '');
// Create RegisterFluxBB conf if not already exists
// ------------------------------------------------
$query = '
SELECT param
FROM ' . CONFIG_TABLE . '
WHERE param = "Register_FluxBB"
;';
$count = pwg_db_num_rows(pwg_query($query));
if ($count == 0) {
$q = '
INSERT INTO ' . CONFIG_TABLE . ' (param, value, comment)
VALUES ("Register_FluxBB","' . pwg_db_real_escape_string(serialize($defaultRegFluxBB)) . '","Register_FluxBB parameters")
;';
pwg_query($q);
}
// Create relation table between FluxBB and Piwigo
// -----------------------------------------------
$q = '
CREATE TABLE IF NOT EXISTS ' . Register_FluxBB_ID_TABLE . ' (
id_user_pwg smallint(5) NOT NULL default "0",
id_user_FluxBB int(10) NOT NULL default "0",
PwdSynch varchar(3) default NULL,
PRIMARY KEY (id_user_pwg),
KEY id_user_pwg (id_user_pwg, id_user_FluxBB, PwdSynch)
)
;';
pwg_query($q);
}
global $page, $user, $lang, $conf, $template, $errors;
if (!defined('PHPWG_ROOT_PATH')) {
die('Hacking attempt!');
}
check_status(ACCESS_ADMINISTRATOR);
if (!defined('REGFLUXBB_PATH')) {
define('REGFLUXBB_PATH', PHPWG_PLUGINS_PATH . basename(dirname(__FILE__)) . '/');
}
include_once PHPWG_ROOT_PATH . 'admin/include/tabsheet.class.php';
include_once PHPWG_ROOT_PATH . '/include/constants.php';
load_language('plugin.lang', REGFLUXBB_PATH);
$conf_Register_FluxBB = unserialize($conf['Register_FluxBB']);
// +-----------------------------------------------------------------------+
// | Getting plugin version |
// +-----------------------------------------------------------------------+
$plugin = RegFluxBB_Infos(REGFLUXBB_PATH);
$version = $plugin['version'];
// +------------------------------------------------------------------+
// | Plugin settings |
// +------------------------------------------------------------------+
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'])) {
$_POST['FluxBB_admin'] = stripslashes($_POST['FluxBB_admin']);
$_POST['FluxBB_guest'] = stripslashes($_POST['FluxBB_guest']);
/* Configuration controls */
// Piwigo's admin username control
$query = '
SELECT username, id
FROM ' . USERS_TABLE . '
WHERE id = ' . $conf['webmaster_id'] . '
;';
$pwgadmin = pwg_db_fetch_assoc(pwg_query($query));
/**
* Function to update plugin version number in config table
* Used everytime a new version is updated even if no database
* upgrade is needed
*/
function RegFluxBB_version_update()
{
global $conf;
// Get current plugin version
// --------------------------
$plugin = RegFluxBB_Infos(REGFLUXBB_PATH);
$version = $plugin['version'];
// Upgrading options
// -----------------
$query = '
SELECT value
FROM ' . CONFIG_TABLE . '
WHERE param = "Register_FluxBB"
;';
$result = pwg_query($query);
$Conf_RegFluxBB = pwg_db_fetch_assoc($result);
$Newconf_RegFluxBB = unserialize($Conf_RegFluxBB['value']);
$Newconf_RegFluxBB['REGFLUXBB_VERSION'] = $version;
$update_conf = serialize($Newconf_RegFluxBB);
conf_update_param('Register_FluxBB', pwg_db_real_escape_string($update_conf));
// Check #_plugin table consistency
// Only useful if a previous version upgrade has not worked correctly (rare case)
// ------------------------------------------------------------------------------
$query = '
SELECT version
FROM ' . PLUGINS_TABLE . '
WHERE id = "Register_FluxBB"
;';
$data = pwg_db_fetch_assoc(pwg_query($query));
if (empty($data['version']) or $data['version'] != $version) {
$query = '
UPDATE ' . PLUGINS_TABLE . '
SET version="' . $version . '"
WHERE id = "Register_FluxBB"
LIMIT 1
;';
pwg_query($query);
}
}
