View Full Version : Major Additions - ICash, Simple, stand alone point system.
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
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.
UPDATE users set money=0;
Blaine0002
06-24-2007, 02:23 PM
And please click install!
NFLfbJunkie
06-24-2007, 02:43 PM
I tried the query and got:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'mytableprefix_forums.users' doesn't exist
Blaine0002
06-24-2007, 08:14 PM
oops! sorry i added an s at the end of user..
UPDATE user set money=0;
BigDog56
06-25-2007, 12:14 PM
Works great, just one question. Where do I find the logs of who has donated what to who?
Blaine0002
06-25-2007, 01:48 PM
Currently isnt one, will be in the next version!
Vinyljunky
06-25-2007, 02:29 PM
Hello,
Im in the process of restoring my DB to another host but I keep getting the error below
Error
SQL query:
--
-- Dumping data for table `holiday`
--
--
-- Table structure for table `icash_donations`
--
CREATE TABLE icash_donations(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
FROM text NOT NULL ,
TO text NOT NULL , I get an error icon on this line
amount int( 11 ) NOT NULL default '0',
time text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;
MySQL said:
#1064 - 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 'from text NOT NULL,
to text NOT NULL,
amount int(11) NOT NULL default '0',
' at line 3
The import works fine if I remove the icash bits from the .sql file
CREATE TABLE icash_donations (
id int(11) NOT NULL auto_increment,
from text NOT NULL,
to text NOT NULL,
amount int(11) NOT NULL default '0',
time text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `icash_donations`
--
INSERT INTO icash_donations VALUES (1,'TheGuru','kazthorn',5,'{time()}');
I therefore guess that the error is in the code above. (Created by the icash mod)
What is wrong, how can I fix it :confused:
Many Thanks
VJ ...
BigDog56
06-25-2007, 03:00 PM
Good deal. Another potential problem is that if a member copies something long then deletes it, they do not lose their money. If they do this a few times, they can end up with alot of money with very few posts.
Blaine0002
06-25-2007, 03:55 PM
No way around that.
BigDog56
06-25-2007, 04:02 PM
One more thing, lol. A problem you hopefully can help me with. I have an admin. Whose money is going up more then I think it should. I might be wrong, so I need to know for sure before accusing this person. Is there any way to find out if this person is bumping up their own money, or at least a way to turn the ability for admin. To donate off and on? I really love this mod, just if people can find a way to cheat, they will...
deezelpope
06-25-2007, 04:12 PM
<i>Can't you check the Admin log?</i>
BigDog56
06-25-2007, 04:42 PM
Thanks, tried that. I gave myself 5 bucks and it didn't show up.
Blaine0002
06-25-2007, 04:55 PM
next version ill add it so it tracks what goes on in the admincp.
BigDog56
06-25-2007, 05:03 PM
Cool. In the mean time, I'll make it where it's on a per thread and post basis only, no money for characters. Be easy to add up that way, lol.
powerful_rogue
06-25-2007, 10:00 PM
Database error in vBulletin 3.6.7:
Invalid SQL:
UPDATE dev_user SET money=money+ WHERE userid='2398';
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='2398'' at line 1
Error Number : 1064
Date : Monday, June 25th 2007 @ 11:59:31 PM
Script : http://www.simalert.com/dev/newreply.php?do=postreply&t=245754
Referrer : http://www.simalert.com/dev/newreply.php?do=newreply&noquote=1&p=1980791
IP Address : 80.4.20.44
Username : Dave
Classname : vB_Database
Get this error when I hit "submit" after typing a reply. If i hit refresh it goes back to the page with my reply submitted.
Blaine0002
06-25-2007, 10:02 PM
is your userid actually 2398?
Vinyljunky
06-26-2007, 01:46 PM
Hello,
Im in the process of restoring my DB to another host but I keep getting the error below
The import works fine if I remove the icash bits from the .sql file
CREATE TABLE icash_donations (
id int(11) NOT NULL auto_increment,
from text NOT NULL,
to text NOT NULL,
amount int(11) NOT NULL default '0',
time text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `icash_donations`
--
INSERT INTO icash_donations VALUES (1,'TheGuru','kazthorn',5,'{time()}');
I therefore guess that the error is in the code above. (Created by the icash mod)
What is wrong, how can I fix it :confused:
Many Thanks
VJ ...
BUMP :o
civic7
06-26-2007, 05:49 PM
Maybe asked before..
When a mod/admin delete a user posts..will the point also get deleted from total points of the user ?
idhelperz
06-26-2007, 06:18 PM
when the next version will up? compatible with vB 3.6.x ?
Chase
06-27-2007, 04:47 PM
Can someone please confirm when the new version will be ready? And can someone confirm if the version out right now is working fine with 3.6.7 PL
agent_smith
06-28-2007, 08:31 PM
Can someone please confirm when the new version will be ready? And can someone confirm if the version out right now is working fine with 3.6.7 PL
It doesnt work with 3.6.7, you get a database error upon posting..
Database error in vBulletin 3.6.7:
Invalid SQL:
UPDATE user SET money=money+ 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 : Thursday, June 28th 2007 @ 02:33:17 PM
Script : http://www.forums.easyforumz.com/newthread.php?do=postthread&f=33
Referrer : http://www.forums.easyforumz.com/newthread.php?do=newthread&f=33
IP Address : 84.66.99.189
Username : EF Matt
Classname : vb_database
kylek
06-28-2007, 11:50 PM
[quote=agent_smith;1278700]It doesnt work with 3.6.7, you get a database error upon posting..
/quote]
Gee thats funny that you would say it doesn't work as there is a lot of users here that have it running on 3.6.7 including myself on 4 sites.
deezelpope
06-29-2007, 09:22 AM
Looks like "someone" didn't read through this thread.:rolleyes::eek:
agent_smith
06-29-2007, 04:31 PM
Instead of trying to be a smart arse could you point it out for me please? I thought it would of been mentioned in the txt file, not in the 782 post thead >_>
Thnx
kylek
06-29-2007, 06:46 PM
Instead of trying to be a smart arse could you point it out for me please? I thought it would of been mentioned in the txt file, not in the 782 post thead >_>
Thnx
I am not being a "smart arse" but am sick and tired of seeing people who have problem with a hack say that it doesn't work or will not search through the thread when told the answer to a problem has been answered several times in the thread, not aiming this at you but lately you see this in almost every hack listed here.
Sorry I cannot remember exactly the posts numbers that answer your problem at this time but if you look though the posts its in here. Try searching through a hack that has 128 pages of posts, thats what i have been doing right now to find a couple of problems I am having.
nymyth
07-06-2007, 01:47 PM
anyway we can have this system take back points if we delete a post or a thread??
njoker555
07-07-2007, 03:16 AM
i had the error that when someone posted - the error would say OKAY and when you refresh the post would be there - and how would i configure to make it so people get certain amount of points per character and post and thread - didnt see that in the options
help appreciated
HIVEDesigner
07-07-2007, 04:22 AM
Alright, so I installed this mod. And, I installed the iCash mod. Now, I don't know what to do after that.
I ran both installers, now all I can do is edit the settings in the admincp. I can't actually get to this in my forum. Same with vBookie.
Help. :(
HIVEDesigner
07-07-2007, 07:44 AM
I have the vBookie hack also installed.
How to I integrate the two? Exactly what files do I change?
deezelpope
07-07-2007, 09:46 AM
<i>Read through this thread...most answers are given within...</i>
JVCode
07-07-2007, 09:40 PM
Has anyone managed to integrate the iCash system with V3-Arcade yet? I'm eagerly awaiting this!
njoker555
07-07-2007, 09:57 PM
Read through this thread...most answers are given within...
well do you mind telling me anyway if you know a solution - because reading through 800 posts is very time consuming and for a person like me i dont have too much time in my hands.
thanks!
also how would i set the certain amount of points they get per post/per charcater/per thread, etc?? it wasnt in the panel - and i cant really install it back now because of that error called "OKAY"
MadKad
07-08-2007, 04:03 PM
Does this hack allow for one usergroup to gain more points say an extra ++ to other groups on posts and thread starting?
if not can it be made? and does any one have any idea how :D
RockMTP
07-10-2007, 12:33 PM
Great little hack...Thanks!
I have a couple of questions / requests.
Is it possible to deduct credits for each attachment viewed?
Would it be possible to give credits per attachment?
For example, each attachment uploaded would earn 2 credits and each attachment viewed would cost 1 credit. Users would be able to see the thumbnails and would get charged if they opened one. Users with no credits would get a message if they tried to open an attachment.
Thanks
Blaine0002
07-10-2007, 10:47 PM
all great ideas, the only one i will impliment in my next version is the removal of points with post deletion, and fixing it to work with the newest VB :)
Carlos2
07-11-2007, 04:07 AM
Hi friends. i explain what i want but i think you didnt understand me because my english is so bad.
My question is how can i separate digits in postbit when the points size are too big, in example, with millions. I want to know if i can separate digits by comas.
Look here the example like are now in my forum and what i want to be with one million points.
CARLOS2 Points: 1000000
And i want it:
Carlos2 Points: 1.000.000
The second one is easy to know how much money i have. Can i do it??
chandker
07-12-2007, 04:25 AM
I just installed this and I really like the Donate feature. However, I'm still pretty new at this and I read through all of the posts in this thread but I didn't see my questions answered.
I used to use the Nexia Point System and I changed money row in ICash to nex_points_hand but it's still not bringing over our previous points into the ICash system. Is there an additional step? I just have Nexia disabled, not uninstalled.
Also, I need to get rid of the ".00" after the money. I read somewhere that you have to change the number format, but I'm not sure how to do that.
All help would be greatly appreciated; I'm sorry if I sound dumb but I did try and find the answers before. :(
Blaine0002
07-12-2007, 04:13 PM
if you changed the variable in the admincp the points system is using nex_points_hand, but it wont be changed in postbit... You will need to edit your postbit template and change $post[money] to $post[nex_points_hand]
:)
BTW, i renewed my liscense and updated the mod to work with the new version, it isnt uploaded yet though, i will do that when i get post deletion working.
agsguar
07-12-2007, 06:43 PM
Hi blane!!
This is a good hack.. i love it and my forum users too..
I have a one question, How can i know who users donate me?? or give me a gift?
Thank you in advance!!
Blaine0002
07-12-2007, 06:46 PM
When you click the donate button you will see who you have donated to and who has donated to you.
agsguar
07-12-2007, 07:23 PM
but only appears the last donation..
if i receive 2 donations??
chandker
07-12-2007, 09:54 PM
Thanks Blaine! Is there any way to get rid of the decimal?
Blaine0002
07-12-2007, 10:59 PM
If you have phpmyadmin, you can go into the user table and change the row that says 'money'
You will see integer(15,2)
just remove the ,2 part and your good to go :)
chandker
07-12-2007, 11:10 PM
I tried that and it still seems to be showing up. :confused: Weird.
Blaine0002
07-13-2007, 02:21 AM
if you changed it properly i have no clue o.o
Blaine0002
07-13-2007, 02:22 AM
are you using the 'money' row?
chandker
07-13-2007, 03:05 AM
I'm not too clear on what you mean by "money row". Could you possibly show me step by step (or as close to possible) as you can about how to go about changing it?
I'm confused as to what the phpmyadmin thing is. Sorry.
Blaine0002
07-13-2007, 03:18 AM
So did you change integer(15,2) to integer(15)???
chandker
07-13-2007, 03:34 AM
Yes I did. In the admin panel where I go to manage products and also in the install xml file.
Blaine0002
07-13-2007, 03:40 AM
yea thats not gunna do anything, your going to need to edit the user table in your database.
jahshaka
07-13-2007, 11:59 PM
sweet mod - any eta on the new release that works with the new vrsion of vb?
Blaine0002
07-14-2007, 12:47 AM
Working on debugging and adding requested features.
JVCode
07-14-2007, 06:28 AM
How do i integrate iCash with IBProArcade?
Blaine0002
07-14-2007, 10:17 PM
Updated.
whitevans1
07-14-2007, 11:12 PM
Database error in vBulletin 3.6.7:
Invalid SQL:
ALTER TABLE user ADD COLUMN money decimal(15,2) DEFAULT '0' NOT NULL;
MySQL Error : Duplicate column name 'money'
Error Number : 1060
Date : Saturday, July 14th 2007 @ 08:11:49 PM
Script : http://www.run3h4x.net/forum/admincp/plugin.php?do=productimport
Referrer : http://www.run3h4x.net/forum/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vb_database
I'm getting that error. can someone help me fix it?
Blaine0002
07-15-2007, 12:54 AM
Hmm, it seems to not have uninstalled correctly. Do you want to save the points you have in the previous installation of icash?
whitevans1
07-15-2007, 01:06 AM
if thats easy then yeah i just want the easiest way to get it working.
iKuro
07-15-2007, 02:17 AM
how i update without lose yhe money of the users in my forum???
Blaine0002
07-15-2007, 02:38 AM
@ikuro just reimport the XML file and reupload all files..
@whitevans, run the following queries, it will delete everything and start over.
ALTER TABLE post DROP COLUMN `icash`
ALTER TABLE forum DROP COLUMN `icash_prethread`
ALTER TABLE forum DROP COLUMN `icash_perreply`
ALTER TABLE forum DROP COLUMN `icash_perchar`
ALTER TABLE user DROP COLUMN `money`
THEN install the XML, (redownload though)
Scathmere
07-15-2007, 03:36 AM
What's the new update?
Please say it sends a PM -_-
whitevans1
07-15-2007, 03:56 AM
Error
SQL query:
ALTER TABLE " . TABLE_PREFIX . "post DROP COLUMN `icash` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_prethread` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_perreply` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_perchar` ALTER TABLE " . TABLE_PREFIX . "user DROP COLUMN `money`
MySQL said: Documentation
#1064 - 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 '" . TABLE_PREFIX . "post DROP COLUMN `icash`
ALTER TABLE " . TABLE_PREFIX . "fo' at line 1
Blaine0002
07-15-2007, 04:02 AM
No it dosent send a pm.... why would you need that??
@whitevans... run them as seperate queries.
and i forgot to delete table prefixes..
try these
ALTER TABLE post DROP COLUMN `icash`
ALTER TABLE forum DROP COLUMN `icash_prethread`
ALTER TABLE forum DROP COLUMN `icash_perreply`
ALTER TABLE forum DROP COLUMN `icash_perchar`
ALTER TABLE user DROP COLUMN `money`
agsguar
07-15-2007, 04:24 AM
Sorry, again me.
But how can i view the last 10 donations (to me)??
is this possible??
Thank you!!
jeremyalyea
07-15-2007, 05:32 AM
I currently have vbookie installed and I am trying to integrate the icash system into it. Every time I try to import the icash xml file, I get the databse error listed below. I have read through the posts and have changed 'money' to 'vbookie_cash', but I'm still getting errors. I have spent a couple of hours on this and still nothing. Would anyone be willing to shed some light?
Invalid SQL:
if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD COLUMN 'vbookie_cash' decimal(15,2) DEFAULT '0' NOT NULL;
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 'if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD' at line 1
Error Number : 1064
Caseyjr86
07-15-2007, 02:48 PM
What do i need to do? I just tried importing and I get this error.. I've never had I cash before.. either..
Database error in vBulletin 3.6.7:
Invalid SQL:
if not exists (select icash_prethread from forum)
ALTER TABLE forum ADD COLUMN icash_perthread DECIMAL(30, 5) NOT NULL DEFAULT '10';
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 'if not exists (select icash_prethread from forum)
ALTER TABLE forum ADD COL' at line 1
Error Number : 1064
Date : Sunday, July 15th 2007 @ 10:46:12 AM
Script : http://www.*****.com/admincp/plugin.php?do=productimport
Referrer : http://www.****.com/admincp/plugin.php?do=productadd
And for giggles I reran it, and now get this error..
Database error in vBulletin 3.6.7:
Invalid SQL:
ALTER TABLE user ADD COLUMN money decimal(15,2) DEFAULT '0' NOT NULL;
MySQL Error : Duplicate column name 'money'
Error Number : 1060
Date : Sunday, July 15th 2007 @ 10:50:10 AM
Script : http://www.***.com/admincp/plugin.php?do=productimport
Referrer : http://www.****.com/admincp/plugin.php?do=productadd
Blaine0002
07-15-2007, 03:16 PM
OOPs! bad column checking on my part!
Redownload and reimport, should work fine now!
whitevans1
07-15-2007, 08:56 PM
atabase error in vBulletin 3.6.7:
Invalid SQL:
UPDATE user
SET `money` = `money` + 0
WHERE userid = '1';
MySQL Error : Unknown column 'money' in 'field list'
Error Number : 1054
Date : Sunday, July 15th 2007 @ 05:57:26 PM
Script : http://www.run3h4x.net/forum/newreply.php?do=postreply&t=13847
Referrer : http://www.run3h4x.net/forum/showthread.php?t=13847
IP Address :
Username :
Classname : vb_database
Blaine0002
07-15-2007, 09:09 PM
Now, you must have just overwritten the product
Uninstall ICASH and THEN import the XML and it will work.
whitevans1
07-15-2007, 09:12 PM
when i try to uninstall i get this
Database error in vBulletin 3.6.7:
Invalid SQL:
ALTER TABLE post DROP COLUMN `icash`;
MySQL Error : Can't DROP 'icash'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:12:31 PM
Script : http://www.run3h4x.net/forum/admincp/plugin.php?do=productkill
Referrer : http://www.run3h4x.net/forum/admincp/plugin.php?do=productdelete&productid=Icash&s=
IP Address :
Username :
Classname : vb_database
Blaine0002
07-15-2007, 09:28 PM
Sorry you had to get caught up in that, That SHOULD be the last error you get, NOW.
Re download the current XML, Import/overwrite your previous one since you cant uninstall, THEN uninstall it, you should not recieve any errors. Now that it is uninstalled install it one last time and I think your good to go.
whitevans1
07-15-2007, 09:36 PM
It won't unistall for some reason... I get the same error and i downloaded the newest one.
Database error in vBulletin 3.6.7:
Invalid SQL:
ALTER TABLE forum DROP COLUMN `icash_prethread`;
MySQL Error : Can't DROP 'icash_prethread'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:36:32 PM
Script : http://www.run3h4x.net/forum/admincp/plugin.php?do=productkill
Referrer : http://www.run3h4x.net/forum/admincp/plugin.php?do=productdelete&productid=Icash&s=
IP Address :
Username :
Classname : vb_database
SKULL1985
07-15-2007, 09:39 PM
I have installed this on my forum 3.6.7 but when you make a post , thread no one gets any points?
Blaine0002
07-15-2007, 09:46 PM
whitevans, make sure you redownload and overwrite your product with the new xml
THEN you should be able to uninstall.
@ skull, make sure you have it configured correctly in the admincp!
SKULL1985
07-15-2007, 09:52 PM
whitevans, make sure you redownload and overwrite your product with the new xml
THEN you should be able to uninstall.
@ skull, make sure you have it configured correctly in the admincp!
Ok its working now it just took a few mins to work is there a way , to edit it so that to make a thread you get 00.10 insted of 10.00 and on a reply insted of 5.00 you get 00.05
whitevans1
07-15-2007, 09:53 PM
I did redownload overwrite and reinstall.
and i get this when trying to uninstall.
.
Invalid SQL:
ALTER TABLE forum DROP COLUMN `icash_prethread`;
MySQL Error : Can't DROP 'icash_prethread'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:36:32 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database
Blaine0002
07-15-2007, 09:59 PM
Stupid spelling errors, thanks for being patient..
Redownload, Overwrite, Reinstall!
whitevans1
07-15-2007, 10:02 PM
lol ok thanks :) and its ok its not easy and i feel like im bugging you so not problem, works thanks :)
SKULL1985
07-15-2007, 10:09 PM
Ok Blaine0002 scrap my last post , i found how to do it i just have to edit each section and edit the points section.
Nice hack thank you
Blaine0002
07-15-2007, 10:11 PM
Glad its finally working :D yay!
Scathmere
07-15-2007, 10:20 PM
Why PMs? How else does someone know who sent the money? Or even items?
And is there at least an extended donation log?
I'm just confused about what you updated?
Blaine0002
07-15-2007, 10:25 PM
i made it work with new vbulletins, and i made it so points can be taken away when a point is deleted... There is a donation log built into the donation page if you havent noticed that.
SKULL1985
07-15-2007, 10:38 PM
Is there a way for the admin to take ponits away from a user ?
Also how can i add it so it deplys the ponits in the user profile?
Scathmere
07-15-2007, 10:38 PM
Thanks,
I noticed the donation log, any simple edit I can make to increase the history?
Blaine0002
07-15-2007, 10:44 PM
I can check scath, i can probably make that part of the usercp
As for negating points from users, just use the admin donate to donate them a negative amount.
edit: it dosen't look like theres a limit on the amount it displays.
SKULL1985
07-15-2007, 11:30 PM
I can check scath, i can probably make that part of the usercp
As for negating points from users, just use the admin donate to donate them a negative amount.
edit: it dosen't look like theres a limit on the amount it displays.
As for negating points from users, just use the admin donate to donate them a negative amount
I dont see that in the admin panel where i can take ponits away from users?
Blaine0002
07-15-2007, 11:39 PM
on the regular donate.php page, there is a section thats only visable to admins :)
SKULL1985
07-15-2007, 11:43 PM
Sorry for all teh qestions and thanks for all the replys
All i see is Donate ITG$ or Admin Donate ITG$ no where to take ponits of anyone.
Would a Sreen shot help?
Also how do i add the ponits like on post bit on my members profile page?
Blaine0002
07-16-2007, 12:17 AM
in the admindonate area, donate a user a negative amount.
SKULL1985
07-16-2007, 01:06 AM
in the admindonate area, donate a user a negative amount.
Thanks i have woked out what your saying now use -10 ect sorry i was looking for somthink else
Thanks
Bellardia
07-16-2007, 02:04 AM
Does this work with 3.6?
Blaine0002
07-16-2007, 02:08 AM
Yep!
Scathmere
07-16-2007, 03:20 AM
edit: it dosen't look like theres a limit on the amount it displays.
Where would I do the edit? :confused:
semma4eva
07-16-2007, 03:51 AM
Hey this might be a bit of a stupid question, and it was probably already asked at soe point, but I'd rather not look through all 52 pages.
Where does it say how many points the person has? I don't see it in my profile.
Nevermind I found it in the postbit, but is there a way to put in so it shows up in the profile, as well? And is there a way to make it so you get a PM when the administrator gives a donation?
agsguar
07-16-2007, 12:45 PM
Sorry, again me.
But how can i view the last 10 donations (to me)??
is this possible??
Thank you!!
Do you have any idea?? Thank you!!! :)
Blaine0002
07-16-2007, 02:25 PM
Its located right on the donate page.
@scathmere There is no limit, no edit is required.
@semma4eva
Open MEMBERINFO template.
Find:
----------
<if condition="$vboptions['usereferrer']">
Add BEFORE:
----------
<if condition="$vboptions['points']">$vboptions[icashn]: $userinfo[money]</if>
semma4eva
07-16-2007, 04:25 PM
okay thanks!
Tanabe
07-18-2007, 07:21 AM
I think it would be a really cool idea if possible to have the mode give out points to those who vote in a poll.
kennethsia
07-19-2007, 12:57 AM
blaine i dont know if uve been ignoring the other guys or what. ><
i want also to know HOW to make the log show the last 10 donations or so. because its a fatal flaw with a very active forum using cash.
donation doesnt include PM and reason of donation
donation only shows the LAST transaction. it should show more than that if possible.
Blaine0002
07-19-2007, 01:19 AM
It should show ALL incoming donations, and ALL outgoing donations.
Is it not?
kennethsia
07-19-2007, 01:32 AM
well i havent updated it, and no it only shows the last donation that happened for everyone.
DJ Teac
07-20-2007, 09:23 PM
The older version didn't showed ALL donations for me too.
But i'm updating it now, gonna tell you in some minutes if it works now.
Edit: Nope, i updatet and it still just shows the last one, like in the old version.
Also the Members now don't get the Points on Registration.
vB is 3.6.7
btw: I didn't check it, but is now the whole text of the addon set to phrases? Because i have to translate it to german, and its a bit confusing searching through the templates and stuff...
Edit: Would it be possible to charge a small amount for a Donation?
Like lets say 5% of the Money, but also set a maximum like "don't charge more then 3 Points".
Because i wanna use it like wiretransfers with banking costs.
The Costs for the transfer should be taken from the one who sends the money, and not from the amount donatet.
I know thats a bit much, but well... Its just a question :)
Aclikyano
07-20-2007, 10:48 PM
Warning: Division by zero in /includes/functions.php(5129) : eval()'d code on line 98
I get this when tryna donate to a new user or a user.
Warning: Division by zero in /includes/functions.php on line 5243
I get that when I enabled, rebuilt all the plugins with "plugin accelator" and trying to donate to myself.
-------------------
98 = case 'userpic_sigpic':
5129 = ($hook = vBulletinHook::fetch_hook('global_complete')) ? eval($hook) : false;
5243 = }
-------------------
All I did was upload the new iCash files (dont think i removed the old files from the FTP cuz I didnt have the old version) and remove and install the new iCash (not overwriting because I already removed)
SO What the problem is? the donate.php file in the /forums dir is CHMOD 775
angelpie
07-21-2007, 02:01 AM
thanks a ton installed
Bacon Butty
07-21-2007, 11:12 AM
Hi Armstrong - I have attached an edited version of Blains XML using the code from your original logging post - see attached (search for $logentry = date('Ymd') in the XML to see the logging lines - you can edit the text to suit your own logs.
Just import this new XML and overwrite teh existing - make sure you have a backup etc and know what your current settings etc are!
This should add to the log file for all iCash earnings
I installed that XML file but were can I now see the donation logs?
Monyet
07-22-2007, 03:29 AM
how can i see the donation and put it in the bank? more instruction please... :-/
chikkoo
07-22-2007, 04:17 AM
It should show ALL incoming donations, and ALL outgoing donations.
Is it not?
I have updated it, still it is NOT showing ALL incoming and outgoing donations. Just the last one is appearing.
heatherl55
07-22-2007, 04:54 AM
Is there anyway I can post how many points and how much money is in the bank in the postbit?
Aclikyano
07-22-2007, 07:16 PM
<a href="https://vborg.vbsupport.ru/showpost.php?p=1296965&postcount=860" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=860</a>
Dont understand how and why I would get this error....
Blaine0002
07-31-2007, 09:54 PM
that is not an error regarding ICash, it seems to be an error regarding a plugin accelerator.
DiarrHeaZORRR
07-31-2007, 11:53 PM
is there anyway to "RESET" this so that everyone is back to 0
ive uninstalled and reinstalled the mod and that didn't work
Blaine0002
08-01-2007, 12:11 AM
hmm uninstalling and reinstalling should work unless you are using a different money row other than 'money'
DiarrHeaZORRR
08-01-2007, 12:25 AM
eh i did try to uninstall it and reinstall a second time but the points came back the same :/
Blaine0002
08-01-2007, 12:49 AM
is your money row set as 'money' in the icash options?
jeremyalyea
08-01-2007, 03:36 AM
If I do an update, will it reset the points for everyone? I am trying to avoid this.
Blaine0002
08-01-2007, 10:57 AM
No.
fitnesshealth
08-01-2007, 02:46 PM
I have uninstalled icash product and deleted all the icash files.
Why is it upon new installation, i will get error like this when i tried to add money through donate.php (admin)?
Database error in vBulletin 3.6.8:
Invalid SQL:
update user set money = money +1 WHERE username = nickname;
MySQL Error : Unknown column 'nickname' in 'where clause'
Error Number : 1054
Date : Wednesday, August 1st 2007 @ 11:43:23 AM
Script : http://www.domain.com/donate.php?do=doadmindonate
Referrer : http://www.domain.com/donate.php
IP Address : 123.21.15.8
Username : Admin
Classname : vb_database
I've tried reinstalling/overwriting everything but the error still exists. I read through this thread but couldn't find a solution.
solutions like set new points in forum section, reinstallation, etc.
Anyone can help? I would be more than glad to pay you a token of appreciation through paypal if you could.
fitnesshealth
08-01-2007, 03:17 PM
Just to update, when i set up everything the same way for 1.0.2, it works. Just that i can't make it work for 1.1.0
Blaine0002
08-01-2007, 08:32 PM
Hmm, so there is a user called "nickname"
There SHOULD be a check for that but im not sure
What version of VB are you running?
TalkBolts
08-02-2007, 11:06 AM
I have uninstalled icash product and deleted all the icash files.
Why is it upon new installation, i will get error like this when i tried to add money through donate.php (admin)?
Database error in vBulletin 3.6.8:
Invalid SQL:
update user set money = money +1 WHERE username = nickname;
MySQL Error : Unknown column 'nickname' in 'where clause'
Error Number : 1054
Date : Wednesday, August 1st 2007 @ 11:43:23 AM
Script : http://www.domain.com/donate.php?do=doadmindonate
Referrer : http://www.domain.com/donate.php
IP Address : 123.21.15.8
Username : Admin
Classname : vb_database
I've tried reinstalling/overwriting everything but the error still exists. I read through this thread but couldn't find a solution.
solutions like set new points in forum section, reinstallation, etc.
Anyone can help? I would be more than glad to pay you a token of appreciation through paypal if you could.
I'm getting the same error. Any ideas?
Blaine0002
08-02-2007, 11:48 AM
Are you only getting this error through admin donate or regular donate as well?
TalkBolts
08-02-2007, 11:50 AM
Are you only getting this error through admin donate or regular donate as well?
I only get the error through admin donate.
regular donate works perfectly.
Blaine0002
08-02-2007, 11:58 AM
Ok, ive fixed the error, i will reupload in a bit and send out an update :) thanks for the bug reports.
Blaine0002
08-02-2007, 12:10 PM
Updated..
Enjoy!
mrpaint
08-02-2007, 12:33 PM
Nice! I hope the new version works well
Very quick work!
Thank you, Blaine
Blaine0002
08-02-2007, 12:45 PM
No problem, Might want to grab 1.1.1 while your here!
Caseyjr86
08-02-2007, 03:28 PM
I see some guy has a similar error, but maybe its not completely fixed, as I have re downloaded everything and reuploaded and over written, unless there is something for me to do.
Database error in vBulletin 3.6.7:
Invalid SQL:
update user set money = money +150 WHERE username = User;
MySQL Error : Unknown column 'User' in 'where clause'
Error Number : 1054
Date : Thursday, August 2nd 2007 @ 11:26:03 AM
Script : http://www.domain.com/donate.php?do=doadmindonate
Referrer : http://www.domain.com/donate.php?to=User
IP Address : *******
Username : RandoM
Classname : vb_database
fitnesshealth
08-02-2007, 04:13 PM
I see some guy has a similar error, but maybe its not completely fixed, as I have re downloaded everything and reuploaded and over written, unless there is something for me to do.
My problem is eliminated after using 1.1.1.
What i did is to completely uninstall the product and deleted all the relevant icash files.
Then i uploaded all the new files from 1.1.1.
I do not know if it is safe to overwrite everything.
New Problems discovered:
However, i discovered some new problems (or maybe they are not problems afterall).
Donate negative amount - Not working
(Successfully Donated 0 Points To nickname.)
Donate amount less than 1.0 (e.g. 0.5) - Not working
(Successfully Donated 0 Points To nickname.)
Donate more than 1.0 - Working fine.
fitnesshealth
08-02-2007, 04:27 PM
The 'Points negated when deleted.' is also not working well. Does not deduct the correct points when post or thread is deleted.
Blaine0002
08-02-2007, 05:08 PM
Thanks for the bug reports, ill look into them :)
Blaine0002
08-02-2007, 05:16 PM
Fixed! update :)
fitnesshealth
08-02-2007, 06:14 PM
Thanks for the quick fix!
Just wondering will my points settings for individual forums or members be reset after installation (overwrite) files/product?
Blaine0002
08-02-2007, 06:18 PM
no they shouldnt.
TalkBolts
08-02-2007, 06:28 PM
Cool, everything seems to be working perfectly now. Thank you Blaine.
fitnesshealth
08-02-2007, 06:43 PM
Ok, i have tried to upload/overwrite all the files and overwrite the product. Now it's displaying as ICash 1.1.2 under Vbulletin Installed Products.
However, the negative amount donation problem still exists.
Any idea which part have i done wrong since TalkBolts mentioned that everything is working perfectly now?
I'm still getting "Successfully Donated 0 Points To nickname."
I do not dare to uninstall/remove everything and install again because i guess the points settings might be gone after doing that.
Please advise. Thank you. :)
Blaine0002
08-02-2007, 07:24 PM
You must have uploaded donate.php incorrectly because it is working fine for me :)
fitnesshealth
08-02-2007, 07:27 PM
Hmm ok. I will take note of it because i've tried uploading in both ascii and binary mode and it's still the same. Perhaps the web server is reading the cached file. I have no idea.
fitnesshealth
08-02-2007, 07:35 PM
Hi,
I have just tried again.
I donated -2 and it deducted correctly. "Successfully Donated -2 Points To nickname."
I donated -0.50 and it says "Successfully Donated 0 Points To nickname."
I donated 0.50 and it says "Successfully Donated 0 Points To nickname."
Do you still have this problem?
Blaine0002
08-02-2007, 08:20 PM
ok, so i guess i fixed the negatives but not the decimals... ill look into it.
TalkBolts
08-07-2007, 05:10 PM
Is there any way to tell who donated money to whom? I think I have some people already trying to job the system by creating new accounts using proxy IP addresses just to get more points, then donating their points to their regular account.
Blaine0002
08-07-2007, 06:41 PM
I plan on making it so theres an option to pm an admin when somone donates, would that do the job for you?
TalkBolts
08-08-2007, 07:03 PM
I plan on making it so theres an option to pm an admin when somone donates, would that do the job for you?
Best would be some sort of transaction log, but PMing the admin would at least make the info available.
TalkBolts
08-08-2007, 07:09 PM
Ok, I found a bug. A bad one.
If a user has zero posts, but has points, that user can donate the points to someone esle with out losing any points. They can give the same points over and over repeatedly basicaly creating an unlimited supply of points for whoever they want to give points to.
Blaine, if you need any help testing any fixes for this, please let me know.
TalkBolts
08-08-2007, 08:34 PM
Leave it to the users on my forum to try everything possible to cheat the system. :mad:
Is there any way to disable the abiltiy of users to donate money to each other?
Blaine0002
08-08-2007, 08:43 PM
Delete your donate.php file :)
How exactly are they cheating the system?
TalkBolts
08-08-2007, 10:33 PM
Delete your donate.php file :)
How exactly are they cheating the system?
I started everyone out with 1000.00 points. Users have found that if they find someone with zero posts, that person can donate the 1000.00 to them without losing the 1000.00. This only seems to work if the user donating has zero posts.
The zero post user will repeatedly give the points to another user as to create a virtually unlimited supply of points.
Black Tiger
08-08-2007, 11:00 PM
Hope you like it, please request some features!
Well... I have one. Wrote about it earlier, but maybe you forgot.
Suppose something goes wrong and users lose all their points.
I would like to request a possibility, to give users their points back related to their postcount.
F.e. If they have a postcount of 25 posts, they get 25 times a configurable amount of points back, if all points are lost in de database, by running some option in the ACP.
I don't know if such thing can be made related to the forums, so they won't get points for forumparts which do not give points, but maybe something like that is possible to build related to the search index or something like that, I don't know.
Personally I would already be happy with a kind of point restore options f.e. via the postcount.
Blaine0002
08-09-2007, 01:39 PM
i Could do something like that, it would be hard to do it using points per character though.
Black Tiger
08-09-2007, 02:08 PM
That would be difficult indeed, but it would already be nice if there was some kind of restore possibility. Points per new thread/per reply would be a nice start.:)
wickland
08-09-2007, 06:38 PM
Can you describe the referral system in regards to your software?
I am wondering how automatic it would be for a referrer to get credits for bringing in new members and also how they can exchange those credits for services.
Thanks
TalkBolts
08-09-2007, 09:42 PM
Blaine, any ideas about this bug that allows users to cheat the system?
TalkBolts
08-10-2007, 08:29 PM
Blaine, are you at least able to reproduce this problem?
Blaine0002
08-11-2007, 09:18 PM
ill look into it, your giving it to the users upon registration?
McCarroll21
08-12-2007, 02:16 AM
Is there a way you can manually put in their amount of iCash so we can manually take some away?
I know you can manually donate through the Admin Donate, but can you manually take away too? If so, how? If not, can it be implemented?
TalkBolts
08-12-2007, 09:11 AM
ill look into it, your giving it to the users upon registration?
Yes, that's correct. They were getting points at registration. Thank you very much for checking into this.
TalkBolts
08-12-2007, 09:12 AM
Is there a way you can manually put in their amount of iCash so we can manually take some away?
I know you can manually donate through the Admin Donate, but can you manually take away too? If so, how? If not, can it be implemented?
Just give the person a negative dollar amount and it'll take it away from them.
vitnuce
08-13-2007, 08:24 AM
New bug: People can send the bigger amount than they have. Ex: A have 1 point on hand, and he can donate to B with amount: 1000; After that, A have -999 points.
Because this code doesn't work:
if ($vbulletin->userinfo[$vbulletin->options['icashf']] - $vbuletin->GPC['amount'] < 0){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
change it to
if ($vbulletin->userinfo[$vbulletin->options['icashf']] - $vbulletin->GPC['amount'] < 0){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
or
if ($vbulletin->userinfo[$vbulletin->options['icashf']] < $vbulletin->GPC['amount'] ){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
Blaine0002
08-13-2007, 02:42 PM
Doh! thanks for pointing that out :)
vitnuce
08-14-2007, 09:37 AM
Update: User may donate negative amout to other. Replace
if ($vbulletin->userinfo[$vbulletin->options['icashf']] - $vbuletin->GPC['amount'] < 0){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
by
if ($vbulletin->userinfo[$vbulletin->options['icashf']] < $vbulletin->GPC['amount'] ){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
if ($vbulletin->GPC['amount'] < 0){
eval(standard_error(fetch_error('error_icash_donth ave')));
}
:(
4newbies
08-20-2007, 06:03 PM
Anyone know if Version 1.1.4 of this has been tested and works with older vB version 3.6.5?
Seems like there should also be a admin panel option to just disable member donations to for people who just wish to avoid the potencial exploits all together with this function.
Black Tiger
08-20-2007, 09:46 PM
Anyone know if Version 1.1.4 of this has been tested and works with older vB version 3.6.5?
Which 1.1.4? We are just at 1.1.2 so there isn't even a 1.1.4.
Maybe wrong thread? I have Icash running at 3.6.8 and in the ACP there is no option to disable member donations. I just deleted the "donate.php" from the forum home directory. And did not at the "donate" line to postbit and postbit-legacy. That works great.
MadKad
08-23-2007, 04:46 PM
Please can some one help, I have tried this
https://vborg.vbsupport.ru/showpost.php?p=1316398&postcount=914
and the problem is still there :(
4newbies
08-27-2007, 05:22 PM
I just installed this along with the latest version of iShop over older versions of iCash & iShop to take advantage of the feature that supposedly removes points when posts are deleted. However, this function does not work for my forum. I tried both "soft-deleting" and "physically removing" posts but the member's amount of points stays the same.
What could be the problem?
I am using vB version 3.6.8
SBlueman
09-04-2007, 04:49 AM
I updated and am getting this DB error:
Warning: Unknown(/home/sblueman/public_html/forums/includes/functions_icash.php): failed to open stream: No such file or directory in /home/sblueman/public_html/forums/includes/functions_newpost.php(360) : eval()'d code on line 20
Warning: (null)() [function.include]: Failed opening '/home/sblueman/public_html/forums/includes/functions_icash.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/sblueman/public_html/forums/includes/functions_newpost.php(360) : eval()'d code on line 20
Fatal error: Call to undefined function: icash_points() in /home/sblueman/public_html/forums/includes/functions_newpost.php(360) : eval()'d code on line 21
Blaine0002
09-04-2007, 04:37 PM
Make sure you have uploaded and overwritten all files when you update :)
scart3r
09-06-2007, 06:37 AM
OK, I need help. I have spent hours looking through this massive thread and still can't find the answer.... so don't tell me to just look through the thread! I honestly don't have any more time to spend working through it all.
My problem? Here is my forum: www.nettrafficchat.com
I have installed it, but when a post is made it says that it's a duplicate post. I have seen ppl reporting this problem, but can't find the solution. If someone can help me that would be awesome. Also, my points are not going up - so, basically the system isn't working....
I found posts like this : https://vborg.vbsupport.ru/showpost.php?p=1272830&postcount=741 which don't really tell me what i need to do to fix it.
Can someone help? This is the second time that I have tried to fix this - the last time I was put off of coming back because people jsut told me to read through the thread. I am honestly not lazy - I did, can't find it.
PLEASE HELP!
Veronica Vain
09-06-2007, 09:52 AM
I have every thing installed and I did the modifications nothing is showing up here is my code from my postbit can anyoen help me?
<!-- Brought to you by vBShazz.com -->
<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" $post[scrolltothis]>
<div class="normal" style="float:$stylevar[right]">
<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> </if>
<if condition="$show['reputationlink']">
<span id="reputationmenu_$post[postid]"><a href="reputation.php?$session[sessionurl]p=$post[postid]" rel="nofollow" id="reputation_$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/reputation.gif" alt="<phrase 1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase>" border="0" /></a></span>
<if condition="$show['popups']"><script type="text/javascript"> vbrep_register("$post[postid]")</script></if>
</if>
<if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a> </if>
<if condition="$show['reportlink']"><a href="report.php?$session[sessionurl]p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/report.gif" alt="$vbphrase[report_bad_post]" border="0" /></a> </if>
$post[iplogged]
<if condition="$show['inlinemod']">
<input type="checkbox" name="plist[$postid]" id="plist_$postid" style="vertical-align:middle; padding:0px; margin:0px 0px 0px 5px" value="$post[checkbox_value]" />
</if>
</div>
<div class="normal">
<!-- status icon and date -->
<a name="post$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif" alt="$post[statustitle]" border="0" /></a>
<if condition="!$show['announcement']">
$post[postdate]<if condition="!$show['detailedtime']">, $post[posttime]</if>
<else />
<phrase 1="$post[startdate]" 2="$post[enddate]">$vbphrase[x_until_y]</phrase>
</if>
$post[firstnewinsert]
<!-- / status icon and date -->
</div>
</td>
</tr>
<tr>
<td class="alt2" style="padding:0px">
<!-- user info -->
<table cellpadding="0" cellspacing="$stylevar[cellpadding]" border="0" width="100%">
<tr>
<if condition="$show['avatar']"><td class="alt2"><a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$post[avatarurl]" $post[avwidth] $post[avheight] alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a></td></if>
<td nowrap="nowrap">
<table cellpadding="2" cellspacing="0" border="0">
<tr>
<td align="center">
<div id="postmenu_$post[postid]">
<if condition="$show['profile']">
<a class="bigusername" href="member.php?$session[sessionurl]u=$post[userid]">$post[musername]</a>
$post[onlinestatus]
<script type="text/javascript"> vbmenu_register("postmenu_$post[postid]", true); </script>
<else />
$post[musername]
</if>
</div>
</td>
</tr>
<if condition="$post['usertitle']"><tr>
<td align="center"><div class="smallfont">$post[usertitle]</div></td></tr></if>
<if condition="$post['rank']"><tr><td align="center"><div class="smallfont">$post[rank]</div></td></tr></if>
</table>
</td>
<td width="100%"> </td>
<td valign="top" nowrap="nowrap">
<table width="200" cellspacing="3" cellpadding="0" border="0"><tr>
<td valign="top">
<if condition="$show['reputation']">
<fieldset class="fieldset"><legend><b>Reputation</b>:</legend><if condition="$show['reputation']">Rep: $post[reputation]<br />
<marquee width="180" scrollamount="3">$post[reputationdisplay]</marquee></if></fieldset></if>
</td>
<td valign="top"><fieldset class="fieldset"><legend><b>Arcade</b></legend><div class="smallfont">$post[crowns]$post[champtext]<br /></div></fieldset>
<fieldset class="fieldset"><legend><b>Forum Stats</b></legend><div class="smallfont">
<if condition="$show['last_seen_online']"><div>$vbphrase[last_seen_online]: $post[lastseen_date] $post[lastseen_time]</div></if><if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>
<if condition="$post['age']"><div>$vbphrase[age]: $post[age]</div></if>
<div>
$vbphrase[posts]: $post[posts]
</div></fieldset>
<fieldset class="fieldset"><legend><b>Contact</b>:</legend>
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>$vboptions[icashn]: $post[money]
<br>
<a href="donate.php?$session[sessionurl]to=$post[username]">Donate</a>
<!-- show awards -->
<if condition="$post[showuserawards]">
<fieldset><legend><a href="member.php?u=$post[userid]#award" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]#award" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</fieldset>
</if>
<!-- /show awards -->
</fieldset>
</tr></table>
</div>
</td>
</tr>
</table>
<!-- / user info -->
</td>
</tr>
<tr>
<td class="alt1" id="td_post_$post[postid]">
<!-- message, attachments, sig -->
<if condition="$show['messageicon'] OR $post['title']">
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if condition="$post['title']"><strong>$post[title]</strong></if>
</div>
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
</if>
<!-- message -->
<div id="post_message_$post[postid]">$post[message]</div>
<!-- / message -->
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">
<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[thumbnailattachments]
</div>
</fieldset>
</if>
<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">
$post[imageattachments]
</div>
</fieldset>
</if>
<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>
<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[otherattachments]
</table>
</fieldset>
</if>
<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>
</div>
<!-- / attachments -->
</if>
<if condition="$post['signature']">
<!-- sig -->
<div>
__________________<br />
$post[signature]
</div>
<!-- / sig -->
</if>
<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont"> <hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>.
<if condition="$post['edit_reason']">$vbphrase[reason]: $post[edit_reason]</if>
</em>
</div>
<!-- / edit note -->
</if>
<div style="margin-top: 10px" align="$stylevar[right]">
<!-- controls -->
<if condition="$post['editlink']">
<img style="display: none" id="progress_$postid" src="$stylevar[imgdir_misc]/progress.gif" alt="$vbphrase[loading_editor_please_wait]" />
<a href="$post[editlink]" name="vB::QuickEdit::$post[postid]"><img src="$stylevar[imgdir_button]/edit.gif" alt="$vbphrase[edit_delete_message]" border="0" /></a>
</if>
<if condition="$post['forwardlink']">
<a href="$post[forwardlink]"><img src="$stylevar[imgdir_button]/forward.gif" alt="$vbphrase[forward_message]" border="0" /></a>
</if>
<if condition="$post['replylink']">
<a href="$post[replylink]" rel="nofollow"><img src="$stylevar[imgdir_button]/<if condition="$post['forwardlink']">reply_small<else />quote</if>.gif" alt="$vbphrase[reply_with_quote]" border="0" /></a>
</if>
<if condition="$show['multiquote_post']">
<a href="$post[replylink]" rel="nofollow" onclick="return false"><img src="$stylevar[imgdir_button]/multiquote_<if condition="$show['multiquote_selected']">on<else />off</if>.gif" alt="$vbphrase[multi_quote_this_message]" border="0" id="mq_$post[postid]" /></a>
</if>
<if condition="$show['quickreply'] AND !$show['threadedmode']">
<a href="$post[replylink]" rel="nofollow" id="qr_$post[postid]" onclick="return false"><img src="$stylevar[imgdir_button]/quickreply.gif" alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a>
</if>
<if condition="$show['moderated']">
<img src="$stylevar[imgdir_misc]/moderated.gif" alt="$vbphrase[moderated_post]" border="0" />
</if>
<if condition="$show['deletedpost']">
<img src="$stylevar[imgdir_misc]/trashcan.gif" alt="$vbphrase[deleted_post]" border="0" />
</if>
<if condition="$show['redcard']">
<a href="infraction.php?$session[sessionurl]do=view&p=$post[postid]"><img src="$stylevar[imgdir_button]/redcard.gif" alt="$vbphrase[received_infraction]" border="0" /></a>
<else />
<if condition="$show['yellowcard']">
<a href="infraction.php?$session[sessionurl]do=view&p=$post[postid]"><img src="$stylevar[imgdir_button]/yellowcard.gif" alt="$vbphrase[received_warning]" border="0" /></a>
</if>
</if>
<!-- / controls -->
</div>
<!-- message, attachments, sig -->
<!-- / Brought to you by vBSHazz.com -->
</td>
</tr>
<if condition="$vboptions['bsh_enabled'] AND ($post['acceptbattles'] OR $post['battle_wins'] > 0 OR $post['battle_losses'] > 0) AND in_array(THIS_SCRIPT, array('showthread', 'showpost', 'editpost'))">
<tr class="thead">
<td style="padding:0px"<if condition="$vboptions['legacypostbit']"> colspan="2"</if>>
</td>
</tr>
</if>
</table>
<!-- post $post[postid] popup menu -->
<div class="vbmenu_popup" id="postmenu_$post[postid]_menu" style="display:none;">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$post[username]</td>
</tr>
<if condition="$show['profile']">
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$post[userid]">$vbphrase[view_public_profile]</a></td></tr>
</if>
<if condition="$show['pmlink']">
<tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]do=newpm&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[send_private_message_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['emaillink']">
<tr><td class="vbmenu_option"><a href="sendmessage.php?$session[sessionurl]do=mailmember&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[send_email_to_x]</phrase></a></td></tr>
</if>
<if condition="$show['homepage']">
<tr><td class="vbmenu_option"><a href="$post[homepage]"><phrase 1="$post[username]">$vbphrase[visit_xs_homepage]</phrase></a></td></tr>
</if>
<if condition="$show['search']">
<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=finduser&u=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[find_all_posts_by_x]</phrase></a></td></tr>
</if>
<if condition="$post['userid'] AND $show['member']">
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&userlist=buddy&u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
</if>
</table>
</div>
<!-- / post $post[postid] popup menu -->
<!-- / Brought to you by vBShazz.com -->
Blaine0002
09-06-2007, 06:58 PM
OK, I need help. I have spent hours looking through this massive thread and still can't find the answer.... so don't tell me to just look through the thread! I honestly don't have any more time to spend working through it all.
My problem? Here is my forum: www.nettrafficchat.com
I have installed it, but when a post is made it says that it's a duplicate post. I have seen ppl reporting this problem, but can't find the solution. If someone can help me that would be awesome. Also, my points are not going up - so, basically the system isn't working....
I found posts like this : https://vborg.vbsupport.ru/showpost.php?p=1272830&postcount=741 which don't really tell me what i need to do to fix it.
Can someone help? This is the second time that I have tried to fix this - the last time I was put off of coming back because people jsut told me to read through the thread. I am honestly not lazy - I did, can't find it.
PLEASE HELP!
Odd i thaught i fixed this, ill look at it.
And @ veronica
If you have changed your money row, change the postbit accordingly
Find $post[money] change to $post[moneyrow] ect.
scart3r
09-06-2007, 10:06 PM
Odd i thaught i fixed this, ill look at it.
Thank you SO much!
Veronica Vain
09-07-2007, 05:11 AM
well i reverted back to what you had orginally but its still not working for some reason. It shows up in the members info but not in the post bit. Do i need to change the post bit legacy?
scart3r
09-07-2007, 11:37 AM
I fixed the duplicate post thing. I forgot to click the over write box... entirely my fault.
Thanks for offering to check it out though :D
EDIT: Sorry - I spoke too soon! The problem is still happening, every time I post :( I am sorry - I still need your help.
Blaine0002
09-07-2007, 05:36 PM
well i reverted back to what you had orginally but its still not working for some reason. It shows up in the members info but not in the post bit. Do i need to change the post bit legacy?
depends on the postbit you are using.
Veronica Vain
09-08-2007, 12:57 AM
im so lost and it doesnt even say donate on the member page. Can anyone help me? Show I post my post bit again?
Black Tiger
09-08-2007, 02:52 PM
I would like to help you, but just to be sure, just put the code in the postbit_legacy too.
Veronica Vain
09-10-2007, 06:24 AM
this is still not working, any one interested in fixign this for me I am willing to pay
Blaine0002
09-11-2007, 12:37 AM
after you reverted the template did you re apply the edit to both postbit and postbit legacy?
GamingAttic
09-11-2007, 12:59 AM
I just installed it, but i have a bunch of activty already, is there a way to make it so that it can give points for things that happend before? like for the referals before, and the posts before? or is that not possible and everyone is just gunna have to start at 0?
Blaine0002
09-11-2007, 01:11 AM
There is no built in function to do this, but it would not be hard to achieve if another coder was up to it, i myself am too busy to even update this mod... sorry :(
GamingAttic
09-11-2007, 01:18 AM
hmm, i just installed iCash, and it shows up as 0.00 in Postbit, but when i post or anyone else posts it doesn't do anything. I edited the main iCash options, and it says Enable points, and for the points per charector/thread/post are activated, yet still nothing, am i forgetting something?
Blaine0002
09-11-2007, 01:18 AM
Odd, check the plugins page and make sure everything under the icash section is enabled.
GamingAttic
09-11-2007, 01:20 AM
Yup it's enabled, I added you to AIM/Yahoo/MSN, if you have a min i'd be very apriciatve if you could log in quick, and maybe take a look at my admincp. its on vb3.6.8 I dunno if that matters, but i did everything it said. Thanks for the quick reply.
Blaine0002
09-21-2007, 12:37 AM
Seems to be a wierd bug..
It started to work for me when i went into the forum options , checked to make sure the data was entered, and resubmitted it.
Ill see what I can do about this.
Try rebuilding your bitfields!
ArchangelX
09-21-2007, 09:06 PM
Has anyone wrote any plug-ins that work with the Arcade? Specifically, to award points for winning games. Thanks.
Black Tiger
09-21-2007, 09:51 PM
Not that I know of, but you could do a search in this mod for "arcade" because Blaine himselve gave an example how to easy configure this. Because there is already a hook present for the Arcade in Icash.
I now have it so that playing costs an x amount of credits and if you win the highscore, you get a certain amount of credits.
No credits for winning games though, only if you have the highscore.
ArchangelX
09-21-2007, 11:43 PM
My problem is that I'm not very good at coding. Would you be able to share your edits? That's basically what I'm asking...sorry!
falbinali
09-24-2007, 04:22 AM
On some of my forums I set the iCash to 0 so posts made in those forums will not count towards their money but they are still earning, what do you think is the problem.
Also, when posts are deleted their iCash still remains the same, not sure what the problem is? Thanks for any help!
Blaine0002
09-24-2007, 10:28 PM
yeah those are confirmed bugs and will be fixed in the next version.
ArchangelX
09-24-2007, 10:34 PM
Blaine, I just wanted to say thanks for all the hard work. It's a great mod, and my forum users love it. :D
Do you have a Paypal? Thanks.
Blaine0002
09-24-2007, 11:57 PM
Check the top post, and you will see a link on the right varifying my paypal and a donation button.
All donations are greatly appreciated cause they pay for gas and my girlfriend :):) XD
Black Tiger
09-25-2007, 01:46 AM
Blaine, you're great... but ehm.. why you got "banned" next to your username?
You're still able to post here (luckily!), somebody made some mistake with your account?
Blaine0002
09-25-2007, 01:25 PM
Lol yesterday i was banned on accadent... XD
and i wasnt able to post. It was entertaining.
Black Tiger
09-25-2007, 02:03 PM
Oh... I'm sooo glad it was a mistake. Good to hear (and see) it's oke again.:)
ArchangelX
09-27-2007, 12:26 AM
Blaine, is there any way you could code an option to reset all users' points, along with the IBank?
To be honest, someone figured out an exploit in the casino, and now there's a couple of people who I don't know that have a gazillion points. I'd like to be able to reset them all, including the IBank.
StarDome
10-01-2007, 01:18 AM
So this works with Vb 3.6.1. correct?
Edit: I have installed this mod, and for some reason I cannot remove cash even with the option enabled, why?
x350x
10-06-2007, 07:00 PM
hey can u help me make this work with ishop please i have both installed and setup just need help making it work with ishop
Blaine0002
10-06-2007, 08:11 PM
make sure your icash money row matcxhes your ishop money row in the respective options pages.
I have some questions, cause maybe this mod could be the one I'm searching for. :cool:
In my previous site I was using phpbb2 cash mod: is ICash something like that?
Can I manage different types of points?
Can moderators assign points to users?
And above all, can I use ICash on vbulletin 3.6.8.? :erm:
Thanks. :)
Blaine0002
10-06-2007, 10:09 PM
Different types of points? please elaborate.
But to your other 2 questions, yes!
Different types of points? please elaborate.
But to your other 2 questions, yes!
Wonderful! :)
About different types of points... it's hard to explain... :o
I have a gaming site; we play various games by forum, such as master mind, quiz and so on. With phpbb2 cash mod I had created many points fields, such as point_mastermind, point_quiz and so on. So in postbit were shown user's mastermind points, quiz points...
Sorry for my poor english, if it is not clear I'll try to explain it better :o
Just another question: can it work with vbcredits?
ArchangelX
10-08-2007, 03:01 AM
I found a huge bug.
If you have at least 1 point...you can donate whatever you want to someone else. I had users donating each other millions of points.
Any ideas on how to fix this? Is there no check to see what's in their account? It's a pretty bad bug...and easily exploitable. I'll have to remove it from the system if we can't get it fixed.
ArchangelX
10-08-2007, 03:18 AM
I think I found it...let me test.
ArchangelX
10-08-2007, 03:22 AM
Yepz. Found it.
There's a typo on the $vbulletin variable on line 169 in icash.php. It's spelled $vbuletin not $vbulletin. Fix that, and the code runs fine.
Line169: if ($vbulletin->userinfo[$vbulletin->options['icashf']] - $vbulletin->GPC['amount'] < 0){
I know it says this is for 3.5.8, but I am using 3.6.8 and it seems none of my user are gaining points when posting or making new threads.
Suggestions?
Black Tiger
10-16-2007, 11:08 PM
There's a typo on the $vbulletin variable on line 169 in icash.php.
Found a bug in your solution.:D
It's not icash.php but donate.php but good job you've found it!
ArchangelX
10-16-2007, 11:34 PM
Woops. Sorry! Thanks!
Oh, and it's actually line 85 if you're editing the file in the .zip. For some reason, once uploaded to my server, the files get a few spaces added inbetween the code. Go figure. :)
Blaine0002
10-16-2007, 11:58 PM
i cant believe i let something so stupid slip
oh well stuff happens
ill fix on next release.
ArchangelX
10-17-2007, 12:55 AM
Blah...no biggie! Your mods are the best! I'll make sure to paypal ya before the end of the week (I spent alotta money this weekend and my wife is on my case, hah!). Your mods have really blown away my forum users, and they really appreciate it!
Oh, and one more error, I think...I'll look through the code to see if it's a quick fix but I got this from one of my users:
you can apparently steal money from other people just putting in a negative amount and their name.
archangelx : -2147483648
archangelx : 2147483647
I actually took 100 million from you and returned it back...but it must freak out the system and it wont show the actual number.
This is different from the other bug where I can donate to someone else and make myself go negative...now I can do the complete opposite.
Blaine0002
10-17-2007, 05:29 PM
Ill look into it thanks.
qtouch
10-18-2007, 04:04 AM
Just installed this but don't see anything in the postbit
Blaine0002
10-18-2007, 09:59 AM
You need to do the postbit edit thats included in the installation.txt file
ChampJames
10-20-2007, 04:56 PM
I have all the files installed by members cant seem to find how to donate cash, any help?
AMcKay
10-20-2007, 08:55 PM
I'm running 3.6.8, unfortunately, it seems that whenever someone gets points for a post, then the post is deleted, the points they received are still there. And I've checked and double-checked that point negation is turned on and all the plugins are turned on also. Is this because my version of vbulletin is newer, or is it a bug?
Black Tiger
10-20-2007, 09:29 PM
@ChampJames: Have you also edited the postbit and/or postbit_legacy templates?
CoryNickerson
10-21-2007, 07:45 PM
theres a major exploit which messed up my website. It allows anyone to send any ammount of forum gold and take away forum gold. Can this be fixed ASAP!?
please contact me as soon as you can.
Machii
10-26-2007, 03:17 PM
Hi, sorry but I'm new here, I'm trying this great addon but I have small problem. Everything works great but I couldn't set the amount for new post and character. Here is the screenshot (http://img510.imageshack.us/img510/677/icses2.png), please help, where should I find it? thanks
Black Tiger
10-26-2007, 03:22 PM
I couldn't set the amount for new post and character.
You can set this seperate in every forum in the forum manager (ACP).
Machii
10-26-2007, 03:30 PM
You can set this seperate in every forum in the forum manager (ACP).
Oh, thanks :) It's my first addon, so... :)
tropicon
10-31-2007, 03:53 PM
I installed icash, users don`t get points for posting, only for signup and referral, why?
And you can donate negative points or more points then you have, then the other user has negative points.
Blaine0002
10-31-2007, 05:31 PM
you need to go into the forum settings and edit the amount of points given.
The donate bug has a fix a few posts above.
tropicon
10-31-2007, 11:29 PM
Ok, the bug with negative donations fixed, spelling error in line 89 donate.php.
But still no points for posts or thread, VB 3.6.8.
Black Tiger
10-31-2007, 11:43 PM
But still no points for posts or thread, VB 3.6.8.
You did set up points for this in each forum via the forum manager in the ACP -and- enabled these options in the configuration of icash in the ACP?
Racecar
11-04-2007, 12:02 AM
What about gifts?
deezelpope
11-04-2007, 12:06 AM
<i>IShop.</i>
golfing
11-07-2007, 08:51 AM
Does this icash hack work on the rpg hack
Blaine0002
11-07-2007, 07:38 PM
which rpg hack?
ShawneyJ
11-08-2007, 12:35 AM
which rpg hack?
RPG Integration Hack v3.5.1 Patch Level 2
Blaine0002
11-08-2007, 12:21 PM
Yes it will work.
tropicon
11-10-2007, 09:53 AM
Ok, now working fine!
I search over this thread and I found two hints but no real answers. The first hint was a user with all of 4 posts making a hit and run reply that makes sense.
You can do it with a small edition of Number Format in XML File then reinstall the mod with Overwrite checked !
The second was what it seems to be instructions on how to ADD the decimal.. Which means there may have been a point when the decimal was not used/displayed. I personally would like to see a small addition that could enable or disable the decimal but I'll take what I can get. This modification along with iShop and iBank will be responsible for many happy members on our forums.
https://vborg.vbsupport.ru/showpost.php?p=1115447&postcount=172
Thanks for any help.
Blaine0002
11-10-2007, 03:44 PM
simply reverse it and run
alter table user modify money int(15);
ThreeD
11-13-2007, 01:06 PM
Hey Blaine, I used this hack when it first was released until a few security issues were detected . I decided to uninstall it until everything was solved and patched. What's the status now? Have you received any negative feedback concerning security or is it all safe and sound? :)
I really liked this system and so did our community!
PS: This works with 3.6.8 right?
deezelpope
11-13-2007, 01:15 PM
<i>It's secure...if it wasn't, it'd be in the Graveyard. And yes, I believe it works with 3.6.8.</i>
Black Tiger
11-13-2007, 01:53 PM
Yep, it's running with 3.6.8 and the security issues were fixed pretty short after they were announced.
Alphawolf83
11-21-2007, 08:28 PM
Hey there,
are there sceenshots and/or a changelog? Thanks. ;)
Blaine0002
11-21-2007, 09:34 PM
updated version coming soon. :)
LouiseWilson
11-22-2007, 01:07 AM
good ill take a look when its updated :)
reebok008
11-22-2007, 07:26 AM
I get this error when create a new topic in one of over 20 forums, some users get it every time they make a new post or create new topic.
What may be causing this issue?
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE vb_user
SET `money` = `money` + 0,15
WHERE userid = '3';
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 '15
WHERE userid = '3'' at line 2
Error Number : 1064
Date : Thursday, November 22nd 2007 @ 11:59:33 AM
Script : http://*****forum.net/newthread.php?do=postthread&f=12
Referrer : http://*****forum.net/newthread.php?do=newthread&f=12
IP Address : ***hidden***
Username : John
Classname : vB_Database
Alphawolf83
11-22-2007, 11:48 AM
updated version coming soon. :)
Well, thanks for your work, but I'd rather like to see what changed in the newest version since I am still running an older version and am unsure either to upgrade or not. :)
fishhub
11-22-2007, 05:09 PM
what if I do this:
1. pause the forum
2. go to cpanel->phpmyadmin and rename the money field to 'vbookie_cash'
3. change icash settings (admincp->icash->'money row') to 'vbookie_cash'
4. install vbookie
5. activate forum
Unless I'm missing something, this should work, right?
I tried to simply typed in vbookie_cash in money row in admincp. But cant seem to place bets in vbookie and i get an error msg once i post replies.
Tried the above but how do i do item 2?
What is phpmyadmin? Where do i find it. Sorry, am new.TIA:o
Blaine0002
11-22-2007, 11:36 PM
it might be because vbookie uses a double as its field type whereas icash uses int, this will be fixed in the next release.
fishhub
11-23-2007, 11:04 AM
it might be because vbookie uses a double as its field type whereas icash uses int, this will be fixed in the next release.
Thanks for e info.
However, i set it back to Icash and tried using it. It does not show any points added upon several post. And as guest , i can donate to anyone. Am using 3.5.4. Hope someone canhelp out. TIA.
Blaine0002
11-24-2007, 03:46 PM
set it to 'money' (without the 's)
reebok008
11-24-2007, 08:38 PM
I get this error when create a new topic in one of over 20 forums, some users get it every time they make a new post or create new topic.
What may be causing this issue?
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE vb_user
SET `money` = `money` + 0,15
WHERE userid = '3';
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 '15
WHERE userid = '3'' at line 2
Error Number : 1064
Date : Thursday, November 22nd 2007 @ 11:59:33 AM
Script : http://*****forum.net/newthread.php?do=postthread&f=12
Referrer : http://*****forum.net/newthread.php?do=newthread&f=12
IP Address : ***hidden***
Username : John
Classname : vB_Database
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.