Printable View
hey,
when im trying to enter my website (127.0.0.1) i got a error message
why is that ?Quote:
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.
i check my sql user and password and they right..i dont know why its like that ..
how can i fix it ?
what sql version u have?
what xampp version u have?
sql 2000Quote:
Originally Posted by karli
xxamp 1.7.1
and what website?
Dudde; the message is pretty clear; check your port settings to make sure that you can access the sql server.
It happend with every website that i try..Quote:
Originally Posted by KarLi
i'm using hamachi ipQuote:
Originally Posted by theguyontherun
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 )Quote:
Database error: connect (127.0.0.1, 123123, $Password)
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 . :)Quote:
Originally Posted by leorond
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)
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 ?Quote:
Originally Posted by KarLi
here + my video tutorial
https://www.youtube.com/watch?v=VnuESyrKKv0
it Work!!!Quote:
Originally Posted by KarLi
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 ..Quote:
Originally Posted by ShakeMyShake
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 .!Quote:
Originally Posted by KarLi
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.
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.Quote:
Originally Posted by KarLi
database>muonline>memb_info> find acc.. find credits table and put manually..
ok..i put it manually.Quote:
Originally Posted by KarLi
now i put 5000 credits for some user ..
in the Query i running this:
but in the website in still show me that he have 0 credit..Quote:
UPDATE MEMB_INFO SET Credits= Credits + '50000' WHERE memb___id='testing'
because in mucoins.php on usercp page modules u have this..
Code:$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
Im not really good with mssql codes but u need to change that in that .php to read correctly and u will fix itCode:$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];
Quote:
Originally Posted by KarLi
still not working
@jacubb help him out with this small code modification lol
I kinda don't understand what exactly he wants.Quote:
Originally Posted by 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
Basically it's a global definition and you can edit value inside of config.php. Or you can simple change query for example to:
Code:SELECT credits FROM MEMB_CREDITS WHERE memb___id = ?
I just wanna know how can i give someone credit's.Quote:
Originally Posted by jacubb
so he can buy item in the webshop , that's it.
UPDATE MEMB_CREDITS SET credits = credits + 1000 WHERE memb___id = 'username'Quote:
Originally Posted by ShakeMyShake
in the website i still show me 0 creditsQuote:
Originally Posted by jacubb
cuz your website .php where it reads from credits it doesnt read MEMB_CREDITS it reads other table..
retry this:
Code:$objetivo = mssql_query("SELECT credits FROM MEMB_CREDITS WHERE memb___id" = '$user_auth_id'");
while($resultado = mssql_fetch_assoc($objetivo))
{
echo $resultado[MEMB_CREDITS];