Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Say if I have a Bengal type tiger and a Bengal type cat. It shows there's one. Because they're both Bengal. It disregards the subtype "tiger" and "cat"
I derped, lol. I didn't realize you removed the fetch unique pdo. Thanks so much, it does work, I tested it by changing around types and subtypes |
#12
|
||||
|
||||
Quote:
There was also the option to add a CONCAT if it didn't work, so it would be okay xD Glad it worked out in the end! And yeah, the GROUP BY makes groups by the combination of those two columns, merging the two columns, so there was no need for fetch_unique this time!
__________________
asp.net stole my soul. |
#13
|
|||
|
|||
I'll make sure to remember that. Thanks a bunch!
|
#14
|
|||
|
|||
Welp, I noticed that the shop and pound only takes from the type, not the subtype (Also the owner reward too, from my last post). If I have a Bengal Cat and a Bengal Tiger (Both of which cost different amounts), it costs the same amount to pound it and it only gives the owner the same reward as the Bengal Cat, I'm assuming because it was made first. Any idea where I'd go to change that around?
Last edited by Chaos77777; 01-21-2017 at 06:20 PM. |
#15
|
|||
|
|||
Freakin A! I got it! Before I go on though I want a more expert opinion.
In class_stockadopt I changed $row = $mysidia->db->select("adoptables", array(), "type ='{$adopttype}'")->fetchObject(); to $row = $mysidia->db->select("adoptables", array(), "id ='{$adopttype}'")->fetchObject(); And in class_adoptshop I changed foreach($this->adopts as $stockadopt){ $adopt = $this->getadopt($stockadopt->type); to foreach($this->adopts as $stockadopt){ $adopt = $this->getadopt($stockadopt->id); -edit- That got the right details to show in the shop and pound but Trying to actually buy it An error has occurred. The adoptable specified is invalid... Boooooooooooo Last edited by Chaos77777; 01-21-2017 at 06:22 PM. |
#16
|
|||
|
|||
I did a workaround and named the types slightly different atm.
If you'd like, you can check out my site http://arconline.x10host.com :( Yeah, I made a dumb@ss typo at the start lol, I'll worry about fixing it later though Last edited by Chaos77777; 01-21-2017 at 09:35 PM. |
|
|
What's New? |
What's Hot? |
What's Popular? |