video_material.lua 897 B

12345678910111213141516171819202122232425262728293031
  1. --推广
  2. local M = {}
  3. local mysqldbx = require "mysqldbx"
  4. local tools = require "tools"
  5. local skynet = require "skynet"
  6. local cjson = require "cjson"
  7. local config = require "run_config"
  8. local db
  9. --设置推广状态
  10. function M.set_tui_guang_status(msg_body)
  11. local isok ,key = tools.checkData({"id_list","status"},msg_body)
  12. if not isok then
  13. return false,string.format("缺少字段: %s.", key)
  14. end
  15. local idString = table.concat(msg_body.id_list, ",")
  16. local sql = string.format("SELECT * FROM video_material WHERE id IN (%s)",idString)
  17. local isok,res;
  18. res = mysqldbx.query(sql)
  19. for i = 1, #res, 1 do
  20. local id = res[i].id
  21. local material_id = res[i].material_id
  22. sql = string.format("UPDATE video_material SET status = %d WHERE id =%d ",msg_body.status,id)
  23. mysqldbx.query(sql)
  24. end
  25. return true,{}
  26. end
  27. return M