Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Points Transactions: How to remove Page Views from the list

I've just installed this mod and activated it.

I had some inital trouble getting the users to show up but now they do... howeverI get a HUGE list because every time a user gets a page view thats one entry to the database.

How can I remove pages views from showing up in the point transaction log? I figured out its "ID: 13" but am unsure of how to remove it from showing up.

Search and change this line from:

$ptrow = $db->sql_query("SELECT tid, username, point_id, points, trans_date FROM {$prefix}_points_transactions ORDER BY $orderby $dir LIMIT $offset, $ptnum");

Thanks for that.

I just realised that the mod isnt working properly although I have 10 pages of pageviews = 0 points (mainly because I set that action to have 0 points) but no other actions are recorded, such as submitting downloads, commenting, posting etc.

Did you edit the mainfile and make the edits in the install file?

yeah I followed the instructions of the mod. I copied the main files to my webserver... ran the installer which loaded the tables into my database and then I did this as per instructions:

Open mainfile.php located in the root of your Nuke site folder.

Find the following code:

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

After that add:

Thats it for editing :-)

Please verify that the table nuke_points_transactions is there.

ok I just checked. the table is there... and for some reason is seems to be working now weird.

I was testing it last night, during a browser refresh it counted instantly as a page refresh but no other actions such as forum posts were being counted.

I'll do some more testing with it just to make sure.

thanks for ur reply... that code now removed the page counts

The page views are still being loaded into the database... just not displayed.

Is there a way to stop them from loading into the database? because if I choose to view a user all the page views still load up and it is also causing the id of transactions to increase rapidly. my transaction id is already over 1000.