Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (Flyin V, Gismo der erste, Island Piper, Ruben Rocha), 36 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 1091
Top Posters (30 Days)
Ruben Rocha 154
Rick 129
Gizmo 115
Thelockman 66
driv 55
phoebe 39
ScriptKeeper 38
AllenAyres 35
Ian 31
Mark S 30
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#179155 - 02/22/07 01:18 PM Any way to stop the renumbering of users when upgrading?
blaaskaak Online   content

****

Registered: 08/30/06
Posts: 1294
Loc: Breda, NL
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?
_________________________

Top
#179164 - 02/22/07 02:28 PM Re: Any way to stop the renumbering of users when upgrading? [Re: blaaskaak]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 11967
Loc: Portland, OR; USA
the import map should remember users, threads, and posts; should mind you..
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#179251 - 02/23/07 09:43 AM Re: Any way to stop the renumbering of users when upgrading? [Re: Gizmo]
blaaskaak Online   content

****

Registered: 08/30/06
Posts: 1294
Loc: Breda, NL
 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.
_________________________

Top
#179255 - 02/23/07 09:54 AM Re: Any way to stop the renumbering of users when upgrading? [Re: blaaskaak]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7880
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#179272 - 02/23/07 01:46 PM Re: Any way to stop the renumbering of users when upgrading? [Re: Rick]
blaaskaak Online   content

****

Registered: 08/30/06
Posts: 1294
Loc: Breda, NL
 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 \:\)
_________________________

Top


Shout Box

Today's Birthdays
The Random Avenger
Recent Topics
Pruning Messages
by EMG
Yesterday at 06:57 PM
7.4.1 Advanced Search - Default to Referer Forum?
by Jim
Yesterday at 01:32 AM
Move charset out of language files?
by Gizmo
11/17/08 09:33 PM
Where is Moderation Queue?
by luket
11/17/08 08:27 PM
Custom Page or Content
by FordDoctor
11/17/08 05:28 PM
Forum Stats
4243 Members
33 Forums
30478 Topics
154597 Posts

Max Online: 978 @ 06/24/07 08:19 PM