Lua Gesior ACC - Buy Characters.

[Potar]

Hello i have http://otland.net/f118/gesior-acc-sell-characters-auctions-buy-now-premium-points-126561/ script.
And i have one question, how to change or where i can add one function, if I added the character he cant log_in like set account_id in database to : 1 (account where are all the characters for sale).

 

[sn3ejk]

Try

function onLogin(cid)
	local character = db.getResult("SELECT * FROM `characters_auctions` WHERE `state` = 0 AND `finish_time` <= ".. time() .." AND char_id = ".. getPlayerGUID(cid) ..";")
	if (character:getID() ~= -1) then
		doPlayerPopupFYI(cid, "This character is locked.")
		return false
	end
	return true
end

 

[Potar]

It probably working but i need something other, if you press "Add Auction" The character have automatically set account_id to 1. (in php)

 

[sn3ejk]

Below

$SQL->query('INSERT INTO `characters_auctions` (`id` ,`finish_time` ,`char_id` ,`buy_now` ,`bid` ,`bidder`) VALUES (NULL , ' . (time() + $auctionTime) . ', ' . $id . ', ' . $priceBuyNow . ', ' . $priceAuction . ', 0);');

Add

$SQL->query("UPDATE `players` SET `account_id` = 1 WHERE `id` = ". $id .";");

 

[Potar]

It doesn't work without any errors.

 

[Potar]

ref