View Single Post
  #33  
Old 02-26-2004, 04:39 PM
Wonko of Shinra's Avatar
Wonko of Shinra Wonko of Shinra is offline
 
Join Date: Feb 2004
Location: Raleigh, NC
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Our goal is making people happy, not journal competition so sure


Alright, here's the deal
the vb2 edition had comments per entry, the people at shinra prefered their comments to be threaded. so we modified that (example http://www.shinraonline.com/board/jo...journalid=2359 )
In order for it to still act much like the old system. To make it work with your upgrade script, i've modified how it adds comments.

so when you have an entry such as...

to make a comment you hit discuss and come back with a link like...
shinraonline.com/board/journal.php?s=&action=comments&journalid=786&entry id=9190

and inside my code it checks to see if the person still wanted to comment on on that topic...
PHP Code:
        if (isset($entryid) && $entryid != "")
        {
                
$testtitle $DB_site->query_first("SELECT title FROM
                journal_entry WHERE entryid=
$entryid");
                
$testtitle[title] = "Re: " $testtitle[title];
                
$subject addslashes(htmlspecialchars($subject));
                if (
$subject != $testtitle[title])
                        
$entryid 0;
        } else {
                
$entryid 0;
        }
        
$insert_comment $DB_site->query("INSERT INTO journal_comments
(commentid, title, comment, timestamp, entryid, journalid, userid) VALUES
('commentid+1', '
$subject',
'"
.addslashes(htmlspecialchars($comment))."',
'"
.time()."', '$entryid', '$journalid', '$bbuserid')"); 
best way to make it compatible is to have it check the timestamp of all comments tied to entryid=0 and check it with the timestamps of the journal entries and insert them where appropriate.

I'll be releasing this in a matter of days or less, so you can figure it all out from there.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01190 seconds
  • Memory Usage 1,781KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete