EVE Technology Lab

Ok I have been searching all over for any way that works..and i think im close but im now stuck..so sending out a plea to all the api code gurus that have figured this out already.

How did you get your walletjournal.xml to work, and how did u successfully upload it into a mysql database?

this is the script i've been testing wtih and I've got the database connection stuff working, but im unable to properly parse the xml and insert it into the database, im getting errors about the foreach statement not giving proper arguments..any and all help greatly appreacited thank you.

--- removed the php starting tag, forum dosnt like it

error_reporting(E_ALL);

include "connection.php"; // this works perfectly, no problems connecting to mysql, or the db

$keyID = "something" ;
$vcode= "something";
$characterID= "something";

$url = "https://api.eveonline.com/char/WalletJournal.xml.aspx?keyID=$keyid&Vcode=$vcode&characterID=$characterID";

$ch = curl_init($url);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE):
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE):

$data = curl_exec($ch);

curl_close($ch);

$doc = new SimpleXmlElement($data, LIBXML_NODATA);

foreach ( $doc -> result -> rowset -> row as $row )
{
$datee = $row ['date']';
$refID = $row ['refid']'
$refTypeID = $row ['refTypeID'];
$ownerName1 = mysql_real_escape_string($row['ownerName1']);
$ownerID1 = $row['ownerID1'];
$ownerName2 = mysql_real_escape_string($row['ownerName2']);
$ownerID2 = $row['ownerID2'];
$argName1 = $row['argName1'];
$argID1 = $row['argID1'];
$amount = $row['amount'];
$balance = $row['balance'];
$reason = $row['reason'];

$time = strtotime('- 30 minute',$datee);
echo $time;
/if the date is within the last 30 minutes
if($datee >= $time)
{
if($ownerName1 != '$exclude_char')
{
$precheck = mysql_query("SELECT refID FROM walletJournal WHERE date = '$datee', AND amount = '$amount'");
$precheck2 = mysql_num_rows($precheck);

if($precheck2['refID'] < 1)
{
mysql_query("INSERT INTO walletJournal (date, refID, refTypeID, ownerName1, ownerID1, ownerName2, ownerID2, argName1, argID1, amount, balance, reason) VALUES ('$datee', '$refID', '$refTypeID', '$ownerName1', '$ownerID1', '$ownerName2', '$ownerID2', '$argName1', '$argID1', '$amount', '$balance', '$reason')")or die(mysql_error());
}
}
}

}

--- removed php ending tag, forum dosnt like it

Louis is entirely right. Use one of the frameworks to do the heavy lifting for you. Makes life a lot easier.

Aside from that:

Look into using PDO. Or little Bobby Tables might come along and drop your database.

Did you mean NODATA, or NOCDATA


If you're ever wondering about the data you're getting back, var_dump() is your friend.

I looked into several different frameworks but couldnt get any of them to work, either they are no longer supported, or they required extra stuff my hosting provider dosnt allow for.

So I'll have to continue working with what I have.

anyone else actually have a walletjournel working without using one of the frameworks ???

yes I realize some of the calls in the code are outdated and insecure now, but that isn't a concern for what this application is designed for, I just simply want to get something working for testing purposes.

Turn your error level reporting up further, you've misspelled the variable.

Then delete this code and use PhealNG.

the typo there was only from typing it onto the forum, its actually spelled correctly in my script..if i manually post the api query, it returns the xml fine, thats not where im having the problem.