summaryrefslogtreecommitdiff
path: root/src/char_sql
AgeCommit message (Collapse)AuthorFilesLines
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
2008-08-24- Implemented Mercenary Scrolls (item_db)zephyrus1-5/+5
- There are some little problems, like remaining time going to 0, but you can summon it, make it walk, follow you. - Feel free to test it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13126 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-24- Ops!! this is mine (homunculus hungry messages).zephyrus1-1/+1
- Fixed a bug on char delete. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13123 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23- Some stuff i forgot for char_sql. Bug Report 2112.zephyrus1-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13119 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23- Completed Mercenary Create, Delete, Save. Tests OK.zephyrus3-4/+37
- Incremented MAX_SKILL required for a proper load of Mercenary Skills. - Some fixes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13118 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-23- Added column `mer_id` on char_dbzephyrus3-29/+85
- 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- Mercenary Packets (Server to Client). Still need a little more info.zephyrus2-1/+54
- Packet for Mercenary Menu. - Some other progress as creation but need more code. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13116 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-19* Fixed a storage saving issue with txt charserver (bugreport:2084)ultramage1-1/+0
- caused by incorrect idb_ensure -> idb_get change (see r12950) - removed redundant account_id variable from storage data - cleaned up the very messy txt storage handling code git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13093 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-17** Please update your server ASAP. **zephyrus1-1/+1
- Fixed a wrong auth process, setting account offline in Login server when accessing Char server. (OMG!) - Fixed a bug on TK_JUMPKICK. It should only do damage if can reach target. - Fixed bug on Arug_cas01 script. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-04Fixed an ancient sql query typo (bugreport:1979)ultramage1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13046 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-04Added configs for quest table name adjustment (bugreport:1778)ultramage1-0/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13041 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-08-01Removed unused guardian hp columns from the guild castles table in main.sql ↵ultramage1-1/+0
(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-07-31Reverted r12230. cUSTOM_CFLAGS is redundant since you can achieve the same ↵ultramage1-1/+1
result by setting CFLAGS. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13022 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-29Renamed struct 'skill' to 's_skill' to remove naming collisions.ultramage1-1/+1
Added defines for mercenary skill ranges. Added a mapping of mercenary skills to the skill db (700-799 atm). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13012 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-26Merged the /loginmerge branch (topic:192754)ultramage4-342/+46
* 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-26Replaced occurences of '-1' with the more appropriate 'INVALID_TIMER' value ↵ultramage1-1/+1
where appropriate. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12998 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-15Removed the party_share_conflict() check.ultramage1-13/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12959 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-13Modified storage data loadingultramage3-48/+13
* storage is now loaded/saved along with character status * as a consequence, a lot of storage handling code was removed * there is no more locking done within storage data * mapservers no longer cache the data (solves muiltimapserver exploit) * loading storage on char select may decrease charserver performance git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12950 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-10Renamed 'storage_' to 'items' in the storage_data structure.ultramage1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12933 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-10Renamed 'struct storage' to 'struct storage_data' (to make 'storage' ↵ultramage2-11/+11
available as a variable name). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12932 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-09Small cleanup of sql storage code (useless data structure allocation)ultramage1-28/+8
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12927 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-29Random assortment of various small corrections and tweaks.ultramage1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12894 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-19Basic cleanup of the SQL charserver homunculus code.ultramage3-163/+165
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12863 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-29- Fixed bug report 1436 (Auction)zephyrus1-3/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12742 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-16Fixed 64bit timestamps messing up auction/storage (bugreport:1454)ultramage2-6/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12713 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-07- Corrected default guild positions not being saved during guild creation.skotlex1-1/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12690 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-28Cleaned up char server set online/offline/char select functions. ↵Kevin1-5/+10
(bugreport:1359) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12670 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-27fixing some timestamp type difference warnings...ultramage1-2/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-27Removed the calc_times() no-op (bugreport:1289)ultramage2-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12668 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-26Cleaned up auth system after change back to map server request.Kevin1-49/+60
- Created function set_char_charselect to get rid of some of the "special case" variables. - Removed code that involved the char server sending auth data at char select. - Changed char select code to update the instance of the char data in the DB to fix map/sex info not being propagated to auth request. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12658 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-21* Changed the data field of timers from int to intptr.FlavioJS4-12/+12
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12633 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-21Made some cleanup in changesextoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12626 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-17- Some mistake from someone but OMG!zephyrus1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12609 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-16Fixed an issue in r12575 where 'not setting char offline when going from ↵ultramage1-5/+3
mapserver to charserver' also caused a permanent account lockout if the player pressed 'cancel' in the char select screen. Merged some recent changes from SQL to TXT, as someone didn't bother to do it. Ifdefed the quest data request code as SQL-only (this was causing server disconnects whenver someone logged in). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12606 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14* Fixed a possible crash in char_sql. (since r12575, later modified in r12590).FlavioJS1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12593 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14Fixed a memory leak in mapif_quests_fromsqltoms2-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12592 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14Fixed a typo in char_sql/char.ctoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12591 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14Fixed a bug in the disconnection part char-server (not sending you offline)toms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12590 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14Removed some unused variables that appeared in the last commit (r12584).Kevin2-3/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12585 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14Some more updates to the quest log system. It has been completely moved to ↵Kevin3-35/+94
the inter server instead of the char server. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12584 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-14* Followup to r12579 (all other players appeared as female on sql branch).FlavioJS1-0/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12583 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13Major updates to the quest system.Kevin6-74/+132
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12581 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13* Quick&dirty reversal of the inter-server behaviour introduced in r3255/r3256:FlavioJS1-1/+83
- the behaviour enabled a desynch between the char-server and the map-server - now the map-server asks the char-server to authenticate the auth info (the char-server doesn't send the auth info immediatelly) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12579 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-13Login will no longer set character offline when going from map to character ↵Kevin1-1/+2
select. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11At char select, the char server will set character to server -2 (server ↵Kevin1-0/+2
unknown) rather then -1 (at char select) and will be changed to the map server id once the character loads in. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12569 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11The max_account_id packetver detection mechanism will never cause any ↵ultramage3-26/+0
connection problems ever again. (bugreport:388) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12563 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11Finished most of the quest log code, still bits here and there but it's ↵Kevin1-6/+9
usable now. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12558 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-11Some quest log changes and removed one of the set char offline calls that ↵Kevin1-1/+1
was added in revision 12552. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12557 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-10Client not marked online until map receives auth request from the client and ↵Kevin1-1/+0
is approved. Also added some online/offline sets to the auth system that were being looked over and not properly updating the char server as to what's going on. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12552 54d463be-8e91-2dee-dedb-b68131a5f0ec