Gesior0.3.8 Latest News Error

[Nokturno]

maybe a table i missed to add at MYSQL?

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lordofwar.server_motd' doesn't exist' in C:\xampp\htdocs\latestnews.php:9 Stack trace: #0 C:\xampp\htdocs\latestnews.php(9): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 9

 

[Belthazor]

create server_motd table in your database

 

[Nokturno]

in wich table, i need to add it?

alter table `????` add `server_motd` INT NOT NULL;

 

[Korrex]

in wich table, i need to add it?

alter table `????` add `server_motd` INT NOT NULL;

INT?
it's supposed to be VARCHAR(32) lol.

Also, it's supposed to be it's own table, so run CREATE TABLE `server_motd` and some other lines.

 

[Cronox]

It's easy
goto yourip/phpmyadmin
now in SQL
paste this query

CREATE TABLE `server_motd`
(
	`id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`text` TEXT NOT NULL,
	UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');

 

[Nokturno]

Thks Cronoxs..

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k.unjustified' in 'where clause'' in C:\xampp\htdocs\latestnews.php:67 Stack trace: #0 C:\xampp\htdocs\latestnews.php(67): PDO->query('SELECT `g`.`id`...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 67


Lol, lot of Tables i need..

someone can with with this one?

 

[Nokturno]

bump.........

 

[ahmed30]

CREATE TABLE `killers`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`death_id` INT NOT NULL,
	`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
[COLOR="#FF0000"]	`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,[/COLOR]
	PRIMARY KEY (`id`),
	FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Natan Beckman]

ALTER TABLE `accounts` ADD vip_time INT(15) NOT NULL DEFAULT 0;