magic-api/DAL.php at master · 4zero4/magic-api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php

	$CardTable = "mtg_cards";

	function sqlString($s, $db){
		return trim($db->real_escape_string($s));
	}

	function DB_create_card($cardObject, $db){
		$name = $cardObject["name"];
		$mana_cost = ( isset($cardObject["mana_cost"]) ? $cardObject["mana_cost"] : null);
		$converted_mana_cost = ( isset($cardObject["converted_mana_cost"]) ? $cardObject["converted_mana_cost"] : null);
		$types = $cardObject["types"];
		$card_text = $cardObject["card_text"];
		$flavor_text = ( isset($cardObject["flavor_text"]) ? $cardObject["flavor_text"] : null );
		$power_toughness = ( isset($cardObject["power_toughness"]) ? $cardObject["power_toughness"] : null);
		$expansion = $cardObject["expansion"];
		$rarity = $cardObject["rarity"];
		$card_number = $cardObject["card_number"];
		$artist = $cardObject["artist"];
		return DB_insert_card($name, $mana_cost, $converted_mana_cost, $types, $card_text, $flavor_text, $power_toughness, $expansion, $rarity, $card_number, $artist, $db);
	}

	function DB_insert_card($name, $mana_cost, $converted_mana_cost, $types, $card_text, $flavor_text, $power_toughness, $expansion, $rarity, $card_number, $artist, $db){
		$result = $db->query( SQL_create_card($name, $mana_cost, $converted_mana_cost, $types, $card_text, $flavor_text, $power_toughness, $expansion, $rarity, $card_number, $artist, $db) );
		if ($result){
			$id = $db->insert_id;
			return $id;
		}
		else {
			echo " [[ " . $db->error . " ]] ";
			return false;
		}
	}
	function SQL_create_card($name, $mana_cost, $converted_mana_cost, $types, $card_text, $flavor_text, $power_toughness, $expansion, $rarity, $card_number, $artist, $db){

		global $CardTable;

		$name = sqlString($name, $db);
		$mana_cost = sqlString($mana_cost, $db);
		$converted_mana_cost = sqlString($converted_mana_cost, $db);
		$types = sqlString($types, $db);
		$card_text = sqlString($card_text, $db);
		$flavor_text = sqlString($flavor_text, $db);
		$power_toughness = sqlString($power_toughness, $db);
		$expansion = sqlString($expansion, $db);
		$rarity = sqlString($rarity, $db);
		$card_number = sqlString($card_number, $db);
		$artist = sqlString($artist, $db);

		/*
		$card_text = addslashes($card_text);
		$flavor_text = addslashes($flavor_text);
		*/

		$SQL = "insert into $CardTable(name, mana_cost, converted_mana_cost, types, card_text, flavor_text, power_toughness, expansion, rarity, card_number, artist)
				values( '$name', '$mana_cost', '$converted_mana_cost', '$types', '$card_text', '$flavor_text', '$power_toughness', '$expansion', '$rarity', '$card_number', '$artist' );";
		//echo $SQL;
		//die();
		return $SQL;
	}

	function DB_card_exists($name, $db){
		$result = $db->query( SQL_card_exists($name, $db) );

		switch ($result->num_rows){
			case 0:
				return false;
				break;
			default:
				$fetchedCard = (array) $result->fetch_object();
				$fetchedCard["ID"] = "";
				$cardObject = array();
				foreach ($fetchedCard as $key => $value){
					if ($value){
						$cardObject[$key] = $value;
					}
				}
				return $cardObject;
		}
	}
	function SQL_card_exists($name, $db){
		global $CardTable;
		$name = sqlString($name, $db);
		return "Select * from $CardTable
				Where name = '$name'";
	}
?>