how to start the server without a SQL login

[Gubailovo]

---------------------------- Configuration ------------------------------

-- datadir
datadir = "data/"

-- map
-- sets what map to load, if sql, determines the sql map
map = "data/world/map.otbm"
mapstore = "data/world/map-mapstore.xml"
housestore = "data/world/map-housestore.xml"
houserentperiod = "monthly"

-- sets what map to load
-- map =

-- OTBM for binary, SQL for SQL map, XML for OTX maps
mapkind = "OTBM"

-- SQL for acc/player info from SQL, XML for acc/player info from XML
sourcedata = "SQL"

-- bans
banIdentifier = "data/bans.xml"

-- the message the player gets when he logs in
loginmsg = "Welcome to Darkonia RPG."

-- Tips
Mess_1 = "Любую информацию по игре можно найти в нашей библиотеке: http://www.chronicles.darkoniarpg.ru/"
Mess_2 = "Последнее обновление от 27 ноября 2006 года, о нем можно прочитать в новостях : http://darkoniarpg.ru/home.php?page=news"
Mess_3 = "Последний багфикс от 13.11.2006 о нем можно прочитать в новостях : http://darkoniarpg.ru/phpbb/viewtopic.php?t=1095"

-- the port otserv listens on
port = "7171"

-- name of our server
servername = "Darkonia RPG"

-- name of the owner of our server
ownername = "Torian Kel"

-- email of the owner of our server
owneremail = "[email protected]"

-- the url for more server info
url = "http://darkoniarpg.ru/"

-- the location of the server
location = "Russia"

-- the ip the server should redirect too
ip = "10.0.0.10"

-- The messagebox you sometimes get before you choose characters
motd = "Welcome to the Darkonia RPG!"
motdnum="0"

-- use md5 passwords for accounts, yes/no
md5passwords = "no"

-- world type. options: pvp, no-pvp, pvp-enforced
worldtype = "pvp"

-- max number of players allowed
maxplayers = "500"

-- exhausted time in ms (1000 = 1sec)
exhausted = 1000

-- exhaustion time for healing spells (1000 = 1sec)
exhaustedheal = 1000

-- how many ms to add if the player is already exhausted and tries to cast a spell (1000 = 1sec)
exhaustedadd = 500

-- how long does the player has to stay out of fight to get pz unlocked in ms (1000 = 1sec)
pzlocked = 30*1000

-- allow multiple logins of the same char
allowclones = 0

-- vocation names
vocations = {"маг", "друид", "рейнджер", "рыцарь", "лич", "мастер заклинаний", "оборотень", "жрец", "жулик", "меткий стрелок", "вампир", "паладин"}
promoted_vocations = {"мастер магии", "старший друид", "королевский рейнджер", "элитный рыцарь", "повелитель мертвых", "мастер рун", "меняющийся", "верховный жрец", "вор", "снайпер", "носферату", "чемпион"}

--- SQL part
sql_host = "10.0.0.10"
sql_user = "root"
sql_pass = ""
sql_db   = ""


--- SQL MAP part
sqlmap = "test_map"
map_host = "localhost"
map_user = "root"
map_pass = ""
map_db   = ""

---------------------------- Save configuration ------------------------------
-- how often do server saves it's state complete (0 = off, 5 = 5min, 60 = hour)
serversave = 60

-------------------------Darkonia RPG configuration-----------------------
--referal system
refpercent = 10
referercoins = 10000

--
lootkoeff = 1

----
buy_sc = 2000000
sell_sc = 3000000

-- resetlvl
-- Reset the player when he gots this lvl(Max lvl is 634)
resetlvl = "630"

-- name of your world (seen on the character list when logging in)
worldname = "Darkonia RPG"

-- do you want to enable cap system (yes/no)
capsystem = "yes"

-- do you want players to learn spells before they can use them (yes/no)
learnspells = "yes"

-- how many summons player can have
maxsummons = 2

-- maximum number of items on a house tile (including those in containers)
maxhousetileitems = 50

-- do you want to give summons for all vocations (yes/no)
summonsallvoc = "no"

-- chance of losing a spear when shot (0 - none lost, 100000 - all lost)
spearlosechance = 5000

-- anti-afk - maximum idle time to kick player (1 = 1min)
kicktime = 10

--Mc = 0 You cant use Mc. Mc = 1 You can use MC.
mc = "1"

--Уровень для чата
chatlevel = 8

--Разделение экспы
p_distance = 30
p_height = 1
p_formula = 1

-- максимум имен в деадлисте

maxdeathentries = 50

---------------------- Soul System configuration ----------------------
-- how many soul pointss you gain when kill a monster
soulup = "2"

