Changing :smilie to ---> :smilie:

[stark427]

Hello there.

When I moved from ezboard to VB me and my members where used to this format of the smilies :

:cry

instead of the default one of VB... which is

: cry : (without the gaps)


So I had changed it... to be like the ezboard one.

I would like to change it back as the :smilies: format is safer - otherwise the way I have it now results to some simple texts to be converted to smilies

So after I change it - I would also like to apply the changes to the old posts, to convert alla the :smilie ones to :smilie:

Anyone who knows which query I should run?

maybe something like this?

UPDATE post SET pagetext=REPLACE(pagetext,':banana',': banana :')

(without the gaps between : and banana.... for every smilie I have...) ?

thanx in advance

[filburt1]

[sql]
UPDATE post SET pagetext = REPLACE(pagetext, ":banana:", ":banana");
[/sql]

[stark427]

thanx

[stark427]

This change gave another idea.....

Back at the ezboard forum some nicknames were different than the ones the members have at VB.

For example a member there was called "polo242" but now in the VB he has the username : "polo"

After the transfer, the accounts were not imported, as we all know this cannot be done...

So my guess is that these old usernames are not in the "user" table right?

So what are they? Were they transfered just as simple text?

(all these old name have the "guest" status under them, now).

And where exactly are these old usernames stored?

What I wanna do is to try - with a query - to change these names to what they are now (e.g. headhunter1 --> headhunter), although I do know that they will *not* have real profiles or be linked in any way with the new usernames.

any ideas?

[filburt1]

The ezboard import is done via a vB staff member because AFAIK they can't access the database, only the final HTML of pages and members.

What specifically do you want to do? Have only alphabetic usernames instead of alphanumeric?

[stark427]

Ok here it goes, I will try my best to explain
I will need two posts - sorry for that.

lets take for example one user who's username at the ezboard was Headhunter17

after the transfer was completed, his account (of course) was not imported.

So, on the VB board his old posts show him as Headhunter17, and his profile leads to nowhere....

see attachment :

[stark427]

On the new board he registered as Headhunter (without the 17) - see attachment

I want to run a query so that all the Headhunter17 names will be changed to Headhunter...

Problem is I do not know where the old usernames are stored at the new board.... as I'm sure they are not stored at the "user" table (or whatever it is the one that stores normally the usernames on VB database).

I hope I helped a little bit more