Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™
Author Message
perfect-games
Regular
Regular


Joined: Oct 28, 2004
Posts: 84

PostPosted: Sat May 21, 2005 10:20 am Reply with quote

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
 
View user's profile Send private message
perfect-games
PostPosted: Sat May 21, 2005 10:23 am Reply with quote

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
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sat May 21, 2005 11:14 am Reply with quote

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?
 
View user's profile Send private message
perfect-games
PostPosted: Sat May 21, 2005 11:26 am Reply with quote

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
 
Raven
PostPosted: Sat May 21, 2005 11:35 am Reply with quote

That code loops through all the admins on your site and searches to see if the admin running the script is a god admin.
 
perfect-games
PostPosted: Sat May 21, 2005 11:42 am Reply with quote

so how would i do it as sql or do i skip it
 
Raven
PostPosted: Sat May 21, 2005 11:54 am Reply with quote

SQL code can only be written as SQL. No logic statements. Select, Alter, Create, Update, Delete, etc. - those statements.
 
perfect-games
PostPosted: Sat May 21, 2005 12:37 pm Reply with quote

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
 
Raven
PostPosted: Sat May 21, 2005 1:03 pm Reply with quote

You don't need it if running it as pure SQL.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©