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)

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..

Quote:

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


Quote:

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

Code:

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

Quote:

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...reply&t=245754
Referrer : http://www.simalert.com/dev/newreply...te=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

Quote:

Originally Posted by Vinyljunky (Post 1276160)
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

Code:

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

Quote:

Originally Posted by Chase (Post 1277808)
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/new...ostthread&f=33
Referrer : http://www.forums.easyforumz.com/new...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

Quote:

Originally Posted by agent_smith (Post 1279299)
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

Quote:

Originally Posted by deezelpope (Post 1285073)
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?


All times are GMT. The time now is 08:49 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.02158 seconds
  • Memory Usage 1,826KB
  • 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
  • (2)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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