Guest User

SReport

a guest
Dec 27th, 2012
17
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 0.76 KB | None | 0 0
  1. -- Serverside
  2. function getThreeShouts( player )
  3.     --verwende lieber die MTA Datenbank Funktionen
  4.     local result = dbQuery( handler, "SELECT * FROM shoutbox" )
  5.     local shoutTable = {}
  6.     local res, row = dbPoll(result,-1)
  7.         if res and row > 0 then
  8.             for id, shout in pairs(res) do
  9.         --  if (not shout) then break end    wird dann eigentlich nicht mehr benötigt
  10.                 local user = shout['User']
  11.                 local text = shout['Entry']
  12.                 local date = shout['Date']
  13.                 local time = shout['Time']
  14.                 table.insert(shoutTable,{ User = user, Text = text, Date = date, Time = time })
  15.                 table.sort(shoutTable)
  16.                 triggerClientEvent(player, "getShouts", player, shoutTable)
  17.             end
  18.         end            
  19. end
  20. addEvent("getShout", true)
  21. addEventHandler("getShout", getRootElement(), getThreeShouts)
Advertisement
Add Comment
Please, Sign In to add comment