mysql_query("UPDATE

[MrLibya]

Hallo

I Made A Quest To Change Plyer Name + Level So I Write Like That :

                mysql_query("UPDATE player.player SET name="..string.format("%q","[Test]"..pc.get_name()).." WHERE id = "..pc.get_player_id())
                mysql_query("UPDATE player.player SET level=1 WHERE id = "..pc.get_player_id())

But Not Work , Is There Any Thing Wrong ?

[.yorliK]

Do you give the database enough time to update? The player has to logout for some minutes.

mysql_query("UPDATE player.player SET name='[Test]"..pc.get_name()).."' WHERE id = '"..pc.get_player_id().."';")
mysql_query("UPDATE player.player SET level=1 WHERE id = '"..pc.get_player_id().."';")

[MrLibya]

I Know But see


When I Select Yes He Say Some Word Then Make Notice
But In The Game When I Select Yes He Just Close The Windos without any wrods , notice
+ nothing change in level or name , even if i logout

[Lord iRemix]

mysql_query("UPDATE player.player SET name='"..string.format("%s","[Test]"..pc.get_name()).."' WHERE id = "..pc.get_player_id())

[Coniesan]

U have to note, that the game is caching big data parts and syncs it every 8-10min with the database. So u'r methode don't work cause u have w8 (logged out) till the game is syncing.
Would use the "default" Quest for that:

 Spoiler

quest chagne_name begin
 state start begin
  when 71055.use begin
   if pc.is_married() then
    say("You cannot change your name if you are married.")
    say("")
    return
   end

   if pc.is_polymorphed() then
    say("You cannot change your name if you are transformed.")
    say("")
    return
   end

   if pc.has_guild() then
    say("You cannot change your name if you are in the guild. ")
    say("")
    return
   end

   if party.is_party() then
    say("You cannot change your name if you are in group.")
    say("")
    return
   end

   if pc.get_level() < 50 then
    say("You cannot change your name if your level is not higher than lever 49.")
    say("")
    return
   end

   if get_time() < pc.getqf("next_time") then
    say("You can not use it now.")
    say("")

    if is_test_server() == true then
     say("Since it's test server, you can go")
     say("")
    else
     return
    end
   end

   say("Please enter the name you want to have") ;

   local name = pc.name ;
   local str = input() ;

   local ret = pc.change_name(str) ;

   if ret == 0 then
    say("You didn't log in after you have changed your name.")
    say("please re-log in.")
    say("")

    char_log(0, "CHANGE_NAME", "HAVE NOT RE-LOGIN")
   elseif ret == 1 then
    say("The problem occured while using the item.")
    say("Please use again.")
    say("")
    
    char_log(0, "CHANGE_NAME", "ITEM USE PROBLEM")
   elseif ret == 2 then
    say("The name is not available.")
    say("Please enter other name.")
    say("")

    char_log(0, "CHANGE_NAME", "CAN NOT USE NAME")
   elseif ret == 3 then
    say("The name is not available.")
    say("Please enter other name.")
    say("")

    char_log(0, "CHANGE_NAME", "ALREADY USING NAME")
   elseif ret == 4 then
    say("You have changed your name successfully.")
    say("Please log in again.")
    say("")

    item.remove() ;

    pc.setqf("next_time", get_time() + time_hour_to_sec(24*15))

    char_log(0, "CHANGE_NAME", "SUCCESS: from "..name.." to "..str)
   else
    say("Unknown error occured.")
    say(ret)

    char_log(0, "CHANGE_NAME", "UNKNOWN NAME")
   end
  end
 end
end

[MrLibya]

Originally Posted by [iRemix]

mysql_query("UPDATE player.player SET name='"..string.format("%s","[Test]"..pc.get_name()).."' WHERE id = "..pc.get_player_id())

Same

Originally Posted by Coniesan

U have to note, that the game is caching big data parts and syncs it every 8-10min with the database. So u'r methode don't work cause u have w8 (logged out) till the game is syncing.
Would use the "default" Quest for that:

 Spoiler

quest chagne_name begin
 state start begin
  when 71055.use begin
   if pc.is_married() then
    say("You cannot change your name if you are married.")
    say("")
    return
   end

   if pc.is_polymorphed() then
    say("You cannot change your name if you are transformed.")
    say("")
    return
   end

   if pc.has_guild() then
    say("You cannot change your name if you are in the guild. ")
    say("")
    return
   end

   if party.is_party() then
    say("You cannot change your name if you are in group.")
    say("")
    return
   end

   if pc.get_level() < 50 then
    say("You cannot change your name if your level is not higher than lever 49.")
    say("")
    return
   end

   if get_time() < pc.getqf("next_time") then
    say("You can not use it now.")
    say("")

    if is_test_server() == true then
     say("Since it's test server, you can go")
     say("")
    else
     return
    end
   end

   say("Please enter the name you want to have") ;

   local name = pc.name ;
   local str = input() ;

   local ret = pc.change_name(str) ;

   if ret == 0 then
    say("You didn't log in after you have changed your name.")
    say("please re-log in.")
    say("")

    char_log(0, "CHANGE_NAME", "HAVE NOT RE-LOGIN")
   elseif ret == 1 then
    say("The problem occured while using the item.")
    say("Please use again.")
    say("")
    
    char_log(0, "CHANGE_NAME", "ITEM USE PROBLEM")
   elseif ret == 2 then
    say("The name is not available.")
    say("Please enter other name.")
    say("")

    char_log(0, "CHANGE_NAME", "CAN NOT USE NAME")
   elseif ret == 3 then
    say("The name is not available.")
    say("Please enter other name.")
    say("")

    char_log(0, "CHANGE_NAME", "ALREADY USING NAME")
   elseif ret == 4 then
    say("You have changed your name successfully.")
    say("Please log in again.")
    say("")

    item.remove() ;

    pc.setqf("next_time", get_time() + time_hour_to_sec(24*15))

    char_log(0, "CHANGE_NAME", "SUCCESS: from "..name.." to "..str)
   else
    say("Unknown error occured.")
    say(ret)

    char_log(0, "CHANGE_NAME", "UNKNOWN NAME")
   end
  end
 end
end

Did You Read My Reply ?

[Coniesan]

Originally Posted by MrLibya

Did You Read My Reply ?

Honestly no.
So it's changing the name and level after relogg, but doesn't execute the say() functions?!
Does u'r syserr sais anything?

[MrLibya]

Originally Posted by Coniesan

Honestly no.
So it's changing the name and level after relogg, but doesn't execute the say() functions?!
Does u'r syserr sais anything?

My Syserr Sleep
Just Kidding :

SYSERR: Sep 29 01:36:21 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 01:41:19 :: heart_idle: losing 182 seconds. (lag occured)
SYSERR: Sep 29 01:42:02 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 01:42:27 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 01:49:35 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 01:49:42 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 01:50:19 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log  VALUES (NOW(), 8, 27001, 78) errno: 1136)
SYSERR: Sep 29 01:50:19 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: INSERT DELAYED INTO money_log  VALUES (NOW(), 8, 27002, 874) errno: 1136)
SYSERR: Sep 29 01:52:38 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 01:52:45 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 01:53:26 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 01:53:32 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 01:54:09 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 01:54:11 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 02:32:17 :: heart_idle: losing 111 seconds. (lag occured)
SYSERR: Sep 29 02:33:03 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 02:33:12 :: Select: wrong QUEST_SELECT request! : 57766
SYSERR: Sep 29 02:34:55 :: heart_idle: losing 38 seconds. (lag occured)
SYSERR: Sep 29 02:35:21 :: operator(): QUEST NOT END RUNNING on Login/Logout - PRO
SYSERR: Sep 29 02:35:42 :: Select: wrong QUEST_SELECT request! : 57766

UP
UP