[GsiX]

Yay.. it finally work...

Q: Is every sever need to set they database.cfg in order for the cookies to work? and is this correct? If not how do i set the correct 1? And how do i open the menu suggested by root?

PHP Code:

"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
} 


[Powerlord]

Originally Posted by GsiX Yay.. it finally work... Q: Is every sever need to set they database.cfg in order for the cookies to work? and is this correct? If not how do i set the correct 1?

clientprefs is set to use a local SQLite database by default. If you want to share client preferences across servers, then you need an external database and would have to edit databases.cfg on every server to use it.

[GsiX]

You were saying that the database.cfg is not required to be configure if i only want to store and read data from it? I m not planing on force the sever owner to share preferences.

EDIT: My subject is on reading and store client cookies.

EDIT2: if i use the default setting like below code. The data is not loaded..

"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}

[FaTony]

Look in sourcemod/configs/sql-init-scripts/sqlite. You must set up the database correctly before using clientprefs.

[GsiX]

Sorry for the late reply, i m deal with life crab lately... Thanks for the guide, finaly i found a file that make sense to me but ho can i set the file up? and which file i need to set up? i have 5 file there.

[berni]

Originally Posted by GsiX i m deal with life crab lately

yummy yummy, life crabs

Originally Posted by GsiX Thanks for the guide, finaly i found a file that make sense to me but ho can i set the file up? and which file i need to set up? i have 5 file there.

The .sql files are SQL dumps, the structure of the tables which you can import into an empty database to create the tables.
The .sq3 files are already sqlite databases that can be used I think.

[GsiX]

Originally Posted by berni The .sql files are SQL dumps, the structure of the tables which you can import into an empty database to create the tables. The .sq3 files are already sqlite databases that can be used I think.

haha... thanks for the info.. as usual i will try this until i success or i pass out. If i pass out mean i will go back here..

[FaTony]

I use MySQL part of XAMPP personally. Just start MySQL, srcds and game client on the same machine - no problems. I dunno why you're refusing simple yet full-fledged solution.

[GsiX]

Originally Posted by FaTony I use MySQL part of XAMPP personally. Just start MySQL, srcds and game client on the same machine - no problems. I dunno why you're refusing simple yet full-fledged solution.

I'v try but i still confused why you still saying i don't use the method you suggest.

I already release what i have here. The l4d2_luffy_rpg.

EDIT: and when i release the full edition.. i may need someone to reconvert this to CS:S or TF2... not sure if any one interesting. So far i only convert my CS:S plugin to l4d2 about 70%.

[Dr. McKay]

If you're trying to use Clientprefs via MySQL, you don't need to do anything. It should create the tables automatically (or at least, it has in my experience).

If you're trying to use SQLite, stop what you're doing. You're overthinking it. Just create a cookie using RegClientCookie and use GetClientCookie and SetClientCookie to access it. Everything else is taken care of for you.