mmo-ref/landsandboat
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
41440 commits 75 branches 0 tags 1.3 GiB
Commit graph

46 commits

Author SHA1 Message Date
Damarus
60d41c0d00 [Core] Implement Fish Ranking contest in Selbina 2024-09-10 22:49:51 -04:00
Zach Toogood
ed79b62d37 Add char_monstrosity to triggers 2023-10-16 16:17:33 +01:00
Corey Sotiropoulos
1cda207af6 Make AH results retail accurate 
Track which items have been listed on the AH using a new protected table
and trigger. Only show these items in the AH by default. This is controlled
by the `search.OMIT_NO_HISTORY` setting and is now on by default.

Run the following query to populate the new table using your existing
auction house history:
```
INSERT IGNORE INTO auction_house_items(itemid)
SELECT itemid FROM auction_house
GROUP BY itemid;
```
 2023-08-13 20:32:25 -04:00
WinterSolstice8
f1c744c4bb [login] Increase rlimit for open files to 10240 2023-06-23 00:08:27 -07:00
Xaver-DaRed
0f2d5315a9 Add char_chocobos table to char deletion trigger 2023-01-18 14:51:24 +01:00
OpheliaXI
e1b4fde87d Implement Save and Load of Equipment on Job Change 2022-09-24 03:46:18 -05:00
Zach Toogood
86082125cc [search] Add expire_all command, fix delete order in listing expiry 2022-06-22 00:14:30 +03:00
Zach Toogood
3a1f093b63 [core, sql] steps_taken -> distance_travelled 2021-06-03 20:18:20 +03:00
Zach Toogood
c4c64586b3 [core, sql] Add char history statistics 2021-06-03 20:11:53 +03:00
Xaver-DaRed
39bd876bca [SQL] Add char_job_points to Char_Delete Trigger 
Also reordered char_unlocks, becouse OCD
 2021-06-01 02:37:16 +02:00
shadowninja826
d7ce5c2a6f
updating table name account_ip_record 
updating table name from accounts_ip_record to account_ip_record to prevent error when attempting to delete a character
 2019-03-08 10:42:38 -06:00
David Norris
1436deed34 changed to update 2019-01-28 18:28:59 -06:00
David Norris
34d664f228 add account ip record to delete char 2019-01-28 18:17:51 -06:00
David Norris
4d47dc074b nix the tabe 2019-01-28 18:01:19 -06:00
David Norris
3fe3da630a add blacklist table to char delete trigger 2019-01-28 08:49:35 -06:00
TeoTwawki
41f8bbd00d Renamed unlockables to unlocks per request 2018-10-04 18:12:54 -04:00
TeoTwawki
e65aeb13d0 Begin migrating non currency things like teleports out of char_points and prepare to get rid of some char_vars junk too. 
Migrations instructions:
you copy from the old table to the new before deleting the columns. It ain't hard to query.
 2018-10-04 17:43:15 -04:00
Caladius
b920c85a67
Unable to Delete Characters from Database 
char_pet_name no longer exists as a table but the DELETE command was still included in the TRIGGERS.sql file disabling auto deletion of characters through the game.

Removed the char_pet_name reference from file
 2018-06-10 08:35:20 -04:00
TeoTwawki
9ea6fd6f52 Fix not being able to delete characters: trigger was referencing a table that no longer exists 2017-06-09 14:23:48 -04:00
Alex Goolsby
631305535f CORE/SQL: dbox: extent outbox orphan detection to non-existent recipients, prevent orphan culling in event of DB access error, add trigger to automatically return items sent to deleted char by other players if they were not picked up 2017-02-03 09:28:59 -05:00
Tyler Schneider
959fd9cd55 Removed an unneeded trigger 
It won't be deleted on an update, it must be deleted manually
 2016-06-27 15:16:33 -06:00
Xaver-Entropia
5a22b4cef2 Fix to character deletion method 
Fix issue where certain tables would not delete character values when deleting a character
 2016-04-09 21:55:01 +02:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Kyle Pittman
6419d41440 Update triggers.sql 
Remove BOM character(s) per issue #1
 2015-11-05 16:29:14 -06:00
demolish
d5202079a3 SQL/LOBBY/CORE: attempt to fix chars loading into the wrong zone 2015-07-04 22:55:06 +01:00
teschnei
00011c7dff SQL: disallowed changing of pos while zoning 
zoning column will be set to 0 once the char has finished loading in to
the next zone
 2015-04-30 18:59:16 -06:00
teschnei
1ad3eb3dc4 SQL: added fkey to accounts_parties and removed trigger to handle deleting rows from accounts_parties on accounts_sessions deletes 2015-02-15 12:35:51 -07:00
teschnei
7bd3d7c822 CORE: refactor delivery box 
follows retail formula more accurately
fixed send box not starting from mog house
fixed canceled items not being left in the send box if not taken
added 'extra' column to preserve charges, signature, fish weight/length, etc to items being delivered
increased slot size in database to help stop a delivery box from being overflowed
 2015-01-05 22:19:18 -07:00
teschnei
c17fa8c009 CORE: allow game server to tell apart zoning from logging in/out, fixed losing EFFECTFLAG_ON_ZONE when logging out 2014-12-31 15:24:59 -07:00
teschnei
bab4bd6fa6 CORE: renamed chat server to message server 
-fixed potential login problems if disconnecting after zoning but before arriving in another server
 2014-10-07 16:10:21 -06:00
teschnei
757f384cf7 CORE/SCRIPTS: unlock automaton attachments 
-added @cs2 command for 0x33 event packets (contain strings)
 -added confirmItem(slotID) to lua_trade_container to be used with confirmTrade (lua_baseentity).  confirmTrade removes only confirmed items (via confirmItem) from players inventory on trade (alternative to completeTrade)
 -temp: add automaton name to CCharEntity (will be moved later) and getAutomatonName (will be replaced with getAutomaton)
SQL: fixed some missing automaton attachments, renamed char_pet_name to char_pet (to store more than just name)
 2013-08-10 05:55:29 +00:00
deviltti
a5b99174b7 CORE/SQL: Fix should take care of any problems with people who already unlocked Dragoon and were not able to select a wyvern name. Your wyvern's name will continue to be "Wyvern" until you change it via the Npc. 2013-06-10 21:04:26 +00:00
teschnei
f9c61bf0f3 CORE: send item packets and logic 
SCRIPTS: delivery NPCs
DATABASE: delivery updates
 2013-04-15 22:58:38 +00:00
teschnei
0ee286dced SQL: modified triggers to exclude char_titles (which no longer exists) 2013-03-21 23:25:30 +00:00
PrBlahBlahtson
d7ecb3dd57 DATABASE: Some long over-due changes to triggers.sql to make life easier for server admins. Please remember to update this when adding character related tables. 2013-02-22 01:07:55 +00:00
diatanato
f4ac14b67d SQL: refactoring - chars 2012-10-25 15:15:09 +00:00
diatanato
72532f9877 CORE: furnishing (без aura и moghancement) 2012-10-14 08:13:43 +00:00
diatanato
8a3520f505 CORE: titles 2012-10-13 18:44:06 +00:00
diatanato
493b5e178b CORE: 
- recast_container
- обновление системы item_usable
 2012-10-13 14:28:32 +00:00
diatanato
9a3e278c9b - DSGame-server обновлен для работы с клиентом v30120208_8 
- начало работ над linkshell
- начало работ над обменом между персонажами (trade)
 2012-02-19 16:07:14 +00:00
diatanato
dc02d20877 автоматически сгенерированные продажи на аукционе не должны содержать реальный id. значение должно быть установлено как 0. 2012-01-23 03:12:09 +00:00
7cipherx7
cacb32969d AHTool issue with more than 254 items sold on AH fixed, need new AHTool_v1.2updated.rar 2012-01-23 00:38:32 +00:00
davecontreras1
89c5f49fb7 SQL:East Ronfaure [S] mobids added to db 2012-01-20 20:00:30 +00:00
diatanato
1040dde978 AuctionHouse: отправляем продавцу gil за купленные у него предметы (к сожалению, забрать их из delivery_box пока не получится) 2012-01-09 20:16:20 +00:00
diatanato
4c7e229ac6 всего понемногу (возможна некоторая нестабильность версии) 
- система чтения магии никуда не годится. удалил все, оставил только анимацию
- trigger для delivery_box
- новая система recast_time (еще не финал)
- сообщение bazaar теперь хранится в char_stats 
- питомцы, нанося удары, оставляют на цели id хозяина

P.S. обновление таблицы char_stats без удаления персонажей - ALTER TABLE `char_stats` ADD `bazaar_message` VARCHAR(120) NOT NULL DEFAULT '\0' AFTER `title`;
 2012-01-09 19:33:35 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00