User talk:Dinoguy1000/Archive/2013/03

Template error

At File:GogogoGolem-DL15-EN-R-UE-Blue.png, I tried adding in the OCG-TCG card image template, but then I got something wonky. Is it because of the last word "Blue" in the title? In any case, I could appreciate if you could point out what I did wrong and/or fix the relevant problems. --UltimateKuriboh (talk • contribs) 16:53, March 1, 2013 (UTC)

System glitch, it happened from time to time. --iFredCat 17:10, March 1, 2013 (UTC)

The wonky formatting from before is because {{Set/DL15}} didn't exist yet; I created it. The template still shows that the file is misnamed, though, because I never got around to properly and fully supporting "extra" tags in the filename (such as the "Blue" used here); you can ignore the misnamed notice since it's not correct. I'll eventually (hopefully in the near future, but we'll have to see) be completely rewriting that template from the ground up, at which time I'll do a better job of having it support the extra tags. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 08:18, March 2, 2013 (UTC)

Kank

Yo Dino, Kankurou asked me to ask you if you could go on Neo Ark Cradle and respond to his PM (he's having problems with editing/posting on talk pages here). TheScarecrow14 (talk • contribs) 19:09, March 3, 2013 (UTC)

Yeah, I'll have a look. I've got a houseguest for a week or so, so I'm already behind on stuff and will end up further behind, otherwise there's every possibility I'd've already taken care of it. Thanks for the heads-up! 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 21:56, March 3, 2013 (UTC)

Chat

Get in the chat now plox, we have questions for you =3. --UltimateKuriboh (talk • contribs) 18:05, March 14, 2013 (UTC)

Side Project

Hey Dinoguy, wanted to see if you wouldn't mind taking a look at my little project I've been working on. It's pretty much working, a few issues to fix here and there. But basically I built a giant Yu-Gi-Oh! checklist system for TCG and OCG. I finally got to a point where I needed some way to keep track of my collection and I couldn't find a good checklist anywhere that was complete or up to date. So I built one. TGCDT
I'm still tinkering with it quite a bit, so some parts may work some may not. -.- But yeah its searchable by card name, set name, and set abb. You can filter the results by the tab buttons, and the side menu lets you work on your collection, your trade list, or your wish list. Still working on decks. And if you double click on the card name it will send you to the wikia. I still need to add the rest of the European sets, and quite a few more names but all the English, Japanese, and Korean sets are in it at the moment. Let me know what you think or if it something breaks on you. This thing is still in beta so expect alot of bugs. ^_^ Look234 (talk • contribs) 02:07, March 15, 2013 (UTC)

Haha, forgot that I haven't fixed the Spell and Trap Type alignment yet. :P Ignore that bit for now... Look234 (talk • contribs) 02:17, March 15, 2013 (UTC)

My very first thought is "how are you storing passwords"? I see a few problems there immediately:

• An account's password is generated by the system; it only generates a four-digit password (or that's all it did for my account).
• This password is transmitted in plaintext via email, but the user is not asked to change it on first login (!!!). This suggests the password is stored in plaintext. A better method (even better than simply asking the user to change their password after first login) would be to generate a random URL that gets emailed to the user that, when clicked, confirms their account, logs them in, and asks them to choose a password.
• There doesn't seem to be any way to change or reset an account's password (never offer to recover passwords, because if you're storing them properly, that's impossible ;) ).

The ideal method to store passwords is with bcrypt - be sure to use a standard library rather than trying to roll your own code; that's just asking for trouble. =)

I suppose now I should actually dig into the functionality proper, shouldn't I? XD 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 02:21, March 15, 2013 (UTC)

Yep the account creation system was implemented only a little while ago, the passwords are stored in a md5 hash, its not much but for now to avoid them being just plain text. And I need to add the form to change the users passwords as well as the avatar image. Working on a lot of filtering for image uploading protection right now. But yeah about 95% of this thing has been made from scratch, I'll look into the bcrypt though! Look234 (talk • contribs) 02:27, March 15, 2013 (UTC)

Cool, there's a lot of info out there on doing passwords properly so you shouldn't have too much trouble finding help. =)

A more immediate concern, though, is that I can't figure out how to get my collection to "stick" - if I add a card to my collection by pressing the + button between the set number and card name to expand its info and then pressing the + button to the right of the count field, I can press the - button between the set number and card name to re-collapse the info and the row turns green, but the info doesn't seem to be saved: my "My English Collection" number doesn't increase, and navigating away and then back makes the rows turn back to their normal color and the numbers to reset. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 02:30, March 15, 2013 (UTC)

Haha that's not good, may I ask what browser you are using? So far it works in the latest version of Chrome and Firefox on Windows 7 and I think my friend is using Firefox on Mac. Does the blue bar say Currently Working on My English Collection when your trying to add to it? Look234 (talk • contribs) 02:41, March 15, 2013 (UTC)

I'm using Chrome dev, and yeah it does: "Currently Working on My English Collection filtered by : DIVINE, 12 results". =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 02:44, March 15, 2013 (UTC)

Hmm, just created an account and it seems to work. If it wouldn't be trouble see if you can edit your tradelist or wishlist. If they work I think I know whats up. Look234 (talk • contribs) 02:47, March 15, 2013 (UTC)

Wishlist doesn't work either; I was getting ready to try the tradelist but the website seems to have gone down. =C 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 02:57, March 15, 2013 (UTC)

Yeah it did that on my end for a sec, mkay I'm going to throw together a quick java script alert to show what should be being sent through and what is. One sec. And thanks again for helping me with this! ^_^ Look234 (talk • contribs) 03:02, March 15, 2013 (UTC)

No prob. =) Just a heads-up, though, I use ScriptSafe, which doesn't work 100% properly in the most recent versions of Chrome dev (mostly display-related, and according to what I've found, other extensions are affected as well), so that could have something to do with the issue too. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 03:04, March 15, 2013 (UTC)

Resetting indent, that may be something, the data is grabbed and sent through a JS/JQuery combo. Mkay try refreshing and now when you add a card it should have a pop up telling you whats going through. if the Value and ID are blank then its not grabbing the data and its a JS/JQuery issue, if it shows up then its a php issue. >.< Look234 (talk • contribs) 03:14, March 15, 2013 (UTC)

I've disabled ScriptSafe (did that by accident while blindly clicking to get an info page) and refreshed, the popup appears with information when I do stuff, but nothing gets updated. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 03:20, March 15, 2013 (UTC)

Alright, took out the $_SESSION data bit on the php file, its now hard coded to your English checklist right now. See if that does anything, if not then I need to dig a little deeper... Look234 (talk • contribs) 03:27, March 15, 2013 (UTC)

If that doesn't work the most I can figure is something on your end doesn't like my update collection script. The flow is the user clicks on the + button to add a card which calls a jQuery function which sends the data that you see in the pop up to the update script. The script then uses the $_SESSION data to work on the correct file, it opens the file which is stored in JSON format and turns it into an array. It checks to see if the array exists, had an early bug without this where it erased my collection -_-, and if it exists then checks to see if that version is already there if the update the amount if not the add the version and the amount. If you can think of anything in this that might be where its getting caught let me know. Most I can think is something on your side doesn't like the call to the the update script or if it makes it that far then it has a problem with opening the file and writing to it. I'm change the update script to send a conformation message if it makes it that far. AS I said before thank you very much for this. ^_^ Look234 (talk • contribs) 03:43, March 15, 2013 (UTC)

Haha so much text, I added an alert that should tell you whether the jQuery .post() succeeds or not. Slowly I will narrow this thing down. >.< Look234 (talk • contribs) 03:51, March 15, 2013 (UTC)

Sorry about the silence, got sidetracked for a while...

Still not working, but I did get all three alerts (success, second success, and finished). I finally thought to check the data inspector: the error console is reporting two "Uncaught ReferenceError: checkValue is not defined" errors. Let me know if you need more info. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 03:52, March 15, 2013 (UTC)

No worries, okay took out the checkValue(), it was a remnant from a previous version for checking the divs, it didn't actually have a function anymore but that might be part of it. And I think something went through from your end I checked the file and it says that your collection has 1 JUMP-EN061. Not sure if that was you or me fiddling but if your collection in the corner isn't updated then there is still a problem. Look234 (talk • contribs) 04:01, March 15, 2013 (UTC)

Refreshed and trying again; the errors are gone. UI still isn't updating though, and my collection shows as empty.

A couple other notes: the console shows that there's an image resource that's 500 Internal Server Error'ing out (http://ygo.tgcdt.com/images/ui-bg_flat_75_ffffff_40x100.png), and it has a couple warnings that the Twitter widget being used is deprecated and will stop functioning soon. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 04:09, March 15, 2013 (UTC)

Okay got rid of those errors the console should be clean now. And the success alert now returns if the php function actually makes it or if not where it gets stuck with hopefully a somewhat specific message. Man sorry about this, this was supposed to be more like "Hey look at this thing I made!" not dive into the internal structure. Look234 (talk • contribs) 04:23, March 15, 2013 (UTC)

Yep, error console's clear. =)

All alerts return fine, but the UI still isn't updating other than the card row bg turning green. I tried adding 1 JUMP-EN037. I'm starting to think this is a problem on my end, rather than a bug in the site coding. =/

Don't worry about it, I find this kind of stuff interesting so it's not a big deal. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 04:35, March 15, 2013 (UTC)

Glad its not too much of a bother ^_^, and again it looks like something might have come through. For giggles try adding 5 more JUMP-EN037, I'll see if it shows up here. If it does than its an issue reading the file with your data, if this works than I think I know what to do to fix it. ^o^ Look234 (talk • contribs) 04:42, March 15, 2013 (UTC)

Added (I'd love to actually have 6 of that, but alas...). Once again, all dialogs popped up with expected/normal info, but no UI changes. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 04:57, March 15, 2013 (UTC)

Resetting indent, BAM! It showed up! ^o^ So its an issue with the $_SESSION variable, just need to put the needed $_SESSION variables in a hidden variable, rip it with some jQuery and pass it through. Let see if I can do that really quick. Also yeah I would love six copies as well, but hey at least its been reprinted twice. Look234 (talk • contribs) 05:02, March 15, 2013 (UTC)

Kk, just let me know when to refresh and retry stuff then. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 05:03, March 15, 2013 (UTC)

Mkay try refreshing, for now just to prove to myself that this is the issue I hard coded the other calls. If this works you should see your collection count updated and JUMP-EN037 highlighted and the increment buttons should hopefully work. There might be a slight delay on the collection count going up, right now it has a 5 second delay, I think, for rechecking. Look234 (talk • contribs) 05:09, March 15, 2013 (UTC)

Ooh, I got UI updates even before refreshing! (I refreshed anyways by reflex) Everything looks like it's working now; I'll try some other stuff. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 05:14, March 15, 2013 (UTC)

Awesome, for now its hard coded to your English Collection, it will stay like that till I add in the fix for the $_SESSION problem. But you can still hop over to the other languages by clicking on the abb under the search form. ^_^ Look234 (talk • contribs) 05:17, March 15, 2013 (UTC)

Awesome, I've already got a few sets entered in; this is a lot of fun (certainly a lot more than writing out lists for new sets ^^ ). =)

So, a feature suggestion or six ( XD ):

• A built-in per-set listing feature, instead of requiring to search by part of the set number.
• Branching off of that, some method to quickly view the gaps in your collection for a given set (maybe filterable by edition?).
• Viewing others' collections (I'm guessing this is planned, but it doesn't hurt to explicitly request it, right? =) ). Users should be able to disable their collections being publically viewable, and I'm not sure what the default should be, but if visibility defaults to public (or open, or whatever you choose to call it) that needs to be shown to the user up-front so they can change it if they want.
• Some way to submit corrections, in the off-chance a user comes across a piece of information that's incorrect.
• A distinction between Magic and Spell prints of cards where that's the only difference between the prints (IIRC, there're cards like this in LOB and MRD), though the user should probably have an option to ignore this difference if they want. (I have a feeling this one'll require some research to find what cards would actually be affected by this, which is where the previous suggestion comes into play ;) )
• An import/export feature.

I'm sure I'll think of other things as I go. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 05:39, March 15, 2013 (UTC)

Haha, I swear just about all those things you listed are on my to-do list on my whiteboard. :D

• I'm working on another tab for sets, instead of the buttons it will put the data in the iframe and list all the sets and their abbreviations along with the count for the how many of that edition you have / the total number. When you double click on the set name it would pull it up in the current list you were working in. I already have the set lists going, they are automatically generated so I don't have to update them. XD Just need to add the counts and the links.
• I did have a filter by edition before I changed the structure, I can add it back in. ^_^
• Yeah this is a big thing I'm working on, I'm trying to design a smart way to do this so you can also give people a link to your collection. I'm adding a search for user bit on the home page or user page, haven't decided yet. And I'll add a kind of friend bit so you can see your friends collections as well.
• Yeah I know I probably have quite a few errors in the other language names, some I had to just Google translate because nobody had it. -_- But yeah I'm setting up an email account just for this or a file that lists and dates it the errors. I'll add a link on the Menu for this.
• Didn't think about that, but I should be able to set up something. Right now all the constant card data is stored in a MySQL table with their number as a primary key so I don't get duplicates. So I'll need to create an exception somewhere.
• On the export any suggestions on what formats to export as? The import is a different story if it is based of an export from this site then it should be okay but if its something like the old Pojo excel sheet then I think for now I'll hold off unless there are enough people out there that want it. ^_^

Yeah I still have a ways to go I've spent alot of time just gathering the raw data for this thing. T-T That's been rough, but it's getting there. Any other sugestions are very much so welcomed. And just a side note I'm also working with a friend on a Pokemon version as well, he is getting the data for that one while I work on the infrastructure, so I hop between the two. So if you don't see any updates on the Yu-Gi-Oh one for a bit I've just hopped over there for a while. But yeah I'll be working on those things on the lists and many more, I'll fix the password jazz first though. -.- But yeah to keep your talk page from getting too swamped I'll post updates I do to the database on the site's homepage. Thanks again for your help and I hope you like it, after it moves along a bit more I'll throw it out to some other people. ^_^ Look234 (talk • contribs) 06:15, March 15, 2013 (UTC)

Great minds think alike? =D

• Awesome, can't wait to see it. =)
• Cool.
• OIC.
• May want to take the time to set up a page that lists submitted corrections, so people can see what's known. From there, it wouldn't be too much work (famous last words =D ) to configure it so accounts with admin or editor or whatever privileges could review and accept/modify/reject submitted fixes.
• Whatever you do, it'd probably be best to try and make it generic so you can use it for other stuff too; differences can pop up in the most unexpected places after all. ;)
• Not sure, since I don't normally utilize import/export functionality in stuff, though I think having some feature whereby a user could select specific things to import/export may be a good idea, at least in the long term.

I saw the PKMN version, and noticed that logins work across both of them; unified logins are a definite plus. =) Also interested in seeing what other card games you eventually expand this to; if you do it right you could end up with a backend that makes adding new games fairly easy. Don't worry too much about my talk page, either; recently it's been pretty inactive anyways. XD (and don't forget to get the $_SESSION fix in place before sharing with more people, I'd rather not have my collection become everybody's collection! XD ) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 06:25, March 15, 2013 (UTC)

Found one omission already, BTW: the Ultra Rare JMP-EN005 Blue-Eyes Ultimate Dragon from Ultimate Edition 1. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 06:40, March 15, 2013 (UTC)

Haha no worries your collection is safe, I've shut down the account creation till I get it fixed and my friend just does Pokemon so no worries there. And that card is in there. I think it's just having trouble due to the fact that it was printed in two different sets with two different rarities but the same set number. Nice catch!

I thought unified logins would be nice, you will also be able to have a different avatar for the different games. And that's the plan, to eventually get the shell built and any game can be added, just takes time to get all the data. XP

• For the error page yeah, I think I'll go that direction and keep a log that shows what needs to be done and what's been done. Hopefully it shouldn't be to bad to set up.
• Yeah the worst so far has been Mecha Phantom Beast Token, freaking thing broke a bunch of rules. -_- Yu-Gi-Oh has to be the kindest so far, Pokemon has been brutal and we haven't even started on the Japanese cards yet. Doing this has made me appreciate our wiki, Pokemon is very lacking in their card list department.
• The import/export bit I'll save for later when I can get some more suggestions for types and see what kind of demand there is.

I'll keep you up to date then on changes, I will forewarn you that they will probably be infrequent. I hop from the infrastructure to data gather on both sites. But I should have the $_SESSION bit fixed soon and have the password bit encrypted and changeable. I'll try to catch you here when I have a fix for the $_SESSION bit going so you can see if it works on your side. I'm going to crash for now, been up a while. -.- But I'll probably have that stuff fixed sometime tomorrow. ^_^ Look234 (talk • contribs) 06:49, March 15, 2013 (UTC)

Cool, cool. =) And I wouldn't have caught it if I didn't have a copy (actually two!) of it (too bad I don't have a copy of the JUMP promo, I'd love an ScR version of it decorating my binder...). ;)

Maybe have an indicator showing what games a user has a collection for, then, with links to go straight there? (once again, with appropriate privacy controls)

Cool, keep me posted. Also, I'm not making any promises, but I may be willing to go through some corrections from time to time if I'm able (hint hint). ;)

BREAK ALL THE RULES! I dunno what your plans are after you get the PKMN stuff to a state you're comfortable leaving it at, but I'd personally suggest that you pursue a game as different from PKMN/YGO as you can find, since that'll force you to confront all the little assumptions you've made and that PKMN and YGO were similar enough to allow you to get away with to that point. ;)

That's fine, it's in your roadmap at least. =)

Cool, cool. You should feel free to contact me however you like, too - on-wiki, via email, or via Skype (my Skype name is phillip.patriakeas). =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 07:09, March 15, 2013 (UTC)

Not sure what happened, but it's showing me as having 0 cards in my collection again. =O 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 07:34, March 15, 2013 (UTC)

I thought I might have found the culprit, see if logging out and logging back in does anything. If it still says 0 let me know and I'll switch it back. ^_^ Look234 (talk • contribs) 07:44, March 15, 2013 (UTC)

Nope, still shows as 0. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 07:52, March 15, 2013 (UTC)

Mkay switched back, I'll will try the other ideas later. ^_^ Look234 (talk • contribs) 07:55, March 15, 2013 (UTC)

Kk, my collection's back, now go to bed. ;) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 08:00, March 15, 2013 (UTC)

New day, new section

Resetting indent, Mkay ready for error testing, first try loggin out and logging back in and the go to SESSION test and let me know what shows up. It should show the current $_SESSION data stored on you side that I need, as far as I can tell you do have some $_SESSION data due to the fact that your username shows up in the top right corner. But for some reason its not going through to the other pages, because the only difference between whats going on now with it now hard coded and before is inserting your username and the other data via $_SESSION into a string to call the right file. Also I put back the pop up it should return what $_SESSION data is present when you try adding a card. One more thing to check is see if when you got to your user page it says "Hello Dinoguy1000 and welcome to your page!" Hopefully from what you get from those tests I can narrow this thing down. Because the only idea I have at thing point is your side isn't storing the $_SESSION data, or if it is there is trouble either getting it on another page or just plain reading the data. Thanks again! ^_^Look234 (talk • contribs) 19:01, March 15, 2013 (UTC)

SESSION variables are as follows:

SESSION Variables
ndiapbgeleubepjgk9dfn1f674
dinoguy1000
checklist
EN
yes

Viewing my page shows "Hello dinoguy1000 and welcome to your page! -_-' Still working on it...".

Okay, I have been logging in using the username "dinoguy1000" up to now (with a lowercased "d"), but I just tried logging in with "Dinoguy1000" (with an uppercase "D" instead; this is the form I registered with) and now when I view my home page, I get a nice pie chart that wasn't there before. It sounds, then, like you're not properly canonicalizing user names (or whatever you'd like to call it); how much you wanna bet that's the problem?

And another bug report: there's a discrepancy in the count between what's shown in the upper-right corner under my name and what's shown when I view my collection; the upper-right count is "1068 (1938) / 23620", but the collection count is "968 results". I hope there's not cards getting lost in the shuffle somewhere? =/

And one last thought: I'm not sure how you're storing and handling cards internally currently, but it'd probably be best over the long-term to do so with an internal ID that doesn't necessarily have anything to do with any of the card's info, since that way you can guarantee 100% that you won't have to worry about card collisions where two (or more! =O ) cards end up with the same ID/key/whatever. 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 21:21, March 15, 2013 (UTC)

Oh, I probably oughta post my SESSION data when logged in as "Dinoguy1000", too:

SESSION Variables
ndiapbgeleubepjgk9dfn1f674
Dinoguy1000
checklist
EN
yes

「ディノ奴千？！」^{? · ☎ Dinoguy1000} 21:23, March 15, 2013 (UTC)

Man if it is the upper/lower case thing I'm going to kick myself. T-T Mkay try it now with upper case Dinoguy1000, if its working you should see your collection and be able to add cards. And the count is just off on the results, its counting the number of divs not the number of versions inside the divs. Need to fix that. But yeah the number in the corner is No. of different versions you have (Total amount of cards you have) / Total number of different versions, and by versions I mean every printed version so each edition and each rarity of that edition. Look234 (talk • contribs) 22:16, March 15, 2013 (UTC)

My count's still there, my collection's still there, and adding new cards works. Should I retry logged in as dinoguy1000? 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 22:24, March 15, 2013 (UTC)

Sorry vanished there, had to take some calls. But yeah looks like you were right the usernames were being stored in case insensitive, so that should be fixed now. ^_^ And yeah see if it still lets you log in with dinoguy1000, if it doesn't than the problem should be solved. It's always the little things you never think about. -.- And I've thought about taking of the primary key status for the sql table the cards are stored in, that would allow me to differentiate between say SPELL and MAGIC types. And I'll get working on the password bit and fixing the result count. ^_^ Look234 (talk • contribs) 00:12, March 16, 2013 (UTC)

The count should be fixed now! Look234 (talk • contribs) 00:19, March 16, 2013 (UTC)

Not a problem, that's more important than this (at least, I'd hope). =)

Trying to log in as dinoguy1000 just shows the login form again. That'll work for now, but the ideal solution would be for login to ignore case, but for everything else to use the casing the user specified on signup - if you handle users via ID instead of via username, this should be much simpler (notice a theme here? handle everything via IDs instead of names/other identifiers, and it clears up a lot of issues ;) ).

Count is fixed, thanks for your attention. =)

Another feature request: being able to add/remove cards to your collection without having to click the + next to each card to expand the actual count portion; that gets pretty tedious if you're adding a bunch of cards in one shot (though I'm not sure how the presentation would work for that). 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 00:35, March 16, 2013 (UTC)

I see what your saying with the ID, that shouldn't be too hard to set up. No trouble on the count. ^_^ And for the +/expand button, I built a button earlier that opens all the divs, but it has trouble when the amount of results returned gets > 2000. But I can set it up again, or I could set the divs to always be open, I just did the show hide bit to simplify the shown data. Let me know! Look234 (talk • contribs) 00:45, March 16, 2013 (UTC)

It would probably be better to start paginating results past a certain number, maybe 500 or so (that should be plenty big enough for any set that'll ever see the light of day), though that means sorting won't work completely properly for lists bigger than that... hmm. Tradeoffs, tradeoffs... 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 00:49, March 16, 2013 (UTC)

Updates

Hey, the sets tab is now working, its not been beautified yet but it works. Click on the set name to bring up cards in the set. It also lists the amount in each edition and the count in bold that you have. Should work for all the languages, the European languages are incomplete at the moment. I still need to add in the rest of the sets. Also the Ultra Rare JMP-EN005 Blue-Eyes Ultimate Dragon error was fixed so he is showing up now. ^_^ User's data is now stored using ID numbers, so there should be no trouble there now. Passwords are now encrypted and changable. Check the email you gave me for a message from Luffy. I'll change the create an account bit so it makes the user pick their password when they first create their account. Still working on the viewing other users collection jazz, little harder to pull off that I previously thought. -.- Trying to come up with a way to give people a link to see your collection/tradelist/wishlist. But it's still on the top of my to-do list. I'm also working on an upload form for user's avatar images. I'll add the Edition filters in later along with the ATK and DEF filters. So much to do. >_< Look234 (talk • contribs) 08:35, March 19, 2013 (UTC)

Email received, and password changed. And on that note, some more bugs:

• If you enter anything into the username or password fields before the page is finished loading, when it does finish, anything entered gets blanked.
• I wasn't able to log in with "dinoguy1000"; it drops me at this blank page.
• Searching by set number seems to be broken; searching for "lob", for example, only returns Mad Lobster and Metabo Globster.
• Adding cards still produces the debug dialog popups; you'll probably want to remove those now. =)

And now for some feature/enhancement requests/suggestions:

• The sets tab should only list the sets you have cards from, with an option to list all sets in the system (for the given language). Alternately, make this change depending on whether you've clicked "View my collection" or "Edit my collection": the former should hide sets you don't have cards from by default, and the latter should show them.
• The sets tab should display the total number of copies of cards you have in a given set, as well as the number of different prints of a given edition, probably the simplest way to display this would be in parentheses to mirror the display in the upper-right corner: "Prints (Copies) / Total prints". For that matter, maybe ditch the parentheses surrounding the count as a whole in favor of colons+semicolons or pipes or something: "1st: count; Unlimited: count" or "1st: count | Unlimited: count" or the like.
• Currently, the row styling for "owned" cards is applied dynamically (whether by the addition of a class name or inline CSS; I'm not sure which since I haven't looked (not that it really matters ^_^ )); it would speed up page load and render times some (especially for queries that return several hundred cards or more (lol big collections)) to just apply a class server-side and style the "owned" rows via a CSS stylesheet. You'll still have to rely on Javascript to update the styles as users edit their collection, but this change would make loading itself much snappier.
• For that matter, the "owned" styling doesn't get applied (or removed) until the row is collapsed or the list is reloaded; having it apply when the button is clicked would be a good visual indicator that the click registered.

That's all I can think of/have noticed for now, so one last question: surely you've peeked at my collection while working on this, so any thoughts? Keep in mind it's not complete yet; I still have four three-inch binders crammed full of boosters and one with Starters and Structures to go through (what's in there is my other Starter/Structure binder, my promos/misc binder, and almost everything that isn't bindered yet). =D 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 09:13, March 19, 2013 (UTC)

Hehe, more updates

Huzzah for sporadic updates! First got the basic principles working for viewing other peoples collections, at least the giving them a link part. See if it works look234. Its not pretty by any means yet, but it works for other people being able to view your page even if they don't have an account. I'm going to add a bar like when searching, that blue bit with the sort buttons, that will have a link to their collection/tradelist/wishlist and allow the person to view said list if the owner gives permission. Still need to add permissions. -.- But the main user page will contain basic stats on their collection. If you have some ideas of what should be displayed let me know, I'm just making this up as I go. ^_^ As for errors/bugs,

• Fixed the set abbreviation search problem.
• Think I managed to fix the erasing log in problem. Let me know if it still happens on your side.
• Removed the test pop ups.
• Should be able to log in using case insensitive username.

For the feature/enhancement:

• The set list tab now will only show sets you have if viewing your collection. I'll add in a bit later that will highlight the set if you have all the cards in it for ease of viewing.
• Still playing with the formatting on the counts. For now they are changed to match the top corner count style. "Prints (Copies) / Total prints"
• And I think I got all the styling fixed, automatic color change and set CSS style for card, no more post load change. ^_^

And your collection is pretty sweet as far as I've seen. o.O Once you add in the other binders I'm sure you will have me beat count wise and card wise. I'm about half way done entering in mine I think. Just curious how do you collect? I started by getting leftover cards from friends and then gave that early collection away. Then started back up with SD1/SD2 and very slowly bought old collections on ebay. Only recently, like Return of the Duelist recently, did I have money to grab a box of each new main set. So my collection is very hit a miss, I haven't started to fill in the gaps quite yet. But I'm interested in how you collect. ^_^ Look234 (talk • contribs) 22:58, March 22, 2013 (UTC)

Yep, I can view your page just fine, and a bit of math based on the number of Commons and the percentage of your entered collection that they comprise suggests you've entered about 3950 cards so far (I got 3948 and a decimal). XD

As for more info... hmm. This is something I've been thinking about since I realized you were already showing a breakdown-by-rarity on an account's "My Page" page, but I seem to be just about as short of ideas as you. Perhaps providing a numerical table of the rarity breakdown to accompany the graph, which includes a "total" row? And maybe some statistics on languages and sets, too (for that matter, does the "My Page" page currently account for all languages you have marked as owning cards in? seems like it'd be an easy thing to overlook just having it look at your English collection)... Other than that, maybe some general high-level account info, like date joined, and maybe allow users to specify their location?

• Search by set does seem to work again, and you also seem to have changed the default sort order to set number - that was another thing bugging me before, but I never thought to mention it. =)
• Still happening for me. Also, I didn't check with this latest update, but I know after the last one, I wasn't able to log into the PKMN database at all - not with my original password, or the reset one, or the one I've changed it to, and not with either capitalization of my username. More generally, having a unified login across the databases would be good, so that it would log you in on all of them if you log in on one (not sure if I've already said this one ^^ ).
• Speaking of, case-insensitive username login works now, though it looks like you're still not handling it quite right (my username as displayed depends on how I log in: if I log in with "dinoguy1000", it is displayed in lowercase, but if I use "Dinoguy1000", that's how it's displayed): if usernames are supposed to be case-insensitive, then you should be using the user IDs internally everywhere, and thus displaying a user's username becomes a lookup; this lets a user specify a preferred capitalization on registration and then log in without having to worry about matching the capitalization, but still have the interface reflect it (not as important to you or me, but there are definitely people out there who have such a preference).
• And one more login-related bug: logging out now does not properly update the interface; my collection count is removed, but I am still shown as being logged in until I reload the entire page (simply clicking a link in the left navigation menu doesn't cause an update).
• Cool, the sets display all looks good so far. =)
• Awesome, loading seems much smoother now. =)

I started back probably shortly after it was released in the US (maybe in 2003?), my friend had a sizeable collection and he gave me a bunch of Common dupes he had; I still have most of them today. Since then, most of my collection growing has consisted of buying random stuff from the local Walmart when I've had spare money, which isn't too often unfortunately (though I got lots of Force of the Breaker while I was working, so it's one of the most complete main-series boosters in my collection), though I have also gotten a few other peoples' collections (including a pretty sizeable one from a friend who moved a couple states over; that's the one a lot of my promos came from). 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 00:02, March 23, 2013 (UTC)

Very close, according to my count I have 3955 entered so far. Haha you are right I still had a call to username instead of the ID. That should be fixed now. The Pokemon log in problem might be that I haven't updated the code on that side yet. I will check.

• Hmm, the log in erasing fix worked fine here. I'll double check though. ^_^
• I get a slight linger of my username and title but it refreshes in a few seconds to the log in. Let me know if after say 4 sec if it doesn't change.

The user page is a big work in progress. And the rarity chart is hard coded to the English collection for now. I'm designing a layout for it right now. Hopefully it will allow for the user to give a description of themselves, show their avatar, have stats on each of their language collections, and when another user views their page have buttons to switch between the languages they have cards in while updating the displayed stats accordingly. Once I have the user page cleaned up a bit and the set list tab then I'll open up the account creation again and see if anyone else would want to try this thing out. ^_^

I remember when I was given peoples common cards, I loved it. ^_^ I really didn't have any spending money till college so whatever someone offered I would grab. And at the moment I'm in between jobs so I wont be adding to my collection anytime soon. -.- Hopefully this database thing makes it easier to keep track of what cards you have though. That was what made me build this in the first place. :P Look234 (talk • contribs) 00:34, March 23, 2013 (UTC)

Cool, looks like the username capitalization is now working properly across the board. =) Logout also works as you described, but it would probably be better to have it force a full page reload, especially since it drops the person back on the home page anyways. And I just checked again, and it still clears the username/pw boxes if they have content before everything's finished loading, though now it takes a couple seconds after the loading finishes for it to happen.

Yeah, free swag is always awesome, that's how I got a decent chunk of my collection. XD

As for what I mentioned above (way, way above) about the Magic versus Spell thing, see User:Dinoguy1000/Magic vs. Spell; I finally got around to documenting it based on my collection. I haven't looked at any boosters yet (I think, in particular, that LOB does this), but I've done all I can with the Yugi, Kaiba, Joey, and Pegasus Starter Decks (though I won't promise I didn't manage to overlook a card somewhere ;) ). Note that this only covers North American English prints; that's all I have (I do have a bunch of Worldwide English LOB and MRD and European English MRD cards, but I'm not near those sets yet). In addition to what's listed there, if you edit the page you'll see I've listed in comments every card in my collection that mentions Magic or Spell Cards, even if I only had the Magic Card version (the comments after the uncommented cards, that read e.g. 1m1s are just counts for me to use after you get this added to the DB so I don't have to dig back through my collection to update my DB as needed =) ). 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 02:26, March 23, 2013 (UTC)

Also, just found another missing card: YSD-ENS01 Elemental HERO Sparkman (UR) from Starter Deck 2006: Special Edition Promos (interestingly enough, it's also missing from Konami's card database). 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 06:22, March 23, 2013 (UTC)

Got it! And did a check again and also found I forgot the RP02-EN099 Limited Edition Green Baboon, Defender of the Forest from the US version blister as well. And I'm working on the Spell/Magic difference I need to change the way the cards are referenced in the tables to the way I do it in the Pokemon one. It will reference the raw card data based on the set number instead of the card number. This allows for me to add in other versions, like Spell/Magic, name changes i.e. Harpie's Brother to Sky Scout, misprint cards like SDRL-EN0010, and to add cards the we don't have card numbers for yet. So all around win win. It will take a little while to do but I will let you know when its changed, you won't see any changes till I activate it so the site should work as normal till then. Keep that list though I will need to use it when I work on it. And yeah that log in erase thing is a pain, I have another idea to fix it so I'll set that up in a bit. ^-^ Look234 (talk • contribs) 03:45, March 24, 2013 (UTC)

Also the new design made me realize that I needed to redo the early Japanese set numbering, the way it is right now if you checked off one it would check off all of them from that same set...errors, errors everywhere. -.- Look234 (talk • contribs) 05:50, March 24, 2013 (UTC)

As I suggested before, probably the best method in the long run would be to assign each card an internal ID number, completely separate from any set number or other identifier used in the game proper; this would give you the most flexibility in the future. ;) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 07:03, March 24, 2013 (UTC)

Re: Sussano

I'm sure I read it was the last Xyz on Neo Ark Cradle (or maybe when Ark listed the anime Xyzs, there was 1 slot left which lead me to assume it'd be in that slot?). If not, I must have been mistaken. TheScarecrow14 (talk • contribs) 00:49, March 16, 2013 (UTC)

Re: FB Page

Hello! Glad to have you volunteer for Facebook! UK is currently an admin for the page and should be able to make you a Facebook manager as long as you "like" the page. Let me know if you guys experience any issues and I'll take a look, thanks :)

Grace<staff /> 00:55, March 16, 2013 (UTC)

SMW Properties

Hey there. Just wondering, do cards have a SMW Property set for which TCG card sets they are released in, meaning I could query for all cards released in X set? AEtherchild (Talk|Contribs) 00:25, March 18, 2013 (UTC)

Not currently, though that's something we hope to address in the near future. =) 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 00:29, March 18, 2013 (UTC)

Nice stuff! Guess I'll manually check the set pages until then. Thanks :) AEtherchild (Talk|Contribs) 00:34, March 18, 2013 (UTC)

Interwiki linking

So, after I saw the fact that the Croatian language wiki was shut down, the only thing is to remove the interwiki links (one example is this article on the bottom. Since it is a part of the template, can you just remove them? Energy X ∞ 18:13, March 25, 2013 (UTC)

Done, can't believe I forgot that. =X 「ディノ奴千？！」^{? · ☎ Dinoguy1000} 20:17, March 25, 2013 (UTC)