Score: 0.00 Votes: 0
rate this

improve

Starter: warpozio Posted: 22 years ago Views: 747
#482
Lvl 12
IMHO The best feature is the voting feature.
Is there a way to mark that I've allready voted for a picture? (I can't remember them all)
#483
Lvl 12
please do not take every picture you ve been emailed, i think the webcam edition is really bad, but the rest is very good, the quality of the pics aint that good in some cases.

We will see the futute

Solid the Snake
#484
Lvl 25
Some jpg quality is low, for a reason. Datatraffic... In the news site there will be a filter for bad pictures and adult pictures.. some people like the webcam chicks, other cute babes, other naked.

So if you have some nice pictures, just submit them with the Upload a picture funtion.
#485
Lvl 25
Hmm, how do you mean, mark?

Problem now is with current voting system the database... Mysql 3.xx doesnt support sub-selects.. mysql 4.1 is just out, and supports sub-selects.. only problem is mysql 4.1 is alpha, and must be beta and then final.. zo it's going to be more then an half year befor i can implent a better hot or not.. or somebody has a better idear for me!?
#486
Lvl 16
when i voted there is a line of text under the picture with the text :34 people rated this picture and you rated a 7

so thats how you know when you rated a picture
* This post has been modified : 22 years ago
#487
Lvl 16
hey diz where is the avater?
#488
Lvl 25
Docterlove:
There are 2 tabels in the rating system, first tabel: ratings. Second table is: rating_log. The first table holds the scores for every picture on the site. The second table holds the picture id of every picture you voted on.

And now the problem: If i want to select every picture that isn't in the rating_log table, i need sub-selects. for example: SELECT a.id FROM picture AS a WHERE a.id NOT IN (SELECT b.id FROM ratepicture_log AS b WHERE userid = '".$userid."' AND b.id = a.id) ORDER BY RAND() LIMIT 1. If i want to do this in php, i need to make a loop, and this will get very nasty! Up to processing times from about 30 or 40 seconds. And you don't want that!

Hehe deleted it when testing the profile.php of the new site.. are a ot of changes in the new profile.php Have to put a new one up, but didn't have the time!