modern acc forum dosent work?

TKO · Nov 7, 2010

hey how come modern acc forum dosent work?
i get this error:

Error Number: 1054

Unknown column 'board_id' in 'field list'

SELECT `b`.`id`, `b`.`name`, `b`.`description`, `b`.`closed`, `b`.`moderators`, `u`.`name` AS `author`, `p`.`thread_id`, `t`.`name` AS `thread_title`, `p`.`time` FROM `forums` AS `b` LEFT JOIN (SELECT `time`, `thread_id`, `board_id`, `author` FROM `posts` ORDER BY `time` DESC) AS `p` ON `p`.`board_id` = `b`.`id` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `threads` AS `t` ON `t`.`id` = `p`.`thread_id` WHERE `b`.`access` <= '0' AND `requireLogin` != '1' AND `b`.`guild` IS NULL GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;

TKO · Dec 16, 2010

yea i tryd and it work but this one then?
Error Number: 1054

Unknown column 'b.order' in 'order clause'

SELECT `b`.`id`, `b`.`name`, `b`.`description`, `b`.`closed`, `b`.`moderators`, `u`.`name` AS `author`, `p`.`thread_id`, `t`.`name` AS `thread_title`, `p`.`time` FROM `forums` AS `b` LEFT JOIN (SELECT `time`, `thread_id`, `board_id`, `author` FROM `posts` ORDER BY `time` DESC) AS `p` ON `p`.`board_id` = `b`.`id` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `threads` AS `t` ON `t`.`id` = `p`.`thread_id` WHERE `b`.`access` <= '0' AND `requireLogin` != '1' AND `b`.`guild` IS NULL GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;

Chris · Dec 16, 2010

SQL:

ALTER TABLE forums ADD (order INT(6) NOT NULL);

TKO · Dec 16, 2010

this error:
#1064 - 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 'ORDER INT(6) NOT NULL)' at line 1

Chris · Dec 16, 2010

Oh, crap. Sorry 'bout that. The word "ORDER" is a reserved SQL word.

SQL:

ALTER TABLE forums ADD (`order` INT(6) NOT NULL);

TKO · Dec 16, 2010

Thanks chris now it finally works

Thanks for your time

rep+

Chris · Dec 16, 2010

The pleasure is all mine! I'm glad it worked out well for you!

TKO · Dec 16, 2010

nvm found out by checking your reponds xD

TKO · Dec 16, 2010

Problem now is when i add a thread inside the forum i says:

Error:

The Post field is required.

but i have added the postfield with test or hello world or somting like that...

Chris · Dec 16, 2010

Hmpf, do you mind sharing the file source? It would help quite the lot.

TKO · Dec 16, 2010

what you mean file source? well im posting a thread inside the forum but i get the error
Website syphero.mine.nu

Chris · Dec 16, 2010

What I meant with 'file source' is may I have the actual file? So I can look in it for possible causes. Copy the content of it and paste it within

PHP:

 tags.

TKO · Dec 16, 2010

no idea what files it is really....
or i added wrong in the tabels?

Chris · Dec 16, 2010

Doubt it. You would most likely receive an error if so. Either way, the file I'm requesting is the following: ./system/application/controllers/forum.php

TKO · Dec 16, 2010

PHP:

<?php 

class Forum extends Controller {
	
	public function index() {
		$ide = new IDE;
		$ide->redirect(WEBSITE."/index.php/forum/view");
	}
	
	public function view($action = null) {
		if($action == 1) alert("You need to be logged in to access this forum.");
		if($action == 2) alert("You don't have right priviliges to view this forum.");
		$this->load->model("forum_model");
		$data = array();
		$data['boards'] = $this->forum_model->getBoards();
		$this->load->view("forum_main", $data);
	}
	
	public function board($id) {
		require("config.php");
		$ide = new IDE;
		$this->load->model("forum_model");
		$data = array();
		$data['board'] = $this->forum_model->getBoardInfo($id);
		if(empty($data['board'])) $ide->redirect(WEBSITE."/index.php/forum/view");
		if($data['board'][0]['requireLogin'] == 1 and $ide->isLogged() == false) $ide->redirect(WEBSITE."/index.php/forum/view/1");
		if($data['board'][0]['access'] > @$_SESSION['access'] and $ide->isLogged() == true) $ide->redirect(WEBSITE."/index.php/forum/view/2");
		if($data['board'][0]['access'] > 0 and $ide->isLogged() == false) $ide->redirect(WEBSITE."/index.php/forum/view/2");
		$this->load->library('pagination');
		$config['base_url'] = WEBSITE.'/index.php/forum/board/'.$id.'/';
		$config['total_rows'] = $this->forum_model->getThreadsAmount($id);
		$config['per_page'] = $config['threadsLimit'];
		$config['uri_segment'] = 4;
		$this->pagination->initialize($config); 
		$data['pages'] = $this->pagination->create_links();
		$data['threads'] = $this->forum_model->getThreads($id);
		
		
		$this->load->view("forum_board_view", $data);
	}
	
	public function thread($id = null) {
		require("config.php");
		$ide = new IDE;
		if(empty($id)) $ide->CriticalRedirect(WEBSITE."/index.php/forum");
		$this->load->model("forum_model");
		$data = array();
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$this->load->library('pagination');
		$config['base_url'] = WEBSITE.'/index.php/forum/thread/'.$id.'/';
		$config['total_rows'] = $this->forum_model->getPostsAmount($id);
		$config['per_page'] = $config['postsLimit'];
		$config['uri_segment'] = 4;
		$this->pagination->initialize($config); 
		$data['id'] = $id;
		$data['pages'] = $this->pagination->create_links();
		$data['posts'] = $this->forum_model->getPosts($id);
		if($ide->isLogged()) {
			$data['characters'] = $this->forum_model->getCharacters();
			$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		}
		$this->load->view("forum_view_thread", $data);
	}
	
	public function _checkCharacter($id) {
		$this->load->model("forum_model");
		if($this->forum_model->characterExistsOnAccount($id))
			return true;
		else {
			$this->form_validation->set_message('_checkCharacter', 'This character does not belongs to you.');
			return false;
		}
	}
	
	public function _checkTimer() {
		require("config.php");
		$time = time();
			if(empty($_SESSION['lastPost']))
				return true;
			else {
				$difference = $time-$_SESSION['lastPost'];
				if ($difference < $config['timeBetweenPosts'])
				{
					$this->form_validation->set_message('_checkTimer', 'You are doing it too fast, please wait another '.($config['timeBetweenPosts']-$difference).' seconds');
					return false;
				}
				else {
					return true;
				}
			}
	}
	
	public function new_thread($id = null) {
		$ide = new IDE;
		$ide->requireLogin();
		if(empty($id)) $ide->criticalRedirect(WEBSITE."/index.php/forum");
		$this->load->model("forum_model");
		$this->load->library("form_validation");
		$data = array();
		$data['board'] = $this->forum_model->getBoardInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if(empty($data['board'])) $ide->goPrevious();
			if(count($data['board']) == 0) $ide->redirect(WEBSITE."/index.php/forum");
			if($data['board'][0]['closed'] == 1) {
				if(!$ide->isAdmin() && $data['isModerator'] == false) {
					$ide->redirect(WEBSITE."/index.php/forum/board/".$data['board']['id']);
				}
			}
			if($data['board'][0]['access'] > @$_SESSION['access'] && $ide->isAdmin() == false && $data['isModerator'] == false)
				$ide->redirect(WEBSITE."/index.php/forum/board/".$data['board']['id']);	
		if($_POST) {
			$this->form_validation->set_rules('character', 'Character', 'required|callback__checkCharacter');
			$this->form_validation->set_rules('title', 'Title', 'required|min_lenght[3]|max_lenght[64]|callback__checkTimer');
			$this->form_validation->set_rules('post', 'Post', 'required|min_lenght[3]|max_lenght[3000]');
			$_POST['post'] = str_replace(array("&lt;", "&gt;"), array("<", ">"), $_POST['post']);
			if($this->form_validation->run() == true) {
				$_SESSION['lastPost'] = time();
				$this->forum_model->postThread($id, $_POST['character'], $_POST['title'], $_POST['post']);
				$ide->redirect(WEBSITE."/index.php/forum/thread/".$board['0']['id']);
			}
		}
		

		$data['id'] = $id;
		$this->load->helper("form_helper");
		$this->load->view("forum_new_thread", $data);
	}
	
	public function reply($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data = array();
		$data['thread'] = $this->forum_model->getThreadInfo($id);
			if(count($data['thread']) == 0) $ide->redirect(WEBSITE."/index.php/forum");
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if(empty($data['board'])) $ide->goPrevious();
			if($data['thread'][0]['closed'] == 1 && $ide->isAdmin() == false && $data['isModerator'] == false) $ide->goPrevious();
			if($data['board'][0]['closed'] == 1 && $ide->isAdmin() == false && $data['isModerator'] == false) $ide->goPrevious();
			if($data['board'][0]['access'] > @$_SESSION['access'] && $ide->isAdmin() == false && $data['isModerator'] == false) $ide->goPrevious();
		$this->load->helper("form_helper");
		$data['id'] = $id;
			$this->load->library("form_validation");
			if(isset($_POST['submit'])) {
				$this->form_validation->set_rules('character', 'Character', 'required|callback__checkCharacter');
				$this->form_validation->set_rules('title', 'Title', 'required|callback__checkTimer');
				$this->form_validation->set_rules('post', 'Post', 'required|min_lenght[3]|max_lenght[3000]');
				$_POST['post'] = str_replace(array("&lt;", "&gt;"), array("<", ">"), $_POST['post']);
				if($this->form_validation->run() == true) {
					$_SESSION['lastPost'] = time();
					$this->forum_model->postReply($data['thread'][0]['board_id'], $id, $_POST['character'], $_POST['title'], $_POST['post']);
					$ide->redirect(WEBSITE."/index.php/forum/thread/".$data['thread'][0]['id']);
				}
			}
		$this->load->view("forum_reply", $data);		
	}
	
	public function edit($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$data = array();
		$this->load->model("forum_model");
		$data['post'] = $this->forum_model->getPostInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['post'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['thread'] = $this->forum_model->getThreadInfo($data['post'][0]['thread_id']);
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
			if(count($data['post']) == 0) $ide->goPrevious();
			if(!$this->forum_model->isAuthor($data['post'][0]['author']) && $data['isModerator'] == false && $ide->isAdmin() == false) $ide->goPrevious();
			if($data['board'][0]['closed'] == 1 && $data['isModerator'] == false && $ide->isAdmin() == false) $ide->goPrevious();
			if($data['board'][0]['access'] > @$_SESSION['access'] and $data['isModerator'] == false and $ide->isAdmin() == false) $ide->goPrevious();
			if($data['thread'][0]['closed'] == 1 and $data['isModerator'] == false and $ide->isAdmin() == false) $ide->goPrevious();
		if($this->forum_model->isAuthor($data['post'][0]['author']) == true or $data['isModerator'] == true or $ide->isAdmin() == true) {
		$data['id'] = $id;
		$this->load->helper("form_helper");
		if($_POST) {
		$this->load->library("form_validation");
			$this->form_validation->set_rules('title', 'Title', 'required|callback__checkTimer');
			$this->form_validation->set_rules('post', 'Post', 'required|min_lenght[3]|max_lenght[3000]');
			$_POST['post'] = str_replace(array("&lt;", "&gt;"), array("<", ">"), $_POST['post']);
			if($this->form_validation->run() == true) {
				$_SESSION['lastPost'] = time();
				$this->forum_model->editPost($id, $_POST['title'], $_POST['post']);
				$ide->redirect(WEBSITE."/index.php/forum/thread/".$data['thread'][0]['id']);
			}
		}
		$this->load->view("edit_post", $data);
		}
	}
	
	public function delete_post($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['post'] = $this->forum_model->getPostInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['post'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['thread'] = $this->forum_model->getThreadInfo($data['post'][0]['thread_id']);
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if(count($data['post']) == 0) $ide->goPrevious();
		if(!$this->forum_model->isAuthor($data['post'][0]['author']) && $data['isModerator'] == false && $ide->isAdmin() == false) $ide->goPrevious();
		if($data['board'][0]['closed'] == 1 and $data['isModerator'] == false and $ide->isAdmin() == false) $ide->goPrevious();
		if($data['board'][0]['access'] > @$_SESSION['access'] and $data['isModerator'] == false and $ide->isAdmin() == false) $ide->goPrevious();
		if($data['thread'][0]['closed'] == 1 and $data['isModerator'] == false and $ide->isAdmin() == false) $ide->goPrevious();

		if($this->forum_model->isAuthor($data['post'][0]['author']) == true or $data['isModerator'] == true or $ide->isAdmin() == true) {
		$this->forum_model->deletePost($id);
		$ide->goPrevious();
		}
		 
	}
	
	public function delete_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false)
		 $ide->goPrevious();
		 else {
		$this->forum_model->deleteThread($id);
		$ide->goPrevious();
		 }
	}
	
	public function stick_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false)
		 $ide->goPrevious();
		 else {
		$this->forum_model->stickThread($id);
		$ide->goPrevious();
		 }
	}
	
	public function unstick_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false)
		 $ide->goPrevious();
		 else {
		$this->forum_model->unstickThread($id);
		$ide->goPrevious();
		 }
	}
	
	public function close_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false) 
		$ide->goPrevious();
		else {
		$this->forum_model->closeThread($id);
		$ide->goPrevious();
		}
	}
	
	public function open_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false)
		$ide->goPrevious();
		else {
		$this->forum_model->openThread($id);
		$ide->goPrevious();
		}
	}
	
	public function truncate_thread($id) {
		$ide = new IDE;
		$ide->requireLogin();
		$this->load->model("forum_model");
		$data['thread'] = $this->forum_model->getThreadInfo($id);
		$data['characters'] = $this->forum_model->getCharacters();
		$data['board'] = $this->forum_model->getBoardInfo($data['thread'][0]['board_id']);
		if(empty($data['board'])) $ide->goPrevious();
		$data['isModerator'] = $this->forum_model->isModerator($data['board'][0]['moderators'], $data['characters']);
		if($data['isModerator'] == false and $ide->isAdmin() == false) 
			$ide->goPrevious();
		else {
		$first = $this->forum_model->getFirstPost($id);
			$this->forum_model->truncateThread($id, $first[0]['id']);
			$ide->goPrevious();
		}
	}
}

?>

Chris · Dec 16, 2010

This is the part that needs the attention, although I cannot see any issues with it without any further investigation and I am unfortunately unable to do that at this point. I had a quick look in the view file as well and couldn't see what was causing it. If someone else wants to try to solve it, here's the code. Otherwise I'll return later, possibly tonight.

PHP:

if($_POST) { 
    $this->form_validation->set_rules('character', 'Character', 'required|callback__checkCharacter'); 
    $this->form_validation->set_rules('title', 'Title', 'required|min_lenght[3]|max_lenght[64]|callback__checkTimer'); 
    $this->form_validation->set_rules('post', 'Post', 'required|min_lenght[3]|max_lenght[3000]'); 
    $_POST['post'] = str_replace(array("&lt;", "&gt;"), array("<", ">"), $_POST['post']); 
    if($this->form_validation->run() == true) { 
        $_SESSION['lastPost'] = time(); 
        $this->forum_model->postThread($id, $_POST['character'], $_POST['title'], $_POST['post']); 
        $ide->redirect(WEBSITE."/index.php/forum/thread/".$board['0']['id']); 
    } 
}

TKO · Dec 16, 2010

Sure thing thanks chris try later then or some one else can help me out!
maybe it aint the php part but the sql part that i faild...

TKO · Dec 18, 2010

bump!

modern acc forum dosent work?

TKO

Syphero Owner!

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

Chris

Inactive

TKO

Syphero Owner!

TKO

Syphero Owner!

Similar threads