• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Getting Fields from a separate database.

#1
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
 

Brogan

XenForo moderator
Staff member
#2
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.
 
#3
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
 

Brogan

XenForo moderator
Staff member
#4
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.