summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2008-08-23- Added column `mer_id` on char_dbzephyrus2-0/+2
- More mercenary implementations (delete, load, create) - Some fixes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13117 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23- Database structure for Mercenary.zephyrus2-0/+29
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13115 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-10Removed 'DROP TABLE' statements from main.sql (bugreport:1714)ultramage1-66/+33
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13062 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-01Removed unused guardian hp columns from the guild castles table in main.sql ↵ultramage1-8/+0
(should have been done in r11915). Corrected incorrect use of the datetime column in the `login` table (bugreport:1962). Refreshed txt account savefile. Cleaned up some random minor source code glitches. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13030 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-31* Fixed: added 'E'-type zenylogs in sql table (bugreport:1957) [akrus]akrus2-2/+7
- added sql file upgrade_svn13025_log.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13025 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-31* Fixed: commented out loginlog in convert engine sql tables (loginlog table ↵akrus2-2/+2
is in logs database now) [akrus] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13019 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-29Corrected upgrade_svn12975_view.sql not assigning default values to the two ↵ultramage1-2/+2
dummy columns (bugreport:1940). Please drop the view and re-run the script. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13010 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-26Merged the /loginmerge branch (topic:192754)ultramage5-21/+78
* the login server storage, ipban and logging systems have been abstracted and now provide a common interface; the rest has been merged into a single login server core (no more login/login_sql duplicity) * storage systems are now added via compiler options (WITH_SQL / WITH_TXT) * multiple storage engines can be compiled in at the same time, and the config option account.engine defines which one will be used. * due to MySQL autoincrement limitations, accounts with id '0' will not be supported; account IDs from this point on should start from '1'. * login_log() functions now again record IP addresses in dotted format, not as 4-byte integers (undo from r6868). * removed config options that defined column names in the login table * removed `memo` and `error message` columns from login db/savefile * moved `loginlog` table to the logs database * added sql files upgrade_svn12975.sql and upgrade_svn12975_log.sql * due to changes to the login table layout, I added an !optional! sql file (upgrade_svn12975_view.sql) that will provide a certain degree of backwards compatibility with existing software; read the instructions inside carefully! * moved third-party includes/libs to a separate directory * updated project files / makefiles Changed the way GM levels are handled * removed conf/gm_account.txt * added the gm level column to the txt savefile (after 'email' column) * gm level information is now transferred along with account data For open problems see bugreport:1889. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13000 54d463be-8e91-2dee-dedb-b68131a5f0ec
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