Hello
We have a custom php website where we accept user registration. Now i want to migrate those users to phpfox 4

Can you tell me what the things we need to migrate from old user table to phpfox 4 tables? like user email, passwords or name

migrating to user table is only enough or we have to migrate users other details to other phpfox 4 tables too?

Please guide

Regards
Gaurav

Be the first person to like this.
JohnJr

The best way to understand what is needed is to set up a development site with a fresh install.  Then you will go to the lists of the table I will provide below and copy the information into an excel spreadsheet with the name of the fields and the data that was put into those fields.  Then you will add one user.  Then go back to those tables and add the new info to the excel spreadsheet...do it for a third user as well.  By doing this you will see a pattern and what data is needed for a new user to be correctly entered into phpfox.  Here are the tables affected and they all need to be used so there are no issues later on.  Using excel CSV files is a clean way to import users because if a specific field/column is all zeros you can put one zero in the box and drag down to create hundreds or thousands of rows in minutes if the default data for that field is zero.  In most of the tables below the data is the same for all the users except the id number etc but it is still needed.

phpfox_user
phpfox_user_activity
phpfox_user_count
phpfox_user_delete
phpfox_user_field
phpfox_user_space
Be the first person to like this.

can u give me an example excel csv please

Be the first person to like this.
JohnJr

Not sure how accurate it is anymore as it was done five years ago.

phpfox_user    
user_id increase by one  
profile_page_id increase by one  
server_id  
user_group_id 2 membership status
status_id  
view_id 7 Looks like 0 is approved for users, 7 is approved for businesses and 1 is pending approval.
user_name url ending or profile or business name
full_name name of business  
password hash thing  
password_salt hash thing  
email    
gender  
birthday    
birthday_search  
country_iso    
language_id    
style_id  
time_zone    
dst_check  
joined 1377108547  
last_login  
last_activity  
user_image 11%s.jpg (increase by one)
hide_tip  
status    
footer_bar  
invite_user_id  
im_beep  
im_hide  
is_invisible  
total_spam  
last_ip_address    
feed_sort  
Be the first person to like this.
JohnJr

To see how you need to import the excel/csv file is to export the table to excel/csv after you have entered the three users for each table.  Then you see what goes in each row...then it is a copy and paste of your old data into the correct columns and then import it through phpmyadmin.  If you don't know how to use that you might have to hire someone or their might be an app in the store but not sure how good it is.

all is set but we are facing issue with password conversion only

once the password work fine but when logout and login again then do nt accept pwd

anyone can help us to tell how to convert normal password to phpfox v4 password? anyhow phpfox also converting normal text to password and storing in database?

Kindly help us. this is the thing only left

Be the first person to like this.