SMF Help - MySQL?

[Ellie]

Heya. I've merged my databases to that my game uses the same database as my forum. This way, I can do things on the forum that will directly affect the game, and vice versa; and there only needs to be one account to log in to both the game and the forums.

So I've been screwing with the Profile page. This is what I have come up with (shouldn't need to login to view this):

http://forums.vengeance-rpg.com/index.p ... rofile;u=1

Basically I've moved everything around, added a referral system, and made a (temporarily shitty looking) mini profile for my game.

Trouble is, at the moment the numbers are nothing. They are just typed in, as examples. I'm not sure how to actually get that data; it's in:

Database > smf_2members => vType, vGroup, vOnline, vLevel, vGold



I also have, in the "Account Settings" tab, some boxes to fill in that should update the database when the whole thing is sent off. I don't know how to do this either, unfortunately

Spoiler

http://img.photobucket.com/albums/v108/dudemaster/profileterolles.png[/img]

Don't s'pose anyone has any experience with SMF?

 

[___]

If you want to upgrade to SMF 2.0, check out this tutorial, it should give you everything you need to know to get custom fields set up.
If you want to stick to 1.1.2 you're going to have to add those fields to your members table in the database, then make sure they're being loaded in the various functions that load and display member data, I don't remember how SMF handles this off the top of my head but I do know it's not object-oriented and thus it's a trashy entangled mess : / I know you'll need to update your templates, it looks like you have that covered already, but you'll also need to integrate it elsewhere in the sources, particularly updateMemberData in Subs.php. Kind of a pain in the ass overall, now that I'm looking at the SMF code. I forgot what a mess it is