Author Topic: how to get a table from other db (Read 12924 times)

Pharexys · « **on:** June 06, 2006, 07:57:46 pm »

Ok so i have more bots running atm
What i want is to put all bots to use only 1 table from other db(diferent then hes own db),
this table is the whois catch one from alreadythere so we dont wait for FC site evrytime,
however i want all bots to use 1, so i dont have to make 1 on evry bot i start lol
I know it is possible and maybe is a really simple way, but i cant really see how to do it.
any help apreciate

Wolfbiter · « **Reply #1 on:** June 06, 2006, 09:08:37 pm »

In MySQL.php

Code: [Select]

	function cngdb($db) {
		mysql_select_db($db,$this->CONN);
	}

In script files

Code: [Select]

	$this->bot->db->cngdb("newDB");
	-script stuff here-
	$this->bot->db->cngdb("oldDB");

Alreadythere · « **Reply #2 on:** June 06, 2006, 09:23:57 pm »

I have to say this

If you go and use my tablename functions, you can use a prefix/suffix for each bot. So you can put all tables for lot's of bots in just one database.

I'm running 10+ bots, all using one database.

Khalem · « **Reply #3 on:** June 06, 2006, 11:43:47 pm »

It can non the less be made easier to connect to more than one database (thinking primarily different database hosts) by making some simple changes to MySQL.php to allow passing of the connection information to the connect function.

For switching between local databases, Wolfbiter's suggestion is a very good one however.

Zacix · « **Reply #4 on:** June 07, 2006, 12:02:53 pm »

If your table is in database "a", and you're connected to database "b"...you can still just do "SELECT * from a.whoiscache". It will return the content of "whoiscache" table in database "a". This is ofc if database "a" and "b" is running on the same service.

Pharexys · « **Reply #5 on:** June 07, 2006, 01:38:21 pm »

I dont have time to test atm, but thanks alot for help guys

anyway i like Zacix way and already,

Well corect me if undertood wrong,
This is the origial function lookup from WhoisCache.php

Code: [Select]

function lookup($name)
	{
		$lookup = $this -> bot -> db -> select("SELECT * FROM " . $this -> bot -> get_tablename("whois") . " WHERE name = '" . $name . "'");

I guess i will need to set it up something like :

Code: [Select]

 function lookup($name)
	{
		$lookup = $this -> bot -> db -> select("SELECT * FROM whois.whois  " WHERE name = '" . $name . "'");

About Alreadythere way of puting prefix/sufix, do i have to do that on evry modules/bot core etc? I mean i have to change the tables the bot use? or is there a faster way to do it?

Zacix · « **Reply #6 on:** June 07, 2006, 04:33:25 pm »

Phar

"SELECT * FROM whois.whois " WHERE name = '" . $name . "'"

would imply that the database name that the whois table is in, is called whois. Just thought that "whois" was a strange name for a database...just mentioning in case you misunderstood my first post. The default select syntax is (simplified):

SELECT * FROM [databasename.]table [WHERE column = 'value']

Pharexys · « **Reply #7 on:** June 07, 2006, 08:00:21 pm »

yea man, i made a db that only handle that and is named whois hehe

well was a exemple anyway, im gonna test it, its alot easyer how Zacix say, if i cant get it work, i'll ask again.
Thanks for help

Alreadythere · « **Reply #8 on:** June 07, 2006, 09:17:23 pm »

Quote from: Pharexys on June 07, 2006, 01:38:21 pm

About Alreadythere way of puting prefix/sufix, do i have to do that on evry modules/bot core etc? I mean i have to change the tables the bot use? or is there a faster way to do it?

If you put all into one databse then yes, you would have to do that. Implementing those functions the first time is quite a bit of work, you have to edit all database queries.
For new modules it's not much more work, just a bit longer writing.