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 - ICash, Simple, stand alone point system. (https://vborg.vbsupport.ru/showthread.php?t=119086)

gibgaming.com 06-18-2007 09:56 PM

hey guys can any one help ?? iam gettign this error


PHP Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET money=moneyWHERE userid='3';

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='3'' at line 1
Error Number 
1064
Date         
MondayJune 18th 2007 11:56:06 PM
Script       
http://www.gibgaming.com/Forums/newreply.php?do=postreply&t=441
Referrer     http://www.gibgaming.com/Forums/newreply.php?do=newreply&noquote=1&p=4583
IP Address   195.166.202.214
Username     
Gib|G
Classname    
vb_database 


deezelpope 06-18-2007 10:03 PM

<i>I remember a lot of us had this error...do a search in this thread for 1064...I just kept overwriting and eventually it worked. Odd, I know, but I haven't had trouble since.</i>

gibgaming.com 06-18-2007 10:11 PM

i did a search no help really didnt find anything

deezelpope 06-18-2007 10:43 PM

<i>Yeah, right...I did it myself right before I advised you to do it. Try again.</i>

epsol 06-19-2007 05:11 AM

Quote:

Originally Posted by gibgaming.com (Post 1271309)
hey guys can any one help ?? iam gettign this error


PHP Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET money=moneyWHERE userid='3';

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='3'' at line 1
Error Number 
1064
Date         
MondayJune 18th 2007 11:56:06 PM
Script       
http://www.gibgaming.com/Forums/newreply.php?do=postreply&t=441
Referrer     http://www.gibgaming.com/Forums/newreply.php?do=newreply&noquote=1&p=4583
IP Address   195.166.202.214
Username     
Gib|G
Classname    
vb_database 


edit all your forums within the adminCP and re-enter the amount of points given for posts.... it should clear it right up for you.....

0lgi 06-19-2007 01:25 PM

Hey thanks for this mod !

Please where can I see the Log of all the donations please !?

Thanks

Olgi

pixel2528 06-19-2007 04:16 PM

i am getting this error

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET vbookie_cash=vbookie_cash+ WHERE userid='1';

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 'WHERE userid='1'' at line 1
Error Number : 1064
Date        : Tuesday, June 19th 2007 @ 12:14:49 PM
Script      : http://www.pixelinsanities.com/forum/newreply.php?do=postreply&t=186
Referrer    : http://www.pixelinsanities.com/forum/newreply.php?do=newreply&noquote=1&p=572
IP Address  :
Username    :
Classname    :

any help

deezelpope 06-19-2007 04:56 PM

<i>Read through...this is answered in the thread.</i>

BigDog56 06-19-2007 05:43 PM

Got the same error, did as was suggested, all works fine now. Trying to find how to reset someones' points..?

BigDog56 06-19-2007 05:55 PM

How can you edit, take away someone's money?

deezelpope 06-19-2007 06:08 PM

I don't think you can...unless you have the Admin log-in as user hack...

https://vborg.vbsupport.ru/showthread.php?t=122939

BigDog56 06-19-2007 06:15 PM

Quote:

Originally Posted by deezelpope (Post 1271906)
I don't think you can...unless you have the Admin log-in as user hack...

https://vborg.vbsupport.ru/showthread.php?t=122939

Thanks, I got it figured out. Just put a negative amount in the donate area.
Posted on page 2 or 3, something like that. Great mod, love it!

deezelpope 06-19-2007 06:16 PM

Oh good!!! Duh, that didn't occur to me...hehehe...sorry!:rolleyes:

BigDog56 06-19-2007 07:26 PM

Quote:

Originally Posted by deezelpope (Post 1271915)
Oh good!!! Duh, that didn't occur to me...hehehe...sorry!:rolleyes:

LOL.Disn't occur to me, either! I read it and thought, simple enough! And it works too! Now to try and find a "Gifts" mod...

deezelpope 06-19-2007 07:30 PM

There's this author's iShop...that's what I use...plus, iBank, for the interest...;)

BigDog56 06-19-2007 08:21 PM

Quote:

Originally Posted by deezelpope (Post 1271950)
There's this author's iShop...that's what I use...plus, iBank, for the interest...;)

I'll check it out! Thank you!

deezelpope 06-19-2007 08:31 PM

No problem!

BTW, I like the homepage of your site...just gorgeous!

BigDog56 06-19-2007 08:54 PM

Quote:

Originally Posted by deezelpope (Post 1272005)
No problem!

BTW, I like the homepage of your site...just gorgeous!

Thank you! I can't take credit for the artwork, but the animation I can. ;)

deezelpope 06-19-2007 09:02 PM

Well, good job!! The fairy is very beautiful!:)

