• 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!

Your website! (Modern AAC only)

Status
Not open for further replies.
Tibiamakers said:
the forum scritp give me a extrange sql error and about houses i have fixed right now .
this is the forum error :

PHP: 
A Database Error Occurred

Error Number: 1054

Unknown column 'b.guild' in 'where clause'

SELECT `b`.`id`, `b`.`name`, `b`.`description`, `b`.`closed`, `b`.`moderators`, `u`.`name` AS `author`, `p`.`thread_id`, `t`.`name` AS `thread_title`, `p`.`time` FROM `forums` AS `b` LEFT JOIN (SELECT `time`, `thread_id`, `board_id`, `author` FROM `posts` ORDER BY `time` DESC) AS `p` ON `p`.`board_id` = `b`.`id` LEFT JOIN `players` AS `u` ON `u`.`id` = `p`.`author` LEFT JOIN `threads` AS `t` ON `t`.`id` = `p`.`thread_id` WHERE `b`.`access` <= '5' AND (`b`.`guild` IS NULL OR `b`.`guild` IN (SELECT `guild_id` FROM guild_ranks WHERE `id` IN (SELECT rank_id FROM players WHERE account_id = '18'))) GROUP BY `b`.`id` ORDER BY `b`.`order` ASC;
Click to expand...

I explained how to upgrade from 0.2 to 1.0, not just replace the files but INSTALL again, as there are important DB changes.
 
I found the problem


I your post you say that i need to put this:
PHP: 
ALTER TABLE `forum` ADD `guild` int(11) unsigned DEFAULT NULL
;

but my file is called forumS

a noob error u,u
 
can you do a mkind of shop that works with premium_points and players can buy items from them (this is not for donations) but acts like them ... the premium_points can be get in-game on quests and stuff so please tell me if possible
 
Sure, poii.

But, you'll have to wait a few days since I am going on vacations this weekend.
 
I rlly think tha most important will be layouts i mean the ugly think about modernACC r the layouts ;/ thats why lots of ppls still using gesior ACC
 
Thanks archez! will be really helpful!, and thacore, you're right on that, layouts sucks, but you can make your own ;)
 
BUMP paxton or archerz can u do the script i requested for please?
 
poii said:
This project still working?
Click to expand...

Yes, this thread is still alive, but my computer died 2 days ago, and I've been very busy looking for a power supply to fill my graphics card needs. (I cannot just buy simple power supply)
 
Auction System ^^!
I ever got here, more is giving error, I've looked everyting and does not work ;x

Script PHP:
PHP: 
<?PHP
    require("config.php");

	$ots = POT::getInstance();
	$ots->connect(POT::DB_MYSQL, connection());
	$SQL = $ots->getDBHandle();
    $ide = new IDE;
    $config['site']['vdarkborder']='#FFFFFF';
    $config['site']['darkborder']='#D0D0D0';
    $config['site']['lightborder']='#B0B0B0';

    $auctions = $SQL->query('SELECT `auction_system`.`player`, `auction_system`.`id`, `auction_system`.`item_name`, `auction_system`.`item_id`, `auction_system`.`count`, `auction_system`.`cost`, `auction_system`.`date`, `players`.`name` FROM `auction_system`, `players` WHERE `players`.`id` = `auction_system`.`player` ORDER BY `auction_system`.`id`')->fetchAll();
    $players = 0;

    echo '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b>Instruction<b></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><center><h2>Commands</h2><b>!offer add, itemName, itemPrice, itemCount</b><br /><small>example: !offer add, plate armor, 500, 1</small><br /><br /><B>!offer buy, AuctionID</b><br /><small>example: !offer buy, 1943</small><br /><br /><b>!offer remove, AuctionID</b><br /><small>example: !offer remove, 1943</small><br /><br /><b>!offer withdraw</b><br /><small>Use this command to get money for sold items.</small></center></TR></TD></TABLE><br />';
    if(empty($auctions))
    {
        echo '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b>Auctions</b></td></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD>Currently is no one active Auction.</TD></TR></TABLE>';
    }
    else
    {

    foreach($auctions as $auction) {

            if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
        $cost = round($auction['cost']/1000, 2);
    $content .= "<TR BGCOLOR=".$bgcolor.">
    <TD><center>".$auction['id']."</center></TD>
    <TD><center><img src='http://www.nefs.es/images/items/".$auction['item_id'].".gif'/></center></TD>
    <TD><center>".$auction['item_name']."</center></TD>
    <TD><center><a href='".urlencode($auction['name'])."'>".$auction['name']."</a></center></TD>
    <TD><center>".$auction['count']."</center></TD>
    <TD><center>".$cost."k<br /><small>".$auction['cost']."gp</small></center></TD>
    <TD><center>!offer buy, ".$auction['id']."</center></TD></TR>";
     $players++;
    }

    echo '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b><center>ID</center></b></TD><TD class="white"><b><center>#</center></b></TD><TD class="white"><b><center>Item Name</center></b></TD><TD class="white"><b><center>Player</center></b></TD><TD class="white"><b><center>Count</center></b></TD><TD class="white"><b><center>Cost</center></b></td><TD class="white"><b><center>Buy</center></b></td></TR>';
    echo $content;
    echo '</TABLE>';
}
    ?>
Error:
PHP: 
A PHP Error was encountered

Severity: Notice

Message: Undefined variable: content

Filename: pages/auction.php

Line Number: 38

Thanks for Help!
 
I'll rewrite the auction system (PHP) as soon as I fix my computer.
 
I had some ideas but dont have really too much time to get it working or to create it. It would be a advanced admin panel injection that you would be able to put values into the database of a character like editing Lvl mana etc by custom fields. With a save option ^^ then i would make it better.. Regards pm me
 
Status
Not open for further replies.
Back
Top