Codezwiz >> Forums >> General PHP Nuke Help >> Site Points Question

This is going to be kind of hard to explain....

Ok. i went and edited how many points users will get for certain things and they were like 5 here 10 there....

Last night we tested and one of my members got over 2000 points in less than 5 minutes...
So obviously it isn't working right. And when they get so many poiints its sets their rank as admin.

I was wondering if there was any way I could get a points system like this site.
That tells you how many points you just got for a post etc etc...
And that bank thing is awesome , much props to whoever made that it is nice.

So is there anyone that can tell me how to get a set up like this site?

Thanks guys and keep up the good work

Is what I'm saying the same as what telli said in the 7.0+ points (sticky) Topic above this?

I mean is that how you guys got the bank and stuff?

Ok i added the points hacks and they work fine (from the sticky topic about the points)

Now I want it to tell the user how much points they got from the post like you guys did and I would like the bank and games and lottery. Did you guys here at codezwiz make that yourself?

Are you willing to show me how to do that?

Thanks, Proxy

Ive given it a few days and still no help.

Could someone at least tell me how to set up the SQL correctly?

I was told to do this...

alter table nuke_users add user_items TEXT;
create table nuke_shopitems (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `startprice` INT (20) UNSIGNED DEFAULT '100', `raise` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `startstock` TINYINT (3) UNSIGNED DEFAULT '100', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`));
create table nuke_shops (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`));
insert into nuke_bbconfig values ('multibuys', 'on');
insert into nuke_bbconfig values ('restocks', 'off');
insert into nuke_bbconfig values ('sellrate', '75');
insert into nuke_bbconfig values ('viewtopic', 'images');
insert into nuke_bbconfig values ('viewprofile', 'images');
insert into nuke_bbconfig values ('viewinventory', 'grouped');
insert into nuke_bbconfig values ('specialshop', '�store�disabled�name�Effects Store�off�1�off�1�off�1�off�1�off�1�off�1');
alter table nuke_users add `user_effects` CHAR (255);
alter table nuke_users add `user_privs` CHAR (255);
alter table nuke_users add `user_custitle` TEXT;
alter table nuke_users add `user_specmsg` TEXT;
update nuke_bbconfig set config_value='�store�disabled�name�Effects Store�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1' where config_name='specialshop';
insert into nuke_bbconfig values ('viewtopiclimit', '5');

Where and how do I do this?
I am using the "ShopModWithPHPNukePointSystem" Mod

After having done everything it asked me to do I get this error when viewing posts inside a topic in my forums...

General Error

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_items' in 'field list'

SELECT u.username, u.user_level, u.user_id, u.user_items, u.user_privs, u.user_effects, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = '5' AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 410
File : /home/ytech/public_html/modules/Forums/viewtopic.php

Does anyone have any ideas on that??

And also i can go to the shop but it says there is nothing there.
How do you add shops/items/etc etc....

Please Help Me
Thank You, Proxy

Register

I can only really help you with the simple part, adding items to the shop.

Go to your forums admin and it'll be there in a new section for the shop as long as all editting is correct.

As far as the points situation goes I use the cash mod here for all the shop stuff and games etc, and then I upgraded to nuke 7.5 from 6.7 which has all the points things in it, maybe I was just lucky but both work perfectly well together

I went to the admin forums section and they are there but...

For the Bank Configeration i get " Fatal Error Getting Total Users! "

For the Points Configeration theres a blank screen that has 2 check boxes for yes and no with nothing beside it, (thats all it has is yes and no, then under it yes and no)
then 3 text areas. one has Points in it, and the other 2 are blank. ???

For the Store Congigeration i get " Fatal Error "

Any ideas?
Thanks, Proxy