summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2007-10-01* Reverted the bug that was added in the last updatePlaytester2-2/+1
- official script clearly says 30% - please don't update db files without official source git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11338 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01Fixed Gemini-S58 Card.Paradox924X2-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11335 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-28Added missing msg_athena.conf entry for the summer outfit; name 'Summer' ↵ultramage2-0/+0
used for now. Removed strange 'svn:executable' attributes from item_db2.sql and mob_db2.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11325 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-28Updated item_db.sqlPlaytester1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11322 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-27* Removed Final Strike from skill_cast_dbPlaytester2-898/+897
- also updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11317 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-27* Reimplemented mmo_char_fromsql using sql statements. (fixes bugreport:93)FlavioJS1-75/+164
* Fixed buildin_gethominfo not being included in the script engine. (bugreport:124) * homunculus_evolution -> homevolution in script_commands.txt. * Deleted item DEFAULT from item_db.txt and regenerated item_db.sql. (bugreport:103) * Skip empty lines and give more feedback (for invalid lines) when reading item_db.txt/item_db2.txt. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11311 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-24Removed unused mobdb2 entries (late followup to 10988 and 10946)ultramage1-33/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11285 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-22Updated sql filesPlaytester2-80/+80
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11273 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-19* Slightly adjusted some drop ratesPlaytester2-14/+14
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Some more drop rate updatesPlaytester1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11235 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Updated sql filesPlaytester2-50/+64
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11232 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-10Updated item_db.sqlPlaytester1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-09- Modified bonus3 bAddEff/bAddEffWhenHit so that the last parameter is now ↵skotlex1-3/+3
passed directly as "trigger" flag. The possible trigger values are ATF_LONG, ATF_SHORT, ATF_TARGET, ATF_SELF. Explanation added to doc/item_bonus.txt - Updated some cards to use the new format of bonus3 bAddEff* git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11157 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-09Updated sql filesPlaytester2-507/+677
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11152 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-04* Some drop and item fixesPlaytester2-150/+184
- also updated sql files - time for players to test all the new stuff now :x git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11128 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-02Forgot to update base item db sql file! :PParadox924X1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11108 54d463be-8e91-2dee-dedb-b68131a5f0ec