ROZWIĄZANY: Mod Pozdrowień

**TechnoDream** · 13 Marca 2009

czy istnieje taka modyfikacja pozdrowień do IPB jak tutaj ??

http://www.global-music.pl/#

Dodaj Wpis! --- A tu lecą pozdrowienia

jest to na zasadzie zrobione że czyta treści postów na stronie glównej

opis z tamtego forum

Pozdrowienia

Wpisane tutaj pozdrowienia będą widoczne na stronie głównej forum!

Zawsze ostatnie 10 postów z tego tematu.

czy dałoby rade zastosować coś takiego w IPB , jakiś skrypt na czytanie treści postów danego tematu coś takiego ?

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

Witam,

skorzystaj z tego:

http://forum.invisionize.pl/index.php?showtopic=1389

oraz:

http://forum.invisionize.pl/index.php?showtopic=1486

Oczywiście po przeróbkach.

W razie problemów piszę proszę - pomożemy.

**TechnoDream** · 13 Marca 2009

DawPi mam kodzik który pisałeś mi aby czytało ostatnie tematy w danych działach , co trzeba zmienić w tym kodzie aby czytało ostatnie 10 postów z danego tematu ??

 $jakas_zmienna = "Najnowsze Sety<marquee direction=left scrollamount=2 scrolldelay=1 onMouseOver='this.stop()' onMouseOut='this.start()' >";
  $this->ipsclass->DB->simple_construct( array(
													   'select' => 'tid, title, last_post',
										  'from'   => 'topics',
										   'where' => 'forum_id IN ( 52,100,101,102,114,117,121,156,191 ) AND approved = 1',
										   'order'  => 'start_date DESC',
											'limit'  => array( 0, 10 )
									  )   );

$this->ipsclass->DB->simple_exec();

while ($rowrm = $this->ipsclass->DB->fetch_row())
  {

	$jakas_zmienna  .=   "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";
  }

	$jakas_zmienna .= "</marquee>";

  $this->ipsclass->skin['_wrapper'] = str_replace( "<% DOSKINA %>"	 , $jakas_zmienna						 , $this->ipsclass->skin['_wrapper']);

prubowałem kombinować z tym

 $this->ipsclass->DB->simple_construct( array(
									'select' => 'p.pid, p.author_name, p.post_date',
									'from'   => array( 'posts' => 'p'),
									 'where'  => 'queued = 0',
									 'add_join' => array( 0 => array( 'select' => 't.tid, t.title, t.last_poster_id, t.starter_name',
																'from'	=> array( 'topics' => 't' ),
																'where'   => 't.tid=p.topic_id AND approved = 1',
																'type'	=> 'inner' ) ),		

							  'order'  => 'pid DESC',
								  'limit'  => array( 0, $IlePostow )
									  )   );

ale brakuje mi czegoś takiego jak wpisanie ID tematu z jakiego ma czytać posty

DawPi · 13 Marca 2009

Spróbuj tak:

$IdTematu = 44; // Wpisz ID tematu z którego ma pobrać posty
$IlePostow = 10; // Wpisz ile ma pobrać postów
$this->ipsclass->DB->simple_construct( array(
									'select' => 'p.*',
									'from'   => array( 'posts' => 'p'),
									 'where'  => 'p.queued = 0',
									 'add_join' => array( 0 => array( 'select' => 't.*',
																'from'	=> array( 'topics' => 't' ),
																'where'   => 't.tid = '.$IdTematu,
																'type'	=> 'inner' ) ),		

							  'order'  => 'pid DESC',
								  'limit'  => array( 0, $IlePostow )
									  )   );

**TechnoDream** · 13 Marca 2009

Wywala mi błąd pewnie coś zle zrobilem i zle kody poustawiałem

	$jakas_zmienna = "<marquee direction=left scrollamount=2 scrolldelay=1 onMouseOver='this.stop()' onMouseOut='this.start()' >";
		   $this->ipsclass->DB->simple_construct( array(

$IdTematu = 8893; // Wpisz ID tematu z którego ma pobrać posty
$IlePostow = 10; // Wpisz ile ma pobrać postów
$this->ipsclass->DB->simple_construct( array(
									'select' => 'p.*',
									'from'   => array( 'posts' => 'p'),
									 'where'  => 'p.queued = 0',
									 'add_join' => array( 0 => array( 'select' => 't.*',
																'from'	=> array( 'topics' => 't' ),
																'where'   => 't.tid = '.$IdTematu,
																'type'	=> 'inner' ) ),

							  'order'  => 'pid DESC',
								  'limit'  => array( 0, $IlePostow )
									  )   );

$this->ipsclass->DB->simple_exec();

while ($rowrm = $this->ipsclass->DB->fetch_row())
  {

	$jakas_zmienna  .=   "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";
  }

	$jakas_zmienna .= "</marquee>";

  $this->ipsclass->skin['_wrapper'] = str_replace( "<% POZDRO %>"	 , $jakas_zmienna						 , $this->ipsclass->skin['_wrapper']);

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

Jaki błąd?

**TechnoDream** · 13 Marca 2009

Parse error: syntax error, unexpected ';', expecting ')' in /home/emmsyste/public_html/trancegeneration/sources/classes/class_display.php on line 1172

linia 1172

$IdTematu = 8893; // Wpisz ID tematu z którego ma pobrać posty

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

Nie widzisz błędu w swoim kodzie to kopiujesz na ślepo.

$jakas_zmienna = "<marquee direction=left scrollamount=2 scrolldelay=1 onMouseOver='this.stop()' onMouseOut='this.start()' >";
$this->ipsclass->DB->simple_construct( array(

$IdTematu = 8893; // Wpisz ID tematu z którego ma pobrać posty

$IlePostow = 10; // Wpisz ile ma pobrać postów

$this->ipsclass->DB->simple_construct( array(

'select' => 'p.*',

'from' => array( 'posts' => 'p'),

'where' => 'p.queued = 0',

'add_join' => array( 0 => array( 'select' => 't.*',

'from' => array( 'topics' => 't' ),

'where' => 't.tid = '.$IdTematu,

'type' => 'inner' ) ),

'order' => 'pid DESC',

'limit' => array( 0, $IlePostow )

) );

$this->ipsclass->DB->simple_exec();

while ($rowrm = $this->ipsclass->DB->fetch_row())

{

$jakas_zmienna .= "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";

}

$jakas_zmienna .= "</marquee>";

$this->ipsclass->skin['_wrapper'] = str_replace( "<% POZDRO %>" , $jakas_zmienna , $this->ipsclass->skin['_wrapper']);

Co to tam robi?

**TechnoDream** · 13 Marca 2009

usunelem kody na czerwono ktore zaznaczyles ale dalej mam blad nic juz nie kumam

DawPi · 13 Marca 2009

Nic nie kumasz, bo nie myślisz.

Nie wiem jaki dostajesz błąd, więc nie mogę Ci pomóc. Podaj kod błędu to wtedy zobaczę, co da się zrobić. Jak inaczej chcesz otrzymać pomoc? ;/

**TechnoDream** · 13 Marca 2009

teraz mam blad IPS Driver Error

Aktualny kod

jakas_zmienna = "<marquee direction=left scrollamount=2 scrolldelay=1 onMouseOver='this.stop()' onMouseOut='this.start()' >";

			   $this->ipsclass->DB->simple_construct( array(


									'select' => 'p.*',
									'from'   => array( 'posts' => 'p'),
									 'where'  => 'p.queued = 0',
									 'add_join' => array( 0 => array( 'select' => 't.*',
																'from'	=> array( 'topics' => 't' ),
																'where'   => 't.tid = '.$IdTematu,
																'type'	=> 'inner' ) ),

							  'order'  => 'pid DESC',
								  'limit'  => array( 0, $IlePostow )
									  )   );

$this->ipsclass->DB->simple_exec();

while ($rowrm = $this->ipsclass->DB->fetch_row())
  {

	$jakas_zmienna  .=   "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";
  }

	$jakas_zmienna .= "</marquee>";

  $this->ipsclass->skin['_wrapper'] = str_replace( "<% POZDRO %>"	 , $jakas_zmienna						 , $this->ipsclass->skin['_wrapper']);

gdzie mam wpisac ID tematu ?

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

Jaki kod IPS Driver Error? Konkretnie.

**TechnoDream** · 13 Marca 2009

no mam tylko to

IPS Driver Error

There appears to be an error with the database.

You can try to refresh the page by clicking here

DawPi · 13 Marca 2009

http://forum.invisionize.pl/index.php?showtopic=542

**TechnoDream** · 13 Marca 2009

CODE-BOX

===================================================
Date: Fri, 13 Mar 2009 02:57:16 -0600
Error Number: 1062
Error: Duplicate entry '4-10015' for key 1
IP Address: 90.141.58.38
mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_
forum_id) VALUES(29,'a:1:{i:3645;i:1236934624;}',1236934624,10015,4)
===================================================
Date: Fri, 13 Mar 2009 06:26:18 -0600
Error Number: 1062
Error: Duplicate entry '209-10608' for key 1
IP Address: 83.21.94.131
mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_
forum_id) VALUES(12,'a:0:{}',1236947167,10608,209)
===================================================
Date: Fri, 13 Mar 2009 06:53:20 -0600
Error Number: 1062
Error: Duplicate entry '4-11292' for key 1
IP Address: 83.238.196.133
mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_
forum_id) VALUES(29,'a:1:{i:988;i:1236948790;}',1236948790,11292,4)
===================================================
Date: Fri, 13 Mar 2009 09:27:09 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:27:09 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 83.24.176.206
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:27:12 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 83.24.176.206
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:32:15 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:32:16 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:32:49 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 195.205.171.38
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:32:51 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:32:52 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:32:53 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 10' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 10
===================================================
Date: Fri, 13 Mar 2009 09:36:34 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:43:57 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:43:57 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 88.156.212.194
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:43:59 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 88.156.212.194
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0
===================================================
Date: Fri, 13 Mar 2009 09:43:59 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pid DESC LIMIT 0' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid = ORDER BY pid DESC LIMIT 0

DawPi · 13 Marca 2009

Próbuj:

jakas_zmienna = "<marquee direction=left scrollamount=2 scrolldelay=1 onMouseOver='this.stop()' onMouseOut='this.start()' >";

			   $this->ipsclass->DB->simple_construct( array(


									'select' => 'p.*',
									'from'   => array( 'posts' => 'p'),
									 'where'  => 'p.queued = 0',
									 'add_join' => array( 0 => array( 'select' => 't.*',
																'from'	=> array( 'topics' => 't' ),
																'where'   => 't.tid = '.$IdTematu,
																'type'	=> 'inner' ) ),

							  'order'  => 'p.pid DESC',
								  'limit'  => array( 0, $IlePostow )
									  )   );

$this->ipsclass->DB->simple_exec();

while ($rowrm = $this->ipsclass->DB->fetch_row())
  {

	$jakas_zmienna  .=   "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";
  }

	$jakas_zmienna .= "</marquee>";

  $this->ipsclass->skin['_wrapper'] = str_replace( "<% POZDRO %>"	 , $jakas_zmienna						 , $this->ipsclass->skin['_wrapper']);

**TechnoDream** · 13 Marca 2009

kolejny blad IPS

Date: Fri, 13 Mar 2009 09:59:00 -0600
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.pid DESC LIMIT 0' at line 1
IP Address: 78.88.120.237
mySQL query error: SELECT p.*,t.* FROM ibf_posts p,ibf_topics t WHERE p.queued = 0 AND t.tid =  ORDER BY p.pid DESC LIMIT 0

DawPi · 13 Marca 2009

Nie dodałeś tego:

$IdTematu = 8893; // Wpisz ID tematu z którego ma pobrać posty
$IlePostow = 10; // Wpisz ile ma pobrać postów

Przed tym kodem wyżej.

P.s. zacznij myśleć o tym, co robisz.

**TechnoDream** · 13 Marca 2009

no niby dziala tylko jest maly problemik

pokazuje mi 10 X nazwe tematu a nie tresc posta tego tematu

??

DawPi · 13 Marca 2009

Zamień:

$jakas_zmienna  .=   "<b>--- <a href=\"{$this->ipsclass->vars['board_url']}/index.php?showtopic=".$rowrm['tid']."\">".$this->ipsclass->txt_truncate($rowrm['title'], 50 )."</a></b> ";

Na:

$jakas_zmienna  .=   $rowrm['post'] . "<br /> ";

Ew. sformatuj jeszcze za pomocą HTML.

**TechnoDream** · 13 Marca 2009

hmmm tweraz pokazuje posty ale nie z tego tematu co trzeba , ID tematu to końcówka w linku tematu??

http://www.trancegeneration.com/Test-t8893.html

hmmm z tego co zauważyłem pokazuje ostatnie 10 postów ale z całego forum

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

Zamień:

'where'   => 't.tid = '.$IdTematu,

Na:

'where'   => 't.tid=p.topic_id AND t.tid = '.$IdTematu,

**TechnoDream** · 13 Marca 2009

wszystko ładnie pięknie huczy

ostatnia prośba jeszcze mały kodzik na pokazywanie Autora posta przed treścią

przykład

TechnoDream : Treść posta

i żeby pokazywało treści posta w jednej linijce , bo jak się zastosuje enter w pisaniu posta czyli

ertert

etertet

eteter

to pokazuje z enterami

Edytowane 13 Marca 2009 przez TechnoDream

DawPi · 13 Marca 2009

$jakas_zmienna  .= $rowrm['author_name']  . " : " . $rowrm['post'] . "<br /> ";

Z tym enterem to nie rozumiem.

**TechnoDream** · 13 Marca 2009

oki działa

z tym enterem jest tak :

jak napisze posta w temacie przykładzik

Pozdrowienia z wielkiej krainy czarow enter

blablabla blablab

to pozniej na stronie głównej pokazuje tam gdzie mam kod <% POZDRO %> treśc tego posta również z enterem czyli nie jest to już w jednej linijce tylko w dwóch

Pozdrowienia: TechnoDream Pozdrowienia z wielkiej krainy czarow

blablabla blablab

i to całe przesuwa się w bok opcją marquee a powinna być to w jednej linijce

Pozdrowienia: TechnoDream Pozdrowienia z wielkiej krainy czarow blablabla blablab

jest na to jakaś rada?

Zaloguj się

ROZWIĄZANY: Mod Pozdrowień

Rekomendowane odpowiedzi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

DawPi

TechnoDream

Ostatnio przeglądający 0 użytkowników

Pliki

Cała aktywność

Przeglądaj

Powiadomienie o plikach cookie