Notice: Tinychanners, welcome to dev.bbs. Official home of open-source ATBBS devlopment.

dev.bbs

Topic: ATBBS v1.0se

Whoreos started this discussion 9.6 years ago #9     

Seeing how so many people are still using ATBBS 1.0 but still want bulletins, I've made a special edition just for that.
Here you go. [P<>]
Don't forget to look at the readme file!
Advertisement: OtakuTalk - Unleash the Weaboo in you!

grey joined in and replied with this 9.6 years ago, 5 hours later#37     

Just after I finished installing 1.0, fuck.

Whoreos (OP) replied with this 9.6 years ago, 1 hour later, 6 hours after the original post#38     

lol, sorry. you won't have to erase your database though, just execute these 2 sql queries to add the extra tables:

------------------------------------------------------

--
-- Table structure for table `bulletins`
--

CREATE TABLE `bulletins` (
`no` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`poster` text NOT NULL,
`time` int(11) NOT NULL,
`date` text NOT NULL,
`uid` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

------------------------------------------------------

--
-- Table structure for table `pre_bulletins`
--

CREATE TABLE `pre_bulletins` (
`no` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`poster` text NOT NULL,
`time` int(11) NOT NULL,
`date` text NOT NULL,
`uid` text NOT NULL,
`ip` text NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

------------------------------------------------------

Anonymous C joined in and replied with this 9.6 years ago, 5 days later, 5 days after the original post#46     

> just execute these 2 sql queries to add the extra tables

Uhm...sorry but, how do I do that?

Whoreos (OP) replied with this 9.6 years ago, 1 hour later, 5 days after the original post#49     

@previous
What hosting service are you using?

Anonymous C replied with this 9.6 years ago, 22 hours later, 6 days after the original post#52     

oh, byethost.

sim joined in and replied with this 9.6 years ago, 5 hours later, 1 week after the original post#53     

I made my own little modded atbbs based on the vanilla source, it has fixed statistics page, bulletins, shuffle, hot topic, rules, sysop links when posting, more mark-up shit, and more.

Read the README, get the source here:

http://ifile.it/4q1zpl8 [P]

When I finish implementing more small changed I will post another link. Feel free to rip anything from it that you need.

Thing I want to add:

- Link to topics listed by date, like TC/AT have, not just latest bumps.
- Proper spam filters (RBL based would be sweet).
- Lock-down mode in case of bot attack.
- Tripcodes.
- Working PM the system and ability for users to receive PM back.
- Links to moderator page under mods names when posting, for now it just works with sysop postings.

I also wouldn't mind setting up another git/svn or whatever, as I don't really like the ADODB branch, and the lack of interest Harbinger has in developing the vanilla sources.

I quite like the vanilla, plain, light, easy on resources. Just needs some optimisation from someone sho really knows php+sql.

Whoreos (OP) replied with this 9.6 years ago, 4 hours later, 1 week after the original post#54     

@52
after you log in to vistapanel, go to the database manager and find "execute query"
then just paste the code from the other post, and execute.

@previous
I've added your version to the repository as "ATBBS 1.1b" (beta, since I haven't seen it in action)
By the way, is there some way to make the separator bar behave like the last seen marker; i.e. use the #last_seen_marker class defined in the stylesheet?

(Edited 13 hours later by a moderator.)

grey replied with this 9.5 years ago, 6 days later, 2 weeks after the original post#68     

Im a newfag at this. Just sayin.

Im looking at the code and I cant tell where one sql querie starts and the other begins. -_-;

Whoreos (OP) replied with this 9.5 years ago, 5 hours later, 2 weeks after the original post#71     

@previous
That's what the long dashed lines are for, but you should be able to execute the entire file (install.sql) at once if you're starting from scratch.

This page took 0.004 seconds to be generated.
[ ATBBS 1.5c ]

In order to conserve space and bandwidth, this site uses arithmetic coding for full-size jpeg images. If your browser does not support arithmetic coding, please report it as a bug to the browser's developer.