[Dev Rev] list_config, ban_list mysql tables (and others)

Welcome in the osRose emulator Project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

[Dev Rev] list_config, ban_list mysql tables (and others)

Postby lmame on Sun Jul 25, 2010 8:52 am

Here are the fields you can set in "list_config" mysql table.
Some of them are perhaps not in Dev Rev 360 since I listed all who are in the next rev but explanations remain the same,


Server main options:
osRoseVer: osRose version... like 81.361
autosave: saving automatically player's data (0=no, 1=yes (default) ),
savetime: if autosave is enabled, the save process will take place each "x" seconds,

Server rates:
exp_rate: experience multiplier,
drop_rate: drop rate in %,
zuly_rate: Zuly multiplier, when you have a Zuly drop its value is multiplied by this number,


Drop options:
pc_drop_zuly: % of chance to have a Zuly drop rather than an item drop,
blue_chance: % of chance to have a blue gear when an item drops,
slot_chance: % of chance to a slot when an item drops,
stat_chance: % of chance to have stat when an item drops,
refine_chance: % of chance to have a refine when an item drops,


Player options:
maxlevel: max level a player can have,
partygap: max difference between two players when they party,
maxstat: max stat a player can have (like STR and so on),
cfmode: 1=cf mode from Junon is opened, 0=closed (NPC Burtland),

Damage control:
player_damage: % attack bonus when a player attacks a monster,
monster_damage: % attack bonus when a monster attacks a player,


Fairy options:
fairymode: 1= fairy mode enabled, 0=disabled,
fairystay: fairy stay time (in minutes)
fairywait: fairy wait time before she's assigned to a new player (in minutes),
fairytestmode: 0=disabled (default), 1=enabled, if disabled, fairywait won't be used,


Union War options:
uwnbplayers: Nb. of players each side should have (minimum) so the Union War can be triggered, see this thread,


You should NOT touch those unless you know what you're doing:
conf: .conf filename for worldserver ("default" by default),
mapdelay: don't touch it.
visualdelay: don't touch it.
worlddelay: don't touch it.
kill_on_fail: not used anymore.
monmax: Nb. of monsters a GM can summon with /mon GM command,
drop_rev: AND drop system (1=enabled, 0=disabled, 1 is default value),
testgrid: enables grid system, much faste than the old one (1=enabled, 0=disabled, 1 is default value),
jrose: not used anymore, let it to 0.
is_pegasus: for internal tests, let it to 0.
rare_refine: not used,
drop_type: not used,
skill_damage: not used,
player_acc: not used,
monster_acc: not used,
pvp_acc: not used,
uwside: who was the last side who won Uwnion War (don't change it),
massexport: special function that exports all AIP and QSD functions to /binary/log/export.log, see this thread (0=disabled (default), 1=enabled),
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [Dev Rev 360] Guide on "list_config" mysql table.

Postby lmame on Sun Jul 25, 2010 9:10 am

ban_list mysql table:
It contains the IPs (or IP ranges) you banned:

ip: banned ip (can be range too, for example if you add "192.168.0" , all the ips starting with "192.168.0" won't connect),
startban: banned time (same as "time" function from C++ or PHP), can be 0 if you want a perma ban (see ban time then),
bantime: ban time (in seconds, 0 if is permanent ban),
bannedby: name of the GM or admin who did the ban,
reason: reason for the ban,
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: [Dev Rev] list_config, ban_list mysql tables (and others

Postby lmame on Sun Jul 25, 2010 9:22 am

Some questions on the mysql tables, I don't list "obvious" tables like "items" and so on...


Which table handles?:
Accounts: accounts... obviously, you have inside the accesslevel of the player (100=normal user, 300=GM),
Avatars: characters (this one has also the "isgm" field, needs to be set to 1 for your GMs to access some Gm commands),
Telegates: list_telegates,
Respawn areas: list_respawnzones,
The drops: item_drops_and,


The special ones:
list_cart_cg: this one contains the CG or cart sets used with /cg or /cart GM command,
list_events: basic events you can trigger using /eventname gm command,


The ones you should NEVER touch:
channels: channel list (done by the server),
mail_list: done by the server, when a player sends you a message and you're offline you'll receive a mail,
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City


Return to Support - OsRose Emulator

Who is online

Users browsing this forum: No registered users and 8 guests

cron