The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Comments |
#12
|
|||
|
|||
![]()
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? |
#13
|
||||
|
||||
![]()
there is one ' missing
PHP Code:
PHP Code:
|
#14
|
|||
|
|||
![]()
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. |
#15
|
||||
|
||||
![]()
Change this in admin/forum.php:
PHP Code:
PHP Code:
|
#16
|
|||
|
|||
![]()
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? |
#17
|
||||
|
||||
![]()
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.
|
#18
|
||||
|
||||
![]()
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. |
#19
|
||||
|
||||
![]()
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. |
#20
|
|||
|
|||
![]()
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? |
#21
|
||||
|
||||
![]()
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. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|