Mods can edit username, useremail, homepage and signature

That's my first hack.

The hack allows your mods to edit username, useremail, homepage and signature only from registered users via modCP.

Changed files: user.php in mod directory

All further instructions can be found in the attachment.

[Chris M]

Thanks...

I was thinking about this earlier, and I thought of something that would be good to add to it, but I dont know how...

At ThePhora, we have a big craze on at the moment of Glowing Custom Titles - At the moment, only Admins can do it via the Admin CP, but I was wondering if there was a way to allow Mods to do it...

If you wouldnt mind...

I think it would be a great Hack to add, and I am sure that some people would like the idea of Custom Glowing Titles...They would need to be able to add HTML to it, so if that is not too much of a problem...

<b><table style="filter:glow(color=yourcolour, strength=3,400)"><font color=white>Your title</font></table></b>

Satan

[Sandron]

First I didn't get what you want, but I think you want your mods to be able to change usertitles. In this case you have to add this code:

Under

PHP Code:

maketableheader("Edit User - $user[username] (userid: $user[userid])"); 


add

PHP Code:

makeinputcode("User Title","usertitle",$user[usertitle]);
      makeyesnocode("Use Custom Title","customtitle",$user[customtitle]); 


and replace

PHP Code:

$DB_site->query("UPDATE user SET email='".addslashes(htmlspecialchars($email))."',homepage='".addslashes(htmlspecialchars($homepage))."',signature='".addslashes($signature)."' WHERE userid=$userid"); 


with

PHP Code:

$DB_site->query("UPDATE user SET usertitle='".addslashes($usertitle)."',customtitle=$customtitle,email='".addslashes(htmlspecialchars($email))."',homepage='".addslashes(htmlspecialchars($homepage))."',signature='".addslashes($signature)."' WHERE userid=$userid"); 


Try it out and tell me, if it works for your mods

[Chris M]

I would love to...

Big Problem...

I am getting this error when I try and view the Database -

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydateastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=13
mysql error: You have an error in your SQL syntax near ') AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
' at line 1

mysql error number: 1064

Date: Tuesday 16th of April 2002 02:39:41 PM
Script: http://www.thephora.com/admin/user.p...edit&userid=13
Referer: http://www.thephora.com/admin/

Any clues as to what it might be?

Satan

[Sandron]

Hm, I checked it out on my forum and there the code I provided works fine.
I'm also wondering, why the error comes up in your admin directory, the code doesn't change anything there.

I hope you have a backup, because I can't imagine where the error comes from.

Where did you the changes? Perhaps you edited in your admin directory and not in the mod directory? Because this piece of code doesn't exist in my edit code for mods, but it exists in the edit code for admins.

[Chris M]

Whatever it was, it sorted itself out...

I think I made a tiny syntax error earlier in the day...

I work on 2 machines, and the one I worked on was the one that caused the problem...I think I hit a key and didnt realise it...

Luckily, I had made the adjustments in the index.php file on my other computer already, so I uploaded that one after adding more to it, and it corrected the problem...

I shall be installing this hack within the next few days...I only clicked "install" when I did, so I can identify it when I visit the Beta Hacks forum once more...

Thanks for the Hack - This is a Great hack...You should be proud...

Satan

[KuraFire]

Does this work on 2.2.5 properly?

[Chris M]

Yes it does...

Satan

[Ian]

Thos hack isn't working for me... When I click the "edit" link I get a blank page... Here's the contents of it:

<html><head>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<meta http-equiv="MSThemeCompatible" content="Yes">
<link rel="stylesheet" href="../cp.css">
</head>
<body leftmargin="10" topmargin="10" marginwidth="10" marginheight="10">
</BODY></HTML>

I double checked to make sure I applied the hack right and everything looks good... I'm using version 2.2.5 BTW. Any idea what's wrong?

[comprichie]

Hi, to all
I am new on this forum, and I want to say that this is a great board.
I have a question that is:
I have vb 2.2.6. and I want to use the hack so that mods can edit users.
I found a script for 2.2.2, but this one is not working with me.
When i want to edit a user, it says that it can not find the page.

Can I change the script, so yes how?
I dont want to give my mods admin.
Is there an option, or a new script?

I hope that here is someone who can help me.

Thanx,

[Palmer ofShinra]

I just hope you guys realize that an unscrupulous mod can use this to hijack any account by setting up a dummy email, then editing a users email to their own, and then using "lost password"