vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   VbTeams/Clubs Hack (https://vborg.vbsupport.ru/showthread.php?t=72448)

TunerNetwork 02-20-2005 09:34 PM

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

miz 02-21-2005 04:45 PM

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 02-21-2005 05:33 PM

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 02-21-2005 07:41 PM

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 02-21-2005 08:32 PM

Quote:

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 02-22-2005 06:00 AM

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:
Code:

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:
Code:

        LEFT JOIN td_user  ON(teams.teamid = user.teamid)
By:
Code:

        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 02-22-2005 09:07 AM

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 02-22-2005 04:29 PM

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 02-22-2005 10:12 PM

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 02-23-2005 03:37 AM

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.


All times are GMT. The time now is 12:53 PM.

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.01495 seconds
  • Memory Usage 1,752KB
  • 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
  • (3)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
  • (2)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