Code: ›
/*********************************************************/
/* Init G2 API */
/* Exports phpnuke users to g2 and */
/* Initial user/group management synchronization. */
/* Output: False if error
/* user info text to display if success */
/*********************************************************/
define("NB_USER_TO_EXPORT_BY_PASS", 3);
function g2_phpnukeTog2UserExport()
{
global $db, $user_prefix,$Phpnuke2G2Lang;
// init G2 transaction, load G2 API, if not already done so
if (!init())
{
return false;
}
// Load all existing phpnuke <-> G2 mappings
list ($ret, $mapsbyentityid, $mapsbyexternalid) = g2getallexternalIdmappings();
if (!$ret)
{
return false;
}
// Map the ExternalmapId "admin" to the last phpnuke admin account found
// TODO: Mapping for multiple admins
list ($ret, $adminGroupId) = GalleryCoreApi::getPluginParameter('module', 'core', 'id.adminGroup');
if ($ret->isError())
{
g2_message('Enable to fetch the admin group. Here is the error message from G2: <br />'.$ret->getAsHtml());
return false;
}
list ($ret, $adminList) = GalleryCoreApi::fetchUsersForGroup($adminGroupId, 5);
if ($ret->isError())
{
g2_message('Enable to fetch a member in the admin group. Here is the error message from G2: <br />'.$ret->getAsHtml());
return false;
}
foreach ($adminList as $adminId => $adminName)
{
}
if (!isset ($mapsbyexternalid["admin"]))
{
if (!g2addexternalMapEntry("admin", $adminId, 0))
{
return false;
}
$outputtext .="Admin account create<br/><br/>";
}
// TODO: Update of the admin account if it already exists
// Export all standard phpnuke users (except anonymous: id=1) to G2 defaut group
// --- dari addon (multiple pass)
$sql = "SELECT count(*) AS ucount FROM ".$user_prefix."_users";
$user_count = $db->sql_fetchrow($db->sql_query($sql));
$nextpage = 0;
$startuser = $_POST['startuser'];
for($i = $startuser; $i <= $user_count['ucount']; $i++)
{
if($i == $startuser+NB_USER_TO_EXPORT_BY_PASS)
{
$nextpage = 1;
break;
}
$outputtext .= "UserId($i) ";
$query='SELECT user_id, name, username, user_password, user_email, user_lang, user_regdate FROM '.$user_prefix."_users WHERE user_id = $i LIMIT 1";
$result=$db->sql_query($query);
if($db->sql_numrows($result) != 0)
{
$sqluserdata = $db->sql_fetchrow($result);
$nukeuser_id = $sqluserdata['user_id'];
$nukeuser_uname = $sqluserdata['username'];
$nukeuser_name = $sqluserdata['name'];
$nukeuser_cryptpass = $sqluserdata['user_password'];
$nukeuser_email = $sqluserdata['user_email'];
$nukeuser_lang = $sqluserdata['user_lang'];
$g2nukeuser_lang = $Phpnuke2G2Lang[$nukeuser_lang];
$nukeuser_regdate = $sqluserdata['user_regdate'];
list( $regmonth, $regday, $regyear ) = split( " ", $nukeuser_regdate );
$regphpusertimestamp = mktime( 0, 0, 0, $regmonth, $regday, $regyear );
// Get Arguments for the new user:
$args['fullname'] = $nukeuser_name;
$args['username'] = $nukeuser_uname;
$args['hashedpassword'] = $nukeuser_cryptpass;
$args['hashmethod'] = 'md5';
$args['email'] = $nukeuser_email;
$args['language'] = $g2nukeuser_lang;
$args['creationtimestamp'] = $regphpusertimestamp;
// if the map exists, just update the user data
if (isset ($mapsbyexternalid[$nukeuser_id]))
{
$ret = GalleryEmbed :: updateUser($nukeuser_id, $args);
if (!$ret->isSuccess())
{
g2_message('Failed to update G2 user with extId ['.$nukeuser_id.']. Here is the error message from G2: <br />'.$ret->getAsHtml());
return false;
}
else
{
$outputtext .= $nukeuser_uname.' (has been updated)<br/>';
}
}
// else we create the user
else
{
$ret = GalleryEmbed :: createUser($nukeuser_id, $args);
if (!$ret->isSuccess())
{
g2_message('Failed to create G2 user with extId ['.$nukeuser_id.']. Here is the error message from G2: <br />'.$ret->getAsHtml());
return false;
}
if (!g2addexternalMapEntry($nukeuser_uname, $nukeuser_id, 0))
{
return false;
}
else
{
$outputtext .= $nukeuser_uname.' (added to g2 users)<br/>';
}
}
}
}
$outputtext .= "<br/>".($i-$startuser)." users imported...<br/><br/>";
// Eveything is ok till now, so ask for the next page if needed
if($nextpage == 1)
{
$startUserNextPage = "<input type=\"hidden\" name=\"startuser\" value=\"$i\">";
$outputtext .="<form action=\"admin.php\" method=\"post\">"."<table border=\"0\">";
$outputtext .="<input type=\"hidden\" name=\"op\" value=\"gallery2_user_export\">"."<tr><td><input type=\"submit\" value=\""._G2_NEXT_PAGE."\">$startUserNextPage</td></tr>"."</table></form>";
}
else
{
$outputtext .= _USER_EXPORT_COMPLETED."<br/>";
}
return $outputtext;
}
Forum FAQ
Statistics
Search
Usergroups
)