-------------------------House configuration---------------------------
-- house price for 1 sqm
priceforsqm = 6000

-- max houses for player
maxhouses = 2

-- Do you want to enable !buyhouse(yes/no)
buyhouseable = "no"
-------------------------Deaths configuration---------------------------
-- how much % of exp/skills/stuff do you lose when dying if you dont have blessings and you dont have promotion
diepercent = 10
diebless0 = 10

-- how much % of exp/skills/stuff do you lose when dying if you dont have blessings and you have promotion
diebless0promo = 7

-- how much % of exp/skills/stuff do you lose when dying if you have 1 blessing and you dont have promotion
diebless1 = 9

-- how much % of exp/skills/stuff do you lose when dying if you have 2 blessings and you dont have promotion
diebless2 = 8

-- how much % of exp/skills/stuff do you lose when dying if you have 3 blessings and you dont have promotion
diebless3 = 7

-- how much % of exp/skills/stuff do you lose when dying if you have 4 blessings and you dont have promotion
diebless4 = 6

-- how much % of exp/skills/stuff do you lose when dying if you have 5 blessings and you dont have promotion
diebless5 = 5

-- how much % of exp/skills/stuff do you lose when dying if you have 1 blessing and you have promotion
diebless1promo = 6

-- how much % of exp/skills/stuff do you lose when dying if you have 2 blessings and you have promotion
diebless2promo = 5

-- how much % of exp/skills/stuff do you lose when dying if you have 3 blessings and you have promotion
diebless3promo = 4

-- how much % of exp/skills/stuff do you lose when dying if you have 4 blessings and you have promotion
diebless4promo = 3

-- how much % of exp/skills/stuff do you lose when dying if you have 5 blessings and you have promotion
diebless5promo = 2

--------------------------- Multipliers and gains ------------------------------

-- mana consumend by {snakebite, moonlight, volcanic, quagmire, tempest} rod
rodmana = {"2", "2", "3", "4", "5"}

-- mana consumed by wand of {vortex, dragonbreath, plague, cosmic energy, inferno}
wandmana = {"2", "2", "3", "4", "5"}

-- shooting range of {snakebite, moonlight, volcanic, quagmire, tempest} rod
rodrange = {"4", "3", "3", "3", "3"}

-- shooting range of  wand of {vortex, dragonbreath, plague, cosmic energy, inferno}
wandrange = {"4", "3", "3", "3", "3"}

-- experience multiplier (how much faster you got exp from monsters)
expmul = 1

-- experience multiplier for pvp-enforced (how much faster you got exp from players)
expmulpvp = 2

-- skill multipliers: 1 - rl tibia, 10 - ten times faster etc. {no-voc, sorcerer, druid, paladin, knight}
weaponmul = {"1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1"}
distmul = {"1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1"}
shieldmul = {"1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1"}
manamul = {"1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1"}

-- how much points of life,mana,cap do you get when advancing {no-voc, sorcerer, druid, paladin, knight}
capgain = {"10", "10", "10", "20", "25", "15", "15", "15", "15", "25", "25", "30", "30"}
managain = {"5", "30", "30", "15", "5", "40", "40", "40", "40", "20", "20", "10", "10"}
hpgain = {"5", "5", "5", "10", "15", "10", "10", "10", "10", "15", "15", "25", "25"}

-- how much faster do you recovery life,mana after eating food (1 - rl tibia)
healthtickmul = 2
manatickmul = 2

-- damage of burst arrows blast
-- default is from (1*lvl+5*mlvl)*0.24 to (1*lvl+5*mlvl)*0.55
burstarrowdmg = {"1.0", "5.0", "0.24", "0.55"}

-- How long work the utana vid in seconds
utanavidtime = 3*60+20

--How many people can have in the vip list
maxviplist = "50"

--Distance away from spawn to remove a monster - The Chaos
dist = "40"

-- How many poison hits from the poison arrow
poisonarrowhits = 5

-- Max poison hit damage from the poison arrow
poisonarrowdamage = 10

-- Minimun level for player can yell
minlvltoyell = 3

-- Muted System by Rex
mutedsystem = "yes"
mutedtime = "20"

-- How many % increase magic damage when u have blue robe?
bluerobe = 15

--How many Hp/Mana you recover while Sleeping per second (60 seconds = [life +1 and mana +1])
bedregain = 10

-- how much % of {exp, mana, skill, eq, bp} do you lose when dying
diepercent = {"7", "7", "7", "7", "100"}

-- speed of attack in seconds (no-voc, sorc, druid, pally, knight)
speed = {"2.0", "1.5", "1.5", "1.1", "0.9", "1.7", "1.7", "1.7", "1.7", "0.7", "0.7", "0.5", "0.7"}

RoHHealth = 5
RoHMana = 5
LifeRingHealth = 5
LifeRingMana = 5


-------------------------------- Skull system ----------------------------------
-- how many unjustified kills to get a red skull
redunjust = 3

-- how many unjustified kills to get banned
banunjust = 6

-- how long do you have white skull after attacking player (1 = 1min)
hittime = 1

-- how long do you have white skull after killing player (1 = 1min)
whitetime = 15

-- how long do you have red skull (1 = 1min)
redtime = 6*60

-- how long do you have to wait to lose 1 unjustified kill (1 = 1min)
fragtime = 12*60
------------------------------ GM System--------------------------------
-- access to ignore damage, exhaustion, cap limit and be ignored by monsters
accessprotect = 2

-- access to walk into houses and open house doors
accesshouse = 3

-- access to broadcast messages and talk in colors (#c blabla - in public channels)
accesstalk = 2

-- access to move distant items from/to distant locations
accessremote = 3

-- access to see id and position of the item you are looking at
accesslook = 2

-- access for report bugs with Ctrl+Z
accessbugreport = 1

-- access for talk orange in Help Channel
accessorange = 1

-- access for use ban window(aka ctrl+y)
accessctrly = 2

-- access for answer reports with Ctrl+R
accessreport = 2

-- only gamemaster can use mc system of tibia?
antigmmc = "yes"

-- Gamemaster cant attack players on melee or using runes? Yes/no
gmprotected = "yes"
---------------------------- Premium configuration ------------------------------
-- do you want premium players to wait in queue as others? (yes/no)
queuepremmy = "no"



-- How many premmy days the player get when say !buypremmy
manypremmydays = 1

-- How many the player pay when say !buypremmy
prricepremmy = 1000000000



-- How many days the player lost when say /sex (for change sex)
sexpremmydays = 5

-- Max Depot items for premmiums accounts
maxdepotpremmy = 2000

-- Max Depot items for free accounts
maxdepotfree = 1000

 

[Tarek]

-- the ip the server should redirect too ip = "10.0.0.10"

Change this to 127.0.0.1

 

[Gubailovo]

need to run simply with a computer without SQL

how to make so I just changed the IP on its own and launched the server

and is it possible? to start using SQL if I am sitting with a SIM card and my IP is changing?
if so then FAQ on server startup
for earlier thanks
xml version="1.0

 

[Infernum]

you cant start up a server without sql
sql holds all the data for your accounts, data, items, etc
even if you did manage to start it up without sql you couldnt even do anything

 

[Gubailovo]

there is a FAQ for working with SQL?

 

[Infernum]

there is a FAQ for working with SQL?

not really
all you do though is download uniserver zero, start apache&mysql, click phpmyadmin and import the mysql.sql schema from the sources you have
then you edit the accounts and create an administrator account for mysql and use that in your config.lua as your login
make sure the sql database as the same as your database name
here's an example of mine (dont use root as your user)

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = "86850"
mysqlDatabase = "1.2"
mysqlPort = 3306
mysqlSock = ""

 

[Gubailovo]

and the tutorial videos there?

what do I need to put in sql?

can somebody deal with it and run?
https://yadi.sk/d/_AYM_GY8349aSY

 

[danick10]

actualy there is someway to start a server without using sql, you can use the database SQLite if you server includes it and if your ip is changing, you can set up your sqldata base on a computer or a dedicated server with a fix ip, and then forward your port 3306, then access to it with a user name and a password and the ip address of that machine =P

 

[danick10]

if the file .sdb3 is not in your server folder, look for the schemas SQLite and you can build your own database using SQLite studio +P

 

[andu]

-- SQL for acc/player info from SQL, XML for acc/player info from XML sourcedata = "SQL"

It looks like a server from 2003-2006. Just download TFS with SQLite, like 0.3 or 0.4. All you will need is to hit enter. Zero SQL server configorations etc and you can edit your accounts/players trough easy addon for chrome.

 

[danick10]

or if you want to, you can modify the source to load xml files =0 Just like the good old yurots! not the best option, but still an option! ;D

 

[danick10]

And by the way, if you use your localhost to access your sql database, it doesn't matter if your ip is changing.... it will always access it with 127.0.0.1, I think you could setup easily MySQL too

 

[Gubailovo]

 

[vTune]

From the looks of your config it looks like it support XML accounts?

-- SQL for acc/player info from SQL, XML for acc/player info from XML
sourcedata = "SQL"

So try use XML instead?