Today I need these php codes for transferring nuke users to a xoops site..and I wrote these codes and wanted to share with you
It is very simple..just use it 
<?php
$MysqlHost = "localhost"; // your mysql host
$MysqlKullanici = "root"; // your mysql user name
$MysqlSifre = ""; // your mysql password
$NukeVeritabaniAdi = "nuke"; // your nuke database name
$NukeVeritabaniOneki = "nuke"; // your nuke prefix
$XoopsVeritabaniAdi = "xoops"; // your xoops database name
$XoopsVeritabaniOneki = "xoops"; // your xoops prefix
$veriyolu = mysql_connect($MysqlHost, $MysqlKullanici, $MysqlSifre);
mysql_select_db($NukeVeritabaniAdi, $veriyolu);
$nukeuyelerinisor = mysql_query("SELECT * FROM ".$NukeVeritabaniOneki."_users ORDER BY user_id ASC");
while($nukeuyeleri = mysql_fetch_array($nukeuyelerinisor)) {
mysql_select_db($XoopsVeritabaniAdi);
$kayit = mysql_query("INSERT INTO ".$XoopsVeritabaniOneki."_users (uid, uname, email, user_regdate, pass, umode) VALUES('".$nukeuyeleri['user_id']."', '".$nukeuyeleri['username']."', '".$nukeuyeleri['user_email']."', '".time()."', '".$nukeuyeleri['user_password']."', 'flat');");
if($kayit) {
mysql_query("INSERT INTO ".$XoopsVeritabaniOneki."_groups_users_link (groupid, uid) VALUES ('2', '".$nukeuyeleri['user_id']."');");
echo $nukeuyeleri['username']." added successfully <br />";
}
else {
echo $nukeuyeleri['username']." passd because this id has already exists <br />";
}
}
echo "<br />That's all .... <a href="http://www.xoopshocasi.com">XoopSHoCasI</a>";
mysql_close($veriyolu);
?>
Bora Canbula -- xoopshocasi@xoopshocasi.com
Uncertified XOOPS Support
|
