[Emp`]

Originally Posted by david It's not there.. This is what it says on mine:

When you run pokemod with mysql for the first time it will add the sql cvars to the file.

[naven]

Pokemod.cfg for newest version should look like this:

//Cvary dla pokemoda, sa przeladowywane przy kazdej zmianie mapy


pm_pokemod           1               
//turns pokemod on and off (1=on, 0=off)

pm_admin             l               
//what accessflag admins need to mess with PokeMod

pm_save              1               
//save players xp (1=on, 0=off)

pm_xpsavedays        30              
//how many days to save xp for before erasing it

pm_safari_mode       0               //turns safari mode on and off (1=on, 0=off)
//turns safari mode on and off (1=on, 0=off)

pm_debug             0              
 //turns pokemod debug messages on and off (1=on, 0=off)

pm_debug_key                         
//only shows debug messages with this in it

pm_wild              0               
//how many people needed to be wild

pm_wild_level        33              
//max level that wild pokemon will be (set to 0 to disable)

pm_maxhp             255             
//max hp that someone can get with HP Ups

pm_botsays           1               
//turns on bot radio commands when they choose/buy a pokemon/item

pm_pokecenter        200             
//set to 0 if you dont want the npcs to be spawned. otherwise this is the distance you can be from pokecenter to use it

pm_oak               ab              
//prof oak properties (a = pokemart, b = heal, c = team specific)

pm_oakhp             150          
//how much hp oak has (set to 0 for godmode)

pm_pokeballs         1               
//spawn pokeballs with pokemon in them at spawns (1=yes, 0=no)

pm_buytime           0.0             
//minutes that you can buy things from pokemart, set to 0 for infinite time

pm_itemtime          30.0            
//items disappear after this time, set to 0 to remove at end of round

pm_pokemart_open     1               
//allow buying from pokemart

pm_burntime          3              
//how long until players are no longer on fire

pm_burndamage        5               
/how much damage per half second burn does
pm_waterheal         3               
//how much hp is healed per second in water (if using a water pokemon)

pm_poisondamage      5               
//how long until players are no longer poisoned
pm_poisontime        3              
//how much damage per second poison does
pm_sleeptime         3               
//players will fall asleep for this amount of time

echo "Pokemod: zaladowano pliki konfiguracyjne 

pm_maxarmor          255             
//max armor that someone can get with bonuses

pm_ffa               0               
//make pokemod work with free for all
pm_mysql_host ""
pm_mysql_user ""
pm_mysql_pass ""
pm_mysql_db  ""
pm_mysql_persistent  1               //only connect to mysql server once (if saving problems, set to 0)

[naven]

Emp i've got problem, i have reinstalled my server, then I have uploaded my amxmodx folder( also uploades models etc.) but I get this error in logs(no xp are loaded, pokemons does not work)

L 05/20/2009 - 20:43:22: [pokemod.amxx] Error Making Tables: 'near "binary": syntax error' - 'CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary NOT NULL default '', `XPS` varchar(255) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, PRIMARY KEY  (`SAVE_KEY`) ) TYPE=MyIS
L 05/20/2009 - 20:43:22: [pokemod.amxx] "Naruto<25><STEAM_ID_LAN><None>" Error Querying MySQL DB for Naruto: 'no such table: pm_save' - 'SELECT `XPS` FROM `pm_save` WHERE `SAVE_KEY` = 'Naruto''
L 05/20/2009 - 20:43:22: [pokemod.amxx] Error Making Tables: 'near "binary": syntax error' - 'CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary NOT NULL default '', `XPS` varchar(255) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, PRIMARY KEY  (`SAVE_KEY`) ) TYPE=MyIS
L 05/20/2009 - 20:43:22: [pokemod.amxx] "naven<27><STEAM_0:0:19566813><None>" Error Querying MySQL DB for naven: 'no such table: pm_save' - 'SELECT `XPS` FROM `pm_save` WHERE `SAVE_KEY` = 'naven''

What could it be? How to avoid/fix this?

[Emp`]

Try to find:

'CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary NOT NULL default '', `XPS` varchar(255) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, PRIMARY KEY  (`SAVE_KEY`) )

It should be in the xp.inl (note it could be in more than one location)

Try changing it to:

'CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary, `XPS` varchar(255) binary, `LAST_PLAY_DATE` timestamp(14), PRIMARY KEY  (`SAVE_KEY`) )

[david]

It's already like that. I just don't know how to link mysql with pokemod. Do I just execute that file? And if I'm suppose to then am I suppose to execute it in parts? Sorry for all these questions...

[naven]

First, you need to change saving to mysql: you need to change 28th line of custom.inl to

 #define SAVE SAVE_MYSQL //     Edit this to which saving type you want (from the above)  //

Then recompile plugin, and put your database host, user, pass to pokemod.cfg as I shown below

[naven]

I found almost the same(you can see original commented) and it gives me compilation errors. My code:

//Only try to create the tables once
    else if (CreateTables) {
        new sql[512]
        new Result:retval

        if ( SQL_TYPE == SQL_SQLITE ){
            if ( !sqlite_table_exists( gMySQL, "pm_save" ) ){
                copy(sql, 511, 'CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary, `XPS` varchar(255) binary, `LAST_PLAY_DATE` timestamp(14), PRIMARY KEY  (`SAVE_KEY`) ) TYPE=MyISAM COMMENT='PokeMod Saving Table'")            
//                copy(sql, 511, "CREATE TABLE `pm_save` ( `SAVE_KEY` varchar(34) binary NOT NULL default '', `XPS` varchar(255) binary NOT NULL default '', `LAST_PLAY_DATE` timestamp(14) NOT NULL, PRIMARY KEY  (`SAVE_KEY`) ) TYPE=MyISAM COMMENT='PokeMod Saving Table'")
                retval = dbi_query(gMySQL,sql)
                if (retval <= RESULT_FAILED) {
                    dbi_error(gMySQL,error,127)
                    debugMessage(0,0,"XP", "Error Making Tables: '%s' - '%s'", error, sql)
                    return
                }

Erros:

//// pokemod.sma
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/skills/ice.inl
(42) : warning 213: tag mismatch
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/xp.inl(209) :
error 027: invalid character constant
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/xp.inl(209) :
error 017: undefined symbol "REATE"
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/xp.inl(209) :
warning 215: expression has no effect
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/xp.inl(209) :
error 001: expected token: ";", but found "`"
// C:\Documents and Settings\komp\Pulpit\compiler\include\pokemon/xp.inl(209) :
fatal error 107: too many error messages on one line
//
// Compilation aborted.
// 4 Errors.
// Could not locate output file compiled\pokemod.amx (compile failed).
//
// Compilation Time: 9,61 sec

[johnny40409]

Well ..Is there a lang file for this?
Cause if I want to translate..
I have to translate from ini files..
It's tired..thanks!

[naven]

yes, there is(newest version) pokemod.txt...

[johnny40409]

Well , I didn't see any cfg files..
I downloaded RC..I didn't see..

And ..I mean..like these

"client_print" .

Message to player,, Does it include it ?

Because I've see ini files,,
there are all clinet_print...printchat..
It's hard to translate