Pruning Members

[deejayh]

Hi All,

Can someone advise me how best to prune my members, remembering that the user databases for Mambo and SMF are linked.

I would like to remove everyone who has not activated their account and everyone who has not visited the forum since December 2005.

Any advice appreciated,
Thanx,
Dave

[Orstio]

What version of the bridge?

[deejayh]

Now theres a thought!! - sorry Orstio, not your problem. Seems so long ago, can't really remember which version, or where to look. Anyway smf.php date is 1/5/2006. I think it is Bridge 1.1.5 or could be 3.19a - First few line here: (Anyway to find out?)

Code Select Expand

<?php
/******************************************************************************
* smf.php                                                                     *
*******************************************************************************
* SMF: Simple Machines Forum                                                  *
* Open-Source Project Inspired by Zef Hemel ([email protected])                *
* =========================================================================== *
* Software Version:           SMF 1.1 RC2                                     *
* Software by:                Simple Machines (http://www.simplemachines.org) *
* Copyright 2001-2006 by:     Lewis Media (http://www.lewismedia.com)         *
* Support, News, Updates at:  http://www.simplemachines.org                   *
*******************************************************************************
* This program is free software; you may redistribute it and/or modify it     *
* under the terms of the provided license as published by Lewis Media.        *
*                                                                             *
* This program is distributed in the hope that it is and will be useful,      *
* but WITHOUT ANY WARRANTIES; without even any implied warranty of            *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                        *
*                                                                             *
* See the "license.txt" file for details of the Simple Machines license.      *
* The latest version can always be found at http://www.simplemachines.org.    *
******************************************************************************/

/* This file is the core of the Mambo-SMF bridge component
Sorry. Using SMF 1.1 RC2, bridge Un-Wrapped using BRIDGE Registration.

Thanks Orstio,
Regards,
Dave

[deejayh]

I am wondering wether to delete the "old" users in the databases for mambo and smf.
Would this be OK?

Cheers,
Dave

[Orstio]

You should be able to delete the users in SMF, and that should also delete them in Joomla.

[deejayh]

Well I took the plunge and deleted everyone in mos_users. Then went to smf admin and pruned/deleted all the non activated users and anyone not been on the site from a certain date.

I then went into mambo backend and then using the smf bridge, to copy smf users to mambo!

Now I cannot get into the admin area of mambo!! Help!

I have noticed in mos_users that admin was id: 62 now its 1, also there is no usertype, password says "migrated" and there are no register dates or lastvisit dates

How can I fix this??
Cheers,
Dave

[Orstio]

Well I took the plunge and deleted everyone in mos_users.

Why?  This is what I said:

You should be able to delete the users in SMF, and that should also delete them in Joomla

Which means that users you delete in SMF will automatically be deleted in Joomla as well.  You don't need to touch your mos_users table, or your Joomla users in any way.

Then went to smf admin and pruned/deleted all the non activated users and anyone not been on the site from a certain date.

That should have been your one and only step.

Now I cannot get into the admin area of mambo!!  Help!

I have noticed in mos_users that admin was id: 62 now its 1, also there is no usertype, password says "migrated" and there are no register dates or lastvisit dates

Yes, that is what will happen if you deleted everyone from your mos_users table.

Do you have a backup of your mos_users table from before you deleted it?

[deejayh]

Yes I have - done one thing right!

[Orstio]

Restore the backup of the mos_users table.

Once you do that, you'll find that the users you deleted in SMF will now still exist in Mambo.  You'll have no way to delete those now except for finding each one individually.

But, at least you and your users will once again have access to Mambo.

[deejayh]

Sorted it Orstio. Thanks!

One other question.

If I remove the bridge and ancillary stuff, remove having a login for Mambo and move the forum to a subdirectory, would I be able to link certain information such as latest posts and discuss bot "discuss in forum" links?

Thanks,
Dave

[Orstio]

You can have SSI-generated things like the latest posts quite easily.  You wouldn't be able to make the discussbot work, but if you want to do the work of linking each article to a topic, that's a definite possibility.

[deejayh]

Thanks for that. Just may do it as I don't need anyone having access to Mambo!

Going back to my original problem, as I had backed up my smf_members database, if I copy this back to the original, and then delete / ptune everyone as you said earlier, how would this delete the corrosponding users in Mambo? As when I did it before, and checked the mos_users database (quickly), I thought they were the same as before!

Thanks again Orstio youre a star
Dave

[Orstio]

Going back to my original problem, as I had backed up my smf_members database, if I copy this back to the original, and then delete / ptune everyone as you said earlier, how would this delete the corrosponding users in Mambo? As when I did it before, and checked the mos_users database (quickly), I thought they were the same as before!

Yes, that should work.