About 22,391 results: "mysql_query"
Page 1 of 50
Filter Results
Sources
Languages
Lines
Any number of lines
Try Search On








  1. 	//first, organize tables in order
  2. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN product_id INTEGER(11) NOT NULL AUTO_INCREMENT FIRST");
  3. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN model_number VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER product_id");
  4. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN post_id INTEGER(11) NOT NULL DEFAULT 0  AFTER model_number");
  5. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN activate_in_store TINYINT(1) NOT NULL DEFAULT 0 AFTER post_id");
  6. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN title VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER activate_in_store");
  7. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN description TEXT COLLATE utf8_general_ci  AFTER title");
  8. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN specifications TEXT COLLATE utf8_general_ci  AFTER description");
  9. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN price  FLOAT(15,3) NOT NULL DEFAULT 0.000 AFTER specifications");
  10. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN list_price  FLOAT(15,3) NOT NULL DEFAULT 0.000 AFTER price");
  11. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN vat_rate  FLOAT(15,3) NOT NULL DEFAULT 0.000 AFTER list_price");
  12. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN handling_price  FLOAT(15,3) NOT NULL DEFAULT 0.000 AFTER vat_rate");
  13. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN stock_quantity INTEGER(7) NOT NULL DEFAULT 0 AFTER handling_price");
  14. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN weight FLOAT(15,3) NOT NULL DEFAULT 0.000 AFTER stock_quantity");
  15. 	mysql_query("ALTER TABLE ec_product MODIFY COLUMN width DOUBLE(15,3) NOT NULL DEFAULT '1.000' AFTER weight");






  1. $time = time() - ($CONF['LAST_LOGIN_MAX'] * 86400);
  2. $SELECT_USERS = mysql_query("SELECT username, last_login, id FROM users WHERE last_login > '0' AND last_login < '".$time. "' AND active = '1' AND suspended = '0' AND admin_level != 'admin' ", $db);
  3. 	//Suspend account
  4. 	mysql_query("UPDATE records SET disabled = '1' WHERE user_id = '".$USERS['id']."' ", $db);
  5. 	mysql_query("UPDATE users SET suspended = UNIX_TIMESTAMP() WHERE id = '".$USERS['id']."' ", $db);
  6. 	
  7. //Check suspended accounts that have passed LAST_LOGIN_MAX_SUSPEND
  8. $SELECT_USERS = mysql_query("SELECT username, last_login, id, suspended FROM users WHERE last_login > '0' AND active = '1' AND suspended > '0' AND admin_level != 'admin' ", $db);
  9. 		//Delete user hosted domains
  10. 	    $SELECT_USER_DOMAINS = mysql_query("SELECT domain_id FROM records WHERE user_id = '".$USERS['id']."' AND type = 'SOA' ", $db);
  11. 		while ($USER_DOMAINS = mysql_fetch_array($SELECT_USER_DOMAINS)){
  12. //Check users that suspended and notify them that their account will be deleted soon
  13. $SELECT_USERS = mysql_query("SELECT username, last_login, id, suspended FROM users WHERE last_login > '0' AND active = '1' AND suspended > '0' AND admin_level != 'admin' ", $db);
  14. 	//check in users_notifications table 
  15. 	$SELECT_PAST_NOTIF = mysql_query("SELECT * FROM users_notifications WHERE user_id = '".$USERS['id']."' AND type = 'LAST_LOGIN_MAX_SUSPEND' ORDER BY time DESC", $db);
  16.         //SEND EMAIL NOTIFICATION
  17. 		mysql_query("INSERT INTO users_notifications (`user_id`, `type`, `time`) VALUES ('".$USERS['id']."', 'LAST_LOGIN_MAX_SUSPEND' , UNIX_TIMESTAMP() ) ", $db);

  1.     $csv_escaped = "\\";
  2. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentwisetotalcalls','".@$filename."','".@$time."','0','".@$time."','0')");
  3. 	$totalleadstatusids = array(7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,26,37,38,39,42,43);
  4. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());
  5. FROM `lead` join user on user.id=lead.currentAllocatedId left join leadStatus LS on LS.leadStatusId=lead.leadStatusId where lead.updatedOn >= "'.@$start.'"  and lead.updatedOn <= "'.@$end.'" group by lead.currentAllocatedId';
  6. 	$esx = mysql_query($tableres) or die(mysql_error());
  7. 
                        
  8. mysql_query($queryforinsert);	
  9.     // Gets the data from the database
  10.     $result = mysql_query($sql_query) or die(mysql_error());
  11. 	$time = time();
  12. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentfreshleadsdisposition','".@$filename."','".@$time."','".@$_SESSION['id']."','".@$time."','".@$_SESSION['id']."')");
  13. 	$totalleadstatusids = '7,8,9,10,37,38,11,12,42,43,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,33,39,43';
  14. 	$time = time();
  15. 	mysql_query("insert into report_info (id,type,filename,createdOn,createdBy,updatedOn,updatedBy) values('','agentfreshleadsdisposition','".@$filename."','".@$time."','0','".@$time."','0')");
  16. 	$chktableExist = mysql_query('DROP TABLE IF EXISTS '.$table.' ') or die(mysql_error());





Back to Top