summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Collapse)AuthorFilesLines
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