The Arcive of Official vBulletin Modifications Site.

amity · #1 03-09-2002, 03:01 PM

hi! i was helped by chen last evening, and now i have another question. my import of wwwthreads did not work- there was an error in the polls and now i must import all over again. i have taken the polls section out of the import script- and downloaded the sql query hack for my vb admin panel (since i cannot access this data base through mysql admin).

how would i go about deleting all information within a database? i don't want to delete the database itself. could someone tell me the query to run?

i apologize, i am not a programmer- i learn what i need as i go.

http://www.amitymama.com/vb/index.php?

these are my forums- i am almost done and would like to finish today.

thank you sooooo much in advance!!
always,
amity

Admin · #2 03-09-2002, 06:21 PM

Well basically to drop a table you do this:

Code:

DROP tblName;

So type this as the query:

Code:

SHOW tables;

This'll give you a list of all tables in the database. Then just type the DROP query for each one.

amity · #3 03-10-2002, 12:46 AM

when i put in the command
DROP access; (for example) i am getting this error message:
Database error in vBulletin Control Panel 2.2.3:

Invalid SQL: DROP access;
mysql error: You have an error in your SQL syntax near 'access' at line 1

mysql error number: 1064

Date: Saturday 09th of March 2002 09:42:06 PM
Script: http://amitymama.com/vb/vb/admin/query.php
Referer:
http://www.amitymama.com/vb/admin/query.php?t=0

i am sorry to bother you. i think i did the query the right way.

have a great evening... always
amity

Admin · #4 03-10-2002, 10:11 AM

Duh... it's DROP TABLE tblName;

amity · #5 03-10-2002, 05:28 PM

while i was deleting the tables, i received an error. so i decided to just upload the install and start over again.

i am about to do the import again- i took out the polls part of the script. i hope this works!!

thank you again chen. your username should be lifesaver... not firefly.

always,
amity

amity · #6 03-11-2002, 02:11 AM

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";
	}

}

//

TECK · #7 03-11-2002, 03:10 AM

what is the parse error?
a little tip for you when you post the code: use [code] or [php] bbCodes to display your code in a elegant way.

regards,
nakkid.

amity · #8 03-11-2002, 03:27 AM

oh, i dunno. this is getting frustrating... really any ideas would be greatly appreciated.

Code:

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: SELECT U_Username AS username,U_Password AS password,U_email AS email,U_Totalposts AS posts,U_Laston AS lastvisit,U_Homepage AS homepage,U_Occupation AS occupation,U_Hobbies AS hobbies,U_Location AS location,U_Bio AS biography,U_Sort AS daysprune,U_PostsPer AS maxposts,U_Number AS importuserid,U_Notify AS emailnotification,U_Registered AS joindate,U_Picture AS avatar,U_AcceptPriv AS reveivepm,U_RegIP AS ipaddress,U_Groups AS usergroup,U_title AS usertitle FROM amitysworld_com.w3t_Users ORDER BY importuserid LIMIT 0,50
mysql error: Access denied for user: 'amitymes@localhost' to database 'amitysworld_com'

mysql error number: 1044

Date: Monday 11th of March 2002 12:24:37 AM
Script: http://amitymama.com/vb/vb/importers/bbimport_w3t.php
Referer: http://www.amitymama.com/vb/importers/bbimport_w3t.php

amity · #9 03-11-2002, 03:34 AM

Code:

Script: http://amitymama.com/vb/vb/importers/bbimport_w3t.php

this should read

Code:

http://amitymama.com/vb/importers/bbimport_w3t.php

where should i change this?

maybe i am getting somewhere.
ugh
amity

Admin · #10 03-11-2002, 11:07 AM

Your problem is not with the script (which I removed from your first post, we don't allow to post full files of vBulletin).
It's with the database permissions, for some reason the user you are using can't access the 'amitysworld_com' database. Ask your host for more help.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04026 seconds Memory Usage 2,262KB Queries Executed 13 (?)
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 (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (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)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_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 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!