Forgot Password / Register
Site Statistics
Total Members: 509
Total Tutorials: 242
Newsest User: Lestop
Todays Unique Hits: 159
0 Users 2 Guests Online

Sign up date

Run this in PHPmyADMIN
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
1
2
$date = date("g:i.sa - d\\t\h F Y");


Change
PHP Code
1
2
$adduser = mysql_query("INSERT INTO `members` (`username`, `password`, `email`) VALUES('$username','$password','$email')");


To
PHP Code
1
2
$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.
SkillMaster
Views:
1790
Rating:
Posted on Friday 11th July 2008 at 08:41 PM
UrbanTwitch
UrbanTwitch
Woot I got it.
Posted on Friday 11th July 2008 at 08:24 PM
UrbanTwitch
UrbanTwitch
What happened its blank!

http://sodadome.com/members.php?user=UrbanTwitch
Posted on Wednesday 23rd April 2008 at 06:25 AM
Stupidkid
Stupidkid
Alright. Your problem is. There is 2 of the

PHP Code
1
$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 8th April 2008 at 05:30 AM
UrbanTwitch
UrbanTwitch
I got the register.php part, as well as the mySQL and config... but still its blank!
Posted on Tuesday 8th April 2008 at 02:12 AM
UrbanTwitch
UrbanTwitch
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 24th December 2007 at 09:38 PM
DanielXP
DanielXP
Thats it, good job Jozo!
Posted on Monday 24th December 2007 at 05:34 PM
Jozo
Jozo
Ahhh, im starting to under stand this :D

Go to members.php

Find

Age: $user[age]

Add <br> to it

Age: $user[age]<br>

Then add

Sign up date: $user[signupdate]

under neath it.

It should look like this:


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

:D
Posted on Monday 24th December 2007 at 05:30 PM
Jozo
Jozo
Nice.. But how do you make it so that it gets displayed on your members page?
Posted on Thursday 7th June 2007 at 08:54 AM
SkillMaster
SkillMaster
Yeah i'll request change now. thanks. LOl forgot to mention
Posted on Wednesday 6th June 2007 at 09:33 PM
Diablosblizz
Diablosblizz
Btw, you edit the files in "register.php"