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

[Ziki]

Originally Posted by The Realist

Are you editing the file correctly?

I boobed the 1st time I did it and my admincp buggered up because I did not follow these instructions:



Laters

OK works now.I forgot to rewrite <navgroups/>.Thanx a lot.I should read the whole code first

[proxx]

I'm getting this error when running the CRON, please help:

atabase error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1141557671, 52, 1, 0, '', , '', 1141557671, 1, 0);

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 ' '', 1141557671, 1, 0)' at line 2
Error Number : 1064
Date : Sunday, March 5th 2006 @ 05:21:11 AM

[The Realist]

How is the votes calculated?
Can the 14 day limit be changed?

Laters

[Jon.]

I also get that maf_rated thing, but it's causing problems. I commented on someone's application, and now it's disappeared. That was via the admin panel, and via the mod panel it never adds my comment.

[Drewish]

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO forum_thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1141866383, 0, 1, 0, '', , '', 1141866383, 1, 0);

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 ' '', 1141866383, 1, 0)' at line 2
Error Number : 1064

^This is when I attempt to run the scheduled task after submitting a test application. Not compatible with vB 3.5.4?

[Treak]

i get this error! any help

this is when i run the installer

i have done everything else. since yhis to see if it helpos but does not!

Database error in vBulletin 3.5.0:

Invalid SQL:

CREATE TABLE `maf_application` (
`appid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`email` varchar(250) NOT NULL default '',
`fullname` varchar(250) NOT NULL default '',
`age` tinyint(4) NOT NULL default '0',
`location` varchar(250) NOT NULL default '',
`timezone` varchar(25) NOT NULL default '',
`position` varchar(250) NOT NULL default '',
`why_them` mediumtext NOT NULL,
`what_they_bring` mediumtext NOT NULL,
`pactivity` mediumtext NOT NULL,
`globally_pactivity` mediumtext NOT NULL,
`plus_site` mediumtext NOT NULL,
`neg_site` mediumtext NOT NULL,
`better_than_rest` mediumtext NOT NULL,
`more` mediumtext NOT NULL,
`application_time` int(10) NOT NULL default '0',
`auto_mailed` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

MySQL Error : Table 'maf_application' already exists
Error Number : 1050
Date : Thursday, March 9th 2006 @ 10:48:32 PM
Script : http://www.lokiart.com/forums/mas_installer.php
Referrer :
IP Address : 24.12.228.89
Username : Smallville
Classname : vb_database

[Stone Cold 3:16]

I wanna install, but sounds very glitchy, any yesses and nos?

[portalimiz]

this hack does not work from the page 1
and no solution is created for 11 pages
IRONIC

[Treak]

yeha i agree.. some help to the solution of this problem would be appriciated!

[David_R]

how to upgrade from 3.x version to 3.5.x for this hack ?
i am getting this error: https://vborg.vbsupport.ru/showpost....&postcount=156

morever, all the tables on my forum have a prefix, but while creating new tables this hack ignore the table prefix. please fix this problem