Modifying Username on CMS

[Spoderman]

I'm currently trying stuff and I need to be able to edit Username on the CMS/account page.
I've tried several different ways but none seem to work, I lack in php knowledge therefore I wouldn't know how to do it via PHP.

If someone could help me out here, it would be great

Cheers lads.

 

[Zodiak]

Edit username? you mean edit your own username or a staff editing someone elses username?
If your referring to a user changing there name via account settings:
Top of the page add:

<?php

$username = mysql_real_escape_string($_POST['username']);

if($_POST['update']) {
$checkuser = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."'");

if(mysql_num_rows($checkuser) == 1)
{
$error = "Username taken";
}
else
{
mysql_query("UPDATE `users` SET `username` = ".$username."'' WHERE `username` = '".$_SESSION['user']['username']."'");
}
}

?>

And the form:

<form method="post">
<input type="text" name="username" placeholder="username" value="<?php echo $_SESSION['user']['username']; ?>">
<input type="submit" name="update" value="Update Account">
</form

Not the most effecient way to code it but it should work, unless I've made a mistake which I may have considering I'm half asleep and rushed on it.
Note: This won't work if your php is updated, as mysql was deprecated.

 

[Zippy]

Also be aware that if your CMS uses the username as a salt for the password, the user won't be able to login after changing their username using the above form.

 

[Zodiak]

Also be aware that if your CMS uses the username as a salt for the password, the user won't be able to login after changing their username using the above form.

Was half asleep aha, wouldn't recommend the way I did that tbh.

 

[Spoderman]

So I'm guessing there is no suitable way to change your username on the CMS?

 

[Zodiak]

So I'm guessing there is no suitable way to change your username on the CMS?

There is and it's quite easy actually.

 

[Mexicano]

There is and it's quite easy actually.

Would you mind telling us that "suitable way"?

 

[Zodiak]

Would you mind telling us that "suitable way"?

Assuming you're using rev the most suitable way of doing it would be by coding it into revs core/forms or wherever the form shit for rev is, haven't edited rev in a while.