Auctions

[rulerofzu]

Obviously not.

Test it with removal of the ctype check ....if it works then you have a issue elsewhere.

[iSOS]

It happens when you have the l33t script in your header that 'secures' everything.

[thebobby]

so wat am i suppose to do then can remove secruity

[rulerofzu]

What you need to do is secure things properly rather than putting stuff into the header and keeping your fingers crossed that it covers everything.

[mr_shuu]

It seems to work BUT

I can add AN item to Auction, bid on it... but after adding three other items, which seem to go through, the Auction Market shows only the one and very first item.

Another player added an item and that shows. Is it that only one item per ID?

I'll check the code when I get back ...I have to do food shopping.

[criminal wars]

Getting money back

i personally think you should bid what ever you want but the money should not be taken off you util you win the item also say like you bid something very high but you win it and dont have the cash or crystals to pay that amount you bidded it should give you a negative balance to make you not try doing it again and teach you that its easy bidding what ever amount but not paying that easily :thumbsup:

 

or

like give you certain amount of days say some thing like 3 days an if you can arrange money within them day you get banned from auction for 3-4days or W.E

also this will enocourange the player to work harder to earn the money ....

[criminal wars]

little help

just wantted to know i have placed auction tab in explore and wannted to put like how many auction are going on so for example

itemmarket

market

blah

blah

auction house [3]

so basically instead of the 3 which is a example i want to put how many bid are on from the database can any ne give me the little code thing that pulls this data out from the database :thumbsup:

[lucky3809]

@criminal wars

I dont use this mod or really looked at the coding of it but if im right...

You need to update the gAuctionBids table and add BidCount int 0 ...

Then make a query to update the count under the bid function where players places the bid, so it counts the bids placed... then just add the {$r['BidCount']} where ever you want it to show.

Also dont forget to change the insert query and add '' after the last insert.

Unless someone has a better way then what i have gaven, this is what i do to get the count lol.

[criminal wars]

can you give me the table sql and the queary to insert please

[Blade Maker]

ALTER TABLE `gAuctionBids` add column `BidCount` int(11) NOT NULL ;

[criminal wars]

thanks blade can i get queary please?

[Blade Maker]

mysql_query("UPDATE `gAuctionBids` SET BidCount=BidCount+1 WHERE (`ID` = ".abs(intval($_GET['ID'])).")");

[lucky3809]

Here you go Bid count ...

Sql:

ALTER TABLE `gAuction` add column `BidCount` int(11) NOT NULL ;

Open Auction.php

Under Index function find:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Replace With:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Under Bid function find:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Above it Add:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Under Add function find:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Replace with:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Then if your posting the count on Auction page you add

'.$aData['BidCount'].'

If your posting on another page you need to make a query similar to the one your replacing under the index function.

Sorry about having you add it to gAuctionBids table that was wrong of me lol. I had to upload the code to see what table to put it under.

[The Bonded Game]

looks great will be adding!

[Glasses]

How do i make it so it shows the sellers username instead of id ?

Thanks

[Glasses]

Can anyone do this please?

[iPanel]

when i press the add to auction button i receive the following error

Unknown column 'it.itmi d' in 'field list'

[sniko]

when i press the add to auction button i receive the following error

Unknown column 'it.itmi d' in 'field list'

remove the space between "i" and "d" in the query :)

Line 144 - Auction.php

-sniko

[iPanel]

remove the space between "i" and "d" in the query :)

Line 144 - Auction.php

-sniko

Thanks man it works! But i received another error

when i press the add to auction button...

An error has occurred, please go back and try again.

[sniko]

Simple test.

Add this to line 145;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

If it returns above 0, it's something to do with the $_GET.

So change ctype_digit (line 146) to is_numeric

-sniko

[iPanel]

Simple test.

Add this to line 145;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

If it returns above 0, it's something to do with the $_GET.

So change ctype_digit (line 146) to is_numeric

-sniko

I added

 

echo $db->num_rows($Data);

and returns 0

changed the line 146 and: An error has occurred, please go back and try again.

[sniko]

As it returns a 0, make sure;

1. The item ID exists in the items table
   
2. You own the item
   
3. $_GET['ID'] has an actual value
   

 

and reply with results please.

Thanks,

-sniko

[iPanel]

when i add the echo

$db->num_rows($Data);

the error message not appear, and i not see nothing, but if i delete echo

$db->num_rows($Data);

the error message will back

[morgan1122]

Getting this error :( Unknown column 'Time Left' in 'field list'

[lucky3809]

Time Left is not in your table in your database you need to add it why your getting that error