Moderator Application System 2.0

[sabret00the]

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?
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.

[sabret00the]

I have this problem aswell

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 763

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
you never set your vBoptions.

[ForumHabbo]

you never set your vBoptions.
What do u mean by that :S
Where abouts is it?

[sabret00the]

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.

[ForumHabbo]

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

[bashy]

I have just replied to your PM ForumHabbo

[Jack Black]

Does this work with 3.6?

[Rover416]

you did set your vBulletin options right Barteken?

@rover i've not forgotten you

No worrys.:)

[sabret00the]

Does this work with 3.6?
Yup.

[Shazz]

Any fixes for the missing pharses and things =\

[sabret00the]

Any fixes for the missing pharses and things =\
what missing phrases and things are you referring to?

[Jack Black]

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

[cbr929rrerion]

like this one..

Could not find phrase 'mas_dontlie'.

[Shazz]

like this one..

Could not find phrase 'mas_dontlie'.
Yea, theres a couple more too.

[sabret00the]

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?

[bashy]

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

[Dark Riku]

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.

[sabret00the]

Ignore that...looks like it was fixed when it went from maf to mas lol
yup yup it was, you were just about to feel my wrath for not checking before posting bugs :p

[sabret00the]

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.
it's possible and it's not too hard but beyond the scope of 'support' regarding this thread.

[Dark Riku]

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

[bashy]

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 :)

[Dark Riku]

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

[sabret00the]

lol ah, anyway i can talk you into helping me on your site? :P
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.

[Dark Riku]

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

[Jack Black]

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?

[Rover416]

Any joy with this problem yet. :)

https://vborg.vbsupport.ru/showpost.php?p=1058623&postcount=225

[Barteken]

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

[sabret00the]

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
files prefixed with MAF_ do not exist within the current system

[TheBlackPoet]

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...

[djjeffa]

[QUOTE=Barteken]I get this db error:

files prefixed with MAF_ do not exist within the current system
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?

[Shazz]

[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?
Its in any version, its just missing for some reason. Its always been like this..

[djjeffa]

[QUOTE=djjeffa]
Its in any version, its just missing for some reason. Its always been like this..
so how do i get it to work? soory for the dumb question

[Shazz]

[QUOTE=Shazz]
so how do i get it to work? soory for the dumb question
ask sabret00the -.-

[djjeffa]

mr sabret00the can you please enlighten me on how to get this to work?
thank you.

[sabret00the]

[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?
replace all the old files with the new files and if you're coming from the old version run the mas_upgrade.php

[sabret00the]

mr sabret00the can you please enlighten me on how to get this to work?
thank you.
i cannot find or replicate the error AT ALL, delete all files that say maf_anything and upload files saying mas_anything.

[sabret00the]

Its in any version, its just missing for some reason. Its always been like this..show me the error message you're getting please?

[Shazz]

show me the error message you're getting please?
The 2 missing phrases that everyone is missing...It dosen't change much

[sabret00the]

The 2 missing phrases that everyone is missing...It dosen't change much
what phrases are you on about? not to be funny but ambiguity isn't helping anyone right now. it's not helping me to help you and it's not you to help me to help you, instead it's just getting my back up because i could be doing something i could be getting paid for.

[djjeffa]

thanks sabret00the
I got a little further i can fill out an app but when i submit I get:
Fatal error:
No Users Matched Your Query
You did not specify a username for your post.
Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 763

also adding the new cron job what do i put for the Varname ?

[djjeffa]

ok im a dumbass I didnt see the second post.
but i did put it in search but it didnt come up.

Also is there a way to Remove the tmezone feild?

[sabret00the]

thanks sabret00the
I got a little further i can fill out an app but when i submit I get:
Fatal error:
No Users Matched Your Query
You did not specify a username for your post.
Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 763

also adding the new cron job what do i put for the Varname ?
the varname doesn't matter.

[sabret00the]

ok im a dumbass I didnt see the second post.
but i did put it in search but it didnt come up.

Also is there a way to Remove the tmezone feild?
the questions are set in your admincp options, you can remove or add any questions you like.

[djjeffa]

the questions are set in your admincp options, you can remove or add any questions you like.
i dont see where tome zone is, I think its in the php but i dont know what to remove?
also how do i edit the agrrement page?
thanks for your help
jeff

[sabret00the]

i dont see where tome zone is, I think its in the php but i dont know what to remove?
also how do i edit the agrrement page?
thanks for your help
jeff
you're right, that's a personal information question. there's no easy way to remove it, other than commenting out the field in the template.

[brvheart]

so as a fresh install....this will work on 3.6.1?

thank you for the hard work :)

[brvheart]

anyone?

[JamieLee2k]

Installed this on my 3.6.1 on my localhost and it works like a dream, tried to install it on my Live server 3.6.2 and I get this error:

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT * FROM _vbmas_application WHERE userid = 1;

MySQL Error : Table 'vb362._vbmas_application' doesn't exist
Error Number : 1146
Date : Saturday, October 7th 2006 @ 04:47:06 PM
Script : http://www.xleagues.net/forum/modapp.php?
Referrer : http://www.xleagues.net/forum/index.php
IP Address : xx.xx.xx.xx
Username : JamieLee2k
Classname : vb_database


I have installed it once before I it was fine followed it word for word, now when I goto run it I get an error.

[JamieLee2k]

I got it working I had to go into phpmyadmin and the databases it put in was mas_application and not _vbmas_application and so I renamed it, all working fine.

[bashy]

Hi

I would really like this where i can set it so previous applicants cant use the system or just turn off the system for any member i choose...

Please can someone help as i have a problem member who is a mate but i dont want to cause a rift and his apps are as though a kids whos spat his dummy out has filled it in....

If this is not possible, then perhaps a conditional for the link where i can manually set specific user ID's to the conditional....

Yours hopefully

[johnrizz]

I did the install and all went well except when I go to submit the form I received an error, this is it.Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758

I didn't bothered filling out the cron "scheduled tasks" would this have something to do with this error?

[brvheart]

I did the install and all went well except when I go to submit the form I received an error, this is it.Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758

I didn't bothered filling out the cron "scheduled tasks" would this have something to do with this error?

Read post number 2..

click here (https://vborg.vbsupport.ru/showpost.php?p=843802&postcount=2)

[johnrizz]

Thanks brvheart! I need to send the application somewhere, my bad! works fine now! installed!!:cool:

[howard007]

Does this work for 3.6.2? If so, do any mods need to be made?
How come a 3.6.2 version is not out?

[browie]

I'm still having the problem

can not find 'mas_dontlie'

I searched this area and I did not see anyone say how to fix this.

[ShadowOne]

Fatal error: Call to undefined function: verify_bs_opponent() in /home/dubicon/public_html/board/includes/visionscripts/psionic_bsh/threadfpdata_presave.php on line 0

[Nathan2006]

Hi Im trying to uninstall this but I keep getting this error :(

Database error in vBulletin 3.6.2:

Invalid SQL:
DROP TABLE `maf_application`;

MySQL Error : Unknown table 'maf_application'
Error Number : 1051
Date : Wednesday, November 1st 2006 @ 05:56:28 PM
Script : http://www.mysite.com/mas_upgrade.php?step=uninstall
Referrer :
IP Address : 12.112.12.112
Username : Nathan
Classname : vb_database

Thank you for any help :)

[browie]

I'm still having the problem



I searched this area and I did not see anyone say how to fix this.

I had to quote this because I swear i went through this whole thing and didn't see how to fix this. :( Some one that fixed this help?

[bklynjava]

Can you be a little more specific as to where this would be added in vboptions.

(ie) Sitename/URL/Contact Details

I can visit the link fine when I test it with my site yet I recieve the error stated in post 2.

I have set the name and Forum ID.

Thank you


EXAMPLE LINK: http://www.yoursite.com/forums/admin..._settingsgroup

[bklynjava]

Follow Up --> All is working great now thanks for the Mod...

[johnrizz]

I had to quote this because I swear i went through this whole thing and didn't see how to fix this. :( Some one that fixed this help?

browie,
I was getting the same error then I realized that this error has to be a joke, When I login to my F o r u m under stone0075 and try to apply for moderator status using a different name as a test in the Username: I do get the, "can not find 'mas_dontlie" haha! good one! but when I apply using stone0075 everything works fine... if you haven't figured this out yet I hope this helps!!!
john.

[rareclownfish]

Installed this on my 3.6.1 on my localhost and it works like a dream, tried to install it on my Live server 3.6.2 and I get this error:

Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT * FROM _vbmas_application WHERE userid = 1;Username : JamieLee2k
Classname : vb_database


MySQL Error : Table 'vb362._vbmas_application' doesn't exist
Error Number : 1146
Date : Saturday, October 7th 2006 @ 04:47:06 PM
Script : http://www.xleagues.net/forum/modapp.php?
Referrer : http://www.xleagues.net/forum/index.php
IP Address : xx.xx.xx.xx


I have installed it once before I it was fine followed it word for word, now when I goto run it I get an error.

Having the same problem, i tried what you said didn't work though, anything else i can try

[Nathan2006]

EDIT: Doesnt matter anymore I got some great help off Psionic Vision on how to uninstall this mod.

UNINSTALLED!

[Ntfu2]

I've got this working on 3.6.3. It wasnt pretty, but heres how i did it.

1. in phpMyadmin find the mas_application and mas_rating tables and add your forums prefix to them.

2. in the modcp/mas_rateapp.php file line 29 looks like

FROM mas_application


Change that to

FROM YOURTABLEPREFIX_mas_application

[rareclownfish]

I might have to give that a try thanks.

[cOuNtErFiET]

Invalid SQL:

SELECT mas.*, u.username
FROM vb_mas_application mas
LEFT JOIN vb_user u ON (u.userid = mas.userid);

MySQL Error : Table 'MY_DATABASE_HERE.vb_mas_application' doesn't exist
Error Number : 1146
Date : Tuesday, December 12th 2006 @ 05:50:15 PM
Script : http://www.MY-SITE.net/forums/modcp/mas_rateapp.php?do=list
Referrer : http://www.MY-SITE.net/forums/admincp/index.php?do=nav

im runing 3.5.7 should i do the 3.6.x edit that you have mentioned above seems to me like its not adding the tableprefix...

[cOuNtErFiET]

ok here is what i did to fix it might help some of ya

1. Edit the mas_ratings.php file like Ntfu2 said
in the modcp/mas_rateapp.php file line 29 looks like
FROM mas_application
To This
FROM vb_mas_application

2. GoTo phpmyadmin and then selcet your db that vbulletin is in, then click the SQl tab, then in the input box enter this below then click Go
RENAME TABLE mas_application TO vb_mas_application,
mas_rating TO vb_mas_rating;

3. go set your vBulletion Options for this hack, then test the application by going to /modapp.php and see if it works, working for me!!!

of course changing the all the vb_ to YOUR boards table prefix!!!

[2fast4ya]

quick question, I'm a noob when it comes to putting links in certain places. I need a link that says "Mod App" in the navbar. I need the entire code for it, as I messed it up several time already. If someone could help that'd be great.

[2fast4ya]

bump

[bashy]

Here ya go m8, I aint really got a clue myself but i did copy another link and added the mod app bits, oh yeah, in the process somehow i broken all my dropdown menus pmsl...need to fix them now, but any hoooo heres ys link :)
You can remove the top line and the bottom line if you want all including guests to see it, if you leave as is then only registered can see it :)
<if condition="$show['member']">
<td class="vbmenu_control"><a href="modapp.php?$session[sessionurl]">Apply To Be A Mod</a></td>
</if>

You can change Apply to be A Mod to what ya want

bump

[dc pringle]

Is there anyway to alter the code so it is only viewable for supermoderators and higher? The supermoderators on the site also have admin ability on the site.. just not all the ftp info and stuff.. so perhaps if easier is there anyway to alter it just to be viewable by admins?

Everything seems to be working fine, but i dont want mods to have access to rating potential applicants, i want that reserved for the supermods and the admins

Something like an if statement before printing the cp header?

cheers mate

[JuGgOlOw22]

The requested URL /admincp/mas_delapp.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request

i cant delete the members app

[dc pringle]

If anyone wants it only accessible ONLY by supermods or admin, here is what to do.. very simple..


You'll just have to edit/add a few things to mas_rateapp.php that you uploaded to ./modcp/mas_rateapp.php

First, find the following 3 lines:

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_databuild.php');

and put them at the top (but below the ?php entry tag)


Then...

under the back-end lines add:


if ($vbulletin->userinfo[usergroupid] == '6' ||
$vbulletin->userinfo[usergroupid] == '5')

{Usergroup 5 = Smods, and Usergroup 6 = Admins, but change as needed.




Then go all the way to the end of the file and above the ending php (below print_cp_footer(); ) tag add:


}
else {
print "Permission denied\n\n"; //Customize error message here
}

[VTXCafe.com]

so, how do you go about changing the moderators rules/ agreements and all the form questions?

Anyone know where this can be edited? I want to use this for another position and it's not a mod position so I want to change the wording of the "Moderator Rules" agreement....anyone?

[AcidX]

I'm having problems installing this mod too.
The author really needs to edit his installation MANUAL.

[Shazz]

I'm having problems installing this mod too.
The author really needs to edit his installation MANUAL.

What part of the instructions are you having trouble with?
I thought it was pretty basic

[AcidX]

Part one:

"forums/modcp/maf.. rahdy rar etc"

maf.. rahdy rar etc? wtf?

"maf_delmodapp.php"

I don't see a file named "maf_delmodapp.php" anywhere in the "Moderator Application System 2.0.0c" zip file.

Maf, Mas... Files that don't even exists or have been renamed - it's kind of confusing, you know.

[IsMaR]

does this work with 3.6.5

[GekkoPixie]

... All I can say is THANK YOU! I have been looking for something like this. I can't believe I didn't see it before...

[brookelyn]

any change of getting this for vb 3.6?

[djjeffa]

is there anyway to add a non staff groupe to be able to rate the apps?

[ZomgStuff]

1 more vote for transform to 3.6 ;)

[djjeffa]

I use on 3.6.5 with no problem im just tring to figer out how to make a non staff group able to vote

[Mrdby]

this worth having?

[djjeffa]

this worth having?

yes if you want an organize way of getting staff

[Shazz]

this worth having?

Thread title and the first post explaining the FAQ:
Says it all.

[MikeSF]

can this be done for 3.6? its great and want to install it on 3.6 :D

[4x4 Mecca]

I searched the thread for the word "emails" and nothing relivant came back. My system is sending out over a hundred emails to the applicant after 2 weeks. What could be causing this? BTW I know this was made for 3.5.X and I'm using 3.6.4, that seems like the obvious answer, but is it? Or is it something fixable?

[Mrdby]

3.6.7???

[UltimateOreo!]

Testing for 3.6.7 right now, Will be back with an answer shortly.

[Taipa]

Works for me on 3.6.7


Is there a better way to delete applications? It's very tedious to have to type (or copy/paste) individual applications just to delete them, especially if you have a lot at one time!

[ChU v2]

Getting this error when submitting an application

Fatal error:

* No Users Matched Your Query
* You did not specify a username for your post.

Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 765

[Mrdby]

any updates?

[Mrdby]

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM vb_mas_application WHERE userid = 1;

MySQL Error : Table '***_vbull.vb_mas_application' doesn't exist
Error Number : 1146
Date : Tuesday, July 17th 2007 @ 10:37:26 PM
Script : http://*****.net/forum/modapp.php?
Referrer :
IP Address : ******
Username : ******
Classname : *****


ANYBODY?

[Mrdby]

ok here is what i did to fix it might help some of ya

1. Edit the mas_ratings.php file like Ntfu2 said
in the modcp/mas_rateapp.php file line 29 looks like
FROM mas_application
To This
FROM vb_mas_application

2. GoTo phpmyadmin and then selcet your db that vbulletin is in, then click the SQl tab, then in the input box enter this below then click Go
RENAME TABLE mas_application TO vb_mas_application,
mas_rating TO vb_mas_rating;

3. go set your vBulletion Options for this hack, then test the application by going to /modapp.php and see if it works, working for me!!!

of course changing the all the vb_ to YOUR boards table prefix!!!



Error

SQL query:

RENAME TABLE mas_application TO vb_mas_application, mas_rating TO vb_mas_rating

MySQL said: Documentation
#1017 - Can't find file: './****_vbull/mas_application.frm' (errno: 2)

[Censtudios]

So it automatically makes the user moderator after 2 weeks when all current moderators vote 7+?

or will the admin (me) get an email that everybody voted 7+ and I can choose for myself if I make him one....?

please answer

[salata]

i tried modifying the questions asked but then i click submit i get this error, anyone know where i made this error and how can i correct this


Invalid SQL:

INSERT INTO mas_application(userid, email, fullname, nicknames, age, experience, height, location, occupation, position answers, application_time)
VALUES (3, 'jkibbs@hotmail.com', 'Jay', 'kibbs', '23', '', '', 'ssffsf', 'sfsfsfs', 'sffsfff', '', 'a:33:{i:0;s:9:\"fame2004\";i:1;s:18:\"hdsajhddhldhsadhdl\";i:2;s:13:\"gsfdgfgaggsag\";i:3;s:9:\"sgasggags\";i:4;s:9:\"sagsagggg\";i:5;s:9:\"sgsgasgga\";i:6;s:11:\"sagsagsagag\";i:7;s:12:\"sfgagsgsgsag\";i:8;s:10:\"sagasgsags\";i:9;s:8:\"sagsgsag\";i:10;s:9:\"gsagagasg\";i:11;s:8:\"gsgsgasg\";i:12;s:7:\"sgsagsg\";i:13;s:10:\"gsagsagasg\";i:14;s:8:\"sgsagsag\";i:15;s:7:\"sgsgsag\";i:16;s:11:\"gsfagsagsag\";i:17;s:9:\"gsgsaggsa\";i:18;s:12:\"gsgsagsagsag\";i:19;s:13:\"fsggsagsagsag\";i:20;s:11:\"sfgsagsagag\";i:21;s:8:\"gsgsagag\";i:22;s:9:\"sfagsgsag\";i:23;s:11:\"gsfagsagsag\";i:24;s:9:\"gsagsagas\";i:25;s:7:\"saggsag\";i:26;s:4:\"ffhf\";i:27;s:9:\"gsagsagsa\";i:28;s:5:\"gsasg\";i:29;s:4:\"fjfj\";i:30;s:12:\"sagagsgagasg\";i:31;s:6:\"gsagga\";i:32;s:6:\"sgggsa\";}', 1187034630);

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 'answers, application_time)
VALUES (3, 'jkibbs@hotmail.com', 'adfds', 'fafffa' at line 1
Error Number : 1064
Date : Monday, August 13th 2007 @ 03:50:30 PM
Script : http://xxxxxxxx.com/forums/modapp.php
Referrer : http://xxxxxxxxx.com/forums/modapp.php
IP Address : 24.57.117.68
Username : Jkibbs
Classname : vb_database

[JaggedEdge]

Will this work with 3.6.8?

[djdonx]

JaggedEdge, I just installed and all appears to be fine

However, not all of my staff will be rating the apps so how can I just see the average rating without all staff looking at it?

[Shazz]

Will this work with 3.6.8?

Theres many bugs ;)

[Mrdby]

so anybody have a updated version?

[Mrdby]

anybody? lol

[sabret00the]

Theres many bugs ;)
what bugs? if someone can collate all the bugs. i'll look into an updated version.

[Lolliedollie]

A copy of the problem with mine
In the Mod app CP :

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT mas.*, u.username
FROM teenshel_mas_application mas
LEFT JOIN teenshel_user u ON (u.userid = mas.userid);

MySQL Error : Table 'teenshel_forum.teenshel_mas_application' doesn't exist
Error Number : 1146
Date : Friday, September 21st 2007 @ 09:04:48 AM
Script : xxxxxxxxxxxxxxxxxxxxxx/forums/modcp/mas_rateapp.php?do=list
Referrer :xxxxxxxxxxxxxxxxxxxxx/forums/admincp/index.php
IP Address : EDITED OUT
Username : Bluetwinkles
Classname : vb_database

helppp??

[Mrdby]

A copy of the problem with mine
In the Mod app CP :

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT mas.*, u.username
FROM teenshel_mas_application mas
LEFT JOIN teenshel_user u ON (u.userid = mas.userid);

MySQL Error : Table 'teenshel_forum.teenshel_mas_application' doesn't exist
Error Number : 1146
Date : Friday, September 21st 2007 @ 09:04:48 AM
Script : xxxxxxxxxxxxxxxxxxxxxx/forums/modcp/mas_rateapp.php?do=list
Referrer :xxxxxxxxxxxxxxxxxxxxx/forums/admincp/index.php
IP Address : EDITED OUT
Username : Bluetwinkles
Classname : vb_database

helppp??
same problem

[Mrdby]

bump

[sabret00the]

is that the only problem?

[sabret00the]

i'll be releasing 2.1 tonight which will get a new thread in the 3.6 releases. The only changes will be the bug fix and the fact that this version is fully phrased, with a few tweaks to the phrases. if there were suggestions/requests that i've missed, now would be the best time to report them as i'm taking a break to watch the footie.

[sabret00the]

3.6.x version here: https://vborg.vbsupport.ru/showthread.php?t=159704

[Anique]

i m using 3.8.1 i get blank page when i run installer :( please help me

[FireFish]

As you all probably know, this mod is no good with 3.8.x. All applicants complain that they are receiving hundreds of confirmation emails repeating themselves. :mad:

Uninstalled.

[wfouly]

Hello
Thank you
some unregistered member , users waiting mail confirmation applying for the form
when I`m trying to delete the application through the admin cpanel it gives this database error message

Database error in vBulletin 3.8.2:

Invalid SQL:

DELETE
FROM mas_application
WHERE userid =;

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 '' at line 3
Error Number : 1064
Request Date : Saturday, April 18th 2009 @ 04:03:40 AM
Error Date : Saturday, April 18th 2009 @ 04:03:40 AM
Script : http://www.mysite.com/admincp/mas_delapp.php?do=dodelapp
Referrer : http://www.mysite.com/admincp/mas_delapp.php?do=sure
IP Address : ***********
Username : ******
Classname : vB_Database
MySQL Version : 5.0.67-community

[johnrizz]

Is there a Moderator Application like this for 4.0 ?

[blake247]

Is there a Moderator Application like this for 4.0 ?

I'd like to know as well.