• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Nicaw AAC] Nicaw Bulletin Board

zippoxer

Active Member
Joined
Mar 18, 2008
Messages
105
Reaction score
44
Location
Israel
This is a forum built for nicaw aac, very easy to install and manage.


Default Features:
- Few antispam systems such as time limit between posting.
- Ability to post threads and reply in them (as in every forum).
- The user has to selected a character in order to post.


Admin features:
- Lock / Stick / Remove threads and replies (more than one post at a time)!
- Empty threads (removes all replies written in the specific thread).
- Create and edit all boards.
- Configure most of the settings trought the admin panel.
- An ability to set the forum's status to opened / closed which helps in case of an attack.


Download link:
nicaw forum.zip


How to install:

1) Extract all files in the zip folder you've downloaded into nicaw aac directory (one of the files should be replaced with a new one).

2) Execute this sql query in your database:
Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `nicaw_boards` (
  `board_id` int(11) NOT NULL AUTO_INCREMENT,
  `board_name` varchar(64) NOT NULL,
  `board_description` longtext NOT NULL,
  `board_access` int(11) NOT NULL,
  PRIMARY KEY (`board_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

CREATE TABLE IF NOT EXISTS `nicaw_posts` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_board_id` int(11) NOT NULL,
  `post_thread_id` int(11) DEFAULT NULL,
  `post_is_thread` tinyint(1) DEFAULT NULL,
  `post_last_post` int(10) NOT NULL,
  `post_is_locked` tinyint(1) DEFAULT NULL,
  `post_is_sticky` tinyint(1) NOT NULL,
  `post_title` varchar(64) DEFAULT NULL,
  `post_content` longtext NOT NULL,
  `post_date` int(11) NOT NULL,
  `post_author_id` int(11) NOT NULL,
  `post_author_name` varchar(100) NOT NULL,
  `post_author_level` int(11) NOT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=126 ;

CREATE TABLE IF NOT EXISTS `nicaw_settings` (
  `name` varchar(64) NOT NULL,
  `value` longtext NOT NULL,
  `description` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `nicaw_settings` (`name`, `value`, `description`) VALUES
('reply_max_length', '1000', ''),
('wait_between_posts', '15', ''),
('thread_min_length', '10', ''),
('thread_max_length', '2000', ''),
('thread_title_min_length', '3', ''),
('thread_title_max_length', '40', ''),
('reply_min_length', '2', ''),
('author_info_box_align', 'left', '');

ALTER TABLE `nicaw_accounts` ADD `last_post` INT( 10 ) NOT NULL

3) Open forum_config.php, change the name zippoxer in line 10 to your admin account name and save.

4) Now feel free to visit forum.php and click the Forum Management link at the top-right (if you cannot see that link then you're not configured as an admin in config.php, repeat step 3).


Just say thanks if it helped you =]
 
Just note that the forum comes closed by default, just change it in the config - my mistake while uploading :\
 
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\Program\xampp\htdocs\nicaw1\forum_config.php on line 42

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program\xampp\htdocs\nicaw1\forum.php on line 15


halp? plssss
 
Fatal error: Cannot access private property Account::$attrs in C:\Tibia Server\XAMPP\htdocs\forum_config.php on line 32

Help please

line 32:
Code:
$is_admin = (in_array($account->attrs['name'], $admin_accounts)) ? TRUE : FALSE;"


I'm using avesta 7.6 btw
 
Help please

line 32:
Code:
$is_admin = (in_array($account->attrs['name'], $admin_accounts)) ? TRUE : FALSE;"


I'm using avesta 7.6 btw

I've tested it only with the newest nicaw SVN, but I can fix it for you.

Now it's 1:00 at morning for me, so my codes will be tired as me (and it's not good). I will fix this and some other problems tomorrow =]
 
zippoxer, you done this script btw?

and can you make so if a board comes over another board, and you wish it would be more lower? make some buttons to lower/higher them on the forum... like movies should not be over news huh? i am right? u get what i mean?
 
zippoxer, you done this script btw?

and can you make so if a board comes over another board, and you wish it would be more lower? make some buttons to lower/higher them on the forum... like movies should not be over news huh? i am right? u get what i mean?

Hhh lol I forgot that ...
I'm fixing it now, but first I just make the board to work with nicaw avesta =]
 
Taken from PHP: extract - Manual
Do not use extract() on untrusted data, like user input (i.e. $_GET, $_FILES, etc.). If you do, for example if you want to run old code that relies on register_globals temporarily, make sure you use one of the non-overwriting extract_type values such as EXTR_SKIP and be aware that you should extract in the same order that's defined in variables_order within the php.ini.
Just a slight warning since I saw that you are using extract for $_POST. I have yet to examine the entire code, but I passed through it real quick and notice the extract function.
 
Sorry for late!

here is the newer version (you can reorder the boards):
nicaw forum.zip

And nicaw avesta version:
nicaw forum avesta.zip

The sql schema is the same as it was (look at the first post).

Absolute Mango, ty for advice. I won't use it anymore =]

And yes, this was scripted by me ;)
 
Back
Top