PDA

View Full Version : Moderator Application System 2.0


Pages : [1] 2

sabret00the
12-07-2005, 10:00 PM
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 "mas-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, a quick dirty one. no not like that ;)

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:

Wait! ain't this the same as the last one? yes but this one runs on 3.5.x :ninja:

xxx

To Upgrade just run the upgrade script www.yoursite.com/forums/mas_upgrade.php?step=1

To Uninstall just run the upgrade script :? www.yoursite.com/forums/mas_upgrade.php?step=uninstall

What's new? you can now add your own questions and stuff

For real? for real.





Screens: https://vborg.vbsupport.ru/showthread.php?t=77340

sabret00the
12-08-2005, 04:36 PM
If you're getting:
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
You have not set your vBoptions.

EXAMPLE LINK: http://www.yoursite.com/forums/admincp/options.php?do=options&dogroup=mas_settingsgroup

Advice-Central
12-08-2005, 04:48 PM
Hi,

I'm getting this error message when trying to run mas_installer.php!

Parse error: parse error, unexpected T_STRING in /home/advice/domains/advice-central.com/public_html/mas_installer.php on line 50

sabret00the
12-08-2005, 05:01 PM
Hi,

I'm getting this error message when trying to run mas_installer.php!

Parse error: parse error, unexpected T_STRING in /home/advice/domains/advice-central.com/public_html/mas_installer.php on line 50

redownload, it should all be working now :)

Advice-Central
12-08-2005, 05:03 PM
Thanks. It's working fine now.

LEAD_WEIGHT
12-08-2005, 05:39 PM
Ah, something that is needed. ;)

Advice-Central
12-08-2005, 05:59 PM
I've followed all of the instructions however when I visit /modapp.php the page that appears is blank.

Daniel
12-08-2005, 06:17 PM
Very very nice. I'll be installing when I'm at home. :)

mcyates
12-08-2005, 06:27 PM
in the instructions.txt it says:
in "includes/cpnav_vbulletin.xml" find:

It should say:

in "includes/xml/cpnav_vbulletin.xml" find:

rb290
12-08-2005, 06:43 PM
"includes/cpnav_vbulletin.xml"

im guessing you mean includes/xml/cpnav_vbulletin.xml ?

bashy
12-08-2005, 06:44 PM
Hi

I have just installed this to the T and yet when i click on Apply to be a Mod
I get a blank screen looks like modapp.php is blank....

i also get this error at the top of the screen when i go into edit options in profile and theres no options showing......

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/sites/bashys-place.com/public_html/forums/profile.php(2704) : eval()'d code on line 51

Please advise as this is a really neet modification!!

Bashy

Advice-Central
12-08-2005, 06:50 PM
When you try to delete the application of a particular member it says that phrase maf_deleted could not be found.

mcyates
12-08-2005, 06:56 PM
I get this error:


Warning: Division by zero in /includes/functions.php(4314) : eval()'d code on line 64

rb290
12-08-2005, 06:56 PM
hmm i got a blank screen also when going to /modapp.php

mcyates
12-08-2005, 06:57 PM
the amount of errors in this, it really should be in a BETA stage.

question?
12-08-2005, 07:04 PM
the amount of errors in this, it really should be in a BETA stage.

I agree.

I've been getting a blank page.

sabret00the
12-08-2005, 07:09 PM
I agree.

I've been getting a blank page.

how can you agree when different people have different errors and it's working fine on my board?

anyway i'm checking the xml to make sure the templates are there, i'll get back to you soon.

sabret00the
12-08-2005, 07:09 PM
the amount of errors in this, it really should be in a BETA stage.

are you getting an error?

sabret00the
12-08-2005, 07:10 PM
Hi

I have just installed this to the T and yet when i click on Apply to be a Mod
I get a blank screen looks like modapp.php is blank....

i also get this error at the top of the screen when i go into edit options in profile and theres no options showing......

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/sites/bashys-place.com/public_html/forums/profile.php(2704) : eval()'d code on line 51

Please advise as this is a really neet modification!!

Bashy

this hack doesn't alter the profile or any of the plugins regarding the profile at all.

bashy
12-08-2005, 07:11 PM
Ok sabre...

Look forward to the fix :)

anyway i'm checking the xml to make sure the templates are there, i'll get back to you soon.

Bashy

sabret00the
12-08-2005, 07:12 PM
When you try to delete the application of a particular member it says that phrase maf_deleted could not be found.

do you really care about? the reason i ask is because i can add the phrase but i was guessing no one would care.

sabret00the
12-08-2005, 07:16 PM
Ok sabre...

Look forward to the fix :)



Bashy

ok new zip up, turns out i did forget one of the templates.

sabret00the
12-08-2005, 07:17 PM
I get this error:


Warning: Division by zero in /includes/functions.php(4314) : eval()'d code on line 64



can anyone confirm this as a bug?

sabret00the
12-08-2005, 07:19 PM
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/sites/bashys-place.com/public_html/forums/profile.php(2704) : eval()'d code on line 51uninstall, make sure the error is gone, then reinstall. if it returns, post here.

JWalker05
12-08-2005, 07:20 PM
getting same error.

Warning: Division by zero in /includes/functions.php(4314) : eval()'d code on line 64

sabret00the
12-08-2005, 07:22 PM
getting same error.

Warning: Division by zero in /includes/functions.php(4314) : eval()'d code on line 64

what page is giving you that error?

JWalker05
12-08-2005, 07:24 PM
When trying to view modapp.php

bashy
12-08-2005, 07:26 PM
ok...whats the best way to uninstall this?

Bashy

PS just had one hell of a database error

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Date : Thursday, December 8th 2005 @ 08:46:31 PM
Script : http://www.bashys-place.com/forums/newattachment.php

rb290
12-08-2005, 07:32 PM
thanks, it worked now.
i just re-installed the xml product, thats all we had to do right ?

mcyates
12-08-2005, 07:35 PM
what page is giving you that error?


It was the modapp.php but its ok now as i've updated the produck xml file.

Great hack!!! :)

sabret00the
12-08-2005, 07:36 PM
thanks, it worked now.
i just re-installed the xml product, thats all we had to do right ?

yup if you already run the installer, you're all set.

sabret00the
12-08-2005, 07:37 PM
getting same error.

Warning: Division by zero in /includes/functions.php(4314) : eval()'d code on line 64

try again with the xml, that fixed michaels problem.

sabret00the
12-08-2005, 07:38 PM
ok...whats the best way to uninstall this?

Bashy

PS just had one hell of a database error

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Date : Thursday, December 8th 2005 @ 08:46:31 PM
Script : http://www.bashys-place.com/forums/newattachment.php

go into the product screen, do uinstall, and that's it :)

mcyates
12-08-2005, 07:41 PM
New Error:

Could not find phrase 'maf_rated'.

After you rate the application

sabret00the
12-08-2005, 07:43 PM
New Error:

Could not find phrase 'maf_rated'.

After you rate the application

do you really care for phrase?
if yes i'll add it, if not, i won't bother

bashy
12-08-2005, 07:44 PM
1st thing the error is limited to 1 style only.....

OK...Uninstalled Error still there...

Reinstalled and error still there but the application now works..

Perhaps its something else that is causing this error, how can i find out please?

Bashy

rb290
12-08-2005, 07:44 PM
New Error:

Could not find phrase 'maf_rated'.

After you rate the application

when it tells you it cant find phrases for hacks, just like the one your seeing it usually still works, so just ignore it.

mcyates
12-08-2005, 07:45 PM
I also get this when running the sheduled task


Database error in vBulletin 3.5.2:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1134078190, 0, 1, 0, '', , '', 1134078190, 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 ' '', 1134078190, 1, 0)' at line 2
Error Number : 1064
Date : Thursday, December 8th 2005 @ 04:43:10 PM
Script : http://www.myfootballforum.com/admincp/cronadmin.php?do=runcron&cronid=30
Referrer : http://www.myfootballforum.com/admincp/
IP Address : 86.136.232.70
Username : boro_boy
Classname : vb_database

sabret00the
12-08-2005, 07:52 PM
I also get this when running the sheduled task


Database error in vBulletin 3.5.2:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1134078190, 0, 1, 0, '', , '', 1134078190, 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 ' '', 1134078190, 1, 0)' at line 2
Error Number : 1064
Date : Thursday, December 8th 2005 @ 04:43:10 PM
Script : http://www.myfootballforum.com/admincp/cronadmin.php?do=runcron&cronid=30
Referrer : http://www.myfootballforum.com/admincp/
IP Address : 86.136.232.70
Username : boro_boy
Classname : vb_database


did you configure the vBulletin options?

sabret00the
12-08-2005, 07:53 PM
1st thing the error is limited to 1 style only.....

OK...Uninstalled Error still there...

Reinstalled and error still there but the application now works..

Perhaps its something else that is causing this error, how can i find out please?

Bashy

if it's one style only and that's a child style then it's a template mod gone horribly wrong.

mcyates
12-08-2005, 07:54 PM
did you configure the vBulletin options?

no. I cant see the options

mcyates
12-08-2005, 07:57 PM
the only thing i can see is the Moderator Applicants where i can rate and delete them, thats it.

sabret00the
12-08-2005, 08:00 PM
the only thing i can see is the Moderator Applicants where i can rate and delete them, thats it.

you sure? http://www.yoursite.com/forums/admincp/options.php?do=options&dogroup=maf

that brings up nothing?

mcyates
12-08-2005, 08:03 PM
yup, that link brings nothing up

rb290
12-08-2005, 08:08 PM
yup, that link brings nothing up
what vB version are you running ?

and sabret00the what versions is this allowed for ?

sabret00the
12-08-2005, 08:08 PM
yup, that link brings nothing up

uninstall the plugin then reinstall it. i can see em in the xml so they should come up.

Dan
12-08-2005, 08:24 PM
did you configure the vBulletin options?

sabe getting the same issue and there are no vBulletin Options.

Oblivion Knight
12-08-2005, 08:31 PM
do you really care for phrase?
if yes i'll add it, if not, i won't botherOf course! Who wants an incomplete addon installed on their forums?

I don't.. :p

sabret00the
12-08-2005, 08:35 PM
ok current zip fixes the latest problem, time to add the phrases :(

mcyates
12-08-2005, 08:45 PM
what vB version are you running ?

and sabret00the what versions is this allowed for ?

i'm using vb 3.5.2

mcyates
12-08-2005, 08:46 PM
uninstall the plugin then reinstall it. i can see em in the xml so they should come up.

ok i'll give it a go

Andreas
12-08-2005, 08:49 PM
@sabret00the
I suggest you to read these threads :)
https://vborg.vbsupport.ru/showthread.php?t=101330
https://vborg.vbsupport.ru/showthread.php?t=82698
https://vborg.vbsupport.ru/showthread.php?t=92953

sabret00the
12-08-2005, 08:51 PM
ok the vBoptions are there as of build D, the missing phrases are there as of Build E. anything else?

mcyates
12-08-2005, 08:52 PM
nope still nothing. Hmm weird.

sabret00the
12-08-2005, 08:54 PM
nope still nothing. Hmm weird.

gah? it's working for someone else? you got 1.5.0e.zip right?

sabret00the
12-08-2005, 08:56 PM
@sabret00the
I suggest you to read these threads :)
https://vborg.vbsupport.ru/showthread.php?t=101330
https://vborg.vbsupport.ru/showthread.php?t=82698
https://vborg.vbsupport.ru/showthread.php?t=92953

and there was me thinking you was gonna offer to takeover the hack :p

in all honesty i was gonna do the recoding i.e. using the API for the thread creation but i just couldn't be bothered it's been a long day, if you check the product it's called MAS and that was my intention to record, and add features like making questions customizable but then my day got shit and i just couldn't be bothered.

bashy
12-08-2005, 09:02 PM
Hi peeps

This is working really well for me, im running VB 3.5.2

*clicks install*

Thanks Sabre

Dan
12-08-2005, 09:02 PM
Yep it's working fine now as of 1.5e thanks man.

4number8
12-08-2005, 09:08 PM
Thank you sabret00the, installed very easily and quick....wish they were all as easy as this one ;)

mcyates
12-08-2005, 09:11 PM
gah? it's working for someone else? you got 1.5.0e.zip right?
yes but when i downloaded version "e" i only uploaded the xml file. I'll upload the whole lot now. I';ll uninstall first though.

mcyates
12-09-2005, 07:54 AM
updated EVERYTHING with the latest version and it all works.

Thank Youi

Snake
12-09-2005, 08:03 AM
Sweet like a candy! Thanks.

mcyates
12-09-2005, 08:10 AM
when do the messages get posted in the designated forum for the ratings? I applied using another account, to become moderator. I then logged out, logged back in as admin, rated the application in the admincp and check the designated forum, and it had NO post in it.

Thanks in advance

sabret00the
12-09-2005, 09:26 AM
when do the messages get posted in the designated forum for the ratings? I applied using another account, to become moderator. I then logged out, logged back in as admin, rated the application in the admincp and check the designated forum, and it had NO post in it.

Thanks in advance

the thread will be made daily (conditions permitting) at the time you set it to be made.

Snake
12-09-2005, 10:38 AM
Is there any live demo?

ShadowOne
12-09-2005, 11:16 AM
how long does it take to post it in the forum i specified?

ShadowOne
12-09-2005, 11:17 AM
^ Nevermind I Just Saw The Answer...lol

scotsnutta
12-09-2005, 05:13 PM
i'm really quite new here so please excuse me when i say i couldn't follow the install instructions, perhaps you could make them a tad clearer???

murrtex
12-10-2005, 01:39 AM
great thanks,
when the user apply this form,system should warn the other moderators by PM and e-mail. and they must rate it.
is it possible??

and what is the results time? i mean is there any finish time or when I want??

and it should be a mew thread about MAF (only can see mod,supermod and admins)

tippen
12-10-2005, 12:15 PM
I think that I am getting a unique error from all of you. When I try to go to the installer, it asks me to login. After I do so, I get the success message, then this:
Fatal error: Call to undefined function: query() in /home/***/domains/***/public_html/forums/install/his_files/hack_install_b3.php on line 48
I had a look at the code in that file (hack_install_b3.php). It seems like it might need PHP5? At least the connect sequence looks new. Is this so? I'm running PHP4-stable-latest.

I am very interested in this hack! :)

sabret00the
12-10-2005, 12:25 PM
I think that I am getting a unique error from all of you. When I try to go to the installer, it asks me to login. After I do so, I get the success message, then this:
Fatal error: Call to undefined function: query() in /home/***/domains/***/public_html/forums/install/his_files/hack_install_b3.php on line 48
I had a look at the code in that file (hack_install_b3.php). It seems like it might need PHP5? At least the connect sequence looks new. Is this so? I'm running PHP4-stable-latest.

I am very interested in this hack! :)

hack_install_b3.php isn't part of this hack in any way which form, you sure you haven't downloaded an old version?

magnus
12-10-2005, 06:36 PM
hack_install_b3.php isn't part of this hack in any way which form, you sure you haven't downloaded an old version?

I just attempted to install this, and I'm getting the same error.

Fatal error: Call to undefined function: query() in /home/*/www/*/forum/install/his_files/hack_install_b3.php on line 48

tippen
12-10-2005, 08:04 PM
hack_install_b3.php isn't part of this hack in any way which form, you sure you haven't downloaded an old version?
I clicked the link in the first post in this thread, which appears at the side. The file I got is titled: MAF (Moderator Application Form & Application Rating Module).zip, while the links says something different.

Help? :)

Edit: Clicking the link again, appears to return a file with the proper title. I suggest downloading again to all users encountering this bug. Must be a vb.org bug! Disss! :ermm:

LBSources
12-11-2005, 12:26 AM
OoooOpPPPS!

Disregard! thanks..

Thanks!

Lenny :)

ReZ
12-11-2005, 08:22 AM
Does this work with vB Version: 3.5.2?

sabret00the
12-11-2005, 08:34 AM
Does this work with vB Version: 3.5.2?

yes it does.

sabret00the
12-11-2005, 08:36 AM
great thanks,
when the user apply this form,system should warn the other moderators by PM and e-mail. and they must rate it.
is it possible??

and what is the results time? i mean is there any finish time or when I want??

and it should be a mew thread about MAF (only can see mod,supermod and admins)

all your questions are answered in the faq.

ShadowOne
12-11-2005, 03:51 PM
Works Great Man... I Need Some Help With A Hack I Already Have, Think You Can Help Me? Cuz The Developer Says Theres No Way To Do It When I Know There Is, He Got His Money, ANd Now He Wont Help Me..:(

AnthonyIsDope
12-11-2005, 11:53 PM
theres sumthin wrong wit da mas_installer.php

AnthonyIsDope
12-11-2005, 11:53 PM
Database error in vBulletin 3.5.2:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

mindtrix25
12-12-2005, 03:42 AM
Nothing too bad here. Over all a nice form but needs some improvements, such as the GMT Feild should be a drop-down menu and not a 'string'. As well as age should be in the form of Date of Birth DD/MM/YYYY.

One bug I noticed, however am not sure if it is just because of a conflict in versions as I currently use vB 3.5.1 however when I choose to rate or delete an application, the CONTROL PANEL STOP MESSAGE page gives me an error:

Could not find phrase 'maf_deleted'.

I checked the phrase options and the feild does exist, but as I am not an advanced coder I am un-able to find a solution to why this error occurs. Everything DOES work, and seems to be in order with the exception of that little bug.

notsonormal
12-12-2005, 04:43 AM
Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1134369650, 164, 1, 0, '', , '', 1134369650, 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 ' '', 1134369650, 1, 0)' at line 2
Error Number : 1064
Date : Sunday, December 11th 2005 @ 10:40:51 PM
Script : http://www..com/forum/admincp/cronadmin.php?do=runcron&cronid=22
Classname : vb_database

ReZ
12-12-2005, 09:21 AM
I installed this hack, it's just what i needed! Thanks.

ragintajin
12-20-2005, 02:35 AM
So wait, can we customize the application questions?

Rich
12-20-2005, 10:06 AM
Hello,

You can modify the questions by editing the code directly.

seany1
12-20-2005, 09:04 PM
Thanks sabre seen this for version 3.0.x thought it would have been ages before seeing it for this version, thanks

Installed :)

ragintajin
12-22-2005, 03:02 AM
How do you undo the changes made from running mas_installer.php?

brvheart
12-22-2005, 11:21 AM
I get this upon upload of the .xml product....

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'maf_username',
'maf',
'',
'',
'free',
'',
10,
0,
1,
'modappsys'
),
(
'maf_forumid',
'maf',
'',
'',
'number',
'',
20,
0,
1,
'modappsys'
);

MySQL Error : Duplicate entry 'maf_username' for key 1
Error Number : 1062

any help please?

slvr ralliart
12-22-2005, 10:00 PM
I have the mod application installed, and everything is right meaning all the files are where they should be, edited the xml file.

With that said, when a person enters their mod application, I see it listed then I go to delete the applications entering the users name of the app.

I get this pop up msg saying:

could not find phrase 'maf_deleted"

it does delete the application. Why am I seeing the could not find pharse?

sabret00the
12-22-2005, 10:08 PM
Database error in vBulletin 3.5.2:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

i need the exact error message. that's only a partial error message.

sabret00the
12-22-2005, 10:09 PM
Nothing too bad here. Over all a nice form but needs some improvements, such as the GMT Feild should be a drop-down menu and not a 'string'. As well as age should be in the form of Date of Birth DD/MM/YYYY.

One bug I noticed, however am not sure if it is just because of a conflict in versions as I currently use vB 3.5.1 however when I choose to rate or delete an application, the CONTROL PANEL STOP MESSAGE page gives me an error:

Could not find phrase 'maf_deleted'.


I checked the phrase options and the feild does exist, but as I am not an advanced coder I am un-able to find a solution to why this error occurs. Everything DOES work, and seems to be in order with the exception of that little bug.

not sure what that's about, i'll look into it. in regards to drop downs and other such things. really depends on my mood when i'm next over this file with the php pen out.

sabret00the
12-22-2005, 10:13 PM
Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1134369650, 164, 1, 0, '', , '', 1134369650, 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 ' '', 1134369650, 1, 0)' at line 2
Error Number : 1064
Date : Sunday, December 11th 2005 @ 10:40:51 PM
Script : http://www..com/forum/admincp/cronadmin.php?do=runcron&cronid=22
Classname : vb_database

you never set the username and forumid

sabret00the
12-22-2005, 10:14 PM
So wait, can we customize the application questions?

nope you can't. well you can but you can only do it by hacking the hack.

sabret00the
12-22-2005, 10:18 PM
How do you undo the changes made from running mas_installer.php?

run these two queries

DROP TABLE `maf_application`

DROP TABLE `maf_ratings`

sabret00the
12-22-2005, 10:18 PM
I get this upon upload of the .xml product....

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'maf_username',
'maf',
'',
'',
'free',
'',
10,
0,
1,
'modappsys'
),
(
'maf_forumid',
'maf',
'',
'',
'number',
'',
20,
0,
1,
'modappsys'
);

MySQL Error : Duplicate entry 'maf_username' for key 1
Error Number : 1062


any help please?

you tried uninstalling the plugin, then reinstalling?

sabret00the
12-22-2005, 10:20 PM
I have the mod application installed, and everything is right meaning all the files are where they should be, edited the xml file.

With that said, when a person enters their mod application, I see it listed then I go to delete the applications entering the users name of the app.

I get this pop up msg saying:

could not find phrase 'maf_deleted"

it does delete the application. Why am I seeing the could not find pharse?

i have no idea where that phrase has gone missing too but it doesn't effect the hack, on the next update i'll fix the problem :)

brvheart
12-22-2005, 11:45 PM
you tried uninstalling the plugin, then reinstalling?


Yes I did that 3 times :-/ same error everytime....

slvr ralliart
12-23-2005, 03:26 AM
i have no idea where that phrase has gone missing too but it doesn't effect the hack, on the next update i'll fix the problem :)
sounds good

and one more, show me a screen shot of what a forum id is?

thanks

bashy
12-23-2005, 10:27 PM
Hi peeps

When i click on the Apply to be a mod link i get this error..

print_standard_error(...)
is now redundant. Instead, use
standard_error(fetch_error(...))

Please advise?

Regards

Bashy

EDIT: I ran the installer again and all is fine now :) thanks for looking

Andyrew
12-25-2005, 08:37 AM
If you don't put a tick in the box i agree to the rules and press apply, you just get a blank screen.
Should this come up with a message or something. ???

YOimYO
12-26-2005, 08:44 AM
everything is working fine except for the cannot find maf_rated ......

is there a fix for this yet ?


very nice work though :D Nice Job !!!

bashy
12-26-2005, 01:37 PM
Hi peeps

I have this installed and working well.......

I want to set the schedule task to be performed every day but cannot do this due to...

When any 1 mod has read the application, and the task looks again for more applications it still picks up the one where its already posted a thread about and will keep doing this untill the application has been deleted...

Is there away around this so that as soon as it read by 1 person then it will not be attached as another thread??

Regards

Bashy

YOimYO
12-26-2005, 02:21 PM
Hi peeps
When any 1 mod has read the application, and the task looks again for more applications it still picks up the one where its already posted a thread about and will keep doing this untill the application has been deleted...

Is there away around this so that as soon as it read by 1 person then it will not be attached as another thread??

Regards

Bashy

Yes Bashy I have also noticed the same thing. Its a lovely addition though. If this could be fixed it would be great ! anyhow. just installed it yesterday. and have tested it to only find only two little things wrong :)

good job again ;)

djjeffa
12-28-2005, 11:21 PM
This is what i get when i try to install
I hade it when i had 3.0.8 now i have 3.5.2
Database error in vBulletin 3.5.2:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

MySQL Error : Table 'maf_application' already exists
Error Number : 1050
Date : Wednesday, December 28th 2005 @ 07:11:10 PM
Script : http://djjeffa.com/vb/mas_installer.php
Referrer :
IP Address : 68.82.83.116
Username : djjeffa
Classname : vb_database

i se no derections for upgrading.

bashy
12-30-2005, 12:55 PM
Hi peeps

Here another small issue..

When the staff has rated an application, where can we see the comments?
When we rated the application, click save it then just gives us the choice to rate it again, what gives?

Regards

Bashy

djjeffa
12-31-2005, 07:28 PM
Bumppppppp
This is what i get when i try to install
I hade it when i had 3.0.8 now i have 3.5.2
Database error in vBulletin 3.5.2:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

MySQL Error : Table 'maf_application' already exists
Error Number : 1050
Date : Wednesday, December 28th 2005 @ 07:11:10 PM
Script : http://djjeffa.com/vb/mas_installer.php
Referrer :
IP Address : 68.82.83.116
Username : djjeffa
Classname : vb_database

i se no derections for upgrading.

sabret00the
12-31-2005, 07:33 PM
theirs no need to bump, just acknowledge it's the holidays and that chances are i'd rather be having a life outside of supporting a free product.

to answer your question, theirs no need to run the installer if you had a previous installation as all the tables that are required already exist.

sabret00the
12-31-2005, 07:33 PM
Hi peeps

Here another small issue..

When the staff has rated an application, where can we see the comments?
When we rated the application, click save it then just gives us the choice to rate it again, what gives?

Regards

Bashy

i'll look into that.

bashy
12-31-2005, 07:36 PM
Cheers m8...

It looks like once all staff have rated it then closes and shows the comments,
Could do with seeing them before the close :)

Happy New Year Sabre

Bashy

bashy
01-03-2006, 06:32 PM
Just to add to this, It looked like once the next scheduled task it stops being able to view the comments again and we have to rate it to be able to view them :(

Bashy

Happy New Year

sabret00the
01-05-2006, 10:19 AM
Just to add to this, It looked like once the next scheduled task it stops being able to view the comments again and we have to rate it to be able to view them :(

Bashy

Happy New Year

so it only shows staff comments sometimes?

bashy
01-05-2006, 03:33 PM
Yes m8, untill all staff have reviewed it...
Its a strange 1, Tell ya what leave what ive said for now
As i cannot quite remember what happens..

Im gonna do a test in a bit and see whats what, then will get
back to you :)

Bashy

mackers8923
01-10-2006, 07:41 PM
Will this run with 3.5.3?

I've tested an install but the cp nav screws up by admincp and nothing appears in the rating screen while testing!!!

GreysAnatomy
01-11-2006, 02:33 PM
I was wondering too if it works with 3.5.3 as I can't seem to get it right. But I'm not an expert and it could very well be my own fault.

Anyway, I followed your instructions and got a blank page when I went to .../forums/modapp.php

I tried d/ling the .zip file again [as suggested by someone], re-uploaded everything and also created a new template called 'modapp' in my parent style with the code you provided in the .zip file, but I still get that blank page. Can anyone help me please - and in dummy language as I'm really not that familiar with hacks. :o

TTG
01-11-2006, 05:10 PM
Just installed on 3.5.3 and had no problems :)
Clicked install.

Reminder
01-15-2006, 07:36 PM
Thanks.

agiacosa
01-19-2006, 01:25 PM
Can this somehow be limited to users with a certain minimum posts?

brvheart
01-22-2006, 02:19 AM
Saber...just tried again, and got the same error as before


Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'maf_username',
'maf',
'',
'',
'free',
'',
10,
0,
1,
'modappsys'
),
(
'maf_forumid',
'maf',
'',
'',
'number',
'',
20,
0,
1,
'modappsys'
);

MySQL Error : Duplicate entry 'maf_username' for key 1
Error Number : 1062

any help on this please?

Dreamchaser
01-22-2006, 05:11 AM
Works Charming in vb3.5.3 !! Will click Install :)!

Vizionz
01-22-2006, 05:25 AM
i dont know what your doing that i am not but once i make the xml edit it totally kills the admincp nav

redspider
01-27-2006, 05:01 PM
Hello. I am having a problem. I am currently using vB Version 3.5.0...I installed this hack and must say it works perfectly, except for one MAJOR issue...After i installed and went to my Admin CP, i now have virtually few nav links. Same prob for other admins on the site...Can someone please tell me what happened? Below is a screenie of what nav links i now have. I dont even have my Plugin options to uninstall the plugin...Help? Please? Other than that, awesome hack...Be well -

redspider
01-27-2006, 06:02 PM
Another question...I did a database restore to revert to before i installed the Mod Application System...So my site is back to norm in that aspect. The question i have is, in the install instructions you started with,

forums/modapp.php
forums/admincp/maf_delmodapp.php
forums/modcp/maf.. rahdy rar etc

However, you did not mention the forums\includes\cron\maf_cron.php file directory...I am supposed to add that one as well right? Im sure i am but needed to know for sure, to be sure this was/wasnt the reason i lost my Admin CP nav links.

Thanks for any feedback, and i still need to know where i went wrong as specified in my previous post. Any help would be greatly appreciated as i really need the Mod Application System incorporated into my site. Be well -

agiacosa
01-30-2006, 09:20 AM
Saber,

Any word on this? Would really like to institute it but am concerned with the admincp issues.

Thanks.

sabret00the
01-30-2006, 09:24 AM
Can this somehow be limited to users with a certain minimum posts?

don't get what you mean?

agiacosa
01-30-2006, 09:25 AM
A member cannot apply unless they have 500 posts.

sabret00the
01-30-2006, 09:26 AM
Saber...just tried again, and got the same error as before




any help on this please?


ok, my advice to you would be;
uninstall the plugin
backup your forums
then run this query before installing again.

DELETE
FROM vb3_setting
WHERE varname = 'maf_username'

sabret00the
01-30-2006, 09:28 AM
ok to people with the admincp nav problem, sadly i will not get a chance to test this out on vb3.5.3 in order to try and duplicate your problem before the end of the week, i've been that busy :( i would leaving this uninstalled till then, especially as it only seems ot be afflicting some people.

sabret00the
01-30-2006, 09:32 AM
Another question...I did a database restore to revert to before i installed the Mod Application System...So my site is back to norm in that aspect. The question i have is, in the install instructions you started with,

forums/modapp.php
forums/admincp/maf_delmodapp.php
forums/modcp/maf.. rahdy rar etc

However, you did not mention the forums\includes\cron\maf_cron.php file directory...I am supposed to add that one as well right? Im sure i am but needed to know for sure, to be sure this was/wasnt the reason i lost my Admin CP nav links.

Thanks for any feedback, and i still need to know where i went wrong as specified in my previous post. Any help would be greatly appreciated as i really need the Mod Application System incorporated into my site. Be well -

add the cron file to what? sorry i'm having a blonde moment and have gotten a little confused.

sabret00the
01-30-2006, 09:34 AM
A member cannot apply unless they have 500 posts.

oh right, yes that can be done.

agiacosa
01-30-2006, 10:04 AM
Hello. I am having a problem. I am currently using vB Version 3.5.0...I installed this hack and must say it works perfectly, except for one MAJOR issue...After i installed and went to my Admin CP, i now have virtually few nav links. Same prob for other admins on the site...Can someone please tell me what happened? Below is a screenie of what nav links i now have. I dont even have my Plugin options to uninstall the plugin...Help? Please? Other than that, awesome hack...Be well -

Can you tell us how you did the edit to cpnav_vbulletin.xml?

redspider
02-05-2006, 06:11 AM
Can you tell us how you did the edit to cpnav_vbulletin.xml?
I finally figured out what my problem was concerning the loss of my ACP Nav links...It seems that when i read the install text, i didnt follow one part of a step...Lemme explain, The install text says,

in "includes/xml/cpnav_vbulletin.xml" find:
=======================================
</navgroups>

<!-- CVS: $RCSfile: cpnav_vbulletin.xml,v $ - $Revision: 1.16 $ -->

Well simple enough except when i replaced the code, i forgot to also replace
</navgroups>

I only replaced,
<!-- CVS: $RCSfile: cpnav_vbulletin.xml,v $ - $Revision: 1.16 $ -->

So needless to say, this was my problem...

However, i have the system installed, works wonderfully, but i am curious, where in the heck does the application go after a member fills it out?

I went into the ACP/vBulletin Options/Moderation Application System and set,
Please enter the username of the person who will start the threads for rating.
to a specific username, and i set,
Please enter for the forum id of the forum you want the threads to appear in
to a specific Forum but once a user applies, nothing appears in the designated forum.

Also, when a user applies and clicks submit, it gives an error saying,
maf_rated cannot be found.
As well as when i delete applications i get the,
maf_deleted cannot be found.
I looked in the zip folder containing the system i downloaded from here, but i didnt see either of these files. Any help would be greatly appreciated...Thank you for your replies...Be well -

bashy
02-05-2006, 07:22 AM
Hi

The cron job is set weekly i think...
You can go into your scheduled tasks and run the MAF manually or set it lower....

Then the application will show up on the thread that you set, well actually it
will only tell you that there is one and you have to goto your admicp or modcp to read it.

Its right at the bottom of ya admincp

but i am curious, where in the heck does the application go after a member fills it out?

redspider
02-05-2006, 02:49 PM
add the cron file to what? sorry i'm having a blonde moment and have gotten a little confused.
You did not specify in your install instructions where to upload the maf_cron.php, but obviously it must be placed in the folder
forums/includes/cron directory. Your install instructions should start with,
forums/modapp.php
forums/admincp/maf_delmodapp.php
forums/modcp/maf_rateapp.php
forums/includes/cron/maf_cron.php
I overlooked it first time as i was strictly following your install notes and did not upload maf_cron.php into the cron directory. I have uploaded it since that post so no biggie...You may want to edit your install txt and add mention of that file as well because it can be somewhat confusing for some peeps. Its ok to have blonde moments, we all have them, for me is quite often hehehe

The cron job is set weekly i think...
You can go into your scheduled tasks and run the MAF manually or set it lower....
Thank you bashy for tipping me about running the cron manually. Doing this does make the thread show in the designated forum. But what do you mean the cron job is set to weekly? It is set to *

=======================================
Title: MAF
Day of the week: *
Day of the month: *
Hour: 12
Minute: 30 - - -
Log Entries: Yes
Filename: ./includes/cron/maf_cron.php
=======================================

Do you mean i should set the Hour lower? or can i change and set the Hour to * and Minute to make it run a cron every x minutes? Thank you for your replies and help...This is a wonderful hack if i can get it tweaked to run the cron on app submit or every x minutes...Be well

LincolnForums
02-06-2006, 08:02 PM
Hello. I am having a problem. I am currently using vB Version 3.5.0...I installed this hack and must say it works perfectly, except for one MAJOR issue...After i installed and went to my Admin CP, i now have virtually few nav links. Same prob for other admins on the site...Can someone please tell me what happened? Below is a screenie of what nav links i now have. I dont even have my Plugin options to uninstall the plugin...Help? Please? Other than that, awesome hack...Be well -


I have this problem as well, and i did replace everything it said to replace. Totally destroyed the admincp - So i skiped this step..


I access the apps thru typing out the links instead for now.

Also missing a phras maf_rated, and maf_deleted. Not sure what else.

Sai01
02-08-2006, 01:31 AM
so, how do you go about changing the moderators rules/ agreements and all the form questions?

Sai01
02-08-2006, 01:59 AM
edit: i don't know what i just did, now everything is mess up... so i just reinstall it. seems to work fine again. how do i change the form questions and the moderator rules?

Dreamchaser
02-10-2006, 03:32 PM
I have a small issue with this,once I complete the rating, it shows me the following error !

vBulletin Message

Could not find phrase 'maf_rated'.

Can you look into this ? Also take a look at the attachment :surprised:

bashy
02-10-2006, 03:38 PM
This has been mentioned many times...
It appears to be non important, its just a phrase missing
Nothing to worry about all does work ok still!!

Dreamchaser
02-10-2006, 03:47 PM
This has been mentioned many times...
It appears to be non important, its just a phrase missing
Nothing to worry about all does work ok still!!

Yea Bashy,

I just browsed all the 10 pages and the author seems to ignore this, a complete hack is one which does have any errors, but I did search for the phrase in the vb admincp, it does exist but I or we are not sure why it says it does not ?

May be he can help us fix this issue as to why it does so ? :ermm:

CrazyShooter
02-10-2006, 06:50 PM
What does this do?

Username
Please enter the username of the person who will start the threads for rating.

Forum ID
Please enter for the forum id of the forum you want the threads to appear in

Ntfu2
02-10-2006, 06:56 PM
I installed this and have the following problems

1. Missing phrases, but i fixed that by adding them
2. It will tell my members they have already filled out the application, even though they haven't. This has happened about 4 out of 15 times now.

Sai01
02-11-2006, 07:29 AM
2. It will tell my members they have already filled out the application, even though they haven't. This has happened about 4 out of 15 times now.
maybe your user is using the same IP? like if they are using it from a school computer or something and someone already submitted with that IP...

anyways... my questions...
. how do i change the form questions and the moderator rules?
???

Ntfu2
02-11-2006, 03:58 PM
maybe your user is using the same IP? like if they are using it from a school computer or something and someone already submitted with that IP...

anyways... my questions...

???

that'd be dumb if this went on a IP basis and not a username...and the people arent on the same ip, i checked

Yukino_AE
02-11-2006, 10:46 PM
i had this installed on vb3.0.7. i removed it from the db when i upgraded. i followed all the intructions and i run the installer and it goes through creates the db files and says done, and then modify the files. yet when i go to upload the product-modappsys.xml it just gives me an error:

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'maf_username',
'maf',
'Yukino',
'',
'free',
'',
10,
0,
1,
'modappsys'
),
(
'maf_forumid',
'maf',
'68',
'',
'number',
'',
20,
0,
1,
'modappsys'
);

MySQL Error : Duplicate entry 'maf_username' for key 1
Error Number : 1062
Date : Saturday, February 11th 2006 @ 04:46:52 PM
Script : http://anime-extreme.net/forum/admincp/plugin.php
Referrer : http://anime-extreme.net/forum/admincp/plugin.php?do=productadd
IP Address : 24.71.223.141
Username : Yukino
Classname : vb_database


and if you go to the manage products after that it shows up there.

and if you actually go to the modd app it's not inside any of the templates.

http://www.anime-extreme.net/forum/modapp.php

and i don't see where we can approve the mod applications as there is nowhere to have it added into the admincp. like in the last one on the left side where it gives you all your list of vb options it had a maf option now there's not one.

please help!

LiveMicSociety
02-16-2006, 01:59 PM
Installed :up:

This modification does work [although i do get errors, which have been mentioned by most other people, such as cannot find maf_deleted or maf_rated]

I also get this error on one certain application when i attempt to delete it:Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE
FROM maf_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
Date : Thursday, February 16th 2006 @ 10:54:38 AM
Script : http://www.livemicsociety.com/forum/admincp/maf_delapp.php
Referrer : http://www.livemicsociety.com/forum/admincp/maf_delapp.php
Classname : vb_databaseAny help would be appreciated ^

Langly
02-20-2006, 02:17 AM
Is it possible to have have the cron set to every 5 hours or so and only have to post a post if its a NEW applicant in the system?

Hornstar
03-01-2006, 02:53 AM
Is it possible to have have the cron set to every 5 hours or so and only have to post a post if its a NEW applicant in the system?


i guess you can make the cron job as often as you like and im assuming if there is nothing for it to do then it wont do anyhing

or would that lag the forum?



When you get the message in your thread

"Their are new moderator applications that need rating, please go and rate them, if need be return here to discuss them further."

I think it should say

Their are new moderator applications that need rating, please go and rate them in your modcp, if need be return here to discuss them further.



That would be better.

I also wouldnt mind getting rid of those few errors that are appearing for every member.


and i just want to confirm this.

If a member gets below 7 after 2 weeks, then they get emailed/pmed and told they are not accepted? (is it only email or is it both pm and email, and is that question true)

What happens if they are above 7 after 2 weeks? what happens then?


Also if i want to change some of the application to suit my board, what do i edit? are they phrases? And what happens if i want to add another question and box for them to write in, how do i do that?


Thanks

The Realist
03-03-2006, 07:31 PM
On rating a application, I get this error "Could not find phrase "maf_rated".

Any ideas?

Laters

Ziki
03-03-2006, 08:36 PM
How to add that rate applications to admincp cause when I do the required file edit it ruins my admincp.How that?

The Realist
03-03-2006, 09:08 PM
Are you editing the file correctly?

I boobed the 1st time I did it and my admincp buggered up because I did not follow these instructions:


in "includes/xml/cpnav_vbulletin.xml" find:
=======================================
</navgroups>

<!-- CVS: $RCSfile: cpnav_vbulletin.xml,v $ - $Revision: 1.16 $ -->
=======================================

and replace with:
=======================================
<navgroup phrase="mod_applicant" hr="true" displayorder="270">

<navoption displayorder="10">
<phrase>rate_apps</phrase>
<link>../{$vbulletin->config[Misc][modcpdir]}/maf_rateapp.php?do=list</link>
</navoption>

<navoption displayorder="20">
<phrase>del_apps</phrase>
<link>maf_delapp.php?do=del</link>
</navoption>

</navgroup>

</navgroups>

<!-- CVS: $RCSfile: cpnav_vbulletin.xml,v $ - $Revision: 1.16 $ -->


Laters

Ziki
03-04-2006, 07:58 AM
Are you editing the file correctly?

I boobed the 1st time I did it and my admincp buggered up because I did not follow these instructions:



Laters


OK works now.I forgot to rewrite <navgroups/>.Thanx a lot.I should read the whole code first

proxx
03-05-2006, 09:23 AM
I'm getting this error when running the CRON, please help:



atabase error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1141557671, 52, 1, 0, '', , '', 1141557671, 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 ' '', 1141557671, 1, 0)' at line 2
Error Number : 1064
Date : Sunday, March 5th 2006 @ 05:21:11 AM

The Realist
03-06-2006, 12:45 PM
How is the votes calculated?
Can the 14 day limit be changed?

Laters

Jon.
03-07-2006, 07:26 PM
I also get that maf_rated thing, but it's causing problems. I commented on someone's application, and now it's disappeared. That was via the admin panel, and via the mod panel it never adds my comment.

Drewish
03-08-2006, 11:08 PM
Database error in vBulletin 3.5.4:

Invalid SQL:

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

^This is when I attempt to run the scheduled task after submitting a test application. Not compatible with vB 3.5.4?

Treak
03-10-2006, 04:49 AM
i get this error! any help

this is when i run the installer

i have done everything else. since yhis to see if it helpos but does not!

Database error in vBulletin 3.5.0:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

MySQL Error : Table 'maf_application' already exists
Error Number : 1050
Date : Thursday, March 9th 2006 @ 10:48:32 PM
Script : http://www.lokiart.com/forums/mas_installer.php
Referrer :
IP Address : 24.12.228.89
Username : Smallville
Classname : vb_database

Stone Cold 3:16
03-11-2006, 02:10 AM
I wanna install, but sounds very glitchy, any yesses and nos?

portalimiz
03-11-2006, 09:16 AM
this hack does not work from the page 1
and no solution is created for 11 pages
IRONIC

Treak
03-14-2006, 09:58 PM
yeha i agree.. some help to the solution of this problem would be appriciated!

David_R
03-22-2006, 12:38 PM
how to upgrade from 3.x version to 3.5.x for this hack ?
i am getting this error: https://vborg.vbsupport.ru/showpost.php?p=920646&postcount=156

morever, all the tables on my forum have a prefix, but while creating new tables this hack ignore the table prefix. please fix this problem

LBSources
03-28-2006, 01:30 PM
How is the votes calculated?
Can the 14 day limit be changed?

Laters
edit /forums/includes/cron/maf_cron.php

find


// Email users who we're declining.
if ($day >= 14 AND $avg < 7)



and

// Email users who we're shortlisting.

if ($day >= 14 AND $avg > 7 AND $auto_mailed == "")

and modify as needed .. i have mine set to 7 days with a <8 & 8> for average rating.. then re-upload the file

then modify the phrase maf_thanks so that folks arent thinking they have to wait 2-3 weeks for a response from you or the team

The Realist
03-28-2006, 01:43 PM
Do you mean:

// Email users who we're declining.

if ($day >= 7 AND $avg < 7)

Or

// Email users who we're declining.

if ($day >= 8 AND $avg < 8)

As you state below?

Also, how do you change the rating side of things from 7?

Laters

edit /forums/includes/cron/maf_cron.php

find


// Email users who we're declining.
if ($day >= 14 AND $avg < 7)



and

// Email users who we're shortlisting.

if ($day >= 14 AND $avg > 7 AND $auto_mailed == "")

and modify as needed .. i have mine set to 7 days with a <8 & 8> for average rating.. then re-upload the file

then modify the phrase maf_thanks so that folks arent thinking they have to wait 2-3 weeks for a response from you or the team

LBSources
03-28-2006, 02:04 PM
its right there ..

if ($day >= 14 AND $avg > 7 AND $auto_mailed == "")

greater then 14 days and an average rating of 7 mail the member

what i meant about my setup is

$avg < 8
$avg > 8

lightwave
03-28-2006, 10:47 PM
i get this error! any help

this is when i run the installer

i have done everything else. since yhis to see if it helpos but does not!

Database error in vBulletin 3.5.0:

Invalid 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` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`appid`)
);

MySQL Error : Table 'maf_application' already exists
Error Number : 1050
Date : Thursday, March 9th 2006 @ 10:48:32 PM
Script : http://www.lokiart.com/forums/mas_installer.php
Referrer :
IP Address : 24.12.228.89
Username : Smallville
Classname : vb_database


i got same error

The Realist
03-29-2006, 12:36 AM
The error is because of this "Table 'maf_application' already exists"

Remove the table 'maf_application'

Laters

Burley
03-31-2006, 07:40 PM
This hack looks nice and realy usefull.

But when I use the installer mas_installer.php I get the following error;


Warning: Unknown(): Unable to access /home/p8ntball/public_html/test_forum/forum/includes/functions_warning.php in /global.php(349) : eval()'d code on line 6

Warning: Unknown(/home/p8ntball/public_html/test_forum/forum/includes/functions_warning.php): failed to open stream: No such file or directory in /global.php(349) : eval()'d code on line 6

Fatal error: (null)(): Failed opening required '/home/p8ntball/public_html/test_forum/forum/includes/functions_warning.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/p8ntball/public_html/test_forum/forum/global.php(349) : eval()'d code on line 6

Which sounds logical to me, since there is no function_warning.php at all in my folders :s

I'm using version 3.5.4, has anyone succesfully installed it on this version?
And if so what did you do different and where did you get the function_warning.php from?!

oh btw, I keep getting this error now and can't seem to login/view my board at all......

rareclownfish
04-05-2006, 02:10 AM
Does this work on 3.5.4?

Burley
04-05-2006, 07:27 AM
it should, but it doesn't

ShadowOne
04-05-2006, 12:50 PM
Before i wiped out my board and started over, i installed this hack and everything worked fine...im not u nderstanding why everyone is having so much trouble, its making me not want to install it again...

Burley
04-05-2006, 12:58 PM
which vb version did you use then? I'm thinking that something changed since 3.5.1 and that's the reason. But I'm unsure!

I send sabrtoothe a pm with a few questions some days ago, not judgemental or something, but he has not responded jet. Perhaps we can solve it together.

kurtbarker
04-08-2006, 12:31 PM
in regards to change after 3.5.1, i've seen a few modifications that say only for 3.5.3 up, so that's where some things may have been altered. however I have a few hacks installed on my 3.5.1 board that were designed for 3.5.3/3.5.4

now for my question... I run a club, and have a committee election coming up, I would love to use a system like this to allow people to apply for the positions... Any chance of being able to have a drop down list for what you want to apply for [pre-defined], somewhere up the top of the form?. Obviously without the Moderator application heading because they won't be what they are applying for...

I know this is probably a big ask, but if anyone can write the code to allow for the drop down box and post it here and where to put it, i'd really application it...

With approval from sabret00the to alter the modification... please mate???

thanks guyz,
Kurt

Burley
04-08-2006, 01:51 PM
For that sabretooth has to respond to any communication first or post somewhere around here, somehow I don't think that that's going to happen very soon....

Burley
04-08-2006, 03:56 PM
Kurtbaker, perhaps you could use the mod in the thread below, probably will take a bit more work though;

https://vborg.vbsupport.ru/showthread.php?t=93970

but you can have a fully customized form. And placing it under a link in the navbar isn't that difficult ;)

Mr_Devlin
04-08-2006, 04:33 PM
now for my question... I run a club, and have a committee election coming up, I would love to use a system like this to allow people to apply for the positions... Any chance of being able to have a drop down list for what you want to apply for [pre-defined], somewhere up the top of the form?. Obviously without the Moderator application heading because they won't be what they are applying for...


This is a nice addon especially for bigger boards with different content.

I installed it on my testboard and would like to make some suggestions on this hack, something like kurt suggested before:

- the field for "Timezone" is unneeded I think. The user will set his time zone in usercp and this is not needed for application. If this feature is wanted for some reason make it enable in Acp with a checkbox and then fill it automaticly like $username and eMail

- the whole hack should be the application form for ALL STAFF POSITIONS,
therefore the field "position" should be a scrolldown menu, options should be added and editable via acp.

- an additional field "knowledge" should be added where applicants have to tell something about their skills and knowledge, that should qualify them for desired position.

- the title of hack should be changed to STAFF APPLICATION SYSTEM so it can be used for ANY staff position that is selectable in position field.

I tried to change the templates in this way but there were errors when submitting the form so this have to be included in the scripts for making them working.

SCORPION1
04-12-2006, 12:50 AM
hi there i am new to this now i have installed this and runs great but when i try to run the forum/includes/cron/maf_cron.php i get this message

Fatal error: Call to a member function on a non-object in /home/madace/public_html/forum/includes/cron/maf_cron.php on line 27
can anyone tell me whats wrong thanks

kurtbarker
04-13-2006, 01:34 PM
hey mate, it was stated that this works out a rating system where moderators rate the member applying...

Idealy I just want a system where when it person applys, it posts the form in the admin section, or even sends it to my email for me to look over...

Does this suit that?

I don't really wanna leave the moderator applications up to my mods, it'll turn into a popularity contest

Mr_Devlin
04-15-2006, 12:27 PM
Hi kurt,
I think this could be an option. It's always good to know that applicants were accepted by other mods. In many cases mods have to rate the applications too because they're forum- or group leaders and have to select their assistant mods. So this feature should be an selectable option for those boards who needs it.

ShadowOne
04-18-2006, 05:39 AM
I am going to test this on 3.5.4, cuz i used this on 3.5.3 before and it worked...so i will be back whenever with an update...

ShadowOne
04-18-2006, 06:32 AM
hi there i am new to this now i have installed this and runs great but when i try to run the forum/includes/cron/maf_cron.php i get this message

Fatal error: Call to a member function on a non-object in /home/madace/public_html/forum/includes/cron/maf_cron.php on line 27
can anyone tell me whats wrong thanks


the only problem i see is it wont send it to a thread...but it can still be read through the admincp...so i will use this for now until update

Nathan2006
04-18-2006, 08:49 AM
Thank you very much sabret00the

This is great!:D

Working fully:cool:

Install

Is there anyway to make the User name & Email Address fields UN-editable?

World be something same as this but I have not got a clue on it
https://vborg.vbsupport.ru/showthread.php?t=99538

This would stop members creating applications for other members :)

Thanks you for any help

Mr_Devlin
04-18-2006, 10:15 AM
Is there anyway to make the User name & Email Address fields UN-editable?

Two spots on this: username and eMail will be parsed from user table in db when creating a new application. Applicant can not edit these entrys.

second: Go into your acp > usergroup settings and turn off the email function for all membergroups except admin (s-mods/mods) so that each others have to use their own client and therefore a reachable email address... this way you can increase your server load too

Nathan2006
04-19-2006, 05:06 AM
Two spots on this: username and eMail will be parsed from user table in db when creating a new application. Applicant can not edit these entrys.

second: Go into your acp > usergroup settings and turn off the email function for all membergroups except admin (s-mods/mods) so that each others have to use their own client and therefore a reachable email address... this way you can increase your server load too

Thanks I will look in to that :)

I did find one more thing - When a user enters a load of wrong infomation there is a Phrase missing - I have looked all over the place but I cannot find it


Could not find phrase 'maf_dontlie'.


Thank you for any help :)

phonexpo
05-20-2006, 03:49 PM
Installed ;)

Thank you.

phonexpo
05-20-2006, 06:00 PM
What happens after a member applies? Cause I tried it and no thread started in the set forum id and I got no emails?

Nathan2006
05-20-2006, 06:07 PM
What happens after a member applies? Cause I tried it and no thread started in the set forum id and I got no emails?

My server is
dead atm but if you go to your admincp and on the menu go to Scheduled tasks there is a option in there to run the application form ;)

Once you have clicked that it will place the new thread in the forum you wanted.

Also your mods can go to the modcp and see the option at the bottom of their menu "Rate Application" same as in the admincp :)

phonexpo
05-20-2006, 06:10 PM
aha ;) so it hasn't run the cycle yet as the time is set @12:30?

Gotcha.... :)

Cheers

Nathan2006
05-20-2006, 06:14 PM
aha ;) so it hasn't run the cycle yet as the time is set @12:30?

Gotcha.... :)

Cheers

You're Welcome

I thought that too when I did not see the thread created lol:D

COBRAws
05-21-2006, 08:31 AM
I uninstall this, its not really supported. A shame :(

Martin-TMGRS
05-26-2006, 01:19 PM
Installed, Thanks :)

Raptor
05-28-2006, 10:15 PM
the files in the zip are all over the place ?

JulianWolf
06-02-2006, 10:56 PM
Also got this error:

Invalid SQL:

INSERT INTO vb3_thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1149290499, 0, 1, 0, '', , '', 1149290499, 1, 0);

MySQL-Fehler : 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 ' '', 1149290499, 1, 0)' at line 2
Fehler-Nr. : 1064
Datum : Saturday, June 3rd 2006 @ 01:21:39 AM
Skript : http://www.mind-evolution.de/nlp/admincp/cronadmin.php?do=runcron&cronid=16
Referrer : http://www.mind-evolution.de/nlp/admincp/index.php
IP-Adresse : 80.135.212.240
Benutzername : Julian
Klassenname : vb_database


This error seems to be a "common" error. And it seems to be ignored by the author. Could you please just post a short information, if you do anything to solve this problem or if it keeps buggy?

Best wishes, Julian!

Renee
06-03-2006, 03:51 PM
The phrases maf_rated and maf_deleted should set to "Front-End Error Messages" then they are works.

JulianWolf
06-07-2006, 02:49 PM
Renee, to which question was this ansewr?

And how can I "set" a phrase?

SHalliday
06-12-2006, 03:48 PM
Installed and finally working. Have to say this has been one of the more difficult hacks I have ever installed. Most likely this is due to already having a previous version installed and lack of good upgrade instructions. With that being said, it is now working very nicely. Clicks --> Install

cooldude714
06-17-2006, 01:06 PM
Is there one available for 3.6.x because it won't work on the 3.6.BETA 1/2

sabret00the
06-17-2006, 01:48 PM
i'll make a working version for 3.6.x and clean up all the misc bugs when 3.6 goes stable, given that code can change and templates change, i really have no desire to get this working for the betas. When this goes stable, i'll read the thread from front to back, compile feature requests and bugs and work on them. i'm not promising feature requests will be added but they'll be reviewed.

2fast4ya
06-18-2006, 03:43 PM
Sabretoothe, I've tried to install this, however now my admincp is empyt, there are a few links there but all my ADMIN links on the left side are basically wrong.. what should I do? I did the install.php file, uploaded, changed the chron thing, but my admin cp is useless now..

2fast4ya
06-18-2006, 03:48 PM
Ok sabret00the, i was working with it, and the include/xml/cpnav file that we edit, that was the problem. is their a certain program to use to edit it? I used note pad and appearently that didn't work... ? i'll try again but can u help me?

sabret00the
06-18-2006, 03:51 PM
Ok sabret00the, i was working with it, and the include/xml/cpnav file that we edit, that was the problem. is their a certain program to use to edit it? I used note pad and appearently that didn't work... ? i'll try again but can u help me?
erm, i'd say notepad is the best bet. however if you have cuteftp the built in editor could do the job too.

2fast4ya
06-18-2006, 03:57 PM
Ok, i finally figured it out.. turns out there were some spaces where there shouldn't have been. Good install and I can't wait for someone to apply to try it out! Thanks

(remember people, NO SPACES)

2fast4ya
06-19-2006, 03:11 AM
Hey sabert00the, another quick question:
when i do things, it's gives me errors like "cannot find maf_delete."
and similar messages when i rate them.. should i try a reinstall of the .php file?

KuJoe
06-30-2006, 03:41 AM
What would be the best way to disable the auto e-mailing feature on this?

oberheimhaven
06-30-2006, 11:52 PM
However I missing something here I have not received mail other than that all installed great 3.5.4

thxs

nay help concerning the mail issue would be appreciated

Mark

Thanks

oberheimhaven
06-30-2006, 11:58 PM
basic half of her I gues i dont care about rating part only like the application part how do i get her to receive mail any help wouldbe appreicate I got her installed all shows up great

UZFRED
07-03-2006, 03:06 PM
Things I fixed for my forum in this modification:

Rules Typo:

in template modapp_rules FIND

encougrage

REPLACE WITH

encourage

Make Nickname & E-mail Address unchangable

in template MODAPP FIND

<input name="username" type="text" value="$bbuserinfo[username]" size="50" maxlength="250">

REPLACE WITH

<input name="username" type="text" value="$bbuserinfo[username]" size="50" maxlength="250" readonly="true">

FIND

<input name="email" type="text" value="$bbuserinfo[email]" size="50" maxlength="250">

REPLACE WITH

<input name="email" type="text" value="$bbuserinfo[email]" size="50" maxlength="250" readonly="true">

There are some more typos on MODAPP and it is really looking unprofessional with Sentences That Always Have Each Word Starting With Capital. I changed all this but I won't be writing it all down here. Not only did this shock me a little bit, but the worse is the guy who made this did a good job on porting the mod, but that it's taking him almost A YEAR (took me 10 seconds for both the boxes), to make the nickname and email box READONLY (this is really crucial, people could just go and abuse this if they want) is the most shocking. (This mod has over 150+ installs, and imagine not everyone clicks the install button (downloaded over 770+ times, I think it's worth to put a little bit effort in this mod, even on these small but crucial things)

Brian31fl
07-04-2006, 12:31 AM
i worked on the phrases even tho his phares are there they do not work aways get the useall cannot find blah blah phrase so here is small fix

goto admincp and open file delapp.php

to very bottom replace the line

define('CP_REDIRECT', 'maf_delapp.php?do=find');
print_stop_message('deleted_user_successfully');

and replace the phrase he has there with this

deleted_user_successfully

as for the rating phrase i worked at it couldnt get it to work

so i just removed the print line

Dr.Viggy
07-04-2006, 11:36 PM
no t rouble here. worked perfectly and will be very helpful.

thanks. installed

KuJoe
07-05-2006, 08:38 PM
Bah, I just added the edit to prevent changing usernames and e-mail... but it was to little to late for me. How exactly do I remove an application when there is no username entered?

fixd
07-25-2006, 02:54 PM
hey, im having a problem with this MOD

This is the error i get, with my IP address removed:

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1153842761, 19, 1, 0, '', , '', 1153842761, 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 ' '', 1153842761, 1, 0)' at line 2
Error Number : 1064
Date : Tuesday, July 25th 2006 @ 03:52:41 PM
Script : http://www.totalreload.co.uk/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://www.totalreload.co.uk/admincp/cronadmin.php?do=modify
IP Address : ***.***.***.***
Username : johnnie
Classname : vb_database

FROGGYJ
08-01-2006, 01:54 AM
well many phares problems, spelling mistakes.....but the thing that bugs me the most is that if I as (mod) or (admin) go and rate someone's application, nobody else from the staff can. It only allows for 1 rating? Well perhaps this will get cleaned up in future. Thanks.

sabret00the
08-01-2006, 09:44 AM
wow a lot of bitching in this thread, as for how long it's taking me to post to 3.6.x i can only apologise, however given the fact that 3.6 Gold isn't out yet it's not like it's gonna happen before then.

As for the various missing phrases, get over it, it's a few control panel stop messages, not the biggest nessessity in the world.

Spelling mistakes, yeah i'm a f'up for them.

Bug to do with only one person being able to rate mods, i can't claim to have seen that. however in a bid to make sure that this doesn't happen again (problems that i ain't experiencing) i'm not going to release the 3.6 (plus bugfixed) version until it's running on my site. The port i made to 3.5 was more for the people here than myself (as i've never used it).

And please leave comments like professionalism out unless you're padding out my pockets, this project was firmly in the hobby/learning experience basket.

Lucas
08-01-2006, 02:28 PM
I'm using it in vBulletin 3.6 RC3 and it is working fine. The only weird thing is all posts have started to be as MODERATED posts. Does anyone know a fix for this?

d8tabyte
08-04-2006, 04:54 PM
I have it working on my site - great work man. Better than I could whip up for sure.

Techno05
08-10-2006, 10:07 PM
I hope when this gets released for version 3.6 that you make the app generate a type of thread for the rest of the staff to see on a site not just in the admin cp...

cooldude714
08-17-2006, 11:11 AM
3.6 version?

sabret00the
08-20-2006, 09:28 PM
Ok a 3.6 version will be released this week, that's ahead of my own site going 3.6 *shock horror* i'll release the 3.6 version as beta so i can squash any bugs i may have missed in trawlling through this thread. i'll add the missing phrases and fix the spelling mistakes too.

sabret00the
08-22-2006, 01:56 PM
Ok a 3.6 version will be released this week, that's ahead of my own site going 3.6 *shock horror* i'll release the 3.6 version as beta so i can squash any bugs i may have missed in trawlling through this thread. i'll add the missing phrases and fix the spelling mistakes too.
well done, just two days later, you're the coolest ;)

UNRE4L
08-22-2006, 02:15 PM
I have got this error now when i tried to upgrade.
Database error in vBulletin 3.6.0:

Invalid SQL:
DELETE FROM `vb_setting WHERE grouptitle = 'maf';

sabret00the
08-22-2006, 02:20 PM
fixed, check the new zip

UNRE4L
08-22-2006, 02:48 PM
Thanks :) It all seems to be working fine now.
Its a useful mod, the forum manager of mine uses it often.

Rover416
08-22-2006, 10:54 PM
Nice idea.

When i run the installer file i get this error:



Invalid SQL:

CREATE TABLE `mas_ratings` (
`ratingid` int(10) NOT NULL,
`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`),
);

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 10
Error Number : 1064
Date : Wednesday, August 23rd 2006 @ 12:43:32 AM
Script : http://www.vectra-sri.co.uk/forum/mas_installer.php
Referrer :
.

:(

sabret00the
08-23-2006, 09:09 AM
zip updated.

Rover416
08-23-2006, 09:51 AM
Thanks, installs great now.

One more thing, the application goes through but when i click to rate it you can see the rating dropdown and comment box at the bottom but after that is:


Application Not Found


There is no submit button.

sabret00the
08-23-2006, 09:57 AM
sorry could you take a screenshot, i'm a little lost on what you're referring to.

Rover416
08-23-2006, 10:13 AM
Sorry, not great at explaining things.

This is the screenshot of the rating screen at the bottom.

Barteken
08-23-2006, 07:56 PM
get an error with the latetst version when submitting the first form:
Although this error appears the forum is submitted well into the db
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

After a second form submit I just get a db error.
Not submitted

sabret00the
08-23-2006, 08:03 PM
get an error with the latetst version when submitting the first form:
Although this error appears the forum is submitted well into the db
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

After a second form submit I just get a db error.
Not submitted
you did set your vBulletin options right Barteken?

@rover i've not forgotten you

bashy
08-23-2006, 08:11 PM
Hi...

How would i change this

"Their are new moderator applications that need rating, please go and rate them, if need be return here to discuss them further."

to this please

"Their are new moderator applications that need rating, please CLICK HERE to rate them, if need be return here to discuss them further.

CLICK HERE takes the staff to the list of application forms....

I can find anything in the phrases nor templates :(

Is it in a file?

BTW do i have to upgrade, this is working fine for me on 3.6 i still run the older version :)

cbr929rrerion
08-24-2006, 02:21 AM
When I go to enter an application I get this error

vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758

cbr929rrerion
08-24-2006, 02:24 AM
also this error

Could not find phrase 'mas_dontlie'.

d8tabyte
08-24-2006, 03:25 AM
ok so I have this installed - the app works fine - the rating works fine - but the app has been sitting there for 22 days now after being rated by staff members... (its set to do its thing at the 14th day i think) Did I miss a memo somewhere?

sabret00the
08-24-2006, 04:16 AM
When I go to enter an application I get this error

vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758
is that everything that appeared on the screen?

sabret00the
08-24-2006, 04:18 AM
Sorry, not great at explaining things.

This is the screenshot of the rating screen at the bottom.
what's the url for that frame?

sabret00the
08-24-2006, 04:19 AM
Hi...

How would i change this

"Their are new moderator applications that need rating, please go and rate them, if need be return here to discuss them further."

to this please

"Their are new moderator applications that need rating, please CLICK HERE to rate them, if need be return here to discuss them further.

CLICK HERE takes the staff to the list of application forms....

I can find anything in the phrases nor templates :(

Is it in a file?

BTW do i have to upgrade, this is working fine for me on 3.6 i still run the older version :)

Edit the cron file. And nope you don't HAVE to upgrade.

sabret00the
08-24-2006, 04:21 AM
ok so I have this installed - the app works fine - the rating works fine - but the app has been sitting there for 22 days now after being rated by staff members... (its set to do its thing at the 14th day i think) Did I miss a memo somewhere?
what's the average rating? and are you sure no emails were sent?

sabret00the
08-24-2006, 04:22 AM
also this error

Could not find phrase 'mas_dontlie'.
thanks, i'll look into it.

bashy
08-24-2006, 05:11 AM
Cheers SabreOOthe

Barteken
08-24-2006, 01:20 PM
is that everything that appeared on the screen?

same here although it's on line 763 but yes thats the only thing that appears on the screen.

sabret00the
08-24-2006, 01:25 PM
same here although it's on line 763 but yes thats the only thing that appears on the screen.
are you sure you set the vBoptions? because the error is basically the script saying that the thread can't be made.

Barteken
08-24-2006, 01:46 PM
Ok the first form submit works now but when I want to send another with another user I get a db error.
This errorDatabase error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO mas_application(userid, email, fullname, age, location, timezone, answers, application_time)
VALUES (608, 'barteke1988@hotmail.com', 'lala', '50', 'slsl', 'dldl', 'a:6:{i:0;s:4:\"dldl\";i:1;s:4:\"dldl\";i:2;s:3:\"dld\";i:3;s:4:\"dldl\";i:4;s:5:\"dlddl\";i:5;s:3:\"dld\";}', 1156430586);

MySQL Error : Duplicate entry '0' for key 1 Error Number : 1062
Date : Thursday, August 24th 2006 @ 04:43:06 PM

sabret00the
08-24-2006, 02:15 PM
Ok the first form submit works now but when I want to send another with another user I get a db error.
This errorDatabase error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO mas_application(userid, email, fullname, age, location, timezone, answers, application_time)
VALUES (608, 'barteke1988@hotmail.com', 'lala', '50', 'slsl', 'dldl', 'a:6:{i:0;s:4:\"dldl\";i:1;s:4:\"dldl\";i:2;s:3:\"dld\";i:3;s:4:\"dldl\";i:4;s:5:\"dlddl\";i:5;s:3:\"dld\";}', 1156430586);

MySQL Error : Duplicate entry '0' for key 1 Error Number : 1062
Date : Thursday, August 24th 2006 @ 04:43:06 PM
run this query, i'll update the installer
ALTER TABLE `mas_application` CHANGE `appid` `appid` INT(10) NOT NULL AUTO_INCREMENT

and this query
ALTER TABLE `mas_rating` CHANGE `ratingid` `ratingid` INT(10) NOT NULL AUTO_INCREMENT

sabret00the
08-24-2006, 02:23 PM
installer updated, it seems that auto increments are removed in making queries MySQL 4.0 compatible. :(

Barteken
08-24-2006, 10:54 PM
ok works like a charm thanks for the fast response!

FReeSTER
08-25-2006, 03:29 PM
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

bashy
08-25-2006, 05:05 PM
Sorted now :)

bashy
08-26-2006, 12:42 PM
Hi

We get this error now when a app is submitted

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

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

sabret00the
08-26-2006, 12:50 PM
Hi

We get this error now when a app is submitted

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

urgently need support on this please as we have 3 peeps that want to apply for a position... :(
did you set your vBoptions?

sabret00the
08-26-2006, 12:51 PM
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
you'd have to edit the templates and mas_cron.php directly.

bashy
08-26-2006, 12:59 PM
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?

ForumHabbo
08-26-2006, 02:05 PM
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