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

Znote AAC 1.4 - [TFS 0.2.13+] & [TFS 0.3.6+/0.4]

How to start player first skills diferent for each vocations on this acc maker?
/clo
 
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 ;)
 
Blokerq said:
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 ;)
Click to expand...

The passwords are being encrypted, you need to enable the encryption on the server side. Edit config.lua and use "sha1" password type. Then it should work.
Passwords should never be stored in plaintext in the database.
 
For 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 :D
 
iDramatiik said:
For 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 :D
Click to expand...
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
 
HalfAway said:
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
Click to expand...



Trying it now thanks , Ill let you know in a minute
 
12:27 /reload talkactions
12:27 Reloading talkactions...
12:27 Reloaded successfully.
12:27 Admin Jay: !shop
12:27 Can only be executed once every 15 seconds. Remaining cooldown: 12
12:27 Admin Jay: !shop



Nothing :( Didn't work again. I have no console errors, I have no idea whats going on my website works perfectly just not the delivery :D
 
also just fyi heres my talk action just incase

<talkaction words="!shop" event="script" value="znoteshop.lua"/>
 
Oh.. Wow I had a hunch.. In Znote's Tutorial it shows him using a God account to receive his shop item.

My god was not working as stated above with my troubles... So I made a fake account (As a player would normally) then I gave it points and tried again and boom it worked.

12:32 Congratulations! You have recieved 1 dramazarian code book(s)!
 
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/

ogiOT8d.png


PD: google translate u.u
 
Last edited:
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;

Pretx said:
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/

ogiOT8d.png


PD: google translate u.u
Click to expand...
 
clouf said:
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;
Click to expand...

still not working (window) u,u
 
I will try to emulate the error, but for further bugs can you post them on github repo?
 
Hi, when i are suppose to enter the websit with localhost it dose not work i still get the same error even ´when i have put in the code in to phpmyadmin as you show in your video, what may be wrong?
 
I'm having problems with changelog sql !

Table 'panamera.znote_changelog' doesn't exist

What is the code I have to use in mysql databse?
 

Similar threads

Joriku
[ZNOTE ACC] Change login method from Username to Email address
Replies
0
Views
521
Joriku
Joriku
alelu541
  • Question
AAC AAC not connecting with my SQL
Replies
1
Views
329
slaw
slaw
elnelson
  • Question
Linux Znote AAC 1.6 not creating account nor character (no info given by website)
Replies
2
Views
503
tomaszek123
tomaszek123
Back
Top