Gå til innhold

Problemer med "digg spy" side jeg har

uranus

Av uranus
i Programmering og webutvikling

Anbefalte innlegg

uranus

uranus

Skrevet
Skrevet

http://www.ludrio.no/forumet/spy/

 

Her er da problemet. Den skal vise 5 nyeste trådene fra forumet mitt. Og utifra dette skal den kun vise de, og når en ny tråd kommer, kommer den øverst og dytter den nederste ut.

 

I denne så viser den alle trådene. Den sirkulerer.

 

Her er koden:

 

Index

Klikk for å se/fjerne innholdet nedenfor

<?php

//DB Connection

mysql_pconnect("localhost", "****", "****");

mysql_select_db("****");

 

//Get the Sajax here

require("scripts/sajax.php");

 

 

//Execute the query to select from the table zips

function GET_zips($x) {

$q = "select topic_title, topic_id, topic_time, topic_views from phpbb_topics order by topic_time desc limit $x, 1;";

$sql = @mysql_query($q);

while($array = mysql_fetch_array($sql)){

return $result = $array[0] . " | " . $array[1] . " | " . $array[2] . " | " . $array[3] . " | " . $array[4];

}

}

 

sajax_init();

$sajax_debug = 0;

sajax_export("GET_zips");

sajax_handle_client_request();

?>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Ludrio Spy</title>

<script type="text/javascript">

<?

sajax_show_javascript();

?>

</script>

<script language="javascript" src="scripts/prototype.js"></script>

<script language="javascript" src="scripts/effects.js"></script>

<script language="javascript" src="scripts/spy.js"></script>

 

<script language="javascript"> columnsmax = 5; </script>

<style type="text/css">

#spy table {font:9px verdana,tahoma,arial,sans-serif;}

#spy div {margin-bottom:15px;}

#spy div:hover {background-color:#F5F7F7}

h3 img {cursor:pointer}

</style>

<style type="text/css">

h3 { text-transform: uppercase }

</style>

</head>

 

<body onload="init()">

<img id="vsplay" src="images/play_down.gif" alt="Play" title="Play Comments" onclick="playVoteSpy();">

<img id="vspause" src="images/pause_up.gif" alt="Pause" title="Pause Comments" onclick="pauseVoteSpy();">

 

 

 

<table width="100%">

<tr valign="top\">

<td width="185">Tittel</td>

<td width="130">ID</td>

<td width="85">Klokken</td>

 

<td width="125">Visninger</td>

</tr>

</table>

 

<div id="spy">

 

<div id="comment-5"/></div>

 

<div id="comment-4"/></div>

 

<div id="comment-3"/></div>

 

<div id="comment-2"/></div>

 

<div id="comment-1"/></div>

 

</div>

</body>

</html>

 

 

Spy.js

Klikk for å se/fjerne innholdet nedenfor

var columnsmax;

var play = 0;

var zip;

var topic_views;

var population;

var topic_title;

var digit = 0;

 

function init() {

start();

}

 

function pauseVoteSpy() {

var playimg = document.getElementById("vsplay");

var pauseimg = document.getElementById("vspause");

 

playimg.src = "images/play_up.gif";

playimg.alt = "Start";

pauseimg.src = "images/pause_down.gif";

pauseimg.alt = "Pause...";

 

pause();

}

 

function playVoteSpy() {

var playimg = document.getElementById("vsplay");

var pauseimg = document.getElementById("vspause");

 

playimg.src = "images/play_down.gif";

playimg.alt = "Viser..";

pauseimg.src = "images/pause_up.gif";

pauseimg.alt = "Pause";

 

resume();

}

 

function pause() {

play = 0;

}

 

function resume() {

play = 1;

}

 

function start() {

setTimeout("processDB()", 500);

 

}

 

 

function GET_zips_CB(result) {

var parts = result.split(" | ");

topic_views = parts[0];

zip = parts[1];

population = parts[2];

topic_title = parts[3];

push();

}

 

function processDB() {

 

x_GET_zips(digit, GET_zips_CB);

digit++;

setTimeout("start()", 2000);

 

}

 

function push() {

 

if (play == 0) {

setTimeout("push()", 1000);

return;

}

 

var cell;

var cellnext;

var text;

var style = "";

 

 

text = "<table width=\"100%\">"

text += "<tr valign=\"top\">";

text += "<td width=\"185\">"+topic_views+"</td>";

text += "<td width=\"130\">" + zip + "</td>";

text += "<td width=\"85\">" + population + "</td>";

text += "<td width=\"125\">" + topic_title + "</td>";

text += "</tr>";

text += "</table>";

 

Element.setOpacity('comment-1', 0.0);

 

for (i = (columnsmax - 1); i >= 1; i--) {

cell = document.getElementById("comment-" + i);

cellnext = document.getElementById("comment-" + (i + 1));

if (cell.innerHTML != "") {

cellnext.innerHTML = cell.innerHTML;

}

}

 

document.getElementById("comment-1").innerHTML = text;

 

Effect.Appear('comment-1', { duration: 1.5 });

 

if (pollids.length > 0) {

setTimeout("push()", 1550);

}

else {

setTimeout("start()", 5000);

}

}

 

 

Håper noen kan hjelpe!

Lenke til kommentar

Opprett en konto eller logg inn for å kommentere

Du må være et medlem for å kunne skrive en kommentar

Opprett konto

Det er enkelt å melde seg inn for å starte en ny konto!

Start en konto

Logg inn

Har du allerede en konto? Logg inn her.

Logg inn nå
Gå til emneliste
×
×
  • Opprett ny...