api_w_watch_list.go 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. package route
  2. import (
  3. "database/sql"
  4. "log"
  5. "opennamu/route/tool"
  6. "strconv"
  7. jsoniter "github.com/json-iterator/go"
  8. )
  9. func Api_w_watch_list(call_arg []string) string {
  10. var json = jsoniter.ConfigCompatibleWithStandardLibrary
  11. other_set := map[string]string{}
  12. json.Unmarshal([]byte(call_arg[0]), &other_set)
  13. page, _ := strconv.Atoi(other_set["num"])
  14. num := 0
  15. if page*50 > 0 {
  16. num = page*50 - 50
  17. }
  18. db := tool.DB_connect()
  19. defer db.Close()
  20. if tool.Get_user_auth(db, other_set["ip"]) == "" {
  21. return "{}"
  22. }
  23. var stmt *sql.Stmt
  24. var err error
  25. if other_set["do_type"] == "star_doc" {
  26. stmt, err = db.Prepare(tool.DB_change("select id from user_set where name = 'star_doc' and data = ? limit ?, 50"))
  27. } else {
  28. stmt, err = db.Prepare(tool.DB_change("select id from user_set where name = 'watchlist' and data = ? limit ?, 50"))
  29. }
  30. if err != nil {
  31. log.Fatal(err)
  32. }
  33. defer stmt.Close()
  34. rows, err := stmt.Query(other_set["name"], num)
  35. if err != nil {
  36. log.Fatal(err)
  37. }
  38. defer rows.Close()
  39. data_list := [][]string{}
  40. ip_parser_temp := map[string][]string{}
  41. for rows.Next() {
  42. var user_name string
  43. err := rows.Scan(&user_name)
  44. if err != nil {
  45. log.Fatal(err)
  46. }
  47. var ip_pre string
  48. var ip_render string
  49. if _, ok := ip_parser_temp[user_name]; ok {
  50. ip_pre = ip_parser_temp[user_name][0]
  51. ip_render = ip_parser_temp[user_name][1]
  52. } else {
  53. ip_pre = tool.IP_preprocess(db, user_name, other_set["ip"])[0]
  54. ip_render = tool.IP_parser(db, user_name, other_set["ip"])
  55. ip_parser_temp[user_name] = []string{ip_pre, ip_render}
  56. }
  57. data_list = append(data_list, []string{ip_pre, ip_render})
  58. }
  59. return_data := make(map[string]interface{})
  60. return_data["language"] = map[string]string{
  61. "watchlist": tool.Get_language(db, "watchlist", false),
  62. "star_doc": tool.Get_language(db, "star_doc", false),
  63. }
  64. return_data["data"] = data_list
  65. json_data, _ := json.Marshal(return_data)
  66. return string(json_data)
  67. }