 skotlex
|
3c5c104561
- Modified the login SQL server so that case insensitive lookups use "where 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.
|
18 年 前 |
|
skotlex
|
c6142c3f39
- Added manual deletion of sc_data entries when deleting a character (char-SQL)
|
18 年 前 |
|
skotlex
|
e7b86b1deb
- Fixed connect_until field being a smallint rather than int in the login table (upgrade with upgrade_svn8630.sql)
|
18 年 前 |
|
skotlex
|
6f3c9a6dc7
- Fixed two instances in the login-sql server where the ip in the log-login table was being stored backwards.
|
19 年 前 |
 toms
|
c0f0a50c79
Fixed syntax error in 'guild' create table statement
|
19 年 前 |
|
skotlex
|
ee59874725
- Fixed yet again AS_SPLASHER doing full damage on all characters. Now you 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.
|
19 年 前 |
 DracoRPG
|
f6d32063cf
SQL fix for Homunc skills
|
19 年 前 |
|
DracoRPG
|
15dd140846
Orn's and Albator's Homunculus system, finally, YAY!!
|
19 年 前 |
|
skotlex
|
5251ce7944
- Fixed the char table having party/guild_id as smallint when they need int there. Thanks to hermematon for pointing it out (use svn_ugprade7580.sql)
|
19 年 前 |
 Euph
|
c897622a1d
sql optimizations.
|
19 年 前 |
|
skotlex
|
e74e095778
- Fixed main.sql adding a key on char_id rather than account_id for the char table.
|
19 年 前 |
 Lance
|
19e8dde400
Syntax errors :(
|
19 年 前 |
|
skotlex
|
e4fb5dbbf7
- Updated mob_db.sql and item_db.sql to latest.
|
19 年 前 |
|
Lance
|
15194233b8
[Improved]:
|
19 年 前 |
|
skotlex
|
078cab13fd
- Fixed loginlog definition in main.sql, thanks to Tempesta
|
19 年 前 |
|
skotlex
|
317b980ace
- Fixed the definition of the KEY in the loginlog, thanks to TheUltraMage
|
19 年 前 |
|
skotlex
|
26a517cd08
- Fix on pc_skill which fixes overlapping when one gets more than one bonus for the same skill.
|
19 年 前 |
|
skotlex
|
f7884c6c52
- Fixed the average_lv column size specification. Thanks to Joshuaali (upgrade_svn5607.sql)
|
19 年 前 |
|
skotlex
|
c606e4de69
- Some cleaning of the main.sql file
|
19 年 前 |
|
skotlex
|
d0c9123432
- Added an upgrade_svn file to fix the party sql table (it lacks the auto-increment property on the party_id column)
|
19 年 前 |
|
skotlex
|
dcd7d940b0
- Updated the login/char sql servers to let the sql tables autogenerate the new id, and then retrieve said id using mysql_insert_id rather than playing smart and loading the next insert ID on startup.
|
19 年 前 |
 Valaris
|
2178a86317
AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO INTO TRUNK.
|
19 年 前 |
|
Valaris
|
fd99753f8e
Clearing trunk.
|
19 年 前 |
 (no author)
|
0ff0152526
Added a auto increment 'start' value in the main.sql file ^^[Sirius]
|
20 年 前 |
 codemaster
|
18332401e0
Added a friend0 column
|
20 年 前 |
 amber
|
2ab9272cf8
removed a USE that should not be there
|
20 年 前 |
|
amber
|
d479e29aee
Fixed some file types
|
20 年 前 |
|
(no author)
|
706e785091
|
20 年 前 |
