Rap Battle System -=RBS=-

Ladys and Gentlemen, i give you, The Rap Battle System -=RBS=-


Many people have been requesting this so here it is. Took along time so im hoping it becomes a popular hack :nervous:



Features

Hmmm there are a few. Select the forum which the battle hack works in via the admin cp
Can edit a users win/loss record via the admincp aswell.

When someone wins a battle it automatically adds it to their win count and the opposite if they lose

The thread does not auto close because in my many years of experience people like to post/argue on after a battle is won or lost.

Erm oh and you submit your favourite line from the battle and it will get added to a database, then lines are randomly shown on the forum homepage.

Check the installation.txt for the full list, Also there is loads more features to come. Hopefully some people will release some addons maybe

Screenshot time wohoo

Oh yeah, the install button is your friend


Attachment edited/upgraded on 15th August 2004 had 87 views woot
Edited attachment on 15/1/2005 to stop all polls closing after one vote. Fix submitted by KingPooky!

[Logik]

Im workin on the top 5 emcees right now.

[Logik]

ok, open up index.php, and anywhere in there, add this code:

// top5emcees
$best = $DB_site->query("SELECT userid, username, bs_wins, bs_loses FROM user ORDER BY rank DESC LIMIT 5");
while ($besttop = mysql_fetch_array($best)):
	++$besttopnbsp;
  $count=$count+1;
$rat = ($besttop[bs_wins] * 3) - ($besttop[bs_loses]);

$ranking = $DB_site->query_first("SELECT rank FROM user WHERE username= '".$bbuserinfo[username]."'");
$ratio .="$rat<br>";
$bestbattler .= "$count <a href=http://www.flowsession.net/forum/member.php?u=$besttop[userid]>$besttop[username]</a> ($besttop[bs_wins]/$besttop[bs_loses])<br>";
     
$DB_site->query("UPDATE user SET rank = $rat WHERE username = '".$bbuserinfo[username]."'");	

endwhile;

Go to your templates, and whereever u want it to show up, add:

<br>
<if condition="$bbuserinfo['userid']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead" width="100%" valign="top">
<normalfont><b>Top 5 Emcees</b></normalfont></td>
</tr>
<tr><td>
$bestbattler</td>

</tr>
</table>
</if>
<br>

I believe thats it.. That shows the ranking, name, and battle. It sorts by ranking.. ( i used a simple formula for ranking). Im havin trouble gettin the rankin in the postbit, it doesnt show up for some reason.. so ifa nyone wants to help with that, then feel free.

[Battle_Ring]

^ I keep getting a database error...

Invalid SQL: SELECT userid, username, bs_wins, bs_loses FROM user ORDER BY rank DESC LIMIT 5
mysql error: Unknown column 'rank' in 'order clause'

[Logik]

oo yea lol... in your phpmyadmin, add the row "rank" to your user table.. my fault

[str8ballin]

Originally Posted by C.Birch

its killing everyday poll's for me

when voteing on a everyday poll you get the error screen, but your vote goes on the poll but it closes the poll.

error:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE user SET bs_wins = bs_wins + 1 WHERE username = 'Who's David?'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's David?'' at line 1

mysql error number: 1064

Date: Friday 13th of August 2004 10:23:25 AM
Script: http://community.ultimate-music.net/poll.php
Referer: http://community.ultimate-music.net/...06257&posted=1
Username: CarlBirch
IP Address: 217.43.193.87

i have removed the edit from poll.php for now.

I too am experiencing this error, I get

---------
Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET bs_wins = bs_wins + 1 WHERE username = 'He's finished'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's finished'' at line 1

mysql error number: 1064
----------

Seems the exact same error.

If I get this runnin without any errors I will be very grateful for this hack and appreciate MindTrix sharin this with us.

[influence]

hey mindtrix, thanks for this. even though this looks like the one given to me but the 2.2 one without the quote fav line part but I might use this ONLY if its BUGS FREE

also suggested features... maybe the KO addon ( only if i know PHP then I can code a simple ... if vote result = 5-0 then add point to field 3 with feild one being win and field 2 being lose ).

also maybe a battle record statistic to show all past battles and who that member battle.

since this is free, I can't give out my other ideas since it might take a while to do those but both of those should be something easy to do

[Romeos Tune]

Ok.... I'm having a problem if someone tries to quote a line with a ' in it. Like in he'll or we're. Somehow we need to add something in the code that will allow punctuation marks..... Here's the error:

Invalid SQL: INSERT INTO vb3_battlesys_favlines VALUES ('', 'Ask 5 minute HH, I bet he'll agree', 'Storm', '38')
mysql error: You have an error in your SQL syntax near 'll agree', 'Storm', '38')' at line 1

mysql error number: 1064

I'll try and find this but I'm just learning this stuff so my chances aren't good......

[Romeos Tune]

btw..... This is in the modification to the file "newreply.php"

[Liquid1ce]

i dont think they are supporting it anymore ????

shame this could have been a great hack

[Romeos Tune]

No doubt a shame..... My users are going crazy for it but I'm gonna have to uninstall it... And my site isn't even a music site... lol