[Duffnexter]

If you are using the mysql saving method you will want to import the shero_mysql_install.sql script (in contrib folder) into your database.

i use sql that i got with my web host can someone help me how do i edit this file (simply put Ur Host Here, Ur Userv Here...) thank you... and just simply tell me how to import it here is the pic of my sql options

# Created by...: Kevin tkm@gamersource.net # Description..: SuperHeroMod MySQL Install Script # Orig Date....: 08/01/03 # Modified Date: 08/01/03 # # Reference: Linux: See MySQL_README_LINUX - SECTION 2.0 # Windows: See MySQL_README_WINDOWS - SECTION 2.0 # # Start: Create the databases CREATE DATABASE IF NOT EXISTS SHeroDB; USE SHeroDB; GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost; #---------------------------------------------------- # Start: Create the tables #---------------------------------------------------- CREATE TABLE IF NOT EXISTS `sh_savexp` ( `SH_KEY` varchar(34) binary NOT NULL default '', `PLAYER_NAME` varchar(32) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, `XP` int(10) unsigned NOT NULL default '0', `HUDHELP` tinyint(1) unsigned NOT NULL default '1', `SKILL_COUNT` int(3) unsigned NOT NULL default '0', PRIMARY KEY (`SH_KEY`) ) TYPE=MyISAM COMMENT='SUPERHERO XP Saving Table'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `sh_savexp` TO SuperHeroModUser@localhost; CREATE TABLE IF NOT EXISTS `sh_saveskills` ( `SH_KEY` varchar(34) binary NOT NULL default '', `SKILL_NUMBER` int(10) unsigned NOT NULL default '0', `HERO_NAME` varchar(25) NOT NULL default '', PRIMARY KEY (`SH_KEY`,`SKILL_NUMBER`) ) TYPE=MyISAM COMMENT='SUPERHERO Skill Saving Table'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `sh_saveskills` TO SuperHeroModUser@localhost; FLUSH PRIVILEGES; #---------------------------------------------------- # Stop #----------------------------------------------------

2. Where do i put file called superhero that is placed in "contrib" folder?

[vittu]

As long as you set the cvars correctly in shconfig.cfg:

// *** MySQL Settings, Only needed if using the mysql saving method ***
// Uncomment the cvar lines to enable these settings

//sh_mysql_host "localhost"
//sh_mysql_user "SuperHeroModUser"
//sh_mysql_pass ""
//sh_mysql_db "sherodb"
//sh_mysql_persistent 0

your tables will be automatically be created the first time you run superheromodmysql.amxx.

[Duffnexter]

// *** MySQL Settings, Only needed if using the mysql saving method *** // Uncomment the cvar lines to enable these settings //sh_mysql_host "localhost" //sh_mysql_user "SuperHeroModUser" //sh_mysql_pass "" //sh_mysql_db "sherodb" //sh_mysql_persistent 0

Are You Tring To Help Or Make It More Coplicated?

sh_mysql_host "localhost" sh_mysql_user "SuperHeroModUser" sh_mysql_pass "" sh_mysql_db "sherodb" sh_mysql_persistent 0

i did it this way and it didnt work
1. it says Your exp will be given next round and it doesnt and those are the errors i get in logs:

[vittu]

If you don't know what your host, user, and password are you shouldn't be trying to use mysql.

[Duffnexter]

i know what my host is user and pass. if u have read what i wrote in first post than u kno what im talkin about

[Jelle]

Originally Posted by Duffnexter sh_mysql_host "localhost" sh_mysql_user "SuperHeroModUser" sh_mysql_pass "" sh_mysql_db "sherodb" sh_mysql_persistent 0

Now, I am not so familiar to mysql. But what I think it should be, is like this:

sh_mysql_host "localhost" //Write your host here
sh_mysql_user "SuperHeroModUser" //Write your username here
sh_mysql_pass "" //write your password here
sh_mysql_db "sherodb"
sh_mysql_persistent 0

And as vittu said, all files will be placed the first time.

[Duffnexter]

well i kno that... i did it before even posting here, it doesnt work like in my first post it tells what i need....