Web [Tut] For all no/low SQL knowledge people

[hacker_kts]

My other tutorials:
http://forum.ragezone.com/f428/guide-setup-your-web-server-384471/
http://forum.ragezone.com/f428/guide-hex-edit-your-client-379958/
http://forum.ragezone.com/f428/guide-navicat-8-mysql-faqs-385036/

Damn, I'm sick of people keep asking the same question, what to fill up, why there's problem to connect and all those sh*t.
Now pull your ears and listen and follow the step.

The source is still under development, so stop all your fantasy of running a BIG MapleStory private server of yours. (seriously I don't get all those people advertising their MapleStory server, unless if you have a good knowledge on C++ and I wouldn't say a thing).

Download WampServer 2 -

You must be registered to see links

Run and install it, for this guide I will assume you install it to D:\Wamp

Run WampServer.exe (D:\Wamp\wampmanager.exe)

Locate WampServer icon at the bottom right of your screen, left click and click "Put Online"

After you click "Put Online" WampServer will automatically restart and put it online.

MySQL User information
By default, there's an account created once you install
MySQL Username: root
MySQL Password:
Yes, there's no password. It's blank, as simple as that.

Create MySQL database and insert the query
Left click on WampServer icon, click "phpMyAdmin".

(the icon is different from before because it had been put online)
Alternatively you can just go to

You must be registered to see links

Create a MySQL database, and name it maplestory, hit the Create button.

After your database has been created, click on SQL tab on the top.

Copy the SQL queries below,

create table users(ID int auto_increment primary key, username varchar(20), password varchar(20), pin int, gender int);

create table characters(ID int auto_increment primary key, name varchar(12), userid int, level tinyint unsigned default 1, job smallint default 0, str smallint, dex smallint, intt smallint, luk smallint, chp smallint default 50, mhp smallint default 50, cmp smallint default 50, mmp smallint default 50, ap smallint default 0, sp smallint default 0, exp smallint default 0, fame smallint default 0, map int default 0, pos smallint default 0, gender tinyint, skin tinyint, eyes int, hair int, mesos int default 0); 

create table equip(equipid int, type tinyint, charid int, pos smallint default 0, slots tinyint default 7, scrolls smallint default 0, istr smallint default 0, idex smallint default 0, iint smallint default 0, iluk smallint default 0, ihp smallint default 0, imp smallint default 0, iwatk smallint default 0, imatk smallint default 0, iwdef smallint default 0, imdef smallint default 0, iacc smallint default 0, iavo smallint default 0, ihand smallint default 0, ispeed smallint default 0, ijump smallint default 0);

create table items(itemid int, charid int, inv tinyint, pos smallint, amount smallint);

create table keymap(charid int, pos0 int default 0, pos1 int default 0, pos2 int default 2564, pos3 int default 3076, pos4 int default 3332, pos5 int default 4612, pos6 int default 5380, pos7 int default 0, pos8 int default 0, pos9 int default 0, pos10 int default 0, pos11 int default 0, pos12 int default 0, pos13 int default 0, pos14 int default 0, pos15 int default 0, pos16 int default 2052, pos17 int default 1284, pos18 int default 4, pos19 int default 1028, pos20 int default 0, pos21 int default 0, pos22 int default 0, pos23 int default 260, pos24 int default 0, pos25 int default 4868, pos26 int default 3588, pos27 int default 3844, pos28 int default 0, pos29 int default 13317, pos30 int default 0, pos31 int default 516, pos32 int default 0, pos33 int default 0, pos34 int default 3456, pos35 int default 2820, pos36 int default 0, pos37 int default 772, pos38 int default 0, pos39 int default 5124, pos40 int default 4100, pos41 int default 0, pos42 int default 0, pos43 int default 2308, pos44 int default 12805, pos45 int default 13061, pos46 int default 1540, pos47 int default 0, pos48 int default 0, pos49 int default 0, pos50 int default 1796, pos51 int default 0, pos52 int default 0, pos53 int default 0, pos54 int default 0, pos55 int default 0, pos56 int default 13573, pos57 int default 0, pos58 int default 0, pos59 int default 25606, pos60 int default 25862, pos61 int default 26118, pos62 int default 26374, pos63 int default 26630, pos64 int default 26886, pos65 int default 27142, pos66 int default 0, pos67 int default 0, pos68 int default 0, pos69 int default 0, pos70 int default 0, pos71 int default 0, pos72 int default 0, pos73 int default 0, pos74 int default 0, pos75 int default 0, pos76 int default 0, pos77 int default 0, pos78 int default 0, pos79 int default 0, pos80 int default 0, pos81 int default 0, pos82 int default 0, pos83 int default 0, pos84 int default 0, pos85 int default 0, pos86 int default 0, pos87 int default 0, pos88 int default 0, pos89 int default 0);

create table skills(charid int, skillid int, points int);

Paste at the box and click the Go button.

Create account by using phpMyAdmin
Click "users" table on the left menu.

Click the tab Insert on top, in this example I will create a an account with username test123, password 123test, and gender is male. So I will do this,

*leave the ID field empty
Click the Ok button when you're done.

When you sees this means you have successfully create your account.

Edit your database by using phpMyAdmin
For example I wanna change my password to testing123, go to your users table (click users on the left menu). Click the tab "Browse", then click the small pencil icon to edit the row.

Change your password accordingly and hit the Go button.
You're done!

Summary
MySQL Host: localhost
MySQL Username: root
MySQL Password:
MySQL database: maplestory
MySQLM.cpp (X:\MapleStoryServer\MapleStoryServer\MySQLM.cpp)

int MySQL::connectToMySQL(){
if(!mysql_real_connect(&maple_db, "localhost", "root", "", "maplestory", 3306, NULL, 0)){
printf(mysql_error(&maple_db));
return 0;
}
return 1;
}

Take note:
You aren't even suppose to make your own MapleStory public, the source is coded as to let people to development and not making it public for people to play yet. Unless you know what you're doing (with enough C++ and SQL knowledge).
In this guide your root user is without a password, don't worry about the security hole since you're not making it public.

Any question just ask here.

 

[xxlkarixx]

Re: [Guide] For all no/low SQL knowledge people

Alternatively, you can use MySQL 5.0 and for database stuff, use Query browser or Navicat

 

[tim92]

Re: [Guide] For all no/low SQL knowledge people

Alternatively, you can use MySQL 5.0 and for database stuff, use Query browser or Navicat

I use MySQL Server 6.0 and SQLYog.

 

[axess1907]

Re: [Guide] For all no/low SQL knowledge people

thanks dude nice guide

 

[willowmp]

Re: [Guide] For all no/low SQL knowledge people

thank you so much


maybe now the topics that havent been answered over and over wont bury the ones that need to be descussed

 

[jaysoNxAzN]

Re: [Guide] For all no/low SQL knowledge people

Uhh

MySQL said:

You must be registered to see links

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


Says the exact same thing when I begin loading the CMD, for the maps items etc.

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

Alternatively, you can use MySQL 5.0 and for database stuff, use Query browser or Navicat

I didn't want them to use Query browser because they will be asking the same old question, what to fill up for this fields. As for Navicat, I believe there will be at least one person saying why it expired.

Uhh

MySQL said:

You must be registered to see links

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


Says the exact same thing when I begin loading the CMD, for the maps items etc.

Check your MySQLM.cpp, make sure your information is matched with the Summary.

 

[jaysoNxAzN]

Re: [Guide] For all no/low SQL knowledge people

I didn't want them to use Query browser because they will be asking the same old question, what to fill up for this fields. As for Navicat, I believe there will be at least one person saying why it expired.


Check your MySQLM.cpp, make sure your information is matched with the Summary.

Where?

 

[clanner]

Re: [Guide] For all no/low SQL knowledge people

I say this method is easier since, well, it seems VERY simple and it won't expire either.

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

Where?

Open up your eyes and look at my post

MySQLM.cpp (X:\MapleStoryServer\MapleStoryServer\MySQLM.cpp)

@clanner:
Yes you're right.

 

[BukLaoKid]

Re: [Guide] For all no/low SQL knowledge people

wanna help me when i tick put online? D:

this is the error i get .

 

[jaysoNxAzN]

Re: [Guide] For all no/low SQL knowledge people

I can't get to the website


Welcome to phpMyAdmin 2.11.5


phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said:

You must be registered to see links

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


And is that suppose to be a racist comment?

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

wanna help me when i tick put online? D:

this is the error i get .

Maybe you are running two WampServer, press Ctrl+Alt+Del on your keyboard, go to Processes tab and end the process for wampmanager.exe

I can't get to the website


Welcome to phpMyAdmin 2.11.5


phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said:

You must be registered to see links

#1045 - Access denied for user 'root'@'localhost' (using password: NO)


And is that suppose to be a racist comment?

I don't find any racist comment, anyway did you install other SQL earlier on?
Remove them completely before you install WampServer 2, because it looks like you have have a password for your root user.

 

[BukLaoKid]

Re: [Guide] For all no/low SQL knowledge people

naw.. only one's loaded that i see.

 

[musicazx]

Re: [Guide] For all no/low SQL knowledge people

Thank you Verry verry much but how to set my char to GM ??

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

naw.. only one's loaded that i see.

Hmmm, maybe you can get support from their official forum,

You must be registered to see links

Thank you Verry verry much but how to set my char to GM ??

Read other thread about job.

 

[clanner]

Re: [Guide] For all no/low SQL knowledge people

Just wondering but how do you allow more than one person to edit the sql database? Like for example, I have a friend that wants to help manage the database, how would I allow him to connect to the database and edit it?

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

The best solution is to make a script that will do all the query, for example a administrator panel or something.

 

[hacker_kts]

Re: [Guide] For all no/low SQL knowledge people

BSoD is most probably caused by by your own computer, oh well. Glad to hear you fixed it.

 

[clanner]

Re: [Guide] For all no/low SQL knowledge people

The best solution is to make a script that will do all the query, for example a administrator panel or something.

Any idea how to do that? I would really appreciate it if you could go into detail, if not, ill check out the wampserver forums.