Market Bulletin (SQL)

[Enzo0714]

This is my 2nd script release

Market Bulletin (SQL)

Version 1.9

Compatibility

- rAthena SVN

Requirement

- MySQL

- run this SQL on your RO database or import the attached .sql file

CREATE TABLE IF NOT EXISTS `market_bulletin` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `type` varchar(1) NOT NULL DEFAULT 'O',
 `char_name` varchar(23) NOT NULL,
 `message` varchar(70) NOT NULL,
 `post_time` datetime NOT NULL DEFAULT '2012-01-01 00:00:00',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `market_bulletin`
--

INSERT INTO `market_bulletin` (`id`, `type`, `char_name`, `message`, `post_time`) VALUES
(1, 'S', 'Testing', 'Test message', '2012-01-01 00:00:00');

Description

- A bulletin where players can read and post market offers like buying, selling, trading and others.

Additional Info

- Player can have a maximum of 5 posts by default.

- Posting fee is 1M. Player can also post and broadcast at the same time. Broadcasting fee is 3M zeny.

- Includes managing of posts where the player can edit, delete or broadcast their posts.

- Also includes search function.

- Posts will be deleted after 72 hours (3 days) by default.

Special Thanks

- Venom

---

Please report bugs here if you found any.

Market_Bulletin_SQL.txt

mbsql.sql

[GM Djinsu]

@ Enzo0714

Thank you for this, testing now & so far all is functioning properly, I really like this script a lot and appreciate the share! If I were

to make a suggestion to make this even more excellent it would be to add a GM Menu for deletion of posts without having to edit

SQL Tables manually. Players could potentially abuse the message input on servers who do not use chat and textual filters.

[Enzo0714]

Thanks GM Djinsu. Nice suggestion I'll try adding a separate NPC within the file.

[Erba]

sir how to use this? sorry newbie here

This is my 2nd script release

Market Bulletin (SQL)

Version 1.9

Compatibility

- rAthena SVN

Requirement

- MySQL

- run this SQL on your RO database or import the attached .sql file

CREATE TABLE IF NOT EXISTS `market_bulletin` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `type` varchar(1) NOT NULL DEFAULT 'O',
 `char_name` varchar(23) NOT NULL,
 `message` varchar(70) NOT NULL,
 `post_time` datetime NOT NULL DEFAULT '2012-01-01 00:00:00',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `market_bulletin`
--

INSERT INTO `market_bulletin` (`id`, `type`, `char_name`, `message`, `post_time`) VALUES
(1, 'S', 'Testing', 'Test message', '2012-01-01 00:00:00');

Description

- A bulletin where players can read and post market offers like buying, selling, trading and others.

Additional Info

- Player can have a maximum of 5 posts by default.

- Posting fee is 1M. Player can also post and broadcast at the same time. Broadcasting fee is 3M zeny.

- Includes managing of posts where the player can edit, delete or broadcast their posts.

- Also includes search function.

- Posts will be deleted after 72 hours (3 days) by default.

Special Thanks

- Venom

---

Please report bugs here if you found any.

sir how to use this? sorry newbie here

[GM Djinsu]

You Paste the SQL Syntax into your SQL directory within a New Query and commit it to

your directory to change tables to accommodate the SQL within the textual script provided.

[Erba]

You Paste the SQL Syntax into your SQL directory within a New Query and commit it to

your directory to change tables to accommodate the SQL within the textual script provided.

ill paste it in the SQL directory where tha Main.SQL is in??

then ill make a new schema for the market bulletin.sql?

then paste the market bulletin.txt in the NPC custom folder???

correct me sir if i mistaken...

[RyokoMVP]

You Paste the SQL Syntax into your SQL directory within a New Query and commit it to

your directory to change tables to accommodate the SQL within the textual script provided.

ill paste it in the SQL directory where tha Main.SQL is in??

then ill make a new schema for the market bulletin.sql?

then paste the market bulletin.txt in the NPC custom folder???

correct me sir if i mistaken...

open phpmyadmin

open your ragnarok table

import new sql ( market bulletin.sql )

open your custom npc folder

insert market bulletin npc there

[Erba]

You Paste the SQL Syntax into your SQL directory within a New Query and commit it to

your directory to change tables to accommodate the SQL within the textual script provided.

ill paste it in the SQL directory where tha Main.SQL is in??

then ill make a new schema for the market bulletin.sql?

then paste the market bulletin.txt in the NPC custom folder???

correct me sir if i mistaken...

open phpmyadmin

open your ragnarok table

import new sql ( market bulletin.sql )

open your custom npc folder

insert market bulletin npc there

what if i only use my SQL database.. and im running my server on LAN?

[GM Djinsu]

You import the SQL Code provided with this script directly into your main directory, the same directory all of your other ragnarok SQL files were originally imported to.

[Erba]

You import the SQL Code provided with this script directly into your main directory, the same directory all of your other ragnarok SQL files were originally imported to.

sir im confused sorry! ill put the SQL in the SQL files.. then i will add a new schema for the MARKET.SQL? or ill repeat making a schema for main.sql?

sorry newbie T_T

[mrlongshen]

@2834, u should import the sql files on the ragnarok database. then u execute. after that pastu the script. and load it on your game .done.

[Erba]

thanks for the help done! ^^

Trial and error method

[Start_]

Working! 5/5 Rated

[elmucho]

how to change broadcast color to a different one ? for example white