Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Jetstream

Pages: [1] 2
1
Mods & Plugins (Releases & Support) / Re: [MOD-beta] Google-Maps Integration V.01
« on: March 24, 2008, 05:16:23 PM »
Ahhhhh Leute, Problem gelöst..... Ich musste den code auf details.html wirklich ganz ganz ganz fest  ;)  zuoberst installieren.... Soifz...
Danke trotzdem an Andi und Kurt für die spontane Unterstützung.

Grüsse an alle aus der Schweiz, und wenn ihr mal gucken möchtet, hier ist meine Galerie... http://www.fotigalerie.ch
Chris

2
Mods & Plugins (Releases & Support) / Re: [MOD-beta] Google-Maps Integration V.01
« on: March 24, 2008, 04:11:45 PM »
Hi Andi

Ich habs im Attachment zu diesem Post als .txt

Hier noch der link zu meiner Galerie und dem "weissen Fleck"  :)
http://www.fotigalerie.ch/details.php?image_id=1150

Vielen Dank für deine Mühe
Chris

3
Mods & Plugins (Releases & Support) / Re: [MOD-beta] Google-Maps Integration
« on: March 24, 2008, 12:20:24 PM »
Quote from: ivan on February 11, 2007, 02:39:05 PM
hi holger,
vielen dank für die super integration in 4images.
ich habe mir das ganze mal installiert, bekomme aber bei der details seite nur
einen weissen inhalt dort wo die map sein sollte, es kommt auch keine fehlermeldung.

der key ist installiert, nach der anmeldung habe ich mit dem angezeigten html code
eine map aufrufen können.

wo könnte hier der fehler sein?

gruss ivan

Hallo Ivan, Hallo alle Modder

Ich habe das gleiche Problem wie Du zu Beginn hattest, nämlich ein weisses Bild anstelle der Map. Mit welchem Mod hat es sich bei Dir geschnitten? Ich habe bloss den ajax starrating mod drauf, und ein paar eigene Änderungen, sind aber nicht der Rede Wert. Allerdings habe ich auf 1.7.6 upgedatet, weiss nicht ob das was ausmacht.

Weiss jemand eine Antwort? Merci dafür im Voraus.

Grüsse aus der Schweiz
Chris

4
Requests for paid modifications / Jobbörse / Re: Pay 4 a part of the mod to force user AND guest to vote for download, cookiebas
« on: August 24, 2007, 01:56:12 PM »
Noch andere Angebote / Are there other offers?

5
Requests for paid modifications / Jobbörse / Re: Suche Template (gegen Bezahlung)!
« on: August 23, 2007, 12:22:12 PM »
Suchst Du immer nochjemand das dir ein cooles Tempalte mit deinen Grafikwünsdchen und vierle Extras "Zückerli" hat :?: Dan mlede Dich, das bring ich Dir voll! mail@chris-gubelmann.ch

PS: Ich kann auch eine Stufe Tiefer, auf php gehen, wenn nötig.

Sag mal einen Preis :!:

6
Requests for paid modifications / Jobbörse / Pay 4 a part of the mod to force user AND guest to vote for download, cookiebas
« on: August 22, 2007, 12:43:33 AM »
Hi all

 :!: I am runnig 1.7.4 and am looking for a mod, who forces the users to vote for the picture he wants to download. I have allowed in the most of my categories that guest can download pictures, but I am unlucky about the voting beheavor of my visitors (7000 downloads but just 300 votes).  Now my question is:   :?:

 :idea: Can anybody develop a mod who allows only pic downloads, if the vstitor previously has rated the pic? That's exactly the thing I am looking for!

There are beginnings in addition who just forced the USER but not the GUESTS, too, to vote: http://www.4homepages.de/forum/index.php?topic=8317.0, But there are already solutions who write the rating to a cookie: http://www.4homepages.de/forum/index.php?topic=5853.
What's missing, is that bit of code who reads out the cookie info, and decides over allowing Download/Ecard.

I think it not so a difficult thing, Remeber:  if you vote 2 times for the same picuture, the system idientifies this (cookie there and IP based) and gives en error out I think we just have the cookie's set for this image an what id storerd. I want all site vitsitors, users AND guests have to vote immedtaitely before they can download, NATARLLLY JUST until the cookie xpires oder will be deletet manually.

I would pay 30 USD, if the mod works on my 4images gallery (www.fotigalerie.ch).

Looking forward for offers
Chris

**********************
*** German Translation ***
**********************

Hallo zusammen,

 :!: Ich habe die Version 1.7.4 installiert und suche ein Mod, das den Besucher zwingt, das Bild zu bewerten, das er downloaden will. Ich habe in den meisten Kategorien die Downloads für alle freigegeben, bin aber unzufrieden mit dem Bewertungsverhalten meiner Besucher (15000 Downloads stehen bloss 317 Bewertungen gegenüber. Meine Frage ist nun:  :?:

 :?: Könnte jemand ein Mod entwicklen, welches den Bilderdownload nur dann zulässt, wenn der Besucher das Bild zuerst bewertet? Das wäre genau das, wonach ich suche!

Es gibt auch Ansätze dazu, die aber nur USER, nicht aber GUESTS zwingen können, zu voten, zB. http://www.4homepages.de/forum/index.php?topic=8317.0, aber auch schon Lösungen, die Ratings in ein Cookie schreiben: http://www.4homepages.de/forum/index.php?topic=5853. Was fehlt, ist eigentlich der Code, der den Cookie ausliest und den Download/Ecard zulässt oder nicht

Würde SFr 30.- bezahlen, wenn der Mod auf meiner 4images läuft (www.fotigalerie.ch).

Freue mich auf Angebote
Chris

7
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 20, 2007, 07:14:42 PM »
soiifz...   :cry: I dont wanted to waste your time I ment. I dont understand why you helped me so far and now stop it that immediately? Have I used the wrong words perhaps? You must know english isn't my mother tongue!

By the way: the two links to mysqlpage aren't helpful for my question how to convert the 4images date format (int(11)) into a format understood by sql!!!

Sorry for that and thanks again for your grait work and time
Chris

8
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 20, 2007, 06:10:36 PM »
Yes I know I am using your time... I mentioned it above. So thank you for your work and time again. But: I don't know how to handel the DATE_FORMAT in the SQL Query! is it perhaps
Code: [Select]
WHERE sh.session_lastaction = DATE_FORMAT(date,'%d,%m,%y')?

Put how to put the actual date into 'date' in php????

You see once more I am a nerth in php!

thx
Chris

9
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 20, 2007, 05:18:30 PM »
Okay, I think I understand now the syntax of the DATE_FORMAT SQL order.

But I have to ask the question the other way: Can you please make this php code with the SQL clause "WHERE sh.session_lastaction =" to run, I dont know how to get the variables 'today' and 'month', so my idea of the php code with sql query is:

Code: [Select]
//-----------------------------------------------------
//--- total user sessions today------------------------
//-----------------------------------------------------
$sql = "SELECT COUNT(*) as sessions
        FROM (".SESSIONS_HIST_TABLE." sh, " . SESSIONS_TABLE . " s)
        LEFT JOIN "  . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = sh.session_user_id)
        WHERE sh.session_lastaction = today and " . get_user_table_field("u.", "user_level") . " >= '" . GUEST . "' AND " . get_user_table_field("u.", "user_level") . " <= '" . USER . "'
        GROUP BY s.session_ip";

$counter_result_day = $site_db->query_firstrow($sql);

and

Code: [Select]
//-----------------------------------------------------
//--- total user sessions this month ------------------
//-----------------------------------------------------
$sql = "SELECT COUNT(*) as sessions
        FROM (".SESSIONS_HIST_TABLE." sh, " . SESSIONS_TABLE . " s)
        LEFT JOIN "  . USERS_TABLE . " u ON (" . get_user_table_field("u.", "user_id") . " = sh.session_user_id)
        WHERE sh.session_lastaction = month and " . get_user_table_field("u.", "user_level") . " >= '" . GUEST . "' AND " . get_user_table_field("u.", "user_level") . " <= '" . USER . "'
        GROUP BY s.session_ip";

$counter_result_month = $site_db->query_firstrow($sql);

thkyou
chris

10
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 20, 2007, 03:11:14 PM »
thunderstrike, you are the expert of sql AND php, so i have a further question: I have a little problem understanding/converting the 4images date format INT(11). So, my hopefully last question to you is how to supplement the WHERE clause to show the result in an gap of any given date (y, m, d; h, m, s)

greets from rainy switzerland
chris

11
Mods & Plugins (Requests & Discussions) / visitor counter based on visitor's ip)?
« on: August 20, 2007, 02:44:39 PM »
 :D Thk you very much, I nearly had the solution, made just a syntax fault. Now, if you change sh.session_ip instad of s.session_ip, it gives you out exactly the result I ever wanted: 1404 ip-uniqe visitors since loggin into session_hist_table, which corresponds exactly with the statistics results.

Thunderstrike, thank you for your faboulous work and the invested time!

 :!: We have here a mod for a working IP-based visitor counter for 4images   :!:

If I have the time to, I will post the whole mod instructions in one here.

12
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 19, 2007, 08:56:12 PM »
 :lol: Yo man yo that was is, it works!!!!! Juhuuuu! thk you so much!!!!!!!!!!!!!!  :P Grrrrrrrrrrrrrrrreat

this ist the first working session-id based visitor counter for 4images!!!!!


thanks to you thunderstrike  :!:

  :?: 'Nother question: Can we build into the SQL sentence a "group by sh.session_ip" to get the visitor counter based upon visitors' ip adress?  :?:

13
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 19, 2007, 05:12:54 PM »
Cool,  :lol: I think we (or have I to say: "You" :roll:) are on the right way.

But:

with this code combination I have the result 0 (ZERO), I think that may come from the
Code: [Select]
(isset($counter_result['sessions'])) ? $counter_result['sessions'] : 0,] , it seems to me that
Code: [Select]
$counter_result['sessions'] seems to be set so that this order will give zero to "counter_result".

