Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (SteveS), 42 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/23/08
Posts: 10
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 3 1 2 3 >
Topic Options
#184464 - 05/19/07 02:46 AM Views
willing Offline
old hand
Registered: 02/12/07
Posts: 701
Strange question perhaps, but is there any way to change the number of "views" for a thread.

For example if it is currently showing "243", can we say, for example, change it to be "4354" if we wanted to? And then once we have changed that number, any further views will be added as normal?

Thanks
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#184468 - 05/19/07 03:46 AM Re: Views [Re: willing]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
it's stored in the database, so you'd have to update that
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#184472 - 05/19/07 03:59 AM Re: Views [Re: Gizmo]
willing Offline
old hand
Registered: 02/12/07
Posts: 701
And how would we do that, if you don't mind? (The other way round too of course - ie. making a number smaller....)

\:\)
Top
#184477 - 05/19/07 06:16 AM Re: Views [Re: willing]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
you'd use phpmyadmin and locate the thread in question; i'm nto entirely sure what tables would need updated offhand as this isn't something I'd update myself so i've not looked into it.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#184478 - 05/19/07 06:18 AM Re: Views [Re: Gizmo]
willing Offline
old hand
Registered: 02/12/07
Posts: 701
I remember with the rating issue I had a while back we could change:

UPDATE ubbt_USER_PROFILE set USER_RATING='0' where USER_ID='###'

Again, just change ### to the userid in question.

That worked I was wondering if there was something similar.
Top
#184479 - 05/19/07 06:19 AM Re: Views [Re: willing]
willing Offline
old hand
Registered: 02/12/07
Posts: 701
Thanks gizmo, it's not something I would normally change either but I want a thread to look less busy than it is (long story....) and if there was a way to do this it would help.
Top
#184480 - 05/19/07 07:07 AM Re: Views [Re: willing]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
that'd be a quick mysql command, and yes it'd work the same way, if i bothered to craft the query; as i wouldn't know where to look offhand I can't craft a simple query; not to mention I think that data is held in a memory resident table as well and am not sure how they work offhand.

Hence the recommendation to login to your SQL server wiht PHPMyAdmin and check.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#184481 - 05/19/07 07:10 AM Re: Views [Re: Gizmo]
willing Offline
old hand
Registered: 02/12/07
Posts: 701
Not exactly sure how to do that, but will look into it.

In the meantime if anyone knows what the command might be! \:\)
Top
#184482 - 05/19/07 07:13 AM Re: Views [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Well, it looks like "ubb7_TOPIC_VIEWS" only holds worthless temporary data, so "ubb7_TOPICS" is the key...

Something similar to:
UPDATE `ubb7_TOPICS` SET `TOPIC_VIEWS` = 'xxxxx' WHERE `ubb7_TOPICS`.`TOPIC_ID` =xx;

xxxxx would be the view ammount
xx would be the topic id
ubb7_ would be your mysql database prefix


Edited by Gizmo (05/19/07 07:40 AM)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#184483 - 05/19/07 07:14 AM Re: Views [Re: Gizmo]
willing Offline
old hand
Registered: 02/12/07
Posts: 701
I was just looking ... what exactly is the topic id? I couldn't see one, just an id for each post. Is the topic id the id number of the first post in a thread? (ie, for this thread, #184464)?
Top
Page 1 of 3 1 2 3 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
Today at 12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image