t3jem
Mar 7 2008, 02:29 AM
Hi, I'm trying to build an online game and figured the easiest way to do the server list would be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my website and I always get an abnormal program termination; however, it will work with the mySQL on my own machine. The code is below: CODE #include <iostream>
#include <iomanip>
#include <mysql++>
#include "pass.h"//holds my password (i program at school)
int main(void)
{
Connection con("t3jem3_test","64.69.46.210","t3jem3_t3jem",pass);
Query query = con.query();
query << "SELECT * FROM test";
Result res = query.store();
Result::iterator i;
Row row;
for(i = res.begin(); i!=res.end(); i++)
{
row = *i;
cout << setw(6) << row["id"] << setw(10) << row["sname"] << endl;
}
::Sleep(5000);
return 0;
} This code was taken almost straight out of my multiplayer games programming book. Other vital info: The site my database is hosted on it right here at trap17 (t3jem.trap17.com). Any help is appreciated, thanks in advance!
Reply
sonesay
Mar 7 2008, 02:35 AM
I dont think trap17 allows mysql connections outside its own server. That could be your problem, try running a local mysql server and see if it works for you there.
Reply
jlhaslip
Mar 7 2008, 03:25 AM
The correct name for the mysql server is "localhost" and the above post by sonesay is correct in that you will not be able to connect to the Trap17 Mysql Server from your own Desktop Command Prompt or from your school. The Mysql server is only available via your Trap17 Hosting Account Cpanel, or a script in one of your files on your account.
Reply
t3jem
Mar 7 2008, 04:25 AM
Alright, thank you very much, at least I know what's wrong now. I will try and figure something out then. Thanks again!
Reply
maplestory
Apr 18 2008, 09:39 PM
im not sure i think it only alows sub mysql witch is easy to do 1. open mysql Query Browser press tools MySQL admin. 2.window should pop up press user admin. 3. click add user make ID pw . 4.then go to schema priv and let it have what u want like acount making and all after done. use it to log in to ur things. if this wont help im not sure
Reply
coolcat50
May 15 2008, 08:34 PM
Well, you could always get one of these free MySQL hosting solutions if you wish to have external MySQL. I believe one is http://freemysql.net could do what you want. They have it configured for other websites to be able to use their MySQL.
Reply
exemption
Jul 4 2008, 04:48 AM
Lol If you need help PM me, unless you have figured the problem out already
Reply
galexcd
Jul 4 2008, 05:27 PM
I suggest using php to create a secure backend that your game can connect to and send and load data from. This way you shouldn't have any issues with permissions.
Reply
Recent Queries:--
travian map.sql schema - 53.04 hr back. (1)
-
mysql tutorial windows form - 79.82 hr back. (1)
-
how to connect to freemysql with java - 95.58 hr back. (1)
-
mysql does not work - 98.53 hr back. (1)
-
adapter "mysql" is not available - 99.95 hr back. (2)
-
joomla the mysql adapter mysql is not available - 100.66 hr back. (1)
-
database error: unable to connect to the database:the mysql adapter "mysql" is not available. - 106.54 hr back. (3)
-
mysql result showing unwanted characters - 121.95 hr back. (1)
-
database error: unable to connect to the database:the mysql adapter "mysql" is not available. linux - 127.49 hr back. (1)
-
mysql cannot connect - 150.48 hr back. (1)
-
unable to connect to the database:the mysql adapter "mysql" is not available. - 20.24 hr back. (2)
-
freemysql 2008 - 162.19 hr back. (1)
-
joomla unable to connect to the database:the mysql adapter "mysql" is not available. - 167.77 hr back. (1)
-
creating a database with mysql - 168.25 hr back. (1)
Similar Topics
Keywords : database, mysql, mysql, work, trap17
- Mysql Hacks
(1)
Database Normalization
(0) For those of you... who really reall Ok... I am sharing to trap17 an easy to use image file to
brush up your understanding of database normalization. Everytime I have to understand the concepts,
I have to go through the complete text and its a little hard to do that... Had some requirement
recently, and I thought I will prepare something like this and refer to, when there are future
requirements. This is not exhaustive and very detailed. Helps to get some basic understanding. Prior
knowledge about the databases, structure will help in understanding the complete concepts....
Creating A Php Login System Using Mysql
I need help in creating a login system, what I want is a login system (10) Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
personalised page for each user and when they login the system transfers the user to their page.
Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
The Only Reason I Choose Ms Sql Server Rather Than Mysql
(0) The only reason i choose ms sql server rather than mysql is, MS SQL has more security
features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I
developed some application to support chinese letter, and dont know how to build one in mysql - Lack
in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like
BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
favourable is - it is free! Dont u guys agree?....
Need Advice On Setting Up Mysql Database.
I have a huge amount of daily data updates to be inserted. (4) First of all, to get the idea of what I am trying to achieve here, please have a look at my
idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
file for how to make use of the map.sql data located on the help.travian.com website, which also
gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
Database Or Pdf
Best way to list books on my site (3) Hi all, I am not sure if this is the right place to post but I'm sure you'll tell
me if it's not. My problem is this: I have a website where I sell books and it's one of
those simpleton sites where I don't need to know code, I just click icons etc Anyway, I can
upload images to the server and need to have them in different resolutions and link from a thumbnail
to the larger picture. What I am trying to say is I have about 6000 books to display on my
website which is impractical as it takes me about 10 mins to load 1 copy. What is the ....
The Best Free Php Mysql Blog
any idea (5) Hi everyone Recently i tried to upload a personal blog. as I know a bit of PHP programming I was
looking for a free open source PHP blog. first I tried Wordpress out but there was few problems
that i needed to change php.ini or .htaccess file and also some other PHP settings. as i was trying
it out on a free web host i didn't have access to php.ini. so i have changed it from Wordpress
to bblog , i have installed it successfully and i followed it's safety instruction (deleting
install folder and install.php and CHmod config.php )then i got another problem i ....
Mysql-essential-5.0.51 Installion Problem
please help me.(urgent) (2) Dear friend, please help me. Iam working on php project (matchmaking site). I have downloaded mysql
essensial 5.0.51. When i was installing mysql 5.0.51, i got following error - Error 1901: Error
attempting to read from the source installation database:
c:\windows\installer\527ec6.msi What is solution of this problem ? Iam using
windows xp professional version 2002 (service pack 2). Please post your reply. Iam waiting for your
answer. ....
What Value Would I Use To Insert This Data?
Help on insertion of data to database? (4) I am learning slowly but surely and I know some of you probably getting tired of my questions. ^^;;
However, I believe one can not learn without asking questions. So.. if I get too bothersome.. just
point me to some books or something. lol XD // Make a MySQL Connection mysql_connect("localhost",
"name", "password") or die(mysql_error()); mysql_select_db("at2927_abq") or die(mysql_error()); //
Insert a row of information into the table "example" mysql_query("INSERT INTO members (pasture)
VALUES('Timmy Mellowman', '23' ) ") or die(mysql_error()); ....
Mysql Query Problems
I need some help or a tutorial? (6) I seem to be having trouble with getting my Query to post my user's ID numbers. CODE //
Make a MySQL Connection mysql_connect("localhost", "user",
"password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error()); // Retrieve
all the data from the members table $result = mysql_query("SELECT * FROM members WHERE
id='$id'") or die(mysql_error()); // store the record of the
id table into $row $row = m....
Php With Simple Csv List As Database, What Do U Think?
(2) I've designed a php website and i used simple CSV file as my database because of few reasons
my client had to pay more to active MySQL database was a simple product list it was easy to
convert product list from existing Excel file to CSV it is easy to make any changes so i have few
files to convert to CSV if i wanna update the website. I know it's less secure specially if
it's an online business (which is not). question is : what are disadvantages? is that slower
than MySQL? is there more possibility of occurring bug? is that less professional? or ......
Forum Database
Forum Database Space and its capacity to hold content (9) Okay, I have a forum which is growing daily. Even though members aren't that many, I'm still
concerned over my database space and its capacity to hold the forum's content. Since post counts
take up database space, the remaining space will decrease daily, albeit by little amounts. Still, it
will decrease anyway and eventually my database for that forum will run out of space. My question
is: 1. Is there any way to possibly create a new database to continue holding the old
database's increasing data? As in, my old database is there but its full and I creat....
Database Migration - Seditio To Joomla
any help is needed (1) Hi guys! I was desperately looking on internet for any help with migrating Seditio database to
Joomla.. I`m admin on site which has more than 2500 members and day by day I get annoyed by
pretty dumb solutions in Seditio.. can anyone tell me how to migrate the seditio site to joomla?
any tutorials on internet on database migration? thanks....
Best Database Software?
(1) I'm quite new to creating and managing databases - yesterday I installed Filemaker Pro 9 and my
initial thoughts are that it's amazing! Only just starting to get to grips with it - think
it'll take some time to master it. What Database software do others use and what do people
think of Filemaker Pro? Advantages/Disadvantages? ....
Mysql Datatype Int() Question
Not sure what value to use inside int() (1) Can anyone clarify what the value in int() actually does? CREATE TABLE job_class ( jc_id int(1)
NOT NULL AUTO_INCREMENT PRIMARY KEY, jc_index int(2) NOT NULL, jc_name varchar(20) NOT NULL, jc_type
varchar(20) NOT NULL ); I was under the impression that any integer value used inside a () was
the limit that data-type would have. In the PRIMARY KEY column I was able to add integer values
1-18. I'm kinda confused now If I can add 2 digit integers there then what is the point of
assigning values inside brackets() For the varchar() any number put in there does limit....
Mysql
(7) Hi... One of my hosts hasnīt MySQL but i need to develop a login system so I need to know if itīs
possible to use a MySQL database intalled in another host... If itīs possible can you explain me how
to do it? Thanks in advance....
Loading File Into Blob Fields To Mysql
(1) Hi all! does any know how to load file into blob filed by sql script?....
Questioning My Database Structure...
(4) Okay, I posted a brief description of this in the PHP section, but I'll summarize myself again.
I'm creating a PHP based game that is an economy game, where you start out with so many
resources and a building, and you expand your business empire by building more buildings, which puts
out more resources, and you can buy and sell on the market and whatnot. In the end, you try and
become the wealthiest player in the game. Now I already have most of my database in MySQL set-up.
But I've been told several different things on my structure and wanted your guys'....
Mysql And Sql
difference??? (7) I was wondering what is the difference between MySQL and SQL. I was really confused when i planned
to do a project recently. This question has haunted me for a long time. Is it both same?....
How To Connect Site To Database? [resolved]
(12) I created a table in phpmyadmin, i copied the code in a file and uploaded this file onto the host.
Now it says that it cannot connect to the database. The error lies within
"mysql_select_db($db)" => so i think this means that it cant find the database? If anyone knows
how to let my login and register forms connect to the database, please help me. I used a login
system from this site, ill post the link later.....
Exporting Database Problems
(3) On the host I moved here from, I have a database that I would like to transfer. On this host I am
unable to use PHPMyAdmin, but I have MySQL-Admin 3.3 that works fine. But the main problem is the
host. Recently they made it so you there is only a 1mb upload limit, and also that MySQL temporarily
will not operate properly. Which is basically why I want to get off that host. Anyway, I can export
each of the small tables easily. But I have tables that are over 2mb, and I do not know how I can
get them. When I click on "Show table", the table starts to load, but then it sto....
Mysql Database Copying
(4) Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and
the bridge is not working like the Joomla! one does. (with the seperate db capability) i know
how to transfer all the tables by hand but depending on how much data you have stored in mysql could
take a long time. Take short time!? Help me!....
Joomla Sql Error: Connection To Database Server Failed.
(1) Hi Today I got this error-message in back-end on my Joomlasite hewwelub.trap17.com/d-lan/
QUOTE This site is temporarily unavailable. Please notify the System Administrator Connection to
database server failed. This is the first time I get this error, and I don't want or have
the time to reinstall the site with all its features... The only time I have seen this problem yet
is when I tried to unpublish a menu item. Any answer would be to great help, thanx /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
Connecting Php With Oracle Database
(1) i need to connect oracle with php ..now me using oracle 10g can any one give me the solution
thanks.....
Mannual Creation Of Oracle Database
(0) Manual Creation of database in windows with oracle 9i (Step-by-Step) (Name of the database=db18)
(Note: all commands are in bold letters) 1. Open the command prompt and execute the command
sqlplus/nolog 2. Connect to the default database as sysdba in sql prompt SQL>conn sys/oracle as
sysdba you can see the name of that database by executing select name from v$database; 3. Now
open another command prompt and set oracle SID as set oracle_sid=db18 4. Start a windows service
with internal password oradim new sid intpwd is the syntax. In this case I use ceylonlinux....
Installing Mysql On Unix, Linux
(2) Download the latest version of MySQL.Choose the latest stable release and, from the stable release
page, choose the option under "Source Downloads" marked "tarball (.tar.gz)". Download the file into
a directory where files can be created and there is sufficient disk space. A good location is /tmp.
Change directory to this location using: 1. % cd /tmp Note that the % character
should not be typed in; this represents the Linux shell prompt and indicates that the command should
be entered at the shell prompt. 2. Uncompress the package in the new ....
Mysql Tools Database
Opensource sql tools... (1) You can download mysql query web browser on http://www.mysql.com you also can download plugin
there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make
and maintance youre database sql easily because use gUI interface..!!....
Looking for database, mysql, mysql, work, trap17
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for database, mysql, mysql, work, trap17
*MORE FROM TRAP17.COM*
|
advertisement
|
|
