Thanks, as i said i'm no coder so how could i do that as that would be great to just add the templates that i want governed by the setting and the usergroups i want to allow access?
Could it be incorporated in a pluggin where you can state which templates cannot be accessed?

Could you also tell me how to do this in a php statement?
<if condition="is_member_of($vbulletin->userinfo, array(1, 2, 3))">.

You would have to establish your own hook in your custom php file. How to notify vB of the existence of the hook is explained by Paul here:
https://vborg.vbsupport.ru/showthread.php?t=83390

The code for your hook would be:
BTW: That permisson does not prevent templates from being accessed. It kicks in much earlier - it prevents the main part of the php page from being processed.

Cellarius, if you wouldn't mind helping a little further, i have created an xml for the hook (as per Pauls' thread), custom_template_permission (custom) is how it's shown in the plugins hook location dropdown, what would i need to add template names and permissions to a plug in?, when the plugin is created would the options be in the admincp nav as a button?

Add the php code for the hook (see my prev post) at the top of the custom code section of your custom php file.
To disallow usergroups from this custom php page add this to the plugin:
This will prevent all members from the usergroups 1,2,3 to see the page. To turn it around use
Note the ! in front of is_member_of. This will prevent all users except usergroups 1,2,3 from accessing the page, so only members of usergroups 1,2,3 will be able to see it.

No, this will add no option to your admincp. This adds a normal hook, and you would need to edit the plugin in the plugin sectin of AdminCP. If this is for your own use only, this is the way I'd do it. An AdminCP option just adds unnecessary overhead. Honestly, I wouldn't even add that hook. Just edit your custom php file directly - thats the most performant and simple way, really.

And once again: This code does not block access to templates. It blocks access to the whole php file, so to say.

I appreciate the time you took to answer, for now i will add it to the custom php, i was asking the other questions for building things in to the admincp in future.

how to make a php page with it???

which may display some data from sql database.???

Just as is explained in the article.

By adding the relevant code to php page you created by following the article in the first post.

Really, it's barely possible to answer unspecific questions like that.

i made my custome page by this tutorial.
now i want to display some data from sql database on it through PHP.

all i got till now is that data is currently comming from Template???
can you please tell me where to write my php code??

If you have your custom page up and running following this tutorial then the purpose of this article and thread is achieved. It can't be the place for every custom programming question. You need to open your own thread for your question. Even better, do some reading before: https://vborg.vbsupport.ru/showthread.php?t=119350

Thnx For Replying, Im Still Clueless...I Know All Database Queries.
My Question is just that where to write my PHP code and queries to display data properly on this page.