TMP4

33 minutes ago, snapkode said:

@ TMP4 If I want to put that on a Dedicated server, 16gbram , FreeBSD 12.2 64bit , that work ? And how I can must do that ? Upload compiled game/dB and start the server ?

  While it is dedicated for the Metin2 Project 2014.1 | Kraizy Updated Edition, it's a good thread to start with.

Basicly you need to install mysql5.6, python(2.7), gdb(optional), DevIL.
When you start the server and it's says xy lib missing, try to google what package contains them and install that package instead of downloading the lib itself from the internet. (You can do that too, to your own risk..)

12 minutes ago, Hik said:

After compiling, if I try to start the launcher, I get this error:

 

LoginWindow.__LoadScript.LoadObject - <type 'exceptions.OverflowError'>:Python int too large to convert to C long

 

 

Can you tell me if it depends on my client?

You have max gold (or anything that you changed from int to long) in your root python files.

Either add max gold to your launcher or remove it from your python like "money = long(text)" --> money = int(text) (There are several occurances of long(x)...)

local affected_rows, goldd = mysql_direct_query("SELECT gold FROM player.player WHERE name = '"..pc.get_name().."';"
local current_gold = goldd[affected_rows]["gold"]
say_reward(tostring(current_gold))
if current_gold < 5 then
	say_reward("You have less then 5 gold.")
else
	say_reward("You have 5 or more gold.")
end

I changed the query's WHERE from account_id to name because you could have up to 4 affected rows with account_id and
"goldd[affected_rows]["gold"]" would only return the last one that may not the current character.

For example if you have 4 character in your acc and uses account_id then the second character's gold is goldd[2]["gold"]).
Affected_rows returns the max value so it's always the lasts if you use that. If it's 1 like in my example, it is good to use, but you can replace it with 1 if you wish.

Edit: Anyone who just read this and thinking pc.get_gold() exists, well yes but this is just a query practice example 

39 minutes ago, dastro said:

Bu ve TMP4 projesi arasındaki fark nedir? Hangisini kullanmalıyım?

What is difference this and TMP4 project? What to use?

Kraizy Updated Edition provides you some updates for 40k, like you can use it with MySQL8 instead of MySQL5.6 and the source is ported to x64 platform, so you can compile it in x64 FreeBSD instead of x32/i386. You may have to solve some bugs on your own until ASIKOO releases a new version.

The "TMP4 Project" is a reference 40k serverfile with 15 languages to choose, but no x64 port, no MySQL8 compatibility by default, instead I provided bug fixes for the most bugs and exploits what a basic 40k serverfile have. 

What to use? It's all on you.

11 minutes ago, dastro said:

Teşekkürler!

Bir sunucu açmak için doğrudan vps'ye koyabilir miyim?

Please use english. If you ask you can put this on a vps, then yeah, why the hell not?

4 minutes ago, Veltor88 said:

 

Damn lol. I knew about locale string builder but I assumed greek is missing 

Greek locale_string: 

(If you want to read then set your notepad++ character encoding to greek->windows-1253, but do not do any conversion)

I Made it via Google Translate but I think the translations are not that bad, I translated some random rows back from greek to english and hungarian and they were pretty good.

Edit: Changed the link to original translate.

8 hours ago, Jimmermania said:

Hello.

First of all , nice work. Keep going. 

Second, from your serverfiles, locale_string_GR is missing. Could you share it please ?

Downoad link: 

(If you want to read then set your notepad++ character encoding to greek->windows-1253, but do not do any conversion)

I'll include this in the next update, but anyone feel free to download it until then.

Edit:

2021.09.07: - 6-7 bonus add/switch blocked on equipped items. (char_item.cpp case 71051 & 71052)
            - Fixed gameland's (gm_guild_build) server_attr.
            - Added the missing locale_string_GR.txt.
            - Removed unused dll files from the client.

3 minutes ago, blaxis said:

Thank you it worked.

SELECT gold FROM player.player WHERE account_id = 2

But it always shows the result as 1.

 Use as I said: local affected_rows, gold = mysql_direct_query("SELECT gold FROM player.player where id = 2")

If you use only local gold, you will get the affected_rows's value only, despite the variable name. (Variable name does not matter, the gold will be the second value, and the affected rows will be the first one even if you name it as gold.)

4 hours ago, Jimmermania said:

Hello.

First of all , nice work. Keep going. 

Second, from your serverfiles, locale_string_GR is missing. Could you share it please ?

Yes locale_string_gr is missing as i wrote in language.txt (only that, other languages are full).
As I stated in the first post, locale_strings, translate.luas are from m2dev threads, I did not made them, of course I can't speak 15 languages, I can't speek greek.

Best I can do in the future is to write some python/c# tool what translates every 2. (the english) line to greek via google translate but currently I'm having peak days, can't say any estimate time. Edit: Actually the original translate files available, please wait.

Add martysama's mysql_direct_query function to your source: https://www.google.com/search?q=mysql_direct_query+epvp+lollo_9_1
Then you can use local affected_rows, gold = mysql_direct_query("SELECT gold FROM player.player where id = 1")

31 minutes ago, Akihiro said:

Hello @ TMP4,
I've already done this, but still got this error.
Also i've change the tables to the default ones, but still got this error.

So are you saying both table have the same collation but the mysql server thinks otherwise?
Bruh that's some black magic what is beyond my knowledge.
Jokes aside please check again the collations, you may have not saved the tables.
It is also possible after you fixed the collation you still got some nasty syserr but it was different what you did not notice.

If you 100% sure that both table have the same collation and this is actually the current syserr then maybe you are changing collation for one table in runtime, like you set a collation query in your source when you initialize this (offline?) shop system.

25 minutes ago, Akihiro said:

up

So you're using latin1_swedish_ci and latin2_general_ci, those are the collations of your 2 table. (player_shop_items, player_shop)

The error says "Illegal mix of collations"...

I'm not an expert of mysql but I have a common sense so what if you choose same collation for that 2 table? Then the mix is gone.

 

6 hours ago, darkfun3 said:

helloo is the database compatible with other versions of mysql as i saw it was on 5.6 on the virtual machine and i would like to upgrade to 8 

kind regards

Obviously it's not by default. 

Here's a great thread to starth with: https://metin2.dev/board/topic/24662-mysql56-to-mysql8/
If you need any help with the upgrade please use Questions & Answers.

 

On 9/2/2021 at 4:46 PM, kupa300 said:

solution change language, at the end of the last step in the root folder I can't find the file to change the language, last step in the root folder the files do not come out ... how do I

Enable hidden files in your ftp client. But that only the alias for compiling quests, just for convenience.

1 minute ago, ScroBo said:

i think it is the best solution to have 64 on dedic and 32 only to compile on computer with vm

Yeah anyway players would have high lags when you compile the src on your live server 

 

31 minutes ago, Veltor88 said:

  

Sorry but you don't set a good example 

He owes nothing to no one. He gives his time for a free service, if you're not happy it's the same 

Thanks

I would rather call this a free release instead a free service, because that's why some people wants me to do stuffs for their server if they choose my serverfile to start with 

12 minutes ago, ScroBo said:

hey guys one question for that server files

if i would like to make it on dedicated maschine all i need is to install: mysql python gmake makedepend gdb llvm devel? or some programs also i need?

I believe they're all, maybe you need devil (from graphics). But when you start db-game you'll see at console what lib you are missing and you can find with google what package contains it.

(To compile the source you need more like cryptopp)

But keep in mind I'm not provide x64 port for source, you can run the compiled game-db in x64 machine but you must compile it in x32 system like the vm I provided.

 

By the way paying for bitcoin via paypal is always a high risk because of refunds. Even if the payment sent as family & friends, refunds can still happen. There are 2 refund types there: Bank chargeback & via customer service. That's why pretty much none of the btc exchanger accepts paypal.

(Yes I see it is an old thread, I just wanted to share my thoughts)

2 minutes ago, Brayle said:

Yes that's why I said clients. Leaving clients without assistance is bad and I can't change my mind about it.

So first of all I'm not leaving my "clients" without assistance, I just don't have time to help my "clients" installing or developing new systems or so for free. That's not my responsibility. BUT! I already released 6 updates and I pretty much resolved every bugs what my "clients" reported me. That's still not my responsibility but I did them because I wanted to keep this thread maintaned.

3 minutes ago, kupa300 said:

I can not download

You have 2 option, mega.nz and metin2.download center. That should be fine enough.
And answering to your dm: No.

----------------------------------------------------------------------------------------

Please everybody, do not dm me here and discord if you need help with your private metin2 server even if you choose my reference serverfile.
If you need help you can find here: https://metin2.dev/board/forum/35-questions-answers/
If you need a service (a developer for your metin2 server) try here: https://metin2.dev/board/forum/46-searching/

Don't get me wrong, anybody can keep reporting bugs even in dm (but better here), I'm talking about the situation where people thinks that because they downloaded my free release, I should be their free developer to do stuffs  No I will not, I'll leave all these DMs unanswered from now, sorry.

5 minutes ago, ScroBo said:

hi help please, after changing language freebsd say:

common_sql says invalid locale key polish

and client cant connect to game

 

The correct one for PL is poland. Just as I wrote in the insturction.

6 minutes ago, SmyleMDFK said:

Yes it's the original ymir template.. the img file are the first and next are images for ranks ant another categories.

Yeah sorry there are "img" and "images" folder and I looked the "images" what have some other design but the "img" folder have the classic one.

37 minutes ago, SmyleMDFK said:

Hmm i have a this website with a new code .. its make with cms code .. here it's the link 

This is the hidden content, please

• Sign In
• or
• Sign Up

 this have 

This is the hidden content, please

• Sign In
• or
• Sign Up

encoded.

I checked it but that is a completly different design, did you upload the correct one to mega?

4 minutes ago, test423klein12ss3 said:

where can I specify for the login that I use sha1 for passwords?  for the registration I already managed it.

main/login.php

$check = "SELECT * from $account where login = '" . $user . "' and password = PASSWORD('$pw')";

 

9 hours ago, Alucard said:

Someone ?

 

On 11/3/2020 at 11:34 PM, ASIKOO said:

 Dead Download Link 

 Moved Topic 

 

If someone has the archive of this topic, can you send it to us? Thank you!

 

I think that it is, from 66dragon99. He published it to metin2hungary too and I usually save things from there to my ext hdd.