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(dbqueryresultdoecho) { 
  
temp.init timevar2
  
temp.results requestsql2(dbqueryresult); 
  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() > || 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.querytrue); 
  if (
temp.result.rows.size() > 0) { 
    for (
temp.rowtemp.result.rows) { 
      echo(
temp.row.Username);
    } 
  } 

And recieved no echo in rc 0.0
__________________
Reply With Quote