vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Insert Thread into database. (https://vborg.vbsupport.ru/showthread.php?t=266173)

Killa878 07-02-2011 05:52 PM
Insert Thread into database.
 
Hello all,

im trying to create a PHP Function that will add a thread to the forums.
This is what i got must its not working:

Code:
        private function MakeThread( $ForumId, $Title, $Content )
        {
                mysql_query( "INSERT INTO `thread` (`threadid`,`title`,`prefixid`,`firstpostid`,`lastpostid`,`lastpost`,`forumid`,`pollid`,`open`,`replycount`,`hiddencount`,`deletedcount`,`postusername`,`postuserid`,`lastposter`,`dateline`,`lastedit`,`views`,`iconid`,`notes`,`visible`,`sticky`,`votenum`,`votetotal`,`attach`,`similar`,`taglist`,`vbseo_linkbacks_no`,`lastposterid`,`keywords`,`wrdate`) VALUES (NULL, '". mysql_real_escape_string($Title) ."', '', '0', '0', '". $ForumId ."', '0', '0', '0', '0', '0', '". $this->UserData['username'] ."', '". $this->UserData['userid'] ."', '". $this->UserData['username'] ."', '". SCRIPT_TIME ."', '0', '0', '', '0', '', '1', '0', '0', '0', '0', '0', '0', '". $this->UserData['userid'] ."', '0', '0')"  ) or die( "Q1: " . mysql_error( ) );
                               
                // Get the inserted thread ID
                $ThreadID = mysql_insert_id( );

                mysql_query( "INSERT INTO 'post` (`postid`,`threadid`,`parentid`,`username`,`userid`,`title`,`dateline`,`lastedit`,`pagetext`,`allowsmilie`,`showsignature`,`ipaddress`,`iconid`,`visible`,`attach`,`infraction`,`reportthreadid`,`htmlstate`) VALUES (NULL, '". $ThreadID ."', '0', '". $this->UserData['username'] ."', '". $this->UserData['userid'] ."', '', '". SCRIPT_TIME ."', '', '" . $Content . "', '0', '0', '". $this->UserIP ."', '0', '1', '0', '0', '0', 'on_nl2br')" ) or die( "Q2: " . mysql_error( ) );

                $PostID = mysql_insert_id( );

                mysql_query( "UPDATE `thread` SET `firstpostid` = " . $PostID . ", `lastpostid` = " . $PostID . " WHERE `threadid` = " . $ThreadID . " LIMIT 1" );
        }
All the vars such as UserData and Username is ok. As they are stored within the class.

At this point no thread is being made.

Thanks

kh99 07-02-2011 06:43 PM
I'm not sure, but if I'm counting right it looks like maybe you're not setting 'visible' to 1 (it looks like you're setting 'sticky' to 1 so probably something's off by one).

Killa878 07-02-2011 07:05 PM
Quote:
Originally Posted by kh99 (Post 2215966)
I'm not sure, but if I'm counting right it looks like maybe you're not setting 'visible' to 1 (it looks like you're setting 'sticky' to 1 so probably something's off by one).
Hmm. i checked into the database and there wasnt any new inserted rows with anything that i created.

I counted and it looks correct.

kh99 07-02-2011 07:48 PM
I count 31 columns and 30 values, again unless I'm screwing up somehow. I pasted it into phpmyadmin, changed the vars to constants, and I got a "value count doesn't match" or something like that (the first query, I mean).

But I don't know why you wouldn't see any error messages. Here's a stupid question - are you sure that's even getting called?

Killa878 07-02-2011 07:51 PM
Quote:
Originally Posted by kh99 (Post 2216001)
I count 31 columns and 30 values, again unless I'm screwing up somehow. I pasted it into phpmyadmin, changed the vars to constants, and I got a "value count doesn't match" or something like that (the first query, I mean).

But I don't know why you wouldn't see any error messages. Here's a stupid question - are you sure that's even getting called?
Yeah its getting called :D
i just did a re-count and got 31 columns and 31 values.

Im stumped on this.

BirdOPrey5 07-02-2011 11:08 PM
Check out my "New Thread on User Banning" mod- it makes a new thread.

Here's a copy of the code to make a new thread... I got it off a tutorial somewhere around here that was for 3.x but the code is the same.

Code:

$bop5onban_fid = 2; //Forum ID for new thread

//Set new thread details...

$banthread =& datamanager_init('Thread_FirstPost', $vbulletin, ERRTYPE_ARRAY, 'threadpost');
$foruminfo = fetch_foruminfo($bop5onban_fid);
$threadinfo = array();   
$forumid = $bop5onban_fid;

//Set some thread/post settings
$bop5postip = "127.0.0.1";
$bop5allowsmilie = '1';
$bop5visible = 1;

$banthread->set_info('forum', $foruminfo);
$banthread->set_info('thread', $threadinfo);
$banthread->setr('forumid', $forumid);
$banthread->setr('userid', $bop5onban_uid);
$banthread->setr('pagetext', $bop5onban_text);
$banthread->setr('title', $bop5onban_title);
$banthread->set('iconid', $vbulletin->options['bop5onban_icon']);
$banthread->set('allowsmilie', $bop5allowsmilie);
$banthread->set('visible', $bop5visible);
$banthread->set('ipaddress', $bop5postip);
$banthread->set('showsignature', $vbulletin->options['bop5onban_sig']);

$banthread->pre_save();
if(count($banthread->errors) < 1)
{
    $threadid = $banthread->save();
    unset($banthread);
    build_thread_counters($banthread);
}
else
{
    print "Error making new thread! " . $banthread->errors[0] . $banthread->errors[1] . $banthread->errors[2] ;
}

 build_forum_counters($forumid);

// end make thread code


All times are GMT. The time now is 11:59 PM.

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.00955 seconds
  • Memory Usage 1,733KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete