There is no simple way. This is roughly how I would proceed:
1: Make a full backup of your existing website
2: Install it locally
3: Identify all modifications to your community builder extension by comparing it to a fresh 1.9.1
4: Update community builder
5: Apply all modifications again. Probably you can't apply them 1:1
6: Replace your online ...
What I recommend you do is take a backup of your Joomla 2.5 site and on that backup, perform the migrations to Joomla 3.x.
Then install the latest version of Community Builder.
Once done, copy over the tables you require to your newly built Joomla 3.x site.
Note: This answer has been updated a few times.
As answer to your comments:
Hardly there will be so many real humans that will do nothing else than creating a fake account to your site every day, so most likely these are bots.
In addition, I don't think there is a way you can completely stop a real human from using something offered on your site.
There may or may not be addition issues with your attempt, but I can tell at first glance that you are not executing your UPDATE query.
$db = JFactory::getDBO();
$user = JFactory::getUser();
$db->setQuery("UPDATE #__comprofiler SET cb_skills = " . $db->q($...
If we're not talking about many values that you need to translate, then you can have a file called gr_GR.plg_content_your_plugin.ini in your languages/gr_GR folder (assuming the language that you want to translate is Greek). In that file, you can have something like:
VALUE_GEORGE=George in Greek
VALUE_JOHN=John in Greek
And then, when you want to print ...
I'm not familiar with CB autoaction, but it looks like you have some additional closing parenthesis and semicolons after each set of VALUES:
NULL , '[name]', '[username]', '[email]', '[cb:userdata field="password" /]', '[block]', '[sendEmail]', '[registerDate]', '[lastvisitDate]', '[activation]', '[params]', '[lastResetTime]', '[resetCount]', '[...
If I remember correctly there should be 2 things to check when using CB for your registration.
verify that the allow registration setting in CB is set to disregard the COM_USERS setting. This allows users to register and the COM_USERS methods to fire even if Joomla user registration is turned off.
look at the users plugin and verify that the setting to not ...
Username and Email are different fields. According to my experience, you can customize your site to have Email also in username field and keep a consistent interface to avoid confussions:
Authentication - EMail plugin, to access with the email http://extensions.joomla.org/extension/authentication-email
Create language overrides, to replace the username word:...
Thanks to Lodder's answer and some help from the french Joomla forum, this is what i’ve done :
Make a backup of the Joomla 2.5
Install the backup
Upgrade to Joomla 3.x
Copy the requrired tables :
_comprofiler_xxx (All the table community builder)
That's it !