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

[sabret00the]

Originally Posted by Lizard King

is the problem with modcp solved ?

Also a question with cron , as I explained before. I just tested application form once cause I had to make some translations over templates. And I ran the cron job and I didn't set a time to run. I have 10 topics now but what I can't understand is if a cron job run once and do his job why is he opening the same topic second time ?
I am not sure if the cron job will re open the thread ? I checked now and he again reopened the thread. Thats is something you must clear urgently cause it will be really disturbing that cron job will do the job again and again which he already did.

Check out the attached screenshot and check the last post time. There is something really wrong with the cron job.

ok for this quite sure what the error is, at the end of the cron script it checks if theirs any new applications, if that case is true then it makes the thread, this isn't in a loop or anything or the sort in order to generate this command more than once, however everytime the script is run it will make a new thread, i can only guess that somehow the script ran ten times.

[Marco van Herwaarden]

I see more people are getting the same SQL error. If i however copy the SQL statement into a SQL-editor, it runs without any problems.

I am running MySQL 4.1.8 myself, you are still on version 3, so that might be the reason for your problems. Would be interesting to see if the other users reporting this error are also running older MySQL versions.

You maybe have access to a server running a higher MySQL version to test?

[sabret00the]

i'm running 4.0.18 on my localhost so i think you're probably right marco

[Lionel]

I've got my own server but I am not sure on how to upgrade to 4.18

[sabret00the]

anyone with modcp/admincp problems can redownload the zip i've got it fixed finally

[Marco van Herwaarden]

@lionel
Try to edit the 'queries.php' file in the hacks install directory.

Change the line:
[sql]) TYPE=MyISAM;
[/sql]
to
[sql]);[/sql]
This should probably be done for every CREATE TABLE statement in that file.

Now please check if it runs and report back.

[Oblivion Knight]

For the "This Application Was Rated: 12846 days ago" bug, open up /modcp/maf_rateapp.php and find:
[sql] SELECT maf_ratings.appid, maf_ratings.userid, user.username, maf_ratings.rating, maf_ratings.additional_comments[/sql]On the same line, after it add:
[sql], maf_ratings.timestamp[/sql]All fixed..

[Lionel]

Originally Posted by MarcoH64

@lionel
Try to edit the 'queries.php' file in the hacks install directory.

Change the line:
[sql]) TYPE=MyISAM;
[/sql]
to
[sql]);[/sql]
This should probably be done for every CREATE TABLE statement in that file.

Now please check if it runs and report back.

that did not help at all. Same results.

[Lionel]

Hey, that helped after all. It was missing a single quote brfor the ; like ';

[Lionel]

Thank you marco. Got it up and running