vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Yet Another Awards System 2.1.4 (https://vborg.vbsupport.ru/showthread.php?t=142487)

MikeSF 05-17-2007 05:32 PM

Suggestions:-
  • Define who can give awards exactly, by user ID (E.G: 1,3,4) - This will allow these users to give awards. This will also prevent admins having to give rights to 'every mod' to be able to give and remove awards.
  • In threads that are created, people who are allowed to give awards can see a quick link, which will automatically give the requesting user the badge (with predefined settings). E.G: Having an 'Automated Award Settings' section, which you decide whether the user automatically gets a notification PM etc etc.

In conjuntion, this is a brilliant MOD. Well done and thank you :]

joshbond 05-18-2007 12:06 AM

Quote:

Originally Posted by masons (Post 1208637)
Can someone integrate this so it shows up in ZOINTS profiles too?

I'm having the same problem. Is there anyway to get this to show up in ZOINTS?

BTW, great mod! I love it. All my members are very excited about receiving their trophies!!!

http://www.photochopz.com/forum

bela-meaad 05-19-2007 01:54 AM

How can i delete the medal i gave to the member?

i can`t find that?

Thanks

MikeSF 05-19-2007 12:14 PM

Quote:

Originally Posted by bela-meaad (Post 1250564)
How can i delete the medal i gave to the member?

i can`t find that?


Thanks

In
Admin CP > Award System > Award Manager > Give award to user

If you look, it's below the form to give a user an award.
Choose the person you want, tick the box which is 'remove' and submit.

MsRachel 05-28-2007 03:34 AM

okay..ive read though all 9 pages..its been a long weekend..so sorry for the stupid questions..! someone already asked how to display the metals with the users profile when they post..and someone said to change the postbit. Can someone tell me what the codes are and what to do..? i got confused a few pages back and im not that patient (thats why im asking for help)..thanks so much..!!

also, how can you create a seperate page where people can vote and the boxes to put answers in..? we've seen it done on other sites. thanks

Pearl 05-28-2007 04:54 AM

You need to change either postbit or postbit_legacy depending on what your forum is set to.

Pic i uploaded is legacy, I cahnged some of the code to fit the needs of my style but the original code you need to add in postbit is
Code:

<!-- show awards -->
<if condition="$post[showuserawards]">
<div class="info"><legend><a href="member.php?u=$post[userid]#award" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]#award" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</div>
</if>
<!-- /show awards -->

as u can see on my pic its underneath everything else it can be anywhere in the postbit .

enable votes in vbulltin options, create a new forum and use the forum id in the options of yaas settings.

VenomMaster 05-31-2007 07:11 AM

Hi there!

fist, let me say "Thanks" for this really great mod.

Second, i got a question: Is it possible to show a list of Awards on another page (actually i try ant combine your hack with the "Customizable Roster"-hack)?

Thanks in advance,

Venom

odinzu 06-03-2007 01:12 AM

EDIT: I Need to know how to edit the style of the award in the postbit legacy. I want to change the border. Here is an example of my postbit: Linky

o0Hubba0o 06-03-2007 02:58 AM

I've used this before on my graphics and have been wanting to get it on my gaming site to give game awards (for contests in diablo, wow, etc). Only downloaded so far will install in a bit, I just have to create my custom awards first. ;)

Hope I have better luck than it sounds like others are having.

VenomMaster 06-04-2007 07:37 AM

Quote:

Originally Posted by VenomMaster (Post 1258192)
Hi there!

fist, let me say "Thanks" for this really great mod.

Second, i got a question: Is it possible to show a list of Awards on another page (actually i try ant combine your hack with the "Customizable Roster"-hack)?

Thanks in advance,

Venom

No one? I really need this...

daviblight 06-04-2007 01:44 PM

i just an odd error...

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE 1=1
AND post.postid IN (0,1331380,1331426,1331429,1331508,1331510,1331542 ,1331851,1334085,1334399,1334432,1334436,1334446,1 334460,1334503,1334505,1334614,1334806,1335043,133 8530,1338533,1338581,1338616,1338693,1342940,13429 68,1344396)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Unknown column 'a.award_id' in 'on clause'
Error Number : 1054
Date : Monday, June 4th 2007 @ 09:42:07 AM
Script : http://www.conceptart.org/forums/showthread.php?t=98016
Referrer : http://www.conceptart.org/forums/forumdisplay.php?f=2
IP Address : 66.72.161.124
Username : davi
Classname : vb_database

IR15H 06-10-2007 10:02 PM

I installed and it all seemed to go well, however when I give someone a medal I get the following error;

Quote:

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in \admincp\award.php on line 581
It gives the award anyway, and appears in memberlist/posbit but when I try to view a member's profile it returns a white screen. I saw someone else mis edited the MEMBERINFO template, so I double checked mine and it was correct. I even reverted it to it's original state and tried clicking the profile anyway (assuming I'd see the user profile but no award stuff), but that still gave a white screen. When I remove the user's medal I can see their profile again. This is on 3.6.7. Help?

santimariani 06-11-2007 05:04 PM

This may seem like a dumb question, but...

How do I get to the Awards List page? I can't seem to find it anywhere.

Thanks!

EDIT: Found it. It's amazing what looking well for something will do.

IR15H 06-13-2007 10:05 AM

Well, it's been over 24 hours so I guess it's ok to bump...

Quote:

Originally Posted by IR15H (Post 1265781)
I installed and it all seemed to go well, however when I give someone a medal I get the following error;

Code:

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in \admincp\award.php on line 581
It gives the award anyway, and appears in memberlist/posbit but when I try to view a member's profile it returns a white screen. I saw someone else mis edited the MEMBERINFO template, so I double checked mine and it was correct. I even reverted it to it's original state and tried clicking the profile anyway (assuming I'd see the user profile but no award stuff), but that still gave a white screen. When I remove the user's medal I can see their profile again. This is on 3.6.7. Help?


PoetJA-1975 06-15-2007 08:43 AM

Thanx very much MTHA for this modification.
Planning on making it a Major Feature on JPiC
**INSTALLED**

Jacquii.

masons 06-17-2007 10:41 PM

Several things that could possible make a good add-on to this amazing mod.

Could you please make it possible for members to know about the different awards that are available in an area that they can readily access it should they desire to do so.

Can this area also have a recommend an award to someone area so that if someone wants to make a recommendation, they can.

Can we have a "Hall of Honor" to display those people who have won awards.

Can we also have something saying that we are prepared to make up a new award should there be a need recommended through PM to admins.

Let me know what you think!

BigDog56 06-19-2007 02:58 PM

Got it working, great mod, was looking for this one! Thank you very much!

kennethsia 06-21-2007 02:30 PM

works fully functional on 3.6.5 please guys follow all the steps, upload files. upload product. DO the styles edit first. then start messing with the awards. test it out before u start editing the settings. great great mod.

wrang 06-26-2007 05:52 PM

Witch database prefix do this mod upload
I want to delete it from my database

is this the thing or is it more?
vb3_award
vb3_award_cat
vb3_award_user

powerful_rogue 06-26-2007 07:17 PM

Any idea where to get the really small award icons? Ive searched high and low and can only find the large ones.

The Ottoman 06-26-2007 08:32 PM

How would I go about changing the Memberinfo page to show the large awards (AwardImage) in place of the small awards (AwardIcon)?

PHP Code:

<tr>
   <
td align="center">
    
$userawards
   
</td>
</
tr

That is the part of the code that displays the small award, what would be the variable to show the large one?


Thanks

powerful_rogue 06-26-2007 11:24 PM

https://vborg.vbsupport.ru/

Hi, At present when an award is given it will show at position number 2. Is it possible, and if so how - to make it show up at position number 1?

Reason being, I have this vast amount of space there, and it would be very useful to show the awards in that section. Im really hoping there is a way of doing this that someone knows.

Many Thanks

Dave

Mrdby 06-27-2007 01:25 AM

so anybody using it with 3.6.7?

mktrilogy 06-27-2007 07:19 AM

using 3.6.7 here

chatzworld 06-27-2007 08:21 AM

same here :)

powerful_rogue 06-28-2007 09:07 AM

Quote:

Originally Posted by powerful_rogue (Post 1277327)
https://vborg.vbsupport.ru/

Hi, At present when an award is given it will show at position number 2. Is it possible, and if so how - to make it show up at position number 1?

Reason being, I have this vast amount of space there, and it would be very useful to show the awards in that section. Im really hoping there is a way of doing this that someone knows.

Many Thanks

Dave


Anyone able to oblige with the above at all please :o

The Ottoman 06-29-2007 12:50 AM

Quote:

Originally Posted by powerful_rogue (Post 1278311)
Anyone able to oblige with the above at all please :o


try putting it between
PHP Code:

<if condition="$post['rank']"><div class="smallfont">$post[rank]</div></if>
<--
put award stuff here-->
</
td>
<
td width="100%">&nbsp;</td>
<
td valign="top" nowrap="nowrap">
 
<
div class="smallfont">
<if 
condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if> 


BANDiT600 06-29-2007 09:42 PM

If I give to user award in second time PM not sending!!!
Where to delete user from award?

kennethsia 06-30-2007 04:00 AM

is this heavy on the resources?

The Ottoman 07-01-2007 04:44 AM

Quote:

Originally Posted by kennethsia (Post 1279627)
is this heavy on the resources?


I haven't noticed a problem with it.

Silvio 07-07-2007 09:57 PM

ty mta for this great mod i'm using it from last version and is really gorgeous.

now i've upgraded to 3.6.x version and i enabled a setting i did not used on last version so i cant say if is the same issue.

issue : phrases not working (after install they doesnt exists and nor create them) at least from cp options
Enter the userID of the User you would like to appear as sender of the Congratulation PM and/or Email.
Leave it "0" to use userid of the one who issue award
To edit the PM Content, click here, to edit the Subject click here.



i guess the problem is here
Code:

To edit the PM Content, click <a href="phrase.php?do=edit&amp;e[3000][award_pm]">here</a>, to edit the Subject click <a href="phrase.php?do=edit&amp;e[4000][award_pm]">here</a>.]]></phrase>
how is possible to fix that?

pls accept apologises for my terrible english

take care
ciao

es-league.com 07-10-2007 06:42 AM

Think I have an error that I hope someone can help with...

I have noticed that only some of the award winning members
have medals displayed in their posts ?

Although the medals are clearly given in the admin cp
and showing as awarded on a particular date,
they even show up in each players user cp but not always
in the posts and threads...

seems a bit random , any ideas ?

Taios 07-12-2007 10:53 AM

Question:
How do i get the medals to be as big as the medals in this forum?
http://www.global-army.com/forum/sho...=9253#post9253

I mean like. When the user posts, they are much bigger. Atm, my forum only shows a minute of the actual thing.

EDIT : figured it out. Just need to do some edits now i guess to change the position fo where its shown :)

katie hunter 07-13-2007 08:34 PM

Hi I have a small question in the award how can i edit this part ? Name / Description

I want to stretch it more a little or add more words to it other then Name / Description

http://forum.nihonomaru.com/awards.php

Thanks

Simetrical 07-16-2007 06:12 PM

This is a nice mod. Unfortunately, it crashed my site when this query was run repeatedly during a period of high load (23 times over, running between 78 and 208 seconds, as of just before I started killing them):
Code:

mysql> EXPLAIN SELECT a.*, au.*, post.userid, post.postid
    ->                        FROM post AS post
    ->                        INNER JOIN award_user AS au ON (au.userid=post.userid)
    ->                        INNER JOIN award AS a ON (a.award_id=au.award_id)
    ->                        WHERE 1=1
    ->
    ->
    ->                        GROUP BY au.issue_id
    ->                        ORDER BY au.issue_time DESC;
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
| id | select_type | table | type  | possible_keys | key    | key_len | ref                    | rows  | Extra                          |
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
|  1 | SIMPLE      | au    | ALL    | NULL          | NULL    | NULL    | NULL                    |  117 | Using temporary; Using filesort |
|  1 | SIMPLE      | a    | eq_ref | PRIMARY      | PRIMARY | 2      | totalwar_vb.au.award_id |    1 | Using where                    |
|  1 | SIMPLE      | post  | ref    | userid        | userid  | 4      | totalwar_vb.au.userid  | 25005 | Using where                    |
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
3 rows in set (0.00 sec)

While I'm no MySQL expert, it seems that this attempts to copy the entirety of the post table to a temporary table, in my case about 1.5 million rows. I've tracked the query down to the showthread_query hook:
PHP Code:

        // Obtain list of awards for current user
        
$alluserawards =  $db->query_read("
            SELECT a.*, au.*, post.userid, post.postid 
            FROM " 
TABLE_PREFIX "post AS post
            INNER JOIN " 
TABLE_PREFIX "award_user AS au ON (au.userid=post.userid)
            INNER JOIN " 
TABLE_PREFIX "award AS a ON (a.award_id=au.award_id)
            WHERE 1=1 
"
iif((!empty($ids)), "AND post.postid IN (0" $ids ")") ."
"
iif((!empty($cache_postids)), "AND post.postid IN (" $cache_postids ")") ."
            GROUP BY au.issue_id
            
$awardsdisplayorder
        "
);

        while( 
$ua $db->fetch_array($alluserawards))
        {
            
$userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
        }
        
$db->free_result($alluserawards); 

Apparently this fails to account for the possibility that $ids and $cache_postids are both empty. I have no idea why it would or would not be reasonable to account for that, because I don't know what either of those variables is, but at any rate, if they both are empty things are not very good. I've wrapped the whole thing in a conditional checking whether both are empty, just not setting anything if they both are. I'd appreciate any response.

letsjoy 07-16-2007 09:41 PM

thanks alot

kartik786 07-18-2007 08:48 PM

thanks a lot.. im going to give it a try soon

malluroses 07-19-2007 09:56 AM

Thanks a lot yaar

The Librarian 07-19-2007 09:43 PM

I've got this mod working but I've got two items I need help fixing:

1) I need to re-arrange the order members are listed on the Awards page. They seem to be listed by MemberID # (order of registration) but I want them in Alphabetical order.

and

2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Oh, and btw, I corrected the English on the PM message. It should be "Congratulations" (with an "s") and "upon receiving" instead of "as you are receiving".

Thanks!

The Librarian 07-20-2007 07:59 PM

More about #2 above:
Quote:

Originally Posted by The Librarian (Post 1296069)
2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Here's the deal... when I try to award another user (5peaches) I get "you have successfully given MA'AM the award"- so it's giving 5peaches award to MA'AM... and then if I try to give MA'AM an award I get this error message:
Quote:

Invalid SQL:

SELECT userid, username
FROM vb_user
WHERE username = 'MA'AM';

MySQL Error : 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 'AM'' at line 3
Error Number : 1064
Date : Thursday, July 19th 2007 @ 08:43:42 PM
Script : http://www.website.com/forum/admincp...do=dogiveaward
Referrer : http://www.website.com/forum/admincp...ers&award_id=9
I'm sure it's because of the appostrophe... does anybody have a fix for this, please?!


All times are GMT. The time now is 11:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01829 seconds
  • Memory Usage 1,867KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (3)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete