[SAMMELTHREAD] Game Source Changes

[RageAtMeBros]

Hello Elitepvpers

After the source been released to public I think that diffs don't make any more sense as people will start working on their own revs and diffs won't work on all the devs. So I made this thread to compile the important changes we made.

Changelog:

 Spoiler

Important Changes:

 Spoiler

Fix for Licence Check at YMIR Server (main.cpp - function Metin2Server_Check) - RageAtMeBros

 Spoiler

void Metin2Server_Check()
{
g_isInvalidServer = false;
}

Fix for External IP Bug (People Getting disconnected after connecting to your server) - RageAtMeBros

BIND_IP: <YOUR PUBLIC IP>

In CONFIG file

 Spoiler

config.cpp:

 Spoiler

char g_szExternalIP[16] = "0";

----

else if (g_szPublicIP[0] == '0')
{
strlcpy(g_szPublicIP, g_szExternalIP, sizeof(g_szPublicIP));
#ifndef __WIN32__
fprintf(stderr, "PUBLIC_IP: %s interface %s\n", g_szExternalIP, ifap->ifa_name);
#else
fprintf(stderr, "PUBLIC_IP: %s\n", g_szExternalIP);
#endif
}

---

if (!GetIPInfo())
{
strlcpy(g_szPublicIP, g_szExternalIP, sizeof(g_szPublicIP));
}


---


TOKEN("bind_ip")
{
strlcpy(g_szPublicIP, value_string, sizeof(g_szPublicIP));
strlcpy(g_szExternalIP, value_string, sizeof(g_szExternalIP));
}

Changes:


Thanks to:

 Spoiler

-

#LAST UPDATE:
01-01-2013 18:10

[~Ok]

Thanks bro

[RageAtMeBros]

Originally Posted by ~Ok

Thanks bro

No problem. By the way you have to put
BIND_IP: <YOUR PUBLIC IP>

In CONFIG file

[MatthewHun]

Thanks. About the compile is not some description? I've tried and I've got two files, they should have put it together somehow.

[Mi4uric3]

If someone posts something here please do not copy his stuff just link to his post so anyone who uses it can thank the author for his contribution

[RageAtMeBros]

Originally Posted by Mi4uric3

If someone posts something here please do not copy his stuff just link to his post so anyone who uses it can thank the author for his contribution

Okay man.

And it should be easier to read aswell, thx for the tip.

[miguelmig]

Originally Posted by Mi4uric3

If someone posts something here please do not copy his stuff just link to his post so anyone who uses it can thank the author for his contribution

I agree, the ones that publish stuff should deservesome recognition.
EDIT: Tested and seems to be working.

[.MaisKolben™]

I don't know, but i think if you posting part's of the source with changes it is not really legal, because of copyrights etc..
If you read the rules, you will know this is not allowed.

Kind regards

[deco016]

Mysql function in quest:
In questlua_global.cpp

 Spoiler

before:

void RegisterGlobalFunctionTable(lua_State* L)

add this code:

	int mysql_do_query(lua_State* L)
	{
		int i=1;
		MYSQL_FIELD *field;
		SQLMsg* run = DBManager::instance().DirectQuery(lua_tostring(L,1));
		MYSQL_RES* res=run->Get()->pSQLResult;
		if (!res){
			lua_pushnumber(L, 0);
			return 0;
		}
		MYSQL_ROW row;
		lua_newtable(L);			
		int rowcount = 1;
		while(row = mysql_fetch_row(res)){
			lua_newtable(L);
			lua_pushnumber(L, rowcount);
			lua_pushvalue(L, -2);
			lua_settable(L, -4);
			unsigned int fields = mysql_num_fields(res);
			for(int i = 0; i < fields; i++){
				lua_pushnumber(L, i + 1);
				lua_pushstring(L, row[i]);
				lua_settable(L, -3);
			}
			lua_pop(L, 1);
			rowcount++;
		}
		return 1;
	}

after

{	"get_special_item_group",		_get_special_item_group			},

add new line

			{	"mysql_query",		mysql_do_query			},

Save and compile, in quest usage:

 Spoiler

quest libmysql begin
state start begin
when login begin
local mysql =mysql_query("SELECT name,level FROM player.player LIMIT 2")
say("Player 1: "..mysql[1][1].." Lv. "..mysql[1][2])
say("Player 2: "..mysql[2][1].." Lv. "..mysql[2][2])
end
end
end

quest libmysql begin
state start begin
when login begin
local mysql = mysql_query("SELECT name,level FROM player.player LIMIT 2")
for key,value in pairs(mysql) do
say("Player"..key..": "..value[1].." Lv. "..value[2])
end
end
end
end

quest libmysql begin
state start begin
when login begin
mysql_query("UPDATE player.player SET level=99 WHERE level>99")
end
end
end

[deco016]

Originally Posted by .Risan.

this is from Sonice ....

No, this is my source , i wrote this for Sonice.

[Metin2 Team]

#LAST UPDATE:
01-01-2013 18:10

xD 2014

[siemka256]

Originally Posted by deco016

No, this is my source , i wrote this for Sonice.

@deco016 you know Source of Game 40250?

[Mario23231]

-

[Laben]

Originally Posted by Metin2 Team

xD 2014

eheheheh

[deco016]

Originally Posted by siemka256

deco016 you know source of game 40250?

yes