View Single Post
  #786  
Old 03-13-2007, 01:32 AM
RedGTiVR6 RedGTiVR6 is offline
 
Join Date: Dec 2006
Location: Little Elm, TX
Posts: 817
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

djjeffa - I've been trying to figure out the same thing for a few weeks now....only to effectively be stone walled...I still can't log into the Dev area of Zoints to download any blocks....


This is the block that the developer wrote to pull the normal profile information. I'm trying to pull fields 18-32 instead of fields 1-5 like this block seems to pull. No dice on my end, but it might help you seeing as how it pulls location, etc on our board.
Code:
# 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 = 18
				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;
	}
}
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01544 seconds
  • Memory Usage 1,774KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete