api_bbs_w_post.go 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package route
  2. import (
  3. "opennamu/route/tool"
  4. "strconv"
  5. )
  6. func Api_bbs_w_post(config tool.Config, set_id string, title string, data string) map[string]string {
  7. db := tool.DB_connect()
  8. defer tool.DB_close(db)
  9. if !tool.Check_acl(db, "", "", "bbs_comment", config.IP) {
  10. return_data := make(map[string]string)
  11. return_data["response"] = "require auth"
  12. return return_data
  13. }
  14. set_code := ""
  15. tool.QueryRow_DB(
  16. db,
  17. "select set_code from bbs_data where set_name = 'title' and set_id = ? order by set_code + 0 desc",
  18. []any{ &set_code },
  19. set_id,
  20. )
  21. set_code_int := tool.Str_to_int(set_code)
  22. set_code_int += 1
  23. set_code_str := strconv.Itoa(set_code_int)
  24. date_now := tool.Get_time()
  25. insert_db := [][]string{
  26. { "title", title },
  27. { "data", data },
  28. { "date", date_now },
  29. { "user_id", config.IP },
  30. }
  31. for _, v := range insert_db {
  32. tool.Exec_DB(
  33. db,
  34. "insert into bbs_data (set_name, set_code, set_id, set_data) values (?, ?, ?, ?)",
  35. v[0],
  36. set_code_str,
  37. set_id,
  38. v[1],
  39. )
  40. }
  41. return_data := make(map[string]string)
  42. return_data["response"] = "ok"
  43. return_data["data"] = set_code_str
  44. return return_data
  45. }