The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
How can change all the Domainname to the New Domainname with only one SQL-Query?
how can i change LINKs in my POSTs table?
I just moved to new domain and some links on the board are linked to the wrong Domainname. How can change all the Domainname to the New Domainname with only one SQL-Query? Thanks 4 you help Berni |
#2
|
||||
|
||||
Not with a single SQL query, I don't think that possible... but, bring some PHP into the equation, and it's perfectly possible, without pretty much lifting a finger.
I will be wanting to do somthing very similar soon myself, so I thought now about right to try to right a script for the job. I haven't actually tested this script on a database yet, but i've tested the script out pretty much... just not with a connection to a database. Try it out, but have a database backup before... you MUST backup your database FIRST. Anyway, this is the general idea : PHP Code:
Exectute the script from within your FORUMS root, and just wait for it to end, and the changes should have happend. I would recommend trying this on a "non-live" server first... like, if you have a copy of your forums on your computer (intranet). Let me know. |
#3
|
||||
|
||||
thanks for your Help.
but i'm looking for a SQl-Query. I know that it is possible with only one query, i just don't know the right expression. Update table set feld = reg(blalblbl) .... Thanks agin Berni |
#4
|
||||
|
||||
I've been speaking with an SQL guru... and he's not sure it's possible with usual SQL.
|
#5
|
||||
|
||||
i know it is.
I saw it on www.vbulletin.com or in this forum. But i just can't remember me where it was thanks berni |
#6
|
||||
|
||||
I'll take your word for it.
Hope somone gives up the link... i'd like a single query to do this. |
#7
|
||||
|
||||
if i find the solution i will drop you an Email.
cu berni |
#8
|
||||
|
||||
Wich field do you want to update in the post table? Title Or Pagetext?
If pagetext then you could use something like this: PHP Code:
|
#9
|
||||
|
||||
thanks!!!!
100% the solution i was looking for thanks again Berni |
#10
|
||||
|
||||
Excellent!!
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|