Jump to content

Life

Inactive Member
  • Posts

    61
  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by Life

  1.  

    Ok now it found, but when i make in navicat coins or cash > 0 in game it was always 0.. i have the quest on winscp. and i have this error on putty:

     
    mysql: ambiguous option '--e=SELECT coins from account.account WHERE id=3 LIMIT 1;' (enable_cleartext_plugin, execute)

     

     

    If your using invoice or 34k replace mysql function with this one http://www.elitepvpers.com/forum/metin2-pserver-guides-strategies/2059867-r-mysql-function.html

    • Metin2 Dev 1
  2. Hi, How do i make this return 

    function getcoins()

    os.execute("mysql -u root player --execute='SELECT coins FROM player WHERE id = "..pc.get_player_id()..";'")

    end

    Like this:

    local a = mysql_query("SELECT coins from player.player WHERE id="..pc.get_account_id().." LIMIT 1;")[1][1]

    a = tonumber(a)

    return a

    (im using os.execute because i'm getting a error when i use mysql_query)

     

    any light on this?

  3.  
     
    0008A81D: 8B E9
    0008A81E: 95 6A
    0008A81F: DC C7
    0008A820: FD 05
    0008A821: FF 00
    000E6F8C: C0 8B
    000E6F8D: 74 85
    000E6F8E: 15 DC
    000E6F8F: 8B FD
    000E6F90: 45 FF
    000E6F91: F4 FF
    000E6F92: 33 25
    000E6F93: 05 FF
    000E6F94: 18 FF
    000E6F95: 14 FF
    000E6F96: 6A 7F
    000E6F97: 08 83
    000E6F98: 75 F8
    000E6F99: 18 02
    000E6F9A: 8B 7E
    000E6F9B: 5D 05
    000E6F9C: F8 B8
    000E6F9D: 8B 00
    000E6F9E: 75 00
    000E6F9F: FC 00
    000E6FA0: 89 00
    000E6FA1: EC 89
    000E6FA2: 5D C2
    000E6FA3: C3 E9
    000E6FA4: 89 7B
    000E6FA5: 74 38
    000E6FA6: 24 FA
    000E6FA7: 04 FF
     
     

    Apply this Dif to gamefile

    • Love 1
  4.  

    Need for Speed was the last movie which i saw.

    And it is much better than every fast & furious.

    Kind regards

    Chuck

    I really enjoyed the new need for speed movie, although i don't agree is much better than fast & furius, i think both are pretty good.

     

     

    You guys got a link for 720p?  :rolleyes:

  5. This quest is with mysql:

    quest achievement begin
    	state start begin
    		function getcoins()
    			local a = mysql_query("SELECT * FROM player.player WHERE id = "..pc.get_player_id().."")
    			return a.coins[1]
    		end
    		function addcoins(coins_ammount)
    			local a = mysql_query("UPDATE player.player SET coins = coins+"..coins_ammount.." WHERE id = "..pc.get_player_id().."")	
    		end
    		function removecoins(coins_ammount)
    			local a = mysql_query("UPDATE player.player SET coins = coins-"..coins_ammount.." WHERE id = "..pc.get_player_id().."")	
    		end		
    		function buy(id,count)
    			pc.give_item2(id,count)
    		end		
    		when 20095.chat."Sklep Osiagniec " begin
    			cmdchat("SetIsNpc")
    			npc.open_shop(16)
    			setskin(NOWINDOW)
    			cmdchat("SetPrice 200|200|200|200|200|0|0|100|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0")
    		end
    		when login begin
    			cmdchat("SetQuestIndex "..q.getcurrentquestindex())
    			cmdchat("setPP "..tonumber(achievement.getcoins()))
    		end
    		when button or info begin
    			local items = {
    				[0]={71124, 1, 200},
    				[1]={71125, 1, 200},
    				[2]={71126, 1, 200},
    				[3]={71127, 1, 200},
    				[4]={71128, 1, 200},
    			}
    			local slot = tonumber(achievement.GetInput("GetInput"))
    			if achievement.getcoins() >= items[slot][3] then
    				achievement.removecoins(tonumber(items[slot][3]))
    				cmdchat("setPP "..tonumber(achievement.getcoins()))
    				achievement.buy(items[slot][1], items[slot][2])
    			else
    				cmdchat("NieMamPP")
    			end
    		end
    		function GetInput(value)
    			cmdchat("GetInputStart")
    			local ret = input(cmdchat(value))
    			cmdchat("GetInputStop")
    			return ret
    		end
    	end
    end

     

    Use console to add this to player.player

    ALTER TABLE player.player ADD coins int(11) NOT NULL;

    *Not tested*

    The inventory shows 1234567, any solution?

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.