girlzlover12

I have been trying to rotate an image for a while now but I cant get it to work right. It seems to be rotating the image not the whole canvas. I am trying to rotate the image, then resize it , then save it, and store the details in my db. The only thing I cant get working right is the rotation (it works but clips parts of the image and fills portions with black space. Must use GD as I don't have ImageMagic Can anyone tell me how I can rotate the image and not loose any part of it due to hanging over the sides. I will give you free advertising on the website I will be using this on if you can help me. http://myiphonebackgrounds.com I would be happy to give you a permanent banner along the side of all pages or put in the top banner rotation plus a friends site link. my source variable is $oldImage and I would like to store the rotated image into that same image file. the size of the imgae is in $width and $height. for now I would like to rotate the image 90 or 270 degrees but in the future I would like to do more. thank you for your time.

how can I store user information in an array so I can retrieve it next time? could I use csv files for each users home and garden? That way I would have 60k csv files and I could parse them for the info. I could store all the info for each tile in a separate field in the grid.

Well Im trying to find out how I should structure the DB I haven't been able to find anything about it. I have looked up limitations and I cant afford oracle. The limit on tables is somewhere around 1700 and rows ~4.5 mil and each row can contain ~65,000 bytes I would like help in figuring out how I can store the information for every tile in 15,000 towns and cities and also also each opf the users gets a garden and house. There is too many tiles in total to keep in one table and I cant split it into one per town because there would be to many tables. Also I am worried about having to perform 400 mysql queries to build the output for each page even if I use cache files it will still require a ridiculous amounts of queries. could I use gd library to save each town as one image and change the image when a tile gets changed? I would probably still need to run millions of queries at a time. I have already spent weeks trying to figure this out.

no-one knows how I can do this? I have been looking everywhere but can't seem to find a clear answer.

well I have taken a class in oracle sql and have so far done the most work on mysql dbs

Hi I am developing a php game which involves generating a map of tiles but I am having difficulties in figuring out how to store the information for the large number of tiles I plan on having cities 25X25 (625 tiles) town 15X15 (225 tiles) garden 20X20 (400 tiles) indoors 20X20 (400 tiles) garden and indoor tiles will also have an item layer (same size). owner ship of each tile needs to be track able to the user along with up to 6 other values needing to be stored. I expect to keep about 60,000 users worth of data in a DB (probably 10-15k towns or cities) I am worried about a good way to store the info I have come up with 2 ways to do it so far. 1. Using TEXT or LONGTEXT store all the info for each tile in 1 column of the db and using string explode to separate the values. Cons. -Huge rows with up to 625 Columns (might go over the limit) -editing 1 tiles properties would require loading the whole row. 2. Store each tile as a different row in separate tables for each type. Cons. - if half of cities/towns are cities that table would need to hold >4.6mill rows - Generating a city would require 625 queries to read the values. One solution to these problems could be caching info but recreating the cache file would still require huge amounts of queries to execute. What would be an efficient way to store this information or should I be using different technologies to do this. I could also use help with an efficient way to store inventory info for each user. Is there a way I could combine all the tiles into one image and generate an image map. Could this be a better way to go about this? Any help is much appreciated.