• [MOD] TiltViewer for 4images 5 0 5 1
Currently:  

Author Topic: [MOD] TiltViewer for 4images  (Read 97220 times)

0 Members and 1 Guest are viewing this topic.

Offline Sebas Bonito

  • Sr. Member
  • ****
  • Posts: 271
  • Sebas Bonito
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #60 on: July 27, 2009, 12:41:06 AM »
:flag-de: Kann ich eigentlich 2 Tabellen kombinieren? Der Hintergrund ist nämlich der, dass ich bereits ne kleine MOD von bergblume nutze, in der ALLE Video-Kategorien (in der Settings-Tabelle) aufgelistet werden. Und Videos gehen ja nicht mit dem Tiltviewer (d.h., ich muss jedes Mal für jede neue Videokategorie die php erneuern). Und statt nun jede Videokategorie einzeln jedes Mal manuell einzugeben, wäre es doch praktischer, wenn das Skript in die Settings-Table bei "cat_rand_pic" schaut, und alle dort aufgelisteten Kategorie-IDs NICHT nimmt. Ginge das zu realisieren?

:flag-en: Is it possible to combine 2 tables? I'm still using the tiny mod of bergblume, in which the Categories (I don't want to show in Tiltviewer) already are listened. They are stored in the Settings-Table. Tiltviewer cannot present videos, so every time, I or my users have opened a new videocategory, I have to modify the tiltviewer.php manually! It would be more easier (cause automatic) to take a look at "cat_rand_pic" in the settings, where all the cat-ids I don't like to present (e.g "1,3,5,7,5") are stored. Is there a way to realize it?
« Last Edit: July 27, 2009, 12:51:21 AM by Sebas Bonito »

Rembrandt

  • Guest
Re: [MOD] TiltViewer for 4images
« Reply #61 on: July 27, 2009, 06:27:05 AM »
Hi!
... Kann ich eigentlich 2 Tabellen kombinieren? Der Hintergrund ist nämlich der, dass.wenn das Skript in die Settings-Table bei "cat_rand_pic" schaut, und alle dort aufgelisteten Kategorie-IDs NICHT nimmt. Ginge das zu realisieren?.....
mit einer sql query den inhalt von "cat_rand_pic" auslesen:

$sql 
"SELECT  setting_value as cat_rand_pic 
	
FROM "
.SETTINGS_TABLE.
	
WHERE setting_name = 'cat_rand_pic'"
;
    
$result $site_db->query($sql); 
    
$row mysql_fetch_object($result);
    
$cat_in $row->cat_rand_pic;


 und die abfrage von:

WHERE i
.image_active AND c.cat_id i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")

auf

WHERE i
.image_active AND c.cat_id i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").") AND i.cat_id NOT IN (".$cat_in.")


mfg Andi

Offline Sebas Bonito

  • Sr. Member
  • ****
  • Posts: 271
  • Sebas Bonito
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #62 on: July 27, 2009, 07:19:02 AM »
Moiähn! Danke Andi, das war's. Perfekt.
Also keine direkte Verküpfung, sondern das Auslesen eines Feldes, das
in eine Variable packen, und DIESE dann in die eigentliche Tabelle einbinden.
Schönen Wochenstart noch!
Sebas

Offline Blackman5001

  • Pre-Newbie
  • Posts: 8
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #63 on: August 13, 2009, 10:07:24 AM »
@ Blackman5001
... Lösungsvorschlag mit Code folgt ...


Gibt es schon etwas neues?

Offline GaYan

  • Sr. Member
  • ****
  • Posts: 301
  • ♫ | G2 | ♫
    • View Profile
    • Ziramagic
Re: [MOD] TiltViewer for 4images
« Reply #64 on: August 13, 2009, 05:42:56 PM »
Working fine !  :lol::D ! Thanks !  :wink:
I'm Back :)

Offline Qwerty123

  • Pre-Newbie
  • Posts: 1
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #65 on: September 18, 2009, 01:35:13 PM »
Quote from: Mr_LovaLove link=topic=20789. msg117550#msg117550 date=1211214973
@mawenzi

Yes i did, and the arabic is :

<Meta Http-Equiv="Content-Type" Content="text/html; Charset=iso-8859-6">

but its not working

do i have to add the charset somewhere else ?

and thanks for ur support
Also interested in the problem encoding

Offline zakaria666

  • Full Member
  • ***
  • Posts: 211
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #66 on: August 27, 2010, 07:27:32 PM »
@Mewanzi

Very great mod man, i love it. Very cool. But im very bad at the customization. Basicailly all i want to do is display all images from home.html. If there are alot of pictures maybe like this, 10 images to be viewed on screen and then user can click arrow to go and view another 10 more, but in a nice and clean column, row grid.

Im so lost of how to do this, plz can u help me sir

Offline mawenzi

  • Moderator
  • 4images Guru
  • *****
  • Posts: 4.500
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #67 on: August 27, 2010, 08:07:30 PM »
@zakaria666

... from home.html ... for instance the newest images ... ?
... then try this : http://www.4homepages.de/forum/index.php?topic=20789.msg113200#msg113200
Your first three "must do" before you ask a question ! ( © by V@no )
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

You are on search for top 4images MOD's ?
- then please search here ... Mawenzi's Top 100+ MOD List (unsorted sorted) ...

Offline zakaria666

  • Full Member
  • ***
  • Posts: 211
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #68 on: August 27, 2010, 08:42:35 PM »
@mewanzi

I think that just may have done the trick, thank u so much man, u and all the administrator and helpers here are the best.

Mewanzi, when i did the tweaking i realized that most of the uploaded content were videos and then realized that the tilt viewer does not display videos. Is there any chance that this can be tweaked to accept video content??

Thanks again bro

Offline mawenzi

  • Moderator
  • 4images Guru
  • *****
  • Posts: 4.500
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #69 on: August 28, 2010, 09:02:05 PM »
@zakaria666

... I think ... no ...
... for that the tiltviewer script must accept video content ... and that was not my part ...
Your first three "must do" before you ask a question ! ( © by V@no )
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

You are on search for top 4images MOD's ?
- then please search here ... Mawenzi's Top 100+ MOD List (unsorted sorted) ...

Offline x23piracy

  • Sr. Member
  • ****
  • Posts: 420
    • View Profile
    • FHG
[Gelöst] Re: [MOD] TiltViewer for 4images
« Reply #70 on: October 01, 2010, 02:39:00 AM »
Hi,

i like use tiltviewer to show the 50 newest images but i need to exlude at least
one categorie but likely more then a single categorie.

My problem is that iam really bad with sql selects, can someone point howto do it?

EDIT:

Ich konnte mir selbst helfen, folgender Code Schnipsel zeigt die letzten 50 Bilder mit
Ausnahme der Kategorienummern in der Klammer nach dem "NOT IN"

Code: [Select]
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (4, 7, 9, 19, 34, 35)
ORDER BY i.image_date DESC
LIMIT 0,50";


Hat schon jemand von euch das Experiment gewagt, den Tiltviewer als Ersatz für die Detailansicht
zu benutzen?


Greetz Jens

« Last Edit: October 03, 2010, 01:52:48 PM by x23piracy »

Don't trust in md5 it's unsafe change your 4i galerys password hash algorythm! second pw db field, create new hashes over some time, deny old hash. Help members that cry, send informationen mail to the rest. Camouflage new pw hash in cookie. Done!

--(◔̯◔)--

Offline repentagliaiv

  • Pre-Newbie
  • Posts: 3
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #71 on: October 03, 2011, 12:00:54 PM »
Hi Mawenzi,
it's far beyond my php skills...how can I select only smaller images e.g. whose size is less than 1MB?

Thanks in advance,
A.

Offline Sunny C.

  • Addicted member
  • ******
  • Posts: 1.805
  • I ♥ 4I
    • View Profile
Re: [MOD] TiltViewer for 4images
« Reply #72 on: November 22, 2011, 01:37:05 PM »
Here is my Version of Tiltviewer
[MOD] Tiltviewer v1.0