Advertisement
Rochet2

Command get player acc, char

May 2nd, 2012
245
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function account_OnChat(event, player, message, type, language)
  2.     local cmd, arg = message:lower():match("^#(a[cn]) ?(.*)")
  3.     if(cmd) then
  4.         if(cmd == "ac") then
  5.             if(arg == "") then
  6.                 player:SendBroadcastMessage("Incorrect syntax. Usage: #"..cmd.." <Account Name>")
  7.             else
  8.                 local Q = CharDBQuery('SELECT a.name, b.login FROM arc_char.characters a, arc_logon.accounts b WHERE b.login like "'..arg..'%" AND a.online <> 0 AND a.acct = b.acct LIMIT 1;')
  9.                 if(Q) then
  10.                     player:SendBroadcastMessage("|cFF4682B4Account von |r|cffff0000"..Q:GetColumn(1):GetString().."|r|cFF4682B4 ist mit dem Character |r|cffff0000"..Q:GetColumn(0):GetString().."|r|cFF4682B4 online.")
  11.                 else
  12.                     player:SendBroadcastMessage("Keine account mit "..arg.." account name gefunden") -- something something :P
  13.                 end
  14.             end
  15.         elseif(cmd == "an") then
  16.             if(arg == "") then
  17.                 player:SendBroadcastMessage("Incorrect syntax. Usage: #"..cmd.." <Player Name>")
  18.             else
  19.                 local Q = CharDBQuery('SELECT a.name, b.login FROM arc_char.characters a, arc_logon.accounts b WHERE a.name like "'..arg..'%" AND a.online <> 0 AND a.acct = b.acct LIMIT 1;')
  20.                 if(Q) then
  21.                     player:SendBroadcastMessage("|cFF4682B4Der Player |r|cffff0000"..Q:GetColumn(0):GetString().."|r|cFF4682B4 ist mit einem anderem Character on: |r|cffff0000"..Q:GetColumn(1):GetString().." ")
  22.                 end
  23.             end
  24.         end
  25.         return false
  26.     end
  27.     return true
  28. end
  29. RegisterServerHook(16, account_OnChat)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement