summaryrefslogtreecommitdiff
path: root/src/char_sql
AgeCommit message (Collapse)AuthorFilesLines
2006-04-16- Fixed char-sql server still reading the old lanconfig format rather than ↵skotlex1-7/+10
the new one. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6123 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-16- Fixed mysql ping setting being in minutes rather than hours.skotlex1-2/+2
- Removed npc_event_sub from npc.h and moved it to npc.c - Cleaned up #warp to prevent spitting non-walkable tile warnings. - Changed the meaning of msg_athena 2, it is now "invalid target cell, randomizing". git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6114 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-13- Added an Info message when pinging the SQL servers.skotlex1-0/+1
- Changed line terminators back to *nix on map.c because otherwise it's impossible to run a diff between the stable and trunk versions of the file. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6043 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-10- Updated the subnet support to not require specifying the subnet mask, it ↵skotlex1-1/+1
is auto-acquired from the char/map IP and the subnet-mask. - skill_wall_check defaults to yes now. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5976 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-05- Added inter config connection_ping_interval which specifies interval in ↵skotlex3-22/+41
hours at which mysql_ping's must be done on all connection handles to keep the mysql connection alive. Defaults to 0 (disabled) - Removed login sql handle from the map server as it isn't used for anything. - Made the login sql handle on the char-sql server be used only when gm_read_method 1 is enabled. - Small fixes to npc_enable, added BL_NPC handling on status_get_sc. - Added a path_search check in map_random_dir, so that the random direction picked up doesn't goes through walls and all that. - Some changes to close-confine, status start will fail when the source is not found or it doesn't has sc-data. - pc_setoption no longer changes the character's class when mounting/dismounting, it only changes the view-class. - The peco-crash-fix from the char servers is still needed. This packet must be wrong! We likely need to sniff it. - Modified the char-txt server to modify the class of mounted characters to their non-mounted version. Added an upgrade_svn file to handle the class update on the sql tables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5902 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-01- Added a check to remove exp-even-share when someone leaves a party.skotlex1-0/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5855 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-27- Changed status_point/skill_point to unsigned short. Adjusted the code as ↵skotlex1-27/+27
necessary to prevent overflows. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5762 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-21warning msg typos fixLupus1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5692 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-17- Fixed handling of the char_gm_read config for packet 0x2af7 (reloadgmdb)skotlex1-9/+7
- Added battle_config debuff_on_logout which removes Asura's SP regen delay and Strip-Equip effects on logout when set to yes (default). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5644 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-13- Corrected char-server parameters so that the subnet config file is the ↵skotlex1-1/+1
third parameter, not the second (which was conflicting with inter_athena.conf's argument), thanks to foobar. - Fixed TK and Soul Linker's position of their job entry in exp2.txt, thanks to Coltaro. - Fixed NPC_GRANDDARKNESS targetting the enemy instead of yourself in mob_skill_db. - Fixed Grandcross's hit and range entries in the skill_db (it had hit 5? that wasn't even a valid value from the description) - PR_BENEDICTIO now ignores mdef - Removed the status_isdead checks from status_check_skilluse, they are now done only on the skill_castend_* functions. - Fixed NPC_SELFDESTRUCTION not doing the correct damage to oneself. - Fixed chatlog's x/y column capacity. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5584 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-04- Fixed a bug on the last fix :Pskotlex1-1/+1
- Removed some of those annoying login-SQL on-log messages that are totally useless. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5459 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-04- Fixed subnet checking being broken in the login txt server.skotlex1-4/+4
- Changed a bit the information of the subnet checking to include the ip that is being checked. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5458 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-03* Fixed character deletion working on SQL without an email address (Thanks ↵Zephiris1-0/+1
to Valaris) [Zephiris] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5449 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-02- Fame list size is now defined by MAX_FAME_LIST constant (mmo.h)skotlex1-6/+29
- Char server can now specify the max size for blacksmith/alchemist/taekwon rankers. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5435 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-01* Corrected a few Compiling Warnings [Codemaster]codemaster4-5/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5405 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-01* Added the ability to select GM loading via Login (default) or Char ↵codemaster1-25/+70
[Codemaster] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5404 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-28Rewrote LAN support code. Changed configuration file name lan_support.conf ↵LuzZza2-57/+78
to subnet_athena.conf, changed it syntax. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5398 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-23- Modified the way autospells stack to mimic official servers. Cards of the ↵skotlex1-1/+1
same ID cannot stack, but different cards with the same skill can each trigger indepedently of each other. - Added battle_config autospell_stacking to enable stacking of cards of same ID. - Moved card-specific battle options to items.conf - Autospells triggered when hit will check the range to the target. - Some cleaning up of status_calc_pc - In status_change_start capped the passed success chance to 100% git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5377 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-20- Added back the char-sql server sending the GM list when the map server ↵skotlex1-3/+2
connects. - Fixed a bug in the add_timer_interval error reporting. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5351 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-17- Char-SQL: Removed the ridiculous check for existing party/guild each time ↵skotlex4-86/+51
a character is saved. The check should be done upon loading (when the guild/party is not found, the char's party/guild id is set to 0 THERE) - Removed the 'Quick loaded char' messages from the char-sql server - Some cleaning of the guild sql saving routine. - Various checks around the char-SQL server and a few memory leak fixes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5309 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-17- Fixed the memory leak on opt_2str as pointed out by End of Examskotlex1-3/+8
- Fixed a few char SQL memory leaks as pointed out by End of Exam git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5307 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-16- Updated the login/char sql servers to let the sql tables autogenerate the ↵skotlex11-310/+110
new id, and then retrieve said id using mysql_insert_id rather than playing smart and loading the next insert ID on startup. - Tables affected are: account creation, char creation, party creation, pet creation and guild creation. - Also corrected some functions to be of type (void) rather than () git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5298 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-15- Fixed the char servers to store correctly exp as uints. They are also ↵skotlex1-11/+17
capped to LONG_MAX before being sent to the client. - TK_DODGE now dodges all ranged attacks, when used with SPURT, dodges everything. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5289 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-08- Fixed Char-SQL server setting up the save/last point to the novice grounds ↵skotlex1-2/+2
when either x, y or the map is 0. - Commented the char server setting up Prontera as default point when there's none (this bug should not exist) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5218 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-07- Fixed sql compile.skotlex1-6/+4
- Some small adjustments on how the user/password in the char server are read. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5207 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-06- Fixed sql compile.skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5205 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-06- Added define clif_deadsit to send the dead state into player packets if ↵skotlex1-3/+4
the player is in trick dead state. - Venom Splasher always hits (but splash damage targets can still avoid it) - Using autoloot with no arguments now toggles it between @autoloot 0 and @autoloot 100% - Falcon Assault now takes Blitz Beat lv5 as base damage. - Fixed pc_makesavestatus not updating status.option correctly. - Corrected Waterball so that higher levels can do insane amount of hits. - Altered slave behaviour. No more random walking, will stay within 2 cells of their master. - Reverted the Summon Slave behaviour to not adjust level based on number of current slaves. - Coma no longer sends SP to 1. - Updated Meteor so that when level 11 or more is casted, the area over which meteors fall is tripled. - Dark elemental characters are now inmune to Curse. - Fixed sc_data saving to sql buffer building method. Thanks to its_sparky. - Changed the map zone reading from using pow to a bit shift. - Experience has now been changed to unsigned int, and is read as such from the dbs. - Increased HT_DETECTING seek range to 7x7 - Added function map_foreachinrange which actually checks distance of nearing objects (unlike for each in area which uses a square area), may come handy for future code. - Corrected Venom Splasher: Being hit does not cancels it, works at 75% or less of target's HP, being hit normally while under the count has a chance of causing poison. Damage is +400% + 50*lv% git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-01- Map and char server now will complain if they are run using the default ↵skotlex1-0/+6
user/password set. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5158 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-30- Some compile warning fixes.skotlex1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5123 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ↵Valaris16-0/+9120
GO INTO TRUNK. IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EVERYTHING ELSE GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29Clearing trunk.Valaris17-8112/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5091 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-04-05* Simplified Valaris' online_timercelest1-11/+12
* Updated Fogwall, Spiderweb, and HP Conversion * Adding saving character online/offline for TXT char and login (unfinished) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1411 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-04-04* Removed anti-freeze system for login and charcelest1-44/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1396 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-04-03fixingshinomori1-1/+8
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1390 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-30* Fixed @reloadgmdb in SQLcelest4-12/+27
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1344 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-29* Fixed SQL char server crashing when loading the item_dbcelest1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1336 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-29* Added auto save guild dataevery 5 minutes during WOEcelest1-12/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1333 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-29Fixe compile time problems with our mixed C++/C conformanceamber4-8/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1328 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-29Fixed use of storage variable to conform to ANSI C spec [MouseJstr]amber1-46/+46
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1327 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-29* Fixed 'use_sql_db' not read properly in SQL char servercelest1-8/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1317 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-28git-svn-id: ↵veider3-15/+95
https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1316 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-23memory bugs fixedamber1-0/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1278 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-23Fixed compile warningcelest1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1276 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-23* Fixed alot of memory leakscelest11-1/+78
* Added stray memory cleaning routine to db.c git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-18* Don't log SQL char actions if log_char is not enabled in char_athena.confcelest1-19/+25
* Updated shop_exp's calculation to give more exp * Some item and mob DB updates * Added Einbech/Einbroch warps git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1249 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-18Fixed SQL compile errorcelest1-4/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1247 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-17* Fixed more typos in /cities/payon.txtcelest1-0/+87
* Added 2 char-server packets to support Freya's login server * Rewrite on Full Strip git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1243 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-08Speedup inventory and storage savingcelest3-314/+131
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1210 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-03SQL: Castles data saving bugfix (fully working! tested during WOE on 100 ↵Lupus1-37/+19
players, 19 guilds) added 2 bugreports git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1201 54d463be-8e91-2dee-dedb-b68131a5f0ec
2005-03-02partial SQL Castles Saving (doesn't clear GuildID when you abandon a castle yet)Lupus1-41/+60
added 2 fixex by Pow (max positions, max guild members) fixed Moving HP quest (added missing delitem) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1199 54d463be-8e91-2dee-dedb-b68131a5f0ec