Works like a charm. There were a few suggestions I had that would be cool in another version or an update...
1)Ability to specify little images, ribbons or something (im using a ribbon system) instead of just text. IE: under input field you enter the number you want,
then it automatically displayes that number of images.
2)Show the "Rating:" under the users avatar and other info. That way he can "show off" his rating to other users
IF this is possible or easy to add that would be purty cool to have
Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter,style.title as styletitle
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid,ratetotal,ratenum,allowrat e
LEFT JOIN style on (user.styleid = style.styleid)
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '3019'
mysql error: Table 'forum.ratetotal' doesn't exist
mysql error number: 1146
this is what is bothering me --> mysql error: Table 'forum.ratetotal' doesn't exist
Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.
212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.
Originally posted by 212rikanmofo can someone help me install this mod please, i dont have phpmyadmin, im stuck at this part, please help me someone... =(
212rikanmofo, as trilOByte specified, you would require a cpanel and most likely would have phpMyAdmin on your server provided by your webhost, since you have vBulletin installed.
Thus, having php support on your server, you will only need administrators access to your domain, and some sort of an Admin Panel, which will most likely have phpMyAdmin installed. If you have Administrator Access on your server, you will be able to upload the files and then run the appropriate scripts or do the required actions to install this modification/hack.
Originally posted by trilOByte Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.
212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.