Commit Graph

  • dedd1fc70d NPC::ModifyNPCStat function bloat cleanup akkadius 2014-08-27 14:26:36 -05:00
  • 5cf748d135 Initial work Akkadius 2014-08-27 09:55:39 -05:00
  • 9ddb56088e merge from master Arthur Ice 2014-08-26 18:49:15 -07:00
  • 9f4167a65c Merge pull request #230 from addtheice/RunQueryToDatabaseQuery_zone_guild_mgr Alex 2014-08-26 17:36:46 -07:00
  • 085b021587 Merge pull request #226 from addtheice/RunQueryToDatabaseQuery_zone_spawngroup Alex 2014-08-26 17:36:17 -07:00
  • 5a65fd4207 Merge pull request #227 from addtheice/RunQueryToDatabaseQuery_zone_spawn2 Alex 2014-08-26 17:36:03 -07:00
  • 0f321b3a69 Merge pull request #228 from addtheice/RunQueryToDatabaseQuery_zone_client_packet Alex 2014-08-26 17:35:51 -07:00
  • 53c7b789f2 Merge pull request #229 from KayenEQ/Development Alex 2014-08-26 17:35:36 -07:00
  • 850ea7789e Merge pull request #225 from addtheice/RunQueryToDatabaseQuery_zone_spells Alex 2014-08-26 17:35:21 -07:00
  • c3a3dc19a7 Merge pull request #224 from addtheice/RunQueryToDatabaseQuery_zone_zone Alex 2014-08-26 17:35:10 -07:00
  • 2606592f32 Merge pull request #223 from addtheice/RunQueryToDatabaseQuery_zone_doors Alex 2014-08-26 17:34:53 -07:00
  • 5c3791631a Merge pull request #221 from addtheice/RunQueryToDatabaseQuery_ucs_database Alex 2014-08-26 17:34:36 -07:00
  • 4c9108a906 Merge pull request #210 from addtheice/RunQueryToDatabaseQuery_zone_waypoints Alex 2014-08-26 17:34:23 -07:00
  • efbcaf6f64 Merge pull request #231 from EQEmu/trade_stacking Uleat 2014-08-26 19:04:01 -04:00
  • 18a4f831be Tweaked QS code for Client::FinishTrade() and QueryServ handlers. #231 Uleat 2014-08-26 06:37:40 -04:00
  • 6597967acd Changed void* to EQEmu::Any in quest interface. Been meaning to change from void* for a while to a structure that data hides instead. KimLS 2014-08-25 22:59:52 -07:00
  • 24825677dc Merge branch 'master' of github.com:EQEmu/Server KimLS 2014-08-25 22:31:15 -07:00
  • 70d5983562 Added eqemu::any KimLS 2014-08-25 22:31:02 -07:00
  • d4a9fed45e Added QS code to Client::FinishTrade() Uleat 2014-08-25 22:29:00 -04:00
  • a6b923a22e UpdateItemQuantity converted to QueryDatabase #230 Arthur Ice 2014-08-25 15:10:46 -07:00
  • 1e87086471 DeleteItem converted to QueryDatabase Arthur Ice 2014-08-25 12:43:14 -07:00
  • c3fdbfe904 SetPermissions converted to QueryDatabase Arthur Ice 2014-08-25 12:33:09 -07:00
  • 00852063c2 Promote converted to QueryDatabase Arthur Ice 2014-08-25 12:15:06 -07:00
  • 44dcf7af7d Merge git://github.com/EQEmu/Server into Development KayenEQ 2014-08-25 09:23:23 -04:00
  • d525d040fe Merge branch 'master' of https://github.com/EQEmu/Server into trade_stacking Uleat 2014-08-24 23:40:15 -04:00
  • 67a774dd9b Remove extra c_str() non-sense now that the bug is fixed Michael Cook (mackal) 2014-08-24 22:28:37 -04:00
  • ff7ff658e0 Merge branch 'master' of https://github.com/EQEmu/Server into trade_stacking Uleat 2014-08-24 21:38:01 -04:00
  • 6100da75c5 Merge branch 'master' of https://github.com/EQEmu/Server into shutdown_crash Uleat 2014-08-24 19:59:34 -04:00
  • a612c3c006 Idiot kls missed a file KimLS 2014-08-24 16:30:02 -07:00
  • 412835d7fa Basic string tests, plus fix for StringFormat returning a std::string that was just very subtley malformed. KimLS 2014-08-24 16:26:51 -07:00
  • 6a4f7466f0 Merge branch 'master' of https://github.com/EQEmu/Server into shutdown_crash Uleat 2014-08-24 19:24:07 -04:00
  • b3ea7ecd0d Added param to special attack NPC_NO_CHASE Param 2 = If set will disable LOS check #229 KayenEQ 2014-08-24 19:11:41 -04:00
  • 50e6d0d256 Load converted to QueryDatabase Arthur Ice 2014-08-24 16:02:21 -07:00
  • f948786f6a Handle_OP_GMSearchCorpse converted to QueryDatabase #228 Arthur Ice 2014-08-24 14:21:33 -07:00
  • 4d0179d525 Handle_OP_SetStartCity converted to QueryDatabase Arthur Ice 2014-08-24 14:13:06 -07:00
  • c851cd3f12 Handle_OP_ItemLinkClick converted to QueryDatabase Arthur Ice 2014-08-24 14:06:52 -07:00
  • b6875564d4 GetCondition converted to QueryDatabase #227 Arthur Ice 2014-08-24 13:47:18 -07:00
  • 0240c61952 LoadSpawnConditions converted to QueryDatabase Arthur Ice 2014-08-24 13:31:55 -07:00
  • 7864a5285d LoadDBEvent converted to QueryDatabase Arthur Ice 2014-08-24 13:18:51 -07:00
  • 538921701c UpdatedDBCondition converted to QueryDatabase Arthur Ice 2014-08-24 13:13:11 -07:00
  • 3cf4d4af1b UpdateDBEvent converted to QueryDatabase Arthur Ice 2014-08-24 13:10:15 -07:00
  • c70c7e13ec CreateSpawn2 converted to QueryDatabase Arthur Ice 2014-08-24 13:07:15 -07:00
  • 9980dfe80e LoadSpawn2 converted to QueryDatabase Arthur Ice 2014-08-24 13:03:45 -07:00
  • 42a51eb373 PopulateZoneSpawnList converted to QueryDatabase Arthur Ice 2014-08-24 13:00:39 -07:00
  • 932dd836d0 LoadSpawnGroupsByID converted to QueryDatabase #226 Arthur Ice 2014-08-24 12:54:06 -07:00
  • adf36bf912 LoadSpawnGroups converted to QueryDatabase Arthur Ice 2014-08-24 12:46:02 -07:00
  • e7ef4b5484 SpellGlobalCheck converted to QueryDatabase #225 Arthur Ice 2014-08-24 12:37:44 -07:00
  • 3d1521857e LoadStaticZonePoints converted to QueryDatabase #224 Arthur Ice 2014-08-24 12:21:16 -07:00
  • 9707b53df2 LoadDoors converted to QueryDatabase #223 Arthur Ice 2014-08-24 12:14:16 -07:00
  • 5d6d489889 GetDoorsDBCountPlusOne converted to QueryDatabase Arthur Ice 2014-08-24 12:08:39 -07:00
  • 8f4e2e99db GetDoorsCountPlusOne converted to QueryDatabase Arthur Ice 2014-08-24 12:00:45 -07:00
  • 377c6a87a2 GetDoorsCount converted to QueryDatabase Arthur Ice 2014-08-24 11:53:28 -07:00
  • b36cc3ab08 Merge pull request #209 from addtheice/RunQueryToDatabaseQuery_zone_tribute Alex 2014-08-24 11:18:38 -07:00
  • 339b8e37a6 Merge pull request #208 from addtheice/RunQueryToDatabaseQuery_zone_trap Alex 2014-08-24 11:18:25 -07:00
  • 8f3e9b4a7a Merge pull request #218 from KayenEQ/Development Alex 2014-08-24 11:17:52 -07:00
  • 633583c266 Created character_lookup table for applications that mirrors all character_ table fields minus blob fields for application lookups - A 2.4GB character_ table will take 7 seconds to query on a SSD versus .1s on the character_lookup table - This also causes applications like Magelo to burst reads of the entire character table because of the blob fields that come with the reads, as much as 500-600MB/s even if a indexed id filter is provided - This field is synchronized on player save and has 0.001s DB hit - When we split out from the blob, ideally this table can be removed, but it really does no harm in mirroring data when a 2.6GB character table mirrors everything subtracting blob data down to 8MB - Required SQL: utils\sql\git\required\2014_08_24_character_lookup.sql akkadius 2014-08-24 08:52:14 -05:00
  • 3b048ee8a2 Character creation process crash fix (world) and query cleanup akkadius 2014-08-24 07:13:15 -05:00
  • 52ae78709b First attempt at fixing zone shutdown crashes. (Mob timer processing accessing released resources.) Uleat 2014-08-24 05:42:43 -04:00
  • dec290ba96 Merge branch 'master' of git://github.com/EQEmu/Server into RunQueryToDatabaseQuery_ucs_database #221 Arthur Ice 2014-08-24 02:07:19 -07:00
  • cef1dfd0c0 Query Fix for SendQuery (Temporary) akkadius 2014-08-24 02:50:39 -05:00
  • 3262bee6c5 ExpeditionSay converted to QueryDatabase Arthur Ice 2014-08-23 23:26:45 -07:00
  • 2dbd616725 SetAccountFlag converted to QueryDatabase Arthur Ice 2014-08-23 23:23:26 -07:00
  • eb98563fa1 LoadAccountFlags converted to QueryDatabase Arthur Ice 2014-08-23 23:20:55 -07:00
  • 7f92e96ae7 TryReward converted to QueryDatabase Arthur Ice 2014-08-23 23:15:49 -07:00
  • a48138dfd6 SendRewards converted to QueryDatabase Arthur Ice 2014-08-23 23:05:58 -07:00
  • 0b486b3f76 strlen to std::string::length Michael Cook (mackal) 2014-08-24 02:02:42 -04:00
  • 46980e5260 DiscoverItem converted to QueryDatabase Arthur Ice 2014-08-23 22:59:38 -07:00
  • 44f9e5495e IsDiscovered converted to QueryDatabase Arthur Ice 2014-08-23 22:52:46 -07:00
  • 97f59282cf KeyRingAdd converted to QueryDatabase Arthur Ice 2014-08-23 22:49:27 -07:00
  • b112dfe860 Fix gcc compile error Michael Cook (mackal) 2014-08-24 01:48:29 -04:00
  • 2a4a5b1beb KeyRingLoad converted to QueryDatabase Arthur Ice 2014-08-23 22:46:29 -07:00
  • 232d61b983 GetFriendAndIgnore converted to QueryDatabase Arthur Ice 2014-08-23 22:33:05 -07:00
  • 4e10b77980 2nd Nix fix akkadius 2014-08-24 00:28:45 -05:00
  • c1469a3a8e RemoveFriendOrIgnore converted to QueryDatabase Arthur Ice 2014-08-23 22:22:49 -07:00
  • 9d5f427f57 AddFriendOrIgnore converted to QueryDatabase Arthur Ice 2014-08-23 22:20:16 -07:00
  • cdd1e17348 Cosmetic log fix from merge akkadius 2014-08-24 00:17:31 -05:00
  • 20e978b676 ExpiredMail converted to QueryDatabase Arthur Ice 2014-08-23 22:16:37 -07:00
  • 163906e0f0 Nix fix akkadius 2014-08-24 00:09:09 -05:00
  • c9bd662b57 SetMessageStatus converted to QueryDatabase Arthur Ice 2014-08-23 22:07:04 -07:00
  • 8529384b00 SendMail converted to QueryDatabase Arthur Ice 2014-08-23 22:00:40 -07:00
  • 7f89191ffc Changed zone process window title format, example: 'crushbone :: clients: 6 inst_id: 1 inst_ver: 0 :: port: 7015' Most of the following changes are QueryServ related, fully implemented its original functionality to be able to offload intensive or metric based logging to a remote server process that could exist on another server entirely Implemented Player Event Logging Types (Go to table qs_player_events): 1 = Player_Log_Quest, 2 = Player_Log_Zoning, 3 = Player_Log_Deaths, 4 = Player_Log_Connect_State, 5 = Player_Log_Levels, 6 = Player_Log_Keyring_Addition, 7 = Player_Log_QGlobal_Update, 8 = Player_Log_Task_Updates, 9 = Player_Log_AA_Purchases, 10 = Player_Log_Trade_Skill_Events, 11 = Player_Log_Issued_Commands, 12 = Player_Log_Money_Transactions, 13 = Player_Log_Alternate_Currency_Transactions, - All QueryServ logging will be implemented with a front end in EoC 2.0 very soon Changed all QS Error related logging to 'QUERYSERV__ERROR' (Natedog) (Crash Fix) Legacy MySQL bug revert for loading AA's COALESCE( from COALESCE ( Implemented Perl Quest objects (LUA still needed to be exported): - quest::qs_send_query("MySQL query") - Will send a raw query to the QueryServ process, useful for custom logging - quest::qs_player_event(char_id, event_desc); - Will process a quest type event to table qs_player_events Added MySQL Tables: - qs_player_aa_rate_hourly - qs_player_events - Source table structures from: - utils\sql\git\queryserv\required\08_23_2014_player_events_and_player_aa_rate_hourly To get the complete QueryServ schema, source from here: - utils\sql\git\queryserv\required\Complete_QueryServ_Table_Structures.sql Added rules for each logging type, source rules here with them enabled by default: - utils\sql\git\queryserv\required\Complete_QueryServ_Rules_Enabled.sql Spawn related logging cleanup General code cleanup Added queryserv.cpp and queryserv.h with QueryServ class akkadius 2014-08-23 23:59:20 -05:00
  • aaf5f8c930 SendBody converted to QueryDatabase Arthur Ice 2014-08-23 21:51:40 -07:00
  • 2bdc44dfb2 SendHeaders converted to QueryDatabase Arthur Ice 2014-08-23 21:47:59 -07:00
  • 6e7136ea18 SetChannelOwner converted to QueryDatabase Arthur Ice 2014-08-23 21:38:57 -07:00
  • 7a507e8d1e SetChannelPassword converted to QueryDatabase Arthur Ice 2014-08-23 21:34:27 -07:00
  • 76fdfa87c1 LoadChatChannels converted to QueryDatabase Arthur Ice 2014-08-23 21:31:26 -07:00
  • 19486bac0d GetVariable converted to QueryDatabase Arthur Ice 2014-08-23 21:27:18 -07:00
  • de47755320 FindCharacter converted to QueryDatabase Arthur Ice 2014-08-23 21:24:28 -07:00
  • 6b90f883cd VerifyMailKey converted to QueryDatabase Arthur Ice 2014-08-23 21:18:47 -07:00
  • 5c640b2d40 FindAccount converted to QueryDatabase Arthur Ice 2014-08-23 21:16:05 -07:00
  • a568a6f194 GetAccountStatus converted to QueryDatabase Arthur Ice 2014-08-23 21:10:30 -07:00
  • 85df09b3f2 Implemented NPC special ability 40 'NPC_CHASE_DISTANCE' Param 0: Sets max distance you need to be away from an npc for it to chase you. Param 1: Sets min distance you need to be from npc for it to chase you. Usage: Ideally used with ranged attack npcs / casters who you DO NOT WANT to chase you unless you get too close or too far or out of sight. #218 KayenEQ 2014-08-23 03:21:36 -04:00
  • 16d47a2c47 Revert accident in 089360a3a5. Looks like it was meant for 7-10 instead of 4-10. JJ 2014-08-22 22:28:40 -04:00
  • 9a5d2d2bc5 Trade Stacking: BETA Uleat 2014-08-22 20:48:11 -04:00
  • 3b16c86007 Fix for aa effect loading. KimLS 2014-08-22 14:50:13 -07:00
  • 7c451f8170 Merge pull request #207 from addtheice/RunQueryToDatabaseQuery_zone_zoning Alex 2014-08-22 13:48:17 -07:00
  • 2e1b75e95b Merge pull request #203 from addtheice/RunQueryToDatabaseQuery_zone_pets Alex 2014-08-22 13:47:59 -07:00
  • 1cd5970649 Merge pull request #201 from addtheice/RunQueryToDatabaseQuery_zone_mob Alex 2014-08-22 13:47:48 -07:00
  • 1bccdf57ee Merge pull request #200 from addtheice/RunQueryToDatabaseQuery_zone_merc Alex 2014-08-22 13:47:29 -07:00
  • d03232ce1b Merge pull request #199 from addtheice/RunQueryToDatabaseQuery_zone_horse Alex 2014-08-22 13:47:07 -07:00