[Release] Auction System V1 (Hen! CMS)

DexterSK · 03/30/2013, 13:28

Hi epvp

Short Video:

V2 coming soon

.RazerX · 03/30/2013, 13:36

woooo! cool!

©NewProject · 03/30/2013, 13:37

dík

~~»Sakazuki~~ · 03/30/2013, 13:54

Already exists ;(

Mfg,
Sakazuki

DexterSK · 03/30/2013, 14:02

Quote:

Originally Posted by »Sakazuki

Already exists ;(

Mfg,
Sakazuki

Okey

.SonY · 03/30/2013, 18:11

i have a problem
when I click on auction shows me that
"Auction
You must be logged in for this area."
but I have done the login.

©NewProject · 03/30/2013, 18:14

Quote:

Originally Posted by .SonY

i have a problem
when I click on auction shows me that
"Auction
You must be logged in for this area."
but I have done the login.

because you must change uzivatelske_prava to user_admin ....

TheMad · 03/30/2013, 19:37

@DexterSK
nice work^^

.SonY · 03/30/2013, 20:24

I'm bad at it
do not know much about it yet
if someone help me I thank
I'm going to buy the item and says he does not have enough coins
but I have enough coins

DexterSK · 03/30/2013, 21:08

Quote:

Originally Posted by .SonY

I'm bad at it
do not know much about it yet
if someone help me I thank
I'm going to buy the item and says he does not have enough coins
but I have enough coins

replace $_SESSION['uzivatelske_mince'] to $_SESSION['user_coins']

.SonY · 03/30/2013, 21:44

Quote:

Originally Posted by DexterSK

replace $_SESSION['uzivatelske_mince'] to $_SESSION['user_coins']

I already changed this
* but nevertheless says it does not have enough coins

and

GaMeLoT · 03/31/2013, 00:12

Quote:

Originally Posted by DexterSK

Hi epvp

Short Video:

V2 coming soon

Error. Please contact administrator. CODE: CHANGE COINS!

this error is not buying

PHP Code:



           <div id="register" class="col-2">
    <div class="content content-last">
        




            <div class="textblock">
        <div class="content-bg">
            <div class="content-bg-bottom">
                 <h2>Müzayede - Satın Al</h2><br>
                <div class="inner-content">
<?PHP
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin'] >= 0)
{
    if($_GET["id"] and $_GET["vnum"])
    {
        $kontrola = mysql_query("SELECT * FROM ".SQL_HP_DB.".auction_system WHERE id='".$_GET['id']."' AND vnum='".$_GET['vnum']."'");
        if(mysql_num_rows($kontrola) >= 1)
        {
            $test0 = mysql_query("SELECT owner_id, cena FROM ".SQL_HP_DB.".auction_system WHERE id='".$_GET['id']."' AND vnum='".$_GET['vnum']."'");
            $fetch0 = mysql_fetch_object($test0);
            $owner_id = mysql_real_escape_string($fetch0->owner_id);
            $cena = mysql_real_escape_string($fetch0->cena);
            
            if($_SESSION['user_coins'] >= $cena)
            {
                $test1 = mysql_query("SELECT account_id FROM player.player WHERE id='".mysql_real_escape_string($_SESSION['uzivatelske_id'])."'");
                $fetch1 = mysql_fetch_object($test1);
                $account_id = $fetch1->account_id;
                
                $test2 = mysql_query("SELECT mince FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($account_id)."'");
                $fetch2 = mysql_fetch_object($test2);
                $aktualne_mince = mysql_real_escape_string($fetch2->mince);
                
                $mince = $_SESSION['user_coins'] - $cena;
                
                //$UPDATE = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".$mince."' WHERE id='".$account_id."'");
                $update_minci = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".mysql_real_escape_string($mince)."' WHERE id='".mysql_real_escape_string($_SESSION['uzivatelske_id'])."'");
                
                $test5 = mysql_query("SELECT mince FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($owner_id)."'");
                $fetch5 = mysql_fetch_object($test5);
                $aktualne_mince5 = mysql_real_escape_string($fetch5->mince);
                $nove_mince5 = mysql_real_escape_string($cena);
                
                $spocitanie = $aktualne_mince5 + $nove_mince5;
                
                $pricitanie_minci = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".mysql_real_escape_string($spocitanie)."' WHERE id='".mysql_real_escape_string($owner_id)."'");
                
                if($update_minci AND $pricitanie_minci)
                {
                    $test3 = mysql_query("SELECT * FROM ".SQL_HP_DB.".auction_system WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'");
                    $fetch3 = mysql_fetch_object($test3);
                
                    
                    $getGroesse = compareItems($fetch3->vnum);
                    $belPos = checkPos($_SESSION['uzivatelske_id']);
                    $possiblePos = findPos($belPos['islager'],$getGroesse['groesse']);
                    
                    $sqlItem = mysql_query("INSERT INTO player.item 
                    (owner_id,window,pos,count,vnum,attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, socket0, socket1, socket2)
                    VALUES 
                    ('".mysql_real_escape_string($_SESSION['uzivatelske_id'])."','MALL','".mysql_real_escape_string($possiblePos[0])."','".mysql_real_escape_string($fetch3->count)."','".mysql_real_escape_string($fetch3->vnum)."','".mysql_real_escape_string($fetch3->attrtype0)."', '".mysql_real_escape_string($fetch3->attrvalue0)."', '".mysql_real_escape_string($fetch3->attrtype1)."', '".mysql_real_escape_string($fetch3->attrvalue1)."', '".mysql_real_escape_string($fetch3->attrtype2)."', '".mysql_real_escape_string($fetch3->attrvalue2)."', '".mysql_real_escape_string($fetch3->attrtype3)."', '".mysql_real_escape_string($fetch3->attrvalue3)."', '".mysql_real_escape_string($fetch3->attrtype4)."', '".mysql_real_escape_string($fetch3->attrvalue4)."', '".mysql_real_escape_string($fetch3->attrtype5)."', '".mysql_real_escape_string($fetch3->attrvalue5)."', '".mysql_real_escape_string($fetch3->attrtype6)."', '".mysql_real_escape_string($fetch3->attrvalue6)."', '".mysql_real_escape_string($fetch3->socket0)."', '".mysql_real_escape_string($fetch3->socket1)."', '".mysql_real_escape_string($fetch3->socket2)."')");
                    
                    if($sqlItem)
                    {
                        $vymazanie_z_auctionu = mysql_query("DELETE FROM ".SQL_HP_DB.".auction_system WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'");
                        if($vymazanie_z_auctionu)
                        {
                            $vymazanie_od_majitela = mysql_query("DELETE FROM player.item WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'");
                            if($vymazanie_od_majitela)
                            {
                                echo'<p>İtem Başarıyla Satın Alındı</p>';
                                echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
                            }
                            else
                            {
                                echo'<p>Hata. Yöneticinize başvurun. KOD: DELETE FROM OWNER!</p>';
                                echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
                            }
                        }
                        else
                        {
                            echo'<p>Hata. Yöneticinize başvurun. KOD: AUCTION DELETE!</p>';
                            echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
                        }
                    }
                    else
                    {
                        echo'<p>Hata. Yöneticinize başvurun. KOD: MOVE ITEM!</p>';
                        echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
                    }
                }
                else
                {
                    echo'<p>Hata. Yöneticinize başvurun. KOD: CHANGE COINS!</p>';
                    echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
                }
            }
            else
            {
                echo'<p>You do not have enough coins.</p>';
                echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
            }
        }
        else
        {
            echo'<p>This ID does not exist. Your number will not change coins.</p>';
            echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
        }
    }
    else
    {
        echo'<p>Error.</p>';
        echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>';
    }
}
else
{
    echo'<p class="meldung">Bu alan için giriş yapmalısınız.</p>';
}
?></div></div></div></div></div></div>

Quote:

Originally Posted by .SonY

I already changed this
* but nevertheless says it does not have enough coins

and

I get the error does not consistently purchase items needed

Code:CHANGE COINS! what is this ?

oooo

ejxxx · 03/31/2013, 20:50

Quote:

Originally Posted by .SonY

I already changed this
* but nevertheless says it does not have enough coins

and

i have some problem

DexterSK · 03/31/2013, 21:32

You must replace all

PHP Code:



$test5 = mysql_query("SELECT mince FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($owner_id)."'");

to

PHP Code:



$test5 = mysql_query("SELECT coins FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($owner_id)."'");

mince change to coins

Quote:

Originally Posted by GaMeLoT

Error. Please contact administrator. CODE: CHANGE COINS!

this error is not buying

PHP Code:

<div id="register" class="col-2"> <div class="content content-last"> <div class="textblock"> <div class="content-bg"> <div class="content-bg-bottom"> <h2>Müzayede - Satın Al</h2><br> <div class="inner-content"> <?PHP if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin'] >= 0) { if($_GET["id"] and $_GET["vnum"]) { $kontrola = mysql_query("SELECT * FROM ".SQL_HP_DB.".auction_system WHERE id='".$_GET['id']."' AND vnum='".$_GET['vnum']."'"); if(mysql_num_rows($kontrola) >= 1) { $test0 = mysql_query("SELECT owner_id, cena FROM ".SQL_HP_DB.".auction_system WHERE id='".$_GET['id']."' AND vnum='".$_GET['vnum']."'"); $fetch0 = mysql_fetch_object($test0); $owner_id = mysql_real_escape_string($fetch0->owner_id); $cena = mysql_real_escape_string($fetch0->cena); if($_SESSION['user_coins'] >= $cena) { $test1 = mysql_query("SELECT account_id FROM player.player WHERE id='".mysql_real_escape_string($_SESSION['uzivatelske_id'])."'"); $fetch1 = mysql_fetch_object($test1); $account_id = $fetch1->account_id; $test2 = mysql_query("SELECT mince FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($account_id)."'"); $fetch2 = mysql_fetch_object($test2); $aktualne_mince = mysql_real_escape_string($fetch2->mince); $mince = $_SESSION['user_coins'] - $cena; //$UPDATE = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".$mince."' WHERE id='".$account_id."'"); $update_minci = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".mysql_real_escape_string($mince)."' WHERE id='".mysql_real_escape_string($_SESSION['uzivatelske_id'])."'"); $test5 = mysql_query("SELECT mince FROM ".SQL_HP_DB.".account WHERE id='".mysql_real_escape_string($owner_id)."'"); $fetch5 = mysql_fetch_object($test5); $aktualne_mince5 = mysql_real_escape_string($fetch5->mince); $nove_mince5 = mysql_real_escape_string($cena); $spocitanie = $aktualne_mince5 + $nove_mince5; $pricitanie_minci = mysql_query("UPDATE ".SQL_HP_DB.".account SET mince='".mysql_real_escape_string($spocitanie)."' WHERE id='".mysql_real_escape_string($owner_id)."'"); if($update_minci AND $pricitanie_minci) { $test3 = mysql_query("SELECT * FROM ".SQL_HP_DB.".auction_system WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'"); $fetch3 = mysql_fetch_object($test3); $getGroesse = compareItems($fetch3->vnum); $belPos = checkPos($_SESSION['uzivatelske_id']); $possiblePos = findPos($belPos['islager'],$getGroesse['groesse']); $sqlItem = mysql_query("INSERT INTO player.item (owner_id,window,pos,count,vnum,attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, socket0, socket1, socket2) VALUES ('".mysql_real_escape_string($_SESSION['uzivatelske_id'])."','MALL','".mysql_real_escape_string($possiblePos[0])."','".mysql_real_escape_string($fetch3->count)."','".mysql_real_escape_string($fetch3->vnum)."','".mysql_real_escape_string($fetch3->attrtype0)."', '".mysql_real_escape_string($fetch3->attrvalue0)."', '".mysql_real_escape_string($fetch3->attrtype1)."', '".mysql_real_escape_string($fetch3->attrvalue1)."', '".mysql_real_escape_string($fetch3->attrtype2)."', '".mysql_real_escape_string($fetch3->attrvalue2)."', '".mysql_real_escape_string($fetch3->attrtype3)."', '".mysql_real_escape_string($fetch3->attrvalue3)."', '".mysql_real_escape_string($fetch3->attrtype4)."', '".mysql_real_escape_string($fetch3->attrvalue4)."', '".mysql_real_escape_string($fetch3->attrtype5)."', '".mysql_real_escape_string($fetch3->attrvalue5)."', '".mysql_real_escape_string($fetch3->attrtype6)."', '".mysql_real_escape_string($fetch3->attrvalue6)."', '".mysql_real_escape_string($fetch3->socket0)."', '".mysql_real_escape_string($fetch3->socket1)."', '".mysql_real_escape_string($fetch3->socket2)."')"); if($sqlItem) { $vymazanie_z_auctionu = mysql_query("DELETE FROM ".SQL_HP_DB.".auction_system WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'"); if($vymazanie_z_auctionu) { $vymazanie_od_majitela = mysql_query("DELETE FROM player.item WHERE id='".mysql_real_escape_string($_GET['id'])."' AND vnum='".mysql_real_escape_string($_GET['vnum'])."'"); if($vymazanie_od_majitela) { echo'<p>İtem Başarıyla Satın Alındı</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } else { echo'<p>Hata. Yöneticinize başvurun. KOD: DELETE FROM OWNER!</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>Hata. Yöneticinize başvurun. KOD: AUCTION DELETE!</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>Hata. Yöneticinize başvurun. KOD: MOVE ITEM!</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>Hata. Yöneticinize başvurun. KOD: CHANGE COINS!</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>You do not have enough coins.</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>This ID does not exist. Your number will not change coins.</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p>Error.</p>'; echo'<p><a href="index.php?s=aukcia">Müzayedeye Geri Dön</a></p>'; } } else { echo'<p class="meldung">Bu alan için giriş yapmalısınız.</p>'; } ?></div></div></div></div></div></div>

I get the error does not consistently purchase items needed

Code:CHANGE COINS! what is this ?

oooo

and

PHP Code:



$_SESSION['uzivatelske_id']

change to

PHP Code:



$_SESSION['user_id']

GaMeLoT · 03/31/2013, 22:10

tank you auction_system_log.sql Are you going to the registry?