-- function Kerub_getinfo(RoleID, Reiting, add)
 -- Sql_con()
  -- local rating_count = 0
  -- for Count in rows(con, "SELECT Count(RoleID) As Count FROM (SELECT RoleID FROM sm_data.Kerub_reiting ORDER BY Reiting DESC LIMIT 10) as t") do
    -- rating_count = Count
  -- end
  -- local Gift_flag = 0
  -- for Gift in rows(con, string.format("SELECT Gift FROM sm_data.Kerub_reiting WHERE RoleID = '%s'", RoleID)) do
    -- gift_flag = Gift
  -- end
  -- if add == 1 then
    -- sql = "SELECT * FROM sm_data.Kerub_reiting WHERE RoleID = '%s'"
    -- local RoleID_id = 0
    -- for RoleID in rows(con, sql:format(RoleID)) do
      -- RoleID_id = RoleID
    -- end
    -- if RoleID_id == 0 then
      -- sql = "INSERT INTO sm_data.Kerub_reiting VALUES ('%s', '%s', 0)"
      -- con:execute(sql:format(RoleID, Reiting))
    -- else
      -- sql = "Update sm_data.Kerub_reiting set Reiting = Reiting+'%s' where RoleID = '%s'"
      -- con:execute(sql:format(Reiting, RoleID))
    -- end
  -- end
  -- if add == 2 then
    -- sql = "Update sm_data.Kerub_reiting set Gift = 1 where RoleID = '%s'"
    -- con:execute(sql:format(RoleID))
  -- end
  -- local RoleID_rating = {}
  -- local RoleID_point = {}
  -- local i = 1
  -- for RoleID, Reiting in rows(con, "SELECT RoleID, Reiting FROM sm_data.Kerub_reiting ORDER BY Reiting DESC LIMIT 10") do
    -- RoleID_rating[i] = RoleID
    -- RoleID_point[i] = Reiting
    -- i = i + 1
  -- end
  -- sql = "SELECT Reiting FROM sm_data.Kerub_reiting WHERE RoleID = '%s'"
  -- local my_rating_point = 0
 
  -- for Reiting in rows(con, sql:format(RoleID)) do
    -- my_rating_point = Reiting
  -- end
  -- con:close()
  -- env:close()
  -- return rating_count, RoleID_rating, RoleID_point, my_rating_point, gift_flag
-- end

-- function Kerub_getinfo2(RoleID, Reiting, add)
 -- Sql_con()
  -- local rating_count = 0
  -- for Count in rows(con, "SELECT Count(RoleID) As Count FROM (SELECT RoleID FROM sm_data.Kerub_reiting_new ORDER BY Reiting DESC LIMIT 10) as t") do
    -- rating_count = Count
  -- end
  -- local Gift_flag = 0
  -- for Gift in rows(con, string.format("SELECT Gift FROM sm_data.Kerub_reiting_new WHERE RoleID = '%s'", RoleID)) do
    -- gift_flag = Gift
  -- end
  -- if add == 1 then
    -- sql = "SELECT * FROM sm_data.Kerub_reiting_new WHERE RoleID = '%s'"
    -- local RoleID_id = 0
    -- for RoleID in rows(con, sql:format(RoleID)) do
      -- RoleID_id = RoleID
    -- end
    -- if RoleID_id == 0 then
      -- sql = "INSERT INTO sm_data.Kerub_reiting_new VALUES ('%s', '%s', 0)"
      -- con:execute(sql:format(RoleID, Reiting))
    -- else
      -- sql = "Update sm_data.Kerub_reiting_new set Reiting = Reiting+'%s' where RoleID = '%s'"
      -- con:execute(sql:format(Reiting, RoleID))
    -- end
  -- end
  -- if add == 2 then
    -- sql = "Update sm_data.Kerub_reiting_new set Gift = 1 where RoleID = '%s'"
    -- con:execute(sql:format(RoleID))
  -- end
  -- local RoleID_rating = {}
  -- local RoleID_point = {}
  -- local i = 1
  -- for RoleID, Reiting in rows(con, "SELECT RoleID, Reiting FROM sm_data.Kerub_reiting_new ORDER BY Reiting DESC LIMIT 10") do
    -- RoleID_rating[i] = RoleID
    -- RoleID_point[i] = Reiting
    -- i = i + 1
  -- end
  -- sql = "SELECT Reiting FROM sm_data.Kerub_reiting_new WHERE RoleID = '%s'"
  -- local my_rating_point = 0
 
  -- for Reiting in rows(con, sql:format(RoleID)) do
    -- my_rating_point = Reiting
  -- end
  -- con:close()
  -- env:close()
  -- return rating_count, RoleID_rating, RoleID_point, my_rating_point, gift_flag
-- end

-- function clear_Kerub_reiting()
  -- Sql_con()
      -- sql = "TRUNCATE sm_data.Kerub_reiting"
      -- con:execute(sql:format())
	  
-- end

-- function clear_Kerub_reiting2()
  -- Sql_con()
      -- sql2 = "TRUNCATE sm_data.Kerub_reiting_new"
      -- con:execute(sql2:format())
-- end


-- function KerubUpdate(RoleID, Glory)
  -- Sql_con()
  -- sql = "INSERT INTO sm_data.Kerub_reiting_new VALUES ('%s', '%s', 0)"
  -- con:execute(sql:format(RoleID, Glory))
  
  -- con:close()
  -- env:close()
-- end