Edit Profiles From Mod Cp

Ok..... Someone requested this
Edit Profiles From Mod CP

What This hack does: Let Mods Who You Give The Permission To Edit Profiles From The Mod Cp

If you dont give A Mod the permission they wont see the option to edit the user profile

If you do then the mod will see the option to edit the profile

Didnt have the time to add the unban option i have to go somewhere ......... But i tested this on my forums and it works perfectly ..... any problems let me know

By the way this is my second hack

[Stryker]

Hmmm, when I go to change a mod's permission settings I get the following MySQL error...

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: UPDATE moderator SET forumid='3',userid='4',newpostemail='0',newthreade mail='0',caneditposts='1',cand eleteposts='1',canviewips='1',canmanagethreads='1' ,canopenclose='1',caneditthrea ds='1',caneditstyles='',canbanusers='0',canviewpro file='0',caneditprofile=1',can announce='1',canmassmove='0',canmassprune='0',canm oderateposts='1',canmoderateat tachments='1' WHERE moderatorid='23'
mysql error: You have an error in your SQL syntax near '',canannounce='1',canmassmove='0',canmassprune='0 ',canmoderateposts='1',canmode r' at line 1

mysql error number: 1064

Any idea how to fix that?

[Lesane]

there is one ' missing

PHP Code:

caneditprofile=1',canannounce='1', 


has 2 be:

PHP Code:

caneditprofile='1',canannounce='1', 


[Stryker]

Thanks for the info, but I can't seem to find that error in the edited files anywhere. Am I completely stupid or am I just looking in the wrong place?

By the way Black, I think it would be much easier if the stuff you had to edit was just listed in a simple text file rather than as part of the installation file - it just makes it easier to go back and check the code after you've installed it.

[Lesane]

Change this in admin/forum.php:

PHP Code:

$DB_site->query("UPDATE moderator SET forumid='$parentid',userid='$userid',newpostemail='$newpostemail',newthreademail='$newthreademail',caneditposts='$caneditposts',candeleteposts='$candeleteposts',canviewips='$canviewips',canmanagethreads='$canmanagethreads',canopenclose='$canopenclose',caneditthreads='$caneditthreads',caneditstyles='$caneditstyles',canbanusers='$canbanusers',canviewprofile='$canviewprofile',caneditprofile=$caneditprofile',canannounce='$canannounce',canmassmove='$canmassmove',canmassprune='$canmassprune',canmoderateposts='$canmoderateposts',canmoderateattachments='$canmoderateattachments' WHERE moderatorid='$moderatorid'"); 


to this:

PHP Code:

$DB_site->query("UPDATE moderator SET forumid='$parentid',userid='$userid',newpostemail='$newpostemail',newthreademail='$newthreademail',caneditposts='$caneditposts',candeleteposts='$candeleteposts',canviewips='$canviewips',canmanagethreads='$canmanagethreads',canopenclose='$canopenclose',caneditthreads='$caneditthreads',caneditstyles='$caneditstyles',canbanusers='$canbanusers',canviewprofile='$canviewprofile',caneditprofile='$caneditprofile',canannounce='$canannounce',canmassmove='$canmassmove',canmassprune='$canmassprune',canmoderateposts='$canmoderateposts',canmoderateattachments='$canmoderateattachments' WHERE moderatorid='$moderatorid'"); 


[Stryker]

Well I'm no longer getting MySQL errors, thanks, but my mods have no way of submitting the changes to member's profiles.

What does the options which allows mods to see "member's whole profile" do exactly? And has that got anything to do with not being able to edit anything?

[Chrysalis]

Ive installed the hack but so far not gave any mods rights to edit profiles, as I want to know if they can edit/add/remove admins.

[Palmer ofShinra]

By my quick perusal of the code, it looks like they can indeed demote admins...

If you want to test it... make two dummy accounts.

Make one an admin, and one a mod with edit rights...

Then edit the dummy admin with the dummy mod. See if it works.

Basically... the part to look for is

usergroupid='$usergroupid',

If you delete that... then the edit display will still come up with the pulldown... but changing it won't do anything because it's not in the update query anymore.

I made custom code for my own Mod Edit... and replaced the Usergroup selector with a chooser that was ahrdcoded to the few groups I wanted them able to edit...

AND disabled it if the person was a mod/supermod/admin.

[Chrysalis]

went to try what you said and got this when giving the test mod edit profile abilities hehe.

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: UPDATE moderator SET forumid='8',userid='2380',newpostemail='0',newthre ademail='0',caneditposts='1',c andeleteposts='1',canviewips='1',canmanagethreads= '1',canopenclose='1',caneditth reads='1',caneditstyles='',canbanusers='0',canview profile='0',caneditprofile=0', canannounce='1',canmassmove='0',canmassprune='0',c anmoderateposts='1',canmoderat eattachments='1' WHERE moderatorid='76'
mysql error: You have an error in your SQL syntax near '',canannounce='1',canmassmove='0',canmassprune='0 ',canmoderateposts='1',canmode r' at line 1

mysql error number: 1064

admin/forum.php

im really tired its 8am after been up all night ill fix my mistake when I wake up.

[Lucky]

There's got to be something up with this?
I have followed instructions to a T and my moderators can't edit profiles. There is no drop down or enter button anywhere?
What's up with this?
Is it still beta?

Any ideas?

[Palmer ofShinra]

Chrysalis...

Look in the query for caneditprofile=0'

Notice... the zero in there only has one single quote around it... it should have two.

That's your error.