PDA

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


amity
09 Mar 2002, 16:01
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

Chen
09 Mar 2002, 19:21
Well basically to drop a table you do this:
DROP tblName;
So type this as the query:
SHOW tables;
This'll give you a list of all tables in the database. Then just type the DROP query for each one. :)

amity
10 Mar 2002, 01:46
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

Chen
10 Mar 2002, 11:11
Duh... it's DROP TABLE tblName; :)

amity
10 Mar 2002, 18:28
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
11 Mar 2002, 03:11
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.

$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
11 Mar 2002, 04:10
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
11 Mar 2002, 04:27
oh, i dunno. this is getting frustrating... really any ideas would be greatly appreciated.


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
11 Mar 2002, 04:34
Script: http://amitymama.com/vb/vb/importers/bbimport_w3t.php


this should read

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


where should i change this?

maybe i am getting somewhere.
ugh
amity

Chen
11 Mar 2002, 12:07
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. :)