Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.220

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Wow recruitment and application

Wow recruitment and application
Goto page 1, 2 Next

12 Replies / 1841 Views


www.clanthemes.com Forum Index » Custom Work	View previous topic :: View next topic

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Wed Apr 22, 2009 8:27 pm
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

hi there this pack is brill but i was wondering if someone could add the death knight class to it also please?

http://www.clanthemes.com/club-download-file-620-wow-guild-application-and-recruitment-module.html

above is the link to the mod.

many thanks

floppy
Reputation: 2087.2
votes: 22
Local time: 2:02 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Wow recruitment and application Posted: Wed Apr 22, 2009 11:54 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Do me a favor, backup your current sql before you try this cause I am purely guessing.

Then run this in phpmyadmin

Code:

DROP TABLE IF EXISTS `recruitment_classes`;
CREATE TABLE `recruitment_classes` (
`name` varchar(32) NOT NULL,
`status` varchar(32) NOT NULL,
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recruitment_classes`
--

INSERT INTO `recruitment_classes` (`name`, `status`) VALUES ('Status', 'Open'),
('Druid', 'High'),
('Death Knight', 'High'),
('Hunter', 'High'),
('Mage', 'High'),
('Paladin', 'High'),
('Priest', 'High'),
('Rogue', 'High'),
('Shaman', 'High'),
('Warlock', 'High'),
('Warrior', 'High');

Phpnuke Downloads | VMaxxRx Male Enhancement

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Thu Apr 23, 2009 2:31 pm
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

hi thx for reply. unfortunatley i couldnt get it to work still
however im sure like myself many would appreciate it very much if one of you experts would spend some time on this mod making ready to download with the deathknight class. Personally im not any good at code etc.
many thanks in advance to anyone who has a shot at this.

floppy
Reputation: 2087.2
votes: 22
Local time: 2:02 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Wow recruitment and application Posted: Thu Apr 23, 2009 4:37 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Why didn't the code I gave you work?

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Thu Apr 23, 2009 4:49 pm
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

i have no idea. perhapt im doing it wrong. like i said unfortunaltely im no good at all the coding stuff.
Ill give it another try and let you know ;)
thx for reply

floppy
Reputation: 2087.2
votes: 22
Local time: 2:02 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Wow recruitment and application Posted: Fri Apr 24, 2009 2:01 am
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Find phpmyadmin in your cpanel or whatever.

Select your nuke database

At the top left click the insert tab

Paste the code I posted and hit go at the bottom right

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Fri Apr 24, 2009 12:43 pm
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

Very big thanks for the help like i said im not good at code but i did what you said. At 1st i failed but im not a quiter. Tried again and worked. Many thanks to you for the help :)

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Wed Apr 29, 2009 4:42 pm
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

All of a sudden i get this error

Error updating database: update recruitment_classes set `knight`='Medium' where `name`='death'
Error updating database: update recruitment_classes set ``='Update' where `name`='Submit'

was working ok before. i tried a fresh install and did what u said again but still this appears. so i cant set the required status for that class.
any help appreciated.
thx
p.s. where it says `knight`='Medium' it says this when i put high or low status to.

floppy
Reputation: 2087.2
votes: 22
Local time: 2:02 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Wow recruitment and application Posted: Wed Apr 29, 2009 7:48 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

The problem is when I gave you the original code

Quote:

INSERT INTO `recruitment_classes` (`name`, `status`) VALUES ('Status', 'Open'),
('Druid', 'High'),
('Death Knight', 'High'),
('Hunter', 'High'),
('Mage', 'High'),
('Paladin', 'High'),
('Priest', 'High'),
('Rogue', 'High'),
('Shaman', 'High'),
('Warlock', 'High'),
('Warrior', 'High');

Death Knight can not have a space in it "Death Knight" it either needs to be changed via phpmyadmin to DeathKnight.

GhOsTxxx
Reputation: 508.9
Local time: 2:02 AM

Tree Hugger

0.04 posts per day
Medals: 0

Joined: Oct 01, 2007
Last Visit: 18 Apr 2011
Posts: 58
Points: 10791

Wow recruitment and application Posted: Thu Apr 30, 2009 12:41 am
Shop Purchases:World of Warcraft Splash Screen · WOW Wrath Of The Lich King Theme · Modern Gamer Evo Multi Theme · Call of Duty: Black Ops Age Gate Splash Screen

tyvm it works as you said. thx again

Taurathian
Reputation: 0.7
Local time: 2:02 AM

Noob

0.01 posts per day
Medals: 0

Joined: Dec 23, 2008
Last Visit: 20 May 2009
Posts: 6
Points: 68

Wow recruitment and application Posted: Sun May 17, 2009 11:04 pm

First of all thanks, I tried this forever, not really knowing much about MySQL. This code snippet does in fact put the Death Knight in the recruitment block. The problem is in the application module, on the page that applicants fill out, there is no Death Knight in the drop down box for Class. There is also no Inscription as a selection under the Profession drop down. Is this handled thru a table in the database? here is a link to it on my site. http://guildanamcara.com/modules.php?name=Application&apply=true

Any help would be greatly appreciated.

Taurathian
Reputation: 0.7
Local time: 2:02 AM

Noob

0.01 posts per day
Medals: 0

Joined: Dec 23, 2008
Last Visit: 20 May 2009
Posts: 6
Points: 68

Wow recruitment and application Posted: Mon May 18, 2009 12:11 am

I actually found it on my own. Just in case anyone else is trying to do this. The snippet of SQL code provided above will add Death Knight to the recruitment block. To add Death Knight as a class and Inscription as a profession you need to edit the webroot \modules\Application\request_forum.php file.

Find the section switch(strtolower($type)) and replace the code between { and } with the following code. (it looks like its line 619-673)

Code:

case "age":
      echo " <option value=\"\">Age</option>\n";
      echo " <option value=\"1\""; if($selected == 1) echo " selected=\"selected\""; echo ">Under 16</option>\n";
      echo " <option value=\"2\""; if($selected == 2) echo " selected=\"selected\""; echo ">16-20</option>\n";
      echo " <option value=\"3\""; if($selected == 3) echo " selected=\"selected\""; echo ">21-30</option>\n";
      echo " <option value=\"4\""; if($selected == 4) echo " selected=\"selected\""; echo ">Over 30</option>\n";
      break;
   case "class":
      echo " <option value=\"\">Class</option>\n";
      echo " <option value=\"1\""; if($selected == 1) echo " selected=\"selected\""; echo ">Druid</option>\n";
      echo " <option value=\"2\""; if($selected == 2) echo " selected=\"selected\""; echo ">DeathKnight</option>\n";
      echo " <option value=\"3\""; if($selected == 3) echo " selected=\"selected\""; echo ">Hunter</option>\n";
      echo " <option value=\"4\""; if($selected == 4) echo " selected=\"selected\""; echo ">Mage</option>\n";
      echo " <option value=\"5\""; if($selected == 5) echo " selected=\"selected\""; echo ">Paladin</option>\n";
      echo " <option value=\"6\""; if($selected == 6) echo " selected=\"selected\""; echo ">Priest</option>\n";
      echo " <option value=\"7\""; if($selected == 7) echo " selected=\"selected\""; echo ">Rogue</option>\n";
      echo " <option value=\"8\""; if($selected == 8) echo " selected=\"selected\""; echo ">Shaman</option>\n";
      echo " <option value=\"9\""; if($selected == 9) echo " selected=\"selected\""; echo ">Warlock</option>\n";
      echo " <option value=\"10\""; if($selected == 10) echo " selected=\"selected\""; echo ">Warrior</option>\n";
      break;
   case "time":
      echo " <option value=\"\">Timezone</option>\n";
      echo " <option value=\"1\""; if($selected == 1) echo " selected=\"selected\""; echo ">Eastern</option>\n";
      echo " <option value=\"2\""; if($selected == 2) echo " selected=\"selected\""; echo ">Central</option>\n";
      echo " <option value=\"3\""; if($selected == 3) echo " selected=\"selected\""; echo ">Mountain</option>\n";
      echo " <option value=\"4\""; if($selected == 4) echo " selected=\"selected\""; echo ">Pacific</option>\n";
      echo " <option value=\"5\""; if($selected == 5) echo " selected=\"selected\""; echo ">Other</option>\n";
      break;
   case "play":
      echo " <option value=\"\">PlayStyle\n";
      echo " <option value=\"1\""; if($selected == 1) echo " selected=\"selected\""; echo ">1(casual)</option>\n";
      echo " <option value=\"2\""; if($selected == 2) echo " selected=\"selected\""; echo ">2</option>\n";
      echo " <option value=\"3\""; if($selected == 3) echo " selected=\"selected\""; echo ">3</option>\n";
      echo " <option value=\"4\""; if($selected == 4) echo " selected=\"selected\""; echo ">4</option>\n";
      echo " <option value=\"5\""; if($selected == 5) echo " selected=\"selected\""; echo ">5</option>\n";
      echo " <option value=\"6\""; if($selected == 6) echo " selected=\"selected\""; echo ">6</option>\n";
      echo " <option value=\"7\""; if($selected == 7) echo " selected=\"selected\""; echo ">7</option>\n";
      echo " <option value=\"8\""; if($selected == 8) echo " selected=\"selected\""; echo ">8</option>\n";
      echo " <option value=\"9\""; if($selected == 9) echo " selected=\"selected\""; echo ">9</option>\n";
      echo " <option value=\"10\""; if($selected == 10) echo " selected=\"selected\""; echo ">10(hardcore)</option>\n";
      break;
   case "prof":
      echo "<option value=\"\">Profession</option>\n";
      echo "<option value=\"1\""; if($selected == 1) echo " selected=\"selected\""; echo ">Alchemy</option>\n";
      echo "<option value=\"2\""; if($selected == 2) echo " selected=\"selected\""; echo ">Blacksmithing</option>\n";
      echo "<option value=\"3\""; if($selected == 3) echo " selected=\"selected\""; echo ">Enchanting</option>\n";
      echo "<option value=\"4\""; if($selected == 4) echo " selected=\"selected\""; echo ">Engineering</option>\n";
      echo "<option value=\"5\""; if($selected == 5) echo " selected=\"selected\""; echo ">Herbalism</option>\n";
      echo "<option value=\"6\""; if($selected == 6) echo " selected=\"selected\""; echo ">Inscription</option>\n";
      echo "<option value=\"7\""; if($selected == 7) echo " selected=\"selected\""; echo ">Leatherworking</option>\n";
      echo "<option value=\"8\""; if($selected == 8) echo " selected=\"selected\""; echo ">Mining</option>\n";
      echo "<option value=\"9\""; if($selected == 9) echo " selected=\"selected\""; echo ">Skinning</option>\n";
      echo "<option value=\"10\""; if($selected == 10) echo " selected=\"selected\""; echo ">Tailoring</option>\n";
      echo "<option value=\"11\""; if($selected == 11) echo " selected=\"selected\""; echo ">Jewel Crafting</option>\n";
      break;

Hope this helps anyone else trying to fix this.

www.clanthemes.com Forum Index » Custom Work

12 Replies / 1841 Views
Page 1 of 2
All times are GMT
Goto page 1, 2 Next

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work