4images Modifications / Modifikationen > Mods & Plugins (Releases & Support)

[MOD] Search between specifyed date

<< < (3/9) > >>

bgmurphy:
v@no -

i have an original .... /search.php ...  file ...
when i do a search and replace for coding in steps 1.2/1.3 - it does not find the references  :roll:

where does the coding live??  8O

thanx
bruce

V@no:
ah, yes, u are right :ops:
I just fixed it.

Bomba:
i think i've found some kind of bug in the mod...

i installed it on my site today, and now, that is counting as 27 of June, when i search for all my images on the server (***), it doesn't appear the pics that were submitted after the 0am of June 27.

why's that, why doesn't search images that were submitted on the present day?
they all have words with more than 3 letters...
i don't understand it

V@no:
yes, u are right, replace:
--- Code: ---AND m.word_id = w.word_id AND i.image_date > UNIX_TIMESTAMP('".$date_start."') AND i.image_date < UNIX_TIMESTAMP('".$date_end."')
--- End code ---
with:
--- Code: ---AND m.word_id = w.word_id AND i.image_date >= UNIX_TIMESTAMP('".$date_start."') AND i.image_date <= UNIX_TIMESTAMP('".$date_end."')
--- End code ---

Bomba:
hey v@no, are u sure that that's correct?
cause i replaced my code and everything works the same way as before...

here's my changed code:

--- Code: ---$sql = "SELECT m.image_id, i.image_date
              FROM ".WORDLIST_TABLE." w, ".WORDMATCH_TABLE." m
              LEFT JOIN ".IMAGES_TABLE." i ON (m.image_id = i.image_id)
              WHERE w.word_text LIKE '".addslashes(str_replace("*", "%", $split_words[$i]))."'
              AND m.word_id = w.word_id AND i.image_date >= UNIX_TIMESTAMP('".$date_start."') AND i.image_date < UNIX_TIMESTAMP('".$date_end."')
              $match_field_sql";
--- End code ---



edit:

i just noticed that no your step 1.2 it's

--- Code: ---AND m.word_id = w.word_id AND i.image_date > UNIX_TIMESTAMP('".$date_start."') AND i.image_date < UNIX_TIMESTAMP('".$date_end."')
--- End code ---


and now the changed code says that i have to replace this

--- Code: ---AND m.word_id = w.word_id AND i.image_date > UNIX_TIMESTAMP('".$date_start."') AND i.image_date <= UNIX_TIMESTAMP('".$date_end."')
--- End code ---


but as you can see, these codes are not the same just look at this part:
--- Code: ---AND i.image_date <= UNIX_TIMESTAMP
--- End code ---


maybe you posted it wrong
maybe :)

Navigation

[0] Message Index

[#] Next page

[*] Previous page