How do you add a comment system to a mod?

[Jaxel]

Okay, I have the following table...

CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."conquest_comments (
commentID int(10) unsigned NOT NULL auto_increment,
nationID int(10) unsigned NOT NULL default '0',
playerID int(10) unsigned NOT NULL default '0',
cDate int(10) unsigned NOT NULL default '0',
cState enum('visible', 'moderation', 'deleted') NOT NULL default 'visible',
cText mediumtext NOT NULL,
cIPAdd int(10) unsigned NOT NULL default '0',
PRIMARY KEY (commendID)
)

How would I go about adding a comment system to my mod? Its a comment system, so smiles should allow whatever is allowed in comments. I know how I could easily add a text box to a comment page, and paginate it, but how do I use the vBulletin message box with it? As well as add ajax support to edit comments.

--------------- Added 1240659924 at 1240659924 ---------------

I found this post, but I dont know how accurate it is...
https://vborg.vbsupport.ru/showthread.php?t=135708&highlight=message

The video directory mod has a comment system and its a bit different... Not to mention the forum tournament & ladders script doesnt even have ANYTHING about ANYTHING in the mod, and it still has a comment system. Is the work involved in that thread even needed?

[Mr-Moo]

For the main question, I cannot help you. However I can provide a little assistance on your second question.

The link you posted is the source on the editor and how to add it. You need a text editor (what I am typing in now) to communicate with the DB and the end-user. That is what it is.

Hope I was able to be of some assistance.

[Jaxel]

I dont think the advice listed on that thread even works anymore with recent updates to vb... so I'm having issues just with the basic form.

this is my php
$specialtemplates = array(
'bbcodecache',
'smiliecache',
);

require_once(DIR . '/includes/functions_editor.php');

$show['wysiwyg'] = ($setting['allow_bbcode'] ? is_wysiwyg_compatible() : 0);
$istyles_js = construct_editor_styles_js();
$show['qr_require_click'] = 0;
$editorid = construct_edit_toolbar('', 0, 'nonforum', $vbulletin->options['privallowsmilies'], 1, 0, 'qr');
$messagearea = "
<script type=\"text/javascript\">
<!--
var require_click = false;
var threaded_mode = 1;
var is_last_page = false;
// -->
</script>
$messagearea
";


and this is my html
<form action="conquest.php?do=comments" method="post" <if condition="!is_browser('webtv')"> onsubmit="return vB_Editor['$editorid'].prepare_submit(0, $vboptions[postminchars])"</if> enctype="multipart/form-data">
<input type="hidden" name="securitytoken" value="$bbuserinfo[securitytoken]" />
<input type="hidden" name="submitcomment" value="true" />
<div class="panel">
<div align="$stylevar[left]" style="max-width: $stylevar[formwidth]; width: auto !important; width: $stylevar[formwidth]">
<div id="$editorid" class="vBulletin_editor">$messagearea</div>
</div>
</div>
<div style="margin-top: $stylevar[cellpadding]px">
<input type="submit" value="submit" />
</div>
</form>


Using the above code, I have a TON of errors...

1 - NONE of the editor buttons work, they are just static images. Cant click on them.

2 - JS error: vB_Text_Editor is undefined

3 - lots of uncached templates
Uncached templates: editor_clientscript (1)
Uncached templates: editor_css (1)
Uncached templates: editor_jsoptions_font (1)
Uncached templates: editor_jsoptions_size (1)
Uncached templates: showthread_quickreply (1)

[Dismounted]

lots of uncached templates
Uncached templates: editor_clientscript (1)
Uncached templates: editor_css (1)
Uncached templates: editor_jsoptions_font (1)
Uncached templates: editor_jsoptions_size (1)
Uncached templates: showthread_quickreply (1)
You have to tell vBulletin that you're going to use the editor (before global.php is called):
define('GET_EDIT_TEMPLATES', true);