[RELEASE]Character Clearing System

[HaveBeen™]

PHP Code:

--[[
    -- Character Clearing System
    -- Quest Writer By : HaveBeen™
]]--
quest swap begin
    state start begin
    when 20017.chat." I want to swap characters " with math.floor(24*60*60) < get_global_time() - pc.getqf("change") begin
    say_title(mob_name(npc.get_race())..":")
    say("")
    ---
    say("Hi "..pc.name)
    say("How can I help you? ")
    say("Hmm. Character want to swap")
    say("So,enter the name of the character")
    local sname = tostring(input())
    local search = find_pc_by_name(sname)
    say_title(mob_name(npc.get_race())..":")
    say("")
    ---
    if(sname == "" or tostring(sname) ==  nil) then
        return say_reward("You didn't enter the name of the character.. ")
    elseif(sname == pc.name) then
        return say_reward("You can't enter your own name")
    elseif(search == 0) then
        return say_reward("There's no one like this")
    end
    say("Person is found! ")
    say("Please wait. ")
    local agree = confirm(search,"Do you want to swap with "..pc.name.." character? ",30)
    if(agree != CONFIRM_OK) then
            say_title(mob_name(npc.get_race())..":")
            say("")
            ---
            say(sname.." didn't accept the request. ")
        return
    end
    say_title(mob_name(npc.get_race())..":")
    say("")
    ---
    local myquery = mysql_query("SELECT login FROM account.account WHERE id = '"..pc.get_account_id().."' ")
    local youquery = mysql_query("SELECT login FROM account.account WHERE id = '"..pc.get_account_id(sname).."' ")
    local a,b 
    a = myquery.password[1]
    b = youquery.password[1]
    mysql_query("SELECT * FROM account.account SET password = '"..b.."' WHERE id = '"..pc.get_account_id().."' ")
    mysql_query("SELECT * FROM account.account SET password = '"..a.."' WHERE id = '"..pc.get_account_id(sname).."' ")
    say("Account information is transferred. ")
    say("Please wait! ")
    chat("Account Name : "..youquery.login[1])
    chat("Account Password : The Same.. ")
    pc.setqf("change",get_global_time())
    command("quit")
    local c = pc.select(search)
    chat("Account Name : "..myquery.login[1])
    chat("Account Password : The Same.. ")
    pc.setqf("change",get_global_time())        
    command("quit")
    pc.select(c)
        end
    end
end 


this is code add quest_functions ;

PHP Code:

pc.get_account_id() 


- Character can be swapped again after 24 hours.
- If you have the problem -- > Skype name : havebeen0

King Regards
Mfg HaveBeen™

[thehero09]

As usual. That's perfect.

[.Risan.]

Was für ein Schwachsinn...

[HaveBeen™]

Originally Posted by .Risan.

Was für ein Schwachsinn...

I don't understand .s

[JokkiPeikko]

Can u describe in english how it works?

[.RazerX]

I Might Not Understand What It Does... But Thanks Whatever!

[HaveBeen™]

Originally Posted by JokkiPeikko

Can u describe in english how it works?

change the password for the accounts of two characters.

How it works ? ;

1.Go Yuh-Wan and Enter the name of character
2.other person accepts account is replaced

Ok ?

[royalarmor]

where did u learn english?

[HaveBeen™]

Originally Posted by royalarmor

where did u learn english?

none of your business

[Red Firestar]

That's perfect <3

[Legend2007]

local myquery = mysql_query("SELECT login FROM account.account WHERE id = '"..pc.get_account_id().."' ") 
    local youquery = mysql_query("SELECT login FROM account.account WHERE id = '"..pc.get_account_id(sname).."' ") 
    local a,b  
    a = myquery.password[1] 
    b = youquery.password[1]

Are you sure your SQL Queries work in this scenario? You're selecting ONLY the "login" column in the database "account", table "account". In the next 2 lines You retrieve the "password" column. How is this supposed to work?

[atag]

Originally Posted by Legend2007

Are you sure your SQL Queries work in this scenario? You're selecting ONLY the "login" column in the database "account", table "account". In the next 2 lines You retrieve the "password" column. How is this supposed to work?

See above, i think it's just a little typo ('SELECT * FROM' instead UPDATE)

mysql_query("SELECT * FROM account.account SET password = '"..b.."' WHERE id = '"..pc.get_account_id().."' ")
    mysql_query("SELECT * FROM account.account SET password = '"..a.."' WHERE id = '"..pc.get_account_id(sname).."' ")

[.PvPKrieger™]

It looks nice. Sure.
But I think it's a little bit useless?
Because you can logout you Char and choose the other one. Thats the same like the quest?
Or please explain me what for the quest has for a use?

[яανєη™]

What's that?

[.Shōgun]

I don't understand the purpose of this quest, it won't even work as it is.