Forums

Please bear with me (article content publishing)

mironsavan 10 Jul, 2009
Hi,
I know this was answered because I've been reading the forums for some days now and I must say that I don't get it:) I don't know PHP/MySQL very well because I haven't worked with it for almost a year. I'm going to tell you my problem using questions and I hope to understand too.
What I have working
[list]1. Three image upload fields that upload the files to the ftp and store the name of the pictures in mysql
2. Two mp3 upload fields that upload the files to the ftp and store the name of the mp3 file in mysql.
3. I have limits to all file sizes
4. Four information fields (name, email, telephone, general information)
5. A choose category field.
6. image verification[/list]

What I need:
[list]1. The information in the custom database table to be moved into article items in joomla content????
2. The name field to become article title ID and post itself correctly????
3. the category field to become category ID and post itself correctly?????
4. the description, three images, 2 mp3s, must be posted in article body (i don't care if its intro text or full article)?????
5. the images must look like this {rokbox title=|name-field-stored-in-the-database|}rootpath/image-stored-in-database.jpg{/rokbox}????????
6. the mp3s must look like this {audio}rootpath/filename-stored-in-the-data-base.mp3{/audio}??????????
7. Have the ability to arrange this in some kind of template where I can put anchors and such.?????????[/list]

Optional (if it can't be done it is no biggie, the above counts)
[list]1. I have a article with a html table that I use for listing content.
2. Cand I resize one picture to 50px and put it in a designated location?
3. Create a link to the joomla article that i mentioned above on the name and picture.[/list]
Max_admin 12 Jul, 2009
Hi, do you have a layout of how the final article output should look like ?

Regards
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
mironsavan 13 Jul, 2009

<h3>Date Personale</h3> - static HTML
<p><strong>Adresa E-mail:</strong> <a href="mailto:provincialii@provincialii.ro">provincialii@provincialii.ro</a></p> ((The e-mail address us stored in the database))
<p><strong>Telefon:</strong> 0722.258.826</p> - static HTML
<h3>Galerie Foto</h3> - static HTML
<p> - static HTML
{rokbox album=|content|}components/com_chronocontact/uploads/pic1-it-is-stored-in-the-database.jpg{/rokbox}
{rokbox album=|content|}components/com_chronocontact/uploads/pic2.jpg{/rokbox}
{rokbox album=|content|}components/com_chronocontact/uploads/pic3.jpg{/rokbox}
</p>
<h3>MP3 Demo</h3> - static HTML
<p>{audio}components/com_chronocontact/uploads/first-mp3-stored-in-the-database.mp3{/audio}</p>
<p>{audio}components/com_chronocontact/uploads/second-mp3-stored-in-the-database.mp3{/audio}</p>
<h3>Video (Youtube.com)</h3> - static HTML
<div align="center">embed video code imputed by the user from youtube.com or other site like this.</div>

Thank you for taking a look at my problem.

You have a pic with how the table looks attached here. Hope it helps. Haven't added the youtube field yet because this is a maybe for now. But if I do, It will be the allvideosplugin i guess... or standard html code.

PS: Here is the e-mail template code.


<div class="form_item">
<div class="form_element cf_text"><span class="cf_text">Pentru a adauga un artist / formatie / furnizor servicii pe MuzicaPentruNunta.ro va rugam completati formularul de mai jos.</span></div>
</div>
<div class="form_item">
<div class="form_element cf_text"><span class="cf_text">ATENTIE: Inscrierile se valideaza manual!</span></div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h3 class="cf_text">Date Personale</h3>
</div>
</div>
<div class="form_item">
<div class="form_element cf_textbox"><label class="cf_label" style="width: 150px;">* Nume Artist</label> <span>{nume_artist}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">* Nume Artist :: Introduceti Numele artistului / furnizorului de servicii / formatiei</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_textbox"><label class="cf_label" style="width: 150px;">* Adresa E-mail</label> <span>{adresa_email}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">* Adresa E-mail :: Trebuie sa introduceti o adresa e-mail valida pentru a putea efectua modificari in viitor!</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_textbox"><label class="cf_label" style="width: 150px;">* Telefon</label> <span>{numar_telefon}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">* Telefon :: Introduceti numarul dumneavoastra de telefon pentru a putea fi contactat</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h3 class="cf_text">Informatii</h3>
</div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown"><label class="cf_label" style="width: 150px;">* Alege Categoria</label> <span>{alege_categoria}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">* Alege Categoria :: Alegeti categoria in care va incardati!</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_textarea"><label class="cf_label" style="width: 150px;">Informatii suplimentare</label> <span>{informatii_suplimentare}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">Informatii suplimentare :: Camp OPTIONAL: Folosind acest camp, puteti oferi informatii suplimentare depsre dvs.</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h3 class="cf_text">Adauga Imagini</h3>
</div>
</div>
<div class="form_item">
<div class="form_element cf_fileupload"><label class="cf_label" style="width: 150px;">* 1. Adauga Imagine</label> <span>{adauga_poza1}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">* 1. Adauga Imagine :: Adaugati O imagine JPG, GIF, JPEG, PNG care sa aiba o dimensiune fizica maxima de 2MB</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_fileupload"><label class="cf_label" style="width: 150px;">2. Adauga Imagine</label> <span>{adauga_poza2}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">2. Adauga Imagine :: Adaugati O imagine JPG, GIF, JPEG, PNG care sa aiba o dimensiune fizica maxima de 2MB.</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_fileupload"><label class="cf_label" style="width: 150px;">3. Adauga Imagine</label> <span>{adauga_poza3}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">3. Adauga Imagine :: Adaugati O imagine JPG, GIF, JPEG, PNG care sa aiba o dimensiune fizica maxima de 2MB.</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_text"><span class="cf_text">ATENTIE: Marime maxima per imagine: 2MB</span></div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h3 class="cf_text">Adauga Melodii MP3</h3>
</div>
</div>
<div class="form_item">
<div class="form_element cf_fileupload"><label class="cf_label" style="width: 150px;">1. Adauga MP3</label> <span>{adauga_mp31}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">1. Adauga MP3 :: Adauga melodie MP3. Marime maxima: 10 MB</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_fileupload"><label class="cf_label" style="width: 150px;">2. Adauga MP3</label> <span>{adauga_mp32}</span> <a class="tooltiplink" onclick="return false;"><img class="tooltipimg" src="components/com_chronocontact/css/images/tooltip.png" border="0" width="16" height="16" /></a>
<div class="tooltipdiv">2. Adauga MP3 :: Adauga melodie MP3. Marime maxima: 10 MB</div>
</div>
</div>
<div class="form_item">
<div class="form_element cf_text"><span class="cf_text">Dimensiune maxima per fisier MP3: 10 MB</span></div>
</div>
<div class="form_item">
<div class="form_element cf_heading">
<h3 class="cf_text">Cod de Securitate</h3>
</div>
</div>
Max_admin 14 Jul, 2009
Hi,

good, the easiest way here is to create a template from the first code, this means remove any data which will be from the form and replace it with something like {field_name} then add the template as a PHP string in the onsubmit code box and replace the placeholders with the real fields data, this is not so hard! this can be made as a Chronoforms plugin to work in a friendly way!

its late here, if you can't do this then please send me an email through the contact us page and I may create this plugin for you and other users as well!😉

Regards
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
mironsavan 17 Jul, 2009
Thank you, I will Test this saturday and post my results here.
This topic is locked and no more replies can be posted.