Well, i first saw this on a game and someone wanted me to make it, so i did, well with a bit of help from lostone on the changing of it, so hear it is.
ALTER TABLE `users` ADD `quote` varchar(255) NOT NULL;
add this to php myadmin
now wherever you want the quote to show add:
Quote: {$r['quote']}
Now in prefrences add this to functions
case 'uq':
user_quote();
break;
add the link now
echo '[url="preferences.php?action=uq"]Quote Change[/url]';
add this before endpage
function user_quote()
{
global $c, $ir;
if($_POST['quote'])
{
$q = mysql_real_escape_string($_POST['quote']);
if(strlen($q) > 255)
{
echo 'Quotes can only have upto 255 characters';
echo '
';
echo '[url="preferences.php?action=uq"]Back[/url]';
}
else
{
mysql_query("UPDATE `users` SET `quote` = '$q' WHERE `userid` = " . $ir['userid']);
}
}
else
{
echo '<h3>Quote Change</h3>';
echo '<form action="preferences.php?action=uq' method='post'>';
echo 'Enter quote below (<font color="red">255 character limit</font>)
';
echo '<input type="text" name="quote">' . $ir['quote'] . '</textarea>';
echo '
';
echo '<input type="submit" value="Update">';
echo '</form>';
}
}
Their it should all be in working order if you need any help pm me or msn me