This is almost more of a mafia question itself, but I'd like to replace my log files with an SQL database. I've already got the PHP file written to grab the variables from the URL and insert them into the database along with the current date, but I can't call it through my script. Here's the test code, simply with the domain name replaced with localhost.
I've run it, the script said it succeeded, but the data was not entered. I know it's not the PHP file causing the problem... but I also now know that mafia doesn't seem to want to call external URLs... at least not from a script.
Is there any way I can actually accomlish this? I think it'd be great as a data mining tool for many other things as well!
Code:
int PeakStartingMeat;
int PeakStartingAdv;
string peakfilename;
void PeakInitializeVars()
{
PeakStartingMeat = my_meat();
PeakStartingAdv = my_adventures();
}
void main()
{
PeakInitializeVars();
cli_execute("[url]http://localhost/koltest.php?charname="[/url] + my_name() + "&start_adv=" + int_to_string(PeakStartingAdv) + "&start_meat=" + int_to_string(PeakStartingMeat) + "&end_meat=" + int_to_string(my_meat()) + "&submit=submit");
}
I've run it, the script said it succeeded, but the data was not entered. I know it's not the PHP file causing the problem... but I also now know that mafia doesn't seem to want to call external URLs... at least not from a script.
Is there any way I can actually accomlish this? I think it'd be great as a data mining tool for many other things as well!