Life

I did this a long time ago.

I vaguely remember the steps.

Replace the DB cache for 34k

Replace gamefile

Add the lib no_txt_db

have a 34k supported client

I may be missing some other things.

 

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

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?

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)

Is it possible to make a lib for 34k game ?

Is it possible to make a lib for 34k game ?

Excellent! 

In root

I do not have that bug, So i'm guessing it's just you

What overflowing db bug?

The only error i have is i cannot see any items in inventory but i can see it when i connect the test client so therefore it's all working fine if you do it correctly. Once i'v somehow upgraded the client, i'll let you know how i did it.

I am using invoice currently trying to upgrade to 4k from 34k. I managed to upgrade the server side successfully now i'm trying to upgrade the client too. Just replace the dbcache and gamefile from vanilla on serverside and upload the libs mentioned on the "read me" text document.

Install invoice v2 and then just upgrade to the 4k core,

I just did that now i'm trying to upgrade my client too (This is hard)

Edit: Found Soloution

Apply this Dif to gamefile

Is it invoice files?

There is a DIF to fix that. Which gamefile do you use?

 

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? 

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?

Currently I am watching the Trasnformers trilogy because the 4th episode is coming and I do not remember the story

 

The last movie what I saw the (Booooring)"Gravity".

The 4th one is not linked with the story, 

It's a new story line, new cast , new everything!

Perfect (Y)

does the exp table editor work on r34083?

Sema is selling these systems

Can someone help me with the quest please, instead of it finding the TR amount from the questflag, i want it to find it from mysql, and when buying something from the TR shop, it reduces TR from database.