issues
Data license: AGPL · Data source: ACEmulator Project
12 rows where "created_at" is on date 2017-02-04
This data as json, CSV (advanced)
Suggested facets: title, user, comments, author_association, body, type, created_at (date), updated_at (date), closed_at (date)
id ▼ | node_id | number | title | user | state | locked | assignee | milestone | comments | created_at | updated_at | closed_at | author_association | active_lock_reason | draft | pull_request | body | reactions | performed_via_github_app | state_reason | repo | type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
205326043 | MDExOlB1bGxSZXF1ZXN0MTA0NjUwNTg2 | 16 | database abstraction and encapsulation. created character model and skill attribute models. | Mogwai-TheFurry 25351661 | closed | 0 | 0 | 2017-02-04T05:57:10Z | 2017-02-04T06:42:11Z | 2017-02-04T06:42:11Z | CONTRIBUTOR | 0 | ACEmulator/ACE/pulls/16 | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/16/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | ||||||
205328952 | MDExOlB1bGxSZXF1ZXN0MTA0NjUxOTE3 | 17 | database encapsulation is done! yay! | Mogwai-TheFurry 25351661 | closed | 0 | 0 | 2017-02-04T06:55:34Z | 2017-05-30T15:34:08Z | 2017-02-04T07:13:27Z | CONTRIBUTOR | 0 | ACEmulator/ACE/pulls/17 | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/17/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | ||||||
205330194 | MDExOlB1bGxSZXF1ZXN0MTA0NjUyNjE0 | 18 | Option to Enable Automatic Account Creation | LtRipley36706 11369233 | closed | 0 | 2 | 2017-02-04T07:23:37Z | 2017-03-20T02:59:13Z | 2017-02-04T22:14:16Z | MEMBER | 0 | ACEmulator/ACE/pulls/18 | Added a configurable variable to Config.json for allowing the server to create an account for the client when one does not exist on the server. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/18/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205346915 | MDU6SXNzdWUyMDUzNDY5MTU= | 19 | Support logging off to the character selection screen. | TigrisOfGaul 25125434 | closed | 0 | Mag-nus 10608427 | 1 | 2017-02-04T13:07:05Z | 2017-06-22T07:59:06Z | 2017-06-22T07:59:06Z | CONTRIBUTOR | Currently the only way to log into the world with a different character is to restart the client. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/19/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | completed | ACE 79078680 | issue | |||||
205353528 | MDU6SXNzdWUyMDUzNTM1Mjg= | 20 | Server should have a way to apply DB migrations | zbuc 570040 | closed | 0 | 7 | 2017-02-04T15:19:26Z | 2017-12-04T14:30:37Z | 2017-12-04T14:30:36Z | CONTRIBUTOR | The server should have a way to track which DB migrations it has applied, and automatically apply missing ones in the correct order. @Mag-nus suggested a naming convention of `YYYY_MM_DD_tablename.sql`. This would work, but would make dealing with pull requests and merges annoying, if multiple came in one day. I would suggest a naming scheme more along the lines of `$patchNumber + '_' + $YYYY_MM_DD + '_' + $descriptiveFeatureName`, for example `01_2017_02_03_add_monster_information.sql` and not limiting them to any particular tables. Picking the second naming system will make dealing with pull requests easier and help developers understand what updates are for. Additionally, the leading number provides a good way of tracking our schema revision. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/20/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | completed | ACE 79078680 | issue | ||||||
205361124 | MDExOlB1bGxSZXF1ZXN0MTA0NjY4MTI0 | 21 | Change password hashing to use scrypt | zbuc 570040 | closed | 0 | 4 | 2017-02-04T17:28:50Z | 2017-03-20T02:20:14Z | 2017-03-20T02:20:14Z | CONTRIBUTOR | 0 | ACEmulator/ACE/pulls/21 | I switched the password hashing over to use libsodium's scrypt implementation. This involved adding a new migration. I noticed that currently the password isn't checked. I started looking into how to implement password checking and it looks like we will probably need to have a launcher to do so. The reason the commit touches so many files is because it also cleans up the files with mixed line endings. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/21/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205362379 | MDExOlB1bGxSZXF1ZXN0MTA0NjY4ODA4 | 22 | Teleloc loader fix and basic set of locations | ChrisAikman 10677293 | closed | 0 | 0 | 2017-02-04T17:48:51Z | 2017-02-04T22:11:12Z | 2017-02-04T22:11:12Z | CONTRIBUTOR | 0 | ACEmulator/ACE/pulls/22 | Fixed an index bug in `WorldDatabase.GetLocations` and added a basic set of telelocations to the `teleport_location` table for use with `teleloc`. Updated the `teleloc` command to accept multiple name locations, such as `Ayan Baqur`. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/22/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205377812 | MDExOlB1bGxSZXF1ZXN0MTA0Njc1ODg4 | 23 | Add Config.json to .gitignore | zbuc 570040 | closed | 0 | 1 | 2017-02-04T21:12:57Z | 2017-02-04T22:53:44Z | 2017-02-04T22:53:44Z | CONTRIBUTOR | 0 | ACEmulator/ACE/pulls/23 | This also forces first-time configuration. Existing Config.json copied to Config.json.example README.md has been updated with instructions. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/23/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205379026 | MDExOlB1bGxSZXF1ZXN0MTA0Njc2NTYy | 24 | Fixed bug in CharacterCreate. | LtRipley36706 11369233 | closed | 0 | 0 | 2017-02-04T21:32:30Z | 2017-02-17T06:50:27Z | 2017-02-04T22:54:04Z | MEMBER | 0 | ACEmulator/ACE/pulls/24 | It was not changing the AccountId in the database when saving leading to empty character list. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/24/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205381602 | MDExOlB1bGxSZXF1ZXN0MTA0Njc3ODA5 | 25 | Option to Enable Automatic Account Creation | LtRipley36706 11369233 | closed | 0 | 1 | 2017-02-04T22:11:38Z | 2017-03-20T02:59:21Z | 2017-02-05T08:52:58Z | MEMBER | 0 | ACEmulator/ACE/pulls/25 | Added a configurable variable to Config.json for allowing the server to create an account for the client when one does not exist on the server. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/25/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205381707 | MDExOlB1bGxSZXF1ZXN0MTA0Njc3ODY1 | 26 | Fixing up Character Delete and Restore functions | LtRipley36706 11369233 | closed | 0 | 1 | 2017-02-04T22:13:24Z | 2017-03-10T04:56:27Z | 2017-02-05T09:03:41Z | MEMBER | 0 | ACEmulator/ACE/pulls/26 | In looking at the character deletion and restore section it made sense to me that name in character database shouldn't be made a unique value At present in master, even if that character was marked as deleted, the character name is held. I've made changes to the code and database to better emulate how it worked before with respect to deletions and restores. As is, no character is ever marked deleted so that is yet to be implemented, although I suspect that would be a server side SQL script or command within ACE running at an interval/manually via console as determined by a configuration variable(s) possibly in config.json for how often it checks, how long the restore window is and if to mark characters deleted or not which would remove them from restoration via client. Going further than original design, perhaps it could be changed to hold the character name for that account only while the restoration window is active, as well as only allowing that account to create a brand new character with that deleted name. | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/26/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull | |||||
205383343 | MDExOlB1bGxSZXF1ZXN0MTA0Njc4NjAw | 27 | Corrected spelling in a few places. | LtRipley36706 11369233 | closed | 0 | 0 | 2017-02-04T22:36:04Z | 2017-02-05T03:35:03Z | 2017-02-05T03:35:03Z | MEMBER | 0 | ACEmulator/ACE/pulls/27 | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/27/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | ACE 79078680 | pull |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issues] ( [id] INTEGER PRIMARY KEY, [node_id] TEXT, [number] INTEGER, [title] TEXT, [user] INTEGER REFERENCES [users]([id]), [state] TEXT, [locked] INTEGER, [assignee] INTEGER REFERENCES [users]([id]), [milestone] INTEGER REFERENCES [milestones]([id]), [comments] INTEGER, [created_at] TEXT, [updated_at] TEXT, [closed_at] TEXT, [author_association] TEXT, [active_lock_reason] TEXT, [draft] INTEGER, [pull_request] TEXT, [body] TEXT, [reactions] TEXT, [performed_via_github_app] TEXT, [state_reason] TEXT, [repo] INTEGER REFERENCES [repos]([id]), [type] TEXT ); CREATE INDEX [idx_issues_repo] ON [issues] ([repo]); CREATE INDEX [idx_issues_milestone] ON [issues] ([milestone]); CREATE INDEX [idx_issues_assignee] ON [issues] ([assignee]); CREATE INDEX [idx_issues_user] ON [issues] ([user]);