- Joined
- Feb 2, 2008
- Messages
- 1,038
- Reaction score
- 11
ALL CREDITS GO TO SJIKKE!!
I will explain how did i do it, there are other ways and many other ways i will focuse in a easy way.
Get - ToPCP
ToPCP --> http://forum.ragezone.com/redirector.php?url=http://www.megaupload.com/de/?d=WVOIQER3
Install - XAMPP
First of all we will dowload XAMPP, wich will provied use a service of apache(php)/mysql and other...
Once download is done. Time to install it. Its all easy asa do next next and next. Until it finished.
Time to run it, after installit a new icon should appear in your destop.
Doble click it.
And now then where it says Apache, press start. With this now php is running.
Install - ToPCP
Now is time to "install" ToPCP, first of all after download ToPCP, and exctract it, we copy the folder where ToPCP is in. And we paste where we installed xampp.
If you didnt touch the destination, its in C: so we go to "C:/XAMPP/HTDOCS/" and paste here the folder that contains ToPCP.
With this ToPCP is alredy "installed".
To acces ToPCP you will acces like this
Configure - ToPCP
Now that that is done run the test.php how to do so?
It will give a number our case is "0" your might be different.
Then lest edit the config.php with notepad. And find this line.
Quote
if(strcasecmp($line[2],$eng_job) == 2) // YOU MIGHT NEED TO CHANGE THIS!!!
Where it says 2 put the number test.php gived to you. Ok now lets head at the start of config.php. You will see this:
Quote
$host = '5.205.63.65';
$username = 'sa';
$password = 'ola';
$chinese_jobs = false; //are the jobs stored in chinese?
$count_gm_in_top = true; // Should GMs be counted in the Top 10 lists?
$guild_name_change_price = 100000; // the amount of money it should cost for a guild leader to
The host you should put the ip you use to conect to your server.
Username -->is the sa dont not touch it.
Password -->the one from when you installed the mssql, if you dont rember, you can go change it the password in the mssql for the username sa. *IMPORTANT* maybe the password is nothing '' try it too.
Save the config.php, and go to:
If no check it all again before asking, and if its some sql problem or some query or something ask Sjikke shes de genius ^^
ERROR
Quote
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 5.205.63.65 in C:\xampp\htdocs\ToPCP\config.php on line 17
Can't connect to DB!!
If, show this your services of db are stop, start it.
-If you dont see the character and account for edit is that you logged with and account that dont have set the permisions of gm lvl to 99. If so go to the open the gamedb the table account and put the gm colum to 99 to your account
is this ToPCP compatible for 1.35 database?
Warning: mssql_query() [function.mssql-query]: message: Cannot insert explicit value for identity column in table 'account_login' when IDENTITY_INSERT is set to OFF. (severity 16) in C:\xampp\htdocs\PrivateServer\config.php on line 23
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\PrivateServer\config.php on line 23
Do this....
Third time I repeat myself. The database has changed, so it wont work that easily on the 1.35 database.
The quickest fix is this:
Look for (in reg.php)Change into
Yeay you can register accounts again!!! Hurray
I will explain how did i do it, there are other ways and many other ways i will focuse in a easy way.
Get - ToPCP
ToPCP --> http://forum.ragezone.com/redirector.php?url=http://www.megaupload.com/de/?d=WVOIQER3
Install - XAMPP
First of all we will dowload XAMPP, wich will provied use a service of apache(php)/mysql and other...
To view the content, you need to sign in or register
Once download is done. Time to install it. Its all easy asa do next next and next. Until it finished.
Time to run it, after installit a new icon should appear in your destop.
Doble click it.
And now then where it says Apache, press start. With this now php is running.
Install - ToPCP
Now is time to "install" ToPCP, first of all after download ToPCP, and exctract it, we copy the folder where ToPCP is in. And we paste where we installed xampp.
If you didnt touch the destination, its in C: so we go to "C:/XAMPP/HTDOCS/" and paste here the folder that contains ToPCP.
With this ToPCP is alredy "installed".
To acces ToPCP you will acces like this
To view the content, you need to sign in or register
in your case
To view the content, you need to sign in or register
.Configure - ToPCP
Now that that is done run the test.php how to do so?
To view the content, you need to sign in or register
It will give a number our case is "0" your might be different.
Then lest edit the config.php with notepad. And find this line.
Quote
if(strcasecmp($line[2],$eng_job) == 2) // YOU MIGHT NEED TO CHANGE THIS!!!
Where it says 2 put the number test.php gived to you. Ok now lets head at the start of config.php. You will see this:
Quote
$host = '5.205.63.65';
$username = 'sa';
$password = 'ola';
$chinese_jobs = false; //are the jobs stored in chinese?
$count_gm_in_top = true; // Should GMs be counted in the Top 10 lists?
$guild_name_change_price = 100000; // the amount of money it should cost for a guild leader to
The host you should put the ip you use to conect to your server.
Username -->is the sa dont not touch it.
Password -->the one from when you installed the mssql, if you dont rember, you can go change it the password in the mssql for the username sa. *IMPORTANT* maybe the password is nothing '' try it too.
Save the config.php, and go to:
To view the content, you need to sign in or register
and enjoy this great admin and a puer gemmer ^^ for your chars xD If all works will apear this.If no check it all again before asking, and if its some sql problem or some query or something ask Sjikke shes de genius ^^
ERROR
Quote
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 5.205.63.65 in C:\xampp\htdocs\ToPCP\config.php on line 17
Can't connect to DB!!
If, show this your services of db are stop, start it.
-If you dont see the character and account for edit is that you logged with and account that dont have set the permisions of gm lvl to 99. If so go to the open the gamedb the table account and put the gm colum to 99 to your account
is this ToPCP compatible for 1.35 database?
Warning: mssql_query() [function.mssql-query]: message: Cannot insert explicit value for identity column in table 'account_login' when IDENTITY_INSERT is set to OFF. (severity 16) in C:\xampp\htdocs\PrivateServer\config.php on line 23
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\PrivateServer\config.php on line 23
Do this....
Third time I repeat myself. The database has changed, so it wont work that easily on the 1.35 database.
The quickest fix is this:
Look for (in reg.php)
Code:
do_query("INSERT INTO account_login (id,name,password,originalPassword) VALUES ('$id','$login','$encr_pass','$pass')","AccountServer");
Code:
do_query("INSERT INTO account_login (name,password,originalPassword) VALUES ('$login','$encr_pass','$pass')","AccountServer");
Last edited: