balkan
New Members-
Posts
5 -
Joined
-
Last visited
Never
Profile Information
-
Gender
Not Telling
balkan's Achievements
Newbie (1/5)
0
Reputation
-
i need code for open link in new window links.php [code]<?php // (c) 2006 Philip Heins // This script is released under terms and conditions of the GNU GPL. include("linkadmin/cstring.php"); if(isset($_GET["goto"])) { $gotowebsite=(int)$_GET["goto"]; mysql_connect($db_Host, $db_Username, $db_Pass) || die("Error: Cannot Connect to database: ".mysql_error()); mysql_select_db($db_Database); $query = "SELECT * FROM $linktable WHERE id = '$gotowebsite' LIMIT 0,1"; $result = mysql_query($query); $goodsite = mysql_num_rows($result); if($goodsite == "1") { $row = mysql_fetch_array($result); if(isset($_COOKIE[$gotowebsite])) { echo "<!--Click cookie still exists.-->\n\n"; } else { setcookie($row["id"], "clicknocounts", time()+1200); $newhits = $row[clicks]+1; mysql_query("UPDATE $linktable SET clicks = '$newhits' WHERE id = '$row[id]'") || die(mysql_error); } ?> <script language="Javascript"> var URL = "<?=$row[url]?>" var speed = 1 function reload() { location = URL } setTimeout("reload()", speed); //--> </script> <?php } else { $errormessage = "<p>There was an error finding your website. Please try clicking the link again.<br><br></p>"; } } ?> <html> <head> <title>WEB LINKS</title> <style type="text/css"> <!-- .sortby { color : #CCCCCC; font-family : Tahoma; font-size : 10pt; text-decoration : none; font-weight : none; } A:link.sortby { COLOR: #FFFFFF; TEXT-DECORATION: none; font-weight: normal; } A:link{ background: transparent; text-decoration: none; color: #000000;} A:visited.sortby { background: transparent; text-decoration: none; color: #FFFFFF;} A:visited{ background: transparent; text-decoration: none; color: #000000;} A:active.sortby { background: transparent; text-decoration: underline; color: #FFFFFF; underline-color: #CCCCCC;} A:active{ background: transparent; text-decoration: none; color: #000000;} A:hover.sortby { font-family : Tahoma; background: transparent; text-decoration: underline; color: #FFFFFF; } A:hover{ background: transparent; text-decoration: underline; color: #1A3355; } --> </style> </head> <body> <?php mysql_connect($db_Host, $db_Username, $db_Pass) || die("Error: Cannot Connect to database: ".mysql_error()); mysql_select_db($db_Database); if(!($_GET["fob"])) $_GET["fob"] = "date"; if(!($_GET["fod"])) $_GET["fod"] = "DESC"; if(!($_GET["uob"])) $_GET["uob"] = "date"; if(!($_GET["uod"])) $_GET["uod"] = "DESC"; // SECURE THAT SHIT UP THERE ^ ^ ^ ^ ^ ^ ^ ^ ^ // make it so it doesn't use actual values $fodunsecure = $_GET["fod"]; $fobunsecure = $_GET["fob"]; $uodunsecure = $_GET["uod"]; $uobunsecure = $_GET["uob"]; switch ($fobunsecure) { case "website": $fob = "name"; break; case "desc": $fob = "descr"; break; case "date": $fob = "datesubmit"; break; case "hits": $fob = "clicks"; break; default: $fob = "datesubmit"; $fobunsecure = "date"; } switch ($fodunsecure) { case "DESC": $fod = "DESC"; break; case "ASC": $fod = "ASC"; break; default: $fod = "DESC"; } switch ($uobunsecure) { case "website": $uob = "name"; break; case "desc": $uob = "descr"; break; case "date": $uob = "datesubmit"; break; case "hits": $uob = "clicks"; break; default: $uob = "datesubmit"; $uobunsecure = "date"; } switch ($uodunsecure) { case "DESC": $uod = "DESC"; break; case "ASC": $uod = "ASC"; break; default: $uod = "DESC"; $uodunsecure = "DESC"; } ?> <center> <p><table border="0" cellspacing="2" cellpadding="3"> <tr> <td colspan="4"> <table border="2" cellspacing="0" cellpadding="2" width="100%" height="100%" bordercolor="#22419C" bordercolorlight="#22419C" bordercolordark="#22419C" bgcolor="#545864"> <tr> <td align="left" valign="center" bordercolor="#545864" width="50%"><font face="Tahoma, Arial, Verdana" size="5"><font color="#517DFF">WEB</font><font color="#FFFFFF">.</font><font color="#9AB3FF">LINKS</font></font></td> <td align="center" valign="center" bordercolor="#545864"><INPUT type="button" value="Add Your Website" onClick="window.open('addlink.php', 'AddYourLink', 'width=335, height=152, status=no, resizeable=no, menubar=no, toolbar=no, directories=no, location=no, scrollbars=no')" style="border: 2px double #98njg3;border-color: #22419C;background-color: #797E8F;color: #FFFFFF;font-size: 10pt;font-weight: bold;font-family: Tahoma, Verdana, Arial, sans-serif;"></td> </tr> </table> </td> </tr> <tr> <td colspan="4"> <center><font face="Arial" size=2 color="red"><br> <?php if(isset($errormessage)) { echo $errormessage; } ?> </font> </FORM> </center> </td> </tr> <tr> <td colspan="4" bgcolor="#C4D3FF"> <font face="Tahoma" size=3><b> Featured Links</b></font> </td> </tr> <tr bgcolor="#2A4596"> <td width="117" align="left" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Website</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=website&fod=ASC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="A-Z"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=website&fod=DESC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Z-A"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="227" align="left" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Description</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=desc&fod=ASC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="A-Z"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=desc&fod=DESC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Z-A"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="80" align="center" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Added</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=date&fod=ASC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Oldest to Newest"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=date&fod=DESC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Newest to Oldest"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="54" align="center" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Hits</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=hits&fod=ASC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Least to most"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=hits&fod=DESC&uob=<?=$uobunsecure?>&uod=<?=$uodunsecure?>" title="Most to Least"><img src="linkadmin/images/asc.gif" border=0></a></font></td> </tr> <?php $query = "SELECT * FROM $linktable WHERE featured = '1' ORDER BY `$fob` $fod"; $result = mysql_query($query); // in the form TITLE - Description while ($row = mysql_fetch_array($result)) { $url = stripslashes($row["url"]); $name = htmlspecialchars(stripslashes($row["name"])); $descr = htmlspecialchars(stripslashes($row["descr"])); $date = gmdate("M d, Y", $row["datesubmit"]); ?> <tr> <td><font face="Tahoma" size="2"><B><A href="<?=$_SERVER["PHP_SELF"]?>?goto=<?=$row[id]?>" title="<?=$url?>"><?=$name?></a></b></font></td> <td><font face="Tahoma" size="2"><?=$descr?></font></td> <td align="center"><font face="Tahoma" size="2"><?=$date?></font></td> <td><font face="Tahoma" size="2"> <?=$row[clicks]?></font></td> </tr> <?php } ?> <tr><td><img src="linkadmin/images/spacer.gif" width="1" height="5"></td></tr> <tr> <td colspan="4" align="right" valign="top" bgcolor="#545864"><font face="Tahoma" size="2" color="#FFFFFF"><b>Total Websites:</b> <?php // get and print number of rows in resultset echo mysql_num_rows($result); ?> </font> </td> </tr> <tr><td> </td></tr> <tr> <td colspan="4" bgcolor="#C4D3FF"> <font face="Tahoma" size=3><b> Fan Links</b></font> </td> </tr> <tr bgcolor="#2A4596"> <td width="117" align="left" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Website</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=website&uod=ASC" title="A-Z"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=website&uod=DESC" title="Z-A"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="227" align="left" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Description</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=desc&uod=ASC" title="A-Z"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=desc&uod=DESC" title="Z-A"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="80" align="center" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Added</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=date&uod=ASC" title="Oldest to Newest"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=date&uod=DESC" title="Newest to Oldest"><img src="linkadmin/images/asc.gif" border=0></a></font></td> <td width="54" align="center" valign="top" height="11"><font face="Tahoma" size="2" color="#FFFFFF"><b>Hits</b> <a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=hits&uod=ASC" title="Least to Most"><img src="linkadmin/images/desc.gif" border=0></a><a class="sortby" href="<?$_SERVER["PHP_SELF"]?>?fob=<?=$fobunsecure?>&fod=<?=$fodunsecure?>&uob=hits&uod=DESC" title="Most to Least"><img src="linkadmin/images/asc.gif" border=0></a></font></td> </tr> <?php $query = "SELECT * FROM $linktable WHERE featured = '0' AND authorized = '1' ORDER BY `$uob` $uod"; $result = mysql_query($query); // in the form TITLE - Description while ($row = mysql_fetch_array($result)) { $url = stripslashes($row["url"]); $name = htmlspecialchars(stripslashes($row["name"])); $descr = htmlspecialchars(stripslashes($row["descr"])); $date = gmdate("M d, Y", $row["datesubmit"]); ?> <tr> <td><font face="Tahoma" size="2"><B><A href="<?=$_SERVER["PHP_SELF"]?>?goto=<?=$row[id]?>" title="<?=$url?>"><?=$name?></a></b></font></td> <td><font face="Tahoma" size="2"><?=$descr?></font></td> <td align="center"><font face="Tahoma" size="2"><?=$date?></font></td> <td><font face="Tahoma" size="2"> <?=$row[clicks]?></font></td> </tr> <?php } ?> <tr><td><img src="linkadmin/images/spacer.gif" width="1" height="5"></td></tr> <tr> <td colspan="4" align="right" valign="top" bgcolor="#545864"><font face="Tahoma" size="2" color="#FFFFFF"><b>Total Websites:</b> <?php // get and print number of rows in resultset echo mysql_num_rows($result); ?> </font></td></tr> </table></p> </p> <p align="center"><font face="Tahoma, Arial" size=2><a href="http://www.google.com">WEB LINKS</a> Version: <?=$version?> - © 2006</font></p> </body></html>[/code]
-
can someone help put in this script logout code and repair [code]echo "main.php?url=".$daten[url]; [/code]
-
i post all code from script, any HELP ?
-
ok admin.php [code] <? include "config.inc.php"; if ($pw == $passwort) { setcookie("pw",$pw,time()+(3600*24*7)); } include "header.php"; if ($pw != $passwort) { ?><form action="admin.php" method="post"> <p>Password:<br> <input type="password" name="pw"></p> <input type="submit" value="Prati"> </form> <? include "footer.php"; exit; } else { mysql_connect($sqlhost,$sqluser,$sqlpass) or die ("Couldn't connect to MySQL Server!"); mysql_select_db($database) or die ("Keine Verbindung zur Datenbank!"); ?> <h2>Administracija</h2> <p><strong><a href="admin.php?do=add">Dodaj Nov Link</a> | <a href="admin.php">Admin Home</a></strong></p> <? if ($do=="insert") { $query = "INSERT INTO $table VALUES ('', '$url','$descr','$title', '$date', '0')"; mysql_query($query) or die (mysql_error()); echo "<strong><font color=\"#FF0000\">Der Link $url wurde in die Datenbank aufgenommen!</font></strong>"; } elseif ($do=="delete") { if ($ask) { echo "<p>Dali si Siguren??</p>"; echo "<a href=\"admin.php?do=delete&id=$id\">Da</a> <a href=\"admin.php\">Ne</a>"; } else { $result = mysql_query("DELETE FROM $table WHERE id = '$id'") or die (mysql_error("Konnte nicht lцschen!")); echo "<strong><font color=\"#FF0000\">Linkot e uspesno izbrisan!</font></strong>"; } } elseif ($do=="change") { if ($change) { mysql_query("UPDATE $table SET url = '$url', title = '$title' WHERE id = $id") or die (mysql_error()); mysql_query("UPDATE $table SET descr='$descr' WHERE id = $id") or die (mysql_error()); echo "Datensatz aktualisiert!"; } else { $query = "SELECT * FROM $table WHERE id = '$id'"; $result = mysql_query($query) or die (mysql_error()); echo "<form action=\"admin.php?do=change&id=$id&change=1\" method=\"post\">"; echo "<table width=\"80%\"><tr><td colspan=\"2\">Promena na Linkot</td></tr><tr><td colspan=\"2\">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</td></tr>"; while ($daten = mysql_fetch_array($result)) { echo "<tr><td>URL:</td><td><input type=\"text\" name=\"url\" value=\"$daten[url]\" size=\"45\"></td></tr>\n"; echo "<tr><td>Naslov:</td><td><input type=\"text\" name=\"title\" value=\"$daten[title]\" size=\"45\"></td></tr>\n"; echo "<tr><td>Opis:</td><td><textarea cols=\"35\" rows=\"15\" name=\"descr\">$daten[descr]</textarea></td></tr>\n"; echo "<tr><td><input type=\"reset\"></td><td><input type=\"submit\"></td></tr>\n"; } echo "</table>"; echo "</form>"; } } elseif ($do=="add") { echo "<form action=\"admin.php?do=insert\" method=\"post\"><table><tr><td colspan=\"2\">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</td></tr>"; echo "<tr><td>URL:</td><td><input type=\"text\" name=\"url\" maxlength=\"250\" size=\"45\"></td></tr>"; echo "<tr><td>Naslov:</td><td><input type=\"text\" name=\"title\" maxlength=\"250\" size=\"45\"></td></tr>"; echo "<tr><td valign=\"top\">Opis:</td><td><textarea cols=\"35\" rows=\"10\" name=\"descr\"></textarea></td></tr>"; echo "<input type=\"hidden\" name=\"date\" value=\"".date($zeit)."\">"; echo "<tr><td><input type=\"reset\"></td><td><input type=\"submit\"></td></tr></table></form>"; } else { $query = "SELECT * from $table ORDER BY id desc"; $result = mysql_query($query) or die (mysql_error()); ?> <table> <tr><td colspan="4">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</td></tr> <tr><td><em>Linkname</em></td><td><em>Url</em></td><td colspan="2"></td></tr> <? while ($daten = mysql_fetch_array($result)) { echo "<tr><td>$daten[title]</td><td>$daten[url]</td><td><a href=\"admin.php?do=change&id=$daten[id]\">change</a></td><td><a href=\"admin.php?do=delete&ask=1&id=$daten[id]\">delete</a></td></tr>"; } ?> </table> <? } } echo "<div align=\"right\"><font size=\"-1\">© <a href=\"http://www.google.com\">labunista.org</a> 2006</font></div>"; include "footer.php"; ?>[/code] config.inc.php [code]<? // ADMIN PASSWORD LOGIN $passwort = "admin"; //DATUMSFORMATIERUNG $zeit = "j.m.Y"; //j STEHT FЬR TAG, m FЬR MONAT, Y FЬR JAHR (Andere mцgl. Formatierung z.B. Y-m-j) //SQL-DATEN $sqlhost = ''; //SQLHOST $sqluser = ''; //SQLUSERNAME $sqlpass = ''; //SQLPASSWORD $database = ''; //DATABASE $table = 'linklist'; //TABELLE // AUSSEHEN $color1 = '#a7a7a7'; // Titelhintergrundfarbe $color2 = '#cbcbcb'; // Texthintergrundfarbe // TOPLIST $toplist = 1; // Anzeige der 5 meistgeklickten Links in einer Liste (1 = ein/0 = aus) $toplist_nr = 3; // Anzahl der Toplist-Eintrдge ?>[/code] index.php [code]<? include "config.inc.php"; mysql_connect($sqlhost,$sqluser,$sqlpass) or die ("Couldn't connect to MySQL Server!"); mysql_select_db($database) or die ("Keine Verbindung zur Datenbank!"); if ($url) { $query = "UPDATE $table SET hits = hits + 1 WHERE url = '$url'"; $result = @mysql_query($query); // Auf uebergebene URL weiterleiten Header("Location: ".$url); } else { include "header.php"; if ($toplist) { echo "<p align=center><table align=center width=\"50%\" border=\"0\" cellspacing=\"0\"><tr bgcolor=\"$color1\"><td width=\"50%\"><strong>Top Linkovi</strong></td><td width=\"50%\"><strong>Hitovi</strong></td></tr>"; $query = "SELECT * FROM $table ORDER BY hits DESC LIMIT 0,$toplist_nr"; $result = mysql_query($query) or die (mysql_error()); while ($daten = mysql_fetch_array($result)) { echo "<tr bgcolor=\"$color2\"><td><a href=\"main.php?url=$daten[url]\">$daten[title]</a></td><td>$daten[hits]</td></tr>"; } echo "</table></p>"; mysql_freeresult($result); } $query = "SELECT * from $table ORDER BY id desc"; $result = mysql_query($query) or die (mysql_error()); while ($daten = mysql_fetch_array($result)) { ?> <table width="90%" border="0" cellpadding="2" cellspacing="0"> <tr> <td bgcolor="<? echo $color1; ?>" colspan="2" valign="top"><b><a target="_blank" href="<? echo "main.php?url=".$daten[url]; ?>"><? echo $daten[title]; ?></a></b></td> </tr> <tr> <td width="5%"></td> <td width="95%" valign="top" bgcolor="<? echo $color2; ?>"><? echo $daten[descr]; ?></td> </tr> <tr> <td width="5%"></td> <td width="95%" valign="top" bgcolor="<? echo $color2; ?>"><font size="-1"><p align="right"><? echo $daten[url]." | $daten[datum] | ".$daten[hits]." Hitovi"; ?></p></font></td> </tr> </table><br> <? } } include "footer.php"; ?>[/code]
-
i need help about web links script, in script not have LOGOUT and you can login only whit password not username, and the password is saved to config, so i just want to login in to username and password called to mysql not to config and add logout button ... and maybe have error in: main.php?url=www.kafic.net ! anyone repair this script and reupload ? download from: [code]http://labunista.a22.biz/links.rar[/code] size: 3.76 KB