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
View attachment 94902

After that he will have to Confirm the purchase
View attachment 94903

so an site admin will Aprove it or denie it if the tranfer is succesfull or not
View 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.:mellow:

 

[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

[URL="

To view the content, you need to sign in or register

Uploaded with

To view the content, you need to sign in or register

[/URL]

 

[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

[URL="

To view the content, you need to sign in or register

Uploaded with

To view the content, you need to sign in or register

[/URL]

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.

 

[xXxAxXx]

wow,and we should gues the error?
Make a ss with the error so we can help you.

 

[agriel]

wow,and we should gues the error?
Make a ss with the error so we can help you.

ups.. sry my mistake. T_T
error such like this :




and if i try to create account or register, the screen just like that and the register not succes or failed :?:

and this my web php

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

To view the content, you need to sign in or register

Thankz be for :

 

[xXxAxXx]

Use xampp 1.7.1

 

[agriel]

Use xampp 1.7.1

thank very much bro Popa Andrei for helping me.
now the register are succes but still error in the rank Top Nation.

Warning: Division by zero in C:\xampp\htdocs\rank\sisRankNacao.php on line 48

Warning: Division by zero in C:\xampp\htdocs\rank\sisRankNacao.php on line 52

:?:

To view the content, you need to sign in or register

 

[xXxAxXx]

read the error very carefful.It sez divid by 0 wich means no stats are in the database.That why you get error.Make an account and create an character.
PS use Like button,does wonders )