can we make it so when a user is the member of da day, he'll get an email saying he's the member of the day . .yadda ydda yadda?

Put
around parenthesis, like this:
:)

Mever mind, saw above link, :

how do i run a query :(...

read above post by cditty:


Check out this thread - http://www.vbulletin.com/forum/show...?threadid=18558

Chris

Just uploaded a vbHacker version to the first post. :)

I use it too, but why does it say nothing?


Look: http://chatter-board.de

Did you run the query you were told to run?

Mein Englisch ist nicht das beste, deswegen versuche ich das nun Deutsch, aber hoffe auf antwort.

Ich brauch den Hack, dass meine Zitate und so auch in diesem K?stchen erscheinen, wo bekomm ich den her, kann mir da einer von euch helfen?

So I think so

Firefly,

thnx for the hack, i find it great and would like to request what I think won't be very tough modification.

How could I add diplaying the avatar the member of the day has?

Thanks again!

I had this type of a hack when I used UBB but haven't used it with vBulletin because all the "members of the day" where people who didn't come to the forums anymore or it picked someone with 0 posts. ;)

How about adding a feature to make sure the member of the day is someone who actually is a participating member. Someone who has logged in within the past month or 2. vBulletin already keeps the "last visit".

Reading through the thread usually helps, diettalk. :rolleyes:

Great hack, just installed it using vbHacker :):up:

is there a text version of the (Members of the Day so that I can do this manually, I prefer this as I can backtrack my mistakes, if any, I am on version 2.2.5
can anyone help please

can we have the 2.2.5 version soon ..

is there anyway to make the member of the day clickable?

if you go into vbhacker ou should be able to generate a txt file with all the instructions

I haven't read through the posts in here yet, but is there a way to make it choose a random user through all those who have posted recently, say, in the last week. I just don't want it to choose a user who hasn't posted in 1 month or something.

Does this work with 2.2.5?
Thanks

Yes it does.

Chen, this is a great hack. However, it isn't working too well at my forums (it's not the hack - it's nothing to do with vb actually ;)). How can I safely remove it?

Sorry for sounding dumb...I haven't ever removed a hack before ;)

Thanks!

Jen

Just do everything the instructions say, only backwords. Don't mind the query you ran, there's no need to remove what it added (trust me).

Great Hack FireFly!!!
Very Easy to install!! :D
Thanx so much..

So how about post #99? Think it can be done?

Already done, read through the thread.

Hi, need a little help.
I got all the way to the last step.

It says:

?Run this query: |
+-----------------------------------------------------------------------+
INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,-2,'memberoftheday','0||vb||0||vb||0');"

How do I do this? What does it mean when Im told to "run a query"? Thanks for your help.

it means run a query on your mySQL database, it will add that table to your database.

do this in phpmyadmin

BUT BACK UP YOUR DATABASE FIRST!!

Thanks for the reply.
Sorry, Im a newbie at this, but how do I access phpmyadmin?

Thanks again.

well im not sure if your server has it installed, but if it does you should be able to acess it via your site cpanel

Ok, thanks for the help:)

no problemo el muchacho ^^

Can I just run the whole the whole query again to get the users who are active to show? Looks like it would be easiest in phpmyadmin. Can someone paste in the whole query with that edit that was post by FireFly? I'm no mysql expert, can't even tell where the query ends. :D

Okay, it isn't the query that needs to be changed, just the code. duh.

Anyhow, I just need people active in the last month to qualify. What timestamp can I use in this code:

Change 14 to 30 (number of days).

Yea, but instead of "time", don't I need php code?

Just change it to what Firefly said and it will work the way you want it to. He's done this once or twice before, I think. :)

Okay...but have some weirdness happening. No name is appearing:

http://www.hostnexus.com/forum/index.php?s=

Under the stats at the top. I just want this working so I can install the main Stats hack.

And Christ. Will some tell me how to get the user online/offline thing happening like it is here? :D

Are you using this line? I just looked at your code and didn't see it. ;)

Yep: