Mirroristas/rathena
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
18,420 Commits 66 Branches 0 Tags 560 MiB
Commit Graph

1652 Commits

Author SHA1 Message Date
Inkfish
816e93ef9b Fixed mob counts and quest states are not saved properly sometimes 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13964 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-07-26 09:52:08 +00:00
Inkfish
4a6f0d122c * Some updates of Quest Log system 
- renamed table 'questlog' to 'quest' to avoid misunderstanding
- updated main.sql
- fixed the server can't load more than 16 quests
- removed the MAX_QUEST limit. tests show the client can handle more than 100 quests.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13963 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-07-26 06:01:10 +00:00
Inkfish
153c9f5c5c Fixed undeclared variables on charserv compiling. how careless i am..... 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13961 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-07-25 21:09:25 +00:00
Inkfish
ea229fd7e0 adding the sql update I forgot... 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13960 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-07-25 21:02:17 +00:00
brianluau
973a96f9aa - Added mosk_que to the mapcache (follow up to r13903). 
- Fixed some input checks and variable types in Megingjard quest.
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13926 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-07-02 18:56:16 +00:00
brianluau
0949ac0d1a - Updated SQL item/mob databases to latest. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13908 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-23 00:15:39 +00:00
brianluau
7b835b0b4e - Changed some variables to scope instead of permanent char. (bugreport:3248) 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13890 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-15 03:38:20 +00:00
Inkfish
a936c021c7 * Fixed TaTaMiGaEShi(Improvised Defense) not working. 
* Implemented new cooking success formula. Now cooking experience starts at 0.(bugreport:2439)

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13881 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-11 13:29:43 +00:00
brianluau
39d6aac90c - Fixed item ID of Pickaxe (should be 6010). (bugreport:3214) 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13862 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-08 12:51:33 +00:00
brianluau
5f6e8fceee - Updated item_db.SQL to latest. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13848 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-05 18:34:54 +00:00
brianluau
00d3f8e966 - Removed some extra spaces in item_db.txt 
- Removed extra spaces in item_db.sql so it matches the TXT version.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13847 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-06-05 18:31:30 +00:00
ultramage
bae7ecf012 Reverted the "The md5() of their kafra code is now stored in #kafra_code$" 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://svn.code.sf.net/p/rathena/svn/trunk@13729 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-05-04 12:29:54 +00:00
brianluau
53998c9f3d * Added the md5() script command. (follow up to r13719) 
- Changed kafra storage password to be stored as md5 hash in #kafra_code$.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13728 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-05-04 08:22:53 +00:00
jmanfffreak
072ee7a90b Updated item_db.sql and mob_db.sql from recent changes to both. Thanks to Peter once again! 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13726 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-05-04 01:25:17 +00:00
brianluau
791429c7b0 * Removed the obfuscation of the #kafra_code password. (bugreport:2323) 
TODO: add a 'md5()' script command and use that instead.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13719 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-05-03 04:30:20 +00:00
Playtester
94a411d8e5 * Updated item_db.sql with the perl script 
* Added missing changelog entries about Moscovia mob changes

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13597 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-03-18 16:47:37 +00:00
jmanfffreak
8f9f43d206 Updated mob_db.sql to latest, thanks to Peter for his auto builds of the db's. [Jguy] 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13595 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-03-17 23:05:36 +00:00
ultramage
5ec23576c6 Corrected the char table's 'manner' column type to match the type used by the server. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13583 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-03-15 22:48:22 +00:00
ultramage
e362a5ce6f Corrected revision number for the previous upgrade script. 
Applied changes made inside the script to main.sql.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13542 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-02-21 10:59:18 +00:00
ultramage
c2cc0763d9 Increased variable size for status/skill points to remove the 65k cap (bugreport:1579). 
Added sql upgrade script to adjust the appropriate char table columns.
This is an enhancement to r5762.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13541 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2009-02-20 19:47:17 +00:00
Kisuka
f2ba968a5e Fixed typo on item script. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13390 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-11-29 23:52:24 +00:00
zephyrus
c830a56da3 - Item Rental System. 
Script Usage:
- rentitem <itemid>,<seconds>;
- rentitem <itemname>,<seconds>;

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13370 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-11-16 16:14:30 +00:00
ultramage
ab77ae1f2b Partially reverted r13197 to maintain consistency with followup sql update. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13200 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-09-08 00:13:18 +00:00
zephyrus
d475f7aaff - Removed mer_id from main.sql in char table. (Bug Report 2192) 
- Removed 13117 sql patch, not necessary anymore.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13197 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-09-07 10:56:08 +00:00
zephyrus
5954733c85 - Moved char server's mercenary code to a different file (int_mercenary.*) 
- New Sql Patch for create mercenary_owner DB.
- Removed mer_id from char_db.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13166 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-09-01 00:03:10 +00:00
zephyrus
e5e14c14fe - Added column mer_id on char_db 
- More mercenary implementations (delete, load, create)
- Some fixes.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13117 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-08-23 14:59:51 +00:00
zephyrus
b6c7de7c00 - Database structure for Mercenary. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13115 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-08-23 12:14:13 +00:00
ultramage
f4c4ccb9c9 Removed 'DROP TABLE' statements from main.sql (bugreport:1714) 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13062 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-08-10 03:59:44 +00:00
ultramage
dac1c2d2df Removed unused guardian hp columns from the guild castles table in main.sql (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://svn.code.sf.net/p/rathena/svn/trunk@13030 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-08-01 07:05:16 +00:00
akrus
4232eaf3d5 * Fixed: added 'E'-type zenylogs in sql table (bugreport:1957) [akrus] 
- added sql file upgrade_svn13025_log.sql


git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13025 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-07-31 07:19:38 +00:00
akrus
0f18041ac7 * Fixed: commented out loginlog in convert engine sql tables (loginlog table is in logs database now) [akrus] 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13019 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-07-31 02:13:20 +00:00
ultramage
f03a7e2413 Corrected upgrade_svn12975_view.sql not assigning default values to the two dummy columns (bugreport:1940). 
Please drop the view and re-run the script.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13010 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-07-29 03:06:58 +00:00
ultramage
106b44c1e7 Merged the /loginmerge branch (topic:192754) 
* 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://svn.code.sf.net/p/rathena/svn/trunk@13000 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-07-26 20:45:57 +00:00
akrus
319d9ced3d * Fixed: replaced TYPEs with ENGINEs in SQL files (for better compatibility, TYPE is a synonym) [akrus] 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12880 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-06-23 06:40:25 +00:00
ultramage
189a9ec34e Typo fix for r12758 >< 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12764 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-06-07 02:54:28 +00:00
ultramage
1aae890f73 Added 'E' type to picklog table's 'type' column (followup to r11721). 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12758 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-06-05 12:51:51 +00:00
ultramage
6b904e34cb Increased the allowed packet size for chat messages. 
Changed the capacity of the message column in chatlog (see sql update).

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12725 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-05-26 11:25:12 +00:00
toms
4f4cb7515f Updated sql files to latest 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12722 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-05-24 11:20:16 +00:00
toms
21c53a83f0 Updated mob_db.sql to latest 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12677 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-05-01 09:43:24 +00:00
toms
bf1e5ff7c6 Updated item_db.sql to latest 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12652 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-25 19:00:22 +00:00
toms
355d69194a Updated sql files to latest 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12630 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-21 21:11:41 +00:00
toms
45a96330d7 Removed all _ in the second name in item_db.txt and updated item_db.sql 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12601 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-15 15:20:09 +00:00
toms
6b035c6f00 Updated item_db.sql to latest 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12597 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-15 08:00:54 +00:00
Kevin
ea96b9da32 Forgot to change main.sql to reflect the update to quest_objective table. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12582 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-13 22:37:04 +00:00
Kevin
302adbf42a Major updates to the quest system. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12581 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-13 22:19:02 +00:00
ultramage
65ea169212 Reverted the login table changes from r12464 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12561 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-11 07:45:26 +00:00
Kevin
e889fc9d62 Changed eol-style to native for these files. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12560 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-11 07:28:27 +00:00
Kevin
a6b57811f9 New sql definitions for the quest code. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-11 07:24:03 +00:00
Kevin
f5fd71f4be Char server now loads/saves quest information. 
Included table definitions for quests and quest objectives.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12545 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-10 05:35:04 +00:00
ultramage
f6a6d34640 Replaced the TYPE keyword with ENGINE in all sql files, because this is the preferred alternative. 
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
 2008-04-04 21:04:47 +00:00