How do I run an sql file with that sql hack?

[Gutspiller]

I'm working on installing that Tombot hack (https://vborg.vbsupport.ru/showthread.php?s=&threadid=48053&highlight=bot) and there's a spot in the instructions I needed help with. I know I could ask this in the hack forum, but I was hoping to get this bad boy installed tonight.

In the instructions it says: Run the SQL file that is inside the sql folder in phpmyadmin

How do I run the sql file if I have that hack of Fireflys (I think it's his)? Do I just put in http://www.theforumz.com/forumz/blah.sql and press the button?

The other question I have is, how do this instruction: "Login to phpmyadmin and check in the 'bots' table that the bot id is 0"?

If somebody can help me with these questions ASAP I would really appreciate it, I want to get this thing done.

Thanks a million!

[MentaL]

php my admin / show processes / databases / choose the database your running tombot on / sql

browse and upload

[Gutspiller]

Today at 09:53 PM mentalrz said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=414851#post414851)
php my admin / show processes / databases / choose the database your running tombot on / sql

browse and upload


yeah, did you read my post? Idon't have phpmyadmin. I have the hack from firefly that will run sql querys in the admin control panel. How do I run the sql file in that? :(

[Gutspiller]

bump

[Gutspiller]

bump

[SmEdD]

Shell access?

[Gutspiller]

Today at 09:59 PM SmEdD said this in Post #6 (https://vborg.vbsupport.ru/showthread.php?postid=415170#post415170)
Shell access?


There is a hack that Firefly provided. In allows an admin to run SQL Queries within the admin control panel of VB. I need to know how I run a sql file using that hack. :(

[SmEdD]

Does it give you a option to browse for files? And the tombot query file runs automatically as I recall. Just put in admin dir then goto the url.

[Gutspiller]

Today at 10:29 PM SmEdD said this in Post #8 (https://vborg.vbsupport.ru/showthread.php?postid=415178#post415178)
And the tombot query file runs automatically as I recall. Just put in admin dir then goto the url.

Instructions:

pload the folder alice and sub folders to your forums root eg: forums/alice

Run the SQL file that is inside the sql folder in phpmyadmin

ChMod all folders to alice 777
Run http://www.yourdomain.co.uk/forums/alice/src/admin/botloader.php this can take a good 30 min because it runs 300,000 queries

Login to phpmyadmin and check in the 'bots' table that the bot id is 0
you find that the table 'bot's the id number in there needs editing to 0 from 1 in some cases

If you wish to edit the bots name and fav food and so on you need to edit the table 'bot'


Before I go waiting 30 minutes (or so) I wanted to make sure I knew how to do the steps after it too.

I've attached an image of exactly what the hack looks like in my admin cp

[SmEdD]

It's like 10 min really, and there about 3000 queries so you deffinatly don't want to do it in the admin cp

[Dean C]

You can't do it with firefly's hack. I suggest contacting your host and asking them to install phpmyadmin. It normally comes installed on most servers anyway?

- miSt

[Gutspiller]

07-02-03 at 09:53 PM mentalrz said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=414851#post414851)
php my admin / show processes / databases / choose the database your running tombot on / sql

browse and upload


OK I found phpmyadmin, but I don't have any link that says "show processes" I have the following links after logging using the login and password for my forum mysql database:

phpMyAdmin documentation
Show PHP information
Official phpMyAdmin Homepage
Sourceforge phpMyAdmin Download Page
[ChangeLog] [CVS] [Lists]

Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Log out (*)

That's all I have. Where do I find the "show processes"?

[Dean C]

To run an sql file there should be a dropdown on the left. Find your database. Then a list of all the tables should appear in the right frame. Click the tab above them called sql and there is an upload box where you can upload your sql files :)

- miSt