vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Moderator Application System 2.0 (https://vborg.vbsupport.ru/showthread.php?t=102506)

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/cronad...cron&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

Quote:

Originally Posted by AnthonyIsDope
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

Quote:

Originally Posted by mindtrix25
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

Quote:

Originally Posted by notsonormal
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/cronad...cron&cronid=22
Classname : vb_database

you never set the username and forumid

sabret00the 12-22-2005 10:14 PM

Quote:

Originally Posted by ragintajin
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

Quote:

Originally Posted by ragintajin
How do you undo the changes made from running mas_installer.php?

run these two queries

[sql]DROP TABLE `maf_application`[/sql]

[sql]DROP TABLE `maf_ratings`[/sql]

sabret00the 12-22-2005 10:18 PM

Quote:

Originally Posted by ravenes
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

Quote:

Originally Posted by slvr ralliart
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

Quote:

Originally Posted by sabret00the
you tried uninstalling the plugin, then reinstalling?


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

slvr ralliart 12-23-2005 03:26 AM

Quote:

Originally Posted by sabret00the
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

Quote:

Originally Posted by bashy
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
Code:

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

Originally Posted by djjeffa
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
Code:

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

Quote:

Originally Posted by bashy
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

Quote:

Originally Posted by bashy
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


Quote:

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


All times are GMT. The time now is 01:34 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01478 seconds
  • Memory Usage 1,854KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete