如何将Oblog博客的内容转换到Z-BLOG

2014-06-18 为码而活 WordPress教程 关注780次 已收录
当前位置：波比源码 > 如何将Oblog博客的内容转换到Z-BLOG
正文概述

网(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文件.一切都完成了去看你的博客吧!

波比源码 – 精品源码模版分享 | www.bobi11.com
1. 本站所有资源来源于用户上传和网络，如有侵权请邮件联系站长！
2. 分享目的仅供大家学习和交流，您必须在下载后24小时内删除！
3. 不得使用于非法商业用途，不得违反国家法律。否则后果自负！
4. 本站提供的源码、模板、插件等等其他资源，都不包含技术服务请大家谅解！
5. 如有链接无法下载、失效或广告，请联系管理员处理！
6. 本站资源售价只是赞助，收取费用仅维持本站的日常运营所需！
7. 本站源码并不保证全部能正常使用，仅供有技术基础的人学习研究，请谨慎下载
8. 如遇到加密压缩包，请使用WINRAR解压,如遇到无法解压的请联系管理员！

波比源码 » 如何将Oblog博客的内容转换到Z-BLOG
分享到：

相关推荐

43 评论

  2. imuran 100 mcg without prescription pfizer viagra 50mg sildenafil 100mg price

  3. order tadalafil 5mg without prescription Cialis canadian cost order viagra 100mg generic

  8. order linezolid pill ladbrokes uk online roulette for real money

  19. 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.

  20. ivermectin 3mg tablets avlosulfon drug dapsone 100mg pills

  21. order benicar pill depakote online buy divalproex 500mg online cheap

  22. 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.

  23. 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.

  25. Хорошая РїРѕРґРІРѕРґРєР° безопасна для глаз. Р’С‹ можете выбрать гипоаллергенные продукты Рё подобрать именно такой оттенок Рё аппликатор, которые РїРѕРґРѕР№РґСѓС‚ лично вам. Для этого – РґРѕР±СЂРѕ пожаловать РІ ближайший стационарный магазин Watsons. Тестируйте, подбирайте, Р° главное – любите себя Рё наслаждайтесь нанесением макияжа! РџРѕРґРІРѕРґРєР° гелевая для глаз MAYBELLINE EYESTUDIO LASTING DRAMA тон 07 черный С…СЂРѕРј. Высокая конценрация пигментов без добавления масел обеспечивает продолжительный эффект свежего макияжа. РќР°…
    https://jaredmkdw998766.uzblog.net/-29456075
    В© Аптека РђРќР¦2022 ‘+$t.data(‘ss’)+’ Противопоказания Хорошее масло для ресниц должно содержать РІ себе множество витаминов, жирных кислот Рё микроэлементов, которые Р±С‹ РЅРµ только питали луковицы, РЅРѕ Рё увлажняли волоски, делая РёС… РјСЏРіРєРёРјРё Рё эластичными. Среди различных масел есть немало средств, обладающих подобными свойствами. Важно лишь подобрать то, которое подойдет именно вам. РџРЅ-РџС‚ СЃ 9 РґРѕ 18 Поделитесь СЃРІРѕРёРј мнением Рѕ нём, это может быть полезно для РґСЂСѓРіРёС… пользователей.

  26. dapoxetine 30mg without prescription domperidone online order motilium online

  27. nortriptyline over the counter buy paxil for sale buy generic paroxetine 10mg

  28. order doxycycline 200mg without prescription cheap doxycycline 100mg methylprednisolone 4 mg for sale

  29. 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

  30. buy tadalafil 10mg without prescription Buy cialis usa buy sildenafil 100mg online cheap

  32. cialis pills top ed drugs erectile dysfunction medicines

  33. 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:

  39. buy generic sildenafil lyrica online buy propecia for sale

  41. buy ondansetron 8mg for sale buy amoxil buy bactrim 480mg without prescription

发表评论

Hi, 如果你对这款模板有疑问，可以跟我联系哦！

联系站长
赞助VIP 享更多特权，建议使用 QQ 登录
QQ登录
喜欢我嘛？喜欢就按“ctrl+D”收藏我吧！♡