Shoutbox

[PaGaisu]

Apparently, some of you were interested on the Onyx shoutbox and wanted to integrate the same in their manialink.

So better to share my code.
Requirements:
- http server with php5 (maybe it works on php4, i did not try)
- MySql (if you have another database, you ll have to do some adjustement)

Php code: http://www.dndnetworks.com/onyx/manialink/shoutbox.txt (to be saved as php file)
Sql code: http://www.dndnetworks.com/onyx/maniali ... ox.sql.txt
Example: Onyxcolor>

Note: I marked in the php code where you should change the coordinates for the shoutbox location.

[jimos94]

Good Job Pagaisu, kool design

[SmokyBird]

Thanks for the chat Pag

But can someone explain me how to put our informations about SQL ? Really difficult, first time using it

[PaGaisu]

If u have phpmyadmin, it s pretty straight forward.
u just need to copy/paste the SQL after having selected/created a database.

[SmokyBird]

I've already made this chat with kev717's help. But now, I've got full errors on the php code

(sorry bad english)

[Terron]

Code: Select all

$http_location="http://".$_SERVER["HTTP_HOST"].$_SERVER["PHP_SELF"];

what I have to add as http location???

[Terron]

please make here step-by-step tutorial

[PaGaisu]

U have not to change http_location.

The only parameters to modify are the following :

Code: Select all

/** To change: database details **/
$db_host = "localhost"; // ip:port
$db_user = "DATABASE_USERNAME";
$db_pass = "DATABASE_PASSWORD";
$db_name = "DATABASE_NAME";
/** end **/

Change this and create the right tables in the right location of ur DB using the sql file.
It s quite basic, u can do it manually if u prefer. The sql just create a table:

Code: Select all

CREATE TABLE `manialink_shoutbox` (
  `id` mediumint(8) NOT NULL auto_increment,
  `login` varchar(255) collate utf8_unicode_ci NOT NULL,
  `nickname` varchar(255) collate utf8_unicode_ci NOT NULL,
  `lang` varchar(10) collate utf8_unicode_ci NOT NULL,
  `path` varchar(255) collate utf8_unicode_ci NOT NULL,
  `message` varchar(255) collate utf8_unicode_ci NOT NULL,
  `timestamp` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=680 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=680 ;

[Terron]

I did it but when i want to view it by in-game browser, it says INVALID MANIALINK ILE, I have also registered it at playerpage

[PaGaisu]

Can u give me the url of ur manialink ? i ll take a look on the xml which has been generated by the php.

[Terron]

ok it works, I hat to save it as PHP file, not XML

[gooblaster]

Errr.... How do you install this? lol..
I know... Im noob.. Could anyone be so kind as to help me out here?

[PaGaisu]

You need to have a minimum of knowledge on php and DB.
Can u find a friend to explain u this ?