Sign up date
Run this in PHPmyADMINCode
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.
Posted on Friday 11th July 2008 at 08:41 PM
Woot I got it.
Posted on Friday 11th July 2008 at 08:24 PM
What happened its blank!
http://sodadome.com/members.php?user=UrbanTwitch
http://sodadome.com/members.php?user=UrbanTwitch
Posted on Wednesday 23rd April 2008 at 06:25 AM
Alright. Your problem is. There is 2 of the
Edit BOTH
One of them is for if you have Email activation. the other is for if you dont.
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
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
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
Its not in my config.php
Posted on Monday 24th December 2007 at 09:38 PM
Thats it, good job Jozo!
Posted on Monday 24th December 2007 at 05:34 PM
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
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
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
Yeah i'll request change now. thanks. LOl forgot to mention
Posted on Wednesday 6th June 2007 at 09:33 PM
Btw, you edit the files in "register.php"