Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #61  
Old 06-03-2002, 07:57 PM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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..
Reply With Quote
  #62  
Old 06-03-2002, 08:13 PM
Highlander Highlander is offline
 
Join Date: Apr 2002
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ??
Reply With Quote
  #63  
Old 06-04-2002, 06:18 AM
Highlander Highlander is offline
 
Join Date: Apr 2002
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 ..
Reply With Quote
  #64  
Old 06-04-2002, 08:28 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #65  
Old 06-05-2002, 05:10 PM
Highlander Highlander is offline
 
Join Date: Apr 2002
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 idtitelurlsprachebeschreibungcoverreleaser  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
Reply With Quote
  #66  
Old 06-05-2002, 10:28 PM
Highlander Highlander is offline
 
Join Date: Apr 2002
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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);
?>
Reply With Quote
  #67  
Old 06-06-2002, 05:26 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #68  
Old 06-06-2002, 06:24 AM
Highlander Highlander is offline
 
Join Date: Apr 2002
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #69  
Old 06-26-2002, 11:24 AM
Wildthinks's Avatar
Wildthinks Wildthinks is offline
 
Join Date: Apr 2002
Location: .:BeRLiN:.
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 threadnamethread.threadid,  thread.forumidfrom_unixtime(post.dateline,'%d.%m.%Y - %H:%i:%s') as ddleft(post.pagetext,80) as pagetxtpost.usernamepost.useridforum.forumidforum.title FROM thread,post,forum where post.threadid=thread.threadid and   thread.forumid=forum.forumid and thread.forumid<>20 and thread.forumid<>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:
Templatenamelast10threads
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
Reply With Quote
  #70  
Old 06-26-2002, 06:57 PM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:41 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10346 seconds
  • Memory Usage 2,306KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (5)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete