[RedGTiVR6]

Can anyone tell me if this mod added any tables to the DB and if so, what are the names of those tables?

Perhaps I should ask for some assistance on this.

I have added Zoints to our web site.

One of the blocks that's avaliable out there will take the additional fields that are added to the normal profile (for lack of a better term) and port them over to your Zoints profile page.

It calls on table "cprofilefield" for this information.

I'm gathering that this mod uses the same table?

I'm trying to figure out how to tell this block to look at the fields for this mod rather than the fields that are under the normal profile area. I'm sure it's super easy (or maybe I'm just that ignorant), but I can't figure it out.

I've attached the code below.

# vBulletin Custom Profile Fields
# 1.0
# Soup (soup@zoints.com)
# http://dev.zoints.com/
#
# This block lets you display your custom profile fields
# from the old vBulletin profile
class user_vbulletin_custom_profile_fields extends z_module
{
	function contents()
	{
		$vbulletin = $this->_zoints->external->vbulletin;
		$languageid = intval($vbulletin->userinfo['languageid']);
		
		# get custom phrases used in this block
		$vbphrase = array();
		$phrases = $vbulletin->db->query_read("
			SELECT * FROM " . TABLE_PREFIX . "phrase
			WHERE fieldname = 'cprofilefield'
				AND (languageid = $languageid OR languageid = -1)
			ORDER BY languageid DESC
		");
		while ($phrase = $vbulletin->db->fetch_array($phrases))
		{
			$vbphrase[$phrase['varname']] = $phrase['text'];
		}
		unset($phrase);
		$vbulletin->db->free_result($phrases);

		# get data from usertextfield for this user
		$extended_info = $vbulletin->db->query_first("
			SELECT * FROM " . TABLE_PREFIX . "userfield
			WHERE userid = " . $this->zuser . "
		");

		$profilefields = $vbulletin->db->query_read("
			SELECT profilefieldid, required, type, data, def, height
			FROM " . TABLE_PREFIX . "profilefield
			WHERE form = 0
				AND hidden = 0
			ORDER BY displayorder
		");

		$search = array(
			'#(\r\n|\n|\r)#',
			'#(<br />){3,}#', // Replace 3 or more <br /> with two <br />
		);
		$replace = array(
			'<br />',
			'<br /><br />',
		);
		
		$customfields = '';
		while ($profilefield = $vbulletin->db->fetch_array($profilefields))
		{
			$profilefieldname = "field$profilefield[profilefieldid]";
			$profilefield['title'] = $vbphrase[$profilefieldname . '_title'];
		
			if ($profilefield['type'] == 'checkbox' OR $profilefield['type'] == 'select_multiple')
			{
				$data = unserialize($profilefield['data']);
				foreach ($data AS $key => $val)
				{
					if ($extended_info["$profilefieldname"] & pow(2, $key))
					{
						$profilefield['value'] .= iif($profilefield['value'], ', ') . $val;
					}
				}
			}
			else if ($profilefield['type'] == 'textarea')
			{
				$profilefield['value'] = preg_replace($search, $replace, trim($extended_info["$profilefieldname"]));
			}
			else
			{
				$profilefield['value'] = $extended_info["$profilefieldname"];
			}
			
			if ($profilefield['value'] != '')
			{
				$customfields .= '<div class="' . $this->style['phead'] . '">' . $profilefield['title'] . '</div>';
				$customfields .= '<div class="' . $this->style['pmain1'] . '">' . $profilefield['value'] . '</div>';
			}
		
		}
		$vbulletin->db->free_result($profilefields);
		
		return $customfields;
	}
}

Any help would be greatly appreciated!