Skip to content

Instantly share code, notes, and snippets.

View quardz's full-sized avatar
💭
I may be slow to respond.

Quardz quardz

💭
I may be slow to respond.
  • Bangalore India
View GitHub Profile
@quardz
quardz / airstack
Created June 26, 2024 04:51
Airstack GQL for top ranked profiles
query GetFarcasterUserSocialCapital {
Socials(
input: {filter: {socialCapitalRank: {_lte: 2000, _gte: 1}}, blockchain: ethereum, order: {socialCapitalRank: ASC}, limit: 200}
) {
Social {
socialCapital {
socialCapitalScore
socialCapitalRank
}
userId
@quardz
quardz / depaystable.js
Created April 20, 2022 01:55
depay.fi payment configuration for stable coins
DePayWidgets.Payment({
accept: [
{ // USDT on ethereum
blockchain: 'ethereum',
amount: 0,
token: '0xdac17f958d2ee523a2206206994597c13d831ec7',
receiver: '@dynamic'
},
{ // USDC on ethereum
blockchain: 'ethereum',
@quardz
quardz / alltags.html
Created December 15, 2019 07:30
List of html elements
<!-- * >
<!DOCTYPE * >
<a * >
<abbr * >
<acronym * >
<address * >
<applet * >
<area * >
<article * >
<aside * >
@quardz
quardz / temp.sql
Created November 8, 2019 05:57
temp sql to test
SELECT node.nid AS nid,
node_data_field_recent_nodes_view.field_recent_nodes_view_vname AS node_data_field_recent_nodes_view_field_recent_nodes_view_vname,
node_data_field_recent_nodes_view.field_recent_nodes_view_vargs AS node_data_field_recent_nodes_view_field_recent_nodes_view_vargs,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_archive_term_view_display.field_archive_term_view_display_vname AS node_data_field_archive_term_view_display_field_archive_term_view_display_vname,
node_data_field_archive_term_view_display.field_archive_term_view_display_vargs AS node_data_field_archive_term_view_display_field_archive_term_view_display_vargs,
node.title AS node_title,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format,
@quardz
quardz / migrate.sh
Last active December 15, 2020 06:23 — forked from pepijnblom/migrate.sh
Upgrade MAMP to Mysql 5.7
#!/bin/sh
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.23-macos10.13-x86_64.tar.gz
tar xfvz mysql-5.7*
echo "stopping mamp"
sudo /Applications/MAMP/bin/stop.sh
sudo killall httpd mysqld
echo "creating backup"
@quardz
quardz / get-all-parents.php
Created July 15, 2018 05:56
Drupal entity reference get all the parents
//Get all the parent of a book as array
function _book2_hlp_get_book_all_parents_array($entity_id, $table = 'node__field_book2_parent',
$parent_field = 'field_book2_parent_target_id', $child_field = 'entity_id',
$bundle = 'book2') {
$output = array();
$node_relation = 'c.' . $child_field . ' = n.nid';
//Get all the childrens in sinle fetch,
@quardz
quardz / sampleico.json
Created June 28, 2018 13:11
{"results":[{"hits":[{"craftEntryId":"20949","title":"Alt.Estate","description":"Protocol to tokenize real estate, and platform to trade tokenized property assets in fractions.","website":"https://alt.estate/?utm_source=icoalert.com&utm_medium=listing","reportAvailable":true,"reportLink":"https://blog.icoalert.com/alt-estate-alt-ico-alert-report-e1c9d13bf3a3","featuredListing":false,"preFeaturedListing":false,"verified":false,"tags":"[]","startDate":1527652800,"startDay":"30","startMonth":"May","startQuarter":"","startYear":"","endDate":1530331200,"tbd":false,"preSaleTbd":false,"preSale":true,"preSaleTimeframeType":"exactDates","preSaleStartDate":1523937600,"preSaleStartDay":"17","preSaleStartMonth":"Apr","preSaleStartQuarter":"","preSaleStartYear":"","preSaleEndDate":1527566400,"kyc":true,"usExcludedOption":2,"dateCreated":1519412286,"objectID":"44042311","_highlightResult":{"title":{"value":"Alt.Estate","matchLevel":"none","matchedWords":[]},"description":{"value":"Protocol to tokenize real estate, and plat
@quardz
quardz / blockchain-trading-signal-platform-stats.csv
Created January 15, 2018 12:11
For medium article embed
Support Markets Cindicator Trakinvest Stox Enigma catalyst Coinfi Santiment cryptics iconomi Melonport
Product Stage Beta / Initial Stage Live for 3 years Beta / Initial Stage Alpha / Not Usable Not avaliable Not avaliable Not avaliable TBA Beta
Number of users 30,000 100,000+ daily active users TBA N/A N/A N/A N/A 28000 TBA
Mobile Downloads 10,000 - 50,000 5,000 - 10,000 NA NA N/A N/A N/A <5,000 TBA
Market Retail and insti Yes Mostly retail No No No No TBA
@quardz
quardz / blockchain-trading-signal-platform-basic.csv
Last active January 15, 2018 12:25
Basic Details Cindicator Trakinvest Stox Enigma catalyst Coinfi Santiment cryptics iconomi Red pulse Melonport
Product Status Beta In Market for 3 years with 100000 Daily active users Beta Not usable NO Alpha NO Live, 28,268 users on q3 2017 TBA TBA
Currency Symbol CND TRAK STX ENG COFI SAN ICN TBA MLN
Total Tokens 2,000,000,005 155,294,118 58,208,389 150,000,000 300,000,000 83,337,000 100,000,000 TBA 749,400
Current Supply 1,445,976,590 TBA 42,368,665 74,836,171 TBA 60,522,871 99,788,314 TBA 599,400
Token Distributed to investors 75% 42.50% 50% 50% TBA 54% 66% TBA TBA TBA
Fund rising goal USD 15,000,000 TBA USD 33,000,000 USD 45,000,000 USD 15,000,000 45000 ETH / USD 12,215,250 USD 20,000,000 USD 10,000,000 TBA USD 3,000,000
ICO Status Over Yet to start Over Over Over Over Yet to Start Over Over Over
@quardz
quardz / blockchain-trading-signal-platform-supported-markets.csv
Last active January 15, 2018 11:39
For Medium article embed
Support Markets Cindicator Trakinvest Stox Enigma catalyst Coinfi Santiment cryptics iconomi Red pulse
Stock Market Yes Yes No No No No No TBA TBA
Crypto Yes 2018 Q2 Yes Yes Yes Yes Yes TBA TBA
Forex Yes Yes No No No No No TBA TBA
Commodities Yes Yes No No No No No TBA TBA
ETF Yes Yes No No No No No TBA TBA
Futures Yes Yes No No No No No TBA TBA
General Predictions No No Yes No No No No TBA TBA