slork/properties.php

<?php

require "settings.php";

$properties = json_decode( '{
	"level": 95,
	"gender": "Female",
	"player_id": 123123123,
	"name": "onetwothree",
	"personalstats": {
		"useractivity": 26835837,
		"logins": 4361,
		"weaponsbought": 11148,
		"attackmisses": 23164,
		"attackdamage": 59351490,
		"attackhits": 52858,
		"axehits": 1067,
		"attackswon": 14060,
		"highestbeaten": 100,
		"bestkillstreak": 504,
		"jailed": 306,
		"mailssent": 1725,
		"attackcriticalhits": 10820,
		"slahits": 426,
		"moneymugged": 19552822850,
		"largestmug": 1000026663,
		"friendmailssent": 375,
		"roundsfired": 271197,
		"pishits": 347,
		"defendswon": 2765,
		"hospital": 8416,
		"defendslost": 3737,
		"rifhits": 6620,
		"attackslost": 797,
		"attacksassisted": 336,
		"attacksstealthed": 8336,
		"onehitkills": 6547,
		"dumpsearches": 1026,
		"dumpfinds": 1026,
		"itemsdumped": 5050,
		"itemssent": 3568,
		"drugsused": 5358,
		"cantaken": 77,
		"auctionswon": 16,
		"daysbeendonator": 1883,
		"spousemailssent": 104,
		"medicalitemsused": 21768,
		"companymailssent": 185,
		"trainsreceived": 1071,
		"cityfinds": 522,
		"theyrunaway": 1022,
		"failedbusts": 249,
		"peoplebusted": 3002,
		"pointsbought": 44095,
		"itemsbought": 3426,
		"xantaken": 4818,
		"traveltimes": 3488,
		"mextravel": 483,
		"itemsboughtabroad": 93119,
		"cantravel": 462,
		"lontravel": 390,
		"caytravel": 418,
		"argtravel": 350,
		"hawtravel": 165,
		"japtravel": 132,
		"switravel": 587,
		"soutravel": 133,
		"dubtravel": 172,
		"chitravel": 196,
		"shrtaken": 50,
		"shohits": 157,
		"piehits": 4646,
		"bountiescollected": 798,
		"totalbountyreward": 210769630,
		"medstolen": 8,
		"attacksdraw": 218,
		"virusescoded": 125,
		"yourunaway": 157,
		"victaken": 84,
		"overdosed": 109,
		"revivesreceived": 806,
		"auctionsells": 15,
		"exttaken": 246,
		"kettaken": 50,
		"respectforfaction": 76343,
		"smghits": 1663,
		"bountiesreceived": 206,
		"factionmailssent": 173,
		"peoplebought": 502,
		"peopleboughtspent": 54974080,
		"chahits": 234,
		"machits": 119,
		"heahits": 697,
		"networth": 30999395805,
		"grehits": 276,
		"missioncreditsearned": 40991,
		"contractscompleted": 1024,
		"dukecontractscompleted": 1024,
		"revives": 663,
		"missionscompleted": 1,
		"bountiesplaced": 487,
		"totalbountyspent": 194943585,
		"bloodwithdrawn": 5140,
		"lsdtaken": 11,
		"defendsstalemated": 28,
		"meritsbought": 45,
		"opitaken": 14,
		"nerverefills": 1412,
		"consumablesused": 24815,
		"candyused": 1838,
		"alcoholused": 13924,
		"energydrinkused": 9053,
		"tokenrefills": 202,
		"organisedcrimes": 158,
		"booksread": 10,
		"h2hhits": 147,
		"classifiedadsplaced": 6,
		"traveltime": 38079060,
		"unarmoredwon": 261,
		"stockpayouts": 489,
		"boostersused": 1189,
		"territorytime": 2655360,
		"rehabs": 6695,
		"rehabcost": 1410430000,
		"awards": 462,
		"statenhancersused": 5,
		"bestdamage": 11472,
		"racingpointsearned": 2139,
		"raceswon": 701,
		"racesentered": 2402,
		"receivedbountyvalue": 88109384,
		"pcptaken": 1,
		"cityitemsbought": 85276,
		"specialammoused": 10977,
		"spetaken": 1,
		"hollowammoused": 4000,
		"tracerammoused": 2498,
		"incendiaryammoused": 2493,
		"piercingammoused": 1986,
		"refills": 1614
	},
	"status": {
		"description": "Okay",
		"details": "",
		"state": "Okay",
		"color": "green",
		"until": 0
	},
	"criminalrecord": {
		"selling_illegal_products": 5003,
		"theft": 25055,
		"auto_theft": 3003,
		"drug_deals": 697,
		"computer_crimes": 7172,
		"murder": 10019,
		"fraud_crimes": 10340,
		"other": 5007,
		"total": 66296
	}
}');

print( "<pre>" );
print_r( $properties );
print( "</pre>");

$list = [];
foreach ( $properties as $key => $val ) {
	if ( is_object( $val ) ) {
		foreach( $val as $subkey => $subval) {
			$list[] = [$subkey, $key];
		}
	} else {
		$list[] = [$key, ''];
	}
}
print("<pre>");
print_r( $list );
print("</pre>");

$pdo = null;
try {
	$pdo = new PDO("sqlite:" . "${db_path}/slork.sqlite");
} catch (PDOException $e) {
	// handle the exception here
}
if ( !$pdo ) {
	exit( "Cannot connect to database" );
}
$query = "DROP TABLE IF EXISTS properties;";
$pdo->exec( $query );
$query = <<<QUERY
	CREATE TABLE IF NOT EXISTS properties (
	    id INTEGER PRIMARY KEY, property TEXT, parent TEXT, UNIQUE(property));
QUERY;
$pdo->exec( $query );
$query = "INSERT INTO properties (property, parent) VALUES (?, ?) ON CONFLICT (property) DO NOTHING;";
$stmt = $pdo->prepare( $query );
foreach ( $list as $item ) {
	$stmt->execute( $item );
}
/**
$query = "SELECT property FROM properties;";
$stmt = $pdo->query( $query );
foreach( $stmt as $row ) {
	print( $row['property'] . ', ');
}
*/