vb.org Archive
Page 16 of 68 « First 61415 16 17182666 Last »
Show 40 post(s) from this thread on one page

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)

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 06:26 PM.
Page 16 of 68 « First 61415 16 17182666 Last »
Show 40 post(s) from this thread on one page

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.01359 seconds
  • Memory Usage 1,767KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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