Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
You last visited: Today at 02:27

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[HELP] mssql connect to register

Discussion on [HELP] mssql connect to register within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
[HELP] mssql connect to register

How I know my DatabaseIP for connect my register from here :


Thanks
white95260 is offline  
Old 05/25/2014, 07:11   #2
 
elite*gold: 0
Join Date: Apr 2012
Posts: 33
Received Thanks: 7
Your database IP is 127.0.0.1, unless you host databases on other server different than you server files.


Example, if you have ShaiyaServer and MSSQL databases on the same PC or same VPS(Virtual Private Server, used for making Shaiya public), then you will use 127.0.0.1 as database IP, but if you have ex. 2 VPSs, 1 for your server files and second for databases, then you will need to change it to IP of second VPS, the one that hosts databases.

Hope I helped you.
kollegga is offline  
Old 05/25/2014, 09:45   #3
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
I see, thanks :P

But why I had this error : Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\processor.php on line 10 ?
white95260 is offline  
Old 05/25/2014, 12:27   #4
 
elite*gold: 0
Join Date: Apr 2012
Posts: 33
Received Thanks: 7
Your login info is most likely wrong. Make sure you created new login at SQL Managment Studio with username "Shaiya" and password "Shaiya123".

To do that, go Managment Studio, expand "Security" and right click on "Logins" and add new login.

username: Shaiya
password: Shaiya123

Enforce password policy must be checked, uncheck two other options below it.
kollegga is offline  
Old 05/25/2014, 12:32   #5
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
It's already does, I have a login called Shaiya :
username : Shaiya
password : Shaiya123

How I can do? :S
white95260 is offline  
Old 05/25/2014, 22:28   #6
 
elite*gold: 0
Join Date: Apr 2012
Posts: 33
Received Thanks: 7
Oh wait.

You are using Abrasive scripts?

What version of XAMPP do you use?

Abrasive scripts work with php_mssql.dll plugin, you need XAMPP with PHP below 5.3, because it is not longer supported in higher versions of PHP.

I suggest you to use XAMPP 1.6.5.

Post results here.
kollegga is offline  
Old 05/26/2014, 14:31   #7




 
Autrux's Avatar
 
elite*gold: 1
Join Date: Dec 2010
Posts: 33,282
Received Thanks: 5,715
Arrow Shaiya PServer Guides & Releases -> Shaiya PServer Development

#moved
Autrux is offline  
Old 05/29/2014, 10:18   #8
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
Worked fine thanks you :P
white95260 is offline  
Old 05/29/2014, 20:17   #9
 
Blober's Avatar
 
elite*gold: 0
Join Date: Mar 2014
Posts: 194
Received Thanks: 67
Abrasive scripts are not using "mssql"

Exept old releases, they are all using odbc. So i don't why you are trying to use an old mssql script from abrasive till all of his scripts are working with odbc.

Just use new ones and not olders.

And he is not using abrasive scripts. But he should. Till the script he is using is 4 years old.
Blober is offline  
Old 05/29/2014, 23:14   #10
 
elite*gold: 0
Join Date: Apr 2012
Posts: 33
Received Thanks: 7
Quote:
Originally Posted by Blober View Post
LOL!!! Make me laught!

Abrasive scripts using "mssql"???!!!

Exept old releases, they are all using odbc. So i don't why you are trying to use an old mssql script from abrasive till all of his scripts are working with odbc.

Just use new ones and not olders.

And he is not using abrasive scripts. But he should. Till the script he is using is 4 years old.
Problem?

I forgot which of these many scripts use which method. So? He's not using his scripts, so?

Did I help him? Yes.

Did you help in anything besides you made yourself look like a ******? No.

Kthnxbye.
kollegga is offline  
Thanks
1 User
Old 05/30/2014, 09:53   #11
 
Blober's Avatar
 
elite*gold: 0
Join Date: Mar 2014
Posts: 194
Received Thanks: 67
Sry. Changed my post.

But his problem has been answered many and many times.
He could search before asking.

It's why there is a search button.
Blober is offline  
Reply


Similar Threads Similar Threads
Register MsSQL Problem
02/23/2013 - Web Development - 0 Replies
Hallo zusammen, ich habe seitdem ich in meiner DB eine neue Spalte hinzugefügt habe, probleme beim registrieren, undzwar erstellt er den Account nicht mehr. Zum registrieren benutze ich eine Prozedur. Ich habe gestern eine neue Spalte hinzugefügt ( uid, mit AI ). Seitdem kann ich mich aber nicht mehr registrieren. Hier mal die ganzen Codes: register ( nur die query ):
[Frage]Mssql Remote Connect
06/14/2012 - Web Development - 1 Replies
heyho liebes Forum. :3 Ich beschäftige mich nur mittelmäßig lang mit Mssql, aber hätte mal die Frage, wie man dort einen Remote Connect einrichtet (den man dann logischer Weise auch via PHP nutzen kann)? Bevor ich irwas kaputt mache, frage ich lieber erst einmal. ;) mfg.
How to remote connect to mssql database?
10/29/2011 - SRO Private Server - 3 Replies
How can I connect to dedicated server's mssql database? sqlserver2005 express edition + sql managment studio installed on both computer (dedi server and my pc) sqlbrowser enabled and running tcp/ip enabled, remote connections enabled i tried connecting like serverip:port serverip\sqlexpress serverip:port\sqlexpress serverip
helping php iss users with mssql connect
10/20/2011 - Shaiya PServer Development - 44 Replies
i have not see anyone realy helped with this one. but after what i have seen you need: In versjon 5.3 of PHP was the support for php_mssql.dll removed. This uses mssql_connect() that all php files out here uses. PHP and microsoft recomend is "Microsoft Drivers for PHP for SQL Server". this has a close syntax, but have other names. to conect you need this. <?php
MSSQL-connect Problem
07/02/2011 - Flyff Private Server - 0 Replies
Ich versuche seit einer Stunde Treachery CS-Shop zum laufen zu kriegen, aber ich schaffe es einfach nicht das PHP sich endlich mal meinem Willen beugt und sich mit meiner DB verbindet... Ich gebe in die config.php datei brav meine Daten ein, allerdings will es trotzdem nicht klappen... http://img18.imageshack.us/img18/2105/mssql.png http://img220.imageshack.us/img220/8788/configr.p ng http://img31.imageshack.us/img31/7397/resultata.p ng Wäre echt nett, wenn mir jemand einen Tipp geben...



All times are GMT +2. The time now is 02:27.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.