vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - vbBux / vbPlaza v1.5.8 (Points + Store System) (https://vborg.vbsupport.ru/showthread.php?t=106953)

Sooner95 02-13-2006 07:25 PM

Quote:

Originally Posted by caimakale
Make sure that the corrupt account that you are removing isn't userid 1 unless you have it set differently in your /includes/config.php file. Did you check the database and clear the other flags area of the user table? I think that's where expiration info is stored. I could be wrong as I am not on my laptop with all of the files so I can't check at this point.

Well, it is userid 1, but i had another admin account, and have already added it tot he congif file. I went thru the tables in mysql.. and even reset the immunity table from 2 to 0, but it still did not work.

Sooner95 02-13-2006 07:25 PM

Quote:

Originally Posted by amykhar
Sooner, don't zap the account. Send me the login info for the forums and your phpmyadmin and I'll try to fix it for you. It's the least I can do for an active member of EA :)

Amy

Thx Amy..i'll pm you on EA when I get a chance..

shaynehammy 02-13-2006 07:26 PM

Thank you for that information. This version is now stable and safe to install?

Ohiosweetheart 02-13-2006 07:33 PM

I'm setting each of my usergroups' permissions... and I'm stumped on something.
Where it says discount rate and paycheck amount.... what are those and how do I set them? I mean, what do I set them to?

Thanks for any help

Sooner95 02-13-2006 08:02 PM

Quote:

Originally Posted by Ohiosweetheart
I'm setting each of my usergroups' permissions... and I'm stumped on something.
Where it says discount rate and paycheck amount.... what are those and how do I set them? I mean, what do I set them to?

Thanks for any help

Discount Rate, say you set it to 5.000 percent, then for whatever that Usergroup buys, it will take 5% off.

Paycheck, like for Mods, you set this to 10000, then every 2 weeks (default, this can be changed too) they will receive 10,000 points.

Hope this helps

Sooner95 02-13-2006 08:09 PM

Quote:

Originally Posted by shaynehammy
Thank you for that information. This version is now stable and safe to install?

I just had that one issue, which, according to some, it has been corrected. Everything else has worked just fine. Installing is a breeze, and well as settign it up.

Sooner95 02-13-2006 08:20 PM

Quick question about the Lotto Ending time.

Says this in my store..

Lottery Ends Approximately: 02-20-06, 11:21 AM

Says this in AdminCP

1140452512

How do these relate?

Ohiosweetheart 02-13-2006 08:24 PM

Quote:

Originally Posted by Sooner95
Discount Rate, say you set it to 5.000 percent, then for whatever that Usergroup buys, it will take 5% off.

Paycheck, like for Mods, you set this to 10000, then every 2 weeks (default, this can be changed too) they will receive 10,000 points.

Hope this helps

it does indeedy Sooner... thank you!

StarBuG 02-13-2006 08:27 PM

Ok I still have the empty category problem

I uninstalled the plugin and reinstalled it.

Still all categories are empty?

Did anyone solve this problem?? Any solutions?

Skyline_GT 02-13-2006 08:35 PM

Quote:

Originally Posted by Sooner95
Quick question about the Lotto Ending time.

Says this in my store..

Lottery Ends Approximately: 02-20-06, 11:21 AM

Says this in AdminCP

1140452512

How do these relate?

everything in seconds.

Ohiosweetheart 02-13-2006 08:38 PM

ut oh.... a member is trying to buy a gift for another member. I have the cost set at 1000 points. It's telling her that she doesn't have enough points to perform this action. But she has over 5,000 points....

what can I do?

bashy 02-13-2006 08:44 PM

Hi..

I have just tried this and got this error...

Code:

Error

SQL-query : 

ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'

MySQL said:


#1054 - Unknown column 'ebux' in 'user'

Any ideas please?
Is it cause its already been done?
If so... My Vbookie cash is still a seperate cash system, I was expecting it to
add all the vbookie cash to the ebux, no?

Quote:

Originally Posted by Ignignokt
Change the eBux field to ucash and then run the following SQL code:

Code:


ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'



Frugal 02-13-2006 08:57 PM

Quote:

Originally Posted by bashy
Hi..

I have just tried this and got this error...

Code:

Error
 
SQL-query :
 
ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'
 
MySQL said:
 
 
#1054 - Unknown column 'ebux' in 'user'

Any ideas please?
Is it cause its already been done?

Yes if you run the query a second time you will get that error because there is no longer an ebux field.
Quote:

If so... My Vbookie cash is still a seperate cash system, I was expecting it to add all the vbookie cash to the ebux, no?
You also need to go into the vbookie settings and enable ucash.

Frugal

bashy 02-13-2006 09:01 PM

It already is m8 :(
Should there still be Vbookie cash and ebux showing in the postbit?

Skyline_GT 02-13-2006 09:08 PM

I wonder are you planning to integrate paypal with this system?
buy points using real money??

Sooner95 02-13-2006 09:13 PM

Quote:

Originally Posted by Skyline_GT
everything in seconds.

oh.. lol

Request:

Can this be set up another way then? hehe.


I am having no luck with settign this..

Its based on seconds, like how many seconds till the end of the lotto?

I put in 302400, which is 1 week. But i get this date

Lottery Ends Approximately: 01-04-70, 07:00 AM

In the time active box, it has 604800, I assume means the lotto is up for 1 week?

Maybe i am just doing it wrong.

Ohiosweetheart 02-13-2006 09:28 PM

Quote:

Originally Posted by Ohiosweetheart
ut oh.... a member is trying to buy a gift for another member. I have the cost set at 1000 points. It's telling her that she doesn't have enough points to perform this action. But she has over 5,000 points....

what can I do?

Never mind, I found the answer. She banked so many points she didn't have enough to do anything with, LOL.

Frugal 02-13-2006 09:33 PM

Quote:

Originally Posted by bashy
It already is m8 :(
Should there still be Vbookie cash and ebux showing in the postbit?

You also need to make sure your template edit is for ebux not vbookie, the vbookie postbit template edit only shows vbookies own money vCash.

In the postbit after

Code:

$vbphrase[posts]: $post[posts]
You should have
Code:

<br />
<a href="estore.php?do=donate&amp;userid=$post[userid]">$vbphrase[ebux_points]</a>: $post[points]<br />
$vbphrase[ebux_bank]: $post[bank]<br />
$vbphrase[ebux_total_points]: $post[totalpoints]<br />

You should not have
Code:

<if condition="$vboptions['vbookiecashon']">
                                                <br />vCash: $post[vbookie_cash]
                                                </if>

Providing ebux is set to use the field ucash, the query has been run to change the ebux field to ucash, vbookie has been set to use ucash, and the postbit has the ebux changes and not the vbookie changes, all should work.

Frugal

JsnakeJ 02-13-2006 09:52 PM

Quote:

Originally Posted by caimakale
I don't follow you. When you integrate with uShop, you are only copying he points in the uShop column to the eBux column. There is no actual integration that occurs. After you have done it once, all of your users points from uShop should now be in eStore and you can just leave that setting alone. I even went as far as going in my database after that and deleting all of the utt, ucash, ushop fields I could find. Did you change the table name to conform with vbookie or something?

Well there must be some error with my eBux then. When I don't use uCash it gives out no points to my users yet the forums settings are set to multiply 1 times x for replys yet it gives them no points.

caimakale 02-13-2006 09:52 PM

Quote:

Originally Posted by Sooner95
oh.. lol

Request:

Can this be set up another way then? hehe.


I am having no luck with settign this..

Its based on seconds, like how many seconds till the end of the lotto?

I put in 302400, which is 1 week. But i get this date

Lottery Ends Approximately: 01-04-70, 07:00 AM

In the time active box, it has 604800, I assume means the lotto is up for 1 week?

Maybe i am just doing it wrong.

Its the unix time stamp. Basically in a nutshell it's the amount of seconds since 1/1/1970 and is a standard that is used when coding.

There is a simple conversion utility here. http://www.onlineconversion.com/unix_time.htm Just punch in the date and time you want and it will spit out the unix time stamp.

caimakale 02-13-2006 09:53 PM

Quote:

Originally Posted by JsnakeJ
Well there must be some error with my eBux then. When I don't use uCash it gives out no points to my users yet the forums settings are set to multiply 1 times x for replys yet it gives them no points.

Did you upgrade to 1.1.2 yet? There was a bug that should have been fixed in the new version. I will double check on my site to see if it was.

caimakale 02-13-2006 10:02 PM

Quote:

Originally Posted by caimakale
Did you upgrade to 1.1.2 yet? There was a bug that should have been fixed in the new version. I will double check on my site to see if it was.

It is all fixed on my site. Now when they post, not only do they get points per character, but they also get points for starting the thread and replying to it. Works as designed.

JsnakeJ 02-13-2006 10:03 PM

Going for the upgrade now.

shaynehammy 02-13-2006 10:08 PM

Quote:

Originally Posted by Ignignokt
Change the eBux field to ucash and then run the following SQL code:

Code:


ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'



Sorry, a little confused. Change what ebux field to ucash? In where?

I

caimakale 02-13-2006 10:11 PM

Quote:

Originally Posted by shaynehammy
Sorry, a little confused. Change what ebux field to ucash? In where?

I

In your AdminCP >> eBux Options >> Manage Settings. Towards the bottom you can change ebux to ucash.

JsnakeJ 02-13-2006 10:20 PM

My problems solved now. All I needed to run was that datastore option. :D

Sooner95 02-13-2006 10:25 PM

Quote:

Originally Posted by caimakale
Its the unix time stamp. Basically in a nutshell it's the amount of seconds since 1/1/1970 and is a standard that is used when coding.

There is a simple conversion utility here. http://www.onlineconversion.com/unix_time.htm Just punch in the date and time you want and it will spit out the unix time stamp.

Ah, ok sweet. Thanks for the info and bookmarked the link. Works for me!

docvader 02-13-2006 10:49 PM

Quote:

Originally Posted by caimakale
In your AdminCP >> eBux Options >> Manage Settings. Towards the bottom you can change ebux to ucash.

Now I'm confused, :)
If you have ucash, and you want to install ebux, I thought ebux was going to take the amount of points that already existed in the ucash tables, and put them into new ebux tables.

With that said, if you're also using vbookie, we now should keep the ucash tables, and not use the ebux system? Doesn't that interfere with the new estore hack?

Wouldn't it be "safer" to take the ucash points, put them into ebux, and then get rid of ucash, and change the vbookie hack to use the ebux tables?

I think, LOL. Now I'm lost! Glad you guys understand this. :speechless:

Frugal 02-13-2006 10:57 PM

Ok as it still keeps coming up and my original instructions are buried about 50 pages back here is a complete guide to making vbookie work with ebux. Section 1 assumes vbookie is already installed and ucash is not installed. If ucash is already installed go straight to section 2.

Maybe CMX can add this to the readme as it is such a common question.

Section 1 (vbbokie installed ucash not installed)
Ok here is how to integrate ebux and vbookie without having to edit the vbookie files.

Install eBux as per the readme.

Search for and remove the following if it exists in postbit and postbit_legacy templates

Code:

<if condition="$vboptions['vbookiecashon']">
                                                <br />vCash: $post[vbookie_cash]
                                                </if>


At this point you have 2 options which I will highlight bold and green, the bold option is for advanced users who are comfortable with running sql queries, if this does not describe you skip past this onto the green section. Once past the chosen section continue the normal text instructions.

Go to ACP >> Maintenance >> Execute SQL Query


Execute the following query


Code:

ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'



Go to AdminCP >> eBux Options >> Manage Settings and change Points Field Name to ucash (this option should be just over half way down the list.)



If you used the bold option skip past this green text. If you didn't feel comfortable messing with the sql then open /includes/functions_vbookie.php change all instances of ucash to eBux BEING CAREFUL NOT TO CHANGE ANY instance of vbookieucash. Remember to make these changes anytime a new version of vbookie is released.


Then go to ACP >> vBulletin Option >> vBookie Settings and set Enable uCash to yes

eBux and vBookie will now work together.

Section 2 ucash is already installed.

First remove ucash and vbookie edits to the postbit and postbit_legacy templates (or simply revert them if ucash and vbookie are your only postbit changes you have made).

Install eBux as per the readme

Go to AdminCP >> eBux Options >> uCash Integration >>click process

Go to AdminCP >> eBux Options >> Manage Settings and change Points Field Name to ucash (this option should be just over half way down the list.)

Go to the ucash settings and turn ucash off (don't uninstall it as this will remove the ucash field from the databse). If you really want to uninstall it you can but after you uninstall ucash you will need to run the SQL query mentioned in the bold section or make the file edits in the green section. If you don't uninstall ucash there is no need to run the query or edit the files.

(If you haven't installed vbookie yet you can install it now but don't do the postbit edits)

Then go to ACP >> vBulletin Option >> vBookie Settings and set Enable uCash to yes

eBux and vBookie will now work together

Hope this helps, although I fear at the speed this thread moves this post will be buried within 48 hours.

Frugal

evenmonkeys 02-13-2006 11:07 PM

It's allowing you to buy lottery tickets even if you don't have enough for one. It sent me 900 eBux into the negative integers.

shaynehammy 02-13-2006 11:07 PM

Got this error when trying to admin donate

"The amount you are trying to transfer is invalid."

Although the amunts gets transferred to the user... how do i rectify this?

lordofgun 02-13-2006 11:54 PM

Regarding vbookie integration:

It's so much easier just to change all instances of "ucash" to "ebux" in functions_vbookie.php

No queries or anything need to be run.

Rickie3 02-14-2006 12:10 AM

Quote:

Originally Posted by lordofgun
Regarding vbookie integration:

It's so much easier just to change all instances of "ucash" to "ebux" in functions_vbookie.php

No queries or anything need to be run.

i'm a little confused here,i have vbookie installed but am using the built in vcash,i dont have ucash installed,so what you are saying if i edit functions_vbookie.php i can integrate this to work with ebux?,if this is so would you care to give some more details please

Frugal 02-14-2006 12:15 AM

Quote:

Originally Posted by lordofgun
Regarding vbookie integration:

It's so much easier just to change all instances of "ucash" to "ebux" in functions_vbookie.php

No queries or anything need to be run.

Apparently this does not work, that was my initial suggestion for people that didn't want to run the query, not tried myself but the person that did try reported that the result was vbookie complained that ucash was not installed when the ucash integration option was chosen.

Personally I'm guessing that is because both vbookieucash and ucash were changed. I suspect that if you leave vbookieucash untouched and only change ucash to eBux it should work. But on the other hand 1 query is far easier than selectively changing multiple instances of ucash in the functions_vbookie.php then reuploading it. Remember a straight "find and replace all" will get both vbookieucash and ucash so you have to selectivey replace them.

The version listed in my earlier post is far longer to explain than to do and really if ucash is not installed it comes down to 1 query and you get a seamless integration that needs no further upkeep. You can have the query done in the time that it takes to find the functions_vbookie file and open it let alone make the changes, save it, then reupload it, only to have to do it all over again when vbookie updates. So nope, it's not easier, just less frightening for those that don't like to run queries.

Frugal

Rickie3 02-14-2006 12:21 AM

Quote:

Originally Posted by Frugal

Section 1 (vbbokie installed ucash not installed)
Ok here is how to integrate ebux and vbookie without having to edit the vbookie files.

Install eBux as per the readme.

Search for and remove the following if it exists in postbit and postbit_legacy templates

Code:

<if condition="$vboptions['vbookiecashon']">
                                                <br />vCash: $post[vbookie_cash]
                                                </if>

Go to AdminCP >> eBux Options >> Manage Settings and change Points Field Name to ucash (this option should be just over half way down the list.)

Go to ACP >> Maintenance >> Execute SQL Query

Execute the following query

Code:

ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'
Then go to ACP >> vBulletin Option >> vBookie Settings and set Enable uCash to yes

eBux and vBookie will now work together.



Frugal

so if i choose to do this ebux will work ok with vbookie, i just want to be sure

Frugal 02-14-2006 12:24 AM

Quote:

Originally Posted by Rickie3
i'm a little confused here,i have vbookie installed but am using the built in vcash,i dont have ucash installed,so what you are saying if i edit functions_vbookie.php i can integrate this to work with ebux?,if this is so would you care to give some more details please

See section 1 of this post

https://vborg.vbsupport.ru/showpost....postcount=1389

This will integrate vbookie and eBux far with less hassle than editing your vbookie files. Editing the vbookie files is only part of it, you still have to follow all of the steps in the post I linked to except the sql query. The main difference between the sql query method and the editing the functions_vbookie method is that the sql method you do once and it is done for good, the file editing method has to be done every time vbookie is updated.

Well the other difference is that the sql method is tried tested and confirmed, the file editing works in theory but hasn't worked in practice (likely due to the person changing too many instances of ucash).

Frugal

Frugal 02-14-2006 12:26 AM

Quote:

Originally Posted by Rickie3
so if i choose to do this ebux will work ok with vbookie, i just want to be sure

Yes, if you have followed the eBux install options correctly including all the template edits and you follow these steps correctly vbookie will work ok with ebux. I should know, I won 7000 eBux points on a vbookie event today when the global flyer broke the record :D

Frugal

TTG 02-14-2006 12:32 AM

I can confirm it works .. just added a vbookie event and had the points deducted from my ebux points for my bet on the new event.

Rickie3 02-14-2006 12:36 AM

Quote:

Originally Posted by Frugal
Yes, if you have followed the eBux install options correctly including all the template edits and you follow these steps correctly vbookie will work ok with ebux. I should know, I won 7000 eBux points on a vbookie event today when the global flyer broke the record :D

Frugal

i'm having problems executing the query from the adminCP

Query
ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'satsfge_.user' doesn't exist

what would be causing this please

caimakale 02-14-2006 12:46 AM

Quote:

Originally Posted by Rickie3
i'm having problems executing the query from the adminCP

Query
ALTER TABLE `user` CHANGE `ebux` `ucash` DECIMAL( 30, 5 ) NOT NULL DEFAULT '0.00000'

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'satsfge_.user' doesn't exist

what would be causing this please

Do you have a table prefix such as vb3_ ???


All times are GMT. The time now is 01:24 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.04599 seconds
  • Memory Usage 1,878KB
  • 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
  • (11)bbcode_code_printable
  • (27)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
  • (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