ERC-20s are mostly a bunch of crap tokens given out freely in air drops that utilize ethereum. Most of the ones I have received are worthless, and those that aren't probably will be in time-and in my opinion it is best for legal reasons not to sell stuff that is worthless and unmarketable-and just wait for them to prove themselves instead. Of course taking my advice could cost you substantial profit. I am guessing I am sitting on about $600-800 from just october, November has mostly been crap aside from the overall increase in value of crypto in general.
usually to participate in an airdrop you have to get a myetherwallet (MEW) ethereum address-an address at an exchange is worthless, and try to hunt down an adrop on bitcointalk. The drawback to my etherwallet is that it doesn't show up everything you recieved, and you manually have to enter in the contract address, symbol, and decimals. needless to say i stopped using the MEW site. There are other sites that will list your tokens and do a good job like ethplorer and etherscan. However, they often don't list a price or have a link to an exchange. And sometimes when they do, it is wrong. For example, ethplorer thinks 5m token that trades at about .00000001 ETH each is worth about 50k. I wish, good bye student loans if true.
So what I did was I used the api from ethplorer, which basically dumps the information for a given address.
https://api.ethplorer.io/getAddressInfo/0xcf085317456133e93d72ab5fc56025d8d3802c38?apiKey=freekey
And with such information, I was able to build my own custom table with the tokens names in alphabetical order, and link them to an exchange, color code the quantities, and do percent ownership. At the end, I decided to add colors to help improve readability; I mean when you are dealing with numbers maybe in the trillions or more and say 18 decimal places it gets hard to read.
As far as quotes, the API for etherdelta wants sockets. I am unsure if my host provider allows sockets in php, but letting this script pull the quotes would likely exceed what ethdelta would allow anyways. If quotes were to be added, the script would have to pull them from a local data store (file or database), with another seperate server script pulling the quotes to feed the data stores on regular intervals as to not flood their servers with needless requests. If I wanted to take it further, I could try to hunt down a list of websites, twitters, telegrams, facebook, discords, etc that the companies use. But Really i didn't make this as a public tool. I made it for myself. If someone wants to take a look at what I did and build onto it, then it is fine by me.
Anyways for a look at a random public eth address (not mine) that has token so you may try it out. Please note, my server does not support https so nothing is encrypted. NEVER PASS A PRIVATE KEY.
So basically same method from when I blogged about bots. This time I get the API. The api is pretty simple, it is just a url including the address, as well as an API key.
https://api.ethplorer.io/getAddressInfo/0xcf085317456133e93d72ab5fc56025d8d3802c38?apiKey=freekey
And it is kind of messy. It is partially organized with delimited of comma and colons, but then it breaks down. Sometimes a url is included, so essentially a fake delimit can appear.
So anyways, here is the code crypto.php.
//This first part is just a form. Pretty simple, an address is entered, and when clicked, it puts stores that address into memory the next when submit is pressed. And w'll give it a nice lightblue background. Obviously, I am not a fan of css or its many derivatives. The best of html was netscape 4.0...long long time ago. I know the body element should be after the html element, I don't care.
<html>
<form action="crypto.php" method="get">
address:<input type=text name=address>
<input type=submit value="Submit">
</form>
<body bgcolor="lightblue">
//So here is the beginning of the php code. Pretty standard we check for a get Request, and if found store it into address. Of just give the address a dummy value. Part of using the ethplorer api means giving credit to the ethplorer ppl.
<?php
$s=$_GET[address] or $s="0x";
echo "This is a test site. Powered in part by EthPlorer<br>";
//this is how we load the eth delta api over https. The domain is api.ethplorer.io. the path is "/GetAdrressInfo/[address]?apikey=freekey . And then we do the connection of port 443. Load the page and store it into gets. hahaha, in looking at the code, you can see an obvious error I made (drudgereport) and their server didn't care and processed it anyways.
$url="ssl://api.ethplorer.io";
$path="/getAddressInfo/$s?apiKey=freekey";
$fp = fsockopen($url, 443, $errno, $errstr, 30); fputs($fp, "GET " . $path . " HTTP/1.1\r\nHost: drudgereport.com\r\nConnection:Close\r\n\n"); while(!feof($fp)) {$pagetext=$pagetext . fgets($fp);} fclose($fp);
$data;
$gets = $pagetext;
//We are going to remove some potential false delimiters Here we remove http, we should have removed https as well.
$gets= str_replace('http:', '', $gets);
//we now skip over some uneeded data.
$gets=substr($gets, strpos($gets, '{"'));
//and we now create a list from a delimited that separateseach row of data, which is basically {"t. We also set a counter
$list=explode('{"t', $gets);
$counter =0;
//for each element in our list, we are going to extract the data we want. We skip over counter value 0, since it is ethereum itself and is irregular-and I decided not to do a special case.
foreach ($list as $a) {
if ($counter!=0) {
//we remove all quotes to ensure that our numbers are numbers. We then create a new list which is separated by a colon.
$a= str_replace('"', '', $a);
$c=explode(':',$a);
//The third index of a line into the data recieved is the name of the token. Sometimes names are not assigned to a token. So here we are getting the name of the token, or setting a data store to "N/A".
$z=strlen(substr($c[3], 0, strpos($c[3],',')));
if ($z0) {$data[$counter][0]="N/A";}
else {$data[$counter][0]=substr($c[3], 0, strpos($c[3],','));}
//The next thing I am extracting is the address, followed by the ticker symbol.
$data[$counter][1]=substr($c[2], 0, strpos($c[2],','));
//this is how many decimals are used.
$data[$counter][2]=substr($c[4], 0, strpos($c[4],','));
// Again, sometimes the ticker symbol is underfined.
$z=strlen(substr($c[5], 0, strpos($c[5],',')));
if ($z0) {$data[$counter][3]="N/A";}
else {$data[$counter][3]=substr($c[5], 0, strpos($c[5],','));}
//now we get the total supple, and of course adjust it to our decimal places.
$data[$counter][4]=pow(10,-$data[$counter][2])*substr($c[6], 0, strpos($c[6],','));
//the balance is irregular in the data recieved. We chose a final value of 28 indexes to dig into, the actual number may be higher in some cases-oh well. We we look for an index that has balance, and extract the data and store it.
for ($d=7;$d<28;$d) {
if (strpos($c[$d], "balance")>1)
{$data[$counter][5]=substr($c[$d+1], 0, strpos($c[$d+1],','))*pow(10,-$data[$counter][2]);
break;}}
//This is in preparation for a saort, we make a copy of the name of the token-only in uppercase.
$data[$counter][6]=strtoupper($data[$counter][0]);
}
$counter;
}
//So sorting we wanted to ensure that the size of the names were of equal length. We we searched for a max size of the name.
$stlen=0;
for($a=1;$a<$counter;$a++) {
$st=strlen($data[$a][0]);
if ($st>$stlen) {$stlen=$st;}}
//using the maximum size, we padding the copy of the namestore with tildes-antil they are all the same length.
for($a=1;$a<$counter;$a) {
while(strlen($data[$a][6])<$stlen) {$data[$a][6]=$data[$a][6]."~";}
//some tokens have the same name. What separates them is the contract address. So we concatonate the contract address to the name
$data1[$a]=$data[$a][6].$data[$a][1];
//We couldn't get array multisort to work. So we created an array where each element is a string of our values delimited by a tilde.
$data2[$a]=$data[$a][0]."".$data[$a][1]."".$data[$a][2]."".$data[$a][3]."".$data[$a][4]."".$data[$a][5]."";}
//and we now sort.
sort($data1);
//and our table begins
echo '<center><table bgcolor="white" border=1><tr><TH>index</TH><TH>Name</th><Th>Ticker</TH></tr><tr><TH>Total Supply</th><Th>owned</TH><Th>Percent Ownership</TH></tr>';
//This is a yucky sort. We are extracting the address from data 2, and comparing it to the already sorted data1. We then store. So we look at an index data1, and if an data2 address is inside data1 , then data2 is copying into data 3 at the index mapped bt data1. So data3 is a sorted data 2 in the same order as data 1.
for($a=0;$a<$counter;$a) {
for($b=0;$b<$counter;$b) {
$n=explode("~",$data2[$b]);
if (strpos($data1[$a],$n[1])>0) {
$data3[$a]=$data2[$b];
}}}
//now we fill our tables.
for($a=0;$a<$counter-1;$a) {
echo "<tr>";
//separating the data in data3 into lists
$n=explode("~",$data3[$a]);
echo "<td>";
//a basic index.
echo ($a+1);
echo "</td><td>";
//the name of the token
echo $n[0];
echo "</td><td>";
//link to the exchange
echo '<a href="https://etherdelta.com/#';
echo $n[1];
echo '-ETH">';
echo $n[3];
echo "</a></td></tr><tr><td>";
//getting rid of commas in the numbers.
$n[4]= str_replace(',', '', $n[4]);
//setting the colors to display
if ($n[4]>=1000000000000) {echo '<font color="red">';}
else if ($n[4]>=1000000000) {echo '<font color="orange">';}
else if ($n[4]>=1000000) {echo '<font color="green">';}
else if ($n[4]>=1000) {echo '<font color="blue">';}
//If a number has a decimal point, we are going to have to trim off the zeros on theright hand side (rtrim). f a number doesn't have a decimal point, it will lose significant digits. So have have to create a special case.
if (strpos($n[4],".")) {
echo rtrim(number_format($n[4],$n[2],".",","),"0");}
else {echo number_format($n[4],0,".",",");}
echo "</font></td><td>";
//this is pretty much the same as $n[4] but for $n[5] and this is the owner balance
$n[5]= str_replace(',', '', $n[5]);
if ($n[5]>=1000000000000) {echo '<font color="red">';}
else if ($n[5]>=1000000000) {echo '<font color="orange">';}
else if ($n[5]>=1000000) {echo '<font color="green">';}
else if ($n[5]>=1000) {echo '<font color="blue">';}
if (strpos($n[5],".")) {
echo rtrim(number_format($n[5],$n[2],".",","),"0");}
else {echo number_format($n[5],0,".",",");}
echo "</font></td><td>";
//and this is the percent ownership.
echo 100*$n[5]/$n[4];
echo "%</TD></tr>";
}
echo "</table>";
?>
</body>
</html>