<? PHP header ("Content-Type: text/html; charset = UTF-8"); function populate_db ($ dbname, $ dbprefix, $ sqlfile) {Global $ errors; @ mysql_select_db ($ dbname); mysql_query ("set names utf8"); $ mqr = @ get_magic_quotes_runtime (); @ resolve (0); $ query = fread (fopen ($ sqlfile, "R"), filesize ($ sqlfile); @ set_magic_quotes_runtime ($ mqr); $ pieces = split_ SQL ($ query); For ($ I = 0; $ I <count ($ pieces); $ I ++) {$ Pieces [$ I] = trim ($ pieces [$ I]); If (! Empty ($ pieces [$ I]) & $ pieces [$ I]! = "#") {$ Pieces [$ I] = str_replace ("#__", $ dbprefix, $ pieces [$ I]); If (! $ Result = @ mysql_query ($ pieces [$ I]) {$ errors [] = array (mysql_error (), $ pieces [$ I]); }}} function split_ SQL ($ SQL) {$ SQL = trim ($ SQL); $ SQL = ereg_replace ("\ n # [^ \ n] * \ n", "\ n ", $ SQL); $ buffer = array (); $ ret = array (); $ in_string = false; For ($ I = 0; $ I <strlen ($ SQL) -1; $ I ++) {if ($ SQL [$ I] = ";"&&! $ In_string) {$ RET [] = substr ($ SQL, 0, $ I); $ SQL = substr ($ SQL, $ I + 1); $ I = 0 ;} if ($ in_string & ($ SQL [$ I] ==$ in_string) & $ buffer [1]! = "\") {$ In_string = false;} elseif (! $ In_string & ($ SQL [$ I] = '"' | $ SQL [$ I] = "'")&&(! Isset ($ buffer [0]) | $ buffer [0]! = "\") {$ In_string = $ SQL [$ I];} If (isset ($ buffer [1]) {$ buffer [0] = $ buffer [1];} $ buffer [1] = $ SQL [$ I];} If (! Empty ($ SQL) {$ RET [] = $ SQL;} return ($ RET);} $ lnk = mysql_connect ('localhost', 'root', 'Password ') or die ('Connection failed '. mysql_error (); If (! Mysql_select_db ('dbname', $ lnk) {exit ();} populate_db ('dbname', '', 'abc. SQL ');?>