redtailboa 06-20-2007 11:53 PM

Ok i installed this mod and this is what i get.. some times i get an error but the post is posted
Quote:

This post is a duplicate of a post that you have posted in the last five minutes. You will be redirected to that thread.
3.6.7
I will deactivate it until there is a fix.

redtailboa 06-21-2007 12:13 AM

nm.. fixed.. re edit icash settings and its working now.

donal 06-21-2007 12:21 AM

Will this hack work for VB 3.6

deezelpope 06-21-2007 08:20 AM

Read over this thread...your answer lies within.:)

MadKad 06-21-2007 04:43 PM

Is there any way that I can change the points system to say

0.01 for posts

and

0.02 for new threads

or if this cant be done, just changing the 5.00 per post to 0.01 :)

deezelpope 06-21-2007 04:48 PM

You set all the money in your forum manager in your AdminCP.:)

Why so cheap?

MadKad 06-21-2007 06:13 PM

Quote:

Originally Posted by deezelpope (Post 1273344)
You set all the money in your forum manager in your AdminCP.:)

Why so cheap?

ok np, I will look at it :)

it might not be that cheap, the reason for it being lower is because its going to be real cash :D

EDIT: sorry one last question, is there no way of making say one usergroup have all the points in say double the standerd?

deezelpope 06-21-2007 08:01 PM

Ohhh, I see. Cool.

I don't think so, considering payment is forum-based.

MadKad 06-21-2007 09:56 PM

no payment will not be forum bassed

====

This does really need a usergroup option so that say my V.I.P. members can earn more points.

Is there no way of doing this?

deezelpope 06-21-2007 10:18 PM

No, no...I mean the points system (payment) is forum/post based...they get paid for posting...that's what I meant.

I dunno.:confused:

MadKad 06-21-2007 10:22 PM

Quote:

Originally Posted by deezelpope (Post 1273571)
No, no...I mean the points system (payment) is forum/post based...they get paid for posting...that's what I meant.

I dunno. :confused:

Yer i know lol getting me very confused now lol, we are just going to do it so they can cash the point in if they want (some how)

this way it will make them want to earn lots :D but apart from that is there a way for \/

====

This does really need a usergroup option so that say my V.I.P. members can earn more points.

Is there no way of doing this?

deezelpope 06-21-2007 10:32 PM

<i>I don't have any idea if there's any way to do what you are asking.</i>

felicialsg 06-22-2007 02:59 PM

Hi everyone. Need to enquire on showing the points in posibit. The instructions say

In order to have Icash display in postbit, open your postbit template
Find:
----------
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>

Add after:
----------
$vboptions[icashn]: $post[money]
<br>
<a href="donate.php?$session[sessionurl]to=$post[username]">Donate</a>

So where do I add the $vboptions.... to?

Is it something like this?

....skypeicon]</div>$vboptions[icashn]: $post[money]
<br>......

I'm not very familar with this. Sorry :(

felicialsg 06-22-2007 03:21 PM

Thanks... I got it working...:D

NFLfbJunkie 06-23-2007 12:28 AM

How much is given per character, post and reply? I can't figure this out.

Nevermind. I figured it out.

pixel2528 06-23-2007 05:38 PM

i cant get it to work help

yashua 06-23-2007 11:17 PM

Quote:

Originally Posted by 007 (Post 1268631)
Where can I set the amount of points people get per post?

All I see is:



There is no place to set this number though.

I'm getting this same problem =( I cant find where to set it all I see is the check box there is no where to put teh value of how much money you want to give each post =(

YukonMaster 06-24-2007 02:32 AM

If you want to set the amount per post and topic etc, you can set this in the individual forums in the Forum Manager in the ACP. It is at the very bottom.

NFLfbJunkie 06-24-2007 01:53 PM

Is there a query that can be run to reset a user's points to '0'?

Blaine0002 06-24-2007 02:22 PM

backup before doing this.
Quote:

UPDATE users set money=0;

Blaine0002 06-24-2007 02:23 PM

And please click install!


All times are GMT. The time now is 01:26 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.02235 seconds
  • Memory Usage 1,828KB
  • 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
  • (2)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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