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

Ver. 0.1.0 - Gesior ITEM/PACC Shop (PHP+LUA) for TFS

item shop is no running on linux debiania ;/
i buy item and i no have on my character... on windos i w8 30-60s and i have item on linux i no have ;/
I no good speak english...
 
I made shop script for TFS 0.2.10 - 0.2.11 and 0.3 (rev. 756, trunk), but maybe work with older TFS versions (not tested).
How to install:
Click to expand...
:/
i have version 2.13. Running this script in TFS 2.13?
 
Godely said:
Can't someone rewrite it? I really don't understand about those things...
Click to expand...
Ask Elf, he had version for new 0.3, but I don't have contact with him now. I don't have time to rewrite this script. I must make updates for my OTS.
Moqill said:
this shop is only for windows...
Click to expand...
Why? :> Any error on linux?
@Ronaldino
I know you are angry and want insult all because you work few weeks to make OTS, added 32468348 scripts to OTS and site, 4000 spawns on map, 3243247 quests and you have 5-20 players online after 3 months :(
persoul.hopto.org said:
Monsters: 4127
Uptime: 14h 32m
Players Online: 2 / 40
Click to expand...
 
Last edited:
ok this is run in my server... :) i look in login.lua and no have script ;)
 
@ Ver. 0.1.0 - Gesior ITEM/PACC Shop (PHP+LUA) for TFS

How am I able to buy premium via gold coins with that system?
Eg. 7 premium days for 50 platinum coins, and you have to got the money in ANY depot :p

Sincerely,
Furstwin.
 
I made it after ~20 priv. msgs :>
Tested on TFS 0.3 rev. 865, should work with every new version of TFS 0.3.
LUA script for users of new versions of TFS 0.3
Code: 
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 17
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
SQL_COMUNICATION_INTERVAL = SQL_interval * 1000
function onLogin(cid)
	if(InitShopComunication == 0) then
		local eventServ = addEvent(sql_communication, SQL_COMUNICATION_INTERVAL, {})
		InitShopComunication = eventServ
	end
	registerCreatureEvent(cid, "PlayerDeath")
	return TRUE
end

function sql_communication(parameters)
	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 = getPlayerByName(tostring(result_plr:getDataString("name")))
			if isPlayer(cid) == TRUE then
				if action == 'give_item' 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 b_head_slot = getPlayerSlotItem(cid, 1)
					local b_necklace_slot = getPlayerSlotItem(cid, 2)
					local b_backpack_slot = getPlayerSlotItem(cid, 3)
					local b_armor_slot = getPlayerSlotItem(cid, 4)
					local b_right_hand = getPlayerSlotItem(cid, 5)
					local b_left_hand = getPlayerSlotItem(cid, 6)
					local b_legs_slot = getPlayerSlotItem(cid, 7)
					local b_feet_slot = getPlayerSlotItem(cid, 8)
					local b_ring_slot = getPlayerSlotItem(cid, 9)
					local b_arrow_slot = getPlayerSlotItem(cid, 10)
					if b_arrow_slot.itemid == 0 or (b_left_hand.itemid == 0 and b_right_hand.itemid == 0) then
						local full_weight = 0
						if add_item_type == 'container' then
							container_weight = getItemWeight(container_id, 1)
							items_weight = container_count * getItemWeight(itemtogive_id, itemtogive_count)
							full_weight = items_weight + container_weight
						else
							full_weight = getItemWeight(itemtogive_id, itemtogive_count)
						end
						local free_cap = getPlayerFreeCap(cid)
						if full_weight <= free_cap then
							if add_item_type == 'container' then
								local new_container = doCreateItemEx(container_id)
								local iter = 0
								while iter ~= container_count do
									doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
									iter = iter + 1
								end
								doPlayerAddItemEx(cid, new_container)
								itemtogive_id = container_id
							else
								local addeditem = doPlayerAddItem(cid, itemtogive_id, itemtogive_count)
							end
							local head_slot = getPlayerSlotItem(cid, 1)
							local necklace_slot = getPlayerSlotItem(cid, 2)
							local backpack_slot = getPlayerSlotItem(cid, 3)
							local armor_slot = getPlayerSlotItem(cid, 4)
							local right_hand = getPlayerSlotItem(cid, 5)
							local left_hand = getPlayerSlotItem(cid, 6)
							local legs_slot = getPlayerSlotItem(cid, 7)
							local feet_slot = getPlayerSlotItem(cid, 8)
							local ring_slot = getPlayerSlotItem(cid, 9)
							local arrow_slot = getPlayerSlotItem(cid, 10)
							if ring_slot.itemid == itemtogive_id or feet_slot.itemid == itemtogive_id or legs_slot.itemid == itemtogive_id or armor_slot.itemid == itemtogive_id or necklace_slot.itemid == itemtogive_id or head_slot.itemid == itemtogive_id or arrow_slot.itemid == itemtogive_id or left_hand.itemid == itemtogive_id or right_hand.itemid == itemtogive_id or backpack_slot.itemid == itemtogive_id then
								if b_ring_slot.uid ~= ring_slot.uid or b_feet_slot.uid ~= feet_slot.uid or b_legs_slot.uid ~= legs_slot.uid or b_armor_slot.uid ~= armor_slot.uid or b_necklace_slot.uid ~= necklace_slot.uid or b_head_slot.uid ~= head_slot.uid or b_backpack_slot.uid ~= backpack_slot.uid or b_right_hand.uid ~= right_hand.uid or b_left_hand.uid ~= left_hand.uid or b_arrow_slot.uid ~= arrow_slot.uid then
								doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop. You should re-login now to become sure your new item will not disappear if any error occur.')
								db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
								db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
								else
									doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop not added. Unknown error occured. Wait about '.. SQL_interval ..' seconds. If error will occur again contact with admin. Error item ID is: '.. id ..'')
								end
							else
								doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop not added. Unknown error occured. Wait about '.. SQL_interval ..' seconds. If error will occur again contact with admin. Error item ID is: '.. id ..'')
							end
						else
							doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot or give to friend and wait about '.. SQL_interval ..' seconds to get it.')
						end
						
						
					else
						doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please take items from both hands or item from arrow slot and wait about '.. SQL_interval ..' seconds to get it.')
					end
				end
			end
            if not(result_plr:next()) then
				break
			end
		end
		result_plr:free()
    end
	local eventServ = addEvent(sql_communication, SQL_COMUNICATION_INTERVAL, parameters)
end
New scripts don't "connect" to database, so you can't get error with "Too many connections".
EDIT:
added to first post
 
Last edited:
Ronaldino said:
Wow, Gesior o_O thats unbelievable you made it, congratz!
Click to expand...
Why don't you use your 'great' shop with boxes? -.-
persoul.hopto.org said:
Sklep Znów Działa! Niedziela, 22 Czerwca 2008 przez GoD Shaize
Click to expand...
"Shop work again! 22 june 2008 by Ronaldino" :)
 
Last edited:
Because Jerzy Skalski write an code ;D, and delete link to my shop from first page.
 
Last edited:
Gesior i use TFS 0.3 and look

Fatal error: Call to a member function fetch() on a non-object in C:\Users\Drimix\Desktop\xampp\htdocs\shopsystem.php on line 54
 
Dator tek said:
Gesior i use TFS 0.3 and look

Fatal error: Call to a member function fetch() on a non-object in C:\Users\Drimix\Desktop\xampp\htdocs\shopsystem.php on line 54
Click to expand...

Whats your config.ini configuration? Did you edit something?

## oh, I'm so sorry but I must say that :( your new script cause error with saveing players sometimes I get error "Error while saving player:" when I delete your script from login.lua error dissapear.
 
Last edited:
No i didnt edit anything and here is my config.ini look;)

server_path = "C:/Users/Drimix/Desktop/TFS 0.3 rev. 815/"
shop_layout_name = "natural"
admin_account = "1"
Click to expand...

OPS! I just want to say i dont know how to add the tables in database :(
 
If you create this table:

CREATE TABLE `z_shop_offer` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`itemid1` int(11) NOT NULL default '0',
`count1` int(11) NOT NULL default '0',
`itemid2` int(11) NOT NULL default '0',
`count2` int(11) NOT NULL default '0',
`offer_type` varchar(255) default NULL,
`offer_description` text NOT NULL,
`offer_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
Click to expand...

Execute in database it:
INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '10', '0', '12', '0', '0', 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC'
), (NULL , '40', '5890', '50', '0', '0', 'item', 'Buy 50 Chicken Feathers!', '50x Chicken Feather'
), (NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor');
Click to expand...

Then you saw an new offerts in shop.
 
ok.. well im still confised excatly how to have people buy points... you should add the file buypoints.php in your first post.. because i read through them all and it was not explained.. 2 guys asked the question and one solved it and another was left in the dust..


Any idea or script..

And if you say sms... how do you add this "SMS" and whats it stand for.. a text msg... -.-


Ok well i went to paypal.com and created an account and then created a button.. but now how do i make it if the player buy's it.. it gives them points... havnt gotten that far yet..
 
Last edited:

Similar threads

Czorcik
  • Question
Gesior sms shop spaming items
Replies
1
Views
274
Czorcik
Czorcik
Back
Top