Skip to content

Instantly share code, notes, and snippets.

@sovrinbloc
Created October 9, 2022 02:40
Show Gist options
  • Save sovrinbloc/fbdf154e47f8194483829fc653698733 to your computer and use it in GitHub Desktop.
Save sovrinbloc/fbdf154e47f8194483829fc653698733 to your computer and use it in GitHub Desktop.
Settings table
mysql> select * From settings \G;
*************************** 1. row ***************************
S_id: 1
S_desc: pointsName
S_value: Diamonds
*************************** 2. row ***************************
S_id: 2
S_desc: gangName
S_value: Faction
*************************** 3. row ***************************
S_id: 3
S_desc: glCoreHash
S_value: 013d411289c9f172f82477136bab1671
*************************** 4. row ***************************
S_id: 4
S_desc: validateUserEmail
S_value: 0
*************************** 5. row ***************************
S_id: 5
S_desc: itemTypes
S_value: [{"id":1,"name":"weapon","type":"equip"},{"id":2,"name":"armor","type":"equip"},{"id":3,"name":"consumable","type":"use"},{"id":4,"name":"crime","type":""},{"id":5,"name":"jewelry","type":""},{"id":6,"name":"upgrade","type":""},{"id":7,"name":"helmet","type":"equip"},{"id":8,"name":"pants","type":"equip"}]
*************************** 6. row ***************************
S_id: 6
S_desc: game_name
S_value: AzHCode
*************************** 7. row ***************************
S_id: 7
S_desc: theme
S_value: default
*************************** 8. row ***************************
S_id: 8
S_desc: adminTheme
S_value: admin
*************************** 9. row ***************************
S_id: 9
S_desc: landingPage
S_value: loggedin
*************************** 10. row ***************************
S_id: 10
S_desc: courseTypes
S_value: [{"id":1,"name":"gym"},{"id":2,"name":"jobs"},{"id":3,"name":"crimes"},{"id":4,"name":"estateAgents"},{"id":5,"name":"stats"}]
*************************** 11. row ***************************
S_id: 11
S_desc: timeZone
S_value: Europe/Paris
*************************** 12. row ***************************
S_id: 12
S_desc: loginSettings
S_value: {"layoutContainer":"container"}
*************************** 13. row ***************************
S_id: 13
S_desc: loginSuffix
S_value:
*************************** 14. row ***************************
S_id: 14
S_desc: loginPostfix
S_value:
*************************** 15. row ***************************
S_id: 15
S_desc: contest
S_value:
*************************** 16. row ***************************
S_id: 16
S_desc: contestHour
S_value:
*************************** 17. row ***************************
S_id: 17
S_desc: contestDay
S_value:
*************************** 18. row ***************************
S_id: 18
S_desc: sitemap
S_value: {"http:\/\/local.game.com:8080\/?page=login&action=login":{"time":1665282703,"hash":"3adf7de48614f58f410a2639db95b460"},"http:\/\/local.game.com:8080\/?page=forgotPassword":{"time":1665282643,"hash":"7fa8307659d7ac8f60c1e57bb85dd259"}}
*************************** 19. row ***************************
S_id: 19
S_desc: sitemapProtocol
S_value: 0
*************************** 20. row ***************************
S_id: 20
S_desc: userProtection
S_value: 3
*************************** 21. row ***************************
S_id: 21
S_desc: levelModules
S_value: []
*************************** 22. row ***************************
S_id: 22
S_desc: themeSettings
S_value: {"layoutContainer":"container"}
*************************** 23. row ***************************
S_id: 23
S_desc: maximumHouseFees
S_value: 5000000
*************************** 24. row ***************************
S_id: 24
S_desc: deleteLogs
S_value: 10
*************************** 25. row ***************************
S_id: 25
S_desc: marriageIQ
S_value: 10
*************************** 26. row ***************************
S_id: 26
S_desc: deleteChats
S_value: 10
*************************** 27. row ***************************
S_id: 27
S_desc: shoutboxAdv
S_value: 50
*************************** 28. row ***************************
S_id: 28
S_desc: shoutboxAdvTime
S_value: 3600
*************************** 29. row ***************************
S_id: 29
S_desc: isAds
S_value: 1
*************************** 30. row ***************************
S_id: 30
S_desc: adsSize
S_value: 8
*************************** 31. row ***************************
S_id: 31
S_desc: gameShoutbox
S_value: 1
*************************** 32. row ***************************
S_id: 32
S_desc: contestFirstItem
S_value:
*************************** 33. row ***************************
S_id: 33
S_desc: contestFirstItemQty
S_value:
*************************** 34. row ***************************
S_id: 34
S_desc: contestFirstMoney
S_value:
*************************** 35. row ***************************
S_id: 35
S_desc: contestFirstDiamonds
S_value:
*************************** 36. row ***************************
S_id: 36
S_desc: contestFirstExp
S_value:
*************************** 37. row ***************************
S_id: 37
S_desc: contestSecondItem
S_value:
*************************** 38. row ***************************
S_id: 38
S_desc: contestSecondItemQty
S_value:
*************************** 39. row ***************************
S_id: 39
S_desc: contestSecondMoney
S_value:
*************************** 40. row ***************************
S_id: 40
S_desc: contestSecondDiamonds
S_value:
*************************** 41. row ***************************
S_id: 41
S_desc: contestSecondExp
S_value:
*************************** 42. row ***************************
S_id: 42
S_desc: contestThirdItem
S_value:
*************************** 43. row ***************************
S_id: 43
S_desc: contestThirdItemQty
S_value:
*************************** 44. row ***************************
S_id: 44
S_desc: contestThirdMoney
S_value:
*************************** 45. row ***************************
S_id: 45
S_desc: contestThirdDiamonds
S_value:
*************************** 46. row ***************************
S_id: 46
S_desc: contestThirdExp
S_value:
46 rows in set (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment