Full Games List
Featured Games
New Games
Reviews
Media
Images
Blogs
Game Updates
Images Feedback Summary
Game Design Highlights
Tutorials
Articles
Scripts
Utilities / Plugins
Resources
Engines
Engine Bulletins
What is Makerscore?
Past Events
Achievements
Misaos
Forums
Post History
Chat
New to RMN?
Full Store List
RMN Music Pack (free)
WHAT ARE YOU THINKING ABOUT RIGHT NOW?
Posts
deboo
85
deboo
View playlists
Close:) i am proud to hear it.
all that english slag can just fly over people's heads
edit: i meant slang but im going to leave it because it made me laugh
all that english slag can just fly over people's heads
edit: i meant slang but im going to leave it because it made me laugh
post=117177
after like three weeks of nothing but healthy food i tried eating pizza today; it made me ill and i had to throw more than half of it away
i'm convinced this is a good thing
Pizza can be good, but frozen/greasy restaurant pizza isn't. My pizzas are made with stuff from the garden, sweet potato and lots of herbs instead of sugary tomatoes (as in, the herb:sauce ratio in the, uh, sauce is more HERB-PACKED).
Yeah.
Also, I'm thinking about how silly chaos is for complaining that Phylomortis mode isn't perfect.
post=117224
sauce is more HERB-PACKED).
Pot in pizza sauce? That's a new one. I can never keep up with what you kids are doing these days.
more sql bucket o' fun!
(this one did not take a day but it was still a neat* learning experience )
* wait you need it to do what now?
*edit*
Also
Craze!
*reedit*
Queries without explanation are bad. This query retrieves the monthly net sales over a year (in this case, 2009). The problem comes from the sales data is in a bunch of table rows where each row is an employee's hours worked + sales made for a day. All these have to be added up for each day (inner-inner query). The next step is to consult another table where there may be an overriding value for a day's total sales and if this value is present for a given day the value specified in that table should be used for the day's net sales instead of the sum of the worker's sales (inner-query). Then it's just combining the sales data based on month (outer query). I'm pretty sure I can make it a bit leaner but it works now!
The last query I posted (that went off the page) was part of a search. Before the query it takes a search string, breaks it up into each word, some extra crap (where $RefineSearch and $ProvinceSearch come in) to narrow the search, and then there's the crazy process: Execute a search for each word in each row in a table (using a bunch of queries that search for one word and combining the result sets of all the searches). Each time a word is found in a row, a '1' is assigned to the row (technically it isn't but I can't think of a better way to describe it right now). Once all the searching is done the outer query adds up the '1's assigned to each row and sorts them based on how many '1's a row was assigned.
aka it is a basic weight-based search system of unknown quality. The DB it was tested in is pretty small so to really test it I'll have to fill it up with junk or something. In the future I plan to add Soundex as a rudimentary way of avoiding simple spelling inconsistancies from string comparison (like, Mc and Mac)
SELECT SUM(TrueNetSales) AS 'NetSales', SUM(Hours) AS 'Hours', SUBSTR(DateCreated, 6, 2) AS 'Month'
FROM (
SELECT Hours, DateCreated, IFNULL(TotalNetSales, NetSales) AS 'TrueNetSales'
FROM (SELECT StoreID, DateCreated, SUM(NetSales) AS 'NetSales', SUM(Hours) AS 'Hours'
FROM MembersStats m
WHERE m.StoreID = 1
AND DateCreated BETWEEN '2009-01-01' AND '2009-12-31'
GROUP BY DateCreated) m
LEFT JOIN DailyTotalNetSales d
ON m.DateCreated = d.Date AND m.StoreID = d.StoreID
WHERE DateCreated BETWEEN '2009-01-01' AND '2009-12-31'
) NetSales
GROUP BY Month
* wait you need it to do what now?
*edit*
Also
*reedit*
Queries without explanation are bad. This query retrieves the monthly net sales over a year (in this case, 2009). The problem comes from the sales data is in a bunch of table rows where each row is an employee's hours worked + sales made for a day. All these have to be added up for each day (inner-inner query). The next step is to consult another table where there may be an overriding value for a day's total sales and if this value is present for a given day the value specified in that table should be used for the day's net sales instead of the sum of the worker's sales (inner-query). Then it's just combining the sales data based on month (outer query). I'm pretty sure I can make it a bit leaner but it works now!
The last query I posted (that went off the page) was part of a search. Before the query it takes a search string, breaks it up into each word, some extra crap (where $RefineSearch and $ProvinceSearch come in) to narrow the search, and then there's the crazy process: Execute a search for each word in each row in a table (using a bunch of queries that search for one word and combining the result sets of all the searches). Each time a word is found in a row, a '1' is assigned to the row (technically it isn't but I can't think of a better way to describe it right now). Once all the searching is done the outer query adds up the '1's assigned to each row and sorts them based on how many '1's a row was assigned.
aka it is a basic weight-based search system of unknown quality. The DB it was tested in is pretty small so to really test it I'll have to fill it up with junk or something. In the future I plan to add Soundex as a rudimentary way of avoiding simple spelling inconsistancies from string comparison (like, Mc and Mac)
post=117280
Dear tardis,
I have never done pot, or any other drug, in my life.
-Craze
you don't "do" pot.
jesus christ
deboo
85
they're both amazingly gorgeous, whoever they are. seems cool to me, more serene
im thinking about how my school is a bastard and we need some form of snow day soon. every other school in leeds had one, it's simply a piss take and i will not have it. and on the way the wind blew and a tonne of snow fell down from a tree into the back of my coat and wellies, and i was a soggy bunny AGAIN
im thinking about how my school is a bastard and we need some form of snow day soon. every other school in leeds had one, it's simply a piss take and i will not have it. and on the way the wind blew and a tonne of snow fell down from a tree into the back of my coat and wellies, and i was a soggy bunny AGAIN
