Thread: SQL Help
View Single Post
  #4  
Old 09-27-2011, 02:03 AM
Ohk4y Ohk4y is offline
Registered User
Ohk4y's Avatar
Join Date: Jun 2011
Posts: 43
Ohk4y is an unknown quantity at this point
Send a message via AIM to Ohk4y
I added this as -Ohk4y/Query
PHP Code:
/** 
    SQL Query Interface 
*/ 

public function executeSQL(db, query, result, doecho) { 
  
temp.init = timevar2; 
  
temp.results = requestsql2(db, query, result); 
  if (
result) { 
    
// Check Results 
    
if (results.error != "") { 
      echo(
format("SQL Error: %s", results.error)); 
      
savelog2("sqlerrors.txt", results.error NL query); 
      return 
NULL; 
    } 
    else if (
results.rows.size() > 0 || query.starts("SELECT")) { 
      if (
doecho) echo(format("SQL returned %s rows.", results.rows.size())); 
    } 
    else if (
results.affectedrows.size() > 0) { 
      if (
doecho) echo(format("SQL affected %s rows.", results.affectedrows.size())); 
    } 
    else if (
results.completed) { 
      if (
doecho) echo(format("SQL %s Query completed successfully.", query.tokenize()[0].upper())); 
    } 
    
temp.taken = timevar2 - temp.init; 
    
// Uncomment to log queries (for checking performance, etc.) 
    //savelog2("sqlqueries.txt", query NL "Took " @ temp.taken @ " seconds"); 
    
return results; 
  } 
} 
And added this as -Ohk4y/Test3
PHP Code:
function onCreated() { 
  
temp.query = "SELECT Username,Password,EZ,Level,X,Y,Exp FROM Accounts"; 
  
temp.result = SQL.executeSQL("default", temp.query, true); 
  if (
temp.result.rows.size() > 0) { 
    for (
temp.row: temp.result.rows) { 
      echo(
temp.row.Username);
    } 
  } 
} 
And recieved no echo in rc 0.0
__________________
Reply With Quote