Shubham Pandey spandey1230
🎯
spandey1230
/ gist:51aa7ae0242030df04ccd74bfc49e028
Created
April 27, 2022 09:55
— forked from voskobovich/gist:537b2000108e4781f70b
List of most currency ISO code and symbol format in SQL.
This file contains hidden or 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
| DROP TABLE currency; | |
| -- Create table variable | |
| CREATE TABLE currency ( | |
| name VARCHAR(20), | |
| code VARCHAR(3), | |
| symbol VARCHAR(5) | |
| ); | |
| ALTER TABLE currency CONVERT TO CHARACTER SET utf8; |
spandey1230
/ Verify_HMAC.php
Created
April 29, 2021 18:36
This file contains hidden or 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 | |
| require_once("connect_to_mysql.php"); | |
| if( isset($_GET['hmac']) != '' ) { | |
| require_once("app_config.php"); | |
| $requests = $_GET; | |
| $hmac = $_GET['hmac']; | |
| $serializeArray = serialize($requests); | |
| $requests = array_diff_key($requests, array( 'hmac' => '' )); | |
| ksort($requests); | |
| $computed_hmac = hash_hmac('sha256', http_build_query($requests), $shared_secret); |
This file contains hidden or 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 | |
| $app_url="THE APP'S PRIMARY URL"; | |
| $api_key = "PASTE YOUR API KET HERE"; | |
| $scopes ="write_script_tags,read_products,read_draft_orders,read_inventory,write_inventory,read_locations,read_fulfillments,write_fulfillments,read_assigned_fulfillment_orders,write_assigned_fulfillment_orders,read_merchant_managed_fulfillment_orders,write_merchant_managed_fulfillment_orders,read_third_party_fulfillment_orders,write_third_party_fulfillment_orders,read_shipping,write_shipping,read_checkouts,write_checkouts,write_products,read_orders,read_content,read_discounts,write_discounts,read_shopify_payments_payouts,read_themes,read_shopify_payments_disputes,read_translations,read_locales,write_price_rules,read_price_rules,read_checkouts,write_resource_feedbacks,read_customers,write_customers"; | |
| $shared_secret = "PASTE YOUR SECRET HERE"; | |
| $app_review_url = "https://apps.shopify.com/WRITE_APP_NAME_HERE/reviews"; | |
| $app_logo_url = "https://DOMAIN.com/img/LOGO_FILE.png"; | |
| $app_website_url="#"; | |
| $parent_website_url="PARENT_WEB |