Sentinel install help

Regular Joined: Oct 28, 2004 Posts: 84

hi guys could someone help maybe i doing this wrong i am trying to make the install as a sql not as a script install.

i done all my other scripts installs as sql fine but now i not sure becuase the install script has one i not sure on

Code:

$importad = $db->sql_query("SELECT `aid`, `name` FROM `".$prefix."_authors`");


while(list($a_aid, $a_name, $a_pwd) = $db->sql_fetchrow($importad)) {


    if(strtolower($a_name) == "god") { $is_god = 1; } else { $is_god = 0; }

i have started and made it like

Code:

SELECT `aid`, `name` FROM nuke_authors`;

but what should i do with the rest
any idears

thanks

Posted: Sat May 21, 2005 10:23 am

apart from this code all the rest is fine ,

or is it ok as it is raven or any other people can you advise me, or would it be best if i create a script install

thanks

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

i'm not sure what you're doing. First it sounded like you just wanted to convert the NukeSentinel(tm) nsnst.php script to a raw sql file. But then you're asking about code. What exactly are you asking to do?

Posted: Sat May 21, 2005 11:26 am

I want the full sql as a sql just that this code above confused me not sure how or what to do with it
as the reason behind it as its part of my update script from older or other versions of nuke to my system
any idears or converting the nsn script in to a full .sql

thanks

Posted: Sat May 21, 2005 11:35 am

That code loops through all the admins on your site and searches to see if the admin running the script is a god admin.

Posted: Sat May 21, 2005 11:42 am

so how would i do it as sql or do i skip it

Posted: Sat May 21, 2005 11:54 am

SQL code can only be written as SQL. No logic statements. Select, Alter, Create, Update, Delete, etc. - those statements.

Posted: Sat May 21, 2005 12:37 pm

so the code above does it need to be script or is there a way to do it with sql basically i making update script from nuke 7.6 with all my added features or would it be best if i create a script update file instead

thanks

Posted: Sat May 21, 2005 1:03 pm

You don't need it if running it as pure SQL.