vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   MAF: (Moderator Application Form & Application Rating Module) (https://vborg.vbsupport.ru/showthread.php?t=77340)

sabret00the 03-03-2005 08:55 AM

doh, give me 45 minutes to fix it, i'll set another update when it's fixed :)

sorry about this OBK

Oblivion Knight 03-03-2005 09:02 AM

Hey no worries Sabe.. I knew it would be kinda risky installing it straight on to my live board so early in development without me testing it on my test board first. Other than the occasional errors, it's a very nice mod indeed and I see a lot of potential..

Once the bugs have been ironed out, I'll look in to seeing if there's anything I can improve upon. I'm sure in some of the e-mail notifications I receive, there are usernames repeated (ie. in more than one notification) and it would be nice to have the applicant usernames printed in the thread notifications too.. :)

sabret00the 03-03-2005 09:52 AM

Quote:

Originally Posted by Oblivion Knight
there are usernames repeated (ie. in more than one notification) and it would be nice to have the applicant usernames printed in the thread notifications too..

the repeated usernames thing, i aint had that but as soon as i'm able to replicate that i'll iron it out, regarding the names in the thread, that's quite an easy one, so no doubt you'll see that soon, just need to make sure theirs no more bugs before i start adding more stuff.

Slybone 03-03-2005 10:07 AM

hmmm on the 4th step I continue to get that SQL error (read up) any clue what thats about?

nexialys 03-03-2005 10:08 AM

SUGG: can you put the cron texts in some text-files and load it depending on $vboptions[languageid] so we can have multiple lang ?! (/includes/cron/maf/lang/1.php) or something...

thanks (i'll do it for myself anyway, but...)

sabret00the 03-03-2005 10:19 AM

Quote:

Originally Posted by Slybone
hmmm on the 4th step I continue to get that SQL error (read up) any clue what thats about?

upgrade or fresh install?

Quote:

Originally Posted by nexialys
SUGG: can you put the cron texts in some text-files and load it depending on $vboptions[languageid] so we can have multiple lang ?! (/includes/cron/maf/lang/1.php) or something...

thanks (i'll do it for myself anyway, but...)

i knew someone was gonna ask for that sooner or later :(

but mainly it comes from an experiment, basically grabbing the email stuff from templates goes straight to inbox rather than junk mail, so i wanted to see how this behaved too.

nexialys 03-03-2005 11:19 AM

Quote:

Originally Posted by sabret00the
i knew someone was gonna ask for that sooner or later :(
but mainly it comes from an experiment, basically grabbing the email stuff from templates goes straight to inbox rather than junk mail, so i wanted to see how this behaved too.

hum ?!.. i don't see the link with lang text... ;)

and yes, i'm the tricky guy that stuck everybody with stupid questions ya know!

sabret00the 03-03-2005 11:21 AM

Quote:

Originally Posted by nexialys
hum ?!.. i don't see the link with lang text... ;)

and yes, i'm the tricky guy that stuck everybody with stupid questions ya know!

i have no idea where the link is with the language text but if when dragging an email out of the templates rather than the phrases it's going to inbox, something has to be different right?

oh well just for you when i add the OBK request i flagged i'll move the email text over to the phrases :)

Oblivion Knight 03-03-2005 11:36 AM

/install/hacks/MAF/2/index.php has a typo.. ;)

Code:

                        require_once('../upgrade_queries.php');
Should be:
Code:

                        require_once('./upgrade_queries.php');
Otherwise, the error that I mentioned earlier still appears.

nexialys 03-03-2005 11:44 AM

Quote:

Originally Posted by sabret00the
i have no idea where the link is with the language text but if when dragging an email out of the templates rather than the phrases it's going to inbox, something has to be different right?

oh that... problem easily solved: trim($the_text) will correct the situation, as a non-trimmed text will send a EOL that bug off the emailers...

sabret00the 03-03-2005 01:08 PM

Quote:

Originally Posted by Oblivion Knight
/install/hacks/MAF/2/index.php has a typo.. ;)

Code:

                        require_once('../upgrade_queries.php');
Should be:
Code:

                        require_once('./upgrade_queries.php');
Otherwise, the error that I mentioned earlier still appears.

thanks, obk. fixed :)

Quote:

Originally Posted by nexialys
oh that... problem easily solved: trim($the_text) will correct the situation, as a non-trimmed text will send a EOL that bug off the emailers...

now that i like, thanks for the heads up :)

wwesn1 03-03-2005 01:24 PM

Quote:

Originally Posted by sabret00the
within your vBoptions, theirs a group, it should be the bottom one, you set it there.

Well for some reason it is not there :(

sabret00the 03-03-2005 01:32 PM

Quote:

Originally Posted by wwesn1
Well for some reason it is not there :(

i suggest a reinstall

just run the installer again and remake the admincp file edit that should make it easier to find what you're looking for

wwesn1 03-03-2005 01:44 PM

everything is working now, thanks :)

wwesn1 03-03-2005 01:47 PM

just one more thing. I did a test application and rated it. Now it says that

This Application Was Rated: 12846 days ago

Also, I tested the cron and ran it twice. Both times it posted in the forum that there was a new mod application however their is only 1. Is it gonna post that message everytime the cron runs?

wwesn1 03-03-2005 01:54 PM

oh and sorry, another thing.

Now how can I delete the test application? I see an option called "Delete Applications" but when I click it there is nothing there.

Deviant++ 03-03-2005 01:56 PM

I'm gonna install this soon. :)

sabret00the 03-03-2005 02:47 PM

Quote:

Originally Posted by wwesn1
oh and sorry, another thing.

Now how can I delete the test application? I see an option called "Delete Applications" but when I click it there is nothing there.

fixed that, please reupload the maf_delapp to your admincp

sabret00the 03-03-2005 02:49 PM

Quote:

Originally Posted by wwesn1
just one more thing. I did a test application and rated it. Now it says that

This Application Was Rated: 12846 days ago



Also, I tested the cron and ran it twice. Both times it posted in the forum that there was a new mod application however their is only 1. Is it gonna post that message everytime the cron runs?

it checks based on if theirs any apps that were there that weren't yesterday, not based on appid's.

sabret00the 03-03-2005 02:50 PM

Quote:

Originally Posted by wwesn1
This Application Was Rated: 12846 days ago

considering both "day's ago" occurances use the same formulee to work them out i'm baffled but i'll try and squash this one.

wwesn1 03-03-2005 03:49 PM

nvm..........

wwesn1 03-03-2005 04:19 PM

If anyone still has trouble with that file, such as I did - caused mysql errors and one of the table names was wrong - missing an 's', here is my edited file (which works for me and I can delete apps now)....

sabret00the 03-03-2005 04:51 PM

Quote:

Originally Posted by wwesn1
If anyone still has trouble with that file, such as I did - caused mysql errors and one of the table names was wrong - missing an 's', here is my edited file (which works for me and I can delete apps now)....

your file is missing table prefixes so i don't even know what version you had. but thank you, i've now updated the files :)

wwesn1 03-03-2005 04:55 PM

It should only have been missing one cause it was causing errors. This was the original...

Code:

        $getuser = $DB_site->query_first("
                SELECT *
                FROM " . TABLE_PREFIX . "user
                WHERE " . TABLE_PREFIX . "username = '" . $username . "'
        ");

but since that would make it vb3_username - that is wrong, at least for me anyhow.

and for some reason the

Code:

DELETE *
                FROM maf_application
                WHERE userid = $getuser[userid]

wouldn't work for me so I had to remove the '*' (also from the line after this)

But as long as it works, I'm happy :)

Lizard King 03-03-2005 05:03 PM

how I can view who applied and where to discuss the application ?
I get the new thread working but there is no link for how I can view who applied and what they fulled in the forum ?

When I go to www.yoursite.com/forum/modcp/maf_rateapp.php it doesn't give me anything.

sabret00the 03-03-2005 05:05 PM

Quote:

Originally Posted by Lizard King
how I can view who applied and where to discuss the application ?
I get the new thread working but there is no link for how I can view who applied and what they fulled in the forum ?

When I go to www.yoursite.com/forum/modcp/maf_rateapp.php it doesn't give me anything.

the moderator control panel to rate

and the thread to discuss it.

and i'll add a fix for that tonight, i just need to work out the table prefix problem first

Lizard King 03-03-2005 05:09 PM

Quote:

Originally Posted by sabret00the
the moderator control panel to rate

and the thread to discuss it.

and i'll add a fix for that tonight, i just need to work out the table prefix problem first

One more thing. I made a test application once and the now I have like 10 threads in my choosed forum :) I don't know why but it still continues to open a new thread :)

sabret00the 03-03-2005 05:13 PM

Quote:

Originally Posted by Lizard King
One more thing. I made a test application once and the now I have like 10 threads in my choosed forum :) I don't know why but it still continues to open a new thread :)

how often are you running this cron?

Lizard King 03-03-2005 05:18 PM

Quote:

Originally Posted by sabret00the
how often are you running this cron?

I didn't choose to run he cron and now I choosed daily :)

sabret00the 03-03-2005 05:55 PM

Quote:

Originally Posted by wwesn1
It should only have been missing one cause it was causing errors. This was the original...

Code:

        $getuser = $DB_site->query_first("
                SELECT *
                FROM " . TABLE_PREFIX . "user
                WHERE " . TABLE_PREFIX . "username = '" . $username . "'
        ");

but since that would make it vb3_username - that is wrong, at least for me anyhow.

and for some reason the

Code:

DELETE *
                FROM maf_application
                WHERE userid = $getuser[userid]

wouldn't work for me so I had to remove the '*' (also from the line after this)

But as long as it works, I'm happy :)

table prefix errors all removed.

Lionel 03-03-2005 09:04 PM

Every time I use this f**king hack.install.php thing I get that error....

Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /var/www/forums/includes/db_mysql.php on line 389

sabret00the 03-03-2005 09:24 PM

Quote:

Originally Posted by Lionel
Every time I use this f**king hack.install.php thing I get that error....

Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /var/www/forums/includes/db_mysql.php on line 389

that just with this one or all the time?

Lionel 03-03-2005 09:33 PM

every time. twice. And the file is there. And that is a fresh copy of 3.07

Lionel 03-03-2005 09:40 PM

I also get:

Database error in vBulletin 3.0.7:

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 tinyint(4) default NULL,
PRIMARY KEY (appid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 21

mysql error number: 1064

Slybone 03-03-2005 09:49 PM

Quote:

Originally Posted by sabret00the
upgrade or fresh install?

fresh install

Lizard King 03-03-2005 10:38 PM

Quote:

Originally Posted by sabret00the
table prefix errors all removed.

is the problem with modcp solved ?

Also a question with cron , as I explained before. I just tested application form once cause I had to make some translations over templates. And I ran the cron job and I didn't set a time to run. I have 10 topics now but what I can't understand is if a cron job run once and do his job why is he opening the same topic second time ?
I am not sure if the cron job will re open the thread ? I checked now and he again reopened the thread. Thats is something you must clear urgently cause it will be really disturbing that cron job will do the job again and again which he already did.

Check out the attached screenshot and check the last post time. There is something really wrong with the cron job.

neo|d3fx 03-03-2005 11:42 PM

Quote:

Originally Posted by Lizard King
is the problem with modcp solved ?

Also a question with cron , as I explained before. I just tested application form once cause I had to make some translations over templates. And I ran the cron job and I didn't set a time to run. I have 10 topics now but what I can't understand is if a cron job run once and do his job why is he opening the same topic second time ?
I am not sure if the cron job will re open the thread ? I checked now and he again reopened the thread. Thats is something you must clear urgently cause it will be really disturbing that cron job will do the job again and again which he already did.

Check out the attached screenshot and check the last post time. There is something really wrong with the cron job.


I to have the same issue.

Lionel 03-04-2005 01:20 AM

Quote:

Originally Posted by Lionel
Every time I use this hack.install.php thing I get that error....

Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /var/www/forums/includes/db_mysql.php on line 389

So is there a way around it? The shoutbox hack using the same system turned out to be a nightmare also for same error.

Lizard King 03-04-2005 01:26 AM

Quote:

Originally Posted by Lionel
So is there a way around it? The shoutbox hack using the same system turned out to be a nightmare also for same error.

I think the problem is with your board cause the installer is working perfect. Can you try to run this modifications installer https://vborg.vbsupport.ru/showthread.php?t=74183 They both run the same installer so maybe you shall check with the thread https://vborg.vbsupport.ru/showthread.php?t=71542

Lionel 03-04-2005 01:41 AM

Big sigh! I have the same problem with the member choice hack. I have had that problem on 3 different boards.


All times are GMT. The time now is 04:20 AM.

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.02431 seconds
  • Memory Usage 1,848KB
  • 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
  • (8)bbcode_code_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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