网(LieHuo.Net)教程 现在喜欢用Z-BLOG,于是就在本机先搭建了一个平台,等完成以后发现在一个问题,原来是使用的OBLOG的程序.网上并没有这两个博客互转的合适例子,所以就头疼了一把,经过自己一翻努力,呵呵终于成功了(不过不带TAG的内容,这个太麻烦了),现在我就把自己的操作方法说出来,大家按这个思路可以根据自己的情况改造一下.
首先先把它这个的ACCESS数据库导到MS SQL2000(或更高的版本中)中,如果没有你就自己写个ASP页面来处理吧,在导入完成后,就可以通过SQL语句来进行相互访问了.
这个是Z-BLOG主要的博客内容表(可以根据你自己想要的内容来增加):
SELECT LOG_CATEID,
LOG_AUTHORID,
LOG_LEVEL,
LOG_TITLE,
LOG_INTRO,
LOG_CONTENT,
LOG_IP,
LOG_POSTTIME,
LOG_VIEWNUMS,
LOG_TAG,
LOG_ISTOP
FROM BLOG_ARTICLE
这个是你OBLOG的用户的博客内容(也可根据自己想要的内容来增加),记得查清你的用户编号,我想这个应该不难:
SELECT TOPIC,
LOGTEXT,
ADDTIME,
TRUETIME,
IIS,
CLASSID,
LOGTAGS,
LOGTAGSID,
ABSTRACT
FROM OBLOG_LOG
WHERE USERID = 2
好了两个主表都找到了,接下来要做的就是看看你的这两个博客里的分类是不是一样的,如果不一样,你最好列举一下它们的对应关系以便后面的CASE语句中用,接下来就是主要的改造语句:
INSERT INTO
BLOG_ARTICLE(
LOG_CATEID,
LOG_AUTHORID,
LOG_LEVEL,
LOG_TITLE,
LOG_INTRO,
LOG_CONTENT,
LOG_IP,
LOG_POSTTIME,
LOG_VIEWNUMS,
LOG_ISTOP)
SELECT CLASSID=
CASE CLASSID
WHEN 3 THEN 1
WHEN 23 THEN 3
WHEN 2 THEN 4
WHEN 4 THEN 5
WHEN 14 THEN 8
WHEN 1 THEN 8
ELSE 7
END,
1,
4,
TOPIC,
ABSTRACT,
LOGTEXT,
‘127.0.0.1’,
ADDTIME,
IIS,
0
FROM OBLOG_LOG
WHERE USERID = 2
以上为我的转换的例子,因为两个博客建的栏目不一样,所以我用CASE转换了一下,大家可以根据自己的栏目内容编号进行修改
我的OBLOG用户编号为2.如果大家在转换中遇到什么问题可以进行沟通。
另外还有部分要修改的就是原来OBLOG中的下载地址和Z-BLOG中的地址是不同的,如果你网站直接是根目录就直接换成下面的就好,如果是http://www.XXX.com/blog/这样的目录,建议你还要修改一下下面的存储过程.
–SELECT LOG_ID FROM BLOG_ARTICLE WHERE LOG_CONTENT LIKE ‘%UPLOADFILES/%’
–定义替换的字符串
DECLARE @S_STR VARCHAR(8000),@D_STR VARCHAR(8000)
SELECT @S_STR=’"UPLOADFILES/’ –要替换的字符串
,@D_STR=’"/UPLOADFILES/’ –替换成的字符串
–因为只能用PATINDEX,所以对于搜索字符串做处理
SET @S_STR=’%’+@S_STR+’%’
–定义游标,循环处理数据
DECLARE @ID VARCHAR(500)
DECLARE #TB CURSOR FOR SELECT LOG_ID FROM BLOG_ARTICLE WHERE LOG_CONTENT LIKE ‘%"UPLOADFILES/%’
OPEN #TB
FETCH NEXT FROM #TB INTO @ID
WHILE @@FETCH_STATUS=0
BEGIN
–字符串替换处理
DECLARE @P VARBINARY(16) ,@P1 INT,@P2 INT ,@RPLEN INT,@STEP INT,@LEN INT
SELECT @P=TEXTPTR(LOG_CONTENT) ,@RPLEN=LEN(@S_STR)-2 ,@STEP=LEN(@D_STR) ,@P1=PATINDEX(@S_STR,LOG_CONTENT) ,@LEN=DATALENGTH(LOG_CONTENT) ,@P2=0 FROM BLOG_ARTICLE WHERE LOG_ID = @ID
WHILE @P1>0
BEGIN
SET @P2=@P1+@P2-1
UPDATETEXT BLOG_ARTICLE.LOG_CONTENT @P @P2 @RPLEN @D_STR
SELECT @P2=@P2+1,@P1=PATINDEX(@S_STR,SUBSTRING(LOG_CONTENT,@P2+1,@LEN))FROM BLOG_ARTICLE WHERE LOG_ID = @ID
END
FETCH NEXT FROM #TB INTO @ID
END
CLOSE #TB
DEALLOCATE #TB
–显示结果
SELECT LOG_ID,LOG_CONTENT FROM BLOG_ARTICLE WHERE LOG_CONTENT LIKE ‘%UPLOADFILES/%’
GO
好基本上的工作已经完成,至于以前的TAG内容,大家都想想办法吧,这个的确有点难.最后再到Z-BLOG中把文件重新建立一下,相关于重新生成HTML文件.一切都完成了去看你的博客吧!
波比源码 » 如何将Oblog博客的内容转换到Z-BLOG
oral levofloxacin 500mg buy levofloxacin 250mg online
imuran 100 mcg without prescription pfizer viagra 50mg sildenafil 100mg price
order tadalafil 5mg without prescription Cialis canadian cost order viagra 100mg generic
luvox 50mg usa luvox 100mg pills glipizide 5mg cheap
nootropil brand buy piracetam 800mg sale viagra price
tadalafil 10mg ca betamethasone cheap anafranil 25mg ca
glucophage us tadalafil drug tadalafil 40mg pills
order linezolid pill ladbrokes uk online roulette for real money
order generic triamcinolone purchase desloratadine pill clarinex over the counter
order allopurinol buy rosuvastatin 20mg pill order zetia 10mg pills
brand colchicine online slots real money legitimate online slots for money
free online slots slots casino games free spins no deposit uk
flagyl uk buy flagyl pill buy bactrim 480mg online
money poker online blackjack online game cialis 5mg cost
buy azithromycin 500mg generic buy zithromax generic gabapentin over the counter
ladbrokes uk stromectol 3mg tablet modafinil drug
buy retin sale oral tretinoin gel purchase avanafil online cheap
buy cialis 10mg free poker online games play online blackjack
Privacy practices may vary, for example, based on the features you use or your age. Learn More Weeds decent enough. Hi, this is Michael from Buy My Weed Online. I just came across this thread and couldn’t resist jumping in. Nowadays there are some dispensaries in Calgary, but, if you are not lucky enough to live near one, save yourself the hassle of commuting and order online! Also, you can show off to your dispensary-buying friends the quality that you get from ordering online with Green Society, and getting premium British Columbia weed without any hassle! They’ll be envious of your flowers and extracts! did it work my man? I have bought from them a lot! I thought they had great quality ….until I tried another mom! Finally their 99$ onz are terrible compare to 99$onz on other site. I tried their AAA a couple time and was so disappointed that I stick with the 99$ onz until I tried a new one. Now it’s been over a year I didn’t buy anything from them. Overpriced, low quality weed for most of the strain etc
https://grailoftheserpent-forum.com/community/profile/obiotis05022867/
CBD will not make you ‘high’ like THC might; in fact it may mitigate some of the intoxicating effects of THC. CBD oil consists of a high-CBD cannabis extract in a carrier oil base, such as coconut-derived MCT oil. Robservations … The average national price per gram for cannabis transactions reported to the Price of Weed is $6.60 (SD: $3.38) compared to $8.37 per gram price (SD: $2.34) as listed by licensed medical cannabis producers, for a difference in means of $1.77. Prices reported to Price of Weed and prices listed on licensed medical cannabis producers’ websites are negatively, albeit weakly, correlated with one another (p = 0.001), indicating that there is an inverse relationship between prices reported to the Price of Weed and listed on licensed medical cannabis producers’ websites.
ivermectin 3mg tablets avlosulfon drug dapsone 100mg pills
order benicar pill depakote online buy divalproex 500mg online cheap
Like many other top real money casino apps, El Royale offers online casino games that are beginner-friendly and easy to play. They are also well-known for their wide array of slot games that spans over 150. You can also find top games like keno, scrap, blackjack roulette, baccarat, poker, video poker, and other specialty games in HD using this casino. We offer a versatile set of mobile casino games that are not only unique in content and gameplay but also are of different types as well. These games have been selectively curated by us in order to incorporate all your needs – whether or not you are a beginner or even the most experienced player in the industry! Our gamut of mobile casino games belongs to a vast genre of casino games. Thus, you are bound to find any sort of casino games that is compatible on your phone. Here are a few types of casino games found under this category:
https://cruzlhbq970791.acidblog.net/46092571/online-casino-with-real-cash-payouts
We know that the Ontario casino LeoVegas looks great on desktop and mobile devices. We also know that there’s a native app for iPhone, iPad, and Android users. However, for all the engineering genius coming out of LeoVegas HQ, the in-house developers can’t do everything. That’s why the site is filled with over 1,600 casino games from the world’s best software suppliers. Most Canadian casinos are licensed by the Kahnawake Gaming Commission. That’s a reliable gaming authority. However, so is the Malta Gaming Authority – the institution that granted LeoVegas its license. In this LeoVegas Mobile review, our team at Casino.Guide will tell you all you need to know about the games, promotions and performance on the HTML 5 site and on the LeoVegas apps for iOS and Android.
Rynek hazardu online niestety prД™Ејnie siД™ rozwija i zdobywa coraz to nowszych sympatykГіw, ktГіrzy mogД… przegraД‡ swoje Ејycie. Niczym grzyby po deszczu pojawiajД… siД™ nowe strony z kasynami, ktГіre zapraszajД… kolorowymi obrazkami, ruchomymi animacjami i rГіЕјnego rodzaju bonusami powitalnymi. PochЕ‚aniajД…c siД™ bez reszty w wybГіr kasyna, moЕјna Е›miaЕ‚o zauwaЕјyД‡ i stwierdziД‡, Ејe wszystkie wyglД…dajД… podobnie, zachД™cajД… podobnymi bonusami i oferujД… bonusy bez depozytu. Nic bardziej mylnego – te kasyna to najwiД™kszy rak i odradzamy korzystania z tego. JeЕ›li jesteЕ› graczem ktГіry lubi prГіbowaД‡ nowe gry kaЕјdego dnia, warto upewniД‡ siД™ Ејe wybrane kasyno oferuje mnГіstwo gier kasynowych od najlepszych dostawcГіw! Nie kaЕјde kasyno bД™dzie jednak przyznawaЕ‚o bonus bez depozytu i to caЕ‚kiem normalne – mimo to, tego rodzaju promocje dajД… moЕјliwoЕ›Д‡ przetestowania oferty kasyna bez wydawania wЕ‚asnych pieniД™dzy.
https://wiki-planet.win/index.php?title=Piątnik_poker_300_ceneo
– FIFA 17 Ultimate Team – kontrakty, kondycja, leczenie, wypożyczenia MoЕјna przeczytaД‡ o tym w oficjalnym komunikacie na Twitch.tv: “Aby zapobiec szkodom i oszustwom tworzonym przez podejrzane usЕ‚ugi hazardowe, ktГіre sponsorujД… treЕ›ci na Twitchu, zabronimy udostД™pniania linkГіw i/lub kodГіw polecajД…cych witrynom oferujД…cym automaty do gry, ruletkД™ lub gry w koЕ›ci. BД™dziemy nadal monitorowaД‡ treЕ›ci zwiД…zane z hazardem i aktualizowaД‡ nasze podejЕ›cie w razie potrzeby. Aby daД‡ Ci czas na usuniД™cie tych treЕ›ci z Twojego kanaЕ‚u, egzekwowanie przepisГіw zostanie opГіЕєnione do 17 sierpnia 2021 r.”. Ruletka CSGO to uproszczona wersja klasycznej ruletki. Celem gry jest obstawienie liczby, koloru lub kombinacji tych dwГіch parametrГіw przy uЕјyciu skГіrek CSGO i uzyskanie duЕјej wygranej za stosunkowo niewielki depozyt. Prawie wszystkie kasyna CSGO w ruletkД™ oferujД… bonusy w postaci punktГіw po rejestracji. Kiedy wypЕ‚acasz pieniД…dze za poЕ›rednictwem systemГіw pЕ‚atnoЕ›ci, prowizja wynosi od 3 do 10 procent Twojego zysku.
diamox pill imdur 20mg drug buy imuran 25mg pill
Хорошая РїРѕРґРІРѕРґРєР° безопасна для глаз. Р’С‹ можете выбрать гипоаллергенные продукты Рё подобрать именно такой оттенок Рё аппликатор, которые РїРѕРґРѕР№РґСѓС‚ лично вам. Для этого – РґРѕР±СЂРѕ пожаловать РІ ближайший стационарный магазин Watsons. Тестируйте, подбирайте, Р° главное – любите себя Рё наслаждайтесь нанесением макияжа! РџРѕРґРІРѕРґРєР° гелевая для глаз MAYBELLINE EYESTUDIO LASTING DRAMA тон 07 черный С…СЂРѕРј. Высокая конценрация пигментов без добавления масел обеспечивает продолжительный эффект свежего макияжа. РќР°…
https://jaredmkdw998766.uzblog.net/-29456075
В© Аптека РђРќР¦2022 ‘+$t.data(‘ss’)+’ Противопоказания Хорошее масло для ресниц должно содержать РІ себе множество витаминов, жирных кислот Рё микроэлементов, которые Р±С‹ РЅРµ только питали луковицы, РЅРѕ Рё увлажняли волоски, делая РёС… РјСЏРіРєРёРјРё Рё эластичными. Среди различных масел есть немало средств, обладающих подобными свойствами. Важно лишь подобрать то, которое подойдет именно вам. РџРЅ-РџС‚ СЃ 9 РґРѕ 18 Поделитесь СЃРІРѕРёРј мнением Рѕ нём, это может быть полезно для РґСЂСѓРіРёС… пользователей.
dapoxetine 30mg without prescription domperidone online order motilium online
nortriptyline over the counter buy paxil for sale buy generic paroxetine 10mg
order doxycycline 200mg without prescription cheap doxycycline 100mg methylprednisolone 4 mg for sale
As our patients had normal renal function GFR 80 120 mL min at baseline, they were almost homogeneous and good choice for evaluating sNGAL cialis cheapest online prices
buy tadalafil 10mg without prescription Buy cialis usa buy sildenafil 100mg online cheap
minocycline usa buy minocycline 100mg online terazosin 5mg pill
cialis pills top ed drugs erectile dysfunction medicines
There are two main types of no deposit bonuses – free spins and free cash. Both allow players to play real-money casino games for free, but there is an important difference. Free spin bonuses are tied to specific slots, while free cash bonuses can be used on any game that has not been restricted for that bonus. Slotvibe Casino20 Free Spins No Deposit 812 E Rollins St. Suite 300Orlando, FL 32803 It is vital players understand the difference between non-cashable and cashable bonuses. To take advantage of a fully cashable no deposit bonus USA, you must know what that means and how best to claim it before signing up for an account. In addition, understanding the requirements for bonus cash promotion is crucial, whether it is free spins offer or a cashable no deposit bonus.
https://uniform-wiki.win/index.php?title=Top_mobile_playtech_casinos
Play poker with the most prestigious name in game from your Android device. Our real money poker app offers all the same incredible features that you can enjoy on our online poker site – all optimized for on-the-go Android poker play. Howard Lederer was born in New Hampshire but spent much of his early poker career in the illegal gambling dens of New York City. Lederer moved from chess to poker and joined the Mayfair Club in the city, a legendary poker den also frequented by pros like Dan Harrington, Stu Ungar, and Erik Seidel. Lederer would go on to win two World Series of Poker bracelets and became one of the leading faces of Full Tilt Poker before it was closed to US players in 2011. There are a lot of things we consider before recommending anyone play online poker for real money. After all, you are putting up at least a portion of your gambling budget, so you want value you can trust. Here are the things we take into account:
purchase glucophage generic purchase glucophage generic generic tamoxifen
order modafinil 100mg generic purchase phenergan generic oral promethazine 25mg
order clomid 100mg pill order clomid 100mg sale prednisolone 10mg drug
prednisone 10mg canada generic accutane 40mg order amoxil 1000mg generic
isotretinoin cheap buy ampicillin online cheap order generic ampicillin
buy generic sildenafil lyrica online buy propecia for sale
ivermectin 12mg without prescription prednisone 20mg brand prednisone 5mg price
buy ondansetron 8mg for sale buy amoxil buy bactrim 480mg without prescription
isotretinoin 40mg sale order generic isotretinoin 10mg azithromycin oral
order albuterol 2mg generic augmentin 375mg cheap order generic augmentin