[WEBTEMPLATES HACK:]Share your WebTemplates or WebQueries!

[Rose]

Originally posted by Logician

ok I see your problem: Use conditional in this format:

[[($bbuserinfo[usergroupid]==1)]]

Of course closing conditional will be replaced too:
[[/($bbuserinfo[usergroupid]==1)]]

That seems to allow the code to show up! Now that I have it so a member can login, how can I get it to return them to the site page, not the forums page?

Also, I'm still having problems with the "Welcome Back ....." as no matter if a member is logged in or out - it still says unregistered and displays the Unregistered name. However, the "My control Panel" link is working. :s

Oh the frustrations! *hehe* This is a great addition/hack, Logician. I really do hope it works out well as it seems to be so far, minus the few tricks here and there.

You've mentioned how with queries it is endless, which is why a list of helpful queries hasn't been posted. However, I've only seen one that has shared so far (the last ten posts). I'm interested in doing more with this hack, but I can't write my own queries just yet. Is there any plans to release some basics to choose from so we can modify them to fit? Suggestions and such?

[Logician]

Originally posted by Rose
That seems to allow the code to show up! Now that I have it so a member can login, how can I get it to return them to the site page, not the forums page?

Do you need your member to login first before she can display the page? Then why dont you simply use [cantsee]1[/cantsee] tag inside your webtemplate? I guess this will do the trick for you: if she is unregistered/unloggedin she'll get "not allowed" (together with login) page and if she is registered/loggedin she can view the template. What do u think about this solution?

Also, I'm still having problems with the "Welcome Back ....." as no matter if a member is logged in or out - it still says unregistered and displays the Unregistered name.

Your format seems correct. Are you sure you are visiting the template after you logged in? Maybe you can create a member account for me in your site (pls pm username and password and template name to me) and let me check it..

You've mentioned how with queries it is endless, which is why a list of helpful queries hasn't been posted. However, I've only seen one that has shared so far (the last ten posts). I'm interested in doing more with this hack, but I can't write my own queries just yet. Is there any plans to release some basics to choose from so we can modify them to fit?

The problem is I dont have time for all: I develop the new version, I give support for the hack and I have many other released hacks which I also give support. Yes it would be nice if some basic webquery samples would be released (for which this thread is created) but it would be nicer if some of the hack users who can do it would share theirs for all of us instead of waiting me to do everything.

I'm hoping that this problem would be solved in the new version to a certain extent. I integrated "download webquery/webtemplate" feature into the new version and with one click you would be able to create a text file with how to install installations of your webtemplates and webqueries. So all you have to do is to attach this file in a reply in this thread. Therefore I'm hoping that sharing traffic would get higher after this release. Hopefully..

[Rose]

Originally posted by Logician
Do you need your member to login first before she can display the page? Then why dont you simply use [cantsee]1[/cantsee] tag inside your webtemplate? I guess this will do the trick for you: if she is unregistered/unloggedin she'll get "not allowed" (together with login) page and if she is registered/loggedin she can view the template. What do u think about this solution?

I think I'll try it and see if it works! Will edit this post afterwards.
Edited to say: - Okay. I've added the cansee/cantsee bit. Now it takes me to login. Making progress. However, when I login, it calls for /site/member.php (when obviously it's in the /forums directory). I can't copy member.php to the site folder because that doesn't work, either. How do I get it to call from the forums directory (I thought I had that done).

Your format seems correct. Are you sure you are visiting the template after you logged in? Maybe you can create a member account for me in your site (pls pm username and password and template name to me) and let me check it..

I'm sure I'm logged into the forums. I'm not sure if I'm logged into the website - I would assume they both use the same stuff, though. I'll pm you specifics as soon as I can with pass/user.

The problem is I dont have time for all: I develop the new version, I give support for the hack and I have many other released hacks which I also give support. Yes it would be nice if some basic webquery samples would be released (for which this thread is created) but it would be nicer if some of the hack users who can do it would share theirs for all of us instead of waiting me to do everything.

I'm hoping that this problem would be solved in the new version to a certain extent. I integrated "download webquery/webtemplate" feature into the new version and with one click you would be able to create a text file with how to install installations of your webtemplates and webqueries. So all you have to do is to attach this file in a reply in this thread. Therefore I'm hoping that sharing traffic would get higher after this release. Hopefully..

I understand. I guess I shall start taking a more proactive stance here, start writing a few things and seeing if they work, and then contribute! That will be on my todo list. *nods* And your plans for the next release sounds grand.

[Craigr]

Anybody want to share some more queries?

Craig

[Craigr]

Hi,

Is there any way someone could write a query that i could use in the templates.

I want a query that extracts the last 5 posts from a thread and displays part of it say the first few hundred characters. If possible also displays the posters name and time posted.

I managed to alter Pluh News to do this, but you can't include php files in Webtemplates.

Thanks
Craig

[Logician]

Today at 07:55 PM Craigr said this in Post #95
I want a query that extracts the last 5 posts from a thread and displays part of it say the first few hundred characters. If possible also displays the posters name and time posted.

here you go:

[Craigr]

Today at 08:18 PM Logician said this in Post #96

here you go:

Works great.

Thanks once again.
Craig

[amykhar]

I threw this together to satisfy my own curiousity. (Thanks to zzed for a tip that helped me do this).

It's not really a finished hack. It's more of a rough job that lets me see what I want to see. As the table grows, I will manually drop older information as needed.

Run this query:
SQL-query : [Edit] [Create PHP Code]
CREATE TABLE `Google` (
`googleid` TINYINT NOT NULL AUTO_INCREMENT,
`url` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `googleid` )
);


In global.php Find:

$header='';
$footer='';

Add After :

if(strstr($url, "google")) {
   $DB_site->query("INSERT INTO Google VALUES (null, '$url')");
}

OK. Now for the Web Templates part:

Create a new query:

Query name: _google
Query: Select url from Google;
Description: Figure out what people are searching for on Google
No result Text: none
Table Row:<li><a href="??url??">??url??</a></li>


Create a new Web Template:
Template name: Google
Page Count: 0
(You will need to tweak this to your taste. I kept mine bare bones and allow anyone who knows about it to see it) Template:
[cansee]everybody[/cansee]
[options]templatequeryon[/options]
<ol>
$_google
</ol>

Demo:
http://www.eaforums.com/forums/show.php?pg=test

Have fun

[Logician]

it is handy, thx for sharing!

[mzbcarper]

Hello, i want to include the username on my custom page, how could i manage this ?

greez

mzbcarper