vb.org Archive - i just installed the sql query from control panel hack- i need to delete all imported

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

i just installed the sql query from control panel hack- i need to delete all imported

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

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. :)

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

Duh... it's DROP TABLE tblName; :)

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

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

        }



}



//

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.

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

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

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
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01070 seconds Memory Usage 1,751KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: