Home . Extensions . Repository
Sponsors
Extension Repository
The official extension repository only consists of freely available extensions. In the future only security reviewed extensions will be displayed. More information about reviews and disclaimer. New documentation is rendered once a day.
CHC Forum
-
- Icon
- Title
- CHC Forum
- Extension key
- ( chc_forum )
- State
- beta, Not reviewed!
- Extension Details
-
- Author
- Zach Davis
- Category
- plugin
- Version
- 1.4.5
- Manual
- Read online
- Downloads (total / this version)
- 30052 / 9965
- Rating
- 3.93 (15 votes)
-
- Updated
- 01.05.2006
- Upload comment
- SECURITY UPGRADE: resolved mysql injection issue, added TS property for enabling or disbaling htmlentities on posts, fixed bug where mailer mailed deleted users,
-
- Description
- A discussion board with some mailing list features. Requires typo3 v. 3.6.0.
- Extension Details
-
- Dependencies
-
- depends on typo3 3.6.21-0.0.20
- depends on php 0.0.25-0.0.25
- depends on cms
- depends on newloginbox
- Reverse dependencies
The following extension versions depend on this extension:
- chcnewscon 0.1.2
-
- Version history
- 1.4.4: Fixed: 0001972: Forum crash after click on [New Posts]; Fixed: 0001790: xhtml validation errors (misplaced semicolon in header template); Fixed: 0001805: International characters overridden in _LOCAL_LANG are displayed incorrectly; Fixed: 0001860: Umlauts
- 1.4.3: Fixed bug in duplicate post prevention check that blocked anonymous users (not-logged-in users) from posting.
- 1.4.2: Note: in versions prior to this version there is a vulnerability that makes javascript injection possible. Please upgrade to 1.4.2 immediately to fix this vulnerability. CHANGES: Fixed bug where link to new posts would not display posts; fixed problems wi
- 1.4.0: fixed all major performance bottlenecks, forum tested with 10,000 posts, numerous bug fixes, html / css templates updated, user permission bugs fixed, additional bugs from bugtracker fixed. Be sure to clear the cache and to update your forum styles if ne
-
- Download extension
-
Preview for file chc_forum-1.4.5-ext_tables__sql:Filename Size View Date Download .DS_Store 6.0 K 27.04.2006 Download changelog.txt 22 K View 27.04.2006 Download class.ext_update.php 2.5 K View 27.04.2006 Download ext_icon.gif 123 View 27.04.2006 Download ext_localconf.php 843 View 27.04.2006 Download ext_tables.php 5.8 K View 27.04.2006 Download ext_tables.sql 8.7 K View 27.04.2006 Download ext_typoscript_constants.txt 1.7 K View 27.04.2006 Download ext_typoscript_setup.txt 18.0 K View 27.04.2006 Download flexform_ds.xml 17.6 K View 27.04.2006 Download locallang.php 2.3 K View 27.04.2006 Download locallang_db.php 117 K View 27.04.2006 Download tca.php 16.9 K View 27.04.2006 Download pi1/.DS_Store 6.0 K 27.04.2006 Download pi1/ce_wiz.gif 283 View 27.04.2006 Download pi1/class.tx_chcforum_author.php 13.2 K View 27.04.2006 Download pi1/class.tx_chcforum_category.php 6.1 K View 27.04.2006 Download pi1/class.tx_chcforum_conference.php 13.9 K View 27.04.2006 Download pi1/class.tx_chcforum_display.php 103 K View 01.05.2006 Download pi1/class.tx_chcforum_display.php.orig 103 K 27.04.2006 Download pi1/class.tx_chcforum_fconf.php 5.4 K View 27.04.2006 Download pi1/class.tx_chcforum_form.php 44 K View 27.04.2006 Download pi1/class.tx_chcforum_message.php 2.7 K View 27.04.2006 Download pi1/class.tx_chcforum_pi1.php 12.7 K View 01.05.2006 Download pi1/class.tx_chcforum_pi1_wizicon.php 1.8 K View 27.04.2006 Download pi1/class.tx_chcforum_post.php 44 K View 27.04.2006 Download pi1/class.tx_chcforum_search.php 13.1 K View 27.04.2006 Download pi1/class.tx_chcforum_shared.php 7.9 K View 27.04.2006 Download pi1/class.tx_chcforum_thread.php 14.2 K View 27.04.2006 Download pi1/class.tx_chcforum_tpower.php 27 K View 27.04.2006 Download pi1/class.tx_chcforum_tpparser.php 2.4 K View 27.04.2006 Download pi1/class.tx_chcforum_user.php 45 K View 27.04.2006 Download pi1/clear.gif 807 View 27.04.2006 Download pi1/kses_lib.php 19.2 K View 27.04.2006 Download pi1/locallang.php 177 K View 27.04.2006 Download pi1/templates/cat_view.tpl 1.3 K 27.04.2006 Download pi1/templates/conf_view.tpl 1.3 K 27.04.2006 Download pi1/templates/cwtcommunity_buddylist.tmpl 1.6 K 27.04.2006 Download pi1/templates/cwtcommunity_guestbook.tmpl 4.6 K 27.04.2006 Download pi1/templates/cwtcommunity_messages.tmpl 5.2 K 27.04.2006 Download pi1/templates/cwtcommunity_profile.tmpl 2.2 K 27.04.2006 Download pi1/templates/cwtcommunity_search.tmpl 1.0 K 27.04.2006 Download pi1/templates/cwtcommunity_userlist.tmpl 2.4 K 27.04.2006 Download pi1/templates/cwtcommunity_welcome.tmpl 1.8 K 27.04.2006 Download pi1/templates/footer.js 332 27.04.2006 Download pi1/templates/footer.tpl 109 27.04.2006 Download pi1/templates/global.js 107 27.04.2006 Download pi1/templates/header.tpl 163 27.04.2006 Download pi1/templates/message_box.tpl 1.1 K 27.04.2006 Download pi1/templates/post_form.js 6.6 K 27.04.2006 Download pi1/templates/post_form.tpl 3.6 K 27.04.2006 Download pi1/templates/search_form.tpl 2.8 K 27.04.2006 Download pi1/templates/single_post.tpl 1.1 K 27.04.2006 Download pi1/templates/single_post_view.tpl 235 27.04.2006 Download pi1/templates/single_thread.tpl 235 27.04.2006 Download pi1/templates/sub_tool_bar.tpl 289 27.04.2006 Download pi1/templates/tool_bar.tpl 1.1 K 27.04.2006 Download pi1/templates/user_list.tpl 0.9 K 27.04.2006 Download pi1/templates/img/Thumbs.db 99 K 27.04.2006 Download pi1/templates/img/aim.gif 767 View 27.04.2006 Download pi1/templates/img/aim.png 1.3 K View 27.04.2006 Download pi1/templates/img/bold_large.gif 772 View 27.04.2006 Download pi1/templates/img/bold_large.png 738 View 27.04.2006 Download pi1/templates/img/chat.gif 645 View 27.04.2006 Download pi1/templates/img/chat.png 0.9 K View 27.04.2006 Download pi1/templates/img/close.gif 755 View 27.04.2006 Download pi1/templates/img/close.png 787 View 27.04.2006 Download pi1/templates/img/close_thread.gif 595 View 27.04.2006 Download pi1/templates/img/close_thread.png 821 View 27.04.2006 Download pi1/templates/img/color_large.gif 808 View 27.04.2006 Download pi1/templates/img/color_large.png 795 View 27.04.2006 Download pi1/templates/img/delete.gif 608 View 27.04.2006 Download pi1/templates/img/delete.png 676 View 27.04.2006 Download pi1/templates/img/edit.gif 655 View 27.04.2006 Download pi1/templates/img/edit.png 1.0 K View 27.04.2006 Download pi1/templates/img/email.gif 708 View 27.04.2006 Download pi1/templates/img/email.png 894 View 27.04.2006 Download pi1/templates/img/header.gif 838 View 27.04.2006 Download pi1/templates/img/header.png 270 View 27.04.2006 Download pi1/templates/img/hide.gif 658 View 27.04.2006 Download pi1/templates/img/hide.png 784 View 27.04.2006 Download pi1/templates/img/image_large.gif 744 View 27.04.2006 Download pi1/templates/img/image_large.png 756 View 27.04.2006 Download pi1/templates/img/italic_large.gif 789 View 27.04.2006 Download pi1/templates/img/italic_large.png 676 View 27.04.2006 Download pi1/templates/img/license.txt 26 K View 27.04.2006 Download pi1/templates/img/mark_read.gif 518 View 27.04.2006 Download pi1/templates/img/mark_read.png 648 View 27.04.2006 Download pi1/templates/img/new.gif 655 View 27.04.2006 Download pi1/templates/img/new.png 1.0 K View 27.04.2006 Download pi1/templates/img/open_thread.gif 595 View 27.04.2006 Download pi1/templates/img/open_thread.png 812 View 27.04.2006 Download pi1/templates/img/profile.gif 605 View 27.04.2006 Download pi1/templates/img/profile.png 883 View 27.04.2006 Download pi1/templates/img/quote.gif 625 View 27.04.2006 Download pi1/templates/img/quote.png 769 View 27.04.2006 Download pi1/templates/img/quote_large.gif 785 View 27.04.2006 Download pi1/templates/img/quote_large.png 582 View 27.04.2006 Download pi1/templates/img/readme.txt 2.5 K View 27.04.2006 Download pi1/templates/img/reply.gif 627 View 27.04.2006 Download pi1/templates/img/reply.png 0.9 K View 27.04.2006 Download pi1/templates/img/search.gif 570 View 27.04.2006 Download pi1/templates/img/search.png 813 View 27.04.2006 Download pi1/templates/img/star.png 850 View 27.04.2006 Download pi1/templates/img/star_empty.png 753 View 27.04.2006 Download pi1/templates/img/thread.gif 745 View 27.04.2006 Download pi1/templates/img/thread.png 1.4 K View 27.04.2006 Download pi1/templates/img/thread_closed.gif 745 View 27.04.2006 Download pi1/templates/img/thread_closed.png 1.5 K View 27.04.2006 Download pi1/templates/img/thread_hot.gif 739 View 27.04.2006 Download pi1/templates/img/thread_hot.png 1.3 K View 27.04.2006 Download pi1/templates/img/thread_hot_new.gif 760 View 27.04.2006 Download pi1/templates/img/thread_hot_new.png 3.9 K View 27.04.2006 Download pi1/templates/img/thread_new.gif 753 View 27.04.2006 Download pi1/templates/img/thread_new.png 1.6 K View 27.04.2006 Download pi1/templates/img/underline_large.gif 791 View 27.04.2006 Download pi1/templates/img/underline_large.png 743 View 27.04.2006 Download pi1/templates/img/unhide.gif 649 View 27.04.2006 Download pi1/templates/img/unhide.png 735 View 27.04.2006 Download pi1/templates/img/url_large.gif 888 View 27.04.2006 Download pi1/templates/img/url_large.png 1.2 K View 27.04.2006 Download pi1/templates/img/user.gif 707 View 27.04.2006 Download pi1/templates/img/user.png 1.0 K View 27.04.2006 Download pi1/templates/img/user_pm.gif 628 View 27.04.2006 Download pi1/templates/img/user_pm.png 1.0 K View 27.04.2006 Download pi1/templates/img/user_pm_add_buddy.gif 651 View 27.04.2006 Download pi1/templates/img/user_pm_add_buddy.png 1.0 K View 27.04.2006 Download pi1/templates/img/user_pm_message.gif 616 View 27.04.2006 Download pi1/templates/img/user_pm_message.png 870 View 27.04.2006 Download pi1/templates/img/user_pm_message_new.gif 630 View 27.04.2006 Download pi1/templates/img/user_pm_message_new.png 0.9 K View 27.04.2006 Download pi1/templates/img/user_pm_message_read.gif 616 View 27.04.2006 Download pi1/templates/img/user_pm_message_read.png 859 View 27.04.2006 Download pi1/templates/img/user_pm_message_reply.gif 627 View 27.04.2006 Download pi1/templates/img/user_pm_message_reply.png 0.9 K View 27.04.2006 Download pi1/templates/img/user_pm_offline.gif 630 View 27.04.2006 Download pi1/templates/img/user_pm_offline.png 0.9 K View 27.04.2006 Download pi1/templates/img/user_pm_trash.gif 653 View 27.04.2006 Download pi1/templates/img/user_pm_trash.png 0.9 K View 27.04.2006 Download pi1/templates/img/users.gif 648 View 27.04.2006 Download pi1/templates/img/users.png 1.0 K View 27.04.2006 Download pi1/templates/img/watch.gif 332 View 27.04.2006 Download pi1/templates/img/watch.png 500 View 27.04.2006 Download pi1/templates/img/emoticons/Thumbs.db 36 K 27.04.2006 Download pi1/templates/img/emoticons/arrow.gif 565 View 27.04.2006 Download pi1/templates/img/emoticons/badgrin.gif 466 View 27.04.2006 Download pi1/templates/img/emoticons/biggrin.gif 357 View 27.04.2006 Download pi1/templates/img/emoticons/confused.gif 581 View 27.04.2006 Download pi1/templates/img/emoticons/cool.gif 353 View 27.04.2006 Download pi1/templates/img/emoticons/cry.gif 726 View 27.04.2006 Download pi1/templates/img/emoticons/doubt.gif 605 View 27.04.2006 Download pi1/templates/img/emoticons/evil.gif 577 View 27.04.2006 Download pi1/templates/img/emoticons/exclaim.gif 617 View 27.04.2006 Download pi1/templates/img/emoticons/idea.gif 389 View 27.04.2006 Download pi1/templates/img/emoticons/lol.gif 2.0 K View 27.04.2006 Download pi1/templates/img/emoticons/mad.gif 571 View 27.04.2006 Download pi1/templates/img/emoticons/neutral.gif 579 View 27.04.2006 Download pi1/templates/img/emoticons/question.gif 582 View 27.04.2006 Download pi1/templates/img/emoticons/razz.gif 364 View 27.04.2006 Download pi1/templates/img/emoticons/redface.gif 2.5 K View 27.04.2006 Download pi1/templates/img/emoticons/rolleyes.gif 0.9 K View 27.04.2006 Download pi1/templates/img/emoticons/sad.gif 355 View 27.04.2006 Download pi1/templates/img/emoticons/shock.gif 354 View 27.04.2006 Download pi1/templates/img/emoticons/smile.gif 367 View 27.04.2006 Download pi1/templates/img/emoticons/surprised.gif 368 View 27.04.2006 Download pi1/templates/img/emoticons/wink.gif 581 View 27.04.2006 Download mailer/Mail.php 7.2 K View 27.04.2006 Download mailer/error_log 160 View 27.04.2006 Download mailer/mailer.php 28 K View 27.04.2006 Download mailer/Mail/RFC822.php 31 K View 27.04.2006 Download mailer/Mail/mail.php 4.2 K View 27.04.2006 Download mailer/Mail/sendmail.php 5.3 K View 27.04.2006 Download mailer/Mail/smtp.php 6.6 K View 27.04.2006 Download mod1/clear.gif 46 View 27.04.2006 Download mod1/conf.php 379 View 27.04.2006 Download mod1/index.php 39 K View 27.04.2006 Download mod1/locallang.php 84 K View 27.04.2006 Download mod1/locallang_mod.php 3.5 K View 27.04.2006 Download mod1/moduleicon.gif 123 View 27.04.2006 Download mod1/templates/add_cat.tpl 900 27.04.2006 Download mod1/templates/add_conf.tpl 2.3 K 27.04.2006 Download mod1/templates/add_grp.tpl 1.2 K 27.04.2006 Download mod1/templates/f_conf.tpl 3.9 K 27.04.2006 Download mod1/templates/list.tpl 340 27.04.2006 Download mod1/templates/list_grp.tpl 343 27.04.2006 Download icons/Thumbs.db 7.5 K 27.04.2006 Download icons/icon_tx_chcforum_cat.gif 127 View 27.04.2006 Download icons/icon_tx_chcforum_cat__d.gif 167 View 27.04.2006 Download icons/icon_tx_chcforum_cat__h.gif 138 View 27.04.2006 Download icons/icon_tx_chcforum_cat__hu.gif 187 View 27.04.2006 Download icons/icon_tx_chcforum_cat__u.gif 183 View 27.04.2006 Download icons/icon_tx_chcforum_cat__x.gif 167 View 27.04.2006 Download icons/icon_tx_chcforum_cnf.gif 127 View 27.04.2006 Download icons/icon_tx_chcforum_cnf__h.gif 137 View 27.04.2006 Download icons/icon_tx_chcforum_cnf__x.gif 168 View 27.04.2006 Download icons/icon_tx_chcforum_fgrp.gif 146 View 27.04.2006 Download icons/icon_tx_chcforum_fgrp__h.gif 179 View 27.04.2006 Download icons/icon_tx_chcforum_fgrp__x.gif 180 View 27.04.2006 Download icons/icon_tx_chcforum_post.gif 121 View 27.04.2006 Download icons/icon_tx_chcforum_post__h.gif 132 View 27.04.2006 Download icons/icon_tx_chcforum_post__x.gif 162 View 27.04.2006 Download icons/icon_tx_chcforum_thrd.gif 124 View 27.04.2006 Download icons/icon_tx_chcforum_thrd__h.gif 132 View 27.04.2006 Download icons/icon_tx_chcforum_thrd__x.gif 162 View 27.04.2006 Download doc/manual.sxw 239 K 27.04.2006 Download #
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_chcforum_aim tinytext NOT NULL,
tx_chcforum_yahoo tinytext NOT NULL,
tx_chcforum_msn tinytext NOT NULL
tx_chcforum_customim tinytext NOT NULL
);
#
# Table structure for table 'tx_chcforum_category'
#
CREATE TABLE tx_chcforum_category (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
cat_title tinytext NOT NULL,
cat_description text NOT NULL,
auth_forumgroup_r blob NOT NULL,
auth_forumgroup_w blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY allowed_group (fe_group)
);
#
# Table structure for table 'tx_chcforum_conference'
#
CREATE TABLE tx_chcforum_conference (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
cat_id int(11) unsigned DEFAULT '0' NOT NULL,
conference_name tinytext NOT NULL,
conference_desc text NOT NULL,
conference_allow_user_edits tinyint(3) unsigned DEFAULT '0' NOT NULL,
conference_public_r tinyint(3) unsigned DEFAULT '0' NOT NULL,
conference_public_w tinyint(3) unsigned DEFAULT '0' NOT NULL,
auth_forumgroup_r blob NOT NULL,
auth_forumgroup_w blob NOT NULL,
auth_feuser_mod blob NOT NULL,
auth_forumgroup_attach blob NOT NULL,
hide_new tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_cat (cat_id)
);
#
# Table structure for table 'tx_chcforum_forumgroup'
#
CREATE TABLE tx_chcforum_forumgroup (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
forumgroup_title tinytext NOT NULL,
forumgroup_desc text NOT NULL,
forumgroup_users blob NOT NULL,
forumgroup_groups blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_chcforum_post'
#
CREATE TABLE tx_chcforum_post (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
post_sent_flag tinyint(4) unsigned DEFAULT '0' NOT NULL,
category_id int(11) DEFAULT '0' NOT NULL,
conference_id int(11) DEFAULT '0' NOT NULL,
thread_id int(11) DEFAULT '0' NOT NULL,
post_author int(11) DEFAULT '0' NOT NULL,
post_author_name tinytext NOT NULL,
post_author_email tinytext NOT NULL,
post_subject tinytext NOT NULL,
post_author_ip tinytext NOT NULL,
post_edit_tstamp int(11) DEFAULT '0' NOT NULL,
post_edit_count int(11) DEFAULT '0' NOT NULL,
post_attached blob NOT NULL,
post_text text NOT NULL,
cache_parsed_text text NOT NULL
cache_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_cat (category_id),
KEY parent_conf (conference_id),
KEY parent_thread (thread_id),
KEY author (post_author),
KEY date (crdate)
);
#
# Table structure for table 'tx_chcforum_thread'
#
CREATE TABLE tx_chcforum_thread (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
category_id int(11) DEFAULT '0' NOT NULL,
conference_id int(11) unsigned DEFAULT '0' NOT NULL,
thread_closed tinyint(4) unsigned DEFAULT '0' NOT NULL,
thread_attribute tinyint(4) DEFAULT '0' NOT NULL,
thread_subject tinytext NOT NULL,
thread_author int(11) DEFAULT '0' NOT NULL,
thread_datetime int(11) DEFAULT '0' NOT NULL,
thread_views int(11) DEFAULT '0' NOT NULL,
thread_replies int(11) DEFAULT '0' NOT NULL,
thread_firstpostid int(11) DEFAULT '0' NOT NULL,
thread_lastpostid int(11) DEFAULT '0' NOT NULL,
cached_last_post_info tinytext NOT NULL,
cached_last_post_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY parent_cat (category_id),
KEY parent_conf (conference_id),
KEY created (thread_datetime)
);
#
# Table structure for table 'tx_chcforum_mail_log'
#
CREATE TABLE tx_chcforum_mail_log (
recipient_uid int(11) unsigned DEFAULT '0' NOT NULL,
message_uid int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_chcforum_user_conf'
#
CREATE TABLE tx_chcforum_user_conf (
user_uid int(11) unsigned DEFAULT '0' NOT NULL,
mailer_confs int(11) unsigned DEFAULT '0' NOT NULL,
forum_uid int(11) unsigned DEFAULT '0' NOT NULL,
KEY parent (mailer_confs),
KEY user (user_uid)
);
#
# Table structure for table 'tx_chcforum_user_thread'
#
CREATE TABLE tx_chcforum_user_thread (
user_uid int(11) unsigned DEFAULT '0' NOT NULL,
mailer_threads int(11) unsigned DEFAULT '0' NOT NULL,
forum_uid int(11) unsigned DEFAULT '0' NOT NULL,
KEY parent (mailer_threads)
);
#
# Table structure for table 'tx_chcforum_f_conf'
#
CREATE TABLE tx_chcforum_f_conf (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
feusers_pid int(11) unsigned DEFAULT '0' NOT NULL,
posts_per_page int(11) unsigned DEFAULT '0' NOT NULL,
threads_per_page int(11) unsigned DEFAULT '0' NOT NULL,
max_user_img int(11) unsigned DEFAULT '0' NOT NULL,
max_attach int(11) unsigned DEFAULT '0' NOT NULL,
allowed_file_types text NOT NULL,
allowed_mime_types text NOT NULL,
mailer_forum_url text NOT NULL,
mailer_disable tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_aim tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_yahoo tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_msn tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_img tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_email tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_website tinyint(3) unsigned DEFAULT '0' NOT NULL,
disable_profile tinyint(3) unsigned DEFAULT '0' NOT NULL,
req_email tinyint(3) unsigned DEFAULT '0' NOT NULL,
custom_im text NOT NULL,
tmpl_path text NOT NULL,
date_format text NOT NULL,
time_format text NOT NULL,
pruning_auto tinyint(3) unsigned DEFAULT '0' NOT NULL,
pruning_age int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_chcforum_mail_queue'
#
CREATE TABLE tx_chcforum_mail_queue (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
conf_uid int(11) unsigned DEFAULT '0' NOT NULL,
thread_uid int(11) unsigned DEFAULT '0' NOT NULL,
post_uid int(11) unsigned DEFAULT '0' NOT NULL,
post_author tinytext NOT NULL,
post_subject tinytext NOT NULL,
post_text text NOT NULL,
post_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
sent_flag tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_chcforum_posts_read'
#
CREATE TABLE tx_chcforum_posts_read (
uid int(11) unsigned NOT NULL auto_increment,
feuser_uid int(11) unsigned DEFAULT '0' NOT NULL,
post_uid text NOT NULL,
PRIMARY KEY (uid),
KEY user (feuser_uid)
);
CREATE TABLE tx_chcforum_visits (
uid int(11) unsigned DEFAULT '0' NOT NULL,
feuser_uid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY user_visit (feuser_uid)
);
#
# Table structure for table 'tx_chcforum_rating'
#
CREATE TABLE tx_chcforum_ratings (
post_uid int(11) unsigned DEFAULT '0' NOT NULL,
rating int(1) unsigned DEFAULT '0' NOT NULL,
rater_ip tinytext NOT NULL,
rater_uid int(11) unsigned DEFAULT '0' NOT NULL,
KEY parent (post_uid)
);
