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 - vBCredits - Ultimate Points System (https://vborg.vbsupport.ru/showthread.php?t=151924)

dai-kun 07-24-2007 11:28 PM

Can you look into the queries problem? I just noticed that with the product turned on, there's about an extra 9 queries, which is really bad.

can anyone else tell me if they have the same problem?

Darkwaltz4 07-24-2007 11:32 PM

Any particular page you are looking at? Unless you are doing mass moderation (like deleting many threads and posts at once) there should only be 1 extra query on everything. Even that I'm trying to get around without file edits.

dai-kun 07-24-2007 11:36 PM

I'm just refreshing my showthread page. It was 29 queries with it turned on, and 20 with it disabled.

I really don't know why since the only place your code show up is in the postbit... I tried removing it from postbit but it still shows up as 29 queries.

Darkwaltz4 07-24-2007 11:46 PM

Holy -- youre right. >.< Its calling the datastore on every post >.< i will correct the plugin this is in, and post you something. I didnt expect showthread to call fetch_foruminfo so many times :X gimme a sec

Darkwaltz4 07-25-2007 12:51 AM

Well, hate to do this to you all for like the 4th time, but another bugfix

IF you DONT use the forum overrides, then just disable the hook 'Forum Credit Override Application';

IF you DO use the forum overrides, then reupload the product. As a bonus, uninstall also deletes the datastore item that was added :-p (not that you were going to uninstall right?)

That should get rid of all of the extra queries, thanks for pointing it out :)

I will make it all up to you guys I promise :D...:'(
(maybe some vBCommerce screenshots posted on vbcredits.com in a little while?)

GekkoPixie 07-25-2007 12:59 AM

I am having a hard time making certain forums *not* impact the credits at all. Someone, for example, deleted a ton of posts in an area designated with all 0's (default turned off), and was reduced from 230 to -20 credits.

Darkwaltz4 07-25-2007 01:05 AM

Well mass-moderation stuff like that is generally a little server intensive, why do you think update counters has you set limits on users to process per run? Because its like 5 queries per person :-p Same thing here. I tried to keep it as small as possible whenever that happens.

The main problem this time was I did not think a certain function was called on every single post, which means a query I stuck in there was. I moved it out of that function and it works the same without that extra query every time.

Also, credits can go negative because it was the only way it can function as correctly as possible. By its very nature pretty much everything can be exploited. What if you made long posts for post size credits, bought something with them, and then trimmed your post to normal? It needs to go negative so at least they will pay back what they technically stole. Plus theres settable amounts for having a post deleted, so you could in fact punish users for writing something that got deleted, so making them work it back is kind of ideal.

GekkoPixie 07-25-2007 01:16 AM

The problem is that I only want credits - positive or negative - to work in certain forums, and that doesn't seem to be happening.

Darkwaltz4 07-25-2007 01:51 AM

It shouldnt be happening... check your global credit settings - is 'count credits where posts arent' set to no? I dont think I missed this setting, it was there since 1.0

Vesica: usergroup editor

PlymWS 07-25-2007 04:35 AM

Voted MOTM. The only thing missing that I would need is the ability to award a point for every attachment a user uploads. Hanging on for future updates with this implemented ;)


All times are GMT. The time now is 02:33 PM.

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.02283 seconds
  • Memory Usage 1,732KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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