[WEBTEMPLATES HACK:]Share your WebTemplates or WebQueries!

[Logician]

Originally posted by Highlander
thx...how can i integrate other PHP sites on external webservers?

If what you want is to compile data from other web sites via this hack, nope this cant be possible. Webqueries only compile data from your board's MYSQL database.

[Highlander]

okaz..that was also mz thinking..
but mz problem now is ..how to get all these queries..i got ideas bot no queries..

for ex.:
Login shown
or
Logout is show
or
last 10 posts

where to search for all these queries..in the php files?

and if so, should i use them exactly so like it writes there ?

[Logician]

WebQueries are SQL SELECT commands which returns data from your MYSQL database. They are not vb-pages or sections or parts so you can not return eg. login/log out display forms.

However you can return eg. last 10 posts because it's a query to your MYSQL and your database can return SQL results for this query.

Considering the fact that you are very new to SQL queries I strongly suggest (as in my previous post) studying SQL. It has a very simple syntax and you can really improve yourself in less than an hour for many SQL SELECT Queries. There are a lot of SQL tutorials on the internet, checking them out can help you a lot..Also get a script or hack to run SQL commands to get practise in your MYSQL. PHPMyAdmin is free and very nice script..

[Highlander]

okay thanx i will do soo..maybe you got an usefull links for me ?

i got again another question..its not really right here..but i dont know who to ask..
I coded a Conent Manager, so it right working very fine..i got an Admin Panel to insert Links with description, Screens and even Covers if they are able to get..this type is specially for games..movie..music and much more content....so but now my expierence is not very much i just started to work with SQL and PHP since 3 months ago..and there isnt much practice yet..even i managed to code this little conten managment..but i cant figure som thing out..and i try ..(but wont work) to integrate this little code in vbulletin..if it is able to be integrated..but the most importand i need to change is ( and i cannot manage it ( ) is all this search queries i got (. examp. list new entries .. or list pcgames..list movies..) are not integrated on one php page..no i dont know how to this..so i created for every search query one php page..and link to it..now i just saw that you can create php pages with many sql in it..you even have to make variables and then link to them to use this queries , right ?..but i cant figure out..mybe you can or would help me a little bit..it would be really nice..i really dont know how to make this run

P.S.
Delete this post if its to wrong here....sorry

[Highlander]

Hi logician..i got another feature to make..but can you help me?

I want in forumID 63 of USERGROUPID2 and USERID56 that all posts are shown LIMIT XX ... .. i will try something..than tell you if it worjks..

[Highlander]

okay i got it...here is a Web Query you can only get shown Threads from specific User:

PHP Code:

SELECT threadid, title, forumid, postusername, dateline FROM thread WHERE postuserid='XX' ORDER BY dateline DESC LIMIT 10 


you see the XX above..there you can put a specific USERID of any USER .. the rest of it it is the same as in _LAST_10_THREADS .. copy all text and just change this thing with USERID='XX' thats it..


@Logician
I got a few questions about the board variables:

You wrote in the Help Template hat i can use $count or $user_userid ..$user_userrname as variables to make it shown ..i tried to put variables of the normal Board templates like $registered or wanted to make visible how much threads started today and i used this variables "$forumt" but nothing happend when i use the normal board varibles .. why ..whats wrong..can i not use the variables of the board templates ??

cu...and even thx .. i just love this hack..ia m every day the whole time on it .. to get out dynamic pages..and my users begin to love it !

[Logician]

Originally posted by Highlander
I got a few questions about the board variables:
You wrote in the Help Template hat i can use $count or $user_userid ..$user_userrname as variables to make it shown ..i tried to put variables of the normal Board templates like $registered or wanted to make visible how much threads started today and i used this variables "$forumt" but nothing happend when i use the normal board varibles .. why ..whats wrong..can i not use the variables of the board templates ??

it depends: Vbulletin has two types of variables: Global and local.
Global variables are produced when ANY vbulletin script runs and are always alive(has a value). For example $bbuserinfo['username'] is a global variable and it always has a value regardless of the vbulletin script running. You can use global variables inside your Web Templates.

However many vb variables are local and they only have a value when a specific script runs. (eg. index.php). $forumt or $registered variables are local and they will only have a value when their parent script runs so they dont work inside WebTemplates..

Ps. As I said in my privous message it's not possible for you to return some sections of vb with this hack. That is, you cant just automatically and easily create "todays birthdays" section in the main page inside a webtemplate like copy/paste or smt. You can however return results from your MYSQL and hack will automatically create tables for them. You can locate these tables easily inside webtemplates. So what you want to integrate should be queried from the MYSQL so as to be integrated into a WebTemplates.

[Highlander]

okay thx..for the info..

for the site integration i dont want to return some sections of VB..no i got some non vb sites and i tried to use this queries to make web queries and templates to make this pages shown..so i would be able to integrate this non vb sites in my vb .. for example:

i got a tabel named pc_games .. so in this table are 5 rows listed .. 1. id
2.url
3.title
4...and so on..

ok.. i just managed to ask for title..as i make an query:
SELECT FROM pc_spiele order by title DESC ..
so i got now listed all titles in this table .. but how to say in the query to make not only the title visible..also all other data nthis table and to make klickable links of it..like in my php sites..

the tabel pc_spiele is in the same database as vb and webtemplates..and what i try is to integrated a whole non vb site in this webtemplates..but i need a little bit help..if i could get help for the first time..i am able to get manage the rest alone..so if you got time or answers tell it to mee...please

[Logician]

Query:
SELECT id, url, title FROM pc_spiele order by title DESC

Table Row:
<li><normalfont><a href="££url££">££title££</a>(id=££id££)</normalfont></li>

Take some time with webquery samples that come with the hack, they will help you get the basics..

[Highlander]

no the writing sxript is already finish and the content managment also..this is not the problem...its only for this specific content managment..but if i finished all and even got time..i will release a similar thing wich will work wqith your template system together..but only if there is interest..

for BETA 0.0.0.0.2
go here :
http://www.spieleplanet.org/vbp/vbb/show.php?pg=spiele

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...really i would be very glad if somebody could help me and tell me some thing i need to know .. !