VbTeams/Clubs Hack

vbTeams / Clubs Hack 2.0.2
this hack allow you to add teams to your board via smart mangemnet
from admin cp with special features like team admin, team privte forums, team privte aream, team chat, join to teams via polls
with addition of pm system.
every team got privte info and public which can be easyly manged via teamadmin control panel.
every team got privte forums and team admin get automaticly set to be team moderator.

features list is long so ill write it later.

also i didnt included the upgrade script for now as i didnt had time to test it
so only new install for you guys, sorry about that
well enjoy.


bug fixes excpected on 2.0.2 version :

• all header problems (headers allready sent) replaced by new error and redirect messages.
• query'scount,willbeaboutmax 7-8 querys per page, dosent metter how manyteams onboard(onold hackwe got 200 querys for 100 team).
• all session problems has been fixed.
• problems on member.php has been fixed.
• teamless timeout is fixed.
• teamadmin - upload avatars bug (save all images as gif) fixed
• reputation showenonly if enabled in vboptiions(Admincp)
• Fixed Navbar Array's

new additions on new version :

• Added $bbteaminfo with pre chace for better coding issue's
• Privte Team Forum - with privte posts,threads,polls
• join polls report
• enable/disable features via admincp
• Added Protect team with Password
• Reputation replaced with a Reputation Bar(Vb deafult)
• teamadminisautomatic set as moderator of the forum (without setting him up asmodvia admin cp) and have powers to close/open edit,stick and etc...
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

want to help ?
if you know about more bugs that not mention here
pleaseinformme,soicaninclude the fix's in the next versions.alsoifyougotmoreidea'sabout howto improve the hack i will begladtoknowaboutthemand to addthem.


Yours. MiZ.



added some screen shoots from next version

[anubis]

In team vote to users,
Appear database error :

There seems to have been a slight problem with the 虛空論壇 database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.3:

Invalid SQL: 
				UPDATE thread
				SET lastpost = 1104148790
				WHERE threadid = 
			
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 '' at line 3

mysql error number: 1064

Date: Monday 27th of December 2004 07:59:51 PM
Script: http://www.helzone.com/vbb/poll.php
Referer: http://www.helzone.com/vbb/teamprivtearea.php?do=viewpoll&pollid=100&teamid=4
Username: 阿修羅
IP Address: 61.230.41.76

poll.php whether want to amend what?

[JD210]

Getting the same error, and also, when anyone clicks the link to invite a user to join, they get taken to a blank page.

[JD210]

It was just brought to my attention that when someone clicks on a username, they are getting the following error:

There seems to have been a slight problem with the Vast Frontier database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

If they are logged in, there is no problem, they are taken right to the user profile, but if they are not logged in, then they get the above error message.


Edit: The more I think about it, the less use I can find for this modification on my board. How do I go about uninstalling it?

[eXtremeTim]

Should learn to use left joins. This adds two queries per thread on forumdisplay and adds a good number of queries to show thread as well.

[eXtremeTim]

In your show teamless code you used a query within the while loop. Mean there will be one query for each user who is teamless. Meaning on a large site you would have just hit that db hard. What you should do is what I did on my site and use the fetch_online_status function.

[eXtremeTim]

Originally Posted by JD210

It was just brought to my attention that when someone clicks on a username, they are getting the following error:



If they are logged in, there is no problem, they are taken right to the user profile, but if they are not logged in, then they get the above error message.


Edit: The more I think about it, the less use I can find for this modification on my board. How do I go about uninstalling it?

This is simple to fix I just fixed it on my site.

do the following

Find in member.php

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $bbuserinfo[teamid]
        "); 


Replace with

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $userinfo[teamid]
        "); 


Miz if you want I can release all the changes I did to my files to your for your next version so that you have a load optimized version. My sites url is http://www.extremechatforums.com/forums/index.php I cleaned up the code on forumdisplay using left joins. I cleaned up the code for showthread (required changes to showthread and functions_showthread) I also cleaned up the not in team list which now runs at 11 (4 of which are from some stats tracking code im using on my site so its really 7 queries) queries on my site no matter how many users as displayed.

[MikaK]

EDIT
The below parse errors were most potentially cused by a erroneus coding - one too much </if> conditionals in the postbit template (my own coding). However, as I decided to remove the hack before finding about the flaw I can not be totally sure.
EDIT

When trying to browse a thread:

If trying to view any thread I get a following error message:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/soundchi/public_html/loud_lounge/includes/functions_showthread.php(820) : eval()'d code on line 346

While the above repeats itself many times with a RBS forum it otherwise shows only once (currently that's the only thread with multiple messages - an indication?) and as the trhread opens the threadbits doesn?t show:
With single post threrads a vBulletin error message shows instead of any of the thread itself:

vBulletin Message

Unable to add cookies, header already sent.
File: /home/soundchi/public_html/loud_lounge/includes/functions_showthread.php(820) : eval()'d code
Line: 346



Now, my setup functions_showthread.php code at lines 340-346:

PHP Code:

$attachcount = sizeof($post['attachments']);
$thumbcount = 0;
if (!$vboptions['attachthumbs'] AND !$vboptions['viewattachedimages'])
{
$showimagesprev = $bbuserinfo['showimages'];
$bbuserinfo['showimages'] = false;
} 


The only modificaction into the threadbit template was the one showing in red below

<div class="smallfont">

<if condition="$show['threadratings'] AND $show['threadrating']"><span style="float:$stylevar[right]"><img class="inlineimg" src="$stylevar[imgdir_rating]/rating_$thread[rating].gif" border="0" alt="<phrase 1="$thread[votenum]" 2="$thread[voteavg]">$vbphrase[thread_rating_x_votes_y_average]</phrase>" /></span></if>

<if condition="$show['guestuser']">

$thread[postusername]

<else />

<span style="cursorointer" onclick="window.open('member.php?$session[sessionurl]u=$thread[postuserid]')">$thread[postusername]</span>

<if condition="$teaminfo['teamid']!=1">
<span style="cursorointer" onclick="window.open('showteams.php?$session[sessionurl]do=teamprofile&amp;teamid=$teaminfo[teamid]')"> @ $teaminfo[name]</span>
<else />

<span style="cursorointer" onclick="window.open('showteams.php?$session[sessionurl]do=teamless')"> @ $teaminfo[name]</span>

</if>

</if>

</div>

All admin area image paths are also somehow false... Only broken images showing... Voting on poll shows a false message, also the pm message showing as an error is quite annoying...

Any comments correcting the above would be greatly appreciated!


Best regards,
Mika

[miz]

if you getting error on polls issue its only cuse you edited poll.php worng
or missed few things, you cant blame me for problems you having, i dont say my code is perfect but its working, here its working for 100 % i know there might be few problems its ok im having problem to give support 24/7 here as most of week im not at home , im working to get updated and to fix bugs as soon as possible, sorry for problems
dont have anything to say anymore.

[sv1cec]

Originally Posted by eXtremeTim

This is simple to fix I just fixed it on my site.

do the following

Find in member.php

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $bbuserinfo[teamid]
        "); 


Replace with

PHP Code:

$bbteam =  $DB_site->query_first("
            SELECT *
            FROM " . TABLE_PREFIX . "teams
            WHERE teamid = $userinfo[teamid]
        "); 


Miz if you want I can release all the changes I did to my files to your for your next version so that you have a load optimized version. My sites url is http://www.extremechatforums.com/forums/index.php I cleaned up the code on forumdisplay using left joins. I cleaned up the code for showthread (required changes to showthread and functions_showthread) I also cleaned up the not in team list which now runs at 11 (4 of which are from some stats tracking code im using on my site so its really 7 queries) queries on my site no matter how many users as displayed.

Sorry, but aren't these two pieces of code the same? Unless I am too tired right now!

Rgds :-)

[yoyoyoyo]

Originally Posted by sv1cec

Sorry, but aren't these two pieces of code the same? Unless I am too tired right now!

Rgds :-)

the first one uses:

PHP Code:

$bbuserinfo[teamid] 


and the second one uses:

PHP Code:

$userinfo[teamid]