summaryrefslogtreecommitdiff
path: root/src/char_sql
AgeCommit message (Collapse)AuthorFilesLines
2006-10-25- Made the exp bonus settings be adjustable:skotlex1-1/+1
- exp_bonus_attacker: Indicates how much additional exp a mob gives per additional attacker (eg: 10 -> +10%*attacker) - exp_bonus_max_attacker: Indicates at which number of attackers the bonus is capped (eg: 5 -> 5 attackers, so a mob yield the same exp whether 5 or 10 people attack it) - Changed the way the party_even_share_bonus setting works. It now uses a simple linear bonus increase (eg: 10 -> +10%*party member) - The defaults are as explained by Tharis: +25%/attacker, capped at 12 attackers, no party bonus. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9067 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-25final clone maps -> original maps change. also fixed novice grounds map in ↵Lupus1-1/+1
char.c. fixed socked_enchant npc git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9064 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-23- char_family now returns the char_id of the children when previously it ↵skotlex2-14/+19
would return true. - Expanded the family check to work as it should, exp-share-range is respected, and the child is not considered for it (thanks to TheUltraMage for the investigation) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9049 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-23- Removed NJ_TOBIDOUGU adding damage to W_HUUMA weapons which somehow got ↵skotlex1-1/+1
readded. - When nonplayers use Cloaking, it will be forced to level 10 since mobs shouldn't have movement/attack restrictions while walking cloaked. - Should fix a warning in int_homun.c git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9043 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-21- Some minor cleanupsskotlex1-2/+1
- Fixed the Homunc not spawning next to you after receiving it's data from the char-server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9035 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-20- Fixed Charge Atk being able to go through chasm/pits.skotlex2-52/+13
- Moved the homunculus DB information from the player structure to the homun structure. Modified the homunculus creation packets to hold this information during creation, also, all initial values are handled by the map-server, the char server only assigns it a homun ID. - Removed target_id/attacked_id from homun_data as it wasn't really used. - Codes cleanup (removing of commented code mostly) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9031 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-13- Base attack for non players is now calculated as str + [str/10]^2 (it does ↵skotlex1-13/+14
not has +dex/5+luk/5 which players do have) - Fixed the char-sql server trying to read the gms off a "gm_db" config setting stead of "login_db" git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8981 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-11- Cleaned up unitattack, unittalk and unitdeadsitskotlex1-28/+25
- Updated status_get_name to take into account fakename, also cleaned it up. - Cleaned up the char-server code when the last point of a player is not found. First it'll check if there's any mapserver online, and then, if there is, it'll look for the major cities. If this fails, then the player will be told server is closed instead of trying to send him to a "random map". git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8967 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-10- Fixed crash when char-server sends to a "random" map-server online on connect.skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8960 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-04- Modified pc_jobchange so that it automatically removes ↵skotlex1-1/+1
peco/falcon/cart/homun if the new job you are changing to does not possess the required skill for them. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8932 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-30- Rewrote the txt->sql converter. It now links directly to the char server ↵skotlex12-211/+225
files so that it should get auto-updated with any code changes in the later. - The converter will now also convert: account-wide variables, parties, guilds, guild storage and guild castles. At this point the only two things not converted are login-server-wide account variables (##, they belong to the login converter) and homunculus (the SQL save function is messy and doesn't lends itself to be integrated with the converter the way all the other functions are). - Modified the char servers so they are compatible with the converter, the define TXT_SQL_CONVERT identifies sections unique to each char-server mode (this would had been a hella lot easier if both char servers where the same code-base instead of duplicated code <.<) - Updated the Makefiles as per the new compiling requirements for the converter. - misceffect2 will no longer cause the effect on top of the source object when it is the fake npc. - Added check so that Frost Nova doesn't hides hitting animation on targets. - Added the missing brackets around the trade logs condition check, thanks to Coltaro. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8908 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-26- Updated battle_check_target so that non-offensive skills cannot be used on ↵skotlex1-24/+4
a homun except for the homun and it's master. - Steal zeny won't work on treasure chests now. - Small optimization in the dual-wielding check. - Some cleaning in char_sql/itemdb.c git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8875 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-22- Fixed the "map server claims to have char online, but this other map ↵skotlex1-2/+6
server also has it tagged as online" message triggering in some cases where it shouldn't. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8846 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-21- Removed the unrecognized class error messages from pc_mapid2jobid and ↵skotlex1-1/+1
pc_jobid2mapid since these can now trigger normally through the use of the script functions roclass and eaclass. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8833 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-14- Likely fixed "half" of the alliance being saved, which ends up in guilds ↵skotlex1-2/+6
that can attack another, but not viceversa. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8761 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-12- Improved sql-query to check if name already exists when creating new chars.skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8727 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-12- Added manual deletion of sc_data entries when deleting a character (char-SQL)skotlex1-0/+10
- 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-08- Added upgrade_svn8675.sql in case, for some reason, your guild table still ↵skotlex2-6/+2
has the emblem_data field as a 'blob' with "NOT NULL" specified. - Some minor cleanups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8675 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-30- Fixed char-sql compilationskotlex3-16/+12
- Added support for reading the item_db_db inter config settings (char-sql) - Fixed some compile warnings (functions with no arguments should have a (void) instead of ()). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8546 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-30- Added a message to @clearweather stating when climate changes will dispel.skotlex2-90/+116
- Corrected @hidenpc saying that it's command name was "@npcoff" - Updated itemdb reading on the char-sql server so that it reads both item_db and item_db2 files (totally untested yet as I can't compile SQL here x.x) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8545 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-23- Some minor cleanups.skotlex1-3/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8455 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22more typosLupus1-8/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8422 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22field typoLupus1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8421 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22added char deletion condition by BaseLevelLupus1-6/+30
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8420 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-21Fixed SQL-Guild Creation, guild name was escaped 2 timestoms1-2/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8413 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-20Fixed "int format, long unsigned int arg" warningtoms1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8391 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-15- Applied multiple fixes which should take care of making homun save/load ↵skotlex1-1/+1
work on TXT now. - Added Gatling Fever's batk bonus. - Some cleaning in status_damage which should prevent trying to free already free'd pointers when unit_remove_map invokes unit_free (when status_damage was going to invoke unit_free anyway) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8308 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-15Delete homunc's skills from sql when the homunc is destroyedtoms1-9/+17
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-15- Fixed the int_homun.c compilation issue with Char-SQL.skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8300 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-15- Some cleanup of int_homun.cskotlex1-16/+38
- Added homun saving/loading support to char-TXT. Note that this is completely untested, so it may be as good as broken. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8299 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-14- Fixed script engine allowing scripts to set a player's zeny to negative ↵skotlex2-2/+4
values. - Fixed setting hide_woe_damage making even "miss" attacks seem to connect. - Cleaned up pc_getzeny to not require doubles. - When readjusting the fame-list, the last entry's id is also reset (may fix characters appearing more than once on it?) - Some sign/unsigned comparison warning fixes. - Some 'may be used unitialized' warning fixes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8273 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-13- Corrected the mapif_parse_PartyChangeMap function to correctly update ↵skotlex1-7/+16
level-range when someone logs on/off, fixes being unable to set even-share on once it's been broken even when the characters out of range logoff. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8254 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-10- Hopefully fixed family-party-even-share not breaking when a member logs out.skotlex1-0/+5
- Corrected Advanced Jobs HP bonus from 30% -> 25% git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8238 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-09- Fixed the char-server not invoking the party_calc_state function when the ↵skotlex1-4/+5
third party-member is added to a party, hence failing to check for families and disabling even share from them unless all three relog first (state is correctly calculated when party is first loaded). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8197 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-08- Fixed the login-sql server replying to the change-sex packet with the ↵skotlex1-0/+1
wrong gender, causing the char-server to screw-up job-change updates. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8180 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-03Changed atoi to strtoul for guild-experience's fieldtoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8090 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-03Fixed a bug in int_storage.c, temp array doesn't have the good sizetoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8088 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-02Code cleanup & optimization on guild part of char-servertoms1-319/+490
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8059 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-01- Fixed the subnet 0 mask being reset to 0 when someone goes up on the fame ↵skotlex1-3/+3
rankings. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8021 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-30Force all players offline in sql when char-server startstoms1-0/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7977 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27- Removed a redeclared variable i in the parsing of the fame list (char-txt ↵skotlex1-1/+0
server) which seems to be the cause of the random memory corruptions. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7915 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27* Fix homunc & code cleanup [Toms] toms1-1/+1
- Timer problems on delete_timer - Intimacy problem (overflow & new values) - Homunc deleted if intimacy < 0 - base exp is now given to master - Homunc sometimes not saved git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7913 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-20- Applied the fix to homunculus name saving...skotlex1-2/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7777 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-19- Fixed the homun creation sql statement. Why noone else did so before?skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7749 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-19- Corrected Trim chars to block 'enter', as explained by the Ultra mage.skotlex1-1/+1
- When the client passes account version 0, the login server will set it to 1 now. - Corrected the HP bar scaling when HP is above Short Max. It should display fine for any HP value now. - Added a check when the mob's adelay is shorter than the amotion, in which case the adelay will be changed to the amotion value. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7742 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-18- Added atcommand @partyoption, lets you alter the party item-distribution ↵skotlex1-3/+3
type on the go. Usage is "@partyoption <pickup share> <item distribution>", where both arguments can be 0/1, yes/no, etc. - Updated @changeleader and @partyoption to use msg_Athena entries. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7737 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-18- Added character 013 (enter) to the list of characters that are always ↵skotlex1-2/+2
removed from new character names. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7732 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-18- Added a proper check to make aggressive mobs never override homun targets ↵skotlex1-8/+7
regardless of distance. - Removed a bunch of homun-related variables that are not needed at all. The alive condition is removed, now the code checks for the hp value to know if the homun is alive or not. - Cleaned up a bit the skill-id function, homun skill checks (such as delay and skill-lv learned) should be correct now. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7727 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-18- Updated mob_db.sql to current mob_db.txt data.skotlex1-9/+6
- Some cleaning on chrif.c - The char-server will allow off-line character saves when said char is tagged for final-save (this is the scenario when the char-map reconnect). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-17orn's lil fixVicious1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7707 54d463be-8e91-2dee-dedb-b68131a5f0ec