Getting Fields from a separate database.

[thedjtrollin]

Hey Guys!

I'm not really a Website Developer so I am a bit confused. Anyone who can help I will love!

Here we go;

Basically I have a Database called Core in this it has a Table called users. This users has a Field called Coins. I basically need to get the Data from the Coins field and put it

in Server Coins field here.

Problem is I have no idea how!

Thanks in advanced<3

 

[Paul B]

That's going to require custom development.
You say you're not a developer so you would be better off contracting someone to do this for you.

I would recommend adding a new column to the xf_user table and storing the data there, which would then make it more easily available in the XenForo code and templates.
You can pull the data from your "core" database either as a one off or periodically.

 

[thedjtrollin]

That's going to require custom development.
You say you're not a developer so you would be better off contracting someone to do this for you.

I would recommend adding a new column to the xf_user table and storing the data there, which would then make it more easily available in the XenForo code and templates.
You can pull the data from your "core" database either as a one off or periodically.

Hmmm I suppose I could use a MySQL event every Hour to do that and update the Coins from Core to xf_user.

How would I retrieve Coins from the XF_users thou?

*Like to point out I am a Java Developer not a Web Developer* So I know roughly whats going on xD

 

[Paul B]

You could start by dumping the $visitor record ({xen:helper dump, $visitor}) in that template (forum_list).

If the query grabs all fields from the table then by adding your column to it, it would automatically be included in the $visitor record.
Then you can just edit the template to add it using $visitor.coins.

 

[Zanthor]

I just wrote a mod today to run a cron that updates member status based on another DB.

http://xenforo.com/community/threads/updating-user-group-membership-question.70163/

Attached is my PHP file that I used to do this. Should be pretty easy to follow that tutorial and piece it together.