emofc 4 Report post Posted May 8, 2017 please if someone know how to fix this sh1ts please help me ! Quote Share this post Link to post Share on other sites
Faller 93 Report post Posted May 8, 2017 Make sure that the SQL User used for the website has SELECT and UPDATE authorizations in your vote column/table/database. Quote Share this post Link to post Share on other sites
emofc 4 Report post Posted May 9, 2017 what do you mean? Quote Share this post Link to post Share on other sites
Faller 93 Report post Posted May 9, 2017 Example: The SQL User you've put in your website to access your database is "web_login"; In order to "web_login" be able to update how many credits a user have (which is basically what the voting system does, but it also has to check when was last vote, IP and so on...), it needs "UPDATE" permission, which basically allows that user to modify that column in the database, or a whole table/database, depending on how you set it... I'll suppose you're not using a custom pkoSite, so you probably use the table "account" in the database "GameDB" to store when the player has voted and how many credits he has... Then, you'll need to give SELECT and UPDATE permission to your website sql user, into that database, table. How you can do that? One of the ways you can do it through SQL queries, which you simply need to right click on the desired database (GameDB in this case) and click "New Query", in that query, type: USE GameDB; GRANT UPDATE ON OBJECT::account TO "LoginName"; GO and execute it... then make another query with this: USE GameDB; GRANT UPDATE ON OBJECT::account TO "LoginName"; GO and execute it... Done! Your website SQL User have permission to modify that table. Note that this may NOT be your case, also, your website might use different database and table to store the vote time/credits. Remember to modify "LoginName" to your SQL username. I'm sorry, maybe I wasn't clear enough, I'm really bad explaining things. :\ 1 Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted May 10, 2017 В 08.05.2017 в 20:56, emofc сказал: please if someone know how to fix this sh1ts please help me ! We need debugging information to understand what the error is. Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites