مساعده في SQL

[Tarek1]

السلام عليكم

شباب ممكن مساعده في ربط بين اسكربت و SQL

ال الاسكربت

?

1. conn = dbConnect( "mysql", "dbname="..tostring(EXPORTS[".sql"]:getMySQLData()[3])..";host=127.0.0.1", tostring(EXPORTS["(.sql"]:getMySQLData()[1]), tostring( exports[".sql"]:getMySQLData()[2]), "share=1" )
2.  
3. mrk = {}
4.  
5. function getPlayerID(player)
6. plid = false
7. pqr = dbQuery(conn, "SELECT * FROM players WHERE acc=? LIMIT 1", getAccountName(getPlayerAccount(player)))
8. pqp = dbPoll(pqr, -1)
9. for k, plas in ipairs (pqp) do
10. plid = plas["id"]
11. end
12. return tonumber(plid)
13. end

 

ال SQL

 

?

1. if ( tostring ( get ( "CONNECTION_TYPE" ) ):lower() == "mysql" ) then
2. outputConsole ( "Attempting to connect as MySQL... Please wait")
3. db = dbConnect( "mysql", "dbname="..tostring(get("DATABASE_NAME"))..";host="..tostring(get("MYSQL_HOST"))..";port="..tostring(get("MYSQL_PORT"))..";unix_socket=/opt/lampp/var/mysql/mysqlSOCK", tostring(get("MYSQL_USER")), tostring(get("MYSQL_PASS")), "share=1;autoreconnect=1" );
4. elseif ( tostring ( get ( "CONNECTION_TYPE" ) ):lower() == "sqlite" ) then
5. db = dbConnect ( "sqlite", tostring(get("DATABASE_NAME")) .. ".sql" );
6. else
7. error ( tostring(get("CONNECTION_TYPE")) .. " is an invalid SQL connection -- valid: mysql, sqlite" );

 

[N3xT]

الصراحة اللي فوق أشوفه حويس