Hacks: Nuke2Xoops Very Simple (Users Table)
Posted by: canbulaOn 2006/12/26 8:10:00 7562 readsToday 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


