Question Importing Points

[Satix]

How do I import points from ibEconomy? I exported the point values and the IDs of the members they belong to via the SQL database - is there a way to import these in?

Thanks for your time!

EDIT: Not sure why this put it in vBulletin - I'm near certain I picked the XenForo one when creating the ticket.

 

[Fillip H.]

How do I import points from ibEconomy? I exported the point values and the IDs of the members they belong to via the SQL database - is there a way to import these in?

If that mod had a points column in the user table, you can simply configure the Credits currency to use the same points column and it will work.

EDIT: Not sure why this put it in vBulletin - I'm near certain I picked the XenForo one when creating the ticket.

There is no separate XF forum at this time, except for an old forum that is no longer really used

 

[Satix]

Thank you for the response! Unfortunately, it's on a different database. Trying to figure out how to port it over.

It's also in the format of '0.00' for values of no points instead of just 0 like the Credits app is. Will that cause any issues?

Thanks again!

 

[Fillip H.]

Oh, that significantly complicates things. Do the user IDs match across both DBs?

The number formatting won't be an issue since the Credits mod allows decimals in the points columns.

 

[Satix]

I got it figured out! The user IDs did match, so what I did was run this SQL query (just in case anyone else has th issue in the future):

update database1.xf_user, database2._pfields_content
set database1.xf_user.dbtech_credits_credits = database2._pfields_content.eco_points
where database1.xf_user.user_id = database2._pfields_content.member_id;

Database 1 = Database that the points are being transferred into
Database 2 = Database that the points are being transferred from
_pfields_content = Table where ibEconomy stores its point values

I included which table ibEconomy uses specifically because the location of the points was hard to find, and it may help make the process for upgrading (and it is a huge upgrade) from ibEconomy on IPB to your credits & shop applications on Xenforo.

Thanks again for your time - really happy with your apps so far.

 

[DragonByte Technologies]

Hello Satix,

This ticket has now been closed with the status Answered.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!