Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Suggestions and Feature Requests

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2014, 03:08 PM
IntoRain's Avatar
IntoRain IntoRain is offline
Moderator
 
Join Date: Jul 2013
Location: Portugal
Posts: 461
Gender: Female
Credits: 22,418
IntoRain is on a distinguished road
Default

Quote:
Originally Posted by Kyttias View Post
^^; Will it still be negligible at 6,000 users?
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.
Reply With Quote
  #2  
Old 12-22-2014, 09:16 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 588,061
Hall of Famer is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-22-2014, 11:03 PM
Kyttias's Avatar
Kyttias Kyttias is offline
Premium Member
 
Join Date: Jan 2014
Posts: 857
Gender: Unknown/Other
Credits: 127,071
Kyttias is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 02-07-2015, 01:27 PM
zoe's Avatar
zoe zoe is offline
the power of love
 
Join Date: Feb 2015
Location: hell
Posts: 25
Gender: Unknown/Other
Credits: 5,116
zoe is on a distinguished road
Default

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?
Reply With Quote
  #5  
Old 02-07-2015, 11:43 PM
FounderSim FounderSim is offline
Member
 
Join Date: Sep 2014
Posts: 65
Gender: Male
Credits: 10,854
FounderSim is on a distinguished road
Default

Dynamically load all content or an option to switch this on and off?
__________________
Reply With Quote
  #6  
Old 02-19-2015, 11:01 PM
Glow's Avatar
Glow Glow is offline
Member
 
Join Date: Nov 2014
Posts: 27
Gender: Female
Credits: 6,259
Glow is on a distinguished road
Default

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? :)
Reply With Quote
  #7  
Old 08-30-2015, 12:42 PM
parayna's Avatar
parayna parayna is offline
Member
 
Join Date: May 2013
Location: Devon, UK
Posts: 342
Gender: Female
Credits: 27,678
parayna is on a distinguished road
Default

Ooh, I would like what Glow suggested! :3
Reply With Quote
  #8  
Old 08-30-2015, 09:34 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 588,061
Hall of Famer is on a distinguished road
Default

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.
Reply With Quote
  #9  
Old 09-06-2015, 07:15 PM
parayna's Avatar
parayna parayna is offline
Member
 
Join Date: May 2013
Location: Devon, UK
Posts: 342
Gender: Female
Credits: 27,678
parayna is on a distinguished road
Default

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.
Reply With Quote
  #10  
Old 09-28-2015, 06:55 AM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 588,061
Hall of Famer is on a distinguished road
Default

Quote:
Originally Posted by parayna View Post
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
Well Anna released a mod for merge-breeding, in which offspring may take some traits/parts from each of their parents. Did you check it out already?
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
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


All times are GMT -5. The time now is 10:08 AM.

Currently Active Users: 2266 (0 members and 2266 guests)
Threads: 4,081, Posts: 32,032, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636