adding fields to my_account module, and to the db?

Worker Joined: Jun 06, 2006 Posts: 105

Hello,

First, not sure if this is the correct place to ask this...

How do I add fields to the my_account module, and to the database to records/retreive those fields?

the field currently, is a date. I would like it to display it, in my_account
module, but only be updateable through a db call.

I am new to programming in php (and nuke), and so I'm attempting to
learn how to do this, but it's honestly the database side of things that I'm
at a loss for.

any help here is hugely apreciated,

spyrule

Posted: Sat Nov 25, 2006 12:04 pm

Moved to Modules forum from RN 2.02.02

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

You might want to look into CNB Your Account, which allows you add additional fields to the Your Account module, and, if desired, you can make them required for registration.

Posted: Sat Nov 25, 2006 2:52 pm

yeah,

I've looked at cnb_youraccount, and it's ok. but it's far from what I need. I don't want the fields to be manually update-able. Plus incorporating cnb into raven, is a pita.

no, all I'm looking for is the code to add a the following fields to each users field.

the info needed to be added would be :

date type fields:
user_lastlogin
user_previouslogin1
user_previouslogin2
user_previouslogin3
user_onleavestart
user_onleaveend

boolean type fields:
user_ismia
user_ismia_notified
user_isawol
user_isawol_notified
user_removed
user_onleave
user_isquit

text type fields:
user_onleavereason
user_corporation
user_ceo
user_jobtitle

With these fields getting attached to each website user, I can populate and update
all the desired info based on a script I run once per week. But the problem I am
having (i'm a noob) at the start of this project, is how to / where to add these
fields to my existing phpnuke mysql database. And then also what is the
general command to fill those fields. (I'm VERY newb... Smile

)

ANY help is hugely apreciated.

spyrule.

registered · Posted: Sat Nov 25, 2006 6:26 pm

You can do all the database stuff directly from phpMyAdmin. It would be tedious to do all the updating by hand, so look up some good PHP/MySQL tutorials on how to write your own scripts to update

Posted: Sat Nov 25, 2006 11:40 pm

thanks evaders99,

but unfortunately my host is godaddy.com who has a very limited feature phpmyadmin version. So manual updates are tedious. But my big problem, is that I don't have a clue where to create the fields needed. I don't even know what tables to create this under so that each setting gets tracked with each user.

could someone just give me a step-by-step instructions one time on how to add ONE record, so that I know what direction to look. I'm seriously in the dark here.

thanks in advance,

spyrule

Posted: Mon Nov 27, 2006 7:02 pm

ok, well I've been able to figure out how to add the above listed fields to the database.

Now I have been _trying_ to figure out how to get them, and add them to the my_account module.

Is their a way to add something to the my_account module, that would act as an include instead of completely modifying the my_account module. The main reason is so that I could offer this change to public, if anybody wants it.

Thanks in advance guys,

spyrule

Posted: Mon Nov 27, 2006 7:15 pm

Sure its possible, but your still talking a lot of code, now if you like, Im sure that a few of us would help to develope this, but to save you some time, Search for phpformgenerator, then alter the code once you have made it as you would like it.