DBHunter
Infinity Member
Golden Member
- Joined
- August 23, 2025
- Messages
- 2,209
- Reaction score
- 4,550
- Points
- 113
- Thread Author
- #1
HELLO DNA COMMUNITY,
Today I have analyzed the carsworld.id database containing 213,303 merchant records from an automotive service platform.
Database Info:
Compromised Data
Key Table & Data
Code:
Today I have analyzed the carsworld.id database containing 213,303 merchant records from an automotive service platform.
Database Info:
- Domain: carsworld.id
- Original File: carsworld.id.sql (2.88 MB / 3,027,579 bytes)
- Platform: Automotive Services / Merchant Marketplace
- Region: Indonesia (ID)
- Total Records: ~213,303 lines
Compromised Data
- Merchant ID and category mapping
- Business name and description fields
- Contact information (email, phone, WhatsApp)
- Location hierarchy (province, city, district, village)
- Full address and geolocation (latitude/longitude)
- Service availability and booking slots
- Operating hours (open/close times)
- Ratings and feature flags
- Image URLs for merchant listings
- System metadata (created/updated timestamps, external IDs)
Key Table & Data
- t_merchant – workshops/merchants with address, contact, GPS, ratings, images, and operating hours
- t_artikel_konsultasi – consultation articles with categories and URLs
- t_workshop_owner – workshop owners with email, phone, status, and ban info
- t_workshop_owner_session – owner login sessions with device, IP, and user agent data
Code:
--- [HASH=3102]###[/HASH] **1️⃣ t_merchant (10 rows)** ```sql INSERT INTO `t_merchant` (`id`, `category_id`, `name`, `deskripsi`, `email`, `phone`, `whatsapp`, `propinsi`, `kota`, `kecamatan`, `kelurahan`, `id_wilayah`, `alamat_lengkap`, `image_url`, `rating`, `latitude`, `longitude`, `enabled`, `home_services`, `is_featured`, `booking_time`, `open_operation`, `close_operation`, `external_id`, `created`, `updated_at`, `updated_by`) VALUES (1, 1, '[DEV] CARfix WR Supratman', '', 'rudiyanto@carfix.co.id', '', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Semarang Barat', 'Gisikdrono', '33.74.13', 'Jl. WR. Soepratman No.18 Semarang', 'https://images.ved.carsworld.id/i/7763a3b7652586e522136474565a5cc1.jpg', 4.4, -6.98901586, 110.38562056, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:54:15', '2020-10-15 15:37:33', 'pandu.wiliantoro'), (2, 1, '[DEV] CARfix Brigjend Sudiarto', '', 'ilham@carfix.co.id', '02476719060', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Pedurungan', 'Palebon', '33.74.06', 'Jl. Brigjend Sudiarto No.426, Semarang', 'https://static.carsworld.id/images/g/n/gn.jpg', 4.4, -7.01007027, 110.47011595, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:54:53', '2021-01-11 19:33:23', 'pandu.wiliantoro'), (3, 1, '[DEV] CARfix Tentara Pelajar', '', 'mustajab@carfix.co.id', '02486452880', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Candisari', 'Jomblang', '33.74.08', 'Jl. Tentara Pelajar No.25, Semarang', 'https://images.ved.carsworld.id/i/6e60426bd294de5b125a060de6264a63.jpg', 4.5, -7.00911164, 110.43353213, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:55:22', '2021-01-11 19:33:23', 'pandu.wiliantoro'), (4, 1, '[DEV] CARfix Wali Songo', '', 'nouval@carfix.co.id', '0248662321', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Tugu', 'Karanganyar', '33.74.16', 'Jl. Walisongo KM11 No.203 Tugu Semarang', 'https://images.ved.carsworld.id/i/6e391be2ad90ce466a3ae1d363fafb67.jpg', 4.3, -6.98379520, 110.33873166, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:55:44', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (5, 1, '[DEV] CARfix Veteran Solo', '', 'rudi.setyawan@carfix.co.id', '0271710177', '+628112982288', 'Jawa Tengah', 'Kota Surakarta', 'Pasar Kliwon', 'Pasar Kliwon', '33.72.03', 'Jl. Veteran No.278, Tipes, Solo', 'https://images.ved.carsworld.id/i/b0ba40fbf789fe2b1bdec47b712c2e10.jpg', 4.4, -7.57895105, 110.81007154, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:19:50', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (6, 1, '[DEV] CARfix Ringroad Selatan', '', 'tulus.widodo@carfix.co.id', '02744342941', '+628112982288', 'DIY Yogyakarta', 'Kab. Bantul', 'Kasihan', 'Tamantirto', '34.02.16', 'Jl. Ringroad Selatan, Taman Tirto, Bantul', 'https://images.ved.carsworld.id/i/365ebbbc6c5966bfdb1c2c5e3037aa14.jpg', 4.5, -7.82166594, 110.32450466, 1, 0, 0, '["9:00","10:00","11:00","13:00","14:00"]', '08:00:00', '17:00:00', '', '2020-02-18 10:50:23', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (7, 1, '[DEV] CARfix Dr. Cipto', '', 'arief.eko@carfix.co.id', '0248318120', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Semarang Timur', 'Karangtempel', '33.74.03', 'Jl. Dr.Cipto No.218, Semarang', 'https://images.ved.carsworld.id/i/c18d1191f55807ecf3adf4c1435f8c8c.jpg', 4.8, -6.99073938, 110.43450286, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:10:48', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (8, 1, '[DEV] CARfix Setiabudi', '', 'jamil@carfix.co.id', '02476405427', '+628112982288', 'Jawa Tengah', 'Kota Semarang', 'Banyumanik', 'Srondol Kulon', '33.74.11', 'Jl. Setiabudi No.229, Semarang', 'https://images.ved.carsworld.id/i/3d13a36b29695af48166c8576fb4dbdd.jpg', 4.5, -7.06204434, 110.41278127, 1, 0, 0, '["8:00","9:00","10:00","11:00","13:00","14:00","15:00"]', '08:00:00', '17:00:00', '', '2020-02-18 12:12:55', '2021-01-11 19:33:24', 'pandu.wiliantoro'), (9, 1, '[DEV] CARfix Kendal', '', 'hudahapsara@gmail.com', '02943690970', '+628112982288', 'Jawa Tengah', 'Kab. Kendal', 'Kendal', 'Ketapang', '33.24.15', 'Jl. Soekarno-Hatta No.60 Kendal', 'https://images.ved.carsworld.id/i/3029b2a133be32623d7 ```