JUNE SLOTS AND POG TRADES~

[neverbepractical]

hi hi~ i'm not collecting this time and i need trades for pog, so please help me out! <3

slots
1. artificial02
2. killed02
3. yousei07
4. agoraphobic20
5. greatspirit10
6. atlamillia08
7. genie08
8. slingshot09
9. archest09
10. cowlick08
sp. ghosts09

if i run out of slots but you want a card pls let me know cos i have some +2/+3 slot coupons still valid that i want to use asap!

POG trades
1. lahariel
2. skybuns
3. toffeecat
4. kellidee
5. needles
6. kureto
7. canute
8. chuuya
9. anaraine
10. kippi
11. adurotum
12. netbug
13. pinnku
14. curie
15. lacie

i also have TWELVE signatures (how x_x) so lets trade those if we haven't already!

ALSO.... if you dont want to load all the cards i have available to trade, all the card names are here in a google doc that you can just CTRL+F through! i use it for asking people for trades but it might be useful the other way round??

Comments

[eclair]

Hello, Miro! Would I have anything here for your asleep06, clueless18, collector05, defeated17, dna09, galaxy11, gekokujou12, kiyoubinbou01, kiyoubinbou10, kiyoubinbou11, kiyoubinbou17, measuring05, mudabijin16, ore-sama02, piano02, piano05, wanted18, wutai14? Please let me know if it's too much, I can decrease the size!

I think there is a code somewhere that just prints out all the text from a collection. I'm gonna try and find it. An alternative way for easy trade pile perusal is through view-source.

Edit: Found it! No idea if it works or not.

[neverbepractical]

i am.. much too dumb with this coding thing to figure that out, unfortunately ;_; i wouldn't know where to begin with getting it to work.

but sure! how about actor08, correct13, dependent15, efficient18, honeybuddha11, himegimi09, lascivious01, pitcher06, southpaw09, subordinate17, third19, universe02, wingman15, senbon08, recipes05, miraculous18, flaming12, crazyd17?

[eclair]

I'm gonna test it later (probably on Monday). Will let you know if it works!



Thank you. ♥

[eclair]

IT WORKS. Let me know if you want to know how? It's actually just copy and pasting the codes in. XD

[neverbepractical]

i tried to copy paste it but i'm not entirely sure where/how things should go/work so yes please! ;v:

[eclair]

Copy and paste the function into your function.php

// Text mod 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']; }

The next part was the most confusing... But you just copy and paste this

<?php echo get_category('TCGNAME','CATEGORYNAME'); ?>

into the place where you want it to be executed. Just change the TCGNAME/CATEGORYNAME to what you need to display. If you're still having trouble, let me know! :-D

[neverbepractical]

i am still having trouble, it seems ;_; i think i must be putting the text mod into the wrong place in my function.php because whenever i paste it in it just breaks my whole site dfjgjsdfg ;;;;

[eclair]

Oh no. Hmmm, did you paste it near the end of your func.php before the closing ?>

Here's how my func.php look as an example.

I'm pretty bad at explaining, might have to teamviewer to solve this. ;;

[neverbepractical]

yup, i even copy pasted the end of your func. to see if it would work and it didnt ;_; </3 i'm up for solving it if you are, i can upload my files or do teamviewer (whatever that is :P)

[eclair]

Sure, if you're willing to share your files, that will work! I can try and recreate the problem and see what's going on. Just let me know what version of eTCG you're using and take a screenshot of what happens when you have the function added so I can see what breaks.

TeamViewer just shares your computer screen with someone else in real time. XD

[neverbepractical]

OH i'm up to teamview if you like, but if not, here's my files.

here's my func.php and here's my colors.php -- let me know if you need anything else?

my etcg is v1.1.0 i think? and the result i get when it totally breaks my site is

Fatal error: Cannot redeclare get_category() (previously declared in /home/mirotcg/neverbepractical.fairy-fountain.net/func.php:97) in /home/mirotcg/neverbepractical.fairy-fountain.net/func.php on line 520

[eclair]

Hmm. Have you added any other mods in your func.php or mod.php before? There might be something in your mod.php that is conflicting with the code.

[neverbepractical]

nope, the only other thing i've done to my func is install the code for the search bar, i'm pretty sure 8(

[eclair]

So the error says the get_category() function is already defined on line 97 and 520. Your func.php doesn't have 520 lines, so I assume it's something in your mod.php that's conflicting with it.

[neverbepractical]

my mods.php is empty - though it is called mods rather than mod, does that make a difference?

[eclair]

Nope. You're right, it's called mods.php. :-D

I'm going to try and create a new eTCG and see if it shows the same error with your func.php and colors.php

[eclair]

It works for me! Here's my bad test page. We might have to teamviewer to solve this problem. Let me know when you're available! Or if you ever see me on Discord, give me a poke. C:

[neverbepractical]

does the brain splodey motions

i don't think i have you on discord? but my UN is miro#8202! if i'm green i'm online and around!

[neverbepractical]

HEY just letting you know that since i got a new host it appears to be working correctly!! no idea what fixed it but yay :D

thank you for all your help!~

[eclair]

YAY. \ o /

I swear it was something in mods.php, lmao.