run this query, i'll update the installer
[SQL] ALTER TABLE `mas_application` CHANGE `appid` `appid` INT(10) NOT NULL AUTO_INCREMENT[/sql]

and this query
[SQL] ALTER TABLE `mas_rating` CHANGE `ratingid` `ratingid` INT(10) NOT NULL AUTO_INCREMENT[/sql]

installer updated, it seems that auto increments are removed in making queries MySQL 4.0 compatible. :(

ok works like a charm thanks for the fast response!

sabret00the you the man bro. Nice hack and was looking for something like this for quite a while until I came to this site. lol

Now, it will great if you can tell me how can I translate that Mod into spanish please. Is it posible to do this Bro? :hurt:

Sorry bro Im a noob ;)


Thanks for any help

Sorted now :)

Hi

We get this error now when a app is submitted

urgently need support on this please as we have 3 peeps that want to apply for a position... :(

In the database i have maf and mas tables, whats this all about please?

Also i still dont see the moderator application section in the admincp, but its there in the modcp
so i cannot delete th appz from the admincp, only from the db its self atm :(

did you set your vBoptions?

you'd have to edit the templates and mas_cron.php directly.

Whoopsy...no i didnt....Note to self...read the instructions :o

Sorted the issue with admincp now...
All the filenames are different now, there all/most are now mas and not maf lol

Also what about the tables in the db, mas and maf?
Can i just delete the maf 1's as it looks like its using the mas 1's now?

I have this problem aswell
but how do I fix it?
Every one refreshes, and we get about 20 applications from each user. If some one had this problem, and fixed it, can you help me please :)

- Habbo-Gold.Com/forum
- Jack

all prefixes (database and files) are now mas, delete all old files and upload the new files, make sure you ran the upgrade script if you're upgrading and make sure you uploaded ALL the files.

you never set your vBoptions.

What do u mean by that :S
Where abouts is it?

when you enter your admincp on the left hand side at the top you see "vBulletin Options"

click that and then find "Moderator Application System" and set those options.

ohhh, I had to put in a username, i didnt think it wd be any thing to do with that, and was looking for something else, Thank You :D

I have just replied to your PM ForumHabbo

Does this work with 3.6?

No worrys.:)

Yup.

Any fixes for the missing pharses and things =\

what missing phrases and things are you referring to?

Any way of hiding the scores from the other mods...so only the admin can see what people rate each applicant?

like this one..

Could not find phrase 'mas_dontlie'.

Yea, theres a couple more too.

if folks don't list the missing phrases i can't fix them, naming one and expecting me to guess the rest is just a little too much no?

Ignore that...looks like it was fixed when it went from maf to mas lol

Hey, Great hack, i was wondering if there was a way to post the contents of what the user actully typed into the post, instead of the admincp :P, Because im using it for a Clan Application System type thing and would love it to post it in a forum instead.

yup yup it was, you were just about to feel my wrath for not checking before posting bugs :p

it's possible and it's not too hard but beyond the scope of 'support' regarding this thread.

lol ah, anyway i can talk you into helping me on your site? :P

thanks sabret00th close call.....lol

Anyway as for posting the deets in a thread, tis a good idea, but we just copy and paste it, have doen from the begining it copies very well lol :)

well yea, But im not always going to be on to Copy/paste it lol :(, I Know there was a hack that was something like this and it posted the info in a thread but i forgot where i found it lol

nope my site is strictly for chit-chat sadly. maybe someone will post in here how to do it. bar that i'd say just make a normal request for an add-on. personally i don't do private support for anything less than ?10GBP via Paypal. but if you make a normal (not paid) hack request, i think you'll get lucky.

Ight ty, ill give it a shot, if it doesnt work then ill probley...ask for private support and have to pay for it lol :P

Quote:

Thank you for your application for the above post of moderator, > congratulations you were successfully shortlisted for the role of > moderator. > > However at this time we're unable to directly instate you, your > application was exempt and we're short listing you for the next opening, > at which point you'll be further contacted by an administrator to let you > know if you were successful or not in your application. > > You\'re presence and input are greatly appreciated, so please try keep > up > the good work. > > Regards

Just had this emailed to one of my applicants and i am curious about the phrase in bold.
Does this mean it can be set up to automatically promote someone to Mod? Also, where can i alter the phrase for this email?

Any joy with this problem yet. :)

https://vborg.vbsupport.ru/showpost....&postcount=225

I get this db error:
[QUOTE]Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT COUNT(*)
FROM maf_application;

MySQL Error : Table 'nlp_online_be.maf_application' doesn't exist Error Number : 1146
Date : Thursday, September 21st 2006 @ 07:40:52 PM
Script : http://www./modcp/maf_rateapp.php?do=list
Referrer : http://www./admincp/index.php?do=nav
IP Address :
Username : Bart
Classname : vb_database

[QUOTE=Barteken]I get this db error:
files prefixed with MAF_ do not exist within the current system

i was originally PISSED!!! the older version didnt work... and when i saw this one.... i was skeptical this would not work either.. but i installed it.. and it works... MAN, YOU STRAIGHT UP... DONE THAT!!!!!

thank you...

[QUOTE=sabret00the]I had this hack befor and now I reinstalled cause im running 3.6 and i got the same error what exactly do I have to do to fix it?