W coin / goblin points

How to add W Coin and Goblin Points Manual ?
Use SQL Server 2008 R2
pls help :(:

DBManager dont work i use zTeam s6
http://s11.postimg.org/4fmiu2iwj/opp.png

PHP Code:

---

Use [MuOnline]
  Update GameShopPoint set WCoinC = 100, WCoinP = 100, GoblinPoint = 100 where AccountID = 'accountName' 


---

Choose acc name & execute at sql

Use [MuOnline] = Database Name

Quote:

---

Originally Posted by 4FUNer

PHP Code:

---

Use [MuOnline]
  Update GameShopPoint set WCoinC = 100, WCoinP = 100, GoblinPoint = 100 where AccountID = 'accountName' 


---

Choose acc name & execute at sql

Use [MuOnline] = Database Name

---

Tables MEMB_INFO
http://s27.postimg.org/qq6xn7qhv/fas.png

well because gameshoppoint doesn't exist, rename the column (gameshoppoint) to your column.

also why you dont add them from memb_info table? right click > open all rows> choose account and scroll all the way at the right
and there is wcoin/goblin point etc, you can add easily.

Quote:

---

Originally Posted by KarLi

well because gameshoppoint doesn't exist, rename the column (gameshoppoint) to your column.

also why you dont add them from memb_info table? right click > open all rows> choose account and scroll all the way at the right
and there is wcoin/goblin point etc, you can add easily.

---

I found in dbo.gameshop_data !! ty +1 rep

Please use prefix [Help] on your topic
View the Rules of each section you post please,

[Help] fixed

Regards Dope.

UPDATE [MuOnline].[dbo].[GameShop_Data] SET WCoinC='900000',WCoinP='900000' WHERE MemberGuid='4'

z-teame S8e2

[IMG]http://image.ohozaa.com/i/546/yCqs2D.png[/IMG]

:D yes good yob
try to:
php code
mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");

WCoin=WCoin+10 change WCoin or Credits or ...
+10 = number WCoin
$username or $username_id ---> by web

Add to this simple form for sending data and is done

For example resetlevel.php
Credits:
GrinYa
leorond

PHP Code:

---

<?php
include    ("usernameaccess.php");
echo "<script type=\"text/javascript\">document.getElementById(\"h4\").innerHTML = \"".table_reset_lvll."\"</script>
        <input type='hidden' id='module_contet' value='".table_reset_lvll."'>";
$char_name    =    $_POST['char_name'];
$ceck_pk    =    mssql_query("select clevel,$reset_column,money,class from character where accountid    =    '$username' and name    =    '$char_name'");
if    (mssql_num_rows($ceck_pk)    ==    0)
{
    exit("<center>".something_wrong."</center>");
}
$myrow_pk    =    mssql_fetch_array($ceck_pk);
$levelnares     = 300+(10*$myrow_pk[$reset_column]);
if($levelnares > 400)
    $levelnares     = 400;
$maxres     = 350;

//if    ($myrow_pk['clevel']    <    $Option['reset_level'])
if    ($myrow_pk['clevel']    <    $levelnares)
{
    echo    "<ul><li>".eror_rr_lvl."</li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    
}
elseif    ($myrow_pk['money']    <    ($Option['zen_per_reset'] * $myrow_pk[$reset_column]))
{
    echo    "<ul><li>".eror_rr_zen."</li></ul>";    
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    
}
elseif ($myrow_pk[$reset_column] >= $maxres )
{
    echo    "<ul><li> Už máš maximální reset </li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");
}
else
{
    $resets    =    $myrow_pk[$reset_column] + 1;
    $money    =    $myrow_pk['money'] - $Option['zen_per_reset'] * $myrow_pk[$reset_column];
    if ($Option['reset_class']    ==    1)
    {
        switch($myrow_pk['class'])
        {
            case    0    or    $myrow_pk['class']    ==    1    or    $myrow_pk['class']    ==    2:
                $reset_class    =    ",class=0";
            break;
            case    $myrow_pk['class']    ==    16    or    $myrow_pk['class']    ==    17    or    $myrow_pk['class']    ==    18:
                $reset_class    =    ",class=16";
            break;
            case    $myrow_pk['class']    ==    32    or    $myrow_pk['class']    ==    33    or    $myrow_pk['class']    ==    34:
                $reset_class    =    ",class=32";
            break;
            case    $myrow_pk['class']    ==    48    or    $myrow_pk['class']    ==    49    or    $myrow_pk['class']    ==    50:
                $reset_class    =    ",class=48";
            break;
            case    $myrow_pk['class']    ==    64    or    $myrow_pk['class']    ==    65    or    $myrow_pk['class']    ==    66:
                $reset_class    =    ",class=64";
            break;
            case    $myrow_pk['class']    ==    80    or    $myrow_pk['class']    ==    81    or    $myrow_pk['class']    ==    82:
                $reset_class    =    ",class=80";
            break;
            case    $myrow_pk['class']    ==    96    or    $myrow_pk['class']    ==    97    or    $myrow_pk['class']    ==    98:
                $reset_class    =    ",class=96";
            break;
        }
        $reset_class    .=    ",quest=NULL";
    }
    if    ($server['Season4Master']    ==    1)
    {
        $master_res        =    ",$masterlevel_=0";
        if    ($Option['clear_skill']    ==    1)
        {
            $master_skil    =    ",$server[Season4mskill]=NULL";
        }
        $master_points    =    ",$server[Season4mpoints]=0";
    }
    if    ($Option['clear_skill']    ==    1)
    {
        $clear_skills        =    ",MagicList=NULL";
    }
    if    ($Option['clear_inv']    ==    1)
    {
        $clear_invent        =    ",Inventory=NULL";
    }
    if ($Option['boughtpprr']    ==    1)
    {
        $add_bought_pp    =    "+bothpoints";
    }
    if    ($Option['reset_stats_type']    ==    0)
    {
        $clear    =    mssql_query("update character$masterleveltable_ set clevel=1,mapnumber=0,mapposx=125,mapposy=125,FruitPoint=0,experience=0,$reset_column=$resets,money=$money$master_res$clear_skills$master_skill$clear_invent$reset_class where accountid    =    '$username' and name    =    '$char_name' $masterlevelwhere_");
    }
    else
    {
        switch($myrow_pk['class'])
        {
            case    0    or    $myrow_pk['class']    ==    1    or    $myrow_pk['class']    ==    2    or    $myrow_pk['class']    ==    3:
                $reset_st        =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dw]*$resets$add_bought_pp,mapnumber=0,mapposx=143,mapposy=134,FruitPoint=0,strength=18,dexterity=18,vitality=15,energy=30,Leadership=0,experience=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    16    or    $myrow_pk['class']    ==    17    or    $myrow_pk['class']    ==    18    or    $myrow_pk['class']    ==    19:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dk]*$resets$add_bought_pp,mapnumber=0,mapposx=135,mapposy=127,FruitPoint=0,experience=0,strength=28,dexterity=20,vitality=25,energy=10,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    32    or    $myrow_pk['class']    ==    33    or    $myrow_pk['class']    ==    34    or    $myrow_pk['class']    ==    35:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_elf]*$resets$add_bought_pp,mapnumber=3,mapposx=180,mapposy=120,FruitPoint=0,experience=0,strength=22,dexterity=25,vitality=20,energy=15,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    48    or    $myrow_pk['class']    ==    49    or    $myrow_pk['class']    ==    50    or    $myrow_pk['class']    ==    51:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_mg]*$resets$add_bought_pp,mapnumber=0,mapposx=140,mapposy=121,FruitPoint=0,experience=0,strength=26,dexterity=26,vitality=26,energy=26,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    64    or    $myrow_pk['class']    ==    65    or    $myrow_pk['class']    ==    66    or    $myrow_pk['class']    ==    67:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dl]*$resets$add_bought_pp,mapnumber=0,mapposx=144,mapposy=122,FruitPoint=0,experience=0,strength=26,dexterity=20,vitality=20,energy=15,Leadership=25,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    80    or    $myrow_pk['class']    ==    81    or    $myrow_pk['class']    ==    82    or    $myrow_pk['class']    ==    83:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_sum]*$resets$add_bought_pp,mapnumber=51,mapposx=50,mapposy=225,FruitPoint=0,experience=0,strength=21,dexterity=21,vitality=18,energy=23,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    96    or    $myrow_pk['class']    ==    97    or    $myrow_pk['class']    ==    98    or    $myrow_pk['class']    ==    99:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_rf]*$resets$add_bought_pp,mapnumber=0,mapposx=147,mapposy=135,FruitPoint=0,experience=0,strength=21,dexterity=21,vitality=18,energy=23,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
        }
    }
    $log1        =    "Has reset his character: <b>".$char_name."</b>";
    $log_all    =    $log1;
    $insert_log    =    mssql_query("insert into EW_LOG (account,[index],credits,datetime) values ('$username','$log_all','0','$date')");
    echo    "<ul><li>".succes_rr."</li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    }
?>

---

For CashShop try to Titan editor ;-)
Good luck

- - - Updated - - -

or try to MSSQL -> New Query ->

PHP Code:

---

update MEMB_INFO set WCoin=WCoin+10 where memb___id=<account name> 


---

Quote:

---

Originally Posted by leorond

:D yes good yob
try to:
php code
mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");

WCoin=WCoin+10 change WCoin or Credits or ...
+10 = number WCoin
$username or $username_id ---> by web

Add to this simple form for sending data and is done

For example resetlevel.php
Credits:
GrinYa
leorond

PHP Code:

---

<?php
include    ("usernameaccess.php");
echo "<script type=\"text/javascript\">document.getElementById(\"h4\").innerHTML = \"".table_reset_lvll."\"</script>
        <input type='hidden' id='module_contet' value='".table_reset_lvll."'>";
$char_name    =    $_POST['char_name'];
$ceck_pk    =    mssql_query("select clevel,$reset_column,money,class from character where accountid    =    '$username' and name    =    '$char_name'");
if    (mssql_num_rows($ceck_pk)    ==    0)
{
    exit("<center>".something_wrong."</center>");
}
$myrow_pk    =    mssql_fetch_array($ceck_pk);
$levelnares     = 300+(10*$myrow_pk[$reset_column]);
if($levelnares > 400)
    $levelnares     = 400;
$maxres     = 350;

//if    ($myrow_pk['clevel']    <    $Option['reset_level'])
if    ($myrow_pk['clevel']    <    $levelnares)
{
    echo    "<ul><li>".eror_rr_lvl."</li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    
}
elseif    ($myrow_pk['money']    <    ($Option['zen_per_reset'] * $myrow_pk[$reset_column]))
{
    echo    "<ul><li>".eror_rr_zen."</li></ul>";    
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    
}
elseif ($myrow_pk[$reset_column] >= $maxres )
{
    echo    "<ul><li> Už máš maximální reset </li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");
}
else
{
    $resets    =    $myrow_pk[$reset_column] + 1;
    $money    =    $myrow_pk['money'] - $Option['zen_per_reset'] * $myrow_pk[$reset_column];
    if ($Option['reset_class']    ==    1)
    {
        switch($myrow_pk['class'])
        {
            case    0    or    $myrow_pk['class']    ==    1    or    $myrow_pk['class']    ==    2:
                $reset_class    =    ",class=0";
            break;
            case    $myrow_pk['class']    ==    16    or    $myrow_pk['class']    ==    17    or    $myrow_pk['class']    ==    18:
                $reset_class    =    ",class=16";
            break;
            case    $myrow_pk['class']    ==    32    or    $myrow_pk['class']    ==    33    or    $myrow_pk['class']    ==    34:
                $reset_class    =    ",class=32";
            break;
            case    $myrow_pk['class']    ==    48    or    $myrow_pk['class']    ==    49    or    $myrow_pk['class']    ==    50:
                $reset_class    =    ",class=48";
            break;
            case    $myrow_pk['class']    ==    64    or    $myrow_pk['class']    ==    65    or    $myrow_pk['class']    ==    66:
                $reset_class    =    ",class=64";
            break;
            case    $myrow_pk['class']    ==    80    or    $myrow_pk['class']    ==    81    or    $myrow_pk['class']    ==    82:
                $reset_class    =    ",class=80";
            break;
            case    $myrow_pk['class']    ==    96    or    $myrow_pk['class']    ==    97    or    $myrow_pk['class']    ==    98:
                $reset_class    =    ",class=96";
            break;
        }
        $reset_class    .=    ",quest=NULL";
    }
    if    ($server['Season4Master']    ==    1)
    {
        $master_res        =    ",$masterlevel_=0";
        if    ($Option['clear_skill']    ==    1)
        {
            $master_skil    =    ",$server[Season4mskill]=NULL";
        }
        $master_points    =    ",$server[Season4mpoints]=0";
    }
    if    ($Option['clear_skill']    ==    1)
    {
        $clear_skills        =    ",MagicList=NULL";
    }
    if    ($Option['clear_inv']    ==    1)
    {
        $clear_invent        =    ",Inventory=NULL";
    }
    if ($Option['boughtpprr']    ==    1)
    {
        $add_bought_pp    =    "+bothpoints";
    }
    if    ($Option['reset_stats_type']    ==    0)
    {
        $clear    =    mssql_query("update character$masterleveltable_ set clevel=1,mapnumber=0,mapposx=125,mapposy=125,FruitPoint=0,experience=0,$reset_column=$resets,money=$money$master_res$clear_skills$master_skill$clear_invent$reset_class where accountid    =    '$username' and name    =    '$char_name' $masterlevelwhere_");
    }
    else
    {
        switch($myrow_pk['class'])
        {
            case    0    or    $myrow_pk['class']    ==    1    or    $myrow_pk['class']    ==    2    or    $myrow_pk['class']    ==    3:
                $reset_st        =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dw]*$resets$add_bought_pp,mapnumber=0,mapposx=143,mapposy=134,FruitPoint=0,strength=18,dexterity=18,vitality=15,energy=30,Leadership=0,experience=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    16    or    $myrow_pk['class']    ==    17    or    $myrow_pk['class']    ==    18    or    $myrow_pk['class']    ==    19:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dk]*$resets$add_bought_pp,mapnumber=0,mapposx=135,mapposy=127,FruitPoint=0,experience=0,strength=28,dexterity=20,vitality=25,energy=10,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    32    or    $myrow_pk['class']    ==    33    or    $myrow_pk['class']    ==    34    or    $myrow_pk['class']    ==    35:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_elf]*$resets$add_bought_pp,mapnumber=3,mapposx=180,mapposy=120,FruitPoint=0,experience=0,strength=22,dexterity=25,vitality=20,energy=15,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    48    or    $myrow_pk['class']    ==    49    or    $myrow_pk['class']    ==    50    or    $myrow_pk['class']    ==    51:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_mg]*$resets$add_bought_pp,mapnumber=0,mapposx=140,mapposy=121,FruitPoint=0,experience=0,strength=26,dexterity=26,vitality=26,energy=26,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    64    or    $myrow_pk['class']    ==    65    or    $myrow_pk['class']    ==    66    or    $myrow_pk['class']    ==    67:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_dl]*$resets$add_bought_pp,mapnumber=0,mapposx=144,mapposy=122,FruitPoint=0,experience=0,strength=26,dexterity=20,vitality=20,energy=15,Leadership=25,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    80    or    $myrow_pk['class']    ==    81    or    $myrow_pk['class']    ==    82    or    $myrow_pk['class']    ==    83:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_sum]*$resets$add_bought_pp,mapnumber=51,mapposx=50,mapposy=225,FruitPoint=0,experience=0,strength=21,dexterity=21,vitality=18,energy=23,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
            case    $myrow_pk['class']    ==    96    or    $myrow_pk['class']    ==    97    or    $myrow_pk['class']    ==    98    or    $myrow_pk['class']    ==    99:
                $reset_st    =    mssql_query("update character$masterleveltable_ set leveluppoint=$Option[reset_rf]*$resets$add_bought_pp,mapnumber=0,mapposx=147,mapposy=135,FruitPoint=0,experience=0,strength=21,dexterity=21,vitality=18,energy=23,Leadership=0,clevel=6,$reset_column=$resets,money=$money$reset_class$master_res$clear_skills$master_skill$clear_invent$master_points where accountid='$username' and name='$char_name' $masterlevelwhere_");
                mssql_query("update ew_credits set credits=credits+1 where memb___id='$username'");
                mssql_query("update MEMB_INFO set WCoin=WCoin+10 where memb___id='$username'");
            break;
        }
    }
    $log1        =    "Has reset his character: <b>".$char_name."</b>";
    $log_all    =    $log1;
    $insert_log    =    mssql_query("insert into EW_LOG (account,[index],credits,datetime) values ('$username','$log_all','0','$date')");
    echo    "<ul><li>".succes_rr."</li></ul>";
    echo "<script type=\"text/javascript\">document.title=\"$enemy[title]Account Panel\";</script>";
    if ($cat[1]    !=    NULL and preg_match("/^[0-9]/i",$cat[1]))    $_GET['page']    =    $cat[1];
    include ("pgs/acc_panel.php");    }
?>

---

For CashShop try to Titan editor ;-)
Good luck

- - - Updated - - -

or try to MSSQL -> New Query ->

PHP Code:

---

update MEMB_INFO set WCoin=WCoin+10 where memb___id=<account name> 


---

---

ty +1