Last active
December 12, 2017 19:32
-
-
Save harddy/9aede2a2ca7d06468efc31670ded4f4c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/* | |
Template Name: dashboadrd | |
*/ | |
?> | |
<form method="POST" action=""> | |
<input type="submit" name="Sinkdata" value="Add data" /> | |
</form> | |
<?php | |
if (isset($_POST['Sinkdata'])) { | |
$base = 'https://www.coinschedule.com'; | |
global $wpdb; | |
$curl = curl_init(); | |
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE); | |
curl_setopt($curl, CURLOPT_HEADER, false); | |
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); | |
curl_setopt($curl, CURLOPT_URL, $base); | |
curl_setopt($curl, CURLOPT_REFERER, $base); | |
curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE); | |
$str = curl_exec($curl); | |
curl_close($curl); | |
$html_base = new simple_html_dom(); | |
$html_base->load($str); | |
$cnt = 1; | |
global $wpdb; | |
//get all Live Token Sales & ICOs | |
$valuesArr_Iso_Masters = array(); | |
foreach ($html_base->find('div.gold ') as $element) { | |
$linkdetailpage = $element->find('a')[0]->href; | |
$image_linktype_gold_standard_silver = $element->find('img')[0]->src; | |
$type_name_gold_standard_silver = "Gold"; | |
$image_iso_logo_url = $element->find('.tooltip_new img')[0]->src; | |
$iso_name = $element->find('h4')[0]->plaintext; | |
$iso_category = $element->find('.category')[0]->plaintext; | |
$iso_percentage_done_or_notdone = $element->find('.tooltip_new b')[0]->plaintext; | |
$Iso_IS_Live = 1; | |
$valuesArr_Iso_Masters[] = "('$iso_name', '$image_iso_logo_url', '$iso_category'" | |
. ", '$type_name_gold_standard_silver', '$image_linktype_gold_standard_silver'," | |
. "'$iso_percentage_done_or_notdone','$linkdetailpage','$Iso_IS_Live'" | |
. ")"; | |
$result = $wpdb->get_results("SELECT * FROM ico_masters WHERE Linkdetailpage = '$linkdetailpage'"); | |
if ($result) { | |
foreach ($result as $row) { | |
$PK_Iso_ID = $row->PK_Iso_ID; | |
$sql = $wpdb->update( | |
'ico_masters', array( | |
'Iso_name' => $iso_name, | |
'Image_iso_logo_url' => $image_iso_logo_url, | |
'Iso_category' => $iso_category, | |
'Type_name_gold_standard_silver' => $type_name_gold_standard_silver, | |
'Image_linktype_gold_standard_silver' => $image_linktype_gold_standard_silver, | |
'Iso_percentage_done_or_notdone' => $iso_percentage_done_or_notdone, | |
'Linkdetailpage' => $linkdetailpage, | |
'Iso_IS_Live' => $Iso_IS_Live,), array( | |
'PK_Iso_ID' => $PK_Iso_ID, | |
) | |
); | |
if ($sql === FALSE) { | |
echo $PK_Iso_ID . "ico_masters Error updating record1" . $wpdb->last_error; | |
} else { | |
// echo "details page Record updated successfully"; | |
$FK_iso_Masters_ID = $PK_Iso_ID; | |
$base1 = $linkdetailpage; | |
echo "<pre>"; | |
print_r($base1); | |
echo "</pre>"; | |
$curl1 = curl_init(); | |
curl_setopt($curl1, CURLOPT_SSL_VERIFYPEER, FALSE); | |
curl_setopt($curl1, CURLOPT_HEADER, false); | |
curl_setopt($curl1, CURLOPT_FOLLOWLOCATION, true); | |
curl_setopt($curl1, CURLOPT_URL, $base1); | |
curl_setopt($curl1, CURLOPT_REFERER, $base1); | |
curl_setopt($curl1, CURLOPT_RETURNTRANSFER, TRUE); | |
$str1 = curl_exec($curl1); | |
curl_close($curl1); | |
// Create a DOM object | |
$html_base1 = new simple_html_dom(); | |
// Load HTML from a string | |
$html_base1->load($str1); | |
$icodetailsarr = array(); | |
$res = array(); | |
$res = array(); | |
// foreach ($html_base1->find('.projectinfo .infoitem') as $element) { | |
// $res[] = $element->find('.infovalue')[0]->plaintext; | |
// } | |
// echo "<pre>"; | |
// print_r($res); | |
// echo "</pre>"; | |
foreach ($html_base1->find('.projectinfo .infoitem') as $element1) { | |
if ($html_base1->find('div.project-heading h1') != NULL) { | |
$icodetailsarr['Projectname'] = $html_base1->find('div.project-heading h1')[0]->plaintext; | |
} | |
if ($html_base1->find('.project-desc') != NULL) { | |
$icodetailsarr['TopDescription'] = $html_base1->find('.project-desc')[0]->plaintext; | |
} | |
$res = $element1->find('.infolabel')[0]->plaintext; | |
if ($res == 'Project Type') { | |
$icodetailsarr['ProjectType'] = $element1->find('.infovalue')[0]->plaintext; | |
} | |
if ($res == 'Platform') { | |
//elem -> text node -> td node | |
$icodetailsarr['Platform'] = $Platform = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Website') { | |
//elem -> text node -> td node | |
$icodetailsarr['Websitelink'] = $element1->find('.infovalue')[0]->find('a')[0]->href; | |
$icodetailsarr['WebsiteStatus'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Category') { | |
//elem -> text node -> td node | |
$icodetailsarr['ProjectCatgory'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Total Supply') { | |
//elem -> text node -> td node | |
$icodetailsarr['TotalSupply'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Whitepaper') { | |
//elem -> text node -> td node | |
$icodetailsarr['Whitepaperlink'] = $element1->find('.infovalue')[0]->find('a')[0]->href; | |
} if ($res == 'Bitcoin Talk') { | |
//elem -> text node -> td node | |
$icodetailsarr['BitcoinTalk_Link'] = $element1->find('.infovalue')[0]->find('a')[0]->href; | |
$icodetailsarr['BitcoinTalk_Status'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Start Date') { | |
$icodetailsarr['StartDate'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'End Date') { | |
$icodetailsarr['EndDate'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Details') { | |
//elem -> text node -> td node | |
$icodetailsarr['Details'] = $element1->find('.infovalue')[0]->plaintext; | |
} | |
} | |
echo "<pre>"; | |
print_r($icodetailsarr); | |
echo "</pre>"; | |
$sqlselectico_masters = $wpdb->get_results("SELECT * FROM ico_details WHERE Fk_iso_masters_ID = $FK_iso_Masters_ID "); | |
if ($sqlselectico_masters) { | |
foreach ($sqlselectico_masters as $row) { | |
// output data of each row | |
$Fk_iso_masters_ID = $row->Fk_iso_masters_ID; | |
$sql = $wpdb->update( | |
'ico_details', $icodetailsarr, array( | |
'Fk_iso_masters_ID' => $Fk_iso_masters_ID, | |
) | |
); | |
if ($sql === FALSE) { | |
echo $Projectname . $FK_iso_Masters_ID . "subdetails updated ERROR: Could not able to execute" . $wpdb->last_error; | |
} else { | |
echo $Fk_iso_masters_ID . " Record updated. <br/>"; | |
} | |
} | |
} else { | |
if ($icodetailsarr['ProjectType'] && $icodetailsarr['Platform'] && $icodetailsarr['TotalSupply'] && $icodetailsarr['Websitelink'] && $icodetailsarr['WebsiteStatus'] && $icodetailsarr['EndDate'] && $icodetailsarr['StartDate']) { | |
$sql1 = $wpdb->insert( | |
'ico_details', $icodetailsarr | |
); | |
// comment insert code | |
if ($sql1 == 1) { | |
echo "subdetails updated time Records inserted successfully. <br/>"; | |
//echo base64_decode("UGVlcmd1ZXNzIGlzIGEgZnJlZSBjcnlwdG9jdXJyZW5jeSBwcmljZSB0aWNrZXIgYXBwbGljYXRpb24gZGVzaWduZWQgdG8gYW5zd2VyIHRoZSBtb3N0IGltcG9ydGFudCB0cmFkaW5nIHF1ZXN0aW9uOiDigJxXaWxsIEJpdGNvaW4gaW5jcmVhc2Ugb3IgZGVjcmVhc2UgaW4gdGhlIG5leHQgMjQgaG91cnM/4oCdLiBZb3Ugd2lsbCBndWVzcyBmdXR1cmUgcHJpY2VzIHRvIGVhcm4gZ2VtcywgbGVhcm4gYWJvdXQgY29tbXVuaXR5IHRlbmRlbmNpZXMgYW5kIGhhdmUgYWNjZXNzIHRvIHRoZSBzb3BoaXN0aWNhdGVkIGRhdGEgdG8gaW1wcm92ZSB5b3VyIGludHVpdGlvbi4g"); | |
} else { | |
echo $Projectname . $FK_iso_Masters_ID . "subdetails ERROR: Could not able to execute." . $wpdb->last_error; | |
} | |
} | |
} | |
// end here details page update insert | |
} | |
} | |
} else { | |
die(); | |
$sql = $wpdb->insert( | |
'ico_masters', array( | |
'Iso_name' => $iso_name, | |
'Image_iso_logo_url' => $image_iso_logo_url, | |
'Iso_category' => $iso_category, | |
'Type_name_gold_standard_silver' => $type_name_gold_standard_silver, | |
'Image_linktype_gold_standard_silver' => $image_linktype_gold_standard_silver, | |
'Iso_percentage_done_or_notdone' => $iso_percentage_done_or_notdone, | |
'Linkdetailpage' => $linkdetailpage, | |
'Iso_IS_Live' => $Iso_IS_Live, | |
) | |
); | |
if ($sql == 1) { | |
$FK_iso_Masters_ID = $wpdb->insert_id; | |
// echo $FK_iso_Masters_ID; | |
$base1 = $linkdetailpage; | |
$curl1 = curl_init(); | |
curl_setopt($curl1, CURLOPT_SSL_VERIFYPEER, FALSE); | |
curl_setopt($curl1, CURLOPT_HEADER, false); | |
curl_setopt($curl1, CURLOPT_FOLLOWLOCATION, true); | |
curl_setopt($curl1, CURLOPT_URL, $base1); | |
curl_setopt($curl1, CURLOPT_REFERER, $base1); | |
curl_setopt($curl1, CURLOPT_RETURNTRANSFER, TRUE); | |
$str1 = curl_exec($curl1); | |
curl_close($curl1); | |
$html_base1 = new simple_html_dom(); | |
$html_base1->load($str1); | |
$res = array(); | |
$icodetailsarr = array(); | |
foreach ($html_base1->find('.projectinfo .infoitem') as $element1) { | |
if ($html_base1->find('div.project-heading h1') != NULL) { | |
$Projectname = $html_base1->find('div.project-heading h1')[0]->plaintext; | |
} | |
if ($html_base1->find('.project-desc') != NULL) { | |
$TopDescription = $html_base1->find('.project-desc')[0]->plaintext; | |
} | |
$res = $element1->find('.infolabel')[0]->plaintext; | |
if ($res == 'Project Type') { | |
$icodetailsarr['ProjectType'] = $element1->find('.infovalue')[0]->plaintext; | |
} | |
if ($res == 'Platform') { | |
//elem -> text node -> td node | |
$icodetailsarr['Platform'] = $Platform = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Website') { | |
//elem -> text node -> td node | |
$icodetailsarr['Websitelink'] = $element1->find('.infovalue')->find('a')[0]->href; | |
$icodetailsarr['WebsiteStatus'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Category') { | |
//elem -> text node -> td node | |
$icodetailsarr['ProjectCatgory'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Total Supply') { | |
//elem -> text node -> td node | |
$icodetailsarr['TotalSupply'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Whitepaper') { | |
//elem -> text node -> td node | |
$icodetailsarr['Whitepaperlink'] = $element1->find('.infovalue')->find('a')[0]->href; | |
} if ($res == 'Bitcoin Talk') { | |
//elem -> text node -> td node | |
$icodetailsarr['BitcoinTalk_Link'] = $element1->find('.infovalue')->find('a')[0]->href; | |
$icodetailsarr['BitcoinTalk_Status'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Start Date') { | |
$icodetailsarr['StartDate'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'End Date') { | |
$icodetailsarr['EndDate'] = $element1->find('.infovalue')[0]->plaintext; | |
} if ($res == 'Details') { | |
//elem -> text node -> td node | |
$icodetailsarr['Details'] = $element1->find('.infovalue')[0]->plaintext; | |
} | |
} | |
$valuesArr_Iso_Masters_spciallinks = array(); | |
//put logic for insert social data | |
if ($element1->find('div.project-events h2') != NULL) { | |
$teamdetails = ""; | |
$UpcomingEventsandMilestones = ""; | |
foreach ($element1->find('div.project-events h2') as $elem) { | |
if ($elem->plaintext == 'Team') { | |
$teamdetails = $elem->next_sibling(); | |
} else if ($elem->plaintext == 'Upcoming Events and Milestones') { | |
$UpcomingEventsandMilestones = $elem->next_sibling(); | |
} else if ($elem->plaintext == 'Links') { | |
if ($elem->next_sibling()->find('.project-links .proj-link') != NULL) { | |
//put delete code for social links | |
$sqldel = $wpdb->query("DELETE FROM ico_details_scoiallinkstable WHERE FK_iso_Masters_ID = $FK_iso_Masters_ID"); | |
if ($sqldel) { | |
echo "Record deleted successfully <br/>"; | |
} else { | |
echo "Error deleting record: " . $wpdb->last_error; | |
} | |
// | |
foreach ($elem->next_sibling()->find('.project-links .proj-link a') as $elem2) { | |
$txt = $elem2->plaintext; | |
$lnkurls = base64_encode($elem2->href); | |
$valuesArr_Iso_Masters_spciallinks[] = "('$elem2->plaintext', '$elem2->href', '0'" | |
. ")"; | |
$sql3 = $wpdb->insert( | |
'ico_details_scoiallinkstable', array( | |
'Name' => $txt, | |
'Link_Url' => $lnkurls, | |
'FK_iso_Masters_ID' => $FK_iso_Masters_ID, | |
) | |
); | |
if ($sql3 == 1) { | |
echo "ico_details_scoiallinkstable Records inserted successfully."; | |
} else { | |
echo $FK_iso_Masters_ID . "ico_details_scoiallinkstable ERROR: Could not able to execute . $wpdb->last_error. "; | |
} | |
} | |
} | |
} | |
} | |
} | |
$Details = base64_encode($Details); | |
$TopDescription = base64_encode($TopDescription); | |
$Distribution = base64_encode($Distribution); | |
$RatesandBonuses = base64_encode($RatesandBonuses); | |
$teamdetails = base64_encode($teamdetails); | |
$UpcomingEventsandMilestones = base64_encode($UpcomingEventsandMilestones); | |
if ($icodetailsarr['ProjectType'] && $icodetailsarr['Platform'] && $icodetailsarr['TotalSupply'] && $icodetailsarr['Websitelink'] && $icodetailsarr['WebsiteStatus'] && $icodetailsarr['EndDate'] && $icodetailsarr['StartDate']) { | |
$sqlselectico_masters = $wpdb->get_results("SELECT * FROM ico_details WHERE Fk_iso_masters_ID = $FK_iso_Masters_ID "); | |
if ($sqlselectico_masters) { | |
foreach ($sqlselectico_masters as $row) { | |
// output data of each row | |
$Fk_iso_masters_ID = $row->Fk_iso_masters_ID; | |
$sql = $wpdb->update( | |
'ico_details', array( | |
'Projectname' => $Projectname, | |
'TopDescription' => $TopDescription, | |
'ProjectType' => $ProjectType, | |
'Platform' => $Platform, | |
'Websitelink' => $Websitelink, | |
'WebsiteStatus' => $WebsiteStatus, | |
'ProjectCatgory' => $ProjectCatgory, | |
'TotalSupply' => $TotalSupply, | |
'Whitepaperlink' => $Whitepaperlink, | |
'BitcoinTalk_Link' => $BitcoinTalk_Link, | |
'BitcoinTalk_Status' => $BitcoinTalk_Status, | |
'Heading_Of_Date_Section' => $Heading_Of_Date_Section, | |
'StartDate' => $StartDate, | |
'StartDays' => $StartDays, | |
'StartHours' => $StartHours, | |
'StartMins' => $StartMins, | |
'StartSecs' => $StartSecs, | |
'EndDate' => $EndDate, | |
'EndDays' => $EndDays, | |
'EndHours' => $EndHours, | |
'EndMins' => $EndMins, | |
'EndSecs' => $EndSecs, | |
'Details' => $Details, | |
'Distribution' => $Distribution, | |
'RatesandBonuses' => $RatesandBonuses, | |
'Fk_iso_masters_ID' => $FK_iso_Masters_ID, | |
'teamdeatils' => $teamdetails, | |
'Upcomingevents' => $UpcomingEventsandMilestones,), array( | |
'Fk_iso_masters_ID' => $Fk_iso_masters_ID, | |
) | |
); | |
if ($sql === FALSE) { | |
echo $Projectname . $FK_iso_Masters_ID . "subdetails updated ERROR: Could not able to execute" . $wpdb->last_error; | |
} else { | |
echo $Fk_iso_masters_ID . " Record updated. <br/>"; | |
} | |
} | |
} else { | |
$sql1 = $wpdb->insert( | |
'ico_details', array( | |
'Projectname' => $Projectname, | |
'TopDescription' => $TopDescription, | |
'ProjectType' => $ProjectType, | |
'Platform' => $Platform, | |
'Websitelink' => $Websitelink, | |
'WebsiteStatus' => $WebsiteStatus, | |
'ProjectCatgory' => $ProjectCatgory, | |
'TotalSupply' => $TotalSupply, | |
'Whitepaperlink' => $Whitepaperlink, | |
'BitcoinTalk_Link' => $BitcoinTalk_Link, | |
'BitcoinTalk_Status' => $BitcoinTalk_Status, | |
'Heading_Of_Date_Section' => $Heading_Of_Date_Section, | |
'StartDate' => $StartDate, | |
'StartDays' => $StartDays, | |
'StartHours' => $StartHours, | |
'StartMins' => $StartMins, | |
'StartSecs' => $StartSecs, | |
'EndDate' => $EndDate, | |
'EndDays' => $EndDays, | |
'EndHours' => $EndHours, | |
'EndMins' => $EndMins, | |
'EndSecs' => $EndSecs, | |
'Details' => $Details, | |
'Distribution' => $Distribution, | |
'RatesandBonuses' => $RatesandBonuses, | |
'Fk_iso_masters_ID' => $FK_iso_Masters_ID, | |
'teamdeatils' => $teamdetails, | |
'Upcomingevents' => $UpcomingEventsandMilestones, | |
) | |
); | |
exit(var_dump($wpdb->last_query)); | |
// comment insert code | |
if ($sql1 == 1) { | |
echo "subdetails updated time Records inserted successfully. <br/>"; | |
//echo base64_decode("UGVlcmd1ZXNzIGlzIGEgZnJlZSBjcnlwdG9jdXJyZW5jeSBwcmljZSB0aWNrZXIgYXBwbGljYXRpb24gZGVzaWduZWQgdG8gYW5zd2VyIHRoZSBtb3N0IGltcG9ydGFudCB0cmFkaW5nIHF1ZXN0aW9uOiDigJxXaWxsIEJpdGNvaW4gaW5jcmVhc2Ugb3IgZGVjcmVhc2UgaW4gdGhlIG5leHQgMjQgaG91cnM/4oCdLiBZb3Ugd2lsbCBndWVzcyBmdXR1cmUgcHJpY2VzIHRvIGVhcm4gZ2VtcywgbGVhcm4gYWJvdXQgY29tbXVuaXR5IHRlbmRlbmNpZXMgYW5kIGhhdmUgYWNjZXNzIHRvIHRoZSBzb3BoaXN0aWNhdGVkIGRhdGEgdG8gaW1wcm92ZSB5b3VyIGludHVpdGlvbi4g"); | |
} else { | |
echo $Projectname . $FK_iso_Masters_ID . "subdetails ERROR: Could not able to execute." . $wpdb->last_error; | |
} | |
} | |
} | |
} else { | |
echo $iso_name . "ERROR: Could not able to execute. "; | |
} | |
} | |
$cnt = $cnt + 1; | |
} | |
echo "count div.icobox.goldbox" . $cnt; | |
} | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment