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>» <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> «</b>\n";
} else {
echo "<p>polls imported sucessfully.</p>";
$action = "threads";
}
}
//