• BBS list

    From Spectre@21:3/105 to Vk3jed on Thursday, September 05, 2019 18:44:00
    http://tlp.zapto.org/bbs/all.php

    provisional listing..... sorry, I needed to add someone else in there to test things. Still have to come up with a form to post new entries yet.

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Vk3jed on Friday, September 06, 2019 13:18:00
    Cool, though my OS is actually Raspian. :P

    It was all a guess.. I just needed a second entry to make sure things were working. I'll post another massage when I get a form to add things up and running.

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Vk3jed on Friday, September 06, 2019 21:04:00
    were working. I'll post another massage when I get a form to add things

    Well it turns out, I'm posting not because it works, but because it doesn't :/

    How is anyones PHP+Apache?

    $status=$_POST['status'];
    $system=$_POST['system'];
    $sysop=$_POST['sysop'];
    $access=$_POST['access'];
    $telnet=$_POST['telnet'];
    $www=$_POST['www'];
    $hours=$_POST['hours'];
    $computer=$_POST['computer'];
    $dos=$_POST['dos'];
    $software=$_POST['software'];
    $emulation=$_POST['emulation'];
    $est=$_POST['est'];
    $notes=$_POST['notes'];

    This lot which looks nasty in the message editor keeps throwing an undefined index: system. Which I canna understand. Any ideas? The form's looking good, but can't post yet.

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Alterego on Friday, September 06, 2019 22:51:00
    Since you are using $_POST, it means the form that you have posted
    back, isnt setting 'system' as a value to post back.

    In some ways its weird, from the example I'm working with, it looks like $_POST
    is an array, which so long as its assigned correctly, should you just be able to assign, and then post to the sql data base by writing the array?

    But I digress, having crawled past that problem, even if its not set, at least you get a null value, which seems fine. I now have what looks like an sql error... that I can't get my head around....

    INSERT INTO list(status,system,sysop,access,telnet,www,hours,computer,dos,est, notes)VALUES('ONLINE', 'donkey', 'gherkin','ONLINE','flopdingle.bbs.org.sdf',' flopdingle.bbs.org.sdf','24hrs','bomb','bdos','sdfs','ASCII','yesterfay',' ')

    thats what comes out of the PHP script, which looks mostly right to my eyes... Apache just show "error" if I use that line straight into sql I get

    ERROR 1136 (21S01): Column count doesn't match value count at row 1


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Vk3jed on Saturday, September 07, 2019 10:47:00
    I can admin an Apache server, but never looked at PHP, beyond hacking already written code to suit a particular purpose.

    Thats about my normal state of affairs. But sometimes you want to do something
    and can't find an alternative...

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to All on Saturday, September 07, 2019 15:47:00
    Well its not ready for the public to tear to shreds, but seeing as we're
    all restrained adults here, feel free to bang your details into the list.

    It looks prettier. Search and Edit are not functional, but coming.

    tlp.zapto.org/bbs

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to All on Saturday, September 07, 2019 22:24:00
    Alrighty, search is functional...

    Tomorrows tasks, is to get data checking in place on
    add bbs, and to get edit working in some fashion. This
    won't seem like high security or anything, but I'm
    considering using the sysops name +"1" or something as
    an auth requirement to edit a bbs entry. Or is someone
    going to be crazy enough to damage the db just for the
    hell of it?

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Blue White on Sunday, September 08, 2019 04:00:00
    tlp.zapto.org/bbs

    Is it only for BBSes in Australia?

    Originally, I thought about it, but no, its a FFA... Free For All...

    Spec



    PS: Only edit BBS System left to fix. Add/Search/View List are all working


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Jagossel on Sunday, September 08, 2019 11:37:00
    Tomorrows tasks, is to get data checking in place on add bbs, and to
    I would say to focus on sanitizing your inputs to prevent SQL and
    HTML injection. I would imagine that there might be good examples for
    PHP.

    Hmm to be honest, I wasn't overly worried, more interest in making it work rather than finding new ways to break it . :) However you're right, and there's
    some sanitizing in place from the scripts I used to work from. Looks like PHP functions for sanitizing.

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)
  • From Spectre@21:3/105 to Nightfox on Monday, September 09, 2019 07:22:00
    I don't know if it was intentional, but that whole
    paragraph is indented

    For better or worse it was intentional, and done in iceedit.

    Ah.. I'm curious why?

    Welll, I think the very first line started normally, then I went a tab for the start of a paragraph, and just kinda kept going instead.... I got your attention :)

    Spec


    --- --- SuperBBS v1.17-3 (Eval)
    * Origin: <Shoot'n the breeze on The Lower Planes> (21:3/105)