after you do that
you have to add one more thing to your data base
Code:
ALTER TABLE `users` ADD `mood` int(10) NOT NULL
my.php go to
Code:
tr("Stylesheet", "",1);
add under
Code:
$mood = "n";
$mood_r = mysql_query("SELECT id,name FROM mood ORDER BY name") or die;
while ($mood_a = mysql_fetch_array($mood_r))
$mood .= "n";
print("
usersdetails.php now you must decide where you'd like to show the user mood (i have it under avatar)
if you'd like to put this unde avatar go to
Code:
if ($user["avatar"])
print("
Avatar
\n");
and add this
Code:
$mood_r = mysql_query("SELECT moodpic FROM mood WHERE id=$user[mood] LIMIT 1") or sqlerr();
if (mysql_num_rows($mood_r) == 1)
{
$mood_a = mysql_fetch_assoc($mood_r);
$mood = "".format_comment($mood_a["moodpic"])."";
}
if ($user["mood"] > 0)
print("
mood
$mood
\n");
for the image I use smiles
if you'd like to change the images with other smile you must go to your data base and modify moodipc
if you don't want to show smiles and want to put other images you must modify moodipc and put your image name and extension (you must have the image in your pic dir) and you must change
Code:
$mood = "".format_comment($mood_a["moodpic"])."";
to
Code:
$mood = "mood_a["moodpic"] style='padding:2px'>";
hope you like this and find it useful and easy to install :)