Your Ads Here
Advertise with Western Studios.
www.westernstudios.net

Theme Shop
Get the best in phpnuke themes, stock photos, icons from Western Studios themes shop.
shop.westernstudios.net

PHP Nuke Downloads
The latest and best in php nuke downloads.
www.westernstudios.net

PHP Nuke Subscription
The #1 php nuke subscription module.
www.westernstudios.net

Live Tutorials
PHP, Photoshop, flash, illustrator tutorials.
www.live-tutorials.com


Advertise Here


Western Studios :: View topic - Cash Mod
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups     ProfileProfile   Log inLog in 


Cash Mod


Goto page 1, 2  Next
 
Post new topic   Reply to topicprinter friendly version    Western Studios Forum Index -> Hack and Mods
Western Studios

WS Newbie
WS Newbie
~PHP Nuke User~


Posts: 18
Next Group: 32 posts
SilentKaos wrote:

Having some trouble with the cash mod recieving the following error
Error retrieving group data

DEBUG MODE

SQL Error : 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 'AND user_pending = 0 ORDER BY group_id ASC' at line 4

SELECT group_id FROM nuke_bbuser_group WHERE user_id = AND user_pending = 0 ORDER BY group_id ASC

Line : 1219
File : functions_cash.php

I have tried various ways to fix this problem and Im just to the point of ripping my hair out. Any assistance would be greatly appreciated.

Posted: Tue May 29, 2007 12:46 am

Western Studios

Site Admin
Site Admin
~PHP Nuke User~

Platinum Subscriber

Posts: 3236
Staff
Next Group: 1764 posts
admin(Mark) wrote:

I am not sure why the userid is not being passed. Try placing the " . $this->user_id . " within a quote ''

On line 1214 change

Code:
               WHERE user_id = " . $this->user_id . "


To:
Code:
               WHERE user_id = '" . $this->user_id . "'


Posted: Tue May 29, 2007 2:20 am

Western Studios

WS Newbie
WS Newbie
~PHP Nuke User~


Posts: 18
Next Group: 32 posts
SilentKaos wrote:

tried that it shot out this error
Code:
Error updating user data

DEBUG MODE

SQL Error : 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 '' at line 3

UPDATE nuke_users SET user_points = user_points + 2 WHERE user_id =

Line : 1275
File : functions_cash.php
is it possible I may have an error in mysql

Posted: Tue May 29, 2007 2:29 am

Western Studios

Site Admin
Site Admin
~PHP Nuke User~

Platinum Subscriber

Posts: 3236
Staff
Next Group: 1764 posts
admin(Mark) wrote:

Do you only get errors with the mod or does the rest of your website output errors?
It seems the first error has been sorted. I think you need to place all those userid within a quote ''.

On line 1272 change:
Code:
               WHERE user_id = " . $this->user_id;


To:
Code:
               WHERE user_id = '" . $this->user_id."'";


I think you will need to do similar with the where clauses.

Posted: Tue May 29, 2007 2:37 am

Western Studios

WS Newbie
WS Newbie
~PHP Nuke User~


Posts: 18
Next Group: 32 posts
SilentKaos wrote:

well what it is, I had a site that had 7.4 nuke installed with 2.0.10 but was fully modded I descided to upgrade to Ravens 7.6 nuke and have installed all my mods. Now the cash mod works just fine with a test account etc. But I tried to import my users over to the new nuke_users table I get a syntax error. So I dropped the entire nuke_users table and just ran the old data nuke_users table from my past 7.4 nuke and I get an error with the cash mod.

Posted: Tue May 29, 2007 2:41 am

Post new topic   Reply to topic    Western Studios Forum Index -> PHP Nuke -> Hack and Mods All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Related topics
 Topics   Replies   Author   Views   Last Post 
No new posts PHP paste bin added 0 admin 683 Wed Mar 23, 2005 6:47 pm
admin View latest post
No new posts PHP Nuke klips 0 admin 556 Fri Mar 18, 2005 6:52 pm
admin View latest post
No new posts Paypal success.php 1 Jabba 714 Fri Mar 04, 2005 7:00 pm
admin View latest post
No new posts Testing PHP tags 2 admin 699 Thu Mar 03, 2005 6:06 pm
admin View latest post
No new posts PHP Nuke Icons 0 admin 725 Mon Aug 23, 2004 4:05 pm
admin View latest post
 
Forums ©