Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const User = require('../models/Alliances')
- const findAlianca = async (connection, req, res) => {
- const Allianca = await User.find(connection, req.session.user.username)
- if (!Allianca) {
- res.status(404).send('Nenhuma cidade encontrada.');
- return;
- }
- console.log("dddd");
- req.session.Allianca = Allianca
- res.locals.Allianca = Allianca
- res.render('Administration/Alliances')
- }
- module.exports = {
- findAlianca
- }
- route aliance
- const express = require('express')
- const router = express.Router()
- const connection = require('../../Config/database')
- const controllerAdmin = require('../../controllers/Administration')
- const controlleruser = require('../../controllers/Alliances')
- router.get('/Administration/Alliances', (req, res) => controllerAdmin.findcidade3(connection, req, res))
- router.get('/Administration/Alliances/limitado', (req, res) => controlleruser.findAlianca(connection, req, res))
- module.exports = app => app.use('/', router)
- models aliance
- const find = (connection,username) => { return new Promise((resolve, reject) => { connection.query(SELECT alianca.nome,alianca.N_membros,alianca.TAG FROM user INNER JOIN alianca ON user.cod_alianca=alianca.id WHERE user.username='${username}', (err, result) => { if(err){ reject(err) }else{ resolve(result) } }) }) }
- module.exports = {
- find
- }
- alliance.jade
- extends layout
- block title
- .col-xs-6.col-xs-offset-3.col-sm-6.col-sm-offset-3
- .col-sm-4(style='width:76%')
- div.panel.panel-primary(style='height:50px') Alliances Page
- div.panel.panel-primary(style='height:700px') fdssdklfsdklfjskldfjkldsjfl
- if locals.user.cod_alianca==null
- p You Dont Have Alliances
- else
- br
- span Your Aliance
- span= locals.Allianca.nome
- .col-xs-2.panel-red(style='width:24%;height:100%;text-align:center')
- my app
- require('./routes/Administration/Alliances')(app)
- my connection db
- const mysql = require('mysql')
- const config = require( "./config.json" )
- const connection =mysql.createConnection({
- host:config.host,
- user:config.user,
- password:config.password,
- database:config.database,
- // port:config.port
- });
- connection.connect((err) =>{
- if(err){
- console.log(err)
- process.exit(0)
- }else{
- console.log('database on')
- }
- })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement