Barny

myslim ze Yas tu ma takový topic... koukni do jeho podpisu

Ahojte mám menší problém je to nedávno co sem se naičil PHP a zkoušel sem si vytvořit novinkováč zkoušel sem brát scripty od rúzných lidí a fórech ale nikdy sem nenarazil na ten spravný tak sem si ho vždy zkoušel vylepšit ale muj lvl v php není tak vysoký ... tak mám dotaz jestli někdo nemá podobný novinkovač ..: Obrázek,Datum,komentář,počet shlédnutí... Pro inspiraci obrázek: Děkuji za jaké koliv uplné soubory atd..

Takže ress u těla vyřešís pomocí nahraní SQL kodu .... A pak konečný čas to si myslím jedině úprava core umřeš poprvé 2sec po druhé 10sec a po třetí to už sou 2min..(ale musíš umřít na stejne mapě..) game_graveyard_zone.rar

otevri si to v poznamkovym bloku a najdi si odpovidajici podle sve struktury tabulky tak dej v Bloku CTRL + H a napis tam flags pak nahradit napis [podle co mas ty v strukture] a dej nahradit vsechny...

de o to jestli to je predplaceny do predu nebo jestli to davas i s wowkem ale takhle samotny bych to videl na 500,-

lol umis anglicky ? proste spatny informace k navazani pripojeni do DB...

Takže ahoj mám problém mam TrinityCore 200 a postupně sem si dával updaty na DB všechno bez chyby ale při spouštění mi to háže toto: 2008-11-08 16:49:38 Loading Waypoints... 2008-11-08 16:49:49 ERROR:SQL: CREATE TEMPORARY TABLE temp LIKE creature_movement 2008-11-08 16:49:49 ERROR:SQL ERROR: Access denied for user 'wow_mangos'@'89.185.242.231' to database 'trinity_word' 2008-11-08 16:49:49 ERROR:SQL: INSERT INTO temp SELECT * FROM creature_movement 2008-11-08 16:49:49 ERROR:SQL ERROR: Table 'trinity_word.temp' doesn't exist 2008-11-08 16:49:49 ERROR:SQL: ALTER TABLE creature_movement DROP PRIMARY KEY 2008-11-08 16:49:49 ERROR:SQL ERROR: ALTER command denied to user 'wow_mangos'@'89.185.242.231' for table 'creature_movement' 2008-11-08 16:49:49 ERROR:SQL: UPDATE creature_movement AS T SET point = (SELECT COUNT(*) FROM temp WHERE id = T.id AND point <= T.point) 2008-11-08 16:49:49 ERROR:SQL ERROR: Table 'trinity_word.temp' doesn't exist 2008-11-08 16:49:50 ERROR:SQL: ALTER TABLE creature_movement ADD PRIMARY KEY (id, point) 2008-11-08 16:49:50 ERROR:SQL ERROR: ALTER command denied to user 'wow_mangos'@'89.185.242.231' for table 'creature_movement' 2008-11-08 16:49:50 ERROR:SQL: DROP TABLE temp 2008-11-08 16:49:50 ERROR:SQL ERROR: Unknown table 'temp' Takže sem skusil i znava DB bez update a slo to..takze to bude nejakym updatem...

no to tak vypada ale to je uz u waiponts jinak to predtim se nacte.. kdyby to bylo userem nebo passem tak by to vubec nenabehlo..

ja newim co chcete jestli de o vzhled tak si dej offik template ale spis me by slo o funkcnost ,, obrazky si vzdy muzes dat jine...

doporucuji nejaky Template nebo nejaky vytvor tady od uzivatelu.... máš hodně moznosti ...

Tak měl sem stejný problem ale bylo to uplne necim jinym .. bylo to kuli M VS 2008 delalo mi to i u mangosu na všech pc kromě mého osobniho takže sem usoudil že to bude něco z kompilatorem tak sem se vratil na M VS 2003 a problemy sou pryc..

Upravený RoSpora jiny skin.... index.php <?php /* */ require_once( 'configuration.php' ); Switch ($lang) { case "cz": $button="create_en.gif"; $text = Array( 'acc' => 'Vytvoření accountu', 'create' => 'je dokončeno !', 'failed' => 'nebylo úspěšné !', 'not_all' => 'Nevyplněna všechna políčka', 'playerson' => 'hráčů online', 'off' => 'je offline', 'name' => 'Jméno accountu', 'tbc' => 'Rozšíření', 'password' => 'Heslo', 'ip_limit' => Array('Z vaší IP ',' byl account již vytvořen'), 'char' => Array('Jméno','Rasa','Classa','LvL','Lokace'), 'backtext' => 'Zpět', ); break; } $maps_a = Array( 0 => 'Azeroth', 1 => 'Kalimdor', 2 => 'UnderMine', 13 => 'Test zone', 17 => 'Kalidar', 30 => 'Alterac Valley', 33 => 'Shadowfang Keep Instance', 34 => 'The Stockade Instance', 35 => 'Stormwind Prizon', 36 => 'Deadmines Instance', 37 => 'Plains of Snow', 43 => 'Wailing Caverns Instance', 44 => 'Monastery Interior', 47 => 'Razorfen Kraul Instance', 48 => 'Blackfathom Deeps Instance', 70 => 'Uldaman Instance', 90 => 'Gnomeregan Instance', 109 => 'Sunken Temple Instance', 129 => 'Razorfen Downs Instance', 530 => 'Outland', 169 => 'Emerald Forest', 189 => 'Scarlet Monastery Instance', 209 => 'ZulFarrak Instance', 229 => 'Blackrock Spire Instance', 230 => 'Blackrock Depths Instance', 249 => 'Onyxias Lair Instance', 269 => 'Caverns of Time', 289 => 'Scholomance Instance', 309 => 'ZulGurub Instance', 329 => 'Stratholme Instance', 349 => 'Maraudon Instance', 369 => 'Deeprun Tram', 389 => 'Ragefire Chasm Instance', 409 => 'The Molten Core Instance', 429 => 'Dire Maul Instance', 449 => 'Alliance PVP Barracks', 450 => 'Horde PVP Barracks', 451 => 'Development Land', 469 => 'Blackwing Lair Instance', 489 => 'Warsong Gulch', 509 => 'Ruins of AhnQiraj Instance', 529 => 'Arathi Basin', 531 => 'Temple of AhnQiraj Instance', 533 => 'Naxxramas Instance', 532 => 'Karazahn', 534 => 'Hyjal Past', 540 => 'Shattered Halls Instance', 542 => 'Blood Furnace Instance', 543 => 'Hellfire Ramparts Instance', 544 => 'Magtheridons Lair Instance', 545 => 'Steamvault Instance', 546 => 'Underbog Instance', 547 => 'Slave Pens Instance', 548 => 'Coilfang Resevoir Instance', 550 => 'Tempest Keep', 552 => 'Tempest Keep', 553 => 'Tempest Keep', 554 => 'Tempest Keep', 555 => 'Auchindoun', 556 => 'Auchindoun', 557 => 'Auchindoun', 558 => 'Auchindoun', 559 => 'Nagrand Arena', 560 => 'Hillsbrad Past', 562 => 'Blades Edge Arena', 564 => 'Black Temple', 565 => 'Gruuls Lair', 566 => 'Netherstorm Arena', 568 => 'Zulaman', ); $zone = Array( 0 => Array( Array(700,10,1244,1873,'Undercity',1497), Array(-840,-1330,-5050,-4560,'Ironforge',1537), Array(1190,200,-9074,-8280,'Stormwind City',1519), Array(-2170,-4400,-7348,-6006,'Badlands',3), Array(-500,-4400,-4485,-2367,'Wetlands',11), Array(2220,-2250,-15422,-11299,'Stranglethorn Vale',33), Array(-1724,-3540,-9918,-8667,'Redridge Mountains',44), Array(-2480,-4400,-6006,-4485,'Loch Modan',38), Array(662,-1638,-11299,-9990,'Duskwood',10), Array(-1638,-2344,-11299,-9918,'Deadwind Pass',41), Array(834,-1724,-9990,-8526,'Elwynn Forest',12), Array(-500,-3100,-8667,-7348,'Burning Steppes',46), Array(-608,-2170,-7348,-6285,'Searing Gorge',51), Array(2000,-2480,-6612,-4485,'Dun Morogh',1), Array(-1575,-5425,-432,805,'The Hinterlands',47), Array(3016,662,-11299,-9400,'Westfall',40), Array(600,-1575,-1874,220,'Hillsbrad Foothills',267), Array(-2725,-6056,805,3800,'Eastern Plaguelands',139), Array(-850,-2725,805,3400,'Western Plaguelands',28), Array(2200,600,-900,1525,'Silverpine Forest',130), Array(2200,-850,1525,3400,'Tirisfal Glades',85), Array(-2250,-3520,-12800,-10666,'Blasted Lands',4), Array(-2344,-4516,-11070,-9600,'Swamp of Sorrows',8), Array(-1575,-3900,-2367,-432,'Arathi Highlands',45), Array(600,-1575,220,1525,'Alterac Mountains',36), ), 1 => Array( Array(2698,2030,9575,10267,'Darnassus',1657), Array(326,-360,-1490,-910,'Thunder Bluff',1638), Array(-3849,-4809,1387,2222,'Orgrimmar',1637), Array(-1300,-3250,7142,8500,'Moonglade',493), Array(2021,-400,-9000,-6016,'Silithus',1377), Array(-2259,-7000,4150,8500,'Winterspring',618), Array(-400,-2094,-8221,-6016,'Un\'Goro Crater',490), Array(-590,-2259,3580,7142,'Felwood',361), Array(-3787,-8000,1370,6000,'Azshara',16), Array(-1900,-5500,-10475,-6825,'Tanaris',440), Array(-2478,-5500,-5135,-2330,'Dustwallow Marsh',15), Array(360,-1536,-3474,-412,'Mulgore',215), Array(4000,-804,-6828,-2477,'Feralas',357), Array(3500,360,-2477,372,'Desolace',405), Array(-804,-5500,-6828,-4566,'Thousand Needles',400), Array(-3758,-5500,-1300,1370,'Durotar',14), Array(1000,-3787,1370,4150,'Ashenvale',331), Array(2500,-1300,4150,8500,'Darkshore',148), Array(3814,-1100,8600,11831,'Teldrassil',141), Array(3500,-804,-412,3580,'Stonetalon Mountains',406), Array(-804,-4200,-4566,1370,'The Barrens',17), ), 530 => Array( Array(6135.25,4829,-2344.78,-1473.95,'Shattrath City',3703), Array(-6400.75,-7612.20,9346.93,10153.70,'Silvermoon City',3487), Array(5483.33,-91.66,1739.58,5456.25,'Netherstorm',3523), Array(7083.33,1683.33,-4600,-999.99,'Terokkar Forest',3519), Array(10295.83,4770.83,-3641.66,41.66,'Nagrand',3518), Array(-10075,-13337.49,-2933.33,-758.33,'Bloodmyst Isle',3525), Array(8845.83,3420.83,791.66,4408.33,'Blades Edge Mountains',3522), Array(4225,-1275,-5614.58,-1947.91,'Shadowmoon Valley',3520), Array(-11066.36,-12123.13,-4314.37,-3609.68,'The Exodar',3557), Array(9475,4447.91,-1416.66,1935.41,'Zangarmarsh',3521), Array(5539.58,375,-1962.49,1481.25,'Hellfire Peninsula',3483), Array(-10500,-14570.83,-5508.33,-2793.75,'Azuremyst Isle',3524), Array(-5283.33,-8583.33,6066.66,8266.66,'Ghostlands',3433), Array(-4487,-9412,7758,11041,'Eversong Woods',3430) ), ); $def = Array( 'character_race' => Array( 1 => 'Human', 2 => 'Orc', 3 => 'Dwarf', 4 => 'Night Elf', 5 => 'Undead', 6 => 'Tauren', 7 => 'Gnome', 8 => 'Troll', 9 => 'Goblin', 10 => 'Dranei', 11 => 'Blood Elf', ), 'character_class' => Array( 1 => 'Warrior', 2 => 'Paladin', 3 => 'Hunter', 4 => 'Rogue', 5 => 'Priest', 7 => 'Shaman', 8 => 'Mage', 9 => 'Warlock', 11 => 'Druid', ), 'character_rank' => Array( 'alliance' => Array( 1 => 'Private', 2 => 'Corporal', 3 => 'Sergeant', 4 => 'Master Sergeant', 5 => 'Sergeant Major', 6 => 'Knight', 7 => 'Knight-Lieutenant', 8 => 'Knight-Captain', 9 => 'Knight-Champion', 10 => 'Lieutenant Commander', 11 => 'Commander', 12 => 'Marshal', 13 => 'Field Marshal', 14 => 'Grand Marshal' ), 'horde' => Array( 1 => 'Scout', 2 => 'Grunt', 3 => 'Sergeant', 4 => 'Senior Sergeant', 5 => 'First Sergeant', 6 => 'Stone Guard', 7 => 'Blood Guard', 8 => 'Legionnare', 9 => 'Centurion', 10 => 'Champion', 11 => 'Lieutenant General', 12 => 'General', 13 => 'Warlord', 14 => 'High Warlord' ) ), ); class DBLayer { var $link_id; var $query_result; var $saved_queries = array(); var $num_queries = 0; function DBLayer($db_host, $db_username, $db_password, $db_name) { $this->link_id = @mysql_connect($db_host, $db_username, $db_password, true); if ($this->link_id) { if (@mysql_select_db($db_name, $this->link_id)) return $this->link_id; else error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__); } else error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__); } function query($sql) { $this->query_result = @mysql_query($sql, $this->link_id); if ($this->query_result) { ++$this->num_queries; return $this->query_result; } else { return false; } } function result($query_id = 0, $row = 0) { return ($query_id) ? @mysql_result($query_id, $row) : false; } function fetch_assoc($query_id = 0) { return ($query_id) ? @mysql_fetch_assoc($query_id) : false; } function fetch_row($query_id = 0) { return ($query_id) ? @mysql_fetch_row($query_id) : false; } function num_rows($query_id = 0) { return ($query_id) ? @mysql_num_rows($query_id) : false; } function affected_rows() { return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false; } function insert_id() { return ($this->link_id) ? @mysql_insert_id($this->link_id) : false; } function get_num_queries() { return $this->num_queries; } function get_saved_queries() { return $this->saved_queries; } function free_result($query_id = false) { return ($query_id) ? @mysql_free_result($query_id) : false; } function escape($str) { if (function_exists('mysql_real_escape_string')) return mysql_real_escape_string($str, $this->link_id); else return mysql_escape_string($str); } function error() { $result['error_sql'] = @current(@end($this->saved_queries)); $result['error_no'] = @mysql_errno($this->link_id); $result['error_msg'] = @mysql_error($this->link_id); return $result; } function close() { if ($this->link_id) { if ($this->query_result) @mysql_free_result($this->query_result); return @mysql_close($this->link_id); } else return false; } } class honor_system { var $realm_db; var $mangos_db; function get_all_honor() { $q = $this->mangos_db->query("SELECT * FROM `character_kill` ORDER BY `guid`"); while($res_row = $this->mangos_db->fetch_assoc($q)) { if($res_row['type']==1){ $honor_arr[$res_row['guid']] += $res_row['honor']; }elseif($res_row['type']==2){ $honor_arr[$res_row['guid']] -= $res_row['honor']; } } return $honor_arr; } function get_character_honor($char_id) { $q = $this->mangos_db->query("SELECT * FROM `character_kill` WHERE `guid`='$char_id'"); while($res_row = $this->mangos_db->fetch_assoc($q)) { if($res_row['type']==1){ $honor += $res_row['honor']; }elseif($res_row['type']==2){ $honor -= $res_row['honor']; } } return $honor; } function calc_character_rank($honor_points) { $rank = 0; if($honor_points <= 0){ $rank = 0; } else{ if($honor_points < 2000 and $honor_points > 500) $rank = 2; else if($honor_points <= 500 and $honor_points > 0) $rank = 1; else if ($honor_points >= 2000) $rank = round(($honor_points / 5000) + 1,0); } return $rank; } } function error($message, $file, $line, $db_error = false) { global $siteerrors; $s = "\t\t".'Error: <strong>'.$message.'.</strong>'."\n"; echo $s; } function get_zone_name($mapid, $x, $y){ global $maps_a, $zone; if (!empty($maps_a[$mapid])) { $zmap=$maps_a[$mapid]; if (($mapid==0) or ($mapid==1)) { $i=0; $c=count($zone[$mapid]); while ($i<$c) { if ($zone[$mapid][$i][2] < $x AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4]; $i++; } } } else $zmap="Unknown zone"; return $zmap; } function test_realm(){ global $server, $port; $s = @fsockopen("$server", $port, $ERROR_NO, $ERROR_STR,(float)0.5); if($s){@fclose($s);return true;} else return false; } function get_realm_name(){ global $hostr, $userr, $passwordr, $dbr, $database_encoding; $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $query = $realm_db->query("SELECT * FROM `realmlist`"); $result = $realm_db->fetch_assoc($query); $realm_db->close(); unset($realm_db); return($result['name']); } if (empty($_POST['username']) and empty($_POST['passw']) and empty($_POST['email'])) { $cont=' <TR> <TD rowSpan=6><IMG height=110 src="'.$img_base.'pixel.gif" width=15></TD> <TD vAlign=center align=left width=190><B style="FONT-SIZE: 8pt; COLOR: white; LETTER-SPACING: 3px; FONT-VARIANT: small-caps"><LABEL for=username>'.$text["name"].':</LABEL> </B><BR><INPUT id=username style="WIDTH: 175px" tabIndex=1 maxLength=16 size=18 name=username></TD> <TD rowSpan=6><IMG height=1 src="'.$img_base.'pixel.gif" width=15></TD></TR> <TR><TD width=190 height=1></TD></TR> <TR><TD width=190 height=1></TD></TR> <TR> <TD vAlign=center align=left width=190><B style="FONT-SIZE: 8pt; COLOR: white; LETTER-SPACING: 3px; FONT-VARIANT: small-caps"><LABEL for=passw>'.$text["password"].':</LABEL> </B><BR><INPUT id=passw style="WIDTH: 175px" tabIndex=2 type=password maxLength=12 size=18 name=passw></TD></TR> <TD vAlign=center align=left width=190><B style="FONT-SIZE: 8pt; COLOR: white; LETTER-SPACING: 3px; FONT-VARIANT: small-caps"><LABEL for=tbc>'.$text["tbc"].':</LABEL> </B><BR><select size="1" name="tbc"> <option selected value="1">TBC</option> <option value="0">WoW</option></select> </TD></TR> <TR> <TD vAlign=center align=left width=190><B style="FONT-SIZE: 8pt; COLOR: white; LETTER-SPACING: 3px; FONT-VARIANT: small-caps"><LABEL for=email>E-mail:</LABEL> </B><BR><INPUT id=email style="WIDTH: 175px" tabIndex=2 maxLength=50 size=18 name=email></TD></TR> <TR> <TD align=left> <TABLE cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD><IMG height=3 src="'.$img_base.'pixel.gif" width=1></TD> <TD></TD> <TD></TD></TR></TBODY></TABLE></TD></TR> <TR> <TD align=left colSpan=3> <TABLE cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD><IMG height=39 src="'.$img_base.'pixel.gif" width=19></TD> <TD><INPUT class=button style="WIDTH: 168px; HEIGHT: 39px" tabIndex=3 type=image alt=Create src="'.$img_base.$button.'" value=Create border=0></TD> </TR></TBODY></TABLE></TD></TR>'; } elseif (empty($_POST['username']) or empty($_POST['passw']) or empty($_POST['email'])) { $cont='<TR><TD rowSpan=6><IMG height=182 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error> '.$text["not_all"].' <br><br><a href="" onClick="history.go(-1)">'.$text["backtext"].'</a></SMALL></TD></TD></TR>'; } else { $username = htmlspecialchars(trim("$_POST[username]")); $passw = trim($_POST['passw']); $email = htmlspecialchars(trim($_POST['email'])); $tbc = trim($_POST['tbc']); $ip = getenv('REMOTE_ADDR'); // ńäĺëŕňü ďđîâĺđęó íŕ íĺďîëó÷ĺíčĺ čďŕ $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr); $realm_db->query("SET NAMES $database_encoding"); $ip_cr=0; if ($lock_reg!=0){ $query = $realm_db->query("SELECT `last_ip` FROM `account` WHERE `last_ip`='$ip'"); while($result = $realm_db->fetch_assoc($query)) $ip_cr++; } function sha_password($user,$pass) { $user = strtoupper($user); $pass = strtoupper($pass); return SHA1($user.':'.$pass); } $passwdhach = sha_password($username,$passw); if (($ip_cr>=$lock_reg) && ($lock_reg!=0)) { $cont='<TR><TD rowSpan=6><IMG height=182 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error> '.$text["ip_limit"][0].$ip.'<br>'.$ip_cr.$text["ip_limit"][1].' <br><br><a href="" onClick="history.go(-1)">'.$text["backtext"].'</a></SMALL></TD></TD></TR>'; } else { if($realm_db->query("INSERT INTO `account` (`username`,`I`,`email`,`last_ip`,`locked`,`tbc`) VALUES ('$username','$passwdhach','$email','$ip','$lock_acc','$tbc')")) { $cont='<TR><TD rowSpan=6><IMG height=182 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL> '.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["create"].'<br> </SMALL></TD></TD></TR>'; } else { $cont='<TR><TD rowSpan=6><IMG height=182 width=1 src="'.$img_base.'pixel.gif"><TD align=Center><SMALL class=error> '.$text["acc"].'<br><strong>'.$username.'</strong><br>'.$text["failed"].' <br><br><a href="" onClick="history.go(-1)">'.$text["backtext"].'</a></SMALL></TD></TD></TR>'; } } $realm_db->close(); unset($realm_db); } function make_players_array(){ global $host, $user, $password, $db, $database_encoding, $pl_array; $i=0; $mangos_db = new DBLayer($host, $user, $password, $db); $mangos_db->query("SET NAMES $database_encoding"); $query = $mangos_db->query("SELECT * FROM `character` WHERE `online`='1' and `account` not in (select `id` from `realmd`.`account` where `gmlevel`>0) ORDER BY `name`"); while($result = $mangos_db->fetch_assoc($query)) { $char_data = explode(' ',$result['data']); $char_gender = dechex($char_data[36]); $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT); $char_gender = $char_gender{3}; $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']); $pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $char_data[34], $res_pos, $char_gender); $i++; } $mangos_db->close(); unset($mangos_db); return $i; } $onlineplayers=make_players_array(); if (!$sort = &$_GET['s']) $sort=0; if (!$flag = &$_GET['f']) $flag=0; if ($flag==0) { $flag=1; $sort_type='<'; } else { $flag=0; $sort_type='>'; } $link=$_SERVER['PHP_SELF']."?f=".$flag."&s="; if (!empty($pl_array)) { usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;')); } $list=""; $i=0; while ($i < $onlineplayers) { $name=$pl_array[$i][0]; $race=$pl_array[$i][1]; $class=$pl_array[$i][2]; $res_race = $def['character_race'][$race]; $res_class = $def['character_class'][$class]; $lvl=$pl_array[$i][3]; $loc=$pl_array[$i][4]; $gender=$pl_array[$i][5]; $list.= " <tr class=txt> <td></td> <td>$name</td> <td align='center'><img alt=$res_race src='".$img_base.$race."-$gender.gif' height='18' width='18'></td> <td align='center'><img alt=$res_class src='".$img_base."$class.gif' height='18' width='18'></td> <td align='center'>$lvl</td> <td >$loc</td> </tr>"; $i++; } $title=get_realm_name(); $copyright=get_realm_name(); $status=get_realm_name(); if (test_realm()) { $title.=(' ('.$onlineplayers.' '.$text["playerson"].')'); $status = "<img alt=Online src='".$img_base."online.gif' height='18' width='18'>"; } else { $title.=(' '.$text["off"] ); $status = "<img alt=Offline src='".$img_base."offline.gif' height='18' width='18'>"; } $foorat="<center><font face=\"Arial\" size=\"2\"><b>Vyrobeno Barnym pro $copyright</b></font><br><font face=\"Arial\" size=\"1\"><br> "; // Main part !!! ?> <HTML><HEAD><META HTTP-EQUIV="Pragma" CONTENT="no-cache"><TITLE><?php print $title ?></TITLE> <META http-equiv=Content-Type content="text/html; charset=<?php print $charset ?>"><LINK id=bnetstyle href="<?php print $img_base ?>style.css" type=text/css rel=stylesheet> <link rel="Shortcut Icon" href="img/wowlogoanim.gif" type="image/gif"> <script type="text/javascript"> var weekdaystxt=["Sun", "Mon", "Tues", "Wed", "Thurs", "Fri", "Sat"] function showLocalTime(container, servermode, offsetMinutes, displayversion){ if (!document.getElementById || !document.getElementById(container)) return this.container=document.getElementById(container) this.displayversion=displayversion var servertimestring=(servermode=="server-php")? '<? print date("F d, Y H:i:s", time())?>' : (servermode=="server-ssi")? '<!--#config timefmt="%B %d, %Y %H:%M:%S"--><!--#echo var="DATE_LOCAL" -->' : '<%= Now() %>' this.localtime=this.serverdate=new Date(servertimestring) this.localtime.setTime(this.serverdate.getTime()+offsetMinutes*60*1000) //add user offset to server time this.updateTime() this.updateContainer() } showLocalTime.prototype.updateTime=function(){ var thisobj=this this.localtime.setSeconds(this.localtime.getSeconds()+1) setTimeout(function(){thisobj.updateTime()}, 1000) //update time every second } showLocalTime.prototype.updateContainer=function(){ var thisobj=this if (this.displayversion=="long") this.container.innerHTML=this.localtime.toLocaleString() else{ var hour=this.localtime.getHours() var minutes=this.localtime.getMinutes() var seconds=this.localtime.getSeconds() var ampm=(hour>=12)? "PM" : "AM" var dayofweek=weekdaystxt[this.localtime.getDay()] this.container.innerHTML=formatField(hour, 1)+":"+formatField(minutes)+":"+formatField(seconds)+" "+ampm+" ("+dayofweek+")" } setTimeout(function(){thisobj.updateContainer()}, 1000) //update container every second } function formatField(num, isHour){ if (typeof isHour!="undefined"){ //if this is the hour field var hour=(num>12)? num-12 : num return (hour==0)? 12 : hour } return (num<=9)? "0"+num : num//if this is minute or sec field } </script> <script language=javascript> <!-- var styleSheet; var agt = navigator.userAgent.toLowerCase(); var appVer = navigator.appVersion.toLowerCase(); var verInt = parseInt(appVer); var ie = (appVer.indexOf('msie') != -1); var opera = (agt.indexOf('opera') != -1); var mozilla = ((agt.indexOf('mozilla')!=-1) && (agt.indexOf('opera')==-1) && (agt.indexOf('spoofer')==-1) && (agt.indexOf('compatible') == -1) && (agt.indexOf('webtv')==-1) && (agt.indexOf('hotjava')==-1)); var ns4 = (mozilla && (verInt == 4)); if (ie && !opera) { document.styleSheets["bnetstyle"].addRule ("input", "background-color: #040D1A"); document.styleSheets["bnetstyle"].addRule ("input", "border-style: solid"); document.styleSheets["bnetstyle"].addRule ("input", "border-width: 1px"); document.styleSheets["bnetstyle"].addRule ("input", "border-color: #7F7F7F"); document.styleSheets["bnetstyle"].addRule ("input", "color: #FFAC04"); document.styleSheets["bnetstyle"].addRule ("textarea", "background-color: #040D1A"); document.styleSheets["bnetstyle"].addRule ("textarea", "border-style: solid"); document.styleSheets["bnetstyle"].addRule ("textarea", "border-width: 1px"); document.styleSheets["bnetstyle"].addRule ("textarea", "border-color: #7F7F7F"); document.styleSheets["bnetstyle"].addRule ("textarea", "color: #FFAC04"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Base-Color: #012158"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Arrow-Color: #7F7F7F"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-3dLight-Color: #7F7F7F"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-DarkShadow-Color: red"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Highlight-Color: red"); document.styleSheets["bnetstyle"].addRule ("textarea", "scrollbar-Shadow-Color: #00B3FF"); document.styleSheets["bnetstyle"].addRule ("select", "background-color: #040D1A"); document.styleSheets["bnetstyle"].addRule ("select", "color: #FFAC04"); document.styleSheets["bnetstyle"].addRule ("select.gray", "background-color: #040D1A"); document.styleSheets["bnetstyle"].addRule ("select.gray", "color: #FFAC04"); document.styleSheets["bnetstyle"].addRule ("ul.thread", "margin-left: 22px;"); } //--> </SCRIPT> </HEAD> <BODY text=#cccc99 vLink=#aaaaaa link=#ffffbb bgColor=#000000 leftMargin=0 topMargin=0 marginheight="0" marginwidth="0"> <FORM name=login_form method=post> <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD align=middle> </center> <TABLE cellSpacing=0 cellPadding=0 background="<?php print $img_base ?>back_create.jpg" border=0 style="background-repeat: no-repeat;"> <TBODY> <TR> <TD vAlign=top> <DIV style="POSITION: relative; left: -12px; top: 0px; width: 224px;"> <DIV style="LEFT: 130px; WIDTH: 400px; POSITION: absolute; TOP: 0px"></DIV></DIV></TD> <TD><left> </left> <IMG height=169 src="<?php print $img_base ?>pixel.gif" width=1></TD> <TD></TD></TR> <TR> <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" width=203></TD> <TD> <TABLE cellSpacing=0 cellPadding=0 width=220 border=0> <TBODY> <?php if($accountoption==1) { echo"$cont"; } else { echo "<br><br><br><br><center><strong><font face=\"Arial\" color=\"#FF0000\" size=\"2\">$accountmessage</font></center></strong><br><br><br><br><br>"; } ?></TBODY></TABLE></TD> <TD><IMG height=1 src="<?php print $img_base ?>pixel.gif" width=217></TD></TR> <TR> <TD colSpan=3> <TABLE cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD colSpan=3 style="height: 85px"><IMG height=17 src="<?php print $img_base ?>pixel.gif" width=1></TD></TR> <TR> <TD width=106><IMG height=1 src="<?php print $img_base ?>pixel.gif" width=106></TD> <TD width=410><SMALL> <br><br> <center style="height: 20px"><?php print $timetext?> : <span id="timecontainer"></span> <script type="text/javascript"> new showLocalTime("timecontainer", "server-php", 0, "short") </script></center><SMALL> <SMALL> <strong class=title><center style="height: 23px"><?php print "$status";echo " "; print "$title"; ?></center></strong> </small></small><br> <table cellpadding='3' cellspacing='0' align='center'> <tbody> <tr class=title> <td align='left' nowrap='nowrap' width=50></td> <td align='left' nowrap='nowrap' width=60><a href="<?php print $link.'0">'.$text['char'][0] ?></a></td> <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'1">'.$text['char'][1] ?></a></td> <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'2">'.$text['char'][2] ?></a></td> <td align='center' nowrap='nowrap' width=40><a href="<?php print $link.'3">'.$text['char'][3] ?></a></td> <td align='left' nowrap='nowrap' width=100><a href="<?php print $link.'4">'.$text['char'][4] ?></a></td> </tr><?php if($onlineoption==1) { echo"$list"; } else { echo "<center><strong><font face=\"Arial\" color=\"#FF0000\" size=\"2\"><br>$onlinemessage</font></strong></center>"; } ?> <tr> <td class='txt' align='center' colspan='6' nowrap='nowrap'><IMG height=1 src='<?php print $img_base ?>pixel.gif' width=400></td></tr> </tbody> </table> </SMALL></TD> <TD width=124><IMG height=1 src="<?php print $img_base ?>pixel.gif" width=124></TD></TR> <TR> <TD colSpan=3><IMG height=100 src="<?php print $img_base ?>pixel.gif" width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></FORM> </table> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </BODY> </HTML> <?php "$barny"; ?> config.php <?php #Database Settings $lang="cz"; // Language ("en" - english, "ru" - russian, "tr" - turkish, "hu" - hungarian) $host="localhost"; // HOST for Mangos database $user="root" ; // USER for Mangos database $password="barny"; // PASS for Mangos database $db="mangos"; // NAME of Mangos database $hostr="localhost"; // HOST for Realm database $userr="root" ; // USER for Realm database $passwordr="barny"; // PASS for Realm database $dbr="realmd"; // NAME of Realm database $database_encoding = 'CP1251'; // Set encoding $server = "127.0.0.1"; // Server adress (for realm status) $port = "8085"; // Server port (for realm status) 8085 or 3724 #Page Account Feature Options $accountoption="1"; //Set your RoSPORA's account creating is open or closed. 1 - Open , 2 - Closed $onlineoption="1"; //Set your RoSPORA's online player display is open or closed. 1 - Open , 2 - Closed $accountmessage="Account Creation Closed!"; //Set your account creation closed text $onlinemessage="Online Player Display Disabled!"; //Set your online player display text $lock_acc=0; // Lock created account to IP adress (1 - on, 0 - off) $lock_reg=0; // Registration only one (or more) account from one IP adress // 0 - not limit, 1 - one acc, 2 - two acc, etc... #Page Template Options $img_base = "img/"; // Image dir $ongif = "img/on.gif"; $offgif = "img/off.gif"; $charset="windows-1250"; //Browser charset of your language.Tarayýcýnýzýn dilinize göre charset ayarý - Türkçe : "iso-8859-9" $timetext="Čas serveru"; //Shows Server Time , if you want you can change it to your language Example: ="yourlang"; ?> Snad vám to pofičí Obrázky img ke stáhnutí zde http://filebeam.com/8495648c3cd46c763a7a545456b4b1a6 A celý komplet zde http://filebeam.com/11aea0434a965c5173cfd1429d3919b6

newim rekl bych ze to de ale na mape bys mel furt orgrimmar a proste si myslim ze to je nemozne udelat kompletni...a pride mi to uplne zbytecne..!

no mohl bych snad to nebude bluma brat jako reklamu proto sem nedam odkaz na web... Petr Hromádka Hokosoft, s.r.o. Peroutkova 55 150 00 Praha 5 Tel.: 222 101 454 Fax: 222 101 459 Gsm: 777 676 708

no lol zkousel sem psat tedka ze srandy jedne firme ... Citace:

Myslim že postavy nenastavis a jedno acc na 1ip to mas registrace např. Raspora tam se to dá nastavit...

tak mas to na ic.cz to newadi ale pro vyplneni configu tam mas ip atd...nenechal si tam 127.0.0.1 musis tam napsat svou verejnou ip nebo hamachi ip a spravne heslo do mysql...

mohl by si napsat trochu více infa o projektu .... aby to pak neskončilo Hamachi a domaci HW

Ano presne tak tento projekt 'trinity' davam mu max 2mesice a zanikne ....Bylo jich uz vice

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration) VALUES (99999, 4, 0, -1, "VIP Neck", 32395, 4, 0, 1, 110000, 110000, 2, -1, -1, 150, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20449, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Item ktery vas portne kam si roys urci by Barny", 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "internalitemhanler", 0, 0, 0, 0, 0); INSERT INTO spell_target_position (id, target_map, target_position_x, target_position_y, target_position_z, target_orientation) VALUES (20449, 0, "3841,1", "-3575,19", "45,5491", "0,788677");

mel sem to taky zmena revky ale ja to mel na mangosu na trinity zatim zadny problem....zkus tu rev96 je tam udpate ACE

na trinity mi jede server sice online jen 30 az 50 ale uptime 2dny a zadne freezy sem jeste nemel

no lol koukam ze o mangosu vis uplny prd radim ti server zrusit nebo prejit na jiny emu kde uz areny mas a projet si strukturu DB pru updatu jadra nemuzes prijit o acc prostuduj si neco o mangosu a skus tady na foru hledat vsechno tady mas ))

Takže ahojte chci se zeptat jestli ste uz nezkousely tu trinitycore a trinityDB vlastne to vystridalo mangos v SVN a MaNGOS jede v GIT ktery sem vubec nepochopil takze chci zkusit Trinity jestli ze to uz ma nekdo na serveru napiste mi pls nejake info ..

mam dotaz jak zjistim co toje za revizi nejak sem se to tam nemohl docist