_Dark_ Posted November 20, 2011 Share Posted November 20, 2011 How to get an associative array using the standard functions? In MySQL, this mysql_fetch_assoc, but it's not in new standard functions MTA. Can be an example? Link to comment
AeroXbird Posted November 22, 2011 Share Posted November 22, 2011 Somehow my mysql login info ended up in that file, oops! If you cant work with that MySQL, you can also use the MYSQL class in mta-paradise as an example, it is very good, stable and you can learn a lot from it. Link to comment
CapY Posted November 22, 2011 Share Posted November 22, 2011 See here Who made this Qaisjp ? http://code.google.com/p/mta-freeroampl ... ection.lua Link to comment
AeroXbird Posted November 22, 2011 Share Posted November 22, 2011 See here Who made this Qaisjp ? http://code.google.com/p/mta-freeroampl ... ection.lua I added that in the userpanel because i had this code laying around, it can be removed though, because the userpanel doesnt use MySQL.. Link to comment
AGENT_STEELMEAT Posted November 22, 2011 Share Posted November 22, 2011 Somehow my mysql login info ended up in that file, oops! A bit off-topic, but important nonetheless: You should never use the root account for your MTA server (or anything in general other than database administration). You should always create a MySQL user for your MTA server, and limit their permissions (i.e making it so they can't use 'DROP TABLE accounts' and modify other tables not related to the MTA sever). If you know for a fact you will only be using your database locally, limit your MTA server's MySQL account to localhost - that way, even if your MySQL credentials are leaked, remote users can not access your database. Link to comment
AeroXbird Posted November 22, 2011 Share Posted November 22, 2011 Somehow my mysql login info ended up in that file, oops! A bit off-topic, but important nonetheless: You should never use the root account for your MTA server (or anything in general other than database administration). You should always create a MySQL user for your MTA server, and limit their permissions (i.e making it so they can't use 'DROP TABLE accounts' and modify other tables not related to the MTA sever). If you know for a fact you will only be using your database locally, limit your MTA server's MySQL account to localhost - that way, even if your MySQL credentials are leaked, remote users can not access your database. lolol, like i dont know that, its just for local testing, any servers that i run have accounts limited to only updating, selecting and inserting. Link to comment
qaisjp Posted November 23, 2011 Share Posted November 23, 2011 See here Who made this Qaisjp ? http://code.google.com/p/mta-freeroampl ... ection.lua Why, thinking I'm a pirate using radical gaming stuff? 1. I am a pirate 2. No, it's not mine Link to comment
_Dark_ Posted November 23, 2011 Author Share Posted November 23, 2011 I know how to work with MTA-Module. I want to learn work with standard tools. dbConnect, dbPoll, etc. Link to comment
CapY Posted November 23, 2011 Share Posted November 23, 2011 See here Who made this Qaisjp ? http://code.google.com/p/mta-freeroampl ... ection.lua Why, thinking I'm a pirate using radical gaming stuff? 1. I am a pirate 2. No, it's not mine LOL! Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now