Codezwiz >> Forums >> Codezwiz BBtoNuke Mods Help >> Combine phpnuke points to cash mod user points

I am currently running phpnuke 7.7 with cash mod 221 what my question is how do i combine the tables points and user points?

I have searched across several forums trying to figure this out the code i got from this forum is

mainfile.php

$db->sql_query("UPDATE ".$user_prefix."_users SET user_points=user_points+$row[points] WHERE username='$username'");

What do you mean combine together? You mean you want the total points from each field added up? Best bet would be to edit that line in your mainfile and just drop the points field altogether. If you want to add up the totals first let me know and I try to write you a little query to do it.

basically php nuke gives points for forum posts, news post .....etc
i added this code to my mainfile.php

$db->sql_query("UPDATE ".$user_prefix."_users SET user_points=user_points+$row[points] WHERE username='$username'");

In combining the features of both all you need to do is to edit some simple figures at the database, this means that you have to have an access at your database you are using, phpyMyadmin would be our case whatsoever in this module.

First, thing you need to install the CashMod module also you have to have a Nuke Points installed, then after installation pre-define your currencies, any currency will do all you need to have is one entry at the moment.

Second, access your database through your cPanel, you have an access if you are the owner of such webhosting account, then look to these database table named "nuke_bbcash", if you have a different prefix then "something_bbcash". Click the browse button to view this table and you will see something like "user_points", "user_cash", "user_what-so-ever-u-named-it" then edit this entry and rename it to "points",

Third, now it would seems that you have two entries in this matter, the pre-defined "points field" for nuke points and the "user_points" from Cash mod, you then have to delete the "points", and renaming the "user_points" or simply you could delete the latter fi you don't know how to edit the field to be have a decimal point, then its all set and you can test it out.

I found this out when editing most script files and noticed that most script files used the default "points" as their points_name so why not do the other way around and edit cashmod instead.

Regardless, I am having bugs in this CashMod whether its caused by these edits or whatsoever. I am running a Nuke 7.8.31 and a phpBB 2.0.17 version
with a ported CashMod 2.2.2 version and seems that when you look into the Memberlist through the forums, the points don't show up and instead leaving a clean columns after "Post".

PS :edited:
It works at exchange points what-so-ever, and that was fun. but if you want to show the decimal value to the "CZ member block"?? if you have your points entry at cash mod with a decimal value most commonly the members block shows this as a whole number, it shows but doesnt change the original value. which in this case there is a code

$userpoints = number_format($userinfo[$sitepoints]);

Since I don't know much about php and database other than mysql, since im just a newbie in this line of knowledge, I can't be able to do much help from this. Here is a 3-line simple sql queries to do the things mentioned above much easier. You can make a blank sql file and paste this code below then upload it your sql database from your phpMyAdmin, i dont know much about other database if this lines would be valid.

UPDATE `nuke_bbcash` SET `cash_dbfield` = 'points' WHERE `cash_id` =1 LIMIT 1 ;
ALTER TABLE `nuke_users` CHANGE `points` `points` DECIMAL( 11, 2 ) NOT NULL DEFAULT '0.00';
ALTER TABLE `nuke_users` DROP `user_points`;

I was working on this for a new site and what i did was go into phpmyadmin and change the table to points instead of user_points which the cash mod expects you to use and so far its working. Is it that easy or will i come up with some problems?