• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Gesior Shop-System] Shop Admin Page v4

Need help if i buy with my points equipment then it doesnt appear in the server, i logged out and then in but it isnt still there, other functions like name change etc. are working but not items

anyone could help me?
 
Comtek said:
Need help if i buy with my points equipment then it doesnt appear in the server, i logged out and then in but it isnt still there, other functions like name change etc. are working but not items

anyone could help me?
Click to expand...

check in your events.
 
When i want add points to a character with this name example: Mon'Xa <<<---

With --> ' <--

Get this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e'' at line 1' in C:\xampp\htdocs\DovuX\shopadmin.php:271 Stack trace: #0 C:\xampp\htdocs\DovuX\shopadmin.php(271): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\DovuX\index.php(118): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\DovuX\shopadmin.php on line 271
Click to expand...

Cant you fix? plzzz
 
Laxiaa said:
Why cant I see picture of the item?
Click to expand...

@up

Nvm it works already




When I click on VIEW SHOP OFFER (EDIT/DELETE) in shop panel admin
it shows :


Warning: simplexml_load_file() [function.simplexml-load-file]: file:///C:/Documents%20and%20Settings/Maciek/Pulpit/OTS/otsor/data/items/items.xml:1591: parser error : error parsing attribute name in C:\xampp\htdocs\shopadmin.php on line 94

Warning: simplexml_load_file() [function.simplexml-load-file]: </item> in C:\xampp\htdocs\shopadmin.php on line 94

Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in C:\xampp\htdocs\shopadmin.php on line 94

Warning: simplexml_load_file() [function.simplexml-load-file]: file:///C:/Documents%20and%20Settings/Maciek/Pulpit/OTS/otsor/data/items/items.xml:1591: parser error : attributes construct error in C:\xampp\htdocs\shopadmin.php on line 94




Its is 94 line: $items = simplexml_load_file($config['site']['server_path'].'data/items/items.xml') or die('<b>Could not load items!</b>');



Whats wrong?
 
good, thnx norix :) working fine
 
ok so i added the code to the index file

case "shopadmin";
$subtopic = "shopadmin";
$topic = "Shop Admin";
include("shopadmin.php");
break;

but now my shop admin page just comes up blank. im using TFS 0.3.5

maybe its to buggy?
 
Hi

My donation system is not work correct.
I can buy Points, but when I'm trying to get my points with a pin code it's says that I got a wrong code!

What have I done wrong?

This is my buypoint.php take a look please.

<?PHP
#################### CONFIG ###################################################
#aktywacja dotpay oraz dostepych systemow platnosci, wartosci: true / false
$config['dotpay'] = array();
$config['dotpay_active'] = false; #active dotpay system?
$config['dotpay_active_sms'] = false; #active dotpay system?
$config['dotpay_active_transfer'] = true; #active dotpay system?
# przykladowy konfig dla SMS
$config['dotpay'][0]['id'] = 21468; # numer ID zarejestrowanego klienta
$config['dotpay'][0]['code'] = "DEB3"; # identyfikator uslug SMS
$config['dotpay'][0]['type'] = "sms"; # typ konta: C1 - 8 znakowy kod bezobslugowy, sms - dla sprawdzania SMSow
$config['dotpay'][0]['addpoints'] = 100; # ile premium punktow daje dany sms
$config['dotpay'][0]['sms_number'] = 73068; # numer na jaki nalezy wyslac kod
$config['dotpay'][0]['sms_text'] = "AP.DEB3"; # tresc jaka ma byc w SMSie
$config['dotpay'][0]['sms_cost'] = "3.66 zl brutto"; # cena za wyslanie sms
# przykladowy konfig dla przelewu bankowego/karty kredytowej
$config['dotpay'][1]['id'] = 21468; # numer ID zarejestrowanego klienta
$config['dotpay'][1]['code'] = "DEBT"; # identyfikator uslug SMS
$config['dotpay'][1]['type'] = "C1"; # typ konta: C1 - 8 znakowy kod bezobslugowy, sms - dla sprawdzania SMSow
$config['dotpay'][1]['addpoints'] = 400; # ile premium punktow daje dany sms
$config['dotpay'][1]['sms_number'] = ""; # numer na jaki nalezy wyslac kod
$config['dotpay'][1]['sms_text'] = "DEBT"; # tresc jaka ma byc w SMSie
$config['dotpay'][1]['sms_cost'] = "5 zl brutto"; # cena za wyslanie sms
# activation of DaoPay system
$config['daopay'] = array();
$config['daopay_active'] = true; #active daopay system?
# example config for daopay
$config['daopay'][0]['appcode'] = 54979; #
$config['daopay'][0]['prodcode'] = '3'; #
$config['daopay'][0]['addpoints'] = '3'; #
$config['daopay'][0]['cost'] = "3 euro inc. VAT"; #

$config['daopay'][1]['appcode'] = 54979; #
$config['daopay'][1]['prodcode'] = '4'; #
$config['daopay'][1]['addpoints'] = '4'; #
$config['daopay'][1]['cost'] = "4 euro inc. VAT"; #

$config['daopay'][2]['appcode'] = 54979; #
$config['daopay'][2]['prodcode'] = '5'; #
$config['daopay'][2]['addpoints'] = '5'; #
$config['daopay'][2]['cost'] = "5 euro inc. VAT"; #

$config['daopay'][3]['appcode'] = 54979; #
$config['daopay'][3]['prodcode'] = '6'; #
$config['daopay'][3]['addpoints'] = '8'; #
$config['daopay'][3]['cost'] = "6 euro inc. VAT"; #

$config['daopay'][4]['appcode'] = 54979; #
$config['daopay'][4]['prodcode'] = '7'; #
$config['daopay'][4]['addpoints'] = '12'; #
$config['daopay'][4]['cost'] = "8 euro inc. VAT"; #

$config['daopay'][5]['appcode'] = 54979; #
$config['daopay'][5]['prodcode'] = '8'; #
$config['daopay'][5]['addpoints'] = '30'; #
$config['daopay'][5]['cost'] = "16 euro inc. VAT"; #


#################################################################################
function save_trans($file, $acc, $code)
{
$hak = fopen($file, "a");
fwrite($hak, $code.'='.$acc.'
');
fclose($hak);
}

function check_code_daopay($appcode, $prodcode, $pin)
{
$handle = fopen("http://DaoPay.com/svc/PINcheck?appcode=".$appcode."&subkey=".$prodcode."&pin=".$pin, 'r');
if ($handle)
{
$status = fgets($handle, 128);
fclose($handle);
if($status[0] == 'o' && $status[1] == 'k')
{

$return = 1;
}
else
$return = 2;
}
else
$return = 3;
return $return;
}

function check_code_dotpay($code, $posted_code, $user_id, $type)
{
$handle = fopen("http://dot.pl/check_code.php?id=".$user_id."&code=".$code."&check=".$posted_code."&type=".$type."&del=0", 'r');
$status = fgets($handle, 8);
$czas_zycia = fgets($handle, 24);
fclose($handle);
$czas_zycia = rtrim($czas_zycia);
return array($status, $czas_zycia);
}

function delete_code_dotpay($code, $posted_code, $user_id, $type)
{
$handle = fopen("http://dotpay.pl/check_code.php?id=".$user_id."&code=".$code."&check=".$posted_code."&type=".$type."&del=1", 'r');
fclose($handle);
}

function add_points(OTS_Account $account, $number_of_points)
{
if($account->isLoaded())
{
$account->setCustomField('premium_points', ($account->getCustomField('premium_points')+$number_of_points));
return true;
}
else
return false;
}


if ($_REQUEST['system'] == 'daopay' && $config['daopay_active'])
{
#################################################################################
$offer_id = (int) $_POST['offer_id'];
$posted_pincode = trim($_POST['pincode']);
$to_user = trim($_POST['to_user']);
$verify_code = trim($_POST['verify_code']);
#################################################################################
if(!empty($to_user))
{
if(is_numeric($to_user))
{
$account = new OTS_Account();
$account->load($to_user);
}
else
{
$player = new OTS_Player();
$player->find($to_user);
if($player->isLoaded())
$account = $player->getAccount();
else
$account = new OTS_Account();
}

if(empty($posted_pincode))
$errors[] = 'Please enter your PIN code.';

if(!$account->isLoaded())
$errors[] = 'Account/account of player with this name doesn\'t exist.';
if(count($errors) == 0)
{
if($config['site']['verify_code_shop'] == 'yes')
{
//check verification code
$string = strtoupper($_SESSION['string']);
$userstring = strtoupper($verify_code);
$_SESSION['string'] = mt_rand(1,99999);
if(empty($string))
$errors[] = "Code from verification image in session is empty, try again.";
else
{
if(empty($userstring))
$errors[] = "Please enter code from verification image.";
else
{
if($string != $userstring)
$errors[] = "Code from verification image is wrong.";
}
}
}

if(count($errors) == 0)
{
$code_info = check_code_daopay($config['daopay'][$offer_id]['appcode'], $config['daopay'][$offer_id]['prodcode'], $posted_pincode);
if($code_info == 3)
$errors[] = 'Server has problem with connection to daopay.com, can\'t verify PIN code.';
elseif($code_info == 2)
$errors[] = 'Wrong PIN code, try to enter code again.';
elseif($code_info == 1)
{
if(add_points($account, $config['daopay'][$offer_id]['addpoints']))
{
save_trans('trans/daopay.log', $account->getId(), $posted_pincode);
$main_content .= '<h2><font color="red">Good PIN code. Added '.$config['daopay'][$offer_id]['addpoints'].' Premium Points to account of: '.$to_user.' !</font></h2>';
}
else
$errors[] = 'Error occured, try again.';
}
}
}
}
if(count($errors) > 0)
{
$main_content .= '<font color="red"><b>Errors occured:</b></font>';
foreach($errors as $error)
$main_content .= '<br />* '.$error;
$main_content .= '<hr /><hr />';
}
$main_content .= 'Buy Premium Points. For this points you can buy pacc/items in Shop. To buy points:<br />
1. Visit one of our pages and donate us (send SMS/call special number).<br />
2. After donate daopay.com will show you PIN code.<br />
3. Save somewhere this PIN code and open this page again.<br />
4. Enter your character name or account and your PIN code in form below.<br />
5. Select donation cost from list and press "Check Code".<br />
6. If account and PIN code is valid you get premium points.<br />
7. Open "Shop Offer" and buy items/pacc :)<br />
<font color="red"><b>Our pages:</b></font>';
foreach($config['daopay'] as $offer)
$main_content .= '<br /><b>* Address <font color="red"><a href="http://daopay.com/payment/?appcode='.urlencode($offer['appcode']).'&prodcode='.urlencode($offer['prodcode']).'">http://daopay.com/payment/?appcode='.$offer['appcode'].'&prodcode='.$offer['prodcode'].'">https://daopay.com/svc/pay.svc?tidkey='.$offer['appcode'].'&subkey='.$offer['prodcode'].'</a></font> - <font color="red"><b>'.$offer['cost'].'</b></font> - <font color="red"><b>'.$offer['addpoints'].'</b></font> premium points</b>';
$main_content .= '<hr /><form action="index.php?subtopic=buypoints&system=daopay" method="POST"><table>';
$main_content .= '<tr><td><b>Player name or account number: </b></td><td><input type="text" size="20" value="'.$to_user.'" name="to_user" /></td></tr>
<tr><td><b>PIN code: </b></td<td><input type="text" size="20" value="'.$posted_pincode.'" name="pincode" /></td></tr><tr><td><b>Offer type: </b></td><td><select name="offer_id">';
foreach($config['daopay'] as $id => $offer)
$main_content .= '<option value="'.$id.'">'.$offer['prodcode'].' - cost '.$offer['cost'].' - points '.$offer['addpoints'].'</option>';
$main_content .= '</select></td></tr>';
if($config['site']['verify_code_shop'] == 'yes')
$main_content .= '<tr><td><B>Verify code: </B></td><td><img src="imgverification/imagebuilder.php?image_refresher='.mt_rand(1,99999).'" border="0" alt=""></td></tr>
<tr><td><B>Enter verify code: </B></td><td><INPUT id="verify" NAME="verify_code" VALUE="" SIZE=30></td></tr>';
$main_content .= '<tr><td></td><td><input type="submit" value="Check Code" /></td></tr></table></form>';
}
elseif ($_REQUEST['system'] == 'dotpay' && $config['dotpay_active'])
{
#################################################################################
$sms_type = (int) $_POST['sms_type'];
$posted_code = trim($_POST['code']);
$to_user = trim($_POST['to_user']);
$verify_code = trim($_POST['verify_code']);
#################################################################################
if(!empty($to_user))
{
if(is_numeric($to_user))
{
$account = new OTS_Account();
$account->load($to_user);
}
else
{
$player = new OTS_Player();
$player->find($to_user);
if($player->isLoaded())
$account = $player->getAccount();
else
$account = new OTS_Account();
}

if(empty($posted_code))
$errors[] = 'Prosze wpisac kod z SMSa/przelewu.';

if(!$account->isLoaded())
$errors[] = 'Konto/konto postaci o podanym nicku nie istnieje.';

if(count($errors) == 0)
{
if($config['site']['verify_code_shop'] == 'yes')
{
//check verification code
$string = strtoupper($_SESSION['string']);
$userstring = strtoupper($verify_code);
$_SESSION['string'] = mt_rand(1,99999);
if(empty($string))
$errors[] = "Kod z obrazka weryfikacyjnego w sesji jest pusty, sproboj ponownie.";
else
{
if(empty($userstring))
$errors[] = "Prosze wpisac kod z obrazka weryfikacyjnego.";
else
{
if($string != $userstring)
$errors[] = "Kod z obrazka weryfikacyjnego jest niepoprawny.";
}
}
}

if(count($errors) == 0)
{
$code_info = check_code_dotpay($config['dotpay'][$sms_type]['code'], $posted_code, $config['dotpay'][$sms_type]['id'], $config['dotpay'][$sms_type]['type']);
if($code_info[0] == 0)
$errors[] = 'Podany kod z SMSa/przelewu jest niepoprawny lub wybrano zla opcje SMSa/przelewu.';
else
{
if(add_points($account, $config['dotpay'][$sms_type]['addpoints']))
{
save_trans('trans/dotpay.log', $account->getId(), $posted_code);
$code_info = delete_code_dotpay($config['dotpay'][$sms_type]['code'], $posted_code, $config['dotpay'][$sms_type]['id'], $config['dotpay'][$sms_type]['type']);
$main_content .= '<h1><font color="red">Dodano '.$config['dotpay'][$sms_type]['addpoints'].' punktow premium do konta: '.$to_user.' !</font></h1>';
}
else
$errors[] = 'Wystapil blad podczas dodawania punktow do konta, sproboj ponownie.';
}
}
}
}
if(count($errors) > 0)
{
$main_content .= 'Wystapily bledy:';
foreach($errors as $error)
$main_content .= '<br />* '.$error;
$main_content .= '<hr /><hr />';
}
if($config['dotpay_active_sms'])
{
$main_content .= '<h2>SMS</h2>Kup punkty premium, mozesz je wymienic w sklepie OTSa na PACC/przedmioty w grze, aby zakupic punkty premium wyslij SMSa:';
foreach($config['dotpay'] as $sms)
if($sms['type'] == 'sms')
$main_content .= '<br /><b>* Na numer <font color="red">'.$sms['sms_number'].'</font> o tresci <font color="red"><b>'.$sms['sms_text'].'</b></font> za <font color="red"><b>'.$sms['sms_cost'].'</b></font>, a za kod dostaniesz <font color="red"><b>'.$sms['addpoints'].'</b></font> punktow premium.</b>';
$main_content .= '<br />W SMSie zwrotnym otrzymasz specjalny kod. Wpisz ten kod w formularzu wraz z nickiem postaci lub numerem konta osoby ktora ma otrzymac punkty.<br />
Serwis SMS obslugiwany przez <a href="http://www.dotpay.pl" target="_blank">Dotpay.pl</a><br />
Regulamin: <a href="http://www.dotpay.pl/regulaminsms" target="_blank">http://www.dotpay.pl/regulaminsms</a><br />
Usluga dostepna w sieciach: Orange, Plus GSM, Era.<br />
<b>'.$config['server']['serverName'].'</b> nie odpowieda za zle wpisane tresci SMS.<hr />';
}
if($config['dotpay_active_transfer'])
{
$main_content .= '<h2>Przelew/karta kredytowa</h2>Kup punkty premium, mozesz je wymienic w sklepie OTSa na PACC/przedmioty w grze, aby zakupic punkty premium wejdz na jeden z adresow i wypelnij formularz:';
foreach($config['dotpay'] as $przelew)
if($przelew['type'] == 'C1')
$main_content .= '<br /><b>* Adres - <a href="https://ssl.allpay.pl/?id='.$przelew['id'].'&code='.$przelew['code'].'"><font color="red">https://ssl.allpay.pl/?id='.$przelew['id'].'&code='.$przelew['code'].'</font></a> - koszt <font color="red"><b>'.$przelew['sms_cost'].'</b></font>, a za kod dostaniesz <font color="red"><b>'.$przelew['addpoints'].'</b></font> punktow premium.</b>';
$main_content .= 'Kiedy Twoj przelew dojdzie (z kart kredytowych i bankow internetowych z listy jest to kwestia paru sekund) na e-mail ktory podales w formularzu otrzymasz kod. Kod ten mozesz wymienic na tej stronie na punkty premium w formularzu ponizej.<hr />';
}
$main_content .= '<form action="index.php?subtopic=buypoints&system=dotpay" method="POST"><table>';
$main_content .= '<tr><td><b>Nick postaci lub numer konta: </b></td><td><input type="text" size="20" value="'.$to_user.'" name="to_user" /></td></tr>
<tr><td><b>Kod z SMSa: </b></td<td><input type="text" size="20" value="'.$posted_code.'" name="code" /></td></tr><tr><td><b>Typ wyslanego SMSa: </b></td><td><select name="sms_type">';
foreach($config['dotpay'] as $id => $sms)
if($sms['type'] == 'sms')
$main_content .= '<option value="'.$id.'">numer '.$sms['sms_number'].' - kod '.$sms['sms_text'].' - SMS za '.$sms['sms_cost'].'</option>';
elseif($przelew['type'] == 'C1')
$main_content .= '<option value="'.$id.'">przelew - kod '.$sms['sms_text'].' - za '.$sms['sms_cost'].'</option>';
$main_content .= '</select></td></tr>';
if($config['site']['verify_code_shop'] == 'yes')
$main_content .= '<tr><td><B>Kod weryfikacji: </B></td><td><img src="imgverification/imagebuilder.php?image_refresher='.mt_rand(1,99999).'" border="0" alt=""></td></tr>
<tr><td><B>Wpisz kod weryfikacji: </B></td><td><INPUT id="verify" NAME="verify_code" VALUE="" SIZE=30></td></tr>';
$main_content .= '<tr><td></td><td><input type="submit" value="Sprawdz" /></td></tr></table></form>';

}
else
{
if($config['dotpay_active'])
$main_content .= '<br /><br /><a href="index.php?subtopic=buypoints&system=dotpay"><h2>For users from Poland - LINK</h2></a><h3>Zaplac SMS, karta kredytowa lub przelewem bankowym.</h3>';
if($config['daopay_active'])
$main_content .= '<br /><br /><a href="index.php?subtopic=buypoints&system=daopay"><h2>PRESS HERE TO DONATE</h2></a><h3>Send SMS (not for all countries) or call special number to donate and get points.

<img src="http://daopay.com/logos/daopay-logo-70x31.gif" width="70" height="31" alt="doapay" />

</h3>';

}
?>
 
Yes, it works with v6, But i will update my modified AAC so it will be implented then...
 
when i add ALTER TABLE `z_shop_offer` ADD `pid` INT( 11 ) NOT NULL DEFAULT '0' i get this error.
#1060 - Duplicate column name 'pid'
 
Hey, if i pay a item with points in website, where i can get that item?

For example a Mpa id 2472, count 1 only ¬¬ i go to purchase the item and enter with my char and nothings apper, halp please ;(
 

Similar threads

Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
497
Czorcik
Czorcik
Back
Top