Website by Leandro-Iron

[LeandroIron]

I have found a "bug".
The Confirm donations sistem doesent work
I am going to explai detailed right now
I seted up the site to use the paypal system so users can donate/purchase with money coins

So o user choses to buy some coins
He will go here
Attachment 94902

After that he will have to Confirm the purchase
Attachment 94903

so an site admin will Aprove it or denie it if the tranfer is succesfull or not
Attachment 94904

If the admin confirms it the cahs is not given to the user as it should be.Normal that should be the functions.So i checked the file structure and i found in the sisConfirmDonate.php from the _administrador folder of the site that the mssql query does not insert any data in the CabalCash database where the coins(in my case) are stored.
here is the query

if($_POST['sbmtConf']) {
$txtCod = $_POST['txtCod'];
    $sql = "UPDATE ".DB_ACC.".dbo.CADDONATE Set 
                  ckEntrega = 1,
                  DataEntr = getdate(),
                  RespEntr = '".$txtLogin."'
                  where CodDon  = '".$txtCod."'";
                $sql_result = mssql_query($sql);
     echo '<script>alert(\'Donation successfully confirmed !\'); location=\'sisConfirmDonate.php\'</script>'; 
mssql_close();
    } 

To make this work it must insert in the databse CabalCash in the field Alz and to the correct UserNum.
I tried some ways but couldnt make it work.
I would apreciate some help.
Thanks

Hello
Use these codes and see if it solves your case

if($_POST['sbmtConf']) {
    
$txtId  = $_POST['txtId'];    
$txtCod = $_POST['txtCod'];
$txtQntCash = $_POST['txtQntCash'];
 $sql_verifica = mssql_fetch_row(mssql_query("SELECT UserNum FROM ".DB_ACC.".dbo.cabal_auth_table WHERE ID = '".$txtId."'"));
    $sql = "UPDATE ".DB_ACC.".dbo.CADDONATE Set 
                  ckEntrega = 1,
                  DataEntr = getdate(),
                  RespEntr = '".$txtLogin."'
                  where CodDon  = '".$txtCod."'
            UPDATE ".DB_CSH.".dbo.Bank Set
                  Alz = Alz + '".$txtQntCash."'
                  WHERE UserNum = '".$sql_verifica[0]."'";
                $sql_result = mssql_query($sql);               
     echo '<script>alert(\'Donation successfully confirmed !\'); location=\'sisConfirmDonate.php\'</script>'; 
mssql_close();
    } 

[m2tuu]

Hei with that webpage comes webshop to right? if so how webshop lookslike?

[xXxAxXx]

the webshop is not included.You will have to use a premade webshop

[elvise]

if i try login show this message

Warning: Cannot modify header information - headers already sent by c:\xampp\htdocs\index.php:34

and 1 more where i can edit or delete news message?

[Yamachi]

if i try login show this message

Warning: Cannot modify header information - headers already sent by c:\xampp\htdocs\index.php:34

and 1 more where i can edit or delete news message?

Please read the thread before replying. Thank you.

[walkernight88]

if i try login show this message

Warning: Cannot modify header information - headers already sent by c:\xampp\htdocs\index.php:34

and 1 more where i can edit or delete news message?

Delete everythin before "<?PHP" (PHP Starting tag). It should work.

[djguncha]

how to fix it so stats are not left on 50.
and would not allow the PNT to present


I want everything to remain as a standard

[Yag4mi2k]

error date, check print

Uploaded with ImageShack.us

[xXxAxXx]

you have to edit the code to display the corect timezone of your server

[cabalboy]

can you make php code to see the items of all the players in the rankings ?

[Yag4mi2k]

error date, check print

Uploaded with ImageShack.us

can anyone help me with this error?

sisGeral.php

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'CASHSHOP.dbo.Bank'. (severity 16) in C:\AppServ\www\sisGeral.php(2) : eval()'d code on line 118

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\sisGeral.php(2) : eval()'d code on line 118

Warning: mssql_fetch_row(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\sisGeral.php(2) : eval()'d code on line 119

[allocen]

It says that in CASHSHOP database table Bank does not exist.

[xXxAxXx]

Yag.. try to fill the cashshop with some data(items)etc...and be shure you have the tables created and the config of the shop perfect seted up.
Regards.

[elvise]

if i add news 2byte language bloken
english news add works good
need some help

[agriel]

hellow...
i need help. i run website by leandro iron use xampp 1.7.3 and got errorin registration (reg.php). the xampp give me some error notice.