Odp: Jak zagra? na w?asnym serwie?
zawarto?? pliku database.sql z mojego acc makera:
CREATE TABLE `nicaw_accounts` (
`account_id` int(10) unsigned NOT NULL,
`rlname` varchar(50) NULL,
`location` varchar(50) NULL,
`comment` tinytext NULL,
`recovery_key` char(32) NULL,
UNIQUE KEY `account_id` (`account_id`)
) ENGINE = InnoDB;
CREATE TABLE `nicaw_account_logs` (
`id` int(10) unsigned NOT NULL auto_increment,
`account_id` int(11) NOT NULL,
`ip` int(11) NOT NULL,
`date` int(11) NOT NULL,
`action` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`),
KEY `account_id` (`account_id`)
) ENGINE = InnoDB;
CREATE TABLE `nicaw_news` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(64) NOT NULL,
`creator` varchar(25) NOT NULL,
`date` int(11) NOT NULL,
`text` text NOT NULL,
`html` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE = InnoDB;
CREATE TABLE `nicaw_polls` (
`id` int(10) unsigned NOT NULL auto_increment,
`question` varchar(255) NOT NULL,
`startdate` int(10) unsigned NOT NULL,
`enddate` int(10) unsigned NOT NULL,
`minlevel` int(10) unsigned NOT NULL,
`hidden` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE = InnoDB;
CREATE TABLE `nicaw_poll_options` (
`id` int(10) unsigned NOT NULL auto_increment,
`poll_id` int(10) unsigned NOT NULL,
`option` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE = InnoDB;
CREATE TABLE `nicaw_poll_votes` (
`option_id` int(10) unsigned NOT NULL,
`account_id` int(11) NOT NULL,
`ip` int(11) NOT NULL
) ENGINE = InnoDB;
CREATE TABLE `nicaw_guild_invites` (
`gid` int(10) unsigned NOT NULL COMMENT 'guild id',
`pid` int(10) unsigned NOT NULL COMMENT 'player id',
`rank` int(10) unsigned NOT NULL
) ENGINE = InnoDB;
ORAZ config inc z acc makera:
<?php
##################################################
# CONFIGURATION #
##################################################
# Congratulations on finding configuration file. #
# This is very simililar to config.lua as it #
# follows same basic principles. Text in between #
# /* */ or starting with # is ignored. Text #
# values must be 'qouted'. Logical values are #
# true/false. All statements end with ; #
##################################################
# Set data directory of your OT server
$cfg['dirdata'] = 'C:/OTServ/ftp/incoming/storm/data/';
$cfg['house_file'] = 'world/Tibia-house.xml';
# MySQL server settings
$cfg['SQL_Server'] = 'localhost';
$cfg['SQL_User'] = 'root';
$cfg['SQL_Password'] = '********';
$cfg['SQL_Database'] = 'testdb';
# Must correspond to your OTServ configuration
# Options: plain, md5, sha1
$cfg['password_type'] = 'plain';
# Not currently supported by OTServ, leave empty
$cfg['password_salt'] = '';
# Skin files can be found in skins folder.
# Each css file represents a skin
$cfg['skin'] = 'inferno';
# In case you want to upload skins somewhere else
$cfg['skin_url'] = 'skins/';
# Captcha is used to prevent automated software from flooding server with accounts
$cfg['use_captcha'] = true;
# Secure session will disable 'remember me' box
$cfg['secure_session'] = false;
# Seconds until session expires
$cfg['timeout_session'] = 15*60;
# Maximum number of characters on account
$cfg['maxchars'] = 10;
# Players per highscore page
$cfg['ranks_per_page'] = 50;
# This access and above will not be in highscores
$cfg['ranks_access'] = 2;
# Home page
$cfg['start_page'] = 'notes.php';
# Name shown in window title
$cfg['server_name'] = 'Nicaw SQL';
# Server ip and port for getting status.
# In most cases localhost should be used
$cfg['server_ip'] = 'localhost';
$cfg['server_port'] = 7171;
# Allow teleportation to temple?
$cfg['char_repair'] = false;
# Force users to validate their emails when registering?
# For email functions to work, SMTP server must be configured correctly
$cfg['Email_Validate'] = false;
# Allow email based account recovery?
$cfg['Email_Recovery'] = false;
# Enable extension=php_openssl.dll in php.ini in order to use gmail
$cfg['SMTP_Host'] = 'ssl://smtp.gmail.com';
$cfg['SMTP_Port'] = 465;
$cfg['SMTP_Auth'] = true;
$cfg['SMTP_User'] = 'user@gmail.com';
$cfg['SMTP_Password'] = 'user';
$cfg['SMTP_From'] = 'user@gmail.com';
# Example configuration for mercury
/*
$cfg['SMTP_Host'] = 'localhost';
$cfg['SMTP_Port'] = 25;
$cfg['SMTP_Auth'] = false;
$cfg['SMTP_User'] = 'user@gmail.com';
$cfg['SMTP_Password'] = 'user';
$cfg['SMTP_From'] = 'user@gmail.com';
*/
# Whether to show skills in character search
$cfg['show_skills'] = true;
# Whether to show deathlist in character search, DevLand only
$cfg['show_deathlist'] = false;
$cfg['skill_names'] = array('fist', 'club', 'sword', 'axe', 'distance', 'shielding', 'fishing');
# Name formating was moved to globals.php
# Banned names
$cfg['invalid_names'] = array('^gm','^god','admin','fuck','gamemaster', 'owner');
# Accounts that are allowed to access admin panel
# Example: array(123123,687687);
$cfg['admin_accounts'] = array();
# Listed IPs always allowed to access admin panel, no matter if it has account or not
$cfg['admin_ip'] = array('127.0.0.1');
# Player can only delete himself after specified time (seconds)
$cfg['player_delete_interval'] = 24*3600;
# Count player as member only if level above. Guilds with more members will be displayed first.
$cfg['guild_level'] = 20;
# Minimum level to create own guild. Cannot be lower than $cfg['guild_level']
$cfg['guild_leader_level'] = 20;
# Please disable guild manager if your server features guild editing
$cfg['guild_manager_enabled'] = true;
# Online status update interval (seconds). Should match statustimeout in your otserv configuration
$cfg['status_update_interval'] = 5*60;
##################################################
# Town Config #
##################################################
/*
NOTICE
Town IDs must be correct and match those in your map
*/
# Town names
$cfg['temple'][1]['name'] = 'Devland';
$cfg['temple'][2]['name'] = 'Forgotten';
$cfg['temple'][3]['name'] = 'Evolutions';
$cfg['temple'][4]['name'] = 'Thais';
$cfg['temple'][5]['name'] = 'Ab\'Dendriel';
$cfg['temple'][6]['name'] = 'Kazordoon';
$cfg['temple'][7]['name'] = 'Something else?';
$cfg['temple'][8]['name'] = 'Darashia';
$cfg['temple'][9]['name'] = 'Port Hope';
$cfg['temple'][10]['name'] = 'Liberty Bay';
# Now set which town(s) you want to use in character making
$cfg['temple'][1]['x'] = 410;
$cfg['temple'][1]['y'] = 573;
$cfg['temple'][1]['z'] = 7;
$cfg['temple'][1]['enabled'] = true;
$cfg['temple'][2]['x'] = 50;
$cfg['temple'][2]['y'] = 50;
$cfg['temple'][2]['z'] = 7;
$cfg['temple'][2]['enabled'] = false;
$cfg['temple'][3]['x'] = 1000;
$cfg['temple'][3]['y'] = 1000;
$cfg['temple'][3]['z'] = 7;
$cfg['temple'][3]['enabled'] = true;
##################################################
# Vocation Config #
##################################################
/*
Notice:
It's only one item per slot. You need to script special onLogin event in OTServ to add more items to new players.
*/
################# No Vocation ####################
$id = 0;
$cfg['vocations'][$id]['name'] = 'No Vocation';
$cfg['vocations'][$id]['level'] = 1;
$cfg['vocations'][$id]['maglevel'] = 0;
$cfg['vocations'][$id]['health'] = 150;
$cfg['vocations'][$id]['mana'] = 0;
$cfg['vocations'][$id]['cap'] = 400;
$cfg['vocations'][$id]['enabled'] = false;
$cfg['vocations'][$id]['look'][0] = 138;
$cfg['vocations'][$id]['look'][1] = 130;
$cfg['vocations'][$id]['skills'][0] = 1;
$cfg['vocations'][$id]['skills'][1] = 1;
$cfg['vocations'][$id]['skills'][2] = 1;
$cfg['vocations'][$id]['skills'][3] = 1;
$cfg['vocations'][$id]['skills'][4] = 1;
$cfg['vocations'][$id]['skills'][5] = 1;
$cfg['vocations'][$id]['skills'][6] = 1;
$cfg['vocations'][$id]['equipment'][3] = 3939;
$cfg['vocations'][$id]['equipment'][4] = 2650;
$cfg['vocations'][$id]['equipment'][5] = 2382;
$cfg['vocations'][$id]['equipment'][10] = 2050;
################# Sorcerer #######################
$id = 1;
$cfg['vocations'][$id]['name'] = 'Sorcerer';
$cfg['vocations'][$id]['level'] = 8;
$cfg['vocations'][$id]['maglevel'] = 0;
$cfg['vocations'][$id]['health'] = 185;
$cfg['vocations'][$id]['mana'] = 40;
$cfg['vocations'][$id]['cap'] = 470;
$cfg['vocations'][$id]['enabled'] = true;
$cfg['vocations'][$id]['look'][0] = 138;
$cfg['vocations'][$id]['look'][1] = 130;
$cfg['vocations'][$id]['skills'][0] = 10;
$cfg['vocations'][$id]['skills'][1] = 10;
$cfg['vocations'][$id]['skills'][2] = 10;
$cfg['vocations'][$id]['skills'][3] = 10;
$cfg['vocations'][$id]['skills'][4] = 10;
$cfg['vocations'][$id]['skills'][5] = 10;
$cfg['vocations'][$id]['skills'][6] = 10;
$cfg['vocations'][$id]['equipment'][1] = 2480;
$cfg['vocations'][$id]['equipment'][2] = 2172;
$cfg['vocations'][$id]['equipment'][3] = 2000;
$cfg['vocations'][$id]['equipment'][4] = 2464;
$cfg['vocations'][$id]['equipment'][6] = 2530;
$cfg['vocations'][$id]['equipment'][7] = 2468;
$cfg['vocations'][$id]['equipment'][8] = 2643;
################# Druid ##########################
$id = 2;
$cfg['vocations'][$id]['name'] = 'Druid';
$cfg['vocations'][$id]['level'] = 8;
$cfg['vocations'][$id]['maglevel'] = 0;
$cfg['vocations'][$id]['health'] = 185;
$cfg['vocations'][$id]['mana'] = 40;
$cfg['vocations'][$id]['cap'] = 470;
$cfg['vocations'][$id]['enabled'] = true;
$cfg['vocations'][$id]['look'][0] = 138;
$cfg['vocations'][$id]['look'][1] = 130;
$cfg['vocations'][$id]['skills'][0] = 10;
$cfg['vocations'][$id]['skills'][1] = 10;
$cfg['vocations'][$id]['skills'][2] = 10;
$cfg['vocations'][$id]['skills'][3] = 10;
$cfg['vocations'][$id]['skills'][4] = 10;
$cfg['vocations'][$id]['skills'][5] = 10;
$cfg['vocations'][$id]['skills'][6] = 10;
$cfg['vocations'][$id]['equipment'][1] = 2480;
$cfg['vocations'][$id]['equipment'][2] = 2172;
$cfg['vocations'][$id]['equipment'][3] = 2000;
$cfg['vocations'][$id]['equipment'][4] = 2464;
$cfg['vocations'][$id]['equipment'][6] = 2530;
$cfg['vocations'][$id]['equipment'][7] = 2468;
$cfg['vocations'][$id]['equipment'][8] = 2643;
################# Palladin #######################
$id = 3;
$cfg['vocations'][$id]['name'] = 'Paladin';
$cfg['vocations'][$id]['level'] = 8;
$cfg['vocations'][$id]['maglevel'] = 0;
$cfg['vocations'][$id]['health'] = 185;
$cfg['vocations'][$id]['mana'] = 40;
$cfg['vocations'][$id]['cap'] = 470;
$cfg['vocations'][$id]['enabled'] = true;
$cfg['vocations'][$id]['look'][0] = 137;
$cfg['vocations'][$id]['look'][1] = 129;
$cfg['vocations'][$id]['skills'][0] = 10;
$cfg['vocations'][$id]['skills'][1] = 10;
$cfg['vocations'][$id]['skills'][2] = 10;
$cfg['vocations'][$id]['skills'][3] = 10;
$cfg['vocations'][$id]['skills'][4] = 10;
$cfg['vocations'][$id]['skills'][5] = 10;
$cfg['vocations'][$id]['skills'][6] = 10;
$cfg['vocations'][$id]['equipment'][1] = 2480;
$cfg['vocations'][$id]['equipment'][2] = 2172;
$cfg['vocations'][$id]['equipment'][3] = 2000;
$cfg['vocations'][$id]['equipment'][4] = 2464;
$cfg['vocations'][$id]['equipment'][6] = 2530;
$cfg['vocations'][$id]['equipment'][7] = 2468;
$cfg['vocations'][$id]['equipment'][8] = 2643;
################# Knight #########################
$id = 4;
$cfg['vocations'][$id]['name'] = 'Knight';
$cfg['vocations'][$id]['level'] = 8;
$cfg['vocations'][$id]['maglevel'] = 0;
$cfg['vocations'][$id]['health'] = 185;
$cfg['vocations'][$id]['mana'] = 40;
$cfg['vocations'][$id]['cap'] = 470;
$cfg['vocations'][$id]['enabled'] = true;
$cfg['vocations'][$id]['look'][0] = 139;
$cfg['vocations'][$id]['look'][1] = 131;
$cfg['vocations'][$id]['skills'][0] = 10;
$cfg['vocations'][$id]['skills'][1] = 10;
$cfg['vocations'][$id]['skills'][2] = 10;
$cfg['vocations'][$id]['skills'][3] = 10;
$cfg['vocations'][$id]['skills'][4] = 10;
$cfg['vocations'][$id]['skills'][5] = 10;
$cfg['vocations'][$id]['skills'][6] = 10;
$cfg['vocations'][$id]['equipment'][1] = 2480;
$cfg['vocations'][$id]['equipment'][2] = 2172;
$cfg['vocations'][$id]['equipment'][3] = 2000;
$cfg['vocations'][$id]['equipment'][4] = 2464;
$cfg['vocations'][$id]['equipment'][6] = 2530;
$cfg['vocations'][$id]['equipment'][7] = 2468;
$cfg['vocations'][$id]['equipment'][8] = 2643;
################# Other IDs ######################
$cfg['vocations'][5]['name'] = 'Master Sorcerer';
$cfg['vocations'][6]['name'] = 'Elder Druid';
$cfg['vocations'][7]['name'] = 'Royal Paladin';
$cfg['vocations'][8]['name'] = 'Elite Knight';
i na koniec config.lua z folderu z silnikiem bo nie wiem o jaki config ci chodzi?o
Sorry ?e tak d?ugo nie odpowiada?em ale by?em zaj?ty.
-- NaxedOt Server Config
-- Account Manager
accountManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 50
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = "no"
-- Banishments
broadcastBanishments = "yes"
banDays = 1
finalBanDays = 5
killsToBan = 6
-- Battle
worldType = "pvp"
hotkeyAimbotEnabled = "yes"
protectionLevel = 50
killsToRedSkull = 3
pzLocked = 30000
deathLosePercent = 8
criticalHitChance = 7
removeAmmoWhenUsingDistanceWeapon = "yes"
removeChargesFromRunes = "yes"
timeToDecreaseFrags = 1 * 60 * 60 * 1000
whiteSkullTime = 10 * 60 * 1000
oldConditionAccuracy = "no"
alternativeExhaust = 1000
stairJumpExhaustion = 1000
animationTextOnHeal = "yes"
-- Commands
displayGamemastersWithOnlineCommand = "no"
-- Connection Config
ip = "93.154.164.156"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171
loginTries = 100
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = "100"
motd = "NaxedOt 3.0"
onePlayerOnlinePerAccount = "yes"
allowClones = 0
serverName = "Naxed"
loginMessage = "welcome to tibia ots"
adminLogsEnabled = "no"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"
-- Deathlist
deathListEnabled = "yes"
maxDeathRecords = 5
-- Guilds
ingameGuildSystem = "yes"
-- Highscores
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60
-- Houses
housePriceEachSQM = 1000
houseRentPeriod = "never"
-- Idle
kickIdlePlayerAfterMinutes = 15
-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000
-- Map
mapName = "NaxedMap"
mapAuthor = "Xiti & Komic"
randomizeTiles = "yes"
mapStorageType = "relational"
-- Messaging
enableRuleViolationReports = "yes"
maxMessageBuffer = 4
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "******"
mysqlDatabase = "mysmenia"
mysqlPort = 3306
-- Premium Account
freePremium = "yes"
-- PVP Server
displayOnOrOffAtCharlist = "no"
allowChangeOutfit = "yes"
noDamageToSameLookfeet = "no"
experienceByKillingPlayers = "no"
-- Rates
rateExp = 100
rateSkill = 200
rateLoot = 2
rateMagic = 50
rateSpawn = 1
-- Real Server Save
-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
-- if you want such a system use autoSaveEachMinutes. this serversave method
-- may be unstable, we recommend using otadmin if you want real serversaves.
serverSaveEnabled = "no"
serverSaveHour = 3
shutdownAtServerSave = "yes"
cleanMapAtServerSave = "yes"
-- Server saving
autoSaveEachMinutes = 15
saveGlobalStorage = "no"
-- Spawns
deSpawnRange = 2
deSpawnRadius = 50
-- SqLite
sqliteDatabase = "NaxedOt.s3db"
-- SQL
sqlType = "mysql"
passwordType = "plain"
-- Startup
defaultPriority = "realtime"
-- Shutdown
freeMemoryAtShutdown = "yes"
-- Status
ownerName = "Xiti"
ownerEmail = "@hotmail.com"
url = "http://dynamic.eshost.com.ar/"
location = "Europe"