summaryrefslogtreecommitdiff
path: root/src/char_sql/char.c
AgeCommit message (Collapse)AuthorFilesLines
2006-12-20Fixed #endif instead of #elseKarLaeda1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9542 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-20- Fixed the #if -> #ifdef mess up -.-skotlex1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9540 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-20- Moved PACKETVER to mmo.h, and added support for the expanded character ↵skotlex1-2/+20
info window on the char-server when PACKETVER is above 7. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9539 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-05- Massive EOL normalization & 'svn:eol-style native' flag setting for all ↵FlavioJS1-4435/+4435
txt/conf/h/c files. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9410 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-04- Fixed the txt->sql converter not escaping character names before saving them.skotlex1-2/+5
- Fixed a pet's level not resetting to their db level when you enable pet leveling and later on decide to turn it off. - Fixed a bad initialization in pc_setnewpc - Fixed restricted equipment not updating your view info after they are unequipped. - Removed a bunch of extra text/checks when ignoring characters (/ex) when Aegis does none of these checks. /inall now wipes your ignore list (it does this on Aegis, too). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9400 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-01- Fixed txt-converter compilation. skotlex1-2/+2
- Added my_global.h include to login converter - Removed sd->char_id since we can use sd->status.char_id instead. - Small speedup in STRECOVERY, and made it not unlock a mob's target. - Fixed GS_GROUNDDRIFT consuming ammo when it's time expires (so it was consuming 2 grenades instead of one). Also added a "explosion effect" when their time runs out. - gvg_dungeon mapflag won't set pvp related mapflags anymore, pc_dead will force pvp ranking gain/loss on gvg_dungeon maps now. - Now when coming out of hiding land-effects will trigger on the character. - Made the pc_setpos message when being placed on an unwalkable tile tell you which player triggered it. - Fixed land effects not taking effect inmediately on map-load when the invincible timer is disabled. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9374 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-24- Added all the missing FIFOHEADs in the login/sql servers (required for ↵skotlex1-143/+163
TURBO support) - Fixed the fact that the TURBO code breaks when you attempt to handle more than one connection at a time within the same function. However this broke map-server compilation, therefore, don't use TURBO yet! It needs more fixing (and I need more time to fix it) - While at it, cleaned a few packet implementations in the char/login servers which were not only ugly, but had some really stupid flaws within (stuff like escaping a string, and then using the non-escaped variable to insert to SQL? T_T) And will someone explain me why the TXT servers are coded much more cleanly, and without such horribly broken code as I find in the SQL ones? T_T; git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-07- Applied FlavioJs's patch which enables colored console output for Windows ↵skotlex1-0/+2
systems. It also includes a config setting called "stdout_with_ansisequence" with which you can turn off the color codes (in case you are logging all output) - Added error reporting when the max number of ground unit cells has been reached (this may be the reason why sometimes it fails to recognize when you step out of a song/dance/encore) - Added passing the Endure effect to other devoted people. Note that the "hit count" is individual for each character, and only when it ends on the Crusader himself will that force it to end on everyone else. It also will not transfer on gvg grounds, but it does transfer in pvp. - Fixed Reflect-Shield triggering Auto-Guard instead on devoted chars. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9168 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 ↵skotlex1-3/+3
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-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-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-09-30- Rewrote the txt->sql converter. It now links directly to the char server ↵skotlex1-91/+49
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-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-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-08-30- Fixed char-sql compilationskotlex1-0/+4
- 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-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-14- Fixed script engine allowing scripts to set a player's zeny to negative ↵skotlex1-1/+3
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-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-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-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 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- 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 and Albator's Homunculus system, finally, YAY!!DracoRPG1-4/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7706 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-10- Fixed check_connect_login_server check in char-sql server. Fixes ↵skotlex1-1/+1
char-server not reconnecting to the login server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7605 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-10- Fixed SQL compilation of the char-SQL server... (I need SQL installed at ↵skotlex1-5/+2
work ~.~) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7602 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-10- Added login-char packet 0x2737. Sets all characters offline (login-server ↵skotlex1-136/+76
side). - Cleaned up char server "set all offline" implementation to remove only characters from the map-server from which the packet was invoked. It will also now correctly kick/set-character offline from the map-server if they are connected. - Cleaned up the char-sql reconnect code. It no longer sets everyone to offline. - Removed setting "kick_on_disconnect", servers will no longer kick characters out when there's a disconnection. Instead, it'll use the most logical approach: Set characters into a "lost" state when there's a disconnection, on reconnect, resent the list of online-characters, do a sync, and let the difference be characters to be removed. Also, the map-server won't release character data until it's saved and the ack returns from the char-server to prevent data loss (all this data is resent on reconnect for saving anyway). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7600 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-07- Okay, added a chrif_save_ack packet to the char-server so now the map ↵skotlex1-1/+7
server will know once a character was "final saved", and only then the character will be removed from memory. On char-server reconnection, all chars that are in final-save state are resent to save (if they are still in memory, it's because the ack hasn't gotten here from the char-server). This should effectively block all dupe problems due to heavy inter-server lag, however as it's untested, it currently prints some debug messages when people are saved and then removed from memory. Need testers so this can be debugged and merged to stable! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7568 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-07- Now, when the login-char connection is cut, the char-server won't set ↵skotlex1-2/+11
everyone offline on reconnect, instead it will send the list of online accounts to the login server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7563 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-07- Modified the error on the char-sql server to set chars online when it ↵skotlex1-2/+7
receives a save packet from a character tagged as offline. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7561 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-06- Modified the party_data structure on the map server to remove some ↵skotlex1-0/+45
redundant data. Added a party_data structure on the char-server to hold a more complete set of information about parties. Added to the party_member structure the class of each member so that the map server can do the appropiate checks even if the character is on another mapserver/offline. Due to the format changes in the party structure, txt servers will have to wipe their party file... (sql save format has not been changed) - Added function char_family to check if there's a family state given the three character ids, instead of doing individual checks all the time. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7553 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-04- Fixed code using i instead of id in a few instances when updating char/map ↵skotlex1-1/+1
server IP. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7510 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-03- Char-server SQL won't perform the reconnect cleanup routines when ↵skotlex1-0/+3
kick_on_disconnect is disabled. - Renamed summons_inherit_effects to summons_trigger_autospells as the setting now only makes the attacks of the slaves trigger the autospells of the master (as it should be). - Corrected code capping no_spawn_on_player to 50 when the max should be 100. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7459 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-27- Cleaned up the IP sync code to...skotlex1-40/+38
- Use charif_sendallwos rather than manually altering the buffers of each server. - Use the id variable for identifying current char-server instead of scanning the connected servers for it (it's doing the same work twice) - Added config setting sync_ip_interval to specify how long to go before updating ip. Defaults to 0 (disabled) - Sending ip update packets will only be done when the ip changed now. - Removed dns_str variables, and now char_ip_str/login_ip_str/map_ip_str will hold the unresolved dns address (as these variables have no use otherwise) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7360 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-22Typos resolving login-DNS instead of char-DNS -.-Lance1-7/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7291 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-22* [Fixed]: Lance1-2/+2
- Compilation warnings and errors. [Improved]: - Changed and moved IP sync status messages to elaborate more. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7290 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-22- Tested and fixed resolve_hostbyname.skotlex1-57/+38
- Applied said function around most of the code where needed. Removed includes for the OS/network system pretty much from every file (our socket.c file should handle this) - Added clif_getip_long, which returns the ip as a long. Prevents having to include the files to define the int_addr structure in all files that include clif.h - Made the GM mute request bypass the manner_system setting. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7285 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-21* [Added]: Lance1-0/+38
- DNS (WAN) sync for those pesky disconnections (dynamic ip renewal). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-19- Fixed the compilation errors of my last commit... >.> <.<skotlex1-8/+8
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7249 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-19- Removed the mysterious array of two of char_dat (char/sql server), ↵skotlex1-113/+101
replaced it with a static structure. - Added function char_loadName to extract the character name of a given ID. - Fixed fame-list updating crashing char-sql server when the given char-id just got into ranking. - Sorry I didn't check if it compiles cleanly because I don't have sql here <.< (am gonna test it in a second, though) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7248 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-19* [Fixed]: Lance1-1/+1
- Typo in parse_frommap. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7240 54d463be-8e91-2dee-dedb-b68131a5f0ec