Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Details »»

Version: , by AmaZed (Guest)
Developer Last Online: Jan 1970 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 08-06-2001 Last Update: Never Installs: 0
 
No support by the author.

I am just wondering how would I go about creating a new thread? I have scanned through the forum code a bit, but really didnt find to much where he created a new thread..

I am writing a news script, and i want to add an option 'create new thread' and it will take all the info I have for my news script and basicly create a new thread with the info givin from the news script.

If i sound fuxed up..ive been up all night codin my site..

/me will edit this for sure later

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 08-06-2001, 01:09 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I presume you mean the query to add a post

you need to do 3 queries

one to write to thread
one to write to post
and one to write to forum to update the latest post

//Create Thread
mysql_query("INSERT INTO thread (threadid, title, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach) VALUES ('', '" . addslashes([SUBJECT]) . "', '[UNIX TIME]', '[FORUM ID]', '0', '1', '0', '[USERNAME]', '[USERID]', '[USERNAME]', '[UNIX TIME]', '1', '1', '', '1', '0','0', '0', '0')");

//Create Posting
mysql_query("INSERT INTO post (postid, threadid, username, userid, title, dateline, attachmentid, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, edituserid, editdate) VALUES ('', '[THREADID]', '[USERNAME]', '[USERID]', '" . addslashes([SUBJECT]) . "', '[UNIX TIME]', '0', '" . addslashes(ALL TEXT) . "', '1', '0', '127.0.0.1', '1', '1', '0', '0')");

//Update Forum Info
mysql_query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='[UNIX TIME]',lastposter='" . addslashes([USERNAME]) . "' WHERE forumid='[FORUMID]'");

[UNIX TIME] <= time in seconds after 1970
[SUBJECT] <= Post Subject
[FORUMID] <= ID of forum this one is number 8
[USERNAME] <= Name as it will appear in post
[USERID] <= User ID of the person posting yours is 7197
[THREADID] <= ID of the thread post is associated with
[ALL TEXT] <= stuff to be in post

thats pretty much everything, if you have any more problems I will help.
Reply With Quote
  #3  
Old 08-06-2001, 02:40 PM
AmaZed
Guest
 
Posts: n/a
Default

thanks! just what i needed
Reply With Quote
  #4  
Old 08-06-2001, 03:51 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah no problem

I already done a comment system for nPHP v215

suggestion though, when they edit the news post, they edit the thread.

If they delete the news post, they delete the thread.

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 02:00 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.14836 seconds
  • Memory Usage 2,223KB
  • Queries Executed 19 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (2)postbit_onlinestatus
  • (4)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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_imicons
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete