UDesigns.be

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

I have purchased Vb Clan members for vbulliten 4.0.3 there is a Mysql error

Database error in vBulletin 4.0.4:

Invalid SQL:
SELECT i.rank, i.joindate, i.birthday, i.avatar, i.xfire, i.steam, i.active, i.realname, i.gender, i.location, i.country, u.birthday, u.msn, u.icq, u.yahoo, u.aim, u.ipoints, u.posts from clan_members_info i, user u where i.name='Trippy' AND u.username='Trippy';

MySQL Error : Unknown column 'i.birthday' in 'field list'
Error Number : 1054
Request Date : Sunday, July 4th 2010 @ 06:16:39 PM
Error Date : Sunday, July 4th 2010 @ 06:16:39 PM
Script : http://www.outkasts.net.au/forum/clanmembers.php
Referrer : http://www.outkasts.net.au/forum/forum.php
IP Address : 120.147.128.16
Username : Trippy
Classname : vB_Database
MySQL Version : 5.0.90-community-log

Can you fix this? please Smile

Thank you

Untergang · Posted: 04 Jul 2010 01:48 pm

Hey,

Thanks for purshasing the vb clan members.
I found the problem and fixed it, you can download the product again here: http://www.udesigns.be/modules.php?name=DLShop&op=ItemDetails&lid=73

You only need to reupload clanmembers/main.php again.

Can I ask you how you found this product? Smile

Greets

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Found another bug

http://www.outkasts.net.au/forum/clanmembers.php

When you change the members from blocks to lists

Database error in vBulletin 4.0.4:

Invalid SQL:
SELECT i.rank, i.joindate, i.avatar, i.xfire, i.steam, i.active, i.realname, i.gender, i.location, i.country, u.birthday, u.msn, u.icq, u.yahoo, u.aim, u.ipoints, u.posts from clan_members_info i, vbuser u where i.name='CLiNT_1983' AND u.username='CLiNT_1983';

MySQL Error : Table 'out47814_reborn.vbuser' doesn't exist
Error Number : 1146
Request Date : Monday, July 5th 2010 @ 05:55:44 AM
Error Date : Monday, July 5th 2010 @ 05:55:45 AM
Script : http://www.outkasts.net.au/forum/clanmembers.php
Referrer : http://www.outkasts.net.au/forum/clanmembers.php?do=Profile&member=CLiNT_1983
IP Address : 120.147.128.16
Username : Trippy
Classname : vB_Database
MySQL Version : 5.0.90-community-log

Regards
Trippy

Untergang · Posted: 04 Jul 2010 09:31 pm

That has been fixed as well, you'll have to reupload the same file again.
Sorry for all this, it's my first product for vBulletin. I tested it a lot, but apparently not enough Smile

Someone needed a member list for vBulletin too, so he asked me to convert the phpnuke module to a vBulletin product, so I did Smile

. I'm going to make a post at that site right away, it seems like quite some people are looking for a member list for vB Smile

I'm working on an update for the wars module at the moment and when that is done, I'm going to convert it too.
If you have suggestions for new features, you can always let me know.

Sorry again for the little errors

Untergang · Posted: 04 Jul 2010 09:56 pm

Ok, it seems like I can post at that site. I used some else's vBulletin site to make the product, because I had never used vBulletin before, so I don't have a license myself and I can't afford one yet Rolling Eyes

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Untergang

That fixed the problem mate I have given the script a bit of a test and I can't find any other bugs then the minnor spelling errors and small cosmetic problems.

This is what I would like done to the script:

Stream: Clickable steam name EG- click on there steam name and it takes the user to there steam community page where the person can add the person or it can add you to the users friends list.

PM User: click on PM and you are taken to your PM box ready to send a PM to the user

Ranks: have the ability to allow ranks to be in categories. EG

Leaders
Member1
member2

Co Leaders
Member 3
Member4
Member5

Captains
Member6

Co-Captains
Member7
Member8
Member9

Cosmetic:

Banners to be in the center at the moment it's to the far left and it looks funny http://www.outkasts.net.au/forum/clanmembers.php or make the banner bigger so it hides the crap behind it?

When u add images in to the profiles the tables play up as well you get a grey thick line above the table. http://www.outkasts.net.au/forum/clanmembers.php

That's all for now Smile

but yeah this is the best clan members list ever made you should put your head up high on a great job mate.

Though my advice would be to make a light version and give that away for free and then have a pro version and that costs money.

If I could help you I would to get a VB license for ya but they are asking a fair bit lol how much more do you need? If you make VB products you realy should make both PRO versions and Light versions...

keep up the good work I will ne hanging around here for more updates Smile

Thanks
Trippy

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Noticed another problem when I add 2 games icons

instead of the icons been side by side for some reason 1 icon is on top of the other game icon and the table turns grey

http://www.outkasts.net.au/forum/clanmembers.php

any way to get rid iof that grey and get the icons side by side?

Never mind worked it out Smile

forgot what I said in this post lol

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Still got that grey bar up above the users tables for some reason!

thanks

regards
Trippy

Untergang · Posted: 05 Jul 2010 08:27 pm

I added the things you said, except for the rank categories. I might add it in the future, but I'm going to leave that out for now.
Could you tell me where you see the spelling errors?

Thanks

btw I still need 190€ to buy a license. I have to pay my host at the end of this month and I don't have enough money on my paypal yet. I'm also going on holiday next week and it's going to be quite expensive, I think, so I'm going to need my money Smile

shooterdfl · 30% Joined: Sep 28, 2008 Posts: 19

Nice suggestions trippy! When Untergang gets the wars module updated and converted vb will finally truly support a competition clan...should be able to sell alot of these mods to vb owners!

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Script works like a dream nice work once again though it seem's I can't find add peoples PM's to users profiles though every thing else works great Smile

Once the script allows a admin to change the display order for ranks then the Member script will be perfect Smile

I still think you should make a Light version and flog that off for free
EG:
Free Version only has members list No members profile no members images and no members awards.

Pro Version comes with it all

Come and check out your hard work Smile

http://www.outkasts.net.au/forum/clanmembers.php

Just an idea for Untergang , if you got a script like Vwar for VB .... then you will hold 100% of the market for clans with VB that want a clan system Smile

There is no script for VB for clans there are a few for wow but that's it just somthing to think about Smile

I am happy to host a banner on my site for you to advertise your scripts for VB ( not php nuke ) also maybe you can use my VB licences to post your scripts on VB.ORG to start you off? PM what you think!

Untergang · Posted: 08 Jul 2010 05:16 pm

You need to install the product again for the pm button. The best is to overwrite it, else you'll lose all your data. The templates need to be updated. I wanted to tell you, but you also said there were some spelling errors, so I wanted to fix those first Smile

Once the clan wars product for vbulletin is ready, I'll make a pro & light version for both products.

You also said that you want to be able to change the display order of ranks, but, normally you can already do that..?

I have a small and large banner atm
http://files.udesigns.be/ud.gif
http://files.udesigns.be/ud-banner-2.jpg
I should make new ones though Smile

It's very kind of you to let me use your account to post the mods and I would like to do that, but I would also like to wait with that till the clan wars product is ready. I want to make the clan members and clan wars product work together, but the clan members product will need a few changes then.

Thanks Smile

Trippy · 20% Joined: Jul 04, 2010 Posts: 10

Added the banner Smile

Just thought of a few ideas

* With the male word and male image can you delete the word Male and Female and just have the image?

* Would it be possible to have a clickable steam image instead of the clickable link?

* Would it be possible to have a clickable MSN image instead of the email address?

I installed the xml file and every thing is perfect Smile

nice work
Hmm can't find them spelling mistakes lol must of been me and my tired eyes!

PM when ya ready Smile

also what is the upload limit on the forums?

Regards
Trippy

Untergang · Posted: 29 Jul 2010 12:50 pm

Hi, sorry for my late reply, but I went on holliday and didn't have a lot of time last days.
I'm working on the wars module now, so after that I'll see what I can do for you Smile

Which upload limit on the forums do you mean?

Greets

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Just purchased this and its working like a charm, many thanks

If possible, Could you include :

Xbox live gamer tag - under real name
PM button below location

Cheers and cant wait for the war to be used with this

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Just found a bug

When you enable the MSN, It does not display it correctly

Mine shows as - betts02[AT]tiscali[DOT]co[DOT]uk

Untergang · Posted: 24 Aug 2010 04:59 pm

That's not a bug, it's a security feature, normally you can choose who can view the address with the symbols replaced or not. It's somewhere in the permissions section (of vBulletin, not the clan members part)
I'll add those 2 things when I do the update for the clan members mod.

Greets

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Found a bug that creates this error :

Warning: unlink([path]/clanmembers/images/Games/Banners) [function.unlink]: Is a directory in [path]/admincp/clanmembers/clean.php on line 60

Warning: unlink([path]/clanmembers/images/Games/Icons) [function.unlink]: Is a directory in [path]/admincp/clanmembers/clean.php on line 60

When you add a member to a game, All is fine

But if you change a users name, It gives this error when you view games via admin

I had to remove a player and add him again with the new username

Untergang · Posted: 25 Aug 2010 01:08 pm

Those 2 folders shouldn't be there. It cleans up the images once a day, but it can't delete folders. I guess you uploaded the Games folder in the extras folder as well, but you're not suposed to do that Smile

. To add a banner or icon, you have to upload it in the administration. So to fix this you just have to delete those 2 folders (Banners and Icons)

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Would this be possible to include a profile field ?

I have our members fill in a profile field for their xbox live gamer tag and this would be great if it could

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Where do i edit the title "Clan Members" that gets put in the navbar ?

cheers

Untergang · Posted: 27 Aug 2010 05:16 pm

With profile field you mean something they fill in to their profile and then gets shown in the clan members list?
I'll have to take a look where you can change that Smile

Greets

betts02 · 20% Joined: Aug 21, 2010 Posts: 11

Exactly mate

On my site i have members fill in their profile fields, 1 of these is their xbox gamer tag, This for mine is field 5

If this could be used, It would be great

Untergang · Posted: 29 Aug 2010 12:58 pm

I'll have to see how it all works first, then I can let you know whether it could be used or not Smile