[RELEASE]Offline Message System

Page 3 of 4 12 3 4
04/18/2013 16:50 margosssss#31
Quote:
Originally Posted by $treet View Post
Change "--e" to "-e" and try again.

If the error happen again try with mysql50-client and deinstall mysql55-client (not server).

I do not understand where? This error writes me putty. Where do I change it?

:(
04/18/2013 16:54 ebert.tonna#32
Bin ich bekloppt oder ihr, 3 Seiten THANKS und der Mist geht nicht was issen mit euch los schaut euch doch mal die Quest an, das müsste doch schon beim Posteingang auffallen.

Wie soll den der fremde Spieler Nachrichten empfangen wenn nicht mal seine ID übermittelt wird!!!!!

Das iss ein System um sich selber Nachrichten zu hinterlassen.
"Hallo du bist dumm, willkommen zurück."

Wenn dann muss der Query ganz anders geschrieben werden, und es auslesen.

Wenn Spieler A dem Spieler B eine Nachricht schreibt, kann der Spieler B diese niemals lesen, weil die Empfänger ID garnicht angegeben wird.

Hohl oder was???? Baut den Mist mal ein und testet das mal dann werdet ihr das endlich mal merken.
Sind denn hier nur noch bekloppte unterwegs oder was.
04/18/2013 17:21 .Risan.#33
Sollen sie das von Zymos nehmen...
Das funktioniert wenigstens.
04/18/2013 17:54 ebert.tonna#34
Das wird auch wieder nicht funktionieren weil das anderers mysql iss

Mysql Schnittstelle von Hanaschi

das iss mit miijago null kompatibel
04/18/2013 18:44 $treet#35
Quote:
Originally Posted by margosssss View Post
I do not understand where? This error writes me putty. Where do I change it?

:(
Search for the "mysql_query function" in the published questlib from mijago.
04/18/2013 19:26 .Bloddy#36
Why do u use query?
Is very better using i/o.
04/18/2013 20:21 margosssss#37
Quote:
Originally Posted by $treet View Post
Search for the "mysql_query function" in the published questlib from mijago.



ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=insert into player.inbox values ('60433','HaveBeen','asdasd')' at line 1


:/
04/19/2013 16:07 null.gaia#38
it's not working, like it can't connect to the index table.
when i try to make a new message at the end it give's me a blank board.
04/19/2013 22:53 .Despero™#39
Bekomme 0 Nachrichten. Bei mir bleibt er einfach so. Ich bekomme garkeine Nachrichten..
04/25/2013 09:26 Kurosaki70#40
I have a probleme with delete and sender message.
When I send a message to someone offline the message are not sent. When I send a message to an online person but the message is sent to the sender.
When I want to delete a message, I get this error:
ERROR 1062 (23000) at line 1: Duplicate entry '11330' for key 'PRIMARY'
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from player.inbox where sender = '[CGA]Loki'' at line 1
04/25/2013 16:19 mateo2012#41
Problems.... I have too
04/26/2013 23:40 xmennoz#42
Translated it to Turkish.


PHP Code:
--[[
    -- HaveBeen TM
    -- Offline Message & New Version
    -- Version : 1.0 <3
    -- For Epvp
    -- Çeviri & Translate : Xmennoz
]]--
quest offlinemessage begin
    state start begin
        when 9006.chat."Messages" begin
            say_title(mob_name(npc.get_race())..":")
            say("")
            ---
            say("Merhaba "..pc.name)
            say("Ne Yapmak İstiyorsun")
            say("")
            local s = select("My İnbox","Mesaj Yaz","Kapat")
            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,"Kapat")
                
                if(table.getn(inbox) == 0) then
                    say("Hiç Bir Mesaj Yok ")
                    say("Sonra Görüşürüz ")
                    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("Bu Mesajı Silmek İstiyormusun ")
                    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("Mesaj Başarı İle Silindi ")
                    say("Sonra Görüşürüz ")
                    say("")
                end
            elseif(s == 2) then
                say_title(mob_name(npc.get_race())..":")
                say("")
                ---
                say("Mesajı Göndermek İstiyormusun ")
                say("İsim Yaz. ")
                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("İsim Yaz. ")
                    return
                elseif(search == 0) then
                    say("Öyle Biri Yok. ")
                    say("Benmle Dalgamı Geçiyorsun ")
                    say("Git Buradan. ")
                end
                local sp = pc.select(sname)
                local l = pc.get_player_id()
                pc.select(sp)                
                say("Mesajın Ne ")
                say("Mesajını Kutuya Yaz. ")
                local message = input()
                say_title(mob_name(npc.get_race())..":")
                say("")
                ---
                if(tostring(message) == nil or message == "") then
                    say("Mesaj Yaz. ")
                    return
                end
                mysql_query("insert into player.inbox values ('"..l.."','"..pc.name.."','"..message.."') ")
                say("Mesaj Başarı İle Gönderildi. ")
                say("Sonra Görüşürüz ")
            end
        end
    end
end 
04/27/2013 11:24 Kurosaki70#43
Translate french?:3
08/28/2013 13:57 .RUVision#44
In wie fern unterscheidet sich das hier zu dem?
[Only registered and activated users can see links. Click Here To Register...]
08/28/2013 19:12 thewizard111#45
Thanks 4 sharing
Page 3 of 4 12 3 4