Vmoods Last Update Time Addon

[paul41598]

Vmoods Addon - When User Last Updated Their Mood!

Original HackFound Here (https://vborg.vbsupport.ru/showthread.php?t=178020&highlight=vmoods)

Whats It Do: This small addon will show you when someone last updated their mood. Kinda gives you a better feel for when someone really is feeling the way they are!

Why: I wanted to know when my users were changing their moods and feeling the way they were...so I figured I'd take a stab it it ;)

Database Changes: 1
Plugin Changes: 3
Template Changes: 1

Database:

ALTER TABLE " . TABLE_PREFIX . "`user` ADD `vmood_updatetime` INT(10) DEFAULT '' NOT NULL;

Remember to click install and rate it if you like!

[Hornstar]

Nice work, have you asked the coder if he can just make this default in his mod? that way it will be easier for all.

[Shelley_c]

Thanks paul. A very useful feature. Installed and rated

[alkolyok]

thanks and nice

[Bin7raib]

Thanks, :)

[Xencored]

Thanks :up:

[BucWiLd]

Nice work, have you asked the coder if he can just make this default in his mod? that way it will be easier for all.

I agree.... cause its to much for us newbs.. i cant do it.. be cool if it was just in an update. can ya do it for me paul? lol

[paul41598]

ya its real easy

[abdulbasitsaeed]

Seems like a great mod, Paul.

I figured the rest out but how would I make the change to the database? Is there any way to do so from the vBulletin Admin CP?

[abdulbasitsaeed]

SQL query?

[WickedWeb]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "`user` ADD `vmood_updatetime` INT(10) DEFAULT '' NOT NULL' at line 1

That is what you get after executing the sql query so you know.. I did it though phpmyadmin.

[randa]

Thanks