Miscellaneous Hacks - World of Warcraft Class Recruitment Status module (db backend)

This mod is no longer supported it has been rewritten.

The new mod is available here:
https://vborg.vbsupport.ru/showthread.php?t=150449

[NightPhoenix]

Fatal error: Call to a member function on a non-object

Line 31 of class_recruit.php

[turnipofdoom]

Well Line 31 is blank in my file so here.

for php5 and only 5.

<?php
/*======================================================================*\
	class_recruit.php
	------------------------------------------------------------------
	
	 * Dark Portal Syndicate http://www.darkportals.com
	 * Copyright 2002-2007
	 * ------------------
	 * class_recruit.php
	 * Began: 6/27/05
	 * Last Modified 1/27/2007
	 * Authors: Delinah Howard, Jessica Zakhar. <site-admins@darkportals.com>
	------------------------------------------------------------------

\*=======================================================================*/


class recruit {
	
	private $vbObj;
	
	function __construct()
		{	
			global $vbulletin;
			$this->vbObj =& $vbulletin;
			
		}
		
	function getStatus( $query )
	{
		
		$result = $this->vbObj->db->fetch_array( 
				  $this->vbObj->db->query_read( "SELECT status FROM recruitment WHERE class='$query'" ) );
		
		return strip_tags( $result['status'] );
	}

	
	function setStatus( $druid,
						$hunter, 
						$mage, 
						$paladin, 
						$priest, 
						$rogue, 
						$shaman,
						$warlock, 
						$warrior )
	{
	
	$classes = array(
					'Druid' => $this->vbObj->db->escape_string( strip_tags( $druid, '<b>' ) ),
					'Hunter' => $this->vbObj->db->escape_string( strip_tags( $hunter, '<b>' ) ), 
					'Mage' => $this->vbObj->db->escape_string( strip_tags( $mage, '<b>' ) ),
					'Paladin' => $this->vbObj->db->escape_string( strip_tags( $paladin, '<b>' ) ),
					'Priest' => $this->vbObj->db->escape_string( strip_tags( $priest, '<b>' ) ),
					'Rogue' => $this->vbObj->db->escape_string( strip_tags( $rogue, '<b>') ),
					'Shaman' => $this->vbObj->db->escape_string( strip_tags( $shaman, '<b>' ) ),
					'Warlock' => $this->vbObj->db->escape_string( strip_tags( $warlock, '<b>' ) ),
					'Warrior' => $this->vbObj->db->escape_string( strip_tags( $warrior, '<b>' ) )
					);

	foreach( $classes AS $key => $value )
		{
			$query = ( "UPDATE recruitment SET status='$value' WHERE class='$key'" );
			$this->vbObj->db->query( $query );
		}
	}
}
?>

and php4

<?php
/*======================================================================*\
	class_recruit.php
	------------------------------------------------------------------
	
	 * Dark Portal Syndicate http://www.darkportals.com
	 * Copyright 2002-2007
	 * ------------------
	 * class_recruit.php
	 * Began: 6/27/05
	 * Last Modified 1/27/2007
	 * Authors: Delinah Howard, Jessica Zakhar. <site-admins@darkportals.com>
	------------------------------------------------------------------

\*=======================================================================*/


class recruit {
	
	var $vbObj;
	
	function recruit()
		{	
			global $vbulletin;
			$this->vbObj =& $vbulletin;
			
		}
		
	function getStatus( $query )
	{
		
		$result = $this->vbObj->db->fetch_array( 
				  $this->vbObj->db->query_read( "SELECT status FROM recruitment WHERE class='$query'" ) );
		
		return strip_tags( $result['status'] );
	}

	
	function setStatus( $druid,
						$hunter, 
						$mage, 
						$paladin, 
						$priest, 
						$rogue, 
						$shaman,
						$warlock, 
						$warrior )
	{
	
	$classes = array(
					'Druid' => $this->vbObj->db->escape_string( strip_tags( $druid, '<b>' ) ),
					'Hunter' => $this->vbObj->db->escape_string( strip_tags( $hunter, '<b>' ) ), 
					'Mage' => $this->vbObj->db->escape_string( strip_tags( $mage, '<b>' ) ),
					'Paladin' => $this->vbObj->db->escape_string( strip_tags( $paladin, '<b>' ) ),
					'Priest' => $this->vbObj->db->escape_string( strip_tags( $priest, '<b>' ) ),
					'Rogue' => $this->vbObj->db->escape_string( strip_tags( $rogue, '<b>') ),
					'Shaman' => $this->vbObj->db->escape_string( strip_tags( $shaman, '<b>' ) ),
					'Warlock' => $this->vbObj->db->escape_string( strip_tags( $warlock, '<b>' ) ),
					'Warrior' => $this->vbObj->db->escape_string( strip_tags( $warrior, '<b>' ) )
					);

	foreach( $classes AS $key => $value )
		{
			$query = ( "UPDATE recruitment SET status='$value' WHERE class='$key'" );
			$this->vbObj->db->query( $query );
		}
	}
}
?>

[hannie]

i can get this to come up but it doesn't appear in a module - it appears on the top of the page - any idea whats going on?

[aitonk]

I get this error when trying to add the SQL Database

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `recr

[turnipofdoom]

Originally Posted by hannie

i can get this to come up but it doesn't appear in a module - it appears on the top of the page - any idea whats going on?

Yeah enable clean file output in the module you created in vbadvanced.

[turnipofdoom]

Originally Posted by aitonk

I get this error when trying to add the SQL Database

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `recr

CREATE TABLE `recruitment` (
`Class` varchar(15) NOT NULL default '',
`Status` varchar(15) NOT NULL default '',
PRIMARY KEY (`Class`)
) ENGINE=MyISAM;

just remove 'DEFAULT CHARSET=latin1

[SReid]

Thanks for making this! Installed at www.malevolenceguild.org

[Feanor]

I can't get it to work - I've tried all the ideas in this thread, and the best I can come up with is a homepage consisting of just this:

[turnipofdoom]

Originally Posted by Feanor

I can't get it to work - I've tried all the ideas in this thread, and the best I can come up with is a homepage consisting of just this:

Are you trying to display the recruitment status page and the update page on the same VB page? Even that should not kick that kind of error... You trying to include class_recruit more than once?

[darkie79]

I would love to install this, but it would be more beneficial to our community as a recruitment tool for specific roles within the community (ie, tournament admin/cs:s team, etc)..how hard would it be to change this to accomodate our needs?

Thanks