Thread: Major Additions - Talkerbot V2.2.3 (AI Posting Bot)
View Single Post
  #316  
Old 09-24-2006, 12:08 AM
warnmar10 warnmar10 is offline
 
Join Date: Nov 2003
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dilbert
Yikes, 300,000 queries!
It's 300,000 table rows.
I can't get it installed, so I have no idea if I can uninstall it.
I believe there are only a few new tables created, so they would be simple enough to delete.

I am hoping in the next version, there is a way for us folks on shared servers with set timeouts, to upload the files.
I'm on a shared server and the problem with my host and all the other shared hosts I've checked out is that the database user is limited to 50,000 questions per hour.
After 50,000 records are imported the database user is locked out for up to one hour.
I am able to get around that limitation on things like re-indexing my search tables because I have 50 database users defined. In includes/config.php I have this:
Code:
$randomNum = rand(0,49);
if($randomNum == 0){$dbuser = 'db_user0';
}
else

if($randomNum == 1){$dbuser = 'db_user1';
}
else

if($randomNum == 2){$dbuser = 'db_user2';
}
else

if($randomNum == 3){$dbuser = 'db_user3';
}

//you get the point

$config['MasterServer']['username'] = $dbuser;
$config['MasterServer']['password'] = 'all_db_users_have_same_password';
Fifty users is mondo-overkill but since my randomizer is a bit on the crude side it is cheap insurance.

If the botloader could be made to import records 1,000 or even 10,000 at a time in conjunction with the multiple db user mod mentioned above, many shared host problems might go away.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01151 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete