PPN,

I tried adding a limit, just HOPING that would work, and that still didn't seem to fix the problem.

i.e.
I'm still thinking that the issue lies within the info of the table. My last entry is always garbled only in that table, no others...

Any luck?

PPN,

I was reviewing this thread and also the code for the hack.

I'm not a programmer but would this be a solution?!!!!

I think that the problem relates to the mysql query and the 'order by rand()' instruction.

Would this solution work?

1. Query the database but exclude the order by rand() referred to above.
2. Count the no of rows in the query result/array. Result ='x'.
3. Use a php function to pick a random value 'y' between 0 and x-1.
4. Select row 'y' from the query result/array and use this to display the advert.

What do you think?

Or is there anyone else out there that has the coding skill to implement and test this?

This is a great hack and only needs the last push to make it a super one!

Keep up the good work.

Willie

If someone can write it, I will test it :)

Right about now is when I start crying....Did PPN wander off again? ;)

good thing I read the last few pages of this thread and realized this hack isn't working. Maybe the first post should be updated with that info so people don't go instalilng it to only find out it doesn't work.

I tried That crapped out my system.

Then, I tried
Still nothing.

How about if generate a random number using PHP, convert it to an integer value (probably by
multiplying by 100 and lopping off the decimals) and use that as the
seed?

I don't know how to do this, but I clearly remember there being something on these forums about a vbrand() function.

Hello,

nice hack! Sorry for my bad english, but I will try to explain the problem that occurs on my board..

I put the variable into the header template and it works on all pages, but if i go directly to a post, e.g. http://forum.ksgemeinde.de/showthrea...230#post170230 the banner is not shown?

But if you go to the same thread directly, e.g. http://forum.ksgemeinde.de/showthrea...threadid=19771 the banner is shown.

Do I have to insert anything anywhere to get it work in the header even if you directly go to the last post?

Thanks in advance,
thakikka

I'm posting another cry for the hack to be fixed. I really need a reliable ad system going. So far this one rocks but I need it to rotate banners.

I'm going to have a go of re-writing this hack, maybe before christmas. Life is just a bit hectic at the moment.

The problem with this hack is basically the sql query that fetches the adverts, it doesn't seem to randomise it.