Jump to content

sqlnoob

Members
  • Posts

    173
  • Joined

  • Last visited

Everything posted by sqlnoob

  1. yup and its the invalid that works better (I know irony here). Can you give me a link to the other page, because I suspect it is one that only overlaps something like 90% and not completely (and hence it wouldn't work). I guess the only solution is the make the map a single layer tiles map (hello to travian style maps bah) perhaps I can ask the mac user to switch to safari, because the bug doesn't seem to appear in IE6, IE7, IE8 and safari, it only appears in FF2 and FF3. It really seems to be a FF only problem.
  2. FF2 compares to the newer version of Pong in the way IE6 compares to the older version of Pong (and its the older version that is better) to give you an analogy but anyway bottomline is like to find a solution to this problem, at least I'm hoping there is something that doesn't require me to make a 1 layer tile map, instead of what I have now. Hence why I am getting rather desperate to solve this.
  3. and this is why this page gives me the feeling to throw FireBUG out of the window and stop crossbrowser support alltogether if it weren't for the occasional Mac user, I'd disregard Firefox, but that is how I feel (no pun intended) when I switch layer 0 with layer 2, both layers will show, but then towns can't be clicked on (and that is no good either). It seems that whenever the top layer completely covers the bottom layers FF doesn't want to display the lower layers and that dbrimlow is what makes me think FF is bugged.
  4. again i've tried several ways, i set it to quirck mode (if that is what you call it), because that one seems to work the best (at least it works in IE)
  5. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML> <HEAD> <TITLE>shugo map</TITLE> <META NAME="keywords" CONTENT="Japan map"> <script type="text/javascript"> function loadImages() { if (document.getElementById) { document.getElementById('hidepage').style.visibility = 'hidden'; } } window.onload = loadImages; function scrollWindow() { window.scrollTo(600,900) } </script> <link rel="stylesheet" type="text/css" href="styles/mapstyle.css"/> </HEAD> <BODY onload="scrollWindow()" value="Scroll"> <div id="hidepage" style="background-color: #FFFFCC; layer-background-color: #FFFFCC; width: 100%;"> <table width=100%><tr><td>Map is loading ... Please wait.</td></tr></table></div> <?php if (isset($_COOKIE["person"])) { $you = $_COOKIE['person']; $con = mysql_connect("localhost","shugonl","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shugonl", $con); /*LAYER 0*/ //YOUR TOWNS $bluecapresult = mysql_query ("SELECT Yashiki FROM persons WHERE Clan ='$you'"); $bluecaprow = mysql_fetch_array($bluecapresult); $capitol = $bluecaprow['Yashiki']; echo "<IMG SRC='pictures/bluecap.gif' class='".$capitol."' BORDER='0' WIDTH='10' HEIGHT='10'>"; $blueresult = mysql_query ("SELECT * FROM Castles WHERE Castellan ='$you' AND Tenshu='0' AND CastleID <>'$capitol'"); while ($bluerow = mysql_fetch_array($blueresult)){ echo "<IMG SRC='pictures/blue.gif' class='".$bluerow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $bluecasresult = mysql_query ("SELECT * FROM Castles WHERE Castellan ='$you' AND Tenshu='1' AND CastleID <>'$capitol'"); while ($bluecasrow = mysql_fetch_array($bluecasresult)){ echo "<IMG SRC='pictures/bluecas.gif' class='".$bluecasrow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } //ENEMY TOWNS $redresult = mysql_query ("SELECT CastleID FROM Castles WHERE Castellan <>'$you' AND Tenshu='0'"); while ($redrow = mysql_fetch_array($redresult)){ echo "<IMG SRC='pictures/red.gif' class='".$redrow[CastleID]."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $redcasresult = mysql_query ("SELECT CastleID FROM Castles WHERE Castellan <>'$you' AND Tenshu='1'"); while ($redcasrow = mysql_fetch_array($redcasresult)){ echo "<IMG SRC='pictures/redcas.gif' class='".$redcasrow[CastleID]."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } /*LAYER 1*/ //VASSAL TOWNS $purpleresult = mysql_query ("SELECT A2.CastleID NOCASTLEF FROM persons A1, Castles A2 WHERE A1.Liege ='$you' AND A1.Clan = A2.Castellan <>'$you' AND A2.Tenshu='0'"); while ($purplerow = mysql_fetch_array($purpleresult)){ echo "<IMG SRC='pictures/purple.gif' class='".$purplerow[NOCASTLEF]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $purplecasresult = mysql_query ("SELECT A2.CastleID CASTLEF FROM persons A1, Castles A2 WHERE A1.Liege ='$you' AND A1.Clan = A2.Castellan <>'$you' AND A2.Tenshu='1'"); while ($purplecasrow = mysql_fetch_array($purplecasresult)){ echo "<IMG SRC='pictures/purplecas.gif' class='".$purplecasrow[CASTLEF]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } //LIEGE TOWNS $yellowresult = mysql_query ("SELECT A2.CastleID NOCASTLEL FROM persons A1, Castles A2 WHERE A1.Clan ='$you' AND A1.Liege = A2.Castellan <>'$you' AND A2.Tenshu='0'"); while ($yellowrow = mysql_fetch_array($yellowresult)){ echo "<IMG SRC='pictures/purple.gif' class='".$yellowrow[NOCASTLEL]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $yellowcasresult = mysql_query ("SELECT A2.CastleID NOCASTLEL FROM persons A1, Castles A2 WHERE A1.Clan ='$you' AND A1.Liege = A2.Castellan <>'$you' AND A2.Tenshu='1'"); while ($yellowcasrow = mysql_fetch_array($yellowcasresult)){ echo "<IMG SRC='pictures/purplecas.gif' class='".$yellowcasrow[NOCASTLEL]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } //ALLIED TOWNS $pinkresult = mysql_query ("SELECT A2.CastleID NOCASTLEA FROM Alliances A1, Castles A2 WHERE A1.Family ='$you' AND Marriage ='2' AND A1.Adopter = A2.Castellan <>'$you' AND A2.Tenshu='0'"); while ($pinkrow = mysql_fetch_array($pinkresult)){ echo "<IMG SRC='pictures/purple.gif' class='".$pinkrow[NOCASTLEA]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $pinkcasresult = mysql_query ("SELECT A2.CastleID NOCASTLEA FROM Alliances A1, Castles A2 WHERE A1.Family ='$you' AND Marriage ='2' AND A1.Adopter = A2.Castellan <>'$you' AND A2.Tenshu='1'"); while ($pinkcasrow = mysql_fetch_array($pinkcasresult)){ echo "<IMG SRC='pictures/purplecas.gif' class='".$pinkcasrow[NOCASTLEA]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $orangeresult = mysql_query ("SELECT A2.CastleID NOCASTLEA FROM Alliances A1, Castles A2 WHERE A1.Adopter ='$you' AND Marriage ='2' AND A1.Family = A2.Castellan <>'$you' AND A2.Tenshu='0'"); while ($orangerow = mysql_fetch_array($orangeresult)){ echo "<IMG SRC='pictures/purple.gif' class='".$orangerow[NOCASTLEA]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $orangecasresult = mysql_query ("SELECT A2.CastleID NOCASTLEA FROM Alliances A1, Castles A2 WHERE A1.Adopter ='$you' AND Marriage ='2' AND A1.Family = A2.Castellan <>'$you' AND A2.Tenshu='1'"); while ($orangecasrow = mysql_fetch_array($orangecasresult)){ echo "<IMG SRC='pictures/purplecas.gif' class='".$orangecasrow[NOCASTLEA]."F' BORDER='0' WIDTH='10' HEIGHT='10'>"; } /*LAYER 3*/ //YOUR ARMIES $armyresult = mysql_query ("SELECT DISTINCT Armylocation FROM Armies WHERE Armyclan ='$you'"); while ($armyrow = mysql_fetch_array($armyresult)){ echo "<IMG SRC='pictures/uma.gif' class='".$armyrow['Armylocation']."B' BORDER='0' WIDTH='5' HEIGHT='10'>"; } /*LAYER 2*/ } ?> <IMG SRC="pictures/nihon.gif" BORDER=1 WIDTH=1200 HEIGHT=1600 USEMAP="#japan" class="pos_abs"> <MAP NAME="japan"> <AREA SHAPE="rect" HREF="town.php?town=1" COORDS="505,1196,514,1207" ALT="Aki" title="Aki"> <AREA SHAPE="rect" HREF="town.php?town=2" COORDS="960,258,968,266" ALT="Akita" title="Akita"> <AREA SHAPE="rect" HREF="town.php?town=3" COORDS="163,1272,174,1282" ALT="Akizuki" title="Akizuki"> <AREA SHAPE="rect" HREF="town.php?town=4" COORDS="518,1023,526,1032" ALT="Ako" title="Ako"> <AREA SHAPE="rect" HREF="town.php?town=5" COORDS="704,910,713,920" ALT="Anegawa" title="Anegawa"> <AREA SHAPE="rect" HREF="town.php?town=6" COORDS="1066,849,1074,858" ALT="Arai" title="Arai"> <AREA SHAPE="rect" HREF="town.php?town=7" COORDS="782,734,791,743" ALT="Arakawa" title="Arakawa"> <AREA SHAPE="rect" HREF="town.php?town=8" COORDS="426,1231,435,1240" ALT="Asakura" title="Asakura"> <AREA SHAPE="rect" HREF="town.php?town=9" COORDS="694,950,705,960" ALT="Azuchi" title="Azuchi"> <AREA SHAPE="rect" HREF="town.php?town=10" COORDS="141,1263,150,1272" ALT="Dazaifu" title="Dazaifu"> <AREA SHAPE="rect" HREF="town.php?town=11" COORDS="1065,787,1074,797" ALT="Edo" title="Edo"> <AREA SHAPE="rect" HREF="town.php?town=12" COORDS="367,1055,376,1065" ALT="Fuchu" title="Fuchu"> <AREA SHAPE="rect" HREF="town.php?town=13" COORDS="656,1026,666,1035" ALT="Fujidera" title="Fujidera"> <AREA SHAPE="rect" HREF="town.php?town=14" COORDS="869,748,878,757" ALT="Fukashi" title="Fukashi"> <AREA SHAPE="rect" HREF="town.php?town=15" COORDS="968,860,977,869" ALT="Fukazawa" title="Fukazawa"> <AREA SHAPE="rect" HREF="town.php?town=16" COORDS="674,821,683,830" ALT="Fukui" title="Fukui"> <AREA SHAPE="rect" HREF="town.php?town=17" COORDS="178,1216,187,1225" ALT="Fukuoka" title="Fukuoka"> <AREA SHAPE="rect" HREF="town.php?town=18" COORDS="825,828,834,837" ALT="Fukushima" title="Fukushima"> <AREA SHAPE="rect" HREF="town.php?town=19" COORDS="393,1079,403,1088" ALT="Fukuyama" title="Fukuyama"> <AREA SHAPE="rect" HREF="town.php?town=20" COORDS="260,1295,269,1304" ALT="Funai" title="Funai"> <AREA SHAPE="rect" HREF="town.php?town=21" COORDS="660,974,669,983" ALT="Fushimi" title="Fushimi"> <AREA SHAPE="rect" HREF="town.php?town=22" COORDS="875,928,883,938" ALT="Futamata" title="Futamata"> <AREA SHAPE="rect" HREF="town.php?town=23" COORDS="764,877,773,886" ALT="Gifu" title="Gifu"> <AREA SHAPE="rect" HREF="town.php?town=24" COORDS="1002,748,1011,758" ALT="Hachigata" title="Hachigata"> <AREA SHAPE="rect" HREF="town.php?town=25" COORDS="1050,123,1059,131" ALT="Hachinohe" title="Hachinohe"> <AREA SHAPE="rect" HREF="town.php?town=26" COORDS="1024,798,1033,808" ALT="Hachioji" title="Hachioji"> <AREA SHAPE="rect" HREF="town.php?town=27" COORDS="235,1114,244,1124" ALT="Hagi" title="Hagi"> <AREA SHAPE="rect" HREF="town.php?town=28" COORDS="113,1265,122,1275" ALT="Hakata" title="Hakata"> <AREA SHAPE="rect" HREF="town.php?town=29" COORDS="300,1042,309,1051" ALT="Hamada" title="Hamada"> <AREA SHAPE="rect" HREF="town.php?town=30" COORDS="867,954,876,962" ALT="Hamamatsu" title="Hamamatsu"> <AREA SHAPE="rect" HREF="town.php?town=31" COORDS="128,1387,137,1397" ALT="Hara" title="Hara"> <AREA SHAPE="rect" HREF="town.php?town=32" COORDS="486,952,495,962" ALT="Hidaka" title="Hidaka"> <AREA SHAPE="rect" HREF="town.php?town=33" COORDS="524,1099,533,1108" ALT="Hikita" title="Hikita"> <AREA SHAPE="rect" HREF="town.php?town=34" COORDS="701,939,711,949" ALT="Hikone" title="Hikone"> <AREA SHAPE="rect" HREF="town.php?town=35" COORDS="566,999,575,1009" ALT="Himeji" title="Himeji"> <AREA SHAPE="rect" HREF="town.php?town=36" COORDS="25,1286,35,1296" ALT="Hirado" title="Hirado"> <AREA SHAPE="rect" HREF="town.php?town=37" COORDS="953,117,962,125" ALT="Hirosaki" title="Hirosaki"> <AREA SHAPE="rect" HREF="town.php?town=38" COORDS="332,1111,341,1120" ALT="Hiroshima" title="Hiroshima"> <AREA SHAPE="rect" HREF="town.php?town=39" COORDS="248,1176,256,1185" ALT="Hofu" title="Hofu"> <AREA SHAPE="rect" HREF="town.php?town=40" COORDS="635,978,644,987" ALT="Homoyama" title="Homoyama"> <AREA SHAPE="rect" HREF="town.php?town=41" COORDS="640,995,649,1004" ALT="Ibaraki" title="Ibaraki"> <AREA SHAPE="rect" HREF="town.php?town=42" COORDS="51,1321,60,1331" ALT="Iimori" title="Iimori"> <AREA SHAPE="rect" HREF="town.php?town=43" COORDS="390,1155,398,1164" ALT="Imabari" title="Imabari"> <AREA SHAPE="rect" HREF="town.php?town=44" COORDS="768,901,777,910" ALT="Inuyama" title="Inuyama"> <AREA SHAPE="rect" HREF="town.php?town=45" COORDS="1116,676,1125,685" ALT="Ishioka" title="Ishioka"> <AREA SHAPE="rect" HREF="town.php?town=46" COORDS="301,1158,310,1167" ALT="Iwakuni" title="Iwakuni"> <AREA SHAPE="rect" HREF="town.php?town=47" COORDS="853,877,863,886" ALT="Iwamura" title="Iwamura"> <AREA SHAPE="rect" HREF="town.php?town=48" COORDS="1046,780,1055,789" ALT="Iwatsuki" title="Iwatsuki"> <AREA SHAPE="rect" HREF="town.php?town=49" COORDS="132,1245,143,1256" ALT="Iwaya" title="Iwaya"> <AREA SHAPE="rect" HREF="town.php?town=50" COORDS="632,1052,641,1061" ALT="Izumi" title="Izumi"> <AREA SHAPE="rect" HREF="town.php?town=51" COORDS="173,1500,183,1510" ALT="Kagoshima" title="Kagoshima"> <AREA SHAPE="rect" HREF="town.php?town=52" COORDS="899,941,908,950" ALT="Kakegawa" title="Kakegawa"> <AREA SHAPE="rect" HREF="town.php?town=53" COORDS="1052,838,1061,847" ALT="Kamakura" title="Kamakura"> <AREA SHAPE="rect" HREF="town.php?town=54" COORDS="737,997,746,1007" ALT="Kameyama" title="Kameyama"> <AREA SHAPE="rect" HREF="town.php?town=55" COORDS="599,957,608,967" ALT="Kameyama" title="Kameyama"> <AREA SHAPE="rect" HREF="town.php?town=56" COORDS="960,799,969,808" ALT="Kamiizumi" title="Kamiizumi"> <AREA SHAPE="rect" HREF="town.php?town=57" COORDS="681,869,690,879" ALT="Kanagasaki" title="Kanagasaki"> <AREA SHAPE="rect" HREF="town.php?town=58" COORDS="1020,734,1029,743" ALT="Kanagawa" title="Kanagawa"> <AREA SHAPE="rect" HREF="town.php?town=59" COORDS="869,706,878,716" ALT="Kanawakajima" title="Kanawakajima"> <AREA SHAPE="rect" HREF="town.php?town=60" COORDS="935,746,944,755" ALT="Kanayama" title="Kanayama"> <AREA SHAPE="rect" HREF="town.php?town=61" COORDS="702,737,710,745" ALT="Kanazawa" title="Kanazawa"> <AREA SHAPE="rect" HREF="town.php?town=62" COORDS="951,887,961,896" ALT="Kanbara" title="Kanbara"> <AREA SHAPE="rect" HREF="town.php?town=63" COORDS="701,960,710,970" ALT="Kannonji" title="Kannonji"> <AREA SHAPE="rect" HREF="town.php?town=64" COORDS="1052,605,1060,614" ALT="Karasawayama" title="Karasawayama"> <AREA SHAPE="rect" HREF="town.php?town=65" COORDS="122,1252,131,1262" ALT="Karatsu" title="Karatsu"> <AREA SHAPE="rect" HREF="town.php?town=66" COORDS="1031,764,1040,774" ALT="Kawagoe" title="Kawagoe"> <AREA SHAPE="rect" HREF="town.php?town=67" COORDS="827,801,836,811" ALT="Kiso" title="Kiso"> <AREA SHAPE="rect" HREF="town.php?town=68" COORDS="763,915,772,924" ALT="Kiyosu" title="Kiyosu"> <AREA SHAPE="rect" HREF="town.php?town=69" COORDS="440,1192,450,1201" ALT="Kochi" title="Kochi"> <AREA SHAPE="rect" HREF="town.php?town=70" COORDS="934,814,943,823" ALT="Kofu" title="Kofu"> <AREA SHAPE="rect" HREF="town.php?town=71" COORDS="717,962,727,972" ALT="Koka" title="Koka"> <AREA SHAPE="rect" HREF="town.php?town=72" COORDS="245,1283,254,1293" ALT="Kokokufu" title="Kokokufu"> <AREA SHAPE="rect" HREF="town.php?town=73" COORDS="217,1521,227,1531" ALT="Kokubu" title="Kokubu"> <AREA SHAPE="rect" HREF="town.php?town=74" COORDS="150,1216,160,1225" ALT="Kokura" title="Kokura"> <AREA SHAPE="rect" HREF="town.php?town=75" COORDS="1078,765,1087,775" ALT="Konodai" title="Konodai"> <AREA SHAPE="rect" HREF="town.php?town=76" COORDS="689,780,698,789" ALT="Komatsu" title="Komatsu"> <AREA SHAPE="rect" HREF="town.php?town=77" COORDS="340,1078,349,1087" ALT="Koriyama" title="Koriyama"> <AREA SHAPE="rect" HREF="town.php?town=78" COORDS="163,1354,173,1364" ALT="Kumamoto" title="Kumamoto"> <AREA SHAPE="rect" HREF="town.php?town=79" COORDS="960,728,969,738" ALT="Kuragano" title="Kuragano"> <AREA SHAPE="rect" HREF="town.php?town=80" COORDS="408,978,418,987" ALT="Kurayoshi" title="Kurayoshi"> <AREA SHAPE="rect" HREF="town.php?town=81" COORDS="142,1290,151,1300" ALT="Kurume" title="Kurume"> <AREA SHAPE="rect" HREF="town.php?town=82" COORDS="1092,823,1101,832" ALT="Kururi" title="Kururi"> <AREA SHAPE="rect" HREF="town.php?town=83" COORDS="898,775,906,784" ALT="Kuwabara" title="Kuwabara"> <AREA SHAPE="rect" HREF="town.php?town=84" COORDS="657,959,666,968" ALT="Kyoto" title="Kyoto"> <AREA SHAPE="rect" HREF="town.php?town=85" COORDS="584,908,594,917" ALT="Maizuru" title="Maizuru"> <AREA SHAPE="rect" HREF="town.php?town=86" COORDS="478,1111,487,1121" ALT="Marugame" title="Marugame"> <AREA SHAPE="rect" HREF="town.php?town=87" COORDS="678,803,688,813" ALT="Maruoka" title="Maruoka"> <AREA SHAPE="rect" HREF="town.php?town=88" COORDS="365,971,373,980" ALT="Matsue" title="Matsue"> <AREA SHAPE="rect" HREF="town.php?town=89" COORDS="857,726,865,735" ALT="Matsumoto" title="Matsumoto"> <AREA SHAPE="rect" HREF="town.php?town=90" COORDS="386,1181,395,1190" ALT="Matsuyama" title="Matsuyama"> <AREA SHAPE="rect" HREF="town.php?town=91" COORDS="363,1112,372,1121" ALT="Mihara" title="Mihara"> <AREA SHAPE="rect" HREF="town.php?town=92" COORDS="691,975,700,985" ALT="Minakuchi" title="Minakuchi"> <AREA SHAPE="rect" HREF="town.php?town=93" COORDS="581,1076,590,1086" ALT="Minami" title="Minami"> <AREA SHAPE="rect" HREF="town.php?town=94" COORDS="933,701,943,710" ALT="Minowa" title="Minowa"> <AREA SHAPE="rect" HREF="town.php?town=95" COORDS="1130,711,1139,720" ALT="Mito" title="Mito"> <AREA SHAPE="rect" HREF="town.php?town=96" COORDS="1069,264,1077,273" ALT="Morioka" title="Morioka"> <AREA SHAPE="rect" HREF="town.php?town=97" COORDS="699,924,708,933" ALT="Nagahama" title="Nagahama"> <AREA SHAPE="rect" HREF="town.php?town=98" COORDS="906,603,915,612" ALT="Nagaoka" title="Nagaoka"> <AREA SHAPE="rect" HREF="town.php?town=99" COORDS="70,1379,79,1388" ALT="Nagasaki" title="Nagasaki"> <AREA SHAPE="rect" HREF="town.php?town=100" COORDS="752,946,761,955" ALT="Nagashima" title="Nagashima"> <AREA SHAPE="rect" HREF="town.php?town=101" COORDS="837,938,847,948" ALT="Nagashino" title="Nagashino"> <AREA SHAPE="rect" HREF="town.php?town=102" COORDS="778,937,787,946" ALT="Nagoya" title="Nagoya"> <AREA SHAPE="rect" HREF="town.php?town=103" COORDS="217,1255,226,1265" ALT="Nakatsu" title="Nakatsu"> <AREA SHAPE="rect" HREF="town.php?town=104" COORDS="733,679,742,688" ALT="Nanao" title="Nanao"> <AREA SHAPE="rect" HREF="town.php?town=105" COORDS="486,1203,495,1212" ALT="Nankoku" title="Nankoku"> <AREA SHAPE="rect" HREF="town.php?town=106" COORDS="689,1033,698,1043" ALT="Nara" title="Nara"> <AREA SHAPE="rect" HREF="town.php?town=107" COORDS="890,557,899,566" ALT="Niigata" title="Niigata"> <AREA SHAPE="rect" HREF="town.php?town=108" COORDS="995,642,1003,651" ALT="Nikko" title="Nikko"> <AREA SHAPE="rect" HREF="town.php?town=109" COORDS="1004,886,1012,895" ALT="Nirayama" title="Nirayama"> <AREA SHAPE="rect" HREF="town.php?town=110" COORDS="278,1397,287,1407" ALT="Nobeoka" title="Nobeoka"> <AREA SHAPE="rect" HREF="town.php?town=111" COORDS="643,904,652,914" ALT="Obama" title="Obama"> <AREA SHAPE="rect" HREF="town.php?town=112" COORDS="273,1499,282,1509" ALT="Obi" title="Obi"> <AREA SHAPE="rect" HREF="town.php?town=113" COORDS="698,893,707,902" ALT="Odani" title="Odani"> <AREA SHAPE="rect" HREF="town.php?town=114" COORDS="1014,846,1023,855" ALT="Odawara" title="Odawara"> <AREA SHAPE="rect" HREF="town.php?town=115" COORDS="735,906,744,916" ALT="Ogaki" title="Ogaki"> <AREA SHAPE="rect" HREF="town.php?town=116" COORDS="486,1063,495,1072" ALT="Okayama" title="Okayama"> <AREA SHAPE="rect" HREF="town.php?town=117" COORDS="803,934,812,943" ALT="Okazaki" title="Okazaki"> <AREA SHAPE="rect" HREF="town.php?town=118" COORDS="779,921,789,931" ALT="Okehazama" title="Okehazama"> <AREA SHAPE="rect" HREF="town.php?town=119" COORDS="713,843,723,853" ALT="Ono" title="Ono"> <AREA SHAPE="rect" HREF="town.php?town=120" COORDS="627,1010,636,1019" ALT="Osaka" title="Osaka"> <AREA SHAPE="rect" HREF="town.php?town=121" COORDS="1125,809,1134,818" ALT="Otaki" title="Otaki"> <AREA SHAPE="rect" HREF="town.php?town=122" COORDS="870,644,879,653" ALT="Otate" title="Otate"> <AREA SHAPE="rect" HREF="town.php?town=123" COORDS="678,971,687,981" ALT="Otsu" title="Otsu"> <AREA SHAPE="rect" HREF="town.php?town=124" COORDS="1024,778,1033,787" ALT="Ozawahara" title="Ozawahara"> <AREA SHAPE="rect" HREF="town.php?town=125" COORDS="366,1235,376,1245" ALT="Ozu" title="Ozu"> <AREA SHAPE="rect" HREF="town.php?town=126" COORDS="840,518,849,527" ALT="Sado" title="Sado"> <AREA SHAPE="rect" HREF="town.php?town=127" COORDS="111,1302,120,1311" ALT="Saga" title="Saga"> <AREA SHAPE="rect" HREF="town.php?town=128" COORDS="301,1312,310,1322" ALT="Saiki" title="Saiki"> <AREA SHAPE="rect" HREF="town.php?town=129" COORDS="251,1461,261,1471" ALT="Saito" title="Saito"> <AREA SHAPE="rect" HREF="town.php?town=130" COORDS="631,1033,640,1042" ALT="Sakai" title="Sakai"> <AREA SHAPE="rect" HREF="town.php?town=131" COORDS="1083,729,1092,739" ALT="Sakasai" title="Sakasai"> <AREA SHAPE="rect" HREF="town.php?town=132" COORDS="953,408,962,417" ALT="Sakata" title="Sakata"> <AREA SHAPE="rect" HREF="town.php?town=133" COORDS="1102,772,1111,782" ALT="Sakura" title="Sakura"> <AREA SHAPE="rect" HREF="town.php?town=134" COORDS="1014,697,1023,706" ALT="Sano" title="Sano"> <AREA SHAPE="rect" HREF="town.php?town=135" COORDS="1057,720,1066,729" ALT="Sekiyado" title="Sekiyado"> <AREA SHAPE="rect" HREF="town.php?town=136" COORDS="719,891,728,900" ALT="Sekigahara" title="Sekigahara"> <AREA SHAPE="rect" HREF="town.php?town=137" COORDS="1094,393,1103,402" ALT="Sendai" title="Sendai"> <AREA SHAPE="rect" HREF="town.php?town=138" COORDS="134,1372,142,1381" ALT="Shimabara" title="Shimabara"> <AREA SHAPE="rect" HREF="town.php?town=139" COORDS="1000,933,1009,942" ALT="Shimoda" title="Shimoda"> <AREA SHAPE="rect" HREF="town.php?town=140" COORDS="166,1191,175,1201" ALT="Shimonoseki" title="Shimonoseki"> <AREA SHAPE="rect" HREF="town.php?town=141" COORDS="914,807,923,816" ALT="Shinpu" title="Shinpu"> <AREA SHAPE="rect" HREF="town.php?town=142" COORDS="437,1064,446,1073" ALT="Soja" title="Soja"> <AREA SHAPE="rect" HREF="town.php?town=143" COORDS="706,674,715,683" ALT="Suemon" title="Suemon"> <AREA SHAPE="rect" HREF="town.php?town=144" COORDS="941,902,950,911" ALT="Sumpu" title="Sumpu"> <AREA SHAPE="rect" HREF="town.php?town=145" COORDS="750,973,759,983" ALT="Suzuka" title="Suzuka"> <AREA SHAPE="rect" HREF="town.php?town=146" COORDS="132,1232,142,1242" ALT="Tachibana" title="Tachibana"> <AREA SHAPE="rect" HREF="town.php?town=147" COORDS="836,657,845,666" ALT="Takada" title="Takada"> <AREA SHAPE="rect" HREF="town.php?town=148" COORDS="503,1091,513,1101" ALT="Takamatsu" title="Takamatsu"> <AREA SHAPE="rect" HREF="town.php?town=149" COORDS="737,709,746,718" ALT="Takaoka" title="Takaoka"> <AREA SHAPE="rect" HREF="town.php?town=150" COORDS="956,710,965,719" ALT="Takasaki" title="Takasaki"> <AREA SHAPE="rect" HREF="town.php?town=151" COORDS="77,1286,88,1296" ALT="Takashima" title="Takashima"> <AREA SHAPE="rect" HREF="town.php?town=152" COORDS="928,956,937,965" ALT="Takatenjin" title="Takatenjin"> <AREA SHAPE="rect" HREF="town.php?town=153" COORDS="857,816,866,825" ALT="Takato" title="Takato"> <AREA SHAPE="rect" HREF="town.php?town=154" COORDS="792,772,802,782" ALT="Takayama" title="Takayama"> <AREA SHAPE="rect" HREF="town.php?town=155" COORDS="820,972,829,981" ALT="Takenoya" title="Takenoya"> <AREA SHAPE="rect" HREF="town.php?town=156" COORDS="1013,788,1022,797" ALT="Takiyama" title="Takiyama"> <AREA SHAPE="rect" HREF="town.php?town=157" COORDS="409,1104,418,1113" ALT="Takiyama" title="Takiyama"> <AREA SHAPE="rect" HREF="town.php?town=158" COORDS="649,1140,658,1150" ALT="Tanabe" title="Tanabe"> <AREA SHAPE="rect" HREF="town.php?town=159" COORDS="933,919,942,928" ALT="Tanaka" title="Tanaka"> <AREA SHAPE="rect" HREF="town.php?town=160" COORDS="990,713,999,722" ALT="Tatebayashi" title="Tatebayashi"> <AREA SHAPE="rect" HREF="town.php?town=161" COORDS="1093,867,1102,876" ALT="Tateyama" title="Tateyama"> <AREA SHAPE="rect" HREF="town.php?town=162" COORDS="791,1015,800,1025" ALT="Toba" title="Toba"> <AREA SHAPE="rect" HREF="town.php?town=163" COORDS="340,994,349,1004" ALT="Toda" title="Toda"> <AREA SHAPE="rect" HREF="town.php?town=164" COORDS="562,1120,571,1130" ALT="Tokushima" title="Tokushima"> <AREA SHAPE="rect" HREF="town.php?town=165" COORDS="538,933,548,943" ALT="Tottori" title="Tottori"> <AREA SHAPE="rect" HREF="town.php?town=166" COORDS="760,728,769,737" ALT="Toyama" title="Toyama"> <AREA SHAPE="rect" HREF="town.php?town=167" COORDS="757,1003,766,1012" ALT="Tsu" title="Tsu"> <AREA SHAPE="rect" HREF="town.php?town=168" COORDS="1106,734,1115,743" ALT="Tsuchiura" title="Tsuchiura"> <AREA SHAPE="rect" HREF="town.php?town=169" COORDS="658,888,667,897" ALT="Tsuruga" title="Tsuruga"> <AREA SHAPE="rect" HREF="town.php?town=170" COORDS="451,996,460,1005" ALT="Tsuyama" title="Tsuyama"> <AREA SHAPE="rect" HREF="town.php?town=171" COORDS="908,760,916,769" ALT="Ueda" title="Ueda"> <AREA SHAPE="rect" HREF="town.php?town=172" COORDS="894,732,902,741" ALT="Uedahara" title="Uedahara"> <AREA SHAPE="rect" HREF="town.php?town=173" COORDS="887,792,897,802" ALT="Uehara" title="Uehara"> <AREA SHAPE="rect" HREF="town.php?town=174" COORDS="709,991,718,1001" ALT="Ueno" title="Ueno"> <AREA SHAPE="rect" HREF="town.php?town=175" COORDS="672,995,681,1005" ALT="Uji" title="Uji"> <AREA SHAPE="rect" HREF="town.php?town=176" COORDS="449,1214,458,1223" ALT="Urado" title="Urado"> <AREA SHAPE="rect" HREF="town.php?town=177" COORDS="284,1289,293,1297" ALT="Usuki" title="Usuki"> <AREA SHAPE="rect" HREF="town.php?town=178" COORDS="1048,670,1057,679" ALT="Utsunomiya" title="Utsunomiya"> <AREA SHAPE="rect" HREF="town.php?town=179" COORDS="359,1270,369,1279" ALT="Uwajima" title="Uwajima"> <AREA SHAPE="rect" HREF="town.php?town=180" COORDS="1029,549,1038,558" ALT="Wakamatsu" title="Wakamatsu"> <AREA SHAPE="rect" HREF="town.php?town=181" COORDS="625,1086,634,1095" ALT="Wakayama" title="Wakayama"> <AREA SHAPE="rect" HREF="town.php?town=182" COORDS="620,960,629,969" ALT="Yagami" title="Yagami"> <AREA SHAPE="rect" HREF="town.php?town=183" COORDS="1016,437,1026,446" ALT="Yamagata" title="Yamagata"> <AREA SHAPE="rect" HREF="town.php?town=184" COORDS="241,1156,250,1166" ALT="Yamaguchi" title="Yamaguchi"> <AREA SHAPE="rect" HREF="town.php?town=185" COORDS="131,1311,141,1321" ALT="Yanagawa" title="Yanagawa"> <AREA SHAPE="rect" HREF="town.php?town=186" COORDS="172,1391,182,1401" ALT="Yatsushiro" title="Yatsushiro"> <AREA SHAPE="rect" HREF="town.php?town=187" COORDS="1056,823,1064,832" ALT="Yokohama" title="Yokohama"> <AREA SHAPE="rect" HREF="town.php?town=188" COORDS="1023,496,1033,506" ALT="Yonezawa" title="Yonezawa"> <AREA SHAPE="rect" HREF="town.php?town=189" COORDS="807,960,816,969" ALT="Yoshida" title="Yoshida"> <AREA SHAPE="rect" HREF="town.php?town=190" COORDS="850,851,859,860" ALT="Yoshioka" title="Yoshioka"> <AREA SHAPE="circle" HREF="harbor.php?harbor=1" COORDS="187,1517,5" ALT="Kagoshima harbor" title="Kagoshima harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=2" COORDS="64,1379,5" ALT="Nagasaki harbor" title="Nagasaki harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=3" COORDS="37,1299,4" ALT="Hirado harbor" title="Hirado harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=4" COORDS="291,1404,4" ALT="Nobeoka harbor" title="Nobeoka harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=5" COORDS="147,1371,4" ALT="Shimabara harbor" title="Shimabara harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=6" COORDS="193,1214,4" ALT="Fukuoka harbor" title="Fukuoka harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=7" COORDS="159,1194,6" ALT="Shimonoseki harbor" title="Shimonoseki harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=8" COORDS="332,1130,4" ALT="Hiroshima harbor" title="Hiroshima harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=9" COORDS="499,1072,4" ALT="Okayama harbor" title="Okayama harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=10" COORDS="351,1272,4" ALT="Uwajima harbor" title="Uwajima harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=11" COORDS="492,1216,4" ALT="Nankoku harbor" title="Nankoku harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=12" COORDS="615,1093,4" ALT="Wakayama harbor" title="Wakayama harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=13" COORDS="627,1052,4" ALT="Sakai harbor" title="Sakai harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=14" COORDS="624,1025,5" ALT="Osaka harbor" title="Osaka harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=15" COORDS="770,998,4" ALT="Tsu harbor" title="Tsu harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=16" COORDS="772,949,5" ALT="Nagoya harbor" title="Nagoya harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=17" COORDS="868,971,5" ALT="Hamamatsu harbor" title="Hamamatsu harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=18" COORDS="1071,825,5" ALT="Yokohama harbor" title="Yokohama harbor"> <AREA SHAPE="circle" HREF="harbor.php?harbor=19" COORDS="1079,794,4" ALT="Edo harbor" title="Edo harbor"> </MAP> <!--copyright 2008 Wiebe de Boer--> </BODY> </HTML>
  6. i checked that. no luck. But after sometime when i checked my query in SQL again. it showing the changes. yes that is where i'd putting it. you were doing num row and the first row of an sql table is always numbered 0. its when you do auto-increment say for example ID's that the first row becomes 1 anyway good luck my friend. I never did a while loop before myself, I just knew the way things numbered
  7. the first row is 0, so the while should start at minus 1 if i'm not mistaken, since you're moving 1 row further with each loop. the while therefore is simply not fetching the first row and starts at the second row instead
  8. are the tables within the same database?
  9. Sue/'s or Sue\'s can't remember for sure if it was addslash or backslash
  10. are you sure you can do a function within a command? (sorry noob myself) also you failed to switch 20 with 30 in the last post and you are manipulating/calculating the same value/variable twice, in php at least that is not possible unless you make a reference, I don't know wether that is acceptable in sql (I'd also have to check the manual for that)
  11. it validates as html. I can get the page to work in Internet Explorer 6 and 7, but it does not work properly in Firefox 2 and 3. The layer with the towns simply will not display with firefox and the towns supposed to be blue or red, instead i get the black background to show in firefox. Obviously the z-index isn't supported in firefox (or in other words firefox is bugged), but does anyone know how to get around this firefox bug? I like to make the map work in both firefox and internet explorer. I have a user with a MacKintosh OS and hence he is stuck with using firefox as his browser. I'd like to make the map work for him too. The windows users can always switch back to IE, but for the Mac user that is not an option. Please any help would be very much obliged.
  12. tried it and no it doesn't work. Now it even fails to play in IE6.
  13. ok thanks i'll try OBJECT and ask him if it works for him
  14. Here is the code! the php file: $bluecapresult = mysql_query ("SELECT Yashiki FROM persons WHERE Clan ='$you'"); $bluecaprow = mysql_fetch_array($bluecapresult); $capitol = $bluecaprow['Yashiki']; echo "<IMG SRC='pictures/bluecap.gif' class='".$capitol."' BORDER='0' WIDTH='10' HEIGHT='10'>"; $blueresult = mysql_query ("SELECT * FROM Castles WHERE Castellan ='$you' AND Tenshu='0' AND CastleID <>'$capitol'"); while ($bluerow = mysql_fetch_array($blueresult)){ echo "<IMG SRC='pictures/blue.gif' class='".$bluerow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $bluecasresult = mysql_query ("SELECT * FROM Castles WHERE Castellan ='$you' AND Tenshu='1' AND CastleID <>'$capitol'"); while ($bluecasrow = mysql_fetch_array($bluecasresult)){ echo "<IMG SRC='pictures/bluecas.gif' class='".$bluecasrow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $redresult = mysql_query ("SELECT * FROM Castles WHERE Castellan <>'$you' AND Tenshu='0'"); while ($redrow = mysql_fetch_array($redresult)){ echo "<IMG SRC='pictures/red.gif' class='".$redrow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } $redcasresult = mysql_query ("SELECT * FROM Castles WHERE Castellan <>'$you' AND Tenshu='1'"); while ($redcasrow = mysql_fetch_array($redcasresult)){ echo "<IMG SRC='pictures/redcas.gif' class='".$redcasrow['CastleID']."' BORDER='0' WIDTH='10' HEIGHT='10'>"; } } ?> <IMG SRC="pictures/nihon.gif" BORDER=1 WIDTH=1200 HEIGHT=1600 USEMAP="#japan" class="pos_abs"> <MAP NAME="japan"> <AREA SHAPE="rect" HREF="town.php?town=1" COORDS="505,1196,514,1207" ALT="Aki"> <AREA SHAPE="rect" HREF="town.php?town=2" COORDS="960,258,968,266" ALT="Akita"> <AREA SHAPE="rect" HREF="town.php?town=3" COORDS="163,1272,174,1282" ALT="Akizuki"> <AREA SHAPE="rect" HREF="town.php?town=4" COORDS="518,1023,526,1032" ALT="Ako"> <AREA SHAPE="rect" HREF="town.php?town=5" COORDS="704,910,713,920" ALT="Anegawa"> </MAP> the css file: body {background-color: #000000;} IMG.pos_abs {position:absolute; left:0px; top:0px; z-index:2;} IMG.1 {position:absolute; left: 505px; top: 1196px; z-index:1;} IMG.2 {position:absolute; left: 960px; top: 258px; z-index:1;} IMG.3 {position:absolute; left: 163px; top: 1272px; z-index:1;} IMG.4 {position:absolute; left: 518px; top: 1023px; z-index:1;} IMG.5 {position:absolute; left: 704px; top: 910px; z-index:1;} Again this works fine in Internet Explorer, but layer 1 will not display in Firefox.
  15. he told me, that he recieved a message saying that he needs to install quicktime yes, but when he tries to install it, it says the plugin isn't there. And I also wonder why it tries to install quicktime. On my computer it works perfectly fine with windows media player. This puzzles me and I really want to fix this, so that every visitor is able to play the midi file.
  16. still haven't solved this problem.
  17. hello I use the following css file: body {background-color: #000000;} IMG.pos_abs {position:absolute; left:0px; top:0px; z-index:2;} IMG.1 {position:absolute; left: 505px; top: 1196px; z-index:1;} IMG.2 {position:absolute; left: 960px; top: 258px; z-index:1;} IMG.3 {position:absolute; left: 163px; top: 1272px; z-index:1;} IMG.4 {position:absolute; left: 518px; top: 1023px; z-index:1;} IMG.5 {position:absolute; left: 704px; top: 910px; z-index:1;} for displaying a dynamic map. A php script generates an amount of fetched numbers from an sql table and then displays small blue or red images on layer 1 according to wether the town is held by the user or not. The map is displayed on layer 2 and the areas that are the towns are transparent so that the lower layer can be seen. The background of the map page is set to black (as you can read from the css file). This code works fine in Internet Explorer. However layer 1 will not display in Firefox! This causes problems for firefox users, since the towns will apear all as black (the background color) and not red or blue (layer 1 colors). In short firefox will not display layer 1. I've changed position to relative or absolute and this does NOT fix the problem. I've swapped layer 1 for layer 2 and that makes the problem even worse, because now you can't click on the towns (layer 2 is an image map). I've swapped layer 1 for layer 2 and made image links out of layer the old layer and this does not work either. Please does anyone know how to solve this and want to tell me the solution to this firefox bug? thanks a lot
  18. the script: <script type="text/javascript"> function breakout() { if (window.top!=window.self) { window.top.location="logout.php"; } } function playSound(){ document.shugosound.play(); } function stopSound() { document.shugosound.stop(); } </script> the html: <form name=myform><input type=button value="Play Music" onClick="playSound()"> <input type=button value="Stop Music" onClick="stopSound()"></form> <EMBED src="dentou.mid" name="shugosound" id="shugosound" type="audio/midi" hidden="true" autostart="false" loop="23"> the problem: I've tested this in IE6 (yes yes i know don't laugh ok) and it works perfectly fine on 98SE using IE6. However I've got remarks from a visitor who used both IE7 and Firefox that the music doesn't work for him. I am puzzled as to why it doesn't work. Google is no help either as to what the problem is, so I'd try here instead.
  19. ahum I meant code tags and yes they don't work. maybe it is because i just came back from the dentist, or maybe it is because friday the 13th is getting close I dunno, but I'm telling you honest to god, no matter how many gazillions times i push on the code tags, they are not appearing in the text.
  20. the script: $genresult = mysql_query("SELECT * FROM Persons WHERE GeneralID='$pickedgeneral'"); $genrow = mysql_fetch_assoc($genresult); $capfirst = $genrow['ForeName']; $capsecond = $genrow['HindName']; $yearling = $genrow['Birth']; $captain = "$capfirst.$capsecond"; mysql_query("UPDATE Generals SET Titles ='taisho' WHERE GeneralID ='$pickedgeneral'"); mysql_query("UPDATE Armies SET Taisho ='$pickedgeneral', Generalname ='$captain', Generalbirth ='$yearling' WHERE ArmyID ='$pickedarmy'"); echo "<BR>The general was assigned to the army <BR>Please remember that the general remains fixed to the army and this may not be changed"; the tables: mysql_select_db("shugonl", $con); $sqlgen = "CREATE TABLE Generals ( GeneralID int(7) NOT NULL AUTO_INCREMENT, PRIMARY KEY(GeneralID), Clan varchar(20) NOT NULL, ForeName varchar(6) NOT NULL, HindName varchar(6) NOT NULL, Birth int(4) DEFAULT '1999', Honor int(3) DEFAULT '1', Titles varchar(7) DEFAULT 'samurai' )"; mysql_query($sqlgen,$con); mysql_select_db("shugonl", $con); $sqlarme = "CREATE TABLE Armies ( ArmyID int(4) NOT NULL AUTO_INCREMENT, PRIMARY KEY(ArmyID), Armyclan varchar(20) NOT NULL, Armyname varchar(20) NOT NULL, Armyduty varchar(9) NOT NULL, Armylocation int(3) NOT NULL, Taisho int(7) DEFAULT '0', Generalname varchar(12) DEFAULT 'noname', Generalbirth int(4) DEFAULT '1999', Yarigumi int(6) DEFAULT '0', Nagayarigumi int(6) DEFAULT '0', Naginatagumi int(6) DEFAULT '0', Yumigumi int(6) DEFAULT '0', Teppogumi int(6) DEFAULT '0', Kengumi int(6) DEFAULT '0', Mushagumi int(6) DEFAULT '0', Kagemusha int(6) DEFAULT '0', Sohei int(6) DEFAULT '0', Yamabushi int(6) DEFAULT '0', Shugenja int(6) DEFAULT '0', Kenzei int(6) DEFAULT '0', Attackpoint int(1) DEFAULT '1' )"; mysql_query($sqlarme,$con); the problem: Obviously the script is faulty, because it is not updating the Armies table properly. I'm not entirely sure it is the concatenation that is wrong. Its probably something really stupid that i glanced through, but again it boggles me for hours now. example: if ForeName is Yoshi and HindName is sue then the captain variable should be Yoshisue
  21. i was referring to the link with the forum rules quote tags isn't working here for some reason, so please don't mention it thank. I cannot help it, that it does not work.
  22. yeah tried that and it isn't working for me. I want to go by the rules, but it just isn't working, no matter how many times i push on the icon.
  23. the script: <?php //CHECKING COOKIE if (isset($_COOKIE["person"])) { $you = $_COOKIE['person']; if (isset($_GET["army"])) { filter_var($_GET["army"], FILTER_SANITIZE_STRING); $thisarmy = $_GET["army"]; //CONNECTOR $con = mysql_connect("localhost", "username", "password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shugonl", $con); $resultarm = mysql_query ("SELECT * FROM Armies WHERE ArmyID ='$thisarmy'"); $rowarm = mysql_fetch_array($resultarm); $whatarmy = $rowarm['Armyname']; $duty = $rowarm['Armyduty']; $location = $rowarm['Armylocation']; $generalnumber = $rowarm['Taisho']; $general = $rowarm['Generalname']; $generalyear = $rowarm['Generalbirth']; $spearmen = $rowarm['Yarigumi']; $lancers = $rowarm['Nagayarigumi']; $halberdeers = $rowarm['Naginatagumi']; $archers = $rowarm['Yumigumi']; $gunners = $rowarm['Teppogumi']; $swordsmen = $rowarm['Kengumi']; $cavalry = $rowarm['Mushagumi']; $shadowwarrior = $rowarm['Kagemusha']; $warriormonk = $rowarm['Sohei']; $mountainwarrior = $rowarm['Yamabushi']; $mountainascetic = $rowarm['Shugenja']; $swordsaint = $rowarm['Kenzei']; $turns = $rowarm['Attackpoint']; //IF GENERAL if ($generalnumber !=0){ $resgen = mysql_query ("SELECT * FROM Generals WHERE AND GeneralID ='$generalnumber'"); $rowgen = mysql_fetch_array($resgen); $generalclan = $rowgen['Clan']; $generalhonor = $rowgen['Honor']; echo "<P class='left'>The ".$whatarmy." army has <BR>".$spearmen." Yarigumi <BR>".$lancers." Nagayarigumi <BR>".$halberdeers." Naginatagumi <BR>".$archers." Yumigumi <BR>".$gunners." Teppogumi <BR>".$swordsmen." Kengumi <BR>".$cavalry." Mushagumi <BR>".$shadowwarrior." Kagemusha <BR>".$warriormonk." Sohei <BR>".$mountainwarrior." Yamabushi <BR>".$mountainascetic." Shugenja <BR>".$swordsaint." Kenzei</P>"; if ($turns ==1){ "<BR>one turn";} else { "<BR>no turns";} echo "<P>The army is being led by ".$general." of the ".$generalclan." clan who was born in ".$generalyear." and has ".$generalhonor." honorpoints"; $resulttown = mysql_query ("SELECT * FROM Castles WHERE CastleID ='$location'"); $rowtown = mysql_fetch_array($resulttown); $townowner = $rowtown['Castellan']; if ($townowner ==$you){ echo "<FORM method='Post' action='assigned.php'><INPUT type='hidden' name='assignduty' value='defenders'><INPUT type='Submit' value='garrison' name='submit'></FORM>"; } else { echo "<FORM method='Post' action='assigned.php'><INPUT type='hidden' name='assignduty' value='attackers'><INPUT type='Submit' value='attackforce' name='submit'></FORM>"; } //ELSE NO GENERAL } else { echo "<P class='left'>The ".$whatarmy." army has <BR>".$spearmen." Yarigumi <BR>".$lancers." Nagayarigumi <BR>".$halberdeers." Naginatagumi <BR>".$archers." Yumigumi <BR>".$gunners." Teppogumi <BR>".$swordsmen." Kengumi <BR>".$cavalry." Mushagumi <BR>".$shadowwarrior." Kagemusha <BR>".$warriormonk." Sohei <BR>".$mountainwarrior." Yamabushi <BR>".$mountainascetic." Shugenja <BR>".$swordsaint." Kenzei</P>"; if ($turns ==1){ "<BR>one turn";} else { "<BR>no turns";} echo "<P>The army is not being led by a general <BR>Please select a clan from which to assign a general to the army <BR><FORM method='Post' action='aide.php'><SELECT name='generalclan'>"; echo "<option value='" .$you. "'>" .$you. "</option>"; $vassalresult = mysql_query ("SELECT Clan FROM persons WHERE Liege ='$you'"); while($vassalrow = mysql_fetch_array($vassalresult)) { echo "<option value='" .$vassalrow['Clan']. "'>" .$vassalrow['Clan']. "</option>"; } echo "</SELECT><input type='hidden' name='armynum' value='".$thisarmy."'><INPUT type='Submit' value='Pick Clan'></FORM>"; } } } else { echo "<BR>No cookie was found";} ?> the table: mysql_select_db("shugonl", $con); $sqlgen = "CREATE TABLE Generals ( GeneralID int(7) NOT NULL AUTO_INCREMENT, PRIMARY KEY(GeneralID), Clan varchar(20) NOT NULL, ForeName varchar(6) NOT NULL, HindName varchar(6) NOT NULL, Birth int(4) DEFAULT '1999', Honor int(3) DEFAULT '1', Titles varchar(7) DEFAULT 'samurai' )"; mysql_query($sqlgen,$con); the problem: Somehow the script is not fetching the data from the Generals table. I know the connector is ok, because it does fetch something from the other tables. I'm staring myself blind as to what I did wrong, from the looks of it it is not a syntax error, because i don't get a white page. Does anyone see the error?
  24. I know you can do a remote adress, but is there also a way to check on the country (GeoIP), browser and operating system? I need it to weed out multiple accounts in a quick and easy manner. Thanks for the help.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.