https://github.com/PrinterLUA/FORGOTTENSERVER-ORTS/archive/master.zipcan u post the full server in 1 download? thanks
i have problem in load events... Crash server... events Crashing my serwer . Server not open.
(Linux)
Warning: mysql_connect(): Access denied for user 'new'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 197
Failed to connect to database.
Install:
Make sure you have imported TFS database. (OTdir/forgottenserver.sql OR OTdir/schemas/mysql.sql)
Import the below schema to a TFS database in phpmyadmin:
CREATE TABLE IF NOT EXISTS `znote` ( `id` int(10) NOT NULL AUTO_INCREMENT, `version` varchar(30) NOT NULL COMMENT 'Znote AAC version', `installed` int(10) NOT NULL, `cached` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote` (`version`, `installed`) VALUES ('1.5_SVN', '1389906189'); CREATE TABLE IF NOT EXISTS `znote_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `ip` int(10) NOT NULL, `created` int(10) NOT NULL, `points` int(10) DEFAULT 0, `cooldown` int(10) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES ('1', '0', '1389906189'); CREATE TABLE IF NOT EXISTS `znote_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `text` text NOT NULL, `date` int(11) NOT NULL, `pid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `desc` text NOT NULL, `date` int(11) NOT NULL, `status` int(11) NOT NULL, `image` varchar(30) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paypal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `txn_id` varchar(30) NOT NULL, `email` varchar(255) NOT NULL, `accid` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paygol` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, `message_id` varchar(255) NOT NULL, `service_id` varchar(255) NOT NULL, `shortcode` varchar(255) NOT NULL, `keyword` varchar(255) NOT NULL, `message` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `operator` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `currency` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL, `created` int(11) NOT NULL, `hide_char` tinyint(4) NOT NULL, `comment` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES ('1', '1389906189', '0', '. . .'); CREATE TABLE IF NOT EXISTS `znote_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL, `itemid` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT '1', `describtion` varchar(255) NOT NULL, `points` int(11) NOT NULL DEFAULT '10', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `points` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `value` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `time` int(11) NOT NULL, `type` tinyint(4) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `access` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `guild_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Staff Board', '4', '0', '0', '0'), ('Tutors Board', '2', '0', '0', '0'), ('Discussion', '1', '0', '0', '0'), ('Feedback', '1', '0', '1', '0'); CREATE TABLE IF NOT EXISTS `znote_forum_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `title` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, `sticky` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Edit config.php with correct mysql connection details.
Change the user in config.lua to w/e user you have.I'm having trouble logging in to the server. I portforwarded 7171 and everything, I tried all kinds of IPs, it just won't load the char list. Wtf am I doing wrong? I also can't figure out how to setup the AAC so I tried to add an account + player manually after importing the database. This is so confusing, other OTs I've had I'm able to set them up within 5 minutes. Could someone make a full video tutorial on how to setup everything properly because I don't get it. On my AAC page I gett this message:
Code:Warning: mysql_connect(): Access denied for user 'new'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 197 Failed to connect to database. Install: Make sure you have imported TFS database. (OTdir/forgottenserver.sql OR OTdir/schemas/mysql.sql) Import the below schema to a TFS database in phpmyadmin: CREATE TABLE IF NOT EXISTS `znote` ( `id` int(10) NOT NULL AUTO_INCREMENT, `version` varchar(30) NOT NULL COMMENT 'Znote AAC version', `installed` int(10) NOT NULL, `cached` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote` (`version`, `installed`) VALUES ('1.5_SVN', '1389906189'); CREATE TABLE IF NOT EXISTS `znote_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `ip` int(10) NOT NULL, `created` int(10) NOT NULL, `points` int(10) DEFAULT 0, `cooldown` int(10) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES ('1', '0', '1389906189'); CREATE TABLE IF NOT EXISTS `znote_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `text` text NOT NULL, `date` int(11) NOT NULL, `pid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `desc` text NOT NULL, `date` int(11) NOT NULL, `status` int(11) NOT NULL, `image` varchar(30) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paypal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `txn_id` varchar(30) NOT NULL, `email` varchar(255) NOT NULL, `accid` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_paygol` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `price` int(11) NOT NULL, `points` int(11) NOT NULL, `message_id` varchar(255) NOT NULL, `service_id` varchar(255) NOT NULL, `shortcode` varchar(255) NOT NULL, `keyword` varchar(255) NOT NULL, `message` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `operator` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `currency` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL, `created` int(11) NOT NULL, `hide_char` tinyint(4) NOT NULL, `comment` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES ('1', '1389906189', '0', '. . .'); CREATE TABLE IF NOT EXISTS `znote_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL, `itemid` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT '1', `describtion` varchar(255) NOT NULL, `points` int(11) NOT NULL DEFAULT '10', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `points` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_shop_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, `type` int(11) NOT NULL, `itemid` int(11) NOT NULL, `count` int(11) NOT NULL, `time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `value` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_visitors_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` int(11) NOT NULL, `time` int(11) NOT NULL, `type` tinyint(4) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `access` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `guild_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Staff Board', '4', '0', '0', '0'), ('Tutors Board', '2', '0', '0', '0'), ('Discussion', '1', '0', '0', '0'), ('Feedback', '1', '0', '1', '0'); CREATE TABLE IF NOT EXISTS `znote_forum_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `title` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, `sticky` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; Edit config.php with correct mysql connection details.
local premiumDaysCost = 3
function onSay(cid, words, param)
local player = Player(cid)
if player:getGroup():getAccess() then
player:setSex(player:getSex() == PLAYERSEX_FEMALE and PLAYERSEX_MALE or PLAYERSEX_FEMALE)
player:sendTextMessage(MESSAGE_INFO_DESCR, "You have changed your sex.")
return false
end
if player:getPremiumDays() >= premiumDaysCost then
player:removePremiumDays(premiumDaysCost)
player:setSex(player:getSex() == PLAYERSEX_FEMALE and PLAYERSEX_MALE or PLAYERSEX_FEMALE)
player:sendTextMessage(MESSAGE_INFO_DESCR, "You have changed your sex for ".. premiumDaysCost .." days of your premium account.")
else
player:sendCancelMessage("You do not have enough premium days, changing sex costs ".. premiumDaysCost .." days of your premium account.")
player:getPosition():sendMagicEffect(CONST_ME_POFF)
end
return false
end