- Scripting Help
(https://forums.alliedmods.net/forumdisplay.php?f=11)
- - [sql] menu
(https://forums.alliedmods.net/showthread.php?t=195909)
avril-lavigne
09-13-2012 00:00
[sql] menu
Is it possible to show Custom item in menu using mysql ?
I want to change TEXT in menu using website. Lets say I have 6 points in menu and form with 6 lines on website. I need to change text in each menu item
1. [HELLO]
2. Drop weapon
3. open xxx menu
4 [BYE]
after change on website
1. LOL ?
2. WTF
3. disconnect
4. get admin
Amxbans has that feature because amxbans reasons read web/sql data
I would pay for the code and sql rows
lucas_7_94
09-13-2012 10:33
Re: [sql] menu
Really , i dont understand what is your idea.
You want to do a Menu with data from MySQL Columns ?
Ex simple
Spoiler
_____|________________
1____| Hello its a menu
2____| Omg this is nice
3____| Ow yea , this spoiler sucks
4____| Oh , hi
But , i really dont understand , you say using mysql , but at the time says you want to read data from website...
avril-lavigne
09-13-2012 10:49
Re: [sql] menu
I want to have ability to rename menu items thru my website, using mysql to store data or set new names.
html form will send new data to mysql
Hlds server will read it and change the menu
Spoiler
1.visit server Gungame
2.Visit server War3
3.Visit server Zombie
after changing the text on website
1.visit fking server again!
2.Boxing mod visit it
3.go to alliedmods forum
just other text in menu item... thas what I want
lucas_7_94
09-13-2012 11:12
Re: [sql] menu
And what should be done in the menu handler ? And i think this should be moved to Request.
mabaclu
09-13-2012 11:26
Re: [sql] menu
Quote:
Originally Posted by lucas_7_94
(Post 1798273)
And what should be done in the menu handler ? And i think this should be moved to Request.
Please answer this question. If the answer is 'nothing', I can do it for 6$.
avril-lavigne
09-13-2012 11:58
Re: [sql] menu
Ok here is the code its not complete I didnt have time to complete
new Handle:Queries = SQL_PrepareQuery( SqlxConnection, "CREATE TABLE IF NOT EXISTS `%s` (\ `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\ `hostname` VARCHAR( 100 ) NOT NULL,\ `adminname` VARCHAR( 100 ) NOT NULL,\ `steamid` VARCHAR( 100 ) NOT NULL,\ `connecttime` TIME NOT NULL default '00:00:00',\ `connectdate` DATE NOT NULL default '0000-00-00')", g_Table );
The database is your custom name , table should be called 'tablehere' , columns names should be "MenuData" and "Handler" , both should be Varchar 64 ( The names should be without quotes )
See if this is that you want.
mabaclu
09-13-2012 15:29
Re: [sql] menu
For what you need use lucas' code.
avril-lavigne
09-13-2012 19:47
Re: [sql] menu
yes lucas, thats exactly what I want. change 'pro classic' to another name and change IP related to that menu item thru website.
can you do that for me. Ill pay of course
lucas_7_94
09-13-2012 20:32
Re: [sql] menu
I already posted the code , install it , create the database with data already posted and done , post your server name and your ips and plugin will do all.