Miscellaneous Hacks - Signatures Gallery Hack

Hello everyone

hack name: Signatures Gallery Hack
vB version: 3.8.X
by all-the-vb (all-the-vb.com)



How the hack works:
It works like a signatures gallery

Features:


1) You can see all signatures instead of going through every member profile to see his signature. So without this hack, if you want to see all signatures then you need to spend hundreds of years, while with this hack you can see them in one page.


2) Members can vote for any signature they like, and number of votes will be beside every signature.


3) You can specify number of signatures that'll be displayed in the page.


4) You can allow/disallow multi vote by user.


5) You can allow/disallow visitors to vote.


6)You can specify the number of posts each user need to be able to vote. (you can ignore this Features).


7) You have the chosse to rest the counter or not for users who change or edit thier Signatures.


8) you can show/hide top Signatures box. and dicide the limit.
(show the results like vb poll results)


9) you can show one signature for a specifc user by using (sig.php?do=exact&u=X)
X= user id


10) Detect other features


To rest counters:
run:

UPDATE user SET sigrate=0

if you use this hack ..(click install)
goodluck.

[Sweeks]

Is this able to just show a page to admins full of every members signatures to date with the ability to edit them then and there?
________
FREE AMATEUR XXX MOVIES

[Hornstar]

I see you have been doing this hack for a very long time. Nice to see you still updating it

[trotskid]

Now working fine with the upgrade. Thanks!

Originally Posted by all-the-vb

colors you can change it in sigratebit template..

<form action="sig.php?do=addvote" name="vbform" method="post">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="alt1" align="$stylevar[left]" width="10%" id="u$sigrate[userid]">
      <p align="center"><a   href="member.php?$session[sessionurl]u=$sigrate[userid]">$sigrate[username]</a>
    <td width="10%" class="alt2" align="$stylevar[left]">
      <p align="center"><input type='radio' name='sigrate' value='$sigrate[userid]'>
    <td class="alt1" width="10%" align="$stylevar[left]">
      <p align="center"><span class="smallfont">$sigrate[sigrate]</span>
  </tr></table>
<table width="100%">
  <tr>
    <td width="100%" class="alt2" align="$stylevar[left]"><p align="center"><span class="smallfont">$sigrate[signature]</span>
  </tr>
</table>

I don?t now where can I chance this.

PS: It would be interesting the option to disable the votes to only show the gallery of signatures of all users (a simple gallery of signatures), and also show only the images signatures, not text. Also the option to restrict users to not show their signature

EDIT: When I establish the n? of posts to be able to vote, always says that you should have X post to be able to vote, indifferently of the number of posts that one has.

[GrendelKhan{TSU]

great idea for a hack!

will try it out.

Originally Posted by trotskid

PS: It would be interesting the option to disable the votes to only show the gallery of signatures of all users (a simple gallery of signatures), and also show only the images signatures, not text. Also the option to restrict users to not show their signature

agreed. those would be awesome. (esp just a simple gallery of ALL users signatures -- perhaps votes tells which signature ranks highest in the list of sigs.)

[SirHappy]

klick Tagged nice work!

[sebil]

same problem

Originally Posted by trotskid

Now working fine with the upgrade. Thanks!

<form action="sig.php?do=addvote" name="vbform" method="post">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="alt1" align="$stylevar[left]" width="10%" id="u$sigrate[userid]">
      <p align="center"><a   href="member.php?$session[sessionurl]u=$sigrate[userid]">$sigrate[username]</a>
    <td width="10%" class="alt2" align="$stylevar[left]">
      <p align="center"><input type='radio' name='sigrate' value='$sigrate[userid]'>
    <td class="alt1" width="10%" align="$stylevar[left]">
      <p align="center"><span class="smallfont">$sigrate[sigrate]</span>
  </tr></table>
<table width="100%">
  <tr>
    <td width="100%" class="alt2" align="$stylevar[left]"><p align="center"><span class="smallfont">$sigrate[signature]</span>
  </tr>
</table>

I don?t now where can I chance this.

PS: It would be interesting the option to disable the votes to only show the gallery of signatures of all users (a simple gallery of signatures), and also show only the images signatures, not text. Also the option to restrict users to not show their signature

EDIT: When I establish the n? of posts to be able to vote, always says that you should have X post to be able to vote, indifferently of the number of posts that one has.

[TimberFloorAu]

I edited ours to look like this. Template sigratebit

<form action="sig.php?do=addvote" name="vbform" method="post">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="tcat" align="$stylevar[left]" width="10%" id="u$sigrate[userid]">
      <p align="center"><a href="member.php?$session[sessionurl]u=$sigrate[userid]">$sigrate[username]</a>
    <td width="10%" class="alt2" align="$stylevar[left]">
      <p align="center"><input type='radio' name='sigrate' value='$sigrate[userid]'>
    <td class="alt1" width="10%" align="$stylevar[left]">
      <p align="center"><span class="smallfont">$sigrate[sigrate]</span>
  </tr></table>
<table width="100%">
  <tr>
    <td width="100%" class="alt2" align="$stylevar[left]"><p align="center"><span class="smallfont">$sigrate[signature]</span>
  </tr>
</table>

[TimberFloorAu]

Tried reimporting the product we now get database error, even though we uninstalled this product.

Database error in vBulletin 3.8.2:

Invalid SQL:
ALTER TABLE yobromofuser ADD `sigrate` VARCHAR(100) NOT NULL;

MySQL Error   : Duplicate column name 'sigrate'
Error Number  : 1060
Request Date  : Wednesday, June 24th 2009 @ 08:14:11 AM
Error Date    : Wednesday, June 24th 2009 @ 08:14:11 AM
Script        : http://www.somesite.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.somesite.com/forum/admincp/plugin.php?do=productadd
IP Address    : xx.xxx.xx.xxx
Username      : ADMINUSER
Classname     : vB_Database
MySQL Version : 4.1.22-standard

Have checked phpmyadmin, cannot find table prefix sigrate or sigyou.

Any suggestions please

[juan71287]

Thanks a lot, installed

[trotskid]

Uninstalled (no upgrades).

PS: Thanks TimberFloorAu for your template.