<?php
define("DB_ENGINE", "mysql");
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
define("DB_PORT", 3306);
define("DB_NAME", "ajax_chat");
define("DB_PREFIX", "");
define('ENCRYPTION_KEY', 'S9kv9034kLAU0338dh2rfSFW3');
define("PDO_DSN", sprintf("mysql:host=%s;port=%d;dbname=%s", DB_HOST, DB_PORT, DB_NAME));
//
try {
$dbh = new PDO(PDO_DSN, DB_USER, DB_PASS, arr_pdo_attr());
} catch (PDOException $e) {
echo "ERROR: " . $e->getMessage();
}
$debugme = 0;
$form = get_form();
#miro si estoy ya en un team
$sdata = array($form["user"], $form["room"]);
$stmt = $dbh->prepare("select * from teams where user = ? and room = ? ");
$stmt->execute($sdata);
$rows = $stmt->fetch();
if ($rows["team_seed"]) {
#i'm on a team
$misala = $rows["team_seed"];
} else {
#miro si hay team en formacion para este room ?
$sdata = array($form["room"]);
$stmt = $dbh->prepare("select * from teams where room = ? and full = 0 ");
<?php
define("DB_ENGINE", "mysql");
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
define("DB_PORT", 3306);
define("CHAT_DB", "cpsx_chat");
define("EDXAPP_DB", "edxapp");
define("DB_PREFIX", "");
define('ENCRYPTION_KEY', 'S9kv9034kLAU0338dh2rfSFW3');
define("PDO_CHAT", sprintf("mysql:host=%s;port=%d;dbname=%s", DB_HOST, DB_PORT, CHAT_DB));
define("PDO_EDXAPP", sprintf("mysql:host=%s;port=%d;dbname=%s", DB_HOST, DB_PORT, EDXAPP_DB));
try {
$dbhchat = new PDO(PDO_CHAT, DB_USER, DB_PASS, arr_pdo_attr());
$dbhedxapp = new PDO(PDO_EDXAPP, DB_USER, DB_PASS, arr_pdo_attr());
} catch (PDOException $e) {
echo "ERROR: " . $e->getMessage();
}
// Return PDO:MySQL attributes
function arr_pdo_attr()
{
$arr_pdo_attrs = array(PDO::ATTR_AUTOCOMMIT => true, PDO::ATTR_EMULATE_PREPARES => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_ORACLE_NULLS => true, PDO::ATTR_PERSISTENT => false, PDO::ATTR_PREFETCH => true, PDO::ATTR_TIMEOUT => 10, PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8');
return $arr_pdo_attrs;
}
