Thread: Major Additions - QuoteIt! - Quote Database
View Single Post
  #514  
Old 02-09-2008, 10:25 AM
Dr. Bantham's Avatar
Dr. Bantham Dr. Bantham is offline
 
Join Date: Feb 2007
Posts: 164
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Cap'n Steve View Post
That is very strange. The ids are managed by MySQL, so it doesn't really matter what they are, but you should be able to reset them with this query (replacing $TP with your table prefix), although I wouldn't mess with that unless it really bothers you (that's what the "Show Continuous Quote IDs" option is for):

[sql]ALTER TABLE $TPlinks AUTO_INCREMENT = 1[/sql]
I am not clear on this and thus reluctant to run the query. Is the table prefix "quotes"? My database name? Will this renumber the entries sequentially, but not impact quotes added thereafter? I really do want to get the numbering straight, as it does bug me considerably to have 500+ integers separating quote runs.
Quote:
Originally Posted by Cap'n Steve View Post
The only thing I can suggest to try is finding this in includes/functions_quoteit.php:
PHP Code:
        $quotebbcodeclasses[$quoteid] = $bgclass
and after that, adding this:

PHP Code:
    if ($vbulletin->userinfo['userid'] == 859) {
        
header('Content-type: text/plain'true);
        echo 
"DEBUG: Found quote $quoteid, returning {Q" QUOTE_BBCODE_ID ":$quoteid}.\n";
    } 
Then I'll try to gather some more information tomorrow.
This had no impact that I could discern. HOWEVER, while repeatedly working with this, I re-imported the product again (as I had done several times before). Voila! Both BBCodes now work consistently. I swear I had done this several times. As with a previous problem, importing and saving settings seem to be subject to whimsy, as there is often a variable impact. Saving settings with no change or re-importing repeatedly can sometimes fix problems - eventually - maybe - curious. Anyway, this procedure deleted the two additional fields and related data which I had created, but a quick query using a table backup fixed this. And yes, the problem was evident before I started creating new fields. At least that is the way I remember it! I am beginning to wonder, at this point. Anywho, many thanks for the persistent assistance!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01174 seconds
  • Memory Usage 1,785KB
  • 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
  • (2)bbcode_php
  • (2)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