summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2009-05-04Reverted the "The md5() of their kafra code is now stored in #kafra_code$" ↵ultramage2-2/+1
change from r13728. Added md5calc to vs8/vs7/vs6 project files. Applied svn:eol-style to the new sql upgrade file. Note that if you already applied the sql upgrade, your kafra passwords are lost. Also note that txt users will still have to implement their own migration code into the kafra scripts since it was omitted in the previous commits. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13729 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04* Added the md5() script command. (follow up to r13719)brianluau1-0/+1
- Changed kafra storage password to be stored as md5 hash in #kafra_code$. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13728 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04Updated item_db.sql and mob_db.sql from recent changes to both. Thanks to ↵jmanfffreak2-3022/+3107
Peter once again! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-03* Removed the obfuscation of the #kafra_code password. (bugreport:2323)brianluau1-0/+1
TODO: add a 'md5()' script command and use that instead. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13719 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-18* Updated item_db.sql with the perl scriptPlaytester1-1680/+2371
* Added missing changelog entries about Moscovia mob changes git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13597 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-17Updated mob_db.sql to latest, thanks to Peter for his auto builds of the ↵jmanfffreak1-139/+177
db's. [Jguy] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-15Corrected the `char` table's 'manner' column type to match the type used by ↵ultramage2-1/+2
the server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13583 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-02-21Corrected revision number for the previous upgrade script.ultramage2-2/+2
Applied changes made inside the script to main.sql. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13542 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-02-20Increased variable size for status/skill points to remove the 65k cap ↵ultramage1-0/+2
(bugreport:1579). Added sql upgrade script to adjust the appropriate char table columns. This is an enhancement to r5762. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13541 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-29Fixed typo on item script.Kisuka2-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13390 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-16- Item Rental System.zephyrus2-0/+10
Script Usage: - rentitem <itemid>,<seconds>; - rentitem <itemname>,<seconds>; git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13370 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-08Partially reverted r13197 to maintain consistency with followup sql update.ultramage1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13200 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-07- Removed mer_id from main.sql in char table. (Bug Report 2192)zephyrus2-2/+0
- Removed 13117 sql patch, not necessary anymore. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13197 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-01- Moved char server's mercenary code to a different file (int_mercenary.*)zephyrus4-0/+41
- New Sql Patch for create mercenary_owner DB. - Removed mer_id from char_db. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13166 54d463be-8e91-2dee-dedb-b68131a5f0ec
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