Not sure if this is the correct place to post this, but I was looking for a way to have new high scores from the arcade shouted in the VSa - Chatbox and could find nothing in this thread, so I created this...
Obviously need to have VSa - Chatbox & ibproarcade installed. This is currently working for the latest versions of each on my site, which can be viewed
HERE
Also create a new bbcode called 'siteurl' with the code
<a href="{option}">{param}</a>
(This makes the game link in the chatbox open in the same window rather than a new one)
Code:
Title = siteurl
BB Code Tag Name = siteurl
Replacement = <a href="{option}">{param}</a>
Example = [siteurl=http://www.example.com]Example Web Site[/siteurl]
Decription = This open site urls in the same window rather than the default target="_blank"
Use {option} = Yes
Button Image (Optional) = Leave Blank
Remove Tag If Empty = Yes
Disable BB Code Within This BB Code = No
Disable Smilies Within This BB Code = Yes
Disable Word Wrapping Within This BB Code = Yes
(Please bare in mind I am not an expert so take no responsiblity for any damage you may cause - backup arcade.php first!). If there was a simpler way to do it, I searched but couldnt find it.
Open arcade.php and find around line 3846
PHP Code:
// finally update Highscore-Table
if ( ($this->arcade->user['id'] != 0) && ($player_score <> 0) )
{
$DB->query("UPDATE ibf_games_champs SET ".$db_string." WHERE champ_gid=".$gid);
$ginfo['champ_mid'] = $this->arcade->user['id'];
$ginfo['champ_name'] = $this->arcade->user['name'];
$ginfo['champ_score'] = $player_score;
Add after
PHP Code:
// Insert New Chatbox Message
$DB->query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND g.active=1 AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,1");
while( $row = $DB->fetch_row() )
{
$newchattxt .= "[color=green]".$row['champ_name']." set a new high score of ".$row['champ_score']." in [/color][siteurl=http://".$_SERVER['SERVER_NAME']."/arcade.php?do=play&gameid=".$row['champ_gid']."]".$row['champ_gtitle']."[/siteurl]";
$vbulletin->db->query_write("
INSERT INTO ".TABLE_PREFIX."vsa_chatbox
(userid, userip, message, dateline, textprop)
VALUES ('42', '".$_SERVER['REMOTE_ADDR']."', '".$newchattxt."', ".TIMENOW.", '')
");
}
// End insert
Then Find
PHP Code:
if ($player_score <> 0) // no champ with no result ...
{
$DB->query("INSERT INTO ibf_games_champs (" .$db_string['FIELD_NAMES']. ") VALUES (". $db_string['FIELD_VALUES'] .")");
$ginfo['champ_mid'] = $this->arcade->user['id'];
$ginfo['champ_name'] = $this->arcade->user['name'];
$ginfo['champ_score'] = $player_score;
Add after
PHP Code:
// Insert New Chatbox Message
$DB->query("SELECT c.*, g.gcat, cat.password FROM ibf_games_champs AS c, ibf_games_list AS g, ibf_games_cats AS cat WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND g.active=1 AND trim(password)='' ORDER BY champ_date DESC LIMIT 0,1");
while( $row = $DB->fetch_row() )
{
$newchattxt .= "[color=green]".$row['champ_name']." set a new high score of ".$row['champ_score']." in [/color][siteurl=http://".$_SERVER['SERVER_NAME']."/arcade.php?do=play&gameid=".$row['champ_gid']."]".$row['champ_gtitle']."[/siteurl]";
$vbulletin->db->query_write("
INSERT INTO ".TABLE_PREFIX."vsa_chatbox
(userid, userip, message, dateline, textprop)
VALUES ('42', '".$_SERVER['REMOTE_ADDR']."', '".$newchattxt."', ".TIMENOW.", '')
");
}
// End insert
Change
BOTH INSTANCES of 42 in the above to the value to the userid of the users name you wish to appear in the chatbox. i.e. I have a user with id 42 called Arcade who does all the arcade shouting.
Thats it.
Jim.
More Information