my website does not work

Quote:

---

Originally Posted by 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

---

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

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

Quote:

---

Originally Posted by KarLi

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:

Quote:

---

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

---

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

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

Code:

---

        $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

Quote:

---

Originally Posted by KarLi

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

Code:

---

        $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

@jacubb help him out with this small code modification lol

Quote:

---

Originally Posted by KarLi

@jacubb help him out with this small code modification lol

---

I kinda don't understand what exactly he wants.

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 = ?

---

Quote:

---

Originally Posted by jacubb

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.

Quote:

---

Originally Posted by ShakeMyShake

I just wanna know how can i give someone credit's.
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 jacubb

UPDATE MEMB_CREDITS SET credits = credits + 1000 WHERE memb___id = 'username'

---

in the website i still show me 0 credits

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];

---