luizinhf0x escreveu:Tipo queria criar uma super Gw.
mais queria uns scrypts pro site,
tipo,
nome da guild,
total de poles quebrados,

se alguém ai entender de php pode me passar uma dicas,
o resto eu me viro

Código:

DROP TABLE IF EXISTS `cq_guildwar`;
CREATE TABLE `cq_guildwar` (
  `id` int(10) NOT NULL auto_increment,
  `guildname` varchar(16) NOT NULL default '',
  `guildleader` varchar(16) NOT NULL default '',
  `sgw` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_id` (`id`)
) TYPE=MyISAM;

-- ----------------------------
-- Records of cq_guildwar
-- ----------------------------
INSERT INTO `cq_guildwar` VALUES ('1', 'Test', 'Test897[PM]', '0');
INSERT INTO `cq_guildwar` VALUES ('2', 'Testing', 'Test564[PM]', '1');

Código:

INSERT INTO `cq_action` VALUES ('0001', '0000', '0000', '0127', '0', 'INSERT INTO cq_guildwar set guildname="%syn_name", guildleader="%syn_leader", sgw="0"');

<?php
$connect = mysql_connect("localhost", "test", "test"); //host, user, pw respectivamente
$database = mysql_select_db("zf"); //database
?>

<?php
echo "<h1> Super Guild War Winners: </h1>";
echo "<hr>";
$sql = "select * from cq_guildwar where sgw=1 order by id desc";
$execute = mysql_query($sql);
while($exibir= mysql_fetch_array($execute)){;
echo "<strong>Guild Name: </strong>" .$exibir ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir ['guildleader'];
echo "<hr>";
}
?>

<?php
echo "<h1>Guild War Winners: </h1>";
echo "<hr>";
$sql1 = "select * from cq_guildwar where sgw=0 order by id desc";
$execute1 = mysql_query($sql1);
while($exibir1= mysql_fetch_array($execute1)){;
echo "<strong>Guild Name: </strong>" .$exibir1 ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir1 ['guildleader'];
echo "<hr>";
}
?>

<?php
echo "<h1>General Guild War Winners: </h1>";
echo "<hr>";
$sql2 = "select * from cq_guildwar order by id desc";
$execute2 = mysql_query($sql2);
while($exibir2= mysql_fetch_array($execute2)){;
echo "<strong>Guild Name: </strong>" .$exibir2 ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir2 ['guildleader'];
echo "<hr>";
}
?>

<?php
$connect = mysql_connect("localhost", "test", "test"); //host, user, pw respectivamente
$database = mysql_select_db("zf"); //database
?>
<?php
echo "<h1> Super Guild War Winners: </h1>";
echo "<hr>";
$sql = "select * from cq_guildwar where sgw=1 order by id desc";
$execute = mysql_query($sql);
while($exibir= mysql_fetch_array($execute)){;
echo "<strong>Guild Name: </strong>" .$exibir ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir ['guildleader'];
echo "<hr>";
}
?>

<?php
echo "<h1>Guild War Winners: </h1>";
echo "<hr>";
$sql1 = "select * from cq_guildwar where sgw=0 order by id desc";
$execute1 = mysql_query($sql1);
while($exibir1= mysql_fetch_array($execute1)){;
echo "<strong>Guild Name: </strong>" .$exibir1 ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir1 ['guildleader'];
echo "<hr>";
}
?>

<?php
echo "<h1>General Guild War Winners: </h1>";
echo "<hr>";
$sql2 = "select * from cq_guildwar order by id desc";
$execute2 = mysql_query($sql2);
while($exibir2= mysql_fetch_array($execute2)){;
echo "<strong>Guild Name: </strong>" .$exibir2 ['guildname'];
echo "<br>";
echo "<strong>Guild Leader: </strong>" .$exibir2 ['guildleader'];
echo "<hr>";
}
?>

pintinho12 escreveu:O video nao deu pra postar .-.
deu 1GB e 19 minutos XD
nao dava pra colocar no youtube (:
entaao *-*

vamos por parte

Código:

DROP TABLE IF EXISTS `cq_guildwar`;
CREATE TABLE `cq_guildwar` (
  `id` int(10) NOT NULL auto_increment,
  `guildname` varchar(16) NOT NULL default '',
  `guildleader` varchar(16) NOT NULL default '',
  `sgw` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_id` (`id`)
) TYPE=MyISAM;

-- ----------------------------
-- Records of cq_guildwar
-- ----------------------------
INSERT INTO `cq_guildwar` VALUES ('1', 'Test', 'Test897[PM]', '0');
INSERT INTO `cq_guildwar` VALUES ('2', 'Testing', 'Test564[PM]', '1');

mantenha os codes, ateh vc terminar, q eh pra vc ver se funciona mesmo(:
essa eh a tabela q vc vai precisar ^^
vamos para o code, qe vai inserir na tabela,
esse vc vai ter de testar ;s
pq se nao funcionar o %syn_leader, vamos ter de remover ^^
dai vc avisa q eu refaço
dai vai mostrar soh a guild vencedora '-'

Código:

INSERT INTO `cq_action` VALUES ('0001', '0000', '0000', '0127', '0', 'INSERT INTO cq_guildwar set guildname="%syn_name", guildleader="%syn_leader", sgw="0"');

Os ids sao de testes '-'
mais, coloque-o por ultimo, nos codes de quando se mata a pole
dai qndo alguem matar o pole vai registrar, isso ai vai registrar quem matou o pole
isso ai vai registrar quem matou o pole, vai dar pra servir de registro..
nao vai mostrar quem ganhou a gw '-'
isso ai ja eh outro script ^^

agora vamos criar, o.. codigo, q vai mostrar, os nomes das guilds
vamos fazer 3 ranks ..
1. Mostrar quem ganhou a super guild war
2. Mostrar quem ganhou as gw normal
3. Mostrar todos

cria, um arquivo php (:
insira isso
todos os codigos foram feito por mim manualmente no video .-.
q eu ja deletei por q tava ocupando mto espaço no meu HD XD

$connect = mysql_connect("localhost", "test", "test"); //host, user, pw respectivamente
$database = mysql_select_db("zf"); //database
?>

echo "

Super Guild War Winners:

";
echo "

---

";
$sql = "select * from cq_guildwar where sgw=1 order by id desc";
$execute = mysql_query($sql);
while($exibir= mysql_fetch_array($execute)){;
echo "Guild Name: " .$exibir ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir ['guildleader'];
echo "

---

";
}
?>

$sql = "select * from cq_guildwar where sgw=1 order by id desc";
entaao neah (: isso ai vc muda no sql, se for super gw, vc coloca no insert into, o sgw=1 se nao for deixa 0
esse ai, vai mostrar quem matou o pole na sgw
para mostrar qualquer coisa dentro de um php, eh usado echo "mensagem";
o code while, serve para ele repetir as mensagens, se voce kiser ver quem matou pela ultima vez, remova o while

echo "

Guild War Winners:

";
echo "

---

";
$sql1 = "select * from cq_guildwar where sgw=0 order by id desc";
$execute1 = mysql_query($sql1);
while($exibir1= mysql_fetch_array($execute1)){;
echo "Guild Name: " .$exibir1 ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir1 ['guildleader'];
echo "

---

";
}
?>

echo "

General Guild War Winners:

";
echo "

---

";
$sql2 = "select * from cq_guildwar order by id desc";
$execute2 = mysql_query($sql2);
while($exibir2= mysql_fetch_array($execute2)){;
echo "Guild Name: " .$exibir2 ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir2 ['guildleader'];
echo "

---

";
}
?>

assim, voce pode mostrar todos em uma mesma pagina ^^
os codes ficariam assim

$connect = mysql_connect("localhost", "test", "test"); //host, user, pw respectivamente
$database = mysql_select_db("zf"); //database
?>
echo "

Super Guild War Winners:

";
echo "

---

";
$sql = "select * from cq_guildwar where sgw=1 order by id desc";
$execute = mysql_query($sql);
while($exibir= mysql_fetch_array($execute)){;
echo "Guild Name: " .$exibir ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir ['guildleader'];
echo "

---

";
}
?>

echo "

Guild War Winners:

";
echo "

---

";
$sql1 = "select * from cq_guildwar where sgw=0 order by id desc";
$execute1 = mysql_query($sql1);
while($exibir1= mysql_fetch_array($execute1)){;
echo "Guild Name: " .$exibir1 ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir1 ['guildleader'];
echo "

---

";
}
?>

echo "

General Guild War Winners:

";
echo "

---

";
$sql2 = "select * from cq_guildwar order by id desc";
$execute2 = mysql_query($sql2);
while($exibir2= mysql_fetch_array($execute2)){;
echo "Guild Name: " .$exibir2 ['guildname'];
echo "
";
echo "Guild Leader: " .$exibir2 ['guildleader'];
echo "

---

";
}
?>

aqui a parte como ficou da db:





agora aqui a parte do site :



é parece que o "syn_leader" não deu certo !

pintinho12 escreveu:da pra colocar o nome do member q mato o pole XD

Código:

         mysql_select_db('zf');
         $res = mysql_query('SELECT count(id) FROM cq_guildwar;');
         $val = mysql_fetch_array($res);
         echo '<font color="#45BEFF", size="2px"> <b>Poles quebradas:</b> '.$val[0].'<br />';