28 Feb
Saw the stats page was an ancient broken mess, started cleaning up.
Now I know how to generate two arrays - like all the breeds, and counts of how many griffs belong to them - in correct orders, store them in DB, then retrieve and loop through them, for a Most Popular Breed ranking, with numbers.
Same code can be used to count elements, oldest griffs and their ages, richest Masters and their money... and all other rankings.
Will finally need a cron to do the counting and results-storing every night. Then when someone visits page during day, DB only has to do a single query - fetch whole row from table - and PHP deals with all those numbers, turning them into rankings. Muuuch better than doing a zillion counts every time page is visited. >.<
Can't help messing with the Trials now. Sooooo outdated! Just deleted at least 70% of the code.
I look forward to making them much more smooth and easy to navigate.
1st March
Added jigsaw and memory match puzzles to the Games page, with AJAX for claiming prizes. Rather satisfied. Just needing lotsa pretty graphics...
2nd March
Cleaned up some DB stuff, and updated the vault and shop scripts. Now, any other script that changes user's money needs updating too. Hooo boy.
4th March
- Adding some shading to the new Minavi bases. It's so detailed and tricky. Just the 2 elder forms so far...
- Finally writing the new personality traits...
- Thinking of doing a quick overhaul of the quick tasks system, it's ancient by now. Wait til personalities are redone.
5th March
Descriptions done. Well, just the 6 main traits (couldn't really think of 7th or 8th ones so removed them). Size/build/aura/fitness need more detail.
6th March
Skills added, with scores/descriptions on griff profiles. Woo. There are 15 skills and 10 possible levels, each with snarky names.
There aren't any ways to increase skills yet - must add that to battles, crafting, quick tasks...
Also might make a training academy (or individual NPCs) who give skills in return for payments. The courses could last a few hours maybe. Too tired now.
7th March
Hnnng. Trying to update the ancient register/login/forgotpass stuff to use the newer, safer PHP password functions.
For some reason, when the hashed version is saved in DB, it's not being stored properly.
If I go to PHPTester and make another hash of the same password, and manually put that in DB, it suddenly works? Argh.
...
Bah, reverted to the older code. At least I did update the register scripts so new users get their default nests, etc. Activation seems to work again, after some hiccups.
9th March
Been redoing the Activity page, with log of all latest goings-on. Previously all messages were in one table, in full HTML. That's a heap of stuff to store...
Now a bunch of different tables store history - one for flock news like griffs adopted/hatching/growing/dying, one for breedings/stud, one for griff sales, one for item sales, one for item trades... and the handful of numbers are used to look up names and generate the messages on page load, using a handy function.
Other advantage of splitting these messages into specialised tables is that they can be searched easily. Look up all the previous owners of a griff, the prices and times. Or all the griffs one user has bought or sold, between X and Y dates, and what happened in those griffs' lives afterwards. Or exactly what items 2 users have been trading/selling to each other. Or if a certain user only obtains/seeks a certain item, and gives it to the same friend... Admins will be able to check for multi accounting.
Anyway, about 4? sections are done, gonna try and finish the rest tonight.
Saw the stats page was an ancient broken mess, started cleaning up.
Now I know how to generate two arrays - like all the breeds, and counts of how many griffs belong to them - in correct orders, store them in DB, then retrieve and loop through them, for a Most Popular Breed ranking, with numbers.
Same code can be used to count elements, oldest griffs and their ages, richest Masters and their money... and all other rankings.
Will finally need a cron to do the counting and results-storing every night. Then when someone visits page during day, DB only has to do a single query - fetch whole row from table - and PHP deals with all those numbers, turning them into rankings. Muuuch better than doing a zillion counts every time page is visited. >.<
Can't help messing with the Trials now. Sooooo outdated! Just deleted at least 70% of the code.
I look forward to making them much more smooth and easy to navigate.
1st March
Added jigsaw and memory match puzzles to the Games page, with AJAX for claiming prizes. Rather satisfied. Just needing lotsa pretty graphics...
2nd March
Cleaned up some DB stuff, and updated the vault and shop scripts. Now, any other script that changes user's money needs updating too. Hooo boy.
4th March
- Adding some shading to the new Minavi bases. It's so detailed and tricky. Just the 2 elder forms so far...
- Finally writing the new personality traits...
- Thinking of doing a quick overhaul of the quick tasks system, it's ancient by now. Wait til personalities are redone.
5th March
Descriptions done. Well, just the 6 main traits (couldn't really think of 7th or 8th ones so removed them). Size/build/aura/fitness need more detail.
6th March
Skills added, with scores/descriptions on griff profiles. Woo. There are 15 skills and 10 possible levels, each with snarky names.
There aren't any ways to increase skills yet - must add that to battles, crafting, quick tasks...
Also might make a training academy (or individual NPCs) who give skills in return for payments. The courses could last a few hours maybe. Too tired now.
7th March
Hnnng. Trying to update the ancient register/login/forgotpass stuff to use the newer, safer PHP password functions.
For some reason, when the hashed version is saved in DB, it's not being stored properly.
If I go to PHPTester and make another hash of the same password, and manually put that in DB, it suddenly works? Argh.
...
Bah, reverted to the older code. At least I did update the register scripts so new users get their default nests, etc. Activation seems to work again, after some hiccups.
9th March
Been redoing the Activity page, with log of all latest goings-on. Previously all messages were in one table, in full HTML. That's a heap of stuff to store...
Now a bunch of different tables store history - one for flock news like griffs adopted/hatching/growing/dying, one for breedings/stud, one for griff sales, one for item sales, one for item trades... and the handful of numbers are used to look up names and generate the messages on page load, using a handy function.
Other advantage of splitting these messages into specialised tables is that they can be searched easily. Look up all the previous owners of a griff, the prices and times. Or all the griffs one user has bought or sold, between X and Y dates, and what happened in those griffs' lives afterwards. Or exactly what items 2 users have been trading/selling to each other. Or if a certain user only obtains/seeks a certain item, and gives it to the same friend... Admins will be able to check for multi accounting.
Anyway, about 4? sections are done, gonna try and finish the rest tonight.