'LinKin

Hello, I had a dilema whether post this on Hosting Solutions section or here, I've decided here is better. So, today when I was sharing a script with someone who hosts his server in someHost, and I found out that his server was not able to connect to my database remotely. So he decided to buy another server from anotherHost and I found out that this time it was working, so the server was connecting normally to the database. Later on, I found another guy who hosts his server at someHost too, and I could verify that the 'problem' was coming from the hosting company. Do you guys know why this happen? I'm thinking to e-mail someHost and ask them why this happens. I've this script working in other 3 servers, and it works normally.

This is so wierd! I totally agree with that.. Yesterday it wasn't connecting, but now it does.. and I've made no changes at all, I just openned the my.cnf file looking for something that could help, but didn't actually modify anything. Today I woke up and found out that the was server connected to the database, and now I've verifed, and yeah it works completely. I'm not even connecting as localhost or 127.0.0.1 but I'm using the server's IP as the host parameter. dbHandler = dbConnect("mysql", "dbname=randomName;host=myVPS_IP", "username", "password", "share=1") All of a sudden it works.. this is strange. And to answer your question: When I commented that line I restarted the mysql server, not the whole VPS. (I'm using LAMP)

Do you understand the thing about bandwidth?

Here, all the combinations I tried: dbHandler = dbConnect("mysql", "dbname=randomName;host=localhost", "username", "password", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=127.0.0.1", "username", "password", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=localhost", "root", "vpsPassword", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=127.0.0.1", "root", "vpsPassword", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=localhost", "root", "mysqlPassword", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=127.0.0.1", "root", "mysqlPassword", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=localhost;port=3306", "username", "password", "share=1") dbHandler = dbConnect("mysql", "dbname=randomName;host=127.0.0.1;port=3306", "username", "password", "share=1") Everything returns "Could not connect to the database" Another relevant data is: to allow remote access I edited something at /etc/mysql/my.cnf I commented this line: bind-address = myVPS_IP So it's like this now: #bind-address = myVPS_IP

Hello, Guys I'm confused with something, in OVH VPS plans they say: So Idk how it works.. I was wondering if there's someone here who hosts his server(s) in OVH so that I can check how fast the in-game download is. Thanks, Linkin.

Ubuntu 12.04 64-bit /usr/lib/ And worked

Same

Still the same, do I need to restart the whole VPS?

Oh no.. It still doesn't work. I tried these as the hosts: localhost, 127.0.0.1 Tried this as the usernames: root And these as the passwords: thePassOfVPS, thePassOfPhpMyAdmin Also tried with port=3306 I combined them, but none worked

Hello, I get this Error when I start the server. Could not load /root/VPS3/mods/deathmatch/./dbconmy.so - libmysqlclient.so.15: cannot open shared object file: No such file or directory How can I solve it? Downloading some libraries? I installed these libraries when I got the brand new VPS, so around 2 months ago. apt-get install build-essential automake libtool libcurl4-openssl-dev libpcre3-dev apt-get install libsqlite3-dev libreadline5-dev subversion libncurses5-dev apt-get install libncursesv5 libsparsehash-dev libmysqlclient-dev apt-get install lib32readline5 apt-get install lib32cursesv5 Thanks.

Thanks mate!

Here's not a place to request scripts, you should give a look at the community resources

Hello, I've a VPS, and I made a database with public access, all my scripts work fine (I'm using them in external servers / not the servers that are hosted in the VPS) and they work flawlessly, but now, I just found out that they don't work on the servers that are hosted in the same VPS. I'm using dbConnect and I provide the IP / pass / username , etc... How could I connect to the db when I'm running the script in a server on the same VPS? Maybe not using the IP but localhost? And by the way why is it like this? Shouldn't it work with the IP too? Thanks.

Thank you

Hello, I found this somewhere in this forum What do they mean by that? Thanks,

Hello, How can I iter character by character of a string? Like: "This_String_For_Example" I want to check one by one each character. Thanks.

I see no other solution that not letting % character be input in the text to make the search. Thank you

Hello, When I am going to search the row(s) where a column matches this symbol: % MySQL returns me every row from the Database! But it doesn't return me the value of the column where I search for the matches. I'm using this code to make the searches: local theQuery = dbPoll(dbQuery(dbHandler, "SELECT * FROM `myTable` WHERE `myColumn` LIKE ?", "%"..theArg.."%"), -1) Note that the variable 'theArg' is the string that I'm looking matches for. So in this case it is '%' I've seen that % symbol has a special use in MySQL, however I don't understand what it really does.

Tested these two examples but any of them is giving a 100% result. So I was thinking to make a custom table in which I'd put the symbols that are accepted, but how can I check if a character from a string matches with any of the symbols previously defined? Basically, how can I loop character by character into an string?

Windows servers don't have console access, if they do, you cannot execute commands on it. Linux servers do have a console access, and you can perform actions through it. Vortex doesn't have console access because their servers are Windows, as well as Sane-Hosting. About th other companies I can't say anything.

Wasn't 1.4 coming soon? Then I read something wrong somewhere, lol.

Oh oh.. OOP in MTA.. Finally, I can keep practicing what I learnt 3 semesters ago After boring structurated programming, OOP is comming. It is a really great improvement for programmers a.k.a scripters

Lua is light, fast, is used by a good amount of videogames and some recognized videogames companies.

Bumping this topic...

local theQuery = dbPoll(dbQuery(dbHandler, "SELECT * FROM `myTable` WHERE `nicknames` LIKE ?", "%"..theArg.."%"), -1) Solved the thing. Now, should I use a fulltext index in the 'nicknames' column? To make queries be faster