vb.org Archive - Miscellaneous Hacks - Yet Another Awards System

Page 8 of 14

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Miscellaneous Hacks - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=187600)

CypherSTL

09-28-2008 09:42 PM

Quote:

Originally Posted by stickskills (Post 1632528)

Any idea on when the update would come that would be dealing with points per award, and maybe other things?

Most likely next week. I've got a busy week coming up with IT contracts.

stickskills

09-28-2008 10:33 PM

No problem at all, just looking for a tentative date. Thanks!

Delazar

09-29-2008 10:19 AM

Quote:

Originally Posted by Delazar (Post 1624719)

hi,

after the last updates to 4.0 in the awards system, we found several bugs. Urgently, we need help. I?m writing in the acp an html code

PHP Code:


		
			
[list][*]text[/list]

it shown as http://my.home.com/award.php. In the member profile the html code is not shown.

I?m writing in the acp an code <ul><li>text</li></ul> is not shown in http://my.home.com/award.php. In the member profile the html code it shown.
How can we correct this mistake?
The second question is: Why the awards are not show in the memberlist?

What is with this problem?

regard
Delazar

CypherSTL

09-29-2008 10:45 AM

Quote:

Originally Posted by Delazar (Post 1632966)

What is with this problem?

regard
Delazar

Screenshots would be nice, since I have no idea what problem you're having.

As for the member list, I removed it.

Delazar

09-29-2008 11:57 AM

Quote:

Originally Posted by CypherSTL (Post 1632979)

Screenshots would be nice, since I have no idea what problem you're having.

Hello CypherSTL,

her the screenshots:

maleficarum

09-29-2008 02:05 PM

Sweet, installed!

CypherSTL

09-29-2008 08:15 PM

Quote:

Originally Posted by Delazar (Post 1633021)

Hello CypherSTL,

her the screenshots:

Thank you for the screenshots, let me look into that issue a bit further and try to find out whats up.

jmurrayhead

09-29-2008 09:34 PM

Not sure if this has been mentioned yet, but the support link for 4.0 (clicking the product name in the product manager) still points to the old thread for 2.1.4.

CypherSTL

09-29-2008 09:44 PM

Quote:

Originally Posted by jmurrayhead (Post 1633449)

Not sure if this has been mentioned yet, but the support link for 4.0 (clicking the product name in the product manager) still points to the old thread for 2.1.4.

Might want to go ahead and grab the newest release on YaAS. That was fixed in our last update.

jmurrayhead

09-29-2008 10:40 PM

Quote:

Originally Posted by CypherSTL (Post 1633462)

Might want to go ahead and grab the newest release on YaAS. That was fixed in our last update.

Now there's an idea! Didn't even notice it was upgraded to 4.0.1 :p

Pixel-Peeps

09-29-2008 11:08 PM

Great work this is my fave MOD! !

masterross

09-29-2008 11:10 PM

Quote:

Originally Posted by Xanlamin (Post 1606910)

Originally Posted by masterross https://vborg.vbsupport.ru/external/2011/11/11.gif

Hello,

Thanks for 3.7.x release but it still has the same not indexing joins:

this is only for 10min works!

This will be fixed in the next release.

The problem still exist....

Code:

[--] Up for: 16m 54s (56K q [55.506 qps], 2K conn, TX: 2B, RX: 14M)

[--] Reads / Writes: 83% / 17%

[--] Total buffers: 602.0M global + 5.7M per thread (250 max threads)

[OK] Maximum possible memory usage: 2.0G (49% of installed RAM)

[OK] Slow queries: 0% (0/56K)

[OK] Highest usage of available connections: 3% (8/250)

[OK] Key buffer size / total MyISAM indexes: 64.0M/178.0M

[OK] Key buffer hit rate: 99.5% (2M cached / 14K reads)

[OK] Query cache efficiency: 59.5% (28K cached / 47K selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)

[!!] Joins performed without indexes: 353

[OK] Temporary tables created on disk: 5% (98 on disk / 1K total)

[OK] Thread cache hit rate: 99% (8 created / 2K connections)

[OK] Table cache hit rate: 95% (238 open / 248 opened)

[OK] Open file limit used: 4% (431/10K)

[OK] Table locks acquired immediately: 99% (45K immediate / 45K locks)

CypherSTL

09-30-2008 04:07 AM

Quote:

Originally Posted by masterross (Post 1633527)

The problem still exist....

Code:

[--] Up for: 16m 54s (56K q [55.506 qps], 2K conn, TX: 2B, RX: 14M)

[--] Reads / Writes: 83% / 17%

[--] Total buffers: 602.0M global + 5.7M per thread (250 max threads)

[OK] Maximum possible memory usage: 2.0G (49% of installed RAM)

[OK] Slow queries: 0% (0/56K)

[OK] Highest usage of available connections: 3% (8/250)

[OK] Key buffer size / total MyISAM indexes: 64.0M/178.0M

[OK] Key buffer hit rate: 99.5% (2M cached / 14K reads)

[OK] Query cache efficiency: 59.5% (28K cached / 47K selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)

[!!] Joins performed without indexes: 353

[OK] Temporary tables created on disk: 5% (98 on disk / 1K total)

[OK] Thread cache hit rate: 99% (8 created / 2K connections)

[OK] Table cache hit rate: 95% (238 open / 248 opened)

[OK] Open file limit used: 4% (431/10K)

[OK] Table locks acquired immediately: 99% (45K immediate / 45K locks)

Where are you seeing that at?

masterross

09-30-2008 08:44 AM

u can see in any any mysql stats.
but I suggest using:
http://wiki.mysqltuner.com/MySQLTuner

for better visualization

regards

CypherSTL

09-30-2008 10:39 AM

Code:

-------- Performance Metrics -------------------------------------------------

[--] Up for: 103d 6h 0m 40s (6M q [0.772 qps], 501K conn, TX: 295B, RX: 1B)

[--] Reads / Writes: 82% / 18%

[--] Total buffers: 34.0M global + 2.7M per thread (100 max threads)

[OK] Maximum possible memory usage: 729.8M (36% of installed RAM)

[OK] Slow queries: 0% (0/1K)

[OK] Highest usage of available connections: 3% (3/100)

[OK] Key buffer size / total MyISAM indexes: 200.0M/11.0M

[!!] Key buffer hit rate: 22.1% (10K cached / 8K reads)

[!!] Query cache efficiency: 14.3% (27 cached / 189 selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 30 sorts)

[OK] Temporary tables created on disk: 4% (3 on disk / 63 total)

[OK] Thread cache hit rate: 94% (3 created / 59 connections)

[OK] Table cache hit rate: 39% (865 open / 2K opened)

[OK] Open file limit used: 44% (1K/3K)

[OK] Table locks acquired immediately: 100% (1K immediate / 1K locks)

[OK] InnoDB data size / buffer pool: 12.4M/24.0M

I don't see that here.

liwo	09-30-2008 06:32 PM

Quote:

Originally Posted by masterross (Post 1633527)

The problem still exist....

Code:

[--] Up for: 16m 54s (56K q [55.506 qps], 2K conn, TX: 2B, RX: 14M)

[--] Reads / Writes: 83% / 17%

[--] Total buffers: 602.0M global + 5.7M per thread (250 max threads)

[OK] Maximum possible memory usage: 2.0G (49% of installed RAM)

[OK] Slow queries: 0% (0/56K)

[OK] Highest usage of available connections: 3% (8/250)

[OK] Key buffer size / total MyISAM indexes: 64.0M/178.0M

[OK] Key buffer hit rate: 99.5% (2M cached / 14K reads)

[OK] Query cache efficiency: 59.5% (28K cached / 47K selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)

[!!] Joins performed without indexes: 353

[OK] Temporary tables created on disk: 5% (98 on disk / 1K total)

[OK] Thread cache hit rate: 99% (8 created / 2K connections)

[OK] Table cache hit rate: 95% (238 open / 248 opened)

[OK] Open file limit used: 4% (431/10K)

[OK] Table locks acquired immediately: 99% (45K immediate / 45K locks)

That means that there are some indexes missing for a table that is used in a join. I had a quick look at the tables and think I found the missing indexes.

So please do a backup of your database and run the following MySQL querys (adding a table prefix as necessary):

Code:

ALTER TABLE `award_user` ADD INDEX `award_id` ( `award_id` )

Code:

ALTER TABLE `award_user` ADD INDEX `userid` ( `userid` )

These two statements create the probably missing indexes.

Code:

OPTIMIZE TABLE `award_user`

This statement actually fills the newly created indexes with the necessary data.

After doing this, check if the problem persists. If I guessed right it doesn't. ;)

masterross

10-01-2008 10:51 AM

Quote:

Originally Posted by liwo (Post 1634106)

Code:

ALTER TABLE `award_user` ADD INDEX `award_id` ( `award_id` )

Code:

ALTER TABLE `award_user` ADD INDEX `userid` ( `userid` )

These two statements create the probably missing indexes.

Code:

OPTIMIZE TABLE `award_user`

This statement actually fills the newly created indexes with the necessary data.

After doing this, check if the problem persists. If I guessed right it doesn't. ;)

Thanks bro!
Now it's much better!
But some indexes are still missing:

Code:

[--] Up for: 6h 1m 4s (2M q [112.642 qps], 106K conn, TX: 3B, RX: 552M)

[--] Reads / Writes: 82% / 18%

[--] Total buffers: 602.0M global + 5.7M per thread (250 max threads)

[OK] Maximum possible memory usage: 2.0G (49% of installed RAM)

[OK] Slow queries: 0% (0/2M)

[OK] Highest usage of available connections: 9% (24/250)

[OK] Key buffer size / total MyISAM indexes: 64.0M/175.9M

[OK] Key buffer hit rate: 100.0% (118M cached / 46K reads)

[OK] Query cache efficiency: 66.6% (1M cached / 2M selects)

[OK] Query cache prunes per day: 0

[OK] Sorts requiring temporary tables: 0% (103 temp sorts / 140K sorts)

[!!] Joins performed without indexes: 132

[OK] Temporary tables created on disk: 7% (3K on disk / 49K total)

[OK] Thread cache hit rate: 99% (24 created / 106K connections)

[OK] Table cache hit rate: 84% (347 open / 413 opened)

[OK] Open file limit used: 5% (539/10K)

[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)

liwo	10-01-2008 07:09 PM

I found another one that should propably be added:

Code:

ALTER TABLE `award` ADD INDEX `award_cat_id` ( `award_cat_id` )

Again, optimize table to fill the index:

Code:

OPTIMIZE TABLE `award`

That's all I spotted now. To further track down the issue I would suggest to turn on slow query log on the mysql server and enable the option "log-queries-not-using-indexes", which logs the querys to the slow query log. If you are on shared hosting, ask your provider to enable these options for you (normally they do such things as you are about to take load off their server ;) ). If you run your own server I hope you know how to do this :P (if not, have a look at the documentation on mysql.com, search for the options and add them to my.cnf)

Medar

10-01-2008 08:35 PM

Question on this mod...I have a previous version installed but am about to drop this one in place and upgrade. Mine is also fairly modified to suit our needs. One thing I am working on is creating a page that would pull users based on their group, display their registered date, and display their awards. IE -

Person 1 . . . . . 08/08/2008 . . . . . AWARD 1 - AWARD 2 - AWARD 5
Person 3 . . . . . 08/12/2008 . . . . . AWARD 1
Person 4 . . . . . 08/15/2008 . . . . . AWARD 2 - AWARD 5
Person 9 . . . . . 08/18/2008 . . . . . AWARD 1 - AWARD 2 - AWARD 5

I have the page already showing everything but the awards...and just started looking at the code for that. Fairly heavy SQL query...anyone have any quick idea on how that would look?

masterross

10-01-2008 10:29 PM

Quote:

Originally Posted by liwo (Post 1634934)

To further track down the issue I would suggest to turn on slow query log on the mysql server and enable the option "log-queries-not-using-indexes", which logs the querys to the slow query log.

Hi,

Thank for the advice!
I've enabled slow query log with log-queries-not-using-indexes but how to find out where are the missing indexes?
It store almost all queries :confused:

vigliarolo12

10-01-2008 10:56 PM

Not Found
The requested URL /forums/admincp/award.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

--------------------------------------------------------------------------------

Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/4.4.8 Server at aox-gaming.com Port 80

ya i got this

help me plz

the edit settings works but the 4 parts under it doesnt

Derek

10-02-2008 09:31 PM

I've found the phrases in the search phrase thing, but I can't edit it. I click on the edit link and there's no place for me to edit the actual template so I can change the outgoing PM.

AzzidReign

10-03-2008 10:03 AM

Installed/upgraded and working fine (from the looks of it)! THANKS!

liwo	10-03-2008 05:27 PM

Quote:

Originally Posted by masterross (Post 1635099)

Hi,

Thank for the advice!
I've enabled slow query log with log-queries-not-using-indexes but how to find out where are the missing indexes?
It store almost all queries :confused:

You probably have a serious problem with your database ;)

To find the querys without indexes, you could try to increase the slow query time, so that less querys get logged. Another aproach might be the tool mysqldumpslow referenced in the mysql documentation.

I haven't done such things myself yet, so I can not really help you here any further...

Kaleem

10-03-2008 06:35 PM

While upgrading do we have to add tables ourselves or product is doing it?`

FazerPaint

10-04-2008 06:22 PM

Is there anyway to make this post a new thread when a user is given an award, I would like to tell every member that someone has recieved an award.

Sorry if this has already been asked.........noobie here

Xanlamin

10-04-2008 08:45 PM

You can have the thread created in a public forum if you wanted instead of a private one and have it where only certain usergroups can post in that thread. This way everyone can see that someone is up for an award and see the outcome but not comment/post...unless you allow them to.

This is already built in minus the thread/forum permissions.

k_v	10-06-2008 05:57 PM

in template awards_request_formanswers
change

HTML Code:

[url=$vboptions[bburl]/awards.php#award$award[award_id]][img]https://vborg.vbsupport.ru/[/img][/url]

HTML Code:

[url=$vboptions[bburl]/awards.php#award$award[award_id]][img]$vboptions[bburl]/$award[award_img_url][/img][/url]

(not show picture of award if using relative path to image in award settings (images/medals/image.gif))

Hanany95

10-08-2008 02:09 AM

So can this mod enable the feature of like giving posting rewards and others.

Xanlamin

10-08-2008 03:52 AM

Quote:

Originally Posted by Hanany95 (Post 1639887)

So can this mod enable the feature of like giving posting rewards and others.

Not as of yet.

CypherSTL

10-08-2008 04:18 AM

I'm currently putting some finishing touches on another release of the awards system. The upcoming version is just some bug fixes, no new features as of yet. I'll try to get this released before Friday, but I'll be leaving Friday to go camping for the weekend.

I'll see what I can do for everyone.

I am planning on re-adding the ability to display awards on the Member's List, but that's another release or so away, as well as some other new features.

alianalyssasmom

10-08-2008 04:03 PM

Ok sorry I am so new at this, but I have downloaded it, now what do I do to get it working??

I have just inherited the boards and have not been admin before so I need a bit of help...............

thanks SO much

PERFORMANCE

10-08-2008 09:05 PM

thank you for the nice mod,

gamerfu

10-09-2008 09:41 PM

This should be fixed... ;)

The "My Awards" in postbit/profile shows oldest to newest, but should display newest to oldest. :cool:

Hanany95

10-10-2008 02:43 AM

bUT CAN WE LIKE NAME AWARDS AND ASSIGN THEM TO PEOPLE.

logicuk

10-10-2008 07:38 PM

Is there a way to remove the border from the medal box in the postbit?

logicuk

10-12-2008 06:43 PM

anyone?

Netunt

10-12-2008 07:08 PM

Not sure. Check in the templates to see if it is set as a border. If it is, change the width to 0 px.

katie hunter

10-13-2008 04:43 AM

I've asked Xanla if this is doable so i am not sure but it is a nice idea =]

------------
Hey,

I have a question regarding to the award system, is it possible to have multi pages, i mean each page can may be have 20 awards or so ?

masterross

10-13-2008 11:26 AM

Another error:

$total_awards = mysql_num_rows($alluserawards);
while ($award = $db->fetch_array($alluserawards))
{

should be:

$total_awards = $db->num_rows($alluserawards);
while ($award = $db->fetch_array($alluserawards))
{

All times are GMT. The time now is 08:10 AM.

Page 8 of 14

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01967 seconds Memory Usage 1,852KB 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 (13)bbcode_code_printable (2)bbcode_html_printable (1)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: