ce.php

<?php
error_reporting(0);
session_start();
function connect() {
	$db = new mysqli("host", "user", "pass", "db");
	if($db -> connect_error) {
		die("Couldn't connect to the database: " . $db -> connect_error);
	}
	return $db;
}

function getResourceList() {
	echo "<td>Resource List</td><td>Quantity</td>";
	$dbConnection = connect();
	$resources = array();
	foreach($_SESSION["schematics"] as $schem_id => $values) {
		$query = $dbConnection -> prepare("SELECT name1, name2, name3, name4, item1_req, item2_req, item3_req, item4_req FROM item_schems WHERE schem_id=? LIMIT 1");
		$query -> bind_param("i", $schem_id);
		$query -> execute();
		$query -> bind_result($item1, $item2, $item3, $item4, $req1, $req2, $req3, $req4);
		$query -> store_result();
		if($query -> num_rows > 0) {
			$query -> fetch();
			$query -> close();
			if(isset($item1) && $item1 != "blank") {
				$resources[$item1] += $req1;
			}
			if(isset($item2) && $item2 != "blank") {
				$resources[$item2] += $req2;
			}
			if(isset($item3) && $item3 != "blank") {
				$resources[$item3] += $req3;
			}
			if(isset($item4) && $item4 != "blank") {
				$resources[$item4] += $req4;
			}
		} else {
			echo "<td>ERROR</td>";
		}
	}
	foreach($resources as $resource => $quantity) {
		echo "<tr><td>" . htmlspecialchars($resource) . "</td><td>" . htmlspecialchars($quantity) . "</td></tr>";
	}
	$dbConnection -> close();
}

function getSchematicList() {
	echo "<tr><td>Schematics List</td></tr>";
}

function getModuleList() {
	echo "<tr><td>Module List</td></tr>";
}

function search($search) {
	$dbConnection = connect();
	$query = $dbConnection -> prepare("SELECT schem_id, item_name, schem_prod_skill, schem_manf_skill, item_store FROM item_schems WHERE item_name LIKE ? ORDER BY item_name ASC");
	$query -> bind_param("s", $search);
	$query -> execute();
	$query -> bind_result($schem_id, $item_name, $schem_prod_skill, $schem_manf_skill, $item_store);
	$query -> store_result();
	$ret = array();
	if($query -> num_rows > 0) {
		while($query -> fetch()) {
			$ret[] = array(
				"id" => htmlspecialchars($schem_id),
				"name" => htmlspecialchars($item_name),
				"prod" => htmlspecialchars($schem_prod_skill),
				"manf" => htmlspecialchars($schem_manf_skill),
				"store" => htmlspecialchars($item_store)
			);
		}
	}
	$query -> close();
	$dbConnection -> close();
	return (count($ret) > 0 ? $ret : array());
}

function getSchematic($item_id) {
	$dbConnection = connect();
	$query = $dbConnection -> prepare("SELECT item_name, schem_prod_skill, schem_manf_skill, item1, item2, item3, item4, item5, item6, item1_req, item2_req, item3_req, item4_req, item5_req, item6_req, xp_given, item_cost, name1, name2, name3, name4, name5, name6, schem_desc FROM item_schems WHERE schem_id=? LIMIT 1");
	$query -> bind_param("i", $item_id);
	$query -> execute();
	$query -> bind_result($item_name, $schem_prod_skill, $schem_manf_skill, $item1, $item2, $item3, $item4, $item5, $item6, $item1_req, $item2_req, $item3_req, $item4_req, $item5_req, $item6_req, $xp_given, $item_cost, $name1, $name2, $name3, $name4, $name5, $name6, $schem_desc);
	$query -> store_result();
	if($query -> num_rows == 1) {
		$query -> fetch();
		$ret = array(
			"item_name" => $item_name,
			"schem_prod_skill" => $schem_prod_skill,
			"schem_manf_skill" => $schem_manf_skill,
			"name1" => $name1,
			"name2" => $name2,
			"name3" => $name3,
			"name4" => $name4,
			"name5" => $name5,
			"name6" => $name6,
			"item1" => $item1,
			"item2" => $item2,
			"item3" => $item3,
			"item4" => $item4,
			"item5" => $item5,
			"item6" => $item6,
			"item1_req" => $item1_req,
			"item2_req" => $item2_req,
			"item3_req" => $item3_req,
			"item4_req" => $item4_req,
			"item5_req" => $item5_req,
			"item6_req" => $item6_req,
			"xp_given" => $xp_given,
			"item_cost" => $item_cost,
			"schem_desc" => $schem_desc
		);
	} else {
		$ret = array();
	}
	$query -> close();
	$dbConnection -> close();
	return $ret;
}

function getAllSchematics($page, $limit = 25) {
	$dbConnection = connect();
	$current = ($page - 1) * $limit);
	$query = $dbConnection -> prepare("SELECT schem_id, item_name, schem_prod_skill, schem_manf_skill, item_store FROM item_schems ORDER BY item_name ASC LIMIT ?, ?");
	$query -> bind_param("ii", $current, $limit);
	$query -> bind_result($schem_id, $item_name, $schem_prod_skill, $schem_manf_skill, $item_store);
	$query -> store_result();
	if($query -> num_rows > 0) {
		$ret = array();
		while($query -> fetch()) {
			$ret[] = array(
				"schem_id" => $schem_id,
				"item_name" => $item_name,
				"schem_prod_skill" => $schem_prod_skill,
				"schem_manf_skill" => $schem_manf_skill,
				"item_store" => $item_store
			);
		}
	} else {
		$ret = array();
	}
	$query -> close();
	$dbConnection -> close();
	return $ret;
}
?>