Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-17-2015, 06:11 AM
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Location: USA
Posts: 647
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default toggle admin option from frontend

i have got this working using
Code:
build_options();
in my php code

but i have a major issue, when i toggle it, i get a fatal user error i cant solve. im not changing any other options so idk what would cause this.

product attached in 2nd post
im trying to create a simple toggle for turning a plugin on or off from the front end.

it looks a little like this.

the toggle:
HTML Code:
<if condition="$vboptions[setting_name] == 1">
  <a href="#" onclick="setting_off()">ON</a>
<else />
  <a href="#" onclick="setting_on()">OFF</a>
</if>
the js: (requires jQuery)
Code:
function setting_off(){
  $.ajax({
    type: "GET", url: "?do=settingoff"
  });
}
function setting_on(){
  $.ajax({
    type: "GET", url: "?do=settingon"
  });
}
the php: (external, and i do include global)
PHP Code:
if ($_GET['do'] == 'settingon'){
  
$vbulletin->db->query("
    UPDATE `" 
TABLE_PREFIX "setting`
    SET value='1'
    WHERE value=0
  "
);
}
// ##### Set Off #######
if ($_GET['do'] == 'settingoff'){
  
$vbulletin->db->query("
    UPDATE `" 
TABLE_PREFIX "setting`
    SET value='0'
    WHERE value=1
  "
);

this all works just fine and dandy, my issue is even though it switches the status of the product, i still have to go into the admincp options and hit save before it really applies (even though before i hit save its already switched) if that makes since...

the href just switches this


yet i actually have to come here and hit save before it really applies.

any ideas how to avoid that process so my href takes care of all of that


important addition!
when i hit save here it seems to be affecting something else also and i have to breakout the tools.php to fix it
Quote:
Fatal User Error: The requested language does not exist, reset via tools.php. in ....\includes\functions.php on line 1417
Attached Images
File Type: jpg Capture.jpg (23.8 KB, 0 views)
Reply With Quote
  #2  
Old 03-17-2015, 07:02 AM
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Location: USA
Posts: 647
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

attached product, someone please help =(

DO NOT USE THIS ON A LIVE SITE YOU RISK THE CHANCE OF RUINING YOUR DB!!!!!!
Attached Files
File Type: xml product-drcfl.xml (4.6 KB, 4 views)
Reply With Quote
  #3  
Old 03-20-2015, 10:27 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you still working on this? I think the problem is that your UPDATE query sets all options that had a setting of 0 to 1. What you want is something like
Code:
UPDATE setting SET value=0 WHERE varname='drc_fl'
Reply With Quote
  #4  
Old 03-20-2015, 03:40 PM
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Location: USA
Posts: 647
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i got it all working already, went about it without ajax and i caught that mysql error, thanks though kev.
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 01:15 PM.


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.03733 seconds
  • Memory Usage 2,211KB
  • Queries Executed 12 (?)
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
  • (3)bbcode_code
  • (1)bbcode_html
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (2)postbit_attachment
  • (4)postbit_onlinestatus
  • (4)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_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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete