![]() |
Home Community Mys-Script Creative Off-Topic |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]()
Honestly, I've used varchar in most of my projects and queries took no longer than a few seconds with a few thousands auto-generated fake data entries. Query speeds actually depended more on the instruction I was doing (lost of joins, constraints, etc.) and if I had indexes to speed up selects.
I mean if you are only getting a person's gender, yes it will be faster, but in mysidia you usually get the whole row (since you are building objects). If you are getting a row where a column is a char and another is a varchar, you will get no performance improvements But if you are indexing tables with columns that can be either char/varchar, go with char. Again, talking on personal opinion about speed difference xD I still agree with you the gender and other columns should be changed anyway
__________________
![]() ![]() ![]() asp.net stole my soul. |
#2
|
||||
|
||||
![]()
Yeah I think you make a good point. For certain data field such as password, salt, session, and etc, we can definitely replace varchar by char since each cell in the same column will have identical or similar length(for password, encryption results in 128 characters for all passwords, regardless of the length of unencrypted password).
__________________
![]() Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#3
|
||||
|
||||
![]()
Also, I wouldn't mind a partial-public trade combo, with the poster choosing a winning 'bid'. Some additional thought might need to be put into it, such as everyone's bidding material being locked (so those pets and items don't end up elsewhere by accident) until the auction closes (the non-chosen get their stuff back), and the poster needing to choose a winner within a certain time period, else it auto-closes.
A "wonder trade" like Pokemon could also be interesting. Really, I'd love an auction house the most but it sounds like quite a lot of effort (even one without bidding, just auto-buys).
__________________
Please do not contact me directly outside of Mysidia.
I also cannot troubleshoot code more than two years old - I legit don't remember it. |
#4
|
||||
|
||||
![]()
I glad the dressing system has been mentioned, I would absolutely LOVE to have one!! And if it cant be done for pets, hopefully it can be done for human avatars and stuff!
Im also happy the gallery/badge mods have been said. Since collecting stuff is a huge part of pet sites, galleries would make sense. (I would have a sticker album. I love stickers.) But what about a safe system, where users can store items without having to carry them? ![]() |
#5
|
|||
|
|||
![]()
Dynamically load all content or an option to switch this on and off?
__________________
|
#6
|
||||
|
||||
![]()
A restock for the shops? Like at a certain time you choose? (Hourly, or set at your own desired time)
And a built in time where you get to choose the GMT for your site? :) |
#7
|
||||
|
||||
![]()
Ooh, I would like what Glow suggested! :3
|
#8
|
||||
|
||||
![]()
This should be possible now that Mys v1.4.0 will introduce the pseudo cron job system/scheduled tasks system that will update your site by any given number of minutes, hours or days as you specify. Once I am ready to show screenshots of this, I will explain how you can use time-based events in Mys v1.4.x.
__________________
![]() Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#9
|
||||
|
||||
![]()
Ooh, this sounds like it will be an amazing update! I can't wait for it to be released! :D Having an admin cp function of being able to add backgrounds to pets with transparent backgrounds, being able to add images over the top for items and 'mutations' would also be amazing :3 Maybe even putting that together with the breeding and allowing your babies to borrow parts from the parents and layer them together XD I know that it is possible (as people have done it), it's just I don't know how to do things like that and I know loads of people would absolutely love it! Even as an official mod would be great lol XD Keeping the old breeding way would be cool as well though, so having both would allow for you to maybe turn one, the other, or both off, or something? If you don't fancy it on your site XD
I'm kind of getting ahead of myself here but as time goes on I'm getting more excited aha XD EDIT: Also got struck with the idea of being able to choose whether 'mutations'/items, etc. can show up on certain genders. So say you had a lion with the 'mane' mutation, it would be cool if you could make it so that that mutation isn't available for the female version! Not sure that would be easy to do... but just an idea XD Last edited by parayna; 09-06-2015 at 07:29 PM. |
#10
|
||||
|
||||
![]() Quote:
__________________
![]() Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
![]() |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
The Official ACP Overhaul Thread for Mys v1.4.0 | Hall of Famer | Suggestions and Feature Requests | 24 | 05-14-2013 03:23 PM |
The official itemshop thread | Hall of Famer | Suggestions and Feature Requests | 12 | 08-26-2011 06:43 AM |
The official Zune/Ipod thread.. But mainly Zune because I'm biased. | shiann | Other Chat | 4 | 03-20-2011 07:19 PM |
The Official Mys v1.2.0 Thread[Beta available in Premium Members Forum now!] | Hall of Famer | Mysidia Adoptables Official Announcement | 86 | 03-12-2011 04:53 AM |
Suggestions Thread: | RoconzaArt | Adoptables Buzz | 3 | 01-18-2011 06:55 PM |
What's New? |
What's Hot? |
What's Popular? |