Now, I have no idea how this variable has to be set and how to implement it, thats exactly my actual question to you.

 :idea: Fot clearness, I will paste in above my whole code at the end of top.php who should read out the count of total unique site visits:

Code: [Select]
//-----------------------------------------------------
//--- total user sessions  ----------------------------
//-----------------------------------------------------
$sql = "SELECT COUNT(*) as sessions
        FROM (".SESSIONS_HIST_TABLE." sh, ".USERS_TABLE." u)
        WHERE sh.session_user_id = " . get_user_table_field("u.", "user_id") . "
        AND " . get_user_table_field("u.", "user_level") . " = '" . GUEST . "' AND " . get_user_table_field("u.", "user_level") . " = '" . USER . "'";

$counter_result = $site_db->query_firstrow($sql);

//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=http://www.chris-gubelmann.ch/index.html>Homepage</a> --> <a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">Fotogalerie</a>".$config['category_separator'];
if ($cat_id && isset($cat_cache[$cat_id])) {
  $clickstream .= get_category_path($cat_id, 1).$config['category_separator'];
}
$clickstream .= $lang['top_images']."</span>";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "summe_hits" => $sum_hits,
  "counter_result" => (isset($counter_result['sessions'])) ? $counter_result['sessions'] : 0,
  "summe_downloads" => $sum_dls,
  "summe_votes" => $sum_votes,
  "summe_cats" => $sum_cat,
  "msg" => $msg,
  "clickstream" => $clickstream,
  "lang_top_image_hits" => $lang['top_image_hits'],
  "lang_top_image_downloads" => $lang['top_image_downloads'],
  "lang_top_image_rating" => $lang['top_image_rating'],
  "lang_top_image_votes" => $lang['top_image_votes']
));
$site_template->print_template($site_template->parse_template($main_template));

$content = ob_get_contents();
ob_end_clean();

if ($cache_page_top) {
  // Reset session mode
  $site_sess->mode = $old_session_mode;

  save_cache_file($cache_id, $content);
}

} // end if get_cache_file()

echo $content;

include(ROOT_PATH.'includes/page_footer.php');
?>
I think we are really on the right way and not far of the goal, but I need your help again. I cannot repeat it enough that I am so thankful of your work, I aprecciate my biggest honour to people like you who invest your time for that good thing. May be I can invite you vor a visit on my 4images based gallery  www.fotigalerie.ch. Hope to hear from you again.
Thanks,
Chris

14
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 17, 2007, 01:05:13 PM »
Hi Thunderstrike, thx for your great help

now I gave in the following code at the bottom of top.php:

Code: [Select]
//-----------------------------------------------------
//--- total user sessions  ----------------------------
//-----------------------------------------------------
$sql = "SELECT COUNT(*) as sessions
        FROM (".SESSIONS_HIST_TABLE." sh, ".USERS_TABLE." u)
        WHERE sh.session_user_id = " . get_user_table_field("u.", "user_id") . "
        AND " . get_user_table_field("u.", "user_level") . " = '" . GUEST . "' AND " . get_user_table_field("u.", "user_level") . " = '" . USER . "'";

$counter_result = $site_db->query_firstrow($sql);

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "summe_hits" => $sum_hits,
  "counter_result" => $counter_result,
...

If I print out {counter_result} it gives me only back "Array". Anything I don't see?

15
Mods & Plugins (Requests & Discussions) / Re: Count of unique site visits (sessions)?
« on: August 14, 2007, 04:04:22 PM »
thank you thunderstrike for your VERY FAST answer, thx really a lot

I just implemented the new code that you proposed above, and it works fine

But my main question is: how to READ OUT the 4images_sessions_hist table for showing me how many visitors (GUESTS & USERS) have visited my site in a time period defined by me?

Greets from sunny switzerland
Chris

Pages: [1] 2