Znote AAC 1.4 - [TFS 0.2.13+] & [TFS 0.3.6+/0.4]

Players online: string(59) "SELECT COUNT(`player_id`) AS `value` FROM `players_online`;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'otserv.players_online' doesn't exist

tring(137) "INSERT INTO `znote_deleted_characters`(`original_account_id`, `character_name`, `time`, `done`) VALUES(4, "Test", (NOW() + INTERVAL ), 0)"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

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 '), 0)' at line 1

string(113) "SELECT `id`, `guild_id`, `enemy_id`, `status`, `begin`, `end` FROM `guild_wars` ORDER BY `begin` DESC LIMIT 0, 30"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'panamera.guild_wars' doesn't exist

SQL-Befehl:


CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
MySQL meldet: Dokumentation

#1005 - Can't create table 'panamera.znote_guild_wars' (errno: 150) (Details…)

$config['delete_character_interval'] = '3 DAY'; // Delay after user character delete request is executed eg. 1 DAY, 2 HOUR, 3 MONTH etc.

mysql_insert('INSERT INTO `znote_deleted_characters`(`original_account_id`, `character_name`, `time`, `done`) VALUES(' . $original_acc_id . ', "' . $char_name . '", (NOW() + INTERVAL ' . Config('delete_character_interval') . '), 0)');

mysql_insert('INSERT INTO `znote_deleted_characters`(`original_account_id`, `character_name`, `time`, `done`) VALUES(' . $original_acc_id . ', "' . $char_name . '", (NOW() + INTERVAL ' . config('delete_character_interval') . '), 0)');