help

[bladewolf2010]

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??

[Renkia]

I Think its.

[mysql]ALTER TABLE `users ` ADD `sig` INT(11)[/mysql]

Etcc, on the line as that mate.

[Djkanna]

[mysql]ALTER TABLE `users` ADD `sig` TEXT NOT NULL[/mysql]

[Zero-Affect]

[mysql]ALTER TABLE `users` ADD `sig` varchar(150) NOT NULL DEFAULT '';[/mysql]

[AlabamaHit]

Shouldn't the sql had came with it?

[Djkanna]

[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