[Zor]

*** UPDATED ***

v0.5 - Fixed errors with dbi_num_rows v0.5a - Added clan_listmembers, and clan_active as well as menus for the clan_active

Have updated this plugin. Very stable so far. Please let me know if you locate any bugs.

Cheers!

[bmann_420]

Omgzors your alive Zor! Ty very much my friend, you are truley a life saver.

EDIT: I just got this,

L 12/22/2005 - 09:18:04: [dbi_clanmanager.amxx] The server encountered an error while performing query = 'SELECT nick,ref_clan_index,ref_level_index,active FROM clan_manager_members WHERE steamid='BOT' LIMIT 1' Function = 'client_authorized' Error = 'Unknown column 'active' in 'field list''
L 12/22/2005 - 09:18:04: [dbi_clanmanager.amxx] The server encountered an error while performing query = 'SELECT nick,ref_clan_index,ref_level_index,active FROM clan_manager_members WHERE steamid='BOT' LIMIT 1' Function = 'client_authorized' Error = 'Unknown column 'active' in 'field list''

L 12/22/2005 - 09:18:18: [dbi_clanmanager.amxx] The server encountered an error while performing query = 'SELECT nick,ref_clan_index,ref_level_index,active FROM clan_manager_members 
WHERE steamid='STEAM_0:1:8189548' LIMIT 1' Function = 'client_authorized' Error = 'Unknown column 'active' in 'field list''
L 12/22/2005 - 09:18:18: [dbi_clanmanager.amxx] The server encountered an error while performing query = 'SELECT nick,ref_clan_index,ref_level_index,active FROM clan_manager_members WHERE steamid='STEAM_0:1:8189548' LIMIT 1' Function = 'client_authorized' Error = 'Unknown column 'active' in 'field list''
L 12/22/2005 - 09:18:47: [dbi_clanmanager.amxx] The server encountered an error while performing query = 'SELECT nick,ref_clan_index,ref_level_index,active FROM clan_manager_members WHERE steamid='STEAM_0:1:3743420' LIMIT 1' Function = 'client_authorized' Error = 'Unknown column 'active' in 'field list''

Did I do something wrong in the sql script? Should I take out the active column?

[Zor]

Ok need to create patch for the SQL file to do updates...just a second...

Cheers!

EDIT....


**** Update ****
Ok for those of you who were using this plugin BEFORE this release. There is a patch file for your SQL in the dbi_sql_files.rar posted at the head of this thread. Please grab it and check it out. This is needed for the plugin to work.

Cheers!

[bmann_420]

Im still gettin this with everything changed,

L 12/22/2005 - 17:14:54: [MYSQL] No more results in handle 38
L 12/22/2005 - 17:14:54: [AMXX] Displaying debug trace (plugin "dbi_clanmanager.amxx")
L 12/22/2005 - 17:14:54: [AMXX] Run time error 10: native error (native "dbi_result")
L 12/22/2005 - 17:14:54: [AMXX]    [0] dbi_clanmanager.sma::checkAccess (line 313)
L 12/22/2005 - 17:14:54: [AMXX]    [1] dbi_clanmanager.sma::client_infochanged (line 254)

[Zor]

I had that error before. Let me look at it and see whats up.

Cheers!

EDIT:

How long is your name, more than 32 characters? And are there members in you SQL? When is this happening? Is it still giving you admin rights? Let me know.

Cheers!

[bmann_420]

This happens right when i start the plugin. I have yet to even use this plugin. This is what the sql admins look like,

SteamID nick ref_level_index webadmin webpass     
STEAM_0:1:3743420 |AoC| Masta)the(Disasta 24 0 
STEAM_0:0:2234170 |AoC| Rambo 24 0

None over 32 characters.

[iceman559]

Hello I am actually hosting the db for the bmann.

there are 29 members in the clan_manager_members db in which the longest name is 27 characters.

the structure is:
steamid nick ref_clan_index ref_level_index firstjoined lastconnected webadmin weblevel webpass active


and all entries are formatted as:
STEAM_0:1743420 |AoC| Masta)the(Disasta 1 24 0000-00-00 00:00:00 0000-00-00 00:00:00 0 0 0


I bolded every other entry for it to be read easier

[bmann_420]

TY Ice

[Zor]

Ok guys, I'm going to asume that the following is true.

This is an example of your members table:

STEAM_0:0:000000 |AoC| Masta)the(Disasta 1 24  0000-00-00 00:00:00 0000-00-00 00:00:00 0 0 0

When in fact you have your clan tag in the name. This is incorrect and most likely causeing the errors. You must have a clan to query against. Within this clan should be the clan tag. And in your case it would look as such:

1, 'Army of Chaos', '|AoC|', '|AoC|(s)', '', 4

This is as follows:
1 = The index for the clan
'The AoC Clan' = This is the Long name of the clan
'|AoC|' = The Short name for the Clan
'|AoC|(s)' = The Tag that goes in front of the nick
'' = The Tag that goes after the nick
4 = The placement of the Rank ( Which you dont have )

Next you must ensure even though you DONT have ranks to have a rank structure setup for ppl. For example, you have 4 ranks:
Top Admin
Middle Admin
Lower Admin
Recruit

You dont need to have a rank but they must be part of the levels. So it would move from bottom up, in other words your first entry should be the lowest level, in this case Recruit and make its way up to top admin:
1, 1, 'Recruit', '', 'jtu'

Broken down:
1 = The clan this rank belongs to
1 = The level of reference
'Recruit' = The Name of the level
'' = The Rank tag that will be added to the name
'jtu' = The amxmodx admin level

The next three would be as follows:

1, 2, 'Lower Admin', '', 'abcefijstu'
1, 3, 'Middle Admin', '', 'abcdefgijkqrstu'
1, 4, 'Top Admin', '', 'abcdefghijkmnopqrsltu'

This will allow you to have everything you need. And all this must be done. And lastly for the members. They should be as follows:

'STEAM_0:0:000000', 'Masta)the(Disasta', 1, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, 1

The break down:

'STEAM_0:0:000000' = Steamid
'Masta)the(Disasta' = Nick
1 = The Clan
4 = The Level
'0000-00-00 00:00:00' = When they joined
'0000-00-00 00:00:00' = Last time they were on the server
0 = Are they a webadmin ( Once the webpage is created )
'' = There webadmin Password in MD5 ( Once the webpage is created )
0 = What is their level of webadministration ( Once the webpage is created )
1 = Are they active 1 = yes 0 = new

Anyway. Check your DB and let me know. I am not getting any errors!

Also you should run the following against your DB:

UPDATE clan_manager_members SET active=1

Your members seem to be inactive, as in active=0

[bmann_420]

Wow, well thank you for that very descriptive response. We will try that and see, and ty again. And its Christmas Eve!