DF Guild Application w/ Recruitment Block

by **robojerk** » Fri May 04, 2007 2:58 pm

Delete the tables manually

Or you could try removing the cpg_inst.php, hit refresh on the Modules page, then put the cpg_inst.php file back in (might fix cacheing issues).

Also, you're looking at the Application module correct?

by **Razac** » Fri May 04, 2007 8:21 pm

Okie i have a fixed version that should work.

Robo im not sure how your getting the undifined prefix variable. its a global var.

I have fixed the includes in this version and an oversight in the install file.

still trying to figure out why it werked for me. my problem is my Server is down and im at work and cant get it back up..

gotta find a spot to host this.

by **Razac** » Fri May 04, 2007 8:43 pm

okie found a spot to store it.

Recruitment Module v2.01

by **Equisetum** » Fri May 04, 2007 11:49 pm

Robo,

Delete the tables manually

What tables would I delete manually? I don't see any tables that refer the recruitment module, and when I look at my cms_admins table, I don't see any recruitment fields at all. I don't even have a cms_recruitment table. It's as if the thing was never installed at all.

Or you could try removing the cpg_inst.php, hit refresh on the Modules page, then put the cpg_inst.php file back in (might fix cacheing issues).

I did a search for this file, and found it in some of the other installed modules folders, but no where else. Is there somewhere else I should look?

Also, you're looking at the Application module correct?

I am in Admin --> General --> Modules. The heading of the pages says "Modules and Addons" and I see WoWRosterDF for example, and a host of others. Many of them have "Uninstall" option, but not "Recruitment Settings" or "Application"

These two don't have an "Install" option either. When I make it active and try to click the link from the menu on the main page, I get:

includes/db/db.php

* CMS Warning line 75: On /Application.html While executing query "SELECT * FROM cms_recruitment" the following error occured: Table 'dragonfly.cms_recruitment' doesn't exist In: /home/httpd/vhosts/rage-and-mana.com/subdomains/wow/httpdocs/modules/Application/appconfig.php on line: 40

Anything else I can try?

Thanks so much for helping me. I love this addon and would love to get it working. I'm sure it's nothing wrong with the addon, but something I'm doing or not doing.

by **robojerk** » Sat May 05, 2007 12:10 am

Just had the same issue on my test server..
It's a cache issue.

Delete the 2 modules "Application" & "Recruitment_Settings"
Refresh the Modules pages. The 2 modules shouldn't be listed now.
Put the 2 modules put on the server and refresh the Modules page again.
That should fix it..

by **Equisetum** » Sat May 05, 2007 12:19 am

Ok... getting closer.

I did what you said, and now I can Install Application. woot!

When I try to install though, I get the following error. I tried this twice to make sure it wasn't me...

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&install=Application While executing query "CREATE TABLE cms_cms_recruitment ( `status` varchar(32) NOT NULL default '', `druid` varchar(32) NOT NULL default '', `hunter` varchar(32) NOT NULL default '', `mage` varchar(32) NOT NULL default '', `paladin` varchar(32) NOT NULL default '', `priest` varchar(32) NOT NULL default '', `rogue` varchar(32) NOT NULL default '', `shaman` varchar(32) NOT NULL default '', `warlock` varchar(32) NOT NULL default '', `warrior` varchar(32) NOT NULL default '', `grpID` tinyint(10) NOT NULL default '0', `showguildinfo` enum('1','0') NOT NULL default '1', `guildrules` varchar(255) NOT NULL default '', `rankstructure` varchar(255) NOT NULL default '', `raidinginfo` varchar(255) NOT NULL default '', `about` varchar(255) NOT NULL default '', `appmessage` varchar(255) NOT NULL default

Suggestions?

by **robojerk** » Sat May 05, 2007 12:21 am

Okay, I download the new version and here is the error I am getting.

On /admin.php?op=modules&install=Application
While executing query "CREATE TABLE cms_cms_recruitment (
`status` varchar(32) NOT NULL default '',
`druid` varchar(32) NOT NULL default '',
`hunter` varchar(32) NOT NULL default '',
`mage` varchar(32) NOT NULL default '',
`paladin` varchar(32) NOT NULL default '',
`priest` varchar(32) NOT NULL default '',
`rogue` varchar(32) NOT NULL default '',
`shaman` varchar(32) NOT NULL default '',
`warlock` varchar(32) NOT NULL default '',
`warrior` varchar(32) NOT NULL default '',
`grpID` tinyint(10) NOT NULL default '0',
`showguildinfo` enum('1','0') NOT NULL default '1',
`guildrules` varchar(255) NOT NULL default '',
`rankstructure` varchar(255) NOT NULL default '',
`raidinginfo` varchar(255) NOT NULL default '',
`about` varchar(255) NOT NULL default '',
`appmessage` varchar(255) NOT NULL default '',
`appmessage_display` enum('1','0') NOT NULL default '1',
`appcomment` varchar(255) NOT NULL default '',
`recipient` varchar(100) NOT NULL default '',
`testname` varchar(50) NOT NULL default '',
`testrecipient` varchar(100) NOT NULL default '',
`altallowed` enum('1','0') NOT NULL default '0',
`druid_forum_id` varchar(32) NOT NULL default '',
`hunter_forum_id` varchar(32) NOT NULL default '',
`mage_forum_id` varchar(32) NOT NULL default '',
`paladin_forum_id` varchar(32) NOT NULL default '',
`priest_forum_id` varchar(32) NOT NULL default '',
`rogue_forum_id` varchar(32) NOT NULL default '',
`shaman_forum_id` varchar(32) NOT NULL default '',
`warlock_forum_id` varchar(32) NOT NULL default '',
`warrior_forum_id` varchar(32) NOT NULL default '',
`save_db` enum('1','0') NOT NULL default '1',
`post_forum` enum('1','0') NOT NULL default '0',
`post_id` int(50) NOT NULL default '',
`post_name` varchar(255) NOT NULL default '',
`post_sig` tinyint(10) NOT NULL default '0',
`send_mail` enum('1','0') NOT NULL default '0'
) TYPE=MyISAM DEFAULT CHARSET=utf8"

the following error occured: Invalid default value for 'post_id'

In: C:\wamp\www\includes\classes\installer.php on line: 61

by **robojerk** » Sat May 05, 2007 12:47 am

I got it to work on my test site...

If you were having problems before make sure the module is uninstalled, and go into cms_admin and make sure the radminapplication table is gone (view image below for phpmyadmin screenshot)..

Changes I made to /modules/Application/cpg_inst.php

Removed $prefix's
Set post_id to 1 (Might be isolated to something with my test server)

Code: Select all: <?php /********************************************* CPG-Dragonflyâ„¢ CMS ******************************************** Copyright Â© 2004 - 2005 by CPG Dev Team http://www.dragonflycms.com Dragonfly is released under the terms and conditions of the GNU GPL version 2 or any later version $Source: /cvs/modules/IRCChat/modules/IRCChat/cpg_inst.php,v $ $Revision: 9.2 $ $Author: djmaze $ $Date: 2005/02/10 00:55:52 $ **********************************************/ if (!defined('ADMIN_MOD_INSTALL')) { exit; } //global $prefix; class Application { var $radmin; var $version; var $modname; var $description; var $author; var $website; var $dbtables; function Application() { $this->radmin = true; $this->version = '2.0'; $this->modname = 'Recruitment_Settings'; $this->description = 'Recruitment mod'; $this->author = 'Unknown'; $this->website = 'www.wow-deception.com'; $this->dbtables = array('recruitment'); } function install() { global $installer, $prefix; $installer->add_query('CREATE', 'recruitment', " `status` varchar(32) NOT NULL default '', `druid` varchar(32) NOT NULL default '', `hunter` varchar(32) NOT NULL default '', `mage` varchar(32) NOT NULL default '', `paladin` varchar(32) NOT NULL default '', `priest` varchar(32) NOT NULL default '', `rogue` varchar(32) NOT NULL default '', `shaman` varchar(32) NOT NULL default '', `warlock` varchar(32) NOT NULL default '', `warrior` varchar(32) NOT NULL default '', `grpID` tinyint(10) NOT NULL default '0', `showguildinfo` enum('1','0') NOT NULL default '1', `guildrules` varchar(255) NOT NULL default '', `rankstructure` varchar(255) NOT NULL default '', `raidinginfo` varchar(255) NOT NULL default '', `about` varchar(255) NOT NULL default '', `appmessage` varchar(255) NOT NULL default '', `appmessage_display` enum('1','0') NOT NULL default '1', `appcomment` varchar(255) NOT NULL default '', `recipient` varchar(100) NOT NULL default '', `testname` varchar(50) NOT NULL default '', `testrecipient` varchar(100) NOT NULL default '', `altallowed` enum('1','0') NOT NULL default '0', `druid_forum_id` varchar(32) NOT NULL default '', `hunter_forum_id` varchar(32) NOT NULL default '', `mage_forum_id` varchar(32) NOT NULL default '', `paladin_forum_id` varchar(32) NOT NULL default '', `priest_forum_id` varchar(32) NOT NULL default '', `rogue_forum_id` varchar(32) NOT NULL default '', `shaman_forum_id` varchar(32) NOT NULL default '', `warlock_forum_id` varchar(32) NOT NULL default '', `warrior_forum_id` varchar(32) NOT NULL default '', `save_db` enum('1','0') NOT NULL default '1', `post_forum` enum('1','0') NOT NULL default '0', `post_id` int(50) NOT NULL default '1', `post_name` varchar(255) NOT NULL default '', `post_sig` tinyint(10) NOT NULL default '0', `send_mail` enum('1','0') NOT NULL default '0' ", 'recruitment'); $installer->add_query('INSERT', 'recruitment', '"Open", "High", "Closed", "Closed", "Closed", "Closed", "Closed", "Closed", "Closed", "Closed", "0", "1", "", "", "", "", "", "1", "", "", "", "", "0", "", "", "", "", "", "", "", "", "", "1", "0", "", "", "0", "0"'); $installer->add_query('CREATE', 'recruit_data', " `ID` int(100) unsigned NOT NULL auto_increment, `Name` varchar(255) NOT NULL default '', `age` varchar(5) NOT NULL default '', `email` varchar(255) NOT NULL default '', `time_zone` varchar(10) NOT NULL default '', `charname` varchar(255) NOT NULL default '', `class` varchar(50) NOT NULL default '', `lvl` varchar(30) NOT NULL default '', `fa_lvl` varchar(30) NOT NULL default '', `prof1` varchar(100) NOT NULL default '', `prof2` varchar(100) NOT NULL default '', `prof1_lvl` varchar(30) NOT NULL default '', `prof2_lvl` varchar(30) NOT NULL default '', `talentname` varchar(100) NOT NULL default '', `tpoint1` tinyint(10) NOT NULL default '0', `tpoint2` tinyint(10) NOT NULL default '0', `tpoint3` tinyint(10) NOT NULL default '0', `res_fr` tinyint(10) NOT NULL default '0', `res_shad` tinyint(10) NOT NULL default '0', `res_arc` tinyint(10) NOT NULL default '0', `res_nature` tinyint(10) NOT NULL default '0', `res_frost` tinyint(10) NOT NULL default '0', `att_ony` enum('Yes','No') NOT NULL default 'Yes', `att_mc` enum('Yes','No') NOT NULL default 'Yes', `att_bwl` enum('Yes','No') NOT NULL default 'Yes', `att_naxx` enum('Yes','No') NOT NULL default 'Yes', `att_kara` enum('Yes','No') NOT NULL default 'Yes', `att_serp` enum('Yes','No') NOT NULL default 'Yes', `att_eye` enum('Yes','No') NOT NULL default 'Yes', `att_hyjal` enum('Yes','No') NOT NULL default 'Yes', `gear_url` varchar(255) NOT NULL default '', `guild1` varchar(100) NOT NULL default '', `guild2` varchar(100) NOT NULL default '', `guild3` varchar(100) NOT NULL default '', `guild_reason` varchar(255) NOT NULL default '', `scale_play` tinyint(10) NOT NULL default '0', `flymount` enum('Yes','No') NOT NULL default 'Yes', `raid_mon` enum('Yes','No') NOT NULL default 'Yes', `raid_tues` enum('Yes','No') NOT NULL default 'Yes', `raid_wed` enum('Yes','No') NOT NULL default 'Yes', `raid_thurs` enum('Yes','No') NOT NULL default 'Yes', `raid_fri` enum('Yes','No') NOT NULL default 'Yes', `raid_sat` enum('Yes','No') NOT NULL default 'Yes', `raid_sun` enum('Yes','No') NOT NULL default 'Yes', `bosses_zul` varchar(255) NOT NULL default '', `bosses_mc` varchar(255) NOT NULL default '', `bosses_bwl` varchar(255) NOT NULL default '', `bosses_aq40` varchar(255) NOT NULL default '', `bosses_naxx` varchar(255) NOT NULL default '', `bosses_kara` varchar(255) NOT NULL default '', `bosses_mag` varchar(255) NOT NULL default '', `bosses_gruul` varchar(255) NOT NULL default '', `bosses_serp` varchar(255) NOT NULL default '', `bosses_eye` varchar(255) NOT NULL default '', `bosses_bltemple` varchar(255) NOT NULL default '', `bosses_hyjal` varchar(255) NOT NULL default '', `tbc_key_shatter` enum('Yes','No') NOT NULL default 'Yes', `tbc_key_shadow` enum('Yes','No') NOT NULL default 'Yes', `tbc_key_arc` enum('Yes','No') NOT NULL default 'Yes', `tbc_hfc_rep` enum('Yes','No') NOT NULL default 'Yes', `tbc_cfr_rep` enum('Yes','No') NOT NULL default 'Yes', `tbc_auch_rep` enum('Yes','No') NOT NULL default 'Yes', `tbc_tk_rep` enum('Yes','No') NOT NULL default 'Yes', `read_faqs` enum('Yes','No') NOT NULL default 'Yes', `cdate` date NOT NULL default '0000-00-00', `other_notes` varchar(255) NOT NULL default '', PRIMARY KEY (`ID`) ", 'recruit_data'); return true; } function uninstall() { global $installer; $installer->add_query('DROP', 'recruitment'); $installer->add_query('DROP', 'recruit_data'); return true; } function upgrade($prev_version) { return true; } }

That got it to work.

by **Equisetum** » Sat May 05, 2007 12:53 am

That worked for me!!

Thanks!

by **Razac** » Sat May 05, 2007 1:27 am

sigh see an over sight.

I forgot that the add_query funtion already adds the prefix. DUH..

I will make that change in my version and repost.

TY for the catch.

is everything working fine now... if so what do you think???

Also as I mentioned I need some one to test the mail out function as sendmail on my linux box isnt configured yet

by **Razac** » Sat May 05, 2007 1:38 am

The only thing I know that is missing is the message to tell the user that they didnt fill out the security image right. it currently just reloads the form filled in..

Minor oversight..

FYI it is also set up to default save to DB if you try and select No to all output options (DB, Forum and email)

by **robojerk** » Sat May 05, 2007 2:14 am

I ran into some major issues with the admin page..

Also, after updating the settings when you click on modify again are the "status" for each class and if recruitment is open or closed reset to closed.

by **robojerk** » Sat May 05, 2007 4:42 am

I have a fix.. Gimme a few to see if there is anything else that needs tweaking.

by **robojerk** » Sat May 05, 2007 5:33 am

Question: Is anyone else having the problesms as me.. My test environment is kind of weird and I just want to make sure this isn't an issue with my testing environment.

by **Anaxent** » Sat May 05, 2007 5:52 am

Sorry I have not had the chance to try this out yet i will get it installed today for testing on my site.