Previous Thread
Next Thread
Print Thread
Hop To
#184464 05/19/2007 2:46 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
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

willing #184468 05/19/2007 3:46 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
it's stored in the database, so you'd have to update that


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184472 05/19/2007 3:59 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
And how would we do that, if you don't mind? (The other way round too of course - ie. making a number smaller....)

smile

willing #184477 05/19/2007 6:16 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184478 05/19/2007 6:18 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
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.

willing #184479 05/19/2007 6:19 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
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.

willing #184480 05/19/2007 7:07 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184481 05/19/2007 7:10 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Not exactly sure how to do that, but will look into it.

In the meantime if anyone knows what the command might be! smile

Gizmo #184482 05/19/2007 7:13 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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

Last edited by Gizmo; 05/19/2007 7:40 AM.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184483 05/19/2007 7:14 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
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)?

willing #184484 05/19/2007 7:17 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
The topic id is the number of the first post in the thread, yes.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
willing #184485 05/19/2007 7:22 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Don't want to hassle you wink but following the format of the other thing earlier in the thread:

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

...would that not be....

UPDATE ubbt_TOPICS set TOPIC_VIEWS='2000' where ubbt_TOPICS.TOPIC_ID='184464'

(where 2000 is the page view I want to show)

?

Thank you!

willing #184486 05/19/2007 7:27 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
actually I just tried that, didn't seem to work frown

willing #184487 05/19/2007 7:28 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'd do it as:
UPDATE `ubbt_TOPICS` SET `TOPIC_VIEWS` = '2000' WHERE `ubbt_TOPICS`.`TOPIC_ID`='184464';

Only because I'm anal retentive about comments, ticks, backticks, and quotation marks and their proper placement.

Last edited by Gizmo; 05/19/2007 7:39 AM.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184488 05/19/2007 7:30 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
You could also do:
UPDATE `ubbt_TOPICS` SET `TOPIC_VIEWS` = '2000' WHERE `TOPIC_ID`='184464';

Theres a few hundred ways to accomplish the same thing...

Last edited by Gizmo; 05/19/2007 7:39 AM.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184489 05/19/2007 7:31 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Thanks Gizmo, unfortunately it didn't change anything when I went into the control panel and tried to change the database. Hmmmmm...

Appreciate the help.

willing #184490 05/19/2007 7:32 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I fail to see why it wouldn't, it looks like that's the only place to update... What is returned when you try to issue that command?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184491 05/19/2007 7:34 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
In the SQL command field when I enter the above ones, it comes back as

"0 rows affected"

frown

willing #184492 05/19/2007 7:35 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Sadly, this happens sometimes, even when it affects a row; try clearing your cache and check the thread to see if it was actually affected.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184493 05/19/2007 7:38 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Try:
UPDATE `ubbt_TOPICS` SET `TOPIC_VIEWS` = '2000' WHERE `POST_ID`='184464';


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184494 05/19/2007 7:38 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Just did that, no change.... frown

Gizmo #184495 05/19/2007 7:39 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by Gizmo
Try:
UPDATE `ubbt_TOPICS` SET `TOPIC_VIEWS` = '2000' WHERE `POST_ID`='184464';
did you do that one?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184496 05/19/2007 7:42 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Curious.... that seems to work! I'm sure I did that one before....

Anyway I'll keep an eye on that thread.

Many thanks as always!

willing #184497 05/19/2007 7:43 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
there was 2 that where similar; one was topic_id (which i specified wrong) and another i posted as post_id lol...

Anywho, I'm off for the night...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #184498 05/19/2007 7:45 AM
Joined: Feb 2007
Posts: 678
W
old hand
old hand
W Offline
Joined: Feb 2007
Posts: 678
Me too. Thanks again.

United for the FA Cup!!!!!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 458 guests, and 91 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)