MySQL Forums
Forum List  »  Partitioning

Re: Do I have to re write querries when Partitioning?
Posted by: john hango
Date: September 05, 2010 07:52PM

return $result;
}
function array_to_string($arrayInHere) {
foreach ($arrayInHere as $index=>$val) $result.=$val.",";
$result = substr($result, 6, -1);
return $result;
}
function newNameForFile($in) {
$out = trim($in);
$out = str_replace(' ','_',$out);
$out = str_replace('.','',$out);
$out = str_replace('\"','',$out);
$out = str_replace('/','',$out);
$out = str_replace('*','',$out);
$out = str_replace('?','',$out);
$out = str_replace('"','',$out);
$out = str_replace('<','',$out);
$out = str_replace('>','',$out);
$out = str_replace('|','',$out);
return $out;
}
function removeDupesFromString($in,$separator) {
$out = trim($in);
$out = explode($separator,$out);
$out = array_unique($out);
$out = implode($separator,$out);
return $out;
}
function colorList($name,$id,$onchange,$reguestedValue) {
global $lang, $setts;
$htmlOutput = "";
$htmlOutput = "
<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"\"".((!$reguestedValue||$reguestedValue=="")?" selected":"").">None</option>
<option value=\"#F0F8FF\" style=\"background-color: #F0F8FF; color: black;\"".(($reguestedValue=="#F0F8FF")?" selected":"").">AliceBlue</option>
<option value=\"#FAEBD7\" style=\"background-color: #FAEBD7; color: black;\"".(($reguestedValue=="#FAEBD7")?" selected":"").">AntiqueWhite</option>
<option value=\"#00FFFF\" style=\"background-color: #00FFFF; color: black;\"".(($reguestedValue=="#00FFFF")?" selected":"").">Aqua</option>
<option value=\"#7FFFD4\" style=\"background-color: #7FFFD4; color: black;\"".(($reguestedValue=="#7FFFD4")?" selected":"").">Aquamarine</option>
<option value=\"#F0FFFF\" style=\"background-color: #F0FFFF; color: black;\"".(($reguestedValue=="#FAEBD7")?" selected":"").">Azure</option>
<option value=\"#F5F5DC\" style=\"background-color: #F5F5DC; color: black;\"".(($reguestedValue=="#F5F5DC")?" selected":"").">Beige</option>
<option value=\"#FFE4C4\" style=\"background-color: #FFE4C4; color: black;\"".(($reguestedValue=="#FFE4C4")?" selected":"").">Bisque</option>
<option value=\"#000000\" style=\"background-color: #000000; color: white;\"".(($reguestedValue=="#000000")?" selected":"").">Black</option>
<option value=\"#FFEBCD\" style=\"background-color: #FFEBCD; color: black;\"".(($reguestedValue=="#FFEBCD")?" selected":"").">BlanchedAlmond</option>
<option value=\"#0000FF\" style=\"background-color: #0000FF; color: white;\"".(($reguestedValue=="#0000FF")?" selected":"").">Blue</option>
<option value=\"#8A2BE2\" style=\"background-color: #8A2BE2; color: white;\"".(($reguestedValue=="#8A2BE2")?" selected":"").">BlueViolet</option>
<option value=\"#A52A2A\" style=\"background-color: #A52A2A; color: white;\"".(($reguestedValue=="#A52A2A")?" selected":"").">Brown</option>
<option value=\"#DEB887\" style=\"background-color: #DEB887; color: black;\"".(($reguestedValue=="#DEB887")?" selected":"").">BurlyWood</option>
<option value=\"#5F9EA0\" style=\"background-color: #5F9EA0; color: white;\"".(($reguestedValue=="#5F9EA0")?" selected":"").">CadetBlue</option>
<option value=\"#7FFF00\" style=\"background-color: #7FFF00; color: black;\"".(($reguestedValue=="#7FFF00")?" selected":"").">Chartreuse</option>
<option value=\"#D2691E\" style=\"background-color: #D2691E; color: white;\"".(($reguestedValue=="#D2691E")?" selected":"").">Chocolate</option>
<option value=\"#FF7F50\" style=\"background-color: #FF7F50; color: white;\"".(($reguestedValue=="#FF7F50")?" selected":"").">Coral</option>
<option value=\"#6495ED\" style=\"background-color: #6495ED; color: white;\"".(($reguestedValue=="#6495ED")?" selected":"").">CornflowerBlue</option>
<option value=\"#FFF8DC\" style=\"background-color: #FFF8DC; color: black;\"".(($reguestedValue=="#FFF8DC")?" selected":"").">Cornsilk</option>
<option value=\"#DC143C\" style=\"background-color: #DC143C; color: white;\"".(($reguestedValue=="#FAEBD7")?" selected":"").">Crimson</option>
<option value=\"#00FFFF\" style=\"background-color: #00FFFF; color: black;\"".(($reguestedValue=="#00FFFF")?" selected":"").">Cyan</option>
<option value=\"#00008B\" style=\"background-color: #00008B; color: white;\"".(($reguestedValue=="#00008B")?" selected":"").">DarkBlue</option>
<option value=\"#008B8B\" style=\"background-color: #008B8B; color: white;\"".(($reguestedValue=="#008B8B")?" selected":"").">DarkCyan</option>
<option value=\"#B8860B\" style=\"background-color: #B8860B; color: white;\"".(($reguestedValue=="#B8860B")?" selected":"").">DarkGoldenRod</option>
<option value=\"#A9A9A9\" style=\"background-color: #A9A9A9; color: white;\"".(($reguestedValue=="#A9A9A9")?" selected":"").">DarkGray</option>
<option value=\"#006400\" style=\"background-color: #006400; color: white;\"".(($reguestedValue=="#006400")?" selected":"").">DarkGreen</option>
<option value=\"#BDB76B\" style=\"background-color: #BDB76B; color: black;\"".(($reguestedValue=="#BDB76B")?" selected":"").">DarkKhaki</option>
<option value=\"#8B008B\" style=\"background-color: #8B008B; color: white;\"".(($reguestedValue=="#8B008B")?" selected":"").">DarkMagenta</option>
<option value=\"#556B2F\" style=\"background-color: #556B2F; color: white;\"".(($reguestedValue=="#556B2F")?" selected":"").">DarkOliveGreen</option>
<option value=\"#FF8C00\" style=\"background-color: #FF8C00; color: white;\"".(($reguestedValue=="#FF8C00")?" selected":"").">Darkorange</option>
<option value=\"#9932CC\" style=\"background-color: #9932CC; color: white;\"".(($reguestedValue=="#9932CC")?" selected":"").">DarkOrchid</option>
<option value=\"#8B0000\" style=\"background-color: #8B0000; color: white;\"".(($reguestedValue=="#8B0000")?" selected":"").">DarkRed</option>
<option value=\"#E9967A\" style=\"background-color: #E9967A; color: white;\"".(($reguestedValue=="#E9967A")?" selected":"").">DarkSalmon</option>
<option value=\"#8FBC8F\" style=\"background-color: #8FBC8F; color: black;\"".(($reguestedValue=="#8FBC8F")?" selected":"").">DarkSeaGreen</option>
<option value=\"#483D8B\" style=\"background-color: #483D8B; color: white;\"".(($reguestedValue=="#483D8B")?" selected":"").">DarkSlateBlue</option>
<option value=\"#2F4F4F\" style=\"background-color: #2F4F4F; color: white;\"".(($reguestedValue=="#2F4F4F")?" selected":"").">DarkSlateGray</option>
<option value=\"#00CED1\" style=\"background-color: #00CED1; color: black;\"".(($reguestedValue=="#00CED1")?" selected":"").">DarkTurquoise</option>
<option value=\"#9400D3\" style=\"background-color: #9400D3; color: white;\"".(($reguestedValue=="#9400D3")?" selected":"").">DarkViolet</option>
<option value=\"#FF1493\" style=\"background-color: #FF1493; color: white;\"".(($reguestedValue=="#FF1493")?" selected":"").">DeepPink</option>
<option value=\"#00BFFF\" style=\"background-color: #00BFFF; color: black;\"".(($reguestedValue=="#00BFFF")?" selected":"").">DeepSkyBlue</option>
<option value=\"#696969\" style=\"background-color: #696969; color: white;\"".(($reguestedValue=="#696969")?" selected":"").">DimGray</option>
<option value=\"#1E90FF\" style=\"background-color: #1E90FF; color: white;\"".(($reguestedValue=="#1E90FF")?" selected":"").">DodgerBlue</option>
<option value=\"#D19275\" style=\"background-color: #D19275; color: white;\"".(($reguestedValue=="#D19275")?" selected":"").">Feldspar</option>
<option value=\"#B22222\" style=\"background-color: #B22222; color: white;\"".(($reguestedValue=="#B22222")?" selected":"").">FireBrick</option>
<option value=\"#FFFAF0\" style=\"background-color: #FFFAF0; color: black;\"".(($reguestedValue=="#FFFAF0")?" selected":"").">FloralWhite</option>
<option value=\"#228B22\" style=\"background-color: #228B22; color: white;\"".(($reguestedValue=="#228B22")?" selected":"").">ForestGreen</option>
<option value=\"#FF00FF\" style=\"background-color: #FF00FF; color: white;\"".(($reguestedValue=="#FF00FF")?" selected":"").">Fuchsia</option>
<option value=\"#DCDCDC\" style=\"background-color: #DCDCDC; color: black;\"".(($reguestedValue=="#DCDCDC")?" selected":"").">Gainsboro</option>
<option value=\"#F8F8FF\" style=\"background-color: #F8F8FF; color: black;\"".(($reguestedValue=="#F8F8FF")?" selected":"").">GhostWhite</option>
<option value=\"#FFD700\" style=\"background-color: #FFD700; color: black;\"".(($reguestedValue=="#FFD700")?" selected":"").">Gold</option>
<option value=\"#DAA520\" style=\"background-color: #DAA520; color: white;\"".(($reguestedValue=="#DAA520")?" selected":"").">GoldenRod</option>
<option value=\"#808080\" style=\"background-color: #808080; color: white;\"".(($reguestedValue=="#808080")?" selected":"").">Gray</option>
<option value=\"#008000\" style=\"background-color: #008000; color: white;\"".(($reguestedValue=="#008000")?" selected":"").">Green</option>
<option value=\"#ADFF2F\" style=\"background-color: #ADFF2F; color: black;\"".(($reguestedValue=="#ADFF2F")?" selected":"").">GreenYellow</option>
<option value=\"#F0FFF0\" style=\"background-color: #F0FFF0; color: black;\"".(($reguestedValue=="#F0FFF0")?" selected":"").">HoneyDew</option>
<option value=\"#FF69B4\" style=\"background-color: #FF69B4; color: white;\"".(($reguestedValue=="#FF69B4")?" selected":"").">HotPink</option>
<option value=\"#CD5C5C\" style=\"background-color: #CD5C5C; color: white;\"".(($reguestedValue=="#CD5C5C")?" selected":"").">IndianRed</option>
<option value=\"#4B0082\" style=\"background-color: #4B0082; color: white;\"".(($reguestedValue=="#4B0082")?" selected":"").">Indigo</option>
<option value=\"#FFFFF0\" style=\"background-color: #FFFFF0; color: black;\"".(($reguestedValue=="#FFFFF0")?" selected":"").">Ivory</option>
<option value=\"#F0E68C\" style=\"background-color: #F0E68C; color: black;\"".(($reguestedValue=="#F0E68C")?" selected":"").">Khaki</option>
<option value=\"#E6E6FA\" style=\"background-color: #E6E6FA; color: black;\"".(($reguestedValue=="#E6E6FA")?" selected":"").">Lavender</option>
<option value=\"#FFF0F5\" style=\"background-color: #FFF0F5; color: black;\"".(($reguestedValue=="#FFF0F5")?" selected":"").">LavenderBlush</option>
<option value=\"#7CFC00\" style=\"background-color: #7CFC00; color: black;\"".(($reguestedValue=="#7CFC00")?" selected":"").">LawnGreen</option>
<option value=\"#FFFACD\" style=\"background-color: #FFFACD; color: black;\"".(($reguestedValue=="#FFFACD")?" selected":"").">LemonChiffon</option>
<option value=\"#ADD8E6\" style=\"background-color: #ADD8E6; color: black;\"".(($reguestedValue=="#ADD8E6")?" selected":"").">LightBlue</option>
<option value=\"#F08080\" style=\"background-color: #F08080; color: white;\"".(($reguestedValue=="#F08080")?" selected":"").">LightCoral</option>
<option value=\"#E0FFFF\" style=\"background-color: #E0FFFF; color: black;\"".(($reguestedValue=="#E0FFFF")?" selected":"").">LightCyan</option>
<option value=\"#FAFAD2\" style=\"background-color: #FAFAD2; color: black;\"".(($reguestedValue=="#FAFAD2")?" selected":"").">LightGoldenRodYellow</option>
<option value=\"#D3D3D3\" style=\"background-color: #D3D3D3; color: black;\"".(($reguestedValue=="#D3D3D3")?" selected":"").">LightGrey</option>
<option value=\"#90EE90\" style=\"background-color: #90EE90; color: black;\"".(($reguestedValue=="#90EE90")?" selected":"").">LightGreen</option>
<option value=\"#FFB6C1\" style=\"background-color: #FFB6C1; color: black;\"".(($reguestedValue=="#FFB6C1")?" selected":"").">LightPink</option>
<option value=\"#FFA07A\" style=\"background-color: #FFA07A; color: black;\"".(($reguestedValue=="#FFA07A")?" selected":"").">LightSalmon</option>
<option value=\"#20B2AA\" style=\"background-color: #20B2AA; color: white;\"".(($reguestedValue=="#20B2AA")?" selected":"").">LightSeaGreen</option>
<option value=\"#87CEFA\" style=\"background-color: #87CEFA; color: black;\"".(($reguestedValue=="#87CEFA")?" selected":"").">LightSkyBlue</option>
<option value=\"#8470FF\" style=\"background-color: #8470FF; color: white;\"".(($reguestedValue=="#8470FF")?" selected":"").">LightSlateBlue</option>
<option value=\"#778899\" style=\"background-color: #778899; color: white;\"".(($reguestedValue=="#778899")?" selected":"").">LightSlateGray</option>
<option value=\"#B0C4DE\" style=\"background-color: #B0C4DE; color: black;\"".(($reguestedValue=="#B0C4DE")?" selected":"").">LightSteelBlue</option>
<option value=\"#FFFFE0\" style=\"background-color: #FFFFE0; color: black;\"".(($reguestedValue=="#FFFFE0")?" selected":"").">LightYellow</option>
<option value=\"#00FF00\" style=\"background-color: #00FF00; color: black;\"".(($reguestedValue=="#00FF00")?" selected":"").">Lime</option>
<option value=\"#32CD32\" style=\"background-color: #32CD32; color: white;\"".(($reguestedValue=="#32CD32")?" selected":"").">LimeGreen</option>
<option value=\"#FAF0E6\" style=\"background-color: #FAF0E6; color: black;\"".(($reguestedValue=="#FAF0E6")?" selected":"").">Linen</option>
<option value=\"#FF00FF\" style=\"background-color: #FF00FF; color: white;\"".(($reguestedValue=="#FF00FF")?" selected":"").">Magenta</option>
<option value=\"#800000\" style=\"background-color: #800000; color: white;\"".(($reguestedValue=="#800000")?" selected":"").">Maroon</option>
<option value=\"#66CDAA\" style=\"background-color: #66CDAA; color: black;\"".(($reguestedValue=="#66CDAA")?" selected":"").">MediumAquaMarine</option>
<option value=\"#0000CD\" style=\"background-color: #0000CD; color: white;\"".(($reguestedValue=="#0000CD")?" selected":"").">MediumBlue</option>
<option value=\"#BA55D3\" style=\"background-color: #BA55D3; color: white;\"".(($reguestedValue=="#BA55D3")?" selected":"").">MediumOrchid</option>
<option value=\"#9370D8\" style=\"background-color: #9370D8; color: white;\"".(($reguestedValue=="#9370D8")?" selected":"").">MediumPurple</option>
<option value=\"#3CB371\" style=\"background-color: #3CB371; color: white;\"".(($reguestedValue=="#3CB371")?" selected":"").">MediumSeaGreen</option>
<option value=\"#7B68EE\" style=\"background-color: #7B68EE; color: white;\"".(($reguestedValue=="#7B68EE")?" selected":"").">MediumSlateBlue</option>
<option value=\"#00FA9A\" style=\"background-color: #00FA9A; color: black;\"".(($reguestedValue=="#00FA9A")?" selected":"").">MediumSpringGreen</option>
<option value=\"#48D1CC\" style=\"background-color: #48D1CC; color: black;\"".(($reguestedValue=="#48D1CC")?" selected":"").">MediumTurquoise</option>
<option value=\"#C71585\" style=\"background-color: #C71585; color: white;\"".(($reguestedValue=="#C71585")?" selected":"").">MediumVioletRed</option>
<option value=\"#191970\" style=\"background-color: #191970; color: white;\"".(($reguestedValue=="#191970")?" selected":"").">MidnightBlue</option>
<option value=\"#F5FFFA\" style=\"background-color: #F5FFFA; color: black;\"".(($reguestedValue=="#F5FFFA")?" selected":"").">MintCream</option>
<option value=\"#FFE4E1\" style=\"background-color: #FFE4E1; color: black;\"".(($reguestedValue=="#FFE4E1")?" selected":"").">MistyRose</option>
<option value=\"#FFE4B5\" style=\"background-color: #FFE4B5; color: black;\"".(($reguestedValue=="#FFE4B5")?" selected":"").">Moccasin</option>
<option value=\"#FFDEAD\" style=\"background-color: #FFDEAD; color: black;\"".(($reguestedValue=="#FFDEAD")?" selected":"").">NavajoWhite</option>
<option value=\"#000080\" style=\"background-color: #000080; color: white;\"".(($reguestedValue=="#000080")?" selected":"").">Navy</option>
<option value=\"#FDF5E6\" style=\"background-color: #FDF5E6; color: black;\"".(($reguestedValue=="#FDF5E6")?" selected":"").">OldLace</option>
<option value=\"#808000\" style=\"background-color: #808000; color: white;\"".(($reguestedValue=="#808000")?" selected":"").">Olive</option>
<option value=\"#6B8E23\" style=\"background-color: #6B8E23; color: white;\"".(($reguestedValue=="#6B8E23")?" selected":"").">OliveDrab</option>
<option value=\"#FFA500\" style=\"background-color: #FFA500; color: black;\"".(($reguestedValue=="#FFA500")?" selected":"").">Orange</option>
<option value=\"#FF4500\" style=\"background-color: #FF4500; color: white;\"".(($reguestedValue=="#FF4500")?" selected":"").">OrangeRed</option>
<option value=\"#DA70D6\" style=\"background-color: #DA70D6; color: white;\"".(($reguestedValue=="#DA70D6")?" selected":"").">Orchid</option>
<option value=\"#EEE8AA\" style=\"background-color: #EEE8AA; color: black;\"".(($reguestedValue=="#EEE8AA")?" selected":"").">PaleGoldenRod</option>
<option value=\"#98FB98\" style=\"background-color: #98FB98; color: black;\"".(($reguestedValue=="#98FB98")?" selected":"").">PaleGreen</option>
<option value=\"#AFEEEE\" style=\"background-color: #AFEEEE; color: black;\"".(($reguestedValue=="#AFEEEE")?" selected":"").">PaleTurquoise</option>
<option value=\"#D87093\" style=\"background-color: #D87093; color: white;\"".(($reguestedValue=="#D87093")?" selected":"").">PaleVioletRed</option>
<option value=\"#FFEFD5\" style=\"background-color: #FFEFD5; color: black;\"".(($reguestedValue=="#FFEFD5")?" selected":"").">PapayaWhip</option>
<option value=\"#FFDAB9\" style=\"background-color: #FFDAB9; color: black;\"".(($reguestedValue=="#FFDAB9")?" selected":"").">PeachPuff</option>
<option value=\"#CD853F\" style=\"background-color: #CD853F; color: white;\"".(($reguestedValue=="#CD853F")?" selected":"").">Peru</option>
<option value=\"#FFC0CB\" style=\"background-color: #FFC0CB; color: black;\"".(($reguestedValue=="#FFC0CB")?" selected":"").">Pink</option>
<option value=\"#DDA0DD\" style=\"background-color: #DDA0DD; color: black;\"".(($reguestedValue=="#DDA0DD")?" selected":"").">Plum</option>
<option value=\"#B0E0E6\" style=\"background-color: #B0E0E6; color: black;\"".(($reguestedValue=="#B0E0E6")?" selected":"").">PowderBlue</option>
<option value=\"#800080\" style=\"background-color: #800080; color: white;\"".(($reguestedValue=="#800080")?" selected":"").">Purple</option>
<option value=\"#FF0000\" style=\"background-color: #FF0000; color: white;\"".(($reguestedValue=="#FF0000")?" selected":"").">Red</option>
<option value=\"#BC8F8F\" style=\"background-color: #BC8F8F; color: white;\"".(($reguestedValue=="#BC8F8F")?" selected":"").">RosyBrown</option>
<option value=\"#4169E1\" style=\"background-color: #4169E1; color: white;\"".(($reguestedValue=="#4169E1")?" selected":"").">RoyalBlue</option>
<option value=\"#8B4513\" style=\"background-color: #8B4513; color: white;\"".(($reguestedValue=="#8B4513")?" selected":"").">SaddleBrown</option>
<option value=\"#FA8072\" style=\"background-color: #FA8072; color: white;\"".(($reguestedValue=="#FA8072")?" selected":"").">Salmon</option>
<option value=\"#F4A460\" style=\"background-color: #F4A460; color: white;\"".(($reguestedValue=="#F4A460")?" selected":"").">SandyBrown</option>
<option value=\"#2E8B57\" style=\"background-color: #2E8B57; color: white;\"".(($reguestedValue=="#2E8B57")?" selected":"").">SeaGreen</option>
<option value=\"#FFF5EE\" style=\"background-color: #FFF5EE; color: black;\"".(($reguestedValue=="#FFF5EE")?" selected":"").">SeaShell</option>
<option value=\"#A0522D\" style=\"background-color: #A0522D; color: white;\"".(($reguestedValue=="#A0522D")?" selected":"").">Sienna</option>
<option value=\"#C0C0C0\" style=\"background-color: #C0C0C0; color: black;\"".(($reguestedValue=="#C0C0C0")?" selected":"").">Silver</option>
<option value=\"#87CEEB\" style=\"background-color: #87CEEB; color: black;\"".(($reguestedValue=="#87CEEB")?" selected":"").">SkyBlue</option>
<option value=\"#6A5ACD\" style=\"background-color: #6A5ACD; color: white;\"".(($reguestedValue=="#6A5ACD")?" selected":"").">SlateBlue</option>
<option value=\"#708090\" style=\"background-color: #708090; color: white;\"".(($reguestedValue=="#708090")?" selected":"").">SlateGray</option>
<option value=\"#FFFAFA\" style=\"background-color: #FFFAFA; color: black;\"".(($reguestedValue=="#FFFAFA")?" selected":"").">Snow</option>
<option value=\"#00FF7F\" style=\"background-color: #00FF7F; color: black;\"".(($reguestedValue=="#00FF7F")?" selected":"").">SpringGreen</option>
<option value=\"#4682B4\" style=\"background-color: #4682B4; color: white;\"".(($reguestedValue=="#4682B4")?" selected":"").">SteelBlue</option>
<option value=\"#D2B48C\" style=\"background-color: #D2B48C; color: white;\"".(($reguestedValue=="#D2B48C")?" selected":"").">Tan</option>
<option value=\"#008080\" style=\"background-color: #008080; color: white;\"".(($reguestedValue=="#008080")?" selected":"").">Teal</option>
<option value=\"#D8BFD8\" style=\"background-color: #D8BFD8; color: black;\"".(($reguestedValue=="#D8BFD8")?" selected":"").">Thistle</option>
<option value=\"#FF6347\" style=\"background-color: #FF6347; color: white;\"".(($reguestedValue=="#FF6347")?" selected":"").">Tomato</option>
<option value=\"#40E0D0\" style=\"background-color: #40E0D0; color: black;\"".(($reguestedValue=="#40E0D0")?" selected":"").">Turquoise</option>
<option value=\"#EE82EE\" style=\"background-color: #EE82EE; color: white;\"".(($reguestedValue=="#EE82EE")?" selected":"").">Violet</option>
<option value=\"#D02090\" style=\"background-color: #D02090; color: white;\"".(($reguestedValue=="#D02090")?" selected":"").">VioletRed</option>
<option value=\"#F5DEB3\" style=\"background-color: #F5DEB3; color: black;\"".(($reguestedValue=="#F5DEB3")?" selected":"").">Wheat</option>
<option value=\"#FFFFFF\" style=\"background-color: #FFFFFF; color: black;\"".(($reguestedValue=="#FFFFFF")?" selected":"").">White</option>
<option value=\"#F5F5F5\" style=\"background-color: #F5F5F5; color: black;\"".(($reguestedValue=="#F5F5F5")?" selected":"").">WhiteSmoke</option>
<option value=\"#FFFF00\" style=\"background-color: #FFFF00; color: black;\"".(($reguestedValue=="#FFFF00")?" selected":"").">Yellow</option>
<option value=\"#9ACD32\" style=\"background-color: #9ACD32; color: black;\"".(($reguestedValue=="#9ACD32")?" selected":"").">YellowGreen</option>
</select>";
return $htmlOutput;
}
function sizeList($name,$id,$onchange,$reguestedValue) {
$htmlOutput = "";
$htmlOutput = "<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"9\"".(($reguestedValue=="9")?" selected":"").">9</option>
<option value=\"10\"".(($reguestedValue=="10")?" selected":"").">10</option>
<option value=\"12\"".(($reguestedValue=="12")?" selected":"").">12</option>
<option value=\"14\"".((!$reguestedValue||$reguestedValue=="14")?" selected":"").">14</option>
<option value=\"16\"".(($reguestedValue=="16")?" selected":"").">16</option>
<option value=\"18\"".(($reguestedValue=="18")?" selected":"").">18</option>
<option value=\"24\"".(($reguestedValue=="24")?" selected":"").">24</option>
<option value=\"36\"".(($reguestedValue=="36")?" selected":"").">36</option>
<option value=\"xx-small\"".(($reguestedValue=="xx-small")?" selected":"").">xx-small</option>
<option value=\"x-small\"".(($reguestedValue=="x-small")?" selected":"").">x-small</option>
<option value=\"small\"".(($reguestedValue=="small")?" selected":"").">small</option>
<option value=\"medium\"".(($reguestedValue=="medium")?" selected":"").">medium</option>
<option value=\"large\"".(($reguestedValue=="large")?" selected":"").">large</option>
<option value=\"x-large\"".(($reguestedValue=="x-large")?" selected":"").">x-large</option>
<option value=\"xx-large\"".(($reguestedValue=="xx-large")?" selected":"").">xx-large</option>
<option value=\"smaller\"".(($reguestedValue=="smaller")?" selected":"").">smaller</option>
<option value=\"larger\"".(($reguestedValue=="larger")?" selected":"").">larger</option>
</select>";
return $htmlOutput;
}
function positionList($name,$id,$onchange,$reguestedValue) {
$htmlOutput = "";
$htmlOutput = "<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"left\"".((!$reguestedValue||$reguestedValue=="left")?" selected":"").">Left</option>
<option value=\"center\"".(($reguestedValue=="center")?" selected":"").">Center</option>
<option value=\"right\"".(($reguestedValue=="right")?" selected":"").">Right</option>
</select>";
return $htmlOutput;
}
function bordersizeList($name,$id,$onchange,$reguestedValue) {
$htmlOutput = "";
$htmlOutput = "<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"0\"".((!$reguestedValue||$reguestedValue=="0")?" selected":"").">0</option>
<option value=\"1\"".(($reguestedValue=="1")?" selected":"").">1</option>
<option value=\"2\"".(($reguestedValue=="2")?" selected":"").">2</option>
<option value=\"3\"".(($reguestedValue=="3")?" selected":"").">3</option>
</select>";
return $htmlOutput;
}
function repeatList($name,$id,$onchange,$reguestedValue) {
$htmlOutput = "";
$htmlOutput = "<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"no-repeat\"".((!$reguestedValue||$reguestedValue=="no-repeat")?" selected":"").">No Repeat</option>
<option value=\"repeat\"".(($reguestedValue=="repeat")?" selected":"").">Horizontally & Vertically</option>
<option value=\"repeat-x\"".(($reguestedValue=="repeat-x")?" selected":"").">Horizontally Only</option>
<option value=\"repeat-y\"".(($reguestedValue=="repeat-y")?" selected":"").">Vertically Only</option>
</select>";
return $htmlOutput;
}
function posList($name,$id,$onchange,$reguestedValue) {
$htmlOutput = "";
$htmlOutput = "<select name=\"".$name."\" id=\"".$id."\" style=\"width: 237;\" onChange=\"".$onchange."\">
<option value=\"-500%\"".((!$reguestedValue||$reguestedValue=="-500%")?" selected":"").">-500%</option>";
for ($i=-499; $i<501; $i++) $htmlOutput .= "<option value=\"".$i."%\"".(($reguestedValue==$i)?" selected":"").">".$i."%</option>";
$htmlOutput .= "</select>";
return $htmlOutput;
}
function flashchartobject($width,$height,$url,$snum) {
global $lang, $setts;
if (!$type||$type=="") $type="pie";
$out = "<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0\" width=\"".$width."\" height=\"".$height."\" id=\"graph-2\" align=\"middle\">";
$out .= "<param name=\"allowScriptAccess\" value=\"sameDomain\">";
$out .= "<param name=\"movie\" value=\"".$setts['siteurl']."flashchart.swf?&width=".$width."&height=".$height."&data=".$url."\">";
$out .= "<param name=\"quality\" value=\"high\">";
$out .= "<param name=\"wmode\" value=\"opaque\">";
$out .= "<param name=\"bgcolor\" value=\"#FFFFFF\">";
$out .= "<embed src=\"".$setts['siteurl']."flashchart.swf?width=".$width."&height=".$height."&data=".$url."\" quality=\"high\" wmode=\"opaque\" bgcolor=\"#FFFFFF\" width=\"".$width."\" height=\"".$height."\" name=\"flashchart".$snum."\" align=\"middle\" allowScriptAccess=\"sameDomain\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\">";
$out .= "</object>";
return $out;
}
function reverseadvTimeLimit($timelimit) {
global $lang, $setts;
if ($timelimit==0) $timelimit = 60;
else $timelimit = $timelimit*60;
return $timelimit;
}
function recalcStartPrice($bidstart,$bidend,$startdate,$enddate,$timelimit) {
global $lang, $setts;
$enddate = $enddate - reverseadvTimeLimit($timelimit);//30 minutes before the auction ends
$bidstart = $bidstart-(($bidstart-$bidend)/($enddate-$startdate));
return $bidstart;
}
function nonPaypalToPaypalCurrencyConvertor($in) {
$paypalAcceptedCurrencies = "AUD,CAD,EUR,GBP,JPY,USD,NZD,CHF,HKD,SGD,SEK,DKK,PLN,NOK,HUF,CZK,ILS,MXN";
if (InStrCount($paypalAcceptedCurrencies,$in)==0) $out = "USD";
else $out = $in;
return $out;
}
function nashCurrencyConverter($from,$to,$amount) {
global $lang, $setts;
$convert_from_rate = getSqlField("SELECT converter FROM yspnash_currencies WHERE symbol='".$from."'", "converter");
$convert_to_rate = getSqlField("SELECT converter FROM yspnash_currencies WHERE symbol='".$to."'", "converter");
if ($convert_from_rate==0) $convert_from_rate = 1;
$dollar_amount = $amount / $convert_from_rate;
$result_amount = $dollar_amount * $convert_to_rate;
$result_amount = round($result_amount,2);
return $result_amount;
}
function idvMarker($userid) {
global $path, $lang, $setts;
$verify = getSqlField("SELECT verify FROM yspnash_users WHERE id='".$userid."'", "verify");
if ($setts['idvmode']==0) {
if ($verify==1) $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\"><img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash89]."\" border=\"0\" align=\"absmiddle\"></a>";
else $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\"><img src=\"".$path."images/not_verified_10x10.gif\" title=\"".$lang[nash90]."\" border=\"0\" align=\"absmiddle\"></a>";
} else if ($setts['idvmode']==1) {
$isphone_verified = getSqlField("SELECT isphone_verified FROM yspnash_users WHERE id='".$userid."'", "isphone_verified");
$isaddress_verified = getSqlField("SELECT isaddress_verified FROM yspnash_users WHERE id='".$userid."'", "isaddress_verified");
$extraMarker = "";
if ($verify==1) $extraMarker = "<img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash4300]."\" border=\"0\" align=\"absmiddle\">";
if ($isphone_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10_2.gif\" title=\"".$lang[nash4301]."\" border=\"0\" align=\"absmiddle\">";
if ($isaddress_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10_3.gif\" title=\"".$lang[nash4302]."\" border=\"0\" align=\"absmiddle\">";
if ($verify==1&&$isphone_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash4300]."\" border=\"0\" align=\"absmiddle\"><img src=\"".$path."images/verified_10x10_2.gif\" title=\"".$lang[nash4301]."\" border=\"0\" align=\"absmiddle\">";
if ($verify==1&&$isaddress_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash4300]."\" border=\"0\" align=\"absmiddle\"><img src=\"".$path."images/verified_10x10_3.gif\" title=\"".$lang[nash4302]."\" border=\"0\" align=\"absmiddle\">";
if ($isphone_verified==1&&$isaddress_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10_2.gif\" title=\"".$lang[nash4301]."\" border=\"0\" align=\"absmiddle\"><img src=\"".$path."images/verified_10x10_3.gif\" title=\"".$lang[nash4302]."\" border=\"0\" align=\"absmiddle\">";
if ($verify==1&&$isphone_verified==1&&$isaddress_verified==1) $extraMarker = "<img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash4300]."\" border=\"0\" align=\"absmiddle\"><img src=\"".$path."images/verified_10x10_2.gif\" title=\"".$lang[nash4301]."\" border=\"0\" align=\"absmiddle\"><img src=\"".$path."images/verified_10x10_3.gif\" title=\"".$lang[nash4302]."\" border=\"0\" align=\"absmiddle\">";
if ($verify==1||$isphone_verified==1||$isaddress_verified==1) $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\">".$extraMarker."</a>";
else $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\"><img src=\"".$path."images/not_verified_10x10.gif\" title=\"".$lang[nash90]."\" border=\"0\" align=\"absmiddle\"></a>";
} else if ($setts['idvmode']==2) {
$idv_steps_completed = getSqlField("SELECT idv_steps_completed FROM yspnash_users WHERE id='".$userid."'", "idv_steps_completed");
if ($verify==1&&$idv_steps_completed==3) $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\"><img src=\"".$path."images/verified_10x10.gif\" title=\"".$lang[nash89]."\" border=\"0\" align=\"absmiddle\"></a>";
else $out = "<a href=\"".$setts['siteurl']."".(($setts['isuserhelp_enabled']==0)?"help":"help360").".php\" target=\"_blank\"><img src=\"".$path."images/not_verified_10x10.gif\" title=\"".$lang[nash90]."\" border=\"0\" align=\"absmiddle\"></a>";
}
return $out;
}
function audioBidio($in) {
$out = "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\" width=\"1\" height=\"1\" name=\"audiolivebidconfirm\" id=\"audiolivebidconfirm\" align=\"\"><param name=\"movie\" value=\"audiolivebidconfirm.swf?sl=audiolivebid.php?p=".$in."&l=0&sh=0&v=100\"><param name=\"quality\" value=\"high\"><param name=\"bgcolor\" value=\"#FFFFFF\"><embed src=\"audiolivebidconfirm.swf?sl=audiolivebid.php?p=".$in."&l=0&sh=0&v=100\" quality=\"high\" bgcolor=\"#FFFFFF\" width=\"1\" height=\"1\" name=\"audiolivebidconfirm\" id=\"audiolivebidconfirm\" align=\"\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\"></embed></object>";
return $out;
}
function checkCategoryExist($catId, $table="yspnash_categories") {
$nbCats = getSqlNumber("SELECT parent FROM $table WHERE id='".$catId."'");
if ($nbCats==0) $catId = getSqlField("SELECT id FROM $table WHERE parent=0 AND hidden=0 AND userid=0 ORDER BY customXcategory,theorder LIMIT 1","id");
return $catId;
}
function checkRegionSuburbsExist($regSubId) {
$nbRegSubs = getSqlNumber("SELECT parent FROM nash_regions_and_suburbs WHERE id='".$regSubId."'");
if ($nbRegSubs==0) $regSubId = getSqlField("SELECT id FROM nash_regions_and_suburbs WHERE parent=0 AND hidden=0 ORDER BY theorder LIMIT 1","id");
return $regSubId;
}
function nash_send_sms($userid,$message) {
global $lang,$setts,$s_membersarea,$s_memberlastaccess,$s_memberid,$s_membername,$s_memberusern,$s_password,$s_sms_phone_number,$s_sms_message,$s_syidescription,$s_nb_items_per_page,$s_is_myfolders,$s_option,$s_charity_id,$s_scatid,$s_sstep,$s_llistin,$s_ageOkToBid,$s_memberzip,$s_memberland,$s_accsusp,$s_is_guest,$s_is_seller,$s_auctionid_refresh,$s_buynow_refresh,$s_buynow_timeout,$s_sess_lang,$s_table_to_modify,$s_slandid,$s_landname,$s_landflag,$s_mygateza_merch_id,$s_mygateza_app_id,$s_mygateza_currency,$s_setcom_email,$s_setcom_username,$s_setcom_pw,$s_setcom_currency,$s_label_comment1,$s_label_comment2,$s_label_comment3,$s_label_comment4,$s_label_comment5,$s_comment1,$s_comment2,$s_comment3,$s_comment4,$s_comment5,$s_quantity,$s_pagseguro_token,$s_show_msg,$s_showcountry,$s_nrs2;
$results = "";
$sms_phone_number = getSqlField("SELECT sms_phone_number FROM yspnash_users WHERE id='".$userid."'", "sms_phone_number");
if (class_exists('sms')&&$sms_phone_number!="n/a"&&$sms_phone_number!="") {
$s_sms_phone_number = $sms_phone_number;
$s_sms_message = $message;
//start of updating sessions
$_SESSION[$setts['pk']."_sessioner"] = base64_encode(nash_cc_encrypt($s_membersarea."[XAX]".$s_memberlastaccess."[XAX]".$s_memberid."[XAX]".$s_membername."[XAX]".$s_memberusern."[XAX]".$s_password."[XAX]".$s_sms_phone_number."[XAX]".$s_sms_message."[XAX]".$s_syidescription."[XAX]".$s_nb_items_per_page."[XAX]".$s_is_myfolders."[XAX]".$s_option."[XAX]".$s_charity_id."[XAX]".$s_scatid."[XAX]".$s_sstep."[XAX]".$s_llistin."[XAX]".$s_ageOkToBid."[XAX]".$s_memberzip."[XAX]".$s_memberland."[XAX]".$s_accsusp."[XAX]".$s_is_guest."[XAX]".$s_is_seller."[XAX]".$s_auctionid_refresh."[XAX]".$s_buynow_refresh."[XAX]".$s_buynow_timeout."[XAX]".$s_sess_lang."[XAX]".$s_table_to_modify."[XAX]".$s_slandid."[XAX]".$s_landname."[XAX]".$s_landflag."[XAX]".$s_mygateza_merch_id."[XAX]".$s_mygateza_app_id."[XAX]".$s_mygateza_currency."[XAX]".$s_setcom_email."[XAX]".$s_setcom_username."[XAX]".$s_setcom_pw."[XAX]".$s_setcom_currency."[XAX]".$s_label_comment1."[XAX]".$s_label_comment2."[XAX]".$s_label_comment3."[XAX]".$s_label_comment4."[XAX]".$s_label_comment5."[XAX]".$s_comment1."[XAX]".$s_comment2."[XAX]".$s_comment3."[XAX]".$s_comment4."[XAX]".$s_comment5."[XAX]".$s_quantity."[XAX]".$s_pagseguro_token."[XAX]".$s_show_msg."[XAX]".$s_showcountry."[XAX]".$s_nrs2,$setts['myprivatekey']));
//end of updating sessions
$mysms = new sms;
$results = $mysms->send($sms_phone_number,$setts['sitename'],$message);
}
return $results;
}
function create_backup_sql($file) {
$line_count = 0;
$tables = mysql_query("SHOW TABLES");
$sql_string = NULL;
while ($table = mysql_fetch_array($tables)) {
$table_name = $table[0];
$sql_string = "TRUNCATE TABLE ".$table_name."[QXNASHXQ]";
$table_query = mysql_query("SELECT * FROM ".$table_name."");
$num_fields = mysql_num_fields($table_query);
while ($fetch_row = mysql_fetch_array($table_query)) {
$sql_string .= "INSERT INTO ".$table_name." VALUES (";
$first = TRUE;
for ($field_count=1; $field_count<=$num_fields; $field_count++) {
if (TRUE==$first) {
$sql_string.="'".mysql_real_escape_string($fetch_row[($field_count-1)])."'";
$first = FALSE;
} else {
$sql_string.=", '".mysql_real_escape_string($fetch_row[($field_count-1)])."'";
}}
$sql_string.=")[QXNASHXQ]";
if ($sql_string!="") {
$line_count = write_backup_sql($file,$sql_string,$line_count);
}
$sql_string = NULL;
}}
return $line_count;
}
function write_backup_sql($file, $string_in, $line_count) {
fwrite($file, $string_in);
return ++$line_count;
}
function load_backup_sql($file) {
$line_count = 0;
$file = substr($file, 0, -10);
$file = explode("[QXNASHXQ]",$file);
for ($i=0; $i<=count($file); $i++) {
mysql_query($file[$i]) or die("sql failed: ".mysql_error()." query: ".$file[$i]);
$line_count++;
}
return $line_count;
}
function hostedEmailsConvert($username_in) {
global $lang, $setts;
$domainConvertr = substr($setts['siteurl'], 0, -1);
$domainConvertr = str_replace('https://www.','',$domainConvertr);
$domainConvertr = str_replace('http://www.','',$domainConvertr);
$domainConvertr = str_replace('https://','',$domainConvertr);
$domainConvertr = str_replace('http://','',$domainConvertr);
$domainConvertr = explode("/",$domainConvertr);
$domainConvertr = $domainConvertr[0];
$usernameConvertr = preg_replace("/[^a-z0-9]/i","",$username_in);
$usernameConvertr = strtolower($usernameConvertr);
$nbSameHostedEmails = getSqlNumber("SELECT id FROM yspnash_users WHERE hosted_email LIKE '%".$usernameConvertr."%'");
if ($nbSameHostedEmails==0) {
$new_nbSameHostedEmails = $nbSameHostedEmails++;
$linkedUsernameAndDomain = $usernameConvertr."@".$domainConvertr;
$hostedemailsexceptions = explode(",",$setts['hosted_emails_exceptions']);
for ($hostedemailsexceptionsCount=0;$hostedemailsexceptionsCount<count($hostedemailsexceptions);$hostedemailsexceptionsCount++) {
if (strtolower($linkedUsernameAndDomain)==$hostedemailsexceptions[$hostedemailsexceptionsCount]) $linkedUsernameAndDomain = $usernameConvertr.$new_nbSameHostedEmails."@".$domainConvertr;
}
if (strtolower($linkedUsernameAndDomain)==strtolower($setts['adminemail'])) $linkedUsernameAndDomain = $usernameConvertr.$new_nbSameHostedEmails."@".$domainConvertr;
} else {
$new_nbSameHostedEmails = $nbSameHostedEmails++;
$linkedUsernameAndDomain = $usernameConvertr.$new_nbSameHostedEmails."@".$domainConvertr;
$hostedemailsexceptions = explode(",",$setts['hosted_emails_exceptions']);
for ($hostedemailsexceptionsCount=0;$hostedemailsexceptionsCount<count($hostedemailsexceptions);$hostedemailsexceptionsCount++) {
if (strtolower($linkedUsernameAndDomain)==$hostedemailsexceptions[$hostedemailsexceptionsCount]) $linkedUsernameAndDomain = $usernameConvertr.$new_nbSameHostedEmails++."@".$domainConvertr;
}
if (strtolower($linkedUsernameAndDomain)==strtolower($setts['adminemail'])) $linkedUsernameAndDomain = $usernameConvertr.$new_nbSameHostedEmails++."@".$domainConvertr;
}
return $linkedUsernameAndDomain;
}
function searchdump($keywords,$datetime,$ip,$username,$nbResults) {
global $lang, $setts;
if ($_SESSION[$setts['pk']."_searchdumpr"]!=$keywords.",".$datetime.",".$ip.",".$username.",".$nbResults) {
if ($setts['searchdump_name']!="") {
$fileName = $setts['searchdump_name'];
} else {
$fileName = "searchdump_".date('Y').md5(uniqid(rand(2, 99999))).time().".csv";
$updSearchDumpName = mysql_query("UPDATE yspnash_gen_setts2 SET searchdump_name='".$fileName."'");
}
if (file_exists($fileName)) $content = "";
else $content = "Keywords,DateTime,IP,Username,ResultsNumber\n";
$fp = fopen($fileName,"a");
$content .= $keywords.",".$datetime.",".$ip.",".$username.",".$nbResults."\n";
fputs($fp,$content);
fclose($fp);
@clearstatcache();
$_SESSION[$setts['pk']."_searchdumpr"] = $keywords.",".$datetime.",".$ip.",".$username.",".$nbResults;
}}
function hmac($key,$data) {
$b = 64;
if (strlen($key)>$b) $key = pack("H*",md5($key));
$key = str_pad($key,$b,chr(0x00));
$ipad = str_pad("",$b,chr(0x36));
$opad = str_pad("",$b,chr(0x5c));
$k_ipad = $key^$ipad;
$k_opad = $key^$opad;
return md5($k_opad.pack("H*",md5($k_ipad.$data)));
}
function hmac2($key,$data) {
$hmac = new Crypt_HMAC($key,"sha1");
$binary_hmac = pack("H40", $hmac->hash(trim($data)));
return base64_encode($binary_hmac);
}
function nash_showNonEnglish($text) {
$text = str_replace("&copy;", '&#169;', $text);
$text = str_replace("&reg;", '&#174;', $text);
$text = str_replace("&trade;", '&#8482;', $text);
$text = str_replace("&amp;", '&', $text);
$text = str_replace("&lt;", '&#60;', $text);
$text = str_replace("&gt;", '&#62;', $text);
$text = str_replace("&cent;", '&#162;', $text);
$text = str_replace("&pound;", '&#163;', $text);
$text = str_replace("&quot;", '&#34;', $text);
$text = str_replace("&lsquo;", '&#8216;', $text);
$text = str_replace("&rsquo;", '&#8217;', $text);
$text = str_replace("&ldquo;", '&#8220;', $text);
$text = str_replace("&rdquo;", '&#8221;', $text);
$text = str_replace("&laquo;", '&#171;', $text);
$text = str_replace("&raquo;", '&#187;', $text);
$text = str_replace("&mdash;", '&#8212;', $text);
$text = str_replace("&ndash;", '&#8211;', $text);
$text = str_replace("&deg;", '&#176;', $text);
$text = str_replace("&plusmn;", '&#177;', $text);
$text = str_replace("&frac14;", '&#188;', $text);
$text = str_replace("&frac12;", '&#189;', $text);
$text = str_replace("&frac34;", '&#190;', $text);
$text = str_replace("&times;", '&#215;', $text);
$text = str_replace("&divide;", '&#247;', $text);
$text = str_replace("&alpha;", '&#913;', $text);
$text = str_replace("&beta;", '&#914;', $text);
$text = str_replace("&infin;", '&#8734;', $text);
$text = str_replace("&nbsp;", '&#160;', $text);
$text = str_replace("&iexcl;", '&#161;', $text);
$text = str_replace("&curren;", '&#164;', $text);
$text = str_replace("&yen;", '&#164;', $text);
$text = str_replace("&brvbar;", '&#166;', $text);
$text = str_replace("&sect;", '&#167;', $text);
$text = str_replace("&uml;", '&#168;', $text);
$text = str_replace("&ordf;", '&#170;', $text);
$text = str_replace("&not;", '&#172;', $text);
$text = str_replace("&shy;", '&#173;', $text);
$text = str_replace("&macr;", '&#175;', $text);
$text = str_replace("&sup2;", '&#178;', $text);
$text = str_replace("&sup3;", '&#179;', $text);
$text = str_replace("&acute;", '&#180;', $text);
$text = str_replace("&micro;", '&#181;', $text);
$text = str_replace("&middot;", '&#183;', $text);
$text = str_replace("&cedil;", '&#184;', $text);
$text = str_replace("&sup1;", '&#185;', $text);
$text = str_replace("&ordm;", '&#186;', $text);
$text = str_replace("&iquest;", '&#191;', $text);
$text = str_replace("&OElig;", '&#338;', $text);
$text = str_replace("&oelig;", '&#339;', $text);
$text = str_replace("&Scaron;", '&#352;', $text);
$text = str_replace("&scaron;", '&#353;', $text);
$text = str_replace("&dagger;", '&#8224;', $text);
$text = str_replace("&Dagger;", '&#8225;', $text);
$text = str_replace("&bull;", '&#8226;', $text);
$text = str_replace("&hellip;", '&#8230;', $text);
$text = str_replace("&permil;", '&#8240;', $text);
return $text;
}

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Do I have to re write querries when Partitioning?
1988
September 05, 2010 07:52PM
1765
September 06, 2010 11:38PM
2405
September 06, 2010 11:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.