Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 11-08-2007, 08:00 PM
trancetopia trancetopia is offline
 
Join Date: Feb 2005
Location: Wales, UK.
Posts: 161
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How to use a loop to create posts/replies to thread

Hi,

I have successfully created a new thead and first post as part of a hack i'm putting together. I'm having problems with the next bit.

I'm checking in another table for data and if it relates to the thread i've just created, I want to add all the comments from the comment table as replies to the thread.

This is what i've got but it's not working or I should say it's not working in the loop:

PHP Code:
$results $db->query_read("SELECT userid, username, date, comment, ipaddress FROM comments WHERE photo = "$ptphotoid " ORDER BY date");

while (
$result $db->fetch_array($results))
{
    
// Insert Reply
    
$postdm = new vB_DataManager_Post($vbulletinERRTYPE_STANDARD);
    
$postuserid $result['userid']; 
    
$postpagetext $result['comment']; 
    
    
$threadinfo fetch_threadinfo($formattedthreadid); 
    
$foruminfo fetch_foruminfo($forumid); 
    
    
$postdm->set_info('forum'$foruminfo); 
    
$postdm->set_info('thread'$threadinfo);   
    
$postdm->set('threadid'$formattedthreadid); 
    
$postdm->set('userid'$postuserid); 
    
$postdm->set('pagetext'$postpagetext); 
    
$postdm->set('allowsmilie'1); 
    
$postdm->set('visible'1); 
    
$postdm->set('dateline'$result[date]); 
    
$postdm->save(); 
    unset(
$postdm); 


      

I've tried a number of variations on the above but can't get it to work.

Is anyone able to offer any pointers please. Hope someone can help.

Thanks.

--------------- Added [DATE]1194566079[/DATE] at [TIME]1194566079[/TIME] ---------------

I've worked it out now. Don't need help with this one.
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:02 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03257 seconds
  • Memory Usage 2,161KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete