Codezwiz >> Forums >> General PHP Nuke Help >> really could do with some advice

my site used to run on e107 now it runs on the php nuke but when running e107 i had over 3000 users but i carnt seem to move the user tables over to the nuke_users table is there anyway to transfrer the user tables over to nuke.or have i to add em one by one?sort of really stuck on this so any help much aprecatded.?

You would have to make a transfer script.

$result = $db->sql_query("SELECT * FROM first_table");
while($row = $db->sql_fetchrow($result)) {
$db->sql_query("UPDATE second_table SET username = 'first_table_username', user_password = 'first_table_user_password' etc.............
} //end select loop

could anyone give me any more help with this please ive tryed and tryed but to no aval im STUCK and STUMPED

Register

Without seeing the columns in the users table it's impossible for someone to build a script to do this. And just like Telli said with the timestamp...table and column formats differ tremendously to make this even more difficult to even an experienced webmaster. Not to mention...any other features you have on your site that use members information will have to be converted.

All in all...it's hard to tranfer users from one Nuke CMS to another...it's real talent to convert users from a different CMS to Nuke..or any other for that matter. But Telli's tip is a great start if you know how to code a bit and understand how your tables work.

Register

I do SQL conversions for any platform... all I need is a table structure for your user's table from e107 and the table structure or version of nuke that you are importing to if you have not added mods

Refiner...thanks for helping out however, if you could please resize your sig to the board specs...thanks

Register

Soz.. I haven't been here in a long time so I haven't checked sig specs for the board... I'll change it