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

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:


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

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

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?

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

the recent attachment code is:

i dont know where to add this code
if someone can help...
thx