View Single Post
  #41  
Old 07-05-2007, 04:18 PM
turnipofdoom turnipofdoom is offline
 
Join Date: May 2004
Location: Connecticut
Posts: 113
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by digitalJE5U5 View Post
Well I managed to get the recruitment module to work, but I too _had to set

Chose Use Module Wrapper Template: NO

Questions:

1] I have added a link to our guild application in the Game Recruitment options page (see screen).

But on the vbadvanced page (http://www.ascendantsguild.net/) there is no link to the application from within your module.

2] How to I changed the display name of the module from "Recruitment" to "Currently Recruiting"?




I chose game [submit]

Added link to recruitment form [submit]

Populated Initial game data [submit]

No errors. Can you tell me what the "populated" table should look like and I can check to see what data is in there.

Code:
Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT usergroupid FROM user 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 1
Error Number : 1064
Date         : Tuesday, July 3rd 2007 @ 07:41:34 AM
Script       : http://www.ascendantsguild.net/
Referrer     : 
IP Address   : 216.84.195.xxx
Username     : xxx
Classname    : xxx
Here is the sql error
Ok that SQL error is probably on me.. I will look into it tonight, I have a patch planned to go out.

For table information you have

game_rec_settings..

In there you have the game field, the groups field (comma seperated list of ppl allowed to edit the form), a link (which is not used yet), and enabled (0, or 1)..

you should have one entry in this table, looking something like

Code:
+-----------+---------+----------+-------------+
| game      | enabled | groups   | recruit_url |
+-----------+---------+----------+-------------+
| everquest |       1 | 5,6,7,28 |             |
--------------------------------------------------------



the recruitment table has the information for the classes that are being recruited.

its just one entry per class and the value of that entry (installed they are all set to 1).

the display form is not set to use the module shell template. the update form however does need to use the module shell template. it wil take up the entire page w/o it.

to change the heading of the module, that is done inside the template for the display portion of the module. adv_portal_warcraft_recruit. (you will have to revert the template changes if you want to update the product)...

I am unsure why userid is null in your SQL query there. I was grabbing it from $_COOKIE to check if the user had permission to view the update form.. Do you have groups set in the settings page ? groupnumber,groupnumber2,groupnumber3? eh even if you do that value shouldnt be null.. I will look at that tonight, like I said I have a patch to fix some of these issues reported thus far.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01084 seconds
  • Memory Usage 1,779KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete