bladewolf2010 Posted May 30, 2010 Share Posted May 30, 2010 function ProfileSig() { global $ir, $db; if (isset($_POST['NewPSig'])) { $db->query(sprintf("UPDATE `users` SET `sig`='%s' WHERE `userid`='%d'", NoXSS($_POST['NewPSig']), $ir['userid'])); echo 'Profile Sig Updated'; } else { echo '<h3>Profile Sig</h3> <form action="preferences.php?act=ProfileSig" method="post">'; echo 'Signature (you may use BBcode): '; echo sprintf("<textarea rows='10' cols='50' name='NewPSig'>%s</textarea> ", $ir['sig']); echo '<input type="submit" value="Change Profile Sig" /> </form>'; } } Can anyone make the sql for this?? Quote Link to comment Share on other sites More sharing options...
Renkia Posted May 30, 2010 Share Posted May 30, 2010 I Think its. [mysql]ALTER TABLE `users ` ADD `sig` INT(11)[/mysql] Etcc, on the line as that mate. Quote Link to comment Share on other sites More sharing options...
Djkanna Posted June 1, 2010 Share Posted June 1, 2010 [mysql]ALTER TABLE `users` ADD `sig` TEXT NOT NULL[/mysql] Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted June 1, 2010 Share Posted June 1, 2010 [mysql]ALTER TABLE `users` ADD `sig` varchar(150) NOT NULL DEFAULT '';[/mysql] Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted June 1, 2010 Share Posted June 1, 2010 Shouldn't the sql had came with it? Quote Link to comment Share on other sites More sharing options...
Djkanna Posted June 1, 2010 Share Posted June 1, 2010 [mysql]ALTER TABLE `users` ADD `sig` varchar(150) NOT NULL DEFAULT '';[/mysql] Oh okay I thought text would have been better (so people can have images and crap in their signature XD) Moved to Modification Support Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.