function get_message()
{
$model = $this->getModel('main');
$message = $model->get_message();
echo Json_encode($message);
}
<?php
$x = '
<div class="canvas_bg" id = "gamecanvas" style = "width:498px;
margin:0 auto;
border : 1px red solid;
">
<div id="leave">Log Out</div>
</div>
';
// include 'config.php';
//include 'messages.php';
//include 'view_003.php';
echo Json_encode($x);
?>
$connection= mysql_connect("localhost","root","root") or die("Connection Failed".mysql_error());
mysql_select_db("school",$connection)or die("Error loading the DataBase".mysql_error());
$tipoAsam = htmlentities($_POST["asamblea"], ENT_QUOTES);
$fecha = htmlentities($_POST["fecha"], ENT_QUOTES);
$horaIni = htmlentities($_POST["horaInit"], ENT_QUOTES);
$horaFin = htmlentities($_POST["horaFin"], ENT_QUOTES);
$idAsam = $_POST["asamId"];
if(!isset($idAsam)){
$query = sprintf("INSERT INTO asamblea (horaIni,horaFin,fecha,tipo_asamblea,abierta) values ('%s','%s','%s','%s',0)",
mysql_real_escape_string($horaIni),
mysql_real_escape_string($horaFin),
mysql_real_escape_string($fecha),
mysql_real_escape_string($tipoAsam)
);
$rs = mysql_query($query);
echo Json_encode(array(
"success" => mysql_errno() == 0,
"msg" => mysql_errno() == 0?"La asamblea del $fecha por $tipoAsam <br/>a sido creada correctamente":mysql_error()
));
}else{
$results = mysql_query("DELETE FROM asamblea WHERE id =$idAsam");
echo Json_encode(array(
"success" => mysql_errno() == 0,
"msg" => mysql_errno() == 0?"Asamblea eliminada correctamente":mysql_error()
));
}
function work_reprocessor()
{
$building_id = JRequest::getVar('building_id');
$quantity = JRequest::getVar('quantity');
$type = JRequest::getVar('type');
$line = JRequest::getVar('line');
$now = time();
$db = JFactory::getDBO();
$sql = "SELECT * FROM #__jigs_objects WHERE id = " . $type;
$db->setQuery($sql);
$product = $db->loadObject();
$user = JFactory::getUser();
$name = $product->name;
$description = $product->description;
$level = $product->level;
$man_time = $product->man_time;
$metal_1 = $product->metal_1;
$quantity_1 = $quantity * $product->quantity_1;
$metal_2 = $product->metal_2;
$quantity_2 = $quantity * $product->quantity_2;
$query = "SELECT id FROM #__jigs_inventory WHERE item_id = {$type} AND player_id = " . $user->id;
$db->setQuery($query);
$player_items = $db->loadAssocList();
$player_items_count = count($player_items);
$model = JModel::getInstance('jigs', 'BattleModel');
$energy_required = $quantity * 1;
if (!$model->use_battery($building_id, $energy_required)) {
$system_status['energy'] = 0;
$system_status['success'] = 0;
$message = "Not enough Energy";
$system_status['message'] = Json_encode($message);
return $system_status;
} else {
$system_status['energy'] = 1;
$system_status['success'] = 1;
}
if ($player_items_count > $quantity) {
//$finished = $now + ($quantity * $man_time * 60 );
$finished = $now + 1 * 1 * 160;
$sql = "INSERT INTO #__jigs_reprocessors (building, type_name, type_quantity, line, metal1, metal2, quantity_1, quantity_2, timestamp, finished)\n VALUES ({$building_id}, '{$name}',{$quantity}, {$line}, {$metal_1},{$metal_2}, {$quantity_1},{$quantity_2}, {$now}, {$finished} )\n ON DUPLICATE KEY UPDATE metal1 = {$metal_1}, metal2 = {$metal_2}, quantity_1 ={$quantity_1}, quantity_2 = {$quantity_1} ,timestamp = {$now}, finished = {$finished}";
$db->setQuery($sql);
$db->query();
$sql2 = "DELETE FROM #__jigs_inventory\n WHERE item_id = {$type}\n AND player_id = {$user->id}\n LIMIT {$quantity}";
$db->setQuery($sql2);
$db->query();
$system_status['count'] = 1;
$system_status['success'] = 1;
//$message = $sql;
$message = "Reprocessing system executed";
$system_status['message'] = Json_encode($message);
} else {
$system_status['count'] = 0;
$system_status['success'] = 0;
$message = "Not enough items in stock";
$system_status['message'] = Json_encode($message);
}
return $system_status;
}
function add_hacking()
{
$model = $this->getModel('main');
$message = $model->add_hacking();
echo Json_encode($message);
}
<?php
$connection= mysql_connect("localhost","root","root") or die("Connection Failed".mysql_error());
mysql_select_db("school",$connection)or die("Error loading the DataBase".mysql_error());
$data = array();
$result = mysql_query("SELECT * FROM estudiantes");
while($row = mysql_fetch_array($result)){
array_push($data,array(
"id" => $row["matricula"],
"nombre" => $row["nombre"]." ".$row["nombre_enmedio"]." ".$row["apellido"],
"carrera" => $row["carrera"],
"semestre"=> $row["semestre"],
"faltas" => $row["num_faltas"],
"ac" => $row["acreditado"],
"mail" => $row["email"]
));
}
echo Json_encode(array(
"success" => true,
"data" => $data
));
function work_flat()
{
$model = $this->getModel('building');
$result = $model->work_flat();
echo Json_encode($result);
}
<?php
@session_start();
require_once getcwd() . '/SqlFuncProc/SqlFuncProc.php';
$order = $_REQUEST['order'];
$param = $_REQUEST['param'];
$func = SqlFuncProc::getInstance($_SESSION['cfg']['SQL_CONN'], $_SESSION['cfg']['SQL_USER'], $_SESSION['cfg']['SQL_PASS']);
if ($order == 'getUsers') {
$data = $func->runFunc("get_users", array('%', '%', '%', $_SESSION['user']['id']), false, true);
echo Json_encode($data);
}
if ($order == 'setUser') {
$data = $func->runProc("set_user", array($param['peer_id'], $_SESSION['user']['id']), true);
if ($data[0] == "00000") {
echo Json_encode('success');
} else {
echo Json_encode('default');
}
}
function initialise($options)
{
// Get the options as a JObject for easier handling.
$options = JArrayHelper::toObject($options, 'JObject');
// Ensure a database type was selected.
if (empty($options->db_type)) {
$this->setError(JText::_('validType'));
return false;
}
// Ensure that a valid hostname and user name were input.
if (empty($options->db_host) || empty($options->db_user)) {
$this->setError(JText::_('validDBDetails'));
return false;
}
// Ensure that a database name was input.
if (empty($options->db_name)) {
$this->setError(JText::_('emptyDBName'));
return false;
}
// Validate database table prefix.
if (!preg_match('#^[a-zA-Z]+[a-zA-Z0-9_]*$#', $options->db_prefix)) {
$this->setError(JText::_('MYSQLPREFIXINVALIDCHARS'));
return false;
}
// Validate length of database table prefix.
if (strlen($options->db_prefix) > 15) {
$this->setError(JText::_('MYSQLPREFIXTOOLONG'));
return false;
}
// Validate length of database name.
if (strlen($options->db_name) > 64) {
$this->setError(JText::_('MYSQLDBNAMETOOLONG'));
return false;
}
// If the database is not yet created, create it.
if (empty($options->db_created)) {
// Get a database object.
$db =& $this->getDbo($options->db_type, $options->db_host, $options->db_user, $options->db_pass, null, $options->db_prefix, false);
// Check for errors.
if (JError::isError($db)) {
$this->setError(JText::sprintf('WARNNOTCONNECTDB', $db->toString()));
return false;
}
// Check for database errors.
if ($err = $db->getErrorNum()) {
$this->setError(JText::sprintf('WARNNOTCONNECTDB', $db->getErrorNum()));
return false;
}
// Check database version.
$db_version = $db->getVersion();
if (($position = strpos($db_version, '-')) !== false) {
$db_version = substr($db_version, 0, $position);
}
if (!version_compare($db_version, '5.0.4', '>=')) {
$this->setError(JText::_('You need MySQL 5.0.4 or higher to continue the installation.'));
return false;
}
// Check utf8 support.
$utfSupport = $db->hasUTF();
// Try to select the database
if (!$db->select($options->db_name)) {
// If the database could not be selected, attempt to create it and then select it.
if ($this->createDatabase($db, $options->db_name, $utfSupport)) {
$db->select($options->db_name);
} else {
$this->setError(JText::sprintf('WARNCREATEDB', $options->db_name));
return false;
}
} else {
// Set the character set to UTF-8 for pre-existing databases.
$this->setDatabaseCharset($db, $options->db_name);
}
// Should any old database tables be removed or backed up?
if ($options->db_old == 'remove') {
// Attempt to delete the old database tables.
if (!$this->deleteDatabase($db, $options->db_name, $options->db_prefix)) {
$this->setError(JText::_('WARNDELETEDB'));
return false;
}
} else {
// If the database isn't being deleted, back it up.
if (!$this->backupDatabase($db, $options->db_name, $options->db_prefix)) {
$this->setError(JText::_('WARNBACKINGUPDB'));
return false;
}
}
// Set the appropriate schema script based on UTF-8 support.
$type = $options->db_type;
if ($utfSupport) {
$schema = 'sql/' . ($type == 'mysqli' ? 'mysql' : $type) . '/joomla.sql';
} else {
$schema = 'sql/' . ($type == 'mysqli' ? 'mysql' : $type) . '/joomla_backward.sql';
}
// Attempt to import the database schema.
if (!$this->populateDatabase($db, $schema)) {
$this->setError(JText::sprintf('Instl_Error_DB', $this->getError()));
return false;
}
// Load the localise.sql for translating the data in joomla.sql/joomla_backwards.sql
$dblocalise = 'sql/' . ($type == 'mysqli' ? 'mysql' : $type) . '/localise.sql';
if (JFile::exists($dblocalise)) {
if (!$this->populateDatabase($db, $dblocalise)) {
$this->setError(JText::sprintf('Instl_Error_DB', $this->getError()));
return false;
}
}
// Handle default backend language setting. This feature is available for localized versions of Joomla 1.5.
$app =& JFactory::getApplication();
$languages = $app->getLocaliseAdmin();
if (in_array($options->language, $languages['admin']) || in_array($options->language, $languages['site'])) {
// Build the language parameters for the language manager.
$params = array();
if (in_array($options->language, $languages['admin'])) {
$params['administrator'] = $options->language;
}
if (in_array($options->language, $languages['site'])) {
$params['site'] = $options->language;
}
$params = Json_encode($params);
// Update the language settings in the language manager.
$db->setQuery('UPDATE `#__extensions`' . ' SET `params` = ' . $db->Quote($params) . ' WHERE `element`="com_languages"');
// Check for errors.
if ($db->getErrorNum()) {
$this->setError($db->getErrorMsg());
$return = false;
}
}
}
return true;
}
<?php
$connection= mysql_connect("localhost","root","root") or die("Connection Failed".mysql_error());
mysql_select_db("school",$connection)or die("Error loading the DataBase".mysql_error());
$matricula = htmlentities($_POST["matricula"], ENT_QUOTES);
$nombre = htmlentities($_POST["nombre"], ENT_QUOTES);
$mi = htmlentities($_POST["iniNombre"], ENT_QUOTES);
$apellido = htmlentities($_POST["apellido"], ENT_QUOTES);
$email = htmlentities($_POST["email"], ENT_QUOTES);
$carrera = htmlentities($_POST["carrera"], ENT_QUOTES);
$semestre = htmlentities($_POST["semestre"], ENT_QUOTES);
$query = sprintf("INSERT INTO estudiantes (matricula,nombre,nombre_enmedio,apellido,email,carrera,semestre,num_faltas,acreditado) VALUES (%d,'%s','%s','%s','%s','%s',%d,0,0)",
mysql_real_escape_string($matricula),
mysql_real_escape_string($nombre),
mysql_real_escape_string($mi),
mysql_real_escape_string($apellido),
mysql_real_escape_string($email),
mysql_real_escape_string($carrera),
mysql_real_escape_string($semestre)
);
$rs = mysql_query($query);
echo Json_encode(array(
"success" => mysql_errno() == 0,
"msg" => mysql_errno() == 0?"El estudiante con matricula $matricula, <br/> fue agregado correctamente.":mysql_error()
));
<?php
include "connexion.inc.php";
//var_dump(file_get_contents("php://input"));
//$data = json_decode(file_get_contents("php://input"));
//$age=$data->age;
$q1 = $conn->query("select * from phone");
$users = array();
$first = mysqli_fetch_array($q1);
echo '[';
$premier["id"] = $first["id"];
$premier["age"] = $first["age"];
$premier["name"] = $first["name"];
$premier["snippet"] = $first["snippet"];
echo Json_encode($premier);
while ($output = mysqli_fetch_array($q1)) {
echo ",";
$json["id"] = $output["id"];
$json["age"] = $output["age"];
$json["name"] = $output["name"];
$json["snippet"] = $output["snippet"];
echo Json_encode($json);
}
echo ']';
$results = mysql_query("SELECT * FROM estudiantes WHERE matricula = $matricula");
$existe = mysql_num_rows($results);
if($existe == 1){
$rs = mysql_query("INSERT INTO asam_estud (id_estudiante,id_asamblea,presente) VALUES ($matricula,$asId,1)");
while($row = mysql_fetch_array($results)){
$name = $row["nombre"] ." ". $row["apellido"];
}
echo Json_encode(array(
"success" => mysql_errno() == 0,
"msg" => mysql_errno() == 0?"Nombre: $name <br/>Matricula: $matricula asamblea $horaFin":mysql_error(),
));
}else{
echo Json_encode(array(
"success" => false,
"msg" => "No se encontro el usuario <br/>con la matricula $matricula.$abierta"
));
}
}//*/
}
function isOpen($horaFinal){
$termina = "no";
$time = time();
$now = date("g:i A",$time);
$meridianoFin = "$horaFinal[6]$horaFinal[7]";
$hFinal = "$horaFinal[0]$horaFinal[1]";
$mFinal = "$horaFinal[3]$horaFinal[4]";
$meridianoHoy = date("A",$time);
$hNow = date("g",$time);
$mNow = date("i",$time);
<?php
$connection= mysql_connect("localhost","root","root") or die("Connection Failed".mysql_error());
mysql_select_db("school",$connection)or die("Error loading the DataBase".mysql_error());
$start = isset($_POST['start'])?$_POST['start']:0;//posición a iniciar
$limit = isset($_POST['limit'])?$_POST['limit']:10;//número de registros que seran mostrados
$record = $_POST["records"];//recor del cual se hara la busqueda
$data = array();
$result = mysql_query("SELECT * FROM estudiantes WHERE nombre LIKE '%$record%' OR apellido LIKE '%$record%' OR nombre_enmedio LIKE '%$record%' OR carrera LIKE '%$record%' ");
while($row = mysql_fetch_array($result)){
array_push($data,array(
"id" => $row["matricula"],
"nombre" => $row["nombre"]." ".$row["nombre_enmedio"]." ".$row["apellido"],
"carrera" => $row["carrera"],
"semestre"=> $row["semestre"],
"faltas" => $row["num_faltas"],
"ac" => $row["acreditado"],
"mail" => $row["email"]
));
}
echo Json_encode(array(
"success" => true,
"total" => count($data),
"data" => array_splice($data,$start,$limit)
));
