I appreciate the thanks jakeace

Ok I will get on that little deal we had.

i tried to make a sig have decided it's beyond me   :(

Ok for some reason I am having Problems editing the first post in the thread. It might be to long by now.
 
Section 4
 
So I have had to post this new part here
Ok, I have made a EOC only Signature with all the stuff you need to get started.
http://kbates666.gotdns.com/PremadeSig.zip
 
Unzip this to a location on your webserver(with php and mysql).
It contains
(3) .ttf font files
(1) .htaccess file
(1) starting .png file
(1) Processing .png file
 
The file Sig.png is the one with all the code in it, you need to change the settings at the top with a text editor
 
If you did it right it should come out like this(with your data)

 
After that you can learn all you need to edit it from either my guides or the php manual.

Hi unhappyelf
 
That is so cool what you have done with EOC stats. I've been checking the code out because I don't know anything about SQL and your code is allowing me to study abit. One thing I noticed is you have coded the signature to update if the last update was over 3 hours. The code writes the time of the update in the SQL database which could be an hour or two behind when EOC updates their statistics. If you used the time stamp in the EOC.XML, their is a time value of when they updated last.

<Last_Update_Unix_TimeStamp>
1301266800
</Last_Update_Unix_TimeStamp>

The 3 hour value (10800) added to the "Last_Update_Unix_TimeStamp" will give you the next update time.  Adding an additional 15 minutes (10800+900) should also allot time enough for EOC to complete their updates. This should help coordinate the signatures with the EOC statistics.

clifford_cooley

Hi unhappyelf

That is so cool what you have done with EOC stats. I've been checking the code out because I don't know anything about SQL and your code is allowing me to study abit. One thing I noticed is you have coded the signature to update if the last update was over 3 hours. The code writes the time of the update in the SQL database which could be an hour or two behind when EOC updates their statistics. If you used the time stamp in the EOC.XML, their is a time value of when they updated last.

<Last_Update_Unix_TimeStamp>
1301266800
</Last_Update_Unix_TimeStamp>

The 3 hour value (10800) added to the "Last_Update_Unix_TimeStamp" will give you the next update time.  Adding an additional 15 minutes (10800+900) should also allot time enough for EOC to complete their updates. This should help coordinate the signatures with the EOC statistics.

 
You know what I didnt even think about it that way before. I think at the time I knew how to get the time to work and had completely forgot about the time stamp included in the xml.
 
I will update me code and posts as soon as I can.
 
Thanks Clifford

unhappyelf

clifford_cooley

Hi unhappyelf

That is so cool what you have done with EOC stats. I've been checking the code out because I don't know anything about SQL and your code is allowing me to study abit. One thing I noticed is you have coded the signature to update if the last update was over 3 hours. The code writes the time of the update in the SQL database which could be an hour or two behind when EOC updates their statistics. If you used the time stamp in the EOC.XML, their is a time value of when they updated last.

<Last_Update_Unix_TimeStamp>
1301266800
</Last_Update_Unix_TimeStamp>

The 3 hour value (10800) added to the "Last_Update_Unix_TimeStamp" will give you the next update time.  Adding an additional 15 minutes (10800+900) should also allot time enough for EOC to complete their updates. This should help coordinate the signatures with the EOC statistics.

You know what I didnt even think about it that way before. I think at the time I knew how to get the time to work and had completely forgot about the time stamp included in the xml.

I will update me code and posts as soon as I can.

Thanks Clifford

 
Oh crap I remember why I didn't do that....The time EOC provides is not standard unix time. In fact I have no Idea what time they are referencing

The Dam EOC site only lists that is can use standard time using Last_Update. Just saw Last_Update_Unix_TimeStamp so nevermind

Umm, what code do I need to change for this to happen for codes hosted by me? ;)

Sleinous

Umm, what code do I need to change for this to happen for codes hosted by me? ;)

Ahhhh.....as usual the code tags are giving me an issue

This is the updated EOC code. It pulls everything from the user portion of the xml file and stores it in the db.
 

//******************************************************************************************************************************
//Everything From Here to the starts is for the mysql database
//eoc id
$foldingUsername = "This will name the database";
$eoc_id = "Put EOC ID here"; 
//mysql information
$db_ip = "localhost";
$db_user = "db user here";
$db_pass = "db pass here";
//connect to database
$con = mysql_connect($db_ip,$db_user,$db_pass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
//does datatbase exist
mysql_query("CREATE DATABASE IF NOT EXISTS my_db",$con);
//does table exist
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE IF NOT EXISTS $foldingUsername(Lasttimequeried int, Username varchar(15), UserID int, TeamRank int, OverallRank int, ChangeRank24h int, ChangeRank7d int, PointsAvg int, PointsUpdate int, PointsToday int, PointsWeek int, Points int, UserWU int)";
// Execute query
mysql_query($sql,$con);
//PHP time and insert time
$time = time();
$result = mysql_query("SELECT * FROM $foldingUsername");
$row = mysql_fetch_array($result);
if($row['Lasttimequeried'] == NULL){
$eoc = simpleXMLToArray(simplexml_load_file("http://folding.extremeoverclocking.com/xml/user_summary.php?s=&u=$eoc_id"));
$lastup = $eoc['status']['Last_Update_Unix_TimeStamp'];
$un = $eoc['user']['User_Name'];
$unid = $eoc['user']['UserID'];
$teamrank = $eoc['user']['Team_Rank'];
$overrank = $eoc['user']['Overall_Rank'];
$crank24h = $eoc['user']['Change_Rank_24hr'];
$crank7d = $eoc['user']['Change_Rank_7days'];
$ptsavg = $eoc['user']['Points_24hr_Avg'];
$ptsupd = $eoc['user']['Points_Update'];
$ptsday = $eoc['user']['Points_Today'];
$ptsweek = $eoc['user']['Points_Week'];
$pts = $eoc['user']['Points'];
$wu = $eoc['user']['WUs'];
mysql_query("INSERT INTO $foldingUsername(Lasttimequeried, Username, UserID, TeamRank, OverallRank, ChangeRank24h, ChangeRank7d, PointsAvg, PointsUpdate, PointsToday, PointsWeek, Points, UserWU) VALUES('$lastup', '$un', '$unid', '$teamrank', '$overrank', '$crank24h', '$crank7d', '$ptsavg', '$ptsupd', '$ptsday', '$ptsweek', '$pts', '$wu')");
}
if($time > ($row['Lasttimequeried']+11700)){
$eoc = simpleXMLToArray(simplexml_load_file("http://folding.extremeoverclocking.com/xml/user_summary.php?s=&u=$eoc_id"));
$lastup = $eoc['status']['Last_Update_Unix_TimeStamp'];
$un = $eoc['user']['User_Name'];
$unid = $eoc['user']['UserID'];
$teamrank = $eoc['user']['Team_Rank'];
$overrank = $eoc['user']['Overall_Rank'];
$crank24h = $eoc['user']['Change_Rank_24hr'];
$crank7d = $eoc['user']['Change_Rank_7days'];
$ptsavg = $eoc['user']['Points_24hr_Avg'];
$ptsupd = $eoc['user']['Points_Update'];
$ptsday = $eoc['user']['Points_Today'];
$ptsweek = $eoc['user']['Points_Week'];
$pts = $eoc['user']['Points'];
$wu = $eoc['user']['WUs'];
mysql_query("UPDATE $foldingUsername SET Lasttimequeried=$lastup");
mysql_query("UPDATE $foldingUsername SET UserID=$unid");
mysql_query("UPDATE $foldingUsername SET TeamRank=$teamrank");
mysql_query("UPDATE $foldingUsername SET OverallRank=$overrank");
mysql_query("UPDATE $foldingUsername SET ChangeRank24h=$crank24h");
mysql_query("UPDATE $foldingUsername SET ChangeRank7d=$crank7d");
mysql_query("UPDATE $foldingUsername SET PointsAvg=$ptsavg");
mysql_query("UPDATE $foldingUsername SET PointsUpdate=$ptsupd");
mysql_query("UPDATE $foldingUsername SET PointsToday=$ptsday");
mysql_query("UPDATE $foldingUsername SET PointsWeek=$ptsweek");
mysql_query("UPDATE $foldingUsername SET Points=$pts");
mysql_query("UPDATE $foldingUsername SET UserWU=$wu");
$result = mysql_query("SELECT * FROM $foldingUsername");
$row = mysql_fetch_array($result);
}
mysql_close($con);

//******************************************************************************************************************************
 
Should mostly be just copy paste with a few edits to your code depending on what you are displaying 

Indeed I do.....it consolidates all those other ones into one large one.

Nice! Although I dont think I even have room for a graph in my sig now :P but I do have some cunning plans to fit more in ;) More on that later.

No worries :) Check out the topic I made - free ftp & php/my sql hoster :D up to 8 databases (only one needed for EOC)

Also, clifford, if you wanted EOC, I do have the database already setup for 2 user eoc stats, cant remember how the tables are named (older method & not elf's revised code' but if u put a 3 at the end of ur table it will write to my database no probs, pm me for the table user pass.

Thanks Sleinous for the EOC table offer. I'm happy with my signature for the time being at least till I learn how to do the graph.

unhappyelfI will have some more time soon and will make proper instructions.

Thanks for the upload :D
 
No rush, take your time on the how too. I'm sure your code above has plenty to keep me thinking.

clifford_cooley

I seem to be stuck. The signature will not start. I think its due to the fonts listed that I do not have and the following quote shows a folder that I do not have.

include("/var/www/pChart2.1.1/class/pData.class.php");
include("/var/www/pChart2.1.1/class/pDraw.class.php");
include("/var/www/pChart2.1.1/class/pImage.class.php");

 
Dude I am so sorry.....forgot to mention you needed the pChart library available here
http://www.pchart.net/download