Codigo php. Como diminui-lo
Parece ser simples, porem me deu branco geral e nao to conseguindo.
Preciso fazer varias buscas com a msm query.
Porem sempre uso array para fazer isso só que desta vez simplesmente nao consegui fazer funcionar.
Acho que é sono.
Então fiz assim.
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 855907;')->fetch();
if($vip == 0) {
$main_content .= 'SEM BOW SKILL<br />';
}else{
$main_content .= 'BOW SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 858931;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Sword SKILL<br />';
}else{
$main_content .= 'Sword SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 857429;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Wand SKILL<br />';
}else{
$main_content .= 'Wand SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 857410;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Rod SKILL<br />';
}else{
$main_content .= 'Rod SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 857421;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Club SKILL<br />';
}else{
$main_content .= 'Club SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 857433;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Axe SKILL<br />';
}else{
$main_content .= 'Axe SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 850000 ;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Haste SKILL<br />';
}else{
$main_content .= 'Haste SKILL<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 850001 ;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Exevo Mas Dead<br />';
}else{
$main_content .= 'Exevo Mas Dead<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 850002 ;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Ubber Gran Exori<br />';
}else{
$main_content .= 'Ubber Gran Exori<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 850003 ;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Exori Song<br />';
}else{
$main_content .= 'Exori Song<br />';
}
$vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = 850004 ;')->fetch();
if($vip == 0) {
$main_content .= 'SEM Exevo Frigo<br />';
}else{
$main_content .= 'Exevo Frigo<br />';
}
KEY = AQUI
Note que somente o AQUI muda em cada query.
Como posso fazer isso economizando codigo???
Alguem sugere algo ai
Discussão (6)
Carregando comentários...