summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Collapse)AuthorFilesLines
2006-09-13- Modified the login SQL server so that case insensitive lookups use "where ↵skotlex1-3/+7
name = BINARY 'name'" instead of "where BINARY name = 'name'", since this way the name index should be used, and performance will no longer be heavily affected. - Modified main.sql to add 4 missing indexes (thanks to ErkDog): char_id on the tables memo/friends, and online/name on the char table. Added upgrade_svn8728.sql to add these indexes to already existing tables. - Changed back the default of case-sensitive to ON since it shouldn't be such a bad performance hog now. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8728 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-12- Added manual deletion of sc_data entries when deleting a character (char-SQL)skotlex1-29/+18
- Updated main.sql to use pure MyISAM tables, removed all foreign keys. - Added Jaguar's sql script to convert all tables to MyISAM. It's located in sql-files/convert_engine.sql - Removed convert_guild_tables.sql as we don't use InnoDB anymore. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-05- Fixed connect_until field being a smallint rather than int in the login ↵skotlex1-1/+1
table (upgrade with upgrade_svn8630.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-10- Fixed two instances in the login-sql server where the ip in the log-login ↵skotlex1-1/+1
table was being stored backwards. - Now when a skill's range is 0 and the skill is NOT casted on self, it will take the basic weapon's range (without Vulture/Snake Eye bonus). - Now when a duration is not specified, sc_start/sc_start2/sc_start4 will try to guess the duration by extracting it from the skill_db (it uses skill_get_time on whatever skill is associated to the status-change using val1 as skill-level) - Corrected that extra comma at the end of the Kaensin layout setup. - Some cleanups on trade_tradeaccept to prevent packets being resent when they shouldn't. - Corrected that ALLOW NULL thingie on main.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8229 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-10Fixed syntax error in 'guild' create table statementtoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8228 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-08- Fixed yet again AS_SPLASHER doing full damage on all characters. Now you ↵skotlex1-1/+1
can use the NK split damage value in the skill_db if you want damage divided by the amount of targets rather than by 2. - Fixed crash on the battle_drain functions. - Cleaned up HAMI_CASTLE, HLIF_AVOID, HAMI_DEFENCE so that it's usable by other types of objects other than Homunculus. - Cleaned up the Asura Strike code so that the SP/Spheres/States is not consumed when the skill fails due to Fog of Wall. - When a negative delay for a skill is specified, this delay is now added on top of the character's amotion rather than adelay - Modified main.sql to make the guild table allow NULL on the emblem data. - Added file conf-tmpl/Changelog.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8185 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-20SQL fix for Homunc skillsDracoRPG1-3/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7768 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-17Orn's and Albator's Homunculus system, finally, YAY!!DracoRPG1-540/+584
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7706 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-08- Fixed the char table having party/guild_id as smallint when they need int ↵skotlex1-2/+2
there. Thanks to hermematon for pointing it out (use svn_ugprade7580.sql) - Applied k3dt fixes to pet-hatching, ice-wall check, and wedding skills. - Fixed endow skills calling the skill no damage packet twice. - Fixed a crash on warpwaitingpc when the chat-room is empty. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16sql optimizations.Euph1-539/+540
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-14- Fixed main.sql adding a key on char_id rather than account_id for the char ↵skotlex1-1/+1
table. - Cleaned up character saving in char-sql, it no longer needs to query the database to see if the player exists on each char-save, instead it checks the received data against the online-players db. - Added an error message on the char-server when the received player data size does not matches with the expected size (should avoid the crash that happens on such a memcpy). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7160 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-14Syntax errors :(Lance1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-13- Updated mob_db.sql and item_db.sql to latest.skotlex1-0/+1
- Added account_id index to char table. Thanks to Buuyo for reporting it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7146 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-31[Improved]: Lance1-1/+1
- loginlog using unsigned long `ip` field. (Please check for compatibility problems). [Added]: - Mercenary.c in VS.NET 2005 project files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6868 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-19- Fixed loginlog definition in main.sql, thanks to Tempestaskotlex1-2/+2
- Likely fixed the mob-skill random picking behaviour causing infinite loops sometimes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6658 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-11- Fixed the definition of the KEY in the loginlog, thanks to TheUltraMageskotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6559 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-09- Fix on pc_skill which fixes overlapping when one gets more than one bonus ↵skotlex1-1/+2
for the same skill. - Updated main.sql's loginlog table structure. - Added svn_update6533.sql to update the loginlog structure as suggested by theultramage. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6533 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-14- Fixed the average_lv column size specification. Thanks to Joshuaali ↵skotlex1-3/+3
(upgrade_svn5607.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5603 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-04- Some cleaning of the main.sql fileskotlex1-28/+28
- Added upgrade file 5455 to make the manner/karma columns signed. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5455 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-17- Added an upgrade_svn file to fix the party sql table (it lacks the ↵skotlex1-1/+1
auto-increment property on the party_id column) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5311 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-16- Updated the login/char sql servers to let the sql tables autogenerate the ↵skotlex1-14/+0
new id, and then retrieve said id using mysql_insert_id rather than playing smart and loading the next insert ID on startup. - Tables affected are: account creation, char creation, party creation, pet creation and guild creation. - Also corrected some functions to be of type (void) rather than () git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5298 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ↵Valaris1-0/+551
GO INTO TRUNK. IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EVERYTHING ELSE GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29Clearing trunk.Valaris1-501/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5091 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-02-10Added a auto increment 'start' value in the main.sql file ^^[Sirius](no author)1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1071 54d463be-8e91-2dee-dedb-b68131a5f0ec
2004-12-19Added a friend0 columncodemaster1-0/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@620 54d463be-8e91-2dee-dedb-b68131a5f0ec
2004-11-29removed a USE that should not be thereamber1-2/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@410 54d463be-8e91-2dee-dedb-b68131a5f0ec
2004-11-14Fixed some file typesamber1-499/+499
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/athena@172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2004-11-04git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/athena@2 ↵(no author)1-0/+500
54d463be-8e91-2dee-dedb-b68131a5f0ec