{"action":"created","issue":{"url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/10","repository_url":"https://api.github.com/repos/rgajendran/ctf_marker","labels_url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/10/comments","events_url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/10/events","html_url":"https://github.com/rgajendran/ctf_marker/issues/10","id":252048998,"number":10,"title":"Adding the Admin User during 'CREATE Users & Teams' fails due to lack of T_TYPE","user":{"login":"kernel-sanders","id":1490292,"avatar_url":"https://avatars3.githubusercontent.com/u/1490292?v=4","gravatar_id":"","url":"https://api.github.com/users/kernel-sanders","html_url":"https://github.com/kernel-sanders","followers_url":"https://api.github.com/users/kernel-sanders/followers","following_url":"https://api.github.com/users/kernel-sanders/following{/other_user}","gists_url":"https://api.github.com/users/kernel-sanders/gists{/gist_id}","starred_url":"https://api.github.com/users/kernel-sanders/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kernel-sanders/subscriptions","organizations_url":"https://api.github.com/users/kernel-sanders/orgs","repos_url":"https://api.github.com/users/kernel-sanders/repos","events_url":"https://api.github.com/users/kernel-sanders/events{/privacy}","received_events_url":"https://api.github.com/users/kernel-sanders/received_events","type":"User","site_admin":false},"labels":[{"id":534457094,"url":"https://api.github.com/repos/rgajendran/ctf_marker/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-08-22T18:31:26Z","updated_at":"2017-08-22T20:01:22Z","closed_at":null,"body":"https://github.com/rgajendran/ctf_marker/blob/5135484c7a8e912249ecea7d1350cfabe5df3dd0/admin.php#L1014\r\n\r\nThe users DB is defined with \r\n``\r\n`T_TYPE` varchar(1) NOT NULL, \r\n``\r\n\r\nBut the Admin user is added without T_TYPE, which causes: \r\n\r\n> Field 'T_TYPE' doesn't have a default value\r\n\r\nI added the Admin user with a T_TYPE of `L` based on what I could see from other spots in the code. It seems to work. Should line 1014 include a T_TYPE of L?"},"comment":{"url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/comments/324135578","html_url":"https://github.com/rgajendran/ctf_marker/issues/10#issuecomment-324135578","issue_url":"https://api.github.com/repos/rgajendran/ctf_marker/issues/10","id":324135578,"user":{"login":"rgajendran","id":12548071,"avatar_url":"https://avatars3.githubusercontent.com/u/12548071?v=4","gravatar_id":"","url":"https://api.github.com/users/rgajendran","html_url":"https://github.com/rgajendran","followers_url":"https://api.github.com/users/rgajendran/followers","following_url":"https://api.github.com/users/rgajendran/following{/other_user}","gists_url":"https://api.github.com/users/rgajendran/gists{/gist_id}","starred_url":"https://api.github.com/users/rgajendran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgajendran/subscriptions","organizations_url":"https://api.github.com/users/rgajendran/orgs","repos_url":"https://api.github.com/users/rgajendran/repos","events_url":"https://api.github.com/users/rgajendran/events{/privacy}","received_events_url":"https://api.github.com/users/rgajendran/received_events","type":"User","site_admin":false},"created_at":"2017-08-22T20:01:22Z","updated_at":"2017-08-22T20:01:22Z","body":"I double checked it, it works on my Fedora aswell.\r\n\r\nIncase if you haven't used XAMPP, follow these steps. \r\n\r\n1. download xampp (`xampp-linux-x64-5.6.31-0-installer.run`)\r\n2. `chmod +x xampp-linux-x64-5.6.31-0-installer.run`\r\n3. `./xampp-linux-x64-5.6.31-0-installer.run`\r\n4. Finish the process and run `./opt/lampp/manager-linux-x64.run`\r\n5. Click `Manage Servers ` Tab -> Start `apache` and `MySQL database`\r\n6. `git clone https://github.com/rgajendran/ctf_marker `(Clone inside `/opt/lampp/htdocs/)`\r\n7. Visit `http://localhost/ctf_marker` and navigate to `http://localhost/ctf_marker/admin.php`\r\n8. Click **Database Management** -> Click Create (Create all 6 Create Buttons)\r\n9. In case if you are forcefully logged out after creating users tables  (Login with admin:admin)\r\n10. After creating all tables, You can create teams with team name and generate either logins or tokens. \r\n\r\nI hope it works for you, let me know if you have any issues. "}}
{"actor":{"display_login":"rgajendran"}}