Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Register FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2005, 08:13 AM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default parse error?

i don't seem to be able to see where i've gone wrong with this

PHP Code:
            $vbulletin->db->query_write("
                INSERT INTO grps_thread
                    (groupid, userid, username, title, dateline, iconid, lastposterid, lastpostdateline, replies)
                VALUES
                    ($groupid, " . $vbulletin->userinfo['userid'] . ", '" .  addslashes($vbulletin->userinfo['username'] . "', '" . addslashes($post['title']) . "', '" . $dateline . "', $post[iconid], " . $vbulletin->userinfo['userid'] . ", '" . $dateline . "', 0)
            "); // parse error here
            $newthreadfirstpostid = $vbulletin->db->insert_id(); 
the parse error is marked with a comment.

the block of code around and including that is

PHP Code:
        // ### POST NEW THREAD ###
        // doublepost check
        $doublepost = $vbulletin->db->query_first("
            SELECT postid, pagetext, userid 
            FROM grps_post
            WHERE pagetext = $post[message]
                AND dateline > " . (TIMENOW - 3600) . "
                AND userid =  " . $vbulletin->userinfo[userid] . "
                AND groupid = $groupid
            ORDER BY dateline DESC 
            LIMIT 1
        ");

        if ($doublepost AND $doublepost['userid'] == $vbulletin->userinfo['userid'])
        {
            eval(standard_error(fetch_error('Thread Already Exists')));
        }
        else
        {
            $dateline = TIMENOW;

            $vbulletin->db->query_write("
                INSERT INTO grps_thread
                    (groupid, userid, username, title, dateline, iconid, lastposterid, lastpostdateline, replies)
                VALUES
                    ($groupid, " . $vbulletin->userinfo['userid'] . ", '" .  addslashes($vbulletin->userinfo['username'] . "', '" . addslashes($post['title']) . "', '" . $dateline . "', $post[iconid], " . $vbulletin->userinfo['userid'] . ", '" . $dateline . "', 0)
            ");
            $newthreadfirstpostid = $vbulletin->db->insert_id();
        
            $vbulletin->db->query_write("
                INSERT INTO grps_post
                    (threadid, groupid, parentid, username, userid, title, dateline, pagetext, ipaddress, iconid, visible, attach, allowsmilie, showsignature)
                VALUES
                    ($newthreadfirstpostid, $groupid, $parentid, '" . addslashes($vbulletin->userinfo['username']) . "', " . $vbulletin->userinfo[userid] . ", '" . addslashes($post['title']) . "', '" . $dateline . "', '" . addslashes($post['message']) . "', '" . addslashes($post['ipaddress']) . "', $post[iconid], $post[visible], 0, $post[enablesmilies], $post[signature])
            ");
        } 
Reply With Quote
  #2  
Old 12-01-2005, 08:45 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
addslashes($vbulletin->userinfo['username'] 
should be:
PHP Code:
addslashes($vbulletin->userinfo['username']) 
Reply With Quote
  #3  
Old 12-01-2005, 09:23 AM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks marco it was indeedy that
Reply With Quote
Reply


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 11:11 AM.


Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.