Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-12-2005, 03:56 PM
Snetty Snetty is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MODS PLEASE MOVE: auto-generate new thread

I've been redeveloping one of my sites (www.mousepilot.co.uk) for the past week or so, using vBulletin as the base for it. My custom scripts allow myself and users to post articles and news on the main site. I can obviously edit these etc.

Something I want to be able to add to these scripts is the ability to automatically create a corresponding discussion thread in vb. The main site and vBulletin use the same database so in theory it should be easy. I've had a look at the thread and post tables, and decided that there are to many fields that I don't understand their purpose for me to be able to have a go at this without more information.

Something else that occurred to me is that I'd probably need to update the various statistics associated (total threads, posts per user etc etc) which I guess is something that I shouldn't have any major difficulty with. I just need confirmation that this is necessary really.

Has anyone ever tried something similar? Either way, is there any chance that someone can give me an insight into the various fields in the thread and posts tables, their uses and what values I need to put in each.

I'm also not sure that this is in the right forum, so mods feel free to move it.
Reply With Quote
  #2  
Old 01-13-2006, 11:17 AM
Snetty Snetty is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Danny.VBT advised me of the following on vbulletin.com

Quote:
Originally Posted by Danny.VBT
Here's a post by Andreas that shows how to create a new thread using vBulletin's datamanager: https://vborg.vbsupport.ru/showp...01&postcount=7

HTH,
Danny
So.. I wrote the following function

PHP Code:
function addthread($contentid){
    
    require_once(
'forums/global.php');
    require_once(
'forums/includes/class_dm.php');
    require_once(
'forums/includes/class_dm_threadpost.php'); 
    
    
$query "SELECT title FROM dynamiccontent WHERE contentid = '$contentid'";
    
$result1 mysql_query ($query) or die(mysql_error());
    
$dynamiccontent mysql_fetch_array ($result1);
    
    
$title $dynamiccontent[title];
    
    
$query "SELECT threadid FROM thread WHERE title = '$title'";
    
$result2 mysql_query ($query) or die(mysql_error());
    
$threadnum =  mysql_num_rows($result2);
    
    if (
$threadnum == 0) {
        
        
$query "SELECT title, content, userid, publish, link, category FROM dynamiccontent WHERE contentid = '$contentid'";
        
$result3 mysql_query ($query) or die(mysql_error());
        
$dynamiccontent mysql_fetch_array ($result3);
        
        
$userid $dynamiccontent[userid];
        
        
$query "SELECT userid FROM user WHERE userid = '$userid'";
        
$result4 mysql_query ($query) or die(mysql_error());
        
$user mysql_fetch_array ($result4);
        
        
$dataman =& datamanager_init('Thread'$vbulletinERRTYPE_ARRAY'threadpost');
        
        if (
$dynamiccontent[category] == ) {
            
            
$dataman->set('forumid''2');
            
        } else {
            
            
$dataman->set('forumid''7');
            
        }
        
        
$dataman->set('open''1');
        
$dataman->setr('title'$dynamiccontent[title]);
        
$dataman->setr('pagetext'$dynamiccontent[content]);
        
$dataman->setr('username'$user[username]);
        
$dataman->setr('userid'$userid);
        
$dataman->set('visible''1');
        
$dataman->set('allowsmilie''1');
        
        
// check for errors
        
if (!empty($userdata->errors)) {
            
            
$errorlist '';
            foreach (
$userdata->errors AS $index => $error) {
                
                
$errorlist .= "<li>$error</li>";
                
            }
            
            
// ... additional code; $errorlist is outputted to the user
            
echo $errorlist;
            
        } else {
            
            
// save the data
            
$threadid $dataman->save();
            
            
// ... additional processing code
            
        

        
    }
    

Which gives me the following error

PHP Code:
Fatal errorRegistry object is not an object in /includes/class_dm.php on line 177 
Can anyone help me with where i've gone wrong please? Chances are that the code I've written is completely wrong. I did my code according to the instructions that I found in the documentation, well, that's the theory anyway.

Oh, I guess this no longer falls under the forum it's in, so can a mod move it to the correct place please.
Reply With Quote
  #3  
Old 01-15-2006, 12:09 PM
Snetty Snetty is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

anyone care to help?
Reply With Quote
  #4  
Old 01-15-2006, 01:04 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this may help you

https://vborg.vbsupport.ru/showthread.php?t=97283
Reply With Quote
  #5  
Old 01-15-2006, 01:19 PM
Snetty Snetty is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ah, many thanks sabret00the
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 07:25 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.01973 seconds
  • Memory Usage 2,219KB
  • 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
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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