Uprava PHP Scriptu Online hracu ( pridani profesi )

warring · March 29, 2011

Cawko nevite nekdo jak do tohoto scriptu přidat informace o to kdo ma jakou profesi ( 2 profese )

SCRIPT

<?php

/// Nstavení pristupu do DB \\\

/// Coded by Warring \\\ ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Online Hrači</title>

<!--

body

{

line-height: 1.2em;

}

#box-table-a

{

font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;

font-size: 12px;

margin: 45px;

text-align: center;

border-collapse: collapse;

}

#box-table-a th

{

font-size: 13px;

font-weight: normal;

padding: 4px;

background: #474747;

font-weight:bold;

border-right: 2px solid #fff;

border-left: 2px solid #fff;

border-bottom: 2px solid #fff;

color: #999999;

}

#box-table-a td

{

padding: 6px;

background: #d9d9d9;

border-bottom: 1px solid #fff;

color: #666666;

font-weight:bold;

border-right: 2px solid #fff;

border-left: 2px solid #fff;

border-top: 2px solid #fff;

text-shadow:1px 1px 0 #FFFFFF;

}

.cervena {color: #FF0000}

.zelena {color: #009900}

.modra {color: #0000FF}

-->

</style>

</head>

<body>

<thead>

<tr>

<th scope="col" style="min-width: 80px;">ID Postavy</th>

<th scope="col" style="min-width: 80px;">ID Accountu</th>

<th scope="col" style="min-width: 200px;">Postava</th>

<th scope="col" style="min-width: 80px;">Level</th>

<th scope="col" style="min-width: 80px;">Peníze</th>

<th scope="col" style="min-width: 80px;">Class</th>

<th scope="col" style="min-width: 80px;">Killy</th>

<th scope="col" style="min-width: 80px;">Honory</th>

<th scope="col" style="min-width: 80px;">Arena Pointy</th>

<th scope="col" style="min-width: 80px;">Latence</th>

</tr>

</thead>

<tbody>

<?php

$ip = "127.0.0.1";

$name = "root";

$heslo = "";

$chardb = "characters";

mysql_connect("$ip", "$name", "$heslo") or die("Nelze se připojit k MySQL: " . mysql_error());

mysql_select_db("$chardb") or die("Nelze vybrat databázi: ". mysql_error());

mysql_query("SET NAMES 'utf8';");

$vysledek=mysql_query("select * from characters where online = '1' order by name ");

$radku=mysql_num_rows($vysledek);

$i=1;

while ($zaznam=MySQL_Fetch_Array($vysledek)):

echo "<tr>";

echo '<td>'.$zaznam["guid"]."</td>";

echo '<td>'.$zaznam["account"]."</td>";

echo '<td>'.$zaznam["name"]."</td>";

if($zaznam["level"]<=80) echo "<td>".$zaznam["level"]."</td>"; else echo "<td><span class='zelena'>GameMaster</span></td>";

if($zaznam["health"]<=1000000) echo "<td>".$zaznam["health"]."</td>"; else echo "<td><span class='modra'>Nad Milion Hp</span></td>";

echo "<td>".$zaznam["money"] / 10000 ." <SUB><img src=img/gold.png width='13' height='13'></SUB></td>";

echo "<td>"."<img src=img/".$zaznam["race"]."-".$zaznam["gender"].".gif>"."</td>";

echo "<td>"."<img src=img/".$zaznam["class"].".gif>"."</td>";

if($zaznam["totalKills"]<=1000) echo "<td>".$zaznam["totalKills"]."</td>"; else echo "<td><span class='cervena'>Monster Killer </span><span class='zelena'><SUB><SUP>1000+</SUP></SUB></span></td>";

if($zaznam["totalHonorPoints"]<=75000) echo "<td>".$zaznam["totalHonorPoints"]."</td>"; else echo "<td><span class='cervena'>Full Honory </span><span class='zelena'><SUB><SUP>75000</SUP></SUB></span></td>";

echo "<td>".$zaznam["arenaPoints"]."</td>";

echo "<td>".$zaznam["latency"]."</td>";

echo "</tr>";

$i++;

endwhile;

?>

</tbody>

</table>

</body>

</html>

Vse funguje jak má ale chce to tak jeste pridat ty dve profese

Jedná se o Jádro TC2

Wardenicek · March 29, 2011

Proč hledat složitě když to jde jednoduše. Pokud vidim dobře Coded by Warring, tzn. že počítám, že znalosti v php máš když si to tedy dělal sám a nevidím důvod proč bys tedy nedokázal připsat další výpis dat z DB pomocí s¨svojí DB či wiki -> http://www.trinitycore.org/w/DB:Characters a upravil to pomocí switch funkce z číselné hodnoty na slovní stejně jako je to u class, race

warring · March 29, 2011

Díky warde nakopnul jsi mne do práce a poradil jako vždy davam +rep

Sakra nejde mi to

Mohl by ses na to kouknout ?

a případně dopsat ?

Edited March 29, 2011 by warring

Wolf Officious · March 29, 2011

Profese jsou vlastně naučený spelly, ne? Takže bych je hledal v týhle tabulce http://www.trinitycore.org/w/Character_spell_tc2

Dá se to napsat celkem jednoduše, škoda že mám málo času.

warring · March 29, 2011

da jednoduše ale ja s php nedělám moc dlouho sem tam neakej low script ale s profesemi to tu ještě nebylo

ntdrt · March 29, 2011

Pomoci spellu to sice taky jde ale elegantnejsi reseni je pomoci skillu.

Kdyz si podle wowheadu najdes IDcka skillu a k nim pripises nazev profese klidne ti to sepisi. To je otazka pul minuty, ale na to hledani Idcek cas nemam.

Tabulka: http://www.trinitycore.org/w/Character_skills_tc2

Edited March 29, 2011 by ntdrt

Wolf Officious · March 29, 2011

Jo, to je vlastně taky fakt.. A jejich seznam je tam odkazovanej.. http://www.trinitycore.org/w/SkillLine.dbc_tc2

ntdrt · March 29, 2011

Jedna z mnoha moznosti:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
   <meta http-equiv="content-type" content="text/html; charset=utf-8" />
   <meta http-equiv="content-language" content="cz-cs" />
   <meta name="author" content="code by Tomáš Kolinger, design by n/a" />
   <meta name="description" content="DESCRIPTION" />
   <meta name="keywords" content="KEYWORDS" />
   <meta name="copyright" content="2011, Tomáš Kolinger" />
   <meta name="robots" content="index, follow" />
   <title>Online hráči</title>
 </head>
 <body>
   <table>
     <tr><th>ID Postavy</th><th>ID Účtu</th><th>Jméno</th><th>Rasa</th><th>Povolání</th><th>Level</th><th>Profese</th></tr>
     <?php
       mysql_connect("localhost", "local", "local");
       mysql_select_db("tc_characters");

       $races = array(
         1  => "human",
         2  => "orc",
         3  => "dwarf",
         4  => "night elf",
         5  => "undead",
         6  => "tauren",
         7  => "gnome",
         8  => "troll",
         10 => "blood elf",
         11 => "draene",
       );
       $classes = array(
         1  => "warrior",
         2  => "paladin",
         3  => "hunter",
         4  => "rogue",
         5  => "priest",
         6  => "death knight",
         7  => "shaman",
         8  => "mage",
         9  => "warlock",
         11 => "druid",
       );  
       $proffesionsNames = array(
         129 => "First Aid",
         164 => "Blacksmithing",
         165 => "Leatherworking",
         171 => "Alchemy",
         182 => "Herbalism",
         185 => "Cooking",
         186 => "Mining",
         197 => "Tailoring",
         202 => "Engineering",
         333 => "Enchanting",
         356 => "Fishing",
         393 => "Skinning",
         755 => "Jewelcrafting",
         773 => "Inscription",
       );       
       $proffesionsList = array_flip($proffesionsNames); 
       $proffesionsList = implode(", ", $proffesionsList);                         
       $characters = mysql_query("SELECT guid, account, name, race, class, level FROM characters WHERE online = 1");
       while($character = mysql_fetch_assoc($characters)){
         $proffesions = mysql_query("SELECT skill, value FROM character_skills WHERE skill IN(".$proffesionsList.") AND guid = ".$character["guid"]);
         echo "<tr>";
         echo "<td>".$character["guid"]."</td>";
         echo "<td>".$character["account"]."</td>";
         echo "<td>".$character["name"]."</td>";
         echo "<td>".$races[$character["race"]]."</td>";
         echo "<td>".$classes[$character["class"]]."</td>";
         echo "<td>".$character["level"]." lvl</td>";
         echo "<td>";
         while($proffesion = mysql_fetch_assoc($proffesions)){
           echo $proffesionsNames[$proffesion["skill"]]."(".$proffesion["value"].") ";
         }
         echo "</td>";
         echo "</tr>\n";
       }
     ?>
   </table>
 </body>
</html>

Ten dotaz by chtel ale nejak upravit, mozna sloucit s tim prvnim - trochu optimalizace ale uz musim jit pracovat.

BTW: NETESTOVANO! Nemam pri ruce databazi kde by nekdo mel profese.. Ale na 95% to fungovat bude.

Edited March 29, 2011 by ntdrt

warring · March 29, 2011

mohl by jsi mi to dat do textaku nebo dat do code

mne nejdou ty spoilery otevirat

Díky

ntdrt · March 29, 2011

Urcite, tady to mas.

BTW: ma telefonu me taky spoiler nefunguje, mozna by to chtelo pouzit jiny script - teda ne mozna ale urcite.

online: http://source.tomas-kolinger.eu/~47/

link #1: http://storage.tomas-kolinger.eu/online-hraci.phps

link #2: online-hraci.php

Edited March 29, 2011 by ntdrt

warring · March 29, 2011

ten script hazi error sice sem nepochopil chybu na řádku 64

$proffesions = mysql_query("SELECT skill, value FROM character_skills WHERE skill IN($proffesionsList) AND guid = ".$character["guid"]);

ale i přes cca 140 pokusu zakomponovat do meho scriptu profese to vzdy padlo neśpěchem chce to wladasse nebo wardika

ntdrt · March 29, 2011

Script ktery jsem napsal me funguje bez problemu. Takze chyba bude jinde.

Jinak kdyby si napsal jaky script a jaka chyba to je tak by to slo resit mnohem lepe a hned.

BTW: Nemyslim si ze Wladass a nebo Wardik vi vice. Zkus to pochopit jak to funguje a hlavne se nauc cist chyby, neber radky ale spise obsah chyby, pokud neumis anglicky muzes pouzit nejaky translator.

warring · March 29, 2011

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\indexx.php on line 64

ntdrt · March 29, 2011

Mas tam napsany nejaky text do PHPcka. Postni sem tvuj kod.

warring · March 30, 2011

MŮJ KOD - BEZ CHYBY

<?php
/// Nstavení pristupu do DB \\\
/// Coded by Warring	 \\\ ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Online Hrači</title>
<style type="text/css">
<!--
body
{
line-height: 1.2em;
}

#box-table-a
{
font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;
font-size: 12px;
margin: 45px;
text-align: center;
border-collapse: collapse;
}
#box-table-a th
{
font-size: 13px;
font-weight: normal;
padding: 4px;
background: #474747;
font-weight:bold;
border-right: 2px solid #fff;
border-left: 2px solid #fff;
border-bottom: 2px solid #fff;
color: #999999;
}
#box-table-a td
{
padding: 6px;
background: #d9d9d9; 
border-bottom: 1px solid #fff;
color: #666666;
font-weight:bold;
border-right: 2px solid #fff;
border-left: 2px solid #fff;
border-top: 2px solid #fff;
text-shadow:1px 1px 0 #FFFFFF;
}
.cervena {color: #FF0000}
.zelena {color: #009900}
.modra {color: #0000FF}
-->
</style>
</head>

<body>
<table id="box-table-a">
<thead>
<tr>
<th scope="col" style="min-width: 80px;">ID Postavy</th>
<th scope="col" style="min-width: 80px;">ID Accountu</th>
<th scope="col" style="min-width: 99px;">Postava</th>
<th scope="col" style="min-width: 80px;">Level</th>
<th scope="col" style="min-width: 80px;">HP</th>
<th scope="col" style="min-width: 80px;">Peníze</th>
<th scope="col" style="min-width: 80px;">Race</th>
<th scope="col" style="min-width: 80px;">Class</th>
<th scope="col" style="min-width: 80px;">Killy</th>	
<th scope="col" style="min-width: 80px;">Honory</th>	
<th scope="col" style="min-width: 80px;">Arena Pointy</th>	
<th scope="col" style="min-width: 80px;">Latence</th>
</tr>
</thead>
<tbody>
<?php
$ip = "127.0.0.1";
$name = "root";
$heslo = "";
$chardb = "characters";
mysql_connect("$ip", "$name", "$heslo") or die("Nelze se připojit k MySQL: " . mysql_error());
mysql_select_db("$chardb") or die("Nelze vybrat databázi: ". mysql_error()); 
mysql_query("SET NAMES 'utf8';");

$vysledek=mysql_query("select * from characters where online = '1' order by name ");
$radku=mysql_num_rows($vysledek);
$i=1;
while ($zaznam=MySQL_Fetch_Array($vysledek)):
echo "<tr>";
echo '<td>'.$zaznam["guid"]."</td>";
echo '<td>'.$zaznam["account"]."</td>";
echo '<td>'.$zaznam["name"]."</td>";
if($zaznam["level"]<=80)	echo "<td>".$zaznam["level"]."</td>"; else echo "<td><span class='zelena'>GameMaster</span></td>";
if($zaznam["health"]<=999999)	echo "<td>".$zaznam["health"]."</td>"; else echo "<td><span class='zelena'>Moc </span><SUB><SUP><span class='cervena'>1.000.000+</SUP></SUB></span></td>";
if($zaznam["money"] <=1999999999)	echo "<td>".$zaznam["money"]/ 10000 ." G</td>"; else echo "<td><span class='zelena'>Moc</span> <SUB><SUP><span class='cervena'>200.000+</SUP></SUB></span></td>";
echo "<td>"."<img src=img/".$zaznam["race"]."-".$zaznam["gender"].".gif>"."</td>";
echo "<td>"."<img src=img/".$zaznam["class"].".gif>"."</td>";
if($zaznam["totalKills"]<=1000)	echo "<td>".$zaznam["totalKills"]."</td>"; else echo "<td><span class='cervena'>Monster Killer </span><span class='zelena'><SUB><SUP>1000+</SUP></SUB></span></td>";
if($zaznam["totalHonorPoints"]<=75000)	echo "<td>".$zaznam["totalHonorPoints"]."</td>"; else echo "<td><span class='cervena'>Full Honory </span><span class='zelena'><SUB><SUP>75000</SUP></SUB></span></td>";
echo "<td>".$zaznam["arenaPoints"]."</td>";
echo "<td>".$zaznam["latency"]."</td>";
echo "</tr>";
$i++;
endwhile;

?>
</tbody>
</table>
</body>
</html>

STAŽENÝ KOD Z TOHOTO TEAMA S PODPOROU PROFESI - HAZI ERROR

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
   <meta http-equiv="content-type" content="text/html; charset=utf-8" />
   <meta http-equiv="content-language" content="cz-cs" />
   <meta name="author" content="code by Tomáš Kolinger, design by n/a" />
   <meta name="description" content="DESCRIPTION" />
   <meta name="keywords" content="KEYWORDS" />
   <meta name="copyright" content="2011, Tomáš Kolinger" />
   <meta name="robots" content="index, follow" />
   <title>Online hráči</title>
 </head>
 <body>
   <table>
     <tr><th>ID Postavy</th><th>ID Účtu</th><th>Jméno</th><th>Rasa</th><th>Povolání</th><th>Level</th><th>Profese</th></tr>
     <?php
       mysql_connect("127.0.0.1", "root", "123456");
       mysql_select_db("characters");

       $races = array(
         1  => "human",
         2  => "orc",
         3  => "dwarf",
         4  => "night elf",
         5  => "undead",
         6  => "tauren",
         7  => "gnome",
         8  => "troll",
         10 => "blood elf",
         11 => "draene",
       );
       $classes = array(
         1  => "warrior",
         2  => "paladin",
         3  => "hunter",
         4  => "rogue",
         5  => "priest",
         6  => "death knight",
         7  => "shaman",
         8  => "mage",
         9  => "warlock",
         11 => "druid",
       );  
       $proffesionsNames = array(
         129 => "First Aid",
         164 => "Blacksmithing",
         165 => "Leatherworking",
         171 => "Alchemy",
         182 => "Herbalism",
         185 => "Cooking",
         186 => "Mining",
         197 => "Tailoring",
         202 => "Engineering",
         333 => "Enchanting",
         356 => "Fishing",
         393 => "Skinning",
         755 => "Jewelcrafting",
         773 => "Inscription",
       );      
       $proffesionsList = array_flip($proffesionsNames);
       $proffesionsList = implode(", ", $proffesionsList);                        
       $characters = mysql_query("SELECT guid, account, name, race, class, level FROM characters WHERE >);
       while($character = mysql_fetch_assoc($characters)){
         $proffesions = mysql_query("SELECT skill, value FROM character_skills WHERE skill IN($proffesionsList) AND guid = ".$character["guid"]);
         echo "<tr>";
         echo "<td>".$character["guid"]."</td>";
         echo "<td>".$character["account"]."</td>";
         echo "<td>".$character["name"]."</td>";
         echo "<td>".$races[$character["race"]]."</td>";
         echo "<td>".$classes[$character["class"]]."</td>";
         echo "<td>".$character["level"]." lvl</td>";
         echo "<td>";
         while($proffesion = mysql_fetch_assoc($proffesions)){
           echo $proffesionsNames[$proffesion["skill"]]."(".$proffesion["value"].") ";
         }
         echo "</td>";
         echo "</tr>\n";
       }
     ?>
   </table>
 </body>
</html>

ERROR NA ŘÁDKU 64

$proffesions = mysql_query("SELECT skill, value FROM character_skills WHERE skill IN($proffesionsList) AND guid = ".$character["guid"]);

VYPSANÝ ERROR

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\indexx.php on line 64

Hkarta · March 30, 2011

AND guid = ".$character["guid"].");

případně

AND guid = $character[guid]);

ntdrt · March 30, 2011

Chyba je jasna a je tady, v :

$characters = mysql_query("SELECT guid, account, name, race, class, level FROM characters WHERE >);

Umazal si kus SQL dotazu:

$characters = mysql_query("SELECT guid, account, name, race, class, level FROM characters WHERE online = 1");

Takze chyba neni u me ale jak jsem rikal u tebe, nemuzes jen tak neco umazat -.-.

Viz funkcni kod: http://source.tomas-kolinger.eu/~47/

TO Hkarta:

Obe moznosti co jsi napsal skonci syntax chybou - jsou spatne.

AND guid = ".$character["guid"]."); - retezec ukoncis, vlozis promenou z pole a zacinas dalsi retezec ktery neni ukonceny

AND guid = $character[guid]); - uplna blbost, neukonceni retezce, navic text bez uvozovek ci apostrofu je bran jako definice...

warring · March 31, 2011

kamarade ten script nejde mam ho stazeny nahozeny a haze porad tem samy error !!!

ntdrt · March 31, 2011

To ti moc nepomuzu. Script je napsab dobre a neni tam chyba natoz kupa chyb.

Priste dodej tvuj zdrojak co ti ty chyby hazi.

Clou · March 31, 2011

Napíše sem tedy někdo celý funkční script? Docela by se mi to hodilo pro jeden WoW server

ntdrt · March 31, 2011

funkcni script mas nahore, viz moje prispevky, to jen tady warring s tim strasne zapasi

Sign In

Announcements

Pravidlo pro postování v TTT

Seznam návodů a důležitých témat v této sekci

Příspěvky tam, kde nemají co dělat

Používání spoilerů

Uprava PHP Scriptu Online hracu ( pridani profesi )

Recommended Posts

warring 55

Share this post

Link to post

Share on other sites

Wardenicek 288

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

Wolf Officious 1382

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

Wolf Officious 1382

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites

Hkarta 584

Share this post

Link to post

Share on other sites

ntdrt 29

Share this post

Link to post

Share on other sites

warring 55

Share this post

Link to post

Share on other sites