Finding names for tables in database.

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I have a feature in my MILPACS module that uses information in another modules database tables. The other module is called vWar and it is what "clans" use to schedule matches and scrimmages with each other. People can sign up for a scrim or match.

The tables in vWar I use with my MILPACS modules are the war, vwar_opponents, vwar_matchtype and maybe one other. The problem is these tables in vWar can be named differently depending on how the modules was installed by the user.

During the setup of vwar you need to set a variable. If you set a n$="" then you have vwar, vwar_opponent and vwar_matchtype. If you set n$="nuke" then you would have vwarnuke, vwarnuke_opponents, vwarnuke_matchtype and the like.

How can I code my module in such a way as to dynamically get the names of these tables in vwar and then use those names, whatever they turn out to be for my module.

As far as I know MySql does not have a sysobject like MSSQL.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

You can get the list of all tables from http://us3.php.net/manual/en/function.mysql-list-tables.php . You would then need to match the $n values however you wish.

Posted: Tue Jan 10, 2006 12:48 pm

mmm.

In the instructions for vWar you have to set the $n variable. This way you can have more than one install. It suffixes your tables...( ie vwar1, vwar2). What if in the my module readme.txt I just told them to set a variable in my module to the same thing they set $n to in their vwar _config.inc.php in the vwar/includes folder.

That way they would be the same and I could just concatenate my sql query.

Where should I set the value of $n if I don't use a config.php file, and how could I pass the value throughout my module? Could I just make it a global?

Posted: Tue Jan 10, 2006 2:29 pm

You will need to make it available, somehow, whether through config.php or a similar mechanism.