MyBB Community Forums

Full Version: Connect to another MySQL database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Greetings to all, I have a question about how I could connect my forum to another database, the situation is as follows, I have an Online server (SA: MP) which I use a database to store the information of the users, where each user has a skin / avatar and I would like the forum to use the same avatar that they are using within the video game, I have the images in a folder ready to be used as an avatar in the forum, but I do not have the slightest idea how to get the skin data and force the user (in the forum) to use that.

The database of my Server is called "americanrp", the table "usuarios" and the column that stores the skin "Skin"

I'm using version 1.8.14 of MyBB

Link of my forum.

I'd appreciate your help!

Anyone?
Anyone?
There is an excellent plugin I use, RandomAvatar: https://community.mybb.com/mods.php?action=view&pid=173

You can set this to randomly choose from your folder of avatars (you set the folder location). When a new user signs up, it will randomly assign an avatar to them. Perhaps you can use this in combination with Avatar Gallery, which may be of some use: https://community.mybb.com/mods.php?action=view&pid=26

Though old users will have to manually set the avatar (unless you go through and set their avatar for them in Admin.)
(2018-01-13, 02:50 PM)DrXotick Wrote: [ -> ]There is an excellent plugin I use, RandomAvatar: https://community.mybb.com/mods.php?action=view&pid=173

You can set this to randomly choose from your folder of avatars (you set the folder location). When a new user signs up, it will randomly assign an avatar to them. Perhaps you can use this in combination with Avatar Gallery, which may be of some use: https://community.mybb.com/mods.php?action=view&pid=26

Though old users will have to manually set the avatar (unless you go through and set their avatar for them in Admin.)

No bro, i want to do a query on another database, the database that i use for the forum, is called "foro" and where i want to do a query is called "americanrp" how can i do that?
You would need to either write a plugin to do that, or ask somebody else to write one for you.