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) ));