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

[TunerNetwork]

Well everyone got it working, thanks to Seph, cheers to you mate! appreciate all your help

[miz]

hey guys sorry for being gone, for few times

ok first of all TunerNetwork - this installer is for clean boards - not upgrade of the hack

to all you that complains , make a clean install of vb306 and try the hack

i dont responsiblle for the modifctations you installd on your own boards
as my hack working perfect on clean install of vbulletin so i dont have problem with that

and for the guy that said its have problems with table_prefix well sorry to disapointed you its working perfect, not my fault that some guys here dont read the instractions carefully,

few things that i do need to fix, is
the lower case problem which is minor and newthread.php edit which i forgot to add to installer instractions, - thats why you getting an error, cuse its redirect you to newthread and you cant see team threads via newthread..

[TunerNetwork]

One suggestion, include clean instructions, just my 2 cents.
This is a great hack Miz, dont misunderstand me. Just the frustrations of minor errors added up and I needed this hack. Good work anyhow, and looking forward to future additions to this hack.

[miz]

well if you can list in descrption that difrenet then "its not working" all of errors you getting
i can fix them in no time.

sorry but for me its harder to make the install instractions then make the hack itself
weird heh

[Sephiroth690]

Originally Posted by miz

and for the guy that said its have problems with table_prefix well sorry to disapointed you its working perfect, not my fault that some guys here dont read the instractions carefully,

Exactly what "instractions" are you refering to. All I have are file edits, template edits and known bugs that don't relate to any table prefix problems. And of course its working perfectly for some people, because some people don't have prefixes in their databases. And the whole "minor error" thing about the letter case, well, I don't consider it "minor" if it makes the entire thing not install.

Another "bug" that I think I've noticed is located somewhere in team application. IDK if it's mentioned in teh instructions i don't have but I believe, from first glance that delimiting characters were no included in the application code. I'm prolly overlooking somthing from trying to fix all the other problems portaining to the install but, everytime someone tries to apply for a team, and uses a character such as '. They'll get an SQL error. May be somthing to look into for next update.

[Digma]

After having installed the mod yesterday following Miz' instruction, I was still having problems when trying to obtain information on the teams (showteams.php and userteam.php). Dunno if anyone else experienced the same with the latest version (2.0.2.)

I checked the MySQL code in these two files again after checking the error below:

For example:

Invalid SQL: 
	SELECT teams.*, teams.name AS username,
	 
	COUNT(user.userid) AS totalmembers,
	sum(user.posts) AS posts,
	sum(user.reputation) AS reputation 
		FROM td_teams AS teams
 	LEFT JOIN td_user  ON(teams.teamid = user.teamid)
	WHERE teams.teamid =2
	GROUP BY teams.teamid
		

mysql error: Unknown table 'user' in field list

And replaced:

 	LEFT JOIN td_user  ON(teams.teamid = user.teamid)

By:

 	LEFT JOIN td_user AS user ON(teams.teamid = user.teamid)

NOTE: Check for the TABLE_PREFIX instead of td_user of course as "td" is obviously my prefix. Sorry for not having the complete code, as I am at work and can't download zip files here.

And it seemed to work. But now I am still getting the same error when calling for the profile and the strange thing of this is that I can't seem to be able to find the code in the file (showteams.php) where "AS user" is missing or any of the other files for that matter.

Anyone know how to tackle this problem? (note: I have cleared my cache)

[Digma]

After doing some searching and exchanging PM's with Miz, I found what I was looking for. Unfortunately that was just the beginning and I was faced with a couple of other bugs. So here's a list of what I found so far in v2.0.2.. Note: I work with a pre-fix on my forums, people with no pre-fix probably won't have a problem with Bug 1.

BUGS:
1) Missing "AS user" or "AS session" in MySQL statement in functions.php (edit), showteams.php, userteams.php and teamprivatearea.php (might be in more but I haven't come that far to iron everything out).

2) The "no avatar" picture is not linked in the team profile page.

3) "Login to Admin area" doesn't have a teamid in it's url, resulting in an error. The same goes for all the links in the navigation bar of the Priv(a)te area.

4) Team Posts is not appearing on the teams' profile page. (Shouldn't this be displaying the number posts even if there's only one user?)

MISSING(?):
1) Option for a user to start a new team, can't find it anywhere. In a 20K community, people msg-ing admins about wanting a new team will become a administrative nightmare. Is it supposed to be included or am I missing something?

Note: This ain't meant when a user wants to sign up to an existing team, but if someone wants to start a NEW team.

I would love to install this hack properly as I feel it will be a great feature for our community, but I would rather have the de-installation instructions for it now as it is causing more problems while I proceed fixing it (if I can find it). By that time I will be near deadline for our new forum and I can't have that.

Hope you will be able to do something about the above. Keep up the good work

Mark

[skorzguy]

How does one fix this problem? Members with no avator? Look at the example to see what I mean?


http://www.allstarchat.com/forums/sh...=8880#post8880



It would be great if a member could start his or her own team as somebody mentioned above.

[TunerNetwork]

Members of the club are having trouble accessing the private forums, any reason for this?

and my apply to team isnt working. Im gonna see what im getting for errors

[christirichards]

To use this hack, I've had to completely rewrite it, including the multitude of spelling annoyances throughout the code. There are so many holes with the existing version that it should go back to Beta as it is NOT stable whatsoever. There is no way this has worked in its entirety on a clean board with the changes provided.

My database has been restructured to allow for multiple teams per user and allow users to create and manage their own teams. The whole section from the ACP has been ripped out and the users now have control over what they want to do.

It has been a nightmare, but it's part of the project that I'm on right now. I was just mistaken in thinking that this would be an easier solution.