Hi Elitepvpers.
Warning !. (Turkish)
Quest File :
Mysql Sql :
German Quest File thanks Sodii ;)
See you soon
Mfg HaveBeen™
Warning !. (Turkish)
Quest File :
PHP Code:
--[[
-- HaveBeen TM
-- Offline Message & New Version
-- Version : 1.0 <3
-- For Epvp
]]--
quest offlinemessage begin
state start begin
when 9006.chat."Messages" begin
say_title(mob_name(npc.get_race())..":")
say("")
---
say("Hi "..pc.name)
say("What do you want? ")
say("")
local s = select("My Inbox","Write Message","Close")
if(s == 1) then
say_title(mob_name(npc.get_race())..":")
say("")
---
local inbox = mysql_query("select * from player.inbox where id = '"..pc.get_player_id().."' ")
local inbox_table = {}
for i = 1,table.getn(inbox),1 do
table.insert(inbox_table,inbox.message[i])
end
table.insert(inbox_table,"Close")
if(table.getn(inbox) == 0) then
say("Currently don't have any messages. ")
say("See you later. ")
return
end
local m = select_table(inbox_table)
if(table.getn(inbox_table) == s) then
return
elseif(table.getn(inbox_table) >= s) then
say_title(inbox.sender[m]..": ")
say("")
---
say(inbox_table[m])
say("")
say_reward("Do you want to delete the message? ")
local q = select(locale.yes,locale.no)
if(q == 2) then
return
end
mysql_query("delete * from player.inbox where sender = '"..inbox.sender[m].."' ")
say_title(mob_name(npc.get_race())..":")
say("")
---
say("Message was succesfully deleted. ")
say("Thanks see you later. ")
say("")
end
elseif(s == 2) then
say_title(mob_name(npc.get_race())..":")
say("")
---
say("To whom will you send the message? ")
say("write his name. ")
local sname = input()
local search = find_pc_by_name(sname)
say_title(mob_name(npc.get_race())..":")
say("")
---
if(tostring(sname) == nil or sname == "") then
say("Write a name. ")
return
elseif(search == 1) then
say("this person is now online. ")
say("are you kidding me? ")
say("Get out you b*st*rd!. ")
end
local sp = pc.select(sname)
local l = pc.get_player_id()
pc.select(sp)
say("What is the message? ")
say("Write in the box. ")
local message = input()
say_title(mob_name(npc.get_race())..":")
say("")
---
if(tostring(message) == nil or message == "") then
say("Write a message. ")
return
end
mysql_query("insert into player.inbox values ('"..l.."','"..pc.name.."','"..message.."') ")
say("Message was successfully sent. ")
say("Thanks see you later.. ")
end
end
end
end
PHP Code:
CREATE TABLE `inbox` (
`id` int(16) NOT NULL ,
`sender` varchar(50) NOT NULL ,
`message` varchar(50) NOT NULL ,
PRIMARY KEY (`id`)
)
;
PHP Code:
--[[
-- HaveBeen TM
-- Offline Message & New Version
-- Version : 1.0 <3
-- For Epvp
]]--
quest offlinemessage begin
state start begin
when 9006.chat."Nachrichten" begin
say_title(mob_name(npc.get_race())..":")
say("")
---
say("Hallo "..pc.name)
say("Was willst du? ")
say("")
local s = select("Posteingang","Neue Nachricht","Abbrechen")
if(s == 1) then
say_title(mob_name(npc.get_race())..":")
say("")
---
local inbox = mysql_query("select * from player.inbox where id = '"..pc.get_player_id().."' ")
local inbox_table = {}
for i = 1,table.getn(inbox),1 do
table.insert(inbox_table,inbox.message[i])
end
table.insert(inbox_table,"Close")
if(table.getn(inbox) == 0) then
say("Du hast keine neuen Nachrichten. ")
say("Bis später. ")
return
end
local m = select_table(inbox_table)
if(table.getn(inbox_table) == s) then
return
elseif(table.getn(inbox_table) >= s) then
say_title(inbox.sender[m]..": ")
say("")
---
say(inbox_table[m])
say("")
say_reward("Willst du diese Nachricht wirklich löschen? ")
local q = select("Ja","Nein")
if(q == 2) then
return
end
mysql_query("delete * from player.inbox where sender = '"..inbox.sender[m].."' ")
say_title(mob_name(npc.get_race())..":")
say("")
---
say("Die Nachricht wurde gelöscht. ")
say("Bis später. ")
say("")
end
elseif(s == 2) then
say_title(mob_name(npc.get_race())..":")
say("")
---
say("An wen willst du die Nachricht senden? ")
say("Gib seinen Namen ein ")
local sname = input()
local search = find_pc_by_name(sname)
say_title(mob_name(npc.get_race())..":")
say("")
---
if(tostring(sname) == nil or sname == "") then
say("Gib einen Namen ein. ")
return
elseif(search == 1) then
say("diese Person ist nun online. ")
say("Willst du mich rollen? ")
say("Verpiss dich mal du Noob ")
end
local sp = pc.select(sname)
local l = pc.get_player_id()
pc.select(sp)
say("Wie lautet die Nachricht? ")
say("Gib eine Nachricht ein. ")
local message = input()
say_title(mob_name(npc.get_race())..":")
say("")
---
if(tostring(message) == nil or message == "") then
say("Gib eine Nachricht ein. ")
return
end
mysql_query("insert into player.inbox values ('"..l.."','"..pc.name.."','"..message.."') ")
say("Nachricht erfolgreich übermittelt. ")
say("Bis später. ")
end
end
end
end
Mfg HaveBeen™