DF Guild Application w/ Recruitment Block

Dragonfly integration forum

DF Guild Application w/ Recruitment Block

Postby 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?
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby 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.
Razac
WR.net Journeyman
WR.net Journeyman
 
Posts: 145
Joined: Thu Jul 27, 2006 6:00 pm

DF Guild Application w/ Recruitment Block

Postby Razac » Fri May 04, 2007 8:43 pm

okie found a spot to store it.

Recruitment Module v2.01
Razac
WR.net Journeyman
WR.net Journeyman
 
Posts: 145
Joined: Thu Jul 27, 2006 6:00 pm

DF Guild Application w/ Recruitment Block

Postby 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.
Last edited by Equisetum on Fri May 04, 2007 11:56 pm, edited 2 times in total.
Image
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

DF Guild Application w/ Recruitment Block

Postby 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..
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby 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?
Image
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

DF Guild Application w/ Recruitment Block

Postby 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
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

Re: DF Guild Application w/ Recruitment Block

Postby 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.
Attachments
Last edited by robojerk on Sat May 05, 2007 12:48 am, edited 1 time in total.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby Equisetum » Sat May 05, 2007 12:53 am

That worked for me!!

Thanks!
Image
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

DF Guild Application w/ Recruitment Block

Postby 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
Razac
WR.net Journeyman
WR.net Journeyman
 
Posts: 145
Joined: Thu Jul 27, 2006 6:00 pm

DF Guild Application w/ Recruitment Block

Postby 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)
Razac
WR.net Journeyman
WR.net Journeyman
 
Posts: 145
Joined: Thu Jul 27, 2006 6:00 pm

Re: DF Guild Application w/ Recruitment Block

Postby 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.
Attachments
dropdown.png
dropdown.png (4.94 KiB) Viewed 234 times
index.zip
Application/admin/index.inc
(3.58 KiB) Downloaded 49 times
Last edited by robojerk on Sat May 05, 2007 2:20 am, edited 2 times in total.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby 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.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby 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.
Image
For the Horde!
Image
User avatar
robojerk
WR.net Master
WR.net Master
 
Posts: 484
Joined: Wed Jul 05, 2006 12:17 am
Location: -The OmniMatrix- Web 3.0

DF Guild Application w/ Recruitment Block

Postby 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.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

PreviousNext

Return to Dragonfly

Who is online

Users browsing this forum: No registered users and 0 guests

cron