VbTeams/Clubs Hack

[miz]

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

[reteep]

Nice to see your hack back online. I'll check it out soon, thanks!

[capslock]

there is no install instructions :(

[miz]

fixed , forgot to add the txt files heh

[vorphalack]

Any limit on the number of "teams"? And is it easy to change the word "team" to something else or would that require a lot of edits?

I also see several misspelled words like private, management, because

I would also want change words to lower case such as (looking at privtearea_viewpoll screenshot): We and Accept

Other than these smaller issues, looks great! There's something I was thinking about adding usergroups for but I think this would work way better.

[capslock]

there is a mysql error during install

[miz]

there is a mysql error during install

what is the error cuse i check the install script about 10 times before posted..


Any limit on the number of "teams"? And is it easy to change the word "team" to something else or would that require a lot of edits?

I also see several misspelled words like private, management, because

I would also want change words to lower case such as (looking at privtearea_viewpoll screenshot): We and Accept

Other than these smaller issues, looks great! There's something I was thinking about adding usergroups for but I think this would work way better.

ok .
1. no limit - you can add as much teams as you want
2. to change word team will take lots of edits - allmost the entire hack
3. if you can pm the sppeking problems i will fix it asap and repost
4. to change what you want edit templates if you dont find it just tell

[Tradjick]

This is awesome! Although i can?t use it right now cause i don?t have enough members yet :(
Some questions:
Is it possible for team members to talk in private forums or do you plan on coding such a feature?
What if reputation isn?t enabled?

[miz]

This is awesome! Although i can?t use it right now cause i don?t have enough members yet :(
Some questions:
Is it possible for team members to talk in private forums or do you plan on coding such a feature?
What if reputation isn?t enabled?

1. you can use this hack even if you got only 1 member, its dosent metter
if you want this option its better to have it before you adding members
2. yes , im planing to do team privte forum but its not easy as its seems so i didnt wanted to add unfinish things that only add bugs
3.team reputation takes all users reputation (which in team) and count them
so its dosent metter if you enable/disable this option..


btw does any1 else have problems with install script ?

[capslock]

this is the error:
Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE `teams` (
`teamid` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`posts` tinyint(10) NOT NULL default '0',
`reputation` tinyint(10) NOT NULL default '0',
`avatarurl` varchar(100) NOT NULL default 'images/teamavatars/no-avatar.gif',
`words` text NOT NULL,
`adminmsg` text NOT NULL,
`ircserver` varchar(50) NOT NULL default '',
`ircport` int(4) NOT NULL default '6667',
`chan` varchar(50) NOT NULL default '',
`chanpass` varchar(50) NOT NULL default '',
`notes` text NOT NULL,
`email` varchar(100) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`teamid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 18

mysql error number: 1064

Date: Friday 03rd of December 2004 05:57:07 PM

[miz]

hmm first use php bbcode when you post things like that
secend i rechecked the file and its runned fine without any problems
does any1 else have this problem ?

[ericgtr]

hmm first use php bbcode when you post things like that
secend i rechecked the file and its runned fine without any problems
does any1 else have this problem ?
Looks really cool, what exactly would this be used for though, could you give an example?

[miz]

Looks really cool, what exactly would this be used for though, could you give an example?

hmm best exsample i can give is this site(vb.org) which diffrent teams posting around like Vbdev vb.org and more..

more exsample is Cs forum which users are arrange in teams and every user got team, or as intergration with rpg system where teams can make challange between them and more and more.
just nothing pop up to my head.

[Red Blaze]

This looks pretty cool, I'll try it out some time.

[Polo]

Cool, been looking for something like this ;)

[Silverdawn222]

It looks great - I'll try it out once this thread gets more feedback. Like most people, I like my hacks (almost) bugfree and without spelling errors. :) Great job!

[capslock]

please, remember the mysql problem. What may be?

[ericgtr]

Hmm.. I made all the file modifications but it really tweaked out my postbit_legacy, can you add instructions for it?

[MindTrix]

Any chance of some screenies for the admin control panel side?? Not admin of the team, admin of the whole board you know :)

Is this done by phrases aswell???

I run a hip hop website so would change 'team' to crew. Otherwise it looks pretty neat.

Does the teams avatar replace their current one of will it be placed somewhere else, im sure my members would not like it to replace their current avatar.

[ericgtr]

I had a lot of trouble with this myself, I guess it's still in beta though. I ended up having to undo everything. the show members who aren't in a team killed my server with lag as if it was trying to parse all 7800 users on one page.

[zzzxxzzz]

got blank page when click invite someone in my team

[miz]

Hmm.. I made all the file modifications but it really tweaked out my postbit_legacy, can you add instructions for it?

postbit_legacy ?? hmm try to change the conditions on postbit, i dont change postbit_legacy in any condition so i dont know what is your problem, screen shot can be nice explain

Any chance of some screenies for the admin control panel side?? Not admin of the team, admin of the whole board you know

Is this done by phrases aswell???

I run a hip hop website so would change 'team' to crew. Otherwise it looks pretty neat.

Does the teams avatar replace their current one of will it be placed somewhere else, im sure my members would not like it to replace their current avatar.


i guss you didnt read the options to the end, if user dont use avatar its show's team avatar, if he do then its show user avatar.
about the phrases , im sorry but i really hate this system so i dont use it
about the screen from admincp i will upload soon, i guss i forgot to add them to pics.
got blank page when click invite someone in my team
check if all templates are in place i cant find other thing that can cuse this issue

I had a lot of trouble with this myself, I guess it's still in beta though. I ended up having to undo everything. the show members who aren't in a team killed my server with lag as if it was trying to parse all 7800 users on one page.

offcurse its will lag and kill your server, you show in 1 time 7800 users with online status, its not ment to be for such big users without team
but you gave me idea, and i will do it like on memberlist page with order by latter
to bad you removed the hack only cuse of 1 option i reccomand that you will reinstall the hack and soon ill add this feature (with latters), the true's i didnt thought about such condition (7800 users without team) but its good you let me know, ill edit it asap..
please, remember the mysql problem. What may be?
the true's i dont know cuse you the only 1 that its happend to him, but just for checking try to run the query from phpmyadmin
if its still happen i guss its problem from your server...

[Kesomir]

Is it possible for board members to belong to more than one team? If not then might this be considered for a future version.

I think if it could be made easy to change the word "team" as well that would be useful. I notice a few other posters in this thread mentioning that and I would like to change it to either guild or clan so I see that as in important feature-to-be since it widens the possible use of this great sounding hack.

[miz]

Is it possible for board members to belong to more than one team? If not then might this be considered for a future version.

I think if it could be made easy to change the word "team" as well that would be useful. I notice a few other posters in this thread mentioning that and I would like to change it to either guild or clan so I see that as in important feature-to-be since it widens the possible use of this great sounding hack.

well to allow member to be more then 1 team is not on my mind beacuse i need to do some major changes on team admin part and more im not intead to do so
about change the team name, i will add the pharse so all of you will be able to change it

[Kesomir]

Shame about joining multiple teams, really restricts the usefulness of the hack. I understand time constraints though.

I've got it installed on my site now after a long trawl through all the code to fix the spelling mistakes. Still some left in there, but sort of lost the will for a bit ;)

major ones were

privte = private
memembers = members
wellcome = welcome

Not a dig, I know English may not be your first language, but it's a good idea to get these mistakes removed for a release candidate.

There is also a bug with the avatar upload. While it uploads the avatar and renames fine, it uses the suffix .gif in the db so non gif images won't display.

Plus I managed to get errors with the pm when denying a poll. Still sent the pm however.

Hope you find this information useful.

[ericgtr]

Miz, thanks for your reply. I will keep an eye on this thread an try again later :)

[miz]

Shame about joining multiple teams, really restricts the usefulness of the hack. I understand time constraints though.

I've got it installed on my site now after a long trawl through all the code to fix the spelling mistakes. Still some left in there, but sort of lost the will for a bit ;)

major ones were

privte = private
memembers = members
wellcome = welcome

Not a dig, I know English may not be your first language, but it's a good idea to get these mistakes removed for a release candidate.

There is also a bug with the avatar upload. While it uploads the avatar and renames fine, it uses the suffix .gif in the db so non gif images won't display.

Plus I managed to get errors with the pm when denying a poll. Still sent the pm however.

Hope you find this information useful.

when you deny a poll its sent a pm to a user which said its denined
thats what you ment ?
i will get the spell fix's as soon as possible

and the avatar problem, i never thought about it...

[SilentK]

I like this hack but I would prefer not to have to add teams myself. Is it possible for the user to create a team? If so how would I do this?

[Andrew]

I am getting a MySQL error when trying to view the No-Team List page. Everything else is working fine but for some reason this is giving me problems. Forum can be accessed at http://www.x-six.org/V.3/VB3/index.php if you need to see it.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS count FROM session WHERE userid='2' AND lastactivity>1102202980
mysql error: Table 'rvadmin_v2.session' doesn't exist

mysql error number: 1146

Date: Saturday 04th of December 2004 06:44:40 PM
Script: http://www.x-six.org/V.3/VB3/showteams.php?do=teamless
Referer: http://www.x-six.org/V.3/VB3/index.php?
Username: Steve
IP Address: 68.68.111.105

[Andrew]

Hmm.. I made all the file modifications but it really tweaked out my postbit_legacy, can you add instructions for it?
Instead of his modification of the avatar code - Use the following for postbit legacy and it works great (Example at : http://www.x-six.org/V.3/VB3/showthread.php?p=110#post110 ):

<if condition="$show['avatar']">
<a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$avatarurl" alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a>
<else />
<if condition="$teaminfo['teamid']!=1">
<a href="showteams.php?$session[sessionurl]do=teamprofile&teamid=$post[teamid]"><img src="$teaminfo[avatarurl]" alt="$teaminfo[name] Avatar" border="0" /></a></if>
</if>

[Zachariah]

I'll check it out.

[Hades-1]

i cant upload avatars, nothing happens, just takes me to admin index

and when i delete avatar i get sql error, column 'avatar' not fund in 'feild list'

[Hades-1]

Any chance of some screenies for the admin control panel side?? Not admin of the team, admin of the whole board you know :)

Is this done by phrases aswell???

I run a hip hop website so would change 'team' to crew. Otherwise it looks pretty neat.

Does the teams avatar replace their current one of will it be placed somewhere else, im sure my members would not like it to replace their current avatar.

nope not on phares, i run music site and made it say labels

well half of it, its hard to weed it all out.

[SilentK]

I had a problem with team avatars not coming up. The reason is that it always looks for .gifs for some reason. I uploaded a jpg and it was a jpg on the server but in the source code the team page was looking for the same file name just with a .gif

[Hades-1]

I had a problem with team avatars not coming up. The reason is that it always looks for .gifs for some reason. I uploaded a jpg and it was a jpg on the server but in the source code the team page was looking for the same file name just with a .gif

exact problem, i have to login phpmyadmin to fix.

[Hades-1]

honestly, shoud'nt this be a beta release?

how are we suppose to delete the private chat?

does that stay there forever?

How can fix the problem with images always looking for gif?

[Andrew]

The problem is in this following bit of code at the bottom of teamadmin.php - I don't know much PHP or I would try to fix it. It is automattically saving the path to the images in the DB with the gif extension regardless of the filetype. The upload function in function_team is saving them properly - All that needs done is a way to add the correct extension in this code here so it referrences it correctly in the DB.
if ($_POST['do'] == removeavatar) {

$teamid = $_POST['teamid'];
// Delete Avatar image from server
$teamoldava = "team".$teamid."_avatar.gif";
@unlink("images/teamavatars/$teamoldava");
$team_ava = "team_noavatar.gif";
$DB_site->query("
UPDATE " . TABLE_PREFIX . "teams
SET avatarurl='images/teamavatars/$team_ava', avatar='0'
WHERE teamid ='$teamid'
");
header("Location: teamadmin.php?&teamid=$teamid");


}

// upload avatar
If($_POST['do'] == doupload) {

$teamid = $_POST['teamid'];

doupload();

$team_ava = "team".$teamid."_avatar.gif";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "teams
SET avatarurl='images/teamavatars/$team_ava'
WHERE teamid ='$teamid'
");



header("Location: teamadmin.php?&teamid=$teamid");
}

[Hades-1]

yeah i am not good either it should be something like

$teamoldava = "team".$teamid."_avatar.$type";

[Andrew]

yeah i am not good either it should be something like

$teamoldava = "team".$teamid."_avatar.$type";
Yeah - But the problem I ran into is I have no clue how to code it to determine the type of the file. It's prolly something that would have to be stored in the DB and then queried for each team.

[miz]

sorry for late with answer i will rls v2.0.1 which will be bug fix of avatars problem, spelling and session problem
if you have few more problems please tell me...

[Andrew]

sorry for late with answer i will rls v2.0.1 which will be bug fix of avatars problem, spelling and session problem
if you have few more problems please tell me...
Cheers miz - I didn't expect a fix for it that quick. Great hack by the way !!

* Andrew clicks install again.

[Hades-1]

another problem is you cant view member.php as guest or you get a database error

this caused because guest has no team id

can you provide a fix?

[mtha]

last step:

in profile.php

FIND :

$DB_site->query("
UPDATE " . TABLE_PREFIX . "user SET

BEFORE ADD :

// team hack
if ($options['removeme'] = 1 ) {

$DB_site->query("
UPDATE " . TABLE_PREFIX . "user
SET teamid='0',teamadmin='0'
WHERE userid='$bbuserinfo[userid]'
");

}

however, there're alot of places has

$DB_site->query("
UPDATE " . TABLE_PREFIX . "user SET

where should I add the code?

[SilentK]

I don't think it matters. I just added it above the first one I found.

[kix]

i have a few odd things popup.

the first one was headers in the admincp/userteam.php - i had to remove some of the header statments... guess it never did the ?go=modify or what ever part.

I then get this error for misc things.
This time this error came from trying to delete a users from the team admin page.

Error
An Error Has Occured! [ Go Back ]
An error has occured, the following message has been left below:
--------------------------------------------------------------------------------

No team specified. If you followed a valid link, please notify the webmaster.

----
and when i try to apply for a team. i get a simular error:
Error
An Error Has Occured! [ Go Back ]
An error has occured, the following message has been left below:
--------------------------------------------------------------------------------

Your Request has ben submited.Please wait for pm from team.

also - when you try to vote on the poll to see if you want the user added to the team or not, it says: No Thread specified. If you followed a valid link, please notify the webmaster

and when you just go ahead and add him to the team, it gives a simular error like above again. I need help bad

[miz]

i have a few odd things popup.

the first one was headers in the admincp/userteam.php - i had to remove some of the header statments... guess it never did the ?go=modify or what ever part.

I then get this error for misc things.
This time this error came from trying to delete a users from the team admin page.

Error
An Error Has Occured! [ Go Back ]
An error has occured, the following message has been left below:
--------------------------------------------------------------------------------

No team specified. If you followed a valid link, please notify the webmaster.

----
and when i try to apply for a team. i get a simular error:
Error
An Error Has Occured! [ Go Back ]
An error has occured, the following message has been left below:
--------------------------------------------------------------------------------

Your Request has ben submited.Please wait for pm from team.


also - when you try to vote on the poll to see if you want the user added to the team or not, it says: No Thread specified. If you followed a valid link, please notify the webmaster

and when you just go ahead and add him to the team, it gives a simular error like above again. I need help bad

hmm first on admin cp i didnt got what was your problem.
2nd = the team admin error i will check
3rd- this problem happends when you dont edit poll.php currectly
if you edit it like its should be then no problem for you...
4th - did you read the error msg ? i used it as confirm msg i guss its makes things for some ppl harder, ill make a confirm msg.

[SilentK]

I am also having the problem when guests view the memberlist. Which is very annoying becuase I have email notification turned on and a few bots wandered into the members list needless to say my inbox was quite full. Is there a way we can lump the unregistered or no-teams into either another team id thats essentially a dud or into the no-team ID?

[miz]

guys please wait untill the end of week were i will rls new version which will be bug fix of what you guys said

if some1 can pm me all of bugs i will appricate it thanx

[SilentK]

Something I am noticing now is that all the team posts are listed as 127 which isn't right.

[Wordplay]

tried installing this, i don't get any error reports, so i guess it was a smooth installation. but... here's my problem, i don't have a navbar... my navbar would be my header that i created from scratch though, so the code is entirely differnt, therefore i left that part out of the template creation. now how do my users start/create a new team? i don't seem to be able to find any team options anywhere, if i go directly into:

teamprivtearea.php
or
teamadmin.php

all i get is:
An Error Has Occured! [ Go Back ]
An error has occured, the following message has been left below:
We Sorry, But you not Team Admin, Or you not logged in.
so help please. i would like to click the install button as soon as possible. cause the idea for the team hack is great!

[Wordplay]

sorry, thought i had another problem but that sovled itself.

furthermore though, how do i set up the team admin?

[miz]

sorry, thought i had another problem but that sovled itself.

furthermore though, how do i set up the team admin?

you edit the user you want to set as team admin

and then you have

User Team : teams-list
and below it

Team Admin : Yes/NO

click on yes
and save user

[Wordplay]

great thanks alot! everything seems to work just fine, except for those error messages, but that's no biggy. thanks alot for the great hack.

oh there is one problem... my private messages (but only the ones the team script sends to users to ask them to join or tell them whether or not they have been accepted) looks like this> i think it's because it tries to use postbit, but i use postbit_legacy for my forum>>>> :

[miz]

soon i will rls a bug fix version , this verion will include info about postbit legacy
btw your pic is from pm so no connect to postbit legacy you probebly edited somethng worng
check again your steps
yours
MiZ

[Kyoko]

i'm allso getting this error

Invalid SQL: CREATE TABLE `teams` (
`teamid` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`posts` tinyint(10) NOT NULL default '0',
`reputation` tinyint(10) NOT NULL default '0',
`avatarurl` varchar(100) NOT NULL default 'images/teamavatars/no-avatar.gif',
`words` text NOT NULL,
`adminmsg` text NOT NULL,
`ircserver` varchar(50) NOT NULL default '',
`ircport` int(4) NOT NULL default '6667',
`chan` varchar(50) NOT NULL default '',
`chanpass` varchar(50) NOT NULL default '',
`notes` text NOT NULL,
`email` varchar(100) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`teamid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 17

does anyone know a way to fix this ?

EDIT: well i got it installed by using phpmyadmin
but i get errors when i want to join a team and i can only make teams via admin cp (if thats normal or not, i'm not realy sure)

[Wordplay]

soon i will rls a bug fix version , this verion will include info about postbit legacy
btw your pic is from pm so no connect to postbit legacy you probebly edited somethng worng
check again your steps
yours
MiZ
seriously?

aha, so where exactly is the part where you add the script to send that pm?

[miz]

seriously?

aha, so where exactly is the part where you add the script to send that pm?


what you talking about ? usercp ?

[Wordplay]

when you invite somebody into your team. it sends out a pm to invite them. apperently that's the part i messed up, since that pm looks completely deformed, so where in the install scrip for this hack is the part where you set up sending that pm?

because that pm on my board appears this way:

https://vborg.vbsupport.ru/attachment.php?attachmentid=22229

and not like the normal pms people send/recieve on my boards.

[miz]

well just reupload the files cuse pm is on files ;]

[bishop93]

Seems that everything works -- except when you click on the "No-Team" (which seems kinda out of place, when I would think that it would just show nothing there rather than "No Team") I get the following error. Otherwise, this works great.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS count FROM session WHERE userid='1' AND lastactivity>1102881603
mysql error: Table 'xxx_xxx.session' doesn't exist

mysql error number: 1146

Date: Sunday 12th of December 2004 03:15:03 PM
Script: http://URL/showteams.php?do=teamless
Referer: http://URL/showthread.php?p=11738
Username: xxx
IP Address: xxx

[cschuck3]

I run a pocketbike racing fourm and want to have this haack installed for othere teams to have there own forums. Is can the teams admin there own fourm and non team memeber can post question and or read fourm? If so this I will install this hack...

[Tradjick]

I run a pocketbike racing fourm and want to have this haack installed for othere teams to have there own forums. Is can the teams admin there own fourm and non team memeber can post question and or read fourm? If so this I will install this hack...
Private Forums aren?t implemented yet. AFAIK miz may work on this at a later time. Not sure though.

[Shadow Blaze]

errrm.... i put it all in, and the images are all there, but in the admin section for a team's admin, the images for the links aren't working, they say the thing but there's an x where it's not seeming to be linking properly... where could i find the linking section to see what's wrong and fix it?

[SilentK]

I had a simlier problem I forget what exacltly I did but the path in the zip file was in correct. View the source or figure out where it's looking for them and move them to there.

my path is .forums/images/team/users.gif for example/ I think the T might of been capitalized or something to that extent and I had to make it lowercase.

[tamago]

You need to modify showteams.php.

Change:
$useronoff=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid='$userid' AND lastactivity>$datecut");
to
$useronoff=$DB_site->query_first("SELECT COUNT(*) AS count FROM ".TABLE_PREFIX."session WHERE userid='$userid' AND lastactivity>$datecut");

It was missing the TABLE_PREFIX.

Seems that everything works -- except when you click on the "No-Team" (which seems kinda out of place, when I would think that it would just show nothing there rather than "No Team") I get the following error. Otherwise, this works great.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS count FROM session WHERE userid='1' AND lastactivity>1102881603
mysql error: Table 'xxx_xxx.session' doesn't exist

mysql error number: 1146

Date: Sunday 12th of December 2004 03:15:03 PM
Script: http://URL/showteams.php?do=teamless
Referer: http://URL/showthread.php?p=11738
Username: xxx
IP Address: xxx

[geoskep]

I installed it; but don't know how to set up a team admin . There are no instructions.

I can't use teamadmin.php; because I'm not a team admin. Where do I set up the team admin?

[anubis]

the 'showteams.php?do=teamless'
Read time very long .......
My forum users have Exceed 12,000 above,
Execute once'showteams .php? do=teamless'
Browse utensil can stop response......

[miz]

geoskep - via user edit you have team admin : yes/no
check yes and user is team admin...

anubis - in next version it will be fixed...

[anubis]

geoskep - via user edit you have team admin : yes/no
check yes and user is team admin...

anubis - in next version it will be fixed...
Thank your response, but I want to quaere......

Next version when release ?

[geoskep]

Thanks for response. That was easy. Good mod. Needs a few things to be great - my wish list:
1) instructions.
2) phrases implemented to allow custom phrases - this can also eliminate some spelling mistakes.
3) allow any user to start a new team and set themselves up as the team admin.
4) enable private teams to be subscription based or free.
5) allow any member to be member of multiple teams.
6) minor bug fixes

[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]

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

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

Replace with
$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:

$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="cursor:pointer" onclick="window.open('member.php?$session[sessionurl]u=$thread[postuserid]')">$thread[postusername]</span>

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

<span style="cursor:pointer" 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]

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

do the following

Find in member.php

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

Replace with
$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]

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

Rgds :-)
the first one uses:
$bbuserinfo[teamid]
and the second one uses:
$userinfo[teamid]

[sv1cec]

the first one uses:
$bbuserinfo[teamid]
and the second one uses:
$userinfo[teamid]
Blind me, I am sorry! I knew it was too late to check these things out.

[miz]

new version will be realsed soon with all of the fix's....

[sv1cec]

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

do the following

Find in member.php

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

Replace with
$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.


Could you please release those changes? I want to apply this hack to my site, but I do not have the time to optimize it.

Thank you.

[sv1cec]

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

do the following

Find in member.php

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

Replace with
$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.

Although, it is again one of those times that my mind does not function pretty well, I do not think that this fix is the proper one. bbteam is the team to which a team admin is inviting the user, not the team to which the user belongs.

A more appropriate fix would be the following in member.php:

Find:


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


Replace that with:


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


With this mod, if the user of the program is a team admin, he can invite the member whose profile he is viewing, to his team.

My 2 Eurocents only.

[sv1cec]

Has anyone tested the chat function? In my system, it works OK with Firefox Mozilla, but not with Internet Explorer (version 5). It does not refresh properly.

Also, I have found several small bugs. For example, when a user asks to be removed from a team, he is not set to teamid='1' but to no team id. This creates problems.

Features I would like to see implemented:

- a report with the status of the join requests.
- Some sort of control panel, where the admin can define if he wants a team avatar, or an admin message (the scrolling thing), or the team reputation (I haven't managed to understand how it goes up and why) etc.

I am anxiously waiting for the new version, as it is at the moment, I am not sure I want to install it on my live system.

[miz]

Has anyone tested the chat function? In my system, it works OK with Firefox Mozilla, but not with Internet Explorer (version 5). It does not refresh properly.

Also, I have found several small bugs. For example, when a user asks to be removed from a team, he is not set to teamid='1' but to no team id. This creates problems.

Features I would like to see implemented:

- a report with the status of the join requests.
- Some sort of control panel, where the admin can define if he wants a team avatar, or an admin message (the scrolling thing), or the team reputation (I haven't managed to understand how it goes up and why) etc.

I am anxiously waiting for the new version, as it is at the moment, I am not sure I want to install it on my live system.
first thank you for reporting bugs
2nd - i as coder of the hack not recommand you to install the hack if you have installed it yet, this days im working on next version of the hack which will include new featurs (like team privte forum) and bug fix's
also i might replace the privte chat with something else with less bugs
a report is good idea i can tell you that ill add it
about the last thing - i didnt exscaly got what you wanted to say but you can edit any team options via team admin area..

yours MiZ.

[sv1cec]

first thank you for reporting bugs
2nd - i as coder of the hack not recommand you to install the hack if you have installed it yet, this days im working on next version of the hack which will include new featurs (like team privte forum) and bug fix's
also i might replace the privte chat with something else with less bugs
a report is good idea i can tell you that ill add it
about the last thing - i didnt exscaly got what you wanted to say but you can edit any team options via team admin area..

yours MiZ.
Miz,

First of all, very nice hack, I really like it. Although my needs are for a far less sophisticated system (all I want is a "club" list of selected few from my members), this is just great.

As for the bugs, they are not many, but they exist. Let me point out one more, in your instructions, you say somewhere to add something above a certain line. That line exists in several places in that file. The user who tries to install the hack, does not know where to place it. Of course, users with coding experience will figure it out, but those without the knowledge will be hard pressed to find the answer.

You do not have to thank me for reporting bugs, it's the least I can do, to help you out, I know, I have a hack of my own here, and I know how important user's input is. Unfortunatelly, I haven't kept a log of all the small changes and edits I made, although I reported one here.

As for the chat feature, I do like it. I can't understand why it does not work with Internet Explorer, it works like a charm with Firefox Mozilla, maybe it has something to do with IE's security settings, I do not know, but I wouldn't like to see it go, it's a nice feature.

Finally, let me explain the last point of my previous post. What I would like to see, is a page, where the administrator can select which features of the hack he would like to use. For example:

Do you want to use the chat feature : Yes/No
Do you want to use a scrolling admin message : Yes/No
Do you want to use the reputation feature : Yes/No
Do you want to use a Team's avatar : Yes/No
Who can see the links to the Teams : All/Mgm+User

These options can be saved in a separate table, and according to these, the hack can show the appropriate sections. Check out the following picture, it comes from my Advanced Warning System and it is exactly that, a page where the user selects which features he would like to use.

https://vborg.vbsupport.ru/attachment.php?attachmentid=21859

The report would be a nice addition, especially for users who plan to use the "Invite" feature. Also, a list of the pending applications (users who have asked to join a team) would be nice too.

Well, I told you, I am anxiously waiting for the new release. At the time, I am playing with the hack in a test system. If I come up with some other bugs, I'll let you know.

Rgds
---------

John

[kevinnguyen]

do we need to uninstall this version in order to install the new version?

[kevinnguyen]

and when u gonna release the new version?
Thanks

[miz]

sv1cec - thank you for feed back i will surly consider your sujestions
kevinnguyen - you wont be able to remove old hack cuse i will provide and update script
and the next version will rls when i will finish to code and to test it.

[KAC]

I keep getting this error during install?
It installs the templates but when it goes to database this is what I get? Also my usercp does not work anymore. Any suggestions? I am using ver 3.0.6. thanxs in advance for any help.

There seems to have been a slight problem with the Forums 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.

[Marco van Herwaarden]

You will need to provide the detailed sql-error in order to get ann answer to this. You can get this by one of the following:
- Check the mail dispatched to your tech mail address if configured.
- View the source of that error page in your browser, you willl see some more lines with the detailed error

[sv1cec]

Any news on that new release?

Rgds

[Dark Aura]

Ermm.. i keep getting broken image's..

But the images are in the right place..

Any idea why?

[miz]

Any news on that new release?

Rgds
hmm yes

i finished lots of work on privte forum
here is a pic of new privte area , offcurse its not finished and it will be changed more
still got some problems im working on but i hope to slove them soon as im working on next version on all of my free time (which isnt much)

[Tradjick]

Nice to see you´re progressing well. Keep up the good work!

Greets.

[KAC]

I changed my php files back to normal and the error went away. HMMMM maybe I will just wait on the next version.

[miz]

I changed my php files back to normal and the error went away. HMMMM maybe I will just wait on the next version.
first if you check the hack is for version 3.0.3 - i tested the hack on this version when i relesed it about your version
the installer use only functions from admin cp and not change anything so i can think of anything that can ++++ up your admin cp
try to upload the orginal files of vbulletin and see if the problem still exsit..
hope your problem will be sloved.

[KAC]

Well I uploaded the original php files and the DB error went away. So it has to be in one of the php files. I did however do some editing to the original hack files to make it work for my application. I do have one question if you dont mind answering. If I wanted to change the name from "Team" to "Club", would I just edit all the instances of "team" in all the files to "club" or am I going about it the wrong way? Thanxs for your response and help. It is greatly appreciated.

[miz]

Well I uploaded the original php files and the DB error went away. So it has to be in one of the php files. I did however do some editing to the original hack files to make it work for my application. I do have one question if you dont mind answering. If I wanted to change the name from "Team" to "Club", would I just edit all the instances of "team" in all the files to "club" or am I going about it the wrong way? Thanxs for your response and help. It is greatly appreciated.
Well, the hack not using atm at the phrase system so to change it from team to club the answer is yes you need to edit all php files
maybe if ill have time i will add pharse to my hack ,im not very framiler with that system and i dont like it much but ill try to do my best to work it out.

[KAC]

I dont mind going through all the files and changing the word "Team" to "Club" if this version will work with the new 3.0.6. I did change the words and when I went to install I got a db error. I just dont want that to happen again.

[Slave]

If you could have an option in the admin area where you could choose what to call the group .. be that clan, club, team, tribe etc etc .. it would be the best way forward I think .. everyone would be happy then ..

:)

[miz]

I dont mind going through all the files and changing the word "Team" to "Club" if this version will work with the new 3.0.6. I did change the words and when I went to install I got a db error. I just dont want that to happen again.
omg heh, did you changed the name 'team' to club before you installed the hack ?
if yes then this is why all of the things ++++ed up.

im coding the new version of the hack to 3.0.6 so no warry about that

If you could have an option in the admin area where you could choose what to call the group .. be that clan, club, team, tribe etc etc .. it would be the best way forward I think .. everyone would be happy then ..

:)
for that i need to user the pharse system to edit lots of things
i hope to do it in feautre versions

yours MiZ.

[KAC]

So you are saying install it first then change the wording in the php files?

[miz]

So you are saying install it first then change the wording in the php files?
yes
install it and then edit templates

btw dont edit form actions and ++++ like that cuse hack wont work properly.

[MD_Hacker]

When i log into AdminCP.Everything works fine,BUT THEN when i select a user and try to view his/her account it says.

Fatal error: Call to undefined function: print_guildchooser_row() in /home/mystical/public_html/unholy/forums/admincp/user.php on line 375

[miz]

When i log into AdminCP.Everything works fine,BUT THEN when i select a user and try to view his/her account it says.

Fatal error: Call to undefined function: print_guildchooser_row() in /home/mystical/public_html/unholy/forums/admincp/user.php on line 375
what is the version of vbulletin you intsalled the hack on ?

[KAC]

ok man. I done as you said and installed the hack the way it was listed. I am still getting a DB error. It must be something with 3.0.6. I will wait on the new update just thought I would let you know.

[anubis]

What be version on earth currently?
I look this attachment and have not what change,
Have already known Bugs still exist,
showteams. php? Do= teamless still do not improve,
Do not publish 2.5 or newest version still do?

[miz]

ok man. I done as you said and installed the hack the way itwas listed. I am still getting a DB error. It must be something with3.0.6. I will wait on the new update just thought I would let youknow.

What be version on earth currently?
I look this attachment and have not what change,
Have already known Bugs still exist,
showteams. php? Do= teamless still do not improve,
Do not publish 2.5 or newest version still do?

ok let me explain something

VBteams2.zip => means Version 2.0

what ill add VBteams2.0.2.zip
this will be the need version

thats why i worte SOON, when i will post trust me you will know
also on instructions As i made major edits on the hack
and hack is much better now

and note Version 2.0.0 is for vb 3.0.3
version 2.0.2 is for Vb3.0.6
so if you make a new install on vb3.0.6 wait few days for the next version
which is more complite with vb3.0.6

thanx. MiZ

[anubis]

ok let me explain something

VBteams2.zip => means Version 2.0

what ill add VBteams2.0.2.zip
this will be the need version

thats why i worte SOON, when i will post trust me you will know
also on instructions As i made major edits on the hack
and hack is much better now

and note Version 2.0.0 is for vb 3.0.3
version 2.0.2 is for Vb3.0.6
so if you make a new install on vb3.0.6 wait few days for the next version
which is more complite with vb3.0.6

thanx. MiZ
good, I unfasten,
Very thank your interpretation......^^

[tpr]

im kinda looking forward for the next release since this will solve A LOT of coding problems in my current site.
please hurry :D

p.s.
Good Work

[miz]

As you can see im adding new bug fixs to bug Fixed list
and also new features to first page.

[TunerNetwork]

I love this hack, Just need to get it fixed. I removed the Teamlest box for now so people wont click on it and lag out the server. TunerNetwork.com, I am using the hack for our Car Club database/organizer. We are planning to have clubs in different states across the country so this should keep it organized for the site purposes very well.

[MD_Hacker]

k nevermind got that part working forgot to edit a template.Also everything works great besides the fact that the PM to Join is never sent.

::Edit::
My Version is 3.0.6

[TunerNetwork]

MD Hacker, did you get this to work properly.

Got a ? everyone, when you go to your forums, and it says :

Zazza CEO @ No-Team <---It'll say the site members name and that "@ No-Team" and if you click on it, it'll bring you to the people that havent joined a team. How do I get rid of this, I dont want it to say this for every member, and I would basically want to do away with the list of who's not on a team. Please respond or pm me, thanks!

[tpr]

miz, any guess on when the next version will be done ?
hate to update my site with the current version only to redo it again in a week (or less :D *hint hint*)

[miz]

miz, any guess on when the next version will be done ?
hate to update my site with the current version only to redo it again in a week (or less :D *hint hint*)

next version is allready done
now only testing it for unnoticed bugs and i will release it

[KAC]

Great, that will give me something to work on. thanxs for all your efforts Miz

[miz]

vbteams2.0.2 Posted :D

[gnawph]

Should I be the first to install? Looks like it. ;)

Wish me luck!

[Eagle Creek]

Can you give permissions based on team-membership? So when you are a member of team A c you can have access granted or denied to other sections than normal users?

Can you send your whole team mail and stuff like that?

[kevinnguyen]

so how is it gnawph?
any demo?

[miz]

Send maill to all of team members in currectly not a featue
but it will be

in order to be part of team user must be registed
thats
no need to be a usergroup based cuse its teams besed premissions

[Amavisca]

I cant find this in the installation.
root/newreply.php
==================

FIND :
if (($tview = fetch_bbarray_cookie('thread_lastview', $threadinfo['threadid'])) != $threadinfo['lastpost'])
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]&amp;posted=1#post$newpost[postid]";
}
else
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]#post$newpost[postid]";
}

REPLACE WITH :

if (($tview = fetch_bbarray_cookie('thread_lastview', $threadinfo['threadid'])) != $threadinfo['lastpost'])
{
if ($foruminfo['teamid'] == $bbteaminfo['teamid'])
{
$url = "teamprivtearea.php?$session[sessionurl]teamid=$bbteaminfo[teamid]&amp;do=showthread&amp;p=$newpost[postid]&amp;posted=1#post$newpost[postid]";
} else {
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]&amp;posted=1#post$newpost[postid]";
}
}
else
{
if ($foruminfo['teamid'] == $bbteaminfo['teamid'])
{
$url = "teamprivtearea.php?$session[sessionurl]teamid=$bbteaminfo[teamid]&amp;do=showthread&amp;p=$newpost[postid]#post$newpost[postid]";
} else {
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]#post$newpost[postid]";
}
}

[miz]

supuse to be around line 245

[Amavisca]

supuse to be around line 245

Hi miz!
I just finish installed your hack, Everything is working fine so far however I have 1 small problem. When some member apply to join the team, the team leader did click acept it but the member who join still not show up as a member of the team (or when team leader invite some member, the member never got a pm ).

I am not sure what did I do wrong. Mayb you can help me out ? ( I will pm my board and a test account so you can know what I mean)

[TunerNetwork]

anyone able to get this hack to work properly, if so, please msg me , i need some help with it.

[WotC_Mel]

Is the "team words" in the screen shot mean to hold News for the team put their by the team leader?

-Melanie

[MD_Hacker]

Hi miz!
I just finish installed your hack, Everything is working fine so far however I have 1 small problem. When some member apply to join the team, the team leader did click acept it but the member who join still not show up as a member of the team (or when team leader invite some member, the member never got a pm ).

I am not sure what did I do wrong. Mayb you can help me out ? ( I will pm my board and a test account so you can know what I mean)

If its based upon the first version , when the Leader of the club accepts you , your added to the poll system.Which gives you 2 options.1) Let members Vote on them or 2) click on that admin tab that says add(In Poll sys).

[Amavisca]

I now can accept member to the team roster however I have another problem which is when I post on the team private forum, after posting it takes me to a page said that I dont have permision.

However click back to the team private forum, I can see my post there. It is very werid....

Do you know how can I fix that??

[evenmonkeys]

I've only edited the files themselves. I've done it twice and got the same error each time.


Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT teams.*, teams.name AS username,

COUNT(user.userid) AS totalmembers,
sum(user.posts) AS posts,
sum(user.reputation) AS reputation
FROM teams AS teams
LEFT JOIN user ON(teams.teamid = user.teamid)
WHERE teams.teamid =0
GROUP BY teams.teamid


mysql error: Table 'admxinny_forums.teams' doesn't exist

mysql error number: 1146

Date: Thursday 10th of February 2005 11:35:09 PM
Script: http://forums.xinnyburt.com/
Referer:
Username: yarub
IP Address: xx.xxx.xxx.xxx

[TunerNetwork]

i get the same thing, i need help with this hack, i need it for my site: http://www.tunernetwork.com

gonna use it to organize my car clubs across the country

[Marco van Herwaarden]

Are you guys by any chance using a table prefix for your database?

[evenmonkeys]

I figured it out. Tuner, do this... Upload the files that came with the zip. Then edit all your files, but don't upload them just yet. Instead, close your forums and edit your templates first. After that, run the install script from your admincp. Once you've got it installed on your forums, upload the files. I did it that way and it works perfectly.

[miz]

Are you guys by any chance using a table prefix for your database?

this hack is fully using ".TABLE_PREFIX."
in all query's so there shouldnt be any problems with that issue
i have tested this version of the hack on my live comunity and its works more then perfect

first run the install script
then edit files
then edit templates


not that hard.

[Amavisca]

How do I cancel the permission fuction? I would like everybody to be able to access teams forums exept the ones with passwords

[TunerNetwork]

ok, i guess my error is that i did all the edits first, then i went to run the install, this the problem? if so, how do i fix? go back and reinstall all the edited files with the originals? then run upload, and reinstall the edited ones? masdlfkjasljd;fksfd

[H2k]

in this code .. i find 2 time so should i change both of them ?

root/threadrate.php
====================
FIND :[2 time the same code]

$url = "showthread.php?$session[sessionurl]t=$threadid&amp;page=$pagenumber&amp;pp=$perpage";
eval(print_standard_redirect('redirect_threadrate_ update'));

REPLACE WITH :

if ($foruminfo['teamid'] == $bbteaminfo['teamid'])
{
$url = "teamprivtearea.php?$session[sessionurl]teamid=$bbteaminfo[teamid]&amp;do=showthread&amp;t=$threadid&amp;page=$pagenumber&amp;pp=$pe rpage";
} else {
$url = "showthread.php?$session[sessionurl]t=$threadid&amp;page=$pagenumber&amp;pp=$perpage";
}
eval(print_standard_redirect('redirect_threadrate_ update'));

FIND :[2 time the same code]

$url = "showthread.php?$session[sessionurl]t=$threadid&amp;page=$pagenumber&amp;pp=$perpage";
eval(print_standard_redirect('redirect_threadrate_ add'));

REPLACE WITH :

if ($foruminfo['teamid'] == $bbteaminfo['teamid'])
{
$url = "teamprivtearea.php?$session[sessionurl]teamid=$bbteaminfo[teamid]&amp;do=showthread&amp;t=$threadid&amp;page=$pagenumber&amp;pp=$pe rpage";
} else {
$url = "showthread.php?$session[sessionurl]t=$threadid&amp;page=$pagenumber&amp;pp=$perpage";
}
eval(print_standard_redirect('redirect_threadrate_ add'));

[H2k]

also when i try to install i get this erro
Error. teams.xml located in directory 'admincp' was not found. Please make sure it is uploaded then press the submit button below

[H2k]

also when i try to install i get this erro
Error. teams.xml located in directory 'admincp' was not found. Please make sure it is uploaded then press the submit button below
I have Installing this hack .. and i get alot of problems. and know i'am trying to delete it from my board.. but idont have a back up of my file so i have to do it bymy self.

There is 100 bug in this MOd
If We Delete the Private Forums it will still show . and there is many i just dont no how to add my self in the team to accept poeple .. this mod is really conf..

[TunerNetwork]

H2k, im getting that same error. If you find someone that can help us out, let me know. I have my files backed up before I edited them with this, so if you need some original code,let me know.

If anyone can help install this mode properly, please let us know.

[TunerNetwork]

Can someone please help up with this, sounds like its a common error/or mistake being made. PM Me if you can help me out getting the private forums working etc. thanks!

[Sephiroth690]

Hey guys, i had the same error. My problem is that my hosting company, and assume all hosting companies have files case sensative. The teams.xml file is callled teams.XML when i uploaded. just change the extension to lowercase and it should work fine.

As for my problem, I'm the admin of my board but everytime after either moveing a thread to a private team forum, or posting a thread or anything like that, I get that no permission error.

And just for reference, if anyone has had an issue with SQL databases about tbales/stuff not found, it's because not all of the hack has the TABLE PREFIX infront of the table variables. It takes awhile, but I think the hack good. Nice work!

[TunerNetwork]

ok bud, thanks, that worked! now...I get this....

Database error in vBulletin 3.0.6:

Invalid SQL:
ALTER TABLE `user` ADD `teamid` INT( 10 ) DEFAULT '1' NOT NULL ,
ADD `teamadmin` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_font_face` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_font_color` VARCHAR( 255 ) NOT NULL ,
ADD `team_chat_pref_user_ignore` TEXT NOT NULL ,
ADD `team_chat_pref_status` VARCHAR( 10 ) NOT NULL ,
ADD `team_chat_pref_auto_on` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `team_chat_pref_auto_msg` VARCHAR( 255 ) NOT NULL ;

mysql error: Duplicate column name 'teamid'

mysql error number: 1060

So...then I try to add a new team and I get this:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT *
FROM forum
WHERE `teamid` !=0

mysql error: Unknown column 'teamid' in 'where clause'

mysql error number: 1054

If someone can please just help me get this damn hack working,lol. Ive tried alot to get it going and need it for my site. So please pm me if you can help, thanks!

[Sephiroth690]

hmmm, i never got that error, in the number of errors i did get. You might just have had the teamid table created....masybe. To get this hack working, your going to have to spend ALOT of time debugging bugs lol. most are a result from like i said, the vbulletin table prefix not in front of the various sql queries. At least for me that was the problem.

[TunerNetwork]

ok, now when i go to click on my USER CP link, I get this error...Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT * FROM teamjoin
WHERE userid='2' AND status='2'

mysql error: Table 'hondanet_vbulletin.teamjoin' doesn't exist

mysql error number: 1146

grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

[Sephiroth690]

like i said, you've gotta go through the entire code almost and find all the db queries and change the code so that the syntax specific to your db tables is correct. When I got all said and done, i had 65 of those vb emails about database errors. I suggest doing that code searching when your forum is offline. Best place to start is all the edits you did in the includes folder.

[TunerNetwork]

Seph, I pm'd you, please read and get back to me if you can.

[Sephiroth690]

For all those here, below are a couple of small things that need to be done to fix some errors.

1. change teams.XML to teams.xml
2. change the images/Team folder to images/team
3. delete the Thumbs.db file from the teamavatars folder

