summaryrefslogtreecommitdiff
path: root/src/char_sql
AgeCommit message (Collapse)AuthorFilesLines
2010-11-22* Fixed guild and guild member exp truncation issue (bugreport:4130, since ↵ai4rei2-15/+15
r14242). - Fixed guild member position, hair, hair color, gender, class and level could potentially become corrupted due to shorts being read as ints (partially since r2986). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14487 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-22* Fixed saving/loading errors with compilers (such as VC6, MinGW), which do ↵ai4rei1-2/+2
not recognize %ll format (since r14242). - This also fixes guild leader name being displayed and saved as "(null)" in the guild member list. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14486 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-19* Fixed WFIFOL being used instead of WFIFOW for a short field of packet ↵ai4rei1-1/+1
0x2710 (bugreport:2819). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14468 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-09Follow-up to r14368. Load last_map from SQL on char load so the information ↵Paradox924X1-2/+5
is available during char select for PACKETVER > 20100721. Patch based on Ai4rei's. (bugreport:4429) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14453 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-02Fixed an issue where two ushorts were being strcmp'd. Follow-up to r14442. ↵Paradox924X1-1/+1
(bugreport:4523) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14443 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-02Ensured character data is saved even when last map is the only value that ↵Paradox924X1-0/+1
has changed during save time. (bugreport:2218) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14442 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-02Applied fix by Ai4rei to reintroduce mapName within charinfo packet when ↵Paradox924X1-1/+1
PACKETVER >= 20100803. Follow-up to r14432. (bugreport:4413) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14440 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-10-17Fixed wrong char info packet size for clients after 2010-07-27 (follow-up to ↵Gepard1-1/+1
r14368). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14432 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-10-11Pull `name` from character table instead of using `master` from guild table ↵Paradox924X1-2/+2
when loading guild data. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14417 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-10-11Use `char_id` rather than `master` when checking if a guild needs to be ↵Paradox924X1-1/+1
deleted during character deletion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14416 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-08-03- Merged a few minor bugfixesSkotlex1-0/+4
- Merged in a bunch of the eA renewal support patch. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14368 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-01Replaced all occurrences of 'leaved' with 'withdraw'.Paradox924X2-7/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14319 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-04-23Merged a few updates for supporting renewal clients (thanks to Diablo): ↵skotlex1-3/+11
[Skotlex] - Updated packet_db entries - Added slot info on packet 0x6b (PACKETVER > 20100413) - Trade add-item use packet 0x80f (PACKETVER > 20100223) - Guild storage add-item use packet 0x1c4 (PACKETVER > 20090603) - Vending list use packet 0x800 (PACKETVER > 20100105) - Allow client to change item-share party settings (PACKETVER > 20090603) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14286 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-03-02Fixed an exploit where the buyer can end the auction himself.Inkfish1-0/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14255 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-09Expanded range for cached and stored-in-db guild member exp (devotion) from ↵Paradox924X1-2/+2
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
2009-12-03Prevented online user count from going negative. (bugreport:3913)Paradox924X1-2/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-24Cleaned up leftover PACKETVER define on the charserver (followup to r14155).ultramage1-6/+0
Expanded the error message in guild_castledataloadack() to actually provide some useful info. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14168 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-19- Applied the renewal client support patch from Diablo (eA forum topic 222623)skotlex1-10/+40
- Added support for strcharinfo(3) to retrieve the player's map - Added script command "searchitem" for name item searches. - Moved PACKETVER to src/common/mmo.h as it's needed by the char-server now - Changed the status valX from int to long so that it won't break for pointer-storage in other architectures. - Moved the change party leader code to party.c - A few bugfixes or packet field completions based on my past experience messing around with my server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-15Removed unnecessary use of StringBuf in int_quest.c to avoid memleaks in ↵ultramage1-16/+2
certain cases. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14148 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-03Extended broadcast implementation:Gepard1-10/+16
- support for font formatting, like font-size - `bc_woe` flag to allow client-side filtering of WoE announcements - new broadcast packet 0x40C git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14120 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-27Fixed quest will never get erased when it's the only quest you have.Inkfish1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14105 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-18Removed the char_rename setting in favor of a PACKETVER define.ultramage2-14/+16
Inverted the way renames are counted: '0' now means 'no renames left' (the default). Please make sure your database matches this new behavior before starting the server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14093 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-12Removed 'char_max_rename', extended 'char_rename', fixed compatibility issues.Inkfish1-28/+15
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14089 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-12Fixed an error when 'char_rename' is set to 'no'Inkfish1-6/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14088 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-11Added character rename function.(topic:225576)(written by pakpil and fixed ↵Inkfish3-25/+199
by me) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14084 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-10-04- Implemented new packets for rental items (from Jobbie and Natz and fixed ↵zephyrus1-3/+3
by me). - Rental items now can be moved to storage and cart. - Autotrade cannot be used when user is dead, and it's not dispelled if user dies to prevent abuse. - Fixed pc_checkitem to do a proper item check and remove. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14082 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-20Disabled ip checking during auth, since it lead to a lot of confusion.ultramage1-4/+4
This essentially reverts the default behavior to before r10021. Re-enabling should only be reconsidered after the subnet mechanism is made fully automatic. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14069 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-04* QuestLog Fix.Inkfish1-11/+5
- mob id no longer stores in sql. - counts won't increase if you have killed sufficient mobs. * Fixed Merchant's medalion wrong aspd bonus (bugreport:3554) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14036 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-21Fixed the wrong packet length makes client choke when add_quest packets are ↵Inkfish1-24/+17
sent. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14019 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-02* Questlog code cleanup.Inkfish2-54/+51
* Fixed range check of autospell and autospell2 using wrong target when it should be used on yourself. * Implemented official behavior of party_show_share_picker. * Restricted zones in 'item_noequip.txt' can now stack. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13987 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-28* Some more updates to Quest LogInkfish3-63/+67
- Implemented a new saving mechanism. Now they can be saved every 'autosave_time' in case the char-server is not online when you get a quest. - Improved 'changequest' code. - Increase MAX_QUEST_DB to 1200. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13973 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-26* Some updates of Quest Log systemInkfish1-1/+1
- 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-25Fixed undeclared variables on charserv compiling. how careless i am.....Inkfish1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13961 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-25Rewrote Quest Log system.Inkfish4-61/+62
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13959 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-30Fixed sql char deletion code using a broken pet deletion query (ran very ↵ultramage1-5/+3
slow, and had a typo in a binary shift operation) (bugreport:3304). Fixed change r13774 to the code responsible for deciding whether to move 1 extra cell when stopping walking; it had its logic inverted by mistake (bugreport:3312). Cleaned up the itemlist, cartlist and storagelist gm command code: - fixed buffer overflows in all three functions (bugreport:456). - merged all three atcommand functions into a single one; the appropriate behavior is detected from the command's name. - using the StringBuf class instead of static-size buffers and string operations for more efficient and safe processing. - using 'jname' (the one without underscores) as the primary item name in the list, and not using the aegis name for cards at all (since it's almost identical). - fixed forged item details never being displayed due to a missing strcat(). - extended item info (crafted/named items, pet eggs) will now be displayed for storage and cart list as well. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13920 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-16Fixed an exploit that makes guild skill get higher level than the max ↵Inkfish2-4/+4
defined in guild_skill_tree. (bugreport:3241) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13894 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-02svn:eol-style native for char_sql's int_mercenary code (missing in r13166).ultramage2-241/+241
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13715 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-04-01* Removed online_check config options. (always active now)FlavioJS1-46/+52
* Clarified char_maintenance config option. * Changed packet 0x2712. (added request_id) * Changed packet 0x2713. (added sex, request_id, version, clienttype; removed email, expiration time, gmlevel) * Delayed user count check and mmo_char_send006b to when the account data arrives. * Created auxiliary function MD5_Salt. (split from a future commit that was getting to big for my taste) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13652 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-02-20Increased variable size for status/skill points to remove the 65k cap ↵ultramage1-4/+4
(bugreport:1579). Added sql upgrade script to adjust the appropriate char table columns. This is an enhancement to r5762. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13541 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-01-05Moved the 'changed' mailbox flag from shared mmo.h to mapserver-only.ultramage1-1/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13433 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-17followupultramage3-2/+5
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13374 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-17- Some "expire_time" = 0 considerations. Please update. (Bugreport 2451)zephyrus2-0/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13373 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-11-16- Item Rental System.zephyrus1-34/+41
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-06* Fixed 'Char creation denied' message not being sent properly.FlavioJS1-1/+1
- Number 2 didn't exist in old clients so it used the default message, now it exists so the wrong message is displayed. - Changed 2 to 0xFF to get the default message. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13356 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-10-15- Added the required changes to support the 2008-09-10+ clientsskotlex1-7/+10
- Cleaned around the char set offline function to properly avoid setting offline a character that had relogged faster than the map server's packet arrival to the char-server (I presume this was the bugfix that Kevin attempted a long time ago, but the current code for that causes a dangling pointer problem). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13293 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-10-03* Fix for "yet another online check bypass technique". (bugreport:2292)FlavioJS1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13256 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-28Fixing the txt-char converter compilation (bugreport:2171).ultramage1-0/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13245 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-02- Fixed problem deleting characters.zephyrus2-12/+10
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-09-01- Moved char server's mercenary code to a different file (int_mercenary.*)zephyrus7-170/+291
- 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-08-31- A proper mercenary lifetime calculation.zephyrus1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13165 54d463be-8e91-2dee-dedb-b68131a5f0ec