[RELEASE]Offline Message System

04/15/2013 19:53 HaveBeen™#1
Hi Elitepvpers.

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(
== 1then
    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 
1,table.getn(inbox),do
     
table.insert(inbox_table,inbox.message[i])
    
end
    table
.insert(inbox_table,"Close")
 
    if(
table.getn(inbox) == 0then
     say
("Currently don't have any messages. ")
     
say("See you later. ")
     return
    
end
 
    local m 
select_table(inbox_table)
    if(
table.getn(inbox_table) == sthen
     
return
    elseif(
table.getn(inbox_table) >= sthen
     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(
== 2then
      
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(== 2then
    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 == 1then
     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 
Mysql Sql :

PHP Code:
CREATE TABLE `inbox` (
`
id`  int(16NOT NULL ,
`
sender`  varchar(50NOT NULL ,
`
message`  varchar(50NOT NULL ,
PRIMARY KEY (`id`)
)

German Quest File thanks Sodii ;)

PHP Code:
--[[ 
-- 
HaveBeen TM 
-- Offline Message & New Version 
-- Version 1.0 <
-- 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(
== 1then 
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 
1,table.getn(inbox),do 
table.insert(inbox_table,inbox.message[i]) 
end 
table
.insert(inbox_table,"Close"
 
if(
table.getn(inbox) == 0then 
say
("Du hast keine neuen Nachrichten. "
say("Bis später. "
return 
end 
 
local m 
select_table(inbox_table
if(
table.getn(inbox_table) == sthen 
return 
elseif(
table.getn(inbox_table) >= sthen 
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(
== 2then 
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(== 2then 
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 == 1then 
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 
See you soon
Mfg HaveBeen
04/15/2013 19:54 -Tuni#2
<P align=left><FONT color=royalblue>You are dumb.</FONT></P>
04/15/2013 19:59 HaveBeen™#3
Quote:
Originally Posted by Tunii View Post
<P align=left><FONT color=royalblue>You are dumb.</FONT></P>
sorry :/ There was an error:p

I understand, but you're the idiot :/
04/15/2013 20:06 DEMONKING.#4
perfect
thank you so much ^^
04/15/2013 20:08 $treet#5
Quote:
Originally Posted by Tunii View Post
<P align=left><FONT color=royalblue>You are dumb.</FONT></P>
Idiot :DDDDDDDDDDDDDD
04/15/2013 20:21 .RazerX#6
It Seems Good... Is It Tested?
Thanks
04/15/2013 20:24 Metin2 Team#7
Quote:
Originally Posted by Tunii View Post
<P align=left><FONT color=royalblue>You are dumb.</FONT></P>
<font color="RED" size="10000"> LOSER </FONT>

Thanks 4 sharing bro

:) keep it up.
04/15/2013 20:26 iShowtime#8
Thanks *-*
04/15/2013 20:26 KingHunter3#9
Nice work man, but could have been better.
04/15/2013 20:27 HaveBeen™#10
Quote:
Originally Posted by .RazerX View Post
It Seems Good... Is It Tested?
Thanks
yep :pimp:

Quote:
Originally Posted by Metin2 Team View Post
<font color="RED" size="10000"> LOSER </FONT>

Thanks 4 sharing bro

:) keep it up.

ahaha thanks bro :pimp:
04/15/2013 20:45 MarcosCC#11
Thx nice work :)
04/15/2013 20:56 .Rebel#12
with interface get awnsome tanks for the idea and release
04/15/2013 20:58 CDiem#13
Damn, thank you!
04/15/2013 22:45 DexterSK#14
Good job.
04/15/2013 22:57 tяuє Ðevin#15
Nice quest.

Translated it to german. (For faster copy-pastein ;))
- - - - - - - - -
Habs mal kurz ins Deutsche übersetzt. (Für's schnelle Copy-Pasten ;))

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(
== 1then
    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 
1,table.getn(inbox),do
     
table.insert(inbox_table,inbox.message[i])
    
end
    table
.insert(inbox_table,"Close")
 
    if(
table.getn(inbox) == 0then
     say
("Du hast keine neuen Nachrichten. ")
     
say("Bis später. ")
     return
    
end
 
    local m 
select_table(inbox_table)
    if(
table.getn(inbox_table) == sthen
     
return
    elseif(
table.getn(inbox_table) >= sthen
     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(
== 2then
      
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(== 2then
    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 == 0then
     say
("Dieser Spieler existiert nicht. ")
     
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