Ooops
November 24, 2020, 09:40:46 AM

Author Topic: BlitzBasic Code Archives coming to SyntaxBomb  (Read 11668 times)

Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #30 on: July 02, 2017, 12:37:54 AM »
btw: There are still are a lot of '"' in the code archives.
There are? God damn MySQL!

Could you post a couple of links here please so I can see what I missed last time and fixy fix fix
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline GW

  • Full Member
  • ***
  • Posts: 202
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #31 on: July 02, 2017, 12:54:21 AM »
I shouldn't say there's a lot, it looks like just a few posts have them..
 
Here's one
http://www.syntaxbomb.com/index.php/topic,2902.msg3891.html

I've also found several archive posts that have no content at all
http://www.syntaxbomb.com/index.php/topic,706.msg1695.html#msg1695

Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #32 on: July 02, 2017, 01:09:28 AM »
Oh I see, thanks. That should be easily sorted via the joys of SQL. I'll do that later today on a mass search and replace to correct other entries too.

Quote
I've also found several archive posts that have no content at all
Funnily enough I spotted a couple today. I need to find out why that happened and if it's only a couple I'll manually add them in but if there are loads then I'll see if my code got confused or if the forum just spat the SQL back out again.


Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline xlsior

  • Jr. Member
  • **
  • Posts: 33
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #33 on: July 02, 2017, 09:37:45 PM »
Just noticed another problem, looking at one of my old postings:

http://www.syntaxbomb.com/index.php/topic,2973.0.html

instead of & it shows & in the source.


Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #34 on: July 02, 2017, 11:03:57 PM »
Code: [Select]
" instead of "fixed all 130+ instances

Code: [Select]
& instead of &fixed all 500+ instances
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline Krischan

  • Full Member
  • ***
  • Posts: 221
    • Krischan's Homepage
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #35 on: July 03, 2017, 07:59:13 AM »
I noticed that the remote image links are messed and additional code tags in the comments section are not being parsed, see http://www.syntaxbomb.com/index.php/topic,3176.msg4165.html#msg4165 for example.

The URL is in plain text <img src="../../blitzbasic.christianhart.de/bb/elite/elitescanner.png"> but should be blitzbasic.christianhart.de/bb/elite/elitescanner.png only, or with a http:// prefix.

Kind regards
Krischan

Windows 10 Pro | i7 9700K@ 3.6GHz | RTX 2080 8GB]
My Blitzbasic Archive | Extrasolar Project | My Github projects

Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #36 on: July 03, 2017, 04:05:45 PM »
Quote
The URL is in plain text
Fixed for all <img src=""> tags :)
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline Krischan

  • Full Member
  • ***
  • Posts: 221
    • Krischan's Homepage
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #37 on: July 03, 2017, 09:08:39 PM »
Hmm ok, perhaps you have time to take a look at more nasty bugs, see attached images? :o

bug_empty: The post contains nothing, even if the post is older
bug_imagelinebreak: the image should start a new paragraph and shoudl be displayed instead of the link
bug_opentags: there is an open italics tag left
bug_url1: could be the same problem like bug_opentags, looks messed
bug_url2: the reference looks strange, and could the same bug like the two previous bugs

Kind regards
Krischan

Windows 10 Pro | i7 9700K@ 3.6GHz | RTX 2080 8GB]
My Blitzbasic Archive | Extrasolar Project | My Github projects

Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #38 on: July 04, 2017, 02:58:09 AM »
Hmm ok, perhaps you have time to take a look at more nasty bugs, see attached images? :o

Time?. This isn't the time to argue about time, we don't have the time...

There are a few more HTML elements in the archives than I thought. When I first looked at a handful of entries they were pretty much all the same pattern. I coded the importer based on those. Sods law there were more.

Luckily it's nothing drastic and for a majority you can do a blanket find / replace to sort the issue. For the <a href> posts I'll have to do a tiny bit of coding to strip the double URL's and make it one URL wrapped in BB code.

Thanks for creating more work for me :P
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline RonTek

  • Sr. Member
  • ****
  • Posts: 357
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #39 on: July 04, 2017, 05:04:20 AM »
The forum version looks nice and integrated, but I think it would be much easier and more convenient to just get the static copy of the archives and query it the same way as the original archives, then modify the theme a bit to match with the site. I have seen there are additional comments and info that provides fixes or updates on most resources.

http://blitzbasic.com/codearcs.php?cat=13 Categories
http://blitzbasic.com/codearcs.php?code=3307 Resource
http://blitzbasic.com/codearcs.php?cat=13&order=&asc=&lang_id=2 Categories with Language Type (BB/BMX/ALL)

Here's a screenshot of the quick styling that I did using the wasted.nz archive copy..




Full Page

http://i.imgur.com/745VGzz.jpg




Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #40 on: July 04, 2017, 11:21:15 AM »
The forum version looks nice and integrated, but I think it would be much easier and more convenient to just get the static copy of the archives and query it the same way as the original archives, then modify the theme a bit to match with the site. I have seen there are additional comments and info that provides fixes or updates on most resources.

I was not provided with the MySQL DB for the code archives or else it would of been much easier. All I had to work with was static HTML pages. So I can't just add a static copy and make it queryable via the forums, hence integrating them into the forums. Also I want the code archives as part of Syntaxbomb so they can be added to over time.

There's only a couple of niggles to solve :)
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline RonTek

  • Sr. Member
  • ****
  • Posts: 357
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #41 on: July 04, 2017, 12:35:50 PM »
Ah got it. Actually, though it may take time but it's not that hard to pull url queries or content particularly if you have a few fields to deal with. For the code archives I'm seeing only 3: the item id, category and language type. Even without an existing MySQL db, you can still rebuild the archives with MySQL as long as the reference links are consistent and intact.

Well, hope all works ok. :)

Btw, I was wondering why you still need to get permission if the code is licensed as Public Domain..

Quote
This code has been declared by its author to be Public Domain code.

I would assume the permission includes the whole page or user comments/replies and other content like images?


Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #42 on: July 04, 2017, 04:33:21 PM »
Quote
you can still rebuild the archives with MySQL as long as the reference links are consistent and intact.
All the HTML pages are converted into the DB here. There are just a few issues to solve with in post links. They'll be sorted :)

Quote
Btw, I was wondering why you still need to get permission if the code is licensed as Public Domain..
I wanted to include the comments with original post. While the code is public domain, the comments are not. As I've mirrored 1000's of posts it was far easier to ask permission. Simples :D
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

Offline xlsior

  • Jr. Member
  • **
  • Posts: 33
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #43 on: July 04, 2017, 09:33:50 PM »
It looks like it still shows &amp; instead of & in the post titles, e.g.:

https://www.syntaxbomb.com/index.php?topic=2845.0

Offline Qube

  • Administrator
  • Hero Member
  • *****
  • Posts: 2565
  • I mostly code at night... Mostly.
    • SyntaxBomb - Indie Coders
Re: BlitzBasic Code Archives coming to SyntaxBomb
« Reply #44 on: July 04, 2017, 10:04:26 PM »
It looks like it still shows &amp; instead of & in the post titles, e.g.:

https://www.syntaxbomb.com/index.php?topic=2845.0

I only applied the changes to the body of the post. I didn't think the issue would be in the titles too. Will sort out this evening, thanks.
Mac mini ( 2018 / 2020 ), 3 GHz 6-Core Intel Core i5, 16 GB 2667 MHz DDR4, 1TB NVMe, eGPU Radeon Pro 580 8 GB, LG Ultragear 27GL83A-B 27 Inch
Commodore VIC-20, 1.1Mhz MOS 6502 CPU, 5KB RAM, VIC ( 6560 ) GPU

Until the next time...

 

SimplePortal 2.3.6 © 2008-2014, SimplePortal