postparsed table...how is it updated?

[minboost]

I noticed that the postparsed table is updated when a new post is made (and probably when it is updated) as well as when a post is viewed (if a record doesn't exist for that post in the table).

When else is it updated?

I'm trying to write a plug-in that circumvents the forum permissions for things like posting html, bbcode, etc...so that no matter what the permissions are I can put in any post I want.

I was thinking that if I insert a record directly into the postparsed table for my post, that will do it. But I'm just not sure if/when vbulletin may delete that record and re-parse the post.

I understand only a limited number of posts are stored in the postparsed table. Would setting the dateline column to an arbitrary date in the future help to keep it from being removed from the postparsed table? How does vBulletin decide when to look in the postparsed table and when to insert/update/remove records from it?

Any ideas?

Thanks guys!

[timetunnel]

Hello.

I'd like to know how the 'postparsed' table is updated also. From which file? All I've seem to see so far is 'DELETE' from that table.

Thanks in advance.

[Adrian Schneider]

When you view a post in a style that hasn't had it cached yet, it will create the cache for that post.

So, viewing a newly created/edited post would cause it to update the postparsed table.

[timetunnel]

Thanks for your reply, SirAdrian.

Which file updates that postparsed table for new posts? All I've found so far is the 'DELETE' from that table vs. INSERT.

Thanks again in advance.

[Adrian Schneider]

from showthread.php, here is its time-out check,

PHP Code:

$post_cachable = (
    $vbulletin->options['cachemaxage'] > 0 AND
    (TIMENOW - ($vbulletin->options['cachemaxage'] * 60 * 60 * 24)) <= $thread['lastpost'] AND
    $vbulletin->session->vars['sessionurl'] == ''
); 


So it goes through each post, and if thats set or if the post has no cache, it will update it with this:

PHP Code:

if (!empty($saveparsed))
{
    $db->shutdown_query("
        REPLACE INTO " . TABLE_PREFIX . "postparsed (postid, dateline, hasimages, pagetext_html, styleid, languageid)
        VALUES $saveparsed
    ");
    unset($saveparsed);
} 


[timetunnel]

Thanks again for your reply.

If I add a 2nd field to the 'newthread' that also uses e.g. the WYSIWYG editor, would I need to create a 2nd 'pagetext_html' (different name of course) in that 'postparsed' table OR would it use the same original 'pagetext_html' table field since it belongs to the ENTIRE post and therefore would just tack on the 2nd field's data onto the 1st field's data?

Thanks again in advance.

[Adrian Schneider]

You would need to add a second field if you want to to save the cache of it.

BTW, I think you would be better off having it NOT cache the post rather than duplicating the content.

[timetunnel]

Got it.

Thanks for your assistance!

[dd009]

Very helpful.

Thanks