Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules
Author Message
spyrule
Worker
Worker



Joined: Jun 06, 2006
Posts: 105

PostPosted: Sat Nov 25, 2006 11:33 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Sat Nov 25, 2006 12:04 pm Reply with quote

Moved to Modules forum from RN 2.02.02
 
View user's profile Send private message Send e-mail
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6432

PostPosted: Sat Nov 25, 2006 1:57 pm Reply with quote

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.

_________________
I search, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
spyrule







PostPosted: Sat Nov 25, 2006 2:52 pm Reply with quote

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.
 
evaders99
Former Moderator in Good Standing



Joined: Apr 30, 2004
Posts: 3221

PostPosted: Sat Nov 25, 2006 6:26 pm Reply with quote

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

_________________
- Star Wars Rebellion Network -

Need help? Nuke Patched Core, Coding Services, Webmaster Services 
View user's profile Send private message Visit poster's website
spyrule







PostPosted: Sat Nov 25, 2006 11:40 pm Reply with quote

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
 
spyrule







PostPosted: Mon Nov 27, 2006 7:02 pm Reply with quote

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
 
gregexp
The Mouse Is Extension Of Arm



Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Mon Nov 27, 2006 7:15 pm Reply with quote

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.

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©