|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
If I upgrade my old Classic forum to Threads, what happens to member #1 (me)?
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
You become member #2. Member #1 is reserved for technical stuff like anonymous posts.
|
|
|
|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
So what happens to number 2? Do all members shift up by one? Probably not a big deal for most places, but unfortunately I built an item years ago that is the most popular thing on this particular website, and the numbers are tied to the member number. Thousands upon thousands of links out there on websites going to particular members. Site is http://map.datastormusers.com and one of 4 permanent links to my info on the site as an example is http://map.datastormusers.com/user3.cfm?user=1 It is even worse in that most of the third-party tools that allow posting to this map use the forum cookie to identify the member
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
You know, that is a good question. I never paid attention when I upgraded from classic a few years ago. I was to involved with that the upgrade worked to notice what happened to the other member numbers. Looking at my member database it looks like your assumption is correct.
Looks like you are using mappoint for the one item above.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Just at a quick look how it works. It looks like the map would update as users report in so that would be a headache for a short period of time as people report in. Because they would have to login again to establish a new cookie. But I would be more concerned on the cookie issue . How it is handled now and how it would be handled with threads!
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
You are correct that I'm using mappoint. The cookie differences would be a headache in rewriting utilities, but a shift of number would be impractical in the extreme. If someone has a web page with hundreds of links to their location, as many of my members do, all of those links would now point to someone else. Most use it in e-mail signature lines, and of course in forum signatures.
The requirement to join the forums in order to show up on the maps has been very helpful in making sure that the maps don't get spammed. I would hate to break the link between membership numbers and map id numbers.
About 2500 of my members have placed themselves on the map at one time or another - many drop off when they aren't actively travelling.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
In the stock code there is no getting around the change in member number. Maybe Rick or one of the beta testers can offer some special installation.Might cost a few but it looks like that is what you need. They may for instance just bump you to a new member number and let all the others stay as is. I just am assuming. Because member 1 as stated is reserved for pretty much orphaned posts.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
Except for user #1, which is pretty much reserved, it would not be an extreme difficult job to renumber everyone back to their old member number in threads.
Most time would go in being careful, not the actual doing of it. You would need a little modification in the migration tool to not throw away the temporary tables it uses for the migration. There is table called ubbt_memtemp used to remap users from old to new. You could use that to get the usernumbers back again.
As far as the numbering goes, by default it starts with #2, and just numbers up. So depending on the number of deleted/missing users, the new member# can differ a lot from the original.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yeah, not a real slick solution to this one and it would definitely take a custom import. Someone would have to be put to the back of the pile. Meaning, either your user #1, or some other early user would need to be given a user number at the very end and then the importer modified for this so it doesn't increment everyone else.
The classic_import.php script would be what needs modified. If it's not something you're paricularly keen of tackling yourself I'm sure there are a few people here that could assist including myself in my off-time.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Yep it looks like he has a lot and I mean a lot of archived static pages built based on member number, It would be a monumental task to try to rebuild them because a member number changed by one or two.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
No static pages (there are only 7 pages that display all of the maps), but it is the static jpg map images (4 for each member) which are named according to member number. They are rebuilt whenever a member moves, and are also rebuilt each night (because others shown on a map might have moved). If I do decide to migrate I will probably tackle it myself. My member #2 was last active in July of 2004, so I doubt he would know or care if I usurped him
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Okay I saw all the jpg files and assumed since some are many moons ago they are static.
Good Luck.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
It doesn't matter a lot in terms of this discussion, but I'm curious for an example of an image that is "many moons ago"?
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
Well just clicking a few of the several hundred or so images some seem to be dated a month or more. Thats all. So I assumed they were static. But if somebody did not move say was in a campground for a while I guess that makes sense too.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jun 2006
Posts: 33
newbie
|
newbie
Joined: Jun 2006
Posts: 33 |
I guess you are referring to the "last updated" date on the data? I used to expire all data at 10 days, but last year I began to allow members to choose an expiration between 5 and 30 days, and those who don't expect to move soon often choose the longest possible. They get an e-mail one day prior to expiration.
The images themselves are rebuilt as I said, every night, whether they've moved or not.
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
That could be it. I can't even find my way back to the jpg list again to verify where I was. I must have stumbled on it by accident. I seem to recall a hover that stated member comments where and when they were.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
If I do decide to migrate I will probably tackle it myself. Be sure to modify the importer not to throw away it's temporary tables. Sort of, if imports goes wrong, you could always fix up the user numbers afterwards.
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
I have a fantasy drum corps league section of my Website that I've scripted and tied to my UBB user database. My fantasy corps were each tied to their respective owner by their member number in the UBB database. When I updated from UBB6 to UBB7, this was all thrown out of wack, so I wrote a little script to solve the problem. I know it's not exactly what you need, since it's scripted exactly for my purpose and my purpose only, but it's the same idea (comparing user numbers from one version to the next and changing them accordingly.) Maybe you can get some use out of it and it can at least give you some ideas or work as a starting-off point. Anyway, just remember that running any sort of script like this is dangerous if it doesn't do exactly what you want it to do, so test it on an offline database and be sure to have a backup of your online before you run it against it.
<?php
if(!defined("UBB_MAIN_PROGRAM")) exit;
function &page_xfix_gpc () {
return array(
"wordlets" => array("fdc"),
"admin_or_mod" => 1,
);
}
function &page_xfix_run () {
global $html,$myinfo,$smarty,$user,$in,$ubbt_lang,$config,$forumvisit,$visit,$dbh,$var_start,$var_eq,$var_sep,$var_extra;
extract($in, EXTR_OVERWRITE | EXTR_REFS);
$Number = $user['USER_ID'];
require ('scripts/xfdc.inc.php');
$query = "
SELECT COUNT(*)
FROM f03_FDCcorps
";
$sth = $dbh -> do_query($query);
list($totalcorps) = $dbh -> fetch_array($sth);
$dbh -> finish_sth($sth);
for($i=0;$i<$totalcorps;$i++){
$query = "
SELECT t1.C_UNumber, t1.C_CNumber, t2.U_Username, t3.USER_ID
FROM f03_FDCcorps AS t1, w3t_Users AS t2, ubbt_USERS AS t3
WHERE t1.C_CNumber = '$i'
AND t1.C_UNumber = t2.U_Number
AND t2.U_Username = t3.USER_DISPLAY_NAME
";
$sth = $dbh -> do_query($query);
list($oldunumber, $corpsnumber, $username, $newunumber) = $dbh -> fetch_array($sth);
$userrow[$i]['oldunumber'] = $oldunumber;
$userrow[$i]['corpsnumber'] = $corpsnumber;
$userrow[$i]['username'] = $username;
$userrow[$i]['newunumber'] = $newunumber;
$dbh -> finish_sth($sth);
$query = "
UPDATE f03_FDCcorps
SET C_UNumber = '{$userrow[$i]['newunumber']}'
WHERE C_CNumber = '{$userrow[$i]['corpsnumber']}'
";
$dbh -> do_query($query);
}
return array(
"header" => array (
"title" => "Fantasy Drum Corps - 20{$fdcyear} Season",
"breadcrumb" => <<<BREADCRUMB
<a href="{$config['BASE_URL']}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm">{$ubbt_lang['FORUM_TEXT']}</a>
»
{$ubbt_lang['LOGIN_PROMPT']}
BREADCRUMB
,
),
"template" => "xshowseason",
"data" => & $smarty_data,
"footer" => true,
);
}
?>
C_UNumber was the user number which was tied to the UBB user number and C_CNumber was the fantasy corps' number.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Well, one thing to keep in mind is that whatever scripts you're using now will have to be updated... there is a huge amount of data changed from UBB6 to UBB7 (reguardless of what you came from, ubb.classic or ubb.threads); this is especially important when we're talking post UBB.Threads 7.3 with the new permission matrix (makes it so even mods made for UBB.T7 had to be recreated)
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
Yeah, I had to dig through dozens of custom PHP scripts last year and update them to work with 7. Upgrading the template files was the most laborious part, due to the switch to smarty.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Perhaps there should be a site devoted to custom scripts that interact with UBB and other applications. I do not think UBBDev would be adequate as it is more of a modify the UBB not attach the UBB to other software type deals. Something even more simplistic then UBBDev as in most cases that site can become very confusing as when the UBB changes the original thread is just amended not a new thread started for modification for a newer version of the UBB hack. P.S And no I'm not going to even offer this time as last time I made such an offer for a specialized site like this some spammer wanted to insult me on this board.
Last edited by Thelockman; 02/21/2009 8:00 AM. Reason: Added the P.S. to be a smartass.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I think UBBdev would be more than adequate as it's a development forum...
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
Perhaps it could be reorganized and threads with mode not span across several releases with a mod then part of a mod rewritten a few times through several releases making it so confusing that you just give up even trying to understand it.
Would be better if the entire mod file was re posted in full not just well change this line to this for this version then a few post's later the same thing. Would be easier to build a rocket step by step with some of these updated many time mods.
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
I always re-post my mods in full when I make changes for new releases. I plan to update the instructions for my mods once 7.5 goes Au.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Well, according to the license, we can't redistribute stock files; hence why it's "add this, move this" as it'd be against the license to just share pre-modded files...
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
Well yeah. I meant that I update the entire "add this, move this" instructions instead of just making a post saying bla bla lines need to be changed to work with Version such and such.
|
|
|
|
Joined: Feb 2007
Posts: 1,294 Likes: 2
Veteran
|
Veteran
Joined: Feb 2007
Posts: 1,294 Likes: 2 |
I think everyone that makes modifications and additions knows the license agreement. What I was talking about for example Multiple Identity Detector. This thread is so confusing by the time you get to the end of it you don't know what your doing. Perhaps when it was first written it worked but then you have to read two more pages and make many modifications to the hack and hope you didn't miss anything so it works. The proper way would have been to make all the changes for each upgrade in a separate thread having the entire hack per UBB ver in a single thread not spanning several UBB versions in one thread. For someone who is not a programmer and just wants to add a cool hack this is frustrating and most likely will not work for them as it is laid out in that particular thread. The result is people who do not return to your site and decide they do not wish to try to add hacks or learn how to make modifications to their site or message board. If your not understanding this then I totally am wasting my time trying to explain it to you.
|
|
|
|
Joined: Mar 2008
Posts: 326
Enthusiast
|
Enthusiast
Joined: Mar 2008
Posts: 326 |
I completely understand what you are saying. It can get frustrating when a code change you need for a certain version is buried in the thread somewhere.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
The proper way would have been to make all the changes for each upgrade in a separate thread having the entire hack per UBB ver in a single thread not spanning several UBB versions in one thread. See, I understand but disagree... I do maintain some of my mods on seperate pages for some versions, and it's quite a chore trying to go in and make sure each thread gets updated when you make a simple update... Especially for some that are for way older versions... Now when it's one thread, and one parent (original) post to update, it makes it far easier to address any changes for each version... I would agree that the original posters should update their initial post with new information defined in the threads; it'd make it far easier for new users... But they should have been doing that as changes occour in the threads (I update my mods whenever a new issue arises so users don't need to bother reading through the pages)
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
I would agree that the original posters should update their initial post with new information defined in the threads; it'd make it far easier for new users... But they should have been doing that as changes occour in the threads (I update my mods whenever a new issue arises so users don't need to bother reading through the pages) Agreed, the original post is supposed to always contain current code/instructions. For the mods I've worked on I update the original post and give a running changelog there too.
|
|
|
1 members (Ruben),
1,101
guests, and
206
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|