Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 03-11-2002, 02:11 AM
amity's Avatar
amity amity is offline
 
Join Date: Feb 2002
Location: PA usa
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

okey dokey. it didn't work. i was getting a parse error. i will attach the full import script, and the part that i left out when i tried to run the script. i can't run the poll section of the import or i receive an error- so i need to import without it.

someone please help? pretty please?
always,
amity

this is the part i tried to delete and run...
attached is the whole script.
Code:
$action = "polls";
	}

}

// ####################################################################################
// IMPORT POLLS
// ####################################################################################

if ($action=="polls") {

	doformheader("bbimport_w3t","dopolls");
	makehiddencode("iserver","$iserver");
	makehiddencode("idbname","$idbname");
	makehiddencode("iuser","$iuser");
	makehiddencode("ipasswd","$ipasswd");

	maketableheader("Step 8: Import UBBThreads polls");
	makedescription("<p>We will now import all your UBBThreads polls into the vBulletin database.</p>");

	doformfooter("Import polls");

}

// ####################################################################################
// DO IMPORT POLLS
// ####################################################################################

if ($action=="dopolls") {


	echo "<p>Importing polls ....</p>\n\n";
	flush();

	if ($startat=="") {
		$startat = 0;
	}

	$ipolls=$DB_site->query("SELECT DISTINCT P_Name FROM $idbname.w3t_Polls ORDER BY P_Name LIMIT $startat,$perpage");
	if ($DB_site->num_rows($ipolls)) {
		while ($ipoll=$DB_site->fetch_array($ipolls)) {
			$options=0;

			$ioptions=$DB_site->query("SELECT P_Title,P_Option AS optionname,w3t_Polls.P_Number AS optionid,COUNT(w3t_PollData.P_Number) AS votes FROM $idbname.w3t_Polls LEFT JOIN $idbname.w3t_PollData USING (P_Name,P_Number) WHERE w3t_Polls.P_Name='".addslashes($ipoll['P_Name'])."' GROUP BY w3t_Polls.P_Number ORDER BY w3t_Polls.P_Number");
			while ($ioption = $DB_site->fetch_array($ioptions)) {
				if ($ipoll['question']=="") {
					$ipoll['question'] = $ioption['P_Title'];
				}

        $ioption['optionname']=str_replace("|||"," || | ",$ioption['optionname']);
        $optionsstring .= "|||".$ioption['optionname']; //||| is delimter, 0 means no votes (as new poll)
        $votesstring .= "|||$ioption[votes]";
        $options++;
			}

			if (substr($optionsstring,0,3)=="|||") {
				$optionsstring=substr($optionsstring,3);
			}
			if (substr($votesstring,0,3)=="|||") {
				$votesstring=substr($votesstring,3);
			}

			$DB_site->query("INSERT INTO poll (importpollid,question,dateline,options,votes,numberoptions) VALUES ('$ipoll[P_Name]','".addslashes($ipoll['question'])."',".time().",'".addslashes($optionsstring)."','".addslashes($votesstring)."',$options)");

			echo "<p>Poll imported correctly</p>";
		}

		$iserver = urlencode($iserver);
		$idbname = urlencode($idbname);
		$iuser = urlencode($iuser);
		$ipasswd = urlencode($ipasswd);

		$startat+=$perpage;

		echo iif(!$pause,"<script language=\"javascript\">window.location=\"bbimport_w3t.php?s=$session[sessionhash]&action=dopolls&startat=$startat&perpage=$perpage&pause=$pause&iserver=$iserver&idbname=$idbname&iuser=$iuser&ipasswd=$ipasswd\";</script>\b","");
		echo "<hr><b>&raquo; <a href=\"bbimport_w3t.php?s=$session[sessionhash]&action=dopolls&startat=$startat&perpage=$perpage&pause=$pause&iserver=$iserver&idbname=$idbname&iuser=$iuser&ipasswd=$ipasswd\">Click here to continue importing polls</a> &laquo;</b>\n";

	} else {
		echo "<p>polls imported sucessfully.</p>";
		$action = "threads";
	}

}

//
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:52 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06660 seconds
  • Memory Usage 2,521KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (6)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete