Search for houses

Started by Calvingreen17., September 09, 2012, 04:47

Storm94

Quote from: Joshy on January 02, 2013, 22:38

There's a lot of houses there so yeah it would be wise to limit results per page. Good suggestion.
There are less than 1500 houses, and they all have a unique (and Im guessing a primary key in the SQL database) ID. To query them ALL would take less than 2 seconds. Pagination would be good though, because it would be hard to look through 1500 results to find one.

I'm back, bitches :D

[glow=#282828,10,500]"I dislike Apple, so no." -mick88
"$nake honestly you are one arrogant prick." -Shane0
"The rest of you who I could consider trolls, just go fuck yourself." -Joshy
"TheGame, All I have to say is you complain a lot, and you're probally gonna be an even more arrogant, pompous jackass after this." -RaceRX
"I have a suggestion: Repost this in a respectful manner without caps, silly colors and big fonts, and perhaps someone will give a fuck about your complaint." -mick88
[/glow]

Can't read my quotes? Stop using the white style.

Joshy

Quote from: Storm94 on January 03, 2013, 04:26
Quote from: Joshy on January 02, 2013, 22:38

There's a lot of houses there so yeah it would be wise to limit results per page. Good suggestion.
There are less than 1500 houses, and they all have a unique (and Im guessing a primary key in the SQL database) ID. To query them ALL would take less than 2 seconds. Pagination would be good though, because it would be hard to look through 1500 results to find one.
Think of all of the images that need to be downloaded too! Definitely needs pagination.
[comment]test[/comment]
LAST SEEN
TOTAL TIME ON SERVER
SCORE
TRUCK LOADS
CONVOY SCORE
ACHIEVEMENTS
ARTIC
DUMPER
VAN
FUEL
CEMENT
ARRESTS
CARS STOLEN
COACH
PLANE
HELICOPTER
TOW TRUCK
LIMO
TRASH
ARMORED VAN
BURGLARIES
ARMORED VANS STOLEN
MISSIONS FAILED
OVERLOADED
FINES PAID
TOTAL SPENT ON FUEL
INTEREST EARNED
DISTANCE TRAVELLED
TIME IN JAIL
LAST MISSION
Generated using Azure Functions & CloudFlare Workers using the Convoy Trucking API. Updates every around 5 minutes. See the original SVG image. View source code (not updated with function yet)




Calvingreen17.

Who woulda thought people were still talking about this XD.

Quote from: mick88 on January 01, 2013, 12:21
Sounds feasible. But number of results will be limited to avoid overloading the databse.

Err what do you mean? Results in total or results per page? Sorry for stupid question LOL.

Older and wiser

Joshy

Sorry for bumping...

Will be added in CT.dev, search types:

  • by area
  • by slots

I won't do by-name search since you will be able to find the player's profile and find their house from there. (since houses belongs to player, not player belongs to house)
[comment]test[/comment]
LAST SEEN
TOTAL TIME ON SERVER
SCORE
TRUCK LOADS
CONVOY SCORE
ACHIEVEMENTS
ARTIC
DUMPER
VAN
FUEL
CEMENT
ARRESTS
CARS STOLEN
COACH
PLANE
HELICOPTER
TOW TRUCK
LIMO
TRASH
ARMORED VAN
BURGLARIES
ARMORED VANS STOLEN
MISSIONS FAILED
OVERLOADED
FINES PAID
TOTAL SPENT ON FUEL
INTEREST EARNED
DISTANCE TRAVELLED
TIME IN JAIL
LAST MISSION
Generated using Azure Functions & CloudFlare Workers using the Convoy Trucking API. Updates every around 5 minutes. See the original SVG image. View source code (not updated with function yet)