[8.21/8.22]Biosoft 0.6.6.0

gm neo colombia · Aug 3, 2008

Features:

* Guid for xml players. (players.xml)
* Full rearranged protocol and game system
* Actions (when using a tile or item)
* SQL databases (for accounts and players)
* Crash tracking
* Monsters
* 7.8 Protocol
* OTB (You now dont have to convert your map, change any ID, 7.5
* ID's are just stacked on top of older ID's same with 7.8 ids!)
* VIP List
* Guild support
* Spawns (and Respawn)
* Commands
* Autowalk
* Rotatable items
* Logger
* Enhanced items database
* Runes with charges
* Depots
* Waitlist
* Houses
* Follow and chase opponent
* A whole new condition engine to handle all kind of conditions.
* A whole new battle engine. The new engine is closer to CIP's formulas.
* The script interface has been rewriten and improved ALOT. You can now script all kind of things. Weapons, movement, talkactions, spells. You name it.
* Monsters have been recoded to use the new condition and battle
* engine. And they now act more like the tibia monsters.
* Vocations are now configable with vocations.xml
* And alot more. Try it yourself and find out.

Version 0.6.1

* Raid System (Jiddo)
* Anti-AFK Fixed (Xidaozu)
* Ring and Amulet System 100% (Yurez, Xidaozu)
* Ring of Healing and Life Ring (Ravalas, Xidaozu)
* Command /shutdown (Yurez)
* Ice Rapier (Xidaozu)
* Exhausted Heal (Yurez)
* Item look for creatures (Xidaozu, BlackDemon)
* New summon system (Tibia Rules, Yurez, Xidaozu)
* Summons share experience (Tibia Rules)
* New Magic Rope System (Xidaozu)
* Party System (Remere)
* Party Share Experience (Remere)
* Experience share fix (Xidaozu)
* Command Logs fix against SQL Injection (Xidaozu)
* Infinite Ammunation in config.lua (Xidaozu)
* Boots of Haste (Yurez)
* New Find Person (Junkfood)
* Command !frags (Xidaozu)
* Command /promote fixed (Xidaozu)
* Monsters move diagonal (LarvaExotech)
* Wands, Rods and Burst Arrows don't cause exhaust (Xidaozu)
* Housedoor crash fixed (Nicaw)
* Premium Outfits (Xidaozu)

Version 0.6.2

* Attack Square (Xidaozu, nfries88)
* Protection System (Xidaozu, nfries88)
* Field damage (nfries88)
* Monster blood colors and damage colors (CVS, Xidaozu)
* Level requirement to buy a house (Xidaozu)
* Summons follow you everywhere (BlackDemon)
* Paralyze Creature (BlackDemon, Xidaozu)
* Learn Spell system (Yurez, Xidaozu)
* Skull System with summons fixed (Xidaozu)
* Premium Days saved in account file (Sapphire, Xidaozu)
* Diagonal Movement for all creatures (CVS)
* Burst Arrow fix (Xidaozu)
* Client Aimbot (configurable in config.lua)(BlackDemon)

Version 0.6.3

* GM Invisible (The Chaos, Xidaozu)
* Clean Command (Yurez, Xidaozu)
* Items to water/lava/swamp/tar (Xidaozu)
* NPC Buy Container (BlackKnight, Nfries88)
* Skull System fix (Xidaozu)
* Fight Modes (Xidaozu)
* Safe Mode (Xidaozu)
* Config: Shoot trough battle window on players (Xidaozu)
* Some codes removed due crashing (Paralyze, Protection System and
* Chat Level)
* Ain't that much in this version (I couldn't think of something else Sad )

Versión 0.7.3**

* Protocol 7.92 (CVS, Xidaozu)
* Graphical User Interface (GUI)(Junkfood, Xidaozu)
* Prevent Loss System (Xidaozu)
* New Premium System (Xidaozu)
* Players.xml not needed (Xidaozu)
* Premium Spells (Xidaozu)

Version 0.7.4(BETA)

* Ingame Acc-Manager (Only XML)(Xidaozu)
* Bug Report/Ctrl + Z (Xidaozu)
* Ban Player/Ctrl + Y (Xidaozu)
* Ban system improved (Xidaozu)
* Fixed the house system (Xidaozu)
* Premium spells fixed (Xidaozu)
* VIP list fixed (Xidaozu)
* Learn Spells fixed (Xidaozu)
* Also some binary fixes
* SQL changes: new table reports, new field (reason) in table bans.

Evloution 0.7.5

* Houses fixed (Xidaozu)
* Premium + Promotion system fixed (Xidaozu)
* Monster loot fixed (Xidaozu)
* Destroy field fixed (Rafacin)
* Skulls fixed when firing fields (SimOne)
* Account Manager fixed a bit (Xidaozu)
* Blue Robe and Magic Turban trough items.xml (Xidaozu)
* New items.otb and items.xml (SimOne)
* Spawnmul in config.lua (SimOne)
* Drowning Condition (SimOne)
* Re-Added High levels 350+ (Xidaozu)
* Auto-load IP in config.lua (Xidaozu)
* Rook Temple in config.lua (Xidaozu)
* Premium Outfits (Xidaozu)
* Fixed server save (Xidaozu)
* Added function to increase physical damage (Xidaozu)
* Unfornately protection system disabled
* Also some binary fixes

Version 0.7.6

* Fixed some item hotkey issues (Xidaozu)
* Fixed some summon issues (SVN)
* Fixed account manager (111111/tibia now)
* Fixed Cap System (SVN)
* Fixed rewriteables (SVN)
* Fixed some spells
* Buy Container (Xidaozu)
* Bed System (100%)(Xidaozu)
* Beds loaded from Map (Xidaozu)
* Protection System fixed (?)
* PvP Arena (Nfries88)
* Combat Zoning (Nfries88)
* Fluid System 100%
* Trade Delay (Xidaozu)
* Death Delay ticks in config.lua (Xidaozu)
* Fixed a learn spell issue (Xidaozu)
* Frag Time in config.lua in minutes (Xidaozu)
* Fixed magic wall (Xidaozu)
* -----------------------
* SQL changes: Acc manager has other accno/pass

Version 0.7.6a

* Removed PvP Arena (Nfries88)
* Removed Bed System (100%)(Xidaozu)
* Removed Beds loaded from Map (Xidaozu)
* Removed Protection System fixed (?)
* Removed Combat Zoning (Nfries88)
* Fixed a learn spell issue
* Fixed some monsters
* Muted System (SVN)
* NPC Auto Walk (SVN)
* PvP Features in config.lua (Xidaozu)
* This version should be alot more stable.

Version 0.7.7

* Remote-Control (SVN, Xidaozu)
* Bed System (Jiddo)
* Beds loaded from map (Jiddo)
* Jiddo's NPC System (Jiddo)
* PvP-Arena (nfries88)
* Seperate addon system (Xidaozu)
* Protection System (Xidaozu)
* NPC's turning to player (SVN)
* NPC Random Walk (SVN)
* GUI removed (Moved to remote-control)
* Config: Minimum action interval
* Tons of bug/crash fixes (That list is too long xd)
-----------------------
* SQL changes: New table addons

Version 0.7.8

* Walk-to items (Xidaozu)
* Bless System (Xidaozu)
* New variables in vocations.xml (Xidaozu)
* Experience Stages (Xidaozu)
* Alot new Lua functions (Xidaozu, SVN)
* New door and leveldoor system (Jiddo)
* Lua functions list (Xidaozu)
* Fixed type tag in raids (Xidaozu)
* Fixed Ctrl + Y (Xidaozu)
* Fixed summons following (Xidaozu)
* Fixed depot tiles (Xidaozu)
* Fixed food loading/saving (Xidaozu)
* Updated skill multipliers in vocations.xml (Xidaozu)
* Updated Jiddo's NPC System (Jiddo)
* Updated Lua Interface (SVN)
* -----------------------
* SQL changes: New table blessings

All Features OTH-OTServ 0.1.0 - 0.1.8.5

Version 0.1.0 Beta (Biosot OTP)

* update bless system evolutions 7.9 (Xidaozu and Neo)
* New Items (Neo)
* Nuevos comandos (y todos los de los otros servers (Neo)
* Debug en los comandos arreglado (kupi)
* Alot new Lua functions (Xidaozu, SVN, Neo, y kupi)
* Todo lo de 8.0 funciona al 100% (noserman addon, items...) (neo, kupi, and...)
* eso es lo destacado, hay mas provarlo y lo vereis

Version 0.1.1 (Biosot OTP)

* Record Player System
* One Player Online Per Account
* AutoClean
* Owner Body System
* TRade system
* New Commands
* New Rookgaard System
* New PVP Zones

Version 0.1.2 (Biosot OTP)

* Fixed Trade delay system (neo)
* New Items (Neo)
* New commands (Neo)
* New system rookgaard improved by 90% (neo)
*New style weapons in #: (neo)
- <attribute Key="dualwield" value="1" /> (You can use 2 Weapons)
- <attribute Key="extraatk" value="25" /> (Add extra attack)
- <attribute Key="attackspeed" value="2000" /> (Add speed for this weapon)
* Add Marriage System (NPC: UnderConstruction) (neo)
* Fixed Marriage System, and added a code to save well (kupi)
* Add Command kickall (neo)
* PVP Zones (PVP zones can do, ZONES PVP-ENFORCED and ZONES NO-PVP (in the script pvp zones.xml I think) (neo)
* Remote Control (Cepe thanks for the image) (os you can download part here below but biene with OT) (kupi)

Biosoft-OTP 0.1.3

* Remove Auto Clena ( BUG)
* Remove command /paralize ( BUG )
* Remove New staly in Weapons
* Add Randomize Ground
* Add Beds Regen
* Add Confi Color. Exp, Square, Animation
* Add Animations (Level Up! etc.)
* Add Exp Color and Rando Exp color
* you can edit test to Show in animations Example ( Level Up! ) - ( You Up Level! )
* Add Christmas Decoration

Biosoft OTP version 0.1.4

* Removed Christmas Ornaments (neo)
* Config.lua removal of the system of access (SVN)
* Removed the function of not attacking one member of the Guild (neo)
* We implemented the weapons system to the new SVN (SVN)
* Add the function "moveback" so that the spears do not fall (neo)
* Addition ShootType, Breakchance, Hitchance from items.xml (neo)
* And much more!

Biosoft OTP version 0.1.5

* Update to Ultimate SVN ( Neo & Kupi )
* Add more funtions ( Neo & Kupi )
* Custom Client in config.lua ( nfries88 )
* Add 90 % Funtion Evolutions ( Neo & Kupi )
* Add MultiWorld System ( nfries88 )
* Add New System QuestsLog ( pregusia )
* Add Dual Wielding [in items.xml] ( nfries88 )
* Weapon Attack Speeds [in items.xml] ( nfries88 )
* Extra Attack [in items.xml] ( nfries88 )
EXAMPLE:

- <attribute>
- <attribute>
- <attribute>

* Add CreatureEvents: onSpawn[monsters], onAdvance [players], onThink [both] ( nfries88 )
* LUA Function: to execute a command [no access checks] ( nfries88, Pedro B. )
* And much more!

Biosoft OTP v.0.1.6 Beta 1

* Nuevo systema de account manager, con mas configuraciones desde config.lua (neo)
* update SVN Rev.2853 (4-1-07) (kupi)
* update SVN Rev.2858 (5-1-97) (kupi) (lo pongo porque traia varios canvios) (e updateado algo mas adelante, pero esque lo actualizan unas 3 veces por dia, se hace imposible dar al abasto Big Grin neo se ancargara de actualizarla y fixar esta version)
* removidos algunos systemas que causaban debugs con los nuevos SVN (kupi)
* arreglados algunos systemas que daban debug con los nuevos systemas (kupi)
* mas configuraciones desde config.lua (neo)
* fixed learn spells system (kupi)
* fixed cap system (kupi)
* fixed configuraciones desde config.lua (kupi)
* agregada mas seguridad (kupi & SVN)
* codigo que da mas proteccion ante los atques DDoS (kupi & Proglin) (removido por bugs)
* add fist weapons system (nose muy bien para que funciona, pero encontre el codigo y lo meti) (kupi)
ejemplo, en items/items.xml
o <item id="5875" name="sniper gloves">
<attribute key="description" value="They are the pride of the paladin guild."/>
<attribute key="weight" value="400"/>
<attribute key="defense" value="15"/>
<attribute key="attack" value="30"/>
<attribute key="weaponType" value="fist"/>
<attribute key="slotType" value="two-handed"/>
</item>
* actualizado el premium system (mas completo) (kupi)
* more lua functions (kupi)
* otra lua function (kupi) :
* mas configuraciones desde config.lua (kupi)
* fixed muchas configuraciones de config.lua que no funcionaban (kupi)
o doPlayerSetSex (ejemplo de script: doPlayerSetSex(cid, 0) )
* custom client (aun me lo estoy pensando) (al final no sacado, seguramente se sacara mas adelante)
* agregar mas configuraciones (como susprise bags...) (kupi & zorzin)
* fixar mas systemas (kupi)
* fixar las configuraciones de config.lua (kupi)
* agregar los systemas removidos (kupi) (algunos, algunos los e tenido de sacar)
* bastante mas... probenlo no hos arrepentireis Big Grin ahora posteo el link

Biosoft OTP v.0.1.6 Beta 2

* fixed database (kupi)
* fixed config.lua Big Grin (kupi)
* fexed actions

Biosoft OTP v.0.1.8 Beta

* Update SVN 04/02/08
* All Bugs Fixed ( GM Neo )
* weapons, items, monsters y muchos mas... ( Trekes )

NOTA:
Bueno por falta de tiempo y andar de afan dare una lista de las cosas que me faltan por agregar, para que el sabado o domingo las tendra listas para dejar el Biosoft de nuevo Full

* Randomize Ground ( Config.lua )
* Animations ( Config.lua )
* Bed regen ( Config.lua)
* Show House Price ( Config.lua )
* House Only premium ( Config.lua )
* Afk turn ( Config.lua )
* Cant send Private message GM's ( Config.lua )
* Bag player after death ( Config.lua )
* Priority ( Config.lua )
* Premium Price ( Config.lua )
* stages.xml
* pvpzones.xml
* pvparenas.xml
* Max summons ( Config.lua )
* Items Hotkeys ( Config.lua )
* Battle Windows ( Config.lua )
* Feet Damage ( Config.lua )
* Animate spells ( Config.lua )
* Protection system ( Config.lua )
* Critical Damage ( Config.lua )

Biosoft OTP v.0.1.8.5

* Add FancyAnimations
* Show House Price ( Config.lua )
* House Only premium ( Config.lua )
* Afk turn ( Config.lua )
* Priority ( Config.lua )
* Premium Price ( Config.lua )
* Max summons ( Config.lua )
* Items Hotkeys ( Config.lua )
* Battle Windows ( Config.lua )
* Animate spells ( Config.lua )
* Critical Damage ( Config.lua )
* Exp Color ( Config.lua )
* Protection Attack DDOS ( Config.lua )
* Advanced CreatureEvents
* MultiWorld System
* Rogier ShareExp ( Config.lua )
* TFS Quests logs

Biosoft OTP v.0.2.8.5

* Bed regen ( Config.lua)
* Randomize Ground ( Config.lua )
* Cant send Private message GM's ( Config.lua )
* stages.xml
* pvpzones.xml (echo)
* pvparenas.xml (echo)
* premiumtiles.xml
* Feet Damage ( Config.lua )
* Protection level system ( Config.lua )

Biosoft OTP v.0.3.8.9

* Show House Price ( Config.lua )
* House Only premium ( Config.lua )
* Afk turn ( Config.lua )
* Premium Price ( Config.lua )
* Max summons ( Config.lua )
* Items Hotkeys ( Config.lua )
* Battle Windows ( Config.lua )
* Advanced CreatureEvents
* Rogier ShareExp ( Config.lua )
* TFS Quests logs
* Randomize Ground ( Config.lua )
* pvpzones.xml (echo)
* pvparenas.xml (echo)
* Feet Damage ( Config.lua )
* Protection level system ( Config.lua )
* new commands
* and more!

REMOVED!
* Add FancyAnimations ( by creatureevents )
* Priority ( Config.lua ) (removed)
* Animate spells ( Config.lua ) (removed)
* Critical Damage ( Config.lua ) (removed)
* Exp Color ( Config.lua ) (removed)
* Protection Attack DDOS ( Config.lua ) (bugged)
* MultiWorld System (bugged)
* Bed regen ( Config.lua) (removed)
* Cant send Private message GM's ( Config.lua ) (removed)
* stages.xml (bugged)
* premiumtiles.xml (removed)

Basado en el SVN del 14/07/08
=> Binario
=> Sources

Biosoft OTP v.0.3.9.0

* Add Beb system
* Bed regent ( config.lua )
* Edit dir files XML ( XML Files )
* Add NPC Test82.lua ( Fixed SVN )
* bugfix in item.cpp ( Tiny )

Basado en el SVN del 18/07/08
=> Binario
=> Sources

Biosoft OTP v.0.6.1.0

* UPDATE to Last Revision Avesta
* All Features Avesta
* Bed System
* Party System
* Skull System
* Quest Log
* Revised NPC System via XML
* Better attack / magic formulas (more RL-Tibia like)
* No-logout zones / PvP Zones
* RL Tibia Exp Share
* Corpse owners
* Elements system
* RL Tibia-like NPC Buy / Sell
* Addon (Fixed)
* AOL (Fixed)
* Add Christmas decoration
* Add Critical damage
* Add Style channel chats (sora)
* Add Default priority (config.lua)
* Premium system (xidaozu, neo)
* GM Look (Nfries88, kupi)
* GM Move (GM's can move items from distance) (Nfries88)
* More house options config (kupi, neo)
* Premium Outfit System (kupi)
* fix bugs (neo & kupi)
* and more systems. (neo & kupi)
* Website compatible and created special for this Distro (kupi)

* Based on Avesta revision: 3387 (19-7-08) (SVN Team) edited by kupi & GM Neo

Basado en Avesta del 19/07/08

=> Binario
=> Sources (Cooming Soon!!!)

Biosoft OTP v.0.6.1.0a

* Based on Avesta revision: 3309 (27-7-08) (SVN Team) edited by kupi & GM Neo

=> Binario
=> Sources (Muy Pronto!)
=> OTMapEditor
=> DLL's Files

Biosoft OTP v.0.6.2.0

* Based on Avesta (29-7-08) (SVN Team) edited by kupi & GM Neo
* Aol ( Fixed )
* Creature Event ( Fixed )
* Items.xml, Items.otb ( Remere )
* Add new access & ranks
* Another Bug's Fixed!

=> Binario
=> Sources
=> OTMapEditor
=> DLL's Files

Biosoft OTP v.0.6.3.0

* Fixed a bug with reloading movement actions ( avesta )
* Added a new function doAddContainerItemEx() ( avesta )
* Updated map to version 1. ( avesta )
* Fixed item 392 to have floorchange down. ( avesta )
* Minor cleanups ( avesta )
* Add new funtion for rings (moreExp)
- <attribute key="moreExp" value="50"/>
* Add Critical damage (config.lua)
* Add trade delay

=> Binario
=> Sources
=> OTMapEditor
=> DLL's Files

Biosoft OTP v.0.6.4.0 ( Beta )

* Add support to protocol 8.22
* Update items.xml ( Avesta )
* Add new lib's ( Gm Neo )
- addPremium
- isPromoted
- Promote
* Add Npc's ( Gm Neo )
- Premium
- Promotion
- Addons Does not work with all outfits (Just the outfits Citizen, Hunter, Mage, Knight)
- Amulets
* add new command
- /promote
* Datadabe bug's Fixed ( Thanks for report )
* Npc crash fix ( Avesta )
* Fixed a bug with the optimized Map ( Avesta )
* Small fix to delayed actions for pushing creatures. ( Avesta )
* and more...

=> Binario
=> Sources
=> OTMapEditor
=> DLL's Files

Biosoft OTP v.0.6.5.0

* Removed old bless system
* Removed command /bless
* Update database
* Add new bless system ( TFS )
* Add Npc bless ( TFS )
* Add Advance NpcSystem ( Jido )
* Npc trade fixed bug doPlayerAddMoney ( Thx for report )
* Npc BroadCaster ( Fixed )
* AttackSpeed ( Fixed )
* Update Ultimate Revision Avesta
* And fixed minor bugs...

Warnnig...
Romove this old database:

Code:

CREATE TABLE `player_blessings` (
    `player_id` INT NOT NULL,
    `blessing` INT NOT NULL
) ENGINE = InnoDB;

And add this in in Players:

Code:

    `blessings` TINYINT(2) NOT NULL DEFAULT 0,

Or add new consult and

Code:

Blessings
TINYINT (2)
No Null
Default 0

=> Binario
=> Sources
=> Dev-Cpp
=> OTMapEditor
=> DLL's Files

Biosoft OTP v.0.6.6.0

* Update to Avesta
* Exiva Player ( Fixed )
* Add System AntiAttack DDOS
* Add MultiWorld System
* Fixed Spells Haste, Strong Haste and Magic Shield
* Update database

Notes:
For those who already have the database only make this list:
-- Enter the phpmyadmin
-- Select database
-- Add new consultation with these values:

Code:

* worltype
* int(11)
* no null
* default 1

=> Binario
=> Sources ( Coming soon )
=> Dev-Cpp
=> OTMapEditor
=> DLL's Files

Luck!

Jokero · Aug 3, 2008

Scan taken on 03 Aug 2008 16:38:45 (GMT)
A-Squared
Found nothing
AntiVir
Found nothing
ArcaVir
Found nothing
Avast
Found nothing
AVG Antivirus
Found nothing
BitDefender
Found nothing
ClamAV
Found nothing
CPsecure
Found nothing
Dr.Web
Found nothing
F-Prot Antivirus
Found nothing
F-Secure Anti-Virus
Found nothing
Fortinet
Found nothing
Ikarus
Found nothing
Kaspersky Anti-Virus
Found nothing
NOD32
Found nothing
Norman Virus Control
Found nothing
Panda Antivirus
Found nothing
Sophos Antivirus
Found nothing
VirusBuster
Found nothing
VBA32
Found nothing

gm neo colombia · Aug 3, 2008

@ Jokero

Thx ^_^

RunarM · Aug 3, 2008

I will try it

Dante · Aug 3, 2008

omfg why rapidshare use speedyshare or something

Kask · Aug 3, 2008

BioSoft never got a Troyanos or BUGS!

Thanks GM Neo & Kupi for this relase

Dante · Aug 3, 2008

so i can trust this server no virus i hope

gm neo colombia · Aug 4, 2008

@ Raikon II

Thx jajaja ni sabe que decir este sujeto ^_^

@ silentdefender

<_< LoL!

Keraxel · Aug 4, 2008

There's source included? I ask about it because I remember January's Biosoft...

gm neo colombia · Aug 4, 2008

@ Keraxel

Code:

=> Binario
=> Sources
=> OTMapEditor
=> DLL's Files

Sources are Included

Nooben nr1 · Aug 4, 2008

can anyone tell me what packers are? I scanned the DLL files and this was the result:

File: otdll-v14.7z
Status: OK(Note: file has been scanned before. Therefore, this file's scan results will not be stored in the database)
MD5: e56035f9a5f330be54e22ab17567c6ce
Packers detected: PE_PATCH.UPX, UPX

Scanner results
Scan taken on 03 Aug 2008 23:20:15 (GMT)
A-Squared Found nothing
AntiVir Found nothing
ArcaVir Found nothing
Avast Found nothing
AVG Antivirus Found nothing
BitDefender Found nothing
ClamAV Found nothing
CPsecure Found nothing
Dr.Web Found nothing
F-Prot Antivirus Found nothing
F-Secure Anti-Virus Found nothing
Fortinet Found nothing
Ikarus Found nothing
Kaspersky Anti-Virus Found nothing
NOD32 Found nothing
Norman Virus Control Found nothing
Panda Antivirus Found nothing
Sophos Antivirus Found nothing
VirusBuster Found nothing
VBA32 Found nothing

gm neo colombia · Aug 4, 2008

DLL's by Talaturen

<_<

Scan?

Ferchox · Aug 4, 2008

Nice!, Bien hecho.

gm neo colombia · Aug 6, 2008

New UPDATE 0.6.3.0

KazzXD · Aug 6, 2008

have sqlite? i can use tfs sqlite databases? no? suck.

gm neo colombia · Aug 6, 2008

you can use SQLite but you need add others tables...

Limannen · Aug 6, 2008

is it me, or is the database kinda bugged?
I can't load it :S

Regards,
Limannen

gm neo colombia · Aug 8, 2008

@ Limannen

^_^ database bugged xD

use this

Code:

CREATE TABLE `groups` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL COMMENT 'group name',
    `flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
    `access` INT NOT NULL,
    `maxdepotitems` INT NOT NULL,
    `maxviplist` INT NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `accounts` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
    `premDays` INT NOT NULL,
    `premEnd` INT NOT NULL,	
    `email` VARCHAR(255) NOT NULL DEFAULT '',
    `blocked` TINYINT(1) NOT NULL DEFAULT FALSE,
    `deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
    `warned` TINYINT(1) NOT NULL DEFAULT FALSE,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `deathlist` (
    `player` INT NOT NULL default 0,
    `killer` VARCHAR(30) collate latin1_general_ci NOT NULL DEFAULT  '',
    `level` INT NOT NULL default 0,
    `date` INT NOT NULL default 0
) ENGINE = InnoDB;

CREATE TABLE `player_addons` (
    `player_id` INT UNSIGNED NOT NULL DEFAULT  0,
    `outfit` INT UNSIGNED NOT NULL DEFAULT  0,
    `type` INT UNSIGNED NOT NULL DEFAULT  0
) ENGINE = InnoDB;

CREATE TABLE `player_blessings` (
    `player_id` INT NOT NULL,
    `blessing` INT NOT NULL
) ENGINE = InnoDB;

CREATE TABLE `players` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `account_id` INT UNSIGNED NOT NULL,
    `group_id` INT UNSIGNED NOT NULL COMMENT 'users group',
    `sex` INT UNSIGNED NOT NULL DEFAULT 0,
    `married` INT NOT NULL DEFAULT 0,
    `lover` INT NOT NULL DEFAULT 0,
    `testify` INT NOT NULL DEFAULT 0,
    `engaged` INT NOT NULL DEFAULT 0,	    
	`vocation` INT UNSIGNED NOT NULL DEFAULT 0,
    `experience` BIGINT UNSIGNED NOT NULL DEFAULT 0,
    `level` INT UNSIGNED NOT NULL DEFAULT 1,
    `maglevel` INT UNSIGNED NOT NULL DEFAULT 0,
    `health` INT UNSIGNED NOT NULL DEFAULT 100,
    `healthmax` INT UNSIGNED NOT NULL DEFAULT 100,
    `mana` INT UNSIGNED NOT NULL DEFAULT 100,
    `manamax` INT UNSIGNED NOT NULL DEFAULT 100,
    `manaspent` INT UNSIGNED NOT NULL DEFAULT 0,
    `soul` INT UNSIGNED NOT NULL DEFAULT 0,
    `direction` INT UNSIGNED NOT NULL DEFAULT 0,
    `lookbody` INT UNSIGNED NOT NULL DEFAULT 10,
    `lookfeet` INT UNSIGNED NOT NULL DEFAULT 10,
    `lookhead` INT UNSIGNED NOT NULL DEFAULT 10,
    `looklegs` INT UNSIGNED NOT NULL DEFAULT 10,
    `looktype` INT UNSIGNED NOT NULL DEFAULT 136,
    `lookaddons` INT UNSIGNED NOT NULL DEFAULT 0,
    `posx` INT NOT NULL DEFAULT 0,
    `posy` INT NOT NULL DEFAULT 0,
    `posz` INT NOT NULL DEFAULT 0,
    `cap` INT NOT NULL DEFAULT 0,
    `lastlogin` INT UNSIGNED NOT NULL DEFAULT 0,
    `lastip` INT UNSIGNED NOT NULL DEFAULT 0,
    `save` TINYINT(1) NOT NULL DEFAULT TRUE,
    `conditions` BLOB NOT NULL COMMENT 'drunk, poisoned etc (maybe also food and redskull)',
    `redskulltime` INT UNSIGNED NOT NULL DEFAULT 0,
    `redskull` TINYINT(1) NOT NULL DEFAULT FALSE,
    `guildnick` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'additional nick in guild - mostly for web interfaces i think',
    `loss_experience` INT NOT NULL DEFAULT 10,
    `loss_mana` INT NOT NULL DEFAULT 10,
    `loss_skills` INT NOT NULL DEFAULT 10,
    `loss_items` INT NOT NULL DEFAULT 10,
    `rank_id` INT NOT NULL COMMENT 'by this field everything with guilds is done - player has a rank which belongs to certain guild',
    `town_id` INT NOT NULL COMMENT 'old masterpos, temple spawn point position',
    `needtobeteleported` INT NOT NULL,
    `ispromoted` INT NOT NULL,
    `havepromotion` INT NOT NULL,	
    `balance` INT NOT NULL DEFAULT 0 COMMENT 'money balance of the player for houses paying',
    PRIMARY KEY (`id`),
    UNIQUE (`name`),
    FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
    FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE = InnoDB;

CREATE TABLE `guilds` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL COMMENT 'guild name - nothing else needed here',
    `ownerid` INT NOT NULL,
    `creationdata` INT NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `guild_ranks` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `guild_id` INT UNSIGNED NOT NULL COMMENT 'guild',
    `name` VARCHAR(255) NOT NULL COMMENT 'rank name',
    `level` INT NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
    PRIMARY KEY (`id`),
    FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_viplist` (
    `player_id` INT UNSIGNED NOT NULL COMMENT 'id of player whose viplist entry it is',
    `vip_id` INT UNSIGNED NOT NULL COMMENT 'id of target player of viplist entry',
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
    FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_spells` (
    `player_id` INT UNSIGNED NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_storage` (
    `player_id` INT UNSIGNED NOT NULL,
    `key` INT NOT NULL,
    `value` INT NOT NULL,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_skills` (
    `player_id` INT UNSIGNED NOT NULL,
    `skillid` INT UNSIGNED NOT NULL,
    `value` INT UNSIGNED NOT NULL DEFAULT 0,
    `count` INT UNSIGNED NOT NULL DEFAULT 0,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_items` (
    `player_id` INT UNSIGNED NOT NULL,
    `sid` INT NOT NULL,
    `pid` INT NOT NULL DEFAULT 0,
    `itemtype` INT NOT NULL,
    `count` INT NOT NULL DEFAULT 0,
    `attributes` BLOB COMMENT 'replaces unique_id, action_id, text, special_desc',
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
    UNIQUE (`player_id`, `sid`)
) ENGINE = InnoDB;

CREATE TABLE `houses` (
    `id` INT UNSIGNED NOT NULL,
    `owner` INT NOT NULL,
    `paid` INT UNSIGNED NOT NULL DEFAULT 0,
    `warnings` INT NOT NULL DEFAULT 0,
    `lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `house_lists` (
    `house_id` INT UNSIGNED NOT NULL,
    `listid` INT NOT NULL,
    `list` TEXT NOT NULL,
    FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `bans` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `type` INT NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
    `value` INT UNSIGNED NOT NULL COMMENT 'ip, player guid, account number',
    `param` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'mask',
    `active` TINYINT(1) NOT NULL DEFAULT TRUE,
    `expires` INT UNSIGNED NOT NULL,
    `added` INT UNSIGNED NOT NULL,
    `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
    `comment` VARCHAR(255) NOT NULL DEFAULT '',
    `reason` INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY  (`id`),
    KEY (`type`, `value`),
    KEY (`expires`)
) ENGINE = InnoDB;

CREATE TABLE `tiles` (
    `id` INT UNSIGNED NOT NULL,
    `x` INT NOT NULL,
    `y` INT NOT NULL,
    `z` INT NOT NULL,
    PRIMARY KEY(`id`)
) ENGINE = InnoDB;

CREATE TABLE `tile_items` (
    `tile_id` INT UNSIGNED NOT NULL,
    `sid` INT NOT NULL,
    `pid` INT NOT NULL DEFAULT 0,
    `itemtype` INT NOT NULL,
    `count` INT NOT NULL DEFAULT 0,
    `attributes` BLOB NOT NULL,
    FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_depotitems` (
    `player_id` INT UNSIGNED NOT NULL,
    `depot_id` INT NOT NULL DEFAULT 0,
    `sid` INT NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
    `pid` INT NOT NULL DEFAULT 0,
    `itemtype` INT NOT NULL,
    `count` INT NOT NULL DEFAULT 0,
    `attributes` BLOB NOT NULL,
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
    INDEX (`player_id`, `depot_id`),
    UNIQUE (`player_id`, `sid`)
) ENGINE = InnoDB;

CREATE TABLE `global_storage` (
    `key` INT UNSIGNED NOT NULL,
    `value` INT NOT NULL,
    PRIMARY KEY(`key`)
) ENGINE = InnoDB;

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 3 AND `value` = OLD.`id`;
END|

CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON `guilds`
FOR EACH ROW
BEGIN
    UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
    DELETE FROM `guild_ranks` WHERE `guild_id` = OLD.`id`;
END|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`;
    UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
END|

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

DELIMITER ;

Atrix · Aug 8, 2008

Error

SQL query:

DELIMITER;

MySQL said: Documentation
#1064 - 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 'DELIMITER' at line 1

this is when i try to add database... i dont know it is working 100% but it shows me accounts... and other shits

and what acc page i must use... if i use Nicaw it show me some error whe i try to make character... plz help me!

Denis Tacador De Runa · Aug 8, 2008

My map seems to unable to load.

:: Loading map from: data/world/blackout.otbm OTBM
FATAL: [OTBM loader] Could not open the file data/world/blackout.otbm.

[8.21/8.22]Biosoft 0.6.6.0

Biosoft-OTP

New Member

Biosoft-OTP

Finally back

silentdefender

Banned User

silentdefender

Biosoft-OTP

Ω Obfuscator Ω

Biosoft-OTP

New Member

Biosoft-OTP

Member

Biosoft-OTP

New Member

Biosoft-OTP

Member

Biosoft-OTP

Server Editor

New Member

Similar threads