I've got a problem with passwords.
Every new account can log on acc site without any problem. But when im trying to log in game it says "invalid password".
To let it work i have to manualy change password from something like this "7288edd0fc3ffcbe93a0cf06e3568e28521687bc" (i have no idea why passwords in phpMyAdmin looks like this) to the password i want.
With new password (changed in phpMyAdmin) i can log into the game, but ACC says "Username and password combination is wrong."
Can you anserw me why does it automaticaly set password to something like this "7288edd0fc3ffcbe93a0cf06e3568e28521687bc", and how to fix it.
Thank you
Try use this znoteshop.luaFor some reason I followed everything exactly in my 0.3.6 and my talk action !shop does not produce any items. It even says I must wait when i spam it ... so that works but it doesnt give me any items.
nice stuff tho thanks znote , help me out if you can
-- Znote Shop v1.0 for Znote AAC on TFS 0.3.6+ Crying Damson.
function onSay(cid, words, param)
local storage = 54073 -- Make sure to select non-used storage. This is used to prevent SQL load attacks.
local cooldown = 15 -- in seconds.
if getPlayerStorageValue(cid, storage) <= os.time() then
setPlayerStorageValue(cid, storage, os.time() + cooldown)
local accid = getAccountNumberByPlayerName(getCreatureName(cid))
-- Create the query
local orderQuery = db.storeQuery("SELECT `id`, `type`, `itemid`, `count` FROM `znote_shop_orders` WHERE `account_id` = " .. accid .. " LIMIT 1;")
-- Detect if we got any results
if orderQuery ~= false then
-- Fetch order values
local q_id = result.getDataInt(orderQuery, "id")
local q_type = result.getDataInt(orderQuery, "type")
local q_itemid = result.getDataInt(orderQuery, "itemid")
local q_count = result.getDataInt(orderQuery, "count")
result.free(orderQuery)
-- ORDER TYPE 1 (Regular item shop products)
if q_type == 1 then
-- Get wheight
local playerCap = getPlayerFreeCap(cid)
local itemweight = getItemWeightById(q_itemid, q_count)
if playerCap >= itemweight then
db.executeQuery("DELETE FROM `znote_shop_orders` WHERE `id` = " .. q_id .. ";")
doPlayerAddItem(cid, q_itemid, q_count)
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Congratulations! You have recieved ".. q_count .." "..getItemNameById(q_itemid).."(s)!")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "Need more CAP!")
end
end
-- Add custom order types here
-- Type 2 is reserved for premium days and is handled on website, not needed here.
-- Type 3 is reserved for character gender(sex) change and is handled on website as well.
-- So use type 4+ for custom stuff, like etc packages.
-- if q_type == 4 then
-- end
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "You have no orders.")
end
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Can only be executed once every "..cooldown.." seconds. Remaining cooldown: ".. getPlayerStorageValue(cid, storage) - os.time())
end
return false
end
Try use this znoteshop.lua
Code:-- Znote Shop v1.0 for Znote AAC on TFS 0.3.6+ Crying Damson. function onSay(cid, words, param) local storage = 54073 -- Make sure to select non-used storage. This is used to prevent SQL load attacks. local cooldown = 15 -- in seconds. if getPlayerStorageValue(cid, storage) <= os.time() then setPlayerStorageValue(cid, storage, os.time() + cooldown) local accid = getAccountNumberByPlayerName(getCreatureName(cid)) -- Create the query local orderQuery = db.storeQuery("SELECT `id`, `type`, `itemid`, `count` FROM `znote_shop_orders` WHERE `account_id` = " .. accid .. " LIMIT 1;") -- Detect if we got any results if orderQuery ~= false then -- Fetch order values local q_id = result.getDataInt(orderQuery, "id") local q_type = result.getDataInt(orderQuery, "type") local q_itemid = result.getDataInt(orderQuery, "itemid") local q_count = result.getDataInt(orderQuery, "count") result.free(orderQuery) -- ORDER TYPE 1 (Regular item shop products) if q_type == 1 then -- Get wheight local playerCap = getPlayerFreeCap(cid) local itemweight = getItemWeightById(q_itemid, q_count) if playerCap >= itemweight then db.executeQuery("DELETE FROM `znote_shop_orders` WHERE `id` = " .. q_id .. ";") doPlayerAddItem(cid, q_itemid, q_count) doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Congratulations! You have recieved ".. q_count .." "..getItemNameById(q_itemid).."(s)!") else doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "Need more CAP!") end end -- Add custom order types here -- Type 2 is reserved for premium days and is handled on website, not needed here. -- Type 3 is reserved for character gender(sex) change and is handled on website as well. -- So use type 4+ for custom stuff, like etc packages. -- if q_type == 4 then -- end else doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, "You have no orders.") end else doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Can only be executed once every "..cooldown.." seconds. Remaining cooldown: ".. getPlayerStorageValue(cid, storage) - os.time()) end return false end
// Use htaccess rewrite? (basically this makes website.com/username work instead of website.com/characterprofile.php?name=username
// Linux users needs to enable mod_rewrite php extention to make it work properly, so set it to false if your lost and using Linux.
$config['htwrite'] = true;
Hi otland
Why when I put anything after my ip in / / layout is broken?
I test in host, pc, vps, (all with xampp or uniform but same error in Znote 1.4 and Znote 1.5) http://ip/andwritehere/
PD: google translate u.u
check in config this one
Code:// Use htaccess rewrite? (basically this makes website.com/username work instead of website.com/characterprofile.php?name=username // Linux users needs to enable mod_rewrite php extention to make it work properly, so set it to false if your lost and using Linux. $config['htwrite'] = true;
you may suggest here https://github.com/Znote/ZnoteAAC/issuesHow to start player first skills diferent for each vocations on this acc maker?
/clo
https://github.com/Znote/ZnoteAAC/blob/master/engine/database/connect.php#L110-L117I'm having problems with changelog sql !
Table 'panamera.znote_changelog' doesn't exist
What is the code I have to use in mysql databse?