WCDDL - Development How-To (Modules, Hooks, etc)

[DEViANCE]

Looking forward to the final release of this. Have been out of the scene for a long time and plan to rebuild EViLDDL using WCDDL v3 instead of DDLCMS like last time. Just hoping a lot of the mods are updated as I'm very much out of practice with PHP, not touched anything for around two years now :-/

[jomasaco]

Let see if i understand whow this works

<?php
// Backlink check
// Coded by JmZ
// LOLLERSKATES
//added looking in download page by moi

if(!defined("WCDDL_GUTS"))
        exit;

// Set the following to true to enable this mod
// Be sure to change yoursite.com below
$modEnabled = false;

function backlinkCheck($submit) {
    // Change the domain below to yours
    $myURL = 'yoursite.com';
    // FGC can be slow, replace with curl if you want
    // Also, this is only a simple check so not always reliable
    $get = file_get_contents($submit->surl);
    if(!preg_match('#href="http://(www\.)?' . $myURL . '/?"#i', $get))
    $get = file_get_contents($submit->url[0]);
    if(!preg_match('#href="http://(www\.)?' . $myURL . '/?"#i', $get))
        $submit->error = 'No backlink detected.';
}
if($modEnabled)
    Core::load()->hook('SubmitValidation', 'backlinkCheck');

[PremiumRDA]

sorry wrong topic

[rade0000]

where i can find wcddl v3 skin?

[ixtra]

I want to create a custom field in the downloads table , I updated the table and have also written the function but I cant understand what exactly to hook so that it takes the sql query of the new field .
How to change the query and params in DownloadsSavePre before it is executed ?

[JmZ]

I didn't code that specific hook as well as I could have, so it may seem a bit hacky but here's how:

- Hook into DownloadsSavePre
- Your function will be given the query string and the parameters
- ($sql, Array $params)

Basically you'd have to replace some common substring with the original and your new fields.

Like so:

$sql = str_replace(') VALUES', ',d, e, f) VALUES', $sql); 

So say our query is:
INSERT INTO wcddl_downloads (a,b,c) VALUES (:a, :b, :c)

The result of replacing ') VALUES' would be:
INSERT INTO wcddl_downloads (a,b,c,d,e,f) VALUES (:a, :b, :c)

Then do the same for the values:

$sql = str_replace('VALUES (', 'VALUES (:d, :e, :f, ', $sql); 

Leaving you with:
INSERT INTO wcddl_downloads (a, b, c, d, e, f) VALUES (:a, :b, :c, , :e, :f)

Remember all fields must be prefixed with 'd.', e.g. 'd.title' rather than 'title'.

When I get around to it, i'll update it slightly to have better hook handling for this.

[ixtra]

Thank You

[JmZ]

3.1 has been uploaded now onto github.

The only changes are dev related.

Queries generated, simplified

Certain queries are now generated and have their own hooks. The following methods were introduced:

Database::insert($table, $map[, $returnID]);
Database::update($table, $map[, $criteria]);
Database::delete($table[, $map]);
// Examples of usage:
Database::insert(WCDDL_DB_PREFIX . 'whitelist', array(
     'url' => $someSite,
));
// The above will insert a row into the whitelist table 

Hooks changed and added

The following hooks now exist:

DownloadQueueInsert // Called when a download is added to the queue, array of params is passed, see Database::insert() usage
DownloadDeQueueDelete // Called when a queue entry is removed, params/criteria passed
DownloadDeleteDelete // Called when a download is deleted, params passed, see Database::delete() usage
DownloadSaveUpdate // Called when a download is updated in the db, see Database::update() usage
DownloadSaveInsert // Same as above but insertions, not updates
SiteSaveUpdate // Called when a site is updated in the db
SiteSaveInsert // Called when a site is added to the db

An example

In your modules now, if you'd like to alter one of these queries, you simply change the params.

So say you added a field to the downloads table, you hook into DownloadSaveUpdate & DownloadSaveInsert, then add your field to the parameters array.

Meaning:

function test($map) {
    $map['myField'] = 'someValue';
}
Core::load()->hook('DownloadSaveInsert', 'test'); 

[Chris2k]

How to display stuff from DB?

[MiltonASpence]

This code help full for me.

Mobile Website Builder