DROP TABLE team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches;

-- CREATE TABLE team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches AS
INSERT INTO team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches
SELECT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp, paymethod
, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type, bankcountry, small_vpa, country_bl_date FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct transactionid, bankcountry, small_vpa
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    , paymethod
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-01-01' - INTERVAL '1' DAY) AND DATE'2025-05-31'
    AND actionrecommended <> 'BLOCK' AND responsestatus = 'SUCCESS'
    AND isindian = 'false' AND bankcountry IS NOT NULL) a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b
ON a.paytmmerchantid = b.edc_mid
INNER JOIN
    (SELECT content as country, "timestamp" AS country_bl_date
    FROM team_kingkong.high_risk_country_list
    WHERE DATE(FROM_UNIXTIME(CAST("timestamp" AS double) / 1000)) <= DATE'2025-05-31')C
ON a.bankcountry = C.country AND DATE(FROM_UNIXTIME(CAST(country_bl_date AS double) / 1000)) < a.txn_date;

@media (max-width: 480px){
	.campaign-zone .wrapper {
    padding-top: 0px;
}

.campaign-zone{
	width: 100%;
	padding-top: 0px;
}

.wrapper{
	padding: 0px;
}
}

-- DROP TABLE team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches;

-- CREATE TABLE team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches AS
INSERT INTO team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches
with offus_txn as
(SELECT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp, paymethod
, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type
, 5 AS threshold_5min
, 40 AS threshold_1day
FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    , paymethod
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-01-01' - INTERVAL '1' DAY) AND DATE'2025-01-31' -- BETWEEN date'2025-01-31' AND
    and paymethod in ('UPI')
    AND actionrecommended <> 'BLOCK') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b
ON a.paytmmerchantid = b.edc_mid
INNER JOIN
    (select distinct txn_id as pg_txn_id
    from dwh.pg_olap
    where ingest_date BETWEEN DATE'2025-01-01' AND DATE(DATE'2025-01-31' + INTERVAL '1' DAY)
    and txn_started_at BETWEEN  DATE'2025-01-01' AND DATE(DATE'2025-01-31' + INTERVAL '1' DAY)
    and txn_status = 'SUCCESS') d
on a.transactionid = d.pg_txn_id)

SELECT * FROM
    (SELECT a.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, A.txn_timestamp
    , A.mid_type, A.paymethod
    , A.threshold_5min
    , A.threshold_1day
    , COUNT(IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 300000, B.transactionid, NULL)) AS txn5_min
    , COUNT(B.transactionid) as txn1_day
    , 'MID_UPI_Daily_TXN_limit_Check' AS rule_name
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date BETWEEN DATE'2025-01-01' AND  DATE'2025-01-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid
    AND A.transactionid <> B.transactionid
    AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    GROUP BY 1,2,3,4,5,6,7,8,9,10)
WHERE (txn5_min >= threshold_5min) OR (txn1_day >= threshold_1day);

-- DROP TABLE team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches;

-- CREATE TABLE team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches AS
INSERT INTO team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches
with offus_txn as
(SELECT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp, paymethod
, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type
, 5 AS threshold_5min
, 40 AS threshold_1day
FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    , paymethod
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-01-01' - INTERVAL '1' DAY) AND DATE'2025-01-31' -- BETWEEN date'2025-01-31' AND
    and paymethod in ('UPI')
    AND actionrecommended <> 'BLOCK') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b
ON a.paytmmerchantid = b.edc_mid
INNER JOIN
    (select distinct txn_id as pg_txn_id
    from dwh.pg_olap
    where ingest_date BETWEEN DATE'2025-01-01' AND DATE(DATE'2025-01-31' + INTERVAL '1' DAY)
    and txn_started_at BETWEEN  DATE'2025-01-01' AND DATE(DATE'2025-01-31' + INTERVAL '1' DAY)
    and txn_status = 'SUCCESS') d
on a.transactionid = d.pg_txn_id)

SELECT * FROM
    (SELECT a.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, A.txn_timestamp
    , A.mid_type, A.paymethod
    , A.threshold_5min
    , A.threshold_1day
    , COUNT(IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 300000, B.transactionid, NULL)) AS txn5_min
    , COUNT(B.transactionid) as txn1_day
    , 'MID_UPI_Daily_TXN_limit_Check' AS rule_name
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date BETWEEN DATE'2025-01-01' AND  DATE'2025-01-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid
    AND A.transactionid <> B.transactionid
    AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    GROUP BY 1,2,3,4,5,6,7,8,9,10)
WHERE (txn5_min >= threshold_5min) OR (txn1_day >= threshold_1day);

// You are using GCC
#include<bits/stdc++.h>
using namespace std;
int main(){
    int n;
    cin>>n;
    int arr[n];
    for(int i=0;i<n;i++){
        cin>>arr[i];
    }
    cout<<"sorted array after selection sort:";
    for(int i=0;i<n;i++){
        int index=i;
        for(int j=i+1;j<n;j++){
            if(arr[j]<arr[index] || arr[j]==arr[index]){
                index=j;
            }
        }
        swap(arr[i],arr[index]);
        cout<<arr[i]<<" ";
    }
    return 0;
}

// You are using GCC
#include<bits/stdc++.h>
using namespace std;
int main(){
    int n;
    cin>>n;
    int arr[n];
    for(int i=0;i<n;i++){
        cin>>arr[i];
    }
    for(int i=0;i<n;i++){
        int min=arr[i];
        int j=i-1;
        while(j>=0 && arr[j]>min){
            arr[j+1]=arr[j];
            j--;
        }
        arr[j+1]=min;
        // cout<<"iretation "<<i+1<<":";
        // for(int k=0;k<n;k++){
        //     cout<<arr[k]<<" ";
        // }
        // cout<<endl;
    }
    cout<<"after sorted using insertion sort:"<<endl;
    for(int i=0;i<n;i++){
        cout<<arr[i]<<" ";
    }
    
    return 0;
}

// You are using GCC
#include<bits/stdc++.h>
using namespace std;
int main(){
    int n;
    cin>>n;
    int arr[n];
    for(int i=0;i<n;i++){
        cin>>arr[i];
    }
    cout<<"after sorted using bubble sort: ";
    for(int i=0;i<n-1;i++){
        for(int j=0;j<n-i-1;j++){
            if(arr[j]>arr[j+1]){
                swap(arr[j],arr[j+1]);
            //   int temp=arr[j];
            //   arr[j]=arr[j+1];
            //   arr[j+1]=temp;
            }
        }
    }
        for(int i=0;i<n;i++){
        cout<<arr[i]<<" ";
        }
    }

/*Tabs > Titles: Remove all caps, increase font size and reduce letter spacing.*/
.blocks-tabs__header-item{
  text-transform: none;
  font-size: 1.5rem;
  letter-spacing: .04rem;
}

/*Quote carousel > Progression circles and arrows: Change arrow hover colour, change progression cirle hover opacity and scale.*/
.block-quote--carousel .carousel-controls-next,
.block-quote--carousel .carousel-controls-prev {
  transition: color 0.3s;
}
.block-quote--carousel .carousel-controls-next:hover,
.block-quote--carousel .carousel-controls-prev:hover {
  color: var(--custom-carousel-prev-next-hover-colour); 
}
.carousel-controls-item-btn {
  transition: all 0.15s ease-in-out;
}
.carousel-controls-item-btn:hover {
  opacity: var(--custom-theme-colour-button-hover-opacity);
  color: var(--custom-theme-hover-bg, #202d60);
}

function allow_custom_font_uploads($mimes) {
    $mimes['woff'] = 'font/woff';
    $mimes['woff2'] = 'font/woff2';
    return $mimes;
}
add_filter('upload_mimes', 'allow_custom_font_uploads');
 
ADD THIS IN FUNCTION.PHP

THEN DOWNLOAD PLUGIN : WP Add Mime Types

THEN ADD : woff = font/woff
woff2 = font/woff2

// creates duplicate list in ascending order
List<WindRosePlotDataRecord> SortedList = _Rows.OrderByDescending(o => o.Parameter).ToList(); 

// creates duplicate list in descending order
List<WindRosePlotDataRecord> SortedList = _Rows.OrderByDescending(o => o.Parameter).ToList(); 
            
// sort-in-place in ascending order
_Rows.Sort((x, y) => x.Parameter.CompareTo(y.Parameter));  

// sort-in-place in descending order
_Rows.Sort((x, y) => y.Parameter.CompareTo(x.Parameter));  // we switched x and y in CompareTo

min-height:19px;
display:flex;
flex-direction:column;
justify-content:center;
line-height:1.2;
background-size:19px;

-- oil_gas_dc_limit_EDC
-- CREATE TABLE team_kingkong.offus_oil_gas_dc_limit_EDC_breaches AS
INSERT INTO team_kingkong.offus_oil_gas_dc_limit_EDC_breaches
SELECT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp, paymethod
, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    , paymethod
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-05-01' - INTERVAL '1' DAY) AND DATE'2025-05-31' -- BETWEEN date'2025-03-31' AND
    and paymethod in ('DEBIT_CARD')
    AND merchantcategory = 'Gas and Petrol' 
    AND cast(eventamount as double)/100 > 125000
    AND actionrecommended <> 'BLOCK' AND responsestatus = 'SUCCESS') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b
ON a.paytmmerchantid = b.edc_mid;

-- TPAP: RISK200
-- DROP TABLE team_kingkong.tpap_risk200_breaches;

-- CREATE TABLE team_kingkong.tpap_risk200_breaches AS
INSERT INTO team_kingkong.tpap_risk200_breaches
with temp_tpap_base as
(SELECT DISTINCT bt.txn_id,
bt.scope_cust_id,
bt.payer_vpa,
bt.payee_vpa,
bt.txn_date,
bt.txn_amount,
st.category,
COALESCE(rd.upi_subtype, CASE WHEN st.category = 'LITE_MANDATE' THEN 'UPI_LITE_MANDATE' ELSE '' END) AS upi_subtype
FROM
    (SELECT txn_id,
    scope_cust_id,
    MAX(CASE WHEN participant_type = 'PAYER' THEN vpa END) AS payer_vpa,
    MAX(CASE WHEN participant_type = 'PAYEE' THEN vpa END) AS payee_vpa,
    MAX(created_on) AS txn_date,
    MAX(amount) AS txn_amount
    FROM switch.txn_participants_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN DATE '2025-01-01' AND DATE '2025-01-31'
    AND DATE(created_on) BETWEEN DATE '2025-01-01' AND DATE '2025-01-31'
    GROUP BY txn_id, scope_cust_id) bt
INNER JOIN
    (SELECT txn_id, category
    FROM switch.txn_info_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN DATE '2025-01-01' AND DATE '2025-01-31'
    AND DATE(created_on) BETWEEN DATE '2025-01-01' AND DATE '2025-01-31'
    AND UPPER(status) = 'SUCCESS') st
ON bt.txn_id = st.txn_id
INNER JOIN (
    SELECT DISTINCT txnid,
    REGEXP_REPLACE(CAST(json_extract(request, '$.evaluationType') AS varchar), '"', '') AS upi_subtype
    FROM tpap_hss.upi_switchv2_dwh_risk_data_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN DATE '2025-01-01' AND DATE '2025-01-31'
    AND (LOWER(REGEXP_REPLACE(CAST(json_extract(request, '$.requestPayload.payerVpa') AS varchar), '"', '')) LIKE '%@paytm%'
    OR LOWER(REGEXP_REPLACE(CAST(json_extract(request, '$.requestPayload.payerVpa') AS varchar), '"', '')) LIKE '%@pt%')
    AND json_extract_scalar(response, '$.action_recommended') <> 'BLOCK') rd
ON bt.txn_id = rd.txnid
WHERE (payer_vpa LIKE '%@paytm%') OR (payer_vpa LIKE '%@pt%')),

temp_blacklist AS
    (SELECT vpa AS blacklisted_vpa,
    DATE(FROM_UNIXTIME(CAST("timestamp" AS double) / 1000)) AS blacklist_date
    FROM team_kingkong.upi_blacklist_vpa_shivam
    WHERE "timestamp" IS NOT NULL
    AND "timestamp" <> ''
    AND DATE(FROM_UNIXTIME(CAST("timestamp" AS double) / 1000)) <= DATE '2025-01-31')

SELECT * FROM  
  (SELECT tb.txn_id,
  tb.scope_cust_id,
  tb.payer_vpa,
  tb.payee_vpa,
  tb.txn_date,
  tb.txn_amount,
  tb.category,
  tb.upi_subtype,
  COALESCE(pv.blacklisted_vpa, rv.blacklisted_vpa) AS blacklisted_vpa,
  COALESCE(pv.blacklist_date, rv.blacklist_date) AS blacklist_date,
  'RISK200' AS risk_code,
  'upi_blacklisted_vpa' AS rule_name
FROM temp_tpap_base tb
LEFT JOIN temp_blacklist pv
  ON tb.payer_vpa = pv.blacklisted_vpa AND tb.txn_date > pv.blacklist_date
LEFT JOIN temp_blacklist rv
  ON tb.payee_vpa = rv.blacklisted_vpa AND tb.txn_date > rv.blacklist_date)
WHERE blacklisted_vpa IS NOT NULL AND blacklist_date < DATE(txn_date);

-- DROP TABLE team_kingkong.tpap_risk307_breaches;

-- CREATE TABLE team_kingkong.tpap_risk307_breaches AS
INSERT INTO team_kingkong.tpap_risk307_breaches
with tpap_base as
(
SELECT B.*, C.category
, IF(D.upi_subtype IS NOT NULL, D.upi_subtype, IF(C.category = 'LITE_MANDATE', 'UPI_LITE_MANDATE', '')) AS upi_subtype
FROM
    (SELECT txn_id, scope_cust_id,
    MAX(CASE WHEN participant_type = 'PAYER' THEN vpa END) AS payer_vpa,
    MAX(CASE WHEN participant_type = 'PAYEE' THEN vpa END) AS payee_vpa,
    MAX(created_on) as txn_date,
    MAX(amount) AS txn_amount,
    created_on AS txn_time
    FROM switch.txn_participants_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN DATE'2025-01-01' AND DATE'2025-01-31'
    AND DATE(created_on) BETWEEN DATE'2025-01-01' AND DATE'2025-01-31'
    AND vpa IS NOT NULL
    GROUP BY 1,2,7)B
inner join
    (select txn_id, category
    from switch.txn_info_snapshot_v3
    where DATE(dl_last_updated) BETWEEN DATE'2025-01-01' AND DATE'2025-01-31'
    and DATE(created_on) BETWEEN DATE'2025-01-01' AND DATE'2025-01-31'
    and upper(status) in ('SUCCESS')
    AND category = 'VPA2MERCHANT') C
on B.txn_id = C.txn_id
LEFT JOIN
    (SELECT DISTINCT txnid
    , regexp_replace(cast(json_extract(request, '$.evaluationType') as varchar), '"', '') AS upi_subtype
    FROM tpap_hss.upi_switchv2_dwh_risk_data_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN date'2025-01-01' AND DATE'2025-01-31'
    AND (lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) LIKE '%@paytm%'
    or lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) like '%@pt%')
    AND json_extract_scalar(response, '$.action_recommended') <> 'BLOCK')D
ON B.txn_id = D.txnid
WHERE (payer_vpa LIKE '%@paytm%') OR (payer_vpa LIKE '%@pt%') -- OR (payee_vpa LIKE '%@pt%') OR (payee_vpa LIKE '%@paytm%')
AND payee_vpa LIKE '%@%' AND payee_vpa <> ''
)

SELECT * FROM
    (SELECT t1.payer_vpa,
      t1.payee_vpa,
      t1.txn_id,
      t1.txn_amount,
      t1.txn_time,
      t1.category,
      t1.upi_subtype,
      COUNT(t2.txn_id) AS prior_txns_last_24h,
      10 as threshold
    FROM tpap_base t1
    INNER JOIN tpap_base t2
      ON t1.payer_vpa = t2.payer_vpa
      AND t1.payee_vpa = t2.payee_vpa
      AND t2.txn_time BETWEEN (t1.txn_time - INTERVAL '24' HOUR) AND t1.txn_time
      AND t2.txn_amount > 1000
    GROUP BY t1.payer_vpa, t1.payee_vpa, t1.txn_id, t1.txn_amount, t1.txn_time, t1.category, t1.upi_subtype)
WHERE prior_txns_last_24h > threshold;

https://www.iperiusremote.com/

It is now crucial to register with the Virtual Assets Regulatory Authority (VARA) if you plan to start a cryptocurrency business in Dubai.. VARA registration ensures compliance with local laws, offering clear guidelines for businesses dealing in virtual assets. Without this registration, companies cannot legally operate within the emirate. Dubai’s focus on regulated crypto activity makes VARA registration a crucial step for businesses aiming to operate transparently and legally. Ensure your business meets the latest requirements by securing your VARA approval before beginning operations.
Beleaf Technologies is the only company offering complete VARA registration services, guiding crypto businesses in Dubai through every step to meet regulatory requirements and operate legally in the region.
Contact for free demo: https://www.beleaftechnologies.com/vara-registration
Whatsapp: +91 7904323274
Telegram: @BeleafSoftTech
Mail to: mailto:business@beleaftechnologies.com

HJBNBHEJNMFHEA

function slow_down_site() {
    sleep(35);
}
add_action('wp', 'slow_down_site');

function slow_down_sitenocache() {
    if (!isset($_GET['nocache'])) {
        wp_redirect(add_query_arg('nocache', time())); // Force reload with new URL
        exit;
    }
    sleep(35);
}
add_action('init', 'slow_down_sitenocache');

function slow_down_site_wpdb() {
    global $wpdb;
    $wpdb->query("SELECT SLEEP(35)"); // MySQL delay
}
add_action('init', 'slow_down_site_wpdb');

const url = 'https://api.inxmail.com/taconova/rest/v1/events/subscriptions/';  // Inxmail API endpoint

// Client ID and Secret (replace these with your actual values)
const clientId = 'CAS-genesisWorld247b5346-afad-4850-b5bb-afcd21c77978';  // Removed newline
const clientSecret = 'AOcVdS5XVYBvKWnJsCWJSSlZYfSoRraQwMphKNNknftJm-9cx5lC1g-y-ZJrDHp7LlpITpGqkpMev8F3o_oftPs';  // Replace with your actual Client Secret

const email = inputData.email || '';  // Email from the form submission
const Vorname = inputData.Vorname || '';  // Optional: first name
const Name = inputData.Name || '';    // Trimmed last name to remove newline
const Firma = inputData.Firma || '';
const Anrede = inputData.Anrede
const listId = 137; // List ID (use the list where you want to add the contact)

// Encode credentials for Basic Authentication (Base64-encoded 'clientId:clientSecret')
const authValue = `${clientId}:${clientSecret}`;
const base64Auth = Buffer.from(authValue).toString('base64');  // Encoding the credentials to Base64

// Request data to send to the Inxmail API
const requestData = {
  email: email,
  listId: listId,
  attributes: {
    Vorname: Vorname,
    Name: Name,
    Anrede: Anrede,
    Firma: Firma
  },
  trackingPermission: "GRANTED",  // You can set this as "GRANTED" for accepted tracking permission
  source: "Web Form"  // Example source, you can modify as needed
};

// Request options for the fetch call
const options = {
  method: 'POST',
  headers: {
    'Authorization': `Basic ${base64Auth}`,  // Basic Auth with Base64-encoded credentials
    'Content-Type': 'application/json',  // Set the correct content type for JSON
  },
  body: JSON.stringify(requestData),  // Send the data as JSON in the request body
};

// Function to send the request
async function sendRequest() {
  try {
    const response = await fetch(url, options);

    if (!response.ok) {
      const errorText = await response.text(); // Get the error response text for debugging
      throw new Error(`Inxmail API request failed: ${errorText}`);
    }

    const responseBody = await response.json();  // Process the response as JSON

    // Return success and the response data
    return {
      success: true,
      data: responseBody,
    };
  } catch (error) {
    // Handle errors and return the error message
    return {
      success: false,
      error: error.message,
    };
  }
}

// Execute the request and assign the result to output
output = await sendRequest();

<div class="et_pb_button_module_wrapper et_pb_button_3_wrapper et_pb_button_alignment_center et_pb_module  dbdb-icon-on-right dbdb-icon-on-hover dbdb-has-custom-padding">
				<a class="et_pb_button et_pb_button_3 et_pb_bg_layout_light" href="/product-category/domestic-hot-water/">learn more</a>
			</div>

pip install gTTS

pip install gTTS

In Backend, go to:
Content- Design - Configuration
Select 	Best Deal Print theme name and edit
Other Settings - Header - Logo Image

-- CREATE TABLE team_kingkong.offus_edc_card_velocity_amount_breaches AS
INSERT INTO team_kingkong.offus_edc_card_velocity_amount_breaches
with offus_txn as
(SELECT DISTINCT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN date'2025-05-01' AND DATE'2025-05-31'
    and paymethod in ('CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')
    AND actionrecommended <> 'BLOCK' AND responsestatus = 'SUCCESS'
    AND paytmmerchantid IS NOT NULL AND paytmmerchantid <> '' AND paytmmerchantid <> ' '
    AND globalcardindex IS NOT NULL AND globalcardindex <> '' AND globalcardindex <> ' ') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT * FROM 
    (SELECT A.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, 'edc_card_velocity_amount' AS rule_name, A.txn_timestamp
    , SUM(IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 21600000, B.txn_amount, NULL)) AS amt6_hr
    , 1000000 AS amt6_hr_threshold
    , SUM(B.txn_amount) as amt24_hr
    , 2000000 AS amt4_hr_threshold
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date  BETWEEN date'2025-05-01' AND DATE'2025-05-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid AND A.transactionid <> B.transactionid
    AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    GROUP BY 1,2,3,4,5,6,7)
WHERE ((amt6_hr + txn_amount) > 1000000) OR ((amt24_hr + txn_amount) > 2000000);

DROP TABLE team_kingkong.offus_edc_card_velocity_count_breaches;

-- CREATE TABLE team_kingkong.offus_edc_card_velocity_count_breaches AS
INSERT INTO team_kingkong.offus_edc_card_velocity_count_breaches
with offus_txn as
(SELECT DISTINCT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-01-01' - INTERVAL '1' DAY) AND DATE'2025-01-31'
    and paymethod in ('CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')
    AND actionrecommended <> 'BLOCK'AND responsestatus = 'SUCCESS'
    AND globalcardindex IS NOT NULL AND globalcardindex <> '' AND globalcardindex <> ' ' 
    AND paytmmerchantid IS NOT NULL AND paytmmerchantid <> '' AND paytmmerchantid <> ' ') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT * FROM 
    (SELECT A.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, 'edc_card_velocity_count' AS rule_name, A.txn_timestamp
    , COUNT(DISTINCT IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 60000, B.transactionid, NULL)) AS txn1_min
    , 2 AS txn1_min_threshold
    , COUNT(DISTINCT IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 21600000, B.transactionid, NULL)) AS txn6_hr
    , 5 as txn6_hr_threshold
    , COUNT(DISTINCT B.transactionid) as txn24_hr
    , 10 AS txn24_hr_threshold
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date BETWEEN DATE'2025-01-01' AND DATE'2025-01-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    AND A.transactionid <> B.transactionid
    GROUP BY 1,2,3,4,5,6,7)
WHERE (txn1_min >= txn1_min_threshold) OR (txn6_hr >= txn6_hr_threshold) OR (txn24_hr >= txn24_hr_threshold);

-- TPAP implementation date
SELECT DISTINCT regexp_replace(cast(json_extract(response, '$.messages.cst[0]') as varchar), '"', '') as risk_code
, MIN(DATE(dl_last_updated)) as implementation_date
FROM tpap_hss.upi_switchv2_dwh_risk_data_snapshot_v3
WHERE DATE(dl_last_updated) >= date'2024-01-01'
AND (lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) LIKE '%@paytm%'
or lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) like '%@pt%')
AND json_extract_scalar(response, '$.action_recommended') = 'BLOCK'
GROUP BY 1;

-- ONUS implementation date
select json_extract_scalar(actionrecommendedrules,'$.actionRecommendedRules[0]') as strategy_name
, MIN(DATE(dateinserted)) AS implementation_date
FROM cdp_risk_transform.maquette_flattened_onus_snapshot_v3
WHERE dl_last_updated >= date '2022-01-01'
AND SOURCE = 'PG' AND actionrecommended = 'BLOCK' AND json_extract_scalar(actionrecommendedrules,'$.actionRecommendedRules[0]') IS NOT NULL
GROUP BY 1

Are you ready to capitalize on IPL excitement with your fantasy sports app? Partnering with a trusted fantasy sports app development company can help you create an engaging platform tailored for cricket fans. With expert guidance, you can offer exciting features, real-time updates, and user-friendly interfaces that attract and retain players throughout the tournament. Capture the enthusiasm of millions, boost user engagement, and turn the IPL season into a great opportunity for your app’s success.

Beleaf Technologies offers affordable solutions to develop fantasy sports apps, providing cost-effective services without compromising quality, helping you enter the market quickly and attract sports enthusiasts with ease.

Know more :https://www.beleaftechnologies.com/fantasy-sports-app-development-company

Whatsapp: +91 7904323274
Telegram: @BeleafSoftTech
Mail to: mailto:business@beleaftechnologies.com

{
    "_id" : ObjectId("682ae3ab51f919e432c3b2d1"),
    "fv" : 2000,
    "pc" : "toi",
    "pfm" : "aos",
    "lid" : 0,
    "enable" : true,
    "deleted" : false,
    "value" : {
        "lang" : 1,
        "defaultSelectedSectionId" : "Home-01",
        "isToRetainUserSelection" : false,
        "bottomBarSections" : [ 
            {
                "uid" : "Home-01",
                "name" : "Home",
                "engName" : "Home",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?client=toi&pc=toi&pfm=aos&path=toi/home",
                "actionBarTitleName" : "Home",
                "tn" : "Home",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897786.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996271.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959876.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897787.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113323285.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113323312.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113323305.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323296.cms"
                }
            }, 
            {
                "uid" : "ETimes-01",
                "name" : "ETimes",
                "engName" : "ETimes",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?path=toi/home/entertainment&pc=toi&fv=<fv>&pfm=aos&client=toi",
                "actionBarTitleName" : "ETimes",
                "tn" : "pagerSection",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897789.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996275.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959881.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897791.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113323293.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113323319.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113323310.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323302.cms"
                },
                "primeSection" : {
                    "uid" : "Yoga-01",
                    "name" : "Yoga",
                    "engName" : "Yoga",
                    "defaulturl" : "https://timeshealthplus.com/TH/plans?acqSource=healthplus_bottomtab&acqSubSource=bottomtab_Icon_iOS&utm_source=Apps&utm_medium=bottomtab_IOS",
                    "actionBarTitleName" : "Yoga",
                    "tn" : "yoga",
                    "icons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "primeIcons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "hideBottomNav" : true,
                    "enableGenericAppWebBridge" : false,
                    "deeplink" : "toiapp://open-$|$-id=Yoga-01-$|$-lang=1-$|$-displayName=Yoga-$|$-url=https://timeshealthplus.com/TH/plans?acqSource=healthplus_bottomtab&acqSubSource=bottomtab_Icon_iOS&utm_source=Apps&utm_medium=bottomtab-$|$-type=htmlview-$|$-pubId-100"
                },
                "myTimes" : {
                    "uid" : "myTimes-01",
                    "name" : "myTimes",
                    "engName" : "myTimes",
                    "defaulturl" : "",
                    "actionBarTitleName" : "myTimes",
                    "tn" : "customtab",
                    "icons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "primeIcons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "hideBottomNav" : true,
                    "enableGenericAppWebBridge" : false
                }
            }, 
            {
                "uid" : "TOIPlus-01",
                "name" : " TOI+",
                "engName" : "TOI+",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?pc=toi&pfm=aos&path=toi/toiplushome&client=toi&fv=<fv>",
                "actionBarTitleName" : "TOI+",
                "tn" : "prSections",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897782.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996269.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959873.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897784.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/112376793.cms"
                }
            }, 
            {
                "uid" : "Print-Edition-01",
                "name" : "ePaper",
                "engName" : "ePaper",
                "defaulturl" : "https://epaper.indiatimes.com/timesepaper/publication-the-times-of-india,city-delhi.cms",
                "actionBarTitleName" : "ePaper",
                "tn" : "ePaperView",
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113088465.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996279.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959884.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323299.cms"
                },
                "icons" : {
                    "darkDeselected" : "https://static.toiimg.com/photo/120897794.cms",
                    "lightSelected" : "https://static.toiimg.com/photo/120766267.cms",
                    "lightDeselect" : "https://static.toiimg.com/photo/120766270.cms",
                    "darkSelected" : "https://static.toiimg.com/photo/120897797.cms"
                },
                "enableGenericAppWebBridge" : true
            }, 
            {
                "secPos" : 4,
                "uid" : "Game-01",
                "name" : "Games",
                "engName" : "Games",
                "defaulturl" : "https://nprelease.indiatimes.com/ufs-utility/toi-games/fetch/game/config?pc=<pc>&pfm=<pfm>&fv=<fv>&lang=<lang>",
                "actionBarTitleName" : "Games",
                "tn" : "games",
                "overrideSelected" : "true",
                "icons" : {
                    "darkDeselected" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_darktheme.png",
                    "lightSelected" : "https://static.toiimg.com/photo/120895359.cms",
                    "lightDeselect" : "https://static.toiimg.com/photo/120959879.cms",
                    "darkSelected" : "https://static.toiimg.com/photo/120766263.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_darktheme.png",
                    "lightSelected" : "https://static.toiimg.com/photo/114589843.cms",
                    "lightDeselect" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_lighttheme.png",
                    "darkSelected" : "https://static.toiimg.com/photo/114589840.cms"
                },
                "animateConfig" : {
                    "animateIconLight" : "https://static.toiimg.com/photo/114427341.cms",
                    "animateIconDark" : "https://static.toiimg.com/photo/114427337.cms",
                    "primeAnimateIconLight" : "https://static.toiimg.com/photo/114427341.cms",
                    "primeAnimateIconDark" : "https://static.toiimg.com/photo/114427337.cms",
                    "startTimeOfDay" : {
                        "hr" : 1,
                        "min" : 30
                    },
                    "endTimeOfDay" : {
                        "hr" : 23,
                        "min" : 30
                    },
                    "secondsStartAfter" : 5,
                    "animationDuration" : 2
                }
            }
        ],
        "cityFallbackSection" : {
            "uid" : "Photos-01",
            "name" : "Photos",
            "engName" : "Photos",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/client/toia/navigation/section?lang=1&uid=Photos-01&category=Photo-01&fv=1130&isPager=true",
            "actionBarTitleName" : "Photos",
            "tn" : "pagerSection",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_dark.png"
            }
        },
        "shortsSection" : {
            "uid" : "Shorts-01",
            "name" : "Shorts",
            "engName" : "Shorts",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/briefs/v1/toia/listing?lang=1&fv=1130",
            "actionBarTitleName" : "Shorts",
            "tn" : "shorts",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "IsPinned" : true
        },
        "outSideIndiaSection" : {
            "uid" : "VideoTB-01",
            "name" : "Videos",
            "engName" : "Videos",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/client/feed/list/toia/home-sections-news?lang=1&uid=VideoTB-01&puid=Home-01&category=VideoTB-01&adtag=homevideo&asset=ad,xwd,bn&fv=1130&swadTag=secWid",
            "actionBarTitleName" : "Videos",
            "tn" : "mixedList",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/video_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/video_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/video_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/video_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113398330.cms",
                "lightSelected" : "https://timesofindia.indiatimes.com/photo/113398327.cms",
                "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113398326.cms",
                "darkSelected" : "https://timesofindia.indiatimes.com/photo/113398328.cms"
            }
        },
        "briefETimesSection" : {
            "uid" : "Briefs-01",
            "name" : "Briefs",
            "engName" : "Brief",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/brief/toia/listing?lang=1&fv=1015&secuid=BriefsEntertainment-01&isincountry==true",
            "actionBarTitleName" : "Brief",
            "tn" : "briefList",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            }
        }
    }
}

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.Events;

public class TurnManager : MonoBehaviour
{
    [SerializeField] private Character[] characters;
    [SerializeField] private float nextTurnDelay = 1.0f;

    private int curCharacterIndex = -1;
    public Character CurrentCharacter;

    public event UnityAction<Character> OnBeginTurn;
    public event UnityAction<Character> OnEndTurn;

    // Singleton
    public static TurnManager Instance;

    void Awake ()
    {
        if(Instance != null && Instance != this)
            Destroy(gameObject);
        else
            Instance = this;
    }

    void OnEnable ()
    {
        Character.OnDie += OnCharacterDie;
    }

    void OnDisable ()
    {
        Character.OnDie -= OnCharacterDie;
    }

    void Start ()
    {
        BeginNextTurn();
    }

    // Called when a new player is ready for their turn.
    public void BeginNextTurn ()
    {
        curCharacterIndex++;

        if(curCharacterIndex == characters.Length)
            curCharacterIndex = 0;

        CurrentCharacter = characters[curCharacterIndex];
        OnBeginTurn?.Invoke(CurrentCharacter);
    }

    // Called after the current character has casted their combat action.
    public void EndTurn ()
    {
        OnEndTurn?.Invoke(CurrentCharacter);
        Invoke(nameof(BeginNextTurn), nextTurnDelay);
    }

    // Called when a character dies.
    void OnCharacterDie (Character character)
    {
        if(character.IsPlayer)
            Debug.Log("You lost!");
        else
            Debug.Log("You win!");
    }
}

-- REJECTION RATE 
CREATE TABLE team_kingkong.offus_rej_rate_monthly AS
WITH offus_base as 
(select DISTINCT a.*, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type from
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct actionrecommended
    , json_extract_scalar(actionrecommendedrulestatus, '$[0].status') as rule_status
    , json_extract_scalar(actionrecommendedrulestatus, '$[0].versionedRule.ruleName') as rule_name
    , transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , substr(cast(dl_last_updated as varchar(30)), 1, 7) AS yearMonth
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN date '2025-01-01' AND DATE'2025-05-31'
    and paymethod in ('UPI','CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')) a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT A.*, B.attempted_txn, B.attempted_gmv FROM
    (SELECT yearMonth, rule_name, mid_type
    , COUNT(transactionid) as rejected_txn
    , SUM(txn_amount) as rejected_gmv
    FROM offus_base
    WHERE actionrecommended = 'BLOCK' AND rule_status = 'LIVE'
    GROUP BY 1,2,3)A
INNER JOIN
    (SELECT yearMonth, mid_type
    , COUNT(transactionid) as attempted_txn
    , SUM(txn_amount) as attempted_gmv
    FROM offus_base
    GROUP BY 1,2)B
ON A.yearMonth = B.yearMonth AND A.mid_type = B.mid_type

-- Rule X Monthly Breach rate
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'MID_CCDC_Daily_TXN_limit_Check' AS rule_name
FROM team_kingkong.offus_MID_CCDC_Daily_TXN_limit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'edc_card_velocity_count' AS rule_name 
FROM team_kingkong.offus_edc_card_velocity_count_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'Merchant_PerTxnLimit_Check' AS rule_name  
FROM team_kingkong.offus_Merchant_PerTxnLimit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'edc_card_velocity_amount' AS rule_name  
FROM team_kingkong.offus_edc_card_velocity_amount_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'MID_UPI_Daily_TXN_limit_Check' AS rule_name  
FROM team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'oil_gas_dc_limit_EDC' AS rule_name  
FROM team_kingkong.offus_oil_gas_dc_limit_EDC_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_Unsafe_Country_Transactions' AS rule_name  
FROM team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'CCUPI_vpa_mid_hourly_limit' AS rule_name  
FROM team_kingkong.offus_CCUPI_vpa_mid_hourly_limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_PerCard_PerMID_TXN_Limit' AS rule_name  
FROM team_kingkong.offus_ICA_PerCard_PerMID_TXN_Limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'CCUPI_vpa_mid_daily_limit' AS rule_name  
FROM team_kingkong.offus_CCUPI_vpa_mid_daily_limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_OddTime_PerCard_PerMID_EDC' AS rule_name  
FROM team_kingkong.offus_ICA_OddTime_PerCard_PerMID_EDC_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_Bank_Decline_Threshold_Block' AS rule_name  
FROM team_kingkong.offus_ICA_Bank_Decline_Threshold_Block_breaches
GROUP BY 1;

-- OFFUS OVERALL BREACH RATE
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt FROM
(SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_MID_CCDC_Daily_TXN_limit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_edc_card_velocity_count_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount 
FROM team_kingkong.offus_Merchant_PerTxnLimit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_edc_card_velocity_amount_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_oil_gas_dc_limit_EDC_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_CCUPI_vpa_mid_hourly_limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_PerCard_PerMID_TXN_Limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount 
FROM team_kingkong.offus_CCUPI_vpa_mid_daily_limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_OddTime_PerCard_PerMID_EDC_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_Bank_Decline_Threshold_Block_breaches)
GROUP BY 1;

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

[CreateAssetMenu(fileName = "Combat Action", menuName = "New Combat Action")]
public class CombatAction : ScriptableObject
{
    public enum Type
    {
        Attack,
        Heal
    }

    public string DisplayName;
    public Type ActionType;

    [Header("Damage")]
    public int Damage;
    public GameObject ProjectilePrefab;

    [Header("Heal")]
    public int HealAmount;
}

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

[CreateAssetMenu(fileName = "Combat Action", menuName = "New Combat Action")]
public class CombatAction : ScriptableObject
{
    public enum Type
    {
        Attack,
        Heal
    }

    public string DisplayName;
    public Type ActionType;

    [Header("Damage")]
    public int Damage;
    public GameObject ProjectilePrefab;

    [Header("Heal")]
    public int HealAmount;
}

final_list = []
for _,row in dataset.iterrows():
    lat = row['latitude']
    lng = row['longitude']
    radius = row['radius']
    country_iso = row['country_iso']
    tran_month = row['month']
    tran_year = row['year']

    start_date,end_date = get_start_end_date(tran_month,tran_year)
    query = get_monthly_count_query(lat,lng,radius,tran_month,tran_year,country_iso)
    print(query)
    
    input_json = row.to_dict()
    result_dataset = execute_query(query,redshift_username, redshift_password)
    data_json = result_dataset.to_dict(orient='records')[0]
    final_json = {**input_json,**data_json}
    final_list.append(final_json)

final_dataset = pd.DataFrame(final_list)
final_dataset

nohup python manage.py runserver 0.0.0.0:8000 > Django_admin.log &

nohup celery -A mysite worker --loglevel=info > celery_worker.log &
nohup celery -A mysite beat --loglevel=info > celery_beat.log &

{
  "name": "Permissions Extension",
  ...
  "permissions": [
    "activeTab",
    "contextMenus",
    "storage"
  ],
  "optional_permissions": [
    "topSites",
  ],
  "host_permissions": [
    "https://www.developer.chrome.com/*"
  ],
  "optional_host_permissions":[
    "https://*/*",
    "http://*/*"
  ],
  ...
  "manifest_version": 3
}

<img src="line.jpg" alt="">

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":star: Xero Boost Days! :star:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Please see below for what's on this week! "
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-21: Wednesday, 21st May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy free coffee and café-style beverages from our partner, *Naked  Duck*.\n:breakfast: *Morning Tea*: Provided by *Naked Duck* from *9am* in the All Hands.\n:massage:*Wellbeing*: Crossfit class at *Be Athletic* from 11am."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-22: Thursday, 22nd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":coffee: *Café Partnership*: Café Partnership: Enjoy coffee and café-style beverages from our partner, *Naked Duck*.\n:late-cake: *Lunch*: Provided by *Naked Duck* from *12pm* in the All Hands."
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Stay tuned to this channel for more details, check out the <https://calendar.google.com/calendar/u/0/r?cid=Y185aW90ZWV0cXBiMGZwMnJ0YmtrOXM2cGFiZ0Bncm91cC5jYWxlbmRhci5nb29nbGUuY29t|*Sydney Social Calendar*>, and get ready to Boost your workdays!\n\nLove,\nWX Team :party-wx:"
			}
		}
	]
}

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":xeros-connect: Boost Days - What's on this week! :xeros-connect:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Morning Ahuriri :wave: Happy Monday, let's get ready to dive into another week with our Xeros Connect Boost Day programme! See below for what's in store :eyes:"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-21: Wednesday, 21st May :camel:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, located in our office building *8:00AM - 11:30AM*.\n:wrap: *Lunch*: Provided by *Design Cuisine* from *12:30PM-1:30PM* in the Kitchen."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-22: Thursday, 22nd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, located in our office building *8:00AM - 11:30AM*.\n:breakfast: *Breakfast*: Provided by *Roam* from *9:30AM-10:30AM* in the Kitchen."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-23: Friday, 23rd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:xero-hackathon: *Hackathon Social Happy Hour*: Enjoy some drinks and nibbles from *4:00PM-5:30PM* in Clearview, and celebrate our Hackathon Award winners!"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "*What else?* Stay tuned to this channel for more details, check out the <https://calendar.google.com/calendar/u/0?cid=eGVyby5jb21fbXRhc2ZucThjaTl1b3BpY284dXN0OWlhdDRAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ|*Hawkes Bay Social Calendar*>, and get ready to Boost your workdays!\n\nWX Team :party-wx:"
			}
		}
	]
}