Sign up date

Name: Sign up date
Rating: 5 (1 reviews)
Author: SkillMaster

Run this in PHPmyADMIN

PHP Code

ALTER TABLE `members` ADD `signupdate` VARCHAR(225) NOT NULL DEFAULT '';

Add this to the top of your page just under include "config.php";

PHP Code

$date = date("g:i.sa - d\\t\h F Y");

Change

PHP Code

$adduser = mysql_query("INSERT INTO `members` (`username`, `password`, `email`) VALUES('$username','$password','$email')");

PHP Code

$adduser = mysql_query("INSERT INTO `members` (`username`, `password`, `email`, `signupdate`) VALUES('$username','$password','$email','$date')");

Basically what this does is create a new database row and add a record to it on signup.

Date code was created from MOD-Shadows PHP tutorial found HERE if you would like to edit it.

Forum add-on to usersystem will be out very soon.

Author:

SkillMaster

Views:

2,816

Rating:

Posted on Friday 11^th July 2008 at 08:41 PM

UrbanTwitch
UrbanTwitch's Avatar

Woot I got it.

Posted on Friday 11^th July 2008 at 08:24 PM

UrbanTwitch
UrbanTwitch's Avatar

What happened its blank!

https://sodadome.com/members.php?user=UrbanTwitch

Posted on Wednesday 23^rd April 2008 at 06:25 AM

Stupidkid

Alright. Your problem is. There is 2 of the

PHP Code

$adduser = mysql_query("INSERT INTO `members` (`username`, `password`, `email`) VALUES('$username','$password','$email')");

Edit BOTH

One of them is for if you have Email activation. the other is for if you dont.

Posted on Tuesday 8^th April 2008 at 05:30 AM

UrbanTwitch
UrbanTwitch's Avatar

I got the register.php part, as well as the mySQL and config... but still its blank!

Posted on Tuesday 8^th April 2008 at 02:12 AM

UrbanTwitch
UrbanTwitch's Avatar

Where do you put $adduser = mysql_query("INSERT INTO `members` (`username`, `password`, `email`, `signupdate`) VALUES('$username','$password','$email','$date')");?

Its not in my config.php

Posted on Monday 24^th December 2007 at 09:38 PM

DanielXP

Thats it, good job Jozo!

Posted on Monday 24^th December 2007 at 05:34 PM

Jozo

Ahhh, im starting to under stand this :D

Go to members.php

Find

Age: $user[age]

Add to it

Age: $user[age] 

Then add

Sign up date: $user[signupdate]

under neath it.

It should look like this:

$user[username]'s Profile 
Email: $user[email] 
Location: $user[location] 
Sex: $user[sex] 
Age: $user[age] 
Sign up date: $user[signupdate]
</fieldset>";

:D

Posted on Monday 24^th December 2007 at 05:30 PM

Jozo

Nice.. But how do you make it so that it gets displayed on your members page?

Posted on Thursday 7^th June 2007 at 08:54 AM

SkillMaster
SkillMaster's Avatar

Yeah i'll request change now. thanks. LOl forgot to mention

Posted on Wednesday 6^th June 2007 at 09:33 PM

Diablosblizz
Diablosblizz's Avatar

Btw, you edit the files in "register.php"