vb.org Archive
Page 9 of 45 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Rap Battle System -=RBS=- (https://vborg.vbsupport.ru/showthread.php?t=68161)

Logik 08-13-2004 07:16 PM
Im workin on the top 5 emcees right now.

Logik 08-13-2004 07:18 PM
ok, open up index.php, and anywhere in there, add this code:
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:
Code:
<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 08-13-2004 10:51 PM
^ 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 08-13-2004 11:30 PM
oo yea lol... in your phpmyadmin, add the row "rank" to your user table.. my fault

str8ballin 08-15-2004 12:38 AM
Quote:
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 08-15-2004 03:12 PM
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 08-16-2004 02:19 AM
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...... :D

Romeos Tune 08-16-2004 02:23 AM
btw..... This is in the modification to the file "newreply.php"

Liquid1ce 08-17-2004 01:48 AM
i dont think they are supporting it anymore ????

shame this could have been a great hack

Romeos Tune 08-17-2004 04:00 AM
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


All times are GMT. The time now is 06:22 AM.
Page 9 of 45 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01475 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete