[WEBTEMPLATES HACK:]Share your WebTemplates or WebQueries!

[Logician]

Originally posted by Highlander
i managed it already to make it visible and first functions are there..but now i just even need some tipps to increase the output ..thats all...

Pal I really have problems following your language :knockedout:
What do you mean by "increase the output". I tried to guess what you want by checking your webtemplate but couldnt figure out anything. Your webtemplate is fine and working (by the way dont you have the longest webtemplate ever made? lol) and I really cant understand what tip I am asked to give. Sorry pal..

[Highlander]

sorry i know .. my english is sometimes very bad ..

longest webtemplate *lol*

thats also one thing i want to figure out..now in the original php file .. i could sel comand like "..*php?sel=a" but now i need new sort queries i think..(increasing output *:-)) ) for example..to sort by alphabetical order .. or newest entry and it is able to count klicks on the link (ID`s) or make some other statistics with help of templates ??

[Highlander]

hmm i think you maybe cant understand my language..lol..sorry for that..

can you help getting some sort options..and how to inster them..should i make for every sorting a new web query..or can i insert different sort queries in and web query ??..if you dont got time to do much help so tell me .. its no matter..but some tipps would be very useful..and i just figured out some things i asked you before..but you should know if you arrive at the next step..there are questions again..and every step i made ... i get more questions..but its fun to get involved in mysql and php .. i like that coding..its really the best to make websites ..

[Logician]

ok I think I understand what you mean now (was not easy though)

I think you want your webtemplates to accept "parameters" like:
url/show.php?pg=whoareyou&sort=threadid

This is requested before (by Wildthinks?) and I'm thinking of adding this future for the new release (btw I'm about to complete it. In fact if I decide not to add this feature, it's already finished)
I have just some concerns about security for this feature, so I dont want to rush and add a security gap, to introduce a new feature. I need some time to ponder about it and if I decide to add it, need more time to design/debug it so as not to impair the code's security.

So I dont promise for this feature, but it's already regarded and you may or may not see it in the new release.

[Highlander]

hello,

i got a question again..

i need to sort all links from a-z .. should i create evrytime one own query

PHP Code:

SELECT id, titel, url, sprache, beschreibung, cover, releaser  FROM pcspiele WHERE titel LIKE "a%"; 


this would mean i need for every section 24 queries to sort by letters..and if i got 4 sections i would have 96 webquerytemplates.

And how should i sort by date ?..when i want specificate to sort by titles wich are 10 days old (for ex.)..

should i also create a webquery template ..or is there a way to get all sort criterias in one webquery ..

this main question would help me out if i could do it in a other way

[Highlander]

hi logician..i think maybe my project cant be done with webtemplates..i just cant figure out some things..so maybe its the best to leave this nonVB pages as they are... the thing is that i dont know the orders to do same things my existing php files do....the code i got on my php files is not working when i put it in the templates.......i will give it some try again...but code like this..what do do with..where should i integrate it ?

PHP Code:

  <?
$link=split("\n",$row[2]);
foreach ($link as $value)
{
$rest = substr ($value, 0, 4);
if ($rest == 'ed2k')
{
$datei = explode("|",$value);
?>

[Logician]

Highlander your problem will be solved if my hack can accept "parameters". Then you will be able to send the parameters to your webtemplates, process them in webqueries and get the result you want like sorting your queires according to field X.

However as I said before this hack does not accept parameters at the moment so you cant do what you want easily. You have to create a different query and webtemplate for all your different sorting orders and it will be arduous for you, I wouldnt suggest that.

If I were you I would leave these pages as they are and convert them to webtemplates only if new release of webtemplates accept parameters.

One more point: If you dont need these pages to use vbulletin data (vb security/vb styles etc.) why are you converting already made pages to webtemplates? Webtemplates hack is for integrating you non-vb pages to vbulletin and if these non-vb pages has nothing to do with vbulletin (for example if you dont want them accessed by user group X, etc.) you can leave them as it is. My 2 cents.

[Highlander]

i just wanted to integrate the whole site in the board..and make some thing only visible to members of my site...so it would be the best to use the USER TABLE of the board...ok and i would manage it at all if i could do this two things with the templates....maybe it would work if we could set our variables and use variables as we want..i just bought some books more this days to figure out some things in queries of sql....and i am very sad not to get this content managment to be integrated...

and i think of the idea...why not to code a content managment for the board..i got also the portal and there is a good link managment to insert links and sort them by much things..like date ..and title..but it will not use my ed2k links ..it only works with http links..so there is really no option at this time ti integrate my little coded content managment ..i am sad now..i just want my link managment integrate in the board .....nobody coded a content managament for the vb wich i could use for my huge link database..thx at all and i will use the webtemplates anyway for other things..and now i will read much books to code my own vb content managment

[Wildthinks]

Hi everybody.... here come a little tutorial for last threads on your mainpage ... demo hier: http://swishzone.net

Ok
1. Install webtemplates from logician :lick:

2. create a query called: _last_10_threads

PHP Code:

query name:
_last_10_threads

query:
SELECT thread.title as threadname, thread.threadid,  thread.forumid, from_unixtime(post.dateline,'%d.%m.%Y - %H:%i:%s') as dd, left(post.pagetext,80) as pagetxt, post.username, post.userid, forum.forumid, forum.title FROM thread,post,forum where post.threadid=thread.threadid and   thread.forumid=forum.forumid and thread.forumid<>20 and thread.forumid<>9 and thread.forumid<>32 order by post.dateline desc limit 10

Description: what you want
no result text: what you want


table row:
<tr id="catportalleft">
<td>
<b><smallfont><a href="$bburl/forumdisplay.php?s=&forumid=??thread.forumid?? title="Klick hier um zum Forum zu kommen">Forum: ??Forum.title??</a></b></smallfont>
<tr>
<td><smallfont><b><a href="$bburl/showthread.php?s=&threadid=??threadid??" title="Klick hier um zum Thema zu kommen"><b><img src="$bburl/https://vborg.vbsupport.ru/images/icons/icon1.gif" valign="bottom" alt="Arrow" border="0">Title: ??threadname??<b></a></b> 
<tr>
<td>
<smallfont>??pagetxt??... [<a href="$bburl/member.php?s=&action=getinfo&userid=??post.userid??" title="Profile von ??post.username?? ansehen">??post.username??</a>]</smallfont></td>
</tr>
<tr>
<td bgcolor="{alternate}"><smallfont>
??dd??</smallfont></td>
</smallfont>
<td>
</tr>
</td>
</tr>
<td>-</td> 


3. create webtemplate

PHP Code:

Templatename: last10threads
pagecount: what you want (0 is good)

Template:
[cansee]everybody[/cansee] [options]templatequeryon[/options] 
<table cellpadding="4" cellspacing="1" border="0" width="100%"> 
<tr id="catportalleft"> 
<td><normalfont color="#FFF788"><b>Letzten 10 Themen </b></normalfont></td> 
</tr> 
$_last_10_threads
</table> 


4. include wherever you want this:

PHP Code:

<?php include ("http://www.yourdomain.de/vbdir/show.php?pg=last10threads"); ?>

That's all and works fine on my site....

The last posts with Date, Poster, Forumname and the first 80 Characters... in this version from Webtemplates dont work the smilies...but Logician is going with the development... i hope

[Logician]

Originally posted by Wildthinks
The last posts with Date, Poster, Forumname and the first 80 Characters... in this version from Webtemplates dont work the smilies...but Logician is going with the development... i hope

Yes new version parses all smilies and bbcodes. It also formats date fields according to page viewer's time settings. But I must say that I liked your approach to convert unix time in MYSQL query. Also it was a nice idea to php include the show.php to another php file (eg. main page). I must confess that I never thought about that before, congratulations!

By the way good news: I really added a very nice feature to the new version. It now accepts outside variables from the user and process them inside webtemplates and more importantly in webqueries. So for example you can design a HTML forum which submits info to a webtemplate and the webqueries in this template will be formed dynamically according to the data your form sent. It seems to work fine in the alpha tests but I really need to work on it a little more. It's really a tricky feature but introduces truly amazing number of possibilities that can be done via this hack.