MAF: (Moderator Application Form & Application Rating Module)

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 "maf-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 thanks to Link and his magical HIS

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:











So you heard their was an upgrade and you're wondering just what you have to do right? simply reupload all the files (not including your cron if you wanna be special and then just run the installer, if that gives you trouble just click overrite original settings, all it's gonna do it reinstall the phrases, reinstall the templates and tell you the two file mods to remake.


So you heard their was an upgrade this time around? simply reupload all the files (if you wanna pretend to be uber 1337 just upload the admincp file and the cron folder file)

latest zip: 10/05/05 16:59

[Blootix]

Originally Posted by Lionel

Big sigh! I have the same problem with the member choice hack. I have had that problem on 3 different boards.

What is this? I got an error message when I installed this on 3.0.7. This occurs when I go to either ACP or MCP and click on Rate Applications:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT maf_application.*, user.username
			FROM maf_application
			LEFT JOIN vb3_user ON (user.userid = maf_application.userid)
		
mysql error: Unknown table 'user' in field list

mysql error number: 1109

Anyone else getting this?

[Lionel]

Looks like I am not the only one after all

https://vborg.vbsupport.ru/showthrea...389#post620190

[Lionel]

sabreth00the, how did you get around the same error you reported at
https://vborg.vbsupport.ru/showthrea...389#post611628

[Marco van Herwaarden]

@lionel
The

Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /var/www/forums/includes/db_mysql.php on line 389

message is a bug in the HIS installer, where it can not display the normal error message if a SQL error occurs. You should find the SQL error however if you ever want to solve your problem.

@all getting errors during install table creations
What MySQL version you're running?
Did you upload the files in binary or ASCII mode?

[Marco van Herwaarden]

@sabre
[sql]SELECT maf_application.*, user.username
FROM maf_application
LEFT JOIN vb3_user ON (user.userid = maf_application.userid)[/sql]
2 problems as i see them:
1. "FROM maf_application" is not using TABLE_PREFIX, and missing a " AS .."
2. "LEFT JOIN vb3_user " should be: "LEFT JOIN vb3_user AS user"

[Lionel]

My files were uploaded in ascii and myql version is 3.23

[sabret00the]

Originally Posted by Lionel

every time. twice. And the file is there. And that is a fresh copy of 3.07

give me the greater part of the day and i'll make a text installer for you

[Lionel]

and this the db error i got

Database error in vBulletin 3.0.7:

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 tinyint(4) default NULL,
PRIMARY KEY (appid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 21

mysql error number: 1064

[sabret00the]

Originally Posted by MarcoH64

@sabre
[sql]SELECT maf_application.*, user.username
FROM maf_application
LEFT JOIN vb3_user ON (user.userid = maf_application.userid)[/sql]
2 problems as i see them:
1. "FROM maf_application" is not using TABLE_PREFIX, and missing a " AS .."
2. "LEFT JOIN vb3_user " should be: "LEFT JOIN vb3_user AS user"

thanks, i'll get that fixed

[Lionel]

Originally Posted by sabret00the

give me the greater part of the day and i'll make a text installer for you

thanks