Jump to content

andy75180

Members
  • Posts

    22
  • Joined

  • Last visited

    Never

About andy75180

  • Birthday 05/04/1978

Contact Methods

  • Website URL
    http://che55.com/

Profile Information

  • Gender
    Male
  • Location
    London, England

andy75180's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Yes I know. It's only a basic security thing, so I can take a closer eye on players with the same ip. I can then take further steps.
  2. No I'm afraid that doesn't work correctly. I'm just getting a list of all the ip addresses and usernames.
  3. Hi ya, Got a problem I'm trying to solve with retrieving data from my mysql database. Wondered if anyone could help. Have a login system with my chess site that logs each player's username and ip when they login to play. I need a query that select only entries that have an IP address associated with 2 or more usernames. This will help me track down cheating users that have 2 or more accounts. Here's an example table:- --USERNAME-----IP ADDRESS--- --terry-------123.123.123.123-- --tony-------65.33.22.43------- --larry-------185.43.5.67------- --larry-------185.43.5.67------- --paul--------32.23.0.4-------- --andy-------123.123.123.123-- --zippy-------55.56.34.123----- The correct mysql select query would retrieve the ip address 123.123.123.123 because terry and andy are using it. 185.43.5.67 would not be retrieved because only larry is using it which is okay. Any ideas anyone on the select query I need to submit?
  4. Your SQL isn't rusty at all. Yes I've tried your idea and my league table is working perfect now. Thankyou very much for time solving my problem.
  5. Mmmm, sounds a better idea. Haven't got time to try it at the moment, but will let you know how I get on. Thankyou for replying.
  6. Hi ya, Any help with this problem anyone? Have decided to include a top 10 chess league position table on my homepage. The league is sorted by the number of points a player has. 1st place the most points. This has been an easy task to do, using ORDER BY and LIMIT mysql commands. Problem is I run into problems when 2 or more players have the same league points. I've decided that players will share the position when this happens, but mysql will only return the top 10. Obviously if 2 players have 10th position I need to extract 11 players from the database. I could do this retrieving all players and sorting the list using PHP array. Quite easy, but is this the most efficent to go about it? Extra time retrieving rows from database I won't be using. My questions I'm asking is; is it possible to retrieve the top 10 players with the highest score, but include more players if league points are the same. Hope I've explain myself properly. To visually see my chess games league table may help solve this problem. Any help most appricated.
  7. Hi ya, If I have a float number of say 3.478399 How can I reduce the number to 1 decimal place without rounding? I've tried it will sprintf, but it rounds the 4 to a 5 which I want to avoid. $float_number = 3.478399; $new_float_number = sprintf ("%0.1f",$float_number); Output returns 3.5 when really I need it to be 3.4 Any help anyone?
  8. Excellent, I tried to do an on-the-fly image, but was unable to do it. Being a dumb dumb, I've realised I missed out the header('Content-type: image/png'); command. It now works fine. Also is quicker, because don't have to save and retrieve it from the server. Thankyou very much, everyone that helped. Good programming....
  9. No the image isn't user specfic, it will be on my homepage, so will be viewed quite a bit. Sounds like I need some sort of file locking then, but not sure how to do it using the normal 'flock' function, because I'm not writing the image to disk using the 'fwrite' command, only the 'imagepng' function which is different. Any idea anyone?
  10. Hi ya, Am currently creating an image using PHP and saving the finished image onto my server using ImagePng($IMAGE,$FILENAME); This works fine, and the image can then be retreived using normal <img> in my XHTML code. I'm now wondering if a problem could occur if a person was getting the image by refreshing their browser and at the same time another person was creating the image file using an automatic PHP script. Does the file need to be write locked in anyway using flock? Any help most appricated. Thankyou
  11. Got the daily chess problem working on home page now. It should automatically change to a new one everyday using a cron job. Have a try at today's if you like.
  12. You need to post the code on here so we can find problem. I've used PHP in my chess site loads, so I should be able to fix it. Probably...... :-\
  13. I've just change width to 1000px and seems to of done the trick. Well, on my monitor anyway it has. It's probably messed up somehow on someone elses screen.
  14. Ok, just replaced my code for the code you put in last post. Is it auto centering now?
  15. Just changed my site so it *should* now auto centre, left and right. Can someone please check it on a 1280*800 size screen? The max mine goes to is 1024*768, so I can't see if i've done it correctly. Thankyou
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.