Recent Posts

Pages: [1] 2 3 ... 10

Elxis 4.x/5.x DEV / Re: Issue with Audio tag in Jodit Editor

« Last post by armpouniotis on May 26, 2020, 22:52:20 »

An Elxis audio plugin will be very helpful !

I really need something like !

I want to embed audio files in my websites, but not in video format, as I am doing now !

Hurry up !

Christos

Administration / Re: Autoupdate 5.0 to 5.1 [Solved]

« Last post by datahell on May 26, 2020, 22:04:36 »

Never modify Elxis standard files. If you dont want to loose your changes on an update add your changes in custom css/js files. Template "Five" is a sample template. You can create a copy of it and rename it to anything you want. For instance, for a site of mine I have renamed it to "Six".

Elxis 4.x/5.x DEV / Re: Issue with Audio tag in Jodit Editor

« Last post by datahell on May 26, 2020, 21:59:41 »

You are right, there is problem. For now, clear the wrapping elements Jodit adds before save. Would you like to create an Elxis plugin for audio? If that helps, I can develop a plugin similar to the built-in HTML5 video plugin.

Database / Re: Παράλληλη εγγραφή σε δεύτερη database

« Last post by datahell on May 26, 2020, 21:42:10 »

$sql = "INSERT INTO ".$db2->quoteId('my_table')." VALUES (".$db2->quote($row->uname).", ".$db2->quote($pword).")";

ή (hardcoded για Mysql):

$sql = "INSERT INTO `my_table` VALUES ('".$row->uname."', '".$pword."')";

Tip: Οι μέθοδοι quoteId και quote προσθέτουν τα "αυτάκια" αυτόματα σε ονομασίες πινάκων και τιμές ανάλογα με τον τύπο της βάσης δεδομένων.

Database / Re: Παράλληλη εγγραφή σε δεύτερη database

« Last post by jimmyz on May 26, 2020, 16:55:04 »

Αυτό λειτουργεί.
$sql = "INSERT INTO my_table (uname, pword) VALUES ('TEST1', 'TEST2')";

Πώς όμως πρέπει να γίνει το
$sql = "INSERT INTO ".$db2->quoteId(my_table)." VALUES (NULL, ".$db2->quoteId($row->uname).", ".$db2->quoteId($pword).")";

Database / Re: Παράλληλη εγγραφή σε δεύτερη database

« Last post by michalis1984 on May 26, 2020, 15:34:19 »

Τα values δεν πρέπει να είναι σε quotes? 'value'

$sql = "INSERT INTO db2table (uname, pword) VALUES ('TEST1', 'TEST2')";

έτσι δουλεύει;

Here are some syntax rules to follow:

The SQL query must be quoted in PHP
String values inside the SQL query must be quoted
Numeric values must not be quoted
The word NULL must not be quoted
Source: https://www.w3schools.com/php/php_mysql_insert.asp

Elxis 4.x/5.x DEV / Issue with Audio tag in Jodit Editor

« Last post by seadhna on May 26, 2020, 14:42:46 »

Hi datahell,
how do you recommend making audio available in Elxis 5?
If I use the audio tag, each time I save the article, this code gets added outside the audio tag:

<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<audio controls="">
<source src="https://www.example.org/example.mp3" type="audio/mpeg">
Your browser does not support the audio tag.
</audio>
</jodit-media>

Each time I save it gets added again; soon looking like this, and preventing CSS from working:

<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;">
<jodit-media data-jodit-temp="1" contenteditable="false" draggable="true" data-jodit_fake_wrapper="1" style="display: block; width: 300px; height: 54px;"><audio controls="">
<source src="https://www.pgaction.org/media/audio/members/valerie-woods-04.mp3" type="audio/mpeg">
Your browser does not support the audio tag.
</audio></jodit-media>
</jodit-media>
</jodit-media>
</jodit-media>
</jodit-media>
</jodit-media>

Database / Re: Παράλληλη εγγραφή σε δεύτερη database

« Last post by jimmyz on May 26, 2020, 11:17:25 »

Ευχαριστώ για την άμεση απάντηση.

components/com_user/controllers/account.php, πάνω και κάτω από την 237:

Code: [Select]

	$params = array(
   'dbtype' => 'mysql',
   'host' => 'localhost',
   'port' => 0,
   'dbname' => 'etest',
   'username' => 'db2user',
   'password' => 'db2pass'
);
$db2 = new elxisDatabase($params);

	
		if ($ok === true) {
		
$sql = "INSERT INTO ".$db2->quoteId('my_table')." VALUES (NULL, ".$db2->quoteId($row->uname).", ".$db2->quoteId($pword).")";
$stmt = $db2->prepare($sql);
$stmt->execute();

Για username TEST1, γράφει σωστά τον νέο χρήστη στην db του elxis, καμία εγγραφή στην etest, δίνει HTTP ERROR 500 και στο log καταφράφει:

Code: [Select]

Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TEST1' in 'field list'' in /var/www/mysite.gr/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /var/www/mysite.gr/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /var/www/mysite.gr/components/com_user/controllers/account.php(255): elxisPDOStatement->execute()
#2 /var/www/mysite.gr/components/com_user/user.php(61): accountUserController->register()
#3 /var/www/mysite.gr/includes/libraries/elxis/document.class.php(1183): userRouter->route()
#4 /var/www/mysite.gr/includes/libraries/elxis/document.class.php(953): elxisDocument->renderComponent()
#5 /var/www/mysite.gr/includes/loader.php(245): elxisDocument->make()
#6 /var/www/mysite.gr/index.php(18): require('/var/www/mysit...')
#7 {main}
  thrown

Ακόμη και αν αλλάξω σε
$sql = "INSERT INTO db2table (uname, pword) VALUES (TEST1, TEST2)";
παίρνω το ίδιο σφάλμα, νομίζει οτι το username που θέλει ο χρήστης, είναι στήλη στο table!

Δοκίμασα, να αφαιρέσω τα ", αλλά δεν είχα τύχη.

Τί προτείνετε;

Administration / Re: Autoupdate 5.0 to 5.1

« Last post by kyomar on May 26, 2020, 10:23:53 »

Finally the update finished successfully. It wasn't a write permission issue, there was already a folder elxis in the repository/tmp/ folder. I checked and it turned out that this folder had "old" files in it from version 2299 (checked file version.php). I have no idea from where and why, during the automatic update process, this folder wasn't overridden while unzipping the new elxis.zip file. I deleted the folder and run the automatic update and voila it worked flawlessly.
So from the first post following problems are solved:
1. after the update I received a 404 error message.
2. in the admin panel it still shows: "You use an outdated Elxis version! Update as soon as possible to Elxis 5.1 Cronus r2344" although the update was done.
5. The search field in the page header (template five) can not be turned off (template top settings). I have reported this a while back but forgot how to correct.
Update! found solution here: https://forum.elxis.org/index.php?topic=9052.msg57540#msg57540

Following points need to be addressed (in my opinion):
3. in the five template the following code was missing in index.php for tabs to work:

Code: [Select]

$jsFile = eFactory::getElxis()->secureBase().'/includes/js/jquery/tabs.js';
$eDoc->addJQuery();
$eDoc->addScriptLink($jsFile);

4. All my css files (template, system, etc.) were replaced. How can I secure/preserve modified files?

Like I already said it would be really helpful if we could check those files we don't want to be updated. In may case I had to manually upload 17 previously modified files. This could be done in the check file-system and should be quite easy (for a pro which I am not).

Thanks again datahell for your help, as always outstanding support.

Database / Re: Παράλληλη εγγραφή σε δεύτερη database

« Last post by datahell on May 25, 2020, 21:28:15 »

Είναι πολύ εύκολο να συνδεθείς σε μία δεύτερη βάση και να κάνεις αυτό που θες. Ωστόσο επειδή πρόκειται για custom-ιά θα πρέπει να τροποποιήσεις τις default επεκτάσεις του Elxis που σημαίνει ότι σε μία αναβάθμιση μπορεί να τις χάσεις αν υπερκαλυφθούν τα αρχεία.

Σύνδεση στη δεύτερη βάση (αλλάξε host αν χρειάζεται καθώς και username/password)
$params = array(
   'dbtype' => 'mysql',
   'host' => 'localhost',
   'port' => 0,
   'dbname' => 'my_other_database',
   'username' => 'db_username',
   'password' => 'db_pass'
);
$db2 = new elxisDatabase($params);

Μετά εκτελείς τα queries ως συνήθως:
$sql = "INSERT INTO ".$db2->quoteId('my_table')." VALUES (NULL, 'blah', 'blah', 'blah')";
$stmt = $db2->prepare($sql);
$stmt->execute();

components/com_user/controllers/account.php
Μετά τη γραμμή 237:
if ($ok === true) {
Συνδέσου στη βάση db2
Και εκτέλεσε το INSERT στη δεύτερη βάση. Όλα τα στοιχεία του χρήστη είναι διαθέσιμα στη μεταβλητή $row. Επειδή το password το έχει το Elxis κρυπτογραφημένο θα το πάρεις ως plain text από τη μεταβλητή $pword. Κάπως έτσι:

$sql = "INSERT INTO ".$db2->quoteId('my_table')." VALUES (NULL, ".$db2->quote($row->uname).", ".$db2->quote($pword).")";
$stmt = $db2->prepare($sql);
$stmt->execute();

Το id του χρήστη είναι αυτό: $row->uid

Pages: [1] 2 3 ... 10