Icemystic

dakujem odomna mas velke +rep :)aspon vidim ze nie kazdy je namysleny a obcas sa najde aj ochotny clovek co pomvoze dakujem

dakujem no stym css sa skusim dako pohrat iked manualne som to este nerobil ale dajak sa stoho vysomarim len este mensia otazka ako to pripojim na DB lebo pokial zo zakladou viem potrebuje to confing alebo priame nastavanie pristupov do db len tuto to nikde nevidim asi som fakt lama na php

jo len hacek je vtom ze ramecky a template viem spravit no zo scriptovania som total vypatlany ako nahodit scripty do stranky viem len mam problem z ich tvorbov a css kom

PREPAC OSPRAVEDLNUJEM SA ALE NEMOHOL SOM VEDET ZE TO OKOPIROVAL JA SOM TO PAK PREROBIL FAKT PREPAC ALE TVOJ DESING NEMA CHYBU ps prepac zapol sa mi capslock

tak namna sa nehnevaj mne to dal kamarat a proste takto kukaj a ja som to upravil na toto

tak tie delal jeden kamos on mi poslal sablonu teda img a ja som urobil desing a na druhej strane staci mat cinemu4D a spravys aky ramik len chces

lukasasko a co to ma spolocne stym co potrebujem ja neak mi to unika

Zdravim vas mam jeden problem urobil som web desing pre server viz foto prikladam aj ukazku ako by ma vizerat desing ramecku a i ako by vnom mal byt text preto vas prosim ci by to niekto zvas nevedel urobit neak tak ze sa vytvory v Db napr tabulka News a vnej by boli uvedene texty a script by ich len stade cital max noviniek na stranku by malo byt 4 akmi vie stymto dakto pomvoct tak mu budem velice vdacny vopred dakujem .

zdravím vás nový project IceMystic fun server ktorý beží na patchi 3.3.5a hladá Core a Db developera ktorý by sa staral o update jadra a DB . Info o serveri : Operačný sistém serveru je Linux debian,world server beží na mangose rev.10599 a Db používame Ytdb. server je online nonstop a spustený je teraz presne týzdeň . Web servera je : http://icemystic.wowko.sk/ Moje icq :636314626 Alebo píšte svoje ponuky sem vopred ďakujem.

pls nevedel by mi dakto poradit ako upravit toto npc pre mangos patch 3.3.5a je to TBc vendor s patchu 2.4.3 problem je vtom ze nepoznam starsiu strukturu db a neviem co podcim hladat aby som to upravil dakujem za kazdu pomoc insert into creature_template (entry, KillCredit1, KillCredit2, modelid_1, modelid_2, name, subname, gossip_menu_id, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, PetSpellDataId, mingold, maxgold, AIName, MovementType, InhabitType, Civilian, RacialLeader, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) values (232323, 0, 0, 2158, 2158, 'Necklace', 'Vendor', 0, 60, 60, 999999, 999999, 999999, 999999, 1, 35, 35, 0, 0.53, 1.14286, 1, 0, 1, 1, 0, 1, 1, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 1, 0, 0, 2, ''); Problem aspon jeden co viem je vtomto Civilian

jop Dakujem vam moc pekne za vasu ochotu pomohlo odomna mate +rep esteraz dik

Pls neviete mi dakto poradit ako vlozit do php cierne pozadie a farbu pisma zmenit na bielu prikladam dany php ak sa dakto najde vopred dakujem . <? include ('config.php'); /* CODE BY HISGRAK and EDITED BY BARNY */ ?> <table align="center" width="520"> <tr><th align="center"><h1>Web teleporter</h1></th></tr> <tr><td align="center"> <table align="center" width="300"> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST"> <tr><td>Account</td><td><input type="text" name="ucet"></td></tr> <tr><td>Character</td><td><input type="text" name="jmenopostavy"></td></tr> <tr><td>Heslo</td><td><input type="password" name="heslokacc"></td></tr> <tr><td>Místo</td><td><select name="misto"> <option value="">-- vyber místa --</option> <option value="shattrath">Shattrath City</option> <option value="sw">Stormwind</option> <option value="ironforge">Ironforge</option> <option value="darnassus">Darnassus</option> <option value="og">Orgrimmar</option> <option value="thunderbluff">Thunder Bluff</option> <option value="undercity">Undercity</option> </td></tr> <tr><td></td><td><input type="submit" Value="Teleportovat"></td></tr> </form> <tr><td colspan="2" align="center"><strong> <?php $account = addslashes($_POST['ucet']); $character = addslashes($_POST['jmenopostavy']); $password = addslashes($_POST['heslokacc']); $lokace = addslashes($_POST['misto']); function sha_password($account,$password){ $account = strtoupper($account); $password = strtoupper($password); return SHA1($account.':'.$password); } if ($account == "" || $character == "" || $password == "" || $lokace == ""): echo "Je nutno vyplnit všechny údaje"; else: $account = strtoupper($account); $heslo = sha_password($account, $password); $dbconn = mysql_connect($ip, $user, $pass) or die ("Spojení nebylo uspěšné"); mysql_select_db($realmd, $dbconn) or die ("Nepovedlo se vybrat databázy $realmd"); $acc_dotaz_sql = "SELECT id, username, sha_pass_hash FROM account WHERE username='".$account."' AND sha_pass_hash='".$heslo."'"; $acc_dotaz_sql_vysledek = mysql_query($acc_dotaz_sql, $dbconn); $row = mysql_fetch_array($acc_dotaz_sql_vysledek); if ($row["id"] == ""): echo "Chybně zadané ACC nebo Heslo"; else: $acc = $row["id"]; mysql_select_db($characters, $dbconn) or die ("Nepovedlo se vybrat databázy $characters"); $hrac_dotaz_sql = "SELECT guid, account, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1398), ' ', -1) AS UNSIGNED) AS `money`, name, online FROM characters WHERE account='".$acc."' AND name='".$character."' AND online=0"; $hrac_dotaz_sql_vysledek = mysql_query($hrac_dotaz_sql, $dbconn); $radek = mysql_fetch_array($hrac_dotaz_sql_vysledek); $charguid = $radek["guid"]; if ($charguid == ""): echo "Špatně zadaný název characteru, nebo jste online"; else: if ($radek["money"] < $webport ): echo "Nedostatek peněz"; else: $penizky = $radek["money"]; switch($lokace): case shattrath: $x = "-1522"; $y = "5313"; $z = "9"; $map = "530"; break; case sw: $x = "-8833"; $y = "628"; $z = "94"; $map = "0"; break; case ironforge: $x = "-5039"; $y = "-809"; $z = "495"; $map = "0"; break; case darnassus: $x = "9953"; $y = "2233"; $z = "1332"; $map = "1"; break; case og: $x = "1328"; $y = "-4379"; $z = "26"; $map = "1"; break; case thunderbluff: $x = "-1345"; $y = "195"; $z = "61"; $map = "1"; break; case undercity: $x = "1897"; $y = "236"; $z = "55"; $map = "0"; break; endswitch; $odecet = $penizky-$webport; $sqlko = "update `characters` set `data`=CONCAT(CAST(SUBSTRING_INDEX(`data`, ' ', 1397) AS CHAR), ' ', $odecet, ' ', CAST(SUBSTRING_INDEX(`data`, ' ', -(1528-1398) - 1)AS CHAR)), position_x='$x', position_y='$y', position_z='$z', map='$map' where guid='$charguid'"; mysql_query($sqlko); echo "Character $character byl Teleportován"; endif; endif; endif; mysql_close(); endif; ?> </strong></td></tr> <tr><td colspan="2" align="center">1)Teleport stojí <? $vgoldech = $webport/10000; echo $vgoldech;?> zlatých<br>2) Character musí být Offline.</td></tr> </table> </td></tr> </table>

Vyriesene !!! pre tych co by stym mali problem staci zmenit cez quice Flags na 32 prikladam vzor SQL aby to bolo strucne a viditelne REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES (202243, 10, 9295, 'Scourge Transporter', '', '', '', 0, 32, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 11015, 1, 0, 0, 0, 0, 0, ''); tak mne to funguje v pohode

Zdravim vas prosim nemate dakto alebo netusite kde by som zohnal SQL opravu na transporteri v ICC ?? Pocul som ze to jestvuje aj sa to pouziva len som to nikde nenasiel Lebo inak mi icc ide az po Arthasa vse funguje aj port knemu az natie v dungu tie nejdu vobec a nejde ani ten od arthasa prosim ak sa najde ochotny clovek co by mi pomohol mu budem tisic krat vdacny vopred dakujem . PS:SERVER BEZI NA MANGOSE A PATCH 3.3.5a. tak sem som pridal SQL vytiahnute cez quice ak spravne uvazujem tak myslim ze mi tam chybaju akurat lokacie kam ma portovat lebo to co tam je je len zaklad a pozicie kde sa v hre nachadza -- 5.2.2011 11:19:45 REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES (202242, 10, 9295, 'Scourge Transporter', '', '', '', 0, 48, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 11013, 1, 0, 0, 0, 0, 0, ''); -- 5.2.2011 11:19:54 DELETE FROM `gameobject` WHERE `id`=202242; INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES (53295, 202242, 631, 15, 128, -17.0711, 2211.47, 30.0546, 0, 0, 0, 1, 0, 604800, 100, 0); -- 5.2.2011 11:21:35 REPLACE INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (53295, 202242, 631, 15, 128, -17.0711, 2211.47, 30.0546, 0, 0, 0, 1, 0, 604800, 100, 0);