- Joined
- Apr 8, 2008
- Messages
- 2,464
- Reaction score
- 11,162
[Release] OpenMu Web Clone
- Thread starter DarkMaster
- Start date
oovan
Member
- Joined
- Oct 21, 2008
- Messages
- 237
- Reaction score
- 16
пичове значи слагам този код alter table character add GrResets int not null default 0 в Query Analyzer в MuOnline(database) и пак не ми излизат Top Players Guild i Rankings ЗАЩО?А преди тва сървъра беше на друг комп и сайта си бачкаше напълно а сега не става...?А кода за Vote Reward си бачка идеално... ?
Good evening!
I take this web, all perfect. Buts, 1 problem. In left block - Top Players - there are no 1 player, in ranking section too. But Top Guild works perfect.
How i can solve this problem?
Sorry, i'm not Bulgarian.
I take this web, all perfect. Buts, 1 problem. In left block - Top Players - there are no 1 player, in ranking section too. But Top Guild works perfect.
How i can solve this problem?
Sorry, i'm not Bulgarian.
oveRLuckEd
New Member
- Joined
- Apr 28, 2008
- Messages
- 1,776
- Reaction score
- 398
are you sure that you have columns - Resets and GrResets if you don't get the code from the 1st page and insert it in QA
Emmm. I'm stupy ;-) In dbo character, i had table Reset, don't Resets. Now i change it to Resets and all good.
Thanks ;-)
Hi all.
I have problem with GR. When people makes GR, they don't get credits. Help me please.
dbo of credits - MEMB_CREDITS
I have problem with GR. When people makes GR, they don't get credits. Help me please.
dbo of credits - MEMB_CREDITS
oveRLuckEd
New Member
- Joined
- Apr 28, 2008
- Messages
- 1,776
- Reaction score
- 398
function dogrand_reset()
{
$account = secure($_SESSION['user']);
global $grandresetcredits;
if(isset($_POST['exchange']))
{
$account = secure($_SESSION['user']);
$character = secure($_POST['character']);
$resets = secure($_POST['resets']);
check_inject();
$querychar = mssql_query("Select resets,grresets from character where name='$character'");
$char = mssql_fetch_row($querychar);
$newresets = $char[0] - $resets;
$newgrresets = $char[1] + $resets;
if($newresets < 0) { echo"<br><font color='red'>Not enought resets!</font><br>"; $error = 1; }
elseif($resets < 0) { echo"<br><font color='red'>Error! You Can't put - numbers!</font><br>"; $error = 1; }
elseif($error != 1) {
$credits = $resets * $grandresetcredits;
echo"<br><font color='green'>You exchange $resets reset(s) for $credits credits</font><br>";
$a = mssql_query("Update Character set resets='$newresets',GrResets='$newgrresets' where name='$character'");
$b = mssql_query("Update MEMB_CREDITS set credits = credits+$credits WHERE memb___id='$account'");
}
}
$query = mssql_query("Select name,resets from character where AccountID='$account'");
echo"
<form action='' name='' method='POST'>
<select id='character' name='character'><optgroup label='Select a character'>
";
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
echo"
<option value='$row[0]'>$row[0] [$row[1]]</option>
";
}
echo"</select>
<br><input type='text' size='25' id='resets' name='resets' />
<br><input type='submit' maxlength='2' value='exchange' name='exchange'>
</form>
<br>Each one sold reset is equivalent to One 'GR' in Rankings !
<br>1 Reset = $grandresetcredits Credits!
";
}
{
$account = secure($_SESSION['user']);
global $grandresetcredits;
if(isset($_POST['exchange']))
{
$account = secure($_SESSION['user']);
$character = secure($_POST['character']);
$resets = secure($_POST['resets']);
check_inject();
$querychar = mssql_query("Select resets,grresets from character where name='$character'");
$char = mssql_fetch_row($querychar);
$newresets = $char[0] - $resets;
$newgrresets = $char[1] + $resets;
if($newresets < 0) { echo"<br><font color='red'>Not enought resets!</font><br>"; $error = 1; }
elseif($resets < 0) { echo"<br><font color='red'>Error! You Can't put - numbers!</font><br>"; $error = 1; }
elseif($error != 1) {
$credits = $resets * $grandresetcredits;
echo"<br><font color='green'>You exchange $resets reset(s) for $credits credits</font><br>";
$a = mssql_query("Update Character set resets='$newresets',GrResets='$newgrresets' where name='$character'");
$b = mssql_query("Update MEMB_CREDITS set credits = credits+$credits WHERE memb___id='$account'");
}
}
$query = mssql_query("Select name,resets from character where AccountID='$account'");
echo"
<form action='' name='' method='POST'>
<select id='character' name='character'><optgroup label='Select a character'>
";
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
echo"
<option value='$row[0]'>$row[0] [$row[1]]</option>
";
}
echo"</select>
<br><input type='text' size='25' id='resets' name='resets' />
<br><input type='submit' maxlength='2' value='exchange' name='exchange'>
</form>
<br>Each one sold reset is equivalent to One 'GR' in Rankings !
<br>1 Reset = $grandresetcredits Credits!
";
}
Last edited:
oveRLuckEd
New Member
- Joined
- Apr 28, 2008
- Messages
- 1,776
- Reaction score
- 398
Yes. MEMB_CREDITS i got 15-20 days ago, when i install webshop.
In character i have GrResets, cause, when characters make GR, they got GRs, but don't getting credits.
oveRLuckEd
New Member
- Joined
- Apr 28, 2008
- Messages
- 1,776
- Reaction score
- 398
oveRLuckEd
New Member
- Joined
- Apr 28, 2008
- Messages
- 1,776
- Reaction score
- 398
Can you see, maybe problem is in script ? I don't change it. It is the same, that in this files.
AgMuN4o
Banned
- Joined
- Apr 19, 2008
- Messages
- 106
- Reaction score
- 53
Here is a fix Replice your code with this code
Code:
[COLOR="Blue"]function dogrand_reset()
{
$account = secure($_SESSION['user']);
global $grandresetcredits;
if(isset($_POST['exchange']))
{
$account = secure($_SESSION['user']);
$character = secure($_POST['character']);
$resets = secure($_POST['resets']);
check_inject();
$querychar = mssql_query("Select resets,grresets from character where name='$character'");
$char = mssql_fetch_row($querychar);
$credits_user = mssql_query("Select * from MEMB_CREDITS where memb___id='$account'");
$credits_user_check = mssql_num_rows($credits_user);
$newresets = $char[0] - $resets;
$newgrresets = $char[1] + $resets;
if($credits_user_check <= 0){ mssql_query("INSERT INTO MEMB_CREDITS (memb___id,credits) VALUES ('$account','0')"); }
if($newresets < 0) { echo"<br><font color='red'>Not enought resets!</font><br>"; $error = 1; }
elseif($resets < 0) { echo"<br><font color='red'>Error! You Can't put - numbers!</font><br>"; $error = 1; }
elseif($error != 1) {
$credits = $resets * $grandresetcredits;
echo"<br><font color='green'>You exchange $resets reset(s) for $credits credits</font><br>";
$a = mssql_query("Update Character set resets='$newresets',GrResets='$newgrresets' where name='$character'");
$b = mssql_query("Update MEMB_CREDITS set credits = credits+$credits WHERE memb___id='$account'");
}
}
$query = mssql_query("Select name,resets from character where AccountID='$account'");
echo"
<form action='' name='' method='POST'>
<select id='character' name='character'><optgroup label='Select a character'>
";
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
echo"
<option value='$row[0]'>$row[0] [$row[1]]</option>
";
}
echo"</select>
<br><input type='text' size='25' id='resets' name='resets' />
<br><input type='submit' maxlength='2' value='exchange' name='exchange'>
</form>
<br>Each one sold reset is equivalent to One 'GR' in Rankings !
<br>1 Reset = $grandresetcredits Credits!
";
}[/COLOR]AgMuN4o
Banned
- Joined
- Apr 19, 2008
- Messages
- 106
- Reaction score
- 53
аз мога да ти кажа че нито 1 стотинка не дадена за тоя шоп шопа е правен от Bupyc и малка част от Mephisto за което Bupyc му е благодарени им права евала и на 2-мата
WEB SHOP-a е правен от SaVoY и малка част от него е преправена от Mephisto а Bupyc нз кво толко е бъркал но WEB SHOP-а си е на SaVoY
а ти като не знаеш а само предполагаш на кои е не говори глупости ами си змалчи :bangin:
