Gesior AAC problem. Creating character and searching players

[Vapous]

I have a problem, site works fine in most aspects but when i search a player i get this error.


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'balance' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:111 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(111): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Player.php(139): OTS_Player->load('3') #2 C:\xampp\htdocs\characters.php(10): OTS_Player->find('Dulokz') #3 C:\xampp\htdocs\index.php(98): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 111


any idea why this is?

 

[Vapous]

lol sorry im a bit noob i got it all going fine thanks to you guys. one last thing tho ... donate works fine but how do i make it so paypal accepts the donateion automaticly??

 

[_Arthur]

Have you made a PayPal donate button?

 

[Vapous]

yeah the donate worked, i recieved payment, but i had to log on paypal and accept it. but now ive noticed the points didnt go on the account too....

 

[_Arthur]

http://otland.net/f118/gesior-aac-fixed-paypal-script-free-101818/

Also, you'll have to "accept" all donations. They will all be in your account though even if you don't "accept" them. :/

 

[Vapous]

ok got it working, but on the site it doesnt apear in the middle of the screen. the font etc appears at the top left.. how do i get it centered

 

[Cykotitan]

You must convert it to a php script.

 

[Vapous]

it is a php file... :/

 

[Cykotitan]

Then it needs to be converted. derp.
Post it! (paypal.php) and don't forget to censor sensitive data.

 

[Vapous]

<b>PayPal Shop System.</b><br><br>
The shop costs:<ul><li> 1 EUR (for 5 points)</li><li> 10 EUR (for 15 points)</li><li> 20 EUR (for 32 points)</li><br>

<b>Here are the steps you need to make:</b> <br>
1. A PayPal account with a required balance [1, 10 or 20 EUR] or a creditcard. <br>
2. Fill in your account number. <br>
3. Click on the Buy Now button or your creditcard brand. <br>
4. Make a transaction. <br>
5. After the transaction 5, 15 or 30 points will be automatically added to your account. <br>
6. Go to Item shop and use your points <br> <br> <br> </b>

<span style="color:red">If you recall the money, and your premiumpoints can't be recalled your account will be deleted</span>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="EMAIL">
<input type="hidden" name="lc" value="US">
<input type="hidden" name="item_name" value="Rampage Premium points">
<b>Account name/login:</b> <input type="text" name="custom" value="">

<select name="amount">
<option value="1.00">1 EUR</option>
<option value="10.00">10 EUR</option>
<option value="20.00">20 EUR</option>
</select>
<input type="hidden" name="button_subtype" value="products">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="notify_url" value="http://xxxxxxxxxx//paypal/ipn/ipn.php">
<input type="hidden" name="return" value="http://xxxxxxxxxx">
<input type="hidden" name="rm" value="0">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHostedGuest">
<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>

 

[Cykotitan]

<?PHP
$main_content .= '<b>PayPal Shop System.</b><br><br>
The shop costs:<ul><li> 1 EUR (for 5 points)</li><li> 10 EUR (for 15 points)</li><li> 20 EUR (for 32 points)</li><br>

<b>Here are the steps you need to make:</b> <br>
1. A PayPal account with a required balance [1, 10 or 20 EUR] or a creditcard. <br>
2. Fill in your account number. <br>
3. Click on the Buy Now button or your creditcard brand. <br>
4. Make a transaction. <br>
5. After the transaction 5, 15 or 30 points will be automatically added to your account. <br>
6. Go to Item shop and use your points <br> <br> <br> </b>

<span style="color:red">If you recall the money, and your premiumpoints can\'t be recalled your account will be deleted</span>

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="EMAIL">
<input type="hidden" name="lc" value="US">
<input type="hidden" name="item_name" value="Rampage Premium points">
<b>Account name/login:</b> <input type="text" name="custom" value="">

<select name="amount">
<option value="1.00">1 EUR</option>
<option value="10.00">10 EUR</option>
<option value="20.00">20 EUR</option>
</select>
<input type="hidden" name="button_subtype" value="products">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="notify_url" value="http://xxxxxxxxxx//paypal/ipn/ipn.php">
<input type="hidden" name="return" value="http://xxxxxxxxxx">
<input type="hidden" name="rm" value="0">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHostedGuest">
<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>';
?>

Keep in mind that the file extension HAS to be .php!
Add this in index.php:

	case "paypal";
		$topic = "Paypal";
		$subtopic = "paypal";
		include("paypal/paypal.php");
	break;

In buypoints.php, replace:

if ($_REQUEST['system'] == 'paypal' && $config['paypal_active']) {
$content = file_get_contents("paypal/paypal.htm");
	$main_content .= $content;
}

with:

if ($_REQUEST['system'] == 'paypal' && $config['paypal_active'])
	header( 'Location: /paypal/paypal.php' );

 

[Vapous]

Your brilliant Thank you so much! learnt so much from you and arthur thanks!

 

[Cykotitan]

Now test it ;s

 

[Vapous]

its works thanks alot. i know this has nothing to do with it but does hosting an ot server use alot of mbs? i mean will i run up an internet bill lol!?

 

[Cykotitan]

Depends on how much traffic you have. If you have a limited bandwidth quota, you better not be hosting on that connection.

 

[XxShallowxX]

ok well im using Gesior Acc-0.3.6 on roxor 8.54 The Forgotten Server Version 0.2.7. havnt made servers in a long time what do u sujest i do??

Try using TFS 0.3.6