Shop System Full! [Modern AAC]

AODOT · Apr 20, 2011

can someone say how to set it up on gesior cuz gesior dont have htdocs and where should i place the files exactly!

psilocibe · Apr 20, 2011

HELP PLZ
I can not add items, the shop does not work with me, I'm using 1.0.2 Modern Acc

I can not add items
I can not add point
I do not know what else to do

please someone help me

psilocibe · Apr 20, 2011

Help !

Sweddy · Apr 20, 2011

It dosnt add points when u buy...

rudger · Apr 21, 2011

Awesome shop, but is there a way to fix on which order they are?

agomez · Apr 23, 2011

bumping my issue, Paypal IPN = Dont sending :S!
if you donate by paypal dont give you the points automatically

Outlaww · May 10, 2011

can someone make a slow tutorial with screen shots and stuffs on how to install it from start to end for retarded peoples like me XD ive been trying to install this to my website for 5 days now and it dosent seem to work XD

Outlaww · May 10, 2011

well i succesfully installed it. sorry for double post i donno how to edit

but i still got one problem. when i buy stuffs i get like 10000000000 of each untill my cap is full or got no inventory

xTremoxx · May 13, 2011

Outlaww said:
well i succesfully installed it. sorry for double post i donno how to edit

but i still got one problem. when i buy stuffs i get like 10000000000 of each untill my cap is full or got no inventory

Same problem here, 0.4 ;B

Elexonic · May 14, 2011

this update has some bugs .. along the track there is some fix. but I'm waiting to have if andrespro can repair bugs and then it will go well at all ..

Up: Test This shop.lua

-

-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
if(result_plr:getID() ~= -1) then
while(true) do
id = tonumber(result_plr:getDataInt("id"))
action = tostring(result_plr:getDataString("action"))
delete = tonumber(result_plr:getDataInt("delete_it"))
cid = getCreatureByName(tostring(result_plr:getDataString("name")))
if isPlayer(cid) == TRUE then
local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
local container_id = tonumber(result_plr:getDataInt("param3"))
local container_count = tonumber(result_plr:getDataInt("param4"))
local add_item_type = tostring(result_plr:getDataString("param5"))
local add_item_name = tostring(result_plr:getDataString("param6"))
local received_item = 0
local full_weight = 0
if add_item_type == 'container' then
full_weight = getItemWeightById(itemtogive_id, 1)
end
local free_cap = getPlayerFreeCap(cid)
if full_weight <= free_cap then
if add_item_type == 'container' then
local new_container = doCreateItemEx(container_id, 1)
local iter = 0
while iter ~= container_count do
doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
iter = iter + 1
end
received_item = doPlayerAddItemEx(cid, new_container)
else
local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
received_item = doPlayerAddItemEx(cid, new_item)
end
if received_item == RETURNVALUE_NOERROR then
doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
db.query("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
doPlayerSave(cid)
end
end
end
if not(result_plr:next()) then
break
end
end
result_plr:free()
end
return TRUE
end

xTremoxx · May 14, 2011

don't work.

RaikND · May 27, 2011

this system got a BUG for clone, i know it

HeberPcL · May 27, 2011

Kofels said:
LOL'd when saw source of that script.

PHP:

if($SQL->query('SELECT * FROM shop_offer WHERE id = '.$product.'')->fetch()) { $info = $SQL->query('SELECT * FROM shop_offer WHERE id = '.$product.'')->fetch();

Yes, we like double up queries. It's 108 line of gifts/gifts.php.

Next, let's look two lines above.

PHP:

$product = $this->uri->segment(5);

I didn't know how URI class implements vulnerability chars (I looked quickly, and It's taken from Code Igniter framework, and these doesn't escape ' char for example). It's bad habit, let's do integer casting before embed in SQL. (mysql_real_escape or something for strings). I hope that URI class successfully make this code secure.

But wait.

Line 178:

PHP:

if($SQL->query('SELECT * FROM players WHERE name = "'.$_POST['other_char'].'"')->fetch())

Oh, cmon guys. :/

I disliked this script. I revive it for others.

How Fix?

RaikND said:
this system got a BUG for clone, i know it

Can you talk more about the problem?

dgaban · May 28, 2011

Hey. My table of Shop and ETC not working. SEE :

Why dont have Shop Table? please help-me !

dgaban · May 28, 2011

More one question:

This shop work with PagSeguro? fast please !

God Nixez · Jun 3, 2011

reupload please.

Thanks

HeberPcL · Jun 4, 2011

GlobalEvents/Shop.lua

PHP:

function onThink(interval, lastExecution, thinkInterval)

	local result = db.getResult("SELECT * FROM shop_history WHERE `processed` = 0;")
	
		if(result:getID() ~= -1) then
			while(true) do
				cid = getCreatureByName(tostring(result:getDataString("player")))
				product = tonumber(result:getDataInt("product"))
				itemr = db.getResult("SELECT * FROM shop_offer WHERE `id` = "..product..";")
					if isPlayer(cid) then
						local id = tonumber(itemr:getDataInt("item"))
						local tid = tonumber(result:getDataInt("id"))
						local count = tonumber(itemr:getDataInt("count"))
						local tipe = tonumber(itemr:getDataInt("type"))
						local productn = tostring(itemr:getDataString("name"))
							if isInArray({5,8},tipe) then
								if getPlayerFreeCap(cid) >= getItemWeightById(id, count) then
									if isContainer(getPlayerSlotItem(cid, 3).uid) then
										received = doAddContainerItem(getPlayerSlotItem(cid, 3).uid, id,count)
										if received then
											doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop system")
											db.executeQuery("UPDATE `shop_history` SET `processed`='1' WHERE id = " .. tid .. ";")
										else
											doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough space on container to receive >> "..productn.." <<")
										end
									else
										doPlayerSendTextMessage(cid,19, "Sorry, you don't have a container to receive >> "..productn.." <<")
									end
								else
									doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough capacity to receive >> "..productn.." << (You need: "..getItemWeightById(id, count).." Capacity)")
								end
							elseif isInArray({6,7},tipe) then
									if tipe == 6 then
										bcap = 8
										bid = 1987
									elseif tipe == 7 then
										bcap = 20
										bid = 1988
									end
									if isItemRune(id) then
										count = 1
									end
									if getPlayerFreeCap(cid) >= (getItemWeightById(1987, 1) + getItemWeightById(id,count * bcap)) then
										local bag = doCreateItemEx(bid, 1)
											for i = 1,bcap do
												doAddContainerItem(bag, id, count)
											end
										received = doPlayerAddItemEx(getPlayerSlotItem(cid, 3).uid, bag)
										 
										if received == RETURNVALUE_NOERROR then
											doPlayerSendTextMessage(cid,19, "You have received >> "..productn.." << from our shop system")
											db.executeQuery("UPDATE `shop_history` SET `processed`='1' WHERE id = " .. tid .. ";")
										else
											doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough space to receive >> "..productn.." <<")
										end
									else
										doPlayerSendTextMessage(cid,19, "Sorry, you don't have enough capacity to receive >> "..productn.." << (You need: "..getItemWeightById(id, count).." Capacity)")
									end
							end
					end
				itemr:free()
				if not(result:next()) then
					break
				end
			end
			result:free()
		end
	return true
end

Error:

PHP:

[17:18:45.057] [Error - GlobalEvent Interface]
[17:18:45.057] data/globalevents/scripts/PowerOT/shop.lua:onThink
[17:18:45.072] Description:
[17:18:45.072] (luaDoPlayerAddItemEx) Player not found

Line 48
received = doPlayerAddItemEx(getPlayerSlotItem(cid, 3).uid, bag)

i change to
received = doPlayerAddItemEx(cid, bag)

* But player receinve BP + 1 rune 20x

Cykotitan · Jun 4, 2011

what do you want? 100x in stack?

Code:

                                    if isItemRune(id) then
                                        count = 100
                                    end

HeberPcL · Jun 4, 2011

UP!
He was blind!

Thanks

Mooosie · Jun 4, 2011

iPacc 1.1 is better because it shows that you need to be inlogged instead of nit showing anything.

Shop System Full! [Modern AAC]

Banned User

Member

Member

Well-Known Member

Active Member

Member

New Member

New Member

domasturb(cid, genital)

Well-Known Member

domasturb(cid, genital)

facebook.xenoria.org

[PowerOT.com.br]

New Member

New Member

Member

[PowerOT.com.br]

Experienced G'

[PowerOT.com.br]

- Lua Scripter -

Similar threads