Lua [CTRL + R] Is it possible?

Guitar Freak · Mar 2, 2009

[CTRL + R] Is it possible? EDIT: 3 months and still NOT SOLVED.. any pr0s around?

Hello everyone, first of all, Im using TFS 0.3.2 (+ 8.4 client).

This time Im wondering if its possible to make a script so when people make reports in-game using CTRL + R, it creates a .txt file (or any extension if it is more convenient) on my server's folder called like "reports.txt" and then every subsequent report made in-game would appear there separated by commas, spaces, lines, numbers or whatever if possible.

(Like the file "Players Record.txt" that gets modified automatically when a player record is made in the server)

Or better yet, Id make a folder called like "Reports" and everytime someone makes a report it creates a file with the person's name or maybe the date of the report? Something like "Report 21/6/2009 15;03pm - Guitar Freak.txt" and it makes different .txts for every different report.

So, is this possible? If so, any tips on how to do this? Or does anyone have it and willing to share it? {Of course Ill + Rep}

Again, it would be for TFS 0.3.2.

Thanks in advance.
Guitar Freak~

Guitar Freak · Mar 3, 2009

~Bumpzor~

Markey · Mar 3, 2009

Yes, with sourceedit:
in game.cpp search for

Code:

bool Game::playerReportBug(uint32_t playerId, std::string bug)
{
	Player* player = getPlayerByID(playerId);
	if(!player || player->isRemoved())
		return false;

	Database* db = Database::getInstance();

	DBQuery query;
	query << "INSERT INTO `server_reports` (`id`, `world_id`, `player_id`, `posx`, `posy`, `posz`, `timestamp`, `report`) VALUES (NULL, ";
	query << g_config.getNumber(ConfigManager::WORLD_ID) << ", " << player->getGUID() << ", ";
	Position pos = player->getPosition();
	query << pos.x << ", " << pos.y << ", " << pos.z << ", ";
	query << time(NULL) << ", " << db->escapeString(bug.c_str()) << ");";
	if(!db->executeQuery(query.str()))
	{
		query.str("");
		return false;
	}

	query.str("");
	player->sendTextMessage(MSG_EVENT_DEFAULT, "Your report has been sent to " + g_config.getString(ConfigManager::SERVER_NAME) + ".");
	return true;
}

and replace the function with this:

Code:

bool Game::playerReportBug(uint32_t playerId, std::string bug)
{
	Player* player = getPlayerByID(playerId);
	if(!player || player->isRemoved())
		return false;
		
	//Create report file
	if(FILE* file = fopen("player_reports.txt", "a"))
        {
   	    char bufferDate[32];
            uint64_t tmp = time(NULL);
            formatDate(tmp, bufferDate);
            fprintf(file, "%s Report by %s: %s\n\n", bufferDate, player->getName().c_str(), bug.c_str());
            fclose(file);
        }

	Database* db = Database::getInstance();

	DBQuery query;
	query << "INSERT INTO `server_reports` (`id`, `world_id`, `player_id`, `posx`, `posy`, `posz`, `timestamp`, `report`) VALUES (NULL, ";
	query << g_config.getNumber(ConfigManager::WORLD_ID) << ", " << player->getGUID() << ", ";
	Position pos = player->getPosition();
	query << pos.x << ", " << pos.y << ", " << pos.z << ", ";
	query << time(NULL) << ", " << db->escapeString(bug.c_str()) << ");";
	if(!db->executeQuery(query.str()))
	{
		query.str("");
		return false;
	}

	query.str("");
	player->sendTextMessage(MSG_EVENT_DEFAULT, "Your report has been sent to " + g_config.getString(ConfigManager::SERVER_NAME) + ".");
	return true;
}

Not Testet!!!
Please try and tell me if it works...

Yours,
Markey

Guitar Freak · Jun 12, 2009

Bumpek~ Didnt work

Anyone out there knows how to do this for TFS 0.3.2?

It would be really useful!

Thanks in advance.

Guitar Freak · Jun 16, 2009

Guitar Freak said:
Bumpek~ Didnt work

Anyone out there knows how to do this for TFS 0.3.2?

It would be really useful!

Thanks in advance.

Bumpzor~

Guitar Freak · Jun 22, 2009

Bump.

Guitar Freak · Jun 24, 2009

BuMp.

Guitar Freak · Jun 25, 2009

BbbbUuuuMmmmPppp.

Any0n€?

Syntax · Jun 25, 2009

yeah dude dont worry bout it, its already scripted in 3.5 Release date is set for the 30th (5days from now)

CREATURE EVENT:
onReportBug(cid, comment)

LUA:

function onReportBug(cid, comment)
	local pos = getCreaturePosition(cid)
	if(db.executeQuery("INSERT INTO `server_reports` (`id`, `world_id`, `player_id`, `posx`, `posy`, `posz`, `timestamp`, `report`) VALUES (NULL, " ..
		getConfigValue('worldId') .. ", " .. getPlayerGUID(cid) .. ", " ..
		pos.x .. ", " .. pos.y .. ", " .. pos.z .. ", " ..
		os.time() .. ", " .. db.escapeString(comment) .. ")"))
	then
		doPlayerSendTextMessage(cid, MESSAGE_EVENT_DEFAULT, "Your report has been sent to " .. getConfigValue('serverName') .. ".")
	else
		doPlayerSendTextMessage(cid, MESSAGE_EVENT_DEFAULT, getConfigValue('serverName') .. " couldn't save your report, please contact with gamemaster.")
	end

	return true
end

You can edit that to work with it while you wait, (am I allowed to release that? Its not the server just a unsuable script unless people have it)

Don Daniello · Jun 25, 2009

You published donator's only content

You'll be hunted !
Rule violations channel is logged by default in /logs if you enable loggin in config.lua
Visit /XML/channels.xml

Delirium · Jun 25, 2009

Markey said:

Yes, with sourceedit:
in game.cpp search for

Code:

bool Game::playerReportBug(uint32_t playerId, std::string bug)
{
	Player* player = getPlayerByID(playerId);
	if(!player || player->isRemoved())
		return false;

	Database* db = Database::getInstance();

	DBQuery query;
	query << "INSERT INTO `server_reports` (`id`, `world_id`, `player_id`, `posx`, `posy`, `posz`, `timestamp`, `report`) VALUES (NULL, ";
	query << g_config.getNumber(ConfigManager::WORLD_ID) << ", " << player->getGUID() << ", ";
	Position pos = player->getPosition();
	query << pos.x << ", " << pos.y << ", " << pos.z << ", ";
	query << time(NULL) << ", " << db->escapeString(bug.c_str()) << ");";
	if(!db->executeQuery(query.str()))
	{
		query.str("");
		return false;
	}

	query.str("");
	player->sendTextMessage(MSG_EVENT_DEFAULT, "Your report has been sent to " + g_config.getString(ConfigManager::SERVER_NAME) + ".");
	return true;
}

and replace the function with this:

Code:

bool Game::playerReportBug(uint32_t playerId, std::string bug)
{
	Player* player = getPlayerByID(playerId);
	if(!player || player->isRemoved())
		return false;
		
	//Create report file
	if(FILE* file = fopen("player_reports.txt", "a"))
        {
   	    char bufferDate[32];
            uint64_t tmp = time(NULL);
            formatDate(tmp, bufferDate);
            fprintf(file, "%s Report by %s: %s\n\n", bufferDate, player->getName().c_str(), bug.c_str());
            fclose(file);
        }

	Database* db = Database::getInstance();

	DBQuery query;
	query << "INSERT INTO `server_reports` (`id`, `world_id`, `player_id`, `posx`, `posy`, `posz`, `timestamp`, `report`) VALUES (NULL, ";
	query << g_config.getNumber(ConfigManager::WORLD_ID) << ", " << player->getGUID() << ", ";
	Position pos = player->getPosition();
	query << pos.x << ", " << pos.y << ", " << pos.z << ", ";
	query << time(NULL) << ", " << db->escapeString(bug.c_str()) << ");";
	if(!db->executeQuery(query.str()))
	{
		query.str("");
		return false;
	}

	query.str("");
	player->sendTextMessage(MSG_EVENT_DEFAULT, "Your report has been sent to " + g_config.getString(ConfigManager::SERVER_NAME) + ".");
	return true;
}

Not Testet!!!
Please try and tell me if it works...

Yours,
Markey

He asked about ctrl + r not ctrl + z.

Guitar Freak · Jun 26, 2009

Don Daniello said:
You published donator's only content You'll be hunted !
Rule violations channel is logged by default in /logs if you enable loggin in config.lua
Visit /XML/channels.xml

How do I enable loggin in config.lua? I saw a couple of things related to Logs but I dont want to mess anything up so I ask just in case.

Im using TFS 0.3.2 btw, seems like I dont have channels.xml in XML folder..

And thanks a lot Old Greg too :thumbup:

Streks · May 30, 2016

that's posible !!!!????????
ok.. mmm
We think that is possible and we are proposing that amendment in my server.
can somebody help me, please ???

StreamSide · May 30, 2016

Streks said:
that's posible !!!!????????
ok.. mmm
We think that is possible and we are proposing that amendment in my server.
can somebody help me, please ???

Guitar Freak,Mar 2, 2009

Lua [CTRL + R] Is it possible?

Guitar Freak

_LüA_n☺b_

Guitar Freak

_LüA_n☺b_

Markey

Ashandra War Scripter

Guitar Freak

_LüA_n☺b_

Guitar Freak

_LüA_n☺b_

Guitar Freak

_LüA_n☺b_

Guitar Freak

_LüA_n☺b_

Guitar Freak

_LüA_n☺b_

Syntax

Developer

Don Daniello

/root

Delirium

OTLand veteran

Guitar Freak

_LüA_n☺b_

Streks

New Member

StreamSide

Joseluis Gonzalez