PHP Warning:  Module 'soap' already loaded in Unknown on line 0

Warning: Module 'soap' already loaded in Unknown on line 0
Psy Shell v0.9.12 (PHP 7.3.33 — cli) by Justin Hileman
New version is available (current: v0.9.12, latest: v0.12.24)
>>> echo "===COUNTS===";
===COUNTS===⏎
>>> $u = DB::select("SELECT COUNT(*) as c FROM tb_users")[0]->c; echo "tb_users: $u
... ";
tb_users: 21
>>> $u2 = DB::select("SELECT COUNT(*) as c FROM users")[0]->c; echo "users: $u2
... ";
users: 406776
>>> $du = DB::select("SELECT COUNT(*) as c FROM deleted_users")[0]->c; echo "deleted_users: $du
... ";
deleted_users: 347393
>>> $pc = DB::select("SELECT COUNT(*) as c FROM partner_credentials")[0]->c; echo "partner_credentials: $pc
... ";
partner_credentials: 0
>>> $pr = DB::select("SELECT COUNT(*) as c FROM partner_requests")[0]->c; echo "partner_requests: $pr
... ";
partner_requests: 28338
>>> $st = DB::select("SELECT COUNT(*) as c FROM stores")[0]->c; echo "stores: $st
... ";
stores: 996
>>> $nw = DB::select("SELECT COUNT(*) as c FROM networks")[0]->c; echo "networks: $nw
... ";
networks: 36
>>> $pg = DB::select("SELECT COUNT(*) as c FROM payout_gateways")[0]->c; echo "payout_gateways: $pg
... ";
payout_gateways: 1
>>> $pm = DB::select("SELECT COUNT(*) as c FROM payout_methods")[0]->c; echo "payout_methods: $pm
... ";
payout_methods: 7
>>> $pp = DB::select("SELECT COUNT(*) as c FROM processed_payouts")[0]->c; echo "processed_payouts: $pp
... ";
processed_payouts: 2534
>>> $sl = DB::select("SELECT COUNT(*) as c FROM sales")[0]->c; echo "sales: $sl
... ";
sales: 2398946
>>> $bt = DB::select("SELECT COUNT(*) as c FROM balance_transactions")[0]->c; echo "balance_transactions: $bt
... ";
balance_transactions: 11001790
>>> $lk = DB::select("SELECT COUNT(*) as c FROM login_keys")[0]->c; echo "login_keys: $lk
... ";
login_keys: 958
>>> $up = DB::select("SELECT COUNT(*) as c FROM user_payout_methods")[0]->c; echo "user_payout_methods: $up
... ";
user_payout_methods: 31162
>>> $ua = DB::select("SELECT COUNT(*) as c FROM user_activities")[0]->c; echo "user_activities: $ua
... ";
user_activities: 101088577
>>> echo "===STRUCTURE_TB_USERS===";
===STRUCTURE_TB_USERS===⏎
>>> $cols = DB::select("DESCRIBE tb_users"); foreach($cols as $c) { echo $c->Field." (".$c->Type.")
... "; }
id (int)
group_id (int)
username (varchar(100))
password (varchar(64))
email (varchar(100))
first_name (varchar(50))
last_name (varchar(50))
avatar (varchar(100))
active (tinyint unsigned)
login_attempt (tinyint)
last_login (datetime)
created_at (timestamp)
updated_at (timestamp)
reminder (varchar(64))
activation (varchar(50))
remember_token (varchar(100))
last_activity (int)
config (mediumtext)
blocked (tinyint(1))
>>> echo "===STRUCTURE_PARTNER_CREDENTIALS===";
===STRUCTURE_PARTNER_CREDENTIALS===⏎
>>> $cols2 = DB::select("DESCRIBE partner_credentials"); foreach($cols2 as $c) { echo $c->Field." (".$c->Type.")
... "; }
id (bigint unsigned)
name (varchar(100))
api_key_hash (char(64))
user_id (bigint unsigned)
is_active (tinyint(1))
rate_limit_per_minute (int unsigned)
last_used_at (timestamp)
created_at (timestamp)
updated_at (timestamp)
>>> echo "===STRUCTURE_STORES===";
===STRUCTURE_STORES===⏎
>>> $cols3 = DB::select("DESCRIBE stores"); foreach($cols3 as $c) { echo $c->Field." (".$c->Type.")
... "; }
id (bigint unsigned)
slug (varchar(191))
name (json)
about_store (json)
more_about_store_title (json)
more_about_store (json)
sp_terms_title (json)
sp_terms (json)
cb_terms (json)
secrets (json)
h1_tag (json)
h2_tag (json)
meta_title (json)
meta_desc (json)
meta_kw (json)
logo (varchar(200))
categories (json)
store_family_id (bigint unsigned)
offers_count (int)
current_cb (decimal(10,2))
was_cb (varchar(255))
amount_type (enum('percent','fixed'))
rate_type (enum('flat','upto'))
header_image (varchar(500))
ref_id (varchar(50))
homepage (json)
domain_name (varchar(500))
dl_url_build (varchar(2500))
cb_status (tinyint(1))
cashback_percent (int)
rate_stars (decimal(3,1))
rate_count (int)
tracking_days (int)
claim_days (int)
clicks (int)
creation_mode (varchar(50))
network_id (int)
network_store_id (bigint)
filter (json)
status (enum('publish','draft','trash'))
visits (int)
exclude_sitemap (tinyint(1))
created_at (timestamp)
updated_at (timestamp)
sweet_store_id (varchar(50))
sweet_data (json)
ext_info (json)
checkout_url (varchar(500))
region_code (json)
tracking_channels (enum('web','mobile','both'))
cb_mobile (tinyint(1))
cb_coupon (tinyint(1))
related_stores (json)
background_color (varchar(191))
text_color (varchar(191))
app_homepage (varchar(191))
dl_app_url_build (varchar(191))
cb_deal_type (enum('percent','fixed'))
cb_deal_value (double)
cb_valid_period (int)
is_featured (tinyint(1))
>>> echo "===STRUCTURE_PAYOUT_GATEWAYS===";
===STRUCTURE_PAYOUT_GATEWAYS===⏎
>>> $cols4 = DB::select("DESCRIBE payout_gateways"); foreach($cols4 as $c) { echo $c->Field." (".$c->Type.")
... "; }
code (varchar(191))
access_token (varchar(191))
expires_at (datetime)
extra_data (json)
>>> echo "===STRUCTURE_NETWORKS===";
===STRUCTURE_NETWORKS===⏎
>>> $cols5 = DB::select("DESCRIBE networks"); foreach($cols5 as $c) { echo $c->Field." (".$c->Type.")
... "; }
id (int)
name (varchar(255))
controller (varchar(255))
affiliate_id (varchar(255))
website_id (int)
api_key (varchar(255))
private_key (varchar(255))
api_url (varchar(255))
short_name (varchar(50))
campaign_statuses (json)
sale_statuses (json)
confirm_days (int)
enabled (tinyint(1))
error_count (int)
type (enum('webhook','pull','manual'))
auto_confirm (tinyint(1))
>>> echo "===STRUCTURE_LOGIN_KEYS===";
===STRUCTURE_LOGIN_KEYS===⏎
>>> $cols6 = DB::select("DESCRIBE login_keys"); foreach($cols6 as $c) { echo $c->Field." (".$c->Type.")
... "; }
id (bigint unsigned)
user_id (int)
email (varchar(255))
key (varchar(255))
created_at (timestamp)
updated_at (timestamp)
is_active (tinyint(1))
>>> exit;
Exit:  Goodbye