Guide/Release: Conquer Server (CoFuture) Using MySql!

03/03/2008 13:01 leavemealone#466
Quote:
Originally Posted by BFsilas View Post
$sql = "INSERT INTO accounts VALUES ('$_POST[regwho]', '$regc', '2', '1', 'null')";
The server is not going to be updated, Korvacs and i have got our own seperate projects much further in progress and using new Conquer Client which is for personal use, Source will not be public released unless stated in the future.

For your php script instead of yours try using the following method.

PHP Code:
$createusername=$_POST['name']; 
$createpassword=$_POST['password'];
$sql="INSERT INTO `accounts` ( `Username`,`Password`,`Etc` ) VALUES ('$createusername','$createpassword','insert')" or die("error: " mysql_error() . "\n"); 
This query will work if you correct the rows and input data etc, thats just a simple eg.
03/03/2008 20:22 mopsio#467
I'm little don't understand it. I wanna make server only on PVP, no mobs, just NPC.
But I've don't understand that guide.
I am on step 2. When I had opening PHPmyadmin message me :


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

What can does it mean? Can u help me?

Sorry for mine bad english.
03/04/2008 01:19 liquid1234#468
i got one problem...when i try run my server got one error...can anyone give me one solution??

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
03/04/2008 03:46 leavemealone#469
Make sure Database='Correct Name' and ur username/passwords are correct to the database, those errors just showing that you are using wrong login info.
03/06/2008 19:21 ahmedzaki123#470
thanks but i need the fil itemtyp pleas..
03/06/2008 20:01 damianpesta#471
Tha fuck dude ! u dun need any itemtype and ur english is bad only things u need in this guide is : client ,server files,some patience,good english, and u will be fine
03/08/2008 15:20 probitch18#472
ok i set up all ports on my router in db server is localhost nd same in server.dat i copyed my co client and patched it to 4348 but..... when i try login i get failed due to maint....
03/09/2008 00:49 xxnikexx#473
Quote:
Originally Posted by probitch18 View Post
ok i set up all ports on my router in db server is localhost nd same in server.dat i copyed my co client and patched it to 4348 but..... when i try login i get failed due to maint....
Make sure that ur ServerName and ip are same in Server.dat and in database!
03/10/2008 06:50 leavemealone#474
Thanks for answering his question :D
03/10/2008 15:08 instrance#475
Thank you for this great release :-). Was wonder if there are any mob files available?
03/10/2008 17:10 instrance#476
Where in the sql db could i change the status of the Job on my char?
03/10/2008 17:38 HolyMage#477
Quote:
Originally Posted by instrance View Post
Where in the sql db could i change the status of the Job on my char?
Why would you want to when there is command to change it in the server.

Code:
                        else if (Splitter[0] == "/job")
                        {
                            Client.Char.Class = (ClassType)(Convert.ToInt32(Splitter[1]));
                            Client.SendData(CPacket.Status(Client.Char, 1, (int)(Client.Char.Class), StatusTypes.Job));
                            return 2;
                        }
So type /job <job Number>

10,InternTrojan
11,Trojan
12,VeteranTrojan
13,TigerTrojan
14,DragonTrojan
15,TrojanMaster
20,InternWarrior
21,Warrior
22,BrassWarrior
23,SilverWarrior
24,GoldWarrior
25,WarriorMaster
40,InternArcher
41,Archer
42,EagleArcher
43,TigerArcher
44,DragonArcher
45,ArcherMaster
100,InternTaoist
101,Taoist
112,MetalTaoist
113,MetalWizard
114,MetalMaster
115,MetalSaint
122,WoodTaoist
123,WoodWizard
124,WoodMaster
125,WoodSaint
132,WaterTaoist
133,WaterWizard
134,WaterMaster
135,WaterSaint
142,FireTaoist
143,FireWizard
144,FireMaster
145,FireSaint
152,EarthTaoist
153,EarthWizard
154,EarthMaster
155,EarthSaint
190,InternTaoist
191,Taosit
192,GeneralTaoist
193,Wizard
194,Master
195,Saint

30,Knight

But you really need to just got sql database click chacaters tab in conquer_server database go to browse than edit the charcater you would like, than go to class and change it to the class you would like above.

P.S
I have did all the steps and read ever post on how to make line 317 of Start.cs work and I know I am not a noob at doing this but it just still won't work have no clue.
03/10/2008 20:08 instrance#478
How can i bring my bow level up?
03/11/2008 07:26 walmartboi#479
Yeah, very good release, but with the account creator that one guy created, how do you put it on your site? Thanks in advance
03/11/2008 09:33 leavemealone#480
You upload the script to your site?.. and set it to your dbs user/pass and ur ip.