Commit graph

51 commits

Author SHA1 Message Date
MrSent
82367618a4 Added saving and using zoneline id's 2025-10-27 00:48:54 +00:00
sruon
a0682a9168 A.M.A.N, Assist Channel 2025-07-30 20:08:14 -06:00
WinterSolstice8
cb0c7607d0 [core] [lua] [sql] Destroy nameflags and replace with a more sane system
Co-authored-by: atom0s <atom0s@live.com>
2024-04-19 20:53:02 -06:00
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
WinterSolstice8
f1c744c4bb [login] Increase rlimit for open files to 10240 2023-06-23 00:08:27 -07:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
claywar
31478300c7
Change chars table home_zone to smallint(5)
Fix comment from copy-paste


Add semicolon
2022-05-27 07:02:06 -04:00
Zach Toogood
16f21b5848 [db] Add chars.chatfilters and migration 2022-04-02 16:46:04 +03:00
InoUno
9d250ae7b2 Implement search comments, preferred languages, and mentor search 2021-07-02 16:42:54 +02:00
TeoTwawki
2589da530c Merge branch 'topaz' of https://github.com/DerpyProjectGroup/topaz into freedom
# Resolved Conflicts:
#	sql/job_points.sql
2021-04-18 13:49:29 -04:00
claywar
40bda8f8c5 [Job Points] SQL, Build, and Migration Scripts 2021-04-17 18:33:07 -04:00
Ixion
c460a89139 Ixion is Come!
- Rebranding.
- Migrate to GitLab.
- Add support for database updates when using Docker.
- Give purpose to version.h (adjust minor version with client updates).
- Add an in-game `!ver` command.
- Remove references to AGPL.
2021-04-17 18:24:14 -04:00
TeoTwawki
276cf1a095 Merge branch 'canary' of https://github.com/topaz-next/topaz into freedom 2021-04-10 22:55:57 -04:00
TeoTwawki
de3066a3cb Remove even more banding references. The name "topaz" remains in places but all of "tpz" should be gone now. 2021-04-01 16:14:56 -04:00
Zach Toogood
9e4993893d Migrate all SQL tables from MyISAM to InnoDB 2021-02-05 17:07:08 +02:00
Zach Toogood
a52962d301 Merge branch 'release' into feature/mystery
# Conflicts:
#	sql/chars.sql
2020-10-22 21:36:45 +03:00
Kreidos
9e82e75366 Adjust char timestamp migration for older Mariadb
Contrary to what the Mariadb documentation alleges,
some older versions of maria seem to not automatically
assume valid default values.
2020-10-19 20:41:37 -07:00
Zach Toogood
36f555060f Merge branch 'release' into feature/mystery
# Conflicts:
#	sql/chars.sql
#	src/map/time_server.cpp
2020-10-16 21:27:21 +03:00
Zach Toogood
93fd8f66ae Merge branch 'release' into feature/mystery
# Conflicts:
#	src/map/map.cpp
#	src/map/time_server.cpp
#	tools/dbtool.py
#	win32/vcxproj/topaz_game.vcxproj.filters
2020-10-13 16:20:00 +03:00
Kreidos
20f83e1943 Records of Eminence Phase 3
-Add Timed Records
-Add Daily Records
-Core Timekeeping / JST code
-Char lastOnline timestamp (to support back-processing of offline chars)
-Performance improvements
-RoE Records moved to own lua file (roe_records.lua)
+Fix kills now count for party/alliance members
+Fix RoE EXP now given after mob kill EXP
2020-10-10 21:40:07 -07:00
Kreidos
88620df671 Core RoE Implementation
Add packets & handlers (0x110C, 110D, 111, 112, 117)
Add triggers for quest-log spark updates
Add RoE log framework to Charentity + Update packet
Lua Hooks:
  getEminenceCompleted
  setEminenceCompleted
  getEminenceProgress
  setEminenceProgress
Add SQL save/loading. Ensure records shown in correct order.
2020-08-17 08:52:52 -07:00
Zach Toogood
a0ed0f59ec
Gobbie Mystery Box plumbing (#405)
* First pass at gobbie mystery box

* Start on Gobbie Mystery Box lua global

* Add map config, alter how gobbie_point is handled

* Simplify date handling

* GetTimeCreated binding

* Hook up binding

* Move gobbie update

* Move logic back into Arbitrix

* Less conversions

* Simplify timestamp on char creation

* Create MYSTERY_GOBBIE_BOX_MINIMUM_AGE_DAYS setting

* Inclusive

* Remove unused global

* timecreate -> timecreated

* Hook up another event

* Updates from testing

* Fix potential crash (too many params)

* gobbie_point -> daily_tally

* Cleanup and new migrations

* update vsproj filters

* Cleanup from Discord chat

* Add midnight handling for clearing gobbieBoxUsed

* Add gobbieBoxUsed in lua

* Add new migrations to migration script

* Simplify SQL queries

* onEventUpdate stuff

* Rename gobbie namespace to daily and daily_system

* Missed rename

* Add upper limit for daily tally points

* Update logging and formatting

* Fix compilation

* Small style changes
2020-03-19 23:36:06 +00:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
Jasson McMorris
a1a5a162f7 Removed c-style arrays in favor of std::arrays and moved moghancement to be stored in chars table 2018-10-01 21:21:43 -07:00
Zynjec
d77e3cb9b1
Removed unused column in chars 2018-09-13 16:30:16 -04:00
Tyler Schneider
1979c04495 Fixed some issues with displayhead
Fixes #4487
2018-01-08 20:11:32 -07:00
Zynjec
90a53f50b8
Add nnameflags column to chars.sql 2018-01-08 20:35:58 -05:00
Tyler Schneider
961c1b5e42 Moved moghouse resolution to database
No longer uses zoneid 0 for figuring out mog house

(except for zonelines to zone 0, which don't exist anyways)
2017-08-19 13:54:39 -06:00
Tyler Schneider
65a75eb8dd Implemented unlockable weaponskills 2016-07-07 19:28:54 -06:00
Ben D'Angelo
ead34185d3 SQL: Moved player spells from a blob to a table 2015-10-14 23:54:53 -04:00
Alex Goolsby
7adb31f76f CORE/SQL: add table for merit storage 2015-08-07 01:16:29 -04:00
CaptainMalRD
77bada0460 Modified LockStyle Implementation
Add CHAR_STYLE table to store the current locked item IDs for each
visible slot.
Modify CHARS table to include a flag to indicate current style lock
status.
Add styleItem array to store current locked item IDs for each visible
slot.
Remove copy of equipped look to main look when setting style lock
status.
Modify charutils::LoadChar to load char_style.
Modify charutils::UpdateItem to update style look when items are
removed.
Add charutils:SetStyleLock to maintain locked item status and push
enable/disable messages.
Add handling of 0x53 packet (new LockStyle packet).
Modify char_look save routine to save the locked style and locked style
items.
2015-05-04 19:38:33 -04:00
TeoTwawki
d38788e590 1. Campaign Allegiance added to char table (new column)
2. Implemented quest "Steamed Rams"
3. Scripted MiliartTK in South Sandy [S]
4. Fixed the exit in Windurst Waters [S]
Sigil itself (and Sanction) will be done in a separate pull request, though its skeleton is here now.
2015-04-02 10:17:06 -04:00
teschnei
f51c461031 CORE: fixed GetCharByName for CZoneInstance
fixed NPCs with status 1 not spawning
fixed save/load of assault and campaign logs
SCRIPTS: fixed instance startup in Seagull Grounded
-fixed assault textIDs in Alzadaal, Arrapago Reef, Bhaflau Thickets and Caedarva Mire
2014-11-04 18:08:33 -07:00
TeoTwawki
037263e082 WARNING: new column in char table!
Fixed A.M.A.N. Mentor recruiter NPCs, Fixed typo'd Debug messages, made mentor flag save its state and update the icon immediately when changed. Prior to this you trigger a char update packet to see the change and logging off reset it.
2014-09-24 00:26:14 -04:00
atom0s
e23c70d657 CORE: Implemented mentor flag and new adventurer flag.
SQL: Added isnewplayer field to chars table for new adventurer flag.
2014-04-07 21:33:51 -07:00
teschnei
ad69d7e591 CORE: save set blue spells on logout and job change, fixed another infinite stats bug, reset blue spells on level restriction
TODO: /BLU packet doesn't work.  Characters will still have stats bonus and be able to cast blue magic via /ma if they were set on BLU main prior to changing to BLU sub.
2013-07-11 23:39:47 +00:00
addnad
288ae161fe CORE: Implemented GM permission levels for commands. This means a new field in the chars table, players can use @ commands that you allow them to, and you can toggle your GM flag on/off for testing or playing. @ commands work based on your GM level, not your nameflags, meaning you can use all commands normally available to you whether your GM icon displays or not.
SCRIPTS: New commands:
@togglegm
@promote <name> <level>
2013-06-18 01:46:59 +00:00
teschnei
aa61e583a2 PROJECT: merged 032713-Update to trunk 2013-03-31 19:22:04 +00:00
teschnei
1c706801e0 CORE: implemented all corsair phantom rolls
added a binding getMerit that returns the merit level * associated value (seriously, use it)
added support for "learnable job abilities" (aka just phantom rolls right now).  works the exact same way as learnable spells
YARR HARR FIDDLE DE DEE
2013-02-13 03:28:55 +00:00
linkandentity
c16b8f5a3c Weapon breaking system (trial & ksnm weapons ect)
What's done:

- Receive 1 point per WS. 
- Points are stored similar to char_vars and are deleted once the weapon is unlocked.
- DMG + Delay are effected when a weapon breaks, items mods are removed on break. Mods are not applied to a broken weapon.

TODO: skillchain extra points
TODO: apply a different set of mods for a broken weapon (6% crit ect)
2013-01-23 23:43:30 +00:00
diatanato
f396ee40f1 CORE: merits + FIX chars.sql (потерял nation) 2012-10-25 18:59:54 +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
91dfed7c2a SQL: тип полей и значения по умолчанию в таблице chars 2011-12-31 18:06:06 +00:00
onetimeffxi
d0b72f3e6f Fame values stored for characters by nation. 2011-11-21 16:35:58 +00:00
onetimeffxi
dcdd495436 Clean up chars.sql 2011-09-30 04:20:53 +00:00
onetimeffxi
f9f66b44f7 Added LUA BaseEntity functions setRank(rankvalue) and getRank(). 2011-09-30 03:52:48 +00:00
onetimeffxi
8a1dbae49b Added increaseContainerSize, added inventory capacity to database. Inventory can now be increased by gobbie bag quests or mog house quests. Also added decreaseContainerSize but this should only be used for testing purposes. 2011-09-19 03:16:10 +00:00