Discussion: Superuser Forum (superuserforum) v3.0.1 Rewritten

[Afkamm]

Lonny wrote the original called 'forum'. Danilo modified and renamed it 'superuserforum' (unsure of the changes that were made). I've rewritten it using the code as a base and added extra features.

Features:

• Categories, Yay!
• Pagination for threads and topics
• Category page shows thread counts, post counts, last post details.
• Thread page shows topic creator, reply count and last post details.
• You can quote posts and edit your own.
• MEGAUSERS and player made moderators can lock/unlock threads, delete posts or entire threads and edit posts (even when locked).
• Default post colour can be changed in preferences.
• All colour codes can now be used along with some bbcode tags.
• A few smaller bits and bobs.

I should point out that I've removed the built in smilies (emoticons). This has been moved to another module which I've yet to write.

Feedback, comments, bugs, etc.

Updates:
06/08/2010 - v3.0.1
+ Added hook to 'checkuserpref' and changed user prefs 'user_' to 'check_'. Now a check is performed and only SU players see these on the preferences page.


Download Thread

[HunterD]

I LIKE IT!  xD  Thanks again!

[The Doctor]

I installed the module, and immediately got the following error:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=INNODB' at line 15
CREATE TABLE superuserforum (
postid smallint(5)   unsigned NOT NULL auto_increment,
threadid smallint(5)   unsigned NOT NULL default '0' ,
catid smallint(5)   unsigned NOT NULL default '0' ,
postorder smallint(5)   unsigned NOT NULL default '1' ,
locked tinyint(1)      unsigned NOT NULL default '0' ,
postdate datetime NOT NULL default '0000-00-00 00:00:00' ,
editdate datetime NOT NULL default '0000-00-00 00:00:00' ,
userid smallint(5)   unsigned NOT NULL default '0' ,
edituserid smallint(5)   unsigned NOT NULL default '0' ,
title varchar(100) NOT NULL ,
content text ,
editreason varchar(100) NOT NULL ,
PRIMARY KEY (postid),
KEY postid (postid)) Type=INNODB

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=INNODB' at line 6
CREATE TABLE superuserforumcats (
catid smallint(5)   unsigned NOT NULL auto_increment,
catname varchar(100) NOT NULL ,
description text ,
catorder smallint(5)   unsigned NOT NULL default '1' ,
PRIMARY KEY (catid)) Type=INNODB

Anyone?

[Afkamm]

If you change both occurrences of Type=INNOB to Engine=INNOB, do you still get the error?

[The Doctor]

If you change both occurrences of Type=INNOB to Engine=INNOB, do you still get the error?

I can't find where in the code is says Type=INNOB, though.. o.o

[Anharat]

At the very end of both sql statements. And it should be INNODB. 

[The Doctor]

At the very end of both sql statements. And it should be INNODB. 

Can anyone else find it? >.> I did a CTRL+F for 'INNODB', and naught. Zilch. It makes a couple of arrays, then synctable's them.. Nothing there about Innodb. o_o

[Boris735]

Don't forget the handy search function on this forum.  Searching for INNODB turns up this earlier post of mine pretty quickly.

[The Doctor]

Don't forget the handy search function on this forum.  Searching for INNODB turns up this earlier post of mine pretty quickly.

A lifesaver you be, sir. Works perfectly! My thanks!

[RaynDarren]

Sorry to bump an old thread, but I've just downloaded this and have run into a problem. The new thred creation doesn't appear to be working. I've attempted to create three threads in two catagories and it keeps telling me that there are no threads and I should make one.

[The Doctor]

Sorry to bump an old thread, but I've just downloaded this and have run into a problem. The new thred creation doesn't appear to be working. I've attempted to create three threads in two catagories and it keeps telling me that there are no threads and I should make one.

Did the database install correctly?

[RaynDarren]

It appears to have yes, I'm going to uninstall and reinstall though, just to be sure

::EDIT::

The uninstall/reinstall worked!

@Afkamm - i LOVE this module! I do believe i'm gonna alter it so it can be for the players too!

[Afkamm]

This isn't an old thread, just over a month old.

Easy enough to change. Change the filename and function names (just to make looks nicer. not something you have to do), hook into a village and add a nav link for people to return to the village.

[Michelina]

Wow!
I love the changes.
*dances*

[Brandon]

*points out that it was a month old* O.o