View Single Post
  #5  
Old 08-01-2011, 09:57 PM
EquinoxWorld EquinoxWorld is offline
 
Join Date: Nov 2009
Location: Naples
Posts: 354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by nhawk View Post
Save the new phrase in the database phrase table.

Code:
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "phrase
	SET text = '" . $newtext . "'
	WHERE varname = '" . $yourphrasename . "'
");
At least I think that will work. It might not if the xml file is read every time the menu is loaded. I haven't checked.
I am taking a look at the phrase tables now, didn't think about setting it from the database..what about if they rebuild the bitfields for any reason, as you said if it's in the file would it stay the same??

Testing now...

--------------- Added [DATE]1312240116[/DATE] at [TIME]1312240116[/TIME] ---------------

OK well it changed it in the table but not in the actual menu...weird...

I refresh the page and it still says Contest 2

I am using this file to test and I can verify it changes the phrase text because I see it in the SQL table in phpmyadmin.

PHP Code:
<?php 
require_once('./global.php');


$yourphrasename 'cotw_cpnav_contest2';

$newtext 'Avatar Of The Week';


$vbulletin->db->query_write("UPDATE " TABLE_PREFIX "phrase
    SET text = '" 
$newtext "'
    WHERE varname = '" 
$yourphrasename "'
    
"
);

?>
--------------- Added [DATE]1312240360[/DATE] at [TIME]1312240360[/TIME] ---------------

And I can also verify that the phrase changed because I see it in the phrase manager... still same though in the actual menu in admin cp, still reads: Contest 2...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01079 seconds
  • Memory Usage 1,778KB
  • 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_php
  • (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