Bėda su Multimod sms sistema

Kalbos apie viską kas nesusiję su kitais forumais.
Post Reply
Zaidejas1
O taip. Jis jau surinko 50 žinučių!
Posts: 52
Joined: 2013 Jun 14 11:41

Bėda su Multimod sms sistema

Post by Zaidejas1 »

Sveiki, iškilo bėda su multimod mokėjimai.lt sms sistema, unban skiltyje meta klaidą. Nesuprantu kaip ją ištaisyti, padėkite.

Prie Amxbans prisijungta sėkmingai. versija 5.1b

Image
Top
User avatar
aaarnas
Vyr. diskusijų administratorius
Posts: 3891
Joined: 2010 Aug 31 13:21
Skype: fiarno
Contact:
Contact aaarnas

Re: Bėda su Multimod sms sistema

Post by aaarnas »

Iš duomenų bazės sistemoje gauna neteisingą užklausą arba visai jos negauna, tai funkcija negali atlikti veiksmo.
Dėl ko taip - čia jau reikia pagal užklausą žiūrėti.
Palikau CS pasaulį ;/ . Nebepasiekiamas.
Top
User avatar
V1LKAS
Flooderis arba specialistas
Posts: 612
Joined: 2012 Nov 08 12:55
Skype: darius489

Re: Bėda su Multimod sms sistema

Post by V1LKAS »

Pradžiai papostink tas eilutes, kur error (107)
Top
Zaidejas1
O taip. Jis jau surinko 50 žinučių!
Posts: 52
Joined: 2013 Jun 14 11:41

Re: Bėda su Multimod sms sistema

Post by Zaidejas1 »

107 eilutė:

Code: Select all

$row = mysql_fetch_array($r, MYSQL_ASSOC);
Top
User avatar
V1LKAS
Flooderis arba specialistas
Posts: 612
Joined: 2012 Nov 08 12:55
Skype: darius489

Re: Bėda su Multimod sms sistema

Post by V1LKAS »

Tai daugiau manau reik, palink visą funkciją nukopijuok.
Top
Zaidejas1
O taip. Jis jau surinko 50 žinučių!
Posts: 52
Joined: 2013 Jun 14 11:41

Re: Bėda su Multimod sms sistema

Post by Zaidejas1 »

Code: Select all

    Unban     </h3>    <div class="windowbg" style="padding: 3px;">    <div class="smalltext">    ";        $connect = mysql_connect($amxbans_hostname, $amxbans_username, $amxbans_password) or die(mysql_error());    $select = mysql_select_db($amxbans_database, $connect) or die(mysql_error());     $result = mysql_query("SELECT bid FROM amx_bans") or die(mysql_error());    $rows = mysql_num_rows($result);     echo "Bans in database: <b><a href=".$amxbans_web." target = _blank>".$rows."</a></b><br>    IP address - <b>".$ip."</b><br>";      $r = mysql_query("SELECT * FROM amx_bans WHERE player_ip = '$ip' AND expired = '0' ORDER BY bid DESC");    [b][size=150]$row = mysql_fetch_array($r, MYSQL_ASSOC);[/size][/b]     if(!$row) {        echo "Status: <b><span style="color:green">Not banned.</span></b><br>";    } else {         echo "Status: <b><span style="color:red">You have been banned!</span></b><br>Reason: <b>$row[ban_reason]</b><br><br>";                $connect = mysql_connect($sms_hostname, $sms_username, $sms_password) or die(mysql_error());         $select = mysql_select_db($sms_database, $connect) or die(mysql_error());                $r = mysql_query("SELECT * FROM ebank WHERE `mod` = 'unban' LIMIT 1");        $row = mysql_fetch_array($r, MYSQL_ASSOC);                $price[unban]= $row['price']/100;                echo "Unban Price: $price[unban]LTL<br><br>        <form target=_blank action="gateway/makro/paymakro.php" method="get">        <input type="hidden" name="orderid" value="$ip">         <input type="hidden" name="act" value="unban">        <input type="hidden" name="amount" value="$row[price]" />        <input type="submit" value="Pay now!"></form>";    } }else if($p == "specadmin"){     echo "<title>SPECADMIN order on IP</title>    <html>    <head>    <meta http-equiv="content-type" content="text/html; charset=utf-8">    <meta name="author" content="Skype = boxter7248">    <link rel="stylesheet" type="text/css" href="style.css">    <h3 class="catbg"><span class="left"></span>    SPECADMIN order on IP    </h3>    <div class="windowbg" style="padding: 3px;">    <div class="smalltext">    <font size="1" color="black">";        echo "<center>&nbsp;";        $r = mysql_query("SELECT * FROM sms1 WHERE `mod` = 'specadmin' ORDER BY id");        while ( $row = mysql_fetch_assoc($r) )     {        echo "<a href='order.php?p=specadmin&c=".$row['country']."&ingame=$ingame'><img src='img/flags/". str_replace(" ","_", strtolower($row['country'])).".gif'/></a>&nbsp;&nbsp;";    }     $r2 = mysql_query("SELECT * FROM sms1 WHERE `mod` = 'specadmin' AND `country` = '$c'");    $row2 = mysql_fetch_array($r2, MYSQL_ASSOC);    $r3 = mysql_query("SELECT * FROM amx_amxadmins WHERE `username` = '$ip'");    $row3 = mysql_fetch_array($r3, MYSQL_ASSOC);     if(!$row2){        if($row3){            if($row3[access] == "$vip_access"){                echo "<br><br>Your <b>VIP</b> end at <b>$row3[timeleft]</b>";            }else if($row3[access] == "$admin_access"){                echo "<br><br>Your <b>ADMIN</b> end at <b>$row3[timeleft]</b>";            }else if($row3[access] == "$specadmin_access"){                echo "<br><br>Your <b>SPECVIP</b> end at <b>$row3[timeleft]</b>";            }        }        echo "<br><br>Choose your country to order <b>SPECADMIN</b> on <b>IP</b>.";        die;    }        echo "<br><b>$c</b></center>";     $price = $row2[price]/100; 
Top
User avatar
V1LKAS
Flooderis arba specialistas
Posts: 612
Joined: 2012 Nov 08 12:55
Skype: darius489

Re: Bėda su Multimod sms sistema

Post by V1LKAS »

Code: Select all

$r = mysql_query("SELECT * FROM ebank WHERE `mod` = 'unban' LIMIT 1");
Turbūt nėra lentelėje ebank, įrašo pavadinimu 'unban'.

bandyk:

Code: Select all

ALTER TABLE  `ebank` CHANGE  `mod`  `mod` ENUM(  'vip',  'admin',  'specadmin',  'unban',) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
Jeigu pagal default.
Top
Zaidejas1
O taip. Jis jau surinko 50 žinučių!
Posts: 52
Joined: 2013 Jun 14 11:41

Re: Bėda su Multimod sms sistema

Post by Zaidejas1 »

Truputėlį nesupratau ką čia reikia padaryti.. :/
Top
User avatar
V1LKAS
Flooderis arba specialistas
Posts: 612
Joined: 2012 Nov 08 12:55
Skype: darius489

Re: Bėda su Multimod sms sistema

Post by V1LKAS »

Prisijunk į mysql db, ir SQL nukopijuok eilutę bei paspausk vygdyti.

Code: Select all

ALTER TABLE  `ebank` CHANGE  `mod`  `mod` ENUM(  'vip',  'admin',  'specadmin',  'unban') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
P.s oij ne į tą eilutę pažiūrėjau

Code: Select all

  $r = mysql_query("SELECT * FROM amx_bans WHERE player_ip = '$ip' ");    $row = mysql_fetch_array($r, MYSQL_ASSOC);     $r2 = mysql_query("SELECT ban_reason FROM amx_bans WHERE player_ip = '$ip' ");        $row2 = mysql_fetch_array($r2, MYSQL_ASSOC);      $reason = $row2['ban_reason'];      if(!$row) {        echo "Status: <b><span style="color:green">Not banned.</span></b><br>";    } else {        echo "Status: <b><span style="color:red">You have been banned!</span></b><br>Reason: <b>$reason</b><br><br>";
Last edited by V1LKAS on 2013 Jun 16 12:53, edited 3 times in total.
Top
Zaidejas1
O taip. Jis jau surinko 50 žinučių!
Posts: 52
Joined: 2013 Jun 14 11:41

Re: Bėda su Multimod sms sistema

Post by Zaidejas1 »

Gerai, padariau, bet vistiek ta pati klaida. :/
Top
Post Reply

Return to “Ne į temą”

Who is online

Users browsing this forum: No registered users and 2 guests