summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2008-06-23* Fixed: replaced TYPEs with ENGINEs in SQL files (for better compatibility, ↵akrus1-2/+2
TYPE is a synonym) [akrus] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12880 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-07Typo fix for r12758 ><ultramage1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12764 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-05Added 'E' type to picklog table's 'type' column (followup to r11721).ultramage1-2/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12758 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-26Increased the allowed packet size for chat messages.ultramage1-0/+1
Changed the capacity of the message column in chatlog (see sql update). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12725 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-24Updated sql files to latesttoms2-35/+57
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-01Updated mob_db.sql to latesttoms1-1/+20
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12677 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-25Updated item_db.sql to latesttoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12652 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-21Updated sql files to latesttoms1-7/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-15Removed all _ in the second name in item_db.txt and updated item_db.sqltoms1-61/+61
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12601 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-15Updated item_db.sql to latesttoms1-21/+24
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12597 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13Forgot to change main.sql to reflect the update to quest_objective table.Kevin1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12582 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13Major updates to the quest system.Kevin1-0/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12581 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11Reverted the `login` table changes from r12464ultramage4-28/+30
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12561 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11Changed eol-style to native for these files.Kevin1-24/+24
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12560 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11New sql definitions for the quest code.Kevin2-15/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-10Char server now loads/saves quest information.Kevin2-0/+55
Included table definitions for quests and quest objectives. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12545 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Replaced the TYPE keyword with ENGINE in all sql files, because this is the ↵ultramage9-108/+112
preferred alternative. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Added login.c to hold most of the common functionality of the login server.ultramage1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12479 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Updated mob_db.sql to latesttoms1-12/+12
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12476 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-03Renamed 'connect_until_time' to 'expiration_time'.ultramage2-2/+4
Renamed 'ban_until_time' to 'unban_time'. this also applies to login table columns (see upgrade_svn12464.sql). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12464 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-27Updated SQL Files (item & mobs)toms3-857/+1055
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12444 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-15Updated Poring Tower to not refinable. (bugreport: 1050)Paradox924X2-1/+2
Renamed custom Stylist to Stylist#customstylist to avoid conflicts with official one. (bugreport: 1042 Updated Airship Typing Challenge to not fail you when you get both strings correct. (bugreport: 1008) Fixed Job_Change Function to properly jobchange babies. (bugreport: 943) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12368 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-05- Added the auctiondb structurezephyrus2-0/+53
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12294 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-02- New optimizations for mail system and adjust to use it on Auctions.zephyrus1-0/+1
- Added a Sql patch to clear all deleted mails. (There is no need to keep that data) - Added more code for Auctions. Not implemented but just for study. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12278 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-25Updated conversion tools for mob_db & item_dbtoms4-288/+406
Updated SQL Files (item & mobs) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12138 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-10Fix to the sql files, password column length must be 32, to store md5 hashes =_=ultramage2-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12049 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-10Another round of login server cleaningultramage2-4/+9
* fixed passwordencrypt on SQL not behaving correctly (since r10753) * corrected some column lengths in the login db (username, password,...) * fixed some places which used wfifo without first reallocating it * removed interserver packet 0x7532 (Request to end connection), as there was no code that actually sent this packet * moved RFIFOSKIP actions to execute as soon as possible git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12043 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-12-17Removed the 'create athena.txt' step from athena-start as the server does ↵ultramage1-0/+0
that automatically. Removed the 'kill -9' action from athena-start, as it prevents the server from shutting down cleanly. If your process gets stuck, kill it manually (or add a hard-stop option). Fixed one wrong revision number in changelog. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11924 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-12-14Guardian hp handling code removal (see bugreport:342)ultramage1-0/+9
- removed guardian hp from the castle data structure, database, savefiles and various script functions (use upgrade_svn11914.sql) - removed guardian hp calculation and manipulation from the castle manager npc, now the hp values are updated by the server itself (glitch: when castle defense changes, all guardians are healed to full) - tweaked script function 'guardianinfo' to provide some data needed by the manager npc (currently available are hp, maxhp and visibility); also, it doesn't need a player attached to execute anymore The whole thing is experimental, use at your own risk (seems to work though...) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11915 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-12-12* Some preparations for the guild script updateultramage3-8/+14
- cleaned up npc event execution code - cleaned up guild data loading/saving code; to be improved later - removed dummy 'account name' expulsion list management code - removed columns 'rsv1' and 'rsv2' from guild member data - removed columns 'rsv1' 'rsv2' 'rsv3' and 'acc' from guild expulsion data - added upgrade_svn11895.sql for SQL git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11895 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-11-12- Important fix to Mail System allowing (by a low change) items duple.zephyrus1-0/+1
- Added picklog to mail. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11721 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-11-07- Some updates on the mail system packets [Zephyrus]zephyrus1-1/+1
- Corrected the mail database structure on main.sql - TODO: find what happens when you cannot receive an emailed item due to weight problems. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11692 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-11-05Updated sql filesPlaytester2-83/+83
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-30- Updated the mail sql structure in main.sql.zephyrus1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11617 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-28Updated sql filesPlaytester1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11602 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-27Followup fixes to r11583:ultramage2-1/+1
* fixed wrong sql upgrade file name, added svn:eol-style native * made 'status' variable directly use the mail_status enum * replaced some hardcoded numbers in mail queries with references to the enum * fixed a query which still used 'read_flag' * fixed all new mails being displayed as 'already read' * removed sd nullpo checks from parse_ functions as that can never happen * fixed mapserver sending (and charserver saving) junk item fields when there is no item attached to a mail * fixed wrong mail send packet interpretation saving random memory after message body ('body_len' doesn't include the terminating zero) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11584 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-27- Improvements to the mail system.zephyrus1-0/+1
- Added a sql patch, renaming "read_flag" column to "status" on the mail db. - Need more testing. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11583 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-24* Cleaned up some messy guild code (more to come)ultramage2-4/+33
* Cleaned up the mail code, no more pointless dynamic allocation * Added upgrade_svn11548.sql to convert the mail table to new format * Updated vs7 and vs6 project files * Increased the max. send buffer size to 5M since 1M is not enough * Please complain if something stops working ^^; git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11571 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-23* Removed the inter_athena.conf maildb settings as they are not required ↵zephyrus2-23/+28
anymore. - MailDB is now an integral part of the MainDB. - To Server Admins, use mysql tools to move your mail data to the new structure. - You can get the maildb structure from main.sql. - Renamed some vars (recomendation of Ultramage :D) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11557 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-22- Added the new mail system. Requires optimization and tests.zephyrus1-11/+22
- Updated the maildb sql structure. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11548 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-21* Added new cards to drops so they can be testedPlaytester2-55/+55
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11539 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-17Updated sql filesPlaytester1-14/+14
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11497 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12Reverted / re-did r11426. Someone please update the db converter to properly ↵ultramage2-13/+13
handle // comments. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11429 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12Updated sql files (2)Playtester2-13/+13
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11426 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12* Removed exp of poring stat mobsPlaytester2-16/+95
- updated Moscovia mob stats - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11421 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-09Added a missing item name thanks to rollopopPlaytester1-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11389 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-09Added upgrade_svn11388.sql to correct some log table column widths (for ↵ultramage2-4/+9
example, atcommandlog only stored first 50 chars) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11388 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-06* Added missing item names in the item_dbPlaytester1-23/+23
- please fix the txt files if there's a bug to begin with next time - also ingame names shouldn't have "_" - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11372 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-05- Bug ID #143: Error In Item_db.sqlzephyrus1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11368 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01Small sql updatePlaytester2-7/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11339 54d463be-8e91-2dee-dedb-b68131a5f0ec