Page 6 of 6 FirstFirst ... 3456
Results 201 to 216 of 216

Thread: Re PlanetSourceCode

  1. #201
    Lively Member
    Join Date
    Jul 2020
    Posts
    99

    Re: Re PlanetSourceCode

    The first item is: "Access Database Manipulation via JDBC (for Microsoft Access)".
    The .mdb has a similar entity in text form, i.e. without .zip (in attachment).
    Is it the same thing or not?
    Last edited by Argus19; Sep 26th, 2020 at 10:36 AM.

  2. #202
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,441

    Re: Re PlanetSourceCode

    Yes, this submission is a code snippet from the database (w/o a separate zip file).

    Unfortunately the database is very inconsistent regarding votes to these submissions (w/o attachments) and some of them have average rating above 5 which is nonsense.

    I removed all submissions rated above 5 from the Hall of fame list but left them in authors/categories lists so these can be located from the indexes at all.

    I'll probably have to remove all submissions w/o attachments as these seem to have dubious/rigged ratings or the database is just an inconsistent mess (as usual).

    I'm currently back-linking the indexes from the submissions' descriptions, i.e. each submission will have a back-link to its author's index and its category's index too.

    Edit: for instance this submission [Polygon Animation Editor (PAN File Editor)] now has back-links to its author's list of submissions [(Tim Miron) yar-interactive software] and its category list [Graphics] too.

    Here is a submission (again w/o attachment) with user rating above 5: https://github.com/Planet-Source-Cod...easily__1-2209

    cheers,
    </wqw>

  3. #203
    Addicted Member
    Join Date
    Jun 2016
    Location
    Espaņa
    Posts
    170

    Re: Re PlanetSourceCode

    good job wqweto.

  4. #204
    Lively Member
    Join Date
    Jul 2020
    Posts
    99

    Re: Re PlanetSourceCode

    The rating is incorrect in many cases.
    It will be sufficient to keep the author's name or pseudonym.
    If there are discussions of newly created materials, then consider the rating from "zero".

  5. #205
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,441

    Re: Re PlanetSourceCode

    Quote Originally Posted by yokesee View Post
    good job wqweto.
    Thanks!

    I even managed to come up with a slogan for the new github org


    Planet Source Code
    Better hosted, still the same "POScode". . .


    Not sure if the slogan color is brown enough though. . . LOL :-))

    cheers,
    </wqw>

  6. #206
    Hyperactive Member
    Join Date
    Jun 2015
    Posts
    391

    Re: Re PlanetSourceCode

    awesome work on this thanks

  7. #207
    Addicted Member
    Join Date
    Jun 2019
    Posts
    163

    Re: Re PlanetSourceCode

    Finally was able to finish testing and cleanup some of the code of the tools to decrypt and extract PSC files, prepare project repos and upload to Gitea server. Some tasks take too much time - uploads to Gitea server for last run took 10.5+ hours running all on localhost on SSDs and lots of RAM.

    Still parts of the code needs refactoring as there are routines to be moved from the tools to the proper libraries or just general refactoring.

    The attached ZIP contains VB.NET 2019 solution (sources only) that will perform the tasks and the final result is this:



    13557 repositories imported in Gitea - some are lost due to broken ZIP files (or just the used ZIP extract library failed to extract).

    Here is short description (full one in README.md in the attached archive):
    ------------

    The provided tools are split into 3 tasks:

    • Decrypt PSC files which are just normal ZIPs xor-ed with 0FFh and extract archives
    • Prepare project repos with proper file name; removed unsafe files (.exe, .obj, .ocx), add .gitignore and .gitattributes; create README.md with proper description and picture from the provided in the CD MDB
    • For each project initialize new Git repository, create repo on Gitea server and push the repo to Gitea


    The projects are allowing extensibility via provided interfaces: different ZIP extraction library, database access for MDB, support for different centralized Git hosting servers - Gitea, Gogs, GitHub, GitLab, etc.

    Tools are using simple INI file for configuration for easier editing (compared to XML or other file types).

    For increased performance the tools can run not only as single-threaded tasks but also to use multi-threading. Decrypt/extract and prepare repos tasks work much faster with parallel processing enabled (configurable in tools config.ini file).

    Note that parallel processing stresses alot the CPU, memory and disk system so it is recommended to use SSD for files storage. Upload to Gitea task requires also 16GB of system memory and still may force Gitea to become unstable and the tool to crash so for this task parallel processing is disabled in the configuration file.
    Attached Files Attached Files

  8. #208
    Addicted Member Episcopal's Avatar
    Join Date
    Mar 2019
    Location
    Brazil
    Posts
    157

    Re: Re PlanetSourceCode

    Someone here said about the Forums for VB communities that "we are the best". It really is, you are the best ...

  9. #209
    Frenzied Member
    Join Date
    Dec 2008
    Location
    Melbourne Australia
    Posts
    1,379

    Re: Re PlanetSourceCode

    I am old, and thus (for me) tardy.
    I was the one who made the PSC CDs available for download.
    I had never gotten around to installing them, but had kept the CDs.
    Later Elroy, and others (in this thread) have been making (great) efforts to make the PSC source code available to us.
    Due to my tardiness, I have not gotten around to checking those out yet.
    In a recent (non related) thread, Eduardo said this -
    https://www.vbforums.com/showthread....52#post5497752
    Post 13 Eduardo said - One site that has the PSC projects and with a search function is this -
    https://www.fortypoundhead.com/browse.asp?catid=122

    I sent this question to Derek (fortypoundhead) -
    Hi Derek,
    Just came across your (great) site, and joined.
    I (and many others at vbforums.com) have been lamenting the loss of PSC.
    Someone posted a link to your site saying -
    "One site that has the PSC projects and with a search function is" (with a link to your site)
    Is that true ?
    Does your VB6 pages contain a cache of all of the PSC VB6 source code ?

    Thought this might be of some interest to our members,
    Rob

  10. #210
    Lively Member
    Join Date
    Jul 2020
    Posts
    99

    Re: Re PlanetSourceCode

    Quote Originally Posted by Bobbles View Post
    I was the one who made the PSC CDs available for download.
    I had never gotten around to installing them, but had kept the CDs.
    I am finishing the image of the DVD disc. It mainly includes PSC codes. I used Elroy's work and mine.
    The program on the disk works without installation, password and does not ask for money.
    Now I supplement with codes that I can find.
    To commemorate your contribution to the processing of the PSC CD, please send me your codes that you think fit in the image and I will add them.

  11. #211
    Junior Member
    Join Date
    Aug 2018
    Location
    Upper left-hand corner of USA
    Posts
    29

    Re: Re PlanetSourceCode

    [QUOTE=Bobbles;5497852
    Does your VB6 pages contain a cache of all of the PSC VB6 source code ?

    Thought this might be of some interest to our members,
    Rob[/QUOTE]

    Good morning Rob (Or evening for you!). I just answered your email, and yes, the site contains all the VB6 code that I could recover from the archives.

  12. #212
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,441

    Re: Re PlanetSourceCode

    Quote Originally Posted by Bobbles View Post
    Someone posted a link to your site saying -
    "One site that has the PSC projects and with a search function is" (with a link to your site)
    Is that true ?
    Does your VB6 pages contain a cache of all of the PSC VB6 source code ?

    Thought this might be of some interest to our members,
    Rob
    https://github.com/Planet-Source-Code -- this contains all PSC submissions from all CDs too.

    Do you find github interface intimidating?

    There are a couple of benefits not found in any other alternative:
    - can search by submission name (simple, most have it)
    - can search by original PSC submission ID (most don't preserve it)
    - can search *inside* source code like .frm, .bas, .cls, .ctl, and other files (full-text search, no one does it)
    - can search by original download filename and original thumbnail filename (most don't preserve it)
    - has an extensive index (by author, by category, etc. including All Time Hall of Fame)
    - can search/browse submissions by original authors (some don't preserve them)
    - can browse the source code directly on site (copy/paste API declares?) without downloading it (only gitea has it)
    - can fork submissions and collaborate on site like a true version control sysem (gitea is not public)
    - can browse all forks of the submission and find newer (better) versions of the source

    cheers,
    </wqw>

  13. #213
    Frenzied Member
    Join Date
    Dec 2008
    Location
    Melbourne Australia
    Posts
    1,379

    Re: Re PlanetSourceCode

    Thanks Derek(FortyPoundHead), and wqweto
    You both have made this 1,000 times easier (with the two posts above) for my tardiness.

    It appears that both of these repositories consist mainly of the 7 CDs contents.
    Thus containing PSC stuff up t0 2012

    I have been saving MORE RECENT recent PSC zips to my computer, but just for those that were of interest to me.
    And I am sure that vbforums members were doing similar
    Can WE ALL somehow come up with a coordinated plan/method/approach for us to upload them somehow/somewhere ?

    Rob
    PS Yes GitHub intimidated the hades out of me, in the past.

  14. #214
    Lively Member
    Join Date
    Jul 2020
    Posts
    99

    Re: Re PlanetSourceCode

    Quote Originally Posted by Bobbles View Post
    Can WE ALL somehow come up with a coordinated plan/method/approach for us to upload them somehow/somewhere ?
    The Internet has an unpleasant feature: sites disappear. For my needs, I already had to change two free hosting. One was overbought, the other became paid. It is good that the information was saved on the computer and on an external drive.
    I put everything into one .iso:
    https://drive.google.com/file/d/1xhq...ew?usp=sharing
    Since the image has not yet been filled up to the DVD level, I use the "Daemon tools lite" free program to work with it.
    I offered to supplement it with your codes, but you ignored my message.

  15. #215
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Posts
    2,441

    Re: Re PlanetSourceCode

    Quote Originally Posted by Bobbles View Post
    Can WE ALL somehow come up with a coordinated plan/method/approach for us to upload them somehow/somewhere ?

    Rob
    PS Yes GitHub intimidated the hades out of me, in the past.
    I'll gladly add collaborators to PSC organization on github so that anyone can upload new submissions.

    Just DM me your username you use there.

    Anyone that would like upload access to PSC organization on github contact me here or on github.

    cheers,
    </wqw>

  16. #216
    Member
    Join Date
    Oct 2015
    Posts
    55

    Re: Re PlanetSourceCode

    Quote Originally Posted by LaVolpe View Post
    Won several monthly contests. As an reward, I think I accepted a couple CDs, but later opted for the physical books they were offering at the time. Got several of those too. The only problem with the CDs, in my opinion, was that they were much like the site, but at a smaller scale -- needed to wade through weeds to find some gems.
    great, I remember ranking for the best code. one of mine was chosen. I could have gotten the book but the most important thing for me was the 'top code' sticker.



    I hope I have most of the code I put in there

Page 6 of 6 FirstFirst ... 3456

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width