[WEBTEMPLATES HACK:]Share your WebTemplates or WebQueries!

[silly rabbit]

Originally Posted by Logician

Webtemplates still has a structure for creating such special variables and templates but it is for advanced users only. People who is proficient in PHP can check vbulletin's algorithm for such special variables . . .

Logician, I see your 'share' thread survives!! Am studying / using your WT system and don't have any real problems(yet) but would value your opinion. Do you see any conflicts or problems with integrating WT with Abe's FORMS HACK ??? One is great at DB reading (yours) and the other is suited to DB / thread writing and although I certainly have more research & learning to do I'm will try to combine the two.

Also, I'm trying to migrate away from the 'td' (table data) and FRAMING system and am using Css for both 'style' and layout formatting thru the use of 'href' and 'import'. As far as positioning is concerned Percent works well but 'absolute' is so so . . .

Any gENERAL Thoughts / Tips to Share??

[leitel]

I also needed a means to manage vb and non-vb data from within vb. I looked at forms hack. It looks adequate for simple needs. I needed more. Then 're-discovered' CodeCharge . With a little hacking you can embed the code 'within' vb pages!!

[Logician]

Originally Posted by silly rabbit

Logician, I see your 'share' thread survives!! Am studying / using your WT system and don't have any real problems(yet) but would value your opinion. Do you see any conflicts or problems with integrating WT with Abe's FORMS HACK ??? One is great at DB reading (yours) and the other is suited to DB / thread writing and although I certainly have more research & learning to do I'm will try to combine the two.

Also, I'm trying to migrate away from the 'td' (table data) and FRAMING system and am using Css for both 'style' and layout formatting thru the use of 'href' and 'import'. As far as positioning is concerned Percent works well but 'absolute' is so so . . .

Any gENERAL Thoughts / Tips to Share??

Sorry I have no idea, I have never used that hack.

[silly rabbit]

Originally Posted by Logician

Sorry I have no idea, I have never used that hack.

Originally Posted by leitel

Then 're-discovered' CodeCharge . With a little hacking you can embed the code 'within' vb pages!!

Great job nonetheless Logician - will report back 'results'!!

Can I parse in HTML and still embed php????

Oh, never knew href file addressing to be Case Sensitive!!!! ('lil things do drive ya nuts!)[/COLOR][/SIZE]

Originally Posted by added

I see CodeCharge - if it generates pages via 'td' with styling 'inline' it's really not much use to me as I need to develop and control my own HTML within Css. Am currently using Studio5 from UltraEdit.com (costs less) having also tried Zends Studio 5 which is geared more for local server side (not hosts). BOTH support ALL scripting languages including PHP and Css thru easy FTP access.

Css Is Great!!!

Holy Cow, I LIKE the editors 'color' selector!!! (also a hack to investigate?) I'd like to see it in HEX values!!!

Cheers!!

[geezmo]

Hi! How do I make a webquery that pulls a post posted fromma certain forum and makes it a separate WebTemplate page?

Sort of an article system, where I make a new thread in say Forum 1 and that new thread becomes a new article page in WebTemplate? So that if I made 10 new threads in Forum 1, I can have 10 different WebTemplate pages corresponding to each of those new threads? Also I don't want it to be a simple link to the post in the forum but a stand-alone article itself.

Hmm.. exactly like this: http://www.theadminzone.com/forums/a...icle&aid=18141

[bada_bing]

Lets see more webQueries and your code. This thread would be cool of we can make this a total "post your WebTemplates and WebQueries for others to see and use.

I currently have WebTemplates installed and I know there is tons of potentials with this hack but me not being a coder I would like to get some ideas of how your using this hack and details on how you created it.

[Logician]

Originally Posted by bada_bing

Lets see more webQueries and your code. This thread would be cool of we can make this a total "post your WebTemplates and WebQueries for others to see and use.

I currently have WebTemplates installed and I know there is tons of potentials with this hack but me not being a coder I would like to get some ideas of how your using this hack and details on how you created it.

I agree with you and the goal of this thread was actually this but I'm afraid hack users are not interested in sharing their WT/WQ much. :knockedout:

Actually import/export WT section is only designed so that people can easily share their work but unless they do, there is not much I can do. Unfortunately I don't have time to create new WT/WQ so it would be really great if hack users take the liberty and help eachother.

[bada_bing]

Originally Posted by Logician

This WebQuery will display the last XX private messages of your members. So if you want to keep your member's pms under surveillance, you'll like this one

Here we go: Login your CP and click ADD QUERY:
Fill the form accordingly:

QUERY NAME:
----------------
_privatemessages

QUERY:
---------
SELECT privatemessageid, fromuserid, touserid, title, message, touser.username AS tousername, fromuser.username AS fromusername
FROM privatemessage
LEFT JOIN user AS touser ON (touser.userid=privatemessage.touserid)
LEFT JOIN user AS fromuser ON (fromuser.userid=privatemessage.fromuserid)
WHERE folderid='0'
ORDER BY privatemessageid DESC LIMIT 30

(Change 30 to whatever you want for last XX messages)

DESCRIPTION:
-------------------
Read last XX private messages of your forum.

NO RESULT TEXT:
----------------------
No private messages exist in the database!

TABLE ROW:
---------------------
<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="#0000FF"><tr><td><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF"><tr> <td ><div align="center"><normalfont>Message
ID: ??privatemessageid??</normalfont></div>
</td><td ><div align="center"><normalfont><a href="$bburl/member.php?s=&action=getinfo&userid=??fromuserid?? ">??fromusername??</a></normalfont></div>
</td><td ><div align="center"><normalfont><a href="$bburl/member.php?s=&action=getinfo&userid=??touserid??"> ??tousername??</a></normalfont></div></td></tr><tr>
<td colspan="3" ><normalfont>??title??</normalfont></td></tr><tr>
<td colspan="3" ><normalfont>??message??</normalfont></td></tr></table></td></tr></table>


Save your query and it's ready to rock. Now let's add a Webtemplate to attach your query:

Click ADD WEBTEMPLATE and create your HTML page as you like. Just a few points about your webtemplate:
1- Insert $_privatemessages in your template in the place where you want the private messages displayed.
2- Insert [options]templatequeryon[/options] anywhere in your template so that the script will parse your WebQuery.
3- Dont forget to ban this page to your ordinary users so that other members wont see all pms of all users. Give access to specific users/usergroups for this page. Eg. insert :

[cantsee]everybody[/cantsee][cansee]6 Admin[/cansee]

This will ban the template to all users except whose usergroup id is 6 or username is "Admin"

Just a WebTemplate Sample here:
(Remember WebTemplates are simple HTML pages so you can create them by yourself, this is just an example)
-- cut ----
[cantsee]everybody[/cantsee][cansee]6 Admin[/cansee] [options]templatequeryon[/options]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head>
<!-- no cache headers -->
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="no-cache">
<meta http-equiv="Expires" content="-1">
<meta http-equiv="Cache-Control" content="no-cache">
<!-- end no cache headers -->
<title>$bbtitle </title>
<p align="left">$headinclude </head> <body> $header <br><p>

<p align="left"> <normal></normal></p>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td valign="top">
<p align="center"><smallfont>The page you accessed is visited by '$count' times.
Last visitor of this page was "$lastvisitorname" who visited the page at $lastvisittime.</smallfont></p>
<p>&nbsp;</p>
<div align="left">
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat">
<td bgcolor="#606096"><normalfont color="#FFF788"><b>Last
30 Private Messages From Your Board:</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#F1F1F1">
<p><normalfont> </normalfont><normalfont>$_privatemessages<br>
</normalfont></p>
</td>
</tr>
</table>
<p align="center"><smallfont></smallfont></p>
</div>
</td>
</tr>
</table>
$footer
-- cut --------

That's all! Now you can call your webtemplate as http://your_board_url/show.php?pg=your_template_name to monitor last XX pms in your board.

Enjoy!
Logician

I am trying to run a query but admincp is giving me this message

You are not authorized to execute SQL queries

I am logged in as Administrator???

[bada_bing]

Any update to this thread? Lets keep it alive and post your code and what you are using this hack for.

[Ntfu2]

Originally Posted by bada_bing

I am trying to run a query but admincp is giving me this message

You are not authorized to execute SQL queries

I am logged in as Administrator???

In the config.php there is a place to add your member id number to the users that can run queriers.

Make sure your number is there