Extension talk:WikiForum/Archive

Please report WikiForum bugs on the Bugzilla rather than on this page.

WikiForum link in the toolbox
is there a way to Move the WikiForum link out from the Toolbox area —The preceding unsigned comment was added by Lynxcub (talk • contribs). Please sign your posts with ~ !


 * Not really. If you don't like it, you can always comment out the appropriate  line in WikiForum.php. --Jack Phoenix (Contact) 21:40, 20 May 2011 (UTC)

No access to mysql command line
I'm on godaddy hosting and they do not allow access to their mysql database from outside their network, as i've been told by a representative. I've never had to add tables to a mysql database via the phpMyAdmin interface.

What should i enter for the field name and number of entries in the 'Create new table on database' section? -June 5, 2011 —The preceding unsigned comment was added by 24.140.145.42 (talk • contribs). Please sign your posts with ~ !


 * You don't need to create a new database. Instead, open phpMyAdmin and go to the existing MediaWiki database. Select the "SQL" tab and paste the queries from wikiforum.sql into that input field, replacing  with the value of $wgDBprefix (or if you don't use $wgDBprefix, you can just delete the   comment, it doesn't matter) and   with the value of $wgDBTableOptions and then press the submit button. --Jack Phoenix (Contact) 14:31, 8 June 2011 (UTC)

sql errors
I've gotten the tables installed, but i get this error on the Special:WikiForum page

Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "WikiForumClass::showOverview". Database returned error "1146: Table 'MYDATABASE.mw_wikiforum_category' doesn't exist (MYDATABASE.db.6835840.hostedresource.com)".

-22:50 EST 6/7/2011 —The preceding unsigned comment was added by 24.140.145.42 (talk • contribs). Please sign your posts with ~ !


 * Apparently you didn't do it correctly. My guess is that you forgot the $wgDBprefix from the queries. --Jack Phoenix (Contact) 14:31, 8 June 2011 (UTC)


 * Maybe?  Problem Solved! The tables were improperly named when they were created, and needed to have 'mw_' added to the beginning of each.  Seems to be working now. 24.140.145.42 23:01, 9 June 2011 (UTC)

database returned error 1146
Hi. I'm having this problem too with a MW/ SemanticBundle - It says "A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SMWSqlStore2IdCache::getId". Database returned error "1146: Table 'sbundle.smw_ids' doesn't exist (localhost)". Could someone explain (to a newbie) how you solved this problem? Perhaps I need a smw_ on the front of my tables - if so, how do I do this? Its running locally using MAMP at the moment. Yours hopefully, Open Research (talk) 20:56, 9 October 2012 (UTC)

smiles
in the original wikiforum there is a link "show list of smiles/icons", which shows the smiles if the ones have been configured. how can i do the same with this wikiforum? --Erithion 08:56, 17 June 2011 (UTC)


 * You can't, at least not at the moment. WikiForum's smiley support is something that I need to clean up and test; I really want to get rid of that $wgWikiForumSmilies global variable, as it's not a flexible way to configure smilies (since it means that site administrators cannot edit them). --Jack Phoenix (Contact) 14:08, 30 June 2011 (UTC)
 * ok, I see. thanks for your reply --Erithion 21:40, 30 June 2011 (UTC)

email notifications
I've noticed that there's no email notification on any replies, no way to watch the thread etc. Is it something that I missed in config or notifications are just absent indeed? --Erithion 21:57, 30 June 2011 (UTC)


 * For now, e-mail notifications are indeed absent. --Jack Phoenix (Contact) 17:32, 19 December 2011 (UTC)

are there any news on the email notification? Your extension is great - but to make a really usable forum we would need some sort of notification... Thanks! --Stefahn (talk) 18:17, 3 September 2012 (UTC)
 * Hello Jack,


 * I wish I had, but nope. As much as I hate to admit this, WikiForum is &mdash; more or less &mdash; bitrotting for the time being. There are some rather annoying bugs that are yet to be fixed (as you can see by just reading this very page), I don't have the time to focus on WikiForum right now due to various other (both online and offline) projects and, in true open source spirit, no-one else seems to have any interest in bugfixing and/or developing the extension, not even the author of the original extension. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

Can you maybe recommend another forum solution for MediaWiki that offers notification mails? I already searched for bridges to common forum softwares such as phpbb but couldn't find any uptodate solution... --Stefahn (talk) 08:45, 4 September 2012 (UTC)
 * Thanks for your quick reply! I understand that you have more important things to do...

Therefore I imagine that spreading the word about WikiForum would gather interest and maybe someone with sufficient PHP (& (My)SQL) skills...then again that could just be my wishful thinking. --Jack Phoenix (Contact) 20:54, 6 September 2012 (UTC)
 * To the best extent of my knowledge, there really aren't any. That's why I ended up hacking the original WikiForum. In my humble opinion, duplicating efforts is just silly, which is why I'd strongly recommend you to at least try to get some people interested in bugfixing and developing WikiForum further. There is a strong demand for some kind of a discussion thingy inside MediaWiki and LiquidThreads (LQT) hasn't succeeded in its mission.

Yes, it would be great if any people extended WikiForum. Unfortunately I only have little PHP skills up2now. I think I will try to integrate WordPress with MediaWiki. WordPress offers proper forum extensions. Only question is how good the bridge between WordPress and MediaWiki will work... --Stefahn (talk) 23:21, 6 September 2012 (UTC)
 * Thanks for the info. Was LQT supposed to be a forum? I think it is a good tool for discussion pages. I don't understand/know why its development is on hold...


 * Stefahn, you might check out AWC's Forum extension. It's got the features you're looking for (a few too many features imo). Not as clean as WikiForum, but pretty good. - Lbillett (talk) 03:47, 18 November 2012 (UTC)


 * Thanks for the hint, Lbillett. I already tried AWC Forum a while ago and wasn't happy with it. Its settings were confusing and it doesn't seem to be maintained... Currently I'm trying to combine MediaWiki and MyBB. If anyone can help regarding a working bridge between MediaWiki and MyBB please help. --Stefahn (talk) 10:50, 18 November 2012 (UTC)

Small/Configurable "New Entries" for the Main Page
Is there a way to config the  tag? I need a smaller, unobtrusive output for the main page (i.e. a link with the title and date of the tree newest entries). Thank you in advance! --129.206.90.2 15:18, 14 July 2011 (UTC)

Tweaks to wikiforum.sql for SQLite
I had to make the following updates create the necessary tables in SQLite 3.7.5 (via the Firefox SQLite Manager extension) --74.70.123.165 18:07, 26 August 2011 (UTC)
 * Change int(10) to INTEGER
 * Change AUTO_INCREMENT to AUTOINCREMENT

Error: Non-string key given
Hi

We have MW 1.17 installed and we want to use this cool extension. Unfortunately the following error message appears, after we deleted a thread: Non-string key given

Backtrace:


 * 0 C:\wrs\www\w\includes\GlobalFunctions.php(781): MessageCache->get(NULL, true, Object(Language))
 * 1 C:\wrs\www\w\includes\GlobalFunctions.php(902): wfMsgGetKey(NULL, true, Object(Language), false)
 * 2 C:\wrs\www\w\languages\Language.php(513): wfMsgExt(NULL, Array)
 * 3 C:\wrs\www\w\languages\Language.php(525): Language->getMessageFromDB(NULL)
 * 4 C:\wrs\www\w\languages\Language.php(799): Language->getMonthName(false)
 * 5 C:\wrs\www\w\languages\Language.php(1560): Language->sprintfDate('H:i, j F Y', false)
 * 6 C:\wrs\www\w\extensions\WikiForum\WikiForumClass.php(1187): Language->timeanddate('2147483647????')
 * 7 C:\wrs\www\w\extensions\WikiForum\SpecialWikiForum.php(321): WikiForumClass->showOverview
 * 8 C:\wrs\www\w\includes\SpecialPage.php(578): WikiForum->execute(NULL)
 * 9 C:\wrs\www\w\includes\Wiki.php(251): SpecialPage::executePath(Object(Title))
 * 1) 10 C:\wrs\www\w\includes\Wiki.php(63): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
 * 2) 11 C:\wrs\www\w\index.php(114): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
 * 3) 12 {main}

What could be the problem? Thx, Dorian & Erwan --193.247.250.35 10:59, 4 September 2011 (UTC)


 * Problem resolved by us - this is no issue any more! Dorian & Erwan --91.137.20.132 07:36, 8 September 2011 (UTC)

How do you resolve the problem?? 10:57, 3 November 2011 (UTC)


 * I analyzed a little bit why this error appears, and I noticed that in WikiForumClass.php the timestamp value of wff_last_post_timestamp was converted in an intval. When I removed that, it worked (see below):

$row = $dbw->fetchRow( $new ); // Update the forum table so that the data shown on			// Special:WikiForum is up to date $dbw->update(				'wikiforum_forums',				array( "wff_reply_count = wff_reply_count - $replyCount", 'wff_thread_count = wff_thread_count - 1', 'wff_last_post_user' => intval( $row['wft_last_post_user'] ), // 'wff_last_post_timestamp' => intval( $row['wft_last_post_timestamp'] ) // OLD 'wff_last_post_timestamp' => $row['wft_last_post_timestamp'] // NEW ),				array( 'wff_forum' => intval( $thread->wft_forum ) ),				__METHOD__			); Cheers, Dorian --85.4.133.156 12:39, 26 December 2011 (UTC)
 * I got the same problem, and when I tried fixing it like above it now just gives me a server error (even after reverting the change). Any ideas? Ajraddatz (Talk) 23:14, 3 March 2013 (UTC)

PostgreSQL 8.4.8
Prompt how to install please WikiForum having database PostgreSQL if it generally is possible.

Excuse for the bad English. —The preceding unsigned comment was added by 89.179.33.86 (talk • contribs)


 * WikiForum doesn't have PostgreSQL support right now, someone needs to write the PostgreSQL schemas first. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

Spam Protection
My wiki was recently found by a number of spam bots. While there were plugins to stop them from generating lots of spam topics and editing articles, these plugins did not stop them from adding junk topics in the forums. How might I stop this? 164.107.85.71 17:54, 14 September 2011 (UTC)


 * I beleive that setting  in the LocalSettings.php disables annonymous posting, which should bring down spam posts with a user verification system.  I cannot confirm this as my forums are 'broken'.  Jacobcia 01:04, 10 November 2011 (UTC)


 * WikiForum currently doesn't support any CAPTCHA methods, such as Extension:ConfirmEdit, but it probably should. Feel free to file a bug ticket on Bugzilla about this. --Jack Phoenix (Contact) 17:32, 19 December 2011 (UTC)

$this in Linker.php
Adding a new thread I get this error:

Fatal error: Using $this when not in object context in /var/wwwwiki/includes/Linker.php on line 175 Line 175 is: $target = $this->normaliseSpecialPage( $target ); Can some one help me?

I got the same error here, can anybody help? --193.16.163.243 11:27, 7 November 2011 (UTC)

I also have the same problem. I am using mediawiki 1.17. Any suggestions? --87.202.73.87 12:27, 14 November 2011 (UTC)
 * I believe that I may have located the problem and found a simple solution. The problem is in line 175 of Linker.php :  which is inside public function link of class Linker. That function is called by WikiForumClass.php on line 2349. That part is as follows


 * From what I understand, that part of the code calls function link of Linker class without creating a Linker instance. Hence the error Using $this when not in object context. I changed the code to


 * This way a new instance of Linker class gets created and its link function is called. So now you do have an object and you are using $this in object context. I haven't tested it fully yet but so far it seems to do the trick. Please try it out give feedback. by sf42--87.202.73.87 12:52, 14 November 2011 (UTC)


 * Just update your MediaWiki to 1.18.0 and WikiForum to the latest version &mdash; the Linker class is static since 1.18. :) --Jack Phoenix (Contact) 17:32, 19 December 2011 (UTC)

Integrate with SocialProfile
Is there a way to make it so that when users post, create threads, etc, that they could earn points in Extension:SocialProfile? i dont know enough about programming to make it work on my own... --24.140.146.29 00:02, 7 November 2011 (UTC)


 * Yes, it's possible to add such support into WikiForum. You'd need to add a new column (for example, ) into the   database table, and then in the appropriate part of WikiForum, you'd call SocialProfile's UserStatsTrack class, maybe something like this:


 * Please keep in mind that the above code is somewhat pseudocode and you probably need to do something more to add a new stat into the user_stats table. While it's not exactly trivial, it's possible. --Jack Phoenix (Contact) 17:32, 19 December 2011 (UTC)

Fatal error: Call to undefined method OutputPage::addModuleStyles in /home/dvswiki/wiki.dvsport.com/extensions/WikiForum/WikiForumHooks.php on line 284
Not sure what I am doing wrong. I have not modified any of the files other than setting the anon variable to false to prevent anonymous creation of threads.

Also looked to report my error on Bugzilla, but there is no listing of WikiForum in the extensions and I don't know where else to post the error I am getting. —The preceding unsigned comment was added by Njhoudini (talk • contribs). Please sign your posts with ~ !


 * The documentation page is &mdash; once again &mdash; out of date. WikiForum has required MediaWiki 1.18.0 since r99352 (9 October 2011). The module stuff is related to ResourceLoader, which is a new feature in MediaWiki 1.17+.


 * It's true that Bugzilla's MediaWiki extension list doesn't have WikiForum (that's because that listing isn't automatically updated, it's manually updated every now and then by the people who have administrative rights to Bugzilla), but you can use the "General/Unknown" component instead. --Jack Phoenix (Contact) 17:32, 19 December 2011 (UTC)

Concerning security
Hi. Congrats for the extension, it works like a charm :) However I'm a bit worried about security. Are there any security risks that the users of the extension should be aware of? (ie XSS in post replies or similar possible attacks)? How does wikiForum extension deal with wikis having $rawHTML enabled? In my case I've been able to post html code during my testing, and immediately wondered if that could be exploited by malicious users. (just to let you know, I do not allow anonymous users posting on the forum) Thanks in advance. —The preceding unsigned comment was added by 195.235.9.98 (talk • contribs)


 * Enabling $wgRawHtml on a publicly editable wiki is asking for your wiki to get cracked. WikiForum uses MediaWiki's standard parsing functions and it should have no security issues. If you do find security issues in WikiForum, please report them on the MediaWiki Bugzilla (Enter a new bug &rarr; pick "Security" as the product). --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

'searchbox' ID
FYI: bug 33676: 'searchbox' collides with the Inputbox 'searchbox'. SPQRobin 00:19, 12 January 2012 (UTC)


 * This was fixed in r115138. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

Does this extension support image?
I think it should have external images support.

--Zoglun (talk) 21:28, 1 March 2012 (UTC)


 * It should, depending on the values of $wgAllowExternalImages and $wgAllowExternalImagesFrom. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

Cant add new forum
I install wikiforum, and add my user to "forum administrator". But in Special:WikiForum page, cant add new forum; i see normal user page. Whats wrong? (Mediawiki 1.17.3, WikiForum (verzió: 1.2.2-SW) (r115615) ) --Mkepler (talk) 16:39, 18 July 2012 (UTC)
 * But! Add manually record to wikiforum_category, everything is fine.--195.228.124.2 06:25, 19 July 2012 (UTC)
 * I dont understand, how did you fix this? I have the same problem, i am forum admin but cannot figure out how to add places to post in the Special:WikiForum page. Crazy Jake88 (talk) 16:52, 27 August 2012 (UTC)

User Rights
Hi, congrats to the wonderful extension. Is it possible that a registered user can write in the forum without editing the normal wiki pages?

Thanks in advance —The preceding unsigned comment was added by 141.99.224.112 (talk • contribs)


 * Probably not possible right now. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

Anonymous Users
Hi, is it possible that anonymous users can leave a name? Otherwise it is difficult to differ between different anonymous users. —The preceding unsigned comment was added by 141.99.224.112 (talk • contribs)


 * Not really, unfortunately. This is a bug that should be fixed. --Jack Phoenix (Contact) 21:48, 3 September 2012 (UTC)

One, minor " problem".
Hey, first of all - Great Job! The forum works perfectly, except:

When a user posts a reply to a topic, it will add to the topic's post counter ; however, when a user finds a small, spelling mistake and edits one's post to change it, the action will also add to the post counter and in result the actual value of the counter will be misleading. Maybe the solution is somewhat trivial for you, as person with expert knowledge in coding, but I have merely covered the basics so far (:. Thanks in advance! 78.88.254.118 11:13, 15 September 2012 (UTC)

Italian translation
$messages['it'] = array(	'wikiforum-desc' => 'Estensione Forum per MediaWiki',	'wikiforum' => 'Forum di Discussione',

// Configuration variables -- do not translate! 'wikiforum-day-definition-new' => '3', 'wikiforum-max-threads-per-page' => '20', 'wikiforum-max-replies-per-page' => '10',

'wikiforum-anonymous' => 'Anonimo', 'wikiforum-announcement-only-description' => 'Forum di Annunci (solo i moderatori possono aggiungere discussioni)', 'wikiforum-by' => '$1 da $2', 'wikiforum-description' => 'Descrizione:', 'wikiforum-forum-is-empty' => 'Il forum è vuoto. Prego contattare un amministratore che possa aggiungere categorie e forum.', 'wikiforum-forum-name' => 'Forum $1', 'wikiforum-name' => 'Nome:', 'wikiforum-button-preview' => 'Anteprima', 'wikiforum-preview' => 'Anteprima', 'wikiforum-preview-with-title' => 'Anteprima: $1', 'wikiforum-save' => 'Salva', 'wikiforum-error-search' => 'Errore di ricerca', 'wikiforum-error-search-missing-query' => 'Devi inserire un termine per la ricerca!', 'wikiforum-search-hits' => 'Trovato NaN $1 vocis', 'wikiforum-search-thread' => 'Discussione: $1', 'wikiforum-thread-deleted' => 'discussione cancellata', 'wikiforum-topic-name' => 'Forum - $1', 'wikiforum-updates' => 'Forum aggiornato di recente',

'wikiforum-write-thread' => 'Nuova Discussione', 'wikiforum-replies' => 'Risposte', 'wikiforum-views' => 'Visite', 'wikiforum-thread' => 'Discussione', 'wikiforum-threads' => 'Discussioni', 'wikiforum-latest-reply' => 'Ultima Risposta', 'wikiforum-latest-thread' => 'Ultima Discussione', 'wikiforum-forum' => 'Forum: $1 > $2', 'wikiforum-overview' => 'Overview', 'wikiforum-pages' => 'Pagine:', 'wikiforum-thread-closed' => 'Discussione Chiusa', 'wikiforum-new-thread' => 'Nuova discussione', 'wikiforum-edit-thread' => 'Modifica discussione', 'wikiforum-delete-thread' => 'Cancella discussione', 'wikiforum-close-thread' => 'Chiude discussione', 'wikiforum-reopen-thread' => 'Riapri discussione', 'wikiforum-write-reply' => 'Rispondi', 'wikiforum-edit-reply' => 'Modifica Risposta', 'wikiforum-delete-reply' => 'Cancella Risposta', 'wikiforum-save-thread' => 'Salva discussione', 'wikiforum-save-reply' => 'Salva risposta', 'wikiforum-thread-title' => 'Titolo della discussione', 'wikiforum-no-threads' => 'Nessuna discussione3 disponibile.',

'wikiforum-posted' => 'Inviato il $1 da $2', 'wikiforum-edited' => 'Modificato il $1 da $2', 'wikiforum-closed-text' => 'La discussione è stata chiusa il $1 da $2',

'wikiforum-cat-not-found' => 'Categoria non trovata', 'wikiforum-cat-not-found-text' => 'La categoria non esiste - torna a $1', 'wikiforum-forum-not-found' => 'Forum non trovato', 'wikiforum-forum-not-found-text' => 'Il Forum non esiste - torna a $1', 'wikiforum-thread-not-found' => 'Discussione non trovata', 'wikiforum-thread-not-found-text' => 'La Discussione non esiste o è stata cancellata - torna a $1.',

'wikiforum-error-thread-reopen' => 'Errore di risposta alla discussione', 'wikiforum-error-thread-close' => 'Errore di chiusura discussione', 'wikiforum-error-general' => 'Oggetto non trovato o non hai i permessi per eseguire questa azione.', 'wikiforum-error-no-rights' => 'Non hai i permessi per eseguire questa azione.', 'wikiforum-error-not-found' => 'Oggetto non trovato.', 'wikiforum-error-no-text-or-title' => 'Titolo o testo non inseriti.', 'wikiforum-error-no-reply' => 'Manca risposta.', 'wikiforum-error-double-post' => 'Protezione da doppio click discussione già aggiunta.', // @todo FIXME: better wording 'wikiforum-error-thread-closed' => 'La discussione è chiusa. Non si possono aggiungere rispote.',

'wikiforum-error-delete' => 'Errore di cancellazione', 'wikiforum-error-sticky' => 'Errore di cambio attributi', 'wikiforum-error-move-thread' => 'Errore di spostamento discussione', 'wikiforum-error-add' => 'Errore di inserimento', 'wikiforum-error-edit' => 'Errore di modifica',

'wikiforum-add-category' => 'Aggiungi Categoria', 'wikiforum-edit-category' => 'Modifica Categoria', 'wikiforum-delete-category' => 'Cancella categoria', 'wikiforum-add-forum' => 'Aggiungi forum', 'wikiforum-edit-forum' => 'Modifica forum', 'wikiforum-delete-forum' => 'Cancella forum', 'wikiforum-sort-up' => 'ordine crescente', 'wikiforum-sort-down' => 'ordine decrescente', 'wikiforum-remove-sticky' => 'Togli Importante', 'wikiforum-make-sticky' => 'Rendi Importante', 'wikiforum-move-thread' => 'Sposta Discussione', 'wikiforum-paste-thread' => 'Incolla Discussione', 'wikiforum-quote' => 'Quota',

// For Special:ListGroupRights 'right-wikiforum-admin' => 'Aggiungi, modifica e cancella categorie sul Forum di Discussione', 'right-wikiforum-moderator' => 'Modifica e cancella discussioni sul Forum di Discussione',

// Forum admin group, as per discussion with Jedimca0 on 30 December 2010 'group-forumadmin' => 'Amministratori Forum', 'group-forumadmin-member' => 'Amministratore Forum', 'grouppage-forumadmin' => '   :Amministratori Forum', );

Group permissions
Can someone please explain the group permissions to me? There is just a massive dropdown list.--60.241.141.102 23:38, 19 February 2013 (UTC)

SQLite to Create the 4 WikiForum tables Manually
if needed, create the tables manually with these sqlite statements

CREATE TABLE wikiforum_category ( wfc_category INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wfc_category_name varchar(50) NOT NULL, wfc_sortkey mediumint(5) NOT NULL DEFAULT '9', wfc_added_timestamp binary(14) NOT NULL DEFAULT '', wfc_added_user INTEGER NOT NULL DEFAULT '0', wfc_edited INTEGER NOT NULL DEFAULT '0', wfc_edited_user INTEGER NOT NULL DEFAULT '0', wfc_deleted INTEGER NOT NULL DEFAULT '0', wfc_deleted_user INTEGER NOT NULL DEFAULT '0' ); COMMIT

CREATE TABLE wikiforum_forums ( wff_forum INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wff_forum_name varchar(50) NOT NULL, wff_description varchar(255) NOT NULL, wff_category INTERGER NOT NULL, wff_sortkey mediumint(5) NOT NULL DEFAULT '9', wff_thread_count INTEGER NOT NULL DEFAULT '0', wff_reply_count INTEGER NOT NULL DEFAULT '0', wff_last_post_user INTEGER NOT NULL DEFAULT '0', wff_last_post_timestamp binary(14) NOT NULL DEFAULT , wff_added_timestamp binary(14) NOT NULL DEFAULT , wff_added_user INTEGER NOT NULL DEFAULT '0', wff_edited_timestamp binary(14) NOT NULL DEFAULT '', wff_edited_user INTEGER NOT NULL DEFAULT '0', wff_deleted INTEGER NOT NULL DEFAULT '0', wff_deleted_user INTEGER NOT NULL DEFAULT '0', wff_announcement tinyint(2) NOT NULL DEFAULT '0' ); COMMIT

CREATE TABLE wikiforum_threads ( wft_thread INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wft_thread_name varchar(255) NOT NULL, wft_text text NOT NULL, wft_sticky tinyint(1) NOT NULL DEFAULT '0', wft_posted_timestamp binary(14) NOT NULL DEFAULT , wft_user INTEGER NOT NULL DEFAULT '0', wft_deleted INTEGER NOT NULL DEFAULT '0', wft_deleted_user INTEGER NOT NULL DEFAULT '0', wft_edit_timestamp binary(14) NOT NULL DEFAULT , wft_edit_user INTEGER NOT NULL DEFAULT '0', wft_closed INTEGER NOT NULL DEFAULT '0', wft_closed_user INTEGER NOT NULL DEFAULT '0', wft_forum INTEGER NOT NULL DEFAULT '0', wft_reply_count INTEGER NOT NULL DEFAULT '0', wft_view_count INTEGER NOT NULL DEFAULT '0', wft_last_post_user INTEGER NOT NULL DEFAULT '0', wft_last_post_timestamp binary(14) NOT NULL DEFAULT '' ); COMMIT

CREATE TABLE wikiforum_replies ( wfr_reply_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wfr_reply_text text NOT NULL, wfr_posted_timestamp binary(14) NOT NULL DEFAULT , wfr_user INTEGER NOT NULL DEFAULT '0', wfr_deleted INTEGER NOT NULL DEFAULT '0', wfr_deleted_user INTEGER NOT NULL DEFAULT '0', wfr_edit_timestamp binary(14) NOT NULL DEFAULT , wfr_edit_user INTEGER NOT NULL DEFAULT '0', wfr_thread INTEGER NOT NULL ); COMMIT