{"action":"created","issue":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/4212","repository_url":"https://api.github.com/repos/ParadiseSS13/Paradise","labels_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/4212/labels{/name}","comments_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/4212/comments","events_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/4212/events","html_url":"https://github.com/ParadiseSS13/Paradise/pull/4212","id":148779762,"number":4212,"title":"Cleans up special role jobbans","user":{"login":"Tastyfish","id":1185434,"avatar_url":"https://avatars.githubusercontent.com/u/1185434?v=3","gravatar_id":"","url":"https://api.github.com/users/Tastyfish","html_url":"https://github.com/Tastyfish","followers_url":"https://api.github.com/users/Tastyfish/followers","following_url":"https://api.github.com/users/Tastyfish/following{/other_user}","gists_url":"https://api.github.com/users/Tastyfish/gists{/gist_id}","starred_url":"https://api.github.com/users/Tastyfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tastyfish/subscriptions","organizations_url":"https://api.github.com/users/Tastyfish/orgs","repos_url":"https://api.github.com/users/Tastyfish/repos","events_url":"https://api.github.com/users/Tastyfish/events{/privacy}","received_events_url":"https://api.github.com/users/Tastyfish/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/labels/Administration","name":"Administration","color":"ffffff"},{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/labels/Fix","name":"Fix","color":"26C5E2"},{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/labels/SQL%20Change","name":"SQL Change","color":"ff00ff"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-15T22:01:02Z","updated_at":"2016-04-19T23:16:37Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/pulls/4212","html_url":"https://github.com/ParadiseSS13/Paradise/pull/4212","diff_url":"https://github.com/ParadiseSS13/Paradise/pull/4212.diff","patch_url":"https://github.com/ParadiseSS13/Paradise/pull/4212.patch"},"body":"- Makes all special roles that have jobban checks jobbannable.\r\n - Also makes it use clean lists in the code instead of hardcoding them.\r\n- Makes borers have their own ban instead of using xeno bans which was weird.\r\n- pAI's can no longer be put in bots if they've been `sentient animal` banned.\r\n- There's apparently a `Records` ban which prevents people from setting their sec/med records in character creation, so I added that to the list so you can actually apply that one too.\r\n- Merges `NPC` and `sentient animal` into `sentient animal` and makes it consistently an option; changes `alien` into `cortical borer` as described below.\r\n - :rotating_light: The following SQL will have to be done to ensure all the bans rollover. :rotating_light:\r\n - The former (sentient animal/NPC) previously split 2 different methods of becoming animal into separate bans.\r\n - The latter (alien) was a ban role that was probably intended to be for xenos but xenos actually used xenomorph, and borers used alien. Those bans are probably a mess because of that; who knows.\r\n```sql\r\nUPDATE `ban` SET job = \"sentient animal\" WHERE job = \"NPC\";\r\nUPDATE `ban` SET job = \"cortical borer\" WHERE job = \"alien\";\r\n```\r\n![Jobban](http://i.imgur.com/vGwLyRo.png)\r\n![Jobban 2](http://i.imgur.com/eK54NAE.png)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/comments/212167832","html_url":"https://github.com/ParadiseSS13/Paradise/pull/4212#issuecomment-212167832","issue_url":"https://api.github.com/repos/ParadiseSS13/Paradise/issues/4212","id":212167832,"user":{"login":"TheDZD","id":8212178,"avatar_url":"https://avatars.githubusercontent.com/u/8212178?v=3","gravatar_id":"","url":"https://api.github.com/users/TheDZD","html_url":"https://github.com/TheDZD","followers_url":"https://api.github.com/users/TheDZD/followers","following_url":"https://api.github.com/users/TheDZD/following{/other_user}","gists_url":"https://api.github.com/users/TheDZD/gists{/gist_id}","starred_url":"https://api.github.com/users/TheDZD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TheDZD/subscriptions","organizations_url":"https://api.github.com/users/TheDZD/orgs","repos_url":"https://api.github.com/users/TheDZD/repos","events_url":"https://api.github.com/users/TheDZD/events{/privacy}","received_events_url":"https://api.github.com/users/TheDZD/received_events","type":"User","site_admin":false},"created_at":"2016-04-19T23:16:37Z","updated_at":"2016-04-19T23:16:37Z","body":"Will merge just before we next patch so that we can ensure nobody forgets about SQL changes."}}