[WEBTEMPLATES HACK:]Share your WebTemplates or WebQueries!

[ChrisBaktis]

Any help with the webquery to list the top to referers and how many referals they have?

[louis_chypher]

Any suggestion on how to pass a parameter to a web querry and have it included in the query? Such as an event id.

such as:

SELECT something FROM calendar where id=xxxx

where I pass to the query the value for xxxx?

Also:

Originally Posted by ChrisBaktis

Any help with the webquery to list the top to referers and how many referals they have?

I am assuming by, "to list the top to referers" you mean the top two (2) referers?

Try in your admin Maintainence sql query (see note):

SELECT COUNT(2) AS count, user.userid AS userid
FROM XXXuser AS users
INNER JOIN XXXuser AS user ON(users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid


*NOTE: replace XXX with the prefix name that you are using for you dB.

The prefix name I use is "vb_" so the query I would use is:

SELECT COUNT(2) AS count, user.userid AS userid
FROM vb_user AS users
INNER JOIN vb_user AS user ON(users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid

If you do not have a prefix then use:

SELECT COUNT(2) AS count, user.userid AS userid
FROM user AS users
INNER JOIN user AS user ON(users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid

******************
if that is what you want then the below should work in your web query as the query to get the count and who:

SELECT COUNT(2) AS count, user.userid AS userid
FROM " . TABLE_PREFIX . "user AS users
INNER JOIN " . TABLE_PREFIX . "user AS user ON(users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid

[Logician]

Originally Posted by louis_chypher

Any suggestion on how to pass a parameter to a web querry and have it included in the query? Such as an event id.

such as:

SELECT something FROM calendar where id=xxxx

where I pass to the query the value for xxxx?

Also:

You can use phpinclude part of webquery. Check priv_privatemessages wt for an example.

[louis_chypher]

Hopefully, I can explian this correctly.

Lets say I made a WebTemplate that is a 'template'; lets call it TemplateTemplate.

I would like to create a webtemplate page (to keep it simple) that allows for the entry of a name and submit button. When a name has been entered and the submit button is pressed the TemplateTemplate is used as a template to create a brand new web template that is named based upon the entred name.

Another try at an explination

I have a webtemplate named TemplateTemplate that is the base template to create other templates off of.

I have another web template that a user can go to, call it 'CreateTemplate'. CreateTemplate has a text field and a submit button. When the submit button is pressed on CreateTemplate, create template (calling what ever is needed) takes TemplateTemplate as a base to create a new web template that is named as was entered on CreateTemplate.

Is this possible?

What code or functions do I need to call to make a webtemplate from one web template?
Can there be be 'default settings' or a default template used to create other templates from?

If its not possilble then what would be needed to make it possible?

[grazianno]

hi,
i want use the recent attachment code with webtemplates to display the recent attachments

the recent attachment code is:

<------the code to add in index.php------>
$trix = $db->query("
SELECT attachmentid, dateline, filename 
FROM attachment 
WHERE dateline < " . TIME() ." 
ORDER BY dateline DESC 
LIMIT 5");

while ($recentattachment = $db->fetch_array($trix))
{
	eval('$latestattachments .= "' . fetch_template('recent_attachments') . '";');
}
<------/the code to add in index.php------>

<------the code to add in a new template "recent_attachments"------>
<tr>
<td class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" valign="top">
<td>
     <tr> 
          <td width="30%"><a href="attachment.php? attachmentid=$recentattachment[attachmentid]">
<img src='attachment.php? attachmentid=$recentattachment[attachmentid]' alt='$recentattachment[filename]' width="50" height="50">
</a>
<br> Attachment number $recentattachment[attachmentid]
</td>
          
        </tr></td>
             </td>
  </tr>
</table> 
<------/the code to add in a new template "recent_attachments"------>

<------the code to add in the forumhome template ------>
<table class="tcat" cellpadding="0" cellspacing="0" border="0" width="100%" align="center" valign="top">
<tr>
<td class="thead" width="100%">
<normalfont><b>Recent ATTachment</b></normalfont></td></tr>
<tr>
<td align="center">
$latestattachments
</td>
</tr>
</table>
<------/the code to add in the forumhome template ------>

i dont know where to add this code

while ($recentattachment = $db->fetch_array($trix))
{
eval('$latestattachments .= "' . fetch_template('recent_attachments') . '";');
}

if someone can help...
thx