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

[Taipa]

Works for me on 3.6.7


Is there a better way to delete applications? It's very tedious to have to type (or copy/paste) individual applications just to delete them, especially if you have a lot at one time!

[ChU v2]

Getting this error when submitting an application

Fatal error:

* No Users Matched Your Query
* You did not specify a username for your post.

Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 765

[Mrdby]

any updates?

[Mrdby]

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM vb_mas_application WHERE userid = 1;

MySQL Error : Table '***_vbull.vb_mas_application' doesn't exist
Error Number : 1146
Date : Tuesday, July 17th 2007 @ 10:37:26 PM
Script : http://*****.net/forum/modapp.php?
Referrer :
IP Address : ******
Username : ******
Classname : *****


ANYBODY?

[Mrdby]

Originally Posted by 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!!!

Error

SQL query:

RENAME TABLE mas_application TO vb_mas_application, mas_rating TO vb_mas_rating

MySQL said: Documentation
#1017 - Can't find file: './****_vbull/mas_application.frm' (errno: 2)

[Censtudios]

So it automatically makes the user moderator after 2 weeks when all current moderators vote 7+?

or will the admin (me) get an email that everybody voted 7+ and I can choose for myself if I make him one....?

please answer

[salata]

i tried modifying the questions asked but then i click submit i get this error, anyone know where i made this error and how can i correct this


Invalid SQL:

INSERT INTO mas_application(userid, email, fullname, nicknames, age, experience, height, location, occupation, position answers, application_time)
VALUES (3, 'jkibbs@hotmail.com', 'Jay', 'kibbs', '23', '', '', 'ssffsf', 'sfsfsfs', 'sffsfff', '', 'a:33:{i:0;s:9:\"fame2004\";i:1;s:18:\"hdsajhddhld hsadhdl\";i:2;s:13:\"gsfdgfgaggsag\";i:3;s:9:\"sga sggags\";i:4;s:9:\"sagsagggg\";i:5;s:9:\"sgsgasgga \";i:6;s:11:\"sagsagsagag\";i:7;s:12:\"sfgagsgsgsa g\";i:8;s:10:\"sagasgsags\";i:9;s:8:\"sagsgsag\";i :10;s:9:\"gsagagasg\";i:11;s:8:\"gsgsgasg\";i:12;s :7:\"sgsagsg\";i:13;s:10:\"gsagsagasg\";i:14;s:8:\ "sgsagsag\";i:15;s:7:\"sgsgsag\";i:16;s:11:\"gsfag sagsag\";i:17;s:9:\"gsgsaggsa\";i:18;s:12:\"gsgsag sagsag\";i:19;s:13:\"fsggsagsagsag\";i:20;s:11:\"s fgsagsagag\";i:21;s:8:\"gsgsagag\";i:22;s:9:\"sfag sgsag\";i:23;s:11:\"gsfagsagsag\";i:24;s:9:\"gsags agas\";i:25;s:7:\"saggsag\";i:26;s:4:\"ffhf\";i:27 ;s:9:\"gsagsagsa\";i:28;s:5:\"gsasg\";i:29;s:4:\"f jfj\";i:30;s:12:\"sagagsgagasg\";i:31;s:6:\"gsagga \";i:32;s:6:\"sgggsa\";}', 1187034630);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'answers, application_time)
VALUES (3, 'jkibbs@hotmail.com', 'adfds', 'fafffa' at line 1
Error Number : 1064
Date : Monday, August 13th 2007 @ 03:50:30 PM
Script : http://xxxxxxxx.com/forums/modapp.php
Referrer : http://xxxxxxxxx.com/forums/modapp.php
IP Address : 24.57.117.68
Username : Jkibbs
Classname : vb_database

[JaggedEdge]

Will this work with 3.6.8?

[djdonx]

JaggedEdge, I just installed and all appears to be fine

However, not all of my staff will be rating the apps so how can I just see the average rating without all staff looking at it?

[Shazz]

Originally Posted by JaggedEdge

Will this work with 3.6.8?

Theres many bugs