Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
  #1  
Old 10-21-2002, 08:35 PM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Trying to update post table via posting.php

I am trying to open/close posts via a button in postbit template. This will not do as open/close thread does but simply do a permission via some other things. I know I dont make sense on what I am gonna be using it for but how do you update the post table (openclose field) via postting.php.

I cant figure out how to make it pull the postid or find it. Not sure actually whats wrong with it. Any help is appreciated.

// ############################### start do open/close posts ###############################
if ($HTTP_POST_VARS['action']=="openclosepost") {

$postid = verifyid("post",$postid);
$postinfo=getpostinfo($postid);

if ($bbuserinfo[usergroupid]==5 or $bbuserinfo[usergroupid]==6 or $bbuserinfo[usergroupid]==16) {
if ($postinfo[openpost]==1) {
$DB_site->query("UPDATE post SET openpost=0 WHERE postid='$postinfo[postid]'");
eval("standardredirect(\"".gettemplate("redirect_t hreadclosed")."\",\"showthread .php?s=$session[sessionhash]&threadid=$threadid\");");
}
if ($postinfo[openpost]==0) {
$DB_site->query("UPDATE post SET openpost=1 WHERE postid='$postinfo[postid]'");
eval("standardredirect(\"".gettemplate("redirect_t hreadopen")."\",\"showthread.p hp?s=$session[sessionhash]&threadid=$threadid\");");
}
}
}
Reply With Quote
  #2  
Old 10-21-2002, 08:35 PM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ohh, thats just the latest way I tried to get it to work, I have tried a few other ways. Been trying for about 8 hrs now...lol
Reply With Quote
  #3  
Old 10-21-2002, 08:53 PM
mADmAX` mADmAX` is offline
 
Join Date: Dec 2001
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nevermind, I am so stupid...

I tried this already but I forgot one thing...

// ############################### start do open/close posts ###############################
if ($action=="openclosepost") {

$post=$DB_site->query_first("SELECT * FROM post WHERE postid=$postid[postid]");

if ($bbuserinfo[usergroupid]==5 or $bbuserinfo[usergroupid]==6 or $bbuserinfo[usergroupid]==16) {
if ($post[openpost] == 1) {
$DB_site->query("UPDATE post SET openpost=0 WHERE postid='$post[postid]'");
eval("standardredirect(\"".gettemplate("redirect_t hreadclosed")."\",\"showthread .php?s=$session[sessionhash]&threadid=$threadid\");");
}
if ($post[openpost] == 0) {
$DB_site->query("UPDATE post SET openpost=1 WHERE postid='$post[postid]'");
eval("standardredirect(\"".gettemplate("redirect_t hreadopen")."\",\"showthread.p hp?s=$session[sessionhash]&threadid=$threadid\");");
}
}
}

I had this...
if ($HTTP_POST_VARS['action']=="openclosepost") {

instead of this...
if ($action=="openclosepost") {
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:26 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.03305 seconds
  • Memory Usage 2,172KB
  • Queries Executed 13 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete