Commit graph

88 commits

Author SHA1 Message Date
shennetsind
2967335cb4 Fixed Bug #7127
Also Implemented allow party invitations state.
Implemented saving of client options (atm show_equip and allow party invitation)
http://hercules.ws/board/tracker/issue-7127-view-equipment/

Signed-off-by: shennetsind <ind@henn.et>
2013-04-15 23:27:29 -03:00
shennetsind
889a866e92 Introducing Slot Change feature
Special Thanks to Yommy for providing the packet structure/data.

Signed-off-by: shennetsind <ind@henn.et>
2013-03-27 15:38:32 -03:00
shennetsind
d2d734ce09 Hercules Renewal'd Pin Code
Feature is not, I repeat, NOT complete. the decryption is not fully functional which leads to dial values  different from the ones the player used.
Credits:
lemongrass3110 for the base
yommy for the packets
LightFighter for the decrypt function (altho its not stable :P)

Signed-off-by: shennetsind <ind@henn.et>
2013-03-09 00:04:28 -03:00
shennetsind
bafe9ad228 Followup 0241d01955
git's commit-per-line thing fooled me, it skipped this line.

Signed-off-by: shennetsind <ind@henn.et>
2013-03-04 22:27:09 -03:00
shennetsind
0241d01955 Introducing account-dependent character slot count
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/

Signed-off-by: shennetsind <ind@henn.et>
2013-03-04 22:22:30 -03:00
shennetsind
4ce4adceac Updated main.sql to reflect the latest sql_updates entries
Signed-off-by: shennetsind <ind@henn.et>
2013-02-16 20:35:36 -02:00
shennetsind
651d6857d7 MySQL Update Checker: Updated
Added a primary key to the `sql_updates` table (special thanks to Trojal)
Modified the parser to ignore new/empty lines and added support for "//" comments in the index file.

Signed-off-by: shennetsind <ind@henn.et>
2013-02-15 18:15:57 -02:00
shennetsind
2bc85620e0 Fixed Bug #5018
Skills granted through scripts are now permanent, until this date they were not relog persistent

Signed-off-by: shennetsind <ind@henn.et>
2013-02-14 17:18:11 -02:00
shennetsind
810ba40b78 Introducing MySQL DB Update Checker
First version.

Signed-off-by: shennetsind <ind@henn.et>
2013-02-14 17:15:36 -02:00
akrus
bb61951098 Getting rid of unused indexes.
Source: http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3).
2013-02-04 14:13:38 +04:00
markzd
5d1712c148 * Renaming variable name from nsiuid to unique_id for better understanding of its meaning, as requested on tid:69380.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08 05:31:06 +00:00
markzd
cf31e4f05b * Follow Up: r17080
1. Removed an unnecessary update call.
   2. Implemented interreg table at main.sql.
   
* Follow Up: r17077, r17072, r17065
   1. Fixed bugreport:7078, removed unnecessary checks.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07 06:01:48 +00:00
markzd
24987d8513 * Implemented Unique identifier for Non stackable items. (tid:69380)
* Set as off by default, it can be changed in /src/config/core.h.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07 05:13:54 +00:00
euphyy
a691c52d01 * Custom Quest Shop updated to v1.6, which adds support for bulk purchases.
* Follow-up r17014, fixed a typo in main.sql -- credits to Jeroen for finding that.
* Follow-up r17039, missed a parameter -- thanks, clydelion/mkbu95!

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17040 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-24 02:56:49 +00:00
rud0lp20
97166dfb92 Happy Holidays and Happy 12/12/12 :)
Update Elemental summon to its official behavior
  - Fixed missing skill features of Ventus(bugreport:6792,bugreport:6723,bugreport:6511)
  - Note: upgrade_svn17014.sql
  - And other elemental skills are to follow :)
Fixed bugreport:6889 updated const.txt where it cause error to some items.
Fixed bugreport:6999 where matk damage deals miss atk to plant type targets.
Fixed status calculation where it doesn't give accurate result or how official calculation does.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17014 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-11 17:20:44 +00:00
shennetsind
cd07da122c Follow up r16663 added missing column to main.sql, superspecial thanks to EvilPuncker for pointing out.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16664 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-18 14:25:26 +00:00
euphyy
b6db5047e4 * Moved RE coordinates of Bullet/Magazine Dealers in Izlude, bugreport:6410
* Added "favorite" column to main.sql file, bugreport:6425 (sql-files\main.sql)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-07 18:47:08 +00:00
kenpachi2k11
b35718cad2 Made field name in char table unique to prevent 3rd party tools from making our data messy. (bugreport:5587)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16490 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-24 10:30:54 +00:00
brianluau
6c98217932 - Fixed a SQL error from r15885. (tid:62072)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15896 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-21 02:29:54 +00:00
shennetsind
92249d9f8e Initial support for Genetic, Sorcerer and Elemental Summons. Special Thanks to 3CeAM for the base.
Notice this revision onwards requires you to update your char sql table and add the elemental sql table (check sql-files/upgrade_svn15885_log.sql)
If you step by any bugs, let us know at http://rathena.org/board/tracker/ Thank you very much.
ARRIBA ARRIBA.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15885 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-20 18:05:14 +00:00
kenpachi2k11
21fca59be8 Follow up to r15572: renamed column level to group_id (login table) in /sql-files/main.sql
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-13 20:23:16 +00:00
shennetsind
ce9b9e74f6 Merging RREmu into rAthena -- quite a few stuff yet to be renamed, but we'll get it sorted.
Some of the stuff included in RREmu that is now part of rAthena:
- RE Drop Rate Modifier
- RE Experience Rate Modifier
- RE Weapon MATK
- RE Shield ASPD job-specific penalty
- RE Cast Time
- Renewal-specific item DEF
- 3.1 classes.
- All-New Mounts
- Official Magical Reflection
- And other perks, such as fully-functional @mapflag
also merged eAthena 15006 into rAthena.
For Bugs, Comments and Suggestions: http://rathena.org/board/tracker/

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15009 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-05 20:51:58 +00:00
ai4rei
432ec6db58 * Added support for visible garments/robes.
- For SQL apply upgrade_svn14797.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself.
- This also fixes NPCs not being visible with clients 2011-01-11aRagexeRE+ (bugreport:4865).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14797 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16 20:15:20 +00:00
ai4rei
15a067108a * Updated field weapon in table char to default to '0' (bare-handed) rather than '1' (knife) (follow up to r11696).
- Apply upgrade_svn14796.sql to reflect the change on existing setups.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14796 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16 18:58:26 +00:00
brianluau
e3858c34c1 - Removed extra <TAB> from const.txt
- Changed the card columns in `cart_inventory` table to SMALLINT(11), to match other tables.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14759 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-24 22:51:05 +00:00
ai4rei
2c3da84a90 * Added support for new delayed character deletion.
- Asks for birth date associated with the account and has a waiting time of 24 hours by default (setting).
- For SQL apply upgrade_svn14700.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself.
- This completes support for clients 2010-08-03aRagexeRE and later.
* Updated login sql engine version, missed during `birthdate` addition (follow up to r14672).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14700 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-08 02:36:43 +00:00
ai4rei
7b5a33083c * Added 'birthdate' field to account data. For SQL apply upgrade_svn14672.sql to upgrade table login; for TXT no action is necessary, as it upgrades itself.
- Control panel developers are encouraged to enable players to modify this value, as it is required for new character deletion (2010-08-03aRagexeRE and later, not yet implemented).

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14672 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-01-14 23:38:31 +00:00
ai4rei
44539d3a09 * Removed motd from ragsrvinfo table in main.sql, missed in previous commit (follow up to r14579).
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12 00:58:24 +00:00
Paradox924X
0034a439b7 Expanded range for cached and stored-in-db guild member exp (devotion) from uint32 to uint64. (bugreport:3983)
Capped value when sending to client to INT_MAX to prevent confusion.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-09 20:26:42 +00:00
Inkfish
14cc248332 Added missing sql update file for rename
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-12 00:07:35 +00:00
Inkfish
da17744daf forget to update main.sql
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14037 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-04 11:16:30 +00:00
Inkfish
e9a090774c * 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13963 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-26 06:01:10 +00:00
ultramage
07a0d9df45 Corrected the char table's 'manner' column type to match the type used by the server.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13583 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-15 22:48:22 +00:00
ultramage
63346b0e5f Corrected revision number for the previous upgrade script.
Applied changes made inside the script to main.sql.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13542 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-02-21 10:59:18 +00:00
zephyrus
8d5fe8a256 - Item Rental System.
Script Usage:
- rentitem <itemid>,<seconds>;
- rentitem <itemname>,<seconds>;

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13370 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-16 16:14:30 +00:00
zephyrus
1d4ff1617b - Removed mer_id from main.sql in char table. (Bug Report 2192)
- Removed 13117 sql patch, not necessary anymore.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13197 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-07 10:56:08 +00:00
zephyrus
bb1a4e56b3 - 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13166 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-01 00:03:10 +00:00
zephyrus
c45d93d9d8 - Added column mer_id on char_db
- More mercenary implementations (delete, load, create)
- Some fixes.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13117 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23 14:59:51 +00:00
zephyrus
59b08db5fc - Database structure for Mercenary.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13115 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23 12:14:13 +00:00
ultramage
7e14af8bda Removed 'DROP TABLE' statements from main.sql (bugreport:1714)
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13062 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-10 03:59:44 +00:00
ultramage
a50c6281bb 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13030 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-01 07:05:16 +00:00
ultramage
1624d1d57d 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13000 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-26 20:45:57 +00:00
akrus
4bdd4910f9 * Fixed: replaced TYPEs with ENGINEs in SQL files (for better compatibility, TYPE is a synonym) [akrus]
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12880 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-23 06:40:25 +00:00
Kevin
c3d84f14f1 Forgot to change main.sql to reflect the update to quest_objective table.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12582 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13 22:37:04 +00:00
ultramage
aa9f053bfc Reverted the login table changes from r12464
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12561 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11 07:45:26 +00:00
Kevin
50d90e80f9 New sql definitions for the quest code.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12559 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11 07:24:03 +00:00
Kevin
84f811edfd Char server now loads/saves quest information.
Included table definitions for quests and quest objectives.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12545 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-10 05:35:04 +00:00
ultramage
43cd16d622 Replaced the TYPE keyword with ENGINE in all sql files, because this is the preferred alternative.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04 21:04:47 +00:00
ultramage
d0e954f077 Renamed 'connect_until_time' to 'expiration_time'.
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-04-03 12:46:55 +00:00
zephyrus
8cf1d7db70 - Added the auctiondb structure
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12294 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-05 02:16:34 +00:00