Moderator Application System 2.0

FAQ:
What Does It Do? it enables your members to apply to be a mod, cuts down on all the asking and stuff

That It? basically

What about the cool back end? ooh yeah, so anyway it will email on the 14th day to either let em know they've been shortlisted or to try again at a later date

How will it know? mod ratings innit, if their under 7 their outta there

Anything else? nah i guess it starts a thread in your mod forum to tell your mods to rate em

How does it know what forum and who's the threadster? you tell em via the admincp options (where the rest of the vboptions are) theirs a handy little group for the MAF and i don't mean 2+2

Ok so that's gotta be it now? nope

What else does it do? it logs it all in the admincp schedules tasks and sends you a copy of the email

Damn who taught you all that? various folks, special thanks to Dean, Marco, OBK and Zero Tolerance who helped me on this specific hack though.

Ok so what's the install like? swift the long thing is the upload

Ok rumour is it needs to run a cron, what's a cron? :squint: it's the automated do-dad in the admincp

How do i set it up? it's so straight forward you could close your eyes and do it, the file you're cronning is called "mas-cron.php" and i recommend running it at 12.30 (that means leave the rest as stars)

Ok so if their an installer? there is indeed, a quick dirty one. no not like that

Well now that's sorted can i install it? please do!

How can i help you become cooler? click install and let's see if i can become hack of the month innit

Bye now? yes go :ermm:

Wait! ain't this the same as the last one? yes but this one runs on 3.5.x :ninja:

[hr]xxx[/hr]

To Upgrade just run the upgrade script www.yoursite.com/forums/mas_upgrade.php?step=1

To Uninstall just run the upgrade script :? http://www.yoursite.com/forums/mas_u...step=uninstall

What's new? you can now add your own questions and stuff

For real? for real.





Screens: https://vborg.vbsupport.ru/showthread.php?t=77340

[johnrizz]

Originally Posted by browie

I had to quote this because I swear i went through this whole thing and didn't see how to fix this. Some one that fixed this help?

browie,
I was getting the same error then I realized that this error has to be a joke, When I login to my F o r u m under stone0075 and try to apply for moderator status using a different name as a test in the Username: I do get the, "can not find 'mas_dontlie" haha! good one! but when I apply using stone0075 everything works fine... if you haven't figured this out yet I hope this helps!!!
john.

[rareclownfish]

Originally Posted by JamieLee2k

Installed this on my 3.6.1 on my localhost and it works like a dream, tried to install it on my Live server 3.6.2 and I get this error:

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT * FROM _vbmas_application WHERE userid = 1;Username     : JamieLee2k
Classname    : vb_database

MySQL Error : Table 'vb362._vbmas_application' doesn't exist
Error Number : 1146
Date : Saturday, October 7th 2006 @ 04:47:06 PM
Script : http://www.xleagues.net/forum/modapp.php?
Referrer : http://www.xleagues.net/forum/index.php
IP Address : xx.xx.xx.xx


I have installed it once before I it was fine followed it word for word, now when I goto run it I get an error.

Having the same problem, i tried what you said didn't work though, anything else i can try

[Nathan2006]

EDIT: Doesnt matter anymore I got some great help off Psionic Vision on how to uninstall this mod.

UNINSTALLED!

[Ntfu2]

I've got this working on 3.6.3. It wasnt pretty, but heres how i did it.

1. in phpMyadmin find the mas_application and mas_rating tables and add your forums prefix to them.

2. in the modcp/mas_rateapp.php file line 29 looks like

			FROM mas_application

Change that to

			FROM YOURTABLEPREFIX_mas_application

[rareclownfish]

I might have to give that a try thanks.

[cOuNtErFiET]

Invalid SQL:

			SELECT mas.*, u.username
			FROM vb_mas_application mas
			LEFT JOIN vb_user u ON (u.userid = mas.userid);

MySQL Error  : Table 'MY_DATABASE_HERE.vb_mas_application' doesn't exist
Error Number : 1146
Date         : Tuesday, December 12th 2006 @ 05:50:15 PM
Script       : http://www.MY-SITE.net/forums/modcp/mas_rateapp.php?do=list
Referrer     : http://www.MY-SITE.net/forums/admincp/index.php?do=nav

im runing 3.5.7 should i do the 3.6.x edit that you have mentioned above seems to me like its not adding the tableprefix...

[cOuNtErFiET]

ok here is what i did to fix it might help some of ya

1. Edit the mas_ratings.php file like Ntfu2 said
in the modcp/mas_rateapp.php file line 29 looks like

FROM mas_application

To This

FROM vb_mas_application

2. GoTo phpmyadmin and then selcet your db that vbulletin is in, then click the SQl tab, then in the input box enter this below then click Go

RENAME TABLE mas_application TO vb_mas_application,
             mas_rating TO vb_mas_rating;

3. go set your vBulletion Options for this hack, then test the application by going to /modapp.php and see if it works, working for me!!!

of course changing the all the vb_ to YOUR boards table prefix!!!

[2fast4ya]

quick question, I'm a noob when it comes to putting links in certain places. I need a link that says "Mod App" in the navbar. I need the entire code for it, as I messed it up several time already. If someone could help that'd be great.

[2fast4ya]

bump

[bashy]

Here ya go m8, I aint really got a clue myself but i did copy another link and added the mod app bits, oh yeah, in the process somehow i broken all my dropdown menus pmsl...need to fix them now, but any hoooo heres ys link
You can remove the top line and the bottom line if you want all including guests to see it, if you leave as is then only registered can see it

<if condition="$show['member']">
<td class="vbmenu_control"><a href="modapp.php?$session[sessionurl]">Apply To Be A Mod</a></td>
</if>

You can change Apply to be A Mod to what ya want

Originally Posted by 2fast4ya

bump