PDA

View Full Version : Trying to update post table via posting.php


mADmAX`
10-21-2002, 08:35 PM
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_threadclosed")."\",\"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_threadopen")."\",\"showthread.p hp?s=$session[sessionhash]&threadid=$threadid\");");
}
}
}

mADmAX`
10-21-2002, 08:35 PM
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

mADmAX`
10-21-2002, 08:53 PM
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_threadclosed")."\",\"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_threadopen")."\",\"showthread.p hp?s=$session[sessionhash]&threadid=$threadid\");");
}
}
}

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

instead of this...
if ($action=="openclosepost") {