Page 25 of 29
Posted: 2009-01-13 22:01:02
by sandmanweb
Je n'ai réussis qu'à faire apparaitre les notes des visiteurs dans le bas de la description détaillée.
J'ai trouvé une façon détournée (avec iframe) d'ajouter l'affichage de cette modif. Mais je ne sais pas comment l'intégrer davantage.
Le code de PKmovie n'est pas très simple à comprendre (côté PHP).
En tk, je n'ai pas les connaissances requises.
J'ai fais ma modif seulement après avoir feuilleté un livre sur le PHP et MySQL
J'espère que d'autres trouveront un moyen
Et comment s'est passé l'installation de ma modif ? Tout fonctionne bien ?
Edit: J'avais mal lu ton message d'hier. Je croyais que tu n'arrivais pas à faire fonctionner la modif. Mais tu veux plutôt savoir comment changer les étoiles de la page principale... tk, tu as eu ta réponse quand même finalement :P
Il faudrait réussir à afficher la variable $notearrondie de cette façon:
faire un select comme suit:
Code: Select all
"SELECT AVG(notes) FROM note WHERE NUM='$NUM'";
et afficher les étoiles comme ça:
Code: Select all
<img src='templates/default/imdb/{$notearrondie}.jpg' border='0' width='78' height='21'>
Sauf que le code PHP ne semble pas fonctionner dans les pages de PKmovie. Je crois qu'il faut absolument faire des focntions ou quelques chose du genre...
J'aurais besoin d'aide là dessus...
Posted: 2009-01-14 12:01:01
by ToastSavy
Sandmanweb,
Thank you for the links
Merci beaucoup!
Posted: 2009-01-14 12:45:51
by sandmanweb
You're welcome
J'ai peut-être compris comment ça fonctionne...
Je vais essayer d'inclure mon script dans le fichier mdb3.php à la place et l'appeler dans les templates. De cette façon, ça devrait fonctionner je crois.
En même temps, ça rendrait ma modification plus intégrée et je pourrais peut-être améliorer son affichage...
Je regarderai ça dans les prochains jours.
Je vous tient au courant des développements
Posted: 2009-01-15 13:05:00
by z3us
Hi.
Im getting this error:
Warning: rename(antexport/pelis.sql,antexport/pelis.bak) [function.rename]: Permission denied in /home/a2546299/public_html/mdb3.php on line 940
SELECT PERIOD,count(*) FROM `a2546299_pelis`.`pelis` GROUP BY PERIOD ORDER BY PERIOD
Invalid Query: Unknown column 'PERIOD' in 'field list'
http://pelis.comoj.com/
Any help?
Thanks
Posted: 2009-01-15 13:56:38
by sandmanweb
do you have all permissions enabled in Mysql for this user ?
Posted: 2009-01-15 15:17:15
by z3us
I solved it chmodding antexport folder to 777.
But now I have another problem: Some of my covers are with the standard filename "catalogname_filmnumber.jpg", but most of my entries have different filenames for the cover like "films_alien.jpg, films_300.jpg, etc"... and these filenames are not exported with the correct name to sql. Instead, the filename in the sql file is "films_filmnumber.jpg", and that picture doesnt exist. Any solution for this? Or any fast way for renaming pictures to the standard filename?
Thanks, and sorry for my bad english
Posted: 2009-01-16 00:45:38
by sandmanweb
Ant Movie Catalog should rename them when exporting to SQL...
If you save the SQL export in the antexport folder, PKmovie should deal with all this very well.
Posted: 2009-01-16 08:10:32
by z3us
sandmanweb wrote:Ant Movie Catalog should rename them when exporting to SQL...
If you save the SQL export in the antexport folder, PKmovie should deal with all this very well.
ANT movie catalog doesnt export pictures like "pelis_alien.jpg, pelis_gladiator.jpg , etc" In the sql file directory only the numbered pictures are present. And, if I manully open the sql ile with notepad, the picture for alien and gladiator is changed to "pelis_aliennumber.jpg, pelis_gladiatornumber.jpg"
This happens if you have AMC configurated to name the cover with the formatted title
Another question:
I had in my catalog, some films with the category "fantastico" and others with the category "fantastica". I manually edit the xml and replaced all "fantastica" to "fantastico". Same with "basado (basada) en hechos reales" and "aventuras (aventura)". I exported to sql and uploaded the sql file to the antexport folder of my server. Now, the categories are repeated in the bottom of the panel, as you can see here:
http://z3us.zobyhost.com/index.php
What coulod be the problem?
Thanks
Posted: 2009-01-16 12:25:27
by ToastSavy
Sandmanweb,
Sorry, but my French is not that good
I will try and get round to installing the app next week and will let you know how I go.
Thanks,
Toasty
Posted: 2009-01-16 12:58:00
by sandmanweb
z3us
I would have change the category of those movies in AMC... I would have been easier.
But I'm sure you will find a way to fix it
For the name of the picture, I don't know why it's working here then. I can set any picture to a movie and it will be exported in this format: amcfilename_number.jpg
ex: films_1.jpg
But if you found an another way, I'm glad for you
Posted: 2009-01-16 18:57:00
by z3us
sandmanweb wrote:z3us
I would have change the category of those movies in AMC... I would have been easier.
But I'm sure you will find a way to fix it
No, it wouldnt have been easy, because "fantastico" isnt the only cattegory of these films, and locating and replacing all would take ages.
Anyway, the genres are correctly displayed in AMC, and Im not able to fix it.
Can anyone help me? Why are those edited genres repeated at the bottom of my lateral panel?
Thanks
http://z3us.zobyhost.com/
Posted: 2009-01-16 19:35:55
by kazgor
When you changed the categories manual, then import the SQL, what type of import did you do, just a update or did you delete the table and then import the new SQL file?
Whenever i update mysite, i tend to always just to a full export, and in AMC on the export SQL, i tell it to delete the table first.
Posted: 2009-01-17 12:23:25
by z3us
Solved. It was only a caps problem : "fantastico", "Fantástico"
Posted: 2009-01-17 14:42:59
by z3us
how can I replace a character (for example . Instead of ,)in all the actors field? I want to do it in the sql server, not in the amc database. And, if possible, that the replacing is done automatically everytime I update the table.
Thanks
Posted: 2009-02-23 01:34:58
by sandmanweb
Un fichier CSS que j'ai modifié pour permettre une plus belle apparence sous Internet Explorer.
Vous avez juste à remplacer le fichier
http://www.mediafire.com/download.php?hnm2ntzxywj
Lizotte mod 1.2
Posted: 2009-02-24 17:23:29
by sandmanweb
Je crois avoir réglé les problèmes de sécurité
J'ai ajouté une commande PHP pour filtrer les variables $_GET.
Ça semble bien fonctionner
Téléchargez la version 1.2 complète ici
Voici ce qu'il y a de nouveau dans cette version:
Version 1.2
- Problèmes de sécurité corrigés
- Apparence sous Internet explorer améliorée (cadre autour des images)
- Déplacé la note des visiteurs dans le haut de la page sous IMDB.
- Ajouté la note des visiteurs sur la page principale (detail_view.tpl)
Version 1.1
- Ajout de notes (étoiles) par les visiteurs
- Ajout de commentaires par les visiteurs
- Automatisé la création des tables SQL pour ma modification
- Amélioration de l'affichage des étoiles imdb (elles s'affichent toujours maintenant)
- Agrandissement de l'image lorsqu'on clique sur l'image d'une pochette
- Bouton pour afficher une page d'informations
- Changement du fichier langue de AMC
Donnez-moi votre avis
Posted: 2009-03-16 16:17:31
by Khaeotica
Hey guys,
I have installed this template for my own movie list that can be visited here:
http://cine.khaeotica.com
And i would like to add a short text right under the logo in the top, so between the logo and the All Movies button. Could anyone advise me where exactly should the code be inserted, in which file and what line? Thanx!
Julius.
Posted: 2009-03-16 17:02:32
by sandmanweb
I would just edit the logo image with photoshop
Posted: 2009-03-16 17:39:48
by Khaeotica
I know, that's the easy way
but I would prefer to be just simple text in html inserted there, independently of the logo.
Posted: 2009-03-16 18:00:36
by sandmanweb
Edit detail_view.tpl
Add your text after:
Code: Select all
<h3><a href='$HTTPPATH'><span>$TITLE</span></a></h3>
The text must be between <div> and </div> if i'm right.
Bye