used some of your application questiosn and "terms" on my custom mod app

just wanted to say thx

ok last night i had someone use the mod app to submit their application. this morning i had received the following error like over 100 times to my email:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_thread(title, lastpost, forumid, open, replycount,
postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1124215271, 0, 1, 0, '',
, '', 1124215271, 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 ' '', 1124215271, 1, 0)' at line 2

mysql error number: 1064

Date: Tuesday 16th of August 2005 10:27:22 AM (the times are different for each email error)
Script: http://anime-extreme.net/forum/cron.php?&rand=246654
Referer: http://anime-extreme.net/forum/
Username: ShinobiXX (the usernames are different for each email error)


is this because i didn't specify variables for the automated thread settings?

because when i set those variables it posts the automated threads like 100 times.

Nice work thanks man

any answers on this?

yup it is i'm afraid

I have a couple of questions. Would there be a way to send a PM to all moderators rather than having it post to a forum?

Also, once the 14 days is past and the applicant retained a 7 or better rating, are they supposed to be automatically added to the mod usergroup? And, is there a way to shorten the timeframe?

Or better yet, what are all the ways the site takes care of the applicant?

Also, my cron ran fine for a couple days, now im getting an error emailed to me:

/bin/sh: line 1: ./includes/cron/maf_cron.php: No such file or directory

well after i specify the variables for the automated thread setting and then the cron runs right after that everytime someone views the forum where the automated thread goes it creates a new thread so i end up with like 182 threads about mod reqeusts to rate.

do you intend to use the thread creation aspect of the script?

yes there would but it requires hacking the hack.
nope, once the times up, they're officially shortlisted, it needs human power to make them mods
it tells them if they got shortlisted or not.
you forgot to edit the maf_cron.php

no i don't really need that. i'm frequently in the admin cp so i'm always checking.