what does shutdown_query do?

[sabret00the]

PHP Code:

$DB_site->shutdown_query(" 


just wondering what this does as opposed to ->query_first and ->query

[Creative Suite]

PHP Code:

    function shutdown_query($query_string, $arraykey = 0)
    {
        global $shutdownqueries;

        if (NOSHUTDOWNFUNC AND !$arraykey)
        {
            return $this->query($query_string);
        }
        elseif ($arraykey)
        {
            $shutdownqueries["$arraykey"] = $query_string;
        }
        else
        {
            $shutdownqueries[] = $query_string;
        }
    } 


[sabret00the]

that went right over my head.

let's simplify

->query( // you'd use for a loop
->query_first( // standard query
->shutdown_query( // ???

[Dean C]

You know what, I have absolutely no idea. It appears that it's a feature designed to run queries after the page has rendered. All the queries in shutdown queries are not run at that particular part of the script I can tell you that. If you look at exec_shut_down() in functions.php you'll see what happens. However, I can't find any reference to that function being run anywhere in any of the vB files

Who knows... maybe I'm overlooking something

[Marco van Herwaarden]

Lol, you should read the how-to's

https://vborg.vbsupport.ru/showthread.php?t=75207

With great thanks to Bruce.Lee

[Dean C]

I just checked again, and that function is not being called anywhere according to ultraedit!

[Andreas]

And I thought UltraEdit was a good software ^.^

admincp/global.php

PHP Code:

    if (!empty($cpsession))
    {
        $DB_site->shutdown_query("
            UPDATE LOW_PRIORITY " . TABLE_PREFIX . "cpsession
            SET dateline = " . TIMENOW . "
            WHERE userid = $bbuserinfo[userid]
                AND hash = '" . addslashes($_COOKIE[COOKIE_PREFIX . 'cpsession']) . "'
        "); 


announcement.php

PHP Code:

if ($anncids)
{
    $DB_site->shutdown_query("
        UPDATE " . TABLE_PREFIX . "announcement
        SET views = views + 1
        WHERE announcementid IN ($anncids)
    ");
} 


attachment.php

PHP Code:

        // doing it as they happen
        $DB_site->shutdown_query("
            UPDATE " . TABLE_PREFIX . "attachment
            SET counter = counter + 1
            WHERE attachmentid = $attachmentinfo[attachmentid]
        "); 


and so on.

Or did you mean exec_shut_down?

functions.php

PHP Code:

if (!NOSHUTDOWNFUNC)
{
    register_shutdown_function('exec_shut_down');
} 


PHP Code:

    if (NOSHUTDOWNFUNC)
    {
        exec_shut_down();
    } 


[Dean C]

No no no no....

Ok those queries are passed to the method with db_mysql.php, and either ran at that exact time or stored in an array. This array is then released by the method with a global call and acn be used anywhere else in the script. There is then no reference to where-else these queries are ran. So they must be run at that exact point in the script. Do a search for $shutdownqueries and you tell me where they are run, in exec_shut_down. Ok then tell me where this function is ran

Follow?

[Andreas]

Revised my last post to include the references for exec_shut_down

[Dean C]

Weird I don't have those lines in my functions.php?