vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   transfering variable (https://vborg.vbsupport.ru/showthread.php?t=159233)

stonner 10-01-2007 09:05 PM
transfering variable
 
I'm using the code following code to allow users to comment a picture:

Code:

function hon_save_vote2(){
        $info = auth_member();
       
        $sql_query = "SELECT photos FROM photo_votes WHERE mem_id=".$info["mem_id"];
        $exclude = $GLOBALS["DB"]->single($sql_query);
        $exclude_photos = handle_empties(explode(",",$exclude));
       
        $rating  = $GLOBALS["Get"]->type_val("rating","integer");
        $pho_id = $GLOBALS["Get"]->type_val("rate_pho_id","integer");
        $comment = $GLOBALS["Get"]->val("comment");
       
        if(!in_array($pho_id,$exclude_photos)){
       
                $sql_query = "UPDATE photos SET rating=rating+".$rating.",votes=votes+1 WHERE pho_id=".$pho_id;
                $GLOBALS["DB"]->execute($sql_query);
       
                $sql_query = "UPDATE photo_votes SET photos=CONCAT(photos,'".$pho_id.",') WHERE mem_id=".$info["mem_id"];
                $updated = $GLOBALS["DB"]->update($sql_query);
       
                if(!$updated){
                        $sql_query = "INSERT INTO photo_votes (mem_id,photos) VALUES (".$info["mem_id"].",'".$pho_id.",')";
                        $GLOBALS["DB"]->execute($sql_query);
                }//if       
       
        }//if
       

        if($comment){
{
                $sql_query = "INSERT INTO photo_comments (pho_id,mem_id,comment)
                                            VALUES (:pho_id:,:mem_id:,':comment:')";
                $vals["pho_id"]  = $pho_id;
                $vals["mem_id"]  = $info["mem_id"];
                $vals["comment"] = $comment;
                $GLOBALS["DB"]->values = $vals;
                $GLOBALS["DB"]->execute($sql_query);
} 

        }//if



load_page("index.php?page=viewphotos&pho_id=".$pho_id."&per_id=".$per_id);
       
}//hon_save_vote2
everything works fine, except the last red line. after commenting it just should reload the same page.

but it reloads:
http://www.schuelercommunity.com/index.php?page=viewphotos&pho_id=100893&per_id=

so it doesn't transfer the per_id at the end. how can i fix this?

thank you for any help!

EnIgMa1234 10-01-2007 09:10 PM
Should it be

load_page("index.php?page=viewphotos&pho_id=".$pho _id."&per_id=".$per_id.");

With the extra " before );

stonner 10-01-2007 09:13 PM
no, there are four quote marks in total. i think that's right.

Dismounted 10-02-2007 04:56 AM
$per_id is not defined anywhere.

stonner 10-02-2007 04:59 AM
ok, another option would be just refreshing the page (just like the refresh button)

or

to retrieve the current URL and to load the current URL.

but i dont how to do this.

Dismounted 10-02-2007 05:06 AM
Replace the load_page() line with:
PHP Code:
$per_id = intval($_GET['per_id']);
load_page('index.php?page=viewphotos&pho_id=' . $pho_id . '&per_id=' . $per_id); 

stonner 10-02-2007 05:32 PM
that gets:

Code:
http://www.schuelercommunity.com/index.php?page=viewphotos&pho_id=100913&per_id=0
but thank you for trying to help me. do you have another idea?

Dismounted 10-03-2007 05:31 AM
Where is per_id located? Is it even passed on to the page?

stonner 10-05-2007 09:25 AM
per_id is in the same table as pho_id.

it is passed to the page i think because it is in the URL of the page where you submit the comment.

Dismounted 10-09-2007 08:00 AM
Give me an example URL.


All times are GMT. The time now is 03:50 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01069 seconds
  • Memory Usage 1,735KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete