| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 305 online users.
» 1 Member(s) | 302 Guest(s)
Google, Bing, email.d.value
|
|
|
| [HELP] Invalid string value on MySQL. |
|
Posted by: Smyle - 2021-01-16, 12:07 AM - Forum: Pawn Scripting
- Replies (2)
|
 |
Hey, yall. So i was trying to make some records inside of a MySQL table and i must use special characters (?, ?, ?, ?, etc). The issue is that when i try to insert a new row into the table with that special characters these special characters just returns to me this following error:
Code: Incorrect string value: '\xE7\xE3o de...'
Note: \xE7 matches to '?' and \xE3 matches to the '?' character.
I've already tried to change my collate and character set on MySQL to utfmb4, utf8, latin1, etc. but nothing works. Also i tried to use mysql_escape_string and also tried to use %e instead of %s when manipulating this string whit the special characters. But nothing seems to change.
Code: ? ? mysql_format(DBConn, Query, 500, "INSERT INTO %s (Data, Registro) VALUES ('%d', '%s')", tableName, timestamp, msg);
? ? mysql_query(DBConn, Query);
Note?: When printing the same format i am using to query, everything shows up fine as expected in the console.
|
|
|
|
| server commands |
|
Posted by: Funkar69 - 2021-01-14, 10:32 PM - Forum: Pawn Scripting
- Replies (1)
|
|
i'm trying to make a /commands with dialog list and I'm suffering how to make a list.
instead of Item 1 there should be Server commands and then it would up another dialog containing another box which would be basic command something like that.
https://imgur.com/RwsbxUd
|
|
|
|
| Yn'il SA:MP Server |
|
Posted by: .coke42O - 2021-01-13, 03:54 PM - Forum: Art
- Replies (1)
|
 |
Hello people. I went to present you a logo from my SA:MP server. Otherwise I'm not a designer.
![[Image: ynil-net-hq-L.png]](https://i.ibb.co/SymkTMf/ynil-net-hq-L.png)
|
|
|
|
| IsDynamicActorStreamedIn always returns 0 |
|
Posted by: c4p - 2021-01-13, 03:26 PM - Forum: Pawn Scripting
- Replies (2)
|
|
Hey. In my mod there is a system which creates shop actors if a player goes inside, and destroys them when everybody went out.
Or at least that's the goal. Creating the actor works fine, as the mod detects if the actor is already created and doesnt spawn it again, etc.
But if anybody leaves the shop and my custom function gets called, the shop actor gets deleted immediately, no matter if someone else got the actor streamed in.
My code:
Code: DestroyShopActorIfUnstreamed(virtualworldid)
{
? ? if (!IsValidDynamicActor(shopactor[virtualworldid])) return 1;
for(new i = 0; i < MAX_PLAYERS 1; i)
? ? {
? ? ? ? if (IsDynamicActorStreamedIn(shopactor[virtualworldid], i))
? ? ? ? {
? ? ? ? ? ? print("streamed");
? ? ? ? ? ?break;
? ? ? ? }
? ? printf("shopactor %i deleted", virtualworldid);
? ? DestroyDynamicActor(shopactor[virtualworldid]);
? ? }
return 1;
}
I know i messed up something with the code
|
|
|
|
| Mysql |
|
Posted by: Syxh0wN - 2021-01-13, 10:28 AM - Forum: Support
- Replies (1)
|
|
my server uses a lot of cpu because of mysql, is there any way for me to know which code is pulling so much cpu?
|
|
|
|
| APARTMENT 3C & ARTSTUDIO |
|
Posted by: Name - 2021-01-13, 06:14 AM - Forum: Videos and Screenshots
- Replies (6)
|
 |
APARTMENT 3C & ARTSTUDIO INTERIORS
(both maps are from my old map collection, some of you probably saw these in the past)
Name: Apartment 3C
Map type: Interior
Author of map: MrName (me)
Number of objects: 300
Number of textures: 324
Removed SA objects: 0?
Custom objects: 0
Location of map: unknown
Map editor used: MSR's mapping system
About map: Reference for this map was taken from Vice City, for more info you can check Vice City's apartment 3c.
Screenshots:
|
|
|
|
| Animation to speak |
|
Posted by: Boxi - 2021-01-12, 09:45 PM - Forum: Pawn Scripting
- Replies (1)
|
 |
Hello, I want to make a command that when using it the character makes the typical talking animation. Do you know what the name of that animation is? thanks!
|
|
|
|
| Nice and easy way to script a countdown? |
|
Posted by: M.D. - 2021-01-12, 08:45 PM - Forum: Pawn Scripting
- Replies (4)
|
 |
What do you reckon that would be an efficient method of implementing a countdown (a few minutes long), including both a timer and an updating TextDraw or GameText?
Afterwards, how would you be able to script something to happen at the end of it?
Cheers!
|
|
|
|
|
![[Image: qNNViRHl.jpg]](https://i.imgur.com/qNNViRHl.jpg)
![[Image: bcsFV2dl.jpg]](https://i.imgur.com/bcsFV2dl.jpg)
![[Image: mDPB4fKl.jpg]](https://i.imgur.com/mDPB4fKl.jpg)
![[Image: UUUr3tsl.jpg]](https://i.imgur.com/UUUr3tsl.jpg)
![[Image: OfWWkP8l.jpg]](https://i.imgur.com/OfWWkP8l.jpg)
![[Image: vd5xMlWl.jpg]](https://i.imgur.com/vd5xMlWl.jpg)
![[Image: JwwXUizl.jpg]](https://i.imgur.com/JwwXUizl.jpg)
![[Image: 76Uewgfl.jpg]](https://i.imgur.com/76Uewgfl.jpg)
![[Image: RysMb7Ll.jpg]](https://i.imgur.com/RysMb7Ll.jpg)
![[Image: 7SWRTdrl.jpg]](https://i.imgur.com/7SWRTdrl.jpg)
![[Image: 0eAKkQPl.jpg]](https://i.imgur.com/0eAKkQPl.jpg)
![[Image: DQ6FOrpl.jpg]](https://i.imgur.com/DQ6FOrpl.jpg)
![[Image: xuZ4ob9l.jpg]](https://i.imgur.com/xuZ4ob9l.jpg)
![[Image: eXNLIuWl.jpg]](https://i.imgur.com/eXNLIuWl.jpg)
![[Image: hnL9btol.jpg]](https://i.imgur.com/hnL9btol.jpg)