vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - vBCredits - Ultimate Points System (https://vborg.vbsupport.ru/showthread.php?t=172399)

yeshoward 07-07-2009 12:10 PM

Hi
we have a ads board and we want members need to "spend" X points per classified ads they post there, possible for your module? so posting is actually deducting points instead of earning

imported_silkroad 07-07-2009 12:51 PM

Yes, it certainly possible (anything is possible!)

If you want to see this in action, visit this link and try to post a "New Thread" as a registered user.

imported_silkroad 07-07-2009 12:56 PM

Hi Dark,

Any idea why this vbcredits query appears so many times in the mysql-slow.log (low query log)? This vbcredits query dominates our slow queries log (slow query time is a big 10 sec). Not sure why.

Stats from the last hour or so:

Quote:

Count: 10456 Time=0.00s (40s) Lock=0.00s (1s) Rows=0.0 (31),
SELECT award.*, award.fromuserid AS userid, user.* FROM credits_transactions AS award LEFT JOIN post AS post ON (award.postid = post.postid) LEFT JOIN user AS user ON (award.fromuserid = user.userid) LEFT JOIN thread AS thread ON (post.threadid = thread.threadid) WHERE award.action = 'S' AND award.completed = N AND thread.threadid = N ORDER BY award.postid ASC, award.timestamp DESC
Thanks.

imported_silkroad 07-07-2009 01:10 PM

Hi (again) Dark,

Nevermind, sorry. I see the issue. We have this set:

--log-queries-not-using-indexes

Command Line Format --log-queries-not-using-indexes Config File Format log-queries-not-using-indexes Option Sets Variable Yes, log_queries_not_using_indexes Variable Name log_queries_not_using_indexes Variable Scope Global Dynamic Variable Yes Deprecated 5.1.29, by slow-query-log Value Set Type boolean


If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. See Section 5.2.4, “The Slow Query Log”. This option does not necessarily mean that no index is used. For example, a query that uses a full index scan uses an index but would be logged because the index would not limit the number of rows.

sebil 07-07-2009 06:53 PM

hello..

i just installed this one ye.. and got this error.. with 3.7

Quote:

1||1246996131||92.25.91.29||do=options&dogroup=cre dits_global_settings||http://www.malludreams.com/forum/adm...v||Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.33 Safari/530.5Access Denied, you have been logged.
and with 3.6:-
iam getting this errror..

Quote:

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = prefixrequired
please helpp

lafsunlmtd 07-08-2009 02:43 PM

I've got a very large forum that runs on a cluster of multiple servers.. How does vbCredits run in a multiple server environment with over 425,000 members? Will we run into any problems using this system, or should everything work out alright?

Darkwaltz4 07-08-2009 05:27 PM

Quote:

Originally Posted by yeshoward (Post 1844459)
Hi
we have a ads board and we want members need to "spend" X points per classified ads they post there, possible for your module? so posting is actually deducting points instead of earning

you can set negative awards even per forum with the forum overrides system, but to make it require a positive number of credits to complete the action, youll need this addon:
http://www.vbcredits.com/forum/showthread.php?t=945

Quote:

Originally Posted by imported_silkroad (Post 1844477)
Hi (again) Dark,

Nevermind, sorry. I see the issue. We have this set:

--log-queries-not-using-indexes

Command Line Format --log-queries-not-using-indexes Config File Format log-queries-not-using-indexes Option Sets Variable Yes, log_queries_not_using_indexes Variable Name log_queries_not_using_indexes Variable Scope Global Dynamic Variable Yes Deprecated 5.1.29, by slow-query-log Value Set Type boolean


If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. See Section 5.2.4, ?The Slow Query Log?. This option does not necessarily mean that no index is used. For example, a query that uses a full index scan uses an index but would be logged because the index would not limit the number of rows.

admittedly, i need to learn optimal table indexing :(

Quote:

Originally Posted by sebil (Post 1844690)
hello..

i just installed this one ye.. and got this error.. with 3.7

and with 3.6:-
iam getting this errror..

please helpp

vbcredits isnt compatible with vbfirewall
to install on vb3.6, install the vb3.6 version of vbcredits instead

Quote:

Originally Posted by lafsunlmtd (Post 1845138)
I've got a very large forum that runs on a cluster of multiple servers.. How does vbCredits run in a multiple server environment with over 425,000 members? Will we run into any problems using this system, or should everything work out alright?

well, ive had several big board users with vbcredits tell me it works alright, in fact you can ask imported_silkroad about his experiences with it and im pretty sure hes got even more members :p

lafsunlmtd 07-08-2009 06:32 PM

hmmm.... it won't install on my master/slave server environ as is. it keeps trying to write to my slaves. I will try some other stuff and let you know if anything works.

Saviour 07-08-2009 07:17 PM

Not sure if this has been covered before...too many posts to search.

Anyway...

When purchasing raffle tickets, I noticed that you will receive an error if you hit the Enter key instead of clicking on Purchase. It causes a database error with the below message:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:
SELECT * FROM vb_credits_lottery WHERE lotteryid =;

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 '' at line 1
Error Number : 1064
Request Date : Wednesday, July 8th 2009 @ 02:43:33 PM
Error Date : Wednesday, July 8th 2009 @ 02:43:34 PM
Script : http://xxxxxxxx.com/forums/credits.php?do=lottery
Referrer : http://xxxxxxxx.com/forums/credits.php?do=manage
IP Address : [removed]
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.0.67-log

Is this a bug? Is there a fix?

bluecamosis 07-12-2009 11:36 AM

Hi, I have a question about this hack. I've successfully installed it on my forums and it's working perfectly fine. But I have a query.

Is there a way to calculate the total amount of credits for a particular user group? I have 4 different "teams" in my forum, and I'm thinking of displaying the total amount of credits each group has accumulated, but I'm not sure how to do that. Help will be greatly appreciated thanks! =)


All times are GMT. The time now is 01:40 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.02307 seconds
  • Memory Usage 1,758KB
  • 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)bbcode_code_printable
  • (7)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