collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Support for a prefix in the tablenames  (Read 6698 times)

0 Members and 2 Guests are viewing this topic.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Support for a prefix in the tablenames
« on: July 14, 2008, 12:36:06 pm »
As I'm seeing some modules using fixed tablenames here a short introduction how to use the support for a prefix in tablenames offered by the BeBot core.

In the CREATE call don't use a fixed tablename, instead use the $this->bot->db->define_tablename($tablename, $prefix) function.
The variable $tablename is a string containing the name of the table, without any prefix. This name without prefix is called internal name in the following.
The variable $prefix is a boolean (or string containing "true" or "false") defining whether the bot should use a prefix for this tablename on default (true/"true") or not (false/"false").

In any other SQL queries to this table use the internal name prefixed with #___ (# followed by 3 _) as prefix. The MySQL module will convert all those tablenames based on the entries for the internal name to use a prefix or not as defined.

The following is a simple example of some code using this ability:
Code: [Select]
$this->bot->db->query("CREATE TABLE " . $this->bot->db->define_tablename("test_table", "true") . " (id INT)");
$this->bot->db->query("INSERT INTO #___test_table (id) VALUES (123)");
$this->bot->db->select("SELECT nickname FROM #___whois WHERE id IN (SELECT id FROM #___test_table)");

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 587
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal