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

[Dave-ahfb]

oops, I meant to say /install/

[red_baron2000]

2 things :

1) there is a small typo " their" should be"there" see attached picture.

2) i have set the cron as stated above and scheduled task to run 1 time per day however it still send the same applicant form to moderators forum non stop any idea how to fix this?

thank you.

[Mla7a6]

I am not sure, but it seems to me the problem with the installation of HIS is associated with MySQL version 3.23 while it didn't affect version 4 and above.. ( I tested it on another site and it ran smoothly like a charm)..

Can you confirm it MarcoH64

[sabret00the]

yup theirs a problem with HIS or atleast my implemation and pre-4.0.0

[Marco van Herwaarden]

Try running the following queries, insert table prefix if needed:
[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)
);[/sql]
[sql]CREATE TABLE maf_ratings (
ratingid int(10) NOT NULL auto_increment,
appid int(10) NOT NULL default 0,
userid int(10) NOT NULL default 0,
rating tinyint(4) NOT NULL default 0,
additional_comments mediumtext NOT NULL,
timestamp int(10) NOT NULL default 0,
PRIMARY KEY (ratingid),
KEY appid (appid),
KEY appid_2 (appid)
);[/sql]

@sabre
Why are you not using TABLE_PREFIX? and why the same KEY twice on the second table?

[Marco van Herwaarden]

Originally Posted by sabret00the

yup theirs a problem with HIS or atleast my implemation and pre-4.0.0

The database errors are not caused by HIS, but by the SQL statements themself. The problem with the current HIS version is that it doesn't show the database error correct.

[Mla7a6]

I ran the SQL query from "phpMyAdmin 2.4.0" as instructed, but there was an error after each query:

after the 1st query

Error

SQL-query :  

CREATE TABLE maf_application(

appid int( 10 ) NOT NULL auto_increment,
userid int( 10 ) NOT NULL default0,
email varchar( 250 ) NOT NULL default '',
fullname varchar( 250 ) NOT NULL default '',
age tinyint( 4 ) NOT NULL default0,
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 default0,
auto_mailed tinyint( 4 ) default NULL ,
PRIMARY KEY ( appid ) 
) 

MySQL said: 


You have an error in your SQL syntax near 'default0, email varchar( 250  )  NOT  NULL default  '', fullname varchar( 250  )' at line 1

and then after the 2nd query:

Error

SQL-query :  

CREATE TABLE maf_ratings(

ratingid int( 10 ) NOT NULL auto_increment,
appid int( 10 ) NOT NULL default0,
userid int( 10 ) NOT NULL default0,
rating tinyint( 4 ) NOT NULL default0,
additional_comments mediumtext NOT NULL ,
timestamp int( 10 ) NOT NULL default0,
PRIMARY KEY ( ratingid ) ,
KEY appid( appid ) ,
KEY appid_2( appid ) 
) 

MySQL said: 

You have an error in your SQL syntax near 'default0, userid int( 10  )  NOT  NULL default0, rating tinyint

Any ideas MarchH64 ?

[Marco van Herwaarden]

Well something went wrong with the copy&paste. If you look at the query i posted on the previous page you will see a space between every 'default 0', this turns into 'default0' at your post.

Try again, but insert a space in every 'default0'.

[SaN-DeeP]

Nice Modification sabretooth.. I will give this a try

Regards,

[Mla7a6]

Originally Posted by MarcoH64

Well something went wrong with the copy&paste. If you look at the query i posted on the previous page you will see a space between every 'default 0', this turns into 'default0' at your post.

Try again, but insert a space in every 'default0'.

I tried to copy&paster several times, and even added extra spaces, but phpMyAdmin didn't get it right.. so I tried something else..

I inserted the tables manually, and the script worked 80% except for the automatic thread creation.. I think the reason was that I didn't know how to run the following command manually: ( I am still novice @ MySQL quries )

KEY appid( appid ) ,
KEY appid_2( appid )

if thats the reason, can you help me.. I know that I bugged you very much.. but I liked the script and will do anything to install it..