Skip to content

Instantly share code, notes, and snippets.

View zr0n's full-sized avatar

Luiz Fernando zr0n

View GitHub Profile
INSERT INTO mdl_course_categories (id, name, idnumber, description, descriptionformat, parent, sortorder, coursecount, visible, visibleold, timemodified, depth, path, theme) VALUES (2, 'Técnico, operação e atendimento', null, '', 0, 0, 10000, 0, 1, 1, 1442871340, 1, '/2', null);
INSERT INTO mdl_course_categories (id, name, idnumber, description, descriptionformat, parent, sortorder, coursecount, visible, visibleold, timemodified, depth, path, theme) VALUES (3, 'Mandatórios, Jurídicos e SSMA', '', '', 1, 0, 60000, 0, 1, 1, 1442864674, 1, '/3', null);
INSERT INTO mdl_course_categories (id, name, idnumber, description, descriptionformat, parent, sortorder, coursecount, visible, visibleold, timemodified, depth, path, theme) VALUES (4, 'Produto e Conveniência', '', '', 1, 0, 50000, 0, 1, 1, 1442864632, 1, '/4', null);
INSERT INTO mdl_course_categories (id, name, idnumber, description, descriptionformat, parent, sortorder, coursecount, visible, visibleold, timemodified, depth, path, theme) VALUES (5, 'Crédito e Fin
UPDATE mdl_config_plugins
SET value = 2015113000
WHERE
plugin = "theme_wizard" AND name = "version";
INSERT INTO `mdl_coursemetadata_info_field` (`id`, `shortname`, `name`, `datatype`, `description`, `descriptionformat`, `categoryid`, `sortorder`, `required`, `locked`, `visible`, `forceunique`, `defaultdata`, `defaultdataformat`, `param1`, `param2`, `param3`, `param4`, `param5`)
VALUES
(7, 'paid', 'Pago: ', 'menu', 'Indica se o curso é pago ou não', 0, 1, 0, 0, 0, 0, 0, 'Não', 0, 'Sim\nNão', NULL, NULL, NULL, NULL),
(8, 'price', 'Preço: ', 'text', 'Indica o preço do curso pago. Ex: R$350,00 ', 0, 1, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL);
<?php
require_once("Banco.php");
class Cadastro extends Banco {
private $titulo;
private $categoria;
private $descricao;
private $endereco;
private $telefone;
private $celular;
private $upload;
<?php
require_once("Banco.php");
class Cadastro extends Banco {
private $titulo;
private $categoria;
private $descricao;
private $endereco;
private $telefone;
private $celular;
private $upload;
<?php
if ($_POST){
if ($_POST['pesquisar']){
include '../model/banco.php';
$usuario = $_POST['consultar'];
$Banco = new Banco();
$resultado = $Banco->consultar($usuario);
if ($resultado == true){
for ($i = 0; $i < mysqli_num_rows($resultado); $i++) {
<?php
if ($_POST){
if ($_POST['pesquisar']){
include '../model/banco.php';
$usuario = $_POST['consultar'];
$Banco = new Banco();
$resultado = $Banco->consultar($usuario);
if ($resultado == true){
for ($i = 0; $i < mysqli_num_rows($resultado); $i++) {
<?php
function calc_troco($pago, $conta){
$nota = array('100', '50', '10', '5', '1');
$centavos = array('50', '10', '5','1');
$troco = $pago - $conta;
$vlr = $troco;
for($i = 0; $i <= 4; $i++){
$ct = floor($vlr / $nota[$i]); // calculando a qtde de notas
if ($ct) {
@zr0n
zr0n / troco.php
Created April 24, 2017 02:29
Calcula o troco de um determinado valor
<?php
function modulo($num1, $num2 ){
$result = (($num1 / $num2) - floor($num1 / $num2)) * $num2;
return (float)number_format($result, 3, '.', '');
}
function calc_troco($pago, $conta){
$nota = array('100', '50', '10', '5', '1');
$centavos = array('50', '10', '5','1');
$troco = $pago - $conta;
<?php
include ('recaptchalib.php');
$to = 'alanzvinicius@gmail.com';
$subject = $_REQUEST['name'];
$email = $_REQUEST["email"];
$message = $_REQUEST['comments'] ;
$header = "from:$email\n";