Changeset 82
- Timestamp:
- Sep 29, 2007, 8:25:17 PM (17 years ago)
- Files:
-
- 1 added
- 1 deleted
- 10 edited
Legend:
- Unmodified
- Added
- Removed
-
WoW_zdechov.ppr
r78 r82 129 129 db\css\css.php 130 130 db\css\zakladni_css.css 131 -include131 +include 132 132 db\include\classes.php 133 133 db\include\crare.php … … 147 147 db\include\qspecial.php 148 148 db\include\qtrskill.php 149 db\include\quest.php 149 150 db\include\questy.php 150 151 db\include\qzone.php … … 155 156 db\include\talents.php 156 157 db\include\uvod.php 157 db\include\quest.php158 158 -js 159 159 db\js\scripty.js … … 165 165 db\komentare\podklad1.png 166 166 db\komentare\SHOWG.TTF 167 ..\..\..\..\..\..\..\SVN\wow_zdechov\db\config.sample.php167 db\config.php 168 168 db\hlavni.php 169 169 db\index.php … … 681 681 [Open project files] 682 682 0=db\index.php 683 1=db\css\zakladni_css.css 684 2=db\hlavni.php 685 3=db\obsah.php 686 4=db\post_read.php 687 5=db\include\questy.php 688 6=..\..\..\..\..\..\..\SVN\wow_zdechov\db\config.sample.php 683 1=db\config.php 684 2=db\css\zakladni_css.css 685 3=db\hlavni.php 686 4=db\obsah.php 687 5=db\post_read.php 688 6=db\include\quest.php 689 7=..\..\..\Skripty\hotove\heslo_md5.php 689 690 [Selected Project Files] 690 691 Main= 691 Selected= db\include\questy.php692 Selected=..\..\..\Skripty\hotove\heslo_md5.php 692 693 [db\index.php] 693 TopLine=61 694 Caret=41,113 694 TopLine=1 695 Caret=5,28 696 [db\config.php] 697 TopLine=16 698 Caret=7,46 695 699 [db\css\zakladni_css.css] 696 TopLine=1 62697 Caret=2 1,181700 TopLine=170 701 Caret=23,202 698 702 [db\hlavni.php] 699 TopLine= 62700 Caret= 22,18703 TopLine=1 704 Caret=70,7 701 705 [db\obsah.php] 702 TopLine= 19703 Caret= 20,44706 TopLine=20 707 Caret=49,44 704 708 [db\post_read.php] 709 TopLine=79 710 Caret=55,102 711 [db\include\quest.php] 712 TopLine=13 713 Caret=12,38 714 [..\..\..\Skripty\hotove\heslo_md5.php] 705 715 TopLine=1 706 Caret=1,6 707 [db\include\questy.php] 708 TopLine=1 709 Caret=71,7 710 [..\..\..\..\..\..\..\SVN\wow_zdechov\db\config.sample.php] 711 TopLine=40 712 Caret=29,7 716 Caret=78,17 -
db/css/zakladni_css.css
r78 r82 5 5 */ 6 6 7 * { margin: 0px; padding: 0px; } 7 * { margin: 0px; padding: 0px; } 8 8 9 9 body { … … 16 16 h1, h2, h3, h4, h5, h6 { 17 17 font-size: 18px; 18 font-weight: normal; 18 font-weight: bold; 19 text-decoration: underline; 19 20 margin-top: 5px; margin-bottom: 5px; 20 21 padding-left: 30px; } … … 191 192 #right table.search_result td a { 192 193 text-decoration: none; } 194 #right table#quest { 195 empty-cells: show; 196 width: 720px; 197 margin-top: 15px; } 198 #right table#quest thead td { 199 font-weight: bold; 200 border-bottom: 2px solid white; 201 border-right: 1px solid white; } 202 #right table#quest td { 203 vertical-align: top; 204 border-bottom: 1px solid white; 205 border-right: 1px solid white; } 206 #right table#quest table thead td { 207 padding-top: 20px; 208 border-right: 0px; 209 border-bottom: 2px solid white; } 210 #right table#quest table td { 211 border: 0px; } 212 #right ul#ucast { 213 display: block; 214 margin-bottom: 8px; 215 padding-left: 15px; } 216 #right ul#ucast li { 217 margin-left: 12px; 218 list-style-type: square; } 219 #right ul#ucast ul li { 220 margin-left: 10px; 221 list-style-type: circle; } 193 222 194 223 #pata { -
db/hlavni.php
r76 r82 5 5 <html> 6 6 <head> 7 <meta http-equiv="Content-Type" content="text/html; charset= <?php echo $Config['DB_read']['Charset']; ?>">7 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 8 8 <meta name="Description" content="<?php echo $Config['DB_read']['Description']; ?>"> 9 9 <meta name="robots" content="all, follow"> … … 22 22 <li><a href="./../forum/">Forum</a></li> 23 23 <li><a href="./../registrace/">Registrace</a></li> 24 <li><a href="./index.php?id=bugreport<?php echo $SID; ?>">Hlášení chyb</a></li> 24 25 <li><a href="./index.php?id=stats<?php echo $SID; ?>">Statistiky</a></li> 25 26 <li><a href="./index.php?id=races<?php echo $SID; ?>">Rasy</a></li> -
db/include/quest.php
r76 r82 3 3 ?> 4 4 5 <form action=" " method="get" class="search_form"> 6 <input type="hidden" name="id" value="questy" class="hidden"> 7 <table class="search_form" border="0" cellspacing="0" cellpadding="2"> 8 <tr><td><label for="quest">Hledat:</label></td><td colspan='3'><input type="text" name="quest" id="quest" value="<?php echo stripslashes($_GET['quest']); ?>"></td></tr> 9 <tr><td>Level <label for="lvl_d">od:</label></td><td><input type="text" name="lvl_d" id="lvl_d" maxlength="3" style="width: 45px;" value="<?php echo $lvl_d; ?>"></td><td><label for="lvl_h">do:</label></td><td><input type="text" name="lvl_h" id="lvl_h" maxlength="3" style="width: 45px;" value="<?php echo $lvl_h; ?>"></td><td><input type="submit" value="Hledat" name="quest_find"></td></tr> 10 </table><?php if(!empty($session_id)){ ?><input type="hidden" name="PHPSESSID" value="<?php echo $session; ?>" class="hidden"><?php }; ?></form> 11 <?php if(array_key_exists('quest', $_GET)){ ?> 12 <?php echo $sql_select['result']; ?> 5 <?php if( empty($sql_select['error']) ){ ?> 6 <table id="quest" cellspacing="0" cellpadding="0"> 7 <tr><td width="30%"><table width="100%" border="0" cellspacing="0" cellpadding="0"> 8 <tr><td>ID Questu: <?php echo $sql_select['quest']['entry']; ?></td></tr> 9 <tr><td>Začíná u:</td></tr> 10 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['StartNPC']; ?></td></tr> 11 <tr><td>Oblast:</td></tr> 12 <tr><td style="padding-left:20px;"><?php echo "???"; ?></td></tr> 13 <tr><td>Level: <?php echo $sql_select['quest']['QuestLevel']; ?></td></tr> 14 <tr><td>Počet XP: <?php echo $sql_select['quest']['RewXpOrMoney']; ?></td></tr> 15 <?php if( !empty($sql_select['other']['SrcItemId']) ){ ?> 16 <tr><td>Důležitá věc:</td></tr> 17 <tr><td style="padding-left:20px;"><?php echo $sql_select['quest']['SrcItemCount']."x ".$sql_select['other']['SrcItemId']; ?></td></tr> 13 18 <?php }; ?> 14 19 20 <?php $zobrazit=0; if($zobrazit =1){ //nevyřešeno !!! ?> 21 <?php if( $sql_select['quest']['PrevQuestId']!=0 OR $sql_select['quest']['NextQuestId']!=0 ){ ?> 22 <tr><td><b>Návaznost:</b></td></tr> 23 <?php }; if( $sql_select['quest']['PrevQuestId']!=0 ){ ?> 24 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['PrevQuestId']; ?></td></tr> 25 <?php }; if( $sql_select['quest']['NextQuestId']!=0 ){ ?> 26 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['PrevQuestId']; ?></td></tr> 27 <?php }; ?><?php }; ?> 28 29 <?php if( !empty($sql_select['other']['ReqItems']) ){ ?> 30 <tr><td>Věci vyžadované pro splnění:</td></tr> 31 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqItems']; ?></td></tr> 32 <?php }; if( !empty($sql_select['other']['ReqSource']) ){ ?> 33 <tr><td>Unknown:</td></tr> 34 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqSource']; ?></td></tr> 35 <?php }; if( !empty($sql_select['other']['ReqCreatureOrGOId']) ){ ?> 36 <tr><td>Věci vyžadované pro splnění:</td></tr> 37 <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqCreatureOrGOId']; ?></td></tr> 38 <?php }; ?> 39 </table></td><td width="70%" style="padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0"> 40 <thead><tr><td style="padding-top:0px;">Detaily: </td></tr></thead> 41 <tr><td><?php echo nl2br($sql_select['quest']['Details']); ?></td></tr> 42 <thead><tr><td>Úkol ve zkratce: </td></tr></thead> 43 <tr><td><?php echo nl2br($sql_select['quest']['Objectives']); ?></td></tr> 44 <thead><tr><td>Při dokončení: </td></tr></thead> 45 <tr><td><?php echo nl2br($sql_select['quest']['OfferRewardText']); ?></td></tr> 46 <thead><tr><td>Při pokusu odevzdat nedokončený úkol: </td></tr></thead> 47 <tr><td><?php echo nl2br($sql_select['quest']['RequestItemsText']); ?></td></tr> 48 </table></td></tr> 49 </table> 50 <?php } elseif( !empty($sql_select['error']) ){ ?> 51 <?php echo $sql_select['error']; ?> 52 <?php }; ?> 53 <?php //<textarea style="width:100%;height:250px;">< ?php print_r($sql_select); ? ></textarea> ?> 54 55 <?php 56 /* <table class="wiki"> 57 <tr><td> <strong>Field</strong> </td><td> <strong>Type</strong> </td><td><strong>Attributes</strong></td><td><strong>Null</strong></td><td><strong>Key Name/Type</strong></td><td><strong>Default</strong></td><td><strong>Extra</strong> 58 59 </td></tr><tr><td> <span class="underline">entry</span> </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> PRIMARY/PRIMARY </td><td> 0 </td><td> 60 </td></tr><tr><td> <a class="missing wiki" href="/trac/MaNGOS/wiki/ZoneOrSort" rel="nofollow">ZoneOrSort?</a> </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 61 62 </td></tr><tr><td> MinLevel </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 63 </td></tr><tr><td> QuestLevel </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 64 65 </td></tr><tr><td> Type </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 66 </td></tr><tr><td> RequiredRaces </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 67 68 </td></tr><tr><td> RequiredSkillValue</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 1 </td><td> 69 </td></tr><tr><td> RequiredRepFaction</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 70 71 </td></tr><tr><td> RequiredRepValue </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 72 </td></tr><tr><td> SuggestedPlayers </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 73 74 </td></tr><tr><td> LimitTime </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 75 </td></tr><tr><td> SpecialFlags </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 76 77 </td></tr><tr><td> PrevQuestId </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 78 </td></tr><tr><td> NextQuestId </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 79 80 </td></tr><tr><td> ExclusiveGroup </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 81 </td></tr><tr><td> NextQuestInChain </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 82 83 </td></tr><tr><td> srcItem </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 84 </td></tr><tr><td> SrcItemCount </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 85 86 </td></tr><tr><td> SrcSpell </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 87 </td></tr><tr><td> Title </td><td>varchar(50) </td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 88 89 </td></tr><tr><td> Details </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 90 </td></tr><tr><td> Objectives </td><td>varchar(150)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 91 92 </td></tr><tr><td> OfferRewardText </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 93 </td></tr><tr><td> RequestItemsText </td><td>varchar(200)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 94 95 </td></tr><tr><td> EndText </td><td>varchar(200)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 96 </td></tr><tr><td> ObjectiveText1 </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 97 98 </td></tr><tr><td> ObjectiveText2 </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 99 </td></tr><tr><td> ObjectiveText3 </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 100 101 </td></tr><tr><td> ObjectiveText4 </td><td>varchar(250)</td><td> </td><td> Yes </td><td> </td><td> NULL </td><td> 102 </td></tr><tr><td> ReqItemId1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 103 104 </td></tr><tr><td> ReqItemId2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 105 </td></tr><tr><td> ReqItemId3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 106 107 </td></tr><tr><td> ReqItemId4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 108 </td></tr><tr><td> ReqItemCount1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 109 110 </td></tr><tr><td> ReqItemCount2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 111 </td></tr><tr><td> ReqItemCount3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 112 113 </td></tr><tr><td> ReqItemCount4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 114 </td></tr><tr><td> ReqSourceId1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 115 116 </td></tr><tr><td> ReqSourceId2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 117 </td></tr><tr><td> ReqSourceId3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 118 119 </td></tr><tr><td> ReqSourceId4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 120 </td></tr><tr><td> ReqSourceCount1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 121 122 </td></tr><tr><td> ReqSourceCount2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 123 </td></tr><tr><td> ReqSourceCount3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 124 125 </td></tr><tr><td> ReqSourceCount4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 126 </td></tr><tr><td> ReqSourceRef1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 127 128 </td></tr><tr><td> ReqSourceRef2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 129 </td></tr><tr><td> ReqSourceRef3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 130 131 </td></tr><tr><td> ReqSourceRef4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 132 </td></tr><tr><td> ReqCreatureOrGOId1 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 133 134 </td></tr><tr><td> ReqCreatureOrGOId2 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 135 </td></tr><tr><td> ReqCreatureOrGOId3 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 136 137 </td></tr><tr><td> ReqCreatureOrGOId4 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 138 </td></tr><tr><td> ReqCreatureOrGOCount1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 139 140 </td></tr><tr><td> ReqCreatureOrGOCount2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 141 </td></tr><tr><td> ReqCreatureOrGOCount3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 142 143 </td></tr><tr><td> ReqCreatureOrGOCount4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 144 </td></tr><tr><td> ReqSpellCast1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 145 146 </td></tr><tr><td> ReqSpellCast2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 147 </td></tr><tr><td> ReqSpellCast3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 148 149 </td></tr><tr><td> ReqSpellCast4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 150 </td></tr><tr><td> RewChoiceItemId1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 151 152 </td></tr><tr><td> RewChoiceItemId2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 153 </td></tr><tr><td> RewChoiceItemId3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 154 155 </td></tr><tr><td> RewChoiceItemId4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 156 </td></tr><tr><td> RewChoiceItemId5 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 157 158 </td></tr><tr><td> RewChoiceItemId6 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 159 </td></tr><tr><td> RewChoiceItemCount1</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 160 161 </td></tr><tr><td> RewChoiceItemCount2</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 162 </td></tr><tr><td> RewChoiceItemCount3</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 163 164 </td></tr><tr><td> RewChoiceItemCount4</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 165 </td></tr><tr><td> RewChoiceItemCount5</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 166 167 </td></tr><tr><td> RewChoiceItemCount6</td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 168 </td></tr><tr><td> RewItemId1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 169 170 </td></tr><tr><td> RewItemId2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 171 </td></tr><tr><td> RewItemId3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 172 173 </td></tr><tr><td> RewItemId4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 174 </td></tr><tr><td> RewItemCount1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 175 176 </td></tr><tr><td> RewItemCount2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 177 </td></tr><tr><td> RewItemCount3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 178 179 </td></tr><tr><td> RewItemCount4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 180 </td></tr><tr><td> RewRepFaction1 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 181 182 </td></tr><tr><td> RewRepFaction2 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 183 </td></tr><tr><td> RewRepFaction3 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 184 185 </td></tr><tr><td> RewRepFaction4 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 186 </td></tr><tr><td> RewRepFaction5 </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 187 188 </td></tr><tr><td> RewRepValue1 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 189 </td></tr><tr><td> RewRepValue2 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 190 191 </td></tr><tr><td> RewRepValue3 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 192 </td></tr><tr><td> RewRepValue4 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 193 194 </td></tr><tr><td> RewRepValue5 </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 195 </td></tr><tr><td> RewOrReqMoney </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 196 197 </td></tr><tr><td> RewXpOrMoney </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 198 </td></tr><tr><td> RewSpell </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 199 200 </td></tr><tr><td> PointMapId </td><td> int(11) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 201 </td></tr><tr><td> PointX </td><td> float </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 202 203 </td></tr><tr><td> PointY </td><td> float </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 204 </td></tr><tr><td> PointOpt </td><td> int(2) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 205 206 </td></tr><tr><td> OfferRewardEmote </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 207 </td></tr><tr><td> RequestItemsEmote </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 1 </td><td> 208 209 </td></tr><tr><td> CompleteScript </td><td> int(11) </td><td> </td><td> No </td><td> </td><td> 0 </td><td> 210 </td></tr><tr><td> Repeatable </td><td> tinyint(1) </td><td> UNSIGNED </td><td> No </td><td> </td><td> 0 </td><td> 211 212 </td></tr></table> 213 <h2 id="entry">entry</h2> 214 <p> 215 Quest Id. <br /> 216 Quest ID is the Primary Key for the Table. Each Quest ID must be unique! <br /> 217 </p> 218 <h2 id="ZoneOrSort"><a class="missing wiki" href="/trac/MaNGOS/wiki/ZoneOrSort" rel="nofollow">ZoneOrSort?</a></h2> 219 <p> 220 If value > 0 then value is Zone IDs taken from <a class="wiki" href="/trac/MaNGOS/wiki/DBFilesClient/AreaTable">AreaTable.dbc</a>. See <a class="wiki" href="/trac/MaNGOS/wiki/ZoneId">ZoneId</a><br /> 221 222 </p> 223 <p> 224 if value < 0 then (-value) is quest sort id: 225 </p> 226 <table class="wiki"> 227 <tr><td> <strong>ID</strong> </td><td> <strong>Name</strong> </td><td> <strong>ID</strong> </td><td> <strong>Name</strong> 228 229 </td></tr><tr><td> 1 </td><td> Epic </td><td> 182 </td><td> Leatherworking 230 </td></tr><tr><td> 21 </td><td> REUSE - old wailing caverns </td><td> 201 </td><td> Engineering 231 </td></tr><tr><td> 22 </td><td> Seasonal </td><td> 221 </td><td> Treasure Map 232 233 </td></tr><tr><td> 23 </td><td> REUSE - old undercity one </td><td> 241 </td><td> REUSE - old sunken temple 234 </td></tr><tr><td> 24 </td><td> Herbalism </td><td> 261 </td><td> Hunter 235 </td></tr><tr><td> 25 </td><td> REUSE - old scarlet monastery </td><td> 262 </td><td> Priest 236 237 </td></tr><tr><td> 41 </td><td> REUSE - old uldaman </td><td> 263 </td><td> Druid 238 </td></tr><tr><td> 61 </td><td> Warlock </td><td> 264 </td><td> Tailoring 239 </td></tr><tr><td> 81 </td><td> Warrior </td><td> 284 </td><td> Special 240 241 </td></tr><tr><td> 82 </td><td> Shaman </td><td> 304 </td><td> Cooking 242 </td></tr><tr><td> 101 </td><td> Fishing </td><td> 324 </td><td> First Aid 243 </td></tr><tr><td> 121 </td><td> Blacksmithing </td><td> 344 </td><td> Legendary 244 245 </td></tr><tr><td> 141 </td><td> Paladin </td><td> 364 </td><td> Darkmoon Faire 246 </td></tr><tr><td> 161 </td><td> Mage </td><td> 365 </td><td> Ahn'Qiraj War 247 </td></tr><tr><td> 162 </td><td> Rogue </td><td> 366 </td><td> Lunar Festival 248 249 </td></tr><tr><td> 181 </td><td> Alchemy </td><td> 367 </td><td> Reputation 250 </td></tr></table> 251 <p> 252 IDs for <a class="missing wiki" href="/trac/MaNGOS/wiki/DBFilesClient/QuestSort" rel="nofollow">QuestSort.dbc?</a> which contains information about quest sorting <br /> 253 </p> 254 <h2 id="MinLevel">MinLevel</h2> 255 256 <p> 257 Minimum level required to get the quest. <br /> 258 </p> 259 <h2 id="QuestLevel">QuestLevel</h2> 260 <p> 261 Level of quest. Player recieves full experience amount only if their level is less than or equal to <a class="missing wiki" href="/trac/MaNGOS/wiki/QuestLevel" rel="nofollow">QuestLevel?</a>+5<br /> 262 </p> 263 <h2 id="Type">Type</h2> 264 <p> 265 Quest type is taken from <a class="wiki" href="/trac/MaNGOS/wiki/DBFilesClient/QuestInfo">QuestInfo.dbc</a><br /> 266 267 </p> 268 <table class="wiki"> 269 <tr><td> <strong>Value</strong> </td><td> <strong>Type</strong> 270 </td></tr><tr><td> 1 </td><td> Elite 271 </td></tr><tr><td> 21 </td><td> Life 272 </td></tr><tr><td> 41 </td><td> PvP 273 274 </td></tr><tr><td> 62 </td><td> Raid 275 </td></tr><tr><td> 81 </td><td> Dungeon 276 </td></tr><tr><td> 82 </td><td> World Event 277 </td></tr></table> 278 <h2 id="RequiredRaces">RequiredRaces</h2> 279 <p> 280 Races required to get the quest. 0 means available for all races.<br /> 281 282 Field's value is a decimal value that must be transform to a 8 bits binary in order to be understandable.<br /> 283 In binary form, each different bit represent a different race. They're assigned as follow :<br /> 284 </p> 285 <table class="wiki"> 286 <tr><td> 128 </td><td> 64 </td><td> 32 </td><td> 16 </td><td> 8 </td><td> 4 </td><td> 2 </td><td> 1 287 288 </td></tr><tr><td> Troll </td><td> Gnome </td><td> Tauren </td><td>Undead </td><td> NightElf </td><td> Dwarf </td><td> Orc </td><td> Human 289 </td></tr></table> 290 <p> 291 292 Example : <br /> 293 Int field value : 77 <br /> 294 Assigning bits from the left to the right :<br /> 295 </p> 296 <table class="wiki"> 297 <tr><td> 128 </td><td> 64 </td><td> 32 </td><td> 16 </td><td> 8 </td><td> 4 </td><td> 2 </td><td> 1 298 299 </td></tr><tr><td> Troll </td><td> Gnome </td><td> Tauren </td><td>Undead </td><td> NightElf </td><td> Dwarf </td><td> Orc </td><td> Human 300 </td></tr><tr><td> 0 </td><td> 1 </td><td> 0 </td><td> 0 </td><td> 1 </td><td> 1 </td><td> 0 </td><td> 1 301 302 </td></tr></table> 303 <p> 304 Then, quest is for races : Human, Dwarf, NightElf, Gnome. In other words, add the values in the above table together for the classes you want. Another example: To make a quest for Humans and Dwarves, add 1 and 4 together to get 5.<br /> 305 </p> 306 <h2 id="RequiredSkillValue">RequiredSkillValue</h2> 307 <p> 308 Player skill value requirement for skill if in <a class="missing wiki" href="/trac/MaNGOS/wiki/ZoneOrSort" rel="nofollow">ZoneOrSort?</a> field < 0 and have some from skill related values. 309 </p> 310 <h2 id="RequiredRepFaction">RequiredRepFaction</h2> 311 312 <p> 313 FactionTemplate ID for reputation requirement. See <a class="wiki" href="/trac/MaNGOS/wiki/Database/Faction">Faction</a> <br /> 314 </p> 315 <h2 id="RequiredRepValue">RequiredRepValue</h2> 316 <p> 317 Players must have this reputation or higher in order to receive the quest <br /> 318 </p> 319 <h2 id="LimitTime">LimitTime</h2> 320 <p> 321 If quest is time limited, field contains the limit, in seconds. <br /> 322 323 </p> 324 <h2 id="SpecialFlags">SpecialFlags</h2> 325 <ul><li>QUEST_SPECIAL_FLAGS_NONE = 0 326 </li><li>QUEST_SPECIAL_FLAGS_DELIVER = 1 327 </li><li>QUEST_SPECIAL_FLAGS_EXPLORATION = 2 328 </li><li>QUEST_SPECIAL_FLAGS_SPEAKTO = 4 329 </li><li>QUEST_SPECIAL_FLAGS_KILL_OR_CAST = 8 330 </li><li>QUEST_SPECIAL_FLAGS_TIMED = 16 331 </li><li>Flag 32 unknown 332 </li><li>QUEST_SPECIAL_FLAGS_REPUTATION = 64 <br /> 333 </li></ul><h2 id="PrevQuestId">PrevQuestId</h2> 334 <p> 335 If value > 0: Contains the previous quest id, that must be completed before this quest can be started. <br /> 336 337 If value < 0: Contains the parent quest id, that must be active before this quest can be started. <br /> 338 If quest have many alternative previous quests (race specific quests lead to single not race specific quest) 339 field NextQuestId in previous quests can used for setting this dependence. <br /> 340 Mangos check completing of PrevQuestId for this quest and completing of all quests that have NextQuestId == this quest id, one completion is enough to allow starting this quest. 341 </p> 342 <h2 id="NextQuestId">NextQuestId</h2> 343 <p> 344 If value > 0: Contains the next quest id, if PrevQuestId of that quest is not sufficient. <br /> 345 If value < 0: Contains the sub quest id, if PrevQuestId of that quest is not sufficient. <br /> 346 347 If quest have many alternative next quests (class specific quests lead from single not class specific quest) 348 field PrevQuestId in next quests can used for setting this dependence. <br /> 349 </p> 350 <h2 id="ExclusiveGroup">ExclusiveGroup</h2> 351 <p> 352 if <a class="missing wiki" href="/trac/MaNGOS/wiki/ExclusiveGroup" rel="nofollow">ExclusiveGroup?</a> > 0 353 </p> 354 <p> 355 Allows to define a group of quests of which only one may be chosen and completed. <br /> 356 E.g. if from quests 1200, 1201 and 1202 only one should be allowed to be chosen, insert 1200 into ExclusiveGroup of all 3 quests. <br /> 357 358 </p> 359 <p> 360 if <a class="missing wiki" href="/trac/MaNGOS/wiki/ExclusiveGroup" rel="nofollow">ExclusiveGroup?</a> < 0 361 </p> 362 <p> 363 Allows to define a group of quests of which all must be completed and rewarded to start next quest. <br /> 364 E.g. if quest 1000 dependent from onw of quests 1200, 1201 and 1202 and all this quests have same negative exclusive group 365 then all this quest mustbe completed and rewareded before quest 1000 can be started. <br /> 366 </p> 367 <h2 id="NextQuestInChain">NextQuestInChain</h2> 368 <p> 369 370 Defines quest chains, the details of the entered quest will be automatically opened when this quest is completed. <br /> 371 Only works when the quest rewarder of this quest is the quest giver of the entered quest. <br /> 372 </p> 373 <h2 id="srcItem">srcItem</h2> 374 <p> 375 Item's ID given by the quest giver at beginning of the quest. <br /> 376 Items will be deleted when quest is abandoned. <br /> 377 </p> 378 <h2 id="srcItemCount">srcItemCount</h2> 379 <p> 380 Number of Item given at quest start. <br /> 381 382 </p> 383 <h2 id="SrcSpell">SrcSpell</h2> 384 <p> 385 Spell casted on player when quest is started. Can be a buff or a learning spell. <br /> 386 </p> 387 <h2 id="Title">Title</h2> 388 <p> 389 Title of the quest. <br /> 390 </p> 391 <h2 id="Details">Details</h2> 392 <p> 393 Long quest's description. <br /> 394 395 </p> 396 <h2 id="Objectives">Objectives</h2> 397 <p> 398 Objectives of the quest. <br /> 399 If empty, quest is an auto-complete quest that can be immediately finished without accepting it first. <br /> 400 </p> 401 <h2 id="OfferRewardText">OfferRewardText</h2> 402 <p> 403 First text send to the player by the NPC when completing the quest. <br /> 404 </p> 405 <h2 id="RequestItemsText">RequestItemsText</h2> 406 407 <p> 408 This text ist send to player, yet did not terminate the Quest and speak with NPC again! <br /> 409 </p> 410 <h2 id="EndText">EndText</h2> 411 <p> 412 This text is indicated to the player, if you open your Questlog and wars send to player ingame. No Change this! <br /> 413 </p> 414 <h2 id="ObjectiveText1-4">ObjectiveText1-4</h2> 415 <p> 416 Used to define non-standard objective texts. <br /> 417 </p> 418 <h2 id="ReqItemId1-4">ReqItemId1-4</h2> 419 420 <p> 421 Item_template Id of the 1.-4. required item to complete the quest. (if any) <br /> 422 </p> 423 <h2 id="ReqItemCount1-4">ReqItemCount1-4</h2> 424 <p> 425 Amount of 1.-4. required items. <br /> 426 </p> 427 <h2 id="ReqSourceId1-4">ReqSourceId1-4</h2> 428 <p> 429 These fields are used in core quest-drop logic. They allow players to get quest drops which are not quest delivery items 430 (ReqItem stand for this), but needed to create quest delivery by player or needed to cast ReqSpellCasts. 431 ReqSourceId1 is the item_template id of a source item for creation of ReqItemX or casting of ReqSpellCastX. X is the value of ReqSourceRef1. 432 Only items which have a quest drop chance (having QuestChance > 0 in *_loot_template) should be used as sources here. 433 </p> 434 435 <p> 436 The same for ReqSourceId2-4 <br /> 437 You may define 1, 2, 3 or even all 4 sources for the same ReqItem/ReqSpellCast or use 4 sources for 4 ReqItems/ReqSpellCasts. 438 </p> 439 <h2 id="ReqSourceCount1-4">ReqSourceCount1-4</h2> 440 <p> 441 Amount of ReqSourceId items the player may gather per unfinished ReqItemId or ReqSpellCast. <br /> 442 So ReqSourceId1 items will drop up to a total amount of (ReqItemCount(ReqSourceRef1) - already owned ReqItemId(ReqSourceRef1)) * ReqSourceCount1. Same for ReqSpellCast objectives. <br /> 443 </p> 444 <h2 id="ReqSourceRef1-4">ReqSourceRef1-4</h2> 445 <p> 446 Should be 0 or 1..4. See ReqSourceId description. <br /> 447 448 </p> 449 <h2 id="ReqCreatureOrGOId1-4">ReqCreatureOrGOId1-4</h2> 450 <p> 451 Value > 0: 1.-4. required creature_template ID the player needs to kill/cast on in order to complete the quest.<br /> 452 Value < 0: 1.-4. required gameobject_template ID the player needs to cast on in order to complete the quest. <br /> 453 If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. 454 </p> 455 <h2 id="ReqCreatureOrGOCount1-4">ReqCreatureOrGOCount1-4</h2> 456 457 <p> 458 Number of kills/casts needed on 1.-4. creature or gameobject. <br /> 459 </p> 460 <h2 id="ReqSpellCast1-4">ReqSpellCast1-4</h2> 461 <p> 462 Spell ID of Spell that needs to be cast in order to fulfill a quest objective. <br /> 463 If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. 464 </p> 465 <h2 id="RewChoiceItemId1-6">RewChoiceItemId1-6</h2> 466 <p> 467 Id of the 1.-6. Item available for reward choice. <br /> 468 469 </p> 470 <h2 id="RewChoiceItemCount1">RewChoiceItemCount1</h2> 471 <p> 472 Number of Charges in the 1.-6. rewarded item available. <br /> 473 </p> 474 <h2 id="RewItemId1-4">RewItemId1-4</h2> 475 <p> 476 1.-4. item Id given for reward (no choice). <br /> 477 </p> 478 <h2 id="RewItemCount1-4">RewItemCount1-4</h2> 479 <p> 480 Number of RewItem1-4. <br /> 481 482 </p> 483 <h2 id="RewRepFaction1-5">RewRepFaction1-5</h2> 484 <p> 485 Faction Id (from Faction.dbc in this case) for which the quest give reputation points. <br /> 486 </p> 487 <h2 id="RewRepValue1-5">RewRepValue1-5</h2> 488 <p> 489 Number of gain or lost reputation points for Faction1-5 at quest completion.<br /> 490 This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically.<br /> 491 </p> 492 <h2 id="RewOrReqMoney">RewOrReqMoney</h2> 493 494 <p> 495 Money earned by completing the quest (if value > 0). Money quest requirement (if value < 0). <br /> 496 </p> 497 <h2 id="RewXpOrMoney">RewXpOrMoney</h2> 498 <p> 499 Experience or money (when player's level = maxlevel) given when completing the quest. Only given once for repeatable quests.<br /> 500 </p> 501 <h2 id="RewSpell">RewSpell</h2> 502 <p> 503 504 Spell casted at player when completing the quest. 505 This can be learn spell and player learned some spell in result, or buff spell, for example. <br /> 506 </p> 507 <h2 id="PointMapId">PointMapId</h2> 508 <p> 509 MapId of a quest point of interest (POI). <br /> 510 POI will be shown on the map when quest is active. <br /> 511 </p> 512 <h2 id="PointX">PointX</h2> 513 <p> 514 X coordinate of quest POI. <br /> 515 </p> 516 517 <h2 id="PointY">PointY</h2> 518 <p> 519 Y coordinate of quest POI. <br /> 520 </p> 521 <h2 id="PointOpt">PointOpt</h2> 522 <p> 523 !!! Need info here : Feel free to document if you know. !!! <br /> 524 </p> 525 <h2 id="OfferRewardEmoteRequestItemsEmote">OfferRewardEmote, RequestItemsEmote</h2> 526 <p> 527 Emote that creature show at request quest details, show incompleted quest and completing quest<br /> 528 529 </p> 530 <h2 id="CompleteScript">CompleteScript</h2> 531 <p> 532 !!! Need info here : Feel free to document if you know. !!! <br /> 533 </p> 534 <h2 id="Repeatable">Repeatable</h2> 535 <p> 536 Is quest repeatable? 1 yes 0 no <br /> 537 </p> 538 <hr /> 539 <p> 540 See also: <a class="wiki" href="/trac/MaNGOS/wiki/Database">Database</a>. 541 542 </p> */ 543 ?> 15 544 16 545 <?php -
db/include/questy.php
r76 r82 6 6 <input type="hidden" name="id" value="questy" class="hidden"> 7 7 <table class="search_form" border="0" cellspacing="0" cellpadding="2"> 8 <tr><td><label for="q uest">Hledat:</label></td><td colspan='3'><input type="text" name="quest" id="quest" value="<?php echo stripslashes($_GET['quest']); ?>"></td></tr>8 <tr><td><label for="q">Hledat:</label></td><td colspan='3'><input type="text" name="q" id="q" value="<?php echo $q; ?>"></td></tr> 9 9 <tr><td>Level <label for="lvl_d">od:</label></td><td><input type="text" name="lvl_d" id="lvl_d" maxlength="3" style="width: 45px;" value="<?php echo $lvl_d; ?>"></td><td><label for="lvl_h">do:</label></td><td><input type="text" name="lvl_h" id="lvl_h" maxlength="3" style="width: 45px;" value="<?php echo $lvl_h; ?>"></td><td><input type="submit" value="Hledat" name="quest_find"></td></tr> 10 10 </table><?php if(!empty($session_id)){ ?><input type="hidden" name="PHPSESSID" value="<?php echo $session; ?>" class="hidden"><?php }; ?></form> 11 <?php if(array_key_exists('quest', $_GET)){ ?> 12 <?php echo $sql_select['result']; ?> 13 <?php }; ?> 14 11 <?php echo $sql_select['result']; ?> 15 12 16 13 <?php -
db/include/uvod.php
r76 r82 15 15 klidně pište na ICQ 327671143 nebo na E-mail: HosipLan<!-- spam ochrana -->@<!-- spam ochrana -->seznam.cz</p> 16 16 17 <h4>Aktuality:</h4> 18 19 <p>HosipLan 19.září.2007<br> 20 Teď nám funguje: <br> 21 -Hledání Questů a nějaké základní údaje o nich.<br> 22 -Návozanost Questu na Creepa a jeho výpis už taky částečně funguje.</p> 23 24 25 <p> </p><p>Postupujeme kvůli časové tísni velice pomalinku.<br> 26 Pokud by chctěl někdo nějak přiložit ruku tak to jedině uvítám</p> 27 28 <h4>Na projektu se podílejí:</h4> 29 30 <ul id="ucast"> 31 <li>HosipLan <ul> 32 <li>Základní struktura stránky</li> 33 <li>Základní grafika</li> 34 <li>Hledání questů</li> 35 <li>Základní výpis Questů</li> 36 <li>Základní výpis Creepů</li> 37 </ul></li> 38 <li>Bbtrash <ul> 39 <li>Konzultace v nesnázích a psychycká podpora :)</li> 40 <li>Nějaká ta rada ohledně databáze.</li> 41 </ul></li> 42 <li>Chronos <ul> 43 <li>Konzultace v nesnázích a psychycká podpora :)</li> 44 <li>Nějaká ta rada ohledně databáze.</li> 45 </ul></li> 46 <li>Perihelion <ul> 47 <li>Konzultace v nesnázích a psychycká podpora :)</li> 48 <li>Nějaká ta rada ohledně databáze.</li> 49 </ul></li> 50 <li>Borci <ul> 51 <li>Úprava titulního obrázku</li> 52 </ul></li> 53 </ul> 54 55 <p>Tímto děkuji všem co se jakkoliv zapojili.</p> 56 17 57 <?php 18 58 }; -
db/index.php
r77 r82 5 5 6 6 /* =========== Config =========== */ 7 if( !file_exists('./config.php') ){ exit; }; 7 8 require_once './config.php'; 8 9 9 10 /* =========== Připojení k Databázi =========== */ 10 11 11 @mysql_connect( $Config['D atabase']['Host'], $Config['Database']['User'], $Config['Database']['Password'] )12 @mysql_connect( $Config['DB_read']['Database']['Host'], $Config['DB_read']['Database']['User'], $Config['DB_read']['Database']['Password'] ) 12 13 OR DIE("<p>Vyskytla se chyba a nelze se připojit k databázi.<br> Zkuste to později.</p>"); 13 mysql_select_db($Config['DB_read']['Database'])14 OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['D atabase']."!</p>");15 mysql_query("SET NAMES ".$Config['DB_read']['Charset']);14 @mysql_select_db($Config['DB_read']['DB_read']['Database']) 15 OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database']."!</p>"); 16 @mysql_query("SET NAMES ".$Config['DB_read']['DB_read']['Charset']); 16 17 17 18 /* =========== Speciální FCE =========== */ … … 20 21 $str = @str_replace("\r","",$str); 21 22 return $str; 23 }; 24 25 function AbsCheck($int){ return (abs($int)==$int)? true : false; }; 26 27 function CheckQuestRace(){ 28 22 29 }; 23 30 … … 108 115 /* =========== GET hodnoty =========== */ 109 116 $id = $_GET['id']; // tady získá id z adresy 117 $q = addslashes($_GET['q']); 110 118 $limit = $_GET['list']; // tady získá list z adresy 111 119 if( is_numeric($limit) == FALSE ){ unset($limit); }; 112 120 if( $limit < 1 OR empty($limit) ){ $limit = 1; }; 113 121 $quest = addslashes($_GET['quest']); 122 if( is_numeric($quest) == FALSE ){ unset($quest); }; 123 $creature = addslashes($_GET['creature']); 124 if( is_numeric($creature) == FALSE ){ unset($creature); }; 114 125 $lvl_d = addslashes($_GET['lvl_d']); 115 126 if( is_numeric($lvl_d) == FALSE ){ unset($lvl_d); }; -
db/obsah.php
r76 r82 2 2 if($vlozeni_souboru == "OK"){ 3 3 4 if( !empty($id) ){ 4 5 if( $id == "uvod" ){ $file = "uvod"; $nadpis = "Úvod"; } 5 6 elseif( $id == "stats" ){ $file = "stats"; $nadpis = "Statistiky"; } … … 28 29 else{ $file = "uvod"; $nadpis = "Úvod"; }; 29 30 30 if ( File_Exists("./include/".$file.".php") ){31 if( File_Exists("./include/".$file.".php") ){ 31 32 $file = "./include/".$file.".php"; 32 } else{ $file = "./include/uvod.php"; }; 33 34 if( !empty($quest) ){ 35 /* $novinka_dotaz_nadpis = @mysql_query("SELECT nadpis FROM novinky WHERE id='".$novinka."' LIMIT 1"); 36 if( mysql_num_rows($novinka_dotaz_nadpis) == "1" ) { $i = "0"; 37 while( $result = @MySQL_Fetch_Array($novinka_dotaz_nadpis) ){ 38 $nadpis_novinky[$i] = $result["nadpis"]; 39 }; 40 } else{ $nadpis_novinky[0] = "Chyba"; }; 41 $file = "novinka"; $nadpis = $nadpis_novinky[0]; 42 if( File_Exists($file.".php") ) { 43 $file = $file.".php"; 44 }; */ 45 }; 33 }; 34 } 35 elseif( !empty($quest) ){ 36 $quest_dotaz_nadpis = mysql_query("SELECT `Title` FROM `quest_template` WHERE `entry`='".$quest."' LIMIT 1"); 37 if( mysql_num_rows($quest_dotaz_nadpis) == "1" ) { $i = "0"; 38 $result = MySQL_Fetch_Array($quest_dotaz_nadpis); 39 $nadpis_quest = $result["Title"]; 40 } else{ $nadpis_quest = "Chyba !"; }; 41 $file = "./include/quest.php"; $nadpis = "Quest: ".$nadpis_quest; 42 if( !File_Exists($file) ){ $file = "./include/uvod.php"; }; 43 } 44 elseif( !empty($creature) ){ 45 $creature_dotaz_nadpis = mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1"); 46 if( mysql_num_rows($creature_dotaz_nadpis) == "1" ) { $i = "0"; 47 $result = @MySQL_Fetch_Array($creature_dotaz_nadpis); 48 $nadpis_creature = $result["name"]; 49 $nadpis_creature .= (!empty($result['subname']))?" <".$result['subname'].">":""; 50 } else{ $creature_quest = "Chyba !"; }; 51 $file = "./include/creep.php"; $nadpis = "Creep: ".$nadpis_creature; 52 if( !File_Exists($file) ){ $file = "./include/uvod.php"; }; 53 } 54 else{ $file = "./include/uvod.php"; }; 46 55 ?> 47 56 <h1><?php echo $nadpis; ?></h1> -
db/post_read.php
r78 r82 5 5 <?php 6 6 7 if( array_key_exists('quest', $_GET) AND !empty($id) ){7 if( !empty($q) AND !empty($id) ){ 8 8 if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; }; 9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q uest%' )", $limit, 20, "?id=questy&quest=".$quest."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID);10 if( @mysql_num_rows($sql_select[1]) > "0" ) { $i = "0";9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&q=".$q."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID); 10 if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 11 11 $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n"; 12 12 $sql_select['result'] .= "<thead><tr><td>Název úkolu</td><td>Min level</td><td>Úkol zadává</td><td>Úkol</td></tr></thead>\n<col width=\"180px\"><col width=\"70px\">"; 13 13 14 while( $result = @MySQL_Fetch_Array($sql_select[1]) ){14 while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 15 15 $sql_select['result'] .= " <tr valign='top'>"; 16 16 $sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry']."\">".$result['Title']."</a></td>"; … … 35 35 }; 36 36 37 }; 37 } 38 elseif( !empty($quest) AND empty($id) ){ 39 $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;"); 40 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 41 $result = MySQL_Fetch_Array($sql_select['sql']); 42 $sql_select['quest'] = $result; 43 44 // Zjištění creatur a gameobjectů kde se Quest dá vzít 45 $startovni_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$sql_select['quest']['entry']." "); 46 if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){ 47 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 48 $sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n"; 49 }; }; 50 $startovni_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$sql_select['quest']['entry']." "); 51 if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){ 52 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 53 $sql_select['other']['StartNPC'] .= "<a href=\"index.php?gameobject=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n"; 54 }; }; 55 if( empty($sql_select['other']['StartNPC']) ){ 56 $sql_select['other']['StartNPC'] = "<b>Úkol není kde začít!<br> Nahlaste to prosím adminovy!</b>"; } 57 58 // Zjištění Oblasti 59 if( AbsCheck($sql_select['quest']['ZoneOrSort']) ){ } 60 else{ }; 61 62 // Důležitá věc 63 $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;"); 64 if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){ 65 $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz); 66 $sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry']."\">".$SrcItemId['name']."</a><br>\n"; 67 }; 68 69 $sql_select['quest']['PrevQuestId']; 70 $sql_select['quest']['NextQuestId']; 71 72 $sql_select['other']['ReqItems']; // ReqItemId1-4.ReqItemCount1-4 73 74 $sql_select['other']['ReqSource']; // ?? 75 /* ReqSourceId1-4 76 These fields are used in core quest-drop logic. They allow players to get quest drops which are not quest delivery items (ReqItem stand for this), but needed to create quest delivery by player or needed to cast ReqSpellCasts. ReqSourceId1 is the item_template id of a source item for creation of ReqItemX or casting of ReqSpellCastX. X is the value of ReqSourceRef1. Only items which have a quest drop chance (having QuestChance > 0 in *_loot_template) should be used as sources here. 77 The same for ReqSourceId2-4 78 You may define 1, 2, 3 or even all 4 sources for the same ReqItem/ReqSpellCast or use 4 sources for 4 ReqItems/ReqSpellCasts. 79 ReqSourceCount1-4 80 Amount of ReqSourceId items the player may gather per unfinished ReqItemId or ReqSpellCast. 81 So ReqSourceId1 items will drop up to a total amount of (ReqItemCount(ReqSourceRef1) - already owned ReqItemId(ReqSourceRef1)) * ReqSourceCount1. Same for ReqSpellCast objectives. 82 ReqSourceRef1-4 83 Should be 0 or 1..4. See ReqSourceId description. */ 84 85 $sql_select['other']['ReqCreatureOrGOId']; // need to kill/cast 86 /* Value > 0: 1.-4. required creature_template ID the player needs to kill/cast on in order to complete the quest. 87 Value < 0: 1.-4. required gameobject_template ID the player needs to cast on in order to complete the quest. 88 If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */ 89 90 $sql_select['other']['ReqSpellCast']; 91 /* Spell ID of Spell that needs to be cast in order to fulfill a quest objective. 92 If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */ 93 94 $sql_select['other']['ReqSpellCast']; 95 /* Spell ID of Spell that needs to be cast in order to fulfill a quest objective. 96 If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */ 97 98 $sql_select['other']['RewChoiceItemId']; // !!! RewChoiceItemCount 99 /* Id of the 1.-6. Item available for reward choice. */ 100 101 $sql_select['other']['RewItemId']; // !!! RewItemCount 102 /* 1.-4. item Id given for reward (no choice). */ 103 104 105 } else{ $sql_select['error'] = "<p>Quest nebyl nalezen.</p>"; }; 106 107 } 108 elseif( !empty($creature) AND empty($id) ){ 109 $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;"); 110 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 111 $result = MySQL_Fetch_Array($sql_select['sql']); 112 $sql_select['creature'] = $result; 113 114 $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) "); 115 if( @mysql_num_rows($questy_dotaz_creature) > 0 ){ 116 while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){ 117 $sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry']."\">".$quest_NPC['Title']."</a><br>\n"; 118 }; }; 119 120 } else{ $sql_select['error'] = "<p>Creep nebyl nalezen.</p>"; }; 121 122 }; 123 38 124 39 125 ?> -
navody/Navod_na_soutez_ve_splhani/index.html
r79 r82 147 147 V první řade umažu řádky, které začínají <b>DELETE FROM</b><br> 148 148 A pak doplním příkazy, které jsou uvedé výše v návodu.<br> 149 Vyjde mi z toho asi něco takového: < a href="vzhuru_nahoru/2007-09-23_logSQL.sql" target="_blank">2007-09-23_logSQL.sql</a><br>149 Vyjde mi z toho asi něco takového: <b><a href="vzhuru_nahoru/2007-09-23_logSQL.sql" target="_blank">2007-09-23_logSQL.sql</a></b><br> 150 150 Teď stačí použít jen phpMyAdmin nebo jiný nástroj na práci s databází a soubor můžete nahrát na Server.<br> 151 151 Teď už jen varovat hráče před restartem a může se žačít.<br><br>
Note:
See TracChangeset
for help on using the changeset viewer.