[SAMMELTHREAD] Game Source Changes

Quote:

Originally Posted by Zonni This little enhancement can be use to record every whisper in game (useful stuff for GameMasters). Firstly include db.h in input_main.cpp. Secondly find 502 line in input_main.cpp (shown under) Code: if (LC_IsEurope() != true) { sys_log(0, "WHISPER: %s -> %s : %s", ch->GetName(), pinfo->szNameTo, buf); } And simply replace with this: Code: if (LC_IsEurope() == true) { char szQuery_WLog[1024+1]; snprintf(szQuery_WLog, sizeof(szQuery_WLog), "INSERT INTO whispers (from_msg, to_msg, msg_text) VALUES ('%s', '%s', '%s');", ch->GetName(), pinfo->szNameTo, buf); std::auto_ptr<SQLMsg> pmsg(DBManager::instance().DirectQuery(szQuery_WLog)); } Finally execute this query in player database: Code: CREATE TABLE `whispers` ( `id` int(20) NOT NULL AUTO_INCREMENT , `from` varchar(24) NOT NULL DEFAULT 'error' , `to` varchar(24) NOT NULL DEFAULT 'error' , `msg` varchar(250) NOT NULL DEFAULT 'empty_msg_error' , PRIMARY KEY (`id`) ); CHANGE COLUMN `from` `from_msg` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'error' AFTER `id`, CHANGE COLUMN `to` `to_msg` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'error' AFTER `from_msg`, CHANGE COLUMN `msg` `msg_text` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'empty_msg_error' AFTER `to_msg`; Well done, you have Whisper log in your server (i'm not sure it right works, because i dont know what collation i must set in mysql so - MARKED AS UNTESTED but should work without any problem.)

std::auto_ptr<SQLMsg> pmsg(DBManager::instance().DirectQuery(szQuery_WLog));

std::auto_ptr<SQLMsg> pmsg(LogManager::instance().Query(szQuery_WLog));

Quote:

Originally Posted by Adasaurus Or change the line Code: std::auto_ptr<SQLMsg> pmsg(DBManager::instance().DirectQuery(szQuery_WLog)); with Code: std::auto_ptr<SQLMsg> pmsg(LogManager::instance().Query(szQuery_WLog)); To the table 'whispers' in log database?

Quote:

Originally Posted by Zonni I'm not sure, try ;) BTW. If your mysql user which is set in config file have access to the log and player databases, simply change "INSERT INTO whispers" to "INSERT INTO log.whispers" and should work & save in log database ;)

//NEWTHATGUYPT - Whisper Logging Function
void LogManager::WhisperLog(const char * from, const char * to, const char * message)
{
	m_sql.EscapeString(__escape_hint, sizeof(__escape_hint), message, strlen(message));

	Query("INSERT INTO whisper_log (from_msg, to_msg, msg_text) VALUES ('%s', '%s', '%s')", from, to, __escape_hint);
}

//NEWTHATGUYPT - Whisper Logging Function
void		WhisperLog(const char * from, const char * to, const char * message);

if (LC_IsEurope() != true)
{
	sys_log(0, "WHISPER: %s -> %s : %s", ch->GetName(), pinfo->szNameTo, buf);
}

//NEWTHATGUYPT - Adds Whispers to Log Database
LogManager::instance().WhisperLog(ch->GetName(), pinfo->szNameTo, buf)
;

DROP TABLE IF EXISTS `whisper_log`;
CREATE TABLE `whisper_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `from_msg` varchar(24) NOT NULL DEFAULT 'error',
  `to_msg` varchar(24) NOT NULL DEFAULT 'error',
  `msg_text` varchar(250) NOT NULL DEFAULT 'empty_msg_error',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

Quote:

Originally Posted by xCPx Das konnte man davor auch schon... war sogar relativ einfach... Nur die modelle hätte jemand neu machen müssen

Quote:

Originally Posted by TheMarv :< You should make sure to remove the calls to the ymir server, or they'll get your ip, or idk what from your computer ;) hätte man nicht O.o man hätte die nur exportieren müssen, würden aber trotzdem gleich aussehen xD

Quote:

Originally Posted by RageAtMeBros I already posted the bypass to this. Well, just a quick update with a proof of concept of my brand new quest function named "pc.getlang". Hope you enjoy and can figure out the infinite aplications of this whole new function: [Only registered and activated users can see links. Click Here To Register...] For example, using this and setting the .when files of the quests of the server I could translate the whole NPCs into infinite languages, including the options which I think that is whole new (I have not been much deep into metin2 stuff tho). I could also for the Missions concatenate the lang + name of the arrays from the gameforge translate.lua to translate the whole server. Aditionally and recoding part of the client-server architecture I could easily let the NPC names, mob names and so long, aswell as the mob messages and npc messages (the ones who show on top of them), and item_proto messages (like "You recieved Sword+0") at the client side, having a complete multi-language server.

Quote:

Originally Posted by TheMarv :< just for the license server, not the rest :)

Quote:

Originally Posted by RageAtMeBros Tell me exactly where they are please.

Quote:

Originally Posted by ƬheGame The ip from ymir it connects to is "202.31.178.251" but its down (It's not just you! [Only registered and activated users can see links. Click Here To Register...] looks down from here. also no answer to ping.

Quote:

Originally Posted by ƬheGame The ip from ymir it connects to is "202.31.178.251" but its down (It's not just you! [Only registered and activated users can see links. Click Here To Register...] looks down from here. also no answer to ping.