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
  #111  
Old 06-09-2014, 08:08 AM
Hwona's Avatar
Hwona Hwona is offline
Member
 
Join Date: Mar 2013
Posts: 620
Gender: Female
Credits: 48,154
Hwona is on a distinguished road
Default

Quote:
Originally Posted by IntoRain View Post
I did this system for Infernette's Forest of Mirrors, it's kind of boring and very rarely used I think. Rounds take long to start, since they need to be full before calculating a winner.

Each competition asks for a certain adoptable (Infernette has implemented stats and moods and season/time of day an adoptable was born in) and has a limited number of entries. When it's filled, it calculate the top 3 adoptables with the best stats and distributes rewards (money)

If there's enough interest I can try to ask her if I can make the code public and translate it to 1.3.4, since I plan on doing many mods once my vacations start
Wow, that must be pretty awesome! I'm actually still using v.1.3.3 and have been trying to get an alternative system up since probably as one of the worst coders here, I can't do anything like competitions. XP
__________________
Reply With Quote
  #112  
Old 09-24-2014, 01:25 PM
parayna's Avatar
parayna parayna is offline
Member
 
Join Date: May 2013
Location: Devon, UK
Posts: 342
Gender: Female
Credits: 16,083
parayna is on a distinguished road
Default

Does anyone know if there has been something like a 'crafting' feature suggested? Like, if I wanted to create the item, 'Sushi,' I could go to a page and then use up the ingredients (fish, seaweed, rice) from my inventory and then come away with a sushi item?

I don't know if it has been suggested yet, but I would love that feature XD (Sorry if it has, I sometimes skim over bits when pages become too long XD)
Reply With Quote
  #113  
Old 09-24-2014, 10:15 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: 327,297
Hall of Famer is on a distinguished road
Default

You may want to check out the alchemy mod I made for Mys v1.3.4, its very similar to the feature you are requesting. In Mys v1.4.0 the alchemy/craft system will still come out as a plugin/mod rather than bundled with the official package.
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
  #114  
Old 09-25-2014, 01:58 PM
parayna's Avatar
parayna parayna is offline
Member
 
Join Date: May 2013
Location: Devon, UK
Posts: 342
Gender: Female
Credits: 16,083
parayna is on a distinguished road
Default

OK! Thank you! :D (Can't wait for the next script to come out :P)
Reply With Quote
  #115  
Old 12-19-2014, 01:31 AM
Kyttias's Avatar
Kyttias Kyttias is offline
Premium Member
 
Join Date: Jan 2014
Posts: 857
Gender: Unknown/Other
Credits: 86,930
Kyttias is on a distinguished road
Default

For v1.4.0, I'd like to see some database optimization done. Some of the VARCHAR values could easily be held as CHAR values.

There are trade-offs, both with their benefits. VARCHAR values take up less disk space, because while they hold a maximum value, they store the contents dynamically. But it's because of this reason exactly that they query slower. CHAR values will always take up the exact amount of space you allocate, whether they are filled or not. But because they are predictable in this fashion, queries through them run up to 20% faster. On the downside, again, is that they are storing the full length of the max you set, regardless of how much of it is filled.

For values that will barely change in length, useralternates in the owned_adoptables table, for example, CHAR(3) may be a better fit, given it will only ever hold yes/no values (and at that rate, rewrite the code to handle it in binary, perchance?), or gender, as a better example, it only holds one character, easily could be CHAR1 instead of VARCHAR10. I think the entire database could use a look over before release, trim up some absurd lengths here and there, etc.

It comes down to size on disk versus query speed. Some more reading here?

But if there's going to be any importing from previous versions, there could be conflicts... =/
__________________
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.

Last edited by Kyttias; 12-19-2014 at 01:57 AM.
Reply With Quote
  #116  
Old 12-19-2014, 02:25 PM
IntoRain's Avatar
IntoRain IntoRain is offline
Moderator
 
Join Date: Jul 2013
Location: Portugal
Posts: 461
Gender: Female
Credits: 19,255
IntoRain is on a distinguished road
Default

Quote:
Originally Posted by Kyttias View Post
For v1.4.0, I'd like to see some database optimization done. Some of the VARCHAR values could easily be held as CHAR values.

There are trade-offs, both with their benefits. VARCHAR values take up less disk space, because while they hold a maximum value, they store the contents dynamically. But it's because of this reason exactly that they query slower. CHAR values will always take up the exact amount of space you allocate, whether they are filled or not. But because they are predictable in this fashion, queries through them run up to 20% faster. On the downside, again, is that they are storing the full length of the max you set, regardless of how much of it is filled.

For values that will barely change in length, useralternates in the owned_adoptables table, for example, CHAR(3) may be a better fit, given it will only ever hold yes/no values (and at that rate, rewrite the code to handle it in binary, perchance?), or gender, as a better example, it only holds one character, easily could be CHAR1 instead of VARCHAR10. I think the entire database could use a look over before release, trim up some absurd lengths here and there, etc.

It comes down to size on disk versus query speed. Some more reading here?

But if there's going to be any importing from previous versions, there could be conflicts... =/
There isn't really that much of a difference in terms of speed, it's pretty neglectible honestly. I believe the char/varchar query differences are actually if you manually create the indexes based on those columns. Database optimization would fall into the very boring subject of normalization xD I agree the yes/no/true/false columns should be changed to boolean (int if database doesn't support it or even enum('true', 'false')). And the gender also, that one deserves to be a char

But I'm not really into databases, normalizing them and stuff has never been my thing, just talking out of personal opinion

---

Having Mysidia on git would really help. People who like this framework could contribute with bug fixes and aditional features, etc. SourceTree is a good interface that supports git, so you don't need to use the command line if you feel uncomfortable with it
__________________


asp.net stole my soul.

Last edited by IntoRain; 12-19-2014 at 02:33 PM.
Reply With Quote
  #117  
Old 12-19-2014, 02:33 PM
Kyttias's Avatar
Kyttias Kyttias is offline
Premium Member
 
Join Date: Jan 2014
Posts: 857
Gender: Unknown/Other
Credits: 86,930
Kyttias is on a distinguished road
Default

^^; Will it still be negligible at 6,000 users?

Quote:
Originally Posted by IntoRain View Post
Having Mysidia on git would really help. People who like this framework could contribute with bug fixes and aditional features, etc. SourceTree is a good interface that supports git, so you don't need to use the command line if you feel uncomfortable with it

Definitely. There are a lot of little things I've long since fixed that were almost too minor to mention, but I feel bad for the less php-savvy.
__________________
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.

Last edited by Kyttias; 12-19-2014 at 02:40 PM.
Reply With Quote
  #118  
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: 19,255
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
  #119  
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: 327,297
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
  #120  
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: 86,930
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
Reply

Thread Tools
Display Modes

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 03:52 AM.

Currently Active Users: 484 (0 members and 484 guests)
Threads: 4,080, Posts: 32,024, 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 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636