in game community board

Printable View

10-10-04
scrapy

in game community board

anyone know how to add posts onto the boards? i can get to the point when it asks to put a title and text in game, but when i press ok, nothing happens

i can make announcements but i dont know how to make a new line in the announcements so all my text is in 1 big line, makes it hard to read what i type in there kind of like how i am typing right now, its quite annoying, does anyone know how to make new lines for announcements?

i have looked in some of the files in the lin2comm database, and i find this.
--------------------------------------------------------
lin_GetArticleList
**
set @table_name = 'board_' + @str_board_id
**
+ ' select top ' + cast( @top as nvarchar) + ' root_bid, thread_order, bid, step, parent_bid, char_id, char_name, account_id, account_name, world_id, title, datediff( ss, ''1970/1/1 0:0:0'' , post_date ) , datediff( ss, ''1970/1/1 0:0:0'' , modify_date ) , read_count, status, comment_cnt, keyword
**
-------------------------------------------------------
it looks to me like there is a needed table that is missing? i cant find any table with those colums, i have tried to create tables with those colums called " board_article , board_ , comment_ " but i cant get it to work.

and my cached has this error

http://members.westnet.com.au/faithlouise/error.JPG
how can i fix it
11-10-04
scrapy

anyone got it working yet?
11-10-04
hicks

check here
Server DIY - GET THE BBS WORKS
11-10-04
scrapy

1) run SQL server enterprise manager
2) open SQL analyze query
3) under lin2comm database -> stored procedures
4) open the dbo.lin_MakeBoard

parent_bid=0 (if you want make a sub bbs)
name=your bbs name
location=0
description=your bbs description
type=1 system bbs / 4 player bbs
admin=admin of the bbs
permission=0 no show/ 4 post only / 8 reply only / 12 post & reply / 255 adv mode
pledge_id=0 (if you want the bbs for clan put the clan id(pledge_id) into it, check it out in pledge table under lin2world databse)
world_id=your world_id(check it in your ini's file)
page_size=1~20(11)
keyword=0

i have done all that in board_list , but i still cant make any posts
do i have to add those lines in to the dbo.lin_MakeBoard somehow?

here is my board_list table
http://members.westnet.com.au/faithlouise/boardlist.JPG
i have tried all permissions 4/8/12/255
11-10-04
scrapy

if you cant see what i am doing wrong, can u please export you lin2comm database so i can download it? these ingame forums are annoying me lol
11-10-04
Stinger357

Permission needs to be set to either 255 or 28...whichever you prefer...but that will fix your problem...in the field called permission make it 255 or 28.
11-10-04
scrapy

Quote:

Originally Posted by stinger357

Permission needs to be set to either 255 or 28...whichever you prefer...but that will fix your problem...in the field called permission make it 255 or 28.

no thats not it, if u read the last line of that post u will see i tried all those permissions.
has it anything to do with boarf_keyword ? i havenothing in there
11-10-04
hicks

why u did not open dbo.lin_MakeBoard? if u dont have a board what the board_list for?
it's your problem :)
11-10-04
Stinger357

I'll let hicks handle this...since I don't read well...and I'm such a newb at this....
11-10-04
scrapy

ok i try to explain better from the start
.................................
i made the database lin2comm and added the file lin2comm_new.sql

then all the tables ect was automaticly made.
then i read this,
1) run SQL server enterprise manager
2) open SQL analyze query
3) under lin2comm database -> stored procedures
4) open the dbo.lin_MakeBoard

parent_bid=0 (if you want make a sub bbs)
name=your bbs name
location=0
description=your bbs description
type=1 system bbs / 4 player bbs
admin=admin of the bbs
permission=0 no show/ 4 post only / 8 reply only / 12 post & reply / 255 adv mode
pledge_id=0 (if you want the bbs for clan put the clan id(pledge_id) into it, check it out in pledge table under lin2world databse)
world_id=your world_id(check it in your ini's file)
page_size=1~20(11)
keyword=0
..................
i couldnt work out how to put that into the stored procedure dbo.lin_MakeBoard
but so i added that info to the table boaard_list instead.

now when i go in game and access the boards, i can see the board i made " Trade " and i can go into it.
the problem is when i click on write, and put in the title and contents and press ok, it does not get added to the board.

i hope this helps..

perhaps if you have yours working you can send me your code from dbo.lin_MakeBoard and i can simply add it to mine and it will work?.

if you have msn please add me shads_runescape@hotmail.com and that will be easyier to talk about it.
11-10-04
scrapy

anyone can help?
11-10-04
hicks

dbo.lin_MakeBoard is stored procedures
borad_list is table... they are not the same...
open stored procedures in SQL analyze query
11-10-04
scrapy

i dont have SQL analyze query
i have MS SQL Query but i dont think that will work
and instead of enterprise manager i use MSDE Manager
11-10-04
SOnick

You must be level 10 or higher to be able to post in the bbs.
12-10-04
zBuffer

The MakeBoard procedure.. Can I execute it using a query? (Much easier for me)
12-10-04
scrapy

Quote:

Originally Posted by SOnick

You must be level 10 or higher to be able to post in the bbs.

tried with 4 different characters on 2 different accounts
level 54
level 50
level 37
level 20
none work.
13-10-04
scrapy

problem solved, i did some research on stored procedures so i could undestand it better lol, turns out my problem was so simple to resolve.

but i have 1 other thing... i want to make a GM only board, where other players cannot view it, but even with permissions 0, any account can still view the board
15-10-04
scrapy

to anyone who has trouble getting the bbs to work, here is what i did.
load up your data manager, and open the sql code window so you can put in some code.
put in this code:

Quote:

EXEC dbo.lin_MakeBoard
@parent_bid='0',
@name='Trade',
@location='0',
@description='Buy / Sell',
@type='4',
@admin='Shads',
@permission='255',
@pledge_id='0',
@world_id='1',
@page_size='10',
@keyword='0'

make sure to run it on your lin2comm database. and that will make a board in the bss that will work ingame. to make more boards just edit the name and description and run it again.