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.


All times are GMT. The time now is 08:59 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.01631 seconds
  • Memory Usage 1,736KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete