EasyTCG: Get Category

This mod gathers a list of your catagories for use with other mods.

I'm hosting EasyTCG mods on my Github & crediting the source, because too often TCG mod sites go down (entire forums of contributed code have gone down) & that code is lost forever unless the Internet Archive happened to save a copy.

Credit

Created by Dite, originally posted on filler00, and tweaked by Kriss.

Before installing ANY etcg mods

Open your func.php file & scroll all the way to the bottom. Before the last line, put include('mods.php');.

Create a new file named mods.php in the same directory as func.php & put the following:

<?php {

} ?>

Alternative route if you're not familiar with code

You can create a mods.php file & mods folder so your mods file will essentially look like this with each mod you have:

<?php {

	include('mods/mod-name.php');

} ?>

This will help you troubleshoot, too, as you can just rename each file to have a 1 after if you need to deduce which code is causing your problems. That said, this isn't flawless & you still need to upload the mod files to the mods directory if you go this route.

Troubleshooting

• If you have ETCG 1.0.1, your mods will use mysql.
• If you have ETCG 1.1.0, your mods will use mysqli.
• Make sure you do not have the same mod in your mods.php file twice.
• Please double check these things if you have a problem!

Display errors

If your post is broken or showing a blank page, try adding the following to your header:

ini_set("display_errors", "1");error_reporting(E_ALL);

• This may show us an error code that will help deduce what is wrong.
• You can remove this when you are done.

Installation

Open mods.php and paste the following between the php tags:

// GET CATAGORY MOD BY DITE (code hosted at https://github.com/autisticjane/etcg-get-category/)
function get_category( $tcg, $category) {

	$database = new Database;
	$sanitize = new Sanitize;
	$tcg = $sanitize->for_db($tcg);
	$category = $sanitize->for_db($category);
	$altname = strtolower(str_replace(' ','',$tcg));

	$result = $database->get_assoc("SELECT `id` FROM `tcgs` WHERE `name`='$tcg' LIMIT 1");
	$tcgid = $result['id'];
	
	$result = $database->get_assoc("SELECT `cards` FROM `cards` WHERE `tcg`='$tcgid' AND 

`category`='$category' LIMIT 1");
	return $result['cards'];

}