my website does not work

[ShakeMyShake]

hey,
when im trying to enter my website (127.0.0.1) i got a error message

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 127.0.0.1 in C:\xampp\htdocs\include\class.mssql.php on line 42
Database error: connect (127.0.0.1, 123123, $Password) failed
MSSQL Error: 0 ()

Session halted.

why is that ?
i check my sql user and password and they right..i dont know why its like that ..
how can i fix it ?

[MentaL]

[KarLi]

what sql version u have?
what xampp version u have?

[ShakeMyShake]

what sql version u have?
What xampp version u have?

sql 2000
xxamp 1.7.1

[KarLi]

and what website?

[theguyontherun]

Dudde; the message is pretty clear; check your port settings to make sure that you can access the sql server.

[ShakeMyShake]

and what website?

It happend with every website that i try..

Dudde; the message is pretty clear; check your port settings to make sure that you can access the sql server.

i'm using hamachi ip

[leorond]

Hi, this is not a bug but a warning that something is wrong.

So you using Hamachi?
A MuCore you use it?

Database error: connect (127.0.0.1, 123123, $Password)

127.0.0.1 -> localhost ( Try to enter a Hamachi IP )
123123 -> Login name ( You changed the login everywhere to be changed? )
$Password -> Variable password ( You entered the correct password to the database? )

Check the information, and if there will be an error let's try to look in detail.

- - - Updated - - -

The login name that is set for MSSQL is usually "sa"

[ShakeMyShake]

Hi, this is not a bug but a warning that something is wrong.

So you using Hamachi?
A MuCore you use it?



127.0.0.1 -> localhost ( Try to enter a Hamachi IP )
123123 -> Login name ( You changed the login everywhere to be changed? )
$Password -> Variable password ( You entered the correct password to the database? )

Check the information, and if there will be an error let's try to look in detail.

- - - Updated - - -

The login name that is set for MSSQL is usually "sa"

Im using website from the Israeli community , but i'll be glad to get a download MUCore website . :)
localhost - i enter my Hamachi IP but i't still the same problem .
MSSQL - Work
SqlUser &* Password - they exactly like I've set in the SQL . (123123 , 123123)

[KarLi]

try to use mucore and see what results u get maybe ur files need another mssql addon in order to work and israeli community where u got it from didnt provide it?

[ShakeMyShake]

try to use mucore and see what results u get maybe ur files need another mssql addon in order to work and israeli community where u got it from didnt provide it?

where i can find here in this forum MuCore website download ?

[KarLi]

here + my video tutorial
https://www.youtube.com/watch?v=VnuESyrKKv0

[ShakeMyShake]

here + my video tutorial
https://www.youtube.com/watch?v=VnuESyrKKv0

it Work!!!
thank you!!!
and one last question - how can i gave Credit's Shop ?

[KarLi]

it Work!!!
thank you!!!
and one last question - how can i gave Credit's Shop ?

by the way ill give u some tips to secure your htdocs / xampp ..
1. in xampp folder delete phpmyadmin, mysql, webdav, anonymous folders.. you dont need them.
2. in xampp/htdocs i.e your mu web files delete agmcp and gmcp if u have, also delete INSTALL folder after installing it. i put it in .rar sometimes incase i reinstall my web..
3. rename admincp to admin1023u192jdqa9j2 so ppl wont inject it or find any way to eneter admincp.. thats it.

hmm what credit's shop? i think you need modules for that... just search ''MuCore credits module'' or whatever module u want and u will find no worries.

[ShakeMyShake]

by the way ill give u some tips to secure your htdocs / xampp ..
1. in xampp folder delete phpmyadmin, mysql, webdav, anonymous folders.. you dont need them.
2. in xampp/htdocs i.e your mu web files delete agmcp and gmcp if u have, also delete INSTALL folder after installing it. i put it in .rar sometimes incase i reinstall my web..
3. rename admincp to admin1023u192jdqa9j2 so ppl wont inject it or find any way to eneter admincp.. thats it.

hmm what credit's shop? i think you need modules for that... just search ''MuCore credits module'' or whatever module u want and u will find no worries.

I am grateful for your help .!
and about the credis shop , i found this
http://forum.ragezone.com/f197/modul...e-1-a-1027325/
but i didn't understand how to install that.

[KarLi]

So what you want? panel where shows how much credits you have? or VIP or what? u need to go to htdocs/muweb folder/page_modules and there u have .php files.. if u use the .php from the thread u send me it will appear in website for USERCP folder .

just need to research abit more about it

[ShakeMyShake]

So what you want? panel where shows how much credits you have? or VIP or what? u need to go to htdocs/muweb folder/page_modules and there u have .php files.. if u use the .php from the thread u send me it will appear in website for USERCP folder .

just need to research abit more about it

Look , i wanna know one thing and that's it - how can i give a credit's shop for some user.

[KarLi]

database>muonline>memb_info> find acc.. find credits table and put manually..

[ShakeMyShake]

database>muonline>memb_info> find acc.. find credits table and put manually..

ok..i put it manually.
now i put 5000 credits for some user ..
in the Query i running this:

UPDATE MEMB_INFO SET Credits= Credits + '50000' WHERE memb___id='testing'

but in the website in still show me that he have 0 credit..

[KarLi]

because in mucoins.php on usercp page modules u have this..

        $objetivo = mssql_query("SELECT ".MU_COINS_COLUMN." FROM ".MU_COINS_TABLE." WHERE ".MU_COINS_USERID_COLUMN." = '$user_auth_id'");
        while($resultado = mssql_fetch_assoc($objetivo))
        {
        echo $resultado[MU_COINS_COLUMN];

Change to

        $objetivo = mssql_query("SELECT ".MEMB_CREDITS." FROM ".MEMB_INFO." WHERE ".memb___id." = '$user_auth_id'");
        while($resultado = mssql_fetch_assoc($objetivo))
        {
        echo $resultado[memb___id];

Im not really good with mssql codes but u need to change that in that .php to read correctly and u will fix it

[ShakeMyShake]

because in mucoins.php on usercp page modules u have this..

        $objetivo = mssql_query("SELECT ".MU_COINS_COLUMN." FROM ".MU_COINS_TABLE." WHERE ".MU_COINS_USERID_COLUMN." = '$user_auth_id'");
        while($resultado = mssql_fetch_assoc($objetivo))
        {
        echo $resultado[MU_COINS_COLUMN];

Change to

        $objetivo = mssql_query("SELECT ".MEMB_CREDITS." FROM ".MEMB_INFO." WHERE ".memb___id." = '$user_auth_id'");
        while($resultado = mssql_fetch_assoc($objetivo))
        {
        echo $resultado[memb___id];

Im not really good with mssql codes but u need to change that in that .php to read correctly and u will fix it

still not working

[KarLi]

@jacubb help him out with this small code modification lol

[jacubb]

@jacubb help him out with this small code modification lol

I kinda don't understand what exactly he wants.

[KarLi]

he has that account panel module and it reads from wrong table from database, he wants to read credits from memb_info / memb_credits and in his .php it reads from MU_COINS_USERID_COLUMN or something

[jacubb]

Basically it's a global definition and you can edit value inside of config.php. Or you can simple change query for example to:

SELECT credits FROM MEMB_CREDITS WHERE memb___id = ?

[ShakeMyShake]

I kinda don't understand what exactly he wants.

I just wanna know how can i give someone credit's.
so he can buy item in the webshop , that's it.