Those are just a couple of things I've noticed.

[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]

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/showthread.php?p=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.

[christirichards]

TunerNetwork are you getting a blank page after you submit the form?

Also, MiZ it might be a good idea to include the old version so that people who have tried to use this hack before can go back and remove it to install the new version.

[Sephiroth690]

christirichards, i would love it if i can get a copy of what you've re-written. I was actually gonna re-code the entire thing myself, but I havn't found the time. If so, i'd be much appreciated.

[TunerNetwork]

Seph, if u can, get me on Messenger again, TN ZAZZA CEO. I got a few issues and wanna see if you have a fix for em,ill be home later tonight. thanks!

[Polo]

I have reported this modification as it contains most of the vBChat program core code nested within this modification, which was used without permission.

- Zero Tolerance

oh oh that's not good :ermm:

[Colin F]

The Staff is reviewing it, so let's stay on topic in the thread.

Thanks :)

[miz]

i did asked for premission and you agreed , to bad you cant remember cuse i still got your answer in my pm flooder...

[Curll]

I'm getting a lot of "Permission Denied" pages when I try to access private team forums.

Also, where the hell are those team forums? I don't see them on the Forums & Mods section of the ACP. It's a minor annoyance, since I had to figure out what forum number it was to edit an unrelated file. But, ANYWAY.

Excellent mod, just needs a good deal of polish. And maybe an English speaking coder to help out.

[miz]

well you, the forumid is auto selected by your team, you dont need forumid of the forum as you cannot axx it from anyother page (all of premission denied you getting)
you can find your team forum via team privte area
you wont find it on acp cuse the hack hides the forums on acp

about the english, well im sorry for my bad english
but every 1 around know only how to complain and to says i fixed the code
so if all of them "fixed" the code how is that i never saw a fix's ? maybe 1 word add as it is minor bugs
also no1 wants to help and point me to spell problems so i cant fix what i dont know its worng.

any way i saw the comments around and i decied not to post the new versions of the hack around here, as ppl feels some1 own them something when he puts he's on free time to post FREE code modifcation

i puted lots of work and lots of thinking on this hack, the true's im sorry that i posted it around here, but i wont remove it
ill keep develop it for myself and few other guys around that i can trust on them

to bad its had to get to this point.

[Curll]

Miz, it's just frustrating. It's a great hack, but the bugs, little hitches, and somewhat awkward coding decisions have people clamoring for a smoother ride. It's not that people don't respect you or your work, they just would rather have the hack install nicely and cleanly and have as little extra work as possible. A lot of members, including myself, aren't overly skilled in PHP. So when something is wrong with the hack, we can't just go to the code and fix it. Take it as a compliment, people WANT this hack. But, if it's not working right for them, they get annoyed.

Think of it as food. You get your nice steak at the restaurant, but they give you a spoon to eat it with. Most people are going to complain about the spoon.

Just ask someone for some help around here with some of the translations and bug fixes. I'm sure a lot of coders would love to help with this. And as far as the English, I can help out a bit there. So can most of the English speaking folks on the board. Just need to compile the rough-around-the-edges English and make a universal fix for it. And we'll help you translate the instructions.

[TunerNetwork]

Ok, well, does anyone want to work with me on correcting this hack. It is a great hack, and I can see both sides of the hardships. I know I want/need this hack. And as Curll mentioned, some of us aren't the best coders...thus, we have this board to rely on for great hacks, hoping they are correct, etc.

But Im willing to work with whomever in getting this hack to work correctly, and to maybe even add some additional features. If anyone is down, please pm me. Let's make this hack work correctly, and bug free. We have enough resources here, so let's use them!

[cat_san]

figured it out --- shoulda ran the install script BEFORE making all those code modifications.... (good thing i kept backups of the originals, huh?)

[Marco van Herwaarden]

Well there is no select query in the install script (teams2.0.2_install.php), so i doubt you are getting this error during the install script.

This error look like the install script was never run.

[TunerNetwork]

well, im having problems where i have people as a member of certain teams and they cant access the private forums for that team etc.

[Scerina]

HELP ME!!!...

After the file modifications and as I attempted to enter my forum's main index page to edit the templates, I came upon this error message:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT teams.*, teams.name AS username,

COUNT(user.userid) AS totalmembers,
sum(user.posts) AS posts,
sum(user.reputation) AS reputation
FROM vb3teams AS teams
LEFT JOIN vb3user ON(teams.teamid = user.teamid)
WHERE teams.teamid =1
GROUP BY teams.teamid


mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Friday 11th of March 2005 12:37:55 AM


Can someone please help me here???

[Marco van Herwaarden]

Sounds to me like you are using table prefix, and the hack didn't support that.

Try to find the file where you made the edit to this sql when installing this hack. You will probably see something like:
LEFT JOIN " . TABLE_PREFIX . "user ON.......chnage it to:LEFT JOIN " . TABLE_PREFIX . "user AS user ON.......

[Scerina]

I didn't do any mysql edits just main file edits...u know how to install this script? If so, can you look over my modified files and see what went wrong and if you see any thing messed up can you fix it? I mean can you help me out????

[Scerina]

screw this hack! Is full of bugs and as I read this entire thread...I realize just like the rest of you...it was poorly coded and the creator is no where to be found to help us out when we need help...I hope someone else (who is more experinced in coding) pick this hack up and rewrite it and test it out...and may that coder be successful in it and we have another cool hack to add to our forums...as for the creator of this hack...you need to practice or learn more bout coding cuz this hack has great potentials but ya codin sux as there are so many bugs in it...is not even funny and it is freakin frustratin to try and sort it out...esp when ur not a techie like u!

PLEASE SOMEONE ELSE WITH MORE CODIN EXPERINCE REWRITE THIS HACK & I HOPE YOU HAVE BETTER LUCK WITH IT THAN IT'S ORIGINAL CREATOR!

And I do not mean to sound ungrateful here but seriously...too much bugs and is freakin frustratin to try and fix it and when u do fix something... more bugs pop up! It got great potential but the codin SUX big ass time

[miz]

screw this hack! Is full of bugs and as I read thisentire thread...I realize just like the rest of you...it was poorlycoded and the creator is no where to be found to help us out when weneed help...I hope someone else (who is more experinced in coding) pickthis hack up and rewrite it and test it out...and may that coder besuccessful in it and we have another cool hack to add to ourforums...as for the creator of this hack...you need to practice orlearn more bout coding cuz this hack has great potentials but ya codinsux as there are so many bugs in it...is not even funny and it isfreakin frustratin to try and sort it out...esp when ur not a techielike u!

PLEASE SOMEONE ELSE WITH MORE CODIN EXPERINCE REWRITE THIS HACK & IHOPE YOU HAVE BETTER LUCK WITH IT THAN IT'S ORIGINAL CREATOR!

And I do not mean to sound ungrateful here but seriously...too muchbugs and is freakin frustratin to try and fix it and when u do fixsomething... more bugs pop up! It got great potential but the codin SUXbig ass time

peeps like is the exscat reason i dont post the fix's and updates.
i had bugs on the table prefix cuse i simply dont use it

you say my coding sux so you have 2 options right now
or code for yourself, or simply dont use my code
if you want to use it take it as it is

thats all. if you want to see my real coding you can take a look on my site
there all of my hacks working 100 % perfectly.

sorry but im not going to support any qustions from you any more
thanx for the response have a good day and good bye.

[Polo]

you need to practice or learn more bout coding cuz this hack has great potentials but ya codin sux as there are so many bugs in it

Scerina no one is forcing you to use this mod, if you dont like it learn php and code it yourself. Here is a good link to start Learn PHP (http://www.php.net)

Also remember that Miz is generous enough to share his mod with the community.. he has no obligation at all to be here or share his coded mods... he does it because he feels like it... if you dont like how he codes, as I said, learn php or pay some coder to create the pefect hack for you.

Have a great day.

P.S. Next time try to be nice and dont let frustration get to you.

[TunerNetwork]

ok, back on track now the hatred has been let out,lol

Anyone want to work on getting this to work correctly for us?

[croft]

supuse to be around line 245

man i cant find this code ANYWHERE at all in newreply. ?????

if (($tview = fetch_bbarray_cookie('thread_lastview', $threadinfo['threadid'])) != $threadinfo['lastpost'])
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]&amp;posted=1#post$newpost[postid]";
}
else
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]#post$newpost[postid]";
}

[Sleepyk]

humn this could be good, i run a hip-hop battle forum, and people got their own crews there, this might work nicely

[Zachariah]

vbteams 2.0.2 / VB3.07

I know I can mess up on copy and paste @ 3am :D, but I rechecked the install a few times.

I do not get:

$teamlink .= "<tr class='alt1' align='center'> <td> <a href='showteams.php?do=teamprofile&teamid=$teamid'> $teamname</a> </td>
<td class='alt1' align='center' width='50%'><a href='usercp.php?teamdo=accept&teamid=$teamid'>[Accept]</a>&nbsp;<a href='usercp.php?teamdo=deny&teamid=$teamid'>[Deny]</a></td>
</tr>";

To show up in the UserCP at all on a user I invite to a team.
Did I miss something? Where in the userCP is the accept / deny ?

Is there a USERCP_SHELL template edit i missed ? (i did not see one in the "template_changes.txt"

REQ: The team admin needs the option to add a user to the team w/o invite. (2 choices for the admin: invite userID / add userID) Once added a PM sent to the new team mate telling them links, needed info.

[Zachariah]

Navbar:
Forums > Teams > Test Profile > Test Privte Area > Test Privte Forum
- stuff

I am in the thread "stuff".
teamprivtearea.php?do=showthread&teamid=3&t=3

In the navbar "Test Privte Forum" links to "forumdisplay.php?f=4" ; it should link to "teamprivtearea.php?do=forumdisplay&teamid=3"


REQ:
**$root/Search.php: for the private team forum to users with team access only. (currently: anyone can search and find thread titles but not view the content)

** add search dropdown to do "quick searches" in the team forum.
teamprivtearea.php?do=forumdisplay&teamid=x

[Xtrato]

HELP ME!!!...

After the file modifications and as I attempted to enter my forum's main index page to edit the templates, I came upon this error message:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT teams.*, teams.name AS username,

COUNT(user.userid) AS totalmembers,
sum(user.posts) AS posts,
sum(user.reputation) AS reputation
FROM vb3teams AS teams
LEFT JOIN vb3user ON(teams.teamid = user.teamid)
WHERE teams.teamid =1
GROUP BY teams.teamid


mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Friday 11th of March 2005 12:37:55 AM


Can someone please help me here???


L'o guys, im having the same error i have a prefix such as dbvb_vbusers

I dont know if thats a huge problem. but I would like some help here.

[croft]

man i cant find this code ANYWHERE at all in newreply. ?????

if (($tview = fetch_bbarray_cookie('thread_lastview', $threadinfo['threadid'])) != $threadinfo['lastpost'])
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]&amp;posted=1#post$newpost[postid]";
}
else
{
$url = "showthread.php?$session[sessionurl]p=$newpost[postid]#post$newpost[postid]";
}

Hey guys if anyone been succesefull with newreply.php can you please explain how you did it ?? Cause that code is NOWHERE on that file.

[miz]

L'o guys, im having the same error i have a prefix such as dbvb_vbusers

I dont know if thats a huge problem. but I would like some help here.


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

change to :

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

[KAC]

Major problems installing this mod.. Does this work on 3.0.7 ? and if it does ..

When I upload sessions.php it brings down the whole forum, database error.
When I upload usercp.php, when I click usercp it give database error.
When I upload forumdisplay.php I am unable to get inside forums.
When I upload profile.php, inside usercp when I click profile I get database error.
When I upload showthread.php, I get database error when posting.

I did the template edits first then uploaded php files, then tried to run install and got database error . removed sessions.php edit and tried to run install . It worked till the end and I got a database error on the install .

Can someone help ?

http://www.kickasscustoms.com/vb/index.php

The hack is half way installed as of now .. I would love to have this working properly if possible since it will be great for my site.

[Marco van Herwaarden]

What editor are you using?

I just checked the install instructions for the sessions.php. No way this can bring your board down if instructions followed accurate.

PS Are you still on 3.0.0 like your profile is showing?

[KAC]

I am at 3.0.7 And when I upload sessions.php I am unable to get to the site .. Even while inside the admincp it comes up database error ... ill check my editing again on session but as far as the other stuff , I have no idea what could be wrong ..

this s the error I get when I upload the edited sessions.php

Fatal error: Call to undefined function: fetch_teaminfo() in /home/virtual/site33/fst/var/www/html/vb/includes/sessions.php on line 316

[Marco van Herwaarden]

Hmm looks like there are some requires of functions_team.php missing from th instructions. Will get back to you later if the hack coder didn't reply first.

PS could be you missed another edit, i didn't go through all instructions yet.

[KAC]

I went over all of my edits and I followed the instructions to the T .. I have a feeling that my forum possibly has another mod or hack that may be messing this one up . Im getting database errors still while replying to posts. so there is another php file that I did not list above that is not correct also ..

[Marco van Herwaarden]

Like i posted before, i have feeling that something is missing from teh isntructions. Surprised nobody mentioned it before now.

I send MIZ a PM asking him to have a look at the instructions.

[KAC]

Well, thanks alot for trying to help marcoH64 .. I have one more day to get this worked out or I have to redo all that I did already . I have about 20,000 hits a day on my site and its just not lookin to good right now for it . I guess maybe Ill retry this mod in the future if nothing is resolved by tommorrow. thanks again

[tpr]

Hi,
Could someone please tell me whats the status of this hack ?
I really (but really) need a good team hack, i was unable to work around some of the problems that exist in this version and from what i understand from miz comments he is not going to continue supporting this hack.
My question is, Miz, are you planning to come back, i know some ppl here tend to forget that they are not paying for these hacks but i dont think its fair to blame everyone else as well.. :(
Assuming Miz is out of the game will someone be willing to build a new & improved team hack ? i can not do a hack like this alone but im sure with some help its doable...
anyone?

Tpr

[Marco van Herwaarden]

Just a quick update:

I installed this hack today on a clean 3.0.7 testboard, and following the instructions (with a litle comon sense) i was able to install it without real problems (not used a table prefix).

I taken the liberty to create a version of this hack that is 100% the same as Miz version, only it has some bugfixes in it so people can at least install this hack (even when using a prefix) and run it secure (fixed some possible SQL injections).

I also updated the install instructions to avoid editing errors.

I plan still to incorporate a fix for the no permission error on post a thread in a private forum (and find out why i can't accept a new member to a group on my testboard). When this is finished (hopefully tomorrow) i will post my version here in this thread.

It is NOT my intention to take over Miz's work, so i will remove my version after Miz returns or withdraw this hack (reading back this thread here makes me wonder if he will want to support this hack more, couldn't blame him if he doesn't).

PS Don't start asking for modifications, i will only fix a few bugs in the current versions that are serious enough to make this hack not functional for some people.

[skorzguy]

Here is an idea somebody suggested to me:

Must have VB teams and Arcade installed:

In the high score list, list the member and what team he or she belongs to:

How would I do this?
Do i just need to edit the templates?

Can someone do this cool feature

[KTBleeding]

Just a quick update:

I installed this hack today on a clean 3.0.7 testboard, and following the instructions (with a litle comon sense) i was able to install it without real problems (not used a table prefix).

I taken the liberty to create a version of this hack that is 100% the same as Miz version, only it has some bugfixes in it so people can at least install this hack (even when using a prefix) and run it secure (fixed some possible SQL injections).

I also updated the install instructions to avoid editing errors.


I plan still to incorporate a fix for the no permission error on post a thread in a private forum (and find out why i can't accept a new member to a group on my testboard). When this is finished (hopefully tomorrow) i will post my version here in this thread.

It is NOT my intention to take over Miz's work, so i will remove my version after Miz returns or withdraw this hack (reading back this thread here makes me wonder if he will want to support this hack more, couldn't blame him if he doesn't).

PS Don't start asking for modifications, i will only fix a few bugs in the current versions that are serious enough to make this hack not functional for some people.
When will this be available? I was just going to try this hack out, but if yours fixes bugs/possible SQL injections, I'm very interested.

[KAC]

thank you MarcoH64, cant wait to try it out ..

[Marco van Herwaarden]

When will this be available? I was just going to try this hack out, but if yours fixes bugs/possible SQL injections, I'm very interested.Like i said, hopefully tomorrow.

[KTBleeding]

Like i said, hopefully tomorrow.
Oh woops, I didn't see that. :o

[|Jordan|]

I'm having a few problems with this hack.

I installed the hack (bloody thing took me over an hour of file edits), everything seems to have installed perfect, along with the install file, etc. I can add teams, but when i try to join a team i created, it says its sending out the PM, but never does. How do i add a team leader?

Also, i added some private forums, but i would like them somewhere else on my forum (or maybe even link off an existing forum), how would i go about doing this? I looked all over the SQL and couldnt find the table its stored in.

[subnet_rx]

I love this team integration, but about the password thing, is that to get in the forums?

Is this like a group where you can apply for the group and be admitted or rejected?

[Marco van Herwaarden]

Just a quick status update:
- I have spoken to Miz. Since he is only once in every few weeks at home because of his work, he will not be able to further develop or support this hack much. He agrees on me creating a bugfix release.
- I haven't been able to write 1 line of coding yesterday (RL work, and spend half my day to remove a Trojan i was stupid enough to catch).
- Still need to be finished: Problems joining a team and error after posting.

Hope to have all this finished today or tomorrow. Just need to find a liitle time to work on it.

[subnet_rx]

thanks for working on this, definitely a good addition to the community.

[Curll]

Any recent news?

[iceytdot]

were the bugs ever fixed for this, cuz it sounds like it can be an amazing hack .. but i just read thru some pages an seen the bugs, so i was wondering if whats there to download now is the one thats not buggy?

[RapCapital]

Does this work for 3.0.7

[Niroj]

did the update version by MarcoH64 get released??

im having a few problems. if a user sends a request to join a group. when the team-admin accepts....it goes into a blank page. and if the admin tries inviting someone...i get PM, saying use the link in userCP. but there is no such link in there!!

pls help

[Marco van Herwaarden]

Hmm actually i didn't spend any time after my last post on this.

I had to do some other things first and after that i have been out of the country and overloaded with work. I will have a look if i can do anything somewhere next week.

[Niroj]

Hmm actually i didn't spend any time after my last post on this.

I had to do some other things first and after that i have been out of the country and overloaded with work. I will have a look if i can do anything somewhere next week.
is there anyone else who had this problem??
if you get a small time gap...cud u see if u cud fix this pls?? :o cos i wona install more hacks...after getting this working....or else il av to remove dis n install it some other time.
i wud b so gratefull

thnx

[Bulletsway]

MarcoH64 , Have you had a chance to modify this hack at all ? This would be real nice on my forum . If you or anyone have figure this to work with vb 3.0.7 please post up ..

[NxTek]

I made the changes per "file changes.txt", but when I went to the admin to do the "template_changes.txt", I get this error:


Invalid SQL:
SELECT teams.*, teams.name AS username,

COUNT(user.userid) AS totalmembers,
sum(user.posts) AS posts,
sum(user.reputation) AS reputation
FROM teams AS teams
LEFT JOIN user ON(teams.teamid = user.teamid)
WHERE teams.teamid =0
GROUP BY teams.teamid


mysql error: Table 'forums.teams' doesn't exist

mysql error number: 1146

[yahoooh]

Just a quick update:

I installed this hack today on a clean 3.0.7 testboard, and following the instructions (with a litle comon sense) i was able to install it without real problems (not used a table prefix).

I taken the liberty to create a version of this hack that is 100% the same as Miz version, only it has some bugfixes in it so people can at least install this hack (even when using a prefix) and run it secure (fixed some possible SQL injections).

I also updated the install instructions to avoid editing errors.


I plan still to incorporate a fix for the no permission error on post a thread in a private forum (and find out why i can't accept a new member to a group on my testboard). When this is finished (hopefully tomorrow) i will post my version here in this thread.

It is NOT my intention to take over Miz's work, so i will remove my version after Miz returns or withdraw this hack (reading back this thread here makes me wonder if he will want to support this hack more, couldn't blame him if he doesn't).

PS Don't start asking for modifications, i will only fix a few bugs in the current versions that are serious enough to make this hack not functional for some people.

we wait :disappointed:

[Marco van Herwaarden]

I am sorry, but other things (real life work, family, my own hacks and payed work) have gotten in the way of looking further into this. I have a half fixed (and more broken, but hey you must make a mess first when trying to clean) version somewhere around, but i doubt i will have time for this soon.

[poetic]

can someone help me.

when someone trys to join the team, it only allow the admins of the team to vote for that person.

it doesnt let them choice weather they can be on the team or not.

[Tigur]

Out of curiosity is there a way to modify this hack to be automated with paypal? For example I have a website and I offer users their own private forum for $20 (one flat fee) and would be easier if the forum purchaser can administer the forum themselves?

[o1dirtydog]

seems like a interesting idea... but not worth all the edits.

and the fact that you have to use team, well that stinks.

[MiskaTorn]

How do I set who is the owner of the team?

[csidlernet]

Whythanks this just what i've been looking for!

[boxingscene]

Whythanks this just what i've been looking for!

is anyone going to post any of the fixed versions of this hack? I installed it and there are all sorts of problems. Mainly the fact that people get PM invites without anywhere to click as far as joining and when a person applies for a group, the poll is all screwed up and comes up the same poll for every user that applies. I noticed that the forumdisplay.php part of the install file is all screwy with errors.

[DonLKSAB]

Did anyone get the join team info to show up in the UserCP?
If so how did you do it?

Everything else seems to work fine.

/DonLKSAB

[NxTek]

Hi,

I'm getting this error when running teams2.0.2_install.php


Database error in vBulletin 3.0.8:

Invalid SQL:

CREATE TABLE `teams` (
`teamid` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`avatarurl` varchar(100) NOT NULL default 'images/teamavatars/no-avatar.gif',
`words` text NOT NULL,
`adminmsg` text NOT NULL,
`ircserver` varchar(50) NOT NULL default '',
`ircport` int(4) NOT NULL default '6667',
`chan` varchar(50) NOT NULL default '',
`chanpass` varchar(50) NOT NULL default '',
`notes` text NOT NULL,
`email` varchar(100) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`teamid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 17

mysql error number: 1064

Date: Saturday 03rd of September 2005 01:30:39 PM
Script: http://www.onlinepokerlistings.com/forums/admincp/teams2.0.2_install.php
Referer: http://www.onlinepokerlistings.com/forums/admincp/teams2.0.2_install.php
Username: DJQuad
IP Address: 69.xx.xx.x

[NxTek]

admincp/announcement.php
========================
FIND :
// display forum-specific announcements
foreach($forumcache AS $key => $forum)
{

AFTER ADD :

// Team Hack Start
if (!$forum['teamid']) {
// Team Hack End

FIND :

print_cells_row($cell, 0, '', -1);
}

print_table_footer();

}

print_cp_footer();

REPLACE WITH :

FIND :
// display forum-specific announcements
foreach($forumcache AS $key => $forum)
{

AFTER ADD :

// Team Hack Start
if (!$forum['teamid']) {
// Team Hack End


This leaves this -


// display forum-specific announcements
foreach($forumcache AS $key => $forum)
{
// Team Hack Start
if (!$forum['teamid']) {
// Team Hack End
// Team Hack Start
if (!$forum['teamid']) {
// Team Hack End


I'm assuming the teamid only needs to be listed once and there is another error in filechanges.txt?

[MustangLisa]

This looks interesting; I'm going to give it a try. Thanks for all your work to put it together!

[DonLKSAB]

Anyone managed to get the invite thing to show up in the usercp?

/DonLKSAB

[ryans]

can you please repost the changes in admincp/announcement.php

it's pretty sketchy. thanks!

[ryans]

can you please repost the changes in admincp/announcement.php

it's pretty sketchy. thanks!

I figured it out....

admincp/announcement.php
========================
FIND :
// display forum-specific announcements
foreach($forumcache AS $key => $forum)
{

AFTER ADD :

if (!$forum['teamid']) {

FIND :

print_cells_row($cell, 0, '', -1);
}

print_table_footer();

}

print_cp_footer();

REPLACE WITH :

print_cells_row($cell, 0, '', -1);
}
}

print_table_footer();

}

print_cp_footer();

[ryans]

I wanted to send Miz a PM, but his account doesn't let him. So I'll just post it here. Hopefully he can read it sometime.
--------------------------------------
Just wanted to say that the team hack is one of the greatest hacks i've seen. Don't let those haters get you down. I appreciate what you've done.

thanks

ryan

[DonLKSAB]

Yeah its realy cool.

Ryans.
Did you manage to get the invite thing to show up in the UserCP?

/DonLKSAB

[ryans]

Nope. I uninstalled it. I really liked it but until there is a newer release I can't use it. there is a site that has it fully functional at http://www.tunerfriends.com

[Beng Yeow]

Can some kind soul please help clean this hack up, its very unstable but its a very useful hack.

[NxTek]

Will this be ported to 3.5?

[ryans]

Will this be ported to 3.5?


Unless some super programmer takes this over. This item is dead and should probably be removed from vb.org as it's just a waste of time to us people that can't program.

[NxTek]

I agree.

[Zachariah]

I have not played with it, or read what is wrong, but I love the idea and might make it VB3.5

What in a good list is the major problems ?

[subnet_rx]

I have not played with it, or read what is wrong, but I love the idea and might make it VB3.5

What in a good list is the major problems ?

This is an excellent idea, I'd like to use it for groups on all of my forums so that I don't have to make a new forum, set permissions, etc. for each new group. Look forward to seeing it ported over if possible.

[sarpicaste]

I dont have a list of problem, but I do thank Zachariah for his offer and I hope it capitalizes and we get the 3.5 running soon.

Thanks!

[Killmark]

Can some kind soul please help clean this hack up, its very unstable but its a very useful hack.

Spent a few days going through tidying the code and fixing spelling mistakes.

Now at a state can use it.

:)

[NxTek]

Spent a few days going through tidying the code and fixing spelling mistakes.

Now at a state can use it.

:)

You're running 3.5?

If not - Zachariah, will you be porting it?

[Zachariah]

You're running 3.5?

If not - Zachariah, will you be porting it?

Sure it should not be a big problem.

@Killmark - send me a memo what ya fixed. It would be best to have a working hack before the convert.

[Killmark]

You're running 3.5?

If not - Zachariah, will you be porting it?

Not yet, and maybe.

[NxTek]

Sure it should not be a big problem.
Good. I have a list of requests for features. Would you consider adding them?

[arurcard]

this does not work with 3.5?

[Xtrato]

REQ port to vB 3.5

[bhxtyrant]

I was also hopeing to see a prt pf this to 3.5.0 :ermm: It seems to be just what i am looking for for use on our forum and sadly i havent seen anything even close to similar to this mod.

[Bratz-Designs]

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

change to :

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

Anyone got a clue where to change this? :)

[asasi]

i have installed the hack and added new team and intered in team admin section.
how can i accept user requests for join???

[asasi]

how can I uninstall this hack?
restore non-edited files - restore templates
how to remove database changes?

[Snake]

Whoa this is hot but are you planning to upgrade for 3.5.2? :D