Looking forward to the update. Thanks for your time.

peterplys wrote:i cant get DB to work, getting this error when trying to add:

#1064 - 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 'collate latin1_general_ci NOT NULL,
`druid` varchar(32) coll


im using phpmy mysql v. 4.1.11

* yes im a noob, tahts why it would be even more nice for me if it worked

Ok, if you're running MySQL 4.x on your webserver...

Use this:

Code: Select all

-- MySQL4
-- Table structure for table `recruitment`
--

CREATE TABLE IF NOT EXISTS `recruitment` (
  `status` varchar(32) NOT NULL,
  `druid` varchar(32) NOT NULL,
  `hunter` varchar(32) NOT NULL,
  `mage` varchar(32) NOT NULL,
  `paladin` varchar(32) NOT NULL,
  `priest` varchar(32) NOT NULL,
  `rogue` varchar(32) NOT NULL,
  `shaman` varchar(32) NOT NULL,
  `warlock` varchar(32) NOT NULL,
  `warrior` varchar(32) NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `recruitment`
--

INSERT INTO `recruitment` VALUES ('Open', 'High', 'Closed', 'Closed', 'Closed', 'Closed', 'Closed', 'Closed', 'Closed', 'Closed');

     --
-- Table structure for table `recruitment`
--


I have uploaded the latest version to the server. If you already have it installed, just over write your request_form.php and confirm.php files.

The changes in this release are simply to include Jewelcrafting as a profession and to add in the BC keys/attunements. The MySQL installation files have also been fixed for new installations.

Thanks for the update!

Hi guys great addon but.....

I have installaed the addon without problem and all is working fine, except, where the hell does the application get sent to? I have trawled the forum and ran numerous tests but the submitted application just do es not appear anywhere.

Do I have to enter an email address somewhere in the code etc.

Sorry for my noobness

You need to modify the contents of the appconfig.php file located in \modules\Application\

Code: Select all

Set the variables below as needed to suit your installation

*/

//Set guild name
$guildname = "Guild";

//Output guild information links? (0 to suppress rules, rank structure and raiding information links)
$showguildinfo = 0;
//Set path to guild rules - Empty string to supress
$guildrules = "";
//Set path to rank structure - Empty string to supress
$rankstructure = "";
//Set path to raiding information - Empty string to supress
$raidinginfo = "";

//Set your "about" message for the recruitment page - Empty string to supress
$about = "";
//Set a message to appear at the top of the application form - Empty string to supress
$appmessage = "";

//Set up the mail - Set the recipient email addresses
$recipient = "Application@mysite.com";
//Set the test name to trigger alternate email (Enter this string in 'Your Name' field of form)
$testname = "Test";
//Set the alternate email address to send to when testname is entered
$testrecipient = "Webmaster@mysite.com";


$recipient is where you set the email address that the completed form gets sent to.
$testname allows for a "backdoor" so you can send a completed form to a different address for testing purposes
$testrecipient is where you set the email address to send the test to.

Thanks mate

I took this little addon one or two or three steps further.

Since I didnt want an email to be sent out and it seemed not right to send all applications to one personand not the class leaders I decided to create a Database table and have all the applications added there.

I have also greatly modified the Application form to better portray the new TBC content.

View the application here. Dawn of Wolves Guild Application

I then added some security to the new admin page that displays the applications so that only members of the Officer group on my site can view them.

They will see a list of applicant and each applicant can be viewed or deleted. It will also display text "NEW" if the application is new that day. When viewed the application will show again but all the responses will be in red text.

here is what is seen in admin
Admin screen 1

Admin Screen 2

Cool, this application form is pretty much what I was trying to get, now I just have to try and rip it out of the CMS and make it work standalone, or integrated with phpBB instead...

Nice work Razac

I had considered writing the info to the database and displaying it as you have it but decided that cutting and pasting into a forum thread was a better solution for us. We add a poll to each thread where we vote on the application and the entire thread gets moved to an archive folder when we are done. This allows us to easily do a search for a character name (some individuals just will not take no for an answer and keep reapplying every so often). It also allows us to look back on comments posted while the individual was going through their recruitment phase.

I wish someone had developed a simple way to go from a form to the forum, I looked around and found several half hearted attempts but nothing that actually functions. I just don't care enough about the issue to undertake the development myself. It's hard for me to justify spending a lot of my time working on it rather than playing WoW or spending time with the family when it only takes 3 seconds to cut and paste the email into a new thread. I have the email automatically forwarded to several other guild officers so I don't personally have to deal with it in any case.

If you want I can zip up the files and make an SQL Schema to import.

Provide some instructions. etc..

Maybe I will see about an export to a Form thread or something..

Ymryl wrote:

Ghostmaster wrote:Wish list:
TBC Attunements
Ability to post application as an forum post instead of email

Anaxent is currently working on moving the configuration settings into the admin module and posting to the forum rather than email for Dragonfly.

Any news about this?

Morill,
He has it working in Dragonfly with ForumsPro. I do not believe he has released his current code however and it is unlikely that it will work with phpbb. It appears that several individuals have take the original concept and ran with it in several different directions (which is awesome). You may want to read through the dragonfly forum for more info on the things they are doing.

Razac,
I'm sure there are plenty of people here that would love to see your code. It may not be particularly useful to me personally but everyone approaches things differently. Sharing code here is kind of like brainstorming. Everyone throws in new ideas and it's cool to see what people come up with.

hmm to bad i am using PHPnuke would be fun to have it work for this

I followed the installation instructions and when I go to the module or the admin pages, all I have is a blank page. Is there something obvious I'm doing wrong? I'd really love to get this working!

I'm running PhpNuke 7.9. My site is http://www.gamenoir.com (module is admin only, due to the blank page currently). If anyone can help I'd appreciate it!