The images are stored in the database as binary MEDUIMBLOB columns.

Thus if your query with the binary string is corrupted, so will your image be.

Like Talisman said, the fix is to edit your games images in the AdminCP. and then add any new games via the AdminCP. The HTML is EXACTLY the same for all of them.

What do you mean when you say edit your games images in the AdminCP? Like try and re-upload them? If thats what you mean it doesn't work I have tried it numerous times. I have even tried to manually upload the image into the db and it STILL doesn't work.

It would be nice for it to just look for the .gif associated with the game name or even number so we didn't have to worry about the uploads not working. It would also probably be better security as well.

It's a weird hack, bharvey. The normal stuff we're used to don't work with this, for some reason. Guess it's because it's still a beta. I imagine futureal will tidy things up in time.

I had the same problems you guys are describing. So I searched the thread and found little scattered comments in here that serve as work-arounds. But they're not easy to find and they're not very thoroughly described. Sounds more like those who posted knew what was going on at the time, but it's not so clear to the rest of us. (At least it made little sense to me, at first.)

There are two things you need to look at:

1. If your situation is like mine..... any time you upload the graphic files to your database yourself, it won't work. Same thing if you run the queries, either using a script or doing it manually. The big globs of gobbledygook (great big columns of binary blob things) in the database come out differently than they do if you upload them using the "add game" or "modify games" options in the ACP.

2. The other thing to check if this isn't working right is the path provided by the hack in the ACP. It's not correct..... you have to delete the first slash. (This is mentioned in passing early on in this thread.)

Sounds like these might be the reasons your graphics aren't getting in there. You can't enter them by query or manually yourself ...... and the bad path in the ACP prevents you from the uploading them the way this hack wants you to do it.

Look at the screenshot I took of this and you'll see what I mean.

Hope that works for you.

Here's the message I found about this from last October.

Futureal, maybe you could edit your first post to explain this and make a few minor corrections to the txt file?

Well, my redneck english might be hard to understand sometimes bein that I done went and growed up in tha middle of Utah in the desert, but I think it's pretty straight forward what I meant. ;)

Go into the admin CP, choose edit game....then scroll to the game you wanna edit. You'll see the corrupted image, then below that there is a radio button that says something like delete current image? you answer yes, then below that there is a file browser. Select the image file you want to use, hit submit, and it stores it CORRECTLY in the database using the proper BLOB format.

As far as security goes, what's more secure? a file, or a datastream protected via MD5 encryption and pass within MySQL...

Personally, I find that uploading the image into the database is alot easier than having to make sure that my uploads directory is properly CHMODed and that the paths are correct, etc.etc....just put the binary in the database, then pull when needed.

He he.... we'll just blame it all on futureal. He spent all that time making it possible for us to upload these things from the ACP, and he damn well intends for us to use it.

Whether we want to or not ...... lol. ;)

;)

No such luck in any of the solutions described here regarding my images :(

- miSt

That was the first thing I tried amongst other things and still doesn't work.

Doesn't work with the / in front of games or not in front.

Also Database, Files, who cares I like solutions that work for everybody. And this seems to be a common issue for some dumb reason.

Hi Futureal,
Thanks for keeping this on your ToDo list even during all your exciting endeavors!

:classic: