• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[8.21/8.22]Biosoft 0.6.6.0

gm neo colombia

Biosoft-OTP
Joined
Jul 4, 2007
Messages
45
Reaction score
0
Location
Medellin / Colombia
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!
 
Last edited:
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
 
BioSoft never got a Troyanos or BUGS!

Thanks GM Neo & Kupi for this relase
 
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
 
@ 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 ;
 
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! :confused::confused:
 
Back
Top