Trades and Codes

[adurotum]

Hello Colors!

Ten here, swinging through with a few quick code edits for those using websites. The first is for alphabetizing your mastery page because alphabetization rocks. The other code is for adding quote text and badge to your mastery page.

If there's any code edits you've been itching for on your site, feel free to message me. I can't guarantee I'll be able to code something, but I'll always try!

I'd also like to open my pile up to regular and random trades! My trade pile is looking like a monster recently, so I'd really like to cut it down some. If you don't see anything I'm collecting, feel free to link your trade pile and I'll pick something out.

Thanks!

Comments

[kuranosuke]

Well, I tried to fix it with the knowledge I have... and now my card count says zero. Go me, hahaha... I'll have to try and fix this. It didn't help that I undo'd everything (for some reason collecting counts... work).

and yes, that sounds good c: thank you.

[adurotum]

That's weird 8|a I messed up a few times by forgetting to include a necessary field though, maybe that might be why?

[kuranosuke]

Hmm... well, my func.php now looks like this (without passwords shown, of course, haha). I don't think I made any major mistakes...

[adurotum]

Hmm, did you just want to show your worth value instead of your card count value?

[kuranosuke]

Well, right now I kinda want it to show any card value right now, as nothing is showing ... but I think it's worth value that leaves out the 00 cards if you put them to right categories?

Sorry for the trouble, by the way. I probably should have listened to the "don't touch this unless you know what you're doing" part, haha.

[adurotum]

I am a firm believer of breaking things as a method to fix them.

Your code looks the same as mine in func.php. Could you c/p me how your code looks in colors.php, the one you're using to call counts?

[kuranosuke]

<?php echo cardcount('colors'); ?> <?php echo cardcount('colors','','topp'); ?>

The code looks like this for the total count, and in individual categories its like the second one.

[adurotum]

... that is really weird, it looks pretty much identical to what I have.

Just in case something got messed up in the code, here's my code for that function (I haven't done any alterations to it).

// Generate a total card count/worth of all cards in the collection, or by category. $tcg = the name of the TCG as defined in the database; $type = worth OR empty to ignore worth; $cat = 'CATEGORY NAME' OR 'collecting' OR 'mastered' OR 'pending' OR empty to count all cards in collection function cardcount ($tcg,$type = '',$cat = '') { $database = new Database; $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='$tcg' LIMIT 1"); $tcgid = $tcginfo['id']; // Count categories $result = $database->query("SELECT `category`,`cards`,`worth` FROM `cards` WHERE `tcg`='$tcgid'"); while ( $row = mysql_fetch_assoc($result) ) { $categories[] = $row['category']; if ( $row['cards'] === '' ) { $$row['category'] = 0; } else { $cards = explode(',',$row['cards']); $$row['category'] = count($cards); } if ( $type === 'worth' ) { $$row['category'] = $$row['category'] * $row['worth']; } $total = $total + $$row['category']; } // Count collecting $result = $database->query("SELECT `cards`,`worth` FROM `collecting` WHERE `tcg`='$tcgid' AND `mastered`='0'"); while ( $row = mysql_fetch_assoc($result) ) { if ( $row['cards'] !== '' ) { $cards = explode(',',$row['cards']); if ( $type === 'worth' ) { $collecting = $collecting + count($cards) * $row['worth']; } else { $collecting = $collecting + count($cards); } } } $total = $total + $collecting; // Count mastered $result = $database->query("SELECT `cards`,`worth` FROM `collecting` WHERE `tcg`='$tcgid' AND `mastered`='1'"); while ( $row = mysql_fetch_assoc($result) ) { if ( $row['cards'] !== '' ) { $cards = explode(',',$row['cards']); if ( $type === 'worth' ) { $mastered = $mastered + count($cards) * $row['worth']; } else { $mastered = $mastered + count($cards); } } } $total = $total + $mastered; // Count pending $result = $database->query("SELECT `giving`,`givingcat` FROM `trades` WHERE `tcg`='$tcgid'"); while ( $row = mysql_fetch_assoc($result) ) { if ( $row['giving'] !== '' ) { $cardgroups = explode(';',$row['giving']); $cardcats = explode(',',$row['givingcat']); array_walk($cardcats, 'trim_value'); $i = 0; foreach ( $cardgroups as $group ) { $group = explode(',',$group); array_walk($group, 'trim_value'); if ( $cardcats[$i] === 'collecting' ) { $exists = $database->num_rows("SELECT `worth` FROM `collecting` WHERE `tcg`='$tcgid' AND `mastered`='0' AND `deck` LIKE '%".$group[0]."%'"); if ( $exists > 0 ) { $groupworth = $database->get_assoc("SELECT `worth` FROM `collecting` WHERE `tcg`='$tcgid' AND `mastered`='0' AND `deck` LIKE '%".$group[0]."%' LIMIT 1"); if ( $type === 'worth' ) { $pending = $pending + count($group) * $groupworth['worth']; } else { $pending = $pending + count($group); } } else { $pending = $pending + count($group); } } else { $groupworth = $database->get_assoc("SELECT `worth` FROM `cards` WHERE `tcg`='$tcgid' AND `category`='".$cardcats[$i]."'"); if ( $type === 'worth' ) { $pending = $pending + count($group) * $groupworth['worth']; } else { $pending = $pending + count($group); } } $i++; } } } $total = $total + $pending; if ( $cat === '' ) { return $total; } else { return $$cat; } }

[kuranosuke]

Oh thank god. It seems something had gone wrong and it works now! Thank you so much ;u;

[adurotum]

Oh yay, I'm glad it works now! And no problem.