Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2003, 02:44 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do I run an sql file with that sql hack?

I'm working on installing that Tombot hack (https://vborg.vbsupport.ru/showthrea...&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!
Reply With Quote
  #2  
Old 07-03-2003, 02:53 AM
MentaL's Avatar
MentaL MentaL is offline
 
Join Date: Jan 2003
Posts: 550
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

browse and upload
Reply With Quote
  #3  
Old 07-03-2003, 02:58 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 09:53 PM mentalrz said this in Post #2
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?
Reply With Quote
  #4  
Old 07-03-2003, 03:16 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bump
Reply With Quote
  #5  
Old 07-04-2003, 02:07 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bump
Reply With Quote
  #6  
Old 07-04-2003, 02:59 AM
SmEdD's Avatar
SmEdD SmEdD is offline
 
Join Date: Mar 2003
Location: Ontario, Canada
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Shell access?
Reply With Quote
  #7  
Old 07-04-2003, 03:24 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 09:59 PM SmEdD said this in Post #6
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.
Reply With Quote
  #8  
Old 07-04-2003, 03:29 AM
SmEdD's Avatar
SmEdD SmEdD is offline
 
Join Date: Mar 2003
Location: Ontario, Canada
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #9  
Old 07-04-2003, 03:39 AM
Gutspiller's Avatar
Gutspiller Gutspiller is offline
 
Join Date: Dec 2001
Posts: 1,046
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 10:29 PM SmEdD said this in Post #8
And the tombot query file runs automatically as I recall. Just put in admin dir then goto the url.
Instructions:
Quote:
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/a.../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
Attached Images
File Type: gif sql.gif (13.0 KB, 0 views)
Reply With Quote
  #10  
Old 07-04-2003, 07:13 PM
SmEdD's Avatar
SmEdD SmEdD is offline
 
Join Date: Mar 2003
Location: Ontario, Canada
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:27 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05686 seconds
  • Memory Usage 2,268KB
  • Queries Executed 14 (?)
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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (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
  • postbit_attachment
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete