Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2006
Posts: 1,360
Likes: 2
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
Hi,

We have lots of scripts that are linked to our ubb 6.5.2 forum user database. Now there's already lots of work in updating the queries, but the usernumbers have also been changed.

Anyone know of a hack or something else in the import proces to stop the renumbering proces? Or is there a table like ubbt_IMPORT_MAP which makes it easy for me to find out new usernumbers?


[Linked Image from siemons.org]
Joined: Jun 2006
Posts: 16,459
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,459
Likes: 145
the import map should remember users, threads, and posts; should mind you..


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!
Joined: Aug 2006
Posts: 1,360
Likes: 2
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
Originally Posted by Gizmo
the import map should remember users, threads, and posts; should mind you..

I just see a post translation table, not a "this old user# is now this new user#"-table.


[Linked Image from siemons.org]
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
The table that maps the old usernumber to the new usernumber is just temporary and is deleted after the import is finished. You could comment out the portion that drops that table at the end so it's still there.

Around line 1658 of threads_import you'll see a line where it drops the table called memtemp.

Joined: Aug 2006
Posts: 1,360
Likes: 2
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
Originally Posted by Rick
Around line 1658 of threads_import you'll see a line where it drops the table called memtemp.

ok, found it. I see it drops a few more interesting tables for me smile


[Linked Image from siemons.org]

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Group Membership
by Morgan - 12/14/2025 10:43 AM
Photos vs/& Folder
by Morgan - 12/13/2025 5:12 PM
SQL error ..
by Morgan - 12/08/2025 7:22 AM
Mirrored databases
by Baldeagle - 12/05/2025 3:27 PM
Who's Online Now
3 members (Gizmo, Conrad, jayme), 4,384 guests, and 150 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
test
test
by Gizmo, August 20
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20